Design And Implementation Of Cold-Rolled Roll Shop Management System

Iron and steel industry is one of the pillar industries of our national economy,and the roller is the key production spare part of the iron and steel companies.Roll management directly affects the quality of enterprise products production and the normal level of production organization.With the continuous improvements of the level of production management modernization of iron and steel enterprises,aspects such as inventory turnover operation of rollers must meet the needs of modern production of rolling lines.Proven that using computers to manage the production spare parts such as rollers,bearings and etc.can improve the efficiency and can have greater social and economic benefits.This is a subsystem of MES system for ultra-thin line of cold rolling mill,which has achieved the tracking and management of whole life cycle of rollers,bearings and bearing boxes in roll shop.With this system,staffs can dynamically track the current state,usage,inventory condition of rollers,bearings and bearing boxes and this system can also make the roll shop run more efficiently.DB2 is applied as DBMS and front-end development tool is Visual Studio 2005(C#).Business logic is developed by C language and communication programs are developed by Java and Delphi.After system analysis,system design,system implementation,system testing and etc.and all stages of work,this system mainly achieve nine features,which are basic information management,matching management,grinding management,using management,outsourced processing management,cleaning management,query management,report management and parameter management.This thesis describes the process of design and implementation of cold-rolled roll shop management system in ultra-thin line of the Benxi Iron and Steel cold rolling mill.Firstly,this thesis introduces the research background,purpose and significance of the system,analyzes the related works all over the world,and briefly introduces the related theories involved in the system and the related application technologies.Secondly,based on the analysis,design,implementation,testing and other project phases,this thesis states the system implementation process,including the establishment of the system logic models,the design of system feature modules,the development and testing of front-end applications and background business logic,the design and establishment of database and the development and implementation of communication program with the control system of grinding machine.Finally,this thesis summarizes the full content and discusses the future improvement of the system.