| This paper is about the ERP (Enterprise Resources Planning) of a steel company. To the actual demand of product management of this factory, having carried on the overall design of the product management system, and having finished the concrete design of the module of main function and implementation method.This paper introduces the background and significant of this item, summarizes ERP's development history, advantages, current application situations at home and abroad and network database programming technology, and have introduced the overall conceptual design of this factory's ERP system and main function framework. The development environment is brief introduced.After understanding the production process of this factory and groundwork function of each department thoroughly, analyzing business procedure of the production management of this factory and data procedure deeply, author have designed the overall framework of this system. The database designs outline is described. The detailed specification for the data list of the stock is completed by author.Around stock of the products, the concrete designing and realizing detail of self relevant links restrain is expounded for put in storage manage, hand in storehouse manage, selling manage, scrap management and etc. Design procedure of procedure block diagram and corresponding trigger that the module of main function realizes is provided. Body of operation window of some software module is provided too. The author counts the module to describe the detailed design to the main report form, and has done the brief introduction to the design of the comprehensive inquiry function. |