Nothing Special   »   [go: up one dir, main page]

CN111523854B - BIM and database-based automatic price-covering system related to automatic pre-settlement - Google Patents

BIM and database-based automatic price-covering system related to automatic pre-settlement Download PDF

Info

Publication number
CN111523854B
CN111523854B CN202010292375.5A CN202010292375A CN111523854B CN 111523854 B CN111523854 B CN 111523854B CN 202010292375 A CN202010292375 A CN 202010292375A CN 111523854 B CN111523854 B CN 111523854B
Authority
CN
China
Prior art keywords
information
engineering quantity
current
unique identification
engineering
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
CN202010292375.5A
Other languages
Chinese (zh)
Other versions
CN111523854A (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.)
Guangzhou Xiangshi Engineering Consulting Co ltd
Original Assignee
Guangzhou Xiangshi Engineering Consulting 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 Guangzhou Xiangshi Engineering Consulting Co ltd filed Critical Guangzhou Xiangshi Engineering Consulting Co ltd
Priority to CN202010292375.5A priority Critical patent/CN111523854B/en
Publication of CN111523854A publication Critical patent/CN111523854A/en
Application granted granted Critical
Publication of CN111523854B publication Critical patent/CN111523854B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • 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
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • 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/0278Product appraisal
    • 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

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

Abstract

The invention discloses an automatic price registering system and method based on BIM and a database, which relate to automatic pre-settlement; the technical scheme is characterized in that first unique identification information corresponding to engineering quantity information is sequentially called and second unique identification information is traversed and inquired; if the second unique identification information correlated with the first unique identification information is matched, the engineering price information corresponding to the second unique identification information is called and combined with the engineering quantity information corresponding to the first unique identification information to form the engineering budget information corresponding to the engineering.

Description

BIM and database-based automatic price-covering system related to automatic pre-settlement
The invention is a divisional application, the original application number: 201910215026.0, filing date: 2019, 3 months, 21 days, invention name: automatic price registering method, system and storage medium based on BIM and database.
Technical Field
The invention relates to an automatic pre-settlement system, in particular to an automatic price registering system and method based on BIM and a database.
Background
Engineering budget is a plan made for the income and expense of engineering projects over a period of time in the future. The method can evaluate the investment of the engineering project in a currency form and reflect the economic effect of the engineering. The method is a basis for strengthening enterprise management, carrying out economic accounting, checking engineering cost and planning construction; and is also the main basis for bidding price and determining engineering cost.
The estimation, the general calculation and the construction diagram budget (investment checking calculation) compiled in each design stage are important components of the design file, and are also important bases for determining engineering cost and controlling engineering investment. In the process of programming engineering single budget, engineering cost personnel consult the quota according to the number of each professional engineering, and the single budget is programmed, so that the whole workload is large, and the workload accounts for about 80% of the whole set of budget files, and the method is a key link for determining the budget files and even completing all the files on time.
In the process, engineering cost personnel frequently add a shift point; because the whole working time is short and the task is heavy, the project cost personnel often have insufficient time to check and audit, the situation of error leakage occurs, and some serious errors can directly lead to the failure of bidding, so that the error rate is high in the artificial processing process, and the accuracy requirement of the existing budget cannot be met.
The invention patent application publication No. CN107038603A discloses an engineering quotation generating method and system based on BIM software, wherein the engineering quotation generating method comprises the steps of selecting a template file in the BIM software, setting a quota of a component in the template file, setting working procedure engineering quantity for completing the consumption of a unit component product and calculation rules, a main material and metering rules thereof in the quota, selecting the component and the main material adopted by the component in the template file, completing the establishment of a model, counting the engineering quantity and the main material quantity of the model according to the working procedure engineering quantity calculation rules and the main material metering rules set in the quota by a designer after setting the quota for each component, reading the engineering quantity and the main material quantity, and generating a quotation according to price information in a database, wherein each engineering and main material in the model is matched with the engineering and main material in the database, and if the matching is successful, the engineering quotation and the main material quotation are obtained through the engineering quantity and the unit price calculation of the matched engineering and main material.
Besides the earlier project budget quotation, accurate settlement data is needed to finish the project construction process, and the frequency of pre-settlement becomes quite high due to repeated design change or/and price change of the construction process, so that the workload of project cost personnel is high and errors are easy to occur.
Disclosure of Invention
The first object of the present invention is to provide an automatic price-covering method based on BIM and database, which can automatically identify and conduct price covering, reduce the workload of engineering cost personnel and simultaneously reduce the error rate.
The technical aim of the invention is realized by the following technical scheme:
an automatic price-covering method based on BIM and a database, comprising the following steps:
acquiring engineering quantity list information, wherein the engineering quantity list information comprises engineering quantity information corresponding to different projects; the engineering quantity information corresponding to each engineering is preset with first unique identification information corresponding to the engineering quantity information;
acquiring enterprise price information, wherein the enterprise price information comprises engineering price information corresponding to engineering quantity information one by one, and the engineering price information is preset with second unique identification information which is mutually related to the first unique identification information;
sequentially calling the first unique identification information corresponding to the engineering quantity information and traversing and inquiring the second unique identification information;
and if the project price information is matched with the second unique identification information which is correlated with the first unique identification information, retrieving the project price information corresponding to the second unique identification information and combining the project quantity information corresponding to the first unique identification information with each other to form project budget information corresponding to the project.
By adopting the scheme, the engineering quantity information and the engineering price information form the association relation according to the association relation between the first unique identification information and the second unique identification information, namely, after the engineering quantity information is acquired, the engineering price information corresponding to the engineering quantity information is acquired, so that the engineering price information corresponding to the engineering quantity information is acquired, and the engineering quantity information and the engineering price information are mutually calculated and combined to form engineering budget information, so that the manually processed engineering budget work is converted into automatic processing, the workload of engineering cost personnel is greatly reduced, and meanwhile, the error rate caused by manpower is further reduced.
Preferably, a plurality of project budget information are subjected to superposition calculation to form budget cost information;
obtaining budget cost information and preset standard price template information;
comparing the budget cost information with the standard price template information;
if the comparison difference rate exceeds the preset difference range, the budget cost information is automatically marked.
By adopting the scheme, after each engineering budget is overlapped with each other, the whole budget cost is formed; if the result of each budget cost is manually judged, a great amount of time is required to be consumed, so that program judgment is directly carried out through corresponding budget cost information and preset standard price template information, once the contrast difference between the budget cost information and the standard price template information is within an allowable range, the budget cost information is directly proposed, and all budget files can be initially screened, so that the progress of forming the judgment result is greatly quickened.
Preferably, the engineering quantity list information further comprises engineering quantity name information;
acquiring current engineering quantity name information corresponding to the current engineering quantity list information according to the first unique identification information;
analyzing and comparing the name information of the current engineering quantity with preset check name information which corresponds to the first unique identification information one by one;
if the current engineering quantity name information is the same as the check name information, judging that the current engineering quantity list information and the first unique identification information are in a corresponding relation;
if the current engineering quantity name information is different from the check name information, judging that the current engineering quantity list information and the first unique identification information are not in a corresponding relation.
By adopting the scheme, because the corresponding requirements of each project are different, related data information is required to be manually input, and errors are easy to occur in the process of producing the project quantity list information, so that the project quantity list information is required to be checked; in order to ensure that the subsequent automatic price registering function can be accurately realized, namely, the current engineering quantity list information and the first unique identification information are mutually corresponding, otherwise, the accurate enterprise price information cannot be called, so that the acquired current engineering quantity name information and the check name information are compared, if the current engineering quantity name information and the check name information are the same, the explanation is free of problems, and if the current engineering quantity name information and the check name information are different, the explanation is problematic.
Preferably, current behavior information of a current user is obtained;
searching current instruction information corresponding to the current behavior information from the corresponding relation between preset behavior information and instruction information, wherein the behavior information comprises verification trigger information for verifying engineering quantity list information, and the instruction information comprises verification execution information mutually corresponding to the verification trigger information;
and according to the verification execution information, acquiring engineering quantity list information for verification.
By adopting the scheme, the verification process needs to be performed in a form of considering triggering, namely, the engineering quantity list information is acquired for verification according to the verification triggering information of the current user, and because part of engineering quantity list information does not need to be verified, time is wasted, so that the verification function is more applicable through a triggering mode.
Preferably, the engineering quantity name information includes name keyword information;
searching current keyword information corresponding to the current engineering quantity name information according to the check name information;
if the check name information has the current keyword information, judging that the current engineering quantity name information is the same as the check name information;
if the check name information does not have the current keyword information, the current engineering quantity name information is judged to be different from the check name information.
By adopting the scheme, when judging whether the current engineering quantity name information is the same as the check name information, because some wrongly written words or different expression modes possibly exist in the editing process, the names of the current engineering quantity name information and the check name information are not the same, but some keywords certainly exist in the two names to be the same, whether the current engineering quantity name information is the same as the check name information is judged by judging whether the corresponding keywords are the same, so that the judgment logic is more logical.
Preferably, if it is determined that the current engineering quantity list information and the first unique identification information are not in a corresponding relationship with each other, the current engineering quantity list information is pushed to the relevant responsible person.
By adopting the scheme, if the two pieces of information are judged not to correspond to each other, the corresponding engineering quantity list information is directly pushed to a responsible person, the responsible person is modified, the verification is carried out again after the modification, the automatic price covering is carried out only after the confirmation of no problem, and the accuracy of formed data is ensured.
A second object of the present invention is to provide a computer-readable storage medium capable of storing a corresponding program, automatically recognizing and performing a trepanning, reducing the workload of engineering personnel, and reducing an error rate.
The technical aim of the invention is realized by the following technical scheme:
a computer readable storage medium comprising a program capable of implementing a BIM and database based automated price matching method as described above when loaded and executed by a processor.
By adopting the scheme, the engineering quantity information and the engineering price information form the association relation according to the association relation between the first unique identification information and the second unique identification information, namely, after the engineering quantity information is acquired, the engineering price information corresponding to the engineering quantity information is acquired, so that the engineering price information corresponding to the engineering quantity information is acquired, and the engineering quantity information and the engineering price information are mutually calculated and combined to form engineering budget information, so that the manually processed engineering budget work is converted into automatic processing, the workload of engineering cost personnel is greatly reduced, and meanwhile, the error rate caused by manpower is further reduced.
The third object of the present invention is to provide an automatic price registering system based on BIM and database, which can automatically identify and register price, reduce the workload of engineering cost personnel and reduce error rate.
The technical aim of the invention is realized by the following technical scheme:
an automated trending system based on a BIM and database, comprising:
the acquisition module is used for acquiring engineering quantity list information and enterprise price information;
the memory is used for storing the program of the automatic price-covering method based on the BIM and the database;
the processor, the program in the memory can be loaded and executed by the processor and realize the automatic price-covering method based on BIM and the database.
By adopting the scheme, the engineering quantity information and the engineering price information form the association relation according to the association relation between the first unique identification information and the second unique identification information, namely, after the engineering quantity information is acquired, the engineering price information corresponding to the engineering quantity information is acquired, so that the engineering price information corresponding to the engineering quantity information is acquired, and the engineering quantity information and the engineering price information are mutually calculated and combined to form engineering budget information, so that the manually processed engineering budget work is converted into automatic processing, the workload of engineering cost personnel is greatly reduced, and meanwhile, the error rate caused by manpower is further reduced.
Preferably, the system further comprises a trigger module for responding to the trigger action of the current user to output the current behavior information.
By adopting the scheme, the verification process needs to be performed in a form of considering triggering, namely, the engineering quantity list information is acquired for verification according to the verification triggering information of the current user, and because part of engineering quantity list information does not need to be verified, time is wasted, so that the verification function is more applicable through a triggering mode.
In summary, the invention has the following beneficial effects: the engineering quantity list information and the engineering price information can be automatically associated through the first unique identification information and the second unique identification information, so that the automatic price covering function is realized, the labor cost is greatly saved, and the error rate is reduced.
Drawings
FIG. 1 is a schematic flow chart of automatic price set according to an embodiment of the present invention;
FIG. 2 is a flow chart of an automatic price-trending method based on BIM and a database in an embodiment of the invention;
FIG. 3 is a flow chart of a method for checking the information of the process flow list in an embodiment of the invention;
fig. 4 is a flowchart of a method for determining a keyword between current engineering quantity name information and check name information according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more clear, the present invention will be described in further detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. It should be noted that, if a directional indication (such as up, down, left, right, front, and rear … …) is involved in the embodiment of the present invention, the directional indication is merely used to explain the relative positional relationship, movement condition, etc. between the components in a specific posture, and if the specific posture is changed, the directional indication is correspondingly changed.
The embodiment of the invention provides an automatic price-covering method based on BIM and a database, which comprises the steps of obtaining engineering quantity list information, wherein the engineering quantity list information comprises engineering quantity information corresponding to different projects; the engineering quantity information corresponding to each engineering is preset with first unique identification information corresponding to the engineering quantity information; acquiring enterprise price information, wherein the enterprise price information comprises engineering price information corresponding to engineering quantity information one by one, and the engineering price information is preset with second unique identification information which is mutually related to the first unique identification information; sequentially calling the first unique identification information corresponding to the engineering quantity information and traversing and inquiring the second unique identification information; and if the project price information is matched with the second unique identification information which is correlated with the first unique identification information, retrieving the project price information corresponding to the second unique identification information and combining the project quantity information corresponding to the first unique identification information with each other to form project budget information corresponding to the project.
According to the method and the device, the engineering quantity information and the engineering price information are formed into the association relation according to the association relation between the first unique identification information and the second unique identification information, namely, after the engineering quantity information is acquired, the engineering price information corresponding to the engineering quantity information is acquired, so that the engineering price information corresponding to the engineering quantity information is acquired, and the engineering quantity information and the engineering price information are mutually calculated and combined to form engineering budget information, so that the engineering budget work which is manually processed is converted into automatic processing, the workload of engineering cost personnel is greatly reduced, and meanwhile, the error rate caused by manpower is further reduced.
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In addition, the term "and/or" herein is merely an association relationship describing an association object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist together, and B exists alone. In this context, unless otherwise specified, the term "/" generally indicates that the associated object is an "or" relationship.
Embodiments of the invention are described in further detail below with reference to the drawings.
Referring to fig. 1, an embodiment of the present invention provides an automatic bid method based on BIM and a database, and the main flow of the method is described as follows.
As shown in fig. 1 and 2:
step 1000: acquiring engineering quantity list information, wherein the engineering quantity list information comprises engineering quantity information corresponding to different projects; the engineering quantity information corresponding to each engineering is preset with first unique identification information corresponding to the engineering quantity information.
The engineering quantity list information is the matter of construction required by each engineering; for example, inventory coding, project name, project characteristics, and engineering quantity information; and project features include model specification, material type, size, etc.; the engineering quantity information is the corresponding working time. When the engineering quantity list information is acquired, the engineering quantity list information can be formed by a direct introduction mode or a manual input mode by a cost personnel.
Encoding the related engineering quantity information, namely encoding through preset first unique identification information which corresponds to the engineering quantity information one by one, wherein the encoding mode can be in various forms, and the encoding mode can be in a digital encoding form, namely, different engineering quantity information corresponds to different numbers, so that the numbers corresponding to each engineering quantity information are different, and the uniqueness of the codes corresponding to the different engineering quantity information is ensured; the method can also ensure that the letters corresponding to the engineering quantity information are different through the letter coding form, namely, different engineering quantity information corresponds to different letters, so that the uniqueness of the codes corresponding to the different engineering quantity information is ensured, and the letters can be a single letter or a combination of a plurality of letters; or a two-dimensional code or a bar code with uniqueness; in this embodiment, one or more of a digital code form, an alphabetic code form, and a two-dimensional code form may be used.
Step 2000: and acquiring enterprise price information, wherein the enterprise price information comprises engineering price information corresponding to the engineering quantity information one by one, and the engineering price information is preset with second unique identification information which is mutually related to the first unique identification information.
The enterprise price information is stored in an enterprise price database, and all enterprise price information stored in the enterprise price database has a unified coding form and a list format; the enterprise price information can be directly imported through corresponding software, and can be formed in a manual input mode; the related enterprise price information can also be formed by directly calling cases in the history case database through a preset history case database.
Encoding the related engineering price information, namely encoding the second unique identification information which is mutually associated with the first unique identification information and preset by the engineering price information, wherein the encoding mode can be in various forms, namely, different engineering quantity information and different numbers can be corresponding through a digital encoding form, so that the numbers corresponding to each engineering quantity information are different, and the uniqueness of the codes corresponding to the different engineering quantity information is ensured; the method can also ensure that the letters corresponding to the engineering quantity information are different through the letter coding form, namely, different engineering quantity information corresponds to different letters, so that the uniqueness of the codes corresponding to the different engineering quantity information is ensured, and the letters can be a single letter or a combination of a plurality of letters; or a two-dimensional code or a bar code with uniqueness; in this embodiment, one or more of a digital code form, an alphabetic code form, and a two-dimensional code form may be used.
The association form between the first unique identification information and the second unique identification information may be the same association, that is, the first unique identification information and the second unique identification information are encoded in the same way, for example, the encoding of the engineering quantity information is 1, and the encoding of the engineering price information is also 1; the association may be in a form of unique correspondence, that is, the first unique identification information corresponds to the second unique identification information one by one, and the unique correspondence is that, for example, the code of the engineering quantity information is x, the code of the engineering price information is y, and no other codes adopt x and y.
Step 3000: and sequentially calling the first unique identification information corresponding to the engineering quantity information and traversing and inquiring the second unique identification information.
The traversal inquiry refers to inquiring all the second unique identification information in turn aiming at the first unique identification information corresponding to each piece of the extracted engineering quantity information, so that omission is avoided.
Step 4000: and if the project price information is matched with the second unique identification information which is correlated with the first unique identification information, retrieving the project price information corresponding to the second unique identification information and combining the project quantity information corresponding to the first unique identification information with each other to form project budget information corresponding to the project.
According to the association relation between the first unique identification information and the second unique identification information, the engineering quantity information and the engineering price information form the association relation, namely, after the engineering quantity information is acquired, the engineering price information corresponding to the engineering quantity information is called, so that after the engineering price information corresponding to the engineering quantity information is acquired, the engineering quantity information and the engineering price information are mutually calculated and combined to form single engineering budget information.
Step 5000: and performing superposition calculation on the plurality of project budget information to form budget cost information.
The budget cost is formed by overlapping a plurality of engineering budgets, so that the final budget overlapping information is formed by overlapping a plurality of engineering budgets, and the overlapping calculation is accumulation calculation.
Step 6000: and obtaining budget cost information and preset standard price template information.
The preset standard price template information is the minimum line requirement, and the specific numerical value is set according to the actual project condition.
Step 7000: comparing the budget cost information with the standard price template information; if the comparison difference rate exceeds the preset difference range, the budget cost information is automatically marked.
If the result of each budget cost is manually judged, a great amount of time is required to be consumed, so that program judgment is directly carried out through corresponding budget cost information and preset standard price template information, and once the contrast difference between the budget cost information and the standard price template information exceeds the set range of the system, the budget cost information is directly marked, and the marking can be realized through color identification, direct extraction and the like; after marking, the manual intervention inquiry processing is performed later, so that all budget files can be initially screened, and the efficiency is greatly improved; the comparison difference rate is obtained by comparing the budget cost information with the standard price template information one by one and counting the number of errors, and dividing the number of errors by the total number of errors, and the difference range can be set according to the actual situation.
Because the corresponding requirements of each project are different, part of the project is required to manually input related data information, and errors are easy to occur in the process of producing the project quantity list information, so that the project quantity list information is required to be checked; as shown in fig. 3, the checking method of the specific engineering quantity list information is as follows:
the engineering quantity list information also comprises engineering quantity name information; the engineering quantity name information includes, among others, the variety, specification, grade (e.g., strength grade), label, size, etc. of the material.
Step 8100: and obtaining the current behavior information of the current user.
The current behavior information can be obtained in a mode of triggering by a mechanical key or in a mode of triggering by a virtual key; the mode of triggering the mechanical key can be automatically obtained by pressing a start key after starting, or the current behavior information can be obtained by pressing the corresponding trigger case again after starting; the virtual key triggering mode can be achieved by pressing a related virtual trigger key in an interface of corresponding software. The checking process needs to be performed in a form of considering triggering, namely, the engineering quantity list information is acquired for verification according to the verification triggering information of the current user, and because part of engineering quantity list information does not need to be verified, time is wasted, so that the verification function is more applicable through a triggering mode.
Step 8200: searching current instruction information corresponding to the current behavior information from the corresponding relation between preset behavior information and instruction information, wherein the behavior information comprises verification trigger information for verifying engineering quantity list information, and the instruction information comprises verification execution information mutually corresponding to the verification trigger information.
After the current behavior information is acquired, inquiring between preset behavior information and instruction information, and after the instruction information corresponding to the current behavior information is inquired, namely if the acquired current behavior information is verification trigger information, correspondingly inquiring to be verification execution information.
Step 8300: and according to the verification execution information, acquiring engineering quantity list information for verification.
Step 8310: and acquiring the name information of the current engineering quantity corresponding to the list information of the current engineering quantity according to the first unique identification information.
Step 8320: and analyzing and comparing the current engineering quantity name information with preset check name information which corresponds to the first unique identification information one by one.
Step 8330: and if the current engineering quantity name information is the same as the check name information, judging that the current engineering quantity list information and the first unique identification information are in a corresponding relation.
Step 8340: if the current engineering quantity name information is different from the check name information, judging that the current engineering quantity list information and the first unique identification information are not in a corresponding relation.
In order to ensure that the subsequent automatic price registering function can be accurately realized, that is, the current engineering quantity list information and the first unique identification information correspond to each other, otherwise, accurate enterprise price information cannot be called, so that the acquired current engineering quantity name information and check name information are compared, if the current engineering quantity name information and the check name information are the same, the explanation is free of problems, and if the current engineering quantity name information and the check name information are different, the explanation is problematic.
Step 8350: if the current engineering quantity list information and the first unique identification information are judged not to be in the corresponding relation, the current engineering quantity list information is pushed to related responsible persons.
And if the two pieces of information are judged not to correspond to each other, the corresponding engineering quantity list information is directly pushed to a responsible person, the responsible person is modified, the verification is carried out again after the modification, the automatic price covering is carried out only after the confirmation of no problem, and the accuracy of the formed data is ensured.
When judging whether the current engineering quantity name information is the same as the check name information, because some wrongly written words or different expression modes may exist in the editing process, the names of the current engineering quantity name information and the check name information are not the same, but some keywords are the same in the two names, so that whether the current engineering quantity name information is the same as the check name information is judged by judging whether the corresponding keywords are the same, as shown in fig. 4, a specific method for judging the current engineering quantity name information and the check name information by the keywords is as follows:
wherein the engineering quantity name information includes name keyword information. The name keyword information is formed by manual input, and keywords in the current engineering quantity name information can be obtained through a keyword recognition technology.
Step 8360: and searching the current keyword information corresponding to the current engineering quantity name information according to the check name information.
The check name information is the information preset before, namely the information used for comparison.
Step 8370: if the check name information has the current keyword information, the current engineering quantity name information is judged to be the same as the check name information.
Step 8380: if the check name information does not have the current keyword information, the current engineering quantity name information is judged to be different from the check name information.
Embodiments of the present invention provide a computer readable storage medium comprising instructions capable of being loaded and executed by a processor to implement the method of FIGS. 1-4. The steps are described in the flow.
The computer-readable storage medium includes, for example: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Based on the same inventive concept, an embodiment of the present invention provides an automatic price-trending system based on a BIM and a database, including:
the acquisition module is used for acquiring engineering quantity list information and enterprise price information;
the triggering module responds to the triggering action of the current user to output current behavior information;
the memory is used for storing the program of the automatic price-covering method based on the BIM and the database;
a processor, a program in a memory can be loaded and executed by the processor, and the implementation is as in fig. 1-4. The automatic price-covering method based on BIM and the database is described in the flow.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional modules is illustrated, and in practical application, the above-described functional allocation may be performed by different functional modules according to needs, i.e. the internal structure of the apparatus is divided into different functional modules to perform all or part of the functions described above. The specific working processes of the above-described systems, devices and units may refer to the corresponding processes in the foregoing method embodiments, which are not described herein.
In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the modules or units is merely a logical functional division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution, in the form of a software product stored in a storage medium, including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor (processor) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a mobile hard disk, a read-only memory, a random access memory, a magnetic disk or an optical disk.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.

Claims (6)

1. An automated bid system based on BIM and database involving automated pre-settlement, comprising:
the system comprises an acquisition module, a management module and a management module, wherein the acquisition module is used for acquiring engineering quantity list information and enterprise price information, and the engineering quantity list information comprises engineering quantity information corresponding to different projects; the engineering quantity information corresponding to each engineering is preset with first unique identification information corresponding to the engineering quantity information; the enterprise price information comprises engineering price information which corresponds to the engineering quantity information one by one, and second unique identification information which is mutually related to the first unique identification information is preset in the engineering price information; the enterprise price information is stored in an enterprise price database, and all enterprise price information stored in the enterprise price database has a uniform coding form and a list format;
a memory for storing only automatic trending programs based on the BIM and the database;
a processor, the program in the memory being loadable and executable by the processor, the processor being configured to perform, in an automatic trepanning process, in order to achieve automatic trepanning based on BIM and a database: sequentially calling the first unique identification information corresponding to the engineering quantity information and traversing and inquiring the second unique identification information;
if the project price information is matched with the second unique identification information which is correlated with the first unique identification information, the project price information corresponding to the second unique identification information is called and combined with the project quantity information corresponding to the first unique identification information to form project budget information corresponding to the project;
superposing and calculating a plurality of project budget information to form budget cost information;
acquiring the budget cost information and preset standard price template information;
comparing the budget cost information with standard price template information; if the comparison difference rate exceeds the preset difference range, automatically marking the budget cost information;
the automatic price-trending system further comprises a triggering module, and the triggering module responds to the triggering action of the current user to output current behavior information; comparing the budget cost information with the standard price template information one by one, counting the number of errors, and dividing the number of errors by the total number of errors to form a comparison difference rate; if the comparison difference rate exceeds the preset difference range, automatically marking the budget cost information; the marking is realized by a color identification or direct extraction mode; after the marking, the manual intervention inquiry processing is performed later, so that all budget files can be primarily screened;
the engineering quantity list information also comprises engineering quantity name information; the processor is further configured to perform, during the reconciliation of the engineering quantity inventory information:
acquiring current engineering quantity name information corresponding to the current engineering quantity list information according to the first unique identification information;
analyzing and comparing the name information of the current engineering quantity with preset check name information which corresponds to the first unique identification information one by one;
if the current engineering quantity name information is the same as the check name information, judging that the current engineering quantity list information and the first unique identification information are in a corresponding relation;
if the current engineering quantity name information is different from the check name information, judging that the current engineering quantity list information and the first unique identification information are not in a corresponding relation;
the processor is further configured to:
obtaining current behavior information of a current user;
searching current instruction information corresponding to the current behavior information from the corresponding relation between preset behavior information and instruction information, wherein the behavior information comprises verification trigger information for verifying engineering quantity list information, and the instruction information comprises verification execution information mutually corresponding to the verification trigger information;
and acquiring engineering quantity list information according to the verification execution information to verify.
2. The automated trending system of claim 1, wherein the engineering quantity name information comprises name keyword information; the processor is further configured to:
searching current keyword information corresponding to the current engineering quantity name information according to the check name information;
if the check name information has the current keyword information, judging that the current engineering quantity name information is the same as the check name information;
and if the check name information does not have the current keyword information, judging that the current engineering quantity name information is different from the check name information.
3. The automated listing system of claim 1, wherein the current project amount listing information is pushed if it is determined that the current project amount listing information and the first unique identifying information are not in correspondence with each other.
4. A BIM and database based automatic bidding method involving automatic pre-settlement employing an automatic bidding system according to any of claims 1 to 3, the method comprising the steps of:
acquiring engineering quantity list information, wherein the engineering quantity list information comprises engineering quantity information corresponding to different projects; the engineering quantity information corresponding to each engineering is preset with first unique identification information corresponding to the engineering quantity information; encoding the related engineering quantity information, namely encoding through preset first unique identification information which corresponds to the engineering quantity information one by one;
acquiring enterprise price information, wherein the enterprise price information comprises engineering price information corresponding to the engineering quantity information one by one, and the engineering price information is preset with second unique identification information which is mutually related to the first unique identification information; encoding the related engineering price information, namely encoding second unique identification information which is mutually associated with the first unique identification information and preset by the engineering price information;
sequentially calling the first unique identification information corresponding to the engineering quantity information and traversing and inquiring the second unique identification information;
if the project price information is matched with the second unique identification information which is correlated with the first unique identification information, the project price information corresponding to the second unique identification information is called and combined with the project quantity information corresponding to the first unique identification information to form project budget information corresponding to the project;
superposing and calculating a plurality of project budget information to form budget cost information;
obtaining budget cost information and preset standard price template information;
comparing the budget cost information with the standard price template information;
the automatic trending method further comprises the following steps: checking the engineering quantity list information, wherein the checking method of the engineering quantity list information comprises the following steps:
obtaining current behavior information of a current user;
searching current instruction information corresponding to current behavior information from a corresponding relation between preset behavior information and instruction information, wherein the current behavior information comprises verification trigger information for verifying engineering quantity list information, and the current instruction information comprises verification execution information mutually corresponding to the verification trigger information;
acquiring engineering quantity list information for verification according to the verification execution information;
acquiring current engineering quantity name information corresponding to the current engineering quantity list information according to the first unique identification information;
analyzing and comparing the name information of the current engineering quantity with preset check name information which corresponds to the first unique identification information one by one;
if the current engineering quantity name information is the same as the check name information, judging that the current engineering quantity list information and the first unique identification information are in a corresponding relation;
if the current engineering quantity name information is different from the check name information, judging that the current engineering quantity list information and the first unique identification information are not in a corresponding relation, and pushing the current engineering quantity list information.
5. The automatic bid amount method based on BIM and database involving automatic pre-settlement according to claim 4, wherein the current engineering amount name information includes name keyword information, whether the current engineering amount name information is identical to the check name information is judged by whether corresponding keywords are identical, and the specific method for judging by keywords between the current engineering amount name information and the check name information includes:
searching current keyword information corresponding to the current engineering quantity name information according to the check name information;
if the check name information has the current keyword information, judging that the current engineering quantity name information is the same as the check name information;
if the check name information does not have the current keyword information, the current engineering quantity name information is judged to be different from the check name information.
6. A computer readable storage medium comprising a program capable of being loaded and executed by a processor to implement a BIM and database based automated trending method involving automated pre-settlement as claimed in claim 4 or 5.
CN202010292375.5A 2019-03-21 2019-03-21 BIM and database-based automatic price-covering system related to automatic pre-settlement Active CN111523854B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010292375.5A CN111523854B (en) 2019-03-21 2019-03-21 BIM and database-based automatic price-covering system related to automatic pre-settlement

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201910215026.0A CN110009302A (en) 2019-03-21 2019-03-21 Automatic cross rate method, system and storage medium based on BIM and database
CN202010292375.5A CN111523854B (en) 2019-03-21 2019-03-21 BIM and database-based automatic price-covering system related to automatic pre-settlement

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
CN201910215026.0A Division CN110009302A (en) 2019-03-21 2019-03-21 Automatic cross rate method, system and storage medium based on BIM and database

Publications (2)

Publication Number Publication Date
CN111523854A CN111523854A (en) 2020-08-11
CN111523854B true CN111523854B (en) 2024-01-12

Family

ID=67167508

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201910215026.0A Pending CN110009302A (en) 2019-03-21 2019-03-21 Automatic cross rate method, system and storage medium based on BIM and database
CN202010292375.5A Active CN111523854B (en) 2019-03-21 2019-03-21 BIM and database-based automatic price-covering system related to automatic pre-settlement

Family Applications Before (1)

Application Number Title Priority Date Filing Date
CN201910215026.0A Pending CN110009302A (en) 2019-03-21 2019-03-21 Automatic cross rate method, system and storage medium based on BIM and database

Country Status (1)

Country Link
CN (2) CN110009302A (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110851462B (en) * 2019-11-06 2022-09-16 福建晨曦信息科技集团股份有限公司 One-key pricing method and terminal based on engineering data
CN113095775A (en) * 2021-03-23 2021-07-09 四川省公路规划勘察设计研究院有限公司 Processing method and system for obtaining roadbed protection project quantity
CN113129057A (en) * 2021-04-16 2021-07-16 河南省信息咨询设计研究有限公司 Software cost information processing method and device, computer equipment and storage medium
CN114022240A (en) * 2021-11-02 2022-02-08 安徽省招标集团股份有限公司 Manufacturing cost deviation processing method and system
CN115907875B (en) * 2022-10-21 2024-07-12 珠海纵横创新软件有限公司 Price interval manufacturing method and device, electronic equipment and medium
CN116503189B (en) * 2023-04-11 2023-12-05 广东建瀚工程管理有限公司 Big data-based cost accounting method, device, computer equipment and medium

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107038603A (en) * 2017-03-17 2017-08-11 东易日盛家居装饰集团股份有限公司 A kind of engineering quotation generation method and system based on BIM softwares
CN109472642A (en) * 2018-11-09 2019-03-15 国网湖南省电力有限公司 The editing of electricity power engineering cost and inventory application system based on working drawing budget management

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105335905B (en) * 2015-11-24 2020-01-21 广州拓欧信息技术有限公司 Building engineering calculation and evaluation system and method
CN108288173A (en) * 2017-12-26 2018-07-17 淮阴工学院 A kind of ancient building local-style dwelling houses timber structure renovation project budget method
CN108564336B (en) * 2018-03-21 2021-11-26 国网浙江省电力有限公司经济技术研究院 Substation installation project construction drawing identification and budgeting method and system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107038603A (en) * 2017-03-17 2017-08-11 东易日盛家居装饰集团股份有限公司 A kind of engineering quotation generation method and system based on BIM softwares
CN109472642A (en) * 2018-11-09 2019-03-15 国网湖南省电力有限公司 The editing of electricity power engineering cost and inventory application system based on working drawing budget management

Also Published As

Publication number Publication date
CN111523854A (en) 2020-08-11
CN110009302A (en) 2019-07-12

Similar Documents

Publication Publication Date Title
CN111523854B (en) BIM and database-based automatic price-covering system related to automatic pre-settlement
CN108764773B (en) Product material coding management method and system
CN110083623B (en) Business rule generation method and device
US20230359599A1 (en) Method and system for managing metadata
CN113420057A (en) Account checking data processing method and related device
CN111831382A (en) Data entry method, device, equipment and medium for engineering cost software
CN114091126A (en) BOM arrangement checking system of PCBA
CN112232962A (en) Transaction index processing method, device and equipment
CN109324963B (en) Method for automatically testing profit result and terminal equipment
CN111651500A (en) User identity recognition method, electronic device and storage medium
CN111242779A (en) Financial data characteristic selection and prediction method, device, equipment and storage medium
CN116795425A (en) Chip front-end development system and method based on git
CN113205421A (en) Accounting method and device for financial products
CN112907220A (en) System, method and device for engineering cost
CN111858324A (en) Automatic generation method and device of test case
CN111353285A (en) Intelligent clearing data configuration method and system
CN112435108A (en) Method and system for managing storage of sodium system and electronic equipment
CN117710068B (en) Temporary supplier verification method, device and equipment based on artificial intelligence
JP6224669B2 (en) Payment application system, payment application method, and program
CN116795329B (en) Work report generation method and device for software engineering and readable storage medium
CN118363874B (en) Keyword-driven automatic use case data generation method
CN115658778B (en) Excel data source-based data processing method for visual application creation
CN110673888B (en) Verification method and device for configuration file
CN117891499A (en) Data processing method, data processing device, computer readable storage medium and electronic equipment
US20210133887A1 (en) Efficiently aging and modifying policy records in a test system

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
CB03 Change of inventor or designer information

Inventor after: Ye Xiuyan

Inventor after: Li Yubin

Inventor after: Zeng Xiangrui

Inventor after: Zhong Delong

Inventor after: Chen Chengliang

Inventor after: Guan Jiahui

Inventor before: Li Yubin

Inventor before: Zeng Xiangrui

Inventor before: Ye Xiuyan

Inventor before: Zhong Delong

Inventor before: Chen Chengliang

Inventor before: Guan Jiahui

CB03 Change of inventor or designer information
GR01 Patent grant
GR01 Patent grant