CN115391446A - Full-automatic list mapping method and system based on BIM system and readable storage medium - Google Patents
Full-automatic list mapping method and system based on BIM system and readable storage medium Download PDFInfo
- Publication number
- CN115391446A CN115391446A CN202211087214.8A CN202211087214A CN115391446A CN 115391446 A CN115391446 A CN 115391446A CN 202211087214 A CN202211087214 A CN 202211087214A CN 115391446 A CN115391446 A CN 115391446A
- Authority
- CN
- China
- Prior art keywords
- component
- data
- information
- list
- bim
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/13—Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/194—Calculation of difference between files
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Geometry (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Civil Engineering (AREA)
- Architecture (AREA)
- Software Systems (AREA)
- Structural Engineering (AREA)
- Computational Mathematics (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Evolutionary Computation (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明公开一种基于BIM系统的清单全自动映射系统及方法,涉及BIM数据映射技术领域,所述方法包括:建立并存储用以反映构件与编码之间对应关系的第一关联关系;建立并存储用以反映BIM模型与各构件之间、以及各构件与各子构件之间对应关系的第二关联关系;获取待生成清单编码的BIM模型,基于所述第二关联关系生成并存储所述BIM模型对应的构件信息及子构件信息;基于所述第一关联关系生成所述BIM模型对应的清单编码。通过上述技术方案,当用户输入BIM模型后系统能够自动根据设定的关系模型将BIM模型进行拆解,得到对应的构件信息及子构件信息,而后调取各个构件对应的编码最终得到BIM模型清单编码,使得后期组价更为高效准确。
The invention discloses a BIM system-based fully automatic list mapping system and method, and relates to the technical field of BIM data mapping. The method includes: establishing and storing a first association relationship for reflecting the corresponding relationship between components and codes; establishing and storing the second association relationship used to reflect the corresponding relationship between the BIM model and each component, and between each component and each sub-component; obtaining the BIM model coded to be generated, generating and storing the Component information and sub-component information corresponding to the BIM model; generating a list code corresponding to the BIM model based on the first association relationship. Through the above technical solution, when the user inputs the BIM model, the system can automatically disassemble the BIM model according to the set relationship model, obtain the corresponding component information and sub-component information, and then call the code corresponding to each component to finally obtain the BIM model list Coding makes the later price formation more efficient and accurate.
Description
技术领域technical field
本发明涉及BIM数据映射技术领域,更具体地说,它涉及一种基于BIM系统的清单全自动映射方法、系统及可读存储介质。The present invention relates to the technical field of BIM data mapping, more specifically, it relates to a BIM system-based fully automatic mapping method, system and readable storage medium.
背景技术Background technique
建筑行业中,工程预算组价是基于国标清单(建设工程的分部分项工程项目、措施项目、其他项目规费项目和税金项目的名称和相应数量等的明细清单)完成的,上述国标清单对工程施工中各项目均规定了对应的编码,即项目编码,上述编码的位数以及指向都是明确的,当前的国标清单中各项目是按照12位编码的方式进行排序的,例如010101001001,其中前两位01代表附录顺序码01(建筑)定额种类;第三四位代表(石)方工程(第一章);第五六位代表土方工程(第一节);第七八九位代表平整场地(第一项),最后三位代表清单项目名称顺序码(由清单编制人设置)。其中一至九位是按照相关标准文件的规定设置,十至十二位应根据拟建工程的工程量清单项目名称设置,同一工程的项目编码不应有重码。In the construction industry, project budget pricing is completed based on the national standard list (detailed list of sub-items of construction projects, measure items, other project fee items and tax items, and the corresponding quantities, etc.). Each item in the project construction has specified a corresponding code, that is, the project code. The digits and directions of the above-mentioned codes are clear. The items in the current national standard list are sorted according to the 12-digit code, such as 010101001001, where The first two digits 01 represent the appendix sequence code 01 (construction) quota category; the third and fourth digits represent (stone) engineering (Chapter 1); the fifth and sixth digits represent earthwork engineering (section 1); the seventh and eighth digits represent Leveling the site (the first item), the last three digits represent the sequence code of the list item name (set by the list compiler). Among them, one to nine digits shall be set according to the relevant standard documents, and ten to twelve digits shall be set according to the item name of the bill of quantities of the proposed project, and the item codes of the same project shall not have repeated codes.
现有技术中,基于上述清单规则进行组价的方式已十分常见,操作时只需要人工输入各项目数量系统便可以自动从国标清单中直接引用叠加得到对应的工程组价。但是,在BIM(建筑信息模型)系统中当前的组价方式仍然是以BIM构件为单位进行人工组价的,例如按照模型中墙体、柱体或混凝土板为单位进行计价组价,无法按照国标清单进行统计,这就使得整个组价过程耗时耗力且准确度难以得到保证。In the prior art, it is very common to set prices based on the above-mentioned list rules. During operation, the system only needs to manually input the quantity of each item, and then the system can automatically quote and superimpose the corresponding project price from the national standard list. However, the current pricing method in the BIM (Building Information Modeling) system is still manually priced in units of BIM components, such as the wall, column or concrete slab in the model. The national standard list is used for statistics, which makes the whole pricing process time-consuming and labor-intensive, and the accuracy is difficult to guarantee.
发明内容Contents of the invention
针对实际运用时BIM系统中模型组价耗时耗力且准确度难以得到保证这一问题,本申请一方面在于提出一种基于BIM系统的清单全自动映射方法,其通过采用特殊的编码映射规则实现了为BIM模型中各个构件匹配符合国家标准的清单条目,不仅能够实现组件的自动化操作,提升组价效率,还能够显著提升组价的准确性。为实现上述方法,本申请另一方面在于提供一种基于BIM系统的清单全自动映射系统,最后,提出一种加载有用以实现上述方法的程序模块的计算机可读存储介质,具体方案如下:In view of the time-consuming and labor-intensive cost of model pricing in the BIM system and the difficulty in ensuring the accuracy of the actual application, this application proposes a fully automatic mapping method for the list based on the BIM system, which adopts special coding mapping rules It realizes the matching of list items that meet national standards for each component in the BIM model, which can not only realize the automatic operation of components, improve the efficiency of price grouping, but also significantly improve the accuracy of price grouping. In order to realize the above method, another aspect of the present application is to provide a fully automatic list mapping system based on the BIM system. Finally, a computer-readable storage medium loaded with program modules for realizing the above method is proposed. The specific scheme is as follows:
一种基于BIM系统的清单全自动映射方法,包括:A method for fully automatic mapping of inventory based on BIM system, including:
建立并存储用以反映构件与编码之间对应关系的第一关联关系;establishing and storing a first association relationship for reflecting the corresponding relationship between components and codes;
建立并存储用以反映BIM模型与各构件之间、以及各构件与各子构件之间对应关系的第二关联关系;Establishing and storing a second association relationship for reflecting the corresponding relationship between the BIM model and each component, and between each component and each sub-component;
获取待生成清单编码的BIM模型,基于所述第二关联关系生成并存储所述BIM模型对应的构件信息及子构件信息;Obtain the BIM model coded by the list to be generated, generate and store component information and sub-component information corresponding to the BIM model based on the second association relationship;
基于所述第一关联关系生成所述BIM模型对应的清单编码。A list code corresponding to the BIM model is generated based on the first association relationship.
通过上述技术方案,当用户输入BIM模型后系统能够自动根据设定的关系模型将BIM模型进行拆解,得到对应的构件信息及子构件信息,而后调取各个构件对应的编码最终得到BIM模型清单编码,使得后期组价更为高效准确。Through the above technical solution, when the user inputs the BIM model, the system can automatically disassemble the BIM model according to the set relationship model, obtain the corresponding component information and sub-component information, and then call the code corresponding to each component to finally obtain the BIM model list Coding makes the later price formation more efficient and accurate.
进一步的,所述建立并存储用以反映构件与编码之间对应关系的第一关联关系,包括:Further, the establishment and storage of the first association to reflect the correspondence between components and codes includes:
导入并存储各构件的编码规则形成一规则库;Import and store the coding rules of each component to form a rule base;
于设定模板中输入构件信息并于所述规则库中查找所述构件信息对应的编码规则;Input component information in the setting template and search the encoding rules corresponding to the component information in the rule base;
若规则库中存有所述构件信息对应的编码规则,则基于所述编码规则对所述构件信息进行编码并存储;If the encoding rules corresponding to the component information are stored in the rule base, encoding and storing the component information based on the encoding rules;
若规则库中未有所述构件信息对应的编码规则,则提示手动输入维护所述编码规则生成所述构件信息对应的编码并存储。If there is no encoding rule corresponding to the component information in the rule base, prompt to manually input and maintain the encoding rule to generate and store the encoding corresponding to the component information.
通过上述技术方案,用户可以对第一关联关系加以完善,使得系统能够适应于不同的BIM构件,未来具有更好的兼容性与扩展性。Through the above technical solution, the user can improve the first association relationship, so that the system can adapt to different BIM components, and has better compatibility and scalability in the future.
进一步的,所述导入并存储各构件的编码规则形成一规则库,包括:Further, said importing and storing the encoding rules of each component forms a rule base, including:
将各位编码按照设定规则划分为多个组别;Divide each code into multiple groups according to the set rules;
建立各个组别中各个编码与编码之间的关联关系以及各组编码之间的关联关系;Establish the association relationship between each code and code in each group and the association relationship between each group of codes;
检测设定组别编码及其变化,根据上述关联关系生成清单编码设定位数的编码;Detect the set group code and its changes, and generate the code with the set digits of the list code according to the above association relationship;
其中,所述关联关系包括固定对应关系以及设定的计算公式。Wherein, the association relationship includes a fixed correspondence relationship and a set calculation formula.
通过上述技术方案,用户只需要输入部分编码系统便能够准确生成并分配剩余的编码,使得规则库的维护高效准确。Through the above technical solution, the user only needs to input part of the coding system to accurately generate and distribute the remaining codes, so that the maintenance of the rule base is efficient and accurate.
进一步的,所述检测设定组别编码及其变化,包括:Further, the detection setting group code and its changes include:
设定编码编辑审批权限及数据链接;Set code editing approval authority and data link;
检测并响应于编码编辑请求,或检测编码变化情况,生成审批请求;Detect and respond to coding edit requests, or detect coding changes, and generate approval requests;
确认审批结果,若审批确认则固定编码修改内容。Confirm the approval result, and if the approval is confirmed, the fixed code will be modified.
通过上述技术方案,可以保证规则库中的编码不会被错误修改。Through the above technical solution, it can be guaranteed that the codes in the rule base will not be wrongly modified.
进一步的,基于所述第一关联关系生成所述BIM模型对应的清单编码,还包括:Further, generating the list code corresponding to the BIM model based on the first association relationship further includes:
根据BIM模型对应的构件信息及子构件信息生成构件清单;Generate a component list according to the component information and sub-component information corresponding to the BIM model;
基于上述构件清单查找未被赋予编码的构件信息或子构件信息;Find component information or sub-component information that has not been coded based on the above component list;
突出显示所述构件信息或子构件信息,调取构件信息或子构件信息对应的编码编辑界面;Highlighting the component information or sub-component information, calling the code editing interface corresponding to the component information or sub-component information;
建立上述编码编辑界面与所述规则库之间的数据连接,基于编码编辑界面获取的操作信息于所述规则库中添加所述子构件信息对应的编码规则。Establish a data connection between the coding editing interface and the rule base, and add coding rules corresponding to the sub-component information to the rule base based on the operation information acquired by the coding editing interface.
通过上述技术方案,可以在生成清单编码时对BIM模型对应的构件信息或子构件信息进行筛查,避免遗漏。Through the above technical solution, the component information or sub-component information corresponding to the BIM model can be screened when the list code is generated to avoid omissions.
进一步的,所述规则库基于一数据表格加以存储;Further, the rule base is stored based on a data table;
所述第一关联关系包括所述数据表格及其中设定单元格之间基于设定计算公式或映射映射关系;The first association relationship includes the data table and the set calculation formula or mapping relationship between the set cells;
所述规则库中预设有数据检索单元,基于用户操作进行数据全局搜索。A data retrieval unit is preset in the rule base to perform global data search based on user operations.
通过上述技术方案,方便用户对规则库加以维护。Through the above technical solution, it is convenient for the user to maintain the rule base.
为实现上述方法,本申请还提出了一种基于BIM系统的清单全自动映射系统,包括:In order to realize the above method, this application also proposes a BIM system-based fully automatic inventory mapping system, including:
存储单元,配置为用以存储反映构件与编码之间对应关系的第一关联关系、以及用以反映BIM模型与各构件之间、各构件与各子构件之间对应关系的第二关联关系、以及BIM模型对应的构件信息及子构件信息;a storage unit configured to store a first association that reflects the correspondence between components and codes, and a second association that reflects the correspondence between the BIM model and each component, and between each component and each sub-component, And the component information and sub-component information corresponding to the BIM model;
交互单元,配置为用于获取用户输入的数据及指令、获取待生成清单编码的BIM模型并输出清单编码及映射过程中的提示信息;The interaction unit is configured to obtain the data and instructions input by the user, obtain the BIM model of the checklist code to be generated, and output the checklist code and the prompt information during the mapping process;
处理单元,配置为与交互单元及存储单元数据连接,接收获取待生成清单编码的BIM模型以及用户输入的数据及指令,基于所述第二关联关系生成构件清单,而后根据第一关联关系并基于上述构件清单生成BIM模型对应的清单编码。The processing unit is configured to be data-connected with the interaction unit and the storage unit, receive and acquire the BIM model coded to be generated and the data and instructions input by the user, generate a component list based on the second association relationship, and then based on the first association relationship and based on The above component list generates the list code corresponding to the BIM model.
进一步的,所述处理单元中还配置有规则库维护模块,包括:Further, the processing unit is also configured with a rule base maintenance module, including:
数据查找组件,配置为接收用户输入的数据并根据第一关联关系于存储单元中查找对应的编码规则或清单编码;The data search component is configured to receive the data input by the user and search the corresponding coding rule or list code in the storage unit according to the first association relationship;
编码规则修订组件,配置为与存储单元内的第一关联关系、第二关联关系中特定数据存储区域数据连接,接收并响应于交互单元输出的数据及指令,对上述特定数据存储区域中的数据加以修改或补充;The encoding rule revision component is configured to be connected to the data in the specific data storage area in the first association relationship and the second association relationship in the storage unit, receive and respond to the data and instructions output by the interaction unit, and modify the data in the above-mentioned specific data storage area be amended or supplemented;
编码映射检查组件,配置为与处理单元数据连接,基于处理单元生成的BIM模型对应的清单编码以及BIM模型对应的构件信息及子构件信息,查找并输出未成功映射的构件信息;The code mapping inspection component is configured to be connected to the data of the processing unit, based on the list code corresponding to the BIM model generated by the processing unit and the component information and sub-component information corresponding to the BIM model, to find and output component information that has not been successfully mapped;
映射结果提示组件,配置为与所述交互单元数据连接,接收并输出未成功映射的构件信息或于BIM模型的三维图像中突出显示未成功映射的构件。The mapping result prompt component is configured to be data-connected with the interaction unit, receive and output information about components that have not been mapped successfully or highlight the components that have not been successfully mapped in the three-dimensional image of the BIM model.
进一步的,所述存储单元包括一数据存储表,所述第一关联关系包括用于存储构件信息的数据单元格与用于存储编码信息的数据单元格之间的直接映射关系,所述第二关联关系包括用于存储BIM模型信息的数据单元格与用于存储构件信息或子构件信息数据单元格之间的直接关联或间接关联关系;Further, the storage unit includes a data storage table, the first association relationship includes a direct mapping relationship between a data cell for storing component information and a data cell for storing encoding information, and the second The association relationship includes the direct or indirect association between the data cell used to store BIM model information and the data cell used to store component information or sub-component information;
其中,用于存储编码信息的数据单元格相互之间设定有定值关联关系或基于设定计算公式的关联关系。Wherein, the data cells used to store the coding information are set with a fixed-value association relationship or an association relationship based on a set calculation formula.
通过上述技术方案,用户输入BIM模型信息后系统可以快速的根据设定规则生成国标清单编码,在映射过程中可以对未成功映射的构件信息加以突出显示并提供规则库维护规则及相关交互界面,有助于避免BIM模型清单编码映射不完全,实现了为BIM模型中各个构件匹配符合国家标准的清单条目,不仅能够实现组件的自动化操作,提升组价效率,还能够显著提升组价的准确性。Through the above technical solution, after the user enters the BIM model information, the system can quickly generate the national standard list code according to the set rules. During the mapping process, it can highlight the component information that has not been successfully mapped and provide rule base maintenance rules and related interactive interfaces. It helps to avoid incomplete coding and mapping of the BIM model list, and realizes the matching of list items that meet national standards for each component in the BIM model. It can not only realize the automatic operation of components, improve the efficiency of price grouping, but also significantly improve the accuracy of price grouping .
一种计算机可读存储介质,所述可读存储介质加载有用以实现如前所述的基于BIM系统的清单全自动映射方法的计算机程序。A computer-readable storage medium loaded with a computer program for realizing the above-mentioned BIM system-based fully automatic inventory mapping method.
与现有技术相比,本发明的有益效果如下:Compared with the prior art, the beneficial effects of the present invention are as follows:
用户输入BIM模型信息后系统可以快速的根据设定规则生成国标清单编码,在映射过程中可以对未成功映射的构件信息加以突出显示并提供规则库维护规则及相关交互界面,有助于避免BIM模型清单编码映射不完全,实现了为BIM模型中各个构件匹配符合国家标准的清单条目,不仅能够实现组件的自动化操作,提升组价效率,还能够显著提升组价的准确性。After the user enters the BIM model information, the system can quickly generate the national standard list code according to the set rules. During the mapping process, it can highlight the unsuccessfully mapped component information and provide rule base maintenance rules and related interactive interfaces, which help to avoid BIM The code mapping of the model list is not complete, and the list items that meet the national standards are matched for each component in the BIM model. It can not only realize the automatic operation of components, improve the efficiency of price grouping, but also significantly improve the accuracy of price grouping.
附图说明Description of drawings
图1为本发明方法的整体流程示意图;Fig. 1 is the overall flow diagram of the inventive method;
图2为导入并存储各构件编码规则形成一规则库的流程示意图;Fig. 2 is a schematic flow diagram of importing and storing each component coding rule to form a rule base;
图3为生成清单编码后进一步维护规则库的流程示意图;Fig. 3 is a schematic flow chart of further maintaining the rule base after the list code is generated;
图4为本发明系统的功能模块示意图。Fig. 4 is a schematic diagram of functional modules of the system of the present invention.
附图标记:1、存储单元;2、交互单元;3、处理单元;4、数据查找组件;5、编码规则修订组件;6、编码映射检查组件;7、映射结果提示组件。Reference signs: 1. Storage unit; 2. Interaction unit; 3. Processing unit; 4. Data search component; 5. Coding rule revision component; 6. Coding mapping checking component; 7. Mapping result prompting component.
具体实施方式Detailed ways
下面结合实施例及图对本申请作进一步的详细说明,但本发明的实施方式不仅限于此。The present application will be further described in detail below with reference to the examples and figures, but the embodiments of the present invention are not limited thereto.
一种基于BIM系统的清单全自动映射方法,如图1所示,主要包括如下步骤:A fully automatic mapping method for inventory based on BIM system, as shown in Figure 1, mainly includes the following steps:
S100,建立并存储用以反映构件与编码之间对应关系的第一关联关系;S100. Establish and store a first association relationship for reflecting the correspondence between components and codes;
S200,建立并存储用以反映BIM模型与各构件之间、以及各构件与各子构件之间对应关系的第二关联关系;S200, establishing and storing a second association relationship for reflecting the corresponding relationship between the BIM model and each component, and between each component and each sub-component;
S300,获取待生成清单编码的BIM模型,基于所述第二关联关系生成并存储所述BIM模型对应的构件信息及子构件信息;S300. Acquire the BIM model coded by the list to be generated, generate and store component information and sub-component information corresponding to the BIM model based on the second association relationship;
S400,基于所述第一关联关系生成所述BIM模型对应的清单编码。S400. Generate a checklist code corresponding to the BIM model based on the first association relationship.
上述步骤S100中,构件包括BIM模型中构件信息及其对应的子构件信息,各个构件分别对应有不同的编码及编码规则,上述构件对应的编码被统一存储形成一规则库,在本申请实施例中,上述规则库基于一数据表格,如EXCEL表格加以存储。In the above step S100, the components include component information in the BIM model and their corresponding sub-component information, and each component corresponds to different codes and coding rules, and the codes corresponding to the above components are uniformly stored to form a rule base. In the embodiment of this application Among them, the above-mentioned rule base is stored based on a data table, such as an EXCEL table.
详述的,上述步骤S100进一步包括:In detail, the above step S100 further includes:
S101,导入并存储各构件的编码规则形成一规则库。上述导入的方式可以通过如下载EXCEL表格模板的形式,对相关数据进行录入。S101. Import and store coding rules of each component to form a rule base. The above import method can be used to input relevant data by downloading the EXCEL form template, for example.
S102,于设定模板中输入构件信息并于所述规则库中查找所述构件信息对应的编码规则。上述设定模板在实际应用中可以配置为如上所述的EXCEL表格模板,也可以配置为其它具有人机交互界面且与所述EXCEL表格具有特定数据链接关系的交互窗口。S102. Input the component information in the setting template and search the coding rule corresponding to the component information in the rule base. In practical applications, the above-mentioned setting template can be configured as the above-mentioned EXCEL form template, and can also be configured as another interactive window with a human-computer interaction interface and a specific data link relationship with the EXCEL form.
S1021,若规则库中存有所述构件信息对应的编码规则,则基于所述编码规则对所述构件信息进行编码并存储;S1021. If the encoding rule corresponding to the component information is stored in the rule base, encode and store the component information based on the encoding rule;
S1022,若规则库中未有所述构件信息对应的编码规则,则提示手动输入维护所述编码规则生成所述构件信息对应的编码并存储。S1022. If there is no encoding rule corresponding to the component information in the rule base, prompt to manually input and maintain the encoding rule to generate and store the encoding corresponding to the component information.
上述步骤S1021与S1022中,待用户输入构件信息后系统自主对上述构件信息加以分析检索,查找规则库,即EXCEL表格中是否既已存有构件信息对应的编码规则,若没有做出提示。In the above steps S1021 and S1022, after the user inputs the component information, the system independently analyzes and retrieves the above component information, searches the rule base, that is, whether there is already a coding rule corresponding to the component information in the EXCEL table, and if not, prompts.
如图2所示,上述步骤S101进一步包括:As shown in Figure 2, the above step S101 further includes:
S1011,将各位编码按照设定规则划分为多个组别。EXCEL表格模板中主要划分为了“项目特征相关属性”、“出量属性”、“辅助属性”等组别,上述组别分别定义了构件不同的属性,用户均可通过插入列,为构件添加新的属性。S1011. Divide the codes of each bit into multiple groups according to the set rules. The EXCEL form template is mainly divided into groups such as "item feature-related attributes", "output attributes", and "auxiliary attributes". The above groups define different attributes of components. Users can add new components to components by inserting columns properties.
S1012,建立各个组别中各个编码与编码之间的关联关系以及各组编码之间的关联关系;其中,所述关联关系包括固定对应关系以及设定的计算公式。例如,本申请实施例中,项目特征相关属性的数据会影响清单编码后三位的属性,表格模板中会根据前九位清单对应构件的项目特征相关属性不同而生成不同的后三位值。出量属性影响构件的工程量,构件工程量会根据公式计算结果显示,如果没公式的话,会根据“出量属性”内的字段内容赋值工程量,如果也没有“出量属性”,则会直接按照个数计算工程量,相应的每个构件工程量赋值为1。S1012. Establish an association relationship between codes in each group and an association relationship between codes in each group; wherein, the association relationship includes a fixed correspondence and a set calculation formula. For example, in the embodiment of this application, the data of the attributes related to the item characteristics will affect the attributes of the last three digits of the list code, and the table template will generate different values of the last three digits according to the different attributes related to the item characteristics of the components corresponding to the first nine digits of the list. The output attribute affects the engineering quantity of the component. The component engineering quantity will be displayed according to the calculation result of the formula. If there is no formula, the engineering quantity will be assigned according to the field content in the "output attribute". If there is no "output attribute", it will be The engineering quantity is directly calculated according to the number, and the corresponding engineering quantity of each component is assigned a value of 1.
S1013,检测设定组别编码及其变化,根据上述关联关系生成清单编码设定位数的编码;S1013, detecting the set group code and its change, and generating the code with the number of set digits of the list code according to the above association relationship;
在本申请实施例中,上述检测设定组别编码及其变化的过程是在完善EXCEL表格模板之后,将EXCEL表格模板导入到系统中,而后由系统自动对比完成。导入成功后,系统会对表格模板前后进行对比,若数据没有变化,则不输出提示,反之则输出提醒。In the embodiment of the present application, the above-mentioned process of detecting and setting group codes and their changes is to import the EXCEL form template into the system after perfecting the EXCEL form template, and then the system automatically compares and completes it. After the import is successful, the system will compare the form template before and after. If there is no change in the data, no prompt will be output, otherwise, a reminder will be output.
为了保证规则库中的编码不会被错误修改,在本申请实施例中,对于规则库的修改引入了权限管理。具体包括:In order to ensure that the codes in the rule base will not be wrongly modified, in the embodiment of the present application, authority management is introduced for the modification of the rule base. Specifically include:
a,设定编码编辑审批权限及数据链接;a. Set code editing approval authority and data link;
b,检测并响应于编码编辑请求,或检测编码变化情况,生成审批请求;b. Detect and respond to coding editing requests, or detect coding changes, and generate approval requests;
c,确认审批结果,若审批确认则固定编码修改内容。c. Confirm the approval result, and if the approval is confirmed, fix the code to modify the content.
上述步骤a中,设定编码编辑审批权限包括表格模板内,允许修改前九位清单编码,修改前九位清单编码并且审批通过后,除了会修改前九位规则库内的前九位清单编码,还会修改后三位规则库内的前九位清单编码,并且维护好的后三位与项目特征描述等信息将会保留不变。In the above step a, setting the code editing and approval authority includes in the form template, allowing the modification of the first nine list codes. After the modification of the first nine list codes and approval is passed, in addition to modifying the first nine list codes in the first nine rule bases , will also modify the first nine list codes in the last three digits rule base, and the maintained information such as the last three digits and project feature description will remain unchanged.
上述步骤b中,当检测到表格模板中的数据发生变化时,自动输出权限审批界面,或将上述权限审批信息发送到相应的用户终端,以此对新增的数据做审批。In the above step b, when it is detected that the data in the form template has changed, the permission approval interface is automatically output, or the above permission approval information is sent to the corresponding user terminal, so as to approve the newly added data.
步骤S100中,所述第一关联关系包括数据表格及其中设定单元格之间基于设定计算公式或映射映射关系,如出量属性中构件工程量则根据公式计算结果显示。In step S100, the first association relationship includes a data table and the setting calculation formula or mapping relationship between the setting cells. For example, the component engineering quantity in the output attribute is displayed according to the calculation result of the formula.
所述规则库中预设有数据检索单元并与一数据交互接口数据连接,基于用户操作进行数据全局搜索。A data retrieval unit is preset in the rule base and is connected to a data interaction interface for data global search based on user operations.
上述步骤S200中,第二关联关系主要为“包含”关系,即将一BIM模型转化为一树形数据结构,各个构件及子构件形成BIM模型本身。In the above step S200, the second association relationship is mainly a "contains" relationship, that is, a BIM model is transformed into a tree data structure, and each component and sub-component forms the BIM model itself.
上述步骤S400中,如图3所示,还包括:In the above step S400, as shown in FIG. 3 , it also includes:
S401,根据BIM模型对应的构件信息及子构件信息生成构件清单;S401, generating a component list according to component information and sub-component information corresponding to the BIM model;
S402,基于上述构件清单查找未被赋予编码的构件信息或子构件信息;S402. Search for component information or sub-component information that has not been coded based on the above component list;
S403,突出显示所述构件信息或子构件信息,调取构件信息或子构件信息对应的编码编辑界面;S403. Highlight the component information or sub-component information, and call the code editing interface corresponding to the component information or sub-component information;
S404,建立上述编码编辑界面与所述规则库之间的数据连接,基于编码编辑界面获取的操作信息于所述规则库中添加所述子构件信息对应的编码规则。S404. Establish a data connection between the coding editing interface and the rule base, and add coding rules corresponding to the sub-component information to the rule base based on the operation information acquired by the coding editing interface.
通过上述技术方案可以在生成清单编码时对BIM模型对应的构件信息或子构件信息进行筛查,避免遗漏。Through the above technical solution, the component information or sub-component information corresponding to the BIM model can be screened when the list code is generated to avoid omission.
当输入一BIM模型进行清单映射时,选择模型并对模型做清单映射,清单映射时会先根据规则库生成对应的清单编码。如果在规则库内没有构件对应的编码规则,则会根据规则库中存有的编码规则对设定位数或组别的编码进行自动生成,而后根据编码位数之间的关联关系生成剩余编码,如首先生成清单前九位,而后生成后三位。如果构件在规则库内找不到对应的编码规则,则会输出提示界面,由用户进行规则库的完善。完善规则库后再次进行模型映射并检查是否存有遗漏,若无,则保存上述清单编码。When inputting a BIM model for checklist mapping, select the model and perform checklist mapping for the model. During checklist mapping, the corresponding checklist code will be generated according to the rule base. If there is no coding rule corresponding to the component in the rule base, the code of the set digit or group will be automatically generated according to the coding rules stored in the rule base, and then the remaining code will be generated according to the relationship between the code digits , such as first generating the first nine digits of the list, and then generating the last three digits. If the component cannot find the corresponding coding rules in the rule base, a prompt interface will be output, and the user can complete the rule base. After perfecting the rule base, perform model mapping again and check whether there are any omissions. If there is no omission, save the above list code.
在特定实施方式中,可于BIM模型的图形化界面中显示出未成功映射的构件,例如,在BIM模型的三维图像中将未成功映射的构件颜色做差异化显示。In a specific implementation, the components that have not been successfully mapped can be displayed on the graphical interface of the BIM model, for example, the colors of the components that have not been successfully mapped can be displayed in a differentiated manner in the three-dimensional image of the BIM model.
本申请方案的优势在于,通过采用特殊的编码映射规则及维护方法实现了为BIM模型中各个构件匹配符合国家标准的清单条目,不仅能够实现组件的自动化操作,提升组价效率,还能够显著提升组价的准确性。The advantage of this application scheme is that, by adopting special coding mapping rules and maintenance methods, it is possible to match each component in the BIM model with a list item that meets the national standard, which can not only realize the automatic operation of components, improve the efficiency of price assembly, but also significantly improve The accuracy of the pricing.
为实现上述方法,本申请还提出了一种基于BIM系统的清单全自动映射系统,如图4所示,主要包括存储单元1、交互单元2以及处理单元3。In order to realize the above method, the present application also proposes a BIM system-based fully automatic inventory mapping system, as shown in FIG. 4 , which mainly includes a
存储单元1配置为用以存储反映构件与编码之间对应关系的第一关联关系、以及用以反映BIM模型与各构件之间、各构件与各子构件之间对应关系的第二关联关系、以及BIM模型对应的构件信息及子构件信息。其中,用于存储编码信息的数据单元格相互之间设定有定值关联关系或基于设定计算公式的关联关系。The
在本申请实施例中,所述存储单元1包括一数据存储表,如EXCEL表,所述第一关联关系包括用于存储构件信息的数据单元格与用于存储编码信息的数据单元格之间的直接映射关系,上述直接映射关系包括数据单元格中数据的直接对应,如A数据单元格中的数据为x,则对应的B数据单元格中数据为y。In the embodiment of the present application, the
所述第二关联关系包括用于存储BIM模型信息的数据单元格与用于存储构件信息或子构件信息数据单元格之间的直接关联或间接关联关系,在本申请实施例中,上述关联关系包括树形关系。The second association relationship includes the direct association or indirect association relationship between the data cell used to store BIM model information and the data cell used to store component information or sub-component information. In the embodiment of this application, the above association relationship Includes tree relationships.
交互单元2包括交互处理器以及交互界面,配置为用于获取用户输入的数据及指令、获取待生成清单编码的BIM模型并输出清单编码及映射过程中的提示信息。The interaction unit 2 includes an interaction processor and an interaction interface, configured to obtain data and instructions input by the user, obtain the BIM model of the list code to be generated, and output the list code and prompt information during the mapping process.
处理单元3配置为与交互单元2及存储单元1数据连接,接收获取待生成清单编码的BIM模型以及用户输入的数据及指令,基于所述第二关联关系生成构件清单,而后根据第一关联关系并基于上述构件清单生成BIM模型对应的清单编码。The processing unit 3 is configured to be data-connected to the interaction unit 2 and the
为了便于对编码规则库中的数据加以维护,所述处理单元3中还配置有规则库维护模块包括有数据查找组件4、编码规则修订组件5、编码映射检查组件6以及映射结果提示组件7。In order to facilitate the maintenance of the data in the coding rule base, the processing unit 3 is also configured with a rule base maintenance module including a data search component 4 , a coding
数据查找组件4配置为接收用户输入的数据并根据第一关联关系于存储单元1中查找对应的编码规则或清单编码。在本申请实施例中,上述数据查找组件4支持数据全局搜索,输入任意搜索内容直接显示搜索结果或跳转至设定的数据存储区域进行显示。The data search component 4 is configured to receive the data input by the user and search the
编码规则修订组件5配置为与存储单元1内的第一关联关系、第二关联关系中特定数据存储区域数据连接,接收并响应于交互单元2输出的数据及指令,对上述特定数据存储区域中的数据加以修改或补充。编码映射检查组件6配置为与处理单元3数据连接,基于处理单元3生成的BIM模型对应的清单编码以及BIM模型对应的构件信息及子构件信息,查找并输出未成功映射的构件信息。映射结果提示组件7配置为与所述交互单元2数据连接,接收并输出未成功映射的构件信息或于BIM模型的三维图像中突出显示未成功映射的构件。The encoding
上述技术方案,用户输入BIM模型信息后系统可以快速的根据设定规则生成国标清单编码,在映射过程中可以对未成功映射的构件信息加以突出显示并提供规则库维护规则及相关交互界面,有助于避免BIM模型清单编码映射不完全,实现了为BIM模型中各个构件匹配符合国家标准的清单条目,不仅能够实现组件的自动化操作,提升组价效率,还能够显著提升组价的准确性。In the above technical solution, after the user enters the BIM model information, the system can quickly generate the national standard list code according to the set rules. During the mapping process, it can highlight the component information that has not been successfully mapped and provide rule base maintenance rules and related interactive interfaces. It helps to avoid incomplete coding and mapping of the BIM model list, and realizes the matching of list items that meet national standards for each component in the BIM model. It can not only realize the automatic operation of components, improve the efficiency of price grouping, but also significantly improve the accuracy of price grouping.
一种计算机可读存储介质,所述可读存储介质加载有用以实现如前所述的基于BIM系统的清单全自动映射方法的计算机程序。A computer-readable storage medium loaded with a computer program for realizing the above-mentioned BIM system-based fully automatic inventory mapping method.
本领域普通技术人员可以理解:实现上述各方法实施例的全部或部分步骤可以通过程序指令相关的硬件来完成。前述的程序可以存储于一计算机可读取存储介质中。该程序在执行时,执行包括上述各方法实施例的步骤;而前述的存储介质包括:ROM、RAM、磁碟或者光盘等各种可以存储程序代码的介质。Those of ordinary skill in the art can understand that all or part of the steps for implementing the above method embodiments can be completed by program instructions and related hardware. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps of the above-mentioned method embodiments; and the aforementioned storage medium includes: ROM, RAM, magnetic disk or optical disk and other various media that can store program codes.
以上所述仅是本发明的优选实施方式,本发明的保护范围并不仅局限于上述实施例,凡属于本发明思路下的技术方案均属于本发明的保护范围。应当指出,对于本技术领域的普通技术人员来说,在不脱离本发明原理前提下的若干改进和润饰,这些改进和润饰也应视为本发明的保护范围。The above descriptions are only preferred implementations of the present invention, and the protection scope of the present invention is not limited to the above-mentioned embodiments, and all technical solutions under the idea of the present invention belong to the protection scope of the present invention. It should be pointed out that for those skilled in the art, some improvements and modifications without departing from the principles of the present invention should also be regarded as the protection scope of the present invention.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211087214.8A CN115391446A (en) | 2022-09-07 | 2022-09-07 | Full-automatic list mapping method and system based on BIM system and readable storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211087214.8A CN115391446A (en) | 2022-09-07 | 2022-09-07 | Full-automatic list mapping method and system based on BIM system and readable storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN115391446A true CN115391446A (en) | 2022-11-25 |
Family
ID=84125095
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211087214.8A Pending CN115391446A (en) | 2022-09-07 | 2022-09-07 | Full-automatic list mapping method and system based on BIM system and readable storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN115391446A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116402480A (en) * | 2023-06-07 | 2023-07-07 | 成都普朗克科技有限公司 | Method and system for outputting inventory based on association rule self-built model |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108920770A (en) * | 2018-06-08 | 2018-11-30 | 上海大学 | Based on the BIM component autocoding of Revit software and the method that is associated with BIM model |
CN110443499A (en) * | 2019-08-05 | 2019-11-12 | 中国电力企业联合会电力建设技术经济咨询中心 | A kind of inventory project amount automatic generation method and system |
CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
-
2022
- 2022-09-07 CN CN202211087214.8A patent/CN115391446A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108920770A (en) * | 2018-06-08 | 2018-11-30 | 上海大学 | Based on the BIM component autocoding of Revit software and the method that is associated with BIM model |
CN110443499A (en) * | 2019-08-05 | 2019-11-12 | 中国电力企业联合会电力建设技术经济咨询中心 | A kind of inventory project amount automatic generation method and system |
CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
Non-Patent Citations (1)
Title |
---|
于鑫, 蒋绮琛, 洪懿昆, 等.: "基于Revit二次开发实现三维装饰算量", 《土木建筑工程信息技术》, vol. 12, no. 5, 15 October 2020 (2020-10-15) * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116402480A (en) * | 2023-06-07 | 2023-07-07 | 成都普朗克科技有限公司 | Method and system for outputting inventory based on association rule self-built model |
CN116402480B (en) * | 2023-06-07 | 2023-09-19 | 成都普朗克科技有限公司 | Method and system for outputting inventory based on association rule self-built model |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN112948427B (en) | Data query method, device, equipment and storage medium | |
CN110543303A (en) | Visual business platform | |
CN111562965A (en) | Page data verification method and device based on decision tree | |
CN113515332B (en) | Data generation method, device, equipment and storage medium | |
CN113722790A (en) | BIM technology-based model engineering quantity statistical method | |
CN116128458B (en) | Intelligent automatic review system for hospital expense card reimbursement | |
CN117372067A (en) | Full life cycle cost programming platform and programming method based on BIM hydraulic engineering | |
CN113868753A (en) | Intelligent metering method and device for building engineering, computing equipment and storage medium | |
CN115391446A (en) | Full-automatic list mapping method and system based on BIM system and readable storage medium | |
CN110968751A (en) | Dynamic display method and device for engineering project capital curve | |
CN118446496B (en) | Digital intelligent construction method, device, medium and product | |
CN114493266A (en) | Intelligent quality control method and system for engineering cost achievement | |
CN111292068B (en) | Contract information auditing method and device, electronic equipment and storage medium | |
CN108920749B (en) | Pipeline two-dimensional and three-dimensional data updating method and device and computer readable storage medium | |
CN113962205B (en) | Method, device, electronic device and storage medium for pasting electronic form content | |
CN118410951A (en) | Main production plan data processing method and device, medium and electronic equipment | |
WO2024065407A1 (en) | Production scheduling method, electronic device and storage medium | |
CN107436928B (en) | Volume and price circulation method of substation engineering | |
CN114677103A (en) | A paperless on-site inventory method, device, equipment and storage medium | |
CN115543969B (en) | Data migration method, device, equipment and medium | |
CN118505390B (en) | Trade analysis report generation method, apparatus, electronic device and storage medium | |
CN115146604B (en) | Method, device, equipment and storage medium for generating interface technical document | |
CN119537801A (en) | Data verification method, device, electronic device and readable storage medium | |
CN118839676A (en) | Data processing method, system, readable storage medium and computer program product | |
CN120047251A (en) | Insurance cost calculation method, system, device and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |