摘要

随着计算机技术的普及，医药经营企业逐渐借助计算机技术去完善医药的管理和提高自身的工作效率，以赢得市场竞争的胜利。医药管理信息系统已经成为各医药经营企业实现医药管理网络化和信息化的必备工具，是医药经营企业规模经营管理不可缺少的部件之一。同时，软件开发环境的高度集成和数据库技术的日益成熟大大降低了系统的开发成本。系统开发工具的智能化、人性化，使得所开发的系统充分满足了医药经营企业的各种需求，从医药经营企业的各个环节对人流、物流、资金流、信息流进行统一系统的管理。

本课题是基于VB6.0和access数据库的应用技术，设计一个“药品进销存管理系统”。目的是实现医药库存信息的基本管理，摆脱手工记录的弊端，力图使得所开发的系统充分满足医药经营企业的各种需求，适用于中小药店以及小型诊所的进销存管理。主要有以下几个功能模块：（1）系统登录模块，实现系统登录。（2）日常时务模块，管理药品的入库、销售。（3）库存管理管理模块，实现库存的查询、库存的盘点、管理价格、报警低储存量（4）查询管理模块，查看所有药品的入库、销售基本信息。（5）基本信息管理模块，提供客户、供应商、仓库、业务员的基本管理。（6）系统设置模块，实现用户的基本密码设置、初始化系统、以及系统数据的保护。（7）其他方面模块，给系统进一步的开发可持续性、实现在药品流通中的药品报损与流通费用的统计。本文只就（2）（3）（4）模块进行详细的阐述。

该系统采用模块化原理编程，提高了系统的可靠性，模块规模适中，本身相对独立。

关键词:药品进销存管理，数据库，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

第一章 系统概述. 1

1.1开发背景. 1

1.2系统设计目标. 1

1.3系统设计环境. 2

1.3.1 Visual Basic介绍. 2

1.3.2 Access数据库介绍. 3

第二章 系统分析. 5

2.1 系统可行性研究. 5

2.2 现行系统的详细调查. 6

2.2.1现行系统的管理职能. 6

2.2.2 业务流程分析. 6

2.3现行药品销售管理存在的问题. 8

2.4 功能需求. 8

2.5 性能需求. 9

2.6 运行环境需求. 10

2.7 安全性、保密性、可靠性的要求. 10

2.8界面要求. 11

2.9异常处理要求. 11

2.10新系统逻辑模型的提出. 11

第三章 数据库设计与实现. 13

3.1数据库分析（E-R图）. 13

3.2数据库逻辑结构设计. 14

第四章 系统各模块的编码与实现. 19

4.1日常时务模块. 19

4.1.1入库单操作界面. 19

4.2库存管理模块. 21

4.2.1库存查询操作界面. 21

4.2.2库存盘点操作界面. 22

4.2.3价格管理主要操作界面. 23

4.2.4库存报警操作界面. 24

4.3查询统计模块. 25

4.3.1入库查询操作界面. 25

第五章 系统测试与维护. 29

5.1系统测试. 29

5.2系统维护. 29

结论. 31

参考文献. 32

致谢. 33

摘 要

Abstract

摘要