Design And Implementation Of Equipment Maintenance Work Order Flow System

With the rapid development of science and technology, the proportion of office application software is growing quickly in daily life. At present, most enterprises still use the mail to send and receive documents, not only the operation is very cumbersome, the data storage and analysis is also very difficult.The work order management system is designed to establish a set of modules, in which you can fill in the form through a web page and finish data storage through the database, and provides the function of data analysis and management. Through this system, it can not only eliminate the tedious process of using mails to exchange files between users, but also can strengthen the classification management of data files and reduce the management cost.Combining with the actual situation of Qingjiang energy company in Yichang, Hubei,according to the analysis of the demand, the template management, data reporting and data analysis are the three main objectives of the work.Specifically speaking, the template management is mainly related to the interface of interacting with users and the storage of database table. The part of Data reporting need to interact with the Office software, access to the contents of the document, and write the relevant data to files and databases. While the data analysis section is required to be able to generate a wide variety of charts, such as the straight line chart, the column chart, the pie chart, etc, and to be able to customize the source of the data.After research and analysis, the decision is made to complete the development of the system by Web program. This system uses.NET as the development platform, and the main interoperability program set PIA provided by Microsoft as a technical basis for the operation of Office software, and adopts OLE-DB technology to read the contents of the Excel file. In addition, it utilizes the Hight Charts control to generate the chart, and uses the database type to control the custom data source.At present, the system has been successfully completed and put into use, which greatly simplifies the original cumbersome work order operation process of Qingjiang company, improves staffs' work efficiency, and reduces the cost of management. The user response is good.