CN107861991A

CN107861991A - Bills data processing method, device, computer equipment and storage medium

Info

Publication number: CN107861991A
Application number: CN201710971085.1A
Authority: CN
Inventors: 付豆; 崔轶; 邢明珠
Original assignee: Kingdee Software China Co Ltd
Current assignee: Kingdee Software China Co Ltd
Priority date: 2017-10-18
Filing date: 2017-10-18
Publication date: 2018-03-30
Anticipated expiration: 2037-10-18
Also published as: CN107861991B

Abstract

The present invention provides a kind of bills data processing method, device, computer equipment and storage medium, and methods described includes：Obtain upstream document mark；Transition status value corresponding with upstream document mark is inquired about in intermediateness table；When transition status value meets preset changeover condition, downstream document is generated；In intermediate data table, corresponding to upstream document mark and the downstream document mark of downstream document, the data of retrography are treated in the document of retrography downstream；According to the Changeover constraint data in upstream document corresponding to the data and upstream document mark for the retrography for corresponding to upstream document mark and downstream document mark in intermediate data table, transition status value is updated.Associated data between document is stored in intermediate data table, the transition status value of upstream document is recorded in intermediateness table simultaneously, reduce the data message stored in document, and do not change the data message in upstream document during generation downstream document, facilitate the displaying and extension of upstream document.

Description

Bills data processing method, device, computer equipment and storage medium

Technical field

The present invention relates to technical field of data processing, more particularly to a kind of bills data processing method, device, computer Equipment and storage medium.

Background technology

In enterprise resource planning, various documents, most of documents can be generated in business procession as needed Between incidence relation be present, the incidence relation between each document reflects all departments of enterprise or operates contact between unit.

At present in business processing flow, it will usually another document is generated according to a kind of conversion of document, in order to embody this Incidence relation between two kinds of documents, the pass between two documents can be also stored while changing generation downstream document by upstream document Join data.

However, at present in document transfer process, the data in upstream document can after each conversion generation downstream document Change, add the complexity of relation between document, cause the displaying of upstream document and extension inconvenient.

The content of the invention

Based on this, it is necessary to shown for current upstream document and extend a kind of inconvenient document number of technical problem proposition According to processing method, device, computer equipment and storage medium.

A kind of bills data processing method, methods described include：

Obtain upstream document mark；

Transition status value corresponding with upstream document mark is inquired about in intermediateness table；

When the transition status value meets preset changeover condition, downstream document is generated；

In intermediate data table, identified corresponding to the downstream document of upstream document mark and the downstream document, instead Write the data that retrography is treated in the downstream document；

According to the retrography for corresponding to upstream document mark and downstream document mark in the intermediate data table Data and upstream document mark corresponding to Changeover constraint data in upstream document, update the transition status value.

In one of the embodiments, the data for treating retrography include preset field name and corresponding field value；It is described Changeover constraint data include Changeover constraint total quantity.

In one of the embodiments, described when the transition status value meets preset changeover condition, generation downstream is single According to, including：

When the transition status value meets preset changeover condition, obtain it is corresponding with the preset field name it is to be written under Swim the field value of document；

Obtain the summation of field value corresponding with the preset field name in intermediate data table；

Obtain the Changeover constraint total quantity in upstream document corresponding to the upstream document mark；

According to the summation and the Changeover constraint total quantity, school is carried out to the field value of downstream document to be written Test；

When the verification passes through, downstream document is generated according to the field value of downstream document to be written.

In one of the embodiments, it is described according to the summation and the Changeover constraint total quantity, to downstream to be written The field value of document is verified, including：

It is poor that the Changeover constraint total quantity and the summation are made, obtain corresponding to the preset field name can retrography word Segment value；

By can the field value of retrography and the field value of downstream document to be written be compared；

When downstream document to be written the field value be less than or equal to can retrography the field value when, verification passes through.

In one of the embodiments, it is described according in the intermediate data table correspond to the upstream document mark and institute State the Changeover constraint number in upstream document corresponding to the data and upstream document mark of the retrography of downstream document mark According to, the transition status value is updated, including：

Obtain the summation of field value corresponding with the preset field name in the intermediate data table；

By the Changeover constraint total quantity compared with the summation；

According to the result of the comparison, the transition status value is updated.

In one of the embodiments, the preset changeover condition includes：The transition status value be first state value or For sky；

It is described that the transition status value is updated according to the result of the comparison, including：

If the Changeover constraint total quantity is more than the summation, the transition status value is updated to first state value；

If the Changeover constraint total quantity is equal to the summation, the transition status value is updated to the second state value.

In one of the embodiments, the upstream document includes upstream business data field；The downstream document includes Downstream document traffic data field；The intermediateness table includes upstream document mark and the transition status value；It is described Intermediate data table includes the data of upstream document mark, downstream document mark and the retrography.

In one of the embodiments, methods described also includes：

When receiving the first displaying instruction, the upstream business data field in the upstream document is shown；

When receiving the second displaying instruction, according to the institute in the upstream business data field and the intermediate data table The transition status value stated in the data of retrography and the intermediateness table creates view, shows that the described of establishment regards Figure.

A kind of bills data processing unit, described device include：

Identifier acquisition module, for obtaining upstream document mark；

State value enquiry module, for the inquiry in intermediateness table and the corresponding transition status of upstream document mark Value；

Document generation module, for when the transition status value meets preset changeover condition, generating downstream document；

Data retrography module, in intermediate data table, being identified and the downstream document corresponding to the upstream document Downstream document mark, the data of retrography are treated in downstream document described in retrography；

State value update module, under according to identifying corresponding to the upstream document in the intermediate data table and being described The Changeover constraint data in upstream document corresponding to the data and upstream document mark of the retrography of document mark are swum, Update the transition status value.

A kind of computer equipment, including memory and processor, the memory storage have computer program, the calculating When machine program is by the computing device so that the computing device following steps：

Obtain upstream document mark；

A kind of computer-readable recording medium, computer program is stored with, when the computer program is executed by processor, So that the computing device following steps：

Obtain upstream document mark；

Above-mentioned a kind of bills data processing method, device, computer equipment and storage medium, need to upstream when detecting When upstream document corresponding to document mark carries out conversion generation corresponding downstream document, the upstream in intermediateness table is first determined whether Whether transition status value corresponding to document mark meets preset changeover condition, only when transition status value meets preset changeover condition When, just conversion generation downstream document, and intermediate data table is updated according to the data that retrography is treated in the downstream document generated, enter And according to Changeover constraint data in the data and upstream document of retrography update transition status value in the intermediate data table.It is logical The data information memory by incidence relation between upstream document and downstream document is represented is crossed in intermediate data table, and by expression The transition status value for swimming the translation state information of document is stored in intermediateness table, is reduced in upstream document and downstream document The data message stored, and do not change the data message in upstream document during changing generation downstream document, it is convenient The displaying and extension of upstream document.

Brief description of the drawings

Fig. 1 is the structural representation of one embodiment Computer equipment；

Fig. 2 is the schematic flow sheet of bills data processing method in one embodiment；

Fig. 3 is the schematic flow sheet of bills data processing method in another embodiment；

Fig. 4 is the structured flowchart of bills data processing unit in one embodiment；

Fig. 5 is the structured flowchart of bills data processing unit in another embodiment.

Embodiment

In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and It is not used in the restriction present invention.

Fig. 1 is the internal structure schematic diagram of one embodiment Computer equipment.As shown in figure 1, the computer equipment bag Include the processor connected by system bus, memory.Wherein, memory may include non-volatile memory medium and memory storage Device.The non-volatile memory medium of the computer equipment is stored with operating system and computer program.The computer program is located When managing device execution, it may be such that processor realizes a kind of bills data processing method.The built-in storage of computer equipment is non-volatile Property storage medium in the operation of computer program environment is provided, the built-in storage can be stored with computer program, the computer When program is executed by processor so that processor realizes a kind of bills data processing method.The processor be used for provide calculate and Control ability, support the operation of whole computer equipment.Computer equipment can be specifically terminal or server.Eventually End can be mobile terminal or fixed terminal, and mobile terminal can be specifically in mobile phone, tablet personal computer and notebook computer etc. It is at least one.

It will be understood by those skilled in the art that the structure shown in Fig. 1, the only part related to application scheme knot The block diagram of structure, the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment are not formed It can include, than more or less parts shown in figure, either combining some parts or arranging with different parts.

In one embodiment, a kind of bills data processing side can be realized with cooperative cooperating between multiple computer equipments Method.For example one or more computer equipments are used for storing upstream document, intermediate data table and intermediateness table, another Or multiple computer equipments are used for obtaining data, and corresponding data processing is carried out according to acquired data, so as to generate down Swim document and renewal intermediate data table and intermediateness table.Computer equipment can both include terminal, include server again.

As shown in Fig. 2 in one embodiment, there is provided a kind of bills data processing method, the present embodiment is in this way Illustrated applied to the computer equipment in above-mentioned Fig. 1.This method specifically comprises the following steps：

S202, obtain upstream document mark.

Wherein, document has been the data message of evidence function.Upstream document is also known as source document, is with changing generation Downstream document is corresponding.Specifically, when changing another document of generation according to a kind of document, a kind of document is exactly upstream Document, another document of conversion generation is exactly downstream document.Upstream document is identified for identifying corresponding upstream document.On Trip document mark can include the character string of at least one of numeral, letter and symbol character.Upstream document mark is specific It can be the unique identifier of upstream document.

In one embodiment, when computer equipment detects the document conversion instruction of assigned operation triggering, according to this Document conversion instruction obtains upstream document identifier corresponding to the upstream document of required conversion.Wherein, assigned operation can be meter Calculate the trigger actions such as pressing, slip or the double-click on machine equipment.Document conversion instruction is to be changed for triggering according to upstream document Generate the instruction of downstream document.

In one embodiment, upstream document mark can be obtained according to predetermined period.Wherein, predetermined period is advance The time interval for being periodically executed required movement of setting.Predetermined period can be that the upstream document set in advance that obtains twice identifies Time interval.Predetermined period can specifically be set according to practical application scene, such as be set as 30 minutes.

In one embodiment, a time point in the time cycle can also be preset, according to the default time Point identifies to obtain upstream document.The default time point can be specifically 6 points of every afternoon or on every Fridays under 4 points of the afternoon of 5 points of noon or monthly last day.

S204, transition status value corresponding with upstream document mark is inquired about in intermediateness table.

Wherein, intermediateness table is the tables of data for storing the transition status of upstream document.Transition status value be for Identify the parameter of the transition status of upstream document.Transition status value can be specifically numeral, letter and at least one of meet The combination of character or various characters.

Specifically, upstream document corresponding to upstream document mark and upstream document mark is stored with intermediate data table Transition status value.After upstream document mark is got, identified according to accessed upstream document and looked into from middle state table Ask State Transferring value corresponding to upstream document mark.

In one embodiment, if computer equipment get upstream document mark after, do not inquire and be stored with this Swim the intermediateness table of document mark, then it represents that current to generate upstream document corresponding to upstream document mark for conversion for the first time Downstream document.Newly-built intermediateness table is now needed, and upstream document mark is stored in the newly-built intermediateness table, will State Transferring value is arranged to empty.After generation downstream document to be converted, then update the transition status value.

In one embodiment, computer equipment is newly-built to deposit when creating upstream document corresponding to upstream document mark The intermediateness table of upstream document mark is contained, and State Transferring value corresponding to upstream document mark is arranged to empty.

S206, when transition status value meets preset changeover condition, generate downstream document.

Wherein, preset changeover condition be it is set in advance be used for judge that the Rule of judgment of document conversion can be carried out.It is default Switch condition can be specifically some state value set in advance.Downstream document is also known as target document, is turned by upstream document Change the document of generation.

Specifically, working as when the upstream document that computer equipment inquires according to upstream document mark from middle state table When preceding conversion state value meets switch condition set in advance, then downstream document is generated.When the transition status value inquired not When meeting preset changeover condition, then inconvertible prompting is returned.

In one embodiment, upstream document record represents the product information of production task, is recorded in intermediateness table It is the completion situation of upstream document mark and production task corresponding to the upstream document, document record in downstream corresponds to the production and appointed The completion of business reports the developments.It then " will can not complete " and be arranged to preset changeover condition, only when the conversion in middle state table State value is not complete man-hour, can just generate the report list of downstream document.If transition status value is to have completed, then it represents that production task It has been completed that, then need not regenerate the return list of downstream document.

S208, in intermediate data table, identified corresponding to the downstream document of upstream document mark and downstream document, under retrography The data of retrography are treated in trip document.

Wherein, intermediate data table is for storing the associated data between upstream document and downstream document, and storage point The information table of the other upstream document mark and downstream document mark that mark action is played to upstream document and downstream document.Downstream document Identify for identifying corresponding downstream document.Downstream document mark can include at least one of numeral, letter and symbol The character string of character.Downstream document mark can be specifically the unique identifier of downstream document.Retrography refers to downstream document In intermediate data table corresponding to data write-in.The data for treating retrography are needed in the document of downstream by retrography into intermediate data table Data.The data for treating retrography can be specifically to represent the associated data between upstream document and downstream document.

Specifically, for computer equipment after downstream document is generated, lookup is stored with upstream document mark and the downstream document The intermediate data table of corresponding downstream document mark, and the associated data of retrography needed for the document of downstream is write into the intermediate data The corresponding position of table.

In one embodiment, computer equipment is newly-built while upstream document corresponding to upstream document mark is created Intermediate data table, and upstream document mark is stored in the newly-built intermediate data table, corresponding downstream document mark and Associated data is arranged to empty.After downstream document is generated, downstream document mark storage corresponding to the downstream document is arrived among this In tables of data, and by the needs in the document of downstream by the associated data renewal of retrography to upstream document mark corresponding to being stored with In the intermediate data table of downstream document mark.

In one embodiment, after computer equipment gets upstream document mark, do not inquire and be stored with this The intermediateness table of document mark is swum, newly-built intermediate data table while newly-built intermediateness table, and high upstream document is identified It is stored in newly-built the intermediateness table and intermediate data table.

S210, according to correspond to upstream document mark in intermediate data table and the data of retrography that downstream document identifies, And the Changeover constraint data in upstream document corresponding to upstream document mark, update transition status value.

Wherein, the data of retrography are the data of retrography needed for the document of downstream by retrography to the number in intermediate data table According to.Constraints conversion data are to change the field value that generation downstream document plays effect of contraction in upstream document to upstream document.Constraint Change data can be specifically the total amount of data in upstream document.

Specifically, computer equipment is write in the intermediate data table for being stored with upstream document mark and downstream document mark Enter in the document of downstream after the data of retrography, obtain all retrography data newest in intermediate data table.From upstream document Changeover constraint data are obtained, according to all anti-after renewal in acquired Changeover constraint data and corresponding intermediate data table The data write, to update transition status value corresponding to upstream document mark in intermediateness table.

A kind of above-mentioned bills data processing method, need to carry out upstream document corresponding to upstream document mark when detecting When conversion generates corresponding downstream document, first determine whether that transition status value corresponding to upstream document mark is in intermediateness table It is no to meet preset changeover condition, only when transition status value meets preset changeover condition, just conversion generation downstream document, and root Intermediate data table is updated according to the data that retrography is treated in the downstream document generated, and then according to retrography in the intermediate data table Data and upstream document in Changeover constraint data update transition status value.By the way that upstream document and downstream document will be represented Between incidence relation data information memory in intermediate data table, and will represent upstream document translation state information conversion State value is stored in intermediateness table, reduces the data message stored in upstream document and downstream document, and change life Into the data message not changed during the document of downstream in upstream document, the displaying and extension of upstream document are facilitated.

In one embodiment, treating the data of retrography includes preset field name and corresponding field value；Changeover constraint data Including Changeover constraint total quantity.

Wherein, preset field name is the field name set in advance for being used for identifying some object.Field name specifically can be with It is the combination of one or more characters in numeral, alphabetical and symbol.Field name for example, can be FQTY.Field value is and field Specific value corresponding to famous prime minister.Changeover constraint total quantity is field value corresponding with certain field famous prime minister in upstream document.Conversion It can be specifically number corresponding to field name " generation total quantity " to constrain total quantity, such as 500.

