CN105488271A - Automatic matching method for oil gas module section steel - Google Patents
Automatic matching method for oil gas module section steel Download PDFInfo
- Publication number
- CN105488271A CN105488271A CN201510852403.3A CN201510852403A CN105488271A CN 105488271 A CN105488271 A CN 105488271A CN 201510852403 A CN201510852403 A CN 201510852403A CN 105488271 A CN105488271 A CN 105488271A
- Authority
- CN
- China
- Prior art keywords
- database
- oil gas
- gas module
- designing
- surplus
- 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.)
- Granted
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
Landscapes
- Physics & Mathematics (AREA)
- Geometry (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Pure & Applied Mathematics (AREA)
- Mathematical Optimization (AREA)
- Mathematical Analysis (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Computational Mathematics (AREA)
- Warehouses Or Storage Devices (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses an automatic matching method for oil gas module section steel. The automatic matching method comprises the following steps: a first step, outputting a design material information report of the oil gas module based on an oil gas module design module by means of a report output function of Tekla design software; meanwhile, using Visual Basic to establish an oil gas module section steel matching platform; establishing an oil gas module section steel inventory database based on SQL Server, wherein the oil gas module section steel inventory database comprises a standard piece database, a standard section steel material database and a remaining material inventory database; and a second step, importing the design material information report of the oil gas module into the oil gas module section steel matching platform to match materials for the design material. By adopting the method, a large amount of manpower sources are saved in the entire process, and the material selection is more reasonable, thus the materials are saved.
Description
Technical field
The present invention relates to matching process, particularly relate to oil gas module shaped steel automatic matching method.
Background technology
China in Recent Years rapid economic development, the manufacture demand of complex hydrocarbon module is increasing, assume responsibility for the production task of a large amount of oil gas module as China of world's factory simultaneously.Larger hydrocarbon module general structure is comparatively complicated, module build in shaped steel kind used, shape various.In present stage oil gas module building course, designer manually carries out the distribution of building required shaped steel according to the model designed in TEKLA.Not of uniform size because building required shaped steel, adopt manual allocation material efficiency lower, and often can not distribute optimal material because energy is limited, cause the waste of manpower and materials.
Summary of the invention
The object of the invention is to the deficiency overcoming prior art, one safe and convenient, reliable, efficient oil gas module shaped steel automatic matching method is more provided.
In order to achieve the above object, the technical solution used in the present invention is:
A kind of oil gas module shaped steel automatic matching method, it comprises the following steps:
Step one, utilize the report output function of Tekla design software based on oil gas module design a model export this oil gas module designing material information report; Use VisualBasic to set up oil gas module shaped steel Matching Platform simultaneously; And set up oil gas module shaped steel inventory database based on SQLServer, described oil gas module shaped steel inventory database comprises standard part database, standard steel section material database and surplus material inventory database;
Step 2, by oil gas module designing material information report import described in oil gas module match materials platform be designing material matching materials, concrete steps are: the coupling of (1) standard component: first designing material information report and database Plays event data storehouse are contrasted, pick out the standard component related material information of contained standard component also described in output in designing material information report, generate standard component outbound list, if some standard component is not enough, then generate standard component buying order simultaneously; (2) match materials of non-standard component: with surplus, designing material information report non-standard component material requested is expected that the processing of inventory database remains material and contrasts, extracts qualified surplus material and marks and generate surplus material outbound list; If do not have qualified processing to remain material, with the standard steel section material contrast in standard steel section material database, shaped steel qualified in standard steel section material database is extracted and marks and generate stock material outbound list; Designing material information report back warp cross twice Auto-matching still do not have Available Material for lacking stock, generate non-standard component order specifics.
Compared with prior art, the present invention has following beneficial effect:
Oil gas module complex structure, required shaped steel kind, shape are various.The shaped steel Auto-matching of the present invention by using oil gas module Distribution of materials platform to complete oil gas module.Replace the mode of original manual allocation shaped steel.Manual allocation material means efficiency is lower, and often can not distribute optimal material because energy is limited.By the present invention, designing material and company's stock material have been compared the distribution of material, whole process saves a large amount of human resources, and selection is more reasonable, saves material.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of a kind of oil gas module shaped steel automatic matching method of the present invention.
Embodiment
Describe the present invention below in conjunction with specific embodiment.
Of the present invention a kind of oil gas module shaped steel automatic matching method as shown in Figure 1, it comprises the following steps:
Step one, utilize the report output function of Tekla design software based on oil gas module design a model export this oil gas module designing material information report, designing material information report comprises the material informations such as shaped steel material, specification, length; Use VisualBasic to set up oil gas module shaped steel Matching Platform simultaneously; And set up oil gas module shaped steel inventory database based on SQLServer, described oil gas module shaped steel inventory database comprises standard part database, standard steel section material database and surplus material inventory database;
Step 2, by oil gas module designing material information report import described in oil gas module match materials platform be designing material matching materials, concrete steps are: the coupling of (1) standard component: first designing material information report and database Plays event data storehouse are contrasted, pick out the standard component related material information of contained standard component also described in output in designing material information report, generate standard component outbound list, if some standard component is not enough, then generate standard component buying order simultaneously; (2) match materials of non-standard component: with surplus, designing material information report non-standard component material requested is expected that the processing of inventory database remains material and contrasts, extracts qualified surplus material and marks and generate surplus material outbound list; If do not have qualified processing to remain material, with the standard steel section material contrast in standard steel section material database, shaped steel qualified in standard steel section material database is extracted and marks and generate stock material outbound list; Designing material information report back warp cross twice Auto-matching still do not have Available Material for lacking stock, generate non-standard component order specifics.
In described step 2, the match materials method of non-standard component comprises the following steps:
A () first to read in designing material information report often row material information data one by one with VisualBasic, comprise the material informations such as the material of required shaped steel, specification, length, and by these information stored in local access database;
B () reads the material information such as material, specification, length of the first row data in access database;
Be not labeled as every bar data of Y in (c) traversal surplus material inventory database, select the surplus material that material, specification and length identical with this row designing material is greater than this designing material; If there is qualified surplus material, that the surplus material selecting length in these surplus material minimum is as the shaped steel of this designing material Auto-matching, and marking this surplus material is Y, and this surplus material information is expected library database stored in surplus; If there is no qualified surplus material, then perform step (d);
Be not labeled as every bar data of K in (d) traversal standard steel section material database, select the stock material that material, specification and length identical with this row designing material is greater than this designing material; If there is qualified stock material, that material selecting length in these stock material minimum is as the shaped steel of this designing material Auto-matching, and marking this strip material is K, and this stock material information is gone out library database stored in stock material; If there is no qualified surplus material, then perform step (e);
If e () does not all have suitable material through twice coupling, then this designing material is labeled as Q stored in back-order data storehouse;
F () reads next line data in access database, and step (c)-(e) described in repeating; If next line data are empty in designing material database, then perform step (g);
(g) by the material being labeled as Y, K, Q respectively from surplusly expecting library database, stock material goes out library database and back-order data storehouse is derived, and generates surplus material outbound list, stock material outbound list and non-standard component order specifics.
Claims (2)
1. an oil gas module shaped steel automatic matching method, is characterized in that, it comprises the following steps:
Step one, utilize the report output function of Tekla design software based on oil gas module design a model export this oil gas module designing material information report; Use VisualBasic to set up oil gas module match materials platform simultaneously; And set up oil gas module shaped steel inventory database based on SQLServer, described oil gas module shaped steel inventory database comprises standard part database, standard steel section material database and surplus material inventory database;
Step 2, by oil gas module designing material information report import described in oil gas module match materials platform be designing material matching materials, concrete steps are: the coupling of (1) standard component: first designing material information report and database Plays event data storehouse are contrasted, pick out the standard component related material information of contained standard component also described in output in designing material information report, generate standard component outbound list, if some standard component is not enough, then generate standard component buying order simultaneously; (2) match materials of non-standard component: with surplus, designing material information report non-standard component material requested is expected that the processing of inventory database remains material and contrasts, extracts qualified surplus material and marks and generate surplus material outbound list; If do not have qualified processing to remain material, with the standard steel section material contrast in standard steel section material database, shaped steel qualified in standard steel section material database is extracted and marks and generate stock material outbound list; Designing material information report back warp cross twice Auto-matching still do not have Available Material for lacking stock, generate non-standard component order specifics.
2. oil gas module shaped steel automatic matching method according to claim 1, is characterized in that: in described step 2, the match materials method of non-standard component comprises the following steps:
A () first to read in designing material information report often row material information data one by one with VisualBasic, and by these information stored in local access database;
B () reads the material information of the first row data in access database;
Be not labeled as every bar data of Y in (c) traversal surplus material inventory database, select the surplus material that material, specification and length identical with this row designing material is greater than this designing material; If there is qualified surplus material, that the surplus material selecting length in these surplus material minimum is as the shaped steel of this designing material Auto-matching, and marking this surplus material is Y, and this surplus material information is expected library database stored in surplus; If there is no qualified surplus material, then perform step (d);
Be not labeled as every bar data of K in (d) traversal standard steel section material database, select the stock material that material, specification and length identical with this row designing material is greater than this designing material; If there is qualified stock material, that material selecting length in these stock material minimum is as the shaped steel of this designing material Auto-matching, and marking this strip material is K, and this stock material information is gone out library database stored in stock material; If there is no qualified surplus material, then perform step (e);
If e () does not all have suitable material through twice coupling, then this designing material is labeled as Q stored in back-order data storehouse;
F () reads next line data in access database, and step (c)-(e) described in repeating; If next line data are empty in designing material database, then perform step (g);
(g) by the material being labeled as Y, K, Q respectively from surplusly expecting library database, stock material goes out library database and back-order data storehouse is derived, and generates surplus material outbound list, stock material outbound list and non-standard component order specifics.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510852403.3A CN105488271B (en) | 2015-11-27 | 2015-11-27 | A kind of oil gas module shaped steel automatic matching method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510852403.3A CN105488271B (en) | 2015-11-27 | 2015-11-27 | A kind of oil gas module shaped steel automatic matching method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105488271A true CN105488271A (en) | 2016-04-13 |
CN105488271B CN105488271B (en) | 2018-05-25 |
Family
ID=55675245
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510852403.3A Active CN105488271B (en) | 2015-11-27 | 2015-11-27 | A kind of oil gas module shaped steel automatic matching method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105488271B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111986318A (en) * | 2020-09-04 | 2020-11-24 | 广州德宇科技有限公司 | Method and device for selecting steel to be processed |
CN112464402A (en) * | 2020-11-24 | 2021-03-09 | 博迈科海洋工程股份有限公司 | Automatic pipeline batching method based on E3D software |
CN113704847A (en) * | 2021-08-18 | 2021-11-26 | 武汉武建机械施工有限公司 | Lacing plate welding spot calculation method, system and terminal of foundation pit lacing plate type four-limb lattice column |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030009727A1 (en) * | 2000-11-09 | 2003-01-09 | Fujitsu Limited | Circuit designing apparatus, circuit designing method and timing distribution apparatus |
CN102521459A (en) * | 2011-12-16 | 2012-06-27 | 武汉武船信息集成有限公司 | Automatic sheet metal part integrated nesting system and method thereof |
CN103279613A (en) * | 2013-05-30 | 2013-09-04 | 南京航空航天大学 | Automatic matching method for high-precision complex product assembling materials |
CN104794597A (en) * | 2014-01-17 | 2015-07-22 | 上海江南长兴重工有限责任公司 | Ship steel supply and demand management system |
-
2015
- 2015-11-27 CN CN201510852403.3A patent/CN105488271B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030009727A1 (en) * | 2000-11-09 | 2003-01-09 | Fujitsu Limited | Circuit designing apparatus, circuit designing method and timing distribution apparatus |
CN102521459A (en) * | 2011-12-16 | 2012-06-27 | 武汉武船信息集成有限公司 | Automatic sheet metal part integrated nesting system and method thereof |
CN103279613A (en) * | 2013-05-30 | 2013-09-04 | 南京航空航天大学 | Automatic matching method for high-precision complex product assembling materials |
CN104794597A (en) * | 2014-01-17 | 2015-07-22 | 上海江南长兴重工有限责任公司 | Ship steel supply and demand management system |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111986318A (en) * | 2020-09-04 | 2020-11-24 | 广州德宇科技有限公司 | Method and device for selecting steel to be processed |
CN112464402A (en) * | 2020-11-24 | 2021-03-09 | 博迈科海洋工程股份有限公司 | Automatic pipeline batching method based on E3D software |
CN113704847A (en) * | 2021-08-18 | 2021-11-26 | 武汉武建机械施工有限公司 | Lacing plate welding spot calculation method, system and terminal of foundation pit lacing plate type four-limb lattice column |
Also Published As
Publication number | Publication date |
---|---|
CN105488271B (en) | 2018-05-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105389402A (en) | Big-data-oriented ETL (Extraction-Transformation-Loading) method and device | |
CN105069524B (en) | Planned dispatching optimization method based on big data analysis | |
CN108564336B (en) | Substation installation project construction drawing identification and budgeting method and system | |
CN103631763A (en) | Multi-people cooperation type large-size document editing device and method | |
CN104346143A (en) | Data conversion method from EBOM (Engineering Bill of Material) to MBOM (Maintenance Bill of Material) | |
CN105488271A (en) | Automatic matching method for oil gas module section steel | |
CN101013451A (en) | Automatic generation system for designing BOM | |
CN104484558A (en) | Method and system for automatically generating analysis reports of biological information projects | |
Hosseini et al. | Flow production of construction processes through implementing lean construction principles and simulation | |
CN103455896A (en) | Paperless assembling quality control method based on internet of things | |
CN105574660A (en) | Supplier evaluation and analysis system | |
CN104217306A (en) | Computer modeling method of full operation flow based on structuralization | |
CN107943968A (en) | The structuring processing method of construction information list data | |
CN106372802A (en) | Construction method for manufacturing object tree | |
CN105653761A (en) | Method for automatically obtaining amount of batch outfititem jacking parts | |
CN105912723A (en) | Storage method of custom field | |
CN104361086A (en) | Data integration method for measurable asset entire life-cycle management system | |
CN108121874A (en) | A kind of bus parameter bill of materials and process route automatic generation method | |
Château et al. | Economic implications of the IEA efficient world scenario | |
Wesumperuma et al. | Green activity based management (ABM) for organisations | |
CN112116322A (en) | Three-dimensional design-based method and system for quickly and accurately compiling construction cost of power transformation project | |
CN113590599B (en) | Data checking method based on complex data environment | |
CN107316164A (en) | Repetition outage analysis method based on fuzzy matching | |
CN102760189A (en) | Automatic outputting method of electric transmission line house distribution map | |
CN102855227B (en) | Document processing system and method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |