CN109064126B - Hydropower engineering metering information management method based on quality driving - Google Patents
Hydropower engineering metering information management method based on quality driving Download PDFInfo
- Publication number
- CN109064126B CN109064126B CN201810787838.8A CN201810787838A CN109064126B CN 109064126 B CN109064126 B CN 109064126B CN 201810787838 A CN201810787838 A CN 201810787838A CN 109064126 B CN109064126 B CN 109064126B
- Authority
- CN
- China
- Prior art keywords
- engineering
- project
- unit
- list
- construction unit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Abstract
The invention provides a hydropower engineering metering information management method based on quality driving, which establishes quality-driven service guarantee logic, flexibly associates engineering metering information with quality evaluation information by utilizing a database technology, ensures that the quality evaluation results of construction projects corresponding to all metering documents are qualified, optimizes and improves the query statistical efficiency of data from the bottom layer by adopting a coding technology of an improved preamble traversal tree, and provides early warning and reminding functions of hysteresis, super junction and re-junction of the engineering metering information.
Description
Technical Field
The invention relates to the technical field of hydraulic and hydroelectric engineering construction metering informatization management, in particular to a hydroelectric engineering metering information management method based on quality driving.
Background
The calculation of settlement engineering quantity is mainly based on an engineering completion drawing and an intermediate endorsement receipt, if the intermediate engineering measurement deviation is large, the completion settlement can be completely rechecked, and even the completion drawing is directly used for carrying out the re-measurement settlement of the whole engineering. After the field construction is finished, all the participating parties need to park special staff to complete the related data and carry out a large amount of calculation work, so that the project completion acceptance is involved in a great delay risk. Therefore, the timeliness and accuracy of the intermediate measurement of the project and the scientificity of the record are very important to the investment and progress management of the whole life cycle of the project.
The perfect metering payment ledger is crucial to investment management, and a good place (application [ J ] of project management software P6 in cost management. petrochemical engineering construction, 2012(2):38-40.) utilizes the progress, resource and expense management functions of the P6 software to provide a set of cost management mode based on resource expense, but the method is separated from a project list pricing method and is not suitable for large-scale construction project investment management. A show margin wave (road engineering metering and payment system [ D ]. electronic technology university, 2007) utilizes a programming theory in combination with road engineering characteristics to develop an information management system which takes metering management as a center and covers progress and material management, and the system takes metering payment as an independent object, does not consider the logical program relationship of progress, quality assessment and metering, and is difficult to guide construction practice. A WorkFlow flow engine is introduced into a high mountain (Dagang mountain hydropower station contract management system design and realization [ D ]. electronic technology university, 2013), and the flows of measurement approval, settlement approval, payment approval, approximate calculation change claim, project subpackage management and the like are integrated in an informationized manner, so that the contract management efficiency is improved; the TGPMS information system introduced by the engineering of the three gorges Water station of Changjiang river, China (Zhangiang, engineering management information System (TGPMS) [ M ]. Yichang, China three gorges Press, 2007; and ran, orchid, Zhao, shallowly talk about TGPMS, is applied to the three gorges Water station engineering for the earliest time [ J ]. China science and technology Explorer, 2014(4):424), realizes the information management functions of P3 progress management, material tracking, fund and cost control, quality evaluation, potential safety hazard, measurement payment and the like, exerts great economic benefit, the two systems are more important to show rich flows, and consider the correlation of information such as measurement, engineering quantity list, approximate calculation and the like, but do not discuss the dividing method of the measurement units and the coordination relationship of the measurement units and the quality evaluation, in the actual engineering, the engineering measurement units and the engineering units are difficult to correspond one to one, the manual examination needs to be carried out with great investment cost.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a hydropower engineering metering information management method based on quality driving, which establishes a quality-driven service guarantee logic, flexibly associates engineering metering information with quality evaluation information by utilizing a database technology, ensures that the quality evaluation results of construction projects corresponding to all metering documents are qualified, optimizes the data query statistical efficiency from the bottom layer by adopting an encoding technology of an improved preamble traversal tree, and provides early warning and reminding functions of hysteresis, super junction and re-junction of the engineering metering information.
The technical scheme adopted by the invention is as follows:
a hydropower engineering metering information management method based on quality driving comprises the following steps:
step 1: adding numerical fields of left and right sequence numbers in a data table of a project amount list by using an improved forward traversal tree coding technology, storing original project amount list records and the left and right sequence numbers in a database together, and providing technical support for real-time efficient summary query of a system;
step 2: the contractor fills in the position, pile number and elevation of the construction unit to be reported in the system, selects a corresponding project amount list item, inputs the project amount to be reported, uploads a calculation book attachment, submits to a designated auditor, and the system automatically generates construction unit codes, complete project intermediate measurement documents and project measurement ledgers, and performs pre-audit of quality acceptance and judgment of measurement super junction, skip junction and re-junction;
and step 3: the system inquires a unit project evaluation database and a project quantity list statistical database according to the business rules, and is used for checking whether unit projects to which metering projects belong are qualified or not and checking the project quantity settlement proportion of list projects, giving error prompts to records which do not accord with the business rules, and leading a supervision engineer to revise data or return to contractors for perfection according to the prompts to ensure the correctness and the integrity of metering information;
and 4, step 4: the field supervision engineer completes verification of the basic information in a matching manner, examines whether the actual completion quantity is consistent with the declaration quantity, returns the records with problems to the contractor for modification, and omits complicated procedural services such as pre-examination of quality acceptance and quality acceptance;
and 5: the system is based on the encoding technology of improved front-end traversal, provides an efficient and flexible query and statistics function, and performs multi-condition screening, settlement proportion real-time analysis and report output printing;
step 6: the system automatically analyzes the states and the logic relations of all unit engineering quality evaluation and measurement visa by comparing the unit engineering evaluation database with the engineering measurement visa database in real time, intelligently judges the unit engineering with untimely measurement visa and prompts in real time.
Further, the step 1 is specifically realized as follows: adding numerical fields of sequence numbers of left lft and right rgt in a data table of a project amount list, performing one-time complete pre-sequence traversal according to path rules of a root node, a left sub-tree node, a right sub-tree node, a node left sequence and a node right sequence, setting the left sequence value of the root node to be 1 during traversal, sequentially increasing and allocating sequence numbers to lft values of nodes in the left sequence traversal process, increasing and allocating sequence numbers to rgt values of the nodes after the left sequence traversal of leaf nodes is completed or the left sequence traversal of sub-nodes of non-leaf nodes is completely completed, and storing node data together with the left sequence number and the right sequence number in a database.
Further, before step 1, defining a coding rule for the construction unit: firstly, adding a construction unit type code after a unit project code, wherein a first type of construction unit is represented by 01 and represents that the construction unit belongs to a certain unit project, and a second type of construction unit is represented by 02 and represents that the construction unit partially belongs to a certain unit project and partially belongs to another unit project; then, adding a space segmentation code after the construction unit type code, and gradually increasing from 01 to represent the times of the segmentation of the unit engineering space;
after the contractor inputs the pile number and the elevation information of the construction unit in the step 2, the system automatically judges whether the spatial information of the filled construction unit is repeated with the spatial information of the historical measurement construction unit or not through numerical analysis, whether discontinuous measurement space exists or not, missing and repeated joints of measurement in the middle of the project are avoided, the system automatically generates construction unit codes after judging that the project is correct, each construction unit code naturally comprises the affiliated unit project code according to the coding rule, the system extracts the unit project code information from the construction unit codes, and the system inquires and judges whether the corresponding construction unit passes the acceptance evaluation through a unit project evaluation database in the step 3, so that the automatic judgment of pre-acceptance check of quality acceptance is realized.
Further, step 2 further comprises the steps of: and configuring a many-to-many mapping relation for the engineering intermediate measurement list and the engineering quantity list, reversely checking an engineering quantity list data table by the system according to engineering quantity list codes recorded in the engineering intermediate measurement list, combining hierarchical structure information of the engineering quantity list, realizing automatic generation of general purpose analysis of the engineering intermediate measurement list account and the engineering quantity, and further comparing the automatic generation with the design quantity to judge whether the engineering quantity of each list item has super junction or not.
The invention has the following beneficial effects:
the large hydropower station has a long engineering construction period, engineering measurement is a key link for controlling the investment expenditure of engineering projects and is an important basis for settlement of engineering quantity calculation, accurate and efficient measurement can facilitate all parties involved in the construction to know the real-time engineering quantity, and the work efficiency of completion settlement can be improved. After the system is used, the supervision engineer can be dedicated to calculation and audit of the engineering quantity, the complex work of pre-audit of quality acceptance, heavy knot audit, missed knot audit, super-junction audit and the like is avoided, the pre-knot is limited on the program level, the problem of super-junction and heavy knot is avoided, the metering management efficiency is greatly improved compared with the traditional mode, 13% more engineering metering audit can be completed in each month on average, in addition, the automatic archiving, analyzing and account-setting statistical functions of the system reduce the workload of field workers, and the operation efficiency of the whole project is improved.
Figure illustrates the drawings
FIG. 1 is a schematic view of the management process of intermediate engineering metrology according to the present invention;
FIG. 2 is a schematic diagram of the application business logic of the metering information management system of the present invention;
FIG. 3 is a data structure diagram of an engineering metrology information system of the present invention;
FIG. 4 is a schematic diagram of an improved encoding rule of a preamble traversal tree according to the present invention;
FIG. 5 is a schematic diagram of an intelligent reminder interface of the metering information management system of the present invention;
FIG. 6 is a schematic view of a data entry interface of the metering information management system of the present invention;
FIG. 7 is a schematic view of a query statistics interface of the metering information management system of the present invention;
FIG. 8 is a flow chart of a hydropower engineering metering information management method based on mass driving according to the invention.
Detailed Description
The technical solution of the present invention will be clearly and completely described below with reference to the drawings.
In order to implement the technical scheme of the invention, the invention needs to complete the following matters in advance:
1. management flow reconstruction
The main process objects involved in the metering process of the hydropower engineering comprise: construction unit, unit project, intermediate project measurement list and project amount list (BOQ). The construction unit is a construction minimum control unit and is a direct management object of site progress, quality and safety, such as 3m deep single-cycle tunnel excavation construction, 20m tunnel section range system anchor rod support construction, independent warehouse concrete construction and the like; the unit project is a minimum complex completed by construction of a plurality of working procedures (or work types) in the subsection project, and is a basic unit for daily quality assessment; the project intermediate measurement list is a file of the actual completion number of each project or structural member which is managed and identified by an owner in the construction process; the engineering quantity list is the quotation basis which is issued by the tenderer in the tendering process and contains the partial engineering project list, the measure project list and other lists, and is finally written into the contract to become the payment basis in the middle period of the engineering.
According to the water conservancy project construction supervision standard (SL288-2014), a management flow chart (figure 1) of the project intermediate measurement is given by combining related requirements before the project intermediate measurement to ensure that the corresponding project is constructed and qualified in quality acceptance and evaluation, namely, after a plurality of construction units are completed, an evaluation link of the corresponding unit project is entered, actual project measurement is carried out after check and check are carried out, and as can be seen from the figure, the unit project is a link for connecting the construction units with the project measurement.
The traditional intermediate engineering measurement bill adopts a paper mode for filling and transferring, the efficiency is low, the workload is large, the systematic management is inconvenient, the system provides an on-line filling and transferring function of the intermediate engineering measurement bill for a contractor, the contractor only needs to fill the part, pile number and elevation of a construction unit to be reported in the system, a corresponding project amount list item is selected, the project amount to be reported is input, a calculation book attachment is uploaded, and the system can automatically generate a complete intermediate engineering measurement bill and an engineering measurement ledger. In addition, the system also supports electronic signature based on CA authentication, and realizes informatization of all process approval.
Most of the auditing work is automatically analyzed and completed by an information system, and comprises the steps of automatically generating construction unit codes, verifying the repeatability and continuity of the elevation of the construction unit pile number, verifying and evaluating the construction quality of a metering project, judging information of the project heavy knots, the missed knots and the super junctions, judging information of the declaration form, judging information of the correctness of the information of the declaration form and the like, wherein the system can give corresponding prompts when any error occurs, and the detailed graph in figure 2 is shown.
In order to ensure that the data of the system is accurate and correct, a field supervision engineer is required to cooperate with the system to check and judge whether the actual completion quantity is consistent with the declaration quantity, and the records with problems are returned to the contractor for modification, so that complicated procedural services such as pre-verification of quality acceptance and quality check are omitted.
2. Data structure arrangement
The unit project is used as a data center for data integration, the unit project in the hydropower station project is generally divided according to the principle of 'unit project-subsection project-item project-unit project', and the project object is disassembled and subdivided in the mode, so that a manager can conveniently perform flexible quality test and evaluation; the project list project is mainly compiled according to project codes, project names and characteristics, measurement units and project quantity calculation rules specified by the current national measurement standard of relevant projects, and reasonable project quantity list configuration can reduce measurement difficulty and facilitate contract processing.
The construction unit is the smallest implementation object, is the smallest engineering measurement unit, keeps the same height with the field construction dynamic state, has great elasticity in space division, and is often continuously adjusted along with the rapid change of the field requirement, so the space division of the construction unit and the unit engineering is often inconsistent, namely, a certain construction unit may belong to one unit engineering partially, and belong to another unit engineering partially. The problem that the space division of the metering unit (namely, the construction unit) is inconsistent with that of the quality management unit (namely, the unit engineering) brings great inconvenience to the metering audit of a supervision engineer:
(1) the quality acceptance condition of an audited object cannot be intuitively known, and corresponding unit projects need to be manually searched according to the pile number elevations of the construction units, and the quality evaluation results are audited in advance;
(2) whether the objects to be examined and verified have the problems of super junction, junction leakage and heavy junction can not be intuitively known, and the intermediate measurement list and the engineering quantity list of the historical engineering need to be manually searched according to the pile number elevation of the construction unit, and are compared and analyzed.
To coordinate the resolution of the above-mentioned spatial inconsistencies, simple coding rules are defined for the construction units (see table 1). Firstly, a construction unit type code is added after the unit engineering code. Wherein, the first kind of construction unit is represented by 01, which means that the construction unit belongs to a certain unit project, the second kind of construction unit is represented by 02, which means that the construction unit belongs to a certain unit project partially, and the construction unit belongs to another unit project partially. Then, a space segmentation code is added after the construction unit type code, and the number of times of segmentation of the unit engineering space is represented by increasing from 01. After the user inputs the pile number and the elevation information of the construction unit, the system automatically judges whether the space information of the filling construction unit is repeated with the space information of the historical measurement construction unit or not and whether a discontinuous measurement space exists or not through numerical analysis, and the missing junction and the repeated junction of the middle measurement of the project are avoided. After the judgment is correct, the system automatically generates construction unit codes, each construction unit code naturally comprises the unit engineering code to which the system belongs according to the coding rule, the system extracts unit engineering code information from the construction unit codes, and inquires and judges whether the corresponding construction unit passes the acceptance evaluation through a unit engineering evaluation database, so that the automatic judgment of the pre-audit of quality acceptance is realized (see figure 3).
TABLE 1 construction Unit coding rules
Further, in order to realize the structured analysis of the engineering intermediate measurement list, a many-to-many mapping relation (see fig. 3) is configured for the engineering intermediate measurement list and the engineering quantity list, the system reversely checks an engineering quantity list data table according to engineering quantity list codes recorded in the engineering intermediate measurement list, the automatic generation of the total item analysis of the engineering intermediate measurement list account and the engineering quantity is realized by combining the hierarchical structure information of the engineering quantity list, and the comparison with the design quantity is further carried out to judge whether the engineering quantity of each list item has super junction or not.
Therefore, under the condition that the space division of the metering unit (namely the construction unit) is inconsistent with the space division of the quality management unit (namely the unit project), the system automatically realizes the preposed auditing of quality acceptance and the judgment of metering super junction, junction leakage and junction recombination, and realizes the global linkage of the unit project, the intermediate metering of the project and the project amount list data. The system introduces a construction unit coding system into an engineering intermediate metering sheet on the premise of keeping an engineering quantity list and an original coding system of the unit engineering unchanged, the engineering intermediate metering sheet is used as a middleware, a many-to-many flexible mapping relation is set up for the unit engineering and the engineering quantity list, and finally, engineering quality data (unit engineering) is used as a drive to fuse quality and metering binary data, so that automatic identification of quality attributes of metering objects, metering work starting reminding of the unit engineering and abnormal analysis of total sub-metering information of the list are realized, the compliance, timeliness and high efficiency of metering services are ensured, and real-time and comprehensive metering decision support is provided for managers.
3. Improved preamble traversal tree coding
The reasonable engineering quantity list configuration can facilitate contract processing and reduce the metering difficulty, a common engineering quantity list is of a tree-shaped hierarchical structure, a mainstream database is based on data storage of a relational data table, and a set of proper coding rules needs to be designed on the basis of a two-dimensional data table to represent the incidence relation of tree-shaped hierarchical data.
The traditional adjacency list method can store tree hierarchical structure data into a relational database, namely, an ID attribute of a father node is added to each tree node in a two-dimensional list so as to show the tree hierarchical relationship through a planar list. When the tree hierarchy is n and the maximum node number of the hierarchy is m, the time complexity is O (nxm) and the space complexity is O (n) when the method is used for obtaining the descendant node of a certain node.
The invention adopts an improved encoding technology of a preamble traversal tree (also called a pre-ordering traversal tree) and defines and encodes tree data in advance by referring to a preamble traversal path rule so as to represent the hierarchy and the incidence relation among nodes. During specific operation, numerical fields of left (lft) and right (rgt) sequence numbers are newly added in a data table of a project amount list, then complete pre-sequence traversal is performed according to path rules of a root node, a left subtree node, a right subtree node, a node left sequence and a node right sequence, the left sequence value of the root node is firstly set to be 1 during traversal, sequence numbers are sequentially and incrementally distributed to lft values of all nodes in the left sequence traversal process, when the left sequence traversal of leaf nodes is completed or the left and right sequence traversal of sub-nodes of non-leaf nodes is completely completed, sequence numbers are incrementally distributed to rgt values of all nodes, node data and the left and right sequence numbers are stored in a database together, and the traversal and coding rules are shown in figure 4.
The coding technology can obtain the descendant node of a certain node only by one simple data operation: "SELECT" FROM table WHERE left BY num1 AND num2 ORDER BY left ASC ", the algorithm eliminates the recursion process, AND the time complexity AND space complexity of the query operation are both reduced to O (1), thereby greatly improving the operation performance. Because the tree levels and the node numbers corresponding to the engineering quantity list in large hydropower station engineering are huge, especially the actual sum of the total amount of the total list needs to be inquired in real time and the sum information of all the descendant nodes under the total list is calculated in a gathering way, the calculation requirement is high, and the encoding technology based on the improved predecessor traversal tree is the most appropriate solution.
4. System interface
The system mainly comprises the functions of intelligent reminding, data entry and import, query statistics and the like. After the authorized user enters the system, the authorized user receives real-time prompt (see figure 5) of engineering metering lag, the user can quickly position according to position, time interval or user-defined search, prompt information is exported and can be conveniently tracked and processed after being printed, and the timeliness of engineering metering is accelerated; after the contractor inputs the intermediate measurement list information of the project in a single or batch mode in the system (see figure 6), the system inquires a unit project evaluation database and a project amount list statistical database according to the business rules in figure 2, an error prompt is given to the record which does not accord with the business rules, and a supervision engineer can revise the data by himself or return to the contractor for perfection according to the prompt to ensure the correctness and the integrity of the measurement information; after the system is checked to be correct, the supervision engineer checks whether the actual completion quantity is consistent with the declared quantity, and can return to the contractor for modification when the declared quantity is wrong. In addition, the system is based on the encoding technology of improved preamble traversal, can provide efficient and flexible query statistics functions for users, and supports the functions of multi-condition screening, settlement proportion real-time analysis, report output printing and the like (see fig. 7).
Referring to fig. 8, based on the above implementation matters, the present invention provides a method for managing measurement information of hydropower engineering based on mass driving, comprising the following steps:
step 1: adding numerical fields of left (lft) and right (rgt) sequence numbers in a data table of a project amount list by using an improved front-end traversal tree coding technology, storing original project amount list records and the left and right sequence numbers in a database together, and providing technical support for real-time and efficient summary query of a system, wherein the method is specifically realized as follows: adding numerical fields of left (lft) and right (rgt) sequence number values in a data table of a project amount list, performing one-time complete pre-sequence traversal according to path rules of a root node, a left sub-tree node, a right sub-tree node, a node left sequence and a node right sequence, setting the left sequence value of the root node to be 1 during traversal, sequentially increasing and allocating sequence numbers to lft values of all nodes in the left sequence traversal process, increasing and allocating sequence numbers to rgt values of all nodes after the left sequence traversal of leaf nodes is completed or after the left sequence traversal of sub-nodes of non-leaf nodes is completely completed, and storing node data and the left and right sequence number values into a database.
Step 2: the contractor fills in the position, pile number and elevation of the construction unit to be reported in the system, selects a corresponding project amount list item, inputs the project amount to be reported, uploads a calculation book attachment, submits to a designated auditor, and the system automatically generates construction unit codes, complete project intermediate measurement documents and project measurement ledgers, and performs pre-audit of quality acceptance and judgment of measurement super junction, skip junction and re-junction.
And step 3: the system inquires the unit engineering assessment database and the engineering quantity list database according to the business rules in the figure 2, gives error prompts to records which do not accord with the business rules, and a supervision engineer can revise data or return to a contractor for perfection according to the prompts to ensure the correctness and the integrity of the metering information.
And 4, step 4: the field proctoring engineer completes the verification of the basic information in a matching way, only needs to pay attention to whether the actual completion quantity is consistent with the declaration quantity or not, and can return the records with problems to the contractor for modification, thereby saving the complicated procedural service.
And 5: the system is based on the encoding technology of improved preamble traversal, can perform efficient and flexible query and statistics functions, and supports multi-condition screening, settlement proportion real-time analysis and report output printing.
Step 6: the system automatically analyzes the states and the logic relations of all unit engineering quality evaluation and measurement visa by comparing the unit engineering evaluation database with the engineering measurement visa database in real time, intelligently judges the unit engineering with untimely measurement visa and prompts in real time.
The above description is only an embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (4)
1. A hydropower engineering metering information management method based on mass drive is characterized by comprising the following steps:
step 1: adding numerical fields of left and right sequence numbers in a data table of a project amount list by using an improved forward traversal tree coding technology, storing original project amount list records and the left and right sequence numbers in a database together, and providing technical support for real-time efficient summary query of a system;
step 2: the contractor fills in the position, pile number and elevation of the construction unit to be reported in the system, selects a corresponding project amount list item, inputs the project amount to be reported, uploads a calculation book attachment, submits to a designated auditor, and the system automatically generates construction unit codes, complete project intermediate measurement documents and project measurement ledgers, and performs pre-audit of quality acceptance and judgment of measurement super junction, skip junction and re-junction;
and step 3: the system inquires a unit project evaluation database and a project quantity list statistical database according to the business rules, and is used for checking whether unit projects to which metering projects belong are qualified or not and checking the project quantity settlement proportion of list projects, giving error prompts to records which do not accord with the business rules, and leading a supervision engineer to revise data or return to contractors for perfection according to the prompts to ensure the correctness and the integrity of metering information;
and 4, step 4: the field supervision engineer completes verification of the basic information in a matching manner, examines whether the actual completion quantity is consistent with the declaration quantity, returns the records with problems to the contractor for modification, and omits complicated procedural services such as pre-examination of quality acceptance and quality acceptance;
and 5: the system is based on the encoding technology of improved front-end traversal, provides an efficient and flexible query and statistics function, and performs multi-condition screening, settlement proportion real-time analysis and report output printing;
step 6: the system automatically analyzes the states and the logic relations of all unit engineering quality evaluation and measurement visa by comparing the unit engineering evaluation database with the engineering measurement visa database in real time, intelligently judges the unit engineering with untimely measurement visa and prompts in real time.
2. The method for managing the metering information of the hydropower engineering based on the mass drive as claimed in claim 1, wherein: the step 1 is specifically realized as follows: adding numerical fields of sequence numbers of left lft and right rgt in a data table of a project amount list, performing one-time complete pre-sequence traversal according to path rules of a root node, a left sub-tree node, a right sub-tree node, a node left sequence and a node right sequence, setting the left sequence value of the root node to be 1 during traversal, sequentially increasing and allocating sequence numbers to lft values of nodes in the left sequence traversal process, increasing and allocating sequence numbers to rgt values of the nodes after the left sequence traversal of leaf nodes is completed or the left sequence traversal of sub-nodes of non-leaf nodes is completely completed, and storing node data together with the left sequence number and the right sequence number in a database.
3. The method for managing the metering information of the hydropower engineering based on the mass drive as claimed in claim 1, wherein: before step 1, defining a coding rule for the construction unit: firstly, adding a construction unit type code after a unit project code, wherein a first type of construction unit is represented by 01 and represents that the construction unit belongs to a certain unit project, and a second type of construction unit is represented by 02 and represents that the construction unit partially belongs to a certain unit project and partially belongs to another unit project; then, adding a space segmentation code after the construction unit type code, and gradually increasing from 01 to represent the times of the segmentation of the unit engineering space;
after the contractor inputs the pile number and the elevation information of the construction unit in the step 2, the system automatically judges whether the spatial information of the filled construction unit is repeated with the spatial information of the historical measurement construction unit or not through numerical analysis, whether discontinuous measurement space exists or not, missing and repeated joints of measurement in the middle of the project are avoided, the system automatically generates construction unit codes after judging that the project is correct, each construction unit code naturally comprises the affiliated unit project code according to the coding rule, the system extracts the unit project code information from the construction unit codes, and the system inquires and judges whether the corresponding construction unit passes the acceptance evaluation through a unit project evaluation database in the step 3, so that the automatic judgment of pre-acceptance check of quality acceptance is realized.
4. The method for managing the metering information of the hydropower engineering based on the mass drive as claimed in claim 1, wherein: further comprising the steps of: and configuring a many-to-many mapping relation for the engineering intermediate measurement list and the engineering quantity list, reversely checking an engineering quantity list data table by the system according to engineering quantity list codes recorded in the engineering intermediate measurement list, combining hierarchical structure information of the engineering quantity list, realizing automatic generation of general purpose analysis of the engineering intermediate measurement list account and the engineering quantity, and further comparing the automatic generation with the design quantity to judge whether the engineering quantity of each list item has super junction or not.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810787838.8A CN109064126B (en) | 2018-07-18 | 2018-07-18 | Hydropower engineering metering information management method based on quality driving |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810787838.8A CN109064126B (en) | 2018-07-18 | 2018-07-18 | Hydropower engineering metering information management method based on quality driving |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109064126A CN109064126A (en) | 2018-12-21 |
| CN109064126B true CN109064126B (en) | 2021-03-26 |
Family
ID=64817163
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810787838.8A Active CN109064126B (en) | 2018-07-18 | 2018-07-18 | Hydropower engineering metering information management method based on quality driving |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109064126B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109767185A (en) * | 2018-12-29 | 2019-05-17 | 福建华闽通达信息技术有限公司 | A kind of measurement control method and computer equipment based on inspection of engineering quality |
| CN110991157B (en) * | 2019-11-25 | 2023-12-01 | 长江勘测规划设计研究有限责任公司 | Engineering quality assessment system design method based on electronic file trusted technology |
| CN112669019A (en) * | 2021-01-31 | 2021-04-16 | 四川沿江攀宁高速公路有限公司 | Engineering data automatic filing method based on engineering quantity list and quality inspection data correlation interaction |
| CN116976840B (en) * | 2023-07-28 | 2024-03-15 | 北京梦诚科技有限公司 | Multi-person collaborative engineering quantity calculation book auditing method and system |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504741A (en) * | 2009-02-18 | 2009-08-12 | 路桥集团国际建设股份有限公司 | Intelligent metering management system and method for construction engineering |
| CN101853310A (en) * | 2010-06-21 | 2010-10-06 | 北京大学 | Method for producing preorder and postorder code of single traversing tree |
| CN101981557A (en) * | 2008-03-27 | 2011-02-23 | 微软公司 | Computing environment representation |
| CN102822882A (en) * | 2010-01-15 | 2012-12-12 | 阿波洛集团公司 | Dynamically recommending learning content |
| CN103136626A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | On-line management method for engineering project |
| US8612271B2 (en) * | 2008-10-02 | 2013-12-17 | Certusview Technologies, Llc | Methods and apparatus for analyzing locate and marking operations with respect to environmental landmarks |
| CN104504030A (en) * | 2014-12-12 | 2015-04-08 | 国家电网公司 | Indexing method for power dispatching automation mass messages |
| CN104599061A (en) * | 2015-01-13 | 2015-05-06 | 上海建工集团股份有限公司 | Method for calculating project amount of road bridge engineering project |
| CN104933487A (en) * | 2015-06-26 | 2015-09-23 | 南京邮电大学 | Medicine retrospective application oriented medicine inquiry optimization method |
| CN107705020A (en) * | 2017-10-12 | 2018-02-16 | 山东联诚工程建设监理有限公司 | A kind of overall process intelligence engineering supervisory information managing and control system |
| CN107871169A (en) * | 2017-11-24 | 2018-04-03 | 中科院合肥技术创新工程院 | A kind of bill of quantities using Multiway Tree Structure encodes automatic generation method |
| CN108234261A (en) * | 2017-12-15 | 2018-06-29 | 国家电网公司 | For the service bus dispatching method of electric control system network supervision |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6938050B2 (en) * | 2002-04-23 | 2005-08-30 | International Business Machines Corporation | Content management system and methodology employing a tree-based table hierarchy which accomodates opening a dynamically variable number of cursors therefor |
-
2018
- 2018-07-18 CN CN201810787838.8A patent/CN109064126B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101981557A (en) * | 2008-03-27 | 2011-02-23 | 微软公司 | Computing environment representation |
| US8612271B2 (en) * | 2008-10-02 | 2013-12-17 | Certusview Technologies, Llc | Methods and apparatus for analyzing locate and marking operations with respect to environmental landmarks |
| CN101504741A (en) * | 2009-02-18 | 2009-08-12 | 路桥集团国际建设股份有限公司 | Intelligent metering management system and method for construction engineering |
| CN102822882A (en) * | 2010-01-15 | 2012-12-12 | 阿波洛集团公司 | Dynamically recommending learning content |
| CN101853310A (en) * | 2010-06-21 | 2010-10-06 | 北京大学 | Method for producing preorder and postorder code of single traversing tree |
| CN103136626A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | On-line management method for engineering project |
| CN104504030A (en) * | 2014-12-12 | 2015-04-08 | 国家电网公司 | Indexing method for power dispatching automation mass messages |
| CN104599061A (en) * | 2015-01-13 | 2015-05-06 | 上海建工集团股份有限公司 | Method for calculating project amount of road bridge engineering project |
| CN104933487A (en) * | 2015-06-26 | 2015-09-23 | 南京邮电大学 | Medicine retrospective application oriented medicine inquiry optimization method |
| CN107705020A (en) * | 2017-10-12 | 2018-02-16 | 山东联诚工程建设监理有限公司 | A kind of overall process intelligence engineering supervisory information managing and control system |
| CN107871169A (en) * | 2017-11-24 | 2018-04-03 | 中科院合肥技术创新工程院 | A kind of bill of quantities using Multiway Tree Structure encodes automatic generation method |
| CN108234261A (en) * | 2017-12-15 | 2018-06-29 | 国家电网公司 | For the service bus dispatching method of electric control system network supervision |
Non-Patent Citations (3)
| Title |
|---|
| 基于BIM的水电工程施工管理系统框架研究;卞小草;《水利水电快报》;20180228;全文 * |
| 工程计量在工程施工管理中的重要作用;郝旭光;《中国科技信息》;20100930;全文 * |
| 浅述工程计量与合同管理;方东苏;《中国高新技术企业》;20100331;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109064126A (en) | 2018-12-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109064126B (en) | Hydropower engineering metering information management method based on quality driving | |
| CN104866426B (en) | Software test integrated control method and system | |
| CN105718490A (en) | Method and device for updating classifying model | |
| CN108564207B (en) | BIM-based construction engineering intelligent bidding decision management system | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN107392748A (en) | A kind of income index based on dimension map matching is efficiently entered an item of expenditure in the accounts system and method | |
| CN112669019A (en) | Engineering data automatic filing method based on engineering quantity list and quality inspection data correlation interaction | |
| CN105069542A (en) | Responsibility cost budget drafting method and system | |
| CN105117588A (en) | Hospital mass business data based medical quality analysis method | |
| CN113204329A (en) | Control method for driving business application by unified data model and application system thereof | |
| CN113312736B (en) | River network hydrodynamic simulation implementation method and system based on cloud platform | |
| CN111190814A (en) | Software test case generation method and device, storage medium and terminal | |
| Zeng et al. | Mechanism analysis of influencing factors on financing efficiency of strategic emerging industries under the “dual carbon” background: evidence from China | |
| CN110363662A (en) | A kind of personal credit points-scoring system | |
| CN113722564A (en) | Visualization method and device for energy and material supply chain based on space map convolution | |
| CN110309205A (en) | A kind of data-optimized extraction system of credit decision and method | |
| CN111950903B (en) | Method and device for generating railway engineering quota and engineering quantity based on template | |
| CN114638431A (en) | Infomworks model-based typical plot year runoff total amount control rate quick-check method | |
| CN109063151A (en) | A kind of commercial banks data fusion method and device | |
| Offutt et al. | An industrial study of applying input space partitioning to test financial calculation engines | |
| Helfert | Perspectives of big data quality in smart service ecosystems (quality of design and quality of conformance) | |
| RU2589520C1 (en) | Information system for taking into account associated petroleum gas | |
| CN113807573A (en) | Construction prediction analysis method and system based on data management and three-dimensional search | |
| CN108132802B (en) | Application method of configuration model in system development | |
| Shikhli et al. | Data Acquisition Model for Analyzing Schedule Delays Using KDD: Knowledge Discovery and Datamining |
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 |