CN112464402B - Automatic pipeline batching method based on E3D software - Google Patents
Automatic pipeline batching method based on E3D software Download PDFInfo
- Publication number
- CN112464402B CN112464402B CN202011332544.XA CN202011332544A CN112464402B CN 112464402 B CN112464402 B CN 112464402B CN 202011332544 A CN202011332544 A CN 202011332544A CN 112464402 B CN112464402 B CN 112464402B
- Authority
- CN
- China
- Prior art keywords
- pipeline
- batching
- stock
- array
- inventory
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/17—Mechanical parametric or variational design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90344—Query processing by using string matching techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/14—Pipes
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Geometry (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Databases & Information Systems (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Finance (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Computational Mathematics (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses an automatic pipeline batching method based on E3D software, which can traverse all pipelines needing batching in an E3D software model through a three-dimensional software secondary development technology, obtain the length and the pipeline number of each batching pipeline, carry out batching on the batching pipelines according to the length sequence from small to large, establish a pipeline inventory table, record the detailed information of each inventory pipeline in a warehouse in the pipeline inventory table, automatically match the inventory pipelines in the pipeline inventory table according to the length of each batching pipeline, establish a batching result table for storing batching results, and store the pipeline number of each batching pipeline and the stock number of the matched inventory pipeline in the same row of the batching result table. The method can efficiently solve the problem of pipeline batching related to pipeline construction, and has the advantages of simple operation, high efficiency, reliability and visual result.
Description
Technical Field
The invention relates to an automatic pipeline batching method, in particular to an automatic pipeline batching method based on E3D software.
Background
The E3D software is three-dimensional design software, can better fuse three-dimensional point cloud data, has related functions of point cloud processing, and combines excellent design functions, so that the E3D software has more advantages in three-dimensional factory reconstruction projects, and the E3D software is commonly used in large-scale pipeline layout design of factories or ships. In the project model of the E3D software, a large number of pipelines are arranged, and the lengths of the pipelines are different from one another. The lengths of the pipes are stored in the warehouse of the factory, and the length information of each pipe in the warehouse is stored in an EXCEL inventory table. In the pipeline construction stage, each pipeline in the project model in the E3D software needs to be searched for a pipeline with a corresponding length in the inventory table for matching, and if a certain pipeline in the E3D model does not have a pipeline with a corresponding length in the inventory table, the pipeline in the inventory table can be cut off for matching.
At present, pipeline batching is manual operation, a large amount of pipelines are manually matched, a large amount of time is consumed, matching is complicated when the pipelines need to be cut off, the optimal matching effect is difficult to achieve, and mistakes are easy to make. Therefore, it is important to perform automatic batching of pipelines, reduce manual calculation and avoid errors.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provide an automatic pipeline batching method which is simple to operate, efficient, reliable and visible in result and is based on E3D software.
In order to achieve the purpose, the invention adopts the technical scheme that:
the invention discloses an automatic pipeline batching method based on E3D software, which comprises the following steps:
opening a model of a pipeline project in E3D software, and carrying out secondary development on the E3D software by using a C # programming language to obtain a part with a part type of a pipeline and detailed attributes of the pipeline, wherein the pipeline is used as a batching pipeline, and the detailed attributes of the batching pipeline comprise the length of the batching pipeline and the number of the batching pipeline; the pipeline numbers of all the batching pipelines are different;
step two, storing the detailed attribute information of each batching pipeline into a batching array represented by a two-dimensional character string, and then sequencing all batching pipelines according to the length sequence from small to large;
step three, establishing a pipeline inventory table by using an EXCEL table, and then recording detailed information of each inventory pipeline in the warehouse in the pipeline inventory table, wherein the detailed information of each inventory pipeline comprises the pipeline length and the pipeline inventory number of each inventory pipeline, the pipeline inventory number comprises the information of a pipeline bill number, a supplier supply package number and a serial number, and the inventory numbers of all the pipelines are different;
reading the detailed information of each stock pipeline in the pipeline stock table by using a C # programming language;
step five, storing the information of the stock pipelines into a stock array represented by a two-dimensional character string, and then sequencing all the stock pipelines according to the length sequence from small to large;
step six, batching, comprising the following specific steps:
firstly, establishing a batching result table for recording batching conditions by adopting a text document format, wherein each line in the batching result table is used for recording the batching conditions of each pipeline to be batched, and the information of each line comprises the pipeline number of the pipeline to be batched and the stock number of the matched stock pipeline:
secondly, taking out a first batching pipeline from the batching array and obtaining the length of the batching pipeline as D, traversing the stock pipelines in the stock array from top to bottom, wherein the length of the jth stock pipeline is D (j), if D (j) is smaller than D, traversing the next stock pipeline in the stock array until the stock pipeline with D (j) larger than or equal to D is found, and D (j) larger than or equal to D indicates that the stock pipeline in the stock array can be D after being cut;
thirdly, adding a row of data in the batching result table, filling the serial number of the batching pipeline taken out from the batching array into the row, filling the pipeline inventory serial number of the inventory pipeline matched with the batching pipeline in the inventory array into the row, and deleting the jth row of data in the inventory array;
and fourthly, taking out the next pipeline from the batching array, repeating the second step and the fourth step until all the pipelines in the batching array are completely batched, and finally checking a batching information result in a batching result table.
Compared with the prior art, the invention has the following beneficial effects:
the method can traverse to obtain all pipelines needing to be proportioned in the E3D software model through a three-dimensional software secondary development technology, automatically match in the pipeline inventory list table according to the length of each pipeline, can efficiently solve the pipeline proportioning problem related to pipeline construction, and is simple to operate, efficient and reliable, and visible in result.
Detailed Description
The present invention will be described in detail with reference to specific examples.
The invention discloses an automatic pipeline batching method based on E3D software, which comprises the following steps:
opening a model of a pipeline project in E3D software, and carrying out secondary development on the E3D software by using a C # programming language to obtain a part with a part type of a pipeline and detailed attributes of the pipeline, wherein the pipeline is used as a batching pipeline, and the detailed attributes of the batching pipeline comprise the length of the batching pipeline and the number of the batching pipeline; the batching pipeline number is a unique identifier of the pipeline in the E3D software, and the pipeline number of each batching pipeline is different.
The specific process of performing secondary development on the E3D software by using the C # programming language to obtain the parts with the part types of the pipelines and the detailed attributes of the pipelines is as follows:
firstly, obtaining all parts in a project model through an API function provided by E3D software, wherein the part types in the E3D software comprise various types such as pipelines, valves, bolts and the like.
Step two, traversing all the parts obtained in the step one, judging whether the type of the part is a pipeline or not, and if the type of the part is not the pipeline, continuously traversing the next part; if the type of the part is a pipe, the pipe is taken as a batching pipe, and the detailed attributes of the batching pipe are read.
Step two, storing the detailed attribute information of each batching pipeline into a batching array represented by a two-dimensional character string, and then sequencing all batching pipelines according to the length sequence from small to large;
as an embodiment of the present invention, a specific process of storing detailed attribute information of each ingredient pipeline into an ingredient array is as follows:
step one, establishing a two-dimensional batching array of a character string type by using a C # programming language, wherein the column number of the batching array is equal to 2, and the row number of the batching array is equal to the number of all batching pipelines in an E3D project model;
secondly, respectively storing the lengths of the batching pipelines and the numbers of the batching pipelines in a first row of a batching array and a second row of the batching array;
and thirdly, establishing a pipeline inventory table by using an EXCEL table, and then recording detailed information of each inventory pipeline in the warehouse in the pipeline inventory table, wherein the detailed information of each inventory pipeline comprises the pipeline length and the pipeline inventory number of each inventory pipeline, the pipeline inventory number comprises the information of a pipeline bill number, a supplier supply package number and a serial number, and the inventory numbers of all pipelines are different.
Reading the detailed information of each stock pipeline in the pipeline stock table by using a C # programming language;
step five, storing the information of the stock pipelines into a stock array represented by a two-dimensional character string, and then sequencing all the stock pipelines according to the length sequence from small to large;
as an embodiment of the invention, the specific process of storing the information of the inventory pipe into an inventory array is as follows:
in a first step, a two-dimensional stock array of a string type is created using the C # programming language, the number of columns of the stock array being equal to 2, and the number of rows of the stock array being equal to the number of all stock pipes in the pipe stock table.
And secondly, storing the length data of the stock pipeline in a first row of the stock array, and storing the stock number of the stock pipeline in a second row of the stock array.
Step six, batching, comprising the following specific steps:
firstly, establishing a batching result table for recording batching conditions by adopting a text document format, wherein each line in the batching result table is used for recording the batching conditions of each pipeline to be batched, and the information of each line comprises the pipeline number of the pipeline to be batched and the stock number of the matched stock pipeline:
and secondly, taking out a first batching pipeline from the batching array and obtaining the length of the batching pipeline as D, traversing the stock pipelines in the stock array from top to bottom, wherein the length of the jth stock pipeline is D (j), if the D (j) is smaller than D, traversing the next stock pipeline in the stock array until finding the stock pipeline of which the D (j) is larger than or equal to D, and the D (j) is larger than or equal to D, which means that the stock pipeline in the stock array can have the length of D after being cut.
And thirdly, adding a row of data in the batching result table, filling the serial number of the batching pipeline taken out from the batching array into the row, filling the pipeline stock serial number of the stock pipeline matched with the batching pipeline in the stock array into the row, and deleting the jth row of data in the stock array.
And fourthly, taking out the next pipeline from the batching array, and repeating the second step and the fourth step until all the pipelines in the batching array are completely batched. The final ingredient information results are viewed in an ingredient results table.
Claims (4)
1. An automatic pipeline batching method based on E3D software is characterized by comprising the following steps:
opening a model of a pipeline project in E3D software, and carrying out secondary development on the E3D software by using a C # programming language to obtain a part with a part type of a pipeline and detailed attributes of the pipeline, wherein the pipeline is used as a batching pipeline, and the detailed attributes of the batching pipeline comprise the length of the batching pipeline and the number of the batching pipeline; the pipeline numbers of all the batching pipelines are different;
step two, storing the detailed attribute information of each batching pipeline into a batching array represented by a two-dimensional character string, and then sequencing all batching pipelines according to the length sequence from small to large;
step three, establishing a pipeline inventory table by using an EXCEL table, and then recording detailed information of each inventory pipeline in the warehouse in the pipeline inventory table, wherein the detailed information of each inventory pipeline comprises the pipeline length and the pipeline inventory number of each inventory pipeline, the pipeline inventory number comprises the information of a pipeline bill number, a supplier supply package number and a serial number, and the inventory numbers of all the pipelines are different;
reading the detailed information of each stock pipeline in the pipeline stock table by using a C # programming language;
step five, storing the information of the stock pipelines into a stock array represented by a two-dimensional character string, and then sequencing all the stock pipelines according to the length sequence from small to large;
step six, batching, comprising the following specific steps:
firstly, establishing a batching result table for recording batching conditions by adopting a text document format, wherein each line in the batching result table is used for recording the batching conditions of each pipeline to be batched, and the information of each line comprises the pipeline number of the pipeline to be batched and the stock number of the matched stock pipeline:
secondly, taking out a first batching pipeline from the batching array and obtaining the length of the batching pipeline as D, traversing the stock pipelines in the stock array from top to bottom, wherein the length of the jth stock pipeline is D (j), if D (j) is smaller than D, traversing the next stock pipeline in the stock array until the stock pipeline with D (j) larger than or equal to D is found, and D (j) larger than or equal to D indicates that the stock pipeline in the stock array can be D after being cut;
thirdly, adding a row of data in the batching result table, filling the serial number of the batching pipeline taken out from the batching array into the row, filling the pipeline inventory serial number of the inventory pipeline matched with the batching pipeline in the inventory array into the row, and deleting the jth row of data in the inventory array;
and fourthly, taking out the next pipeline from the batching array, repeating the second step and the fourth step until all the pipelines in the batching array are completely batched, and finally checking a batching information result in a batching result table.
2. The E3D software-based pipeline automatic batching method according to claim 1, characterized in that; the specific process of performing secondary development on the E3D software by using the C # programming language to obtain the parts with the part types of the pipelines and the detailed attributes of the pipelines comprises the following steps:
step one, obtaining all zeros in a project model through an API function provided by E3D software;
step two, traversing all the parts obtained in the step one, judging whether the type of the part is a pipeline or not, and if the type of the part is not the pipeline, continuously traversing the next part; if the type of the part is a pipe, the pipe is taken as a batching pipe, and the detailed attributes of the batching pipe are read.
3. The E3D software-based pipeline automatic batching method according to claim 1 or 2, characterized in that: the specific process of storing the detailed attribute information of each batching pipeline into the batching array is as follows:
step one, establishing a two-dimensional batching array of a character string type by using a C # programming language, wherein the column number of the batching array is equal to 2, and the row number of the batching array is equal to the number of all batching pipelines in an E3D project model;
and secondly, respectively storing the lengths of the batching pipelines and the serial numbers of the batching pipelines in a first row of the batching array and a second row of the batching array.
4. The E3D software-based pipeline automatic batching method according to claim 3, characterized in that: the specific process of storing the information of the stock pipes into an inventory array is as follows:
firstly, establishing a two-dimensional stock array of a character string type by using a C # programming language, wherein the column number of the stock array is equal to 2, and the row number of the stock array is equal to the number of all stock pipelines in a pipeline stock table;
and secondly, storing the length data of the stock pipeline in a first row of the stock array, and storing the stock number of the stock pipeline in a second row of the stock array.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011332544.XA CN112464402B (en) | 2020-11-24 | 2020-11-24 | Automatic pipeline batching method based on E3D software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011332544.XA CN112464402B (en) | 2020-11-24 | 2020-11-24 | Automatic pipeline batching method based on E3D software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112464402A CN112464402A (en) | 2021-03-09 |
| CN112464402B true CN112464402B (en) | 2023-04-07 |
Family
ID=74798818
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011332544.XA Active CN112464402B (en) | 2020-11-24 | 2020-11-24 | Automatic pipeline batching method based on E3D software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112464402B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2827290A1 (en) * | 2013-07-19 | 2015-01-21 | Daniel Kropp | Method for handling and/or distribution of goods by means of a goods depot and goods depot |
| CN107256318A (en) * | 2017-07-18 | 2017-10-17 | 中国电建集团河南工程公司 | Boiler tubule pipeline construction method based on BIM technology |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2638404A1 (en) * | 2007-08-04 | 2009-02-04 | Rob Anderson | Inventory management and ordering system |
| CN102034155A (en) * | 2010-12-17 | 2011-04-27 | 武汉钢铁(集团)公司 | Data processing method for automatic burdening of hot-rolling slab |
| CN104537150A (en) * | 2014-12-01 | 2015-04-22 | 艾法能源工程股份有限公司 | Statistical method for pipe support materials in PDMS |
| CN105488271B (en) * | 2015-11-27 | 2018-05-25 | 天津博迈科海洋工程有限公司 | A kind of oil gas module shaped steel automatic matching method |
| CN108145378A (en) * | 2017-11-24 | 2018-06-12 | 南通象屿海洋装备有限责任公司 | A kind of ship pipe processing technique |
| CN108763187A (en) * | 2018-06-07 | 2018-11-06 | 中国化学赛鼎宁波工程有限公司 | A kind of Material Takeoff method based on PDMS softwares |
| CN111008458A (en) * | 2019-11-12 | 2020-04-14 | 天津博迈科海洋工程有限公司 | Intelligent nesting method for large oil-gas module pipeline |
| CN111553625A (en) * | 2020-04-08 | 2020-08-18 | 山东鹰联光电科技有限公司 | Raw material management method and system for cable distribution |
-
2020
- 2020-11-24 CN CN202011332544.XA patent/CN112464402B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2827290A1 (en) * | 2013-07-19 | 2015-01-21 | Daniel Kropp | Method for handling and/or distribution of goods by means of a goods depot and goods depot |
| CN107256318A (en) * | 2017-07-18 | 2017-10-17 | 中国电建集团河南工程公司 | Boiler tubule pipeline construction method based on BIM technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112464402A (en) | 2021-03-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9495347B2 (en) | Systems and methods for extracting table information from documents | |
| CN111311735B (en) | Ship piping weld data management method and device, readable storage medium and terminal | |
| CN101981575B (en) | Method and apparatus for copying objects in an object-oriented environment using a multiple-transaction technique | |
| CN111368368B (en) | Method and device for constructing ship piping component library, storage medium and terminal | |
| CN111143478A (en) | Two-three-dimensional file association method based on lightweight model and engineering object bit number | |
| CN101915583A (en) | Road indexing method applied to dynamic traffic information processing | |
| CN110362596A (en) | A kind of control method and device of text Extracting Information structural data processing | |
| CN112948911A (en) | System and method for converting S3D bridge model into MapGIS model | |
| CN109582726A (en) | The treating method and apparatus of tables of data | |
| CN112464402B (en) | Automatic pipeline batching method based on E3D software | |
| CN112948510B (en) | Construction method of knowledge graph in media industry | |
| CN112182871A (en) | System and method for converting three-dimensional pipeline model into MapGIS model | |
| CN112199808B (en) | System and method for quickly designing ship pipeline | |
| CN101388018A (en) | Computer aided design document management method | |
| CN116167365A (en) | Flow chart generation method based on form template | |
| CN109388685B (en) | Method and device for warehousing spatial data used by planning industry | |
| CN113791594B (en) | Configuration establishing method, system, equipment and medium of distributed control system | |
| CN116861602A (en) | Method and device for checking comprehensive pipe network topology structure | |
| WO2016119508A1 (en) | Method for recognizing large-scale objects based on spark system | |
| CN115186312A (en) | Method for automatically generating cable pipe-burying section view through CAD | |
| CN113245757A (en) | Information management method for oil-gas module process pipeline welding seam | |
| CN103605849A (en) | Implementation method for linkage computing in product design analysis and development environment | |
| CN105224596A (en) | A kind of method of visit data and device | |
| CN109800425A (en) | A kind of semantic missing automatic error-correcting processing method and system of cross-platform information exchange | |
| CN118095805B (en) | Method, system, equipment, medium and product for predicting early-stage materials of nuclear power instrument control cabinet |
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 |