CN111444251B - Flexible and efficient dynamic data conversion method - Google Patents
Flexible and efficient dynamic data conversion method Download PDFInfo
- Publication number
- CN111444251B CN111444251B CN202010213297.5A CN202010213297A CN111444251B CN 111444251 B CN111444251 B CN 111444251B CN 202010213297 A CN202010213297 A CN 202010213297A CN 111444251 B CN111444251 B CN 111444251B
- Authority
- CN
- China
- Prior art keywords
- data
- scheme
- interface configuration
- filtering
- function
- Prior art date
- Legal status (The legal status 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 status listed.)
- Active
Links
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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/23—Updating
-
- 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/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Human Computer Interaction (AREA)
- User Interface Of Digital Computer (AREA)
- Digital Computer Display Output (AREA)
Abstract
The invention discloses a flexible and efficient dynamic data conversion method, which relates to the technical field of data conversion, wherein an interface configuration function and a reusable form window are required to be additionally arranged in a service module of an ERP system, and the implementation process of the method comprises the following steps: the mapping scheme, the display scheme, the filtering scheme and the write-back scheme of the dynamic flow data are customized by utilizing the interface configuration function, and meanwhile, the customized mapping scheme, the display scheme, the filtering scheme and the write-back scheme are changed at any time by utilizing the interface configuration function and stored in a database in real time; and filtering, displaying and writing back different flow data by utilizing a user-defined mapping scheme corresponding to different modulation of the input parameters by utilizing the reusable Winform window. The invention can be used for the implementation personnel to directly configure and call when aiming at the feedback report or processing the flow dynamic data, provides the information write-back function, improves the development and implementation efficiency, is very flexible, and has good popularization and application values.
Description
Technical Field
The invention relates to the technical field of data conversion, in particular to a flexible and efficient dynamic data conversion method.
Background
In ERP, basically all business modules contain flow data, sometimes a leader wants to grasp the business flow from the whole, at this time, we usually provide report functions or query tracking functions, and the functions are usually report functions formed by writing different sql through different codes, so that the report is usually fixed after the function development is finished, if the report is modified, feedback development is needed to be implemented, the development and the implementation are complicated and non-reusable, the leader can only check the result on line and cannot make on-line feedback, and if the opinion conclusion is still needed to be fed back off line, the development and delivery efficiency is reduced, and the issuing efficiency of the leader opinion is also reduced.
Disclosure of Invention
Aiming at the needs and the shortcomings of the prior art development, the invention provides a flexible and efficient dynamic data conversion method.
The invention discloses a flexible and efficient dynamic data conversion method, which solves the technical problems and adopts the following technical scheme:
a flexible and efficient dynamic data conversion method needs to add interface configuration functions and reusable Winform forms in a service module of an ERP system, and the implementation process of the method comprises the following steps:
the mapping scheme, the display scheme, the filtering scheme and the write-back scheme of the dynamic flow data are customized by utilizing the interface configuration function, and meanwhile, the customized mapping scheme, the display scheme, the filtering scheme and the write-back scheme are changed at any time by utilizing the interface configuration function and stored in a database in real time;
and filtering, displaying and writing back different flow data by utilizing a user-defined mapping scheme corresponding to different modulation of the input parameters by utilizing the reusable Winform window.
Specifically, an interface configuration header and an interface configuration detail data table are established by utilizing an interface configuration function;
the interface configuration header data table is used for distinguishing different flows, and prescribes the ID, name, number and main table of the report function; the serial numbers of the report functions are used as parameters to be transmitted into the subsequent display functions and used for distinguishing different business processes and reading different configuration information;
the interface configuration detail data table is used for configuring each field mapping relation, header merging and displaying, header lower field displaying sequence, fonts and whether to write back various information or not.
More specifically, the interface configuration detail data table is also used for configuring various information of condition styles, message reminding and tasks to be handled which are displayed under different flows.
More specifically, the interface configuration detail data table is further used for adding description fields, wherein the description fields comprise the font and the color of the header, the font and the color of the table body data, and the condition style of the data meeting certain conditions.
More specifically, the interface configuration detail data table is also used for adding the permission field, and the data to be read is filtered according to the permission field added by the operator.
Specifically, the interface configuration detail data table is displayed in a tree form, and grading information exists in the interface configuration detail data table; the interface configuration detail data table comprises a corresponding table or view, a corresponding table field, a corresponding table main key, a corresponding table data stream field and an editing or not; the five fields of the 'corresponding table or view', 'corresponding table field', 'corresponding table primary key', 'table corresponding data stream field', 'whether to edit' are used for data loading and data writing back together with the primary table field of the interface configuration header data table.
More specifically, an interface configuration function is utilized to construct two data tables of an interface configuration header and an interface configuration detail into a left-list right-tree-shaped flow tracking configuration interface; the flow tracking configuration interface directly displays and maintains different flow functions, multi-stage header display of each function, data mapping relation, interface display, filtering conditions and corresponding help of the interface display and various information of the write-back section, and is also provided with an 'additionally-added function' button, a 'deleting function' button, an 'additionally-added stage' button, an 'additionally-added sub-stage' button, a 'deleting sub-stage' button and a 'cancel' button, an 'edit' button and a 'save' button for operating the interface configuration header data table.
More specifically, the workflow of the reusable Winform form is:
receiving an input parameter, wherein the parameter is the number of a report function;
calling corresponding configuration information from a database according to the input parameters, wherein the configuration information is a mapping scheme, a display scheme, a filtering scheme and a write-back scheme of dynamic flow data customized by utilizing an interface configuration function;
after the configuration information is obtained, a filtering scheme and a write-back scheme are executed, and finally, the display is carried out according to a display scheme.
More specifically, after the configuration information is obtained, specific operations for executing the filtering scheme include:
the interface configuration detail data table comprises a field of whether filtering, corresponding help, node type, corresponding name, corresponding field, edit, display sequence, font and color;
according to the fields of filtering or not and corresponding help, using codes to draw the filtering conditions of the filtering area;
the table head and the table body display format of the table are configured according to the node type, the corresponding name, the corresponding field, whether the editing is performed, the display sequence, the font and the color fields, and whether the editing is allowed or not is sequentially performed according to the corresponding relation between the fields of the table and the data source.
More specifically, after the configuration information is obtained, specific operations of executing the write-back scheme include:
acquiring all data tables loaded by data in configuration information, and eliminating repeated data tables;
establishing an association relation through the corresponding bill flow ID and taking a corresponding main table in configuration information as a query main table;
according to the fields of the corresponding table, the corresponding field and the corresponding main key, adding search conditions spliced by the identifiers of the help returns in the filtering area, and finishing the sql splicing of data loading;
in the data write-back process, traversing the data row with the change set, splicing sql of the data to be updated according to the field of 'whether to edit', 'corresponding table or view', 'corresponding table main key', and executing to realize the data write-back.
Compared with the prior art, the flexible and efficient dynamic data conversion method has the beneficial effects that:
the invention provides a report form which can convert dynamic flow data into a report form with feedback through user-defined configuration, can be directly configured and called by an implementer aiming at the feedback report form or processing the dynamic flow data, provides an information write-back function, improves development and implementation efficiency, is very flexible, and has good popularization and application values.
Drawings
FIG. 1 is a flow trace configuration interface of the present invention;
fig. 2 is a schematic view of information contained in a column of the flow tracking configuration interface according to the present invention.
FIG. 3 is a flow chart of the present invention for performing data write back using a reusable Winform window.
Detailed Description
In order to make the technical scheme, the technical problems to be solved and the technical effects of the invention more clear, the technical scheme of the invention is clearly and completely described below by combining specific embodiments.
Embodiment one:
the embodiment provides a flexible and efficient dynamic data conversion method, which needs to add an interface configuration function and a reusable window in a service module of an ERP system, and the implementation process of the method comprises the following steps:
the mapping scheme, the display scheme, the filtering scheme and the write-back scheme of the dynamic flow data are customized by utilizing the interface configuration function, and meanwhile, the customized mapping scheme, the display scheme, the filtering scheme and the write-back scheme are changed at any time by utilizing the interface configuration function and stored in a database in real time;
and filtering, displaying and writing back different flow data by utilizing a user-defined mapping scheme corresponding to different modulation of the input parameters by utilizing the reusable Winform window.
In this embodiment, an interface configuration header and an interface configuration detail data table are established by using an interface configuration function.
The interface configuration header data table is used for distinguishing different flows, and prescribes the ID, name, number and main table of the report function; the number of the report function is used as a parameter to be transmitted into a subsequent display function, so as to distinguish different business processes and read different configuration information, as shown in the following table 1:
the interface configuration detail data table is used for configuring each field mapping relation, header merging and displaying, header lower field displaying sequence, fonts and whether to write back various information or not. As shown in table 2 below:
in connection with Table 2, the interface configuration details data table is also used to:
1) Configuring various information of a condition style, a message reminder and a task to be handled which are displayed under different flows;
2) Adding a description field, wherein the description field comprises a font and a color of a header, a font and a color of table body data, and a conditional style of the data meeting certain conditions;
3) And adding an authority field, and filtering the data to be read according to the authority field added by the operator.
In this embodiment, referring to fig. 1, the interface configuration detail data table is displayed in a tree form, and hierarchical information exists in the interface configuration detail data table. The interface configuration detail data table comprises a corresponding table or view, a corresponding table field, a corresponding table main key, a corresponding table data stream field and an editing or not; the five fields of the 'corresponding table or view', 'corresponding table field', 'corresponding table primary key', 'table corresponding data stream field', 'whether to edit' are used for data loading and data writing back together with the primary table field of the interface configuration header data table.
In this embodiment, with reference to fig. 1 and 2, two data tables including an interface configuration header and an interface configuration detail are constructed as a left-list right-tree-shaped flow tracking configuration interface by using an interface configuration function. The flow tracking configuration interface directly displays and maintains different flow functions, multi-stage header display of each function, data mapping relation, interface display, filtering conditions and corresponding help of the interface display and various information of the write-back section, and is also provided with an 'additionally-added function' button, a 'deleting function' button, an 'additionally-added stage' button, an 'additionally-added sub-stage' button, a 'deleting sub-stage' button and a 'cancel' button, an 'edit' button and a 'save' button for operating the interface configuration header data table.
In this embodiment, referring to fig. 3, the workflow of the reusable window is:
receiving an input parameter, wherein the parameter is the number of a report function;
calling corresponding configuration information from a database according to the input parameters, wherein the configuration information is a mapping scheme, a display scheme, a filtering scheme and a write-back scheme of dynamic flow data customized by utilizing an interface configuration function;
after the configuration information is obtained, a filtering scheme and a write-back scheme are executed, and finally, the display is carried out according to a display scheme.
Wherein:
a) After the configuration information is obtained, specific operations of executing the filtering scheme include:
the interface configuration detail data table comprises a field of whether filtering, corresponding help, node type, corresponding name, corresponding field, edit, display sequence, font and color;
according to the fields of filtering or not and corresponding help, using codes to draw the filtering conditions of the filtering area;
the table head and the table body display format of the table are configured according to the node type, the corresponding name, the corresponding field, whether the editing is performed, the display sequence, the font and the color fields, and whether the editing is allowed or not is sequentially performed according to the corresponding relation between the fields of the table and the data source.
B) After the configuration information is acquired, specific operations of executing the write-back scheme include:
acquiring all data tables loaded by data in configuration information, and eliminating repeated data tables;
establishing an association relation through the corresponding bill flow ID and taking a corresponding main table in configuration information as a query main table;
according to the fields of the corresponding table, the corresponding field and the corresponding main key, adding search conditions spliced by the identifiers of the help returns in the filtering area, and finishing the sql splicing of data loading;
in the data write-back process, traversing the data row with the change set, splicing sql of the data to be updated according to the field of 'whether to edit', 'corresponding table or view', 'corresponding table main key', and executing to realize the data write-back.
In summary, the flexible and efficient dynamic data conversion method can be used for implementing personnel to directly configure and call the feedback report or process the flow dynamic data, and provides an information write-back function, so that the development and implementation efficiency is improved, the method is flexible, and the popularization and application value is very good.
The foregoing has outlined rather broadly the principles and embodiments of the present invention in order that the detailed description of the invention may be better understood. Based on the above-mentioned embodiments of the present invention, any improvements and modifications made by those skilled in the art without departing from the principles of the present invention should fall within the scope of the present invention.
Claims (5)
1. A flexible and efficient dynamic data conversion method is characterized in that the method needs to add interface configuration functions and reusable Winform forms in a service module of an ERP system, and the implementation process of the method comprises the following steps:
establishing an interface configuration header and an interface configuration detail data table by utilizing an interface configuration function; the interface configuration header data table is used for distinguishing different flows, and prescribes the ID, name, number and main table of the report function, wherein the number of the report function is used as a parameter to be transmitted into the subsequent display function for distinguishing different business flows and reading different configuration information; the interface configuration detail data table is used for configuring mapping relations of various fields, merging and displaying of table heads, displaying sequence of fields below the table heads, fonts and whether various information is written back or not, the interface configuration detail data table is displayed in a tree form, hierarchical information exists in the interface configuration detail data table, and the interface configuration detail data table comprises a corresponding table or view, a corresponding table field, a corresponding table main key, a table corresponding data stream field and whether editing is carried out; five fields, namely a corresponding table or view, a corresponding table field, a corresponding table main key, a table corresponding data stream field and an editing or not, are used for data loading and data writing back together with a main table field of an interface configuration table header data table;
the mapping scheme, the display scheme, the filtering scheme and the write-back scheme of the dynamic flow data are customized by utilizing the interface configuration function, and meanwhile, the customized mapping scheme, the display scheme, the filtering scheme and the write-back scheme are changed at any time by utilizing the interface configuration function and stored in a database in real time;
filtering, displaying and writing back different flow data by utilizing a user-defined mapping scheme corresponding to different modulation of input parameters by using a reusable Winform window, and specifically comprises the following steps: (1) Receiving an input parameter, wherein the parameter is the number of a report function; (2) Calling corresponding configuration information from a database according to the input parameters, wherein the configuration information is a mapping scheme, a display scheme, a filtering scheme and a write-back scheme of dynamic flow data customized by utilizing an interface configuration function; (3) After the configuration information is obtained, a filtering scheme and a write-back scheme are executed, and finally, the display is carried out according to a display scheme, wherein (3.1) the specific operation of executing the filtering scheme is as follows: the interface configuration detail data table comprises a field of whether filtering, corresponding help, node type, corresponding name, corresponding field, edit, display sequence, font and color; according to the fields of filtering or not and corresponding help, using codes to draw the filtering conditions of the filtering area; configuring the table head and the table body display format of the table and the corresponding relation between the fields of the table and the data source according to the node type, the corresponding name, the corresponding fields, whether the editing is performed, the display sequence, the font and the color fields in sequence, and whether the editing is allowed for the fields; (3.2) the specific operations to perform the write-back scheme are: acquiring all data tables loaded by data in configuration information, and eliminating repeated data tables; establishing an association relation through the corresponding bill flow ID and taking a corresponding main table in configuration information as a query main table; according to the fields of the corresponding table, the corresponding field and the corresponding main key, adding search conditions spliced by the identifiers of the help returns in the filtering area, and finishing the sql splicing of data loading; in the data write-back process, traversing the data row with the change set, splicing sql of the data to be updated according to the field of 'whether to edit', 'corresponding table or view', 'corresponding table main key', and executing to realize the data write-back.
2. The flexible and efficient dynamic data conversion method according to claim 1, wherein the interface configuration detail data table is further used for configuring various information of condition styles, message reminders and tasks to be handled displayed under different processes.
3. The flexible and efficient dynamic data conversion method according to claim 1, wherein said interface configuration detail data table is further used for adding description fields, said description fields including font and color of header, font and color of table body data, and conditional style of data satisfying certain conditions.
4. The flexible and efficient dynamic data conversion method according to claim 1, wherein the interface configuration detail data table is further used for adding a permission field, and the data to be read is filtered according to the permission field added by the operator.
5. The flexible and efficient dynamic data conversion method according to claim 1, wherein the interface configuration header and the interface configuration detail are constructed as a left-list right-tree-shaped flow tracking configuration interface by using an interface configuration function, the flow tracking configuration interface directly displays and maintains different flow functions and multi-level header display, data mapping relation, interface display, filtering conditions and corresponding help of each function, and each item of information of a write-back word, and the flow tracking configuration interface is also provided with a new function button, a delete function button, a new level button, a delete level button, a cancel button, an edit button and a save button for operating the interface configuration header data table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010213297.5A CN111444251B (en) | 2020-03-24 | 2020-03-24 | Flexible and efficient dynamic data conversion method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010213297.5A CN111444251B (en) | 2020-03-24 | 2020-03-24 | Flexible and efficient dynamic data conversion method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111444251A CN111444251A (en) | 2020-07-24 |
| CN111444251B true CN111444251B (en) | 2023-10-13 |
Family
ID=71629433
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010213297.5A Active CN111444251B (en) | 2020-03-24 | 2020-03-24 | Flexible and efficient dynamic data conversion method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111444251B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN102866985A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data formatting device and method for on-line analytical processing system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040133606A1 (en) * | 2003-01-02 | 2004-07-08 | Z-Force Communications, Inc. | Directory aggregation for files distributed over a plurality of servers in a switched file system |
| US20130198243A1 (en) * | 2010-03-29 | 2013-08-01 | Brien Robert Givens | System and method for dynamically generating a gui according to table relationships in a database |
-
2020
- 2020-03-24 CN CN202010213297.5A patent/CN111444251B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN102866985A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data formatting device and method for on-line analytical processing system |
Non-Patent Citations (1)
| Title |
|---|
| 闫冬 ; 张晖 ; 余军 ; 何云峰 ; 于俊清 ; 唐九飞 ; .火力发电企业燃料信息报表自定义系统.电力信息与通信技术.2017,(04),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111444251A (en) | 2020-07-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10733193B2 (en) | Similar document identification using artificial intelligence | |
| Scheer | Business process engineering: reference models for industrial enterprises | |
| CN101916244B (en) | Method and system for filter and sort by format | |
| US11196695B2 (en) | Document manager integration | |
| US20070185835A1 (en) | Identifying and/or extracting data in connection with creating or updating a record in a database | |
| WO2014070037A1 (en) | Automated report generation method | |
| US20100241610A1 (en) | Methods and systems for preserving and accessing information related to decision-making | |
| CN107578217B (en) | Working electronic flow autonomous generation method and device and office management system | |
| CN111143370B (en) | Method, apparatus and computer-readable storage medium for analyzing relationships between a plurality of data tables | |
| CN110362596A (en) | A kind of control method and device of text Extracting Information structural data processing | |
| CN112667209A (en) | Flow component system for realizing full-connection rapid development framework based on computer software | |
| CN105630759A (en) | Data reference device and method | |
| CN112540988A (en) | Service processing device, processing method and readable storage medium | |
| CN111444251B (en) | Flexible and efficient dynamic data conversion method | |
| CN116401407A (en) | Node attribute configuration method, device, equipment and storage medium of mind map | |
| CN108766513B (en) | Intelligent health medical data structured processing system | |
| US20090024424A1 (en) | System and method for dynamic linking of business processes | |
| CN112395371B (en) | Financial institution asset classification processing method, device and readable medium | |
| CN113537943A (en) | Universal workflow engine and construction method thereof | |
| US20200320250A1 (en) | Systems and Methods for Generating Logical Documents for a Document Evaluation System | |
| CN102045426A (en) | Mobile terminal and method for editing contact information thereof | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN107729305B (en) | Automatic conference material generation method based on database and front-end display technology | |
| Krause et al. | The code system of a systematic literature review on pre-requirements specification traceability | |
| US10776399B1 (en) | Document classification prediction and content analytics using artificial intelligence |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230911 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |