| In this paper,Anhui Jiangnan Machinery Co.,Ltd.in large quantities,many varieties of modes of production process changes and product characteristics, systems analysis automotive spare parts industry hinge actual status of production and processing business logic;because of auto industry parts hinge processing exist fixed inaccurate Products,many parts processing,spare parts Universal flow transfer and documentation are not synchronized with the actual logistics and other special phenomenon,as well as at the lack of metering equipment and Products Product standard toolbox and other factors led to the production of documents should not reverse the Product at the extent permitted by the error fluctuations reflect the actual production and processing data,production management department has not been able to know the actual production data within the workshop and the entire company made semi-finished and finished goods production data distribution.Products based on the production process,the extensive process flow and product flow model,for some products to optimize business processes and production of documents flow adjust and adopt the way of automatic identification products flow,the main problems in thehigh-volume,multi-species,multi-process production mode,Product flow may occur at changes in production under the control of information flow to guide the actual production data extensive statistical analysis,and timely arrangements for the production department of production planning and business provide the basis for cost control,and explore the production of internal management problems exist.In order to adapt the production process and achieve system design goals,the overall product flow process analysis,detailed analysis of product flow processing model,the product of extensive design and product flow auto-sensing mode,the use of UML modeling tools to the workshop set up operations as the central part of the production process functional model;the main business model is designed to form the core of the design of database structure,make full use of the data view, stored procedure,trigger,cursor control technology,and Panel process to improve the efficiency of data query and maintenance of data integrity constraints;achieve the overall function of the final architecture and the main application.function modules,and system implementation to make some suggestions. |