WO2018161402A1 - Method and system for processing modular packaged reports - Google Patents

Method and system for processing modular packaged reports Download PDF

Info

Publication number
WO2018161402A1
WO2018161402A1 PCT/CN2017/080125 CN2017080125W WO2018161402A1 WO 2018161402 A1 WO2018161402 A1 WO 2018161402A1 CN 2017080125 W CN2017080125 W CN 2017080125W WO 2018161402 A1 WO2018161402 A1 WO 2018161402A1
Authority
WO
WIPO (PCT)
Prior art keywords
report
information
database
data
format
Prior art date
Application number
PCT/CN2017/080125
Other languages
French (fr)
Chinese (zh)
Inventor
黄驰
熊娅娟
袁也
刘新奇
曾昭志
Original Assignee
深圳市科脉技术股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 深圳市科脉技术股份有限公司 filed Critical 深圳市科脉技术股份有限公司
Publication of WO2018161402A1 publication Critical patent/WO2018161402A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results

Definitions

  • the present invention relates to the field of report technology, and in particular, to a method and system for processing a modular package report.
  • Each report has a section of the query for filling in the query criteria and a table section for loading the data. Between different reports, the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template. In the system, a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade.
  • the object of the present invention is to provide a processing method and system for a modular package report. For a developer, it is no longer necessary to design a separate report file, and only one display page is needed to display the report, so that it is convenient to add a new report. Make it easy to introduce different systems into the reporting system, and at the same time facilitate the development and upgrade of the reporting system.
  • an embodiment of the present invention provides a method for processing a modular package report, where the method includes the following steps:
  • the database has a corresponding report identifier ID (Identity, identifier);
  • the embodiment of the present invention provides a first possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • first operation instruction information of the user where the first operation instruction information includes switching information
  • the embodiment of the present invention provides a second possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • the embodiment of the present invention provides a third possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • Modifying format information of the report according to the modification information and saving the modified format information in the database.
  • the embodiment of the present invention provides the fourth possible implementation manner of the first aspect, wherein the format information includes query information and form information,
  • the query information includes a query entry and a query format, the form information including a form entry and Form format.
  • the embodiment of the present invention further provides a processing system for a modular package report, including:
  • the saving unit is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the first searching unit is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • the processing unit is configured to query the report data according to the data storage information, and process the report data to obtain a data processing result;
  • a loading unit configured to load format information of the report and the data processing result into a display page.
  • the embodiment of the present invention provides the first possible implementation manner of the second aspect, further including:
  • a first acquiring unit configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information
  • the identification unit is configured to identify the report ID according to the switching information
  • a second searching unit configured to look up the report from the database according to the report ID.
  • the embodiment of the present invention provides a second possible implementation manner of the second aspect, further including:
  • a second acquiring unit configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information
  • Adding a unit configured to add a new report based on the added information and save in the database.
  • the embodiment of the present invention provides a third possible implementation manner of the second aspect, Among them, it also includes:
  • a third acquiring unit configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information
  • a modifying unit configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
  • the embodiment of the present invention provides the fourth possible implementation manner of the second aspect, wherein the format information includes query information and form information,
  • the query information includes a query entry and a query format, the form information including a form entry and a table format.
  • the invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database;
  • the report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report. Go to the display page.
  • FIG. 1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention
  • FIG. 2 is another flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention
  • FIG. 3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention.
  • FIG. 4 is another schematic structural diagram of a processing system for a modular package report according to Embodiment 2 of the present invention.
  • 10-save unit 20-first search unit; 30-processing unit; 40-load unit; 50-first acquisition unit; 60-identification unit; 70-second search unit.
  • Each report has a section of the query for filling in the query criteria and a table section for loading the data.
  • the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template.
  • a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade.
  • the present invention provides a processing party for modular package reports. Law and system, for developers, no longer need to design a separate report file, only need a display page to display the report, easy to add new reports, can make different systems easy to introduce the report system, at the same time, facilitate the development of the report system And upgrades.
  • the modular package report of the embodiment of the invention is modularly packaged for the basic class library of the report, and all the data operation information related to the report is encapsulated in the module, and the data operation information includes reading data, processing data, displaying data, and the like. It is easy to introduce new reporting systems for different systems.
  • Embodiment 1 is a diagrammatic representation of Embodiment 1:
  • FIG. 1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention.
  • the processing method of the modular package report includes:
  • Step S101 Obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the report includes a query part and a form part
  • the format information of the report includes query information and form information
  • the query information includes a query item and a query format
  • the form information includes a form entry and a table format.
  • the query part of the report can be set by the user, and any one of the query results can be used as a query condition to satisfy the user's differentiation of the analysis dimension of the report.
  • the data storage information is a storage process of the report data, and the report data can be queried according to the data storage information.
  • the format information and the data storage information of the report are stored in the database according to a predetermined rule, and are in one-to-one correspondence with the report ID.
  • Step S102 Searching, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • Step S103 querying report data according to the data storage information, and processing the report data to obtain a data processing result
  • the queried report data is loaded into the server where the package file is located for data processing, and the report data is automatically processed according to the encapsulated data operation function, and the processed data result is obtained.
  • step S104 the format information and the data processing result of the report are loaded into the display page.
  • the display page may be a main page, such as AutoQuery.aspx, or other pages, such as an application interface.
  • all reports can be displayed through the same body page (such as AutoQuery.aspx), which inherits from data processing classes, such as the AutoQueryPage class, and the AutoQueryPage class is encapsulated in a separate pure class library project that can be compiled.
  • a separate dynamic link library file that is, the package file, all query information, table information and data storage process of the report are stored in the database, and the library mainly processes the assembly work of the information. If the report system is referenced in a new project, simply reference the dynamic link library file, and then add the main page AutoQuery.aspx or other display page, and the database fills the report related data according to the agreed specifications.
  • the method further includes:
  • Step S201 acquiring first operation instruction information of the user, where the first operation instruction information includes switching information;
  • Step S202 identifying the report ID according to the switching information
  • Step S203 searching for a report corresponding to the report ID from the database according to the report ID.
  • each report corresponds to a report ID.
  • the system first identifies the ID of the report that the user needs to switch to, and then finds the corresponding report from the database according to the ID of the report.
  • the query information and form information are loaded into the display interface.
  • the method further includes:
  • the new report is the associated report of the original report.
  • the data in the new report comes from the original report, but the statistics items and query conditions in the table are re-set to get different.
  • the report, the name of the new report, and access rights can be set by the user.
  • the method further includes:
  • Modifying format information of the report according to the modification information and saving the modified format information in the database.
  • the query information and the form information of the report may be modified.
  • the name of the item in the form information, the column width, the order in which the items are displayed, and the like may be modified, and the query condition in the query information may be modified according to the query result.
  • Any one of the query results can be used as a query condition, and the query format can also be modified.
  • the query date is XXX ⁇ XXX, or the start date is XXX, and the end date is XXX.
  • the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
  • Embodiment 2 is a diagrammatic representation of Embodiment 1:
  • FIG. 3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention.
  • the processing system of the modular package report includes:
  • the saving unit 10 is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the first searching unit 20 is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • the processing unit 30 is configured to query the report data according to the data storage information, and process the report data according to the package information to obtain a data processing result;
  • the loading unit 40 is configured to load the format information of the report and the data processing result into the display page.
  • the system further includes:
  • the first obtaining unit 50 is configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information;
  • the identifying unit 60 is configured to identify the report ID according to the switching information
  • the second searching unit 70 is configured to search the database from the database according to the report ID.
  • the method further includes:
  • a second obtaining unit (not shown), configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information;
  • An adding unit (not shown) is provided for adding a new report based on the added information and saving in the database.
  • the method further includes:
  • a third acquiring unit (not shown), configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information;
  • a modifying unit (not shown), configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
  • the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
  • the processing system of the modular package report provided by the embodiment of the present invention has the same technical features as the processing method of the modular package report provided by the foregoing embodiment, so that the same technical problem can be solved and the same technical effect can be achieved.
  • the invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database;
  • the report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report.
  • the computer program product provided by the embodiment of the present invention includes a computer readable storage medium storing the program code, and the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the specific implementation refer to the method embodiment. , will not repeat them here.
  • the terms “installation”, “connected”, and “connected” are to be understood broadly, and may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined. , or connected integrally; may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • installation may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined.
  • connected integrally may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • the specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.
  • the functions may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a standalone product.
  • the technical solution of the present invention which is essential or contributes to the prior art, or a part of the technical solution, may be embodied in the form of a software product, which is stored in a storage medium, including
  • the instructions are used to cause a computer device (which may be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention.
  • the foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like. .

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A method and system for the packaging and data storage of reports, relating to the technical field of reporting, wherein said method comprises: acquiring format information and data storage information for a report, saving said information in a database, wherein the report has a corresponding identifier ID within the database (S101); searching for report format information and data storage information corresponding to the report ID in the database according to the report ID corresponding to the report (S102); querying report data according to the data storage information, and performing processing on the report data to obtain a data processing result (S103); and loading the report format information and data processing result onto a display page (S104). The present method may facilitate the adding of new reports, and is beneficial to introducing a reporting system to different systems, while also facilitating the development and upgrading of reporting systems.

Description

模块化封装报表的处理方法和***Modular package report processing method and system
本申请要求于2017年03月10日提交中国专利局的申请号为CN201710144782.X、名称为“模块化封装报表的处理方法和***”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。This application claims priority to Chinese Patent Application No. CN201710144782.X, entitled "Processing Method and System for Modular Packaged Reports", filed on March 10, 2017, the entire contents of which are incorporated by reference. In this application.
技术领域Technical field
本发明涉及报表技术领域，尤其是涉及模块化封装报表的处理方法和***。The present invention relates to the field of report technology, and in particular, to a method and system for processing a modular package report.
背景技术Background technique
每个报表都有用于填写查询条件的查询部分，以及用于加载数据的表格部分。不同报表之间，查询部分的条目与格式不一样，表格部分的条目与格式(比如单元格的宽度)也不一样。所以，每个报表都需要预先设计一个单独的模板，在***中，即需要生成一个单独的模板文件，不利于不同的***引进新报表体系，开发和升级也比较困难。Each report has a section of the query for filling in the query criteria and a table section for loading the data. Between different reports, the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template. In the system, a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade.
发明内容Summary of the invention
有鉴于此，本发明的目的在于提供模块化封装报表的处理方法和***，对于开发者来说，不再需要设计单独的报表文件，只需要一个显示页面来显示报表，便于添加新报表，可以使不同的***方便引进报表***，同时，便于报表***的开发和升级。In view of this, the object of the present invention is to provide a processing method and system for a modular package report. For a developer, it is no longer necessary to design a separate report file, and only one display page is needed to display the report, so that it is convenient to add a new report. Make it easy to introduce different systems into the reporting system, and at the same time facilitate the development and upgrade of the reporting system.
第一方面，本发明实施例提供了模块化封装报表的处理方法，所述方法包括如下步骤：In a first aspect, an embodiment of the present invention provides a method for processing a modular package report, where the method includes the following steps:
获取报表的格式信息和数据存储信息，并保存在数据库中，所述报表在所 述数据库中具有对应的报表标识符ID(Identity，标识符)；Obtaining format information and data storage information of the report, and saving the data in the database The database has a corresponding report identifier ID (Identity, identifier);
根据所述报表对应的报表ID从所述数据库中查找与所述报表ID对应的所述报表的格式信息和所述数据存储信息；Finding format information and the data storage information of the report corresponding to the report ID from the database according to the report ID corresponding to the report;
根据所述数据存储信息查询报表数据，并对所述报表数据进行处理，得到数据处理结果；Querying report data according to the data storage information, and processing the report data to obtain a data processing result;
将所述报表的格式信息和所述数据处理结果加载到显示页面中。Loading the format information of the report and the data processing result into a display page.
结合第一方面，本发明实施例提供了第一方面的第一种可能的实施方式，其中，所述方法还包括如下步骤：With reference to the first aspect, the embodiment of the present invention provides a first possible implementation manner of the first aspect, wherein the method further includes the following steps:
获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；Obtaining first operation instruction information of the user, where the first operation instruction information includes switching information;
根据所述切换信息识别所述报表ID；Identifying the report ID according to the switching information;
根据所述报表ID从所述数据库中查找与所述报表ID对应的报表。Finding a report corresponding to the report ID from the database according to the report ID.
结合第一方面，本发明实施例提供了第一方面的第二种可能的实施方式，其中，所述方法还包括如下步骤：With reference to the first aspect, the embodiment of the present invention provides a second possible implementation manner of the first aspect, wherein the method further includes the following steps:
获取用户的第二操作指令信息，所述第二操作指令信息包括添加信息；Obtaining second operation instruction information of the user, where the second operation instruction information includes adding information;
根据所述添加信息添加新的报表，并保存在所述数据库中。Add a new report based on the added information and save it in the database.
结合第一方面，本发明实施例提供了第一方面的第三种可能的实施方式，其中，所述方法还包括如下步骤：With reference to the first aspect, the embodiment of the present invention provides a third possible implementation manner of the first aspect, wherein the method further includes the following steps:
获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息；Obtaining third operation instruction information of the user, where the third operation instruction information includes modification information;
根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。Modifying format information of the report according to the modification information, and saving the modified format information in the database.
结合第一方面至第一方面的第三种可能的实施方式，本发明实施例提供了第一方面的第四种可能的实施方式，其中，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和 表格格式。With reference to the third aspect, the third possible implementation manner of the first aspect, the embodiment of the present invention provides the fourth possible implementation manner of the first aspect, wherein the format information includes query information and form information, The query information includes a query entry and a query format, the form information including a form entry and Form format.
第二方面，本发明实施例还提供模块化封装报表的处理***，包括：In a second aspect, the embodiment of the present invention further provides a processing system for a modular package report, including:
保存单元，配置成获取报表的格式信息和数据存储信息，并保存在数据库中，所述报表在所述数据库中具有对应的报表标识符ID；The saving unit is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
第一查找单元，配置成根据所述报表对应的报表ID从所述数据库中查找与所述报表ID对应的所述报表的格式信息和所述数据存储信息；The first searching unit is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
处理单元，配置成根据所述数据存储信息查询报表数据，并对所述报表数据进行处理，得到数据处理结果；The processing unit is configured to query the report data according to the data storage information, and process the report data to obtain a data processing result;
加载单元，配置成将所述报表的格式信息和所述数据处理结果加载到显示页面中。a loading unit configured to load format information of the report and the data processing result into a display page.
结合第二方面，本发明实施例提供了第二方面的第一种可能的实施方式，其中，还包括：With reference to the second aspect, the embodiment of the present invention provides the first possible implementation manner of the second aspect, further including:
第一获取单元，配置成获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；a first acquiring unit, configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information;
识别单元，配置成根据所述切换信息识别所述报表ID；The identification unit is configured to identify the report ID according to the switching information;
第二查找单元，配置成根据所述报表ID从所述数据库中查找所述报表。a second searching unit configured to look up the report from the database according to the report ID.
结合第二方面，本发明实施例提供了第二方面的第二种可能的实施方式，其中，还包括：With reference to the second aspect, the embodiment of the present invention provides a second possible implementation manner of the second aspect, further including:
第二获取单元，配置成获取用户的第二操作指令信息，所述第二操作指令信息包括添加信息；a second acquiring unit, configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information;
添加单元，配置成根据所述添加信息添加新的报表，并保存在所述数据库中。Adding a unit configured to add a new report based on the added information and save in the database.
结合第二方面，本发明实施例提供了第二方面的第三种可能的实施方式， 其中，还包括：With reference to the second aspect, the embodiment of the present invention provides a third possible implementation manner of the second aspect, Among them, it also includes:
第三获取单元，配置成获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息；a third acquiring unit, configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information;
修改单元，配置成根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。And a modifying unit configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
结合第二方面至第二方面的第三种可能的实施方式，本发明实施例提供了第二方面的第四种可能的实施方式，其中，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和表格格式。With reference to the third aspect to the third possible implementation of the second aspect, the embodiment of the present invention provides the fourth possible implementation manner of the second aspect, wherein the format information includes query information and form information, The query information includes a query entry and a query format, the form information including a form entry and a table format.
本发明提供了模块化封装报表的处理方法和***，该方法包括：获取报表的格式信息和数据存储信息，并保存在数据库中，报表在数据库中具有对应的报表标识符ID；根据报表对应的报表ID从数据库中查找与报表ID对应的报表的格式信息和数据存储信息；根据数据存储信息查询报表数据，并对报表数据进行处理，得到数据处理结果；将报表的格式信息和数据处理结果加载到显示页面中。通过采用模块化封装报表，不再需要设计单独的报表文件，只需要一个显示页面来显示报表，便于添加新报表，可以使不同的***方便引进报表***，同时，便于报表***的开发和升级。The invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database; The report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report. Go to the display page. By adopting modular packaged reports, it is no longer necessary to design a separate report file. Only one display page is needed to display the report, which is convenient for adding new reports. It is convenient for different systems to introduce the report system, and at the same time, it is convenient for the development and upgrade of the report system.
本发明的其他特征和优点将在随后的说明书中阐述，并且，部分地从说明书中变得显而易见，或者通过实施本发明而了解。本发明的目的和其他优点在说明书、权利要求书以及附图中所特别指出的结构来实现和获得。Other features and advantages of the invention will be set forth in the description which follows, and The objectives and other advantages of the invention are realized and attained by the invention particularly pointed in
为使本发明的上述目的、特征和优点能更明显易懂，下文特举较佳实施例，并配合所附附图，作详细说明如下。 The above described objects, features and advantages of the present invention will become more apparent from the aspects of the appended claims.
附图说明DRAWINGS
为了更清楚地说明本发明具体实施方式或现有技术中的技术方案，下面将对具体实施方式或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图是本发明的一些实施方式，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings to be used in the specific embodiments or the description of the prior art will be briefly described below, and obviously, the attached in the following description The drawings are some embodiments of the present invention, and those skilled in the art can obtain other drawings based on these drawings without any creative work.
图1为本发明实施例一提供的模块化封装报表的处理方法流程图；1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention;
图2为本发明实施例一提供的模块化封装报表的处理方法的另一流程图；2 is another flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention;
图3为本发明实施例二提供的模块化封装报表的处理***结构示意图；3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention;
图4为本发明实施例二提供的模块化封装报表的处理***的另一结构示意图。FIG. 4 is another schematic structural diagram of a processing system for a modular package report according to Embodiment 2 of the present invention.
图标：icon:
10-保存单元；20-第一查找单元；30-处理单元；40-加载单元；50-第一获取单元；60-识别单元；70-第二查找单元。10-save unit; 20-first search unit; 30-processing unit; 40-load unit; 50-first acquisition unit; 60-identification unit; 70-second search unit.
具体实施方式detailed description
为使本发明实施例的目的、技术方案和优点更加清楚，下面将结合附图对本发明的技术方案进行清楚、完整地描述，显然，所描述的实施例是本发明一部分实施例，而不是全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例，都属于本发明保护的范围。The embodiments of the present invention will be clearly and completely described in detail with reference to the accompanying drawings. An embodiment. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts are within the scope of the present invention.
每个报表都有用于填写查询条件的查询部分，以及用于加载数据的表格部分。不同报表之间，查询部分的条目与格式不一样，表格部分的条目与格式(比如单元格的宽度)也不一样。所以，每个报表都需要预先设计一个单独的模板，在***中，即需要生成一个单独的模板文件，不利于不同的***引进新报表体系，开发和升级也比较困难。基于此，本发明提供了模块化封装报表的处理方 法和***，对于开发者来说，不再需要设计单独的报表文件，只需要一个显示页面来显示报表，便于添加新报表，可以使不同的***方便引进报表***，同时，便于报表***的开发和升级。Each report has a section of the query for filling in the query criteria and a table section for loading the data. Between different reports, the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template. In the system, a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade. Based on this, the present invention provides a processing party for modular package reports. Law and system, for developers, no longer need to design a separate report file, only need a display page to display the report, easy to add new reports, can make different systems easy to introduce the report system, at the same time, facilitate the development of the report system And upgrades.
本发明实施例的模块化封装报表对于报表的基础类库，进行了模块化封装，所有报表相关的数据操作信息都封装在模块内部，数据操作信息包括读取数据、处理数据、显示数据等等，易于不同的***引进新报表体系。The modular package report of the embodiment of the invention is modularly packaged for the basic class library of the report, and all the data operation information related to the report is encapsulated in the module, and the data operation information includes reading data, processing data, displaying data, and the like. It is easy to introduce new reporting systems for different systems.
为便于对本实施例进行理解，首先对本发明实施例所公开的模块化封装报表的处理方法进行详细介绍。In order to facilitate the understanding of the present embodiment, the processing method of the modular package report disclosed in the embodiment of the present invention is first introduced in detail.
实施例一：Embodiment 1:
图1为本发明实施例一提供的模块化封装报表的处理方法流程图。FIG. 1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention.
参照图1，模块化封装报表的处理方法包括：Referring to Figure 1, the processing method of the modular package report includes:
步骤S101，获取报表的格式信息和数据存储信息，并保存在数据库中，报表在数据库中具有对应的报表标识符ID；Step S101: Obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
具体地，报表包括查询部分和表格部分，报表的格式信息包括查询信息和表格信息，查询信息包括查询条目和查询格式，表格信息包括表格条目和表格格式。报表的查询部分可以由用户设置，查询结果中的任何一项都可以做为查询条件，满足用户对报表的分析维度的差异化。数据存储信息为报表数据的存储过程，根据数据存储信息可以查询报表数据。这里，报表的格式信息和数据存储信息按预定的规则保存在数据库中，并和报表ID一一对应。Specifically, the report includes a query part and a form part, and the format information of the report includes query information and form information, and the query information includes a query item and a query format, and the form information includes a form entry and a table format. The query part of the report can be set by the user, and any one of the query results can be used as a query condition to satisfy the user's differentiation of the analysis dimension of the report. The data storage information is a storage process of the report data, and the report data can be queried according to the data storage information. Here, the format information and the data storage information of the report are stored in the database according to a predetermined rule, and are in one-to-one correspondence with the report ID.
步骤S102，根据报表对应的报表ID从数据库中查找与报表ID对应的报表的格式信息和数据存储信息；Step S102: Searching, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
步骤S103，根据数据存储信息查询报表数据，并对报表数据进行处理，得到数据处理结果；Step S103, querying report data according to the data storage information, and processing the report data to obtain a data processing result;
这里，将查询到的报表数据加载到封装文件所在的服务器进行数据处理，根据封装的数据操作功能自动对该报表数据进行处理，得到处理后的数据结果。 Here, the queried report data is loaded into the server where the package file is located for data processing, and the report data is automatically processed according to the encapsulated data operation function, and the processed data result is obtained.
步骤S104，将报表的格式信息和数据处理结果加载到显示页面中。In step S104, the format information and the data processing result of the report are loaded into the display page.
具体地，显示页面可以是主体页面，例如AutoQuery.aspx，也可以是其他页面，例如应用程序的界面。Specifically, the display page may be a main page, such as AutoQuery.aspx, or other pages, such as an application interface.
这里，所有报表都可以通过同一个主体页面(例如AutoQuery.aspx)展示，该页面继承于数据处理类，例如AutoQueryPage类，而AutoQueryPage类封装在一个独立的纯类库的项目中，该项目可编译成一个单独的动态链接库文件，即封装文件，报表的所有查询信息、表格信息以及数据存储过程保存在数据库中，而该类库主要处理这些信息的组装工作。如果在新项目中引用该报表体系，只需引用该动态链接库文件，然后添加主体页面AutoQuery.aspx或其他显示页面，数据库按约定好的规范来填充报表相关数据即可。Here, all reports can be displayed through the same body page (such as AutoQuery.aspx), which inherits from data processing classes, such as the AutoQueryPage class, and the AutoQueryPage class is encapsulated in a separate pure class library project that can be compiled. As a separate dynamic link library file, that is, the package file, all query information, table information and data storage process of the report are stored in the database, and the library mainly processes the assembly work of the information. If the report system is referenced in a new project, simply reference the dynamic link library file, and then add the main page AutoQuery.aspx or other display page, and the database fills the report related data according to the agreed specifications.
进一步地，如图2所示，所述方法还包括：Further, as shown in FIG. 2, the method further includes:
步骤S201，获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；Step S201, acquiring first operation instruction information of the user, where the first operation instruction information includes switching information;
步骤S202，根据所述切换信息识别所述报表ID；Step S202, identifying the report ID according to the switching information;
步骤S203，根据所述报表ID从所述数据库中查找与所述报表ID对应的报表。Step S203, searching for a report corresponding to the report ID from the database according to the report ID.
具体地，每个报表都对应一个报表ID，当用户需要从一个报表切换到另一个报表时，***首先识别用户需要切换到的报表的ID，然后根据报表的ID从数据库中分别找到对应的报表的查询信息和表格信息，并加载到显示界面中。Specifically, each report corresponds to a report ID. When the user needs to switch from one report to another, the system first identifies the ID of the report that the user needs to switch to, and then finds the corresponding report from the database according to the ID of the report. The query information and form information are loaded into the display interface.
根据本发明的示例性实施例，所述方法还包括：According to an exemplary embodiment of the present invention, the method further includes:
获取用户的第二操作指令信息，所述第二操作指令信息包括添加信息；Obtaining second operation instruction information of the user, where the second operation instruction information includes adding information;
根据所述添加信息添加新的报表，并保存在所述数据库中。Add a new report based on the added information and save it in the database.
这里，可以根据添加指令添加新的报表，该新的报表为原报表的关联报表，新的报表中的数据来自原报表，只不过将表格部分的统计条目和查询条件重新进行设置，得到不同的报表，新报表的名称和访问权限等可以由用户自己设置。 Here, you can add a new report according to the add command. The new report is the associated report of the original report. The data in the new report comes from the original report, but the statistics items and query conditions in the table are re-set to get different. The report, the name of the new report, and access rights can be set by the user.
根据本发明的示例性实施例，所述方法还包括：According to an exemplary embodiment of the present invention, the method further includes:
获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息；Obtaining third operation instruction information of the user, where the third operation instruction information includes modification information;
根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。Modifying format information of the report according to the modification information, and saving the modified format information in the database.
需要说明的是，可以对报表的查询信息和表格信息进行修改，比如表格信息中的条目名称，列宽、条目显示顺序等等都可以修改，查询信息中的查询条件可以根据查询结果进行修改，查询结果中的任何一项都可以做为查询条件，查询格式也可以进行修改，比如查询日期为XXX～XXX，也可以为开始日期为XXX，结束日期为XXX这种格式。It should be noted that the query information and the form information of the report may be modified. For example, the name of the item in the form information, the column width, the order in which the items are displayed, and the like may be modified, and the query condition in the query information may be modified according to the query result. Any one of the query results can be used as a query condition, and the query format can also be modified. For example, the query date is XXX~XXX, or the start date is XXX, and the end date is XXX.
根据本发明的示例性实施例，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和表格格式。According to an exemplary embodiment of the present invention, the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
实施例二：Embodiment 2:
图3为本发明实施例二提供的模块化封装报表的处理***的结构示意图。FIG. 3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention.
参照图3，模块化封装报表的处理***包括：Referring to Figure 3, the processing system of the modular package report includes:
保存单元10，用于获取报表的格式信息和数据存储信息，并保存在数据库中，所述报表在所述数据库中具有对应的报表标识符ID；The saving unit 10 is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
第一查找单元20，用于根据所述报表对应的报表ID从所述数据库中查找与所述报表ID对应的所述报表的格式信息和所述数据存储信息；The first searching unit 20 is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
处理单元30，用于根据所述数据存储信息查询报表数据，并根据所述封装信息对所述报表数据进行处理，得到数据处理结果；The processing unit 30 is configured to query the report data according to the data storage information, and process the report data according to the package information to obtain a data processing result;
加载单元40，用于将所述报表的格式信息和所述数据处理结果加载到显示页面中。The loading unit 40 is configured to load the format information of the report and the data processing result into the display page.
进一步地，如图4所示，所述***还包括： Further, as shown in FIG. 4, the system further includes:
第一获取单元50，用于获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；The first obtaining unit 50 is configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information;
识别单元60，用于根据所述切换信息识别所述报表ID；The identifying unit 60 is configured to identify the report ID according to the switching information;
第二查找单元70，用于根据所述报表ID从所述数据库中查找所述报表。The second searching unit 70 is configured to search the database from the database according to the report ID.
根据本发明的示例性实施例，还包括：According to an exemplary embodiment of the present invention, the method further includes:
第二获取单元(未示出)，用于获取用户的第二操作指令信息，所述第二操作指令信息包括添加信息；a second obtaining unit (not shown), configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information;
添加单元(未示出)，用于根据所述添加信息添加新的报表，并保存在所述数据库中。An adding unit (not shown) is provided for adding a new report based on the added information and saving in the database.
根据本发明的示例性实施例，还包括：According to an exemplary embodiment of the present invention, the method further includes:
第三获取单元(未示出)，用于获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息；a third acquiring unit (not shown), configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information;
修改单元(未示出)，用于根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。And a modifying unit (not shown), configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
根据本发明的示例性实施例，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和表格格式。According to an exemplary embodiment of the present invention, the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
本发明实施例提供的模块化封装报表的处理***，与上述实施例提供的模块化封装报表的处理方法具有相同的技术特征，所以也能解决相同的技术问题，达到相同的技术效果。The processing system of the modular package report provided by the embodiment of the present invention has the same technical features as the processing method of the modular package report provided by the foregoing embodiment, so that the same technical problem can be solved and the same technical effect can be achieved.
本发明提供了模块化封装报表的处理方法和***，该方法包括：获取报表的格式信息和数据存储信息，并保存在数据库中，报表在数据库中具有对应的报表标识符ID；根据报表对应的报表ID从数据库中查找与报表ID对应的报表的格式信息和数据存储信息；根据数据存储信息查询报表数据，并对报表数据进行处理，得到数据处理结果；将报表的格式信息和数据处理结果加载到显 示页面中。通过采用模块化封装报表，不再需要设计单独的报表文件，只需要一个显示页面来显示报表，便于添加新报表，可以使不同的***方便引进报表***，同时，便于报表***的开发和升级。The invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database; The report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report. To display In the page. By adopting modular packaged reports, it is no longer necessary to design a separate report file. Only one display page is needed to display the report, which is convenient for adding new reports. It is convenient for different systems to introduce the report system, and at the same time, it is convenient for the development and upgrade of the report system.
本发明实施例所提供的计算机程序产品，包括存储了程序代码的计算机可读存储介质，所述程序代码包括的指令可用于执行前面方法实施例中所述的方法，具体实现可参见方法实施例，在此不再赘述。The computer program product provided by the embodiment of the present invention includes a computer readable storage medium storing the program code, and the program code includes instructions for executing the method described in the foregoing method embodiment. For the specific implementation, refer to the method embodiment. , will not repeat them here.
所属领域的技术人员可以清楚地了解到，为描述的方便和简洁，上述描述的***和装置的具体工作过程，可以参考前述方法实施例中的对应过程，在此不再赘述。A person skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the system and the device described above can refer to the corresponding process in the foregoing method embodiments, and details are not described herein again.
另外，在本发明实施例的描述中，除非另有明确的规定和限定，术语“安装”、“相连”、“连接”应做广义理解，例如，可以是固定连接，也可以是可拆卸连接，或一体地连接；可以是机械连接，也可以是电连接；可以是直接相连，也可以通过中间媒介间接相连，可以是两个元件内部的连通。对于本领域的普通技术人员而言，可以具体情况理解上述术语在本发明中的具体含义。In addition, in the description of the embodiments of the present invention, the terms "installation", "connected", and "connected" are to be understood broadly, and may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined. , or connected integrally; may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements. The specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.
所述功能如果以软件功能单元的形式实现并作为独立的产品销售或使用时，可以存储在一个计算机可读取存储介质中。基于这样的理解，本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的部分可以以软件产品的形式体现出来，该计算机软件产品存储在一个存储介质中，包括若干指令用以使得一台计算机设备(可以是个人计算机，服务器，或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括：U盘、移动硬盘、只读存储器(ROM，Read-Only Memory)、随机存取存储器(RAM，Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。The functions may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a standalone product. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, or a part of the technical solution, may be embodied in the form of a software product, which is stored in a storage medium, including The instructions are used to cause a computer device (which may be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like. .
在本发明的描述中，需要说明的是，术语“中心”、“上”、“下”、“左”、“右”、“竖直”、“水平”、“内”、“外”等指示的方位或位置关系为基于附图所示的方位或位置关系，仅是为了便于描述本发明和简化描述，而不是指示或暗示所指的 装置或元件必须具有特定的方位、以特定的方位构造和操作，因此不能理解为对本发明的限制。此外，术语“第一”、“第二”、“第三”仅用于描述目的，而不能理解为指示或暗示相对重要性。In the description of the present invention, it is to be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inside", "outside", etc. The orientation or positional relationship indicated is based on the orientation or positional relationship shown in the drawings, and is merely for the convenience of describing the present invention and simplifying the description, rather than indicating or implying The device or component must have a particular orientation, configuration and operation in a particular orientation, and thus is not to be construed as limiting the invention. Moreover, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
最后应说明的是：以上所述实施例，仅为本发明的具体实施方式，用以说明本发明的技术方案，而非对其限制，本发明的保护范围并不局限于此，尽管参照前述实施例对本发明进行了详细的说明，本领域的普通技术人员应当理解：任何熟悉本技术领域的技术人员在本发明揭露的技术范围内，其依然可以对前述实施例所记载的技术方案进行修改或可轻易想到变化，或者对其中部分技术特征进行等同替换；而这些修改、变化或者替换，并不使相应技术方案的本质脱离本发明实施例技术方案的精神和范围，都应涵盖在本发明的保护范围之内。因此，本发明的保护范围应以所述权利要求的保护范围为准。 Finally, it should be noted that the above-mentioned embodiments are merely specific embodiments of the present invention, and are used to explain the technical solutions of the present invention, and are not limited thereto, and the scope of protection of the present invention is not limited thereto, although reference is made to the foregoing. The present invention has been described in detail, and those skilled in the art should understand that any one skilled in the art can still modify the technical solutions described in the foregoing embodiments within the technical scope disclosed by the present invention. The changes may be easily conceived, or equivalents may be substituted for some of the technical features. The modifications, variations, or substitutions of the present invention are not intended to depart from the spirit and scope of the technical solutions of the embodiments of the present invention. Within the scope of protection. Therefore, the scope of the invention should be determined by the scope of the appended claims.

Claims (10)

  1. 一种模块化封装报表的处理方法，其特征在于，所述方法包括如下步骤：A method for processing a modular package report, characterized in that the method comprises the following steps:
    获取报表的格式信息和数据存储信息，并保存在数据库中，所述报表在所述数据库中具有对应的报表标识符ID；Obtaining format information and data storage information of the report, and saving the data in the database, where the report has a corresponding report identifier ID in the database;
    根据所述报表对应的报表ID从所述数据库中查找与所述报表ID对应的所述报表的格式信息和所述数据存储信息；Finding format information and the data storage information of the report corresponding to the report ID from the database according to the report ID corresponding to the report;
    根据所述数据存储信息查询报表数据，并对所述报表数据进行处理，得到数据处理结果；Querying report data according to the data storage information, and processing the report data to obtain a data processing result;
    将所述报表的格式信息和所述数据处理结果加载到显示页面中。Loading the format information of the report and the data processing result into a display page.
  2. 根据权利要求1所述的模块化封装报表的处理方法，其特征在于，所述方法还包括如下步骤：The method of processing a modular package report according to claim 1, wherein the method further comprises the following steps:
    获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；Obtaining first operation instruction information of the user, where the first operation instruction information includes switching information;
    根据所述切换信息识别所述报表ID；Identifying the report ID according to the switching information;
    根据所述报表ID从所述数据库中查找与所述报表ID对应的报表。Finding a report corresponding to the report ID from the database according to the report ID.
  3. 根据权利要求1所述的模块化封装报表的处理方法，其特征在于，所述方法还包括如下步骤：The method of processing a modular package report according to claim 1, wherein the method further comprises the following steps:
    获取用户的第二操作指令信息，所述第二操作指令信息包括添加信息；Obtaining second operation instruction information of the user, where the second operation instruction information includes adding information;
    根据所述添加信息添加新的报表，并保存在所述数据库中。Add a new report based on the added information and save it in the database.
  4. 根据权利要求1所述的模块化封装报表的处理方法，其特征在于，所述方法还包括如下步骤：The method of processing a modular package report according to claim 1, wherein the method further comprises the following steps:
    获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息； Obtaining third operation instruction information of the user, where the third operation instruction information includes modification information;
    根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。Modifying format information of the report according to the modification information, and saving the modified format information in the database.
  5. 根据权利要求1至权利要求4任一项所述的模块化封装报表的处理方法，其特征在于，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和表格格式。The method for processing a modular package report according to any one of claims 1 to 4, wherein the format information comprises query information and form information, the query information includes a query entry and a query format, The form information includes table entries and table formats.
  6. 一种模块化封装报表的处理***，其特征在于，包括：A processing system for modular packaged reports, comprising:
    保存单元，配置成获取报表的格式信息和数据存储信息，并保存在数据库中，所述报表在所述数据库中具有对应的报表标识符ID；The saving unit is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
    第一查找单元，配置成根据所述报表对应的报表ID从所述数据库中查找与所述报表ID对应的所述报表的格式信息和所述数据存储信息；The first searching unit is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
    处理单元，配置成根据所述数据存储信息查询报表数据，并对所述报表数据进行处理，得到数据处理结果；The processing unit is configured to query the report data according to the data storage information, and process the report data to obtain a data processing result;
    加载单元，配置成将所述报表的格式信息和所述数据处理结果加载到显示页面中。a loading unit configured to load format information of the report and the data processing result into a display page.
  7. 根据权利要求6所述的模块化封装报表的处理***，其特征在于，还包括：The processing system of the modular packaged report according to claim 6, further comprising:
    第一获取单元，配置成获取用户的第一操作指令信息，所述第一操作指令信息包括切换信息；a first acquiring unit, configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information;
    识别单元，配置成根据所述切换信息识别所述报表ID；The identification unit is configured to identify the report ID according to the switching information;
    第二查找单元，配置成根据所述报表ID从所述数据库中查找所述报表。a second searching unit configured to look up the report from the database according to the report ID.
  8. 根据权利要求6所述的模块化封装报表的处理***，其特征在于，还包括：The processing system of the modular packaged report according to claim 6, further comprising:
    第二获取单元，配置成获取用户的第二操作指令信息，所述第二操作指令 信息包括添加信息；a second acquiring unit, configured to acquire second operation instruction information of the user, where the second operation instruction Information includes adding information;
    添加单元，配置成根据所述添加信息添加新的报表，并保存在所述数据库中。Adding a unit configured to add a new report based on the added information and save in the database.
  9. 根据权利要求6所述的模块化封装报表的处理***，其特征在于，还包括：The processing system of the modular packaged report according to claim 6, further comprising:
    第三获取单元，配置成获取用户的第三操作指令信息，所述第三操作指令信息包括修改信息；a third acquiring unit, configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information;
    修改单元，配置成根据所述修改信息对所述报表的格式信息进行修改，并将修改后的格式信息保存在所述数据库中。And a modifying unit configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
  10. 根据权利要求6至权利要求9任一项所述的模块化封装报表的处理***，其特征在于，所述格式信息包括查询信息和表格信息，所述查询信息包括查询条目和查询格式，所述表格信息包括表格条目和表格格式。 The processing system of the modular packaged report according to any one of claims 6 to 9, wherein the format information comprises query information and form information, and the query information comprises a query entry and a query format, The form information includes table entries and table formats.
PCT/CN2017/080125 2017-03-10 2017-04-11 Method and system for processing modular packaged reports WO2018161402A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710144782.XA CN106934021B (en) 2017-03-10 2017-03-10 Processing method and system for modular encapsulation report
CN201710144782.X 2017-03-10

Publications (1)

Publication Number Publication Date
WO2018161402A1 true WO2018161402A1 (en) 2018-09-13

Family

ID=59433152

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/080125 WO2018161402A1 (en) 2017-03-10 2017-04-11 Method and system for processing modular packaged reports

Country Status (2)

Country Link
CN (1) CN106934021B (en)
WO (1) WO2018161402A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109446507A (en) * 2018-11-13 2019-03-08 浙江中智达科技有限公司 A kind of construction method and device of report

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113051219A (en) * 2019-12-26 2021-06-29 贵州白山云科技股份有限公司 Database management method, device, equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751436A (en) * 2008-12-19 2010-06-23 ***通信集团山东有限公司 Method and system for generating reports
CN102682126A (en) * 2012-05-16 2012-09-19 深圳市凯立德科技股份有限公司 Access method and device for form data
CN103345484A (en) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 Report form processing system based on dynamic domain and method
CN104516864A (en) * 2013-09-30 2015-04-15 北大方正集团有限公司 Report generating method and report generating device

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7188100B2 (en) * 2000-02-25 2007-03-06 Joseph De Bellis Search-on-the-fly report generator
US20050114308A1 (en) * 2003-11-24 2005-05-26 International Business Machines Corporation User customizable reporting
CN101140562A (en) * 2007-02-14 2008-03-12 中兴通讯股份有限公司 Method for realizing user-defined report forms
US20080250054A1 (en) * 2007-02-20 2008-10-09 Donald Bert Nickel Object based heuristics database platform
CN104317839B (en) * 2014-10-10 2017-11-14 北京国双科技有限公司 The method and apparatus for generating report form template
CN104572813B (en) * 2014-11-26 2019-02-26 国家电网公司 A kind of report generation method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751436A (en) * 2008-12-19 2010-06-23 ***通信集团山东有限公司 Method and system for generating reports
CN102682126A (en) * 2012-05-16 2012-09-19 深圳市凯立德科技股份有限公司 Access method and device for form data
CN103345484A (en) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 Report form processing system based on dynamic domain and method
CN104516864A (en) * 2013-09-30 2015-04-15 北大方正集团有限公司 Report generating method and report generating device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109446507A (en) * 2018-11-13 2019-03-08 浙江中智达科技有限公司 A kind of construction method and device of report

Also Published As

Publication number Publication date
CN106934021A (en) 2017-07-07
CN106934021B (en) 2020-06-23

Similar Documents

Publication Publication Date Title
US8959106B2 (en) Class loading using java data cartridges
CN109933571B (en) Database design document generation method, device and computer readable storage medium
CN111596965B (en) Project engineering initialization method, device, computer equipment and storage medium
US20190138498A1 (en) Resolving in-memory foreign keys in transmitted data packets from single-parent hierarchies
US20240143904A1 (en) Human-Computer Interaction Method And Apparatus Thereof
CN109284261B (en) Application searching method and device, storage medium and electronic equipment
CN109710220B (en) Relational database query method, relational database query device, relational database query equipment and storage medium
WO2021217846A1 (en) Interface data processing method and apparatus, and computer device and storage medium
CN108563694B (en) SQL execution method and device for logic deletion, computer equipment and storage medium
CN104268472B (en) Reduction is by the method and apparatus of third party's dynamic base Modification growth function address
JP2014130547A (en) File management program, file management device and file management method
WO2018161402A1 (en) Method and system for processing modular packaged reports
US20120159515A1 (en) Sharing object representations
CN107908679B (en) Script statement conversion method and device and computer readable storage medium
US8190661B2 (en) Using virtual repository items for customized display
WO2018001041A1 (en) Interface implementation method and device, set-top box, and storage medium
US20140298316A1 (en) Managing method for application program installation and electronic device
TW201324347A (en) System and method for managing commands of function module
JP6110139B2 (en) File management program, file management apparatus, and file management method
CN111158777B (en) Component calling method, device and computer readable storage medium
US11900269B2 (en) Method and apparatus for managing knowledge base, device and medium
CN111488144A (en) Data processing method and equipment
CN113849524B (en) Data processing method and device
CN114676133A (en) Index creating method, device, equipment and storage medium
CN115033592A (en) SQL statement processing method, device, equipment and storage medium based on database

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17899455

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 17899455

Country of ref document: EP

Kind code of ref document: A1