Method and system for realizing data sharing by completing one-table communication based on data elements

Abstract

The invention relates to the technical field of computers, in particular to a method and system for achieving data sharing by completing one-table communication based on data elements, and the method comprises the following steps: filling an enterprise information filling item questionnaire table, uploading a sample table, importing the content of the Excel questionnaire table into a page table by importing an Excel function, and storing the Excel questionnaire table in the page table; online filling, template downloading, storage and next operation are achieved, the page table has the functions of editing, sample table uploading and deletion operation, and operation is cancelled to empty unstored data; the method and the system have the beneficial effects that according to the method and the system for realizing data sharing by completing one-table communication based on the data elements, the one-table communication application of enterprise data is realized by utilizing the prior art according to business requirements and packaging related implementation methods, and the problems of multi-head filling and repeated filling of enterprise information and the like are solved; according to the method, the enterprise information filling rule and the enterprise information filling process are optimized, the cross-department collaborative service level is improved, and one event can be efficiently handled in more fields.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method and system for achieving data sharing through one-table communication based on data elements. Background Art

[0002] With the rapid development of information technology, data sharing has become an important demand in various industries and fields. Especially in the construction of enterprise informatization, the integration, sharing and utilization of data are of great significance to improving the operational efficiency and management level of enterprises. However, traditional data management methods often have problems such as data islands, repeated data filling, and difficulty in efficient use of data. These problems seriously restrict the data sharing and informatization construction process of enterprises.

[0003] The prior art has the following deficiencies:

[0004] Data island problem: Due to the lack of unified data standards and incompatible data interfaces between different systems and departments, data cannot be shared and exchanged across systems and departments, forming data islands.

[0005] Problem of duplicate data entry: Enterprises need to fill out a large number of forms and reports in different business scenarios, and the data in these forms and reports are often filled out repeatedly, which not only increases the workload but also reduces the accuracy and timeliness of the data.

[0006] The problem of data being difficult to use efficiently: Since data is scattered across different systems and departments and there is a lack of a unified data management and analysis platform, data is difficult to use and analyze efficiently, and cannot provide strong support for corporate decision-making. Summary of the invention

[0007] The purpose of the present invention is to provide a method and system for achieving data sharing through one table based on data elements, so as to solve the problems raised in the above background technology.

[0008] To achieve the above object, the present invention provides the following technical solution: a method for realizing data sharing by completing one-table communication based on data elements, the method comprising the following steps:

[0009] a) Fill in the "Enterprise Information Reporting Questionnaire" and upload the sample form. Use the Excel import function to import the Excel survey form content into the page form to realize online reporting, download templates, save, and next step operations. The page form has the functions of editing, uploading sample forms, deleting, and canceling operations to clear unsaved data;

[0010] b) Check the "Enterprise Information Reporting Questionnaire" that you have temporarily saved or completed, and filter according to the department / bureau, name of the person filling in the questionnaire, status of the questionnaire, and date conditions, and enter different operation pages according to the status of the questionnaire;

[0011] c) Check and maintain the data items contained in the submitted sample tables, supplement the definition and data type information, import, export and view logs of the sample tables, submit data items in batches with the status of "pending submission", and perform information maintenance and submission review operations;

[0012] d) View the list of matters, sample forms and data items submitted by all departments, display the number of matters, sample forms and data items under different departments, and click on the department to view the total number of specific data items, data element name, data type and matching status of related data items;

[0013] e) Check and review the data item information maintained by the department, query according to the department, category, data item name, review status, and one-table matching status, and perform batch review or flow review on data items with a status of "pending review".

[0014] Preferably, in step a), after the online reporting is completed, the reported information is saved in the database "Enterprise Information Reporting Questionnaire", and the next step will jump the page to the enterprise information reporting questionnaire list page, and the jump can only be made if there is reported data.

[0015] Preferably, in step c), the maintenance page displays the data items under the currently stored sample table and the sample tables associated with the data items. When entering the maintenance page from the homepage, the page recursively displays all the maintenance data item information and all the sample tables of the current user, and batches are submitted for data items with a status of "pending submission". In other states, the "batch submit" button is grayed out.

[0016] Preferably, in step d), by clicking the "Extract" button, the extracted data items are stored in the database enterprise information reporting item data item table EIFM_DataItem_tmp, displaying the items, sample tables and data item numbers under different departments. Click on the department to view the total number of specific data items, data element name, data type and matching status of related data items, including the DuPont diagram.

[0017] Preferably, in step e), the audit data item information page displays the data item information maintained by all departments, and batch audit or flow audit is performed on the data items with the status of "pending audit". During the flow audit, all information cannot be changed, and the operation performed is "audit passed" or "audit failed". If it fails, the reason for failure must be filled in; finally, a table of enterprise data is queried and exported, and different permissions are given according to different login roles. The administrator edits and adds operations to a table.

[0018] A system for realizing data sharing by completing one-table communication based on data elements, applied to a method for realizing data sharing by completing one-table communication based on data elements, the system comprising:

[0019] Filling module: used to fill in the "Enterprise Information Filling Questionnaire" and upload sample forms, support importing Excel files to automatically fill in form content, filling in and uploading sample forms online, downloading templates, saving filling information to the database, jumping to the questionnaire list page, editing form content, uploading sample forms, deleting form content, and canceling unsaved filling information;

[0020] View module: used to view the "Enterprise Information Reporting Questionnaire" that has been temporarily stored or completed by the applicant, and supports query and filtering based on department / bureau, name of the applicant, status of the questionnaire, and date conditions. It also allows users to enter different operation pages based on the status of the questionnaire, including viewing the details page, editing the questionnaire in the draft state, and extracting sample forms and storing data item information;

[0021] Maintenance module: used to view and maintain the data items contained in the submitted sample forms, supplement the definition and data type information, support import, export, and log viewing operations, batch submit data items with the status of "pending submission", perform corresponding operations on the sample forms with "approved" and "failed" status, and ensure that all required items are filled in before saving or submitting to the database for review;

[0022] Basic situation viewing module: used to view the list of items, sample tables, and data items submitted by all departments, display the number of items, sample tables, and data items under different departments, and support clicking on departments to view detailed information of specific data items, including data element name, data type, matching status, and DuPont diagram;

[0023] Audit module: used to view and audit the data item information maintained by the department. It supports query based on department, classification, data item name, audit status, and table matching status. It can export table data to Excel, and perform batch audit or flow audit on data items with the status of "pending audit". During flow audit, all information cannot be changed. Only "audit passed" or "audit failed" operations can be performed, and the reason for failure can be filled in.

[0024] Query and export module: used to query and export a table of enterprise data, display all standard table data, support query based on classification method and data item name, export table data to Excel, and grant different permissions based on different login roles. Administrators can edit and add operations to a table.

[0025] Preferably, the reporting module also includes a function for saving the reported information into the database "Enterprise Information Reporting Questionnaire" after the reporting is completed, and jumping to the enterprise information reporting questionnaire list page when performing the next operation.

[0026] Preferably, the maintenance module also includes a function for ensuring that all required items are filled in when maintaining sample form information, and saving the filled in information content to the database department data item table when clicking Save, and a function for reviewing in addition to saving the filled in information content to the database department data item table when clicking Submit for Review.

[0027] Preferably, the survey situation viewing module also includes a function for storing the extracted data items into the database enterprise information reporting item data item table EIFM_DataItem_tmp by clicking the "Extract" button, and displaying the items, sample tables and data item quantities under different departments.

[0028] Preferably, the query export module also includes a function for ensuring that the "data item name" is unique and cannot be changed when the administrator edits a table, and updating the information to the database data element modification log table when clicking Save after modifying the enterprise data item information, as well as querying whether the same data item name exists in a table EDReport_AllDataElement of the database enterprise data based on the filled-in data item name when adding a new data item, and performing corresponding operations based on the query results.

[0029] Compared with the prior art, the present invention has the following beneficial effects:

[0030] The method and system proposed in the present invention for achieving data sharing through one-form based on data elements utilizes existing technologies to encapsulate relevant implementation methods according to business needs, realizes the one-form application of enterprise data, and automatically solves the problems of multiple reporting and repeated reporting of enterprise information; promotes government-enterprise data sharing, optimizes enterprise information reporting rules and processes, improves the level of cross-departmental collaborative services, and realizes efficient completion of "one thing" in more fields. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 It is a schematic diagram of the state of the sample table of the present invention;

[0032] Figure 2 The present invention is a flowchart of the audit steps. DETAILED DESCRIPTION

[0033] In order to make the purpose and technical solution of the present invention clearly and completely described, and the advantages more clearly understood, the embodiments of the present invention are further described in detail with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are part of the embodiments of the present invention, rather than all of the embodiments, and are only used to explain the embodiments of the present invention, and are not used to limit the embodiments of the present invention. All other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0034] For example, see Figure 1 to Figure 2 The present invention provides a technical solution: a method for realizing data sharing by completing one-table communication based on data elements, the method comprising the following steps:

[0035] Step 1: Fill in the "Enterprise Information Reporting Questionnaire" and upload the sample form (I want to fill in the module). Add a new page for the enterprise information reporting questionnaire, the specific functional requirements of the page are as follows:

[0036] 1. Import Excel: You can import the contents of the Excel survey form into the table on the page to automatically fill in the information

[0037] 2. Online reporting: The pop-up window in the drawer allows you to input the reporting content online and upload the sample form. After completing the reporting, the reported information will be entered into the "Enterprise Information Reporting Questionnaire" in the database.

[0038] 3. Download the template: import the content in the table of the enterprise information filling questionnaire page into Excel and download it

[0039] 4. Save: Save the filled information to the database "Enterprise Information Filling Questionnaire" and continue to stay on the filling list page

[0040] 5. Next step: Save the reported information to the database "Enterprise Information Reporting Questionnaire" and then jump to the Enterprise Information Reporting Questionnaire List Page (reported data must exist)

[0041] 6. The page table needs to have editing operations, sample table upload operations, and deletion operations

[0042] 7. Cancel: The newly reported information in the form (data that has not been saved) is cleared, and the data is not saved in the database "Enterprise Information Reporting Questionnaire"

[0043] Step 2: View the "Enterprise Information Filling Questionnaire" that has been temporarily saved and processed, and you can view or continue processing (I want to view the module)

[0044] This module is divided into three parts. The first part shows the overall content of the enterprise information reporting form. If there is too much content, you can search and filter according to the department / bureau, name of the person filling out the form, form status, start date-end date and other conditions. Depending on the status of the form, you can enter different pages.

[0045] Part 2: When the status of the survey form is "Entry completed", you can only enter the details page, where you can see the specific detailed content of the form.

[0046] Part 3: When the status of the survey form is "Draft", you can edit it, enter the extraction and storage page to extract the sample form and enter the sample form information into the database enterprise information filling item data item table. After the storage is completed, enter the I want to maintain the data item information module to supplement the data, etc.

[0047] Step 3: View and maintain the data items included in the submitted sample form, and supplement the definition, data type and other information (I want to maintain the data item information module)

[0048] The maintenance page needs to be displayed according to the situation. The maintenance page entered after the storage is completed displays the data items under the current storage sample table and the sample tables associated with the data items. When entering the maintenance page from the homepage, the page displays all the maintenance data item information and all the sample tables of the current user. The page list displays all the sample tables under the first data item by default. When all the sample tables under the current data item are displayed, the next data item will be displayed and all the corresponding sample tables will be displayed, and so on and so forth, until all the data are displayed.

[0049] All sample tables can be imported, exported, and logs can be viewed. For data items in the sample table with a status of "pending submission", batch submission can be performed. In other states, the "batch submission" button is grayed out. In addition, information maintenance and submission review operations can be performed.

[0050] For the sample forms with a status of "approved", you can view details; for the sample forms with a status of "failed", you can maintain information, submit for review, and perform other operations.

[0051] When maintaining sample form information, make sure all required fields are filled in. When you click "Save" after completing the information, the filled in information will be saved in the database department data item table (eifm_orgdataitem). When you click "Submit for Review", in addition to saving the filled in information in the database department data item table (eifm_orgdataitem), it will also be reviewed.

[0052] Step 4: Check all items, sample forms, and data item lists submitted by all departments (I want to check the survey status module)

[0053] The "I want to survey" page mainly displays the data items extracted from the quality inspection warehousing page under the maintenance information module and stored in the database enterprise information reporting item data item table EIFM_DataItem_tmp by clicking the "Extract" button. On this page, you can intuitively see how many items, sample tables and data items there are under different departments. You can click on the department to view the total number of occurrences of specific data items under the department, the data element name, data type and matching of related data items, DuPont diagram, etc.

[0054] Step 5: Check and review the data item information maintained by the department (I want to review the data item information module)

[0055] The audit data item information page will display the data item information that has been maintained by all departments. If there is a lot of information, you can query it based on the department, classification (field classification, basic classification), data item name, audit status, and a table matching status. For table data, the data content in the table can be imported into Excel through the "Export" function and downloaded. Only the data in the table with a status of "pending review" can be "batch reviewed" or "flow reviewed". During "flow review", all information cannot be changed. The operations that can be performed are "review passed" and "review failed". If it fails, the reason for failure must be filled in.

[0056] Step 6: Query and export a table of enterprise data (I want to query a table module for enterprises)

