The Design And Implementation Of The Drug Warehouse Management System

Along with the implementation of the new reform, state supervision of the pharmaceutical industry will get stronger, which puts forward higher requirements for the management of the medicine circulation enterprises. At the same time, the number of enterprise joining into logistics industry is increasing dramatically. This background brings high growth opportunity for the pharmaceutical supply chain each link of the enterprise, at the same time, the enterprise faces the question of improving working efficiency. Therefore, it is undoubtedly an important means to solve this problem that the use of information technology improves the work efficiency. Especially for circulation and sales industry, it is imperative to develop an efficient and practical drug warehouse management system.This paper uses center storeroom management business of community health center in Tianjin for practical background, elaborates the current development status of drug warehouse management system at home and abroad, based on the investigation and analysis. The system uses the c# language, based on the MVC design idea. It is divided into the presentation layer, business layer, resource access layer, which is developed by ASP.NET technology. The system chooses Oracle11g database. When users operate system in the presentation layer, the system processes data by service representation layer. The user information is received by the business logic of the business layer class, then, the resource access layer handles the data inside the data entity class through the data access class, which is manipulated by the database table to complete the user’s request.The drug storehouse management system mainly implements the system management, storage management, outbound management, inventory management, query statistics. The system management completes the management of the user, the classification of the drug, the drug information, the reservoir area and the position data. The storage management consists of storage registration and quality inspection. The outbound management mainly includes outbound order management, generating the picking orders, picking, outbound. The inventory management is made up of goods inventory classification analysis, inventory query, pendulum cargo management, shifting cargo management, freeze management, thaw management, displacement of single library management, inventory management, coding rules library management, and inventory adjustment, etc. The query statistics consists of inventory statistics, warehousing statistics, overage shortage statistics, location usage statistics, state statistical and inventory statistics, and so on.At present, the central pharmacy store of Tianjin community health service center uses this system to realize the computer information management of the storage, and through this system, it makes warehouse management more scientific, reduces the investment of human resources and improves the operating efficiency. After the system operation, it reduces the workload of the community health service center of Tianjin, improves the operating efficiency, standardizes the management, enhances the competitiveness, and creates greater efficiency.