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.
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.
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.