药品进销存管理系统Purchase, Sales and Inventory Of Drugs Management System
1.1编写目的（Compilation goal） (4)
2、任务概述（Tasks Outline） (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.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) (25)
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) (28)
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) (36)
5.2.3 药品出库查询E-R图(Drugs leave the storehouse to Inquire the E-R Diagram) 36
5.2.4 药品入库E-R图(Drugs go into storage E-R the Diagram) (36)
5.2.5 药品出库E-R图(Drugs leave the storehouse E-R Diagram) (37)
5.2.6 药品报废E-R图(Drugs Discard the E-R Diagram) (37)
5.3 信息管理E-R图(Information Management E-R Diagram) (37)
5.3.1 供货商信息查询E-R图(Supplier Information Inquire the E-R Diagram) (37)
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) (38)
5.3.4 供货商信息管理E-R图(Supplier Information Management E-R Diagram) (38)
5.3.5 客户信息管理E-R图(Customer Information Management E-R Diagram) (38)
5.3.6 员工信息管理E-R图(Staff Information Management E-R Diagram) (38)
5.4 销售管理E-R图(Sales management E-R Diagram) (39)
5.4.1 销售录入E-R图(Sales Input the E-R Diagram) (39)
5.4.2 退货管理E-R图(Returned Goods manage the E-R Diagram) (39)
5.4.3 销售查询E-R图(Sales Inquire the E-R Diagram) (39)
5.4.4 退货查询E-R图(Returned Goods inquire the E-R Diagram) (40)
5.5 信息预警E-R图(Information Forewarn the E-R Diagram) (40)
5.5.1 报废预警E-R图(Abandonment Forewarn the E-R Diagram) (40)
5.5.2 库存预警E-R图(Stocks Forewarn the E-R Diagram) (40)
5.6 系统管理E-R图(System Administration E-R Diagram) (40)
6、数据流图(Data Flow Diagram) (40)
6.1 系统基本模型(System Fundamental Models) (41)
6.2 药品管理数据流图(Drug Control Data Flow Diagram) (42)
6.3 信息管理数据流图(Information Management Data Flow Diagram) (42)
6.4 销售管理数据流图(Sales Management Data Flow Diagram) (43)
6.5 信息预警数据流图(Information Early Warning Data Flow Diagram) (44)
6.6 系统管理数据流图(System Administration Data Flow Diagram) (44)
7.Data Dictionary（数据字典） (45)
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.
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.
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.
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.
《Software engineering》，Zhang Haifan writes, People's posts and telecommunications publishing house
《Software engineering Foundation》，Tang Wei writes, Xi'an Jiaotong University Publishing house
《Software engineering introductory remarks》，Zhu Shaomin writes, Tsinghua University publishing house
《Software construction design》，Wen Yu writes, Electronics industry publishing house
《Software testing technology classical course》，Zhao Bin writes, Scientific Publishing house
《Software designer course》，Chen Ping,Zhu Hua writes, Tsinghua University publishing house
2 任务概述（Tasks Outline）
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.
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)
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)
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)
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)
4.2药品管理需求分析(Drug control requirement analysis)
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)
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)
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)
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)
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).
(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.