CN110390564B - Method, system and computer readable storage medium for quick self-checking items in building pricing program - Google Patents

Method, system and computer readable storage medium for quick self-checking items in building pricing program Download PDF

Info

Publication number
CN110390564B
CN110390564B CN201910648042.9A CN201910648042A CN110390564B CN 110390564 B CN110390564 B CN 110390564B CN 201910648042 A CN201910648042 A CN 201910648042A CN 110390564 B CN110390564 B CN 110390564B
Authority
CN
China
Prior art keywords
list
checking
items
data
pricing
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
Application number
CN201910648042.9A
Other languages
Chinese (zh)
Other versions
CN110390564A (en
Inventor
高照伟
李丽丽
袁鹏
乔静
陈鹏强
郭甜
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Glodon Co Ltd
Original Assignee
Glodon Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Glodon Co Ltd filed Critical Glodon Co Ltd
Priority to CN201910648042.9A priority Critical patent/CN110390564B/en
Publication of CN110390564A publication Critical patent/CN110390564A/en
Application granted granted Critical
Publication of CN110390564B publication Critical patent/CN110390564B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84Mapping; Conversion
    • G06F16/86Mapping to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0283Price estimation or determination
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/08Auctions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/08Construction

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Databases & Information Systems (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Primary Health Care (AREA)
  • Human Resources & Organizations (AREA)
  • Tourism & Hospitality (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Game Theory and Decision Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a rapid self-checking method for items in a building pricing program, which comprises the steps of carrying out standardization processing on self-checking items; the examination items are digitized and structured; and establishing rapid reading and processing of an electronic bidding document and a paper form bidding document for a newly-built bidding project in a building pricing program, forming a standardized digital document, and recording and storing according to different conditions. The invention checks the paper label, collects and analyzes the historical engineering data of users in the pricing industry by utilizing big data technology, and forms a set of standard data which accords with the business rule. And (4) checking possible problems of the current engineering data of the user by analyzing the difference between the standard data and the current engineering data of the user. The range of inspection problems mainly includes comprehensive unit price inspection and wrong sleeve inspection. The standard data is dynamically updated, so that the timeliness and the accuracy of the data are ensured.

Description

Method, system and computer readable storage medium for quick self-checking items in building pricing program
Technical Field
The invention relates to the fields of big data, multithreading, XML and the like, and mainly aims at the inspection of conformity, consistency and conventional notice of bidding quantities, bidding control price and bidding quotation of a bidding link in the construction industry.
Background
With the development of the construction industry, in order to improve the transparency of purchasing, save resources and transaction cost, and avoid the outstanding problems of bid inviting and bidding fields such as falsifying, dark box operation, colluding bidding and restricting exclusion of potential bidders by using technical means, the electronic bid inviting and bidding method is promoted from China, favorable conditions are created for fully utilizing information technical means to solve the outstanding problems of the bid inviting and bidding fields, at present, various provinces and cities carry out standard and uniform electronic bid inviting and bidding data formats and standard data interaction interfaces aiming at public bidding projects, the administrative supervision mode of electronic bid inviting and bidding is greatly changed, and comprehensive, real-time and transparent supervision of networking and paperless can be realized by using the information technology; for enterprises who bid and bid, how to guarantee successful bid and bid performance is often increasingly emphasized by enterprises in checking bid lists, bid control prices, standardization, compliance and the like of bid quotations, and how to help users accurately and efficiently check bidding specifications is a problem to be solved by related design software.
As shown in fig. 1, which is a data structure diagram of a construction project, more existing products are built-in conventional inspection items and the like according to standard data interface specifications:
as shown in Table 1, the attribute table of elements of construction project (M is optional and O is optional)
And in the actual service of the user:
TABLE 1 construction project element Attribute Table
Serial number Attribute name Attribute description Data type Description of the invention
1 Number Item numbering String
2 Name Name of item String
3 Segment Section name String
4 ProjectAddress Item address String
5 ProjectAddressCode Digital code of project attribution String
6 FileKind Cost file type String
7 StandardName Standard name String
8 StandardNumber Standard numbering String
9 Scale Construction scale String
10 Mode Construction method String
11 Explains Compile general description String
The electronic bidding project adopts project items of project amount list pricing, except necessary items explicitly specified by data interface specifications, list pricing specifications, bidding documents and the like are explicitly specified: the bidder must fill in the price according to the bid-inviting engineering quantity list, and the project code, the project name, the project characteristics, the measurement unit and the engineering quantity must be consistent with the bid-inviting engineering quantity list. If the inconsistency is not consistent, the treatment is generally carried out according to the waste standard, and the problem is very serious. When an engineering project is tendered, bid and evaluated by adopting an electronic tendering and bidding system, a user establishes the bidding project by introducing an electronic tendering book, modification changes of an engineering quantity list can be caused by conditions such as labor division, misoperation and the like in the process of bidding quotation preparation, in order to avoid the problem of waste bidding, generally, after the bidding quotation of the project is completed, whether the compliance problem of the engineering quantity list exists in a prepared bidding quotation file needs to be rapidly checked, and correction operation is carried out, and the work cannot be efficiently and accurately completed through manual comparison.
As shown in fig. 2, in the prior art, after matching a list compiled by a tender and a list of an electronic tender according to conditions such as a list code and item characteristics, consistency is checked. The above-described matching and checking processes are performed on a list-by-list basis, which is inefficient.
Secondly, the paper bidding project, bidding documents and the like can also be specified clearly: the bidder must fill in the price according to the bid amount list, and the item code, item name, item characteristics, measurement unit, amount of work must be consistent with the bid amount list, etc. If the inconsistency is not consistent, the treatment is generally carried out according to the waste standard, and the problem is very serious. The unit price of the same list and the unit price of the same material need to be consistent. For example, a large project may have tens of hundreds of unit projects, and the unit projects in the project are usually allocated to different personnel to be compiled respectively, and finally the project is merged. There may be instances where the same list item is not quoted consistently or where the same material unit price is not consistent. Therefore, after merging the projects, the user wants to check the price consistency of the quotations for the project, and if the comprehensive unit price is not consistent, the user usually compares the prices of the part of the lists to judge which list comprehensive unit price is correct, and then multiplexes the correct list price under other list items to realize the consistency of the comprehensive unit price. The requirements for checking the comprehensive unit price of the finished list and the unit price consistency of the work and material machine quickly and efficiently are very required for tenderers and bidders. The problem of waste bidding caused by time, misoperation and other conditions in the process of compiling the bid quotation generally needs to check the conformity problem of the engineering quantity list in detail after the project bid quotation is finished and carry out correction operation, and the workload is very large, so that manual comparison cannot be efficiently and accurately finished.
Aiming at the two standard book checking modes, the existing technology carries out checking according to interface specifications more, is not comprehensive in comprehensiveness and checking contents of paper standard books, and is low in checking efficiency. In addition to the conventional check items, the widely-connected products also have check items such as consistency check, conventional check, paper label check, etc. in addition to the conventional check items in the standard data interface specification. The inspection efficiency is greatly improved through the multithreading technology. And by combining a big data technology, checking more intelligent and accurate comprehensive unit price and missed set of the list according to historical engineering data of users and industries.
In general, there are still many disadvantages to the existing bidding document inspection.
1. More inspections require an operator to download and install a separate inspection tool for inspection, the operation of the lead-in part is relatively troublesome, when the inspection has problems, the inspection tool needs to be returned to the pricing software for correction, and the inspection tool and the pricing software are not mutually fused;
2. in addition to the inspection items specified by the standard interface, the conventional inspection and consistency inspection are still very concerned by the user and are also the waste mark condition items, so the inspection contents of the comprehensive and paper standard book are still lacked.
3. The efficiency is low when the bidding documents are checked one by one in a list mode.
Disclosure of Invention
The invention aims at the problems and provides a method for quickly performing project self-inspection, so that a user can quickly inspect the problem of the cost book and correct the problem in time through simple interaction of several steps.
In order to achieve the above object, the present invention provides a method for quickly self-checking items in a building pricing program, comprising:
step one, standardizing the self-checking items, wherein one or more of bid lists, bid control prices, bid quotations, quota items, free list pricing and quota pricing are distinguished to be used as checking items;
step two, digitalizing and structuring the inspection items, digitalizing and structuring according to different inspection items under different settings and a uniform standard format to form a standard digital file, and storing the standard digital file in a classified manner according to a data format;
and step three, establishing rapid reading and processing of the electronic bidding documents and the paper form bidding documents for the newly-built bidding items in the building pricing program, forming standardized digital documents and recording and storing the standardized digital documents according to different conditions.
Preferably, when the electronic bidding document is imported in the quick self-checking method, the content of the bidding document is read in an SAX mode.
Preferably, the information read from the electronic bidding document is stored in a temporary database file, and the temporary database file is imported into the user bidding project in batch for one time to generate a corresponding list.
Preferably, the table records to the project database are generated according to set rules, and the rules are stored in a common text file format and can be dynamically modified.
Preferably, the fast self-checking method adopts a multi-thread technology, allocates all the lists to a plurality of threads to perform matching and checking, and compares and checks the bidding engineering quantity list and the bidding engineering quantity list one by one to check the consistency with the bidding document.
Preferably, the above fast self-checking method further requires a regular check item, including but not limited to, a repeated list code, inconsistent unit prices of lists with the same code, a list name being empty, a list item feature being empty, a sub-project amount being zero, and a work and material machine price being zero.
Preferably, the quick self-test method further includes:
and step four, classifying the checked problems and generating a report in a standard format, and checking specific problems or positioning by double-click to a problem list to modify or intelligently and quickly modify the specific problems or the double-click to the problem list through the report.
Preferably, the rapid self-checking method includes the following steps when the paper label is imported:
step 1.1, collecting and analyzing historical engineering data of a user in the pricing industry by using a big data spark technology to form standard data meeting business rules;
step 1.2, importing the electronic bidding document and carrying out data structuring processing, and storing the electronic bidding document in a form of a table and a record in a database;
step 1.3, traversing all lists and work and material machines in the engineering project, quickly matching the same lists and the work and material machines according to judgment conditions of the same lists and the same work and material machines to form a matching data table, then comparing whether the comprehensive unit price and the unit price are the same, and recording and storing according to different conditions;
step 1.4, checking out possible problems of the current engineering data of the user by analyzing the difference between the standard data in the step 1.1 and the current engineering data of the user;
and step 1.5, classifying the checked problems and generating a report in a standard format, wherein specific problems can be checked through the report or the problems can be corrected intelligently and quickly through double-click positioning to a problem list.
Preferably, the range of checking the problem in step 1.5 mainly includes a comprehensive unit price check and a wrong-fit and wrong-fit check.
Preferably, the step 1.1 specifically includes:
(1) extracting list data in the user engineering according to time batches and uploading the list data to a server;
(2) filtering and screening the list pricing scheme with wrong items, multiple items and few items;
(3) calculating hash of comprehensive unit price of the list on the basis of the fields of the list database, the sequence, the name, the code, the unit, the characteristic and the tax-counting mode;
(4) merging the same list comprehensive unit prices according to the hash;
(5) and saving the comprehensive unit price result of the list.
A quick self-checking system for projects in a building pricing program comprises:
the standardization processing unit is used for carrying out standardization processing on the self-checking items, and one or more of bid lists, bid control prices, bid quotations, quota items, free list pricing and quota pricing are distinguished to be used as checking items;
the structure processing unit is used for carrying out digitalization and structure processing on the checking items, carrying out digitalization and structure according to different checking items under different settings and a uniform standard format to form a standard digital file, and storing the standard digital file according to data format classification;
the expression reading and processing unit is used for quickly reading and processing the electronic bidding documents and the paper form bidding documents of the newly-built bidding project in the building pricing program to form standardized digital documents and record and store the standardized digital documents according to different conditions;
and the report generation output unit is used for classifying the checked problems and generating a report in a standard format, and the specific problems can be checked through the report or the problem list can be positioned by double clicking to be modified or intelligently and quickly corrected.
Preferably, the importing of the paper label includes the following steps:
step 1.1, collecting and analyzing historical engineering data of a user in the pricing industry by using a big data spark technology to form standard data meeting business rules;
step 1.2, importing the electronic bidding document and carrying out data structuring processing, and storing the electronic bidding document in a form of a table and a record in a database;
step 1.3, traversing all lists and work and material machines in the engineering project, quickly matching the same lists and the work and material machines according to judgment conditions of the same lists and the same work and material machines to form a matching data table, then comparing whether the comprehensive unit price and the unit price are the same, and recording and storing according to different conditions;
step 1.4, checking out possible problems of the current engineering data of the user by analyzing the difference between the standard data in the step 1.1 and the current engineering data of the user;
and step 1.5, classifying the checked problems and generating a report in a standard format, wherein specific problems can be checked through the report or the problems can be corrected intelligently and quickly through double-click positioning to a problem list.
Preferably, the step 1.1 specifically includes:
(1) extracting list data in the user engineering according to time batches and uploading the list data to a server;
(2) filtering and screening the list pricing scheme with wrong items, multiple items and few items;
(3) calculating hash of comprehensive unit price of the list on the basis of the fields of the list database, the sequence, the name, the code, the unit, the characteristic and the tax-counting mode;
(4) merging the same list comprehensive unit prices according to the hash;
(5) and saving the comprehensive unit price result of the list.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of any of the above-mentioned methods.
Compared with the prior art, the invention has the following advantages:
1. the inspection range is more comprehensive: the specific checking items are divided into consistency checking, interface checking and conventional item checking, and corresponding checking items are defaulted according to the specification file, and a user can adjust the checking items as required.
2. The checking mode is more perfect: the existing bidding mode examination of the user can be met through the setting of the electronic bidding examination and the paper bidding examination. And a big data technology is introduced, and the project of the user is more intelligently and more accurately checked by using the historical project data of the user and the industry.
3. The program utilizes the multithreading technology to check all lists and work and material machines in the engineering project in parallel, and the checking efficiency is greatly improved.
4. The inspection problem is more intuitive to present: the system presents the detected problems to the user in a unified and clear classified manner, and the user can check specific problems or double click to position the problems to a problem list for modification or intelligent quick modification.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required to be used in the embodiments of the present invention will be briefly described below, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 illustrates a prior art and in-product construction project data structure diagram;
FIG. 2 is a flow chart illustrating the prior art of matching a listing compiled from a tender with a listing of an electronic tender according to conditions such as listing code, item characteristics, etc., and then checking for consistency;
FIG. 3 is a technical schematic diagram illustrating an import flow of the rapid self-checking method for items in the building pricing program according to the present invention;
FIG. 4 is a schematic diagram of the present invention, which is a technical diagram of a method for quick self-checking items in a multi-thread architecture pricing program;
FIG. 5 is a schematic diagram illustrating data collection and analysis by big data technology in the method for rapid self-checking of items in a multi-thread architecture pricing program according to the present invention.
Detailed Description
Features and exemplary embodiments of various aspects of the present invention will be described in detail below, and in order to make objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not to be construed as limiting the invention. It will be apparent to one skilled in the art that the present invention may be practiced without some of these specific details. The following description of the embodiments is merely intended to provide a better understanding of the present invention by illustrating examples of the present invention.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The embodiment provides a method for quickly self-checking items in a building pricing program, which comprises the following steps:
step one, standardizing the self-checking items, wherein one or more of bid lists, bid control prices, bid quotations, quota items, free list pricing and quota pricing are distinguished to be used as checking items;
step two, digitalizing and structuring the inspection items, digitalizing and structuring according to different inspection items under different settings and a uniform standard format to form a standard digital file, and storing the standard digital file in a classified manner according to a data format;
and step three, establishing rapid reading and processing of the electronic bidding documents and the paper form bidding documents for the newly-built bidding items in the building pricing program, forming standardized digital documents and recording and storing the standardized digital documents according to different conditions.
In some embodiments, when the electronic bidding document is imported in the quick self-check method, the content of the bidding document is read in an SAX mode.
In some embodiments, the information read from the electronic bidding document is stored in a temporary database file, and the temporary database file is imported into the user bidding project in batch for one time to generate a corresponding list.
In some embodiments, table records to the project database are generated according to set rules, which are stored in plain text file format and are dynamically modifiable.
In some embodiments, the fast self-check method is used for checking consistency with the bidding document by adopting a multi-thread technology, distributing all the lists into a plurality of threads to perform matching and checking, and comparing and checking the bidding engineering quantity list and the bidding engineering quantity list item by item.
In some embodiments, the fast self-checking method further requires regular check items, including but not limited to check items such as list coding repetition, inconsistent unit prices of lists synthesized by the same coding, list name empty, list item feature empty, sub-project amount zero, and work and material machine price zero.
In some embodiments, the fast self-test method further comprises: and step four, classifying the checked problems and generating a report in a standard format, and checking specific problems or positioning by double-click to a problem list to modify or intelligently and quickly modify the specific problems or the double-click to the problem list through the report.
In some embodiments, the self-test rules are as shown in table 2, and the rules are stored in plain text file format and can be dynamically modified.
Table 2 sample table of self-checking rules
Figure BDA0002134188660000101
In some embodiments, the fast self-checking method includes the following steps when the paper label is imported:
step 1.1, collecting and analyzing historical engineering data of a user in the pricing industry by using a big data spark technology to form standard data meeting business rules;
step 1.2, importing the electronic bidding document and carrying out data structuring processing, and storing the electronic bidding document in a form of a table and a record in a database;
step 1.3, traversing all lists and work and material machines in the engineering project, quickly matching the same lists and the work and material machines according to judgment conditions of the same lists and the same work and material machines to form a matching data table, then comparing whether the comprehensive unit price and the unit price are the same, and recording and storing according to different conditions;
step 1.4, checking out possible problems of the current engineering data of the user by analyzing the difference between the standard data in the step 1.1 and the current engineering data of the user;
and step 1.5, classifying the checked problems and generating a report in a standard format, wherein specific problems can be checked through the report or the problems can be corrected intelligently and quickly through double-click positioning to a problem list. The range of inspection problems mainly includes comprehensive unit price inspection and wrong sleeve inspection.
In some embodiments, step 1.1 specifically comprises:
(1) extracting list data in the user engineering according to time batches and uploading the list data to a server;
(2) filtering and screening the list pricing scheme with wrong items, multiple items and few items;
(3) calculating hash of comprehensive unit price of the list on the basis of the fields of the list database, the sequence, the name, the code, the unit, the characteristic and the tax-counting mode;
(4) merging the same list comprehensive unit prices according to the hash;
(5) and saving the comprehensive unit price result of the list.
The present invention also provides an embodiment comprising the steps of:
the electronic bidding document checking item:
1. and importing the electronic bidding document when the bidding project is newly established.
The file format of electronic posters is typically XML. When the electronic bidding document is imported, the content of the bidding document is read in an SAX mode. SAX is a technology that reads XML documents efficiently, compared to another technology that reads XML: DOM and SAX are higher in efficiency and lower in memory occupation.
The information read from the tender is stored in a temporary database file. Then, the temporary database files are imported into the user bidding engineering in batch at one time to generate corresponding lists. The biggest technical difficulty of the step is how to generate the table record of the project database according to the information of the bidding document and certain rules. The rules are stored in a fixed format file and can be dynamically modified. Different bidding document formats can be supported only by modifying the rule file and not re-encoding codes, and the method is very flexible to use. Fig. 3 shows a technical schematic diagram of the import flow. And if the rule changes, modifying the corresponding rule file.
2. Executing the function of 'conformity check' or 'check and bidding document consistency' (the system will compare and check the bidding engineering quantity list and bidding engineering quantity list one by one, and record the problems of item addition, item deficiency, item modification and the like);
as shown in FIG. 4, the present invention adopts the multithreading technology, and utilizes the characteristic that the present computer is generally a multi-core CPU to distribute all the lists to a plurality of threads to execute matching and checking, which is several times higher than the prior art in operating efficiency.
3. The regular check items can be freely set according to the options.
4. The system presents reports to users uniformly and clearly in a classified manner aiming at the detected problems, and the users can check specific problems or double click to position a problem list for modification or intelligent quick modification;
the export report file formats are Excel and Html, and the report result is displayed visually and has a clear structure.
Second, paper label examination item:
1. and selecting paper label for inspection.
2. Setting the functions of 'comprehensive unit price consistency of the list', 'unit price consistency of the work and material machine', routine inspection and the like;
3. the program traverses all lists and work and material machines in the engineering project, quickly matches the same lists and the work and material machines according to the judgment conditions of the same lists and the same work and material machines to form a matching data table, then compares whether the comprehensive unit price and the unit price are the same, and records and stores the comprehensive unit price and the unit price aiming at different conditions;
4. after the comparison and check are finished, the checked problems are uniformly and clearly presented to the user, and the user can check specific problems or double click to position the problems to a problem list or a work and material machine for modification or intelligent quick correction.
As shown in fig. 5, the examination of the paper label utilizes big data technology to collect and analyze the historical engineering data of users in the pricing industry, and a set of standard data meeting the business rules is formed. And (4) checking possible problems of the current engineering data of the user by analyzing the difference between the standard data and the current engineering data of the user. The range of inspection problems mainly includes comprehensive unit price inspection and wrong sleeve inspection. The standard data is dynamically updated, so that the timeliness and the accuracy of the data are ensured.
Furthermore, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.
Furthermore, a server may be provided, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the above method when executing the program.
Compared with the prior art, the invention
1. The inspection range is more comprehensive: the specific checking items are divided into consistency checking, interface checking and conventional item checking, and corresponding checking items are defaulted according to the specification file, and a user can adjust the checking items as required.
2. The checking mode is more perfect: the existing bidding mode examination of the user can be met through the setting of the electronic bidding examination and the paper bidding examination.
3. The inspection problem is more intuitive to present: the system presents reports to users uniformly and clearly in a classified manner aiming at the detected problems, and the users can check specific problems or double click to position a problem list for modification or intelligent quick modification;
4. and a historical project data warehouse of a user and an industry is established by using a big data technology, so that project self-checking can be more intelligently and more accurately performed.
5. And the multithreading technology is used for improving the checking efficiency.
6. And a historical project data warehouse of a user and an industry is established by using a big data technology, so that project self-checking can be more intelligently and more accurately performed.
7. The multithreading technology is used for greatly improving the checking efficiency while ensuring the accuracy, so that the work of a user is more efficient.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims (12)

1. A quick self-checking method for items in a building pricing program is characterized by comprising the following steps:
step one, standardizing the self-checking items, wherein one or more of bid lists, bid control prices, bid quotations, quota items, free list pricing and quota pricing are distinguished to be used as checking items;
step two, digitalizing and structuring the inspection items, digitalizing and structuring according to different inspection items under different settings and a uniform standard format to form a standard digital file, and storing the standard digital file in a classified manner according to a data format;
establishing rapid reading and processing of an electronic bidding document and a paper bidding document for a newly-built bidding project in a building pricing program to form a standardized digital document and record and store the standardized digital document according to different conditions;
the rapid self-checking method comprises the following steps when the electronic bidding document is imported:
step 1.1, collecting and analyzing historical engineering data of a user in the pricing industry by using a big data spark technology to form standard data meeting business rules;
step 1.2, importing the electronic bidding document and carrying out data structuring processing, and storing the electronic bidding document in a form of a table and a record in a database;
step 1.3, traversing all lists and work and material machines in the engineering project, quickly matching the same lists and the work and material machines according to judgment conditions of the same lists and the same work and material machines to form a matching data table, then comparing whether the comprehensive unit price and the unit price are the same, and recording and storing according to different conditions;
step 1.4, checking out possible problems of the current engineering data of the user by analyzing the difference between the standard data in the step 1.1 and the current engineering data of the user;
and step 1.5, classifying the checked problems and generating a report in a standard format, wherein specific problems can be checked through the report or the problems can be corrected intelligently and quickly through double-click positioning to a problem list.
2. The method as claimed in claim 1, wherein when the electronic bidding document is introduced into the method, the content of the bidding document is read in SAX mode.
3. The method for rapidly self-checking items in a construction pricing program according to claim 1 or 2, characterized in that the information read from the electronic bidding document is stored in a temporary database file, and the temporary database file is imported into a user bidding project in batch for one time to generate a corresponding list.
4. The method of claim 3, wherein the table records are generated to the project database according to set rules, the rules are stored in a plain text file format and can be dynamically modified.
5. The method for rapid self-checking items in a building pricing program according to any of claims 1-2 and 4, characterized in that the method for rapid self-checking is to perform matching and checking by using multi-thread technology, distributing all lists to a plurality of threads, and comparing and checking the bidding engineering quantity list and the bidding engineering quantity list one by one to check the consistency with the bidding document.
6. The method for rapid self-checking of items in a building pricing program according to claim 5, wherein the method for rapid self-checking further requires regular checking items, including but not limited to list code repetition, inconsistent unit prices for the same code list, list name empty, list item feature empty, sub-project amount zero, and work and material machine price zero.
7. The method of claim 6, further comprising:
and step four, classifying the checked problems and generating a report in a standard format, and checking specific problems or positioning by double-click to a problem list to modify or intelligently and quickly modify the specific problems or the double-click to the problem list through the report.
8. The method for rapidly self-checking items in a building pricing program according to claim 1, characterized in that the range of checking problems in step 1.5 comprises a comprehensive unit price check and a wrong-fit and wrong-fit check.
9. The method for rapidly self-checking items in a building pricing program according to claim 1 or 8, wherein the step 1.1 specifically comprises:
(1) extracting list data in the user engineering according to time batches and uploading the list data to a server;
(2) filtering and screening the list pricing scheme with wrong items, multiple items and few items;
(3) calculating hash of comprehensive unit price of the list on the basis of the fields of the list database, the sequence, the name, the code, the unit, the characteristic and the tax-counting mode;
(4) merging the same list comprehensive unit prices according to the hash;
(5) and saving the comprehensive unit price result of the list.
10. A quick self-checking system for projects in a building pricing program comprises:
the standardization processing unit is used for carrying out standardization processing on the self-checking items, and one or more of bid lists, bid control prices, bid quotations, quota items, free list pricing and quota pricing are distinguished to be used as checking items;
the structure processing unit is used for carrying out digitalization and structure processing on the checking items, carrying out digitalization and structure according to different checking items under different settings and a uniform standard format to form a standard digital file, and storing the standard digital file according to data format classification;
the expression reading and processing unit is used for establishing rapid reading and processing of an electronic bidding document and a paper bidding document for a newly-built bidding project in the building pricing program, forming a standardized digital document and recording and storing the standardized digital document according to different conditions;
the report generation output unit is used for classifying the checked problems and generating a report in a standard format, and the specific problems can be checked through the report or the problem list can be positioned by double clicking to be modified or intelligently and quickly corrected;
the quick self-checking system is specifically used for the following steps when the electronic bidding document is imported: step 1.1, collecting and analyzing historical engineering data of a user in the pricing industry by using a big data spark technology to form standard data meeting business rules; step 1.2, importing the electronic bidding document and carrying out data structuring processing, and storing the electronic bidding document in a form of a table and a record in a database; step 1.3, traversing all lists and work and material machines in the engineering project, quickly matching the same lists and the work and material machines according to judgment conditions of the same lists and the same work and material machines to form a matching data table, then comparing whether the comprehensive unit price and the unit price are the same, and recording and storing according to different conditions; step 1.4, checking out possible problems of the current engineering data of the user by analyzing the difference between the standard data in the step 1.1 and the current engineering data of the user; and step 1.5, classifying the checked problems and generating a report in a standard format, wherein specific problems can be checked through the report or the problems can be corrected intelligently and quickly through double-click positioning to a problem list.
11. The system according to claim 10, characterized in that said step 1.1 comprises in particular:
(1) extracting list data in the user engineering according to time batches and uploading the list data to a server;
(2) filtering and screening the list pricing scheme with wrong items, multiple items and few items;
(3) calculating hash of comprehensive unit price of the list on the basis of the fields of the list database, the sequence, the name, the code, the unit, the characteristic and the tax-counting mode;
(4) merging the same list comprehensive unit prices according to the hash;
(5) and saving the comprehensive unit price result of the list.
12. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 9.
CN201910648042.9A 2019-07-18 2019-07-18 Method, system and computer readable storage medium for quick self-checking items in building pricing program Active CN110390564B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910648042.9A CN110390564B (en) 2019-07-18 2019-07-18 Method, system and computer readable storage medium for quick self-checking items in building pricing program

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910648042.9A CN110390564B (en) 2019-07-18 2019-07-18 Method, system and computer readable storage medium for quick self-checking items in building pricing program

Publications (2)

Publication Number Publication Date
CN110390564A CN110390564A (en) 2019-10-29
CN110390564B true CN110390564B (en) 2022-04-15

Family

ID=68285168

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910648042.9A Active CN110390564B (en) 2019-07-18 2019-07-18 Method, system and computer readable storage medium for quick self-checking items in building pricing program

Country Status (1)

Country Link
CN (1) CN110390564B (en)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111400252B (en) * 2020-03-11 2023-10-31 国网江西省电力有限公司信息通信分公司 Project acceptance compliance-based detection system, device, detection method and application
CN111754193A (en) * 2020-06-24 2020-10-09 精效新软新技术(北京)有限公司 Automatic accounting method, system and medium for piece wage in production and processing process
CN112084302B (en) * 2020-08-24 2024-04-30 江苏易达捷信数字科技有限公司 Method, system, device and storage medium for detecting inventory data of cost file
CN112598375A (en) * 2020-12-16 2021-04-02 中国建设银行股份有限公司 Property inspection analysis method and device for intelligent park
CN112734369A (en) * 2020-12-31 2021-04-30 大为国际工程咨询有限公司 Engineering cost management system based on big data
CN112966486A (en) * 2021-03-17 2021-06-15 机械工业第九设计研究院有限公司 Intelligent engineering quantity list generation method and device, terminal and storage medium
CN113762224B (en) * 2021-11-09 2022-04-29 四川野马科技有限公司 Engineering cost achievement quality inspection system and method thereof
CN114493266A (en) * 2022-01-26 2022-05-13 海天工程咨询有限公司 Intelligent quality control method and system for engineering cost achievement

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105719070A (en) * 2016-01-18 2016-06-29 四川建设网有限责任公司 Electronic auxiliary reviewing method and system
CN105741011A (en) * 2016-01-18 2016-07-06 四川建设网有限责任公司 Engineering tender offer and evaluation method and engineering tender offer and evaluation system
CN109034673A (en) * 2018-09-07 2018-12-18 赣州和永软件开发有限责任公司 A kind of method, system, equipment and storage medium for realizing the synchronous control of engineering construction project
CN109857799A (en) * 2019-01-29 2019-06-07 国网物资有限公司 The automatic auditing system of tender price and method
CN110008458A (en) * 2019-04-11 2019-07-12 国网河北省电力有限公司物资分公司 The structuring preparation method of electric power bidding document

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20060010081A1 (en) * 2001-03-01 2006-01-12 Williams Charles W Automated system for assisting the architectural process

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105719070A (en) * 2016-01-18 2016-06-29 四川建设网有限责任公司 Electronic auxiliary reviewing method and system
CN105741011A (en) * 2016-01-18 2016-07-06 四川建设网有限责任公司 Engineering tender offer and evaluation method and engineering tender offer and evaluation system
CN109034673A (en) * 2018-09-07 2018-12-18 赣州和永软件开发有限责任公司 A kind of method, system, equipment and storage medium for realizing the synchronous control of engineering construction project
CN109857799A (en) * 2019-01-29 2019-06-07 国网物资有限公司 The automatic auditing system of tender price and method
CN110008458A (en) * 2019-04-11 2019-07-12 国网河北省电力有限公司物资分公司 The structuring preparation method of electric power bidding document

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
广联达计价软件GB4.0中单位工程自检;禾沐;《服务新干线》;20181010;第1-3页 *

Also Published As

Publication number Publication date
CN110390564A (en) 2019-10-29

Similar Documents

Publication Publication Date Title
CN110390564B (en) Method, system and computer readable storage medium for quick self-checking items in building pricing program
US20220237174A1 (en) Structuring data
Lu et al. Discovering interacting artifacts from ERP systems
US9665403B2 (en) Executing algorithms in parallel
Rahman et al. Source code properties of defective infrastructure as code scripts
KR20180030521A (en) Data quality analysis
US20070162482A1 (en) Method and system of using artifacts to identify elements of a component business model
CN109063178B (en) Method and device for automatically expanding self-help analysis report
AU2013202007A1 (en) Data selection and identification
CN110728422A (en) Building information model, method, device and settlement system for construction project
CN113326247A (en) Cloud data migration method and device and electronic equipment
CN114461644A (en) Data acquisition method and device, electronic equipment and storage medium
CN111414410A (en) Data processing method, device, equipment and storage medium
CN110704525A (en) Method, system and medium for realizing data transfer between multiple systems
CN113538626A (en) Workflow generation method and device
CN110765100B (en) Label generation method and device, computer readable storage medium and server
CN112099801A (en) Excel analysis method and system based on metadata driving
CN113159118A (en) Logistics data index processing method, device, equipment and storage medium
US20140372386A1 (en) Detecting wasteful data collection
US20140149186A1 (en) Method and system of using artifacts to identify elements of a component business model
Mittelmann et al. A server for automated performance analysis of benchmarking data
CN113961649A (en) Multi-source data fusion method and system
CN111125483A (en) Method and device for generating webpage data extraction template, computer device and computer readable storage medium
Ouhaichi et al. Dynamic data management for machine learning in embedded systems: A case study
CN117972115B (en) Method, equipment and medium for constructing process automation rule base

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