[0057] All the above steps are to obtain "a table of enterprise data". On the final page of a table of enterprise data, we can see all the standard table data. When there is a lot of data, we can query according to the classification method and data item name of a table. The table content can be stored in Excel through the "Export" function and then downloaded. For a specific table, we give different permissions according to different login roles. The administrator can "edit" and "add" a table. When editing, the "data item name" is unique and cannot be changed. After the enterprise data item information is modified, click Save to update the information to the database data element modification log table (log table: eifm_dataitemmodifylog, all tables will use different hashkeys as indexes and use the trigger flipFlopChange for association. Every time a table value is added, deleted, or modified, it will be calculated, assigned, and managed by flipFlopChange). When adding, a table lookup will be performed when you click Save (according to the filled data item name, check whether there is the same data item name in the database enterprise data table EDReport_AllDataElement. If the data item name does not exist, the newly added data will be entered into the database enterprise data table EDReport_AllDataElement. If the data item name exists, it will prompt "A table exists, please re-enter it."

[0058] Embodiment 2, based on Embodiment 1, proposes a system for realizing data sharing by completing one table based on data element, which is applied to a method for realizing data sharing by completing one table based on data element, and the system comprises:

[0059] Filling module: used to fill in the "Enterprise Information Filling Questionnaire" and upload sample forms, supports importing Excel files to automatically fill in form content, filling in and uploading sample forms online, downloading templates, saving reported information to the database, jumping to the questionnaire list page, editing form content, uploading sample forms, deleting form content and canceling unsaved reported information; the filling module also includes a function for saving the reported information to the "Enterprise Information Filling Questionnaire" in the database after the filling is completed, and jumping to the enterprise information filling questionnaire list page when performing the next step.

[0060] View module: used to view the "Enterprise Information Reporting Questionnaire" that has been temporarily stored or completed by the applicant, and supports query and filtering based on department / bureau, name of the applicant, status of the questionnaire, and date conditions. It also allows users to enter different operation pages based on the status of the questionnaire, including viewing the details page, editing the questionnaire in the draft state, and extracting sample forms and storing data item information;

[0061] Maintenance module: used to view and maintain the data items contained in the submitted sample forms, supplement the definition and data type information, support import, export, and log viewing operations, batch submit data items with the status of "pending submission", perform corresponding operations on the sample forms with "approved" and "failed review", and ensure that all required items are filled in before saving or submitting them to the database for review; the maintenance module also includes functions for ensuring that all required items are filled in when maintaining sample form information, saving the filled in information to the database department data item table when clicking Save, and reviewing the information in addition to saving it to the database department data item table when clicking Submit for Review.

[0062] Basic survey review module: used to view the list of matters, sample forms, and data items submitted by all departments, display the number of matters, sample forms, and data items under different departments, and support clicking on departments to view detailed information of specific data items, including data element name, data type, matching status, and DuPont diagram; the basic survey review module also includes a function for storing the extracted data items into the database enterprise information reporting matters data item table EIFM_DataItem_tmp by clicking the "Extract" button, and displaying the number of matters, sample forms, and data items under different departments.

[0063] Audit module: used to view and audit the data item information maintained by the department. It supports query based on department, classification, data item name, audit status, and table matching status. It can export table data to Excel, and perform batch audit or flow audit on data items with the status of "pending audit". During flow audit, all information cannot be changed. Only "audit passed" or "audit failed" operations can be performed, and the reason for failure can be filled in.

[0064] Query and export module: used to query and export a table of enterprise data, display all standard table data, support query based on classification method and data item name, export table data to Excel, and grant different permissions according to different login roles. Administrators can edit and add operations to a table; the query and export module also includes functions for ensuring that the "data item name" is unique and cannot be changed when the administrator edits a table, and updating the information to the database data element modification log table when clicking Save after modifying the enterprise data item information, as well as querying whether the same data item name exists in the database enterprise data table EDReport_AllDataElement according to the filled-in data item name when adding a new data item, and performing corresponding operations based on the query results.

[0065] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for achieving data sharing through one table based on data elements, characterized in that: The method comprises the following steps: a) Fill in the "Enterprise Information Reporting Questionnaire" and upload the sample form. Use the Excel import function to import the Excel survey form content into the page form to realize online reporting, download templates, save, and next step operations. The page form has the functions of editing, uploading sample forms, deleting, and canceling operations to clear unsaved data; b) Check the "Enterprise Information Reporting Questionnaire" that you have temporarily saved or completed, and filter according to the department / bureau, name of the person filling in the questionnaire, status of the questionnaire, and date conditions, and enter different operation pages according to the status of the questionnaire; c) Check and maintain the data items contained in the submitted sample tables, supplement the definition and data type information, import, export and view logs of the sample tables, submit data items in batches with the status of "pending submission", maintain information and submit for review; d) View the list of matters, sample forms and data items submitted by all departments, display the number of matters, sample forms and data items under different departments, and click on the department to view the total number of specific data items, data element name, data type and matching status of related data items; e) Check and review the data item information maintained by the department, query according to the department, category, data item name, review status, and one-table matching status, and perform batch review or flow review on data items with the status of "pending review".

2. A method for realizing data sharing based on data element completion through one table according to claim 1, characterized in that: In step a), after the online reporting is completed, the reported information is saved in the database "Enterprise Information Reporting Questionnaire", and the next step will jump the page to the Enterprise Information Reporting Questionnaire list page. The page can only be jumped if there is reported data.

3. A method for realizing data sharing based on data element completion through one table according to claim 1, characterized in that: In step c), the maintenance page displays the data items under the current stored sample table and the sample tables associated with the data items. When entering the maintenance page from the home page, the page recursively displays all the maintenance data item information and all the sample tables of the current user, and batch submits the data items with the status of "pending submission". The "batch submit" button is grayed out in other states.

4. The method for realizing data sharing based on data element completion through one table according to claim 1, characterized in that: In step d), by clicking the "Extract" button, the extracted data items are stored in the database enterprise information reporting item data item table EIFM_DataItem_tmp, displaying the items, sample tables and data item numbers under different departments. Click on the department to view the total number of specific data items, data element name, data type and matching status of related data items, including the DuPont diagram.

5. The method for realizing data sharing based on data element completion through one table according to claim 1, characterized in that: In step e), the audit data item information page displays the data item information maintained by all departments. Data items with the status of "pending audit" are subject to batch audit or flow audit. During flow audit, all information cannot be changed. The operations performed are "audit passed" or "audit failed". If the audit fails, the reason for failure must be filled in. Finally, a table of enterprise data is queried and exported. Different permissions are granted according to different login roles, and the administrator can edit and add operations to a table.

6. A system for realizing data sharing by completing one table based on data elements, applied to a method for realizing data sharing by completing one table based on data elements as claimed in any one of claims 1 to 5, characterized in that: The system comprises: Filling module: used to fill in the "Enterprise Information Filling Questionnaire" and upload sample forms, support importing Excel files to automatically fill in form content, filling in and uploading sample forms online, downloading templates, saving filling information to the database, jumping to the questionnaire list page, editing form content, uploading sample forms, deleting form content, and canceling unsaved filling information; View module: used to view the "Enterprise Information Reporting Questionnaire" that has been temporarily stored or completed by the applicant, and supports query and filtering based on department / bureau, name of the applicant, status of the questionnaire, and date conditions. It also allows users to enter different operation pages based on the status of the questionnaire, including viewing the details page, editing the questionnaire in the draft state, and extracting sample forms and storing data item information; Maintenance module: used to view and maintain the data items contained in the submitted sample forms, supplement the definition and data type information, support import, export, and log viewing operations, batch submit data items with the status of "pending submission", perform corresponding operations on the sample forms with "approved" and "failed" status, and ensure that all required items are filled in completely before saving or submitting to the database for review; Basic situation viewing module: used to view the list of items, sample tables, and data items submitted by all departments, display the number of items, sample tables, and data items under different departments, and support clicking on departments to view detailed information of specific data items, including data element name, data type, matching status, and DuPont diagram; Audit module: used to view and audit the data item information maintained by the department. It supports query based on department, category, data item name, audit status, and table matching status. It can export table data to Excel and perform batch audit or flow audit on data items with the status of "pending audit". During flow audit, all information cannot be changed. Only "audit passed" or "audit failed" operations can be performed, and the reason for failure can be filled in. Query and export module: used to query and export a table of enterprise data, display all standard table data, support query based on classification method and data item name, export table data to Excel, and grant different permissions based on different login roles. Administrators can edit and add operations to a table.

7. A system for realizing data sharing based on data element through one table according to claim 6, characterized in that: The reporting module also includes a function for saving the reported information to the "Enterprise Information Reporting Questionnaire" in the database after the reporting is completed, and jumping to the enterprise information reporting questionnaire list page when performing the next step.

8. A system for realizing data sharing based on data element through one table according to claim 6, characterized in that: The maintenance module also includes a function for ensuring that all required items are filled in when maintaining sample form information, and saving the filled in information content to the database department data item table when clicking Save, and a function for reviewing the filled in information content in addition to saving it to the database department data item table when clicking Submit for Review.

9. A system for realizing data sharing based on data element through one table according to claim 6, characterized in that: The survey situation viewing module also includes a function for storing the extracted data items into the database enterprise information reporting item data item table EIFM_DataItem_tmp by clicking the "Extract" button, and displaying the items, sample tables and data item quantities under different departments.

10. A system for realizing data sharing based on data element through one table according to claim 6, characterized in that: The query export module also includes a function for ensuring that the "data item name" is unique and cannot be changed when the administrator edits a table, and updating the information to the database data element modification log table when clicking Save after modifying the enterprise data item information, as well as querying whether the same data item name exists in a table EDReport_AllDataElement of the database enterprise data based on the filled-in data item name when adding a new data item, and performing corresponding operations based on the query results.

Images