CN103631980B - Engineering intelligent design system - Google Patents
Engineering intelligent design system Download PDFInfo
- Publication number
- CN103631980B CN103631980B CN201210307834.8A CN201210307834A CN103631980B CN 103631980 B CN103631980 B CN 103631980B CN 201210307834 A CN201210307834 A CN 201210307834A CN 103631980 B CN103631980 B CN 103631980B
- Authority
- CN
- China
- Prior art keywords
- module
- file
- inventory
- attribute
- cabinet
- 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
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000004069 differentiation Effects 0.000 claims description 3
- 238000000034 method Methods 0.000 description 2
- 238000012946 outsourcing Methods 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000005422 blasting Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of engineering intelligent design system, this system includes that figure module, information identification and acquisition module, module database, information are checked and file generating module and data calculate and BOM inventory generation module.Multiple stage cabinet plane graph disposably can be converted into separate unit cabinet BOM by this system, needs the work of more than 2 hours to complete in can foreshortening to a few minutes by originally manually going out BOM inventory, and not only efficiency is greatly improved, and data are accurate.
Description
Technical field
The present invention relates to a kind of engineering intelligent design system, particularly relate to a kind of engineering intelligent design system that the modular planar effect picture gone out with two-dimensional pattern drafting is automatically generated out cabinet inventory.
Background technology
At present, after designer's grasp skilled to cabinet configuration, general by checking cabinet plane graph, open the inventory of every comprised part of cabinet body item by item, the most time-consuming more than 15 minutes of the most every cabinet body, in order to complete generation task, averagely 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 the most nearly 3 hours.Owing to containing much information, some mistakes the most often occur, give and produce and be negatively affected date of delivery.
Summary of the invention
The problem existed for above-mentioned prior art, present invention aim at providing a kind of engineering intelligent design system, by graph data by program and the support of data base, derive cabinet inventory, reducing designer's working strength, efficiency is also greatly improved simultaneously, and accuracy rate also gets a promotion.
The technical scheme is that a kind of engineering intelligent design system, this system includes that figure module, information identification and acquisition module, module database, information are checked and file generating module and data calculate and BOM inventory generation module, wherein:
Figure module, is predefined graph block in planar graph software；
Information identification and acquisition module, word and figure module in the plane graph that will comprise multiple cabinet are identified and are converted to separate unit cabinet attribute；
Module database, it is by the file of module making, the title of each module is different, and in each module, include the information such as the different title of part, specification, unit, quantity, COM code, classifications, whether the selection of module is the property control by comprising in each module, and the attribute comprised in each module respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message；
Information is checked and file generating module, is checked by all separate unit cabinet attributes, generate the module data library file required for all cabinets that module title and the file of required module number and plane graph contained by each separate unit cabinet comprise in module database；
Data calculate and BOM inventory generation module, the data in module data library file required for all cabinets comprise module title contained by each separate unit cabinet and the file of required module number and plane graph are calculated with module number by module, then by cabinet number, the data of separate unit cabinet save as single BOM inventory file.
As preferably, this system also includes inventory conversion module, and the BOM inventory file of all cabinets comprised in plane graph is converted into the program of operation inventory file.
As preferably, this system also includes configuring list and Pricedata and information is checked and inventory generation module, wherein:
Configuration list and Pricedata, wherein include configuration module, each configuration module price data to there being associated, the selection of each configuration module is the most also the property control by comprising in it, and the attribute comprised in each configuration information respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message；
Information is checked and inventory generation module, carries out checking and generate strike price inventory file with configuration list and Pricedata by separate unit cabinet attribute.
As preferably, this system also includes that inventory is checked and generation module, carries out strike price inventory file and operation inventory file checking the pre-shopping list file of generation.
As preferably, each module in module database is controlled by multiple attribute conditions, and employing and door or door and not gate condition carry out the differentiation of intermodule.
The invention has the beneficial effects as follows: this system can be disposably by multiple stage cabinet plane graph (individual drawing, each cabinet body is distinguished by coordinate) it is converted into separate unit cabinet BOM, the work of more than 2 hours was needed to complete in can foreshortening to a few minutes by originally manually going out BOM inventory, not only efficiency is greatly improved, and data are accurate；Configuration list and schedule of prices can also be derived in 1 minute simultaneously；By a key, the drawing designed and BOM inventory can be uploaded to system assigned catalogue, other authorized persons can check at any time and download, and simplify and upload and method for down loading simultaneously, improve work efficiency, can also immediately grasp sequence information simultaneously..
Accompanying drawing explanation
Fig. 1 is that the present invention generates separate unit cabinet BOM inventory and the flow chart of operation inventory；
Fig. 2 is that the present invention generates strike price inventory and the flow chart of pre-shopping list；
Fig. 3 is an example of the plane graph of the cabinet arrangement using CAXA Software on Drawing；
Fig. 4 is the Local map of an example of module database；
Fig. 5 is the Local map of the example that plane graph is converted into 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 module title and required module number contained by each separate unit cabinet；
Fig. 8 is the Local map of an example of the module data library file required for all cabinets that plane graph comprises；
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.
Detailed description of the invention
As one embodiment of the present invention, as shown in Figure 1, a kind of engineering intelligent design system, run in computer, this system includes figure module, information identification and acquisition module, module database, information checks and file generating module, data calculate 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 plane graph of cabinet arrangement, the primary system figure that plane graph provides according to client, in CAXA software, the figure module that needs are chosen is combined, then add some Word messages, some cabinet attributes that cannot represent with figure module are described.Needed for cabinet, attribute the most singly can represent with figure module, it is also possible to represents with Word message, is an example of the plane graph of the cabinet arrangement using CAXA Software on Drawing as shown in Figure 3.
Information identification and acquisition module, Word message and figure module in the plane graph that will comprise multiple cabinet are identified and are converted to separate unit cabinet attribute.Separate unit cabinet attribute comprise this cabinet body had an impact the design of this cabinet information (as cabinet type, cabinet width, cabinet is deep, cabinet is high, the cup degree of depth, switch model etc.).Every cabinet body has and must have this module of framework, graphic definition when, anchor point is scheduled on the upper left position of figure, specification is the width of figure, and during outline draught, framework figure is impossible overlapping, and all figures being in framework figure and word broadly fall into this cabinet body.The i.e. frame module of the separate unit cabinet in plane graph comprises a region, all figure modules in this region and Word message broadly fall into this cabinet body to be owned, the graphic file of plane graph is chosen, derive TXT file, TXT file comprises each figure and the coordinate information of Word message and defined attribute information, whole separate unit cabinet attribute can be drawn by information identification and acquisition module analysis.The attribute of cabinet generates in same attribute list file by the gross, attribute list cabinet field distinguish this attribute and belong to which cabinet and own.
Module database, it is by the file of module making, the title of each module is different, and in each module, include the information such as the different title of part, specification, unit, quantity, COM code, classifications, whether the selection of module is the property control by comprising in each module, the attribute comprised in each module respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message, each module is controlled by multiple attribute conditions, and employing and door or door and not gate condition carry out the differentiation of intermodule.It is 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 (i.e. comprising the attribute list file of cabinet attribute by the gross) are checked in module database, generates the module data library file required for all cabinets that module title and the file of required module number and plane graph contained by each separate unit cabinet comprise；The content of the module data library file required for all cabinets that module title and the file of required module number and plane graph contained by each separate unit cabinet comprise can be modified as required.
Data calculate and BOM inventory generation module, the data in module data library file required for all cabinets comprise module title contained by each separate unit cabinet and the file of required module number and plane graph are calculated with module number by module, then by cabinet number, the data of separate unit cabinet save as single BOM inventory file.
Inventory conversion module, is converted into the program of operation inventory file by the BOM inventory file of all cabinets comprised in plane graph.
Described information identification and acquisition module, information checks and file generating module, data calculate and BOM inventory generation module and inventory conversion module are the software programs using e language to write with VBA.
nullWhen needing the work carrying out BOM inventory generation，First open plane graph with CAXA software，As shown in Figure 5，Required cabinet part is chosen and is converted into TXT property file，Then TXT file content is read by native system program，By any cabinet body belonging to all module attributes of coordinate position identification and word attribute，And the good cabinet number of labelling，Realize being converted into planogram data the attribute information of all separate unit cabinets，Then in module database, respective modules is searched according to the attribute information (being the Local map of an example of all separate unit cabinet attributes as shown in Figure 6) of all separate unit cabinets，Draw module title contained by every cabinet body and required module number (being the Local map of an example of the file of module title and required module number contained by each separate unit cabinet as shown in Figure 7)，Module database required for simultaneously also extracting this batch of cabinet (being the Local map of an example of module data library file required for all cabinets of comprising of plane graph as shown in Figure 8)，Then data are calculated with module number by program by module，Then by cabinet number, the data of separate unit cabinet are saved as single BOM inventory file (being the Local map of an example of the BOM inventory of single cabinet as shown in Figure 9).The BOM inventory file of each cabinet generated in same sheet of planar figure can be arranged by the inventory conversion module of follow-up operation, by program by BOM invoice summary, merges and generates an operation inventory file.
On the basis of above, as in figure 2 it is shown, 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 includes some in cabinet essential with optional configuration module, each configuration module price data to there being associated；The selection of each configuration module is the most also the property control by comprising in it, the attribute comprised in each configuration information respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message, each configuration module is controlled by multiple attribute conditions, and same employing makes a distinction with door or door and not gate condition.It is the Local map of an example of module database as shown in Figure 4.
Information is checked and inventory generation module, the attribute conditions one by one configuration module comprised in configuration list and Pricedata and separate unit cabinet attribute comparison, find out every cabinet body required configuration module and configuration module number, identical configuration module number is merged, thus obtain the configuration of cabinet by the gross, then find out the configuration rates of correspondence according to configuration list and Pricedata, 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, carries out strike price inventory and operation inventory checking 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 to use the software program write with VBA of e language.Program first passes through information identification and acquisition module equally and realizes being converted into planogram data the attribute information of cabinet, then in configuration list and Pricedata, the configuration module of correspondence is searched according to cabinet attribute information, draw and configure module number accordingly, configuration list and Pricedata are searched dutiable value, thus draw configuration list and price, i.e. strike price inventory file, is carried out the Local map of an example of valency inventory as shown in Figure 10.The inventory of follow-up operation is checked and strike price inventory file is checked by generation module with operation inventory file generated above, according to classification, such as the part that classification is P or PS is decomposed plastic-blasting part list, the part of D or DS is decomposed galvanized part list, the part of Y or YS is decomposed outsourcing piece list, the part containing S is decomposed loose mail list.Being hidden by the row of inventory part in outsourcing piece list, (carrying out brush choosing according to part name) just obtains needing to purchase in advance the pre-shopping list of part.
The drawing designed and BOM inventory can also be uploaded to system assigned catalogue by a key by system, and other authorized persons can check at any time and download, and simplify and upload and method for down loading, improve work efficiency, can also immediately grasp sequence information simultaneously.By program in FTP per year, set up by the moon corresponding document press from both sides, by program, single file is uploaded directly in FTP corresponding folder the most again, if multiple files, then file is packed by program, it is 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, the most not only ensures that O/No. will not repeat, and can find out when this order produces according to O/No..By FTP priority assignation, it is possible to specify authorized person has download permission, simply entering corresponding order coding, program can find out corresponding these order file all, selects file can realize downloading.
Claims (5)
1. an engineering intelligent design system, it is characterised in that: this system includes that figure module, information identification and acquisition module, module database, information are checked and file generating module and data calculate and BOM inventory generation module, wherein:
Figure module, is predefined graph block in planar graph software；
Information identification and acquisition module, word and figure module in the plane graph that will comprise multiple cabinet are identified and are converted to separate unit cabinet attribute；
Module database, it is by the file of module making, the title of each module is different, and in each module, include the different title of part, specification, unit, quantity, COM code, classification information, whether the selection of module is the property control by comprising in each module, and the attribute comprised in each module respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message；
Information is checked and file generating module, is checked by all separate unit cabinet attributes, generate the module data library file required for all cabinets that module title and the file of required module number and plane graph contained by each separate unit cabinet comprise in module database；
Data calculate and BOM inventory generation module, the data in module data library file required for all cabinets comprise module title contained by each separate unit cabinet and the file of required module number and plane graph are calculated with module number by module, then by cabinet number, the data of separate unit cabinet save as single BOM inventory file.
Engineering intelligent design system the most according to claim 1, it is characterised in that: this system also includes inventory conversion module, and the BOM inventory file of all cabinets comprised in plane graph is converted into the program of operation inventory file.
Engineering intelligent design system the most according to claim 2, it is characterised in that: this system also includes configuring list and Pricedata and information is checked and inventory generation module, wherein:
Configuration list and Pricedata, wherein include configuration module, each configuration module price data to there being associated, the selection of each configuration module is the most also the property control by comprising in it, and the attribute comprised in each configuration information respectively should with the attribute of the figure module in plane graph and the Attribute Relative of Word message；
Information is checked and inventory generation module, carries out checking and generate strike price inventory file with configuration list and Pricedata by separate unit cabinet attribute.
Engineering intelligent design system the most according to claim 3, it is characterised in that: this system also includes that inventory is checked and generation module, carries out strike price inventory file and operation inventory file checking 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 characterised in that: each module in module database is controlled by multiple attribute conditions, and employing and door or door and not gate condition carry 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 CN103631980A (en) | 2014-03-12 |
| CN103631980B true 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) |
Families Citing this family (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103631980A (en) | 2014-03-12 |
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 | |
| Parthanadee et al. | Production efficiency improvement in batch production system using value stream mapping and simulation: a case study of the roasted and ground coffee industry | |
| Chen et al. | Modeling and performance evaluation of supply chains using batch deterministic and stochastic Petri nets | |
| Faccio et al. | Kanban number optimisation in a supermarket warehouse feeding a mixed-model assembly system | |
| Yılmaz et al. | Strategic level three-stage production distribution planning with capacity expansion | |
| Li et al. | Balancing manual mixed-model assembly lines using overtime work in a demand variation environment | |
| CN103226747A (en) | Diagram generation method, and diagram generation apparatus | |
| CN102567864B (en) | Material substitution method in MRP system, device | |
| CN104011720A (en) | Behavioral attribute analysis method and device | |
| CN111461590A (en) | Method for calculating complete set of materials according to sales, inventory and purchase information | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| CN101470865A (en) | Quotation information gathering system and method | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN103631980B (en) | Engineering intelligent design system | |
| Lu et al. | Asynchronous stochastic learning curve effects in engineering-to-order customisation processes | |
| Ezema et al. | Industrial design and simulation of a JIT material handling system | |
| CN106372802A (en) | Construction method for manufacturing object tree | |
| Wen et al. | Cost-benefit analysis of RFID application in apparel retailing for SME: a case from Taiwan | |
| Freeman et al. | Parallel-machine scheduling to minimize overtime and waste costs | |
| Li | Simulation study of coordinating layout change and quality improvement for adapting job shop manufacturing to CONWIP control | |
| Pai et al. | Effective implementation for introducing ISO/TS 16949 in semiconductor manufacturing industries | |
| Hung et al. | Applying group technology to the forging industry | |
| Marques et al. | Towards a requirements traceability process centered on the traceability model | |
| Zhao et al. | Optimizing pricing and inventory strategies for dietary supplement production under stochastic demand |
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 | ||
| 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. |
|
| 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 |
|
| PE01 | Entry into force 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 |
|
| PC01 | Cancellation 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 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |