Design And Implementation Of Order Management System For Electrical Equipment Manufacturing And Processing Enterprices

With the continuous development of science and technology and enterprise information technology deeply,information management system and the importance of enterprise informatization construction is increasing,in order to obtain a certain advantage in the fierce market competition process,for electrical appliances manufacturing and processing enterprises,improve the production and management of enterprises to use the advanced information technology has become more and more important.For many small and medium sized electrical appliance manufacturing and processing enterprises,the production and management of enterprises is a very common mode.In this application background,how to solve the problems related to the system of electrical appliance manufacturing and processing enterprises in the order management process,improve the production efficiency will become small and medium-sized appliances manufacturing enterprises,one of the important means to maintain the competitiveness of enterprises.In this system,electric appliance manufacturing enterprises EPR system development project as the background,according to the actual situation of small and medium-sized electric appliance manufacturing enterprises backward management means and low informationization level,based on the B/S model,the periodic synchronization based on the database server to achieve the order processing all functions in the process,including order management,invoice management purchase order management,order management,customer management,return expenses,reimbursement,meeting records,inventory management,product maintenance and other 16 core business modules.The system is expected to improve business orders for customers to improve decision-making capacity,and effectively enhance the competitiveness of enterprises.According to the requirements of the order management information system open,this study intends to introduce the dynamic management information system,the two main techniques of dynamic SQL and dynamic data window based on system level through the establishment of data dictionary and the stored procedure enables applications and specific data table separation,so as to realize the dynamic system.To solve the problem of low efficiency in large number of import data by using the definition of large array of order information pretreatment and automation technology(OLE).