CN101976235A - Extensible Word report automatically-generating method based on dynamic web page - Google Patents

Abstract

Translated fromChinese

本发明涉及一种基于动态网页的可扩展的Word报告自动生成方法，其包括以下步骤：1)为每一个数据处理方法添加一条唯一的表明方法功能和用途的描述信息；2)利用反射技术从数据处理方法共享文件中解析数据处理方法的描述信息，并分类整理封装为标签；3)利用标签定制一份Word形式的报告模板；4)用模板生成动态网页；5)根据页面传过来的数据信息替换Word报告模板中数据占位符，生成Word报告。该方法摆脱了Word对数据访问界面的限制，可获得良好的交互性体验，同时不增加模板定制和报告编写人员的负担，保证系统的高效性和可扩展性。

The present invention relates to a kind of extensible Word report automatic generation method based on dynamic webpage, and it comprises the following steps: 1) for each data processing method, add a unique descriptive information indicating method function and purpose; Analyze the description information of the data processing method in the data processing method sharing file, and classify and package it into labels; 3) Use the label to customize a report template in Word form; 4) Use the template to generate a dynamic web page; 5) According to the data passed from the page The information replaces the data placeholders in the Word report template to generate a Word report. This method gets rid of the limitation of Word on the data access interface, can obtain a good interactive experience, and does not increase the burden of template customization and report writers, and ensures the efficiency and scalability of the system.

Description

Translated fromChinese

基于动态网页的可扩展的Word报告自动生成方法An Extensible Automatic Word Report Generation Method Based on Dynamic Web Pages

技术领域technical field

本发明涉及一种基于动态网页的可扩展的Word报告自动生成方法。The invention relates to an expandable Word report automatic generation method based on a dynamic webpage.

背景技术Background technique

Word是世界上使用范围最广泛的文字处理系统，每天都有大量的word报告需要编制，例如在服务器运行日常管理工作中，针对每一台服务器的运行情况都需要编写日报、周报、月报、季报和年报。这些报告的格式几乎都是固定的，只是其中涉及的具体参数和数据不同而已。如果仅依靠人工进行处理，大量的查询、复制和粘贴工作不但繁琐、耗时，效率低下，而且还容易出错，降低了报告的准确性。因此，研究word报告的自动生成功能具有重要的应用价值。Word is the most widely used word processing system in the world. A large number of word reports need to be prepared every day. For example, in the daily management of server operation, daily, weekly, monthly reports, Quarterly and annual reports. The format of these reports is almost fixed, but the specific parameters and data involved are different. If only relying on manual processing, a large number of query, copy and paste work is not only cumbersome, time-consuming, inefficient, but also error-prone, reducing the accuracy of the report. Therefore, it has important application value to study the automatic generation function of word report.

目前，Word报告自动生成方法有以下几种：Currently, there are several ways to automatically generate Word reports:

1.文档光标跟踪定位方法(叶明，张诤，基于C#.NET的Word报告生成功能开发，计算机工程与应用，2008，44(9)：104-106)。1. Document cursor tracking and positioning method (Ye Ming, Zhang Zheng, Word report generation function development based on C#.NET, Computer Engineering and Application, 2008, 44(9): 104-106).

该方法的主要原理是通过跟踪和控制Word文档内部光标的位置来控制文档内容的起始和相应的格式，并在相应位置上插入指定的内容。其缺点是：报告的版面、样式和内容必须通过程序顺序输入；此外，该方案不够完整，没有涉及用户对数据信息的筛选操作。The main principle of this method is to control the start of the document content and the corresponding format by tracking and controlling the position of the cursor inside the Word document, and insert the specified content at the corresponding position. Its disadvantages are: the layout, style and content of the report must be input sequentially through the program; in addition, the scheme is not complete, and does not involve the user's screening of data information.

2.利用OLE或COM技术直接控制Word(鲁保玉，杨新芳，用Delphi生成Word报告及动态结构表格，计算机软件与应用，2007，4(3)：180-183；孔令彦，黄蓬勃，姜青香等，使用Visual Basic操纵Microsoft Word对象生成报告文档，计算机工程与应用，2003，39(36)：115-117)。2. Use OLE or COM technology to directly control Word (Lu Baoyu, Yang Xinfang, Using Delphi to generate Word reports and dynamic structure tables, Computer Software and Applications, 2007, 4(3): 180-183; Kong Lingyan, Huang Pengbo, Jiang Qingxiang et al., Using Visual Basic to Manipulate Microsoft Word Objects to Generate Report Documents, Computer Engineering and Applications, 2003, 39(36): 115-117).

该方法的主要原理是利用OLE或COM技术直接控制Word，将数据库表结构中的列信息作为标签插入Word文档中以定义模板，在Word中添加自定义窗体连接数据库，在生成文档时从数据库中读取数据，并自动填写到模板中的相应位置上。缺点是采用C/S结构，部署不够方便；并且需要扩展Word的窗口作为数据选择的界面，自定义数据编辑窗体与Word现有界面项目限制，交互体验差；此外，生成报告后，无法在此基础上进行二次数据查询转换；最关键的是，用户还必须熟悉数据库结构及数据库表的列信息。The main principle of this method is to use OLE or COM technology to directly control Word, insert the column information in the database table structure as a label into the Word document to define the template, add a custom form in Word to connect to the database, and generate the document from the database. Read the data in and automatically fill in the corresponding position in the template. The disadvantage is that it adopts the C/S structure, and the deployment is not convenient enough; and it needs to expand the Word window as the data selection interface, the custom data editing form and the existing interface items of Word are limited, and the interactive experience is poor; in addition, after the report is generated, it cannot be On this basis, perform secondary data query conversion; most importantly, users must also be familiar with the database structure and the column information of the database table.

3.基于多种技术的Word文档自动生成方法(葛芬，吴宁，基于多种技术的Word设计文档自动生成平台，电子科技大学学报，2007，36(2))。3. The method of automatic generation of Word documents based on multiple technologies (Ge Fen, Wu Ning, Automatic Generation Platform of Word Design Documents Based on Multiple Technologies, Journal of University of Electronic Science and Technology of China, 2007, 36(2)).

该方法的主要原理是利用VBA将一篇规范的通用文档中可允许被替换的部分采用插入批注的形式设置标签，并把文档及其中的标签信息存储到数据库服务器中，下一步在Asp页面上提供输入框由用户为标签赋值，最后利用用户输入值替换通用文档中标签处的内容生成新的文档。其缺点是：VBA程序全部嵌入到客户端Word应用程序中，部署不够方便；并且VBA界面元素不够丰富，只支持简单的文本录入形式，对于表格、图片等没有后台方法支持。The main principle of this method is to use VBA to set tags in the form of inserting annotations for the part that can be replaced in a standardized general document, and store the document and the tag information in the database server. The next step is on the Asp page Provide an input box for the user to assign a value to the label, and finally use the user input value to replace the content of the label in the general document to generate a new document. Its disadvantages are: all VBA programs are embedded in the client-side Word application program, and the deployment is not convenient enough; and the VBA interface elements are not rich enough, only simple text input forms are supported, and there is no background method support for tables, pictures, etc.

4.使用报表引擎生成指定格式的Word文档。该方法的主要原理是由报表定义工具提供可视化的手段让用户定义报表结构，抽取的字段和抽取后的二次计算规则由用户自定义，在生成报表的时候由报表引擎完成对数据库的访问并在相应位置完成数据替换以生成中间格式的报表，然后再通过输出转换工具，转换成Word文件。典型的产品如水晶报表、润乾报表、用友的Cell等。其缺点是：无法满足复杂的业务逻辑。虽然报表引擎一般提供了特定的语言以编程的形式实现数据计算，但是也仅限于完成简单的处理，对于像“海量数据的任意时间区间的均值/极值的趋势图绘制”，以及实现数据替换后的可编辑操作这样的复杂业务，仍然难以胜任。4. Use the report engine to generate a Word document in the specified format. The main principle of this method is that the report definition tool provides a visual means for the user to define the report structure, the extracted fields and the extracted secondary calculation rules are defined by the user, and the report engine completes the access to the database when generating the report. Complete data replacement at the corresponding position to generate a report in an intermediate format, and then convert it into a Word file through the output conversion tool. Typical products such as Crystal Reports, Rungan Reports, UFIDA Cell, etc. Its disadvantage is that it cannot satisfy complex business logic. Although the report engine generally provides a specific language to realize data calculation in the form of programming, it is limited to simple processing, such as "the trend graph drawing of the mean value/extreme value of any time interval of massive data" and the realization of data replacement. Complicated business such as post-editable operations is still difficult to do.

由此可见，目前还没有一种基于B/S结构的，部署方便、界面元素丰富、交互体验好、支持二次编辑并且具备良好扩展性的Word报告自动生成方法。It can be seen that there is currently no automatic generation method for Word reports based on B/S structure, convenient deployment, rich interface elements, good interactive experience, support for secondary editing, and good scalability.

发明内容Contents of the invention

为了摆脱Word对数据访问界面的限制，获得良好的交互性体验，同时不增加模板定制和报告编写人员的负担，保证系统的高效性和可扩展性，本发明提供了一种全新的方法，它将数据查询方法封装为数据占位符，然后把数据占位符插入Word文档中定制报告模板；利用报告模板生成动态页面，页面调用数据查询方法读取、展示、编辑信息；最终利用这些信息替换报告模板中的数据占位符生成最终的报告。使用该方法，通过Word定制报告模板，对模板定制人员没有额外的技术要求；在页面中展示、编辑数据信息，保证良好的用户操作体验，交互性强；利用信息替换数据占位符生成报告，支持在线的报告局部反复多次编辑；可定制任意复杂的业务处理方法，并且支持运行时动态添加数据查询方法文件，具备良好的可扩展性。In order to get rid of the limitation of Word on the data access interface, obtain a good interactive experience, and at the same time not increase the burden on template customization and report writers, and ensure the efficiency and scalability of the system, the present invention provides a brand new method, which Encapsulate the data query method as a data placeholder, and then insert the data placeholder into the Word document to customize the report template; use the report template to generate a dynamic page, and the page calls the data query method to read, display, and edit information; finally use this information to replace The data placeholders in the report template generate the final report. Using this method, the report template is customized through Word, and there is no additional technical requirement for template customizers; data information is displayed and edited on the page to ensure a good user experience and strong interactivity; use information to replace data placeholders to generate reports, It supports partial repeated editing of online reports; it can customize arbitrarily complex business processing methods, and supports dynamic addition of data query method files during runtime, which has good scalability.

本发明采用的技术方案如下：The technical scheme that the present invention adopts is as follows:

一种基于动态网页的可扩展的Word报告自动生成方法，包括以下步骤：A scalable Word report automatic generation method based on dynamic web pages, comprising the following steps:

1)扩展数据处理方法1) Extended data processing method

为每一个数据处理方法添加一条唯一的表明方法功能和用途的描述信息，并通过编译器或者解释器生成一个可以被其他应用程序共享的模块或者文件即数据处理方法共享文件；Add a unique descriptive information indicating the function and purpose of each data processing method, and generate a module or file that can be shared by other applications through a compiler or interpreter, that is, a data processing method shared file;

2)创建数据处理方法对应的标签2) Create a label corresponding to the data processing method

利用反射技术从数据处理方法共享文件中解析数据处理方法的描述信息，并分类整理封装为标签，标签由标签头即标签类型和标签体两部分组成，标签头和标签体是一对多的关系；Use reflection technology to analyze the description information of the data processing method from the shared file of the data processing method, and classify and package it into tags. The tag is composed of two parts: the tag header, which is the tag type and the tag body. The tag header and the tag body are in a one-to-many relationship. ;

3)定制报告模板3) Custom report template

利用标签定制一份Word形式的报告模板；Use tags to customize a report template in Word format;

4)用报告模板生成动态网页4) Generate dynamic web pages with report templates

5)生成word报告5) Generate a word report

根据动态网页中收集的数据信息替换Word报告模板中的数据占位符，生成Word报告。Replace the data placeholders in the Word report template according to the data information collected in the dynamic web page to generate a Word report.

所述步骤3)进一步细分为以下子步骤：Said step 3) is further subdivided into the following sub-steps:

3.1)扩展Word菜单并添加选择标签的窗口；3.1) Extend the Word menu and add a window for selecting tabs;

3.2)定义报告的章节；3.2) Define the sections of the report;

3.3)选择标签类型；3.3) Select the label type;

3.4)选择标签体；3.4) Select the tag body;

3.5)把选择的标签组合以书签的方式作为数据占位符放在相应的章节下；3.5) Place the selected label combination under the corresponding chapter as a data placeholder in the form of a bookmark;

3.6)将这份包含数据占位符的Word文档保存为一份Word文件作为报告模板。3.6) Save this Word document containing data placeholders as a Word file as a report template.

所述步骤4)进一步细分为以下子步骤：Said step 4) is further subdivided into the following sub-steps:

4.1)从Word报告模板中以遍历书签的方式查找数据占位符并读取它的值即数据处理方法的描述信息；4.1) Find the data placeholder by traversing bookmarks from the Word report template and read its value, which is the description information of the data processing method;

4.2)通过反射技术和描述信息、数据处理方法的一一对应关系，找到数据处理方法；4.2) Find the data processing method through the one-to-one correspondence between reflection technology, description information, and data processing methods;

4.3)反射数据处理方法的返回值类型并据此确定数据的Aspx展示控件，此Aspx为一种动态网络编程的网络语言；4.3) Reflect the return value type of the data processing method and determine the Aspx display control of the data accordingly. This Aspx is a network language for dynamic network programming;

4.4)把报告模板保存为Html形式；4.4) Save the report template as Html form;

4.5)利用正则表达式删除Html文件中的注释和样式等信息添加Aspx页面需要的信息；4.5) Use regular expressions to delete information such as comments and styles in the Html file and add the information required by the Aspx page;

4.6)通过模板引擎技术用Aspx数据展示控件替换Html中数据占位符，生成动态页面；4.6) Use the Aspx data display control to replace the data placeholder in Html through the template engine technology to generate a dynamic page;

4.7)根据报告模板中的数据占位符，生成动态页面对应的后台处理文件，调用每一个数据占位符对应的数据处理方法读取数据并与动态页面中的数据展示组件绑定；4.7) According to the data placeholders in the report template, generate the background processing file corresponding to the dynamic page, call the data processing method corresponding to each data placeholder to read the data and bind it to the data display component in the dynamic page;

4.8)通过访问Aspx页面完成对报告的编辑。4.8) Finish editing the report by accessing the Aspx page.

在所述步骤5)中，如果传过来的数据是文本、表格和图片，就按数据的格式替换模板中的数据占位符，如果传过来的数据是字节数组，就把数据转换为图片并用图片替换模版中的数据占位符，如果传过来的数据是文件路径，就先读取文件路径指向的文件的内容并以此替换模板中的数据占位符，最终利用数据替换模板中所有的数据占位符并保存为一份Word文件作为Word报告。In said step 5), if the passed data is text, table and picture, replace the data placeholder in the template according to the format of the data, if the passed data is a byte array, convert the data into a picture And replace the data placeholders in the template with images. If the passed data is a file path, first read the content of the file pointed to by the file path and replace the data placeholders in the template with this, and finally replace all the data in the template with the data. data placeholders and save as a Word file as a Word report.

本发明具有以下优点：The present invention has the following advantages:

1.通过Word定制报告模板，对模板定制人员没有额外的技术要求；1. Customize the report template through Word, and there is no additional technical requirement for template customizers;

2.为模板生成动态网页，界面元素丰富，用户交互性好；2. Generate dynamic web pages for templates, with rich interface elements and good user interaction;

3.利用信息替换数据占位符生成报告，支持在线的报告局部反复多次编辑；3. Use information to replace data placeholders to generate reports, and support partial and repeated editing of online reports;

4.支持任意复杂的业务处理方法定制和运行时动态添加数据查询方法文件，具备良好的可扩展性。4. It supports customization of arbitrary complex business processing methods and dynamic addition of data query method files during runtime, with good scalability.

附图说明Description of drawings

图1是本发明的整体流程图；Fig. 1 is the overall flowchart of the present invention;

图2为数据处理方法文件内容的示意图；Fig. 2 is the schematic diagram of data processing method file content;

图3是定制报告模板流程图；Figure 3 is a flowchart of a customized report template;

图4是报告模板示意图；Figure 4 is a schematic diagram of a report template;

图5是生成动态页面流程图；Fig. 5 is a flowchart of generating a dynamic page;

图6是动态网页图；Fig. 6 is a dynamic web page diagram;

图7是生成的Word报告示意图；Figure 7 is a schematic diagram of the generated Word report;

图8是可扩展流程图；Fig. 8 is a scalable flowchart;

图9是本发明实施的系统组成图；Fig. 9 is a system composition diagram implemented by the present invention;

图10是Word报告模板、数据查询方法文件、数据库、Word报告之间的关系图。Fig. 10 is a relationship diagram among the Word report template, the data query method file, the database, and the Word report.

具体实施方式Detailed ways

本发明提供了一种基于动态网页的可扩展的Word报告自动生成方法。如图1所示，该方法包括以下步骤：The invention provides an expandable Word report automatic generation method based on dynamic web pages. As shown in Figure 1, the method includes the following steps:

1.数据处理方法扩展1. Data processing method extension

利用特性(Attribute)为每一个数据处理方法添加一条唯一的、表明方法功能和用途的描述信息，然后通过编译器或者解释器将此添加了描述信息的数据处理方法生成一个可以被其他应用程序共享的模块或者文件，即数据处理方法共享文件。例如：一个功能为查询商品本年度的出库、入库记录的方法对应的描述信息为仓库管理-查询商品本年度的出入库信息(图2)。这样数据处理方法和描述信息就形成了一对一的对应关系。Use Attribute to add a unique descriptive information to each data processing method, indicating the function and purpose of the method, and then use the compiler or interpreter to generate a data processing method with descriptive information that can be shared by other applications. Modules or files, that is, data processing methods share files. For example: a function of querying the storage and storage records of commodities in this year corresponds to the description information as warehouse management - querying the storage and storage information of commodities in this year (Figure 2). In this way, the data processing method and the description information form a one-to-one correspondence.

通过为数据处理方法扩展一一对应的描述信息，在描述信息、数据处理方法、数据库和数据间建立了从描述信息到数据处理方法、从数据处理方法到数据库、从数据库到数据的关系链，因此可以通过选择描述信息的方式来选择数据。By expanding the one-to-one corresponding description information for data processing methods, a relationship chain from description information to data processing methods, from data processing methods to databases, and from databases to data is established between description information, data processing methods, databases, and data. Therefore, data can be selected by selecting description information.

2.创建数据处理方法对应的标签2. Create a label corresponding to the data processing method

反射(Reflection)是.NET中的重要机制，通过反射可以在运行时获得.NET中每一个类型(包括类、结构、委托、接口和枚举等)的成员，包括方法、属性、事件，以及构造函数等；还可以获得每个成员的名称、限定符和参数等。利用反射技术从数据处理方法共享文件中解析出数据处理方法的描述信息，并分类整理封装为标签，此标签由标签头即标签类型和标签体两部分组成，标签头和标签体是一对多的关系。例如，在对仓库管理-查询商品本年度的出入库信息进行封装的标签中，标签类型为仓库管理，标签体为查询商品本年度的出入库信息。Reflection is an important mechanism in .NET. Through reflection, members of each type (including classes, structures, delegates, interfaces, and enumerations) in .NET can be obtained at runtime, including methods, properties, events, and Constructors, etc.; you can also get the name, qualifiers, parameters, etc. of each member. Use reflection technology to analyze the description information of the data processing method from the shared file of the data processing method, and classify and package it into tags. This tag consists of two parts: the tag header, which is the tag type and the tag body. The tag header and the tag body are one-to-many Relationship. For example, in the tag that encapsulates warehouse management-query the entry and exit information of the commodity this year, the tag type is warehouse management, and the tag body is the entry and exit information of the query commodity this year.

3.定制报告模板3. Custom report template

利用标签定制一份Word文档形式的报告模板，该报告模板为由报告的章节标题和数据占位符组成的报告框架。定制报告模板的流程如图3所示：Use tags to customize a report template in the form of a Word document, which is a report frame composed of report chapter titles and data placeholders. The process of customizing the report template is shown in Figure 3:

利用Vsto(Visual Studio Tools for Office)技术扩展Word菜单，即在Word启动时自动在Word菜单栏添加一个名为“报告模板定制”的菜单，和一个名为“选择数据”的子菜单；Use Vsto (Visual Studio Tools for Office) technology to expand the Word menu, that is, automatically add a menu named "Report Template Customization" and a submenu named "Select Data" to the Word menu bar when Word starts;

输入报告的章节标题并设置章节标题的样式和编号，例如：6本年度商品出入库情况；Enter the chapter title of the report and set the style and number of the chapter title, for example: 6 The goods in and out of the warehouse this year;

在点击“选择数据”后，添加选择标签的窗口；After clicking "Select Data", add a window for selecting labels;

选择标签类型，例如选择标签类型为仓库管理；Select the label type, for example, select the label type as Warehouse Management;

选择标签体，例如选择标签体为查询商品本年度的出入库信息；Select the label body, for example, select the label body to query the entry and exit information of the product this year;

把选择的标签组合以书签的方式作为数据占位符放在相应的章节下，为了区别于普通文本，可以为数据占位符设置一些特殊的样式。数据占位符是位于报告模板中但最终会被数据库中的一组数据集替换的文本，它标记了数据在文档中的位置；Put the selected label combination as a data placeholder under the corresponding chapter in the form of a bookmark. In order to distinguish it from ordinary text, you can set some special styles for the data placeholder. A data placeholder is text that is placed in the report template but will eventually be replaced by a set of data sets in the database, which marks the location of the data in the document;

将这份包含数据占位符的Word文档保存为一份Word文件作为报告模板。Save this Word document with data placeholders as a Word file as a report template.

例如：仓库管理类别下的查询商品本年度的出入库信息作为数据占位符放在章节商品本年度出入库情况中(图4)。For example: the entry and exit information of the queried goods under the warehouse management category this year is placed as a data placeholder in the chapter entry and exit of goods this year (Figure 4).

可见，在报告模板、数据占位符、描述信息间已经建立了一条从报告模板到数据占位符、从数据占位符到描述信息的关系链，以描述信息作为桥梁就可以与另一条关系链(从描述信息到数据处理方法、从数据处理方法到数据库、从数据库到数据)连接，这就构成了从报告模板到数据占位符、从数据占位符到描述信息、从描述信息到数据处理方法、从数据处理方法到数据库、从数据库到数据的完整的关系链，建立了模板与数据的关联关系。It can be seen that a relationship chain from the report template to the data placeholder and from the data placeholder to the description information has been established between the report template, the data placeholder, and the description information, and the description information can be used as a bridge to connect with another relationship chain. Chain (from description information to data processing method, from data processing method to database, from database to data) connection, which constitutes from report template to data placeholder, from data placeholder to description information, from description information to The data processing method, the complete relationship chain from the data processing method to the database, and from the database to the data establishes the association relationship between the template and the data.

4.用模板生成动态网页4. Generate dynamic web pages with templates

生成动态网页的流程如图5所示，利用Vsto技术从Word报告模板中以遍历书签的方式查找数据占位符并读取它的值即数据处理方法的描述信息；The process of generating a dynamic web page is shown in Figure 5. Use Vsto technology to search for data placeholders from the Word report template by traversing bookmarks and read its value, which is the description information of the data processing method;

通过反射技术和描述信息、数据处理方法的一一对应关系，找到数据处理方法；Find the data processing method through the one-to-one correspondence between reflection technology and description information and data processing methods;

反射数据处理方法的返回值类型并据此确定数据的Aspx(一种网络编程语言)展示控件，例如：方法的返回值为文本则对应Aspx的多行文本框，方法的返回值为表格和对象集合则对应Aspx的表格类控件，方法的返回值是图片或者字节数组则对应Aspx的图片框等等；Reflect the return value type of the data processing method and determine the Aspx (a network programming language) display control of the data accordingly, for example: the return value of the method is text, which corresponds to the multi-line text box of Aspx, and the return value of the method is a table and object The collection corresponds to the form control of Aspx, and the return value of the method is a picture or byte array, which corresponds to the picture box of Aspx, etc.;

利用Vsto把报告模板保存为Html(HyperText Markup Language或超文本置标语言)形式；Use Vsto to save the report template as Html (HyperText Markup Language or hypertext markup language);

利用正则表达式删除Html文件中的注释和样式等信息，添加Aspx页面需要的头信息、Js(Javascript，一种计算机脚本语言)和Css(Cascading Style Sheet或级联样式表)等信息；Use regular expressions to delete information such as comments and styles in the Html file, and add information such as the header information required by the Aspx page, Js (Javascript, a computer scripting language) and Css (Cascading Style Sheet or cascading style sheet);

通过模板引擎技术用Aspx数据展示控件(TextBox、GridView和PictureBox等)替换Html中数据占位符，生成动态页面；Use template engine technology to replace data placeholders in Html with Aspx data display controls (TextBox, GridView and PictureBox, etc.) to generate dynamic pages;

利用模板引擎语言编写一份准后台处理文件，然后由模板引擎把其中的模板引擎变量标识符替换成报告模板中的数据占位符对应的数据处理方法，生成与动态页面对应的后台处理文件，调用每一个数据处理方法从数据库中读取数据并与动态页面中的数据展示控件绑定；Use the template engine language to write a quasi-background processing file, and then the template engine replaces the template engine variable identifier in it with the data processing method corresponding to the data placeholder in the report template to generate a background processing file corresponding to the dynamic page. Call each data processing method to read data from the database and bind it to the data display control in the dynamic page;

通过访问Aspx页面完成对报告的编辑，其结构与最终的Word报告一致，但是可以进行局部反复的查询和修改，并且支持中途保存即保存已做的编辑但不生成报告。例如：商品本年度出入库情况章节在页面的效果如图6所示。Editing of the report is completed by visiting the Aspx page. Its structure is consistent with the final Word report, but it can be partially and repeatedly queried and modified, and it supports midway saving, that is, saving the edits made but not generating a report. For example: Figure 6 shows the effect of the section on the entry and exit of goods this year on the page.

5.生成word报告5. Generate a word report

根据页面传过来的数据信息替换Word报告模板中的数据占位符，生成Word报告。如果传过来的数据是文本、表格和图片，就按数据的格式替换Word报告模板中的数据占位符；如果传过来的数据是字节数组，就把数据转换为图片并用图片替换模版中的数据占位符；如果传过来的数据是文件路径，就先读取文件路径指向的文件的内容并以此替换Word报告模板中的数据占位符。最终利用数据替换Word报告模板中所有的数据占位符并保存成一份Word文件作为Word报告。例如：由仓库管理-查询商品本年度的出入库信息获取的数据是一段文本和一张图片，替换后的结果如图7所示。Replace the data placeholders in the Word report template according to the data information passed on the page to generate a Word report. If the passed data is text, tables and pictures, replace the data placeholders in the Word report template according to the format of the data; if the passed data is a byte array, convert the data into pictures and replace the placeholders in the template with pictures Data placeholder; if the passed data is a file path, first read the content of the file pointed to by the file path and replace the data placeholder in the Word report template. Finally, replace all the data placeholders in the Word report template with data and save it as a Word file as a Word report. For example: the data obtained by warehouse management-querying the information of goods in and out of the warehouse this year is a piece of text and a picture, and the result after replacement is shown in Figure 7.

此外，以数据查询方法为基础也使得本发明拥有良好的可扩展性，本发明支持以两种方式在运行时动态地添加数据查询方法。第一种方式：将编译好的包含数据查询方法的Dll(Dynamic Link Library，是一个包含可由多个程序共享的代码和数据的库)文件放入指定目录下，负责数据查询方法解析的服务监测到这一事件后，遍历目录下新增加的数据查询方法文件并逐一加载，提取可用的数据查询方法及其描述信息，并提交给上层的模板定制和报告页面等使用。第二种方式如图8所示：在自定义数据查询方法页面，输入数据查询接口的参数、返回值、用途及其他信息，自动生成代码服务，据此生成一份数据访问方法源文件，并提交给自动编译服务，自动编译服务完成编译并将编译后的Dll文件转移到指定目录下，由第一种方式进一步处理。In addition, being based on the data query method also enables the present invention to have good scalability, and the present invention supports dynamically adding data query methods at runtime in two ways. The first method: Put the compiled Dll (Dynamic Link Library, a library containing code and data that can be shared by multiple programs) file containing the data query method into the specified directory, responsible for the service monitoring of the data query method analysis After this event, traverse the newly added data query method files in the directory and load them one by one, extract the available data query methods and their description information, and submit them to the upper-level template customization and report pages for use. The second method is shown in Figure 8: On the custom data query method page, enter the parameters, return value, purpose and other information of the data query interface, automatically generate code services, and generate a data access method source file accordingly, and Submit to the automatic compilation service, the automatic compilation service completes the compilation and transfers the compiled Dll file to the specified directory, and is further processed by the first method.

本发明方法已经在某实时支持系统中得到完全实施。如图9所示，该系统采用B/S架构，使用IIS作为应用服务器，国产通用数据库作为数据库服务器，开发了一系列的aspx页面和COM组件部署在IIS服务器上。我们成功实现了日、周、月、季、年等报告模板的定制，并利用这些模板完成了分析报告的自动生成。从图中可以看出数据存储在数据库服务器中；Word报告模板由客户端创建并最终存储在应用服务器上；包含数据查询方法及其描述信息的文件存储在应用服务器上；而出于安全性的考虑，由报告模板生成的Word报告最终也保存在数据库服务器上。The inventive method has been fully implemented in a real-time support system. As shown in Figure 9, the system adopts B/S architecture, uses IIS as the application server, and a domestic general database as the database server. A series of aspx pages and COM components are developed and deployed on the IIS server. We have successfully realized the customization of report templates such as daily, weekly, monthly, quarterly, and annual, and completed the automatic generation of analysis reports by using these templates. It can be seen from the figure that the data is stored in the database server; the Word report template is created by the client and finally stored on the application server; the file containing the data query method and its description information is stored on the application server; and for security Consider that the Word report generated by the report template is also finally saved on the database server.

图10反映了Word报告模板、数据查询方法文件、数据库、Word报告之间的关系。首先，定制模板时，利用数据查询方法文件中的数据查询方法描述信息作为Word报告模板中的数据占位符，为Word报告模板与数据库的数据之间建立了联系，而数据查询方法就是桥梁。其次，生成报告时，把Word报告模板转为Html文件，把Html文件中的数据占位符替换为Aspx数据展示控件生成Aspx页面，在Aspx后台处理文件中调用数据查询方法获取的数据并与Aspx页面控件绑定，最后利用Aspx后台传回的数据替换Word报告模板中的数据占位符，从而生成Word报告并存入数据库。Figure 10 reflects the relationship among the Word report template, data query method file, database, and Word report. First, when customizing the template, use the data query method description information in the data query method file as the data placeholder in the Word report template to establish a connection between the Word report template and the data in the database, and the data query method is a bridge. Secondly, when generating a report, convert the Word report template into an Html file, replace the data placeholders in the Html file with the Aspx data display control to generate an Aspx page, and call the data obtained by the data query method in the Aspx background processing file and compare it with the Aspx The page control is bound, and finally the data placeholder in the Word report template is replaced with the data returned by the Aspx background, thereby generating a Word report and storing it in the database.

通过本发明方法的应用，该系统成功实现了分析报告(日、周、月、季、年)的自动生成，大大减轻了报告编写人员的日常工作负担。与此同时，模板定制和报告生成对于人员没有额外的技术要求，便于系统的实施和推广；数据的查询、编辑在页面中完成并支持报告中途保存及数据继承(一份报告从另外一份报告中提取信息)等功能交互性体验良好，并且系统以业务查询方法的描述信息为基础，具备了良好的扩展性。Through the application of the method of the invention, the system successfully realizes the automatic generation of analysis reports (day, week, month, quarter, year), which greatly reduces the daily work burden of report writers. At the same time, template customization and report generation have no additional technical requirements for personnel, which is convenient for system implementation and promotion; data query and editing are completed on the page and support half-way saving of reports and data inheritance (one report from another The interactive experience of functions such as extracting information from ) is good, and the system is based on the description information of the business query method, and has good scalability.

Claims (4)

1. the extendible Word based on dynamic web page reports automatic generation method, it is characterized in that may further comprise the steps:

1) growth data disposal route

Be that each data processing method adds a unique descriptor that shows methodological function and purposes, and to generate a module or the file that can be shared by other application programs by compiler or interpreter be the data processing method shared file;

2) label of establishment data processing method correspondence

Utilize the descriptor of reflection technology resolution data disposal route from the data processing method shared file, and taxonomic revision is encapsulated as label, label is that tag types and label body two parts are formed by tag head, and tag head and label body are the relations of one-to-many;

3) customization report template

Utilize label to customize the report template of a Word form;

4) generate dynamic web page with report template

5) generate the word report

Data placeholder according in the data message replacement Word report template of collecting in the dynamic web page generates the Word report.

2. the extendible Word based on dynamic web page as claimed in claim 1 reports automatic generation method, it is characterized in that:

Described step 3) further is subdivided into following substep:

3.1) expand the Word menu and add the window of selecting label;

3.2) chapters and sections of definition report;

3.3) the selection tag types;

3.4) the selection label body;

3.5) mode of the tag combination of selecting with bookmark is placed under the corresponding chapters and sections as the data placeholder;

3.6) Word document that this part comprised the data placeholder saves as a Word file as report template.

3. the extendible Word based on dynamic web page as claimed in claim 1 reports automatic generation method, it is characterized in that:

Described step 4) further is subdivided into following substep:

4.1) value of searching the data placeholder and reading it in the mode of traversal bookmark from the Word report template is the descriptor of data processing method;

4.2) by the one-to-one relationship of reflection technology and descriptor, data processing method, find data processing method;

4.3) the rreturn value type of reflectance data disposal route and the Aspx displaying control of specified data in view of the above, this Aspx is a kind of netspeak of dynamic network programming;

4.4) report template is saved as the Html form;

4.5) utilize information such as note in the regular expression deletion Html file and pattern to add the information that the Aspx page needs

4.6) replace data placeholder among the Html by the template engine technology with Aspx data display control, generate dynamic page;

4.7) according to the data placeholder in the report template, generate the background process file of dynamic page correspondence, call each data placeholder correspondence the data processing method reading of data and with dynamic page in the data display component binding;

4.8) finish editor by the visit Aspx page to report.

4. the extendible Word based on dynamic web page as claimed in claim 1 reports automatic generation method, it is characterized in that:

In described step 5), if passing the data of coming is text, form and picture, just by the data placeholder in the form replacement template of data, if passing the data of coming is byte arrays, just data are converted to picture and replace data placeholder in the masterplate with picture, if passing the data of coming is file path, just read the content of the file that file path points to earlier and replace data placeholder in the template, finally utilize data to replace data placeholders all in the template and save as a Word file and report as Word with this.

Images