Method and system for linkage updating of fields between electronic forms, medium and electronic equipment

Abstract

The invention discloses a method and system for linkage updating of fields between electronic forms, a medium and electronic equipment, and relates to the technical field of ERP systems.The method comprises the steps that in the configuration step, a linkage updating configuration table is configured in advance, and the linkage updating configuration table comprises the mapping relation and updating rules of associated fields between a source electronic form and a target electronic form; a triggering step: when the operation type is newly added storage, modified storage or audit, executing an updating step; if so, executing a backspacing step; an updating step: generating an updating SQL statement for the target electronic form field, executing the updating SQL statement, and recording an updating operation log; and a rollback step: searching a rollback operation SQL statement for the target electronic form field, executing the rollback SQL statement, restoring the value of the target electronic form field, and recording a rollback operation log. According to the method and the device, updating of related fields of the target form can be triggered automatically according to field changes of the source form, so that the accuracy and the efficiency of data processing are improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of ERP systems, and in particular relates to a method, system, medium and electronic equipment for linking and updating fields between electronic forms. Background Art

[0002] In information systems or ERP (Enterprise Resource Planning) systems, as business complexity increases, data association and consistency maintenance between different electronic forms have become important requirements. The traditional manual update method is not only inefficient, but also prone to errors. The field association operation between related electronic forms has become part of the actual business needs. This means that in the business process, when certain fields on one electronic form change, the related fields of another or more electronic forms should be automatically updated to maintain data consistency. At present, the existing technology has not yet disclosed the technical content to solve this problem. Summary of the invention

[0003] To this end, the technical problem to be solved by the present invention is to provide a method, system, medium and electronic device for linkage updating of fields between electronic forms, aiming to automatically trigger the update of relevant fields of the target form according to changes in the source form fields, so as to improve the accuracy and efficiency of data processing.

[0004] In a first aspect, the present invention discloses a method for linking and updating fields between electronic forms, comprising: A configuration step of pre-configuring a linkage update configuration table, wherein the linkage update configuration table includes a mapping relationship and an update rule between associated fields between a source electronic form and a target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated; The triggering step is, when an operation is performed on the associated field of the source electronic form, finding the name of the source electronic form and the operation type of the associated field of the source electronic form according to the context of the operation, obtaining the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and finding the target electronic form; Setting a triggering time, wherein the triggering time includes: when the operation type is to add and save, modify and save, or review, executing the update step; when the operation type is to abandon review or delete, executing the rollback step; An updating step, generating an updating SQL statement for the target electronic form field according to the updating rule, executing the updating SQL statement, and recording an updating operation log; The rollback step is to search for a rollback SQL statement for the target electronic form field, execute the rollback SQL statement, restore the value of the target electronic form field, and record a rollback operation log.

[0005] Furthermore, the mapping relationship in the configuration step includes: The source electronic form header field is mapped to the target electronic form header field; The source electronic form header fields are mapped to the target electronic form detail fields; The source electronic form detail fields are mapped to the target electronic form detail fields.

[0006] Furthermore, in the configuration step, the source electronic form is a native electronic form or a custom electronic form; the target electronic form is a native electronic form or a custom electronic form; The mapping relationship includes: Native electronic form header fields are mapped to native electronic form header fields; The native electronic form header fields are mapped to the native electronic form detail fields; Native electronic form detail fields are mapped to native electronic form detail fields; Native electronic form header fields are mapped to custom electronic form header fields; The native electronic form header fields are mapped to the custom electronic form detail fields; Native electronic form detail fields are mapped to custom electronic form detail fields; Customized electronic form header fields are mapped to customized electronic form header fields; The custom electronic form header fields are mapped to the custom electronic form detail fields; Customized electronic form detail fields are mapped to customized electronic form detail fields; Customized electronic form header fields are mapped to native electronic form header fields; Customized electronic form header fields are mapped to native electronic form detail fields; Customized spreadsheet detail fields are mapped to native spreadsheet detail fields.

[0007] Furthermore, the new header fields of the native electronic form are added through a third-party platform or tool.

[0008] Furthermore, the update rule in the configuration step includes addition, subtraction or assignment.

[0009] Furthermore, in the updating step, generating an update SQL statement for the target electronic form field includes: concatenating an SQL statement for updating the target electronic form field and an SQL statement for rolling back the inverse operation of the update operation, and persisting them in a database for tracing the update operation process.

[0010] Furthermore, the linkage update configuration table and the triggering timing are pre-configured in a script on a codeless development platform, and then the script is installed into the system.

[0011] In a second aspect, the present invention further provides a system for linking and updating fields between electronic forms, comprising: A configuration module pre-configures a linkage update configuration table, wherein the linkage update configuration table includes a mapping relationship and an update rule between associated fields between a source electronic form and a target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated; The trigger module, when operating the associated fields of the source electronic form, finds the source electronic form name and the operation type of the associated fields of the source electronic form according to the context of the operation, obtains the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and finds the target electronic form; Setting a triggering time, wherein the triggering time includes: when the operation type is to add and save, modify and save, or review, executing the update step; when the operation type is to abandon review or delete, executing the rollback step; An update module, which generates an update SQL statement for the target electronic form field according to the update rule, executes the update SQL statement, and records an update operation log; The rollback module searches for a rollback SQL statement for the target electronic form field, executes the rollback SQL statement, restores the value of the target electronic form field, and records a rollback operation log.

[0012] In a third aspect, the present invention further discloses a computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the aforementioned method for linking and updating fields between electronic forms.

[0013] In a fourth aspect, the present invention further discloses an electronic device, comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and can be run on the processor, and when the processor executes the computer program, the method for linking and updating fields between electronic forms is implemented.

[0014] Beneficial effects: The present invention discloses a method, system, medium and electronic device for linking and updating fields between electronic forms, which realizes automatic updating and rollback of fields between electronic forms by configuring field mapping relationships, operation rules and condition ranges between different electronic forms, thereby improving the accuracy and efficiency of data processing and reducing errors caused by manual updating. The present invention can be flexibly configured to meet the needs of different business scenarios; By persisting the linkage update and reverse operations, the process of linkage update data changes can be traced; The code-free development platform reduces development costs and maintenance difficulties; Support multiple electronic form types to improve the compatibility and scalability of the system. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 A flow chart of a method for linking and updating fields between electronic forms of the present invention; Figure 2 This is a flowchart of the update operation of Embodiment 1 of the present invention; Figure 3 This is a rollback operation flow chart of Example 1 of the present invention. DETAILED DESCRIPTION

[0016] The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments. The principles and features of the present invention are described below in combination with the accompanying drawings. It should be noted that the embodiments in this application and the features in the embodiments can be combined with each other without conflict. The embodiments are only used to explain the present invention and are not used to limit the scope of the present invention.

[0017] In information systems or ERP systems, as business complexity increases, data association and consistency maintenance between different electronic forms have become important requirements. The traditional manual update method is not only inefficient but also prone to errors. Therefore, a method and system is needed that can automatically trigger the update of relevant fields of the target form according to the changes in the source form fields to improve the accuracy and efficiency of data processing.

[0018] The present invention aims to provide a method and system for linking and updating fields between electronic forms, which realizes automatic updating and rollback of fields between electronic forms by configuring field mapping relationships, operation rules and condition ranges between different electronic forms, thereby ensuring the consistency and accuracy of data.

[0019] Example 1 like Figure 1 As shown, the present invention discloses a method for linking and updating fields between electronic forms, comprising the following steps: The configuration step allows customers to specify the association and associated fields between different electronic forms by pre-configuring the linkage update configuration table. The linkage update configuration table includes the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated.

[0020] The triggering step is to find the source electronic form name and the source electronic form associated field operation type according to the context of the operation, obtain the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and find the target electronic form when operating the associated fields of the source electronic form.

