CN103631980A - Engineering intelligent design system - Google Patents
Engineering intelligent design system Download PDFInfo
- Publication number
- CN103631980A CN103631980A CN201210307834.8A CN201210307834A CN103631980A CN 103631980 A CN103631980 A CN 103631980A CN 201210307834 A CN201210307834 A CN 201210307834A CN 103631980 A CN103631980 A CN 103631980A
- Authority
- CN
- China
- Prior art keywords
- module
- file
- inventory
- attribute
- checked
- 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
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000004069 differentiation Effects 0.000 claims description 3
- 239000000463 material Substances 0.000 claims description 3
- 238000000034 method Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012946 outsourcing Methods 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000005422 blasting Methods 0.000 description 1
- 230000001680 brushing effect Effects 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an engineering intelligent design system which comprises a graphic module, an information identification and acquisition module, a modularized database, an information checking and file generating module and a data calculating and BOM generating module. According to the engineering intelligent design system, the plane graphs of multiple cabinet bodies can be transformed into the BOM of single cabinet body at one time, work which needs more than two hours to be finished when the BOM is originally made manually can be completed in a few minutes, work time can be shortened, efficiency is improved greatly, and data are accurate.
Description
Technical field
The present invention relates to a kind of engineering intelligent design system, relate in particular to a kind of engineering intelligent design system that the modular planar effect picture going out with two-dimensional pattern drafting is generated automatically to cabinet inventory.
Background technology
At present, after designer skillfully grasps cabinet configuration, generally by checking cabinet planimetric map, open item by item the inventory of every cabinet part that body comprises, common every cabinet body is at least consuming time more than 15 minutes, and in order to complete generation task, on average everyone has at least needed the design of 10 cabinet bodies, in order to complete the cabinet of 10, only going out BOM inventory will be consuming time nearly 3 hours.Owing to containing much information, also often there will be some mistakes, give and produce and bring delivery date negative effect.
Summary of the invention
The problem existing for above-mentioned prior art, the object of the invention is to provide a kind of engineering intelligent design system, graph data is passed through to the support of program and database, derive cabinet inventory, reduce designer's working strength, efficiency also improves greatly simultaneously, and accuracy rate also gets a promotion.
Technical scheme of the present invention is: a kind of engineering intelligent design system, and this system comprises figure module, information identification and acquisition module, module database, information is checked and file generating module and data calculating and BOM inventory generation module, wherein:
Figure module is predefined graph block in planar graph software;
Information identification and acquisition module, identify and be converted to separate unit cabinet attribute by the word in the planimetric map that comprises a plurality of cabinets and figure module;
Module database, it is the file by module making, the title of each module is different, and the information such as title, specification, unit, quantity, material code, classification that includes different parts in each module, whether the selection of module is the property control comprising by each module, the attribute comprising in each module respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should;
Information is checked and file generating module, all separate unit cabinet attributes are checked in module database, generated the file of the contained module title of each separate unit cabinet and required module number and the needed module data library file of all cabinets that planimetric map comprises;
Data are calculated and BOM inventory generation module, data in the needed module data library file of all cabinets that the file of the contained module title of each separate unit cabinet and required module number and planimetric map are comprised are calculated by module and module number, then by cabinet number, the data of separate unit cabinet are saved as to independent BOM inventory file.
As preferably, this system also comprises inventory conversion module, the BOM inventory file of all cabinets that comprise in planimetric map is converted into the program of operation inventory file.
As preferably, this system also comprises configuration list and Pricedata and information is checked and inventory generation module, wherein:
Configuration list and Pricedata, wherein include configuration module, each configuration module is to there being the price data of associated, whether the selection of each configuration module is also the property control by comprising in it, the attribute comprising in each configuration information respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should;
Information is checked and inventory generation module, and strike price inventory file is checked and generated to separate unit cabinet attribute and configuration list and Pricedata.
As preferably, this system also comprises that inventory is checked and generation module, and strike price inventory file and operation inventory file are checked and generated pre-shopping list file.
As preferably, each module in module database is controlled by a plurality of attribute conditions, adopts with door or door and not gate condition and carries out the differentiation of intermodule.
The invention has the beneficial effects as follows: this system can be disposable by many cabinets body plane figure (individual drawing, by coordinate, distinguish each cabinet body) be converted into separate unit cabinet BOM, by originally manually going out BOM inventory, needed above work in 2 hours to foreshorten in a few minutes to complete, not only efficiency improves greatly, and data are accurate; Also can in 1 minute, derive configuration list and schedule of prices simultaneously; The drawing designing and BOM inventory can be uploaded to system assigned catalogue by a key, other authorized persons can check at any time and download, and have simplified and have uploaded and method for down loading, have promoted work efficiency simultaneously, also can immediately grasp sequence information simultaneously.。
Accompanying drawing explanation
Fig. 1 is the process flow diagram that the present invention generates separate unit cabinet BOM inventory and operation inventory;
Fig. 2 is the process flow diagram that the present invention generates strike price inventory and pre-shopping list;
Fig. 3 is an example of the planimetric map of the cabinet arrangement of employing CAXA Software on Drawing;
Fig. 4 is the Local map of an example of module database;
Fig. 5 is for being converted into planimetric map the Local map of the example of TXT property file;
Fig. 6 is the Local map of an example of all separate unit cabinet attributes;
Fig. 7 is the Local map of an example of the file of the contained module title of each separate unit cabinet and required module number;
Fig. 8 is the Local map of an example of the needed module data library file of all cabinets that comprises of planimetric map;
Fig. 9 is the Local map of an example of the BOM inventory of single cabinet;
Figure 10 is the Local map of an example of strike price inventory.
Embodiment
As one embodiment of the present invention, as shown in Figure 1, a kind of engineering intelligent design system, run in computing machine, this system comprises figure module, information identification and acquisition module, module database, information is checked and file generating module, data calculating and BOM inventory generation module and inventory conversion module, wherein:
Figure module, is predefined graph block in planar graph software, selects CAXA software to carry out the establishment of figure module in the present embodiment, and in each figure module, definition has figure title and specification attribute.
Before utilizing native system work, must first carry out the making of the planimetric map of cabinet arrangement, the primary system figure that planimetric map provides according to client, the figure module of in CAXA software, needs being chosen combines, then add some Word messages, the cabinet attribute that some cannot represent with figure module is described.The required attribute of cabinet singly can not represent with figure module, can represent with Word message yet, is an example that adopts the planimetric map that the cabinet of CAXA Software on Drawing arranges as shown in Figure 3.
Information identification and acquisition module, identify and be converted to separate unit cabinet attribute by the Word message in the planimetric map that comprises a plurality of cabinets and figure module.The information that separate unit cabinet attribute kit designs containing influential this cabinet of this cabinet body institute (as cabinet type, cabinet is wide, cabinet is dark, cabinet is high, cup degree of depth, switch model etc.).Every cabinet body has and must have this module of framework, anchor point is fixed on to the position, the upper left corner of figure in graphical definition, specification is the width of figure, and during outline draught, framework figure is impossible overlapping, and all figure and words that are in framework figure all belong to this cabinet body.The frame module that is the separate unit cabinet in planimetric map comprises a region, it is all that all figure modules in this region and Word message all belong to this cabinet body, the graphic file of planimetric map is chosen, derive TXT file, the coordinate information and the defined attribute information that in TXT file, comprise each figure and Word message, identify and acquisition module analysis can draw whole separate unit cabinet attributes by information.The attribute of cabinet is created in same attribute list file by the gross, and by attribute list cabinet field, distinguishing this attribute, to belong to which cabinet all.
Module database, it is the file by module making, the title of each module is different, and the information such as title, specification, unit, quantity, material code, classification that includes different parts in each module, whether the selection of module is the property control comprising by each module, the attribute comprising in each module respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should, each module is controlled by a plurality of attribute conditions, and employing and door or door and not gate condition are carried out the differentiation of intermodule.The Local map of an example of module database as shown in Figure 4.
Information is checked and file generating module, all separate unit cabinet attributes (comprising the attribute list file of cabinet attribute by the gross) are checked in module database, generated the file of the contained module title of each separate unit cabinet and required module number and the needed module data library file of all cabinets that planimetric map comprises; The content of the needed module data library file of all cabinets that the file of the contained module title of each separate unit cabinet and required module number and planimetric map comprise can be modified as required.
Data are calculated and BOM inventory generation module, data in the needed module data library file of all cabinets that the file of the contained module title of each separate unit cabinet and required module number and planimetric map are comprised are calculated by module and module number, then by cabinet number, the data of separate unit cabinet are saved as to independent BOM inventory file.
Inventory conversion module, is converted into the BOM inventory file of all cabinets that comprise in planimetric map the program of operation inventory file.
Described information identification and acquisition module, information is checked and file generating module, data are calculated and BOM inventory generation module and inventory conversion module are the software programs that adopts easy language and VBA to write.
In the time need to carrying out the work of BOM inventory generation, first with CAXA software, open planimetric map, as shown in Figure 5, required cabinet is partly chosen and is converted into TXT property file, then by native system program, read TXT file content, by coordinate position, identify any cabinet body under all module attributes and word attribute, and the good cabinet number of mark, realization is converted into planimetric map data the attribute information of all separate unit cabinets, then according to the attribute information of all separate unit cabinets (being the Local map of an example of all separate unit cabinet attributes as shown in Figure 6), in module database, search respective modules, draw the contained module title of every cabinet body and required module number (being the Local map of an example of the file of the contained module title of each separate unit cabinet and required module number as shown in Figure 7), also extract this batch of needed module database of cabinet (being the Local map of an example of the needed module data library file of all cabinets that comprises of planimetric map as shown in Figure 8) simultaneously, then program is calculated data by module and module number, then by cabinet number, the data of separate unit cabinet are saved as to independent BOM inventory file (being the Local map of an example of the BOM inventory of single cabinet as shown in Figure 9).The inventory conversion module of follow-up operation can arrange the BOM inventory file of each cabinet generating in same sheet of planar figure, by program, by BOM invoice summary, is merged and generates an operation inventory file.
On above basis, as shown in Figure 2, increase configuration list and Pricedata in system, information is checked and inventory generation module and inventory is checked and generation module, wherein:
Configuration list and Pricedata, wherein include some the essential and optional configuration modules in cabinet, and each configuration module is to there being the price data of associated; Whether the selection of each configuration module is also the property control by comprising in it, the attribute comprising in each configuration information respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should, each configuration module is controlled by a plurality of attribute conditions, and same employing and door or door and not gate condition are distinguished.The Local map of an example of module database as shown in Figure 4.
Information is checked and inventory generation module, the attribute conditions and the separate unit cabinet attribute that in configuration list and Pricedata, one by one configuration module are comprised are compared, find out the required configuration module of every cabinet body and configuration module quantity, identical configuration module quantity is merged, so just obtain the configuration of cabinet by the gross, then according to configuration list and Pricedata, find out corresponding configuration rates, all configuration rates are merged and just can draw strike price list.The content of strike price inventory can be modified as required.
Inventory is checked and generation module, and strike price inventory and operation inventory are checked to the pre-shopping list of generation, and the content of pre-shopping list can be modified as required.
Information is checked and inventory generation module and inventory is checked and generation module is also the software program that adopts easy language and VBA to write.Equally first program is identified by information and acquisition module is realized the attribute information that planimetric map data is converted into cabinet, then according to cabinet attribute information, in configuration list and Pricedata, search corresponding configuration module, draw corresponding configuration module quantity, in configuration list and Pricedata, search dutiable value, thereby draw configuration list and price, being strike price inventory file, is the Local map of an example of strike price inventory as shown in figure 10.The inventory of follow-up operation is checked and generation module is checked strike price inventory file and the operation inventory file generating above, according to classification, the part that by classification is for example P or PS decomposes plastic-blasting part list, the part of D or DS is decomposed to galvanized part list, the part of Y or YS is decomposed to outsourcing piece list, the part that contains S is decomposed to loose mail list.The row of stock's part in outsourcing piece list is hidden, and (according to part name, brushing choosing) just obtains needing the pre-shopping list of pre-buying part.
System can also be uploaded to system assigned catalogue by a key by the drawing designing and BOM inventory, and other authorized persons can check at any time and download, and simplifies and uploads and method for down loading, has promoted work efficiency, also can immediately grasp sequence information simultaneously.By program in FTP per year, month set up corresponding document and press from both sides, and then by program, Single document is directly uploaded in FTP corresponding folder, a plurality of files if, file is packed by program, be uploaded to again in FTP corresponding folder, file name is all O/No., and the suffix name of different files is different.O/No. wherein specific fields comprises year, month, day information, and last three fields are serial code, so not only guarantees that O/No. can not repeat, and can find out when this order produces according to O/No..By FTP authority, arrange, can specify authorized person to have download permission, as long as the corresponding order coding of input, program can be found out corresponding all these order files, and select File can be realized download.
Claims (5)
1. an engineering intelligent design system, is characterized in that: this system comprises figure module, information identification and acquisition module, module database, information is checked and file generating module and data calculating and BOM inventory generation module, wherein:
Figure module is predefined graph block in planar graph software;
Information identification and acquisition module, identify and be converted to separate unit cabinet attribute by the word in the planimetric map that comprises a plurality of cabinets and figure module;
Module database, it is the file by module making, the title of each module is different, and the information such as title, specification, unit, quantity, material code, classification that includes different parts in each module, whether the selection of module is the property control comprising by each module, the attribute comprising in each module respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should;
Information is checked and file generating module, all separate unit cabinet attributes are checked in module database, generated the file of the contained module title of each separate unit cabinet and required module number and the needed module data library file of all cabinets that planimetric map comprises;
Data are calculated and BOM inventory generation module, data in the needed module data library file of all cabinets that the file of the contained module title of each separate unit cabinet and required module number and planimetric map are comprised are calculated by module and module number, then by cabinet number, the data of separate unit cabinet are saved as to independent BOM inventory file.
2. engineering intelligent design system according to claim 1, is characterized in that: this system also comprises inventory conversion module, the BOM inventory file of all cabinets that comprise in planimetric map is converted into the program of operation inventory file.
3. engineering intelligent design system according to claim 2, is characterized in that: this system also comprises configuration list and Pricedata and information is checked and inventory generation module, wherein:
Configuration list and Pricedata, wherein include configuration module, each configuration module is to there being the price data of associated, whether the selection of each configuration module is also the property control by comprising in it, the attribute comprising in each configuration information respectively with planimetric map in the attribute of figure module and the Attribute Relative of Word message should;
Information is checked and inventory generation module, and strike price inventory file is checked and generated to separate unit cabinet attribute and configuration list and Pricedata.
4. engineering intelligent design system according to claim 3, is characterized in that: this system also comprises that inventory is checked and generation module, and strike price inventory file and operation inventory file are checked to the pre-shopping list file of generation.
5. according to the engineering intelligent design system described in claim 1,2,3 or 4, it is characterized in that: each module in module database is controlled by a plurality of attribute conditions, employing and door or door and not gate condition are carried out the differentiation of intermodule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210307834.8A CN103631980B (en) | 2012-08-28 | 2012-08-28 | Engineering intelligent design system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210307834.8A CN103631980B (en) | 2012-08-28 | 2012-08-28 | Engineering intelligent design system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103631980A true CN103631980A (en) | 2014-03-12 |
| CN103631980B CN103631980B (en) | 2016-12-21 |
Family
ID=50213021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210307834.8A Active CN103631980B (en) | 2012-08-28 | 2012-08-28 | Engineering intelligent design system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103631980B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111985015A (en) * | 2020-08-17 | 2020-11-24 | 四川九立微波有限公司 | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function |
| CN112801609A (en) * | 2021-01-19 | 2021-05-14 | 深圳市墨工智云科技有限公司 | System for managing data and working in coordination based on BOM |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920835A (en) * | 2005-08-26 | 2007-02-28 | 鸿富锦精密工业（深圳）有限公司 | Materials list generation system and method |
| CN1959709A (en) * | 2005-11-02 | 2007-05-09 | 鸿富锦精密工业（深圳）有限公司 | System and method for creating list of materiel |
| CN101013451A (en) * | 2007-01-31 | 2007-08-08 | 济南二机床集团有限公司 | Automatic generation system for designing BOM |
| CN201707670U (en) * | 2010-05-18 | 2011-01-12 | 财团法人数位艺术基金会 | Two-dimensional image object molding system |
| KR101087197B1 (en) * | 2009-01-16 | 2011-11-29 | 현대로템 주식회사 | The method of linking computer aided design system with product data management system in real time |
-
2012
- 2012-08-28 CN CN201210307834.8A patent/CN103631980B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920835A (en) * | 2005-08-26 | 2007-02-28 | 鸿富锦精密工业（深圳）有限公司 | Materials list generation system and method |
| CN1959709A (en) * | 2005-11-02 | 2007-05-09 | 鸿富锦精密工业（深圳）有限公司 | System and method for creating list of materiel |
| CN101013451A (en) * | 2007-01-31 | 2007-08-08 | 济南二机床集团有限公司 | Automatic generation system for designing BOM |
| KR101087197B1 (en) * | 2009-01-16 | 2011-11-29 | 현대로템 주식회사 | The method of linking computer aided design system with product data management system in real time |
| CN201707670U (en) * | 2010-05-18 | 2011-01-12 | 财团法人数位艺术基金会 | Two-dimensional image object molding system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111985015A (en) * | 2020-08-17 | 2020-11-24 | 四川九立微波有限公司 | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function |
| CN112801609A (en) * | 2021-01-19 | 2021-05-14 | 深圳市墨工智云科技有限公司 | System for managing data and working in coordination based on BOM |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103631980B (en) | 2016-12-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104866599B (en) | The production method and system of Visual Report Forms | |
| Montevechi et al. | Conceptual modeling in simulation projects by mean adapted IDEF: an application in a Brazilian tech company | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| Müller et al. | Lean information and communication tool to connect shop and top floor in small and medium-sized enterprises | |
| Jung et al. | Real-time data-driven discrete-event simulation for garment production lines | |
| CN103020750A (en) | Process report generation method and device | |
| CN106919625A (en) | A kind of internet customer attribute recognition methods and device | |
| CN105160462A (en) | Reinforcement raw material information automatic integration apparatus and method for prefabricated concrete member | |
| CN106408435A (en) | Process compiling system and process compiling method | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| Bevilacqua et al. | Visual Management implementation and evaluation through mental workload analysis. | |
| Chiarini | A comparison between time-driven activity-based costing and value stream accounting in a lean Six Sigma manufacturing case study | |
| CN103218448A (en) | Self-service report generating method, device and system | |
| CN107239923B (en) | Method and device for generating material application form | |
| Denkena et al. | Efficient generation of a digital twin using object detection for data acquisition and XML-interface for model creation | |
| CN106372802A (en) | Construction method for manufacturing object tree | |
| CN103631980A (en) | Engineering intelligent design system | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN115048396A (en) | Bill processing method and device | |
| Lin et al. | Development of the digital model of the jewellery production process for resource optimisation and prediction | |
| Hung et al. | Applying group technology to the forging industry | |
| Li | Simulation study of coordinating layout change and quality improvement for adapting job shop manufacturing to CONWIP control | |
| CN105630997A (en) | Data parallel processing method, device and equipment | |
| Marques et al. | Towards a requirements traceability process centered on the traceability model | |
| Chwastyk et al. | Integration CAD/CAPP/CAM systems in design process of innovative products |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20170314 Address after: Pixian 610000 Sichuan Province, Chengdu city Chengdu industrial area north of the four Hong Kong Modern North Road No. 555 Patentee after: Wankong Technology (Chengdu) Co., Ltd. Address before: Pixian 610000 Sichuan Province, Chengdu city Chengdu modern industrial area four North Road north of Hong Kong Patentee before: Wankong Group (Chengdu) Electric Co., Ltd. |
|
| TR01 | Transfer of patent right | ||
| 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: Engineering intelligent design system Effective date of registration: 20191022 Granted publication date: 20161221 Pledgee: Chengdu SME financing Company Limited by Guarantee Pledgor: Wankong Technology (Chengdu) Co., Ltd. Registration number: Y2019510000040 |
|
| PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Date of cancellation: 20201015 Granted publication date: 20161221 Pledgee: Chengdu SME financing Company Limited by Guarantee Pledgor: WECOME TECHNOLOGY (CHENGDU) Co.,Ltd. Registration number: Y2019510000040 |
|
| 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: Engineering intelligent design system Effective date of registration: 20201030 Granted publication date: 20161221 Pledgee: Chengdu SME financing Company Limited by Guarantee Pledgor: WECOME TECHNOLOGY (CHENGDU) Co.,Ltd. Registration number: Y2020980007376 |