药品进销存管理系统需求分析[V1.1]

药品进销存管理系统Purchase, Sales and Inventory Of Drugs Management System

需求分析报告

Requirement Report

[V1.1]

拟制人董小龙、江淑萍、朱建钊、吴斌、

包峥于、解伟、谈洪波

审核人董小龙

批准人

[二零零九年四月七日]

目录

1、引言（Introduction） (4)

1.1编写目的（Compilation goal） (4)

1.2背景（Background） (5)

1.3定义（Definitions） (7)

1.4参考资料（References） (7)

2、任务概述（Tasks Outline） (8)

2.1目标(Goals) (8)

2.2用户特征(User characteristics) (10)

2.3产品与其环境的关系(Products and its environment relations) (11)

2.4限制和约束(Limits and restraint) (11)

3、需求规定(Rules of Requirement) (11)

3.1对功能的规定(Rules of function) (11)

3.2对性能的规定(Rules of performance) (12)

3.2.1精度(Precisions) (12)

3.2.2时间特性要求(Time response request) (13)

3.2.4数据管理能力要求(Data management ability request) (13)

3.2.5故障处理要求(Failure processing request) (14)

3.2.6其他专门要求(Other request specially) (14)

4、系统功能需求分析(System function Requirement analysis) (14)

4.1系统功能总体结构(System function gross structure) (14)

4.2药品管理需求分析(Drug control requirement analysis) (15)

4.2.1 药品查询(Drugs Inquiries) (16)

4.2.2 药品入库查询(Drugs warehousing inquiry) (16)

4.2.3 药品出库查询(Drugs leave the storehouse Inquiry) (17)

4.2.4 药品入库(Drugs Warehousings) (18)

4.2.5 药品出库(Drugs out of the Treasury) (19)

4.2.6药品信息管理(Drugs Information Management) (20)

4.2.7药品报废(Drugs abandonment) (20)

4.3信息管理需求分析(Information Management Requirements Analysis) (21)

4.3.1 供货商查询(Supplier inquiries) (21)

4.3.2 客户查询(Customer Inquiries) (22)

4.3.3 员工查询(Staffs Inquire) (23)

4.3.4 员工信息管理(Staff information management) (24)

4.3.5 客户信息管理(Customer information management) (25)

4.3.6 供货商信息管理(Supplier information management) (26)

4.4销售管理需求分析(Sales management requirement analysis) (26)

4.4.1 销售录入(Sales Inputs) (27)

4.4.2 退货管理(Returned goods management) (28)

4.4.3 销售查询(Sales Inquiries) (29)

4.4.4 退货查询(Returned goods inquiries) (29)

4.5信息预警需求分析(Information early warning requirement analysis) (29)

4.5.1 报废预警(Abandonment early warnings) (30)

4.5.2 库存预警(Stock early warnings) (30)

4.6系统管理需求分析(System administration demand analysis) (31)

4.6.1 权限管理(Jurisdiction management) (31)

4.6.2 修改密码(Modify Passwords) (32)

4.6.3 系统帮助(System help) (32)

5、实体-关系图（E-R Diagram） (34)

5.1 系统功能总体E-R图(System Function Overall E-R Diagram) (34)

5.2 药品管理E-R图(Drug Management E-R Diagram) (35)

5.2.1 药品查询E-R图(Drugs Inquire the E-R Diagram) (35)

5.2.2 药品入库查询E-R图(Drugs Warehousing Inquire the E-R Diagram) (37)

5.2.3 药品出库查询E-R图(Drugs leave the storehouse to Inquire the E-R Diagram) 37

5.2.4 药品入库E-R图(Drugs go into storage E-R the Diagram) (37)

5.2.5 药品出库E-R图(Drugs leave the storehouse E-R Diagram) (37)

5.2.6 药品报废E-R图(Drugs Discard the E-R Diagram) (38)

5.3 信息管理E-R图(Information Management E-R Diagram) (38)

5.3.1 供货商信息查询E-R图(Supplier Information Inquire the E-R Diagram) (38)

5.3.2 客户信息查询E-R图(Customer Information Inquire the E-R Diagram) (38)

5.3.3 员工信息查询E-R图(Staff Information Inquire the E-R Diagram) (39)

5.3.4 供货商信息管理E-R图(Supplier Information Management E-R Diagram) (39)

5.3.5 客户信息管理E-R图(Customer Information Management E-R Diagram) (39)

5.3.6 员工信息管理E-R图(Staff Information Management E-R Diagram) (39)

5.4 销售管理E-R图(Sales management E-R Diagram) (40)

5.4.1 销售录入E-R图(Sales Input the E-R Diagram) (40)

5.4.2 退货管理E-R图(Returned Goods manage the E-R Diagram) (40)

5.4.3 销售查询E-R图(Sales Inquire the E-R Diagram) (40)

5.4.4 退货查询E-R图(Returned Goods inquire the E-R Diagram) (41)

5.5 信息预警E-R图(Information Forewarn the E-R Diagram) (41)

5.5.1 报废预警E-R图(Abandonment Forewarn the E-R Diagram) (41)

5.5.2 库存预警E-R图(Stocks Forewarn the E-R Diagram) (41)

5.6 系统管理E-R图(System Administration E-R Diagram) (42)

6、数据流图(Data Flow Diagram) (42)

6.1 系统基本模型(System Fundamental Models) (42)

6.2 药品管理数据流图(Drug Control Data Flow Diagram) (43)

6.3 信息管理数据流图(Information Management Data Flow Diagram) (44)

6.4 销售管理数据流图(Sales Management Data Flow Diagram) (44)

6.5 信息预警数据流图(Information Early Warning Data Flow Diagram) (45)

6.6 系统管理数据流图(System Administration Data Flow Diagram) (45)

7.Data Dictionary（数据字典） (47)

1、引言（Introduction）

（董小龙3062101124 DONG XIAO LONG Reg No. 2102-011-0024）随着计算机的普及，人们对计算机的认识及需求有了明显的增加。计算机对于大量信息的管理优势更是显而易见。药店处理数据的日趋庞大和对信息的准确要求、快速等因素的存在，使得计算机及相应的管理软件在药品公司管理中的应用成为必然趋势。有了这个药品库存管理系统，这样便可以帮助职工从繁琐的重复性劳动中解脱出来,提高整个药店的工作效率,而由于系统的开发应用使药店运营效率提高会带来无形的可观的经济效益,从而提高药店的经济效益。

With computer's popularization,the people have obviously increase to computer's understanding and the demand.The computer regarding the massive information's management superiority is obvious.The pharmacy processing data is day by day huge and to the information accurate request, fast and so on factor existences,causes the computer and the corresponding management software are in drugs corporate management application into inevitable trend. Have this drugs stock management system,this then may help the staff to extricate from the tedious duplicated work, enhances the entire pharmacy the working efficiency,but because system's development application makes the pharmacy operation efficiency to enhance can bring the invisible considerable economic efficiency, thus enhances the pharmacy the economic efficiency.

1.1编写目的（Compilation goal）

此系统是为中小型药店进行日常业务管理而开发，但开发者和用户之间的行业、领域差异，使得开发者和用户对此系统功能的理解存在一定的差别。为了能使开发者明白用户的目的，开发出让客户满意的系统，更好地实现用户的要求；同时也为了用户能清楚地知道此系统的功能和作用，开发一个集处理药品、客户、供货商信息于一体的，包括员工管理的药品进销存管理系统，是符合市场发展需要的，所以要进行需求分析，并以文档的形式来记录。通过需求分析报告，开发者与用户之间的沟通更为方便，也有利于开发者充分分析客户的需求，从而开发出具有功能强大，客户满意的系统。

This system is carries on the day-to-day business management for the middle and small scale pharmacy to develop，but between exploiter and user's profession, domain difference，causes the exploiter and user regarding this system function understanding existence certain difference. For can cause the exploiter to understand the user the goal, the development sells the customer satisfied system, realizes user's request well;

Simultaneously can also know this system's function and the function clearly for the user, develops collection processing drugs, the customer, the supplier information in a body, manages the drugs including the staff to enter Purchase,Sales and Inventory Of Drugs Management System, conforms to the market development to need, therefore we should carry on the demand analysis, and comes the record by the documents form. Through demand analysis report, between the exploiter and user's communication is more convenient, is also advantageous to the exploiter analyzes the customer fully the demand, so develop the system which has the function to be formidable, customer satisfied.

1.2背景（Background）

如今药品调价频繁,且品种繁多,增加了药品销售定价的难度。药品来货验收登记中的审查有效期环节容易出错,错收过期或有效期不足的药品。手工模式下的药品库存难以及时掌握,虽然采取了每日进行缺货登记的措施来控制库存,却增加了登记尚未缺货药品库存的多余工作,费时费力。不能及时了解每种药品的所剩有效期,使一些药品错过退货期限,造成过期药品库存堆积,带来严重的经济损失。为了适应时代的发展,提高药店的工作效率,优化库存的数量与质量,以增加药店的经济效益和使药店运转更顺利,应尽量减少手工操作的工序,实现对药品的各项管理的电脑化,使高新技术在降低运营成本、提高管理水平和综合经济效益中发挥积极的作用。因此，开发一个集处理药品、客户、供货商信息于一体的，包括员工管理的药品进销存管理系统，是符合市场发展需要的。

目前软件市场上已有功能比较完善的各类销售、财务等软件,但该药店没有广泛使用管理信息系统软件。综合各方面因素,没有必要购买市场上价位较高的现成软件,虽然这些软件的功能已相当完善,只须开发一个适合该药店的操作简单的小型管理信息系统就可以了,大型软件中一方面好多功能冗余，只是摆设，并

不能实际的为药店所用，另一方好多功能方面都很欠缺，主要表现在库存报警系统与客户信息这一块，对于客户、供货商信息的管理做得都不完善，有的根本没这部分内容，而这些信息也是很重要的，有利药店人员从各个方面对药店状况进行分析，管理。因此，开发这样的药品进销存管理系统，是符合市场发展需要的，而且由于药店现在的员工均在中、青年龄段,对外来的新鲜事物接受能力较高,完全可以胜任该套管理信息系统的使用,这样便可以帮助职工从繁琐的重复性劳动中解脱出来,提高整个药店的工作效率,而由于系统的开发应用使药店运营效率提高会带来无形的可观的经济效益,从而提高药店的经济效益。

Today, frequent drug price, and a variety of drugs has increased the difficulty of selling price. Drugs to cargo acceptance review of the validity of the registration error-prone links, wrong date or a period of less than resumption of the drug.Manual mode it is difficult to gain prompt access to drug stocks, although the daily缺货登记taken measures to control inventory, but have not yet registered an increase of excess inventory out of stock medicines work, time-consuming and laborious. Unable to understand the validity of each of the remaining drugs, some pharmaceutical missed period returns, resulting in the accumulation of expired medicine inventory, lead to serious economic losses. In order to adapt to the times of development and improving the efficiency of the pharmacy, and optimize the quantity and quality of inventory in order to increase the economic benefits of drug stores and pharmacies operate more smoothly, and should minimize manual processes and achieve the management of drug computerized so high and new technology to reduce operating costs, raise the level of management and integrated cost-effective to play an active role. Therefore, the development of a set to deal with drugs, customers, suppliers of information in one, including staff management of drug Invoicing Management System, is in line with market development needs. The current software market, there are various types of functions to improve sales, finance and other software, but it is not widely used in pharmacy management information system software. Taking all factors, there is no need to buy a higher market price of the off-the-shelf software, although the functions of the software is quite perfect, only for the development of a simple operation of the

pharmacy management information system of small-scale it, on the one hand, large-scale software good multi-redundant, but display does not actually used for the pharmacy, the other side are the lack of good multi-purpose area, the main alarm system in the inventory and customer information in this piece, for customers, suppliers of information management do not perfect, and some did not this part, which is also very important information, enabling all aspects of pharmacy from an analysis of the situation on the pharmacy management. Therefore, the development of drugs such as Purchase, Sales and Inventory Management System is in line with the market development needs, and as a result of pharmacy staff are now in the Green group, external to the ability to accept new things higher, can be competent enough for the set of management information system so that we can to help workers from the tedious repetitive work out of and improve the efficiency of the entire pharmacy, and as a result of the development and application of systems to enable pharmacies to improve operational efficiency will bring about considerable economic benefits invisible, thereby enhancing the pharmacy economic benefits.

1.3定义（Definitions）

药品进销存是从药品的采购（进）到入库（存）到销售（销）的动态管理过程。

进销存：“进”是指药店的商品采购；“销”是指药店的商品销售，包括批发、零售和连锁；“存”是指药店的商品的存储；合起来就是整个药店的日常经营活动。

Purchase,Sales and Inventory Of Drugs are (enter) from the drugs purchase (save) (sells) to the sale the dynamic management process to the warehousing.

Purchase,Sales and Inventory: “purchase” is refers to the pharmacy the commodity purchase; “sales” is refers to the pharmacy the realization of goods, including wholesale, retail sales and chain-like; “inventory” is refers to the pharm acy the commodity memory; Gathers is the entire pharmacy daily operative activity.

1.4参考资料（References）

（1）《软件工程》，张海藩编著，人民邮电出版社

(1)《Software engineering》，Zhang Haifan writes, People's posts and telecommunications publishing house

（2）《软件工程基础》,汤惟编著,西安交通大学出版社

(2)《Software engineering Foundation》，Tang Wei writes, Xi'an Jiaotong University Publishing house

(3)《软件工程导论》,朱少民编著，清华大学出版社

(3)《Software engineering introductory remarks》，Zhu Shaomin writes, Tsinghua University publishing house

(4)《软件架构设计》，温昱编著，电子工业出版社

(4)《Software construction design》，Wen Yu writes, Electronics industry publishing house

(5)《软件测试技术经典教程》，赵斌，科学出版社

(5)《Software testing technology classical course》，Zhao Bin writes, Scientific Publishing house

（6）《软件设计师教程》，陈平褚华编著，清华大学出版社

(6)《Software designer course》，Chen Ping,Zhu Hua writes, Tsinghua University publishing house

2、任务概述（Tasks Outline）

（江淑萍：3062101129 JIANG SHU PING Reg No. 2102-011-0029）

2.1目标(Goals)

药店的目标是要扩建至少两个分药店，并在各大城市成立连锁店。原有的管理系统已不再适应药店发展的需要，其中也存在许多问题，而且药店的发展要求系统有更多、更强大的功能，原有系统却不具备这几点。

药品进销存管理信息系统的功能模型中包括了对新药品数据的管理与维护，对药品库存数据的管理与维护以及对客户数据的管理。这些数据对药店进行药品进销存管理极为重要，为此,提供方便、快捷的信息查询和维护是系统设计考虑的基础。药品进销存管理系统是将技术含量不高，重复性强的工作转化为自动化处理的。本系统的开发目的主要是为了解决中小型药店日常经营中包括药品采购、药品销售、药品库存、账务往来等所有业务环节在内的科学化管理，完成日常经营活动中各种业务数据的共享，通过对这些数据的汇总和分析来对决策作出支持，从而来提升药店的核心竞争力。

新系统强大的管理功能和业务处理功能，再加上科学的管理方法，一定会提高药店的工作效率，从而为药店的发展做出很多贡献。

Purchase, sales and inventory of drugs management information system's functional model to include to the new drugs data management and the maintenance, to drugs stock data management and maintenance as well as to customer data management.These data carry on the drugs to the pharmacy to enter sells saves the management great importance, for this reason, provides convenient, the quick information inquiry and the maintenance is the system design consideration foundation.Purchase,Sales and Inventory Of Drugs Management system are not high the technique content, the duplicated strong work transforms as automated processing. This system's development goal is mainly to solve in the middle and small scale pharmacy daily management including the drugs purchase, the drugs sale, the drugs stock, the bookkeeping intercourse and so on all service link's scientific management, completes in the daily operative activity each kind of service data sharing, through and analyzes to these data's compiling makes the support to the decision-making, thus promotes the pharmacy the core competitiveness.

Alarm system and customer information this quite important, in each pharmacy or the medicine company's stock drugs are many, if one kind or time many kinds of drugs stock insufficiency, artificial searches is not realistic, including inspect goods time is not very convenient, in the existing system has carried on the restraint to near effective date drugs, if three month warnings, one month warning, but the stock drugs warning actually throughout is a blank, but this can reflect that exactly one drugs the sales degree, this is advantageous for the next time drugs purchase the selection. In the pharmacy will have the drugs to sell and the input every day, but in the existing system has not taken the customer information and supplier information this on the one hand the content, was only has carried on the management to the pharmacy personnel, but in fact, the customer information and the supplier information

advantageous pharmacy personnel carried on the analysis, the management from each aspect to the pharmacy condition, if had the customer contact method and the record, might implement the preferential policy like this at the same time regarding the old customer, the new customer might carry on the follow-up service, if fixed time telephoned to inquire that the drugs service condition as well as told the customer some matters needing attention.

The new system formidable management function and the handling of traffic function, in addition the scientific management, certainly will enhance the pharmacy the working efficiency, will thus make many contributions for the pharmacy development.

2.2用户特征(User characteristics)

此系统的最终用户为中小型药店各部门的业务人员，药店的中高层领导，系统管理员，各部门的统计员，客户等。

