CN107193906B - Method and device for generating process pipeline instrument diagram bill of materials - Google Patents
Method and device for generating process pipeline instrument diagram bill of materials Download PDFInfo
- Publication number
- CN107193906B CN107193906B CN201710330568.3A CN201710330568A CN107193906B CN 107193906 B CN107193906 B CN 107193906B CN 201710330568 A CN201710330568 A CN 201710330568A CN 107193906 B CN107193906 B CN 107193906B
- Authority
- CN
- China
- Prior art keywords
- graphic
- block
- parameter data
- data
- information storage
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
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/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for generating a process pipeline instrument diagram bill of materials, wherein the method comprises the following steps: receiving an instruction that a graphic block in a process pipeline instrument diagram is selected; reading a material identifier in the graphic block; searching material category data corresponding to the material identification in a material database; selecting material parameter data corresponding to the graphic block from the material category data; transmitting the selected material parameter data to a graphic block data information storage block; storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block; extracting material parameter data stored in a data information storage block corresponding to a part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, summarizing the extracted material parameter data and forming a table; and outputting the table. The invention can automatically summarize the material forming list in the process pipeline instrument diagram and can output the list in a table form.
Description
Technical Field
The invention relates to the field of AUTOCAD plug-ins, in particular to a method and a device for generating a process pipeline instrument diagram bill of materials.
Background
AutoCAD is the most widely used computer aided design software in the world at present, and is widely applied to various enterprises and design houses in China. The AutoCAD function is rich, can easily realize various drawing and information storage functions, but is a general software after all, and the special functions required by each enterprise are not refined. In order to facilitate the user to customize the function, the AutoCAD comprehensively opens an internal management API, so that the API can be fully developed according to the requirements of enterprises or industries to meet the requirements of specific industries or use functions. After drawing the pipeline trend process pipeline instrument diagram, designers need to count the quantity of pipelines and pipe fittings manually in order to give a construction material list, and after the quantity is added, the information of names, specifications, quantity, materials and the like of materials is input in an AutoCAD or EXCEL table so as to facilitate construction. In an enterprise with ERP management, designers need to input ERP numbers into a list by referring to an ERP material table so as to enter an ERP system for purchase. Because the variety of pipelines, especially pipe fittings is various, not only time and labor are wasted, but also the situations of omission and input errors often occur.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention aims to provide a method and a device for generating a process pipeline instrument diagram bill of materials, which can solve the problems of time and labor waste, omission and errors caused by manual statistics of data information of a pipe fitting by a designer.
The purpose of the invention is realized by adopting the following technical scheme: the method for generating the bill of materials of the process pipeline instrument diagram comprises the following steps of:
receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
reading a material identifier in the graphic block;
searching material category data corresponding to the material identification in a material database;
selecting material parameter data corresponding to the graphic block from the material category data;
transmitting the selected material parameter data to a graphic block data information storage block;
storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
extracting material parameter data stored in data information storage blocks corresponding to part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, wherein the part of graphic blocks or all graphic blocks are selected part of graphic blocks or all graphic blocks;
summarizing the extracted material parameter data and forming a table;
and outputting the table.
Preferably, the material parameter data includes material name, material code, material specification, material model and material quantity.
Preferably, after summarizing the extracted material parameter data, the method further comprises: and classifying the summarized material parameter data according to a material coding priority rule, wherein the classifying according to the material coding priority rule comprises the step of counting and combining the quantity of materials with the same codes.
Preferably, the material parameter data corresponding to the graphic block is selected from the material category data, and the selection method includes inputting material main parameters, and searching two groups of material parameter data closest to the material main parameters according to the material main parameters for selection.
Preferably, the material database is an ERP system database.
Preferably, the graphic block data information storage block includes a graphic block extended data dictionary.
The invention also provides a device for generating the material list of the process pipeline instrument diagram, the process pipeline instrument diagram is drawn on the AUTOCAD of the development plug-in, the AUTOCAD is connected with the material database, each graphic block in the process pipeline instrument diagram is attached with a data information storage block, and the device comprises
The receiving instruction module is used for receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
the reading module is used for reading the material identification in the graph block;
the searching module is used for searching material category data corresponding to the material identification in the material database;
the selection module is used for selecting material parameter data corresponding to the graphic block from the material category data;
the transmission module is used for transmitting the selected material parameter data to the graphic block data information storage block;
the storage module is used for storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
the extraction module is used for extracting material parameter data stored in a data information storage block corresponding to part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, wherein the part of graphic blocks or all graphic blocks are selected part of graphic blocks or all graphic blocks;
the summarizing module is used for summarizing the extracted material parameter data and forming a table;
and the output module is used for outputting the table.
Preferably, the material parameter data includes material codes, material specifications, material models and material quantities.
Preferably, the device further comprises a classification module for classifying the summarized material parameter data according to a material coding priority rule, wherein the material coding priority rule comprises the step of counting and combining the number of materials with the same code.
Preferably, the selection module selects material parameter data corresponding to the graphic block from the material category data, and the selection method includes inputting material main parameters, and searching two groups of material parameter data closest to the material main parameters according to the material main parameters for selection.
Compared with the prior art, the invention has the beneficial effects that: the material data are selected from the material database and stored in the extended data dictionary of the graphic block in the process pipeline instrument diagram, and the material data in the extended data dictionary are extracted to form a form file, so that the effects of time saving, labor saving, completeness and correctness are achieved.
Drawings
FIG. 1 is a flow chart illustrating a method for generating a bill of materials for a process piping instrument diagram according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart showing a specific selection step of step 003 in FIG. 1;
FIG. 3 is a schematic diagram of an apparatus for generating a bill of materials for a process piping instrument diagram according to an embodiment of the present invention.
Detailed Description
The invention will be further described with reference to the accompanying drawings and the detailed description below:
in order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The invention is based on the communication connection of a plug-in API module developed on AUTOCAD and a material database of an ERP system, and realizes the bidirectional data transmission; the process pipeline instrument diagram is drawn in AUTOCAD, and graph blocks and line segments in the process pipeline instrument diagram have saved data attributes; the ERP system in the invention stores all material information data required to be used.
Based on the above introduction, a method for generating a bill of materials for a process pipeline instrument diagram is described in detail below.
Referring to fig. 1, fig. 1 is a schematic flow chart of a method for generating a process piping diagram bill of materials according to an embodiment of the present invention, and in fig. 1, the method for generating a process piping diagram bill of materials includes the following steps:
step 001: receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
and executing a selected command on a graphic block or a line segment which needs to store material data in the process pipeline instrument diagram, and reading the graphic block or the line segment by the system after receiving the selected command.
Step 002: reading a material identifier in the graphic block;
the graphic block is attached with marks such as the name or the parameter of the material represented by the graphic block, and the range of searching the material database can be reduced by reading the marks.
Step 003: searching material category data corresponding to the material identification in a material database;
the material database in this embodiment is an enterprise ERP system material database. According to the identification information of the read graphic block, identification search is performed in the material database, and the specific search steps in this embodiment are as shown in fig. 2:
step 031: searching whether materials consistent with the identification exist in the material names or not in a material database;
if the graphic block is identified as the equipment, searching whether a list or an option list of the equipment exists in the material database;
step 032: if so, outputting the material type data consistent with the identification, and if not, judging the material type of the identification;
if the identifier is consistent with the identifier, outputting all lists classified into the equipment, and if the identifier is not consistent with the identifier, judging the identifier to be of which type, such as equipment, instruments, valves and the like;
step 033: outputting the judged material category data;
and outputting the corresponding material category list if the identification belongs to the material category after the identification is finished.
Step 004: selecting material parameter data corresponding to the graphic block from the material category data;
the material type data includes various material parameter data, for example, the equipment includes name, model, specification, material, etc., and more specific material parameter data is selected from the material type data.
Step 005: transmitting the selected material parameter data to a graphic block data information storage block;
and exporting the selected material parameter data from an ERP system database, and transmitting the exported material parameter data to a graphic block data information storage block.
Step 006: storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
the graphic block is provided with a data information storage block for storing data, the data information storage block comprises an extended data dictionary, and the material parameter data is stored in the extended data dictionary of the graphic block.
Step 007: extracting material parameter data stored in a data information storage block corresponding to a part of graphic blocks or all graphic blocks in the process pipeline instrument diagram;
and part of the graph blocks or all the graph blocks are graph blocks which need to output material parameter data, the extracted part of the graph blocks or all the graph blocks are selected graph blocks, and the extracted material parameter data are read from the data information storage blocks corresponding to the graph blocks and are output.
Step 008: summarizing the extracted material parameter data and forming a table;
and summarizing the extracted material parameter data in a file according to output sequence, and forming a table with a regular format.
Step 009: classifying the summarized material parameter data according to a material coding priority rule;
the material parameter data comprises material codes, material specifications, material quantity, material materials and the like, the summarized material parameter data is sorted and classified according to the material codes, and the material code optimization rule comprises the step of counting and combining the quantity of the materials with the same codes.
Step 010: outputting the table;
the form may be output as a file in EXCEL form.
Based on the method for generating the process pipe instrument diagram bill of materials, the invention also correspondingly provides a process pipe instrument diagram bill of materials generating device, as shown in fig. 3, the device comprises:
the receiving instruction module 10 is used for receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
the reading module 20 is used for reading the material identification in the graphic block;
the searching module 30 is configured to search the material database for material category data corresponding to the material identifier;
the selection module 40 is used for selecting material parameter data corresponding to the graphic block from the material category data;
the transmission module 50 is used for transmitting the selected material parameter data to the graphic block data information storage block;
a saving module 60, configured to save the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
the extraction module 70 is used for extracting material parameter data stored in a data information storage block corresponding to a part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, wherein the part of graphic blocks or all graphic blocks are selected part of graphic blocks or all graphic blocks;
a summarizing module 80, configured to summarize the extracted material parameter data and form a table;
a classification module 90, configured to classify the summarized material parameter data according to a material coding priority rule, where the material coding priority rule includes counting and merging the number of materials with the same code;
an output module 10, configured to output the table;
the form may be output as a file in EXCEL form.
The functional modules of the apparatus in this embodiment correspond to each step in the above-described generation method, and the functional functions and principles of the respective modules will not be described in detail in the apparatus for the execution subject of each step.
The invention has the beneficial effects that: the material data are selected from the material database and stored in the extended data dictionary of the graphic block in the process pipeline instrument diagram, and the material data in the extended data dictionary are extracted to form a form file, so that the effects of time saving, labor saving, completeness and correctness are achieved.
Various other modifications and changes may be made by those skilled in the art based on the above-described technical solutions and concepts, and all such modifications and changes should fall within the scope of the claims of the present invention.
Claims (10)
1. The method for generating the process pipeline instrument diagram bill of material is characterized in that the process pipeline instrument diagram is drawn based on AUTOCAD of a development plug-in, the AUTOCAD is connected with a material database, the process pipeline instrument diagram comprises a graphic block, and the graphic block is attached with a data information storage block, and the method comprises the following steps:
receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
reading a material identifier in the graphic block;
searching material category data corresponding to the material identification in a material database;
selecting material parameter data corresponding to the graphic block from the material category data;
transmitting the selected material parameter data to a graphic block data information storage block;
storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
extracting material parameter data stored in data information storage blocks corresponding to part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, wherein the part of graphic blocks or all graphic blocks are selected part of graphic blocks or all graphic blocks;
summarizing the extracted material parameter data and forming a table;
and outputting the table.
2. The method of claim 1, wherein the material parameter data comprises a material name, a material code, a material specification, a material model, and a material quantity.
3. The method of claim 2, wherein the aggregating the extracted instrument profile data further comprises: and classifying the summarized material parameter data according to a material coding priority rule, wherein the classifying according to the material coding priority rule comprises the step of counting and combining the quantity of materials with the same codes.
4. The method for generating the bill of material for the process pipe instrument diagram according to claim 1, wherein the selecting of the material parameter data corresponding to the diagram block from the material category data comprises inputting material main parameters, and searching two groups of material parameter data closest to the material main parameters according to the material main parameters for preferential selection.
5. The method of claim 1, wherein the inventory database is an ERP system database.
6. The method of claim 1, wherein the graphics block data information storage block comprises a graphics block extended data dictionary.
7. The device for generating the bill of materials of the process pipeline instrument diagram is characterized in that the process pipeline instrument diagram is drawn and completed on the basis of AUTOCAD of the development plug-in, the AUTOCAD is connected with a material database, each graphic block in the process pipeline instrument diagram is attached with a data information storage block, and the device comprises:
the receiving instruction module is used for receiving an instruction that a graphic block in a process pipeline instrument diagram is selected;
the reading module is used for reading the material identification in the graph block;
the searching module is used for searching material category data corresponding to the material identification in the material database;
the selection module is used for selecting material parameter data corresponding to the graphic block from the material category data;
the transmission module is used for transmitting the selected material parameter data to the graphic block data information storage block;
the storage module is used for storing the material parameter data transmitted to the graphic block data information storage block in the graphic block data information storage block;
the extraction module is used for extracting material parameter data stored in a data information storage block corresponding to part of graphic blocks or all graphic blocks in the process pipeline instrument diagram, wherein the part of graphic blocks or all graphic blocks are selected part of graphic blocks or all graphic blocks;
the summarizing module is used for summarizing the extracted material parameter data and forming a table;
and the output module is used for outputting the table.
8. The apparatus of claim 7, wherein the material parameter data comprises a material code, a material specification, a material model, and a material quantity.
9. The apparatus of claim 8, further comprising a classification module configured to classify the aggregated material parameter data according to a material code preference rule, wherein the material code preference rule comprises statistical combinations of the number of materials with the same code.
10. The apparatus of claim 7, wherein the selection module selects the material parameter data corresponding to the graph block from the material category data, and the selection comprises inputting material main parameters, and searching two sets of material parameter data closest to the material main parameters according to the material main parameters for preference selection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710330568.3A CN107193906B (en) | 2017-05-11 | 2017-05-11 | Method and device for generating process pipeline instrument diagram bill of materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710330568.3A CN107193906B (en) | 2017-05-11 | 2017-05-11 | Method and device for generating process pipeline instrument diagram bill of materials |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107193906A CN107193906A (en) | 2017-09-22 |
| CN107193906B true CN107193906B (en) | 2020-09-04 |
Family
ID=59872487
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710330568.3A Active CN107193906B (en) | 2017-05-11 | 2017-05-11 | Method and device for generating process pipeline instrument diagram bill of materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107193906B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362883B (en) * | 2019-06-25 | 2023-02-17 | 中车青岛四方机车车辆股份有限公司 | Maintenance assembly process design method and bogie maintenance assembly method |
| CN110377620A (en) * | 2019-07-16 | 2019-10-25 | 四川康佳智能终端科技有限公司 | A kind of material searching method, computer and storage medium based on BOM tool |
| CN111459397B (en) * | 2020-02-28 | 2023-09-26 | 湖南华中天地环保科技有限公司 | Data identifier |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004954A (en) * | 2010-11-12 | 2011-04-06 | 上海信哲通软件有限公司 | Product information system and information integration method of product design system |
| CN102004943A (en) * | 2010-04-28 | 2011-04-06 | 重庆迈特科技有限责任公司 | Product multiple-BOM (bill of material) tree configurator based on unified material store |
| CN106484995A (en) * | 2016-09-30 | 2017-03-08 | 华中科技大学无锡研究院 | A kind of generation method of the GB standard BOM based on CATIA |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP5001614B2 (en) * | 2006-09-26 | 2012-08-15 | 株式会社日立製作所 | Design change range search method, design change range search device, and design change range search system |
| US7970667B2 (en) * | 2008-08-29 | 2011-06-28 | Siemens Industry, Inc. | System, method, and computer program product for a geometric search of a configurable product structure |
| CN101702219A (en) * | 2009-12-08 | 2010-05-05 | 金蝶软件（中国）有限公司 | Method for generating material information and device thereof |
| US8290830B2 (en) * | 2010-04-07 | 2012-10-16 | Siemens Product Lifecycle Management Software Inc. | System and method for visualization and comparison of physical assets using engineering design data |
| CN102999671B (en) * | 2012-11-30 | 2015-04-01 | 江苏省电力公司盱眙县供电公司 | Computer design method of standard distribution network line |
| CN105574735A (en) * | 2015-12-15 | 2016-05-11 | 北京中网易企秀科技有限公司 | Internet-based display material system and display material manufacturing method |
| CN105975562A (en) * | 2016-05-03 | 2016-09-28 | 水木智博（北京）网络信息科技有限公司 | Method and apparatus for automatically generating budget table of engineering drawing |
-
2017
- 2017-05-11 CN CN201710330568.3A patent/CN107193906B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004943A (en) * | 2010-04-28 | 2011-04-06 | 重庆迈特科技有限责任公司 | Product multiple-BOM (bill of material) tree configurator based on unified material store |
| CN102004954A (en) * | 2010-11-12 | 2011-04-06 | 上海信哲通软件有限公司 | Product information system and information integration method of product design system |
| CN106484995A (en) * | 2016-09-30 | 2017-03-08 | 华中科技大学无锡研究院 | A kind of generation method of the GB standard BOM based on CATIA |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107193906A (en) | 2017-09-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Al-Saeed et al. | Automating construction manufacturing procedures using BIM digital objects (BDOs) Case study of knowledge transfer partnership project in UK | |
| CN111462327B (en) | Unstructured data analysis method for three-dimensional inspection model of three-dimensional modeling software | |
| CN104268428B (en) | A kind of visual configuration method calculated for index | |
| CN107885499A (en) | A kind of interface document generation method and terminal device | |
| CN106777808B (en) | Network resource generation method based on standardized CAD drawing | |
| CN107193906B (en) | Method and device for generating process pipeline instrument diagram bill of materials | |
| CN107357970B (en) | Data mining-based building information model abnormal element detection device and method | |
| CN111144089B (en) | Method and equipment for checking difference between part list and model file of design software | |
| CN105446952B (en) | For handling the method and system of semantic segment | |
| CN106469152A (en) | A kind of document handling method based on ETL and system | |
| CN114328980A (en) | Knowledge graph construction method and device combining RPA and AI, terminal and storage medium | |
| CN101290622A (en) | Database cleaning system and method | |
| CN115329556A (en) | Transformer substation CAD drawing auditing method and device | |
| CN114706915A (en) | Method for building BOM information from PLM system by EDA software | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| CN110737729A (en) | Engineering map data information management method based on knowledge map concept and technology | |
| CN105912723A (en) | Storage method of custom field | |
| CN103425490A (en) | Management method based on running object data in CRM system | |
| CN111898351B (en) | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN116821223A (en) | Industrial visual control platform and method based on digital twinning | |
| CN113535966A (en) | Knowledge graph creating method, information obtaining method, device and equipment | |
| CN116010380A (en) | Data warehouse automatic management method based on visual modeling | |
| CN113434798B (en) | Code-free RPA automatic process file generation method and system | |
| CN107844639B (en) | Project standard structure automatic generation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Generation method and device of P & ID BOM Effective date of registration: 20210128 Granted publication date: 20200904 Pledgee: Bank of China Limited by Share Ltd. Guangzhou Panyu branch Pledgor: AWS ENVIRONMENT TECHNOLOGIES Ltd. Registration number: Y2021980000838 |