VB药房管理系统设计毕业论文.doc

毕业设计（论文） 学 院：计算机与信息工程学院 题 目：仓储式药房管理系统设计与开发 ——销售和入库的设计 二○○六年六月  仓储式药房管理系统设计与开发 ——销售和入库的设计 摘 要 仓储式药房管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。结合的要求，对SQL Server2000数据库管理系统、SQL语言原理、应用程序设计，数据库技术进行了较深入的，主要完成对管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。第一章第二章第四章第五章进行了具体的程序设计，具体划分了三类用户的操作权限，设计了了三个操作界面。实现了数据库表的浏览，记录的添加、删除修改，报表的生成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 scan