Form member replacement method and device, equipment and storage medium

Abstract

The present application relates to the field of research and development management, and discloses a form member replacement method, device, equipment and storage medium, the method comprises the following steps: based on the form member replacement request issued by the upstream system, the state table in the relational database is updated, wherein the member information of the form member to be replaced is included in the form member replacement request; when the state table is updated, the data monitoring task is triggered, the schema of the corresponding application program is acquired, and the relational database corresponding to the application program is logged in through the schema; the preset form member replacement script is called and run, and the member information is input into the form member replacement script as a parameter, and the form member in the relational database is replaced through the form member replacement script; after the form member replacement is completed, the form of the replaced form member is updated on the corresponding front-end page. The present application can replace the script, and subsequent replacement member information only needs to be updated in the script, without manual editing of the form.

Description

Technical Field

[0001] The present invention relates to the field of research and development management, and in particular to a form member replacement method, device, equipment and storage medium. Background Art

[0002] With the continuous growth of the economy, some companies are expanding in size and employing more and more employees. To strengthen the comprehensive assessment of employee performance, objectively and impartially evaluate their work performance and effectiveness, and further enhance their awareness of efficiency, competition, risk, and cooperation, different banks use different performance indicators for employee performance appraisals. Traditionally, manual performance evaluations have many shortcomings due to the large amount of information, dispersion, and variety, and are not effectively utilized and communicated. Therefore, some large companies use enterprise performance management software, such as Hyperion, for performance management.

[0003] Currently, during Hyperion system operation and maintenance, if you encounter a scenario where you need to replace members in a form in the Hyperion system, there are two ways to handle this: one is to replace the members by editing the form. The operation process is as follows: after logging in to the system with an administrator account, enter the workspace, click the form to be replaced, right-click to edit, or click the page edit button to enter the edit page, find the dimension members to be replaced, then replace them and save. The other is to replace the members by exporting the form to an XML file. The operation process is as follows: after logging in to the system with an administrator account, enter sharedservice, export the form whose members need to be replaced as an XML file, then open it with a text editor, replace the members, save the file, and then import it into the system.

[0004] The above two operation methods are standard operations in the industry. However, they have the following disadvantages in scenarios where large-scale adjustments are required: 1. Adjustments need to be made form by form, which can easily lead to omissions; 2. The operation process is purely manual, which can easily lead to manual errors; 3. The workload is large, wasting developer time. Summary of the Invention

[0005] The main purpose of the present invention is to solve the technical problem of low efficiency of member replacement in a form in existing enterprise performance management software.

[0006] The first aspect of the present application provides a form member replacement method, comprising: obtaining a form member replacement request issued by an upstream system, wherein the form member replacement request includes member information of a form member to be replaced; updating a state table in a relational database based on the form member replacement request; triggering a data monitoring task when the state table is updated, obtaining a schema of a corresponding application, and logging into a relational database corresponding to the application through the schema; calling and running a preset form member replacement script, and inputting the member information as a parameter into the form member replacement script, replacing a form member in the relational database through the form member replacement script; and performing a commit operation to update a page of a form with a replaced form member in a corresponding front-end page after the form member replacement is completed.

[0007] Optionally, in the first implementation manner of the first aspect of the present application, the updating the state table in the relational database based on the form member replacement request comprises: generating a corresponding state parameter based on the form member replacement request; identifying a form member corresponding to the form member replacement request in the state table based on the member information; and storing the state parameter in a corresponding position of the form member in the state table.

[0008] Optionally, in the second implementation manner of the first aspect of the present application, the calling and running the preset form member replacement script, inputting the member information as a parameter into the form member replacement script, and replacing the form member in the relational database through the form member replacement script comprises: calling and running the preset form member replacement script, calling a first two-dimensional table and a second two-dimensional table of the relational database through the form member replacement script, wherein the first two-dimensional table records an internal identification master id of a form member in the relational database, and the second two-dimensional table records a dimension value relationship in the relational database; querying a corresponding internal identification master id in the first two-dimensional table according to the member information; querying a corresponding dimension value relationship in the second two-dimensional table based on the internal identification master id corresponding to the member information; querying record data contained by each form in the relational database based on the dimension value relationship; and replacing the form member in the relational database according to the record data and the member information.

[0009] Optionally, in a third implementation form of the first aspect of the present application, the page updating of the form corresponding to the replaced form member on the front-end page after the commit operation is performed and the form corresponding to the replaced form member is updated on the front-end page comprises: after the commit operation is performed and the form corresponding to the replaced form member is updated on the front-end page, calling the component node form parameter rule saved by the front-end page and sending an asynchronous network request to the back-end; and after the asynchronous network request is successful, updating and rendering the form parameter of the component node of the front-end page based on the form corresponding to the replaced form member.

[0010] Optionally, in a fourth implementation form of the first aspect of the present application, the updating and rendering of the form parameter of the component node of the front-end page based on the form corresponding to the replaced form member comprises: generating a form rendering request based on the form corresponding to the replaced form member, wherein the form rendering request comprises the form parameter of the form corresponding to the replaced form member; sending the form rendering request to the front-end page, determining the form type of the form corresponding to the replaced form member through the front-end page, and determining the form logic corresponding to the form type based on the pre-stored correspondence between the form logic and the form type; and updating and rendering the form parameter of the component node of the front-end page based on the form logic.

[0011] Optionally, in a fifth implementation form of the first aspect of the present application, after the commit operation is performed and the form corresponding to the replaced form member is updated on the front-end page, the method further comprises: obtaining form data in the front-end page, wherein the form data is configured with a current data format; calling a front-end verification file to verify the current data format against a preset data format in the front-end verification file; and if the verification fails, converting the current data format into the preset data format in the front-end verification file.

[0012] The second aspect of the present application provides a form member replacement device, comprising: a request obtaining module, configured to obtain a form member replacement request sent by an upstream system, wherein the form member replacement request comprises member information of a form member to be replaced; a state updating module, configured to update a state table in a relational database based on the form member replacement request; a database login module, configured to trigger a data monitoring task when the state table is updated, obtain a schema of a corresponding application program, and log into a relational database corresponding to the application program through the schema; a member replacement module, configured to call and run a preset form member replacement script, input the member information into the form member replacement script as a parameter, and replace a form member in the relational database through the form member replacement script; and a page updating module, configured to perform a commit operation after the form member is replaced, and update a page of a front-end page corresponding to the form of the replaced form member.

[0013] Optionally, in the first implementation manner of the second aspect of the present application, the state updating module is specifically configured to: generate a corresponding state parameter based on the form member replacement request; identify a form member corresponding to the form member replacement request in the state table based on the member information; and store the state parameter in a corresponding position of the form member in the state table.

[0014] Optionally, in the second implementation manner of the second aspect of the present application, the member replacement module is specifically configured to: call and run a preset form member replacement script, and call a first two-dimensional table and a second two-dimensional table of the relational database through the form member replacement script, wherein the first two-dimensional table records internal identification master ids of form members in the relational database, and the second two-dimensional table records dimension value relationships of forms in the relational database; query a corresponding internal identification master id in the first two-dimensional table according to the member information; query a corresponding dimension value relationship in the second two-dimensional table based on the internal identification master id corresponding to the member information; query record data contained in each form in the relational database based on the dimension value relationship; and replace form members in the relational database according to the record data and the member information.

[0015] Optionally, in the third implementation manner of the second aspect of the present application, the page updating module specifically comprises: a calling unit configured to, after the form member replacement is completed, perform a commit operation, call form parameter rules of component nodes encapsulated and saved by the front-end page, and send an asynchronous network request to the back-end; and a page rendering unit configured to, after the asynchronous network request is successful, update and render form parameters of component nodes of the front-end page based on a form of the replaced form member.

[0016] Optionally, in the fourth implementation manner of the second aspect of the present application, the page rendering unit is specifically configured to: generate a form rendering request based on a form of the replaced form member, wherein the form rendering request comprises form parameters of the form of the replaced form member; send the form rendering request to the front-end page, determine a form type of the form of the replaced form member through the front-end page, determine form logic corresponding to the form type based on a corresponding relationship between form logic and form types stored in advance, and update and render form parameters of component nodes in the front-end page based on the form logic.

[0017] Optionally, in a fifth implementation form of the second aspect of the present application, the form member replacement device further comprises a verification module, which specifically comprises: obtaining form data in the front-end page, the form data being configured with a current data format; calling a front-end verification file to verify the current data format against a preset data format in the front-end verification file; and if the verification fails, converting the current data format into the preset data format in the front-end verification file.

[0018] The third aspect of the present application provides a form member replacement device, comprising: a memory and at least one processor, the memory storing instructions, and the memory and the at least one processor being interconnected by a circuit; the at least one processor invoking the instructions in the memory to enable the form member replacement device to perform the steps of the form member replacement method described above.

[0019] The fourth aspect of the present application provides a computer-readable storage medium storing instructions, which, when executed on a computer, enable the computer to perform the steps of the form member replacement method described above.

[0020] In the technical solution of the present application, a form member replacement request is obtained from an upstream system, wherein the form member replacement request includes member information of a form member to be replaced; a state table in a relational database is updated based on the form member replacement request; when the state table is updated, a data monitoring task is triggered to obtain a schema of a corresponding application program, and the relational database corresponding to the application program is logged in through the schema; a preset form member replacement script is invoked and run, and the member information is input into the form member replacement script as a parameter, so that the form member in the relational database is replaced through the form member replacement script; after the form member replacement is completed, a commit operation is performed to update the corresponding front-end page of the form of the replaced form member. After the script is fixed, the method only needs to update the replaced former member and the replaced latter member in the script and execute in the database, without manual editing of the form and without checking one by one, and meanwhile, the accuracy of the form member replacement is high. BRIEF DESCRIPTION OF DRAWINGS

[0021] Figure 1 The first embodiment of the form member replacement method in the embodiments of the present application is shown in the figure;

[0022] Figure 2 The second embodiment of the form member replacement method in the embodiments of the present application is shown in the figure;

[0023] Figure 3Schematic diagram of a third embodiment of the form member replacement method according to an embodiment of the present invention;

[0024] Figure 4 Schematic diagram of a fourth embodiment of a form member replacement method according to an embodiment of the present invention;

[0025] Figure 5 A schematic diagram of an embodiment of a form member replacement device according to an embodiment of the present invention;

[0026] Figure 6 A schematic diagram of another embodiment of a form member replacement device according to an embodiment of the present invention;

[0027] Figure 7 This is a schematic diagram of an embodiment of a form member replacement device in an embodiment of the present invention. DETAILED DESCRIPTION

[0028] In the technical solution of the present invention, a form member replacement request is obtained from an upstream system, wherein the form member replacement request includes member information of the form member to be replaced; based on the form member replacement request, a status table in a relational database is updated; when the status table update is completed, a data monitoring task is triggered, a schema for creating a corresponding application is obtained, and the relational database corresponding to the application is logged in through the schema; a preset form member replacement script is called and run, and the member information is input as a parameter into the form member replacement script, and the form members in the relational database are replaced through the form member replacement script; after the form member replacement is completed, a commit operation is executed, and the form with the replaced form member is updated on the corresponding front-end page. After the dimension value member replacement script is solidified, if there is a need to replace members later, it is only necessary to update the pre-replacement member and the post-replacement member in the script and execute it in the database, without the need to manually edit the form or check each one. At the same time, the accuracy of form member replacement is high.

[0029] The terms "first," "second," "third," "fourth," and the like (if any) in the description and claims of the present invention and in the accompanying drawings are used to distinguish similar objects and are not necessarily used to describe a particular order or precedence. It should be understood that the terms used in this manner are interchangeable where appropriate so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" or "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product, or apparatus that includes a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units that are not explicitly listed or that are inherent to these processes, methods, products, or apparatus.

[0030] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 The first embodiment of the form member replacement method in the embodiment of the present invention includes:

[0031] 101. Obtain a form member replacement request issued by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced;

[0032] It is understandable that the execution subject of the present invention can be a form member replacement device, or a terminal or a server, which is not limited here. The embodiment of the present invention is described by taking a server as the execution subject as an example. The server can be an independent server, or it can be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDNs), and big data and artificial intelligence platforms.

[0033] In actual applications, when using enterprise performance management software, it is necessary to collect data from different upstream systems for aggregation, calculate enterprise performance, and apply it to tables during use. Generally, electronic forms contain multiple controls, and there may be arithmetic operations between multiple controls. When certain data in the upstream system changes, the form members in the form of the enterprise performance management software need to be updated. At this time, the upstream system issues a form member replacement request to replace the form members, wherein the form member replacement request includes the form members that need to be replaced and the content of the form member replacement.

[0034] 102. Based on the form member replacement request, update the state table in the relational database;

[0035] In this embodiment, the form member replacement request includes the members and content that need to be replaced, including the members before replacement and the members after replacement. The status table refers to a table used to record the processing status corresponding to the form members stored in a relational database, such as a temporary table of Oracle. Each form member has a corresponding status parameter. The status parameter refers to a parameter that describes the processing status corresponding to each form member. The processing status includes four status parameters: pending status, processing status, successful processing status, and failed processing status. In this embodiment, in order to facilitate the identification of different processing statuses, the status parameter is used to represent the corresponding processing status, specifically: 0 corresponds to the pending status, 1 corresponds to the processing status, 2 corresponds to the successful processing status, and 3 corresponds to the failed processing status. Specifically, the status parameter corresponding to each form member stored in the big data management platform is pending, that is, it corresponds to the status parameter 0. When a form member is obtained, its corresponding processing status is the pending status, and the status parameter in the status table is set to 0; when the form member is replaced, its corresponding processing status is the processing status, so that the status parameter in the status table is changed to 1; and according to whether the processing is successful or not, it can be determined whether it corresponds to the processing success status or the processing failure status, so as to determine whether the status parameter in the status table is 2 or 3.

