CN101894133B - Method and device for modifying form data in batches - Google Patents

Abstract

The present invention provides a method for modifying form data in batches, including: step 102, preset one or more target modification elements and preset one or more conditional elements; step 104, modify the elements from one or more targets Select a target modification element in, and select at least one condition element for a target modification element from one or more condition elements, and determine the modification condition according to at least one condition element; Step 106, according to a target modification element and modification condition, in Determine the modification position in the form, and modify the data in the modification position. The invention also provides a device for modifying form data in batches. According to the technical solution of the present invention, a method and device for modifying form data in batches can be realized, and the form data can be modified more quickly and with higher accuracy.

Description

Method and device for batch modifying form data

Technical field

The present invention relates to data processing technology, and in particular to a method and device for batch modifying form data.

Background technology

In the data processing with row and column structure, there are often many repeated operations. For example, for form data, there are the following business requirements:

There is a sales delivery order, which may have hundreds of lines of detailed data, describing information such as product code, product specifications and delivery date, etc. When the goods are delivered, the detailed data may be adjusted according to the current inventory information. For example, the original delivery date of the product with product code A is 2010-04-23, but now the delivery date needs to be adjusted to 2010-04-28 according to production conditions. There may be 40 records with product code A on this form.

For the above business, the current processing method is: find the records with product code A and delivery date 2010-04-23, and modify them manually one by one, or sort the product records by product code, display the records with product code A together, and then modify them manually.

As can be seen from the above, manual operation is commonly used for such post-policy modification tasks. This method has the following problems:

First, searching for records that need to be modified one by one is easy to lose, which increases the probability of error;

Second: The operation is cumbersome, which can easily lead to data errors, low work efficiency, and poor usability and operability.

Therefore, a method is needed to modify form data in batches according to a policy, so as to solve the problems of complicated operation, large operation workload, low efficiency and easy error in the current method of modifying line by line manually.

Contents of the invention

The technical problem to be solved by the present invention is to provide a method for batch modifying form data according to a strategy, so as to solve the problems of cumbersome operation, large operation workload, low efficiency and easy error in the current method of modifying line by line by manual operation.

In view of this, the present invention discloses a method for batch modifying form data, including: step 102, presetting one or more target modification elements and presetting one or more conditional elements; step 104, selecting a target modification element from the one or more target modification elements, and selecting at least one conditional element for the one target modification element from the one or more conditional elements, and determining a modification condition based on the at least one conditional element; step 106, determining a modification position in the form based on the one target modification element and the modification condition, and modifying the data in the modification position.

In the above technical solution, preferably, it further includes: step 108, when there is relevant data associated with the data at the modification position in the form, the relevant data is updated according to the data.

In the above technical solution, preferably, the step 108 further includes: when a formula calculation relationship exists between the data and the related data, notifying the form controls of the form to update the related data in a formula calculation manner.

In the above technical solution, preferably, the step 102 further comprises: setting the source data format of the form, wherein the source data format comprises an AdoDB.Recordset record set or an XML document.

In the above technical solution, preferably, when the source data format is an AdoDB.Recordset record set, determining the modification position in the form includes: converting the modification condition into a conditional filter string that conforms to the AdoDB.Recordset record set specification, calling the filter property of the AdoDB.Recordset record set to perform a filtering operation to obtain row records that conform to the modification condition, and then determining the modification position based on the one target modification element.

In the above technical solution, preferably, when the source data format is an XML document, determining the modification position in the form includes: converting the modification condition into a conditional filter string that complies with the XML XPath specification, calling the XML filtering method to perform a filtering operation to obtain row records that meet the modification condition, and then determining the modification position based on the one target modification element.

In the above technical solution, preferably, each of the one or more target modification elements includes column information of a modifiable column in the form, and each of the one or more conditional elements includes column information of a column in the form that can be used as a condition, wherein the column information includes keywords, display names and data types.

The present invention also discloses a device for batch modifying form data, comprising: a configuration unit, used to preset one or more target modification elements and one or more condition elements; a batch modification setting unit, used to select a target modification element from the one or more target modification elements, and select at least one condition element for the one target modification element from the one or more condition elements, and determine a modification condition according to the at least one condition element; a batch modification unit, used to determine a modification position in the form according to the one target modification element and the modification condition selected by the batch modification setting unit, and modify the data in the modification position.

In the above technical solution, preferably, it also includes: a revision unit, which is used to update the relevant data according to the data when there is relevant data associated with the data at the modification position on the form.

In the above technical solution, preferably, the revision unit is also used to notify the form controls of the form to update the relevant data by formula calculation when a formula calculation relationship exists between the data and the relevant data.

In the above technical solution, preferably, the configuration unit is also used to set the source data format of the form, wherein the source data format includes an AdoDB.Recordset record set or an XML document.

In the above technical solution, preferably, when the source data format is an AdoDB.Recordset record set, the batch modification unit determines the modification position in the form, including: the batch modification unit converts the modification condition into a conditional filter string that conforms to the AdoDB.Recordset record set specification, calls the filter property of the AdoDB.Recordset record set to perform a filtering operation to obtain row records that conform to the modification condition, and then determines the modification position based on the one target modification element.

In the above technical solution, preferably, when the source data format is an XML document, the batch modification unit determines the modification position in the form, including: the batch modification unit converts the modification condition into a conditional filter string that complies with the XML XPath specification, calls the XML filtering method to perform a filtering operation to obtain row records that meet the modification condition, and then determines the modification position based on the one target modification element.

In the above technical solution, preferably, each of the one or more target modification elements includes column information of a modifiable column in the form, and each of the one or more conditional elements includes column information of a column in the form that serves as a condition, wherein the column information includes keywords, display names and data types.

Through the above technical scheme, a method and device for batch modification of form data can be realized, by presetting the modification condition elements, then finding the row records that meet the conditions according to the modification elements selected by the user, and presetting the target modification elements to select the modified columns, so as to determine the modification position for automatic modification.

Description of the attached figure

FIG1 is a flow chart of a method for batch modifying form data according to the present invention;

2 is a block diagram of an apparatus for batch modifying form data according to the present invention;

3 to 5 are schematic screenshot diagrams of an apparatus for batch modifying form data according to an embodiment of the present invention.

Specific implementation method

The embodiments according to the present invention are described in detail below with reference to the accompanying drawings.

FIG. 1 is a flow chart of a method for batch modifying form data according to the present invention.

As shown in Figure 1, the present invention provides a method for batch modifying form data, including: step 102, presetting one or more target modification elements and presetting one or more conditional elements; step 104, selecting a target modification element from the one or more target modification elements, and selecting at least one conditional element for the one target modification element from the one or more conditional elements, and determining a modification condition based on the at least one conditional element; step 106, determining a modification position in the form based on the one target modification element and the modification condition, and modifying the data in the modification position.

The above technical solution further includes: step 108, when there is relevant data associated with the data at the modification position in the form, the relevant data is updated according to the data.

In the above technical solution, the step 108 further includes: when a formula calculation relationship exists between the data and the related data, notifying the form controls of the form to update the related data in a formula calculation manner.

In the above technical solution, the step 102 further includes: setting the source data format of the form, wherein the source data format includes an AdoDB.Recordset record set or an XML document.

In the above technical solution, when the source data format is an AdoDB.Recordset record set, determining the modification position in the form includes: converting the modification condition into a conditional filter string that conforms to the AdoDB.Recordset record set specification, calling the filter property of the AdoDB.Recordset record set to perform a filtering operation to obtain row records that conform to the modification condition, and then determining the modification position based on the one target modification element.

In the above technical solution, when the source data format is an XML document, determining the modification position in the form includes: converting the modification condition into a conditional filter string that complies with the XML XPath specification, calling the XML filtering method to perform a filtering operation to obtain row records that meet the modification condition, and then determining the modification position based on the target modification element.

In the above technical solution, each of the one or more target modification elements includes column information of the modifiable columns in the form, and each of the one or more conditional elements includes column information of the columns in the form that can be used as conditions, wherein the column information includes keywords, display names and data types.

FIG. 2 is a block diagram of an apparatus for batch modifying form data according to the present invention.

As shown in Figure 2, the present invention also provides an apparatus 200 for batch modifying form data, comprising: a configuration unit 202, for presetting one or more target modification elements and presetting one or more condition elements; a batch modification setting unit 204, for selecting a target modification element from the one or more target modification elements, and selecting at least one condition element for the one target modification element from the one or more condition elements, and determining a modification condition according to the at least one condition element; a batch modification unit 206, for determining a modification position in the form according to the one target modification element and the modification condition selected by the batch modification setting unit 204, and modifying the data in the modification position.

The above technical solution also includes: a revision unit, which is used to update the relevant data according to the data when there is relevant data associated with the data at the modification position on the form.

In the above technical solution, the revision unit is further used to notify the form controls of the form to update the related data by formula calculation when a formula calculation relationship exists between the data and the related data.

In the above technical solution, the configuration unit 202 is further used to set the source data format of the form, wherein the source data format includes an AdoDB.Recordset record set or an XML document.

In the above technical solution, when the source data format is an AdoDB.Recordset record set, the batch modification unit 206 determines the modification position in the form, including: the batch modification unit 206 converts the modification condition into a conditional filter string that conforms to the AdoDB.Recordset record set specification, calls the filter property of the AdoDB.Recordset record set to perform a filtering operation to obtain row records that conform to the modification condition, and then determines the modification position based on the one target modification element.

In the above technical solution, when the source data format is an XML document, the batch modification unit 206 determines the modification position in the form, including: the batch modification unit 206 converts the modification condition into a conditional filter string that complies with the XML XPath specification, calls the XML filtering method to perform a filtering operation to obtain row records that comply with the modification condition, and then determines the modification position based on the one target modification element.

In the above technical solution, each of the one or more target modification elements includes column information of the modifiable columns in the form, and each of the one or more conditional elements includes column information of the columns in the form that serve as conditions, wherein the column information includes keywords, display names and data types.

3 to 5 are schematic screenshot diagrams of an apparatus for batch modifying form data according to an embodiment of the present invention.

As shown in Figure 3, it is the original sales order described in the implementation case of the present invention. During the processing of this document, due to business requirements, the estimated delivery date of the products with inventory code of CPU is uniformly modified to 2009-10-29.

First, use the configuration unit 202 to preset the target modification element, and the target modification element includes the column information of the modifiable column. In this example, the modifiable columns include quantity, unit price, amount, etc., and the range of the modifiable columns is determined by the user of this device according to the current authority or other constraints. The column information of the column includes the keyword of the column, the display name of the column, and the data type of the column. For example, the example format of the column information of quantity is: <quantity display name = 'quantity' data type = 'decimal' decimal places = '2' custom format = "/>", and the example format of the column information of pre-delivery date is: <predeliverydate display name = 'pre-delivery date' data type = 'date' decimal places = "custom format = 'YYYY year MM month DD day'".

Then, the configuration unit 202 is used to preset condition elements, and the condition elements include column information of columns that can be used as policy conditions; in this example, the columns that can be used as policy conditions include inventory code, inventory name, pre-delivery date, etc., wherein the example format of the column information of the inventory code is: <cinvcode display name = 'Inventory code' data type = 'String' decimal places = "Custom format = ''/>", and the example format of the column information of the pre-delivery date is: <predeliverydate display name = 'Pre-delivery date' data type = 'Date' decimal places = "Custom format = 'YYYY year MM month DD day'/>".

As shown in Figure 3, the user can then use the batch modification setting unit 204 to select a target column, set the value of the target column, and add a modification condition, which can be a combination of multiple single conditions. In this example, the target column selected is "Estimated Shipping Date" and the condition is that the stock code is equal to "CPU".

According to the selected conditions, the batch modification unit 206 finds all the row records that meet the conditions and updates the value of the target column. The batch modification unit 206 converts the above selected conditions into conditional filtering strings that meet the XML XPath (XPath is used to find information in XML documents. This is a well-known technology for those skilled in the art and will not be repeated here) according to the category of the source data. In this example, it is XML. In this example, it is (string-compare(cinvcode, 'CPU') = 0), and calls the selectNodes method in the XML DOM object, passing in the parameter (string-compare(cinvcode, 'CPU') = 0) to find all the records that meet the conditions. In this example, there are two rows (the second and seventh rows in Figure 3). The batch modification unit 206 updates the corresponding data and completes the modification.

As shown in Figure 4, it is a schematic diagram of the modified result. In this example, the modification column is the estimated delivery date. Generally, there is no formula calculation. If the modification column is the quantity, as a preferred step, the value update event is also triggered. The revision unit can notify the form control to perform formula calculations. For example, amount = quantity × unit price. If the quantity is modified, the amount will be modified synchronously.

In summary, the method and device for batch modification of form data implemented according to the technical solution of the present invention greatly enhance the work efficiency of operators, are simple and easy to understand, and can set target columns, target values, and modification policy conditions for batch modification. The conditions support a combination of multiple conditions and have a wide range of uses.

The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims (12)

1. a method that is used for modifying form data in batches is characterized in that, comprising:

Step 102 presets one or more target modification elements and presets one or more condition elements;

Step 104, from described one or more target modification elements, select a target modification elements, and from described one or more condition elements, select at least one condition element, and determine the modification condition according to described at least one condition element for a described target modification elements;

Step 106 according to a described target modification elements and described modification condition, is determined location revision, and the data in the described location revision is made amendment in described list,

Wherein, each described one or more target modification elements comprises the column information of the revisable row in the described list, each described one or more condition element comprises the column information of the row of the condition that can be used as in the described list, wherein, column information comprises key word, display Name and data type.

2. method according to claim 1 is characterized in that, also comprises:

Step 108 when having the related data have with the data association of described location revision in described list, is then upgraded described related data according to described data.

3. method according to claim 2 is characterized in that, described step 108 also comprises:

When between described data and described related data, having the formula calculated relationship, notify the form controls of described list, described related data is upgraded with the formula account form.

4. method according to claim 1 is characterized in that, described step 102 also comprises:

Set the source data layout of described list, wherein, described source data layout comprises AdoDB.Recordset record set or XML document.

5. method according to claim 4 is characterized in that, when described source data layout is the AdoDB.Recordset record set, describedly determines that in described list location revision comprises:

Described modification condition is converted into the condition filter character string that meets described AdoDB.Recordset record set standard, call the filter attributes of described AdoDB.Recordset record set and carry out filter operation, to obtain meeting the line item of described modification condition, according to a described target modification elements, determine described location revision again.

6. method according to claim 4 is characterized in that, when described source data layout is XML document, describedly determines that in described list location revision comprises:

Described modification condition is converted into the condition filter character string that meets described XML XPath standard, the filter method of call XML carries out filter operation, to obtain meeting the line item of described modification condition, according to a described target modification elements, determine described location revision again.

7. a device that is used for modifying form data in batches is characterized in that, comprising:

Dispensing unit is used to preset one or more target modification elements and presets one or more condition elements;

The batch modification setup unit, be used for selecting a target modification elements from described one or more target modification elements, and from described one or more condition elements, select at least one condition element for a described target modification elements, determine the modification condition according to described at least one condition element;

The batch modification unit is used for a described target modification elements and described modification condition according to described batch modification setup unit selection, determines location revision in described list, and the data in the described location revision are made amendment,

Wherein, each described one or more target modification elements comprises the column information of the revisable row in the described list, each described one or more condition element comprises the column information as the row of condition in the described list, wherein, column information comprises key word, display Name and data type.

8. device according to claim 7 is characterized in that, also comprises:

The revision unit when being used on described list existing the related data that has with the data association of described location revision, upgrades described related data according to described data.

9. device according to claim 8, it is characterized in that, when described revision unit also is used for having the formula calculated relationship between described data and described related data, notify the form controls of described list, described related data is upgraded with the formula account form.

10. device according to claim 7 is characterized in that, described dispensing unit also is used to set the source data layout of described list, and wherein, described source data layout comprises AdoDB.Recordset record set or XML document.

11. device according to claim 10 is characterized in that, when described source data layout was the AdoDB.Recordset record set, described batch modification unit determined that in described list described location revision comprises:

Described batch modification unit is converted into described modification condition the condition filter character string that meets described AdoDB.Recordset record set standard, call the filter attributes of described AdoDB.Recordset record set and carry out filter operation, to obtain meeting the line item of described modification condition, according to a described target modification elements, determine described location revision again.

12. device according to claim 10 is characterized in that, when described source data layout was XML document, described batch modification unit determined that in described list described location revision comprises:

Described batch modification unit is converted into described modification condition the condition filter character string that meets described XML XPath standard, the filter method of call XML carries out filter operation, to obtain meeting the line item of described modification condition, according to a described target modification elements, determine described location revision again.

Images