The Design And Implementation Of XML-Based Report Generation System On .NET Platform

Report is a powerful means of information organization and analysis,which is also one of the important parts of management information system.Hence,it has a very wide range of applications in all walks of life.In order to meet the increasing requirements of report making,and to support the storage and high quality display of various forms of information,special report generation system must be developed.The development of report generation system,not only need to consider providing rich types of statements,but also need to provide an effective way for other management information system to integrate,and taking into account the mainstream software development platform application,both to meet the changing needs of users,and be conducive to system maintenance and second time development.Based on the above consideration,as well as the special requirement of the hospital class users,this thesis designs and implements a report generation system based on XML on the.NET platform.The main work and technical points of the thesis are as follows:The thesis introduces the general module partition and the technology involved in each component of the report system.Then the overall design scheme of the system is determined according to the actual application scenarios and user requirements.It mainly includes:the system is designed according to the three layer architecture of the presentation layer,the production layer and the data layer;External interface and internal interface design for system internal control and access to external information system;Data structure and database naming standard design,etc.;achieve the design of each sub module of the system includes:report design module,report template library management module,data source module,and so on.At last,the business process and basic function of each module are described in detail.The thesis describes the implement of report generation system which consists of Report Designer,Report Server Agent and Report Control in detail.The Report Designer is the heart of the entire system.This system achieves the general function of report designer,such as the design type of drag and drop and data source management tree and report results in real time preview.The Shell uses the open source control of DevExpress Design Kit;Custom draw function is provided by encapsulating more than 50 functions of GDI,and thus reduces drawing algorithm code.In the Data Source Page module,the hash table is used as a data buffer,which improves the operating performance of the system.The Search Condition Page achieves real time condition transport through the interaction with the data source module.The Preview Page achieves many output type like Excel export,PDF export.Report Server Agent is responsible for database access,and in this module we achieve the basic function of the interaction between the database system and the report system.The report server also provides interfaces for Report Control through Webservice.Report Control achieves the integration with other management information system by packaging report designer's main function as a DLL control using COM component technology.It also support custom interface by highly scalable code design.Besides,the thesis also describes the specific consideration for the application requirement of the hospital users.Temperature control,doctor's medical advice and other personalized features are integrated in the system.Moreover,by the reference of the report control library files,it provides the PDF streaming export service to the hospital for the docking of HIS system.In addition,it also introduces the method to solve the problem of drawing algorithm code duplication and too much system resources occupation during large amount of data loading.Trough the integration of the report control in the actual management information system,the main function of the report system and the large amount of data loading is tested by using real patient data.The experimental results show that the implemented system can carry out a variety of complex statements of report template design,and the performance in large amounts of data can meet the design requirements.Finally,the thesis summarizes the work done and describes possible directions for future studies.