Automatic material identification and matching method and system for three-dimensional model and medium

Abstract

The invention provides an automatic material identification and matching method and system for a three-dimensional model and a medium, and relates to the technical field of material management, and the method comprises the steps: constructing a standardized material database, and extracting and standardizing material attribute information; analyzing first material description information in the three-dimensional software model by utilizing an SQL (Structured Query Language), and matching the first material description information with the material attribute information to obtain a first material matching result; extracting second material description information in the project material document by using VBA programming, and matching the second material description information with the material attribute information to obtain a second material matching result; and data integration is carried out through PowerBI, and a project material state visual billboard is constructed. The technical problems that in the prior art, a unified standardized material database is lacked, material description formats in different sources are inconsistent, expression is not standard, a construction material list cannot be accurately generated, and informatization and intellectualization of project material management are limited are solved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of material management, and in particular to a three-dimensional model-oriented material automatic identification matching method, system and medium. BACKGROUND

[0002] In marine engineering equipment manufacturing projects, the pipeline specialty involves a large number of materials, complex specifications, various materials, and a long procurement cycle, and the management chain spans multiple stages of design, procurement and construction. The description information of such materials often contains multiple attribute items, such as size, wall thickness, pound level, material, standard, etc. The information dimension is extensive and the expression method is not unified, which can easily cause management confusion. However, in the current actual engineering projects, a unified standardized material database has not been formed, and the project participants (design, procurement, construction) still generally rely on experience-based operations and manual form processing in terms of material description, coding method and data management means. This non-standardization and information island phenomenon seriously restricts the connection of material data between various participants. This inefficient and error-prone management mode often causes a chain reaction in actual projects. Once the material identification is incorrect or missed, it will lead to material shortage or repeated procurement at the construction site, thereby affecting the construction progress and increasing the cost, and even causing the project to stall and resource waste. SUMMARY

[0003] The present application provides a three-dimensional model-oriented material automatic identification matching method, system and medium, aiming to solve the technical problems that the prior art lacks a unified standardized material database, the material description formats in different sources are inconsistent and not standardized, cannot accurately generate a construction material list, and limits the informatization and intelligentization of project material management.

[0004] The first aspect of the present application provides a three-dimensional model-oriented material automatic identification matching method, which comprises: constructing a standardized material database, extracting and standardizing material attribute information; using SQL language to parse first material description information in a three-dimensional software model, and matching with the material attribute information to obtain a first material matching result, wherein the three-dimensional software model comprises an E3D / PDMS model; using VBA programming to extract second material description information in a project material document, and matching with the material attribute information to obtain a second material matching result; and using PowerBI to integrate the first material matching result and the second material matching result, and constructing a project material state visual board.

[0005] In a second aspect, the application discloses a three-dimensional model-oriented material automatic identification and matching system, which is used for the three-dimensional model-oriented material automatic identification and matching method, and comprises a material attribute information extraction module, a first matching module, a second matching module, and a visual board generation module.

[0006] In a third aspect, the application discloses a storage medium, which stores a computer program. When the computer program is executed by a processor, the steps of the three-dimensional model-oriented material automatic identification and matching method are implemented.

[0007] The one or more technical solutions provided in the application have at least the following beneficial effects: By constructing a standardized material database, extracting and standardizing material attribute information, and uniformly managing complex and inconsistent material description information, a clear material attribute system is established, the standard description method of each material is determined, and the internal logical consistency and calculability of data are ensured. The material description in the three-dimensional software model has problems such as inconsistent format, chaotic order, and non-standard expression. By using the SQL language rule, the attribute field with logical structure can be effectively cleaned and extracted, and compared with the material attribute information in the standardized material database, the material code of each model component can be quickly matched, and the structured archiving is realized. The field content in the project material document is extracted by using the VBA programming, the efficient acquisition of the drawing material demand and the purchase quantity is realized, and manual processing is not required. The material expression in the drawing and the purchase file is often inconsistent. The VBA can clean and standardize the expression in the extraction process, so that the expression is consistent with the standardized material database in the same format, and the matching is facilitated. The material demand of the model node, the construction quantity of the design drawing, and the procurement data of the purchase order are integrated into the PowerBI platform to construct a complete material use chain. The PowerBI dynamically displays the inventory status, gap situation, and purchase progress of various materials, supports multi-dimensional screening and comparison according to regions, nodes, systems, and the like, improves the management transparency, and visually presents which materials are in short supply and which materials have inventory redundancy, thereby supporting the purchase optimization and the adjustment of the on-site construction sequence, realizing the full-process automation from data collection to analysis and presentation, and providing digital support for the fine management of materials in the whole process of a project.

[0008] The above description is only a summary of the technical solutions of the present application. In order to enable the technical means of the present application to be more clearly understood, and to be implemented according to the content of the specification, and in order to enable the above and other purposes, characteristics and advantages of the present application to be more apparent and easy to understand, the following specific embodiments of the present application are described. BRIEF DESCRIPTION OF DRAWINGS

[0009] Figure 1 A schematic diagram of a three-dimensional model-oriented material automatic identification matching method provided by an embodiment of the present application is provided.

[0010] Figure 2 A schematic diagram of an exemplary model matching result in the three-dimensional model-oriented material automatic identification matching method provided by an embodiment of the present application is provided.

[0011] Figure 3 A schematic diagram of an exemplary material state visualization result in the three-dimensional model-oriented material automatic identification matching method provided by an embodiment of the present application is provided.

[0012] Figure 4 A schematic diagram of a three-dimensional model-oriented material automatic identification matching system structure provided by an embodiment of the present application is provided.

[0013] Explanation of reference signs: material attribute information extraction module 10, first matching module 20, second matching module 30, and visualization board generation module 40. DETAILED DESCRIPTION

[0014] The embodiments of the present application provide a three-dimensional model-oriented material automatic identification matching method, system and medium, which solves the technical problem that the prior art lacks a unified standardized material database, the material description formats in different sources are inconsistent and not standardized, the construction material list cannot be accurately generated, and the informatization and intelligentization of project material management are limited.

[0015] After introducing the basic principles of the present application, various non-limiting embodiments of the present application will be specifically introduced in combination with the drawings of the specification. It should be understood that the specific embodiments described herein are only used to explain the present application and not to limit the present application.

[0016] Embodiment one, as shown in the drawings, the embodiments of the present application provide a three-dimensional model-oriented material automatic identification matching method, the method comprises: Figure 1 Constructing a standardized material database, extracting and standardizing material attribute information. Constructing a standardized material database, extracting and standardizing material attribute information.

[0017] The materials used in the marine engineering project are classified and sorted, and the common material types include pipelines, elbows, tees, flanges, etc. On the basis of material classification, the description attributes of each material are defined, and the main attributes include size, wall thickness, pound level, material, etc. Each attribute has a fixed format description rule, such as size expressed in inches, material using international standard abbreviations, such as CS, SS, DSS, SDSS, etc., and wall thickness and pound level using ASME or ISO standards. To ensure the uniqueness of each material, a unique eight-digit material code is assigned to each standardized material information. This material code not only distinguishes the material type and specification, but also specifies the order of attribute description to ensure the consistency and automatic parsing of the information. The above standardized data is entered into the Access database, and the Access database establishes different data tables according to the material classification, including material type, size, wall thickness, pound level, material, material code, and description semantics. This Access database can be accessed through SQL Server to facilitate automatic calling of SQL language in subsequent use.

[0018] The first material description information in the three-dimensional software model is parsed using SQL language, and is matched with the material attribute information to obtain a first material matching result, wherein the three-dimensional software model includes an E3D / PDMS model.

[0019] In the E3D / PDMS model, each construction node (such as a pipeline or a flange) contains first material description information in character form. The first material description information often has inconsistent formats and chaotic semantics, and may have redundant symbols, non-standard spelling, or chaotic attribute order. In order to parse these chaotic description information, key attribute information in the first material description information is extracted by writing SQL. The SQL rule decomposes the original characters according to the standard semantic order defined in the standardized material database, excludes redundant information, and performs cleaning processing.

[0020] The parsed description field is disassembled into attribute sub-items, and then compared with the material attribute information in the Access database one by one. The matched items return their corresponding material code, standard description, and material classification information as the first material matching result, which is used for subsequent visualization integration and material tracking.

[0021] The second material description information in the project material document is extracted using VBA programming, and is matched with the material attribute information to obtain a second material matching result.

[0022] The project material document includes two-dimensional drawings and procurement material lists. The two-dimensional drawings reflect the material demand in the project design phase, which is derived from the table generated by the drawing software. The procurement material list reflects the material data that has been purchased and is sorted by the procurement department in the form of a table, including material name, specification, quantity, and arrival time. A macro program is written using VBA (Visual Basic for Applications) to automatically read the material table content from the project material document. The VBA script processes each row of data, extracts key fields such as material, specification, and quantity, and performs format standardization processing, including removing spaces, unifying units, and processing character case, to ensure effective comparison with the standardized material database. The extracted fields are compared with the defined material attribute information in the standardized material database to find the corresponding material code and record the matching material quantity and related information as the first material matching result.

[0023] The first material matching result and the second material matching result are integrated by PowerBI to build a project material status visualization board.

[0024] The first material matching result and the second material matching result are imported into PowerBI, which is an enterprise-level data visualization and business intelligence tool that can help users aggregate, process, and visualize data from different sources to support enterprise data analysis and decision-making.

[0025] In PowerBI, a real-time material data comparison list is built by connecting the two types of data by material code and establishing field correspondence. Through field comparison, risk indicators such as material gap (demand greater than procurement), material redundancy (procurement greater than demand), and material arrival delay are obtained. Based on the comparison results, visualization components such as tables, column charts, pie charts, and heat maps are designed to generate a project material status visualization board. Through the project material status visualization board, project managers can view material usage dynamics, procurement progress, and potential problems in real time through the interactive interface, greatly improving the transparency and efficiency of material management.

[0026] Further, in the standardized material database, the material attribute information includes material type, material quality, size, wall thickness, and pound level. The material type at least includes pipeline, elbow, tee, and flange. The material quality at least includes carbon steel, stainless steel, duplex steel, super duplex steel, copper-nickel, CPVC, and glass steel.

[0027] According to the common building components in marine engineering equipment, the material types at least include pipelines, elbows, tees, and flanges, wherein the pipelines are used for medium transportation and are the most basic building units, the elbows are used for changing the direction of the pipelines, the tees are used for connecting three pipelines to realize flow separation or flow combination, and the flanges are used for realizing the flange connection between the pipelines and are often used with bolts. This classification can be extended to four-way pipes, reducers, gaskets and other standard parts or custom components.

[0028] According to the engineering requirements such as corrosion resistance, strength grade, and use environment, the material qualities cover various metals and composite materials, wherein carbon steel (CS) has high strength and low cost and is suitable for conventional environments, stainless steel (SS) has good corrosion resistance and is often used in medium corrosion areas, duplex steel (DSS) and super duplex steel (SDSS) have both strength and corrosion resistance and are suitable for high corrosion and high pressure environments, copper-nickel (CuNi) is often used in seawater piping systems, CPVC (chlorinated polyvinyl chloride) and glass steel (FRP) are suitable for part of non-metal pipeline systems or special corrosion environments.

[0029] The size is mainly in units of nominal diameter (DN) or inch (IN), and ranges from small diameter to large diameter, which affects the flow and interface connection; the wall thickness is represented in the form of SCH40, SCH80, etc., which corresponds to different pressure grades and mechanical strengths; the pound level is mainly suitable for flange components and reflects their pressure-bearing capacity, and exemplary pound levels include CL3000, etc.

[0030] Further, the method comprises: In the standardized material database, a unique material code is defined for each material based on the standardized material description; wherein the material code is an eight-digit character; wherein the material code is used to distinguish different materials; wherein the material code is also used to specify the material description order.

[0031] In the standardized material database, in order to ensure that each material has a unique identifier, a unique material code needs to be generated for each material record, and the material code is generated based on the standardized material description, that is, each attribute item of the material (including material type, material quality, size, wall thickness, and pound level) participates in the composition of the final material code to ensure that it can completely describe a material unit.

[0032] Wherein, the material code adopts a fixed-length eight-digit character, which is concise and efficient, facilitating database storage, query and transmission, and also facilitating on-site identification and report display. For example, the material code can be constructed in the following logical segments: the first two digits represent the material type, such as 10 for pipeline, 20 for elbow, 30 for tee, etc., the middle three digits represent the combination of size, wall thickness, and pound level, the last two digits represent the material quality, and the last digit is a check code or an extension bit for future attribute supplementation.

[0033] Material code plays a core role in distinguishing material entities throughout the system. Specifically, in the comparison between the three-dimensional model and the drawing bill of materials, the same material code represents the same material entity; in the PowerBI material dashboard, data connection is made through the material code to achieve unified summary of modeling quantity, procurement quantity, and usage quantity; in procurement, warehousing, construction, and other links, material code serves as a bridge between material objects and management data. Even if the descriptions of two materials are very close, as long as any attribute is different, the generated material code should also be different to ensure accurate system identification.

[0034] Material code also assumes the function of standardizing the description order, for example, it is specified that material description should be arranged in the order of material type, size, wall thickness, pound level, and material quality. This order is enforced through coding design, and in the extraction and comparison process, matching failure caused by chaotic description order can be avoided.

[0035] Further, the method for utilizing SQL language to parse the first material description information in the three-dimensional software model and matching with the material attribute information to obtain a first material matching result comprises: writing SQL code to define standardized statement rules; based on the standardized statement rules, extracting material description strings of each model node from the E3D / PDMS model; matching the material description strings with the material attribute information to obtain a first material matching result; wherein the first material matching result includes the material usage quantity of each model node.

[0036] The pattern of common material description fields in the model is extracted, and the attribute items corresponding to the keywords such as size (DN50), wall thickness (SCH40), material quality (CS), type (FLANGE), and pound level (300#) are extracted. Through the string processing function in the SQL statement, the original character field is disassembled into multiple attribute segments and stored as temporary fields for subsequent matching. Since the model description may have sequence disorder or omitted fields, multiple judgment logic needs to be established, such as first identifying the size and material quality, and then finding the pipe type and pound level. The standard attribute items in the Access database are introduced into the SQL logic as a lookup table, and the preliminary corresponding matching is achieved through JOIN operation.

[0037] In the E3D / PDMS model, each modeling node (such as a section of pipe, a flange) corresponds to a set of attribute fields, which are contained in the model database, connected to the E3D / PDMS model database, access the component list, select the field containing the material description as the target data source, that is, the first material description information. Using the standardized statement rules defined in SQL, read and cache the first material description information, preprocess the first material description information, such as removing spaces, converting to lowercase, unifying unit expressions (for example, "INCH" to "IN"), etc., and disassemble the first material description information by section into category, material, size, wall thickness, pound level, etc. Field, obtain the material description string, prepare for subsequent matching.

[0038] The disassembled material description string is matched and queried with the material attribute information in the standardized material database, and the material code and standard description information that match successfully are returned. For some fields missing description, the most possible standard material can be identified through fuzzy matching or fault tolerance logic, and the matching confidence is recorded. The matching successful data is taken as the first material matching result, and the structured record table containing the model node number, material code, and standard description is output, such as shown in Figure 2

[0039] In the E3D / PDMS model database, each component record is accompanied by a quantity field indicating the unit quantity of the component. The matching successful node material information is grouped and counted by material code, and the total amount of each type of material used in the entire model is summarized. The first material matching result contains the fields: model node ID, material code, material type, standard description, and material usage quantity, which serves as the basic data source for subsequent visualization analysis.

[0040] Further, the project material document includes two-dimensional drawings and procurement lists.

[0041] Two-dimensional drawings are drawn by engineering design software (such as AutoCAD, MicroStation, etc.), and material lists are generated to list the material types, sizes, quantities, etc. involved in the drawings in table form, which represents the amount of material required in the design phase; procurement lists refer to actual procurement lists compiled by the procurement department according to design requirements, which include procurement material name, specification, quantity, supplier information, purchased quantity, procurement status, expected arrival time, etc. The list is also saved in table form.

[0042] Further, the second material description information in the project material document is extracted using VBA programming, and matched with the material attribute information to obtain the second material matching result, the method comprising: ​The material construction consumption is extracted based on the two-dimensional drawing, and the material procurement quantity is extracted based on the procurement material list; the material construction consumption, the material procurement quantity and material attribute information are matched to obtain a second material matching result.

[0043] In order to automatically process a large number of material documents and avoid manual recognition and transcription errors, automatic extraction and analysis through VBA (Visual Basic for Applications) script is a key technical means. Through VBA, each row of data in the two-dimensional drawing table file is first read, the key fields in each row are identified, and format uniformity processing is performed, including cleaning of size units and material expression to ensure alignment with standard material attribute information, combining the quantities of materials with the same attributes, and generating material construction consumption classified by material attributes. Through VBA, the "material name", "specification", "material", "purchase quantity", "status" and other fields in the procurement material list are read, non-standard writing in the material name is processed to ensure alignment with the standard material attribute information, and records of states such as not yet ordered, canceled purchase, and returned goods are filtered out. The material procurement quantity is counted according to the material attribute dimension as the basis for subsequent comparison.

[0044] The Access database is connected to accurately or fuzzily match the fields of material construction consumption, material procurement quantity and material attribute information to determine the corresponding material code. For each construction consumption item, the material code and required quantity are recorded, and for each purchase item, the material code and purchase quantity are recorded. The two are combined according to the material code as the output of the second material matching result. The second material matching result completely reflects the real status of the project's drawing demand quantity and purchased quantity.

[0045] Further, the data integration of the first material matching result and the second material matching result through PowerBI constructs a project material state visual board, including: Through PowerBI, the material usage quantity of each model node and the material construction consumption and material procurement quantity are dynamically checked to generate a real-time material data comparison list, wherein the real-time material data comparison list identifies material gaps, material redundancies and arrival risks of each model node; the real-time material data comparison list is visually processed to generate the project material state visual board.

[0046] The material usage quantity of each model node (from the first material matching result), the material construction quantity, and the material procurement quantity (from the second material matching result) are imported into PowerBI, and data correlation among the three is established based on unique material codes, so as to realize horizontal docking of data from different sources. Logical expressions are set, for example, material gap equals material usage quantity minus material procurement quantity, material redundancy equals material procurement quantity minus material construction quantity, and arrival risk is generated based on the arrival time and the relationship between the material gap nodes. Through the above comparison logic, a dynamically refreshed real-time material data comparison list is generated, in which each record corresponds to a material code, serving as the core basis for judging the project material state. PowerBI can set an automatic refresh frequency, and synchronize with the Access database in real time, so as to ensure that the real-time material data comparison list reflects the real state of the current project materials.

[0047] Based on the data fields of the real-time material data comparison list, suitable chart components are selected for visual display, for example, table form is used to display the state information of different materials, including gap and redundancy, or a heat map is used to display high-gap areas in the construction area. Further, filters and slicers can be added to support material state filtering according to system modules, professional categories, suppliers, and other conditions. When a certain type of material or a certain area of data is clicked, the usage details and state of the subordinate materials can be displayed. For key materials with large gaps or not yet arrived, color coding (such as red highlight) or icon marking is used to enhance risk identification capability, so as to realize early warning and key tracking. As shown in Figure 3 The project material state visualization board can realize full-process visual monitoring of material supply and demand, dynamically respond to changes in project material state, and provide decision support for procurement scheduling and inventory control.

[0048] Further, the standardized material database is stored in the Access database.

[0049] The standardized material data uses the Access database as a storage platform. The Access database is convenient for local or local area network sharing, suitable for rapid deployment of small and medium-sized project or department-level material management systems, users can directly access through the interactive interface, reducing the use threshold, and the Access database can interoperate with systems such as SQL Server, and also can be linked with PowerBI, realizing automatic updating and synchronous analysis of material data. In summary, the standardized material database not only standardizes the material information expression method, making identification and management have a standard basis, but also realizes a lightweight and efficient storage structure through the Access database, providing stable basic data support for the entire automatic identification system.

[0050] In summary, the automatic material identification and matching method for 3D models provided in this application has the following technical effects: By constructing a standardized materials database, material attribute information is extracted and standardized, unifying the management of complex and inconsistent material descriptions, establishing a clear and concise material attribute system, defining the standard description method for each material, and ensuring the inherent logical consistency and computability of the data. Material descriptions in 3D software models suffer from inconsistent formats, disordered order, and non-standard expressions. Through SQL language rules, logically structured attribute fields can be effectively cleaned and extracted. Comparing these with material attribute information in the standardized materials database allows for rapid matching of material codes for each model component, achieving structured archiving. VBA programming is used to extract field content from project material documents, enabling efficient acquisition of material requirements and procurement quantities for drawings, eliminating the need for manual processing of each item. Material representations in drawings and procurement documents often differ. VBA can clean and standardize these representations during the extraction process, ensuring they align with a standardized materials database for easy matching. By integrating material requirements from model nodes, construction quantities from design drawings, and procurement data from purchase orders into the Power BI platform, a complete material usage chain is constructed. Power BI dynamically displays the inventory status, shortages, and procurement progress of various materials, supporting multi-dimensional filtering and comparison by region, node, and system, enhancing management transparency. Visual results intuitively show which materials are in short supply and which have excess inventory, thus supporting procurement optimization and adjustments to on-site construction sequences. This achieves full-process automation from data collection to analysis and presentation, providing digital support for refined material management throughout the project.

[0051] Example 2, based on the same inventive concept as the automatic material identification and matching method for 3D models in the foregoing examples, such as... Figure 4 As shown in the embodiment of this application, an automatic material identification and matching system for three-dimensional models is provided, the system comprising: The material property information extraction module 10 is used to construct a standardized material database and extract and standardize material property information; the first matching module 20 is used to parse the first material description information in the 3D software model using SQL language and match it with the material property information to obtain the first material matching result, wherein the 3D software model includes an E3D / PDMS model; the second matching module 30 is used to extract the second material description information in the project material document using VBA programming and match it with the material property information to obtain the second material matching result; the visualization dashboard generation module 40 is used to integrate the first material matching result and the second material matching result using Power BI to construct a project material status visualization dashboard.

[0052] Further, the material attribute information in the standardized material database includes material type, material quality, size, wall thickness, and pound level, wherein the material type at least includes pipeline, elbow, tee, and flange, and the material quality at least includes carbon steel, stainless steel, duplex steel, super duplex steel, copper-nickel, CPVC, and glass steel.

[0053] Further, the material attribute information extraction module 10 is configured to perform the following operation steps: In the standardized material database, a unique material code is defined for each material based on the standardized material description, wherein the material code is an eight-digit character, the material code is used to distinguish different materials, and the material code is also used to specify the material description sequence.

[0054] Further, the first matching module 20 is configured to perform the following operation steps: SQL code is written to define a standardized statement rule, the material description string of each model node is extracted from the E3D / PDMS model based on the standardized statement rule, and the material description string is matched with the material attribute information to obtain a first material matching result, wherein the first material matching result includes the material usage quantity of each model node.

[0055] Further, the project material document includes two-dimensional drawings and procurement material lists.

[0056] Further, the second matching module 30 is configured to perform the following operation steps: VBA programming is used to extract the material construction quantity based on the two-dimensional drawings and the material procurement quantity based on the procurement material lists, and the material construction quantity and the material procurement quantity are matched with the material attribute information to obtain a second material matching result.

[0057] Further, the visual board generation module 40 is configured to perform the following operation steps: The material usage quantity of each model node and the material construction quantity and the material procurement quantity are dynamically checked by PowerBI to generate a real-time material data comparison list, wherein the real-time material data comparison list identifies material gaps, material redundancies, and arrival risks of each model node, and the real-time material data comparison list is visually processed to generate the project material state visual board.

[0058] Further, the standardized material database is stored in an Access database.

[0059] Through the foregoing detailed description of the method for automatically identifying and matching materials facing three-dimensional models, those skilled in the art can clearly understand the system for automatically identifying and matching materials facing three-dimensional models in the embodiments. Since the system corresponds to the method disclosed in the embodiments, the system is described relatively simply, and the relevant part can be referred to the description of the method.

[0060] Embodiment three provides a storage medium, which stores a computer program, and the computer program is executed by a processor to implement any step of the method in embodiment one.

[0061] The technical features of the above embodiments can be combined in any manner. To make the description simple, all possible combinations of the technical features in the above embodiments are not described, however, as long as the combinations of the technical features do not exist contradictions, they should be considered as the scope of the disclosure.

[0062] The above description of disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to the embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A material automatic recognition matching method for a three-dimensional model, characterized in that, The method comprises: constructing a standardized material database, extracting and standardizing material attribute information; using SQL language to parse first material description information in a three-dimensional software model, and matching with the material attribute information to obtain a first material matching result, wherein the three-dimensional software model comprises an E3D / PDMS model; using VBA programming to extract second material description information in a project material document, and matching with the material attribute information to obtain a second material matching result; using PowerBI to integrate the first material matching result and the second material matching result, and constructing a project material state visual board.

2. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, In the standardized material database, the material attribute information comprises material type, material quality, size, wall thickness, and pound level, wherein the material type at least comprises pipeline, elbow, tee, and flange, and the material quality at least comprises carbon steel, stainless steel, duplex steel, super duplex steel, copper-nickel, CPVC, and glass steel.

3. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, The method comprises: In the standardized material database, a unique material code is defined for each material based on standardized material description; wherein the material code is an eight-digit character; wherein the material code is used to distinguish different materials; wherein the material code is also used to specify the material description sequence.

4. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, The method of using SQL language to parse first material description information in a three-dimensional software model, and matching with the material attribute information to obtain a first material matching result comprises: writing SQL code to define standardized statement rules; based on the standardized statement rules, extracting material description strings of each model node from the E3D / PDMS model; matching the material description strings with the material attribute information to obtain a first material matching result; wherein the first material matching result comprises the material usage quantity of each model node.

5. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, The project material document comprises two-dimensional drawings and procurement material lists.

6. The three-dimensional model-oriented material automatic recognition matching method according to claim 5, wherein, The method of using VBA programming to extract second material description information in a project material document, and matching with the material attribute information to obtain a second material matching result comprises: using VBA programming to extract material construction usage based on the two-dimensional drawings, and extracting material procurement quantity based on the procurement material lists; matching the material construction usage and the material procurement quantity with the material attribute information to obtain a second material matching result.

7. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, The method of using PowerBI to integrate the first material matching result and the second material matching result, and constructing a project material state visual board comprises: using PowerBI to dynamically check the material usage quantity of each model node, and the material construction usage and the material procurement quantity, and generating a real-time material data comparison list, wherein the real-time material data comparison list identifies material gaps, material redundancies, and arrival risks of each model node; visually processing the real-time material data comparison list to generate the project material state visual board.

8. The three-dimensional model-oriented material automatic recognition matching method according to claim 1, wherein, The standardized material database is stored in an Access database.

9. A material automatic recognition matching system for a three-dimensional model, characterized by, The application discloses a three-dimensional model-oriented material automatic identification matching method and a system thereof. The system comprises a material attribute information extraction module, a first matching module, a second matching module and a visual board generation module. The material attribute information extraction module is used for constructing a standardized material database and extracting and standardizing material attribute information. The first matching module is used for parsing first material description information in a three-dimensional software model by using an SQL language and matching the first material description information with the material attribute information to obtain a first material matching result. The second matching module is used for extracting second material description information in a project material document by using VBA programming and matching the second material description information with the material attribute information to obtain a second material matching result.

10. A storage medium having stored thereon a computer program, characterized in that The visual board generation module is used for integrating data of the first material matching result and the second material matching result by using PowerBI and constructing a project material state visual board. The computer program is executed by a processor to realize the steps of the three-dimensional model-oriented material automatic identification matching method in any one of claims 1 to 8.

Images