此软件最终将直接面对员工，而员工可能在其自身领域内是工作经验丰富，但面对一个其他领域的事物时，可能就不具备使用或操作的经验。这就要求本系统在使用时要尽可能的简单方便。

系统管理员，各部门的系统管理员及统计员，此类人员具备计算机领域的相关知识，包括数据系统等方面的知识，可以操作并熟练使用此系统，同时可以通过更改软件的一些参数，使用相关的工具来实现查询、统计、更新、等功能。

系统管理员，此类人员具备计算机领域的高端技术，对软件的框架结构及技术非常了解，可以通过软件自带的工具和专业技术对系统进行维护，以保证系统能高效工作。

客户，客户可以通过登录本系统来下订货单，这就要求操作简便，尽量减少输入，交互友好，安全可靠。

另外还有一个特殊的用户群体：药店的中高层领导，这就要求系统具有业务数据汇总、分析的功能，可以帮助公司的中高层领导来做出决策，及时调整营销策略。

This system's end-user is the middle and small scale pharmacy various departments' services, the pharmacy high-level leader, system manager, various departments' statistician, customer and so on.

This software will face the staff directly finally, but the staff possibly is the work experience is rich in its own domain, but faces other domains time the thing, possibly does not have the use 'OR' operation experience. This requests this system when the

use must as far as possible simple convenient.

The various departments' system managers and the statistician, this kind of personnel have the computer domain related knowledge, including aspect and so on data system knowledge, may operate and use this system skilled, simultaneously may through change software's some parameters, uses the related tool to realize the inquiry, the statistics, the renewal, and so on functions.

The system manager, this kind of personnel have the computer domain high-end technology, understood to software's portal frame construction and the technology, may carries on the maintenance through the software bringing tool and the specialized technology to the system, the guarantee system can work highly effective.

Under the customer, the customer may through register this system to come the order form, this request operation is simple, reduces the input as far as possible, is alternately friendly, safe reliable.

In addition has special user community: The pharmacy high-level leader, this request system has the service data to compile, the analysis function, may help company's high-level leaders to make the decision-making, adjusts the marketing strategy promptly.

2.3产品与其环境的关系(Products and its environment relations)

此系统的服务器用于存放日常业务数据，以及供应商、客户、药品的信息，服务器应该放置在药店总部里安全的地方。而其他终端则放在分药店，连锁店，各相关部门办公室、库房。

This system's server uses in storing the day-to-day business data, as well as the supplier, the customer, the drugs information, the server should lay aside in the pharmacy headquarters the safe place. But other terminals place a minute pharmacy, chain store, each related department office, storehouse.

2.4限制和约束(Limits and restraint)

要求此系统实现功能的强大性与经济性很好地结合，得到资金限度内的功能最优化。同时也要求开发期限为18周，以便早日投入使用。

Functional requirements of this system and the powerful combination of a good economy, finance function within the limits of optimization. It also requires the development of a period of 18 weeks in order to put into use as soon as possible.

3、需求规定(Rules of Requirement)

3.1对功能的规定(Rules of function)

药店管理系统的功能模型由五个子系统组成,即药品管理子系统、销售管理子系统、信息管理子系统、信息预警子系统系统管理子系统。

药品进销存管理信息系统的功能模型中包括了对新药品数据的管理与维护，对药品库存数据的管理与维护以及对客户数据的管理。这些数据对药店进行药品进销存管理极为重要，为此,提供方便、快捷的信息查询和维护是系统设计考虑的基础。要求新系统能解决中小型店日常经营中包括药品采购、药品销售、药品库存、账务往来等所有业务环节在内的科学化管理，完成日常经营活动中各种业务数据的共享，实现实时通信来保证业务数据的快速更新，通过对这些数据的汇总和分析来对决策作出支持，从而来提升药店的核心竞争力。

Pharmacy management system functional model composed of five subsystems, namely, drug management system, sales management system, information management system, information system management system of early warning system.Invoicing drug management information system functional model, including new drugs for the management and maintenance of data, data on the management of drug inventory and maintenance, as well as the management of customer data. The data on the management of pharmacies to drug Invoicing and to that end that will offer convenient, efficient and maintenance of information is the basis of system design considerations.Requirements of the new system to solve day-to-day operation of small and medium-sized stores, including drug procurement, drug sales, drug inventory, accounts and other transactions, including all business aspects of scientific management, the completion of day-to-day business operations of various data sharing, real-time business data communications to ensure the rapid update of summary of the data and analysis to support decision-making and thus to enhance the core competence of pharmacy.

3.2对性能的规定(Rules of performance)

3.2.1精度(Precisions)

要求能准确、无误地查询、添加、修改、删除供应商信息，客户信息，药品

信息；能够精确地进行业务数据汇总来支持决策。做到实时通信来保证业务数据的最新性。

The request can accurate, inquire, the increase, the revision, to delete the supplier information unmistakably, the customer information, the drugs information; Can carry on the service data to compile precisely supports the decision-making. Achieves the real-time communication to guarantee the service data newest.

3.2.2时间特性要求(Time response request)

●响应时间

要求响应迅速，实现业务数据的实时传递，时间大约为1s。

●更新处理时间

要求执行更新处理操作时，能快速准确地处理，时间大约为1~1.5s。

●数据的转换和传送时间

库存盘点时要用到条码扫描终端设备，要求到条码时，能快速转换数据，并将数据迅速传到系统进行汇总处理，时间大约为1s。

●response time

The request response is rapid, realizes the service data real-time transmission, the time probably is 1s.

●Renewal process time

When request execution renewal processing operation, can process accurately fast, the time probably is 1~1.5s.

●Data transformation and transmission time

When stock inventorying must use the bar code to scan the terminal device, when requests to the bar code, can the split-second-selection data, and passes to the data the system to carry on compiles processing, the time probably be 1s rapidly.

3.2.3输入输出要求(Input output request)

当用户输入查询关键字时，能迅速进行汇总，并以报表的形式给出分析结果，要具备清晰明了的优点。

When user input inquiry key words, can carry on rapidly compiles, and gives the analysis result by the report form, must have the clear intelligible merit.

3.2.4数据管理能力要求(Data management ability request)

要求新系统有强大的数据库系统为支持，可以容纳大量的业务数据和各种信息资料。同时还具有强大的数据管理能力，包括查询、更新、修改、统计等功能。数据库的维护和备份也要做到方便、简洁。

Request the new system to have the formidable database system is the support, may hold the massive service data and each kind of information paper. Simultaneously also has the formidable data management ability, including functions and so on inquiry, renewal, revision, statistics. The database maintenance and the backup must achieve are convenient, are succinct.

3.2.5故障处理要求(Failure processing request)

当系统出现故障时，可利用系统自身的维护工具来进行系统的故障排除，也可以联系我们来进行故障处理。

When the system presents the breakdown, may carry on system's trouble shooting using the system own maintenance tool, may also contact with us to carry on the failure processing.

3.2.6其他专门要求(Other request specially)

新系统可以设置不同的访问权限，用户单位为了安全，可以针对不同级别的用户来设置不同的访问权限。用户使用系统时，操作简单方便。同时系统具有可维护性、可补充性、易读性、可靠性、运行环境可转换性的特殊要求等。

The new system may establish the different access authority, the user unit to be safe, may aim at the different rank the user to establish the different access authority. When user use system, the simplicity of operator is convenient. Simultaneously the system has the maintainability, to be possible supplemental, the readability, reliable, the movement environment convertibility special request and so on.

4、系统功能需求分析(System function Requirement analysis) 4.1系统功能总体结构(System function gross structure)

（董小龙3062101124 Dong XIAO LONG Reg No. 2102-011-0024）

4.2药品管理需求分析(Drug control requirement analysis)

（解伟3062101136 XIE WEI Reg No. 2102-011-0036）

完成各类药品信息的查询，添加，修改，删除操作；

药品入、出、存的查询统计；

辅助制定合理的药品库存水平和采购计划，以最小的资金占用保证药品的供应。

包含功能如下图所示：

Complete each kind of drugs information the inquiry, the increase, the revision, deletes the operation;

The drugs enter the inquiry statistics which, saves;

The auxiliary formulation reasonable drugs stock level and the buying plan, take the guarantee drugs by the smallest fund the supply；

Contains the function following chart to show:

4.2.1 药品查询(Drugs Inquiries)

在药品查询模块中，用户可以完成对各类药品信息进行查询操作。可以按不同的条件进行查询，如：

按名称查询：药品简拼、药品名称、药品ID

按种类查询:泌尿系统、消化系统、内分泌系统、抗感染类系统、五官科系统、妇产科、神经系统、细血管系统、呼吸系统

按供货商查询:供货商名称、供货商ID

按科目查询:西药、中药、中成药

按库存量查询:零库存量、全部库存、手动控制查询条件

In the drugs inquiry module, the user may complete to each kind of drugs information carries on the inquiry operation. May carry on the inquiry according to the different condition,as follows:

Inquires according to the name: Drugs Jan Pin, drugs name, drugs ID

Inquires according to the type: Uninary system, digesting system, endocrine system, anti-infection class system, five senses branch system, gynecology and obstetrics department, nervous system, thin vascular system, respiratory system Inquires according to the supplier: Supplier name, supplier ID

Inquires according to the subject: Western medicine, traditional Chinese medicine, traditional Chinese medicine

Inquires according to the reserve: Zero reserve, keeps in stock, the hand control inquiry condition completely

4.2.2 药品入库查询(Drugs warehousing inquiry)

在药品入库查询模块中，用户可以对段时间内的采购药品进行查询，如需对上月3月10号至3月31号进行的采购药品情况进行查询（便于客户了解销售情况），则可进行段时间内查询，并可对总金额进行统计打印。

In the drugs warehousing inquiry module, the user may carry on the inquiry to the section time purchase drugs, if must carry on to last month March 10 to March 31 the purchase drugs situation carried on the inquiry (to be advantageous for customer understanding sale situation), then might carry on the section time to inquire, and might carry on the statistical printing to the aggregate amount.

4.2.3 药品出库查询(Drugs leave the storehouse Inquiry)

类似于药品出库查询模块，实现功能以及实现方式与药品出库查询模块相似，在药品出库查询模块中，用户可以对段时间内的采购药品出库情况进行查询，如需对上月3月10号至3月31号出库药品情况进行查询（便于使用者了解出库情况），则可进行段时间内查询，并可对销售总金额进行统计打印。

药品出库时，应按发货或配送凭证对实物进行质量检查和数量、项目的核对。如发现以下问题应停止发货或配送，并报有关部门处理：

（一）药品包装内有异常响动和液体参漏；

（二）外包装出现破损、封口不牢、衬垫不实、封条严重损坏等现象；

（三）包装标识模糊不清或脱落；

（四）药品已超出有效期。

Is similar leaves the storehouse inquiry module in the drugs, realizes the function as well as realizes the way and the drugs leaves the storehouse inquiry module to be similar, in the drugs leave in the storehouse inquiry module, the user may leave the storehouse situation to the section time purchase drugs to carry on the inquiry, if must carry on the inquiry to last month March 10 to March 31 storehouse drugs situation (to be advantageous for user to find out storehouse situation), then might carry on the section time to inquire, and might carry on the statistical printing to the sales aggregate amount.

When the drugs leave the storehouse, should according to deliver goods or the allocation certificate carries on the quality testing and quantity, the project checkup to the material object. If discovered that the following question should stop delivering goods or the allocation, and the newspaper Department concerned processes:

(1) In the drugs packing has the unusual sound and the liquid senate leaks;

(2) The outside wrapping presents phenomena and so on breakage, seal not jail,

liner not reality, seal major damage;

(3) The packing marks slurred or falls off;

(4) The drugs have surpassed the term of validity.

4.2.4 药品入库(Drugs Warehousings)

（朱建钊3062101128 ZHU JIAN ZHAO Reg No. 2102-011-0028）当销售药品时首先判定库存余量是否充足，如若余量不足则需进行采购，采购完毕时需进行药品入库操作，将药品存至库存之中，并将其准确的数量进行统计保存（如若库存中有剩余量，则可进行查询操作，并直接进行数量的增添）。

基本要求：

（1）药品与非药品、内服药与外用药应分开存放，易串味的药品与一般药品应分开存放。

（2）药品应根据其温湿度要求，按照规定的储存条件存放。

（3）处方药与非处方药应分柜摆放。

（4）特殊管理的药品应按照国家的有关规定存放。药品在库陈列储存

（5）危险品不应陈列。如因需要必须陈列时，只能陈列代用品或空包装。危险品的储存应按国家有关规定管理和存放。

（7）拆零药品应集中存放于拆零专柜，并保留原包装的标签。

（8）中药饮片装斗前应做质量复核，防止混药。

When sales drugs first determines the stock remainder to be whether sufficient, if remainder insufficiency, then must carry on the purchase, the purchase finished when must carry on the drugs warehousing operation, saved the drugs to the stock during, and carried on its accurate quantity the statistical preservation (, if kept in stock has residual, then might carry on inquiry operation, and carried on quantity directly addition).

Essential requirements:

(1) The drugs with the non-drugs, the medicine and the external use medicine should separate depositing, the easy taste contamination's drugs and the common drugs should separate depositing.

(2) The drugs should act according to its humiture request, according to stipulation storage condition depositing.

(3) The prescription drug should divide the cabinet with the non-prescription

drug to place.

(4) The special management's drugs should defer to national concerned requirements depositing. Drugs in storehouse exhibition storage.

(5) The dangerous material should not exhibit. When if needs must exhibit, can only exhibit the substitute item or the spatial packing. The dangerous material storage should according to the national concerned requirements management and depositing.

(6) Sells separately the drugs to concentrate depositing to selling separately the special counter, and retains the original package the label.

(7)Before the traditional Chinese medicine tablets ready for decoction attire fights, should make the quality to reexamine, prevents to mix the medicine.

4.2.5 药品出库(Drugs out of the Treasury)

相反，如若余量充足时需要进行销售，即出库操作，根据不同的数量要求进行数量的更改操作。药品出库工作由药库管理员负责。药品出库凭“药品领用单”。由领用单位填写“药品领用单”，药库管理员按照实际品种和数量发放药品，对库存暂不足的品种，均需说明情况，并尽快请购，严把质量关，药品出库时，药库管理员和领用者必须以认真负责的态度，检查质量和有效期，核实品种，规格等，严防变质失效的药品出库。药品领用单经领用者以及发药库管理员签字，作为存档，以备查。出库单、退货出库、盘亏、报损、药品外售等，都必须有完整记录。

On the contrary, when the remainder is sufficient needs to carry on the sale, namely the storehouse operation, carries on quantity according to the different quantitative requirement the change operation. The drugs leave the storehouse work to be responsible by the medical supply store manager. The drugs leave the storehouse to depend on “the drugs to lead with the list”. Fills in “the drugs by the collar with the unit to lead with the list”, the medical supply store manage r according to the actual variety and quantity provide drugs, to keeps in stock temporarily the insufficient variety, must explain the situation, and please buy as soon as possible, strictly the quality pass, when the drugs leave the storehouse, the medical supply store manager and leads the customer to by the earnest responsible manner, the inspection quality and the term of validity, the checking variety, the specification and so on, takes strict precautions against the drugs which the deterioration expires to leave the storehouse. The drugs get with Shan Jingling the customer as well as send the medical supply store manager signature, takes the archive, by reference. Leaves the storehouse list, to return goods the storehouse, the loss, to write off, outside the drugs to sell and so on,

must have the complete record.

4.2.6 药品信息管理(Drugs Information Management)

药品信息管理中包含了所有药品的详细信息，如产地、科目、种类、规格、单位、售价、批准文号、生产日期、进价、有效期、数量及备注。药品信息是药品进销存管理系统的核心枢纽，决定了其他操作的执行，如：查询条件、药品报废条件等等。

In the drugs information management has contained all drugs detailed information, like habitat, subject, type, specification, unit, selling price, authorized document number, production date, purchasing price, term of validity, quantity and note. The drugs information is the drugs enters sells saves management system management system's core key position, has decided other operation execution, for example: Inquiry conditions, drugs abandonment condition and so on.

4.2.7 药品报废(Drugs abandonment)

当药品超过最大有效期限或国家要求停止生产时需对药品进行报废处理。药品的有效期是反映药品内在质量的重要指标之一，是保证药品安全性和有效性的前提，超过有效期的药品即为过期药品，坚持药房药品常购少存原则，根据需求合理掌握库存药品数量。不常用的药品坚持少进或不进的原则，避免过期造成浪费。药品管理人员要经常检查药品出厂日期、不可避免的药品过期失效，由药店管理人员列出药品清单，由卫生所负责人签字，报经领导审批后集中进行销毁。

When the drugs surpass the most greatly date of expiry or the national request stop produce must to the drugs carry on abandonment processing. The drugs term of validity is reflected that one of drugs intrinsic quality important targets, is guaranteed the drugs security and the valid premise, surpasses the term of validity the drugs is the expired drugs, insisted that pharmacy drugs Chang Goushao save the principle, grasps the stock drugs quantity reasonably according to the demand. Not the commonly used drugs insisted that little enters the principle which or does not enter, avoids expired creating the waste. The drug control personnel want to inspect the drugs manufacture date, the inevitable drugs expired expiration frequently, lists the drugs detailed list by the pharmacy administrative personnels, by clinic person in charge signature, newspaper after leadership examination concentrates carries on the destruction.