[0036] 103. When the status table is updated, the data monitoring task is triggered to obtain the schema for creating the corresponding application and log in to the relational database corresponding to the application through the schema.

[0037] In practical applications, a schema is the organization and structure of a database. A schema contains schema objects, which can be tables, columns, data types, views, stored procedures, relationships, primary keys, foreign keys, etc. A database schema can be represented by a visual diagram that shows the database objects and their relationships with each other.

[0038] In practical applications, a relational database is a database built on the basis of a relational database model, which processes data in the database by means of concepts and methods such as set algebra, and is also organized into a set of tables with formal descriptions. The essence of the form of the table is to load special collections of data items, and the data in the table can be accessed or recalled in many different ways without reorganizing the database table. The definition of a relational database causes a table of metadata or a formal description of tables, columns, ranges, and constraints. Each table (sometimes referred to as a relationship) contains one or more data categories represented by columns. Each row contains a unique data entity, and the data is the category defined by the column. The mainstream relational databases include oracle, db2, sqlserver, sybase, mysql, etc.

[0039] 104. The preset form member replacement script is called and run, and the member information is input as a parameter into the form member replacement script to replace the form member in the relational database through the form member replacement script;

[0040] In the embodiment, for the form of Hyperion, the ID, name, folder relationship, dimension value relationship in the form, relationship between the form and the dimension, relationship between the form and the business rule, and permission of the form are involved. Therefore, for the form corresponding to a specific dimension value, the form can be replaced in the form of a relational database command, only the dimension value before replacement and the dimension value after replacement need to be specified, and then the commit operation is performed. Based on the principle, the update script for performing the dimension value replacement is generated in advance, after logging in the relational database corresponding to the application program, the script is directly called, and the member information is input as a parameter into the script. The script directly finds the form member in the relational database to perform the replacement operation.

[0041] 105. After the form member replacement is completed, the commit operation is performed to update the page of the form corresponding to the replaced form member in the front end.

[0042] In practical applications, the COMMIT command is used to save the modifications made by the transaction to the database, and all transactions after the last COMMIT or ROLLBACK command are saved to the database. All modifications are first sent to the temporary rollback area, and if the temporary rollback area has no space, the modifications made to the database cannot be saved, and the database may be suspended, and further transaction operations are prohibited.

[0043] In the embodiment, after the commit operation is executed, the result of the form member replacement is saved to the database, and the form with the replaced form member is read from the database to update and render the front-end page (including a web page and a smartview page), so that the form update effect can be seen on the front-end page.

[0044] In the embodiment, a form member replacement request is acquired, wherein the form member replacement request includes member information of a form member to be replaced; a state table in a relational database is updated based on the form member replacement request; when the state table is updated, a data monitoring task is triggered to acquire a schema of a corresponding application program, and the relational database corresponding to the application program is logged in through the schema; a preset form member replacement script is called and run, and the member information is input into the form member replacement script as a parameter, so that the form member in the relational database is replaced through the form member replacement script; after the form member replacement is completed, a commit operation is performed to update the page of the form with the replaced form member on the corresponding front-end page. After the script is fixed through the value member replacement script, the subsequent demand for replacing the member can be met by only updating the pre-replacement member and the post-replacement member in the script and executing in the database, without manually editing the form and checking one by one. Meanwhile, the form member replacement has high accuracy.

[0045] Referring to Figure 2 The second embodiment of the form member replacement method in the embodiment includes the following steps.

[0046] 201. A form member replacement request issued by an upstream system is acquired, wherein the form member replacement request includes member information of a form member to be replaced.

[0047] 202. A corresponding state parameter is generated based on the form member replacement request.

[0048] In the embodiment, in order to facilitate identification of different processing states, the state parameter is used to represent the corresponding processing state, specifically: 0 corresponds to a to-be-processed state, 1 corresponds to a processing state, 2 corresponds to a processing success state, and 3 corresponds to a processing failure state.

[0049] 203. A form member corresponding to the form member replacement request in the state table is identified based on the member information.

[0050] In the embodiment, when the form member is acquired, the corresponding processing state is the to-be-processed state, the state parameter in the state table is set to 0, when the replacement processing of the form member is started, the corresponding processing state is the processing state, so that the state parameter in the state table is changed to 1; and whether the processing is successful or not, the corresponding processing state is determined to be the processing success state or the processing failure state, so that the state parameter in the state table is determined to be 2 or 3.

[0051] 204, storing the state parameter in the corresponding position of the form member in the state table;

[0052] In the embodiment, since there are multiple form members that need to be replaced in the form member request, the replacement of the form members may succeed in part and fail in part, the replacement of the form members can be judged in real time by reading the state parameter stored in the state table in real time, and the replacement of the form members is identified by the state parameter after the replacement fails, and the replacement of the form members is performed again.

[0053] 205, when the state table is updated, triggering the data monitoring task, acquiring the schema of the corresponding application program, and logging in the relational database corresponding to the application program through the schema;

[0054] 206, calling and running the preset form member replacement script, inputting the member information as a parameter into the form member replacement script, and replacing the form member in the relational database through the form member replacement script;

[0055] 207, after the replacement of the form member is completed, performing a commit operation, and updating the page of the form in which the form member is replaced in the corresponding front-end page.

[0056] The embodiment based on the previous embodiment describes in detail the process of updating the state table in the relational database based on the form member replacement request, generating the corresponding state parameter based on the form member replacement request, identifying the form member corresponding to the form member replacement request in the state table based on the member information, and storing the state parameter in the corresponding position of the form member in the state table. After the value member replacement script is fixed, the subsequent replacement of the member is required, only the replacement of the member before the replacement and the replacement of the member after the replacement in the script need to be updated, and the replacement can be performed in the database without manual editing of the form and without checking one by one. At the same time, the accuracy of the replacement of the form member is high.

[0057] Please refer to Figure 3 The third embodiment of the form member replacement method in the embodiment of the application includes:

[0058] 301. Obtain a form member replacement request sent by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced;

[0059] 302. Based on the form member replacement request, update the state table in the relational database;

[0060] 303. When the status table is updated, the data monitoring task is triggered to obtain the schema for creating the corresponding application and log in to the relational database corresponding to the application through the schema;

[0061] 304. Call and run a preset form member replacement script. The form member replacement script calls a first two-dimensional table and a second two-dimensional table of the relational database. The first two-dimensional table records the internal identification primary ID of the form member in the relational database, and the second two-dimensional table records the dimension-value relationship of the form in the relational database.

[0062] 305. Query the corresponding internal identification primary ID in the first two-dimensional table according to the member information;

[0063] 306. Query the dimension-value relationship corresponding to the second two-dimensional table based on the internal identification primary ID corresponding to the member information;

[0064] 307. Query the record data contained in each form in the relational database based on the dimension-value relationship;

[0065] 308. Replace the form members in the relational database according to the record data and member information;

[0066] In this embodiment, the Hyperion system whose relational database is Oracle database is taken as an example, wherein main elements such as form ID and form name are stored in the two-dimensional table HSP_OBJECT, and the association relationship between the form and its dimension value is stored in the two-dimensional table HSP_FORMOBJ_DEF_MBR.

[0067] Among them, OBJECT_ID of HSP_OBJECT is the internal identification primary ID of the element, OBJECT_NAME is the readable description of the element; MBR_ID of HSP_FORMOBJ_DEF_MBR is the internal identification field of the dimension element.

[0068] Therefore, we consider first finding the internal identification primary ID of the dimension member that needs to be replaced through HSP_OBJECT, then associating the MBR_ID of HSP_FORMOBJ_DEF_MBR to obtain all records containing the dimension member, and then updating the MBR_ID in these records. The updated content is the internal identification primary ID of the target replacement dimension member.

[0069] 309. After the form members are replaced, a commit operation is executed to update the form with the replaced form members on the corresponding front-end page.

[0070] Based on the previous embodiment, this embodiment describes in detail the process of calling and running a preset form member replacement script, inputting member information as a parameter into the form member replacement script, and replacing form members in a relational database through the form member replacement script. By calling and running the preset form member replacement script, the form member replacement script calls the first two-dimensional table and the second two-dimensional table of the relational database, wherein the first two-dimensional table records the internal identification primary ID of the form members in the relational database, and the second two-dimensional table records the dimension-value relationship of the form in the relational database; queries the corresponding internal identification primary ID in the first two-dimensional table based on the member information; queries the corresponding dimension-value relationship in the second two-dimensional table based on the internal identification primary ID corresponding to the member information; queries the record data contained in each form in the relational database based on the dimension-value relationship; and replaces the form members in the relational database based on the record data and member information. After the dimension-value member replacement script is solidified, if there is a need to replace members later, only the pre-replacement member and the post-replacement member in the script need to be updated and executed in the database, eliminating the need to manually edit the form or check each one individually. At the same time, the accuracy of form member replacement is high.

[0071] See also Figure 4 The fourth embodiment of the form member replacement method in the embodiment of the present invention includes:

[0072] 401. Obtain a form member replacement request sent by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced;

[0073] 402. Based on the form member replacement request, update the state table in the relational database;

[0074] 403. When the status table is updated, the data monitoring task is triggered to obtain the schema for creating the corresponding application and log in to the relational database corresponding to the application through the schema.

[0075] 404. Call and run a preset form member replacement script, and input the member information as a parameter into the form member replacement script, and replace the form members in the relational database through the form member replacement script;

[0076] 405. After the form member replacement is completed, the commit operation is executed, the component node form parameter rules encapsulated and saved in the front-end page are called, and an asynchronous network request is sent to the back-end for execution;

[0077] 406. Generate a form rendering request based on the form of the replaced form member, where the form rendering request includes form parameters of the form of the replaced form member;

[0078] 407. Send the form rendering request to the front-end page, determine the form type of the form to be replaced by the front-end page, and determine the form logic corresponding to the form type based on the pre-stored correspondence between the form logic and the form type;

[0079] 408. Update and render the form parameters of the component node in the front-end page based on the form logic;

[0080] 409. Get the form data in the front-end page. The form data is configured with the current data format.

[0081] 410. Call the front-end verification file and verify the current data format with the data format preset in the front-end verification file;

[0082] 411. If the verification fails, the current data format is converted to the data format preset in the front-end verification file.

[0083] This embodiment, building on the previous embodiment, describes in detail the process of executing a commit operation after form member replacement is complete, and updating the form of the replaced form member on the corresponding front-end page. By executing a commit operation after form member replacement is complete, the component node form parameter rules encapsulated and saved on the front-end page are called and an asynchronous network request is sent to the back-end to execute. After the asynchronous network request is successful, the form parameters of the component node on the front-end page are updated and rendered based on the form of the replaced form member. After the dimension value member replacement script is solidified, this method only requires updating the pre-replacement and post-replacement members in the script and executing it in the database when a member replacement is required. There is no need to manually edit the form or check each one individually. At the same time, the accuracy of form member replacement is high.

[0084] The above describes the form member replacement method in the embodiment of the present invention. The following describes the form member replacement device in the embodiment of the present invention. Figure 5 In one embodiment of the present invention, a form member replacement device includes:

[0085] The request acquisition module 501 is used to acquire a form member replacement request issued by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced;

[0086] A state updating module 502 is configured to update a state table in a relational database based on the form member replacement request;

[0087] The database login module 503 is configured to trigger a data monitoring task when the state table update is completed, acquire a schema of a corresponding application program, and log in a relational database corresponding to the application program through the schema.

[0088] The member replacement module 504 is configured to call and run a preset form member replacement script, input the member information into the form member replacement script as a parameter, and replace form members in the relational database through the form member replacement script.

[0089] The page update module 505 is configured to perform a commit operation after the form member replacement is completed, and update a page of a form corresponding to the replaced form member.

[0090] In the embodiment of the application, the form member replacement device runs the form member replacement method, the form member replacement device acquires a form member replacement request sent by an upstream system, the form member replacement request includes member information of a form member to be replaced, updates a state table in a relational database based on the form member replacement request, triggers a data monitoring task when the state table update is completed, acquires a schema of a corresponding application program, logs in a relational database corresponding to the application program through the schema, calls and runs a preset form member replacement script, inputs the member information into the form member replacement script as a parameter, and replaces form members in the relational database through the form member replacement script, and performs a commit operation after the form member replacement is completed, and updates a page of a form corresponding to the replaced form member. The method can replace members through a script, and only needs to update a former member and a latter member in the script and perform the replacement in the database, without manually editing forms and checking one by one. In addition, the form member replacement has high accuracy.

[0091] Please refer to Figure 6 The second embodiment of the form member replacement device in the embodiment of the application includes:

[0092] The request acquisition module 501 is configured to acquire a form member replacement request sent by an upstream system, and the form member replacement request includes member information of a form member to be replaced.

[0093] The state update module 502 is configured to update a state table in a relational database based on the form member replacement request.

[0094] The database login module 503 is configured to trigger a data monitoring task when the state table is updated, acquire a schema of a corresponding application, and log in a relational database corresponding to the application through the schema.

[0095] The member replacement module 504 is configured to call and run a preset form member replacement script, input the member information into the form member replacement script as a parameter, and replace a form member in the relational database through the form member replacement script.

[0096] The page update module 505 is configured to perform a commit operation after the form member replacement is completed, and update a page of a form corresponding to the replaced form member.

[0097] In this embodiment, the state update module 502 is specifically configured to generate a corresponding state parameter based on the form member replacement request, identify a form member corresponding to the form member replacement request in the state table based on the member information, and store the state parameter in a corresponding position of the form member in the state table.

[0098] In this embodiment, the member replacement module 504 is specifically configured to call and run a preset form member replacement script, call a first two-dimensional table and a second two-dimensional table of the relational database through the form member replacement script, where the first two-dimensional table records an internal identification master id of a form member in the relational database, and the second two-dimensional table records a dimension value relationship of a form in the relational database, query a corresponding internal identification master id in the first two-dimensional table according to the member information, query a corresponding dimension value relationship in the second two-dimensional table based on the internal identification master id corresponding to the member information, query record data contained in each form in the relational database based on the dimension value relationship, and replace a form member in the relational database according to the record data and the member information.

[0099] In this embodiment, the page update module 505 specifically includes a calling unit 5051 configured to perform a commit operation after the form member replacement is completed, call a component node form parameter rule encapsulated and saved by the front-end page, and send an asynchronous network request to the back-end; and a page rendering unit 5052 configured to, after the asynchronous network request is successful, update and render a form parameter of a component node of the front-end page based on a form of a replaced form member.

[0100] In this embodiment, the page rendering unit 5052 is specifically configured to generate a form rendering request based on the form of the replaced form member, the form rendering request including form parameters of the form of the replaced form member; and send the form rendering request to the front-end page, determine a form type of the form of the replaced form member through the front-end page, and determine form logic corresponding to the form type based on a pre-stored correspondence between form logic and form types.

[0101] In this embodiment, the form member replacement device further includes a verification module 506, which specifically includes: obtaining form data in the front-end page, the form data being configured with a current data format; calling a front-end verification file to verify the current data format against a preset data format in the front-end verification file; and if the verification fails, converting the current data format into the preset data format in the front-end verification file.

[0102] This embodiment is based on the previous embodiment and describes the specific functions of various modules and the unit composition of some modules in detail. After the value member replacement script is solidified, when a need to replace a member is encountered subsequently, only the pre-replacement member and the post-replacement member in the script need to be updated, and the execution in the database is sufficient, without the need for manual editing of forms or one-by-one checking. Meanwhile, the form member replacement has high accuracy.

[0103] The above Figure 5 and Figure 6 The form member replacement device in the embodiment of the present application is described in detail from the perspective of a modular functional entity, and the form member replacement device in the embodiment of the present application is described in detail from the perspective of hardware processing.

[0104] Figure 71 is a schematic diagram of the structure of a form member replacement device provided by an embodiment of the present invention. The form member replacement device 700 may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 710 (for example, one or more processors) and a memory 720, and one or more storage media 730 (for example, one or more mass storage devices) storing application programs 733 or data 732. The memory 720 and the storage medium 730 may be temporary storage or permanent storage. The program stored in the storage medium 730 may include one or more modules (not shown in the figure), each module may include a series of instruction operations on the form member replacement device 700. Furthermore, the processor 710 may be configured to communicate with the storage medium 730, and execute a series of instruction operations in the storage medium 730 on the form member replacement device 700 to implement the steps of the above-mentioned form member replacement method.

[0105] The form member replacement device 700 may further include one or more power supplies 740, one or more wired or wireless network interfaces 750, one or more input and output interfaces 760, and / or one or more operating systems 731, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. It will be understood by those skilled in the art that Figure 7 The structure of the form member replacement device shown does not constitute a limitation on the form member replacement device provided in this application, and may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently.

[0106] The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. The computer-readable storage medium stores instructions, which, when executed on a computer, cause the computer to execute the steps of the form member replacement method.

[0107] Those skilled in the art will clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described systems, devices, and units can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0108] The integrated unit, if implemented in the form of a software function unit and sold or used as an independent product, can be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application or the entire or part of the technical solutions that essentially contribute to the prior art can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes a plurality of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method described in the various embodiments of the present application. The aforementioned storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and various media that can store program codes.

[0109] The above description and the above embodiments are only used to illustrate the technical solutions of the present application, but not to limit them. Although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacements for some technical features. These modifications or replacements do not make the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A form member replacement method, characterized in that: The form member replacement method includes: Obtaining a form member replacement request issued by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced; Based on the form member replacement request, updating a state table in a relational database; When the status table is updated, the data monitoring task is triggered to obtain the schema for creating the corresponding application and log in to the relational database corresponding to the application through the schema; Calling and running a preset form member replacement script, and inputting the member information as a parameter into the form member replacement script, and replacing the form members in the relational database through the form member replacement script; After the form member is replaced, a commit operation is performed to update the form with the replaced form member on the corresponding front-end page; The calling and running of a preset form member replacement script, and inputting the member information as a parameter into the form member replacement script, and replacing the form members in the relational database by the form member replacement script includes: Calling and running a preset form member replacement script, and calling a first two-dimensional table and a second two-dimensional table of the relational database through the form member replacement script, wherein the first two-dimensional table records the internal identification primary ID of the form member in the relational database, and the second two-dimensional table records the dimension-value relationship of the form in the relational database; Query the first two-dimensional table for the corresponding internal identification primary ID according to the member information; querying the dimension-value relationship corresponding to the second two-dimensional table based on the internal identification primary ID corresponding to the member information; querying the record data contained in each form in the relational database based on the dimension-value relationship; The form members in the relational database are replaced according to the record data and the member information.

