Development And Application Of Real-time Report Configuration Running Software In MES

The topic of this paper is based on the "Statistical Analysis of Production and Operation Data of a Nanjing Petrochemical Company" project.With the development and accumulation of a petrochemical company in Nanjing for decades,the report service has become an important demand.The company has diverse requirements for reporting services and different design patterns.It also has higher requirements for all stages of energy production and consumption,and hopes to complete statistics and analysis of data.Therefore,the report services is an important part of the petrochemical company MES.The old version of the report automation system has been unable to meet the changing needs,and with the use of the past few years,its efficiency in statistics,analysis and design are not high.In addition,the drawbacks of increased labor intensity and difficulty in maintaining information are also becoming increasingly prominent.Based on the characteristics of real problems,the original report business and features were investigated and analyzed,and the report system software applicable to the company was designed and developed.As a carrier of information,the report provides a powerful guarantee for the petrochemical company’s integrated management and control services.This system uses Delphi as a development tool.The database is SQL Server and the local database is a server.The development platform is Delphi7Build8.1,using SOA design pattern,C/S and B/S hybrid multi-level architecture.It not only reduces the pressure on the server,but also solves problems such as poor data collection and presentation of reports.Based on the RBAC privilege model design to reduce business logic coupling,enhanced maintainability and scalability.In technology,by combining dynamic fields and script-based dynamic report generation methods,the determination of the report structure is postponed until the system is running,overcoming the manual drawing of reports in the traditional software development process,and the report cannot be modified while the system is running.The structural weaknesses make the report generation dynamic.Reports generated in this way can combine,count,filter,and calculate corrections to the original data according to the actual needs of the user,and satisfy the need for data report flexibility in the production work.The main development system management module,report configuration module,report export module and chart display module,and real-time and historical data collection and finishing.At present,the system has been operating normally in a petrochemical company in Nanjing and has achieved good results.