藥品供銷存貯系統(tǒng)

論文字?jǐn)?shù):11790,頁數(shù):39

摘  要
隨著計(jì)算機(jī)技術(shù)的普及，醫(yī)藥經(jīng)營企業(yè)逐漸借助計(jì)算機(jī)技術(shù)去完善醫(yī)藥的管理和提高自身的工作效率，以贏得市場競爭的勝利。醫(yī)藥管理信息系統(tǒng)已經(jīng)成為各醫(yī)藥經(jīng)營企業(yè)實(shí)現(xiàn)醫(yī)藥管理網(wǎng)絡(luò)化和信息化的必備工具，是醫(yī)藥經(jīng)營企業(yè)規(guī)模經(jīng)營管理不可缺少的部件之一。同時(shí)，軟件開發(fā)環(huán)境的高度集成和數(shù)據(jù)庫技術(shù)的日益成熟大大降低了系統(tǒng)的開發(fā)成本。系統(tǒng)開發(fā)工具的智能化、人性化，使得所開發(fā)的系統(tǒng)充分滿足了醫(yī)藥經(jīng)營企業(yè)的各種需求，從醫(yī)藥經(jīng)營企業(yè)的各個(gè)環(huán)節(jié)對人流、物流、資金流、信息流進(jìn)行統(tǒng)一系統(tǒng)的管理。
本課題是基于VB6.0和access數(shù)據(jù)庫的應(yīng)用技術(shù)，設(shè)計(jì)一個(gè)“藥品進(jìn)銷存管理系統(tǒng)”。目的是實(shí)現(xiàn)醫(yī)藥庫存信息的基本管理，擺脫手工記錄的弊端，力圖使得所開發(fā)的系統(tǒng)充分滿足醫(yī)藥經(jīng)營企業(yè)的各種需求，適用于中小藥店以及小型診所的進(jìn)銷存管理。主要有以下幾個(gè)功能模塊：（1）系統(tǒng)登錄模塊，實(shí)現(xiàn)系統(tǒng)登錄。（2）日常時(shí)務(wù)模塊，管理藥品的入庫、銷售。（3）庫存管理管理模塊，實(shí)現(xiàn)庫存的查詢、庫存的盤點(diǎn)、管理價(jià)格、報(bào)警低儲存量（4）查詢管理模塊，查看所有藥品的入庫、銷售基本信息。（5）基本信息管理模塊，提供客戶、供應(yīng)商、倉庫、業(yè)務(wù)員的基本管理。（6）系統(tǒng)設(shè)置模塊，實(shí)現(xiàn)用戶的基本密碼設(shè)置、初始化系統(tǒng)、以及系統(tǒng)數(shù)據(jù)的保護(hù)。（7）其他方面模塊，給系統(tǒng)進(jìn)一步的開發(fā)可持續(xù)性、實(shí)現(xiàn)在藥品流通中的藥品報(bào)損與流通費(fèi)用的統(tǒng)計(jì)。本文只就（2）（3）（4）模塊進(jìn)行詳細(xì)的闡述。
該系統(tǒng)采用模塊化原理編程，提高了系統(tǒng)的可靠性，模塊規(guī)模適中，本身相對獨(dú)立。
關(guān)鍵詞:藥品進(jìn)銷存管理，數(shù)據(jù)庫，Visual Basic，Access

Abstract
With the popularity of computer technology. TCM enterprises gradually perfecting the use of computer technology to medicine and to improve their work efficiency, market competition in order to win the victory. Medical Management Information System has become the medical and pharmaceutical enterprises, network management and information technology as a hedge, Management is the medical management of the scale one of the indispensable components. Meanwhile, a highly integrated software development environment and database technology greatly reduce the increasing maturity of the system development costs. System Development Tool intelligent, humane, making the system fully developed to meet the medical needs of business enterprises, Enterprises from all aspects of the flow of medicine, logistics, capital flow, information flow unified system management.
The topic is based on Visual Basic 6.0 and database access technology, Design of a "drug inventory management system." Information is the basic purpose of medical inventory management manual records from the ills trying to make the system fully developed to meet the needs of pharmaceutical enterprises. Small pharmacies and clinics in the small inventory management. Mainly in the following modules : (1) entry module system to achieve download system. (2) daily times module, the storage management of pharmaceutical sales. (3) inventory management module, the realization of inventory inquiries, stock inventory and price management. Alarm low storage capacity (4) on the management module, check to see all the medicines, sales of basic information. (5) basic information management module provides customers, suppliers, warehouses, the basic sales management. (6) install the module, users can set up the basic passwords, system initialization, and data protection. (7) other modules to the system to further the development of sustainability, realize the drugs in the pharmaceutical distribution and circulation costs of reported losses. Only on paper (2) (3) (4) modules are described in detail.
The system uses modular programming principles to improve the reliability of the system, module size and, in itself relatively independent.
Key words : pharmaceutical inventory management, database, Visual Basic, Access

目 錄
摘  要 I
Abstract II
第一章 系統(tǒng)概述 1
1.1開發(fā)背景 1
1.2系統(tǒng)設(shè)計(jì)目標(biāo) 1
1.3系統(tǒng)設(shè)計(jì)環(huán)境 2
1.3.1 Visual Basic介紹 2
1.3.2 Access數(shù)據(jù)庫介紹 3
第二章 系統(tǒng)分析 5
2.1 系統(tǒng)可行性研究 5
2.2 現(xiàn)行系統(tǒng)的詳細(xì)調(diào)查 6
2.2.1現(xiàn)行系統(tǒng)的管理職能 6
2.2.2 業(yè)務(wù)流程分析 6
2.3現(xiàn)行藥品銷售管理存在的問題 8
2.4 功能需求 8
2.5 性能需求 9
2.6 運(yùn)行環(huán)境需求 10
2.7 安全性、保密性、可靠性的要求 10
2.8界面要求 11
2.9異常處理要求 11
2.10新系統(tǒng)邏輯模型的提出 11
第三章 數(shù)據(jù)庫設(shè)計(jì)與實(shí)現(xiàn) 13
3.1數(shù)據(jù)庫分析（E-R圖） 13
3.2數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) 14
第四章 系統(tǒng)各模塊的編碼與實(shí)現(xiàn) 19
4.1日常時(shí)務(wù)模塊 19
4.1.1入庫單操作界面 19
4.2庫存管理模塊 21
4.2.1庫存查詢操作界面 21
4.2.2庫存盤點(diǎn)操作界面 22
4.2.3價(jià)格管理主要操作界面 23
4.2.4庫存報(bào)警操作界面 24
4.3查詢統(tǒng)計(jì)模塊 25
4.3.1入庫查詢操作界面 25
第五章 系統(tǒng)測試與維護(hù) 29
5.1系統(tǒng)測試 29
5.2系統(tǒng)維護(hù) 29
結(jié)  論 31
參考文獻(xiàn) 32
致  謝 33