CN102043860A - Method and device for controlling limit of document - Google Patents

Method and device for controlling limit of document Download PDF

Info

Publication number
CN102043860A
CN102043860A CN 201010608501 CN201010608501A CN102043860A CN 102043860 A CN102043860 A CN 102043860A CN 201010608501 CN201010608501 CN 201010608501 CN 201010608501 A CN201010608501 A CN 201010608501A CN 102043860 A CN102043860 A CN 102043860A
Authority
CN
China
Prior art keywords
document
amount control
data
numerical value
amount
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.)
Pending
Application number
CN 201010608501
Other languages
Chinese (zh)
Inventor
奚卫平
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yonyou Software Co Ltd
Original Assignee
Yonyou Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yonyou Software Co Ltd filed Critical Yonyou Software Co Ltd
Priority to CN 201010608501 priority Critical patent/CN102043860A/en
Publication of CN102043860A publication Critical patent/CN102043860A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention provides a method for controlling the limit of a document. The method comprises the following steps: 302, extracting intermediate data from the document according to a predefined rule; 304, acquiring a value of a comparison item in a limit control requirement according to the intermediate data; and 306, according to the comparison condition in the limit control requirement, comparing the value of the comparison item with the value of the data item in the limit control requirement to determine whether the document exceeds the preset limit or not. The invention also provides a document limit control device. According to the invention, the dynamic data of the document can be subjected to limit control without changing the document.

Description

Document amount control method and device
Technical field
The present invention relates to a kind of document amount control method and device.
Background technology
Document amount control is meant: before the state of document changes, some projects on the document are checked, only when satisfying certain requirement, just can be allowed this changes, common control merchandise discount when examining as document and can not be lower than certain discount.
General document amount control method usually is that the some concrete field on the document is controlled, as quantity, unit price, the amount of money etc., this mode be directly with the field on the document as checking or data item and a desired value compare, draw the judgement that whether exceeds the quata then.
Document amount control method general generally possesses following key element:
1. comparison operator: comprise greater than, less than, equal;
2. relatively: be positioned at the operational character left side, be generally a certain on the document entity object, or with the relevant dynamic data of current document entity object;
3. desired value or data item: being positioned at the operational character right side, being generally a concrete numerical value, also can be a numerical formula.
Relation between comparison operator, comparison item, desired value or the data item three as shown in Figure 1.
According to the example of Fig. 1, the description of general document amount control method is exemplified below:
1. control [document total charge] [less than] [1000 yuan]
2. control [retail unit price] [greater than] [commodity price * 88 foldings]
3. control [client's credit balance] [greater than] [0]
According to above example, define several metadata and be used for describing above information:
1.MetaData1: the receipt field that description will be controlled, quote document entity corresponding physical table and field name;
2.MetaData2: describe comparison operator, the comparison operator of different documents might also can be different;
3.MetaData3: the data of description item can be numerical value or numerical formula.
By these metadata descriptions, can realize a general document amount control method, can go into shown in Figure 2.
According to Fig. 2, the value of the field that can at first define among the taking-up MetaData1 from document is item as a comparison, taking out the value that defines among the MetaData3 or formula again carries out computing and obtains desired value, to compare and desired value compares by the comparison operator that defines among the MetaData2, obtain net result for inspection by or do not pass through.
The key of this method is that the definition of MetaData1 is to point to the document entity, and problem is, the data field that defines in the MetaData1 metadata derives from [document entity], so also can only retrieve field and data in [document entity] when the document amount is checked, that is to say that the inspection of document amount directly depends on [document entity], the defective of existence mainly contains:
1.[document entity] field attribute relatively fixing, be the set of describing the information of document, be not easy to expand, if the inspection of document amount need be used other project, then do not have good way to solve, unless expand the field attribute in [document entity];
2. the data on the document are through further processing, generally are difficult to satisfy complicated a little any document amount inspection requirements;
3. the program design and the developer of the inspection of document amount can cause this algorithm instability often because some special logics remove to revise algorithm, and each modification all will be carried out substantive test;
4. the business paper developer after [document entity] upward increases for the field of carrying out the inspection requirements of document amount, might need to revise the logic of document.
Based on said method, if realization is to the control of dynamic data such as client's credit balance, common practices is: at first will increase by row on the document entity object, be client's credit balance, secondly when document is preserved or examined, calculate the value of credit balance immediately and it is stored in the credit balance field of document entity object.As seen, if increase a control, can increase suitable complexity, and will revise the document entity object at least, bring certain instability dynamic data.
Therefore, need a kind of new document amount control mode, can carry out amount control control to dynamic data neatly, and not need document is changed.
Summary of the invention
Technical matters to be solved by this invention is, a kind of new document amount control mode is provided, and can carry out amount control control to dynamic data neatly, and not need document is changed.
In view of this, the invention provides a kind of document amount control method, comprising: step 302, according to predefined rule, from document, extract intermediate data; Step 304 according to intermediate data, is obtained the numerical value of the comparison item in the amount control requirement; Step 306, the comparison condition in requiring according to amount control, the numerical value of the data item during relatively numerical value required with amount control compares, and whether has exceeded the amount of being scheduled to determine document.In this technical scheme, processing obtains intermediate data to document, finds out the numerical value of comparison item again in intermediate data, can not need document itself is changed, and only need lay down a regulation flexibly according to document types gets final product.
In technique scheme, preferably, in step 302, also with intermediate data storage in middle table.
In technique scheme, preferably, has the unique identification sign indicating number in the middle table.
In technique scheme, preferably, in step 304, also require and intermediate data obtains the numerical value of data item according to amount control.
In technique scheme, preferably, rule is carried out predefine according to bill type.
The present invention also provides a kind of document amount control device, comprising: data preparation module, according to predefined rule, from document, extract intermediate data; Data acquisition module according to intermediate data, obtains the numerical value of the comparison item in the amount control requirement; The amount control module, the comparison condition in requiring according to amount control, the numerical value of the data item during relatively numerical value required with amount control compares, and whether has exceeded amount control with definite document.In this technical scheme, processing obtains intermediate data to document, finds out the numerical value of comparison item again in intermediate data, can not need document itself is changed, and only need lay down a regulation flexibly according to document types gets final product.
In technique scheme, preferably, data preparation module with intermediate data storage in middle table.
In technique scheme, preferably, has the unique identification sign indicating number in the middle table.
In technique scheme, preferably, data acquisition module obtains the numerical value of data item according to amount control requirement and intermediate data.
In technique scheme, preferably, also comprise: the rule definition module, according to bill type predefine rule.
According to technique scheme, can realize a kind of document amount control method and device, can not need under the prerequisite that document itself is changed, by extracting intermediate data neatly, realize amount control to dynamic data.
Description of drawings
Fig. 1 is the synoptic diagram that concerns between the comparison item, comparison operator, data item in the amount control method.
Fig. 2 is the principle schematic of general amount control method;
Fig. 3 is the process flow diagram of document amount control method according to an embodiment of the invention;
Fig. 4 is the block diagram of document amount control device according to an embodiment of the invention;
Fig. 5 is the principle schematic of document amount control device according to an embodiment of the invention;
Fig. 6 is the work synoptic diagram of the data preparation module of document amount control device according to an embodiment of the invention;
Fig. 7 is that the data acquisition module of document amount control device according to an embodiment of the invention is checked the synoptic diagram of obtaining desired data the middle table from amount.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with the drawings and specific embodiments.
Set forth a lot of details in the following description so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 1 is the process flow diagram of document amount control method according to an embodiment of the invention.
As shown in Figure 1, the invention provides a kind of document amount control method, comprising: step 302, according to predefined rule, from document, extract intermediate data; Step 304 according to intermediate data, is obtained the numerical value of the comparison item in the amount control requirement; Step 306, the comparison condition in requiring according to amount control, the numerical value of the data item during relatively numerical value required with amount control compares, and whether has exceeded the amount of being scheduled to determine document.In this technical scheme, processing obtains intermediate data to document, finds out the numerical value of comparison item again in intermediate data, can not need document itself is changed, and only need lay down a regulation flexibly according to document types gets final product.
In technique scheme, in step 302, also with intermediate data storage in middle table.
In technique scheme, has the unique identification sign indicating number in the middle table.
In technique scheme, in step 304, also require and intermediate data obtains the numerical value of data item according to amount control.
In technique scheme, rule is carried out predefine according to bill type.
Fig. 2 is the block diagram of document amount control device according to an embodiment of the invention;
As shown in Figure 2, the present invention also provides a kind of document amount control device 400, comprising: data preparation module 402, according to predefined rule, from document, extract intermediate data; Data acquisition module 404 according to intermediate data, obtains the numerical value of the comparison item in the amount control requirement; Amount control module 406, the comparison condition in requiring according to amount control, the numerical value of the data item during relatively numerical value required with amount control compares, and whether has exceeded amount control with definite document.In this technical scheme, processing obtains intermediate data to document, finds out the numerical value of comparison item again in intermediate data, can not need document itself is changed, and only need lay down a regulation flexibly according to document types gets final product.
In technique scheme, data preparation module 402 with intermediate data storage in middle table.
In technique scheme, has the unique identification sign indicating number in the middle table.
In technique scheme, data acquisition module 404 obtains the numerical value of data item according to amount control requirement and intermediate data.
In technique scheme, also comprise: rule definition module 408, according to bill type predefine rule.
Fig. 5 is the principle schematic of document amount control device according to an embodiment of the invention.
As shown in Figure 5, with respect to general document amount control technology scheme, in the present embodiment, added step 502, carry out data and prepare, promptly from the document entity, extract intermediate data according to certain rule, and step 504, in intermediate data, find the corresponding data of corresponding MetaData1 (relatively item), MetaData3 (data item), realize amount control to compare according to MetaData2 (comparison operator).
Fig. 6 is the work synoptic diagram of the data preparation module of document amount control device according to an embodiment of the invention.
As shown in Figure 6, data preparation module 402 is quoted the document entity object, at different document types, by calling corresponding method (comprising COM+ assembly method, multiple storing process) by mapping, check middle table with the information on the document entity or through the information stores of calculating to amount, can also be the different data preparation module 402 of document customization of different document types by the developer, in general, one type document entity can corresponding data preparation module 402.
Amount checks that middle table is the memory storage for data preparation module 402 storage intermediate data, and purpose is to use for data acquisition module 404, and this table is designed to and independent of service, and concrete field design is as follows:
A) ID: major key field;
B) Item1-4: the text field that storage is relevant with calculating is mainly used in condition judgment;
C) BigItem1-4: the long text field that storage is relevant with calculating is mainly used in condition judgment;
D) Expr1-10: the numeric field that storage is relevant with calculating;
E) Result1: storage cap desired value or numerical formula result calculated;
F) Result2: storage lower limit desired value or numerical formula result calculated;
G) ConcurrentID: the operation that this amount of unique identification is checked is used to distinguish other simultaneously concurrent amount checked operations.
Data acquisition module 404 is obtained required data from this amount inspection middle table, as shown in Figure 7.For the MetaData1 metadata: this metadata description relatively, data acquisition module 404 is quoted amount and is checked the middle table field, and makes it possess professional implication.Check " Expr1 " field of middle table as " unit price " corresponding amount; For the MetaData3 metadata: this metadata description data item field, be used for the definition of computing formula, equally also can quote amount and check the middle table field.As want that the discounted price of judging the detailed commodity of document can not can define " retail price " herein less than 88 foldings of retail price, corresponding amount is checked " Expr2 " field of middle table; Can also describe other nonumeric type projects, be used to judgement of carrying out logical condition etc.Data acquisition module 404 is obtained the value (may comprise upper and lower bound) of comparison item and data item respectively, by amount control module 406 both values of comparison, reaches a conclusion at last.
According to above technical scheme, can realize a kind of document amount control method and device, its advantage is, check middle table and data beamhouse operation by amount, promptly obtain intermediate data, cut off the direct dependence of business paper entity and MetaData1, make MetaData1, MetaData2, MetaData3, amount check middle table and document amount inspection method have of one's own a sealing, with system independent of service, self-described, mainly obtained following effect:
1. document amount checking process is stable, does not rely on objects outside (document entity object, data preparation device), need not frequent change after the specific algorithm design of amount inspection is finished;
2. the business paper entity no longer checks that with amount algorithm is relevant, need not add with amount and check the relevant field of algorithm, also need not go to safeguard these fields again on the service logic, so self is also relatively stable;
3. the data beamhouse operation can increase and decrease on demand, and need not to influence specific algorithm and the business paper entity that the document amount is checked;
4. reduce the development amount.By technical scheme of the present invention, realize that the amount control of dynamic data is had identical algorithm complex with the amount of the attribute data of document entity object self is controlled.
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 (10)

1. a document amount control method is characterized in that, comprising:
Step 302 according to predefined rule, is extracted intermediate data from document;
Step 304 according to described intermediate data, is obtained the numerical value of the comparison item in the amount control requirement;
Step 306, according to the comparison condition in the described amount control requirement, the numerical value that the numerical value and the described amount of described relatively item are controlled the data item in requiring compares, and whether has exceeded predetermined amount with definite described document.
2. document amount control method according to claim 1 is characterized in that, in described step 302, also with described intermediate data storage in middle table.
3. document amount control method according to claim 2 is characterized in that having the unique identification sign indicating number in the described middle table.
4. document amount control method according to claim 1 is characterized in that, in described step 304, also control requires and described intermediate data obtains the numerical value of described data item according to described amount.
5. according to each described document amount control method in the claim 1 to 4, it is characterized in that described rule is carried out predefine according to described bill type.
6. a document amount control device is characterized in that, comprising:
Data preparation module according to predefined rule, is extracted intermediate data from document;
Data acquisition module according to described intermediate data, obtains the numerical value of the comparison item in the amount control requirement;
The amount control module, the comparison condition during control requires according to amount, the numerical value that the numerical value and the described amount of described relatively item are controlled the data item in requiring compares, to determine whether described document has exceeded amount control.
7. document amount control device according to claim 6 is characterized in that, described data preparation module with described intermediate data storage in middle table.
8. document amount control device according to claim 7 is characterized in that having the unique identification sign indicating number in the described middle table.
9. document amount control device according to claim 6 is characterized in that, described data acquisition module obtains the numerical value of described data item according to described amount control requirement and described intermediate data.
10. according to each described document amount control device in the claim 6 to 9, it is characterized in that, also comprise:
The rule definition module is according to the described rule of described bill type predefine.
CN 201010608501 2010-12-27 2010-12-27 Method and device for controlling limit of document Pending CN102043860A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201010608501 CN102043860A (en) 2010-12-27 2010-12-27 Method and device for controlling limit of document

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201010608501 CN102043860A (en) 2010-12-27 2010-12-27 Method and device for controlling limit of document

Publications (1)

Publication Number Publication Date
CN102043860A true CN102043860A (en) 2011-05-04

Family

ID=43909997

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201010608501 Pending CN102043860A (en) 2010-12-27 2010-12-27 Method and device for controlling limit of document

Country Status (1)

Country Link
CN (1) CN102043860A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102270227A (en) * 2011-06-28 2011-12-07 用友软件股份有限公司 Data processing device and data processing method
CN102521713A (en) * 2011-12-28 2012-06-27 用友软件股份有限公司 Data processing device and data processing method
CN104281667A (en) * 2014-09-28 2015-01-14 用友优普信息技术有限公司 Expansible budget control device and method

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1510598A (en) * 2002-12-21 2004-07-07 鸿富锦精密工业(深圳)有限公司 Accounts receivable customer credit administration method

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1510598A (en) * 2002-12-21 2004-07-07 鸿富锦精密工业(深圳)有限公司 Accounts receivable customer credit administration method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
《SAP方丈-SD-信用控制》 20090112 SAP方丈 SAP方丈-SD-信用控制 http://blog.e-works.net.cn/434450/articles/27154.html 1-10 , *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102270227A (en) * 2011-06-28 2011-12-07 用友软件股份有限公司 Data processing device and data processing method
CN102521713A (en) * 2011-12-28 2012-06-27 用友软件股份有限公司 Data processing device and data processing method
CN104281667A (en) * 2014-09-28 2015-01-14 用友优普信息技术有限公司 Expansible budget control device and method

Similar Documents

Publication Publication Date Title
Ranis et al. A theory of economic development
JP4437576B2 (en) Graph display method, apparatus for implementing the same, and recording medium recording the processing program
US20020032645A1 (en) System and method for score calculation
CN108090225A (en) Operation method, device, system and the computer readable storage medium of database instance
CN101944208A (en) Method and device for dividing document
US10878476B2 (en) Assortment optimization
CN105868878B (en) The Risk Identification Method and device of MAC Address
CN110263307A (en) Report form generation method, server and computer readable storage medium
CN109062881A (en) Purchase bidding documenting method and system
CN107301179A (en) The method and apparatus of data base read-write separation
CN106327100A (en) Change list generation method and device
CN103020753A (en) Document state display system and document state display method
Wahab et al. A dynamic approach to measure machine and routing flexibilities of manufacturing systems
CN102043860A (en) Method and device for controlling limit of document
CN112465601A (en) Electronic order generation method and device and storage medium
EP2871602A1 (en) Report data management server, report data management program, and report data management device
CN107688892A (en) Distribution method, storage medium and the server of breakpoint list
CN110473114A (en) Declaration form share calculation method, device, computer equipment and storage medium
CN110097250A (en) Product risks prediction technique, device, computer equipment and storage medium
CN110675054A (en) Data processing method, data processing system and related equipment in ERP system
CN109544348B (en) Asset security screening method, device and computer readable storage medium
CN102546190A (en) Search method of universal fee packets of cloud computing resources
CN106021349A (en) A foreign exchange data submitting method and device
CN112000701A (en) Data query method, device, equipment and storage medium
WO2023157181A1 (en) Information processing device, information processing method, and program

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20110504