The Design And Implementation Of The Warehouse Management System For Workshop

Cigarette factory has a spare parts warehouse and the corresponding management system, to achieve a centralized storage of spare parts and unified query. The production workshop for the protection of production needs, have their own two warehouses, storage of items include:from the plant spare parts for spare parts, spare parts removed from the scrap available spare parts, utility tools and maintenance tools. Second-level warehouse is used by manual billing, storage, the library need to manually fill out the form, and later to maintain. The difference between the different personnel records and the accuracy makes the maintenance of the system difficult. The enterprise spare parts management system can not be timely, and it is difficult to maintain the spare parts management system. Accurate grasp of the actual inventory of enterprise spare parts and use.The spare parts management system is an important part of the enterprise information system. Its basic function is to realize the warehousing, warehousing and statistical management. The higher level demand is the early warning of the inventory and the health state of the equipment and provide the basis for the spare parts purchasing plan. Based on the design and development of workshop spare parts management system and the actual demand of workshop spare parts management, this paper designs and implements an Internet-based workshop-level spare parts management system. This system uses B/S structure development, based on Windows 7 operating system, with.NET framework as the development platform, using C# as the development language, SQL Server2008 as the database. Spare parts management system development using software engineering ideas and methods to improve development efficiency and reduce the difficulty of maintenance.Workshop spare parts management information system to achieve the main functions are:(1) Spare parts out of storage management:the system provides spare parts to add, delete, modify functions, and tools to borrow also management. (2) Statistical query management:to achieve monthly, quarterly inventory management, and classified according to production line cost statistics. (3) Spare parts early warning management:When the spare parts inventory quantity is lower than the inventory limit, make an early warning; for the spare parts with life, in the near life period to remind maintenance personnel to carry out inspections. (4) Spare parts statistical functions:statistical analysis of spare parts replacement frequency. (5) Role management:sub-warehouse administrator, maintenance personnel role.The system has been deployed in the shop operation, improve the spare parts management efficiency and the efficiency of the use of spare parts funds.