医药管理系统VFP009

 

门诊药品管理系统可以对各个药品厂家，医院商家的各个仓库进行管理。使用起来操作简单，方便易行。可以提高仓库管理的效率。

本文论述了门诊药品管理系统中面临的问题。应用了VF6.0应用软件来实现仓库管理功能。

本系统主窗体采用了简洁明了的菜单形式,各个功能清晰可见。总仓操作界面可以调用不同的仓库数据库，比如根据某项配件的名称，类型号等信息进行比较简单的查询，并可以完成仓库数据表中各个记录的删除，更新和浏览，以及在数据表中添加新数据。在入库出库表单中，先查找到要操作的记录就可以进行出入库操作，若库中没有要做的记录就可以添加新的货物，若出库数大于库存则系统提示库存不够并回到起初界面。在模糊查询表单中，具有详细的统计报表功能。可以根据不同的要求对数据库表中的任何字段进行限制，以便查找到更为准确的信息。还具有打印保存等功能，也是报表的基本功能。使管理者可以方便的浏览各个仓库中不同货物的基本情况，使之一目了然。

 

关键词： 项目    控件    变量    类

 

 

 

The outpatient service drugs management system management system may to Each drugs factory, hospital merchant's each warehouse carry on the management.

Uses the operation to be simple, facilitates Yi Xing. May enhance thestorage management the efficiency. This article elaborated the question which outpatient service drugs management system managementsystem central plane is near. Has realized the storage managementfunction using the VF6.0 application software. This systematic hostwindow has used the succinct bright menu form, each function isclearly discernible. The total warehouse operation contact surface maytransfer the different warehouse database, for instance acts according to some item of fitting the name, information and so on kind of model carries on the quite simple inquiry, and may complete in the warehouse data sheet each recording deletion, the renewal and the browsing, as well as increases the recent data in the data sheet. In goes into storage in the storehouse table list, first searches the recording which must operate to be allowed to carry on goes into storage the operation, if in the storehouse has not  had to do the recording may increase the new cargo, if the storehouse number is bigger than the stock then the system prompt stock is insufficient and returns to at first the contact surface. In the fuzzy questionnaire list, has the detailed statistical report form function. May act according to the

different request to carry on the limit to in database table anyfield, in order to searches more accurate information. Also has function and so on printing preservation, also is the report form basic function. Causes in browsing each warehouse which the superintendent may facilitate different cargo basic situation, causes it to be clear.

 

 

Key word：Project  Controls    Variable    Kind

 

2.1  VF6.0的简介----------------------------------------6

2.2  VF的面向对象技术-----------------------------------7

2.3  窗体的主要属性和识别事件---------------------------7

2.4  常用控件的使用-------------------------------------8

2.5  菜单的设计-----------------------------------------9

3.1  数据库的建立和访问---------------------------------10

3.2  数据表的建立---------------------------------------11

3.3  数据表的添加---------------------------------------11

3.4  数据表的访问---------------------------------------11

3.5  数据表的删除---------------------------------------12

3.6  用数据控件访问数据库------------------------------12

3.7  SQL语言的特点-------------------------------------12

4.1  系 统 设 计----------------------------------------15

4.2  创 建 项 目 管 理 器-------------------------------17

4.3  数 据 库 设 计-------------------------------------17

4.4  数据库结构设计-------------------------------------17

4.5 表单------------------------------------------------20

4.5.1 登陆界面表单设计-----------------------------20

4.5.2 出入库日常业务操作表单设计-------------------22

4.5.3 库存表单设计---------------------------------24

4.5.4 查询统计表单设计-----------------------------26

4.5.5 报表管理表单设计-----------------------------27

4.5.6 基础信息管理表单设计-------------------------29

4.5.7 系统管理表单设计-----------------------------30

4.5.8 帮助表单设计---------------------------------31

4.6 菜单设计程序---------------------------------------33

4.7 主程序及菜单程序-----------------------------------33

4.8 系统调试-------------------------------------------37

 

数据库技术是使用计算机管理数据的一门最新技术。使用数据库对数据进行管理是计算机应用的一个重要而广阔的领域。