2. The form member replacement method according to claim 1, characterized in that: The updating of the state table in the relational database based on the form member replacement request includes: Based on the form member replacement request, generating corresponding state parameters; Based on the member information, identifying the form member corresponding to the form member replacement request in the status table; The state parameter is stored in a corresponding position of the form member in the state table.

3. The form member replacement method according to claim 1, characterized in that: After the form member is replaced, a commit operation is performed to update the form of the replaced form member on the corresponding front-end page, including: After the form member replacement is completed, a commit operation is performed, the component node form parameter rule encapsulated and saved in the front-end page is called, and an asynchronous network request is sent to the back-end for execution; After the asynchronous network request is successful, the form parameters of the front-end page component node are updated and rendered based on the form of the replaced form member.

4. The form member replacement method according to claim 3, characterized in that: The form parameters for re-updating and rendering the front-end page component node based on the form replacing the form members include: Generate a form rendering request based on the form of the replaced form member, wherein the form rendering request includes form parameters of the form of the replaced form member; Sending the form rendering request to the front-end page, determining the form type of the form of the replaced form member through the front-end page, and determining the form logic corresponding to the form type based on a pre-stored correspondence between form logic and form type; The form parameters of the component nodes in the front-end page are updated and rendered based on the form logic.

5. The form member replacement method according to claim 1, characterized in that: After executing the commit operation and updating the form of the replaced form member on the corresponding front-end page, the following steps are also included: Obtaining form data in the front-end page, wherein the form data is configured with a current data format; Calling a front-end verification file to verify the current data format with a data format preset in the front-end verification file; If the verification fails, the current data format is converted into a data format preset in the front-end verification file.

6. A form member replacement device, characterized in that: The form member replacing device comprises: A request acquisition module, configured to acquire a form member replacement request issued by an upstream system, wherein the form member replacement request includes member information of the form member to be replaced; A state update module, configured to update a state table in a relational database based on the form member replacement request; A database login module is used to trigger a data monitoring task when the status table is updated, obtain a schema for creating a corresponding application, and log in to the relational database corresponding to the application through the schema; A member replacement module is used to call and run a preset form member replacement script, and input the member information as a parameter into the form member replacement script, and replace the form members in the relational database through the form member replacement script; A page update module is used to perform a commit operation after the form member replacement is completed, and update the form with the replaced form member on the corresponding front-end page; The member replacement module is specifically used for: Calling and running a preset form member replacement script, and calling a first two-dimensional table and a second two-dimensional table of the relational database through the form member replacement script, wherein the first two-dimensional table records the internal identification primary ID of the form member in the relational database, and the second two-dimensional table records the dimension-value relationship of the form in the relational database; Query the first two-dimensional table for the corresponding internal identification primary ID according to the member information; querying the dimension-value relationship corresponding to the second two-dimensional table based on the internal identification primary ID corresponding to the member information; querying the record data contained in each form in the relational database based on the dimension-value relationship; The form members in the relational database are replaced according to the record data and the member information.

7. The form member replacement device according to claim 6, characterized in that: The status update module is specifically used for: Based on the form member replacement request, generating corresponding state parameters; Based on the member information, identifying the form member corresponding to the form member replacement request in the status table; The state parameter is stored in a corresponding position of the form member in the state table.

8. The form member replacement device according to claim 6, characterized in that: The page update module specifically includes: a calling unit, which performs a commit operation after the form member replacement is completed, calls the component node form parameter rules encapsulated and saved by the front-end page, and sends an asynchronous network request to the back-end for execution; a page rendering unit, which is used to re-update and render the form parameters of the front-end page component node based on the form of the replaced form member after the asynchronous network request is successful.

9. A form member replacement device, characterized in that: The form member replacement device includes: a memory and at least one processor, wherein instructions are stored in the memory, and the memory and the at least one processor are interconnected via a line; The at least one processor calls the instructions in the memory to enable the form member replacement device to perform the steps of the form member replacement method according to any one of claims 1 to 5.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the form member replacement method according to any one of claims 1 to 5 are implemented.

Images