CN107273417A - The generation method and device of a kind of pipeline rout figure BOM - Google Patents
The generation method and device of a kind of pipeline rout figure BOM Download PDFInfo
- Publication number
- CN107273417A CN107273417A CN201710331011.1A CN201710331011A CN107273417A CN 107273417 A CN107273417 A CN 107273417A CN 201710331011 A CN201710331011 A CN 201710331011A CN 107273417 A CN107273417 A CN 107273417A
- Authority
- CN
- China
- Prior art keywords
- pipeline
- data
- material data
- rout
- autocad
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Warehouses Or Storage Devices (AREA)
Abstract
The invention discloses the generation method of pipeline rout figure BOM and device, it the described method comprises the following steps：Receiving pipeline moves towards the selected instruction of pipeline figure in figure；With the material data corresponding to selected pipeline figure in selection material database；The material data chosen is transferred in data storage block；The material data in data storage block is will be transmitted to be stored in data storage block；The material data preserved in pipeline rout figure in the DSB data store block of section of tubing figure or whole pipeline figures is extracted, the section of tubing figure or whole pipeline figures are selected section of tubing figure or whole pipeline figures；The material data of extraction is collected and form is formed；Form is exported.It can collect the material formation inventory in pipeline rout figure automatically to the present invention, and can export in a tabular form.
Description
Technical field
The present invention relates to AUTOCAD plug-in units field, more particularly to a kind of generation method of pipeline rout figure BOM and
Device.
Background technology
AUTOCAD is to use most computer aided design softwares in the world at present, at home each enterprise and designing institute
In be widely applied.AUTOCAD is feature-rich, can easily realize various drawing and information storage function, but
It is a common software after all, and the specific function that each enterprise needs is not refined.For the ease of the customized work(of user
Can, the AUTOCAD all-round openings API of internal control so that it fully can carry out plug-in unit according to enterprise or industry requirement
Exploitation, meets specific industry or the demand using function.After pipeline rout figure is drawn, designer is in order to provide construction material
Inventory, it is necessary to count the title for inputting material after pipeline, the quantity of pipe fitting, totalling in AUTOCAD or EXCEL tables, rule by hand
The information such as lattice, quantity, material are to construct.In the enterprise for having ERP to manage, designer will also compare ERP material tables, by ERP
Numbering input inventory could be purchased into ERP system.Because pipeline, the species of particularly pipe fitting is various, not only time-consuming to take
Power and the situation that omission, input error often occurs.
The content of the invention
In order to overcome the deficiencies in the prior art, object of the present invention is to provide a kind of pipeline rout figure BOM
Generation method, what it can solve that designer counts that the data of pipe fitting are brought by hand wasted time and energy, omit and mistake is asked
Topic.
The purpose of the present invention is realized using following technical scheme：
A kind of generation method of pipeline rout figure BOM, AUTOCAD of the pipeline rout figure based on exploitation plug-in unit
On complete, the AUTOCAD is connected with material data storehouse, and each pipeline figure in the pipeline rout figure is all with number
According to memory block, it the described method comprises the following steps：
Receiving pipeline moves towards the selected instruction of pipeline figure in figure；
With the material data corresponding to selected pipeline figure in selection material database；
The material data chosen is transferred in data storage block；
The material data in data storage block is will be transmitted to be stored in data storage block.
Preferably, methods described is further comprising the steps of：
Extract the material number preserved in pipeline rout figure in the DSB data store block of section of tubing figure or whole pipeline figures
According to the section of tubing figure or whole pipeline figures are selected section of tubing figure or whole pipeline figures；
The material data of extraction is collected and form is formed；
Form is exported.
Preferably, the material data includes COM code, material specification, material model, material material and material quantity.
Preferably, it is described the material data of extraction is collected after also include：By the material data collected by
COM code priority rule is sorted out, described to carry out sorting out including to COM code identical thing by COM code priority rule
The quantity of material carries out statistics merging.
Preferably, the form carry out output include with the output of AUTOCAD tableau formats in AUTOCAD figures or with
EXCEL tableau formats are output as a unique file.
Preferably, the material data storehouse is ERP system database.
Preferably, the pipeline graph data memory block includes pipeline figure growth data dictionary.
The technical program separately provides a kind of generating means of pipeline rout figure BOM, it is characterised in that the pipe
Road moves towards what is completed on AUTOCAD of the figure based on exploitation plug-in unit, and the AUTOCAD is connected with material data storehouse, the pipe
Each pipeline figure that road is moved towards in figure all has DSB data store block, and described device includes：
Instruction module is received, the selected instruction of pipeline figure in figure is moved towards for receiving pipeline；
Selecting module, for select in material database with the material data corresponding to selected pipeline figure；
Transport module, for the material data chosen to be transferred in data storage block；
Preserving module, is stored in data storage block for will be transmitted to the material data in data storage block.
Preferably, described device also includes：
Extraction module, for extracting in pipeline rout figure in the DSB data store block of section of tubing figure or whole pipeline figures
The material data of preservation, the section of tubing figure or whole pipeline figures pipe for selected section of tubing figure or all
Road figure；；
Summarizing module, for being collected the material data of extraction and forming form；
Output module, for form to be exported.
Preferably, the material data includes COM code, material specification, material model, material material and material quantity.
Preferably, described device also includes classifying module, for the material data collected is preferential by COM code
Rule is sorted out, described to include carrying out the quantity of COM code identical material by the progress classification of COM code priority rule
Statistics merges.
Preferably, the mode of the output module output formats includes in AUTOCAD scheming with the output of AUTOCAD tableau formats
A unique file is output as in shape or with EXCEL tableau formats.
Compared with prior art, the beneficial effects of the present invention are：By selecting material data in material data storehouse and inciting somebody to action
Material data is stored in the growth data dictionary of the pipeline figure in pipeline rout figure, by extracting in growth data dictionary
It is time saving and energy saving that material data formation form document reaches, complete correct effect.
Brief description of the drawings
Fig. 1 is a kind of generation method schematic flow sheet of pipeline rout figure BOM in the embodiment of the present invention；
Fig. 2 is the specifically chosen data flow diagram of step 002 in Fig. 1；
Fig. 3 is a kind of structural representation of the generating means of pipeline rout figure BOM in the embodiment of the present invention.
Embodiment
Below, with reference to accompanying drawing and embodiment, the present invention is described further：
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
The present invention is to be connected based on the plug-in unit API module developed on AUTOCAD with the communication of ERP system material data storehouse, that
This realizes that data double-way is transmitted；Pipeline rout figure in the present invention is to be completed in AUTOCAD, pipeline rout figure
In pipeline figure have preserve data attribute；ERP system in the present invention stores all material information data needed to use,
All pipe fittings used and accessory are in typing ERP system in pipeline rout figure.
Introduction basis based on more than, describes a kind of pipeline rout figure material based on AUTOCAD plug-in units clear in detail below
Single generation method.
Such as Fig. 1, Fig. 1 is a kind of generation method schematic flow sheet of pipeline rout figure BOM in the embodiment of the present invention,
In Fig. 1, a kind of generation method of pipeline rout figure BOM comprises the following steps：
Step 001：Receiving pipeline moves towards the selected instruction of pipeline figure in figure；
Order is chosen to needing the pipeline figure for storing material data to perform in pipeline rout figure, system receives this and chosen
Instruction, performs and selection material data command is found in ERP system database.
Step 002：With the material data corresponding to selected pipeline figure in selection material database.
According to the demand of design, choosing is scanned in ERP system material data storehouse by way of inputting parameter of materials
Select, the material in the present embodiment corresponding to pipeline figure is pipe fitting, the specifically chosen step of pipe fitting data is as shown in Figure 2：
Step 100：According to the demand of design, the data of pipe fitting are filtered out from ERP system；
Search and preliminary screening outlet pipe number of packages evidence from material data storehouse, pipe fitting data now are the pipe fitting of all size
Data；
Step 200：Select the specification of pipe fitting；
The pipe fitting data of the corresponding one or more of specifications of pipeline figure are selected from the pipe fitting data of plurality of specifications；
Step 300：Deploy specification subclass, further selection pipe fitting model, material etc.；
Other data of pipe fitting are selected from specification subclass, other data include the data such as model, material；
Step 400：Other pipe fitting information such as model, material and coding are obtained to be exported；
Obtain the pipe fitting data such as selected model, material, and generate the pipe fitting store list with coding, and by this pipe fitting material
Forms data is exported from EPR system material datas storehouse, i.e., the corresponding pipe fitting data of pipeline figure are chosen finishes.
Step 003：The material data chosen is transferred in data storage block；
The material data chosen is transferred in the DSB data store block in AUTOCAD contained by pipeline figure, it is preferred that
Pipeline graph data memory block includes pipeline figure growth data dictionary.
Step 004：The material data in data storage block is will be transmitted to be stored in data storage block；
The material data that transmission comes is stored in growth data dictionary.
Step 005：Extract in pipeline rout figure and preserved in the DSB data store block of section of tubing figure or whole pipeline figures
Material data；
All choose to the required section of tubing figure for extracting material data or directly, and to being stored in part pipe
Material data in the DSB data store block of road figure or whole pipeline figures is extracted.
Step 006：The material data of extraction is collected and form is formed；
The material data extracted is being summarised in same file.
Step 007：The material data collected is sorted out by COM code priority rule；
Material data in file is reclassified according to the coding priority rule in material data, the preferential rule of coding
Then include carrying out the quantity of COM code identical material statistics addition merging.
Step 008：Form is exported；
The mode of output formats can be in AUTOCAD figures or with EXCEL tables with the output of AUTOCAD tableau formats
Form is output as a unique file.
Based on the generation method of above pipeline rout figure BOM, the present invention also accordingly provides a kind of pipeline rout
Figure BOM generating means, as shown in figure 3, described device includes：
Instruction module 10 is received, the selected instruction of pipeline figure in figure is moved towards for receiving pipeline；
Selecting module 20, for select in material database with the material data corresponding to selected pipeline figure；
Material data includes COM code, material specification, material model and material quantity.
Transport module 30, for the material data chosen to be transferred in data storage block；
Preserving module 40, is stored in data storage block for will be transmitted to the material data in data storage block；
Extraction module 50, the DSB data store block for extracting section of tubing figure or whole pipeline figures in pipeline rout figure
The material data of middle preservation, the section of tubing figure or whole pipeline figures are selected section of tubing figure or whole
Pipeline figure；；
Summarizing module 60, for being collected the material data of extraction and forming form；
Classifying module 70, for the material data collected to be sorted out by COM code priority rule；
It is described to include counting the quantity of COM code identical material by the progress classification of COM code priority rule
Merge.
Output module 80, for form to be exported；
The mode of output module output formats include with AUTOCAD tableau formats output in AUTOCAD figures or with
EXCEL tableau formats are output as a unique file.
Each step that the functional module of device in the present embodiment corresponds in above-mentioned generation method, is each step
Executive agent, does not just repeat to describe function and the principle of modules in detail in the present apparatus.
Beneficial effect of the present invention is：By selecting material data in material data storehouse and material data being stored in into pipe
Road is moved towards in the growth data dictionary of the pipeline figure in figure, by extracting the formation form of the material data in growth data dictionary
It is time saving and energy saving that file reaches, complete correct effect.
It will be apparent to those skilled in the art that technical scheme that can be as described above and design, make other various
It is corresponding to change and deformation, and all these change and deformation should all belong to the protection domain of the claims in the present invention
Within.
Claims (10)
1. a kind of generation method of pipeline rout figure BOM, it is characterised in that the pipeline rout figure is based on exploitation plug-in unit
AUTOCAD on complete, the AUTOCAD is connected with material data storehouse, each piping drawing in the pipeline rout figure
Shape all has DSB data store block, the described method comprises the following steps：
Receiving pipeline moves towards the selected instruction of pipeline figure in figure；
With the material data corresponding to selected pipeline figure in selection material database；
The material data chosen is transferred in data storage block；
It will be transmitted to the material data in data storage block to be stored in the pipeline rout figure, and stored with graphic file.
2. the method as described in claim 1, it is characterised in that protected in the material data that will be transmitted in data storage block
It is further comprising the steps of in the presence of in the pipeline rout figure, and after being stored with graphic file：
Extract the material data preserved in pipeline rout figure in the DSB data store block of section of tubing figure or whole pipeline figures, institute
It is selected section of tubing figure or whole pipeline figures to state section of tubing figure or whole pipeline figures；
The material data of extraction is collected and form is formed；
Form is exported.
3. method as claimed in claim 2, it is characterised in that it is described the material data of extraction is collected after also wrap
Include：The material data collected is sorted out by COM code priority rule, it is described to be carried out by COM code priority rule
Sorting out includes carrying out statistics merging to the quantity of COM code identical material.
4. the method as described in claim 1, it is characterised in that the form, which carries out output, to be included with AUTOCAD tableau formats
Output is output as a unique file in AUTOCAD figures or with EXCEL tableau formats.
5. the method as described in claim 1, it is characterised in that the material data storehouse is ERP system database.
6. the method as described in claim 1, it is characterised in that the pipeline graph data memory block includes pipeline graphic extension
Data dictionary.
7. a kind of generating means of pipeline rout figure BOM, it is characterised in that the pipeline rout figure is based on exploitation plug-in unit
AUTOCAD on complete, the AUTOCAD is connected with material data storehouse, each piping drawing in the pipeline rout figure
Shape all has DSB data store block, and described device includes：
Instruction module is received, the selected instruction of pipeline figure in figure is moved towards for receiving pipeline；
Selecting module, for select in material database with the material data corresponding to selected pipeline figure；
Transport module, for the material data chosen to be transferred in data storage block；
Preserving module, is stored in data storage block for will be transmitted to the material data in data storage block.
8. device as claimed in claim 7, it is characterised in that also include：
Extraction module, is preserved for extracting in pipeline rout figure in the DSB data store block of section of tubing figure or whole pipeline figures
Material data, the section of tubing figure or whole pipeline figure are selected section of tubing figure or whole piping drawings
Shape；
Summarizing module, for being collected the material data of extraction and forming form；
Output module, for form to be exported.
9. device as claimed in claim 8, it is characterised in that described device also includes classifying module, for collecting described
Material data sorted out by COM code priority rule, it is described by COM code priority rule carry out sort out include to material
The quantity for encoding identical material carries out statistics merging.
10. device as claimed in claim 7, it is characterised in that the mode of the output module output formats include with
The output of AUTOCAD tableau formats is output as a unique file in AUTOCAD figures or with EXCEL tableau formats.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710331011.1A CN107273417A (en) | 2017-05-11 | 2017-05-11 | The generation method and device of a kind of pipeline rout figure BOM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710331011.1A CN107273417A (en) | 2017-05-11 | 2017-05-11 | The generation method and device of a kind of pipeline rout figure BOM |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107273417A true CN107273417A (en) | 2017-10-20 |
Family
ID=60073925
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710331011.1A Pending CN107273417A (en) | 2017-05-11 | 2017-05-11 | The generation method and device of a kind of pipeline rout figure BOM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107273417A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111259210A (en) * | 2018-11-30 | 2020-06-09 | 塔塔咨询服务公司 | System and method for automated extraction of information from piping and instrumentation diagrams |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080077902A1 (en) * | 2006-09-26 | 2008-03-27 | Ichiro Harashima | Method of Determining Range Of Change in Design, Design Change Range Determining Apparatus, and Design Change Range Determining System |
| CN101350079A (en) * | 2007-07-17 | 2009-01-21 | 英业达股份有限公司 | Method and system for calculating product cost |
| 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 |
| CN103324681A (en) * | 2013-05-31 | 2013-09-25 | 重庆瑜煌电力设备制造有限公司 | Process card data generation method based on computed-aided design (CAD) |
| CN105975562A (en) * | 2016-05-03 | 2016-09-28 | 水木智博（北京）网络信息科技有限公司 | Method and apparatus for automatically generating budget table of engineering drawing |
| CN106484995A (en) * | 2016-09-30 | 2017-03-08 | 华中科技大学无锡研究院 | A kind of generation method of the GB standard BOM based on CATIA |
-
2017
- 2017-05-11 CN CN201710331011.1A patent/CN107273417A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080077902A1 (en) * | 2006-09-26 | 2008-03-27 | Ichiro Harashima | Method of Determining Range Of Change in Design, Design Change Range Determining Apparatus, and Design Change Range Determining System |
| CN101350079A (en) * | 2007-07-17 | 2009-01-21 | 英业达股份有限公司 | Method and system for calculating product cost |
| 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 |
| CN103324681A (en) * | 2013-05-31 | 2013-09-25 | 重庆瑜煌电力设备制造有限公司 | Process card data generation method based on computed-aided design (CAD) |
| CN105975562A (en) * | 2016-05-03 | 2016-09-28 | 水木智博（北京）网络信息科技有限公司 | Method and apparatus for automatically generating budget table of engineering drawing |
| CN106484995A (en) * | 2016-09-30 | 2017-03-08 | 华中科技大学无锡研究院 | A kind of generation method of the GB standard BOM based on CATIA |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111259210A (en) * | 2018-11-30 | 2020-06-09 | 塔塔咨询服务公司 | System and method for automated extraction of information from piping and instrumentation diagrams |
| CN111259210B (en) * | 2018-11-30 | 2024-04-30 | 塔塔咨询服务公司 | System and method for automated information extraction from piping and instrumentation diagrams |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102044016A (en) | Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule | |
| CN102541529B (en) | A kind of query page generating device and method | |
| CN104268428B (en) | A kind of visual configuration method calculated for index | |
| CN109669933B (en) | Transaction data intelligent processing method and device and computer readable storage medium | |
| CN105912609B (en) | A kind of data file processing method and device | |
| CN103678648B (en) | A kind of BOM table sort aggregation system and method thereof | |
| CN105389402A (en) | Big-data-oriented ETL (Extraction-Transformation-Loading) method and device | |
| KR101617696B1 (en) | Method and device for mining data regular expression | |
| CN105320806B (en) | Method for summarizing nuclear power process pipeline material by combining PML (polymethylene diamine) with Excel-VBA (Excel-VBA) processing data | |
| CN105975466A (en) | Method and device for machine manuscript writing aiming at short newsflashes | |
| CN103279478A (en) | Method for extracting features based on distributed mutual information documents | |
| CN110471754A (en) | Method for exhibiting data, device, equipment and storage medium in job scheduling | |
| CN109636092B (en) | Warehouse goods space allocation method based on double-factor optimization | |
| Lee et al. | NESIS: a neutral schema for a web-based simulation model exchange service across heterogeneous simulation software | |
| CN106528641A (en) | Data storage method and device and communication gateway machine | |
| CN107193906A (en) | The generation method and device of process pipe meter diagram BOM | |
| CN107273417A (en) | The generation method and device of a kind of pipeline rout figure BOM | |
| CN110287603A (en) | A kind of circuit auxiliary design method and device based on CBB circuit library | |
| CN103425490A (en) | Management method based on running object data in CRM system | |
| CN101894317B (en) | System and method for driving business logic through data changes | |
| Cecelja | Manufacturing Information and Data Systems: Analysis, Design and Practice | |
| CN102567590A (en) | CAD (computer aided design) server device and method | |
| CN103970900B (en) | Multi-dimensional cross data flexible management method and system based on industrial field | |
| CN102855227B (en) | Document processing system and method | |
| CN107301239A (en) | A kind of database converter and conversion method |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171020 |
|
| RJ01 | Rejection of invention patent application after publication |