CN101894133B - Method and device for modifying form data in batches - Google Patents
Method and device for modifying form data in batches Download PDFInfo
- Publication number
- CN101894133B CN101894133B CN2010101998322A CN201010199832A CN101894133B CN 101894133 B CN101894133 B CN 101894133B CN 2010101998322 A CN2010101998322 A CN 2010101998322A CN 201010199832 A CN201010199832 A CN 201010199832A CN 101894133 B CN101894133 B CN 101894133B
- Authority
- CN
- China
- Prior art keywords
- condition
- modification
- elements
- data
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Abstract
The invention provides a method for modifying form data in batches, which comprises: a step 102 of presetting one or more target modification elements and presetting one or more condition elements; a step 104 of selecting one target modification element from the one or more target modification elements, selecting at least one condition element for the selected target modification element from the one or more condition elements, and determining modification conditions according to the at least one condition element; and a step 106 of determining a modification position in a form according to the selected target modification element and the modification conditions, and modifying the data at the modification position. The invention also provides a device for modifying the form data in batches. Through the technical scheme of the invention, the method and the device for modifying the form data in batches can be implemented, the form data can be modified more rapidly and conveniently, and the accuracy is higher.
Description
Technical field
The present invention relates to data processing technique, in particular to a kind of method and apparatus that is used for modifying form data in batches.
Background technology
In having the data processing of row-column configuration, a lot of repeated operation are often arranged, for example,, following business demand is arranged at form data:
Have a revenue shipment single, detailed data has row up to a hundred, and descriptor is product code, product specification and Shipping Date etc.In the time of concrete the delivery, detailed data may adjust according to current stock information, the Shipping Date that such as the original plan product code is the product of A is 2010-04-23 day, adjust Shipping Date to 2010-04-28 day according to condition of production needs now, product code is that the record of A has 40 on this list.
At as above professional, present disposal route is: finding product code is A, and Shipping Date is the record of 2010-04-23, manual one by one the modification, or earlier with the product record according to the product code ordering, be product code to show manual then the modification in the record set of A.
Can see that from above at the modification task of this later stage band strategy, operation commonly used is manual operations, there is following problem in this mode:
One: mode is searched and is lost the record that needs modification easily one by one, increases probability of errors;
Its two: complex operation, cause data to be made mistakes easily, and work efficiency is low, ease for use and operability are poor.
Therefore, need a kind of form data that make to carry out the mode of batch modification according to strategy, with solve at present the complex operation that exists in the mode of revising line by line by manual operations, the operation element amount is big, efficient is lower, the problem of makeing mistakes easily.
Summary of the invention
Technical matters to be solved by this invention is, provide a kind of form data that makes to carry out the mode of batch modification according to strategy, with solve at present the complex operation that exists in the mode of revising line by line by manual operations, the operation element amount is big, efficient is lower, the problem of makeing mistakes easily.
In view of this, the invention discloses a kind of method that is used for modifying form data in batches, comprising: step 102, preset one or more target modification elements and preset 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.
In technique scheme, preferably, also comprise: step 108, when in described list, having the related data have with the data association of described location revision, then described related data is upgraded according to described data.
In technique scheme, preferably, described step 108 also comprises: when having the formula calculated relationship between described data and described related data, notify the form controls of described list, with the formula account form described related data is upgraded.
In technique scheme, preferably, 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.
In technique scheme, preferably, when described source data layout is the AdoDB.Recordset record set, describedly determine 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.
In technique scheme, preferably, when described source data layout is XML document, describedly determine 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.
In technique scheme, preferably, 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.
The invention also discloses a kind of device that is used for modifying form data in batches, 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.
In technique scheme, preferably, also comprise: the revision unit, when being used on described list existing the related data that has with the data association of described location revision, upgrade described related data according to described data.
In technique scheme, preferably, 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, with the formula account form described related data is upgraded.
In technique scheme, preferably, 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.
In technique scheme, preferably, when described source data layout is the AdoDB.Recordset record set, described batch modification unit determines 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.
In technique scheme, preferably, when described source data layout is XML document, described batch modification unit determines 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.
In technique scheme, preferably, 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.
Pass through technique scheme, can realize a kind of method and apparatus of modifying form data in batches, by presetting the condition element of modification, qualified line item will be usually found in the modification of selecting according to the user then, and preset target modification elements and select the row revised, revise automatically to determine location revision.
Description of drawings
Fig. 1 is the process flow diagram that is used for the method for modifying form data in batches according to of the present invention;
Fig. 2 is the block diagram that is used for the device of modifying form data in batches according to of the present invention;
Fig. 3 to Fig. 5 is the screenshotss synoptic diagram that is used for the device of modifying form data in batches according to an embodiment of the invention.
Embodiment
Describe in detail according to embodiments of the invention with reference to the accompanying drawings below.
Fig. 1 is the process flow diagram that is used for the method for modifying form data in batches according to of the present invention.
As shown in Figure 1, the invention provides a kind of method that is used for modifying form data in batches, comprising: step 102, preset one or more target modification elements and preset 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.
In technique scheme, also comprise: step 108, when in described list, having the related data have with the data association of described location revision, then described related data is upgraded according to described data.
In technique scheme, described step 108 also comprises: when having the formula calculated relationship between described data and described related data, notify the form controls of described list, with the formula account form described related data is upgraded.
In technique scheme, 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.
In technique scheme, when described source data layout is the AdoDB.Recordset record set, describedly determine 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.
In technique scheme, when described source data layout is XML document, describedly determine 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.
In technique scheme, 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.
Fig. 2 is the block diagram that is used for the device of modifying form data in batches according to of the present invention.
As shown in Figure 2, the present invention also provides a kind of device 200 that is used for modifying form data in batches, comprising: dispensing unit 202 is used to preset one or more target modification elements and presets one or more condition elements; Batch modification setup unit 204, 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; Batch modification unit 206 is used for a described target modification elements and described modification condition according to described batch modification setup unit 204 selections, determines location revision in described list, and the data in the described location revision are made amendment.
In technique scheme, also comprise: the revision unit, when being used on described list existing the related data that has with the data association of described location revision, upgrade described related data according to described data.
In technique scheme, 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, with the formula account form described related data is upgraded.
In technique scheme, described dispensing unit 202 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.
In technique scheme, when described source data layout is the AdoDB.Recordset record set, described batch modification unit 206 determines that in described list described location revision comprises: described batch modification unit 206 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.
In technique scheme, when described source data layout is XML document, described batch modification unit 206 determines that in described list described location revision comprises: described batch modification unit 206 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.
In technique scheme, 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.
Fig. 3 to Fig. 5 is the screenshotss synoptic diagram that is used for the device of modifying form data in batches according to an embodiment of the invention.
As shown in Figure 3, be the described original sales order of the invention process case.In the processing procedure of this document, need be encoded to unified being revised as 2009-10-29 day of pre-Shipping Date of the product of CPU because of business need to stock.
At first, use dispensing unit 202 to preset target modification elements, described target modification elements comprises the column information of the row that can revise.In this example, revisable row comprise quantity, unit price, the amount of money etc., and the scope of revisable row is determined according to current authority or other constraint condition by the user of this device.The column information of row comprises the key word of row, the display Name of row, the data type of row, format sample such as the column information of quantity:＜quantity display Name=' quantity ' data type=' decimal ' decimal place=' 2 ' user-defined format="/〉 ", the format sample of the column information of pre-Shipping Date:＜predeliverydate display Name=' pre-Shipping Date ' data type=' date ' decimal place=" user-defined format=' YYYY MM month DD day '/".
Then, re-use dispensing unit 202 prerequisite key elements, described condition element comprises the column information of the row that can be used as policy condition; In this example, the row that can be used as policy condition comprise stock coding, stock title, pre-Shipping Date etc., the format sample of the column information of stock coding wherein:＜cinvcode display Name=' stock coding ' data type=' character string ' decimal place=" user-defined format=' '/", the format sample of the column information of pre-Shipping Date:＜predeliverydate display Name=' in advance Shipping Date ' data type=' date ' decimal place=" user-defined format=' YYYY MM month DD day '/".
As shown in Figure 3, next the user can use batch modification setup unit 204 select targets row, and the value of target column is set, and can increase the condition of modification, and condition can be the combination of a plurality of single conditions.Select target is classified " pre-Shipping Date " as in this example, and condition is that the stock coding equals " CPU ".
According to the condition of selecting, all qualified line items are found out in batch modification unit 206, and the value of target column is upgraded.Batch modification unit 206 is according to the classification of coming source data, in this example XML, the condition of above-mentioned selection transferred to meet XML XPath (XPath is used for searching information in XML document, this is those skilled in the art's a known technology, do not repeat them here) the condition filter character string, in this example (string-compare (cinvcode, ' CPU ')=0), and use the selectNodes method of calling at XML DOM object, import parameter (string-compare (cinvcode into, ' CPU ')=0), find all qualified records, this example is two row (row of second among Fig. 3 and the 7th row).Batch modification unit 206 upgrades corresponding data, finishes modification.
As shown in Figure 4, be to revise the result schematic diagram that finishes.Revise in this example and classify pre-Shipping Date as, generalized case does not have formula to calculate, and classifies quantity as if revise, as preferred steps, also want the trigger value update event, the revision unit can be notified form controls to carry out formula and calculate, such as the amount of money=quantity * unit price, quantity is revised, and can revise the amount of money synchronously.
In sum, the method and apparatus that is used for modifying form data in batches according to technical scheme realization of the present invention, strengthened operating personnel's work efficiency greatly, simply, understandable, and can set the target column of batch modification, desired value, and revise policy condition, condition is supported the combination of a plurality of conditions, and usable range is wider.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within 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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101998322A CN101894133B (en) | 2010-06-08 | 2010-06-08 | Method and device for modifying form data in batches |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101998322A CN101894133B (en) | 2010-06-08 | 2010-06-08 | Method and device for modifying form data in batches |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101894133A CN101894133A (en) | 2010-11-24 |
| CN101894133B true CN101894133B (en) | 2011-12-07 |
Family
ID=43103325
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101998322A Active CN101894133B (en) | 2010-06-08 | 2010-06-08 | Method and device for modifying form data in batches |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101894133B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105022722A (en) * | 2014-04-18 | 2015-11-04 | 珠海金山办公软件有限公司 | Electronic form row and column freezing method and electronic form row and column freezing device |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103970777B (en) * | 2013-01-30 | 2017-07-18 | 金蝶软件（中国）有限公司 | The method and apparatus that batch operation is carried out to list data |
| CN103744697A (en) * | 2013-12-26 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | System file configuration method and device |
| CN105224531A (en) * | 2014-05-28 | 2016-01-06 | 腾讯科技（深圳）有限公司 | The method and apparatus of localization of XML node |
| CN104536997B (en) * | 2014-12-12 | 2018-11-09 | 北京国双科技有限公司 | Batch data processing method and processing device for client end interface |
| CN106446350A (en) * | 2016-08-31 | 2017-02-22 | 江苏国泰新点软件有限公司 | Method and device for modifying parameters of family types of design class platform |
| CN107679081B (en) * | 2017-08-30 | 2020-06-30 | 平安科技（深圳）有限公司 | Information modification method and device, computer equipment and computer readable storage medium |
| CN107729447A (en) * | 2017-09-30 | 2018-02-23 | 杭州迪普科技股份有限公司 | The update method and device of mesh object, computer-readable recording medium |
| CN109102248A (en) * | 2018-07-28 | 2018-12-28 | 万翼科技有限公司 | Amending method, device and the computer readable storage medium of nodal information |
| CN110795915A (en) * | 2018-07-31 | 2020-02-14 | 中兴通讯股份有限公司 | Method, system, equipment and computer-readable storage medium for modifying xml file in batch |
| CN113239053A (en) * | 2021-04-30 | 2021-08-10 | 国网江苏省电力有限公司 | Intelligent editing method for updating data based on rule matching |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000010103A1 (en) * | 1998-08-11 | 2000-02-24 | Shinji Furusho | Method and apparatus for retrieving, accumulating, and sorting table-formatted data |
| CN101398812B (en) * | 2007-09-27 | 2012-05-30 | 国际商业机器公司 | Apparatus and method for generating electric table with service logic |
-
2010
- 2010-06-08 CN CN2010101998322A patent/CN101894133B/en active Active
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105022722A (en) * | 2014-04-18 | 2015-11-04 | 珠海金山办公软件有限公司 | Electronic form row and column freezing method and electronic form row and column freezing device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101894133A (en) | 2010-11-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101894133B (en) | Method and device for modifying form data in batches | |
| US6895409B2 (en) | Method and apparatus for creating an adaptive application | |
| US7857221B2 (en) | RFID tag system | |
| US6947903B1 (en) | Method and system for monitoring a supply-chain | |
| CN100476833C (en) | Designing, purchasing and manufacturing collaboration of electronic element | |
| JP4580518B2 (en) | Database design system | |
| US20050197786A1 (en) | System and method for managing the development and manufacturing of a pharmaceutical drug | |
| US20050102192A1 (en) | Method and apparatus for processing of purchase orders | |
| US20040193602A1 (en) | Method and system for maintenance of engineering change data | |
| WO2008006370A2 (en) | Transport rating system | |
| US20140058881A1 (en) | System and Process for Crop Scouting and Pest Cure Recommendation | |
| JP2009104587A (en) | Data and application model for configurable tracking and reporting system | |
| JPWO2015033376A1 (en) | Form data management server and form data management program | |
| CN101702216A (en) | Method for supporting configuration of various stock services | |
| US7258266B1 (en) | Defining, administering, and managing automatic identification information, such as bar codes | |
| CN102422233B (en) | Operation guidance setting support device, operation support system | |
| JP2009048594A (en) | Global article data, article management program, and device operated by the program | |
| US20030061226A1 (en) | Data loader for handling imperfect data and supporting multiple servers and data sources | |
| US20150066565A1 (en) | Systems and methods for managing an inventory of component parts | |
| CN112258107A (en) | LED intelligent material rack management method, system, equipment and storage medium | |
| JP5395785B2 (en) | Manufacturing record management system and manufacturing record management method | |
| US7149711B2 (en) | Apparatus for issuing commodity codes for commodity model names | |
| US20040107076A1 (en) | Method and system for integration of engineering change data | |
| KR20200102708A (en) | Method for standardizing documents of electronic transaction | |
| CN108182563A (en) | The method and apparatus being managed in electric terminal to the part of equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20160217 Address after: 100094 Beijing City, North Road, Haidian District, No. 68, building 2, floor 2 Patentee after: You Pu Information Technology Co., Ltd of UFSOFT Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |