VB+SQL Server药房管理系统

仓储式药房管理系统设计与开发

——销售和入库的设计 

摘  要

仓储式药房管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立一个数据一致性和完整性强、数据安全性好的数据库。而对于后者则要求具备应用程序功能完备,易使用等特点。

结合医药行业的特殊要求，本文对SQL Server2000数据库管理系统、SQL语言原理、VB应用程序设计，VB数据库技术进行了较深入的调查和研究，主要完成对仓储式药房管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。

第一章阐述了开发仓储式药房管理系统的意义和背景。

第二章第三章阐述了MIS系统和仓储式MIS系统的基本理论。

第四章阐述了此系统的开发环境。

第五章第六章进行了具体的程序设计，具体划分了三类用户的操作权限，设计了了三个操作界面。实现了数据库表的浏览，记录的添加、删除、修改和查询，报表的生成等。详细的给出了从仓储式药房管理系统分析到总体设计详细设计与实现及测试的各个环节，最后指明本系统还存在的不足及未实现的功能。

关键词：药房管理系统、管理信息系统、仓储、医药

WAReEHOUSE PHARMACY MANAGEMENT SYSTEM DESIGN AND DEVELOPMENT

----DESIGN OF DISTRIBUTION AND ENTERING STORAGE

ABSTRACT

Warehouse-style pharmacy management system is a typical management information system (MIS), mainly including the establishment and maintenance of the background database and the development of front-end application. For the former it requests establishment of a database with strong data consistency and integrity and good data security. For the latter it should be characterized with perfect application functions and easy to use at least.

Therefore, in line with the special requirements of the curatorial industry, after deeply investigating and researching the following points: SQL Server 2000 database management systems, SQL language theory, VB applications design and VB database technologies, the article mainly accomplish the analysis of the main warehouse-style pharmacy management system requirements, functional modules division, and the database model, and the design of structure of the database and applications according to it.

Chapter I expounds the meaning and background of the development of warehouse-style pharmacy management system.

Chapter II and chapter III explains the basic theory of MIS system and storage system.

Chapter IV explains that the system development environment.

Chapter V and Chapter VI carries through specific procedures design, specifically establish manipulate scope of the three categories of users including seller, storage manager and system manager and designs three operational interface. The article also achieved the scanning of the database tables, adding, deleting, modifying and enquiring of records, as well as generation of statements, etc. Besides, the specific process from the warehouse-style pharmacy management system to the whole design and detailed design ,and the realization of the various link, as well as the design and test is detailedly given, and finally the system also identified deficiencies and unrealized functions.

KEYWORDS：Pharmacy Management System, MIS, Warehouse, Medicine221

[1] [2] [3] [4] [5] [6] [7] [8] 下一页