[0021] Set the trigger timing to specify the conditions under which the target electronic form must meet to perform the corresponding operation. The trigger timing includes: when the operation type is new save, modified save or review, execute the update step; when it is abandoned or deleted, execute the rollback step.

[0022] Update step: In this embodiment, the linked update occurs on the server side. According to the update rule, an update SQL statement for the target electronic form field is generated, the update SQL statement is executed, and the update operation log is recorded. Figure 2 .

[0023] Rollback step: according to the current electronic form information, find the SQL statement for rolling back the target electronic form field, execute the rollback SQL statement, restore the value of the target electronic form field, so that the data can be rolled back to the state before the update, and then record the rollback operation log, see Figure 3 .

[0024] In a specific implementation, the mapping relationship between the two electronic forms in the configuration step includes: The source electronic form header fields are mapped to the target electronic form header fields; The source electronic form header fields are mapped to the target electronic form detail fields; The source spreadsheet detail fields are mapped to the target spreadsheet detail fields.

[0025] The linkage rule settings support the following mappings: Native electronic forms (new fields added through third-party platforms or tools) are mapped to native electronic forms (new fields added through third-party platforms or tools); Native electronic forms (new fields added through third-party platforms or tools) are mapped to custom electronic forms; Custom electronic forms are mapped to custom electronic forms; Customized electronic forms to native electronic forms (new fields added through third-party platforms or tools); Customized electronic form to native electronic form, the customized electronic form header fields are mapped to the native electronic form header fields; Customized electronic forms are converted to native electronic forms, and the custom electronic form detail fields are mapped to the native document detail fields.

[0026] Preferably, if Figure 2As shown, in the update step, the generation of the update SQL statement for the target electronic form field is achieved by the following steps: splicing the SQL statement for updating the target electronic form field and the SQL statement for rolling back the inverse operation of the update operation, persisting them in the database, and the update operation process can be traced back through these stored SQL statements. In addition, before updating, the value of the target document field is saved in the cache.

[0027] In specific implementation, the linkage update configuration table and trigger timing can be pre-configured in the script on the codeless development platform, and then the script can be installed in the current system.

[0028] This method has been used in reality and can support multiple electronic form types: native electronic forms (new fields added through third-party platforms or tools) and custom electronic forms.

[0029] Example 2 The present invention also provides a system for linking and updating fields between electronic forms, comprising: A configuration step, pre-configuring a linkage update configuration table, wherein the linkage update configuration table includes a mapping relationship and an update rule of associated fields between a source electronic form and a target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated; The triggering step is to find the source electronic form name and the source electronic form associated field operation type according to the operation context when the associated field of the source electronic form is operated, obtain the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and find the target electronic form; Set the trigger timing. The trigger timing includes: when the operation type is to add and save, modify and save, or review, execute the update step; when the operation type is to abandon the review or delete, execute the rollback step; An update step, generating an update SQL statement for the target electronic form field according to the update rule, executing the update SQL statement, and recording the update operation log; The rollback step is to find the SQL statement for the rollback operation on the target electronic form field, execute the rollback SQL statement, restore the value of the target electronic form field, and record the rollback operation log.

[0030] Example 3 The present invention also provides a computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the method for linking and updating fields between electronic forms.

[0031] Example 4 The present invention also provides an electronic device, including a memory, a processor and a computer program. The computer program is stored in the memory and can be run on the processor. When the processor executes the computer program, the method for linking and updating fields between electronic forms is implemented.

[0032] Obviously, the above embodiments are merely examples for the purpose of clear explanation, and are not intended to limit the implementation methods. For those skilled in the art, other different forms of changes or modifications can be made based on the above description. It is not necessary and impossible to list all the implementation methods here. The obvious changes or modifications derived therefrom are still within the scope of protection of the invention.

Claims

1. A method for updating fields in electronic forms in a linked manner, characterized in that: include: A configuration step of pre-configuring a linkage update configuration table, wherein the linkage update configuration table includes a mapping relationship and an update rule between associated fields between a source electronic form and a target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated; The triggering step is, when an operation is performed on the associated field of the source electronic form, finding the name of the source electronic form and the operation type of the associated field of the source electronic form according to the context of the operation, obtaining the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and finding the target electronic form; Setting a triggering time, wherein the triggering time includes: when the operation type is to add and save, modify and save, or review, executing the update step; when the operation type is to abandon review or delete, executing the rollback step; An updating step, generating an updating SQL statement for the target electronic form field according to the updating rule, executing the updating SQL statement, and recording an updating operation log; The rollback step is to find a rollback SQL statement for the target electronic form field, execute the rollback SQL statement, restore the value of the target electronic form field, and record a rollback operation log.

2. The method according to claim 1, characterized in that The mapping relationship in the configuration step includes: The source electronic form header field is mapped to the target electronic form header field; The source electronic form header fields are mapped to the target electronic form detail fields; The source electronic form detail fields are mapped to the target electronic form detail fields.

3. The method according to claim 2, characterized in that In the configuration step, the source electronic form is a native electronic form or a custom electronic form; the target electronic form is a native electronic form or a custom electronic form; The mapping relationship includes: Native electronic form header fields are mapped to native electronic form header fields; The native electronic form header fields are mapped to the native electronic form detail fields; Native electronic form detail fields are mapped to native electronic form detail fields; Native electronic form header fields are mapped to custom electronic form header fields; The native electronic form header fields are mapped to the custom electronic form detail fields; Native electronic form detail fields are mapped to custom electronic form detail fields; Customized electronic form header fields are mapped to customized electronic form header fields; The custom electronic form header fields are mapped to the custom electronic form detail fields; Customized electronic form detail fields are mapped to customized electronic form detail fields; Customized electronic form header fields are mapped to native electronic form header fields; Customized electronic form header fields are mapped to native electronic form detail fields; Customized spreadsheet detail fields are mapped to native spreadsheet detail fields.

4. The method according to claim 3, characterized in that: The new header fields of the native electronic form are added through a third-party platform or tool.

5. The method according to claim 1, characterized in that The updating rule in the configuring step includes accumulation, decrement or assignment.

6. The method according to claim 1, characterized in that In the updating step, generating an update SQL statement for the target electronic form field includes: concatenating an SQL statement for updating the target electronic form field and an SQL statement for rolling back the inverse operation of the update operation, and persisting them in a database for tracing the update operation process.

7. The method according to claim 1, characterized in that The linkage update configuration table and the trigger timing are pre-configured in a script on a codeless development platform, and then the script is installed into the system.

8. A system for updating fields in electronic forms in a linked manner, characterized in that: include: A configuration module pre-configures a linkage update configuration table, wherein the linkage update configuration table includes a mapping relationship and an update rule between associated fields between a source electronic form and a target electronic form; the source electronic form is the electronic form currently being operated, and the target electronic form is the target electronic form to be updated; The trigger module, when operating the associated fields of the source electronic form, finds the source electronic form name and the operation type of the associated fields of the source electronic form according to the context of the operation, obtains the mapping relationship and update rules of the associated fields between the source electronic form and the target electronic form from the linkage update configuration table, and finds the target electronic form; Setting a triggering time, wherein the triggering time includes: when the operation type is to add and save, modify and save, or review, executing the update step; when the operation type is to abandon review or delete, executing the rollback step; An update module, which generates an update SQL statement for the target electronic form field according to the update rule, executes the update SQL statement, and records an update operation log; The rollback module searches for a rollback SQL statement for the target electronic form field, executes the rollback SQL statement, restores the value of the target electronic form field, and records a rollback operation log.

9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method for linking and updating fields between electronic forms according to any one of claims 1 to 7 is implemented.

10. An electronic device comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and can be run on the processor, wherein: When the processor executes the computer program, the method for linking and updating fields between electronic forms as claimed in any one of claims 1 to 7 is implemented.

Images