CN109597979A - Inventory table generation method, device, computer equipment and storage medium - Google Patents
Inventory table generation method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109597979A CN109597979A CN201811435465.4A CN201811435465A CN109597979A CN 109597979 A CN109597979 A CN 109597979A CN 201811435465 A CN201811435465 A CN 201811435465A CN 109597979 A CN109597979 A CN 109597979A
- Authority
- CN
- China
- Prior art keywords
- inventory
- target
- data information
- information
- data
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
This application involves a kind of inventory table generation method, device, computer equipment and storage mediums.The described method includes: being generated based on the inventory table and included control information being instructed to obtain corresponding target inventory when receiving the generation instruction of inventory table；The target data information that the target inventory is included is obtained, and identifies and determines the corresponding category attribute of the target data information；It generates to obtain the corresponding inventory table of the target inventory based on the corresponding category attribute of the target data information.It uses this method that can completely export target inventory to generate and obtain corresponding inventory table, and preserves corresponding incidence relation between the data information in obtained inventory table, do not need to carry out format setting to inventory table again.
Description
Technical field
This application involves architectural engineering technical field of data processing, more particularly to a kind of inventory table generation method, dress
It sets, computer equipment and computer readable storage medium.
Background technique
In architectural engineering industry, multiple valuation and Cost Management System are had existed, user can be valuated by these
And Cost Management System software carries out list of engineering establishment and cost management.But since the popularity rate of valuation software is too late
The teleworkings such as Excel software is high, is typically necessary the good inventory of software programming that will valuate and carries out export use.
Current valuation software existing on the market and Cost Management System, when exporting inventory, obtained table is only
It is able to satisfy the function that data are checked, and the set good calculation formula, data in advance in pricing system and cost management software
The information such as incidence relation can not be exported.Since table derived from institute is sufficiently complete, so that user is obtaining derived table
When, it is also necessary to it carries out corresponding format information in table to re-start setting again, just can be carried out corresponding operation.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of inventory table that can completely export inventory table
Generation method, device, computer equipment and storage medium.
A kind of inventory table generation method, which comprises
When receiving the generation instruction of inventory table, is generated based on the inventory table and included control information is instructed to obtain
To corresponding target inventory；
The target data information that the target inventory is included is obtained, and identifies and determines that the target data information is corresponding
Category attribute；
It generates to obtain the corresponding inventory table of the target inventory based on the corresponding category attribute of the target data information.
In one of the embodiments, further include:
It obtains the inventory and generates the included control information of instruction, and based on inventory included in the control information
Mark is inquired in preset list database, obtains the corresponding target inventory of the inventory mark.
In one of the embodiments, further include:
Based on the target data information that the target inventory is included, generation obtains corresponding homepage label table；
It is raw based on the bookmark information that the corresponding category attribute of the target data information and the target inventory are included
At obtaining the corresponding subpage label table of the target inventory；
The homepage label table and subpage label table are summarized, the corresponding inventory table of the target inventory is obtained.
In one of the embodiments, further include:
The target data information that the target inventory is included is read, and obtains category attribute in the target data information
For the editable data information of editable classification, and the editable data are summarized and go to re-generate to obtain comprising described
The homepage label table of editable data information.
In one of the embodiments, further include:
Based on the bookmark information that target inventory is included, data associated by target bookmark are read from target data information
Information, and obtaining category attribute in data information associated by the target bookmark is the other fixed data information of fixed class；
Preset list form template is obtained, determines first of the fixed data information in the inventory form template
Confidence breath；
Based on the first location information, the fixed data information is directed into the inventory form template, is generated
Obtain subpage label table corresponding to target bookmark.
In one of the embodiments, further include:
Obtaining category attribute in the data information that the target bookmark is included is the calculating data information for calculating classification；
Determine computation rule corresponding to the calculating data information, and when the computation rule is not that can recognize rule
Recognizable computation rule is converted by the computation rule；
Determine second location information of the calculating data information in corresponding subpage label table, and by the computation rule
It is directed into position corresponding to the second location information.
In one of the embodiments, further include:
Data Identification included in the subpage label table is obtained, and is identified based on the data in the homepage label table
The corresponding data information to be imported of the Data Identification is obtained in lattice, and the data information to be imported is directed into the subpage
It signs in table；
When the data information in the homepage label table is modified, the data mark by modification data information is obtained
Know, and data update is carried out to the subpage label table comprising the Data Identification.
A kind of inventory table generating means, described device include:
Inventory obtains module, for generating instruction based on the inventory table when receiving the generation instruction of inventory table
The control information for being included obtains corresponding target inventory；
Attribute determination module, the target data information for being included for obtaining the target inventory, and identify described in determination
The corresponding category attribute of target data information；
Table generation module is clear for generating to obtain the target based on the corresponding category attribute of the target data information
Single corresponding inventory table.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device performs the steps of when executing the computer program
When receiving the generation instruction of inventory table, is generated based on the inventory table and included control information is instructed to obtain
To corresponding target inventory；
The target data information that the target inventory is included is obtained, and identifies and determines that the target data information is corresponding
Category attribute；
It generates to obtain the corresponding inventory table of the target inventory based on the corresponding category attribute of the target data information.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
It is performed the steps of when row
When receiving the generation instruction of inventory table, is generated based on the inventory table and included control information is instructed to obtain
To corresponding target inventory；
The target data information that the target inventory is included is obtained, and identifies and determines that the target data information is corresponding
Category attribute；
It generates to obtain the corresponding inventory table of the target inventory based on the corresponding category attribute of the target data information.
Above-mentioned inventory table generation method, device, computer equipment and storage medium refer to receiving the generation of inventory table
When enabling, inventory table, which generates, based on the received instructs included control information to obtain corresponding target inventory, then obtains
The data information that target is included is taken, and identifies and determines category attribute corresponding to acquired data information, finally according to number
It is believed that ceasing category attribute affiliated respectively generates to obtain inventory table corresponding to target inventory.It realizes and is generated in inventory table
During, category attribute corresponding to data information included in target inventory is identified first, then according to data information
Category attribute generate to obtain the inventory table of target inventory exist between data information so that generating in obtained inventory table
Corresponding incidence relation does not need to re-establish corresponding relationship to the data information in inventory table.
Detailed description of the invention
Fig. 1 is the applied environment figure of inventory table generation method in one embodiment；
Fig. 2 is the flow diagram of inventory table generation method in one embodiment；
Fig. 3 is flow diagram the step of generating inventory table in one embodiment；
Fig. 4 is flow diagram the step of generating subpage label table in one embodiment；
Fig. 5 is flow diagram the step of generating subpage label table in another embodiment；
Fig. 6 is the structural block diagram of inventory table generating means in one embodiment；
Fig. 7 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Inventory table generation method provided by the embodiments of the present application, can be applied in application environment as shown in Figure 1.Its
In, terminal 102 is communicated with server 104 by network by network.Terminal 102 is receiving the generation instruction of inventory table
When, inventory table is generated into instruction and is sent to server 104, so that server 104 instructs table to generate instruction according to inventory
Then the corresponding target inventory of the control acquisition of information for being included reads target data information included in target inventory, and
Identify category attribute corresponding to target data, and then the category attribute according to corresponding to target data generates to obtain target inventory
Corresponding inventory table, last terminal 102 will obtain the inventory table generated of server 104.Wherein, terminal 102 can with but
It is not limited to various personal computers, laptop, smart phone, tablet computer and portable wearable device, server
104 can be realized with the server cluster of the either multiple server compositions of independent server.
In one embodiment, as shown in Fig. 2, providing a kind of inventory table generation method, it is applied to Fig. 1 in this way
In terminal for be illustrated, comprising the following steps:
Step 202, it when receiving the generation instruction of inventory table, is generated based on inventory table and instructs included control letter
Breath obtains corresponding target inventory.
Wherein, inventory table generates instruction as the control instruction of progress inventory table generation.Control information is inventory table
Generate the command information other than inventory table generates instruction entrained in instruction.Target inventory is for obtaining tablet menu
The foundation of lattice.
When expected end receiver to inventory table, which generates, to be instructed, identifies and obtain included in the generation instruction of inventory table
Information is controlled, the corresponding target inventory for carrying out the generation of inventory table is then obtained according to obtained control information, wherein control
It include the identification information for carrying out the inventory of inventory table generation in information.Specifically, terminal is receiving inventory generation instruction
When, identification inventory generates inventory mark included in control information included in instruction, is then based on inventory mark pre-
If carrying out match query in inventory database, to obtain the corresponding target inventory of inventory mark.
It should be noted that inventory table, which generates instruction, to be triggered based on user's carry out corresponding operation at the terminal
, it can be the virtual key that the generation of inventory table is carried out by touching the representative in terminal display interface, specifically instruction touching
Originating party formula is unlimited.
Step 204, the data information that target inventory is included is obtained, and identifies the corresponding classification category of determining data information
Property.
Wherein, category attribute is the category feature of data information, and is existed between the different corresponding data of category attribute
Corresponding incidence relation.
Specifically, terminal is after obtaining target inventory, it will reads the data information that target inventory is included, and knows
Not Que Ding target inventory included data information corresponding to category attribute.In practical applications, raw in trigger list table
When at instruction, terminal will control information from there are the default of bill of quantities according to included in the generation instruction of inventory table
It is inquired in inventory database, to obtain corresponding target inventory, and then reads data information included in target inventory,
And category attribute corresponding to recognition data and information.
For a bill of quantities, the category attribute of data information included in inventory is generally divided into editable
Classification, fixed classification and calculating classification.Wherein data information corresponding to editable classification be user can carry out editor repair
The data information changed, the corresponding data information of fixed classification are to be present in inventory and the not modifiable data information of information, than
Such as project number, project name, item characteristic description, unit and project amount attribute information, calculate number corresponding to classification
According to be based on obtained from the corresponding data of editable classification, that is, calculate data corresponding to classification it is self-contained have it is corresponding
Data information computation rule.
Step 206, it generates to obtain the corresponding inventory table of target inventory based on the corresponding category attribute of data information.
Wherein, inventory table be Downloadable electronic document, as Excel or other can carry out the office of Table edit
Software.
Specifically, terminal is obtaining target inventory and is identifying the category attribute of the data information that determining target inventory is included
Later, the category attribute according to corresponding to data information generates to obtain inventory table corresponding to target inventory.In target inventory
There is certain incidence relation between the data information for being included, for example, category attribute be calculate the data information of classification with can
Edit corresponding to classification between data information that belong to the attribute information for calculating classification there are certain calculated relationship be based on can
Data information corresponding to classification is edited according to obtained from corresponding data computation rule, and belongs to the other data of fixed class
There is corresponding corresponding relationships between information and the data information of editable classification and the data information of calculating classification.
In above-mentioned inventory table generation method, when receiving inventory table and generating instruction, inventory based on the received
It generates and included control information is instructed to obtain corresponding target inventory, then obtain the data information that target is included, and know
Category attribute corresponding to data information that Que Ding be acquired is finally generated according to category attribute belonging to data information difference
Obtain inventory table corresponding to target inventory.It realizes during inventory table generates, first in identification target inventory
Then category attribute corresponding to the data information for being included generates to obtain target inventory according to the category attribute of data information
Inventory table, so that not needed there are corresponding incidence relation to inventory between data information in the inventory table that generation obtains
Data information in table re-establishes corresponding relationship.
In one embodiment, as shown in figure 3, step 206, generates to obtain mesh based on the corresponding category attribute of data information
The corresponding inventory table of SD list, comprising:
Step 302, the data information for being included based on target inventory, generation obtain corresponding homepage label table.
When generating inventory table, corresponding subpage label table is generated in addition to data associated by different bookmark information can correspond to
Except lattice, all data informations that can also included according to target inventory generate to obtain corresponding homepage label table.Specifically, eventually
All data informations that target inventory is included are read at end, are then generated to obtain corresponding homepage according to obtained data information
Sign table, wherein it include the corresponding data of editable classification in data information in homepage label table, and for homepage label table
The data stored in lattice can correspond to the related information for storing each data information, the son being respectively associated with each data information of determination
Bookmark.
In practical applications, target inventory is when generation obtains inventory table, in the data for obtaining target inventory and being included
When information, identification determines the category attribute of obtained data information, then believes the data that category attribute is editable classification
Breath, which is summarized to obtain in corresponding homepage label table, that is, homepage label table, is stored with editable all in target inventory
Data information, in addition, data information associated by different bookmark information will also be present in corresponding subpage label table, in turn
Realize the incidence relation between the data information in the data information and homepage label table in subpage label table.
The data information being present in homepage label table is the set of editable data information in all subpage label tables,
It include that will also carry out corresponding data by the subpage label of modification data when some data in homepage label table are modified
It updates, does not need to including successively to be modified update by the subpage label of modification data.
Step 304, the bookmark information for being included based on the corresponding category attribute of data information and target inventory, generates
To the corresponding subpage label table of target inventory.
It wherein, include multiple and different subdivisional works in target inventory, different subdivisional works corresponds to different pages
Information is signed, bookmark information is the description to the characteristic information of subdivisional work, and subpage label table is subdivisional work institute in target inventory
The inventory table that corresponding data information generates, it should be noted that the editable data in subpage label table are right respectively
The related information answered is fixed and invariable, and will not be modified incidence relation with the change of data information, there is variation
Be only subpage label table included in data information, specifically become according to the change of the data in subpage label table
Change.
It specifically, include several bookmark information in target inventory, different bookmark information corresponds to different data letters
Breath, terminal is after obtaining the corresponding category attribute of data information that target inventory is included, according to corresponding to data information
What the bookmark information that category attribute and target inventory are included generated arrives subpage label table corresponding to target inventory, subpage label
Data information associated by corresponding bookmark information is stored in table.
It in practical applications, include several subdivisional works in target inventory, and each subdivisional work has corresponding bookmark
Information and correspond to corresponding data information, wherein may deposit between data information included in different subdivisional works
In certain relationship, for example data information is identical or there are corresponding incidence relations.When generating inventory table, different points
Item engineering generates different subpage label tables, and different partitioned project, construction unit and individual works can be according to inventory
There are corresponding different subpage label tables for the actual demand of table.
Step 306, homepage label table and subpage label table are summarized, obtains the corresponding inventory table of target inventory.
Specifically, after obtaining subpage label table and homepage label table, subpage label table is carried out in homepage label table
Summarize, generate obtain include different bookmarks mark inventory table.When generating inventory table, each subpage label table is independent
It is existing, that is, data information included in subpage label table not will receive data included in other subpage label tables
The influence of information, when being summarized subpage label table and homepage label table to obtain inventory table corresponding to target inventory,
Different bookmarks is shown and is shown on interface in different tables.
In the present embodiment, it is generated to obtain corresponding homepage label table according to the data information that target inventory is included, and
Category attribute corresponding to the bookmark information and data information for being included according to target inventory generates to obtain corresponding subpage label
Table finally summarizes homepage label table and subpage label table, inventory table corresponding to target inventory is obtained, wherein clearly
It include homepage label table and subpage label table in single table.By the way that all editable data are summarized to obtain homepage
Table is signed, so that when modifying to the data information in inventory, it is necessary first to believe the data in homepage label inventory table
Breath is modified, and then subpage label table associated with modification data information will will do it data and update, and is avoided in data
The case where successively modifying to the data in sub- bookmark is needed when information changes.
In the present embodiment, due to set the data in subpage label table as can not editing mode, to tablet menu
It when data in lattice are modified, needs to modify to corresponding data in homepage label table, and then when completing modification
The data stored in subpage label table are updated, data update mainly is carried out to the data modified.Further, may be used also
It is in editable state with the data in setting section subpage label table, but the data in not all subpage label table are equal
Edit-modify can be carried out, can be according to the actual demand of staff, set some data is in specific subpage label table
Editable state, and be still in other subpage label tables can not editing mode, and editable subpage label table
Setting can according to actual needs, such as the frequency of use etc. of subpage label table, such as data A, it is assumed that there are in subpage
It signs in table 1,2 and 3, and setting data A is editable state in subpage label table 1 according to actual needs, in subpage label
In table 2 and 3 for can not editing mode, if then when checking subpage label table 1 want modify to data A, can be straight
Edlin modification is tapped into, and when edit-modify is completed, the data A in sub- bookmark table 2 and 3 is updated, while right
Data A in homepage label table is also updated.
In one embodiment, as shown in figure 4, step 302, clear based on the corresponding category attribute of data information and target
Single bookmark information for being included, generation obtain the corresponding subpage label table of target inventory, comprising:
Step 402, the bookmark information for being included based on target inventory reads target bookmark from target data information and is wrapped
The data information contained, and obtain in the data information that target bookmark is included category attribute be the other fixed number of fixed class it is believed that
Breath.
Step 404, default subpage label form template is obtained, determines first of fixed data information in inventory form template
Location information.
Step 406, it is based on first location information, fixed data information is directed into subpage label form template, is generated
To subpage label table corresponding to target bookmark.
Specifically, when generation obtains subpage label table, it is necessary first to determine the current mesh for carrying out subpage label table and generating
It marks bookmark, and then from reading data information associated in target bookmark in target data information, and obtains acquired and mesh
Marking category attribute in the associated data information of bookmark is the other fixed data information of fixed class, then obtains default subpage label table
Grid template, to determine first location information of the fixed data in subpage label form template, finally according to identified first
Fixed data information is directed into obtained subpage label form template by confidence breath, is obtained corresponding to target bookmark with generating
Subpage label table.
In practical applications, each subdivisional work included in target inventory corresponds to a bookmark information, for one
For bill of quantities, because data information included in bill of quantities is more huge, if all data are believed
, will be very complicated when carrying out data information search when breath generates export in a table, since bill of quantities is by not
Inventory corresponding to same subdivisional work is formed, therefore when generating to obtain corresponding target table based on target inventory, can
Several subpage label inventories are obtained to generate, and the set of data information included in all subpage label inventories is target
The data information that inventory is included.
When generation obtains subpage label table, data information associated by target bookmark is obtained first, and obtain page object
Category attribute is fixed classification fixed data information in the associated data information of label, wherein fixed data information is can not be more
The attribute informations such as the data information changed, such as the description of project number, project name, item characteristic, unit and project amount, together
When, the subpage label form template for generating subpage label table is obtained, then determines fixed data information in subpage label form template
Location information, it is generally the case that position of the fixed data information in subpage label form template is fixed, for example is present in
In the gauge outfit of table and in the first row of table.For subpage label table, it is not intended to place fixed data in table
For other cells of information for importing corresponding editable data, all data informations in target bookmark have respective correspondence
Data Identification, for determining position of the data information in obtained table.
In the present embodiment, obtained subpage label table is other than including fixed data information, further includes that have can
Data information and others are edited in the associated data information of target bookmark.For needing to be directed into subpage label table
Editable data information, since all editable data are stored in homepage label table, by determine subpage label table with
The incidence relation of subpage label table obtains corresponding editable data information from homepage label table, to be directed into subpage label table
In lattice, without carry out editable data information importing when, for the data information in each subpage label table into
Row individually imports.
Further, according to generate corresponding inventory table when, subpage label table be according to the demand of practical inventory and
It obtains, and all editable data are present in homepage label table.In practical applications, subpage is obtained in generation
When signing table, in addition to obtaining corresponding subpage label table according to the demand of editable data and inventory table in homepage label table
Except lattice, the generation of second level subpage label table can also be carried out, it is root that second level subpage label table, which is also one kind of subpage label table,
A kind of subpage label table generated according to subpage label table, when generation obtains second level subpage label table, data base at this time
Plinth will be partial data included in the subpage label table of part.For example, need to the associated data of a certain characteristic
Summarized, before this there are three the subpage label tables associated with this characteristic, respectively subpage label table 1, subpage label
Table 2 and subpage label table 3, if the data for calculating belonging in three sub- bookmark tables classification is needed to summarize at this time
When, it will directly acquire and belong to the data for calculating classification in three sub- bookmark tables to form second level subpage label table.It needs to illustrate
, when obtaining second level subpage label table associated with a certain characteristic, can also be directly acquire it is associated with this characteristic
Data, and then obtain corresponding subpage label table to carry out corresponding data summarization.
Further, in one embodiment, as shown in figure 5, this method is also wrapped when generation obtains subpage label table
It includes:
Step 502, obtaining category attribute in the data information that target bookmark is included is the calculating data letter for calculating classification
Breath.
Step 504, it determines and calculates computation rule corresponding to data information, and when computation rule is not that can recognize rule
Recognizable computation rule is converted by computation rule.
Step 506, the second location information for calculating data information in corresponding subpage label table is determined, and by computation rule
It is directed into position corresponding to second location information.
When generating to obtain subpage label table according to target bookmark, for all data informations included in target bookmark
Corresponding position of the corresponding generation in subpage label table is required, position of the fixed data information in subpage label table is being determined
When setting, obtaining category attribute in the data information that target bookmark is included is the calculating data information for calculating classification, and determines meter
Computation rule corresponding to data information is calculated, then computation rule is directed into and calculates position corresponding to data information, in addition,
For obtained computation rule, it is also necessary to determine whether it is and can recognize rule, and when not being that can recognize rule by its turn
Turn to corresponding recognizable computation rule.
In practical applications, it usually there will be in bill of quantities and believed based on data obtained from other data informations
Breath, such as common subtotal, total and total price etc., these data informations are carried out based on accordingly by editable data information
It obtained from calculation, therefore is obtained in corresponding inventory table in generation, can also exist in table and belong to the data letter for calculating classification
Breath.In the present embodiment, in the corresponding subpage label table of generation target bookmark, the letter of data included in target bookmark is obtained
Category attribute is the data information for calculating classification in breath, then determines pair for calculating data information in corresponding subpage label table
The second location information answered, and then computation rule or the corresponding standard rule of computation rule are imported based on second location information
Corresponding position into subpage label table.
Further, when generation obtains the corresponding subpage label table of target bookmark, for the needs in subpage label table
Other data informations imported, it will obtained and imported from homepage label table, specifically: obtaining subpage label table
Included in Data Identification, and the corresponding data to be imported of Data Identification are obtained in homepage label table based on Data Identification and are believed
Breath, data information to be imported is directed into subpage label table；And when the data information in homepage label table is modified
When, it obtains by the Data Identification of modification data information, and data update is carried out to the subpage label table comprising Data Identification.
It specifically, include all editable data informations in homepage label table, and each data information is right
There should be unique Data Identification, there are when corresponding Data Identification in group bookmark table, directly be obtained from homepage label table
Corresponding data information is taken, to be directed into position corresponding to Data Identification in subpage label table.Meanwhile in homepage label table
Data information when being modified, corresponding includes that the data information in subpage label table by modification data information will will do it
It updates, that is, carries out the modification of data information.
It should be understood that although each step in the flow chart of Fig. 2-5 is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, these steps can execute in other order.Moreover, at least one in Fig. 2-5
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, the execution sequence in these sub-steps or stage is also not necessarily successively
It carries out, but can be at least part of the sub-step or stage of other steps or other steps in turn or alternately
It executes.
In one embodiment, as shown in fig. 6, providing a kind of inventory table generating means 600, comprising: inventory obtains
Module 602, attribute determination module 604 and table generation module 606, in which:
Inventory obtains module 602, for generating instruction institute based on inventory table when receiving the generation instruction of inventory table
The control information for including obtains corresponding target inventory；
Attribute determination module 604, the target data information for being included for obtaining target inventory, and identify determining number of targets
It is believed that ceasing corresponding category attribute；
Table generation module 606, for generating to obtain target inventory pair based on the corresponding category attribute of target data information
The inventory table answered.
In one embodiment, a kind of inventory provided obtains module and is also used to obtain the included control of inventory generation instruction
Information processed, and inquired in preset list database based on inventory mark included in control information, obtain inventory mark
Know corresponding target inventory.
In one embodiment, a kind of table generation module provided includes: homepage label table generation module, subpage label table
Lattice generation module and table summarize generation module.Wherein, homepage label table generation module for being included based on target inventory
Target data information, generation obtain corresponding homepage label table；Subpage label table generation module be used for based on number of targets it is believed that
The bookmark information that corresponding category attribute and target inventory are included is ceased, generation obtains the corresponding subpage label table of target inventory
Lattice；Table summarizes generation module for summarizing homepage label table and subpage label table, obtains inventory corresponding to target inventory
Table.
In one embodiment, a kind of homepage label table generation module provided is also used to read target inventory and is included
Target data information, and obtain the editable data information that category attribute in target data information is editable classification, and to can
Editor's data are summarized and go to re-generate to obtain the homepage label table comprising editable data information.
In one embodiment, a kind of subpage label table generation module provided further includes that data information obtains module, position
It sets information determination module and imports generation module.Wherein, data information obtains module for being included based on target inventory
Bookmark information reads data information associated by target bookmark from target data information, and obtains associated by target bookmark
Category attribute is the other fixed data information of fixed class in data information；Location information determining module is for obtaining preset list table
Grid template determines first location information of the fixed data information in inventory form template；Generation module is imported to be used for based on the
Fixed data information is directed into inventory form template by one location information, and generation obtains subpage label corresponding to target bookmark
Table.
In one embodiment, a kind of subpage label table generation module provided further includes regular determining module.Wherein, number
Being also used to obtain category attribute in the data information that target bookmark is included according to data obtaining module is the calculating number for calculating classification
It is believed that breath；Regular determining module calculates computation rule corresponding to data information for determining, and is not that can know in computation rule
Recognizable computation rule is converted by computation rule when irregular；Importing generation module is also used to determine calculating data information right
The second location information in subpage label table is answered, and computation rule is directed into position corresponding to second location information.
In one embodiment, a kind of inventory table generation method provided further include data import modul and data more
New module.Wherein, data import modul is existed for obtaining Data Identification included in subpage label table, and based on Data Identification
The corresponding data information to be imported of Data Identification is obtained in homepage label table, and data information to be imported is directed into subpage label table
In lattice；Data update module is used for when the data information in homepage label table is modified, and is obtained by the number of modification data information
Data update is carried out according to mark, and to the subpage label table comprising Data Identification.
Specific about inventory table generating means limits the limit that may refer to above for inventory table generation method
Fixed, details are not described herein.Modules in above-mentioned inventory table generating means can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, a kind of computer equipment is provided, which can be terminal, internal structure
Figure can be as shown in Figure 7.The computer equipment includes processor, the memory, network interface, display connected by system bus
Screen and input unit.Wherein, the processor of the computer equipment is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system and computer journey
Sequence.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The network interface of machine equipment is used to communicate with external terminal by network connection.When the computer program is executed by processor with
Realize a kind of inventory table generation method.The display screen of the computer equipment can be liquid crystal display or electric ink is shown
Screen, the input unit of the computer equipment can be the touch layer covered on display screen, be also possible on computer equipment shell
Key, trace ball or the Trackpad of setting also may include corresponding speech input device, can also be external keyboard, touching
Control plate or mouse etc..
It will be understood by those skilled in the art that structure shown in Fig. 7, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, is stored in memory
Computer program, the processor perform the steps of when executing computer program
When receiving inventory table and generating instruction, is generated based on inventory table and included control information is instructed to obtain pair
The target inventory answered；
The target data information that target inventory is included is obtained, and identifies the corresponding classification category of determining target data information
Property；
It generates to obtain the corresponding inventory table of target inventory based on the corresponding category attribute of target data information.
In one embodiment, it is also performed the steps of when processor executes computer program
It obtains inventory and generates the included control information of instruction, and based on inventory mark included in control information pre-
If being inquired in inventory database, the corresponding target inventory of inventory mark is obtained.
In one embodiment, it is also performed the steps of when processor executes computer program
Based on the target data information that target inventory is included, generation obtains corresponding homepage label table；
Based on the bookmark information that the corresponding category attribute of target data information and target inventory are included, generation obtains mesh
The corresponding subpage label table of SD list；
Homepage label table and subpage label table are summarized, the corresponding inventory table of target inventory is obtained.
In one embodiment, it is also performed the steps of when processor executes computer program
The target data information that target inventory is included is read, and obtaining category attribute in target data information is editable
The editable data information of classification, and editable data are summarized and go to re-generate to obtain comprising editable data information
Homepage label table.
In one embodiment, it is also performed the steps of when processor executes computer program
Based on the bookmark information that target inventory is included, data associated by target bookmark are read from target data information
Information, and obtaining category attribute in data information associated by target bookmark is the other fixed data information of fixed class；
Preset list form template is obtained, determines first location information of the fixed data information in inventory form template；
Based on first location information, fixed data information is directed into inventory form template, generation obtains target bookmark
Corresponding subpage label table.
In one embodiment, it is also performed the steps of when processor executes computer program
Obtaining category attribute in the data information that target bookmark is included is the calculating data information for calculating classification；
It determines and calculates computation rule corresponding to data information, and will calculate and advise when computation rule is not that can recognize rule
Then it is converted into recognizable computation rule；
It determines the second location information for calculating data information in corresponding subpage label table, and computation rule is directed into the
Position corresponding to two location informations.
In one embodiment, it also performs the steps of and is obtained in subpage label table when processor executes computer program
The Data Identification for being included, and the corresponding data letter to be imported of Data Identification is obtained in homepage label table based on Data Identification
Breath, data information to be imported is directed into subpage label table；
When the data information in homepage label table is modified, obtain by the Data Identification of modification data information, and to packet
Subpage label table containing Data Identification carries out data update.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of when being executed by processor
When receiving inventory table and generating instruction, is generated based on inventory table and included control information is instructed to obtain pair
The target inventory answered；
The target data information that target inventory is included is obtained, and identifies the corresponding classification category of determining target data information
Property；
It generates to obtain the corresponding inventory table of target inventory based on the corresponding category attribute of target data information.
In one embodiment, it is also performed the steps of when computer program is executed by processor
It obtains inventory and generates the included control information of instruction, and based on inventory mark included in control information pre-
If being inquired in inventory database, the corresponding target inventory of inventory mark is obtained.
In one embodiment, it is also performed the steps of when computer program is executed by processor
Based on the target data information that target inventory is included, generation obtains corresponding homepage label table；
Based on the bookmark information that the corresponding category attribute of target data information and target inventory are included, generation obtains mesh
The corresponding subpage label table of SD list；
Homepage label table and subpage label table are summarized, the corresponding inventory table of target inventory is obtained.
In one embodiment, it is also performed the steps of when computer program is executed by processor
The target data information that target inventory is included is read, and obtaining category attribute in target data information is editable
The editable data information of classification, and editable data are summarized and go to re-generate to obtain comprising editable data information
Homepage label table.
In one embodiment, it is also performed the steps of when computer program is executed by processor
Based on the bookmark information that target inventory is included, data associated by target bookmark are read from target data information
Information, and obtaining category attribute in data information associated by target bookmark is the other fixed data information of fixed class；
Preset list form template is obtained, determines first location information of the fixed data information in inventory form template；
Based on first location information, fixed data information is directed into inventory form template, generation obtains target bookmark
Corresponding subpage label table.
In one embodiment, it is also performed the steps of when computer program is executed by processor
Obtaining category attribute in the data information that target bookmark is included is the calculating data information for calculating classification；
It determines and calculates computation rule corresponding to data information, and will calculate and advise when computation rule is not that can recognize rule
Then it is converted into recognizable computation rule；
It determines the second location information for calculating data information in corresponding subpage label table, and computation rule is directed into the
Position corresponding to two location informations.
In one embodiment, it is also performed the steps of when computer program is executed by processor
Data Identification included in subpage label table is obtained, and data are obtained in homepage label table based on Data Identification
Corresponding data information to be imported is identified, data information to be imported is directed into subpage label table；
When the data information in homepage label table is modified, obtain by the Data Identification of modification data information, and to packet
Subpage label table containing Data Identification carries out data update.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of inventory table generation method, which comprises
When receiving inventory table and generating instruction, is generated based on the inventory table and included control information is instructed to obtain pair
The target inventory answered；
The target data information that the target inventory is included is obtained, and identifies and determines the corresponding classification of the target data information
Attribute；
It generates to obtain the corresponding inventory table of the target inventory based on the corresponding category attribute of the target data information.
2. the method according to claim 1, wherein described generated based on the inventory instructs included control
Information obtains corresponding target inventory, comprising:
It obtains the inventory and generates the included control information of instruction, and based on the mark of inventory included in the control information
It is inquired in preset list database, obtains the corresponding target inventory of the inventory mark.
3. the method according to claim 1, wherein described be based on the corresponding classification category of the target data information
Property generates to obtain the corresponding inventory table of the target inventory, comprising:
Based on the target data information that the target inventory is included, generation obtains corresponding homepage label table；
Based on the bookmark information that the corresponding category attribute of the target data information and the target inventory are included, generate
To the corresponding subpage label table of the target inventory；
The homepage label table and subpage label table are summarized, the corresponding inventory table of the target inventory is obtained.
4. according to the method described in claim 3, it is characterized in that, the category attribute includes fixed classification, editable classification
And calculate classification；
The target data information for being included based on the target inventory, generation obtain corresponding homepage label table, comprising:
The target data information that the target inventory is included is read, obtaining category attribute in the target data information is that can compile
The editable data information of classification is collected, and the editable data are summarized and go to re-generate to obtain comprising the editable
The homepage label table of data information.
5. according to the method described in claim 4, it is characterized in that, described be based on the corresponding classification category of the target data information
Property and the target inventory bookmark information that is included, generation obtain the corresponding subpage label table of the target inventory, comprising:
Based on the bookmark information that target inventory is included, the letter of data associated by target bookmark is read from target data information
Breath, and obtaining category attribute in data information associated by the target bookmark is the other fixed data information of fixed class；
Preset list form template is obtained, determines first position letter of the fixed data information in the inventory form template
Breath；
Based on the first location information, the fixed data information is directed into the inventory form template, generation obtains
Subpage label table corresponding to target bookmark.
6. according to the method described in claim 5, it is characterized in that, the method also includes:
Obtaining category attribute in the data information that the target bookmark is included is the calculating data information for calculating classification；
Determine computation rule corresponding to the calculating data information, and when the computation rule is not that can recognize rule by institute
It states computation rule and is converted into recognizable computation rule；
It determines second location information of the calculating data information in corresponding subpage label table, and the computation rule is imported
To position corresponding to the second location information.
7. according to method described in claim 3 to 6 any one, which is characterized in that the method also includes:
Data Identification included in the subpage label table is obtained, and is identified in the homepage label table based on the data
The corresponding data information to be imported of the Data Identification is obtained, the data information to be imported is directed into the subpage label table
In lattice；
When the data information in the homepage label table is modified, the Data Identification by modification data information is obtained, and
Data update is carried out to the subpage label table comprising the Data Identification.
8. a kind of inventory table generating means, which is characterized in that described device includes:
Inventory obtains module, for generating instruction based on the inventory table and being wrapped when receiving the generation instruction of inventory table
The control information contained obtains corresponding target inventory；
Attribute determination module, the target data information for being included for obtaining the target inventory, and identify and determine the target
The corresponding category attribute of data information；
Table generation module, for generating to obtain the target inventory pair based on the corresponding category attribute of the target data information
The inventory table answered.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811435465.4A CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811435465.4A CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109597979A true CN109597979A (en) | 2019-04-09 |
| CN109597979B CN109597979B (en) | 2022-11-11 |
Family
ID=65960502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811435465.4A Active CN109597979B (en) | 2018-11-28 | 2018-11-28 | List table generation method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109597979B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111611284A (en) * | 2020-05-28 | 2020-09-01 | 联想(北京)有限公司 | Material list generation method and electronic equipment |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN113031883A (en) * | 2021-02-26 | 2021-06-25 | 广东核电合营有限公司 | Label data printing method, label data printing device, computer equipment and storage medium |
| CN113095686A (en) * | 2021-04-15 | 2021-07-09 | 广联达科技股份有限公司 | Multi-standard-section cost adjusting method and device for power engineering |
| CN113221525A (en) * | 2021-02-26 | 2021-08-06 | 平安普惠企业管理有限公司 | Data processing method and device, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050137883A1 (en) * | 2003-12-19 | 2005-06-23 | Hiroaki Nohgawa | Business form issuing apparatus and electronic business form system |
| CN101794236A (en) * | 2009-01-30 | 2010-08-04 | 卡西欧计算机株式会社 | Application software generating apparatus, computer program and application software generation system |
| CN101968800A (en) * | 2010-09-21 | 2011-02-09 | 北京空间飞行器总体设计部 | Metadata driving based method for realizing dynamic form |
| JP5497948B1 (en) * | 2013-06-26 | 2014-05-21 | 前田建設工業株式会社 | Tabular data processing program, method and apparatus |
| JP2014157441A (en) * | 2013-02-15 | 2014-08-28 | Topic Maker:Kk | Homepage preparation method, and homepage preparation system |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
-
2018
- 2018-11-28 CN CN201811435465.4A patent/CN109597979B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050137883A1 (en) * | 2003-12-19 | 2005-06-23 | Hiroaki Nohgawa | Business form issuing apparatus and electronic business form system |
| CN101794236A (en) * | 2009-01-30 | 2010-08-04 | 卡西欧计算机株式会社 | Application software generating apparatus, computer program and application software generation system |
| CN101968800A (en) * | 2010-09-21 | 2011-02-09 | 北京空间飞行器总体设计部 | Metadata driving based method for realizing dynamic form |
| JP2014157441A (en) * | 2013-02-15 | 2014-08-28 | Topic Maker:Kk | Homepage preparation method, and homepage preparation system |
| JP5497948B1 (en) * | 2013-06-26 | 2014-05-21 | 前田建設工業株式会社 | Tabular data processing program, method and apparatus |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111611284A (en) * | 2020-05-28 | 2020-09-01 | 联想(北京)有限公司 | Material list generation method and electronic equipment |
| CN113031883A (en) * | 2021-02-26 | 2021-06-25 | 广东核电合营有限公司 | Label data printing method, label data printing device, computer equipment and storage medium |
| CN113221525A (en) * | 2021-02-26 | 2021-08-06 | 平安普惠企业管理有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN113095686A (en) * | 2021-04-15 | 2021-07-09 | 广联达科技股份有限公司 | Multi-standard-section cost adjusting method and device for power engineering |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109597979B (en) | 2022-11-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109597979A (en) | Inventory table generation method, device, computer equipment and storage medium | |
| CN109815471A (en) | Contract text generation method, device, computer equipment and storage medium | |
| CN110009471A (en) | Financial affairs receipt generation method, device, computer equipment and storage medium | |
| CN110955418A (en) | Code generation method and device, computer equipment and storage medium | |
| CN109615343A (en) | Electronic contract generation method, device, computer equipment and storage medium | |
| CN109767320A (en) | Order checking method, device, computer equipment and storage medium | |
| CN109493158B (en) | Product quotation measuring and calculating method, device, computer equipment and storage medium | |
| CN110222336A (en) | Analysis of financial statement method, apparatus, computer equipment and storage medium | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN110413922A (en) | Page info display methods, device, computer equipment and storage medium | |
| CN108334625A (en) | Processing method, device, computer equipment and the storage medium of user information | |
| CN108415722A (en) | Update method, device, computer equipment and the storage medium of channel application | |
| CN109828809A (en) | Information visualization methods, device, computer equipment and the storage medium of billboard | |
| CN113342249B (en) | Content management method, device, equipment and storage medium capable of previewing in real time | |
| CN114327435A (en) | Technical document generation method and device and computer readable storage medium | |
| CN110008180A (en) | Financial data recording method, device, computer equipment and storage medium | |
| CN110362478A (en) | Application upgrade test method, device, computer equipment and storage medium | |
| CN116029080A (en) | Chip storage device design and verification method and device and electronic equipment | |
| CN108921459A (en) | Index generates method, apparatus, computer equipment and storage medium | |
| CN113254455B (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN109213785A (en) | Bill compilation method, apparatus, computer equipment and storage medium | |
| CN109614188A (en) | A kind of page online help method, apparatus, computer equipment and storage medium | |
| CN109299126A (en) | Method of data synchronization, device, computer equipment and storage medium | |
| CN113157712A (en) | Data processing method, system and related equipment | |
| CN109299300A (en) | Inventory specific item generation method, device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |