A rapid design tool and its use in process piping and instrumentation diagrams

By leveraging the data interaction, intelligent positioning, and Excel integration modules of the rapid design tool, the cumbersome problem of synchronizing drawing and data in the design of process piping and instrumentation diagrams has been solved. This has enabled efficient synchronization and consistency of graphics and data, improving design efficiency and reducing learning costs.

CN122333752APending Publication Date: 2026-07-03ZHEJIANG YOUSHAN NEW ENERGY TECHNOLOGY CO LTD +1

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
ZHEJIANG YOUSHAN NEW ENERGY TECHNOLOGY CO LTD
Filing Date
2026-04-03
Publication Date
2026-07-03

AI Technical Summary

Technical Problem

Existing process piping and instrumentation diagram design tools suffer from cumbersome and error-prone synchronization of drawing and data, and difficulty in ensuring consistency. Furthermore, existing intelligent systems are costly to implement, difficult to learn, and lack efficient two-way intelligent interaction capabilities between graphics and data, resulting in low design efficiency.

Method used

This invention provides a rapid design tool, including a data interaction module, an intelligent positioning module, and an Excel integration module, enabling two-way intelligent interaction between drawing data and external data. The intelligent positioning module highlights elements in the drawing, while the Excel integration module automatically generates device tag numbers and merges data tables. It utilizes a memory index table to achieve second-level positioning and data synchronization.

Benefits of technology

It significantly improves the design and maintenance efficiency of process piping and instrumentation diagrams, ensures consistency between data sources and graphics, simplifies the search for massive amounts of elements, reduces learning costs, and enables the widespread application of advanced functions in small and medium-sized design units.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122333752A_ABST
    Figure CN122333752A_ABST
Patent Text Reader

Abstract

This invention discloses a rapid design tool and its application in process piping and instrumentation diagrams, relating to the field of engineering drawing technology. It includes: a data interaction module for exchanging data between drawing files loaded in the CAD platform and external data files, enabling the export of drawing data and / or drawing updates based on external data; an intelligent positioning module connected to the data interaction module for locating and highlighting corresponding graphic elements in the drawing file based on user-input search criteria; and an Excel integration module connected to the data interaction module for processing Excel data files associated with the drawing file, performing automatic generation of equipment tag numbers and / or merging of data from multiple tables. In summary, the advantages of this invention are: by integrating a lightweight plugin into a mature CAD platform, it achieves bidirectional intelligent interaction and efficient synchronization between drawing data and external table data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of engineering drawing technology, specifically to a rapid design tool and its application in process piping and instrumentation diagrams. Background Technology

[0002] A process piping and instrumentation diagram (PIP) is a technical document that uses standardized graphic symbols and text codes to systematically depict all the equipment, instruments, piping, valves, and major fittings required for a chemical process unit. Its purpose is to clearly describe the structure and function of the entire process unit by combining all components according to their functions based on process and safety requirements.

[0003] In existing technologies, process piping and instrumentation diagram (P&ID) design mainly faces the following efficiency bottlenecks: traditional workflows rely on manual operation using basic CAD software, making drawing and attribute annotation cumbersome. Furthermore, after drawing modifications, related data statistics tables require manual synchronization, which is prone to errors and inconsistent. While integrated intelligent P&ID systems exist, their complex architecture and high implementation and learning costs make them difficult to adopt in small and medium-sized design firms. Existing tools generally lack efficient two-way intelligent interaction capabilities between graphics and data, resulting in low efficiency in data extraction, reverse updating, and rapid retrieval and location of massive amounts of components from existing drawings, severely impacting the design and management efficiency of large projects. Therefore, there is an urgent need for a lightweight, flexible, and highly efficient tool that can be deeply integrated into the existing design environment. Summary of the Invention

[0004] To address the aforementioned technical problems, this technical solution provides a rapid design tool and its application in process piping and instrumentation diagrams. This solution resolves at least one of the technical problems mentioned in the background section.

[0005] To achieve the above objectives, the technical solution adopted by the present invention is as follows: A rapid design tool, comprising: The data interaction module is used to exchange data between the drawing files loaded in the CAD platform and external data files, so as to realize the export of drawing data and / or the updating of drawings based on external data. The intelligent positioning module, connected to the data interaction module, is used to locate and highlight the corresponding graphic elements in the drawing file based on the search conditions input by the user. The Excel integration module is connected to the data interaction module and is used to process Excel data files associated with the drawing file, and to perform automatic generation of equipment tag numbers and / or merging of data from multiple tables.

[0006] Preferably, the data interaction module specifically includes: The export unit is used to traverse the model space of the current drawing in the CAD platform, identify and extract the attribute data of graphic elements of a preset type, and generate a structured first external data file. The import unit is used to parse the second external data file provided by the user, read the updated data, match the updated data with the attributes of the corresponding graphic elements in the drawing, and modify them in batches. The second external data file has the same attribute format as the first external data file.

[0007] Preferably, when the tool is started, the intelligent positioning module pre-constructs a memory index table containing the correspondence between the attribute values ​​of graphic elements in the drawing file and the identifiers of internal CAD objects; The intelligent positioning module includes a tag number positioning unit, which responds to a specific device tag number input by the user, directly obtains the corresponding internal object identifier by querying the memory index table, and controls the CAD platform to highlight the graphic element.

[0008] Preferably, the intelligent positioning module further includes: The fuzzy positioning unit is used to respond to at least one keyword input by the user, perform fuzzy matching on multiple attribute values ​​of graphic elements in the drawing, locate and highlight all matching graphic elements; The batch positioning unit is used to read a list file containing multiple search conditions and automatically call the logic of the position number positioning unit or the fuzzy positioning unit in a loop to achieve the high-highlight positioning of batch graphic elements.

[0009] Preferably, the Excel integration module includes: The tag number generation unit is used to call the Excel application interface to automatically generate the device tag number in the Excel file and perform uniqueness verification according to the preset industry coding standards. The table merging unit is used to read multiple device data table files, merge the data, remove duplicates, and generate a project-level device statistics summary table.

[0010] Compared with the prior art, the beneficial effects of the present invention are as follows: The rapid design tool provided by this invention, by integrating a lightweight plug-in into a mature CAD platform, achieves bidirectional intelligent interaction and efficient synchronization between drawing data and external table data, significantly improving the design and maintenance efficiency of process piping and instrumentation diagrams. Through automatic extraction and reverse updating of drawing data, it overcomes the drawbacks of traditional one-way processing, ensuring a high degree of consistency between the data source and the graphics. Its retrieval mechanism based on intelligent recognition and memory indexing achieves second-level location of massive drawing elements, freeing designers from tedious manual searching. Simultaneously, the tool is not dependent on specific drawing libraries, can flexibly handle standard and non-standard components, and its low-cost, low-learning-curve plug-in format enables the widespread application of advanced intelligent auxiliary functions in a wide range of small and medium-sized design units, possessing significant practical value and promotional significance. Attached Figure Description

[0011] Figure 1 This is a block diagram of a rapid design tool architecture proposed in Embodiment 1 of this solution; Figure 2 This is a diagram showing the deployment and application interface of a rapid design tool proposed in Embodiment 1 of this solution; Figure 3 This is a block diagram of the data interaction module architecture proposed in Embodiment 2 of this solution; Figure 4 This is a block diagram of the intelligent positioning module architecture proposed in Embodiment 3 of this solution; Figure 5 This is a block diagram of the Excel integration module architecture proposed in Embodiment 4 of this solution. Detailed Implementation

[0012] The following description is intended to disclose the invention and enable those skilled in the art to implement it. The preferred embodiments described below are merely examples, and other obvious variations will occur to those skilled in the art.

[0013] Example 1 Reference Figure 1 As shown, this embodiment proposes a rapid design tool, including: The data interaction module is used to exchange data between the drawing files loaded in the CAD platform and external data files, so as to realize the export of drawing data and / or the updating of drawings based on external data. The intelligent positioning module, connected to the data interaction module, is used to locate and highlight the corresponding graphic elements in the drawing file based on the search conditions input by the user. The Excel integration module is connected to the data interaction module and is used to process Excel data files associated with the drawing file, and to perform automatic generation of equipment tag numbers and / or merging of data from multiple tables.

[0014] Its actual deployment application interface is as follows Figure 2 As shown, the toolbar is integrated into the AutoCAD interface in an intuitive toolbar format, and users can trigger functions by clicking the corresponding buttons. The toolbar mainly includes the following functional areas: Data interaction area: includes "Register", "Export Data", and "Import Data"; Intelligent positioning area: including "cloud line positioning", "tag number positioning", "Any positioning", "batch tag number positioning", and "batch Any positioning"; Excel Integration Area: Includes "ExcelPidTools" and "Excel Merge"; Auxiliary information area: includes "Plugin Description" and "About Us".

[0015] The interface design is simple and conforms to the usage habits of engineers. The functions are clearly categorized, which greatly improves the efficiency of operation.

[0016] The following simulated design example illustrates the practical applications of this tool and its use in the design process: There is a process piping and instrumentation diagram design for a methanol synthesis section. In the initial design phase, the engineer loads this rapid design tool plugin. A dedicated toolbar appears on the interface. He first clicks the "ExcelPidTools" button, which opens an Excel file and a preset template. The engineer enters a list of the main equipment for this section, along with its type and the corresponding process step. Based on preset industry coding standards, the tool automatically generates a unique and correctly formatted tag number for each piece of equipment and performs uniqueness verification, avoiding errors and duplications that might occur with manual coding. During the design process, engineers use the tool's library or basic AutoCAD commands to draw equipment symbols with correct tag numbers onto the drawings. After drawing, they click the "Export Data" button on the toolbar. The tool then traverses the drawing model space, identifies all equipment block references, and extracts their tag numbers, model numbers, and other attribute data, automatically generating a structured equipment table Excel file, completing the initial synchronization from graphics to data. After client review, the client requested updates to some equipment parameters. The project manager directly modified the model number of heat exchanger E-1001 and certain specifications of reactor R-1001 in the equipment table Excel file exported by the engineer. After receiving the updated Excel file, the engineer clicked the "Import Data" button in the drawing and selected the file. The tool parsed the Excel file, read the changed information, and then automatically matched the equipment graphic elements with end numbers "E-1001" and "R-1001" in the drawing, and batch modified their corresponding attribute values, completing the reverse update of the drawing data and ensuring the consistency between the drawing and the data source. During an internal review meeting, reviewers inquired about the details of the inlet piping for reactor R-1001. Given the numerous devices on the drawings, the engineer entered "R-1001" into the tool's "Smart Location" search box and clicked "Tag Location." Using its pre-built memory index table, the tool immediately located the reactor on the drawing and highlighted it. Another reviewer wanted to view all "Pressure Gauges," so the engineer entered "P" or "Pressure" for "Any Location." The tool, through fuzzy matching, instantly highlighted all gauges on the drawing whose tag numbers contained "P" or whose names contained "Pressure." As the project design neared completion, a comprehensive equipment inventory was required. The engineer collected equipment lists in Excel format from colleagues in the piping and instrumentation fields. Using the tool's "Excel Merge" function, he selected the files, clicked the operation, and the tool automatically merged the data and removed duplicates, generating a complete "Project Equipment Procurement List Summary," which was directly used in subsequent procurement and budgeting processes.

[0017] Example 2 This embodiment further optimizes the design of the data interaction module based on Embodiment 1, referring to... Figure 3 As shown, the data interaction module specifically includes: The export unit is used to traverse the model space of the current drawing in the CAD platform, identify and extract the attribute data of graphic elements of a preset type, and generate a structured first external data file. The import unit is used to parse the second external data file provided by the user, read the updated data, match the updated data with the attributes of the corresponding graphic elements in the drawing, and modify them in batches. The second external data file has the same attribute format as the first external data file.

[0018] The process of identifying and extracting attribute data of graphic elements of a preset type to generate a structured first external data file specifically includes: Using C# code, the AutoCAD.NET API is called to obtain the database object of the currently active document. This database object is the root entry point for the program to access all data in the drawing. Access the model space that stores the main graphical elements through the database object; Using a transaction mechanism, all primitives in the model space are traversed. Primitives are the basic units of CAD graphics, including lines, circles, text, and block references. Block reference types are identified and filtered out. In process piping and instrumentation diagrams, equipment and instruments are usually inserted in the form of blocks. Block references are instances of these equipment and instruments in the drawings. For each identified block reference type primitive, its contained attribute reference set is further accessed. The elements in the attribute reference set include device tag number, model, specifications, and description. Read the attribute tags and their corresponding values ​​from the attribute reference set of each block reference type primitive one by one, and temporarily store them in memory in a structured manner; After all the attribute data of the target graphic elements have been extracted, the program uses the third-party library EPPlus to dynamically write the structured data in memory and generate a standard first external data file. The generated first external data file will organize the data with clear columns, such as "location", "model", "specification" etc., and rows, with one record for each device, and save it to the local path specified by the user.

[0019] The data flow in this implementation process is clear, as described in the document: DWG drawing data → data structure in memory → local Excel file.

[0020] In summary, the core of this step is to use the AutoCAD.NET API programming interface to traverse, filter, and parse the drawing database layer by layer, ultimately extracting the attribute text information embedded in the drawing blocks and converting it into a common tabular data format.

[0021] The process of parsing the second external data file provided by the user, reading the updated data, matching the updated data with the attributes of the corresponding graphic elements in the drawing, and batch modifying the data specifically includes: Receive the path to a second external data file specified by the user, open and parse the second external data file; Read the worksheets and columns in a preset format from the second external data file, convert each row of data into a structured object in memory, and form an updated data set; Using the AutoCAD.NET API, start a transaction, traverse the graphic elements in the current drawing model space, and lock the block reference type primitives; For each target block reference in the drawing, the program extracts its key attribute values; Then, the reference number of the target block in the drawing is used as the key to perform a query and match in the updated data set; Once a match is found, the target block is marked as a primitive object that needs to be updated, and primitives that are not matched are skipped. Establish a temporary mapping relationship to associate the primitive object that needs to be updated with the corresponding new attribute value in the updated data set; For all successfully matched primitives, access their set of attributes; For each attribute that needs to be updated, write the corresponding new value from the updated data set into the attribute of the graphic element; Commit the transaction to save all attribute changes to the current DWG drawing file.

[0022] The complete data flow for this process is as follows: Excel file → updated data set in memory → attribute value of the corresponding element in the DWG drawing.

[0023] This function is essentially the reverse process of exporting data. The key technology lies in using external data to drive the process, matching through unique identifiers, and relying on the CAD API for programmatic and batch attribute refresh, thereby achieving bidirectional synchronization and efficient updates between drawings and data sources.

[0024] The following section, using the simulation example from Example 1, details the design concept of the process piping and instrumentation flow diagram for the methanol synthesis section: When the engineer clicks the "Export Data" button, the system automatically traverses the model space of the current drawing based on the above design, and identifies all "block reference" type elements, namely devices such as P-101A, P-101B, and E-102. For each device block, the system accesses its attribute reference set, reads attribute tags such as "TAG", "MODEL", and "SPEC" and their corresponding values, and temporarily stores these data in memory in a structured manner, such as: TAG:P-101A, MODEL:IH50-32-160, SPEC:Q=10m³ / hH=32m, forming a device data list; Using the EPPlus library, the structured data list in memory is written to a new Excel file. This file automatically generates column headers such as "Tag Number", "Model Number", and "Specification", and fills in the data for each device as a row. This completes the unidirectional data flow of "DWG drawing data → data structure in memory → local Excel file". After clicking the "Import Data" button and selecting the modified Excel file, the engineer parsed the file, read all rows of data, and found that the "Model" value in row E-102 had changed. This change was then created as an updated data set in memory. The engineer then iterated through all block references in the drawing, extracting the "Tag Number" attribute for each block. When the engineer reached block reference E-102, using its tag number "E-102" as the key, a match was successfully found in the updated data set. After establishing the mapping, the system accessed the attribute set of block reference E-102, found the "Model" attribute marker, and modified its value. This modification was completed within a transaction. After the transaction was committed, the graphic attributes in the drawing were immediately updated. This completed the reverse data flow: "Excel file → updated data set in memory → attribute value of corresponding element in DWG drawing." The drawing and data source were now synchronized.

[0025] Example 3 This embodiment, based on Embodiment 1 or Embodiment 2, further optimizes the design of the intelligent positioning module, referring to... Figure 4 As shown, the intelligent positioning module includes: The tag number positioning unit is used to respond to a specific device tag number input by the user, directly obtain the corresponding internal object identifier by querying the memory index table, and control the CAD platform to highlight the graphic element. The fuzzy positioning unit is used to respond to at least one keyword input by the user, perform fuzzy matching on multiple attribute values ​​of graphic elements in the drawing, locate and highlight all matching graphic elements; The batch positioning unit is used to read a list file containing multiple search conditions and automatically call the logic of the position number positioning unit or the fuzzy positioning unit in a loop to achieve the high-highlight positioning of batch graphic elements.

[0026] When the tool starts, the intelligent positioning module pre-builds a memory index table containing the correspondence between the attribute values ​​of graphic elements in the drawing file and the identifiers of internal CAD objects. The specific steps are as follows: Obtain the database object of the current drawing file using the AutoCAD.NET API; Access the model space that stores the main graphical elements through the database object; Using a transaction mechanism, all primitives in the model space are traversed. These primitives are the basic units of CAD graphics, including lines, circles, text, and block references. Block reference types are identified and filtered out with particular emphasis. For each identified block reference type primitive, its contained attribute references are further accessed, and the device tag number and its corresponding value are extracted. Initialize a hash table object in memory, and add the device bit number and corresponding value of all block reference type primitives as data pairs to this hash table; When a transaction is closed, the hash table is a memory index table that contains the tag numbers of all block reference type primitives in the current drawing and their corresponding internal object identifiers.

[0027] The module pre-builds an in-memory index table (hash table) at startup, which is a key performance optimization strategy. It maps and caches the attributes (such as device tag numbers) of all key graphic elements (block references) in the drawing to their unique object identifiers (ObjectId) within the CAD system through a one-time initialization traversal. This eliminates the need to rescan the drawing for any subsequent "tag number location" queries; instead, the value (ObjectId) is retrieved directly from the hash table in memory via the key (tag number), achieving instant location with a time complexity of O(1). This fundamentally solves the problem of time-consuming and laborious manual searching in massive element drawings. Based on the high-speed index mentioned above, the module provides three progressive retrieval methods: Precise retrieval of corresponding location units: Directly utilizing hash tables for precise key-value matching, achieving "second-level" location of a single specific device. This is the fastest and most crucial retrieval method.

[0028] Fuzzy search corresponds to the fuzzy positioning unit: when a user cannot remember the complete tag number or needs to search by category, such as entering "pump", this unit uses techniques such as LINQ to perform fuzzy matching on multiple attribute values ​​of graphic elements. Although this usually requires traversing and filtering elements that meet the conditions, its search scope is the attribute dataset already loaded into memory, which is far more efficient than native traversal in the graphics database.

[0029] Batch retrieval corresponds to the batch positioning unit: This unit batches the first two capabilities. By reading an external search list file and invoking precise or fuzzy positioning logic, multiple targets are highlighted at once. It optimizes workflows for scenarios such as list-based drawing review and material statistics.

[0030] The three units are not isolated but work collaboratively. Both the fuzzy positioning unit and the batch positioning unit may internally call the core query logic of the tag number positioning unit. The data flow of the entire module begins with the "drawing traversal and hash table construction" at tool startup. Subsequently, all interactive queries by the user are based on this memory index and are finally highlighted in the view controlled by the CADAPI, forming a closed loop of "initialization construction - interactive query - graphical feedback".

[0031] Example 4 This embodiment, based on Embodiment 1, Embodiment 2, or Embodiment 3, further optimizes the design of the Excel integration module, referring to... Figure 5 As shown, the Excel integration module includes: The tag number generation unit is used to call the Excel application interface to automatically generate the device tag number in the Excel file and perform uniqueness verification according to the preset industry coding standards. The table merging unit is used to read multiple device data table files, merge the data, remove duplicates, and generate a project-level device statistics summary table.

[0032] The step of calling the Excel application programming interface to automatically generate the device tag number in the Excel file and perform uniqueness verification according to the preset industry coding standards specifically includes: Based on a preset coding standard, the equipment tag number is assigned to the generation rule logic. For example, in some preferred embodiments, the preset industry coding standard, such as the chemical industry standard HG / T 20519, is converted into program logic. For example, the rule may be defined as: [Equipment type code] + [Process number] + [Serial number]. According to the "equipment type" data, such as "pump" and "tower", it is mapped to a fixed letter code, such as "P" for pump and "T" for tower; the "process" data is directly read, such as 100; and a sequence number is generated for equipment of the same type and process, such as 01 and 02. Iterate through the existing device tag number column, extract all used tag numbers, and store them in a hash set; The program iterates through all devices that need to generate bit numbers, extracts the device's attributes, and generates a bit number based on the device's attributes and the generation rules. This bit number is then compared with a bit number already used in the hash set. If no duplicates are found, the bit number is usable, assigned to the current device, and added to the hash set. If a duplicate is found, the program continues generating a new bit number according to the device bit number generation rules and compares it with a bit number already used in the hash set. Specifically, based on the device type and process in the current row, a prefix for the bit number is generated (e.g., P-100). Starting from sequence number "01", a complete bit number is generated (e.g., P-10001). This complete bit number is compared with the "already sequenced hash set" established in the previous step. If no duplicates are found, the bit number is usable, assigned to the current row, and added to the hash set to ensure that subsequent rows will not repeat the same bit number. If a duplicate is found, the sequence number is incremented (e.g., P-10002), and the verification is repeated until a unique bit number is found.

[0033] Industry standards are translated into algorithmic logic, and a hash set in memory is used for duplicate checking, thereby completing coding work efficiently, accurately, and in batches. This fundamentally avoids format inconsistencies and duplication errors that may occur with manual coding. The entire process is data-driven, with basic data such as equipment type and process as input, and standardized equipment tag numbers that conform to the specifications and are unique as output.

[0034] In summary, the advantages of this invention are as follows: By integrating a lightweight plug-in into a mature CAD platform, it achieves bidirectional intelligent interaction and efficient synchronization between drawing data and external table data, significantly improving the design and maintenance efficiency of process piping and instrumentation diagrams. Through automatic extraction and reverse updating of drawing data, it overcomes the drawbacks of traditional one-way processing, ensuring a high degree of consistency between the data source and the graphics. Its retrieval mechanism based on intelligent recognition and memory indexing achieves second-level positioning of massive drawing elements, freeing designers from tedious manual searching. Simultaneously, the tool is not dependent on specific drawing libraries, can flexibly handle standard and non-standard components, and its low-cost, low-learning-curve plug-in format enables the widespread application of advanced intelligent auxiliary functions in a wide range of small and medium-sized design units, possessing significant practical value and promotional significance.

[0035] The foregoing has shown and described the basic principles, main features, and advantages of the present invention. Those skilled in the art should understand that the present invention is not limited to the above embodiments. The embodiments and descriptions in the specification are merely principles of the invention. Various changes and modifications can be made to the invention without departing from its spirit and scope, and all such changes and modifications fall within the scope of the claimed invention. The scope of protection claimed by the appended claims and their equivalents is defined.

Claims

1. A rapid design tool, characterized in that, include: The data interaction module is used to exchange data between the drawing files loaded in the CAD platform and external data files, so as to realize the export of drawing data and / or the updating of drawings based on external data. The intelligent positioning module, connected to the data interaction module, is used to locate and highlight the corresponding graphic elements in the drawing file based on the search conditions input by the user. The Excel integration module is connected to the data interaction module and is used to process Excel data files associated with the drawing file, and to perform automatic generation of equipment tag numbers and / or merging of data from multiple tables.

2. The rapid design tool according to claim 1, characterized in that, The data interaction module specifically includes: The export unit is used to traverse the model space of the current drawing in the CAD platform, identify and extract the attribute data of graphic elements of a preset type, and generate a structured first external data file. The import unit is used to parse the second external data file provided by the user, read the updated data, match the updated data with the attributes of the corresponding graphic elements in the drawing, and modify them in batches. The second external data file has the same attribute format as the first external data file.

3. A rapid design tool according to claim 2, characterized in that, The process of identifying and extracting attribute data of graphic elements of a preset type to generate a structured first external data file specifically includes: Using C# code, the AutoCAD.NET API is called to obtain the database object of the currently active document. This database object is the root entry point for the program to access all data in the drawing. Access the model space that stores the main graphical elements through the database object; Using a transaction mechanism, all primitives in the model space are traversed. These primitives are the basic units of CAD graphics, including lines, circles, text, and block references. Block reference types are identified and filtered out with particular emphasis. For each identified block reference type primitive, its contained attribute reference set is further accessed. The elements in the attribute reference set include device tag number, model, specifications, and description. Read the attribute tags and their corresponding values ​​from the attribute reference set of each block reference type primitive one by one, and temporarily store them in memory in a structured manner; After all the attribute data of the target graphic elements has been extracted, the program uses the third-party library EPPlus to dynamically write the structured data in memory and generate a standard first external data file.

4. A rapid design tool according to claim 3, characterized in that, The process of parsing the second external data file provided by the user, reading the updated data, matching the updated data with the attributes of the corresponding graphic elements in the drawing, and batch modifying the data specifically includes: Receive the path to a second external data file specified by the user, open and parse the second external data file; Read the worksheets and columns in a preset format from the second external data file, convert each row of data into a structured object in memory, and form an updated data set; Using the AutoCAD.NET API, start a transaction, traverse the graphic elements in the current drawing model space, and lock the block reference type primitives; For each target block reference in the drawing, the program extracts its key attribute values; Then, the reference number of the target block in the drawing is used as the key to perform a query and match in the updated data set; Once a match is found, the target block is marked as a primitive object that needs to be updated, and primitives that are not matched are skipped. Establish a temporary mapping relationship to associate the primitive object that needs to be updated with the corresponding new attribute value in the updated data set; For all successfully matched primitives, access their set of attributes; For each attribute that needs to be updated, write the corresponding new value from the updated data set into the attribute of the graphic element; Commit the transaction to save all attribute changes to the current DWG drawing file.

5. A rapid design tool according to claim 1, characterized in that, When the tool is started, the intelligent positioning module pre-builds a memory index table containing the correspondence between the attribute values ​​of graphic elements in the drawing file and the identifiers of internal CAD objects. The intelligent positioning module includes a tag number positioning unit, which responds to a specific device tag number input by the user, directly obtains the corresponding internal object identifier by querying the memory index table, and controls the CAD platform to highlight the graphic element.

6. A rapid design tool according to claim 5, characterized in that, The intelligent positioning module also includes: The fuzzy positioning unit is used to respond to at least one keyword input by the user, perform fuzzy matching on multiple attribute values ​​of graphic elements in the drawing, locate and highlight all matching graphic elements; The batch positioning unit is used to read a list file containing multiple search conditions and automatically call the logic of the position number positioning unit or the fuzzy positioning unit in a loop to achieve the high-highlight positioning of batch graphic elements.

7. A rapid design tool according to claim 6, characterized in that, The pre-built memory index table containing the correspondence between attribute values ​​of graphic elements in the drawing file and CAD internal object identifiers specifically includes: Obtain the database object of the current drawing file using the AutoCAD.NET API; Access the model space that stores the main graphical elements through the database object; Using a transaction mechanism, all primitives in the model space are traversed. These primitives are the basic units of CAD graphics, including lines, circles, text, and block references. Block reference types are identified and filtered out with particular emphasis. For each identified block reference type primitive, its contained attribute references are further accessed, and the device tag number and its corresponding value are extracted. Initialize a hash table object in memory, and add the device bit number and corresponding value of all block reference type primitives as data pairs to this hash table; When a transaction is closed, the hash table is a memory index table that contains the tag numbers of all block reference type primitives in the current drawing and their corresponding internal object identifiers.

8. A rapid design tool according to claim 1, characterized in that, The Excel integration module includes: The tag number generation unit is used to call the Excel application interface to automatically generate the device tag number in the Excel file and perform uniqueness verification according to the preset industry coding standards. The table merging unit is used to read multiple device data table files, merge the data, remove duplicates, and generate a project-level device statistics summary table.

9. A rapid design tool according to claim 8, characterized in that, The step of calling the Excel application programming interface to automatically generate the device tag number in the Excel file and perform uniqueness verification according to the preset industry coding standards specifically includes: The device tag number is assigned to the generation rule logic based on the preset coding specification; Iterate through the existing device tag number column, extract all used tag numbers, and store them in a hash set; The program iterates through all devices that need to generate bit numbers, extracts the attributes of the device, and generates a bit number based on the generation rule logic of the device bit number based on the device attributes. It then compares the generated bit number with the bit number already used in the hash set. If there is no duplicate, the bit number is available and is assigned to the current device. The device is also added to the hash set. If there is a duplicate, the program continues to generate a new bit number according to the generation rule logic of the device bit number and compares it with the bit number already used in the hash set.

10. The application of the rapid design tool as described in any one of claims 1-9 in the design of process piping and instrumentation diagrams.