In the present embodiment, the Changeover constraint number in data and upstream document that retrography is treated in the document of downstream has been described in detail According to.Every time after generation downstream document, by by the preset field name in the document of downstream and its corresponding field value retrography to middle Tables of data so that intermediate data table can record all downstreams list of the corresponding generation of the upstream document between current time comprehensively According to, and the data message of the downstream document generated.Moreover, using the Changeover constraint total quantity in upstream document under generation Verified before trip document, the probability for generating downstream document against regulation can be reduced.

In one embodiment, in bills data processing method, step S206 includes：When transition status value meets default turn When changing condition, the field value of downstream document to be written corresponding with preset field name is obtained；Obtain in intermediate data table with presetting The summation of field value corresponding to field name；Obtain the Changeover constraint total quantity in upstream document corresponding to upstream document mark；Root According to summation and Changeover constraint total quantity, the field value of downstream document to be written is verified；When verification passes through, according to be written Enter the field value generation downstream document of downstream document.

Wherein, the numerical value of downstream document is write when the field value of downstream document to be written is and generates downstream document.It is middle Field value corresponding with preset field name is the data for treating retrography corresponding to the preset field name in the document of downstream in tables of data By retrography into intermediate data table after, with one or more numerical value corresponding to the preset field name.It is in intermediate data table and pre- If field value corresponding to field name is the field value of all retrographies corresponding with the predetermined word segment value in intermediate data table.School It is the process for examining the field value of downstream document to be written whether to meet preparatory condition to test.

In one embodiment, when transition status value meets preset changeover condition, acquired in computer equipment with it is pre- If the field value of field name downstream document to be written accordingly, can be by detect it is that outside input is obtained or It is set in advance to be obtained automatically from other documents related to upstream document according to predetermined period.

In one embodiment, computer equipment obtains field value corresponding with preset field name from middle tables of data , it is necessary to be summed to all field values corresponding to the preset field name in middle tables of data during summation.

In one embodiment, intermediate data table is directly stored with the total of all field values corresponding to the preset field name With, therefore computer equipment only needs directly to read the summation from middle tables of data.

In the present embodiment, computer equipment first has to obtain after judging that transition status value meets preset changeover condition Need to write downstream document and field value corresponding with preset field name, and according in intermediate data table retrography with the field name Changeover constraint total quantity in the summation and upstream document of corresponding field value, acquired need are write with the word of downstream document Segment value is verified.Only when verification passes through, just downstream document can be generated according to the acquired field value.The checking procedure It can effectively avoid generating downstream document against regulation.

In one embodiment, according to summation and Changeover constraint total quantity, the field value of downstream document to be written is carried out The step of verification, includes：It is poor that Changeover constraint total quantity and summation are made, corresponding to acquisition preset field name can retrography field value； By can the field value of retrography and the field value of downstream document to be written be compared；When the field value of downstream document to be written is less than Or equal to can retrography field value when, verification passes through.

Wherein, can the field value of retrography refer to can be with retrography to the field value in intermediate data table in the document of downstream.Treat The field value of write-in downstream document writes downstream document when generating downstream document, and after downstream document generates, and by retrography Field value corresponding with preset field name into intermediate data table.

Specifically, computer equipment calculates accessed Changeover constraint total quantity and institute in intermediate data table in upstream document Difference between the summation of the field value of the retrography got, obtain downstream document currently can retrography into intermediate data table Field value, and by the calculating obtained can the field value of field value and above-mentioned acquired downstream document to be written of retrography enter Row compares.If the field value of downstream document to be written be less than or equal to can retrography field value, expression currently to be changed generation Downstream document be meet as defined in, then according to the field value of the downstream document to be written generate downstream document.If under to be written Swim document field value be more than can retrography field value, represent the field value of the downstream document to be written and the word of all retrographies Segment value summation has exceeded Changeover constraint total quantity specified in upstream document, that is, represents the current downstream document to be changed generation It is against regulation, therefore, downstream document will not be generated, return to inconvertible prompting.

In this embodiment, computer equipment by calculate in intermediate data table can retrography field value, and can according to this The field value of retrography verifies to the field value of downstream document to be written, only can just generate downstream document when verification passes through, Prevent because of downstream document retrography into intermediate data table and the summation of field value corresponding with preset field name exceedes upstream document In Changeover constraint total quantity and generate downstream document against regulation, improve the accuracy of generated downstream document.

In one embodiment, in bills data processing method, step S210 includes：Obtain in intermediate data table with presetting The summation of field value corresponding to field name；Obtain the Changeover constraint total quantity in upstream document corresponding to upstream document mark；Will Changeover constraint total quantity is compared with summation；According to result of the comparison, transition status value is updated.

Wherein, computer equipment obtains the step of summation of field value corresponding with preset field name in intermediate data table, It is that data for treating retrography in the document of downstream are performed after retrography to intermediate data table.In other words, this is acquired Summation is all fields in the intermediate data table including the current retrography of downstream document to the field value in intermediate data table The summation of value.

Specifically, computer equipment by the document of downstream after the data retrography of retrography to after intermediate data table, in acquisition Between in tables of data all field values corresponding with preset field name summation, and by the acquired summation and upstream document Changeover constraint total quantity is compared, according to comparative result come update in intermediateness table the upstream document identify corresponding to change State value.

In the present embodiment, the field value of all retrographies of the computer equipment in the intermediate data table after renewal Changeover constraint total quantity in summation and upstream document, to judge the current conversion state of upstream document, and according to deserving forward The transition status value changed in state renewal intermediateness table.So that before generation next time downstream document, according to the conversion after the renewal Whether state value meets preset changeover condition to prejudge, and then decides whether to generate downstream document, improves what is generated The accuracy rate of downstream document.

In one embodiment, preset changeover condition includes：Transition status value is first state value or is empty；According to comparing Result, update transition status value, including：If Changeover constraint total quantity is more than summation, transition status value is updated to first State value；If Changeover constraint total quantity is equal to summation, transition status value is updated to the second state value.

Wherein, first state value and the second state value are the parameters for identifying the transition status of document.First state Value and the second state value can be the combinations of one or more characters in Chinese character, numeral, letter and symbol.First state value and Second state value can be mutually contradictory two states.First state value can be specifically " completion ", and the second state value has Body can be " not completing ".Transition status value is sky, represents not generate corresponding downstream according to upstream document conversion before this Document.

Specifically, transition status value is that first state value or sky are set as preset changeover condition by computer equipment.Calculate Machine equipment by the downstream document generated after the data retrography of retrography is into intermediate data table, will in intermediate data table with it is pre- If the summation of all field values is compared with the Changeover constraint total data in upstream document corresponding to field name.If Changeover constraint Total quantity is more than summation, represents that upstream document does not convert also, i.e., can also generate downstream document, then by transition status value more New is first state value；If Changeover constraint total quantity is equal to summation, represent that upstream document has converted, without under regeneration Document is swum, then transition status value is updated to the second state value.

In the present embodiment, by the intermediate data table after the Changeover constraint total quantity in upstream document, and renewal Compared with the size of the summation of field value corresponding to preset field name, to judge the current conversion state of upstream document, and it will turn Beam total quantity of exchanging treaties is more than the State Transferring value updated during summation as preset changeover condition.Have been described in detail to transition status The renewal process of value, and set preset changeover condition, for the upstream document with downstream document by number constraint, further Facilitate the displaying and extension of upstream document.

In one embodiment, upstream document includes upstream business data field；Downstream document includes downstream document business Data field；Intermediateness table includes upstream document mark and transition status value；Intermediate data table include upstream document mark, under Swim document mark and the data of retrography.

In the present embodiment, in upstream document and downstream document respectively comprising corresponding upstream document traffic data field and Downstream document traffic data field, and the associated data renewal storage between upstream document and downstream document will be represented and arrive intermediateness In table and intermediate data table, reduce the data volume of upstream document, facilitate the displaying and extension of upstream document.

In one embodiment, above-mentioned bills data processing method also includes：When receiving the first displaying instruction, displaying Upstream business data field in upstream document；When receiving the second displaying instruction, according to upstream business data field with Between retrography in tables of data data and intermediateness table in transition status value create view, show the view of establishment.

In the present embodiment, the upstream business data field in upstream document can be individually shown, can also be according to upstream The data creation view in upstream document traffic data field and intermediateness table and intermediate data table in document, and open up Show created view, improve the flexibility of document displaying, further facilitated the displaying of document.

In one embodiment, in above-mentioned bills data processing method, when carrying out document displaying, upstream can only be shown Data in document.The business datum of the upstream document is only recorded in upstream document, without recording and associating between other documents Data.Reduce the data volume recorded in the upstream document so that displaying speed faster, and can easily increase other words Section so that document displaying is more convenient.

In one embodiment, upstream document can be the product information of record production.The product recorded in upstream document Information can specifically include one in material of product type, product total number, the color of product and production product produced etc. Kind or much information.

In one embodiment, upstream document and its corresponding associated data if desired are shown simultaneously, then can passes through root According to upstream document, and corresponding with upstream document intermediate data table creates the mode of view and is shown.In other words, Intermediate data table corresponding to upstream document and the upstream document is merged into individual data table, the individual data is shown by inquiring about Table can show simultaneously upstream document and and its associated data, effectively prevent while inquire about efficiency caused by multiple tables of data The problem of low.

As shown in figure 3, in a specific embodiment, the bills data processing method specifically includes following steps：

S302, obtain upstream document mark.

S304, transition status value corresponding with upstream document mark is inquired about in intermediateness table.

S306, judges whether transition status value meets preset changeover condition, if so, jumping to step S308；If it is not, then jump Go to step S310.

S308, obtain the field value of downstream document to be written corresponding with preset field name.

S310, prompt not convertible.

S312, obtain the Changeover constraint total quantity in upstream document corresponding to upstream document mark.

S314, obtain the summation of field value corresponding with preset field name in intermediate data table.

S316, it is poor that summation acquired in Changeover constraint total quantity and step S314 is made, and it is corresponding to obtain preset field name Can retrography field value.

S318, judge downstream document to be written field value whether be less than or equal to can retrography field value, if so, then jumping Go to step S320；If it is not, then jump to step S322.

S320, downstream document is generated according to the field value of downstream document to be written.

S322, prompt not convertible.

S324, in intermediate data table, identified corresponding to the downstream document of upstream document mark and downstream document, under retrography The data of retrography are treated in trip document, this treats that the data of retrography include preset field name and corresponding field value.

S326, the Changeover constraint total quantity in upstream document corresponding to upstream document mark is obtained again.

S328, obtain the summation of field value corresponding with preset field name in intermediate data table.

S330, if Changeover constraint total quantity is more than summation acquired in step S328, transition status value is updated to First state value.

S332, if Changeover constraint total quantity is equal to summation acquired in step S328, transition status value is updated to Second state value.

In the present embodiment, computer equipment obtains first when to change generation downstream document according to upstream document Upstream document mark corresponding to document is swum, and judges that State Transferring value corresponding with upstream document mark is sentenced in intermediateness table It is disconnected whether to meet preset changeover condition.When meeting preset changeover condition, the field value of downstream document to be written is obtained, and according to Changeover constraint total quantity in upstream document, and in intermediate data table all field values corresponding with preset field famous prime minister it is total With to be verified to the field value of acquired downstream document to be written.By the above-mentioned process for judging verification twice, to determine It is fixed whether to generate downstream document, effectively to avoid generating downstream document against regulation.After downstream document is generated, by under this Retrography data retrography is treated into intermediate data table in trip document, and according in the intermediate data table and upstream document after the renewal Changeover constraint total amount of data update the State Transferring value in intermediateness table, to generate conduct before the document of downstream in next time Basis for estimation, the accuracy of generated downstream document is improved, so as to improve the efficiency of document conversion.

In a specific application scenarios, the product information of upstream document S record productions, corresponding to the upstream document on Trip document is identified as S-001, and upstream document mark can be specifically upstream document major key.Wherein, turn in the upstream document Exchange treaties beam total quantity, i.e., needed for the product total quantity of production be 10.Document D records in downstream correspond to product in the upstream document Completion report information, wherein, corresponding to the document of downstream downstream document mark can be specifically downstream document major key.The applied field Jing Zhong, preset changeover condition are State Transferring value not complete or empty.From carry out for the first time completion report generation downstream document to Generation downstream document is reported in last time completion, and the bills data processing method specifically includes following processing procedure：

When carrying out completion for the first time and reporting generation downstream document, product has completed 2, i.e. now downstream document to be written Field value corresponding to field name FQTY is 2.Now the State Transferring value in intermediateness table is sky, and expression can report, and In intermediate data table, corresponding to upstream document major key S-001 and the field name and field of downstream document major key D-001 retrography It is worth to be empty, then directly generates downstream document corresponding to the document mark D-001 of downstream, and retrography will be treated in the document D-001 of downstream Field name FQTY and its corresponding field value 2, recorded in intermediate data table, obtain following intermediate data table：

Then further according to the upstream field value 2 of retrography and product total quantity 10 judge upstream in above-mentioned intermediate data table Transition status value current document S, that is, complete situation, because the upstream field value 2 of retrography is less than product total quantity 10, represents production Product are not completed also, therefore transition status value corresponding to upstream document major key S-001 is updated to not complete, and are recorded in centre State table：

Field name	Upstream document major key	Upstream document state
			Field value	S-001	Do not complete

When carrying out completion report generation downstream document for the second time, the product in upstream document S has completed 8 again.Now, in Between transition status value in state table not complete, explanation can continue to report.The quantity now reported in intermediate data table For 2, product total quantity is 10, and the quantity that can be reported by can be calculated this is 8, and the quantity 8 that need to be reported with this is just It is equal, therefore verification passes through, and can generate downstream document D-002.And by treated in the document D-002 of downstream retrography field name FQTY and Its corresponding field value 8, continues to recorded in intermediate data table, obtains following intermediate data table：

Further according to the summation 10 and product total quantity of the retrography upstream field value recorded twice in newest intermediate data table 10 are compared, and the two is equal, then it represents that complete, therefore by transition status value corresponding to upstream document major key S-001 more New is to have completed, and is updated to intermediateness table：

Field name	Upstream document major key	Upstream document state
			Field value	S-001	Complete

When third time carries out completion report generation downstream document, now, the transition status value in intermediateness table is complete Work, is unsatisfactory for report condition, then provides prompting, not convertible.

As shown in figure 4, in one embodiment, there is provided a kind of bills data processing unit 400.Reference picture 4, the document Data processing equipment 400 includes：Identifier acquisition module 401, state value enquiry module 402, document generation module 403, data are anti- Writing module 404 and state value update module 405.

Identifier acquisition module 401, for obtaining upstream document mark.

State value enquiry module 402, for the inquiry in intermediateness table and the corresponding transition status of upstream document mark Value.

Document generation module 403, for when transition status value meets preset changeover condition, generating downstream document.

Data retrography module 404, in intermediate data table, the downstream with downstream document to be identified corresponding to upstream document Document is identified, and the data of retrography are treated in the document of retrography downstream.

State value update module 405, for being identified and downstream document mark corresponding to upstream document according in intermediate data table Changeover constraint data in upstream document corresponding to data and the upstream document mark for the retrography known, update transition status Value.

A kind of above-mentioned bills data processing unit, need to carry out upstream document corresponding to upstream document mark when detecting When conversion generates corresponding downstream document, first determine whether that transition status value corresponding to upstream document mark is in intermediateness table It is no to meet preset changeover condition, only when transition status value meets preset changeover condition, just conversion generation downstream document, and root Intermediate data table is updated according to the data that retrography is treated in the downstream document generated, and then according to retrography in the intermediate data table Data and upstream document in Changeover constraint data update transition status value.By the way that upstream document and downstream document will be represented Between incidence relation data information memory in intermediate data table, and will represent upstream document translation state information conversion State value is stored in intermediateness table, reduces the data message stored in upstream document and downstream document, and change life Into the data message not changed during the document of downstream in upstream document, the displaying and extension of upstream document are facilitated.

In one embodiment, bills data processing unit 400 also includes：Field value acquisition module 406, summation obtain mould Block 407, total quantity acquisition module 408 and field value correction verification module 409.

Field value acquisition module 406, for when transition status value meets preset changeover condition, obtaining and preset field name The field value of corresponding downstream document to be written；

Summation acquisition module 407, for obtaining the summation of field value corresponding with preset field name in intermediate data table；

Total quantity acquisition module 408, for obtaining the Changeover constraint sum in upstream document corresponding to upstream document mark Amount；

Field value correction verification module 409, for according to summation and Changeover constraint total quantity, to the field of downstream document to be written Value is verified；

Document generation module 403 is additionally operable to when verification passes through, and downstream is generated according to the field value of downstream document to be written Document.

In one embodiment, field value correction verification module 409 is additionally operable to Changeover constraint total quantity and summation making poor, acquisition Corresponding to preset field name can retrography field value；By can the field value of retrography and the field value of downstream document to be written compared Compared with；When downstream document to be written field value be less than or equal to can retrography field value when, verification passes through.

In one embodiment, summation acquisition module 407 is additionally operable to corresponding with preset field name in acquisition intermediate data table Field value summation；Total quantity acquisition module 408 is additionally operable to obtain the conversion in upstream document corresponding to upstream document mark Constrain total quantity；Field value correction verification module 409 is additionally operable to Changeover constraint total quantity compared with summation；State value updates mould Block 405 is additionally operable to, according to result of the comparison, update transition status value.

In one embodiment, preset changeover condition includes：Transition status value is first state value or is empty；State value is more If new module 405, which is additionally operable to Changeover constraint total quantity, is more than summation, transition status value is updated to first state value；If conversion Constraint total quantity is equal to summation, then transition status value is updated into the second state value.

In one embodiment, bills data processing unit 400 also includes：Document display module 410.

Document display module 410, for when receiving the first displaying instruction, showing the upstream business number in upstream document According to field；When receiving the second displaying instruction, the number of the retrography in upstream business data field and intermediate data table According to and intermediateness table in transition status value create view, show the view of establishment.

A kind of computer equipment, including memory and processor, memory storage have computer program, computer program quilt During computing device so that computing device following steps：Obtain upstream document mark；Inquiry and upstream in intermediateness table Transition status value corresponding to document mark；When transition status value meets preset changeover condition, downstream document is generated；In mediant According in table, corresponding to upstream document mark and the downstream document mark of downstream document, the data of retrography are treated in the document of retrography downstream； According to the data and upstream document mark of the retrography for corresponding to upstream document mark and downstream document mark in intermediate data table Changeover constraint data in upstream document corresponding to knowledge, update transition status value.

In one embodiment, when transition status value meets preset changeover condition, downstream document is generated, including：When turn When changing state value and meeting preset changeover condition, the field value of downstream document to be written corresponding with preset field name is obtained；Obtain The summation of field value corresponding with preset field name in intermediate data table；Obtain in upstream document corresponding to upstream document mark Changeover constraint total quantity；According to summation and Changeover constraint total quantity, the field value of downstream document to be written is verified；Work as school Test by when, according to the field value of downstream document to be written generate downstream document.

In one embodiment, according to summation and Changeover constraint total quantity, the field value of downstream document to be written is carried out Verification, including：It is poor that Changeover constraint total quantity and summation are made, corresponding to acquisition preset field name can retrography field value；Can The field value of the field value of retrography and downstream document to be written is compared；When the field value of downstream document to be written is less than or waits In can retrography field value when, verification passes through.

In one embodiment, it is anti-according to being identified in intermediate data table corresponding to upstream document mark and downstream document Changeover constraint data in upstream document corresponding to data and the upstream document mark write, update transition status value, including： Obtain the summation of field value corresponding with preset field name in intermediate data table；Obtain upstream document corresponding to upstream document mark In Changeover constraint total quantity；By Changeover constraint total quantity compared with summation；According to result of the comparison, transition status is updated Value.

In one embodiment, computer program also causes computing device following steps：Refer to when receiving the first displaying When making, the upstream business data field in upstream document is shown；When receiving the second displaying instruction, according to upstream business data Transition status value in the data and intermediateness table of retrography in field and intermediate data table creates view, displaying wound The view built.

Above computer equipment, need to carry out upstream document corresponding to upstream document mark conversion generation phase when detecting During the downstream document answered, first determine whether transition status value corresponding to upstream document mark meets to preset in intermediateness table Switch condition, only when transition status value meets preset changeover condition, just conversion generation downstream document, and according to being generated The data of retrography are treated in the document of downstream to update intermediate data table, and then according to data of retrography and upper in the intermediate data table The Changeover constraint data in document are swum to update transition status value.By the way that incidence relation between upstream document and downstream document will be represented Data information memory in intermediate data table, and will represent upstream document translation state information transition status value storage In intermediateness table, reduce the data message stored in upstream document and downstream document, and change generation downstream document During do not change data message in upstream document, facilitate the displaying and extension of upstream document.

A kind of computer-readable recording medium, computer program is stored with, when the computer program is executed by processor, So that the computing device following steps：Obtain upstream document mark；Inquiry identifies with upstream document in intermediateness table Corresponding transition status value；When transition status value meets preset changeover condition, downstream document is generated；In intermediate data table, Corresponding to upstream document mark and the downstream document mark of downstream document, the data of retrography are treated in the document of retrography downstream；In Between correspond to upstream document mark in tables of data and the data of retrography that downstream document identifies and upstream document mark it is corresponding Upstream document in Changeover constraint data, update transition status value.

Above computer readable storage medium storing program for executing, need to turn upstream document corresponding to upstream document mark when detecting Change when generating corresponding downstream document, whether first determine whether in intermediateness table transition status value corresponding to upstream document mark Meet preset changeover condition, only when transition status value meets preset changeover condition, just change and generate downstream document, and according to The data of retrography are treated in the downstream document generated to update intermediate data table, and then according to retrography in the intermediate data table Changeover constraint data in data and upstream document update transition status value.By that will represent between upstream document and downstream document The data information memory of incidence relation is in intermediate data table, and will represent the conversion shape of the translation state information of upstream document State value is stored in intermediateness table, reduces the data message stored in upstream document and downstream document, and change generation Do not change the data message in upstream document during the document of downstream, facilitate the displaying and extension of upstream document.

One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with The hardware of correlation is instructed to complete by computer program, described program can be stored in a non-volatile computer and can be read In storage medium, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, it is provided herein Each embodiment used in any reference to memory, storage, database or other media, may each comprise non-volatile And/or volatile memory.Nonvolatile memory may include that read-only storage (ROM), programming ROM (PROM), electricity can be compiled Journey ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include random access memory Or external cache (RAM).By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) directly RAM (RDRAM), straight Connect memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..

Each technical characteristic of above example can be combined arbitrarily, to make description succinct, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, lance is not present in the combination of these technical characteristics Shield, all it is considered to be the scope of this specification record.

Embodiment described above only expresses the several embodiments of the present invention, and its description is more specific and detailed, but simultaneously Therefore the limitation to the scope of the claims of the present invention can not be interpreted as.It should be pointed out that for one of ordinary skill in the art For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the guarantor of the present invention Protect scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.

Claims

1. a kind of bills data processing method, methods described include：

Obtain upstream document mark；

In intermediate data table, corresponding to upstream document mark and the downstream document mark of the downstream document, retrography institute State the data that retrography is treated in the document of downstream；

According to the number for the retrography for corresponding to upstream document mark and downstream document mark in the intermediate data table According to and upstream document mark corresponding to Changeover constraint data in upstream document, update the transition status value.

2. according to the method for claim 1, it is characterised in that the data for treating retrography are including preset field name and accordingly Field value；The Changeover constraint data include Changeover constraint total quantity.

3. according to the method for claim 2, it is characterised in that described when the transition status value meets preset changeover condition When, downstream document is generated, including：

When the transition status value meets preset changeover condition, it is single to obtain downstream to be written corresponding with the preset field name According to field value；

According to the summation and the Changeover constraint total quantity, the field value of downstream document to be written is verified；

4. according to the method for claim 3, it is characterised in that described total according to the summation and the Changeover constraint Amount, is verified to the field value of downstream document to be written, including：

It is poor that the Changeover constraint total quantity and the summation are made, obtain corresponding to the preset field name can retrography field Value；

5. according to the method for claim 2, it is characterised in that described to correspond to according in the intermediate data table on described Swim upstream document corresponding to the data and upstream document mark of the retrography of document mark and downstream document mark In Changeover constraint data, update the transition status value, including：

By the Changeover constraint total quantity compared with the summation；

6. according to the method for claim 5, it is characterised in that the preset changeover condition includes：The transition status value For first state value or it is empty；

7. according to the method for claim 1, it is characterised in that the upstream document includes upstream business data field；Institute Stating downstream document includes downstream document traffic data field；The intermediateness table includes upstream document mark and described turn Change state value；The intermediate data table includes the number of upstream document mark, downstream document mark and the retrography According to.

8. according to the method for claim 7, it is characterised in that methods described also includes：

When receiving the second displaying instruction, according in the upstream business data field and the intermediate data table The transition status value in the data of retrography and the intermediateness table creates view, shows the view of establishment.

9. a kind of bills data processing unit, it is characterised in that described device includes：

Identifier acquisition module, for obtaining upstream document mark；

State value enquiry module, for inquiring about transition status value corresponding with upstream document mark in intermediateness table；

Data retrography module, in intermediate data table, corresponding under upstream document mark and the downstream document Document mark is swum, the data of retrography are treated in downstream document described in retrography；

State value update module, for single according to upstream document mark and the downstream is corresponded in the intermediate data table According to the Changeover constraint data in upstream document corresponding to the data of the retrography of mark and upstream document mark, renewal The transition status value.

10. device according to claim 9, it is characterised in that described device also includes：Field value acquisition module, summation Acquisition module, total quantity acquisition module and field value correction verification module；

Field value acquisition module, for when the transition status value meets preset changeover condition, obtaining and the preset field The field value of the corresponding downstream document to be written of name；

Summation acquisition module, for obtaining the summation of field value corresponding with the preset field name in intermediate data table；

Total quantity acquisition module, for obtaining the Changeover constraint total quantity in upstream document corresponding to the upstream document mark；

Field value correction verification module, for according to the summation and the Changeover constraint total quantity, to the institute of downstream document to be written Field value is stated to be verified；

Document generation module, it is additionally operable to when the verification passes through, under being generated according to the field value of downstream document to be written Swim document.

11. a kind of computer equipment, including memory and processor, the memory storage has computer program, the calculating When machine program is by the computing device so that the step of method any one of the computing device claim 1 to 8 Suddenly.

12. a kind of computer-readable recording medium, computer program is stored with, when the computer program is executed by processor, So that any one of the computing device claim 1 to 8 the step of method.