A garment enterprise ERP Sales Management System Design and Implementation
|School||University of Electronic Science and Technology|
|Keywords||Garment Enterprises Sales Management System ERP ASP.NET SQL Server|
In this thesis, against the background of M garment enterprise, aiming at the demand of its ERP sales management system, we first analyze the supplier, product, client, order, district and corresponding business process, clear and refine the functional requirement of the sales management system. On this basis, we design the database of the sales management system using Microsoft SQL Server, and model the functional modules of the sales management system using ASP.NET. The sales management system has excellent stability and expandability because of the ASP.NET.We research the system from the following aspects in details.Firstly, on the basis of summarizing the status of the sales management system and evolution trends of ERP technology, we analyze and confirm the development methodology, achieving goals, functional modules, operating environment and layer of structure of the ERP sales management system of M garment enterprise.Secondly, we design the data base of the ERP sales management system of M garment enterprise using Microsoft SQL Server 2000. Specifically, it includes clearing the logical relationship of the data sheets and establishing them one by one. We also develop the stored procedure of all the parts of the system according to the sales business process.Thirdly, we divide the ERP sales management system into three functional modules, respectively product management, sales management and order management, depending on the actual business of the sales department of M garment enterprise. We realize each functional module using the most popular network programming language ASP.NET. Besides, we also build the user management system, to preserve the safety and integrity of the system.