CN106547535A - Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated - Google Patents
Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated Download PDFInfo
- Publication number
- CN106547535A CN106547535A CN201610863224.4A CN201610863224A CN106547535A CN 106547535 A CN106547535 A CN 106547535A CN 201610863224 A CN201610863224 A CN 201610863224A CN 106547535 A CN106547535 A CN 106547535A
- Authority
- CN
- China
- Prior art keywords
- accessory
- standard
- controls
- bom tables
- standard component
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a kind of method automatically generated based on the standard component BOM tables that VB6.0 writes, is related to BOM table generating method technical fields.Methods described comprises the steps：The 3D design standard parts being involved in are put in order, are programmed into inside program with VB6.0；User is write using VB6.0 and uses interface, allow users to product 3D standard components specification to be used and quantity be clicked in user interface；Operate the BOM tables of the use interface outputting standard part.Methods described can simply, quickly finish standard component BOM tables content foundation, greatly improve the efficiency and accuracy for setting up standard component BOM tables.
Description
Technical field
The present invention relates to BOM table generating method technical fields, more particularly to a kind of standard component BOM write based on VB6.0
The method that table is automatically generated.
Background technology
In enterprise product design production process, BOM tables (product-based bom flow) are requisite capsule information.Technology
Personnel are required for for new product, ceaselessly setting up BOM tables daily.BOM tables intricate operation is set up manually and mistake easily occurs.For
This, technical staff particularlys hope there is a kind of simple BOM table method for building up.In this enterprises according to commonly used
Parts, establish a set of standard component data, a 3D standard components data of our company's internal organization, comprising main part and accessory,
Content sources are provided for standardized BOM tables method for building up.
Visual Basic 6.0 | VB is a kind of event-driven volume comprising assistance development environment developed by Microsoft
Cheng Yuyan, it stems from BASIC programming languages.VB possesses graphic user interface（GUI）And Express ＆ Imagging Logging System（RAD）System
System, easily can connect data base using DAO, RDO, ADO, or easily create ActiveX control.Programmer can be light
The component that the use VB of pine is provided quickly sets up an application program, therefore, VB 6.0 is programmed and is caused this BOM tables foundation side
Formula is achieved.
The content of the invention
The technical problem to be solved is to provide and a kind of is automatically generated based on the standard component BOM tables that VB6.0 writes
Method, methods described can simply, quickly finish standard component BOM tables content foundation, greatly improve and set up standard component
The efficiency and accuracy of BOM tables.
To solve above-mentioned technical problem, the technical solution used in the present invention is：A kind of standard write based on VB6.0
The method that part BOM tables are automatically generated, it is characterised in that methods described comprises the steps：
1）The 3D design standard parts being involved in are put in order, are programmed into inside program with VB6.0；
2）User is write using VB6.0 and uses interface, allow users to product 3D marks to be used be clicked in user interface
Quasi- part specification and quantity；
3）Operate the BOM tables of the use interface outputting standard part.
Further technical scheme is, when user is write using interface, using following VB controls：
ComboBox controls, 3D standard component data informations are programmed in such control, are selected by user；
TextBox controls, the accessory data of 3D standard components is exported Dao such control in.
Further technical scheme is, detailed step 3D standard component data informations being programmed in ComboBox controls
It is rapid as follows：
In the List attributes of the ComboBox controls in denominational, the classification of the 3D standard component data planned is programmed into, is used
The ComboBox controls that family is clicked in denominational will appear from drop-down option；
After the specifically chosen a certain option of ComboBox controls in denominational, the ComboBox controls in specifications and models hurdle
List attributes, it will the concrete model specification of corresponding 3D standard components classification occur；
After the ComboBox in denominational and specifications and models hurdle have selected particular content, the ComboBox controls on touching quantity hurdle
Part, may be selected particular number, from the option of 1-30 select one.
Further technical scheme is, by the accessory data output of 3D standard components to the method in TextBox controls
It is as follows：
After the ComboBox controls of denominational, specifications and models hurdle and quantity hurdle have selected particular content, if the option has right
The accessory answered, then accessory data can export automatically in the TextBox controls in accessory hurdle, the title comprising accessory, specification, number
Amount and item number；The numeral on TextBox quantity hurdle therein can be linear with the change of quantity hurdle ComboBox control options
Ratio changes.
Further technical scheme is to quote 14.0 Object Library API softwares of Microsoft Excel
Generate 3D standard BOM tables.
Further technical scheme is, described 14.0 Object Library of reference Microsoft Excel
The method of API Software Create 3D standard BOM tables is as follows：
When new BOM tables will be set up, by quoting 14.0 Object Library API softwares of Microsoft Excel, first
Open the template file BOM_Model.xls files of 3D standard component BOM tables；
Again by the title of the main part title of 3D standard components, specifications and models, quantity, item number and accessory, accessory specification, with number of packages
Amount, accessory item number, to newly-established BOM tables, wherein accessory can be judged the content output in note, if the name of accessory
Claim, specification is identical, then merge, i.e., number of fitting parts is overlapped, be merged into only output.
Using the beneficial effect produced by above-mentioned technical proposal it is：Methods described can simply, quickly finish standard
Part BOM tables content is set up, and greatly improves the efficiency and accuracy for setting up standard component BOM tables.
Description of the drawings
The present invention is further detailed explanation with reference to the accompanying drawings and detailed description.
The flow chart of Fig. 1 embodiment of the present invention methods describeds；
The icon of the program write in Fig. 2 embodiment of the present invention methods describeds；
The working interface of the program write in Fig. 3 embodiment of the present invention methods describeds；
Main part title surface chart is selected in Fig. 4 embodiment of the present invention methods describeds；
Main part specifications and models surface chart is selected in Fig. 5 embodiment of the present invention methods describeds；
Selection main part quantity surface chart in Fig. 6 embodiment of the present invention methods describeds；
Automatic addition accessory profile interface figure in Fig. 7 embodiment of the present invention methods describeds；
Input BOM table name surface charts in Fig. 8 embodiment of the present invention methods describeds；
Clicking operation menu setecting in Fig. 9 embodiment of the present invention methods describeds sets up BOM surface and interface figures；
In Figure 10 embodiment of the present invention methods describeds, BOM tables are successfully established information surface chart；
Newly-established BOM tables in Figure 11 embodiment of the present invention methods describeds；
The content of newly-established BOM tables in Figure 12 embodiment of the present invention methods describeds.
Specific embodiment
With reference to the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Ground description, it is clear that described embodiment a part of embodiment only of the invention, rather than the embodiment of whole.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made
Embodiment, belongs to the scope of protection of the invention.
Many details are elaborated in the following description in order to fully understand the present invention, but the present invention can be with
It is different from alternate manner described here to implement using other, those skilled in the art can be without prejudice to intension of the present invention
In the case of do similar popularization, therefore the present invention is not limited by following public specific embodiment.
Overall, as shown in figure 1, the invention discloses a kind of automatically generated based on the standard component BOM tables that VB6.0 writes
Method, methods described comprises the steps：
1）The 3D design standard parts being involved in are put in order, are programmed into inside program with VB6.0；
2）User is write using VB6.0 and uses interface, allow users to product 3D marks to be used be clicked in user interface
Quasi- part specification and quantity；
3）Operate the BOM tables of the use interface outputting standard part.
Further, methods described is comprised the steps of：
1) arrangement of enterprises 3D standard component data：According to enterprise's knowhow for many years, sort out a set of enterprise and be suitable for
3D standard component data.Title comprising 3D standard components, specifications and models, the title of accessory, specification, quantity, item number etc..
2) user interface is write using VB6.0：ComboBox controls, TextBox controls are used mainly.In denominational
ComboBox control List attributes in write 3D standard components all titles.ComboBox controls in specifications and models hurdle
List property contents are determined by the content that the ComboBox controls in denominational are clicked.Herein using in denominational
The Click event responses of ComboBox controls, and If is used in event is corresponding ... else ... end if programmed statements, judge
The specifications and models content gone out under main part Names Catalogue.For example：Main part title ComboBox control
Content is " plastic casing ", then 3 kinds are had in the List of its corresponding specifications and models ComboBox control and are respectively " and B2 ",
“B3”、“B4”.If main part title ComboBox control is " suspension ring ", the List of its corresponding specifications and models ComboBox control
Inside have 3 kinds and be respectively " M24 ", " M18 ", " M12 ".
TextBox controls are mainly used in the title for exporting accessory, specification, quantity, item number, remarks.When the title of main part,
Specification, after quantity is selected, by according to the 3D standard component data for arranging, judges whether which has accessory, if there is accessory, by accessory certainly
Dynamic output is on the TextBox controls in accessory hurdle.
3) the 3D standard component BOM tables of company are exported：When point chooses the title of main part, main part specifications and models, after main part quantity,
Its corresponding accessory name, accessory specification, number of fitting parts, accessory item number are exported in accessory hurdle automatically.As all masters of product
Part data is put after choosing, and all of accessory data also completes output automatically.Now, click on and set up BOM table menus, can build automatically
Vertical portion meets the BOM tables of company's requirement.Wherein repeat accessory item, will merge, will quantity superposition, merge into one
Output.
Specifically, when user is write using interface, using following VB controls：
ComboBox controls, 3D standard component data informations are programmed in such control, are selected by user；
TextBox controls, the accessory data of 3D standard components is exported Dao such control in.
More specifically, detailed step 3D standard component data informations being programmed in ComboBox controls is as follows：
In the List attributes of the ComboBox controls in denominational, the classification of the 3D standard component data planned is programmed into, is used
The ComboBox controls that family is clicked in denominational will appear from drop-down option；
After the specifically chosen a certain option of ComboBox controls in denominational, the ComboBox controls in specifications and models hurdle
List attributes, it will the concrete model specification of corresponding 3D standard components classification occur；
After the ComboBox in denominational and specifications and models hurdle have selected particular content, the ComboBox controls on touching quantity hurdle
Part, may be selected particular number, from the option of 1-30 select one.
Will be the accessory data output of 3D standard components as follows to the method in TextBox controls：
After the ComboBox controls of denominational, specifications and models hurdle and quantity hurdle have selected particular content, if the option has right
The accessory answered, then accessory data can export automatically in the TextBox controls in accessory hurdle, the title comprising accessory, specification, number
Amount and item number；The numeral on TextBox quantity hurdle therein can be linear with the change of quantity hurdle ComboBox control options
Ratio changes.
During the BOM tables of outputting standard, Microsoft 14.0 Object Library API of Excel are quoted soft
Part generates 3D standard BOM tables.
More specifically, described 14.0 Object Library API Software Create 3D of reference Microsoft Excel
The method of standard BOM table is as follows：
When new BOM tables will be set up, by quoting 14.0 Object Library API softwares of Microsoft Excel, first
Open the template file BOM_Model.xls files of 3D standard component BOM tables；
Again by the title of the main part title of 3D standard components, specifications and models, quantity, item number and accessory, accessory specification, with number of packages
Amount, accessory item number, to newly-established BOM tables, wherein accessory can be judged the content output in note, if the name of accessory
Claim, specification is identical, then merge, i.e., number of fitting parts is overlapped, be merged into only output.
The Operation interface diagram being related in methods described as shown in figs. 2-12, methods described can simply, quickly finish
Standard component BOM tables content is set up, and greatly improves the efficiency and accuracy for setting up standard component BOM tables.
Claims (6)
1. a kind of method automatically generated based on the standard component BOM tables that VB6.0 writes, it is characterised in that methods described include as
Lower step：
1）The 3D design standard parts being involved in are put in order, are programmed into inside program with VB6.0；
2）User is write using VB6.0 and uses interface, allow users to product 3D marks to be used be clicked in user interface
Quasi- part specification and quantity；
3）Operate the BOM tables of the use interface outputting standard part.
2. the method for being automatically generated based on the standard component BOM tables that VB6.0 writes as claimed in claim 1, it is characterised in that
When writing user using interface, using following VB controls：
ComboBox controls, 3D standard component data informations are programmed in such control, are selected by user；
TextBox controls, the accessory data of 3D standard components is exported Dao such control in.
3. the method for being automatically generated based on the standard component BOM tables that VB6.0 writes as claimed in claim 2, it is characterised in that will
The detailed step that 3D standard component data informations are programmed in ComboBox controls is as follows：
In the List attributes of the ComboBox controls in denominational, the classification of the 3D standard component data planned is programmed into, is used
The ComboBox controls that family is clicked in denominational will appear from drop-down option；
After the specifically chosen a certain option of ComboBox controls in denominational, the ComboBox controls in specifications and models hurdle
List attributes, it will the concrete model specification of corresponding 3D standard components classification occur；
After the ComboBox in denominational and specifications and models hurdle have selected particular content, the ComboBox controls on touching quantity hurdle
Part, may be selected particular number, from the option of 1-30 select one.
4. the method for being automatically generated based on the standard component BOM tables that VB6.0 writes as claimed in claim 3, it is characterised in that
Will be the accessory data output of 3D standard components as follows to the method in TextBox controls：
After the ComboBox controls of denominational, specifications and models hurdle and quantity hurdle have selected particular content, if the option has right
The accessory answered, then accessory data can export automatically in the TextBox controls in accessory hurdle, the title comprising accessory, specification, number
Amount and item number；The numeral on TextBox quantity hurdle therein can be linear with the change of quantity hurdle ComboBox control options
Ratio changes.
5. the method for being automatically generated based on the standard component BOM tables that VB6.0 writes as claimed in claim 1, it is characterised in that：
Quote 14.0 Object Library API Software Create 3D standard BOM tables of Microsoft Excel.
6. the method for being automatically generated based on the standard component BOM tables that VB6.0 writes as claimed in claim 5, it is characterised in that
The method of described 14.0 Object Library API Software Create 3D standard BOM tables of reference Microsoft Excel is such as
Under：
When new BOM tables will be set up, by quoting 14.0 Object Library API softwares of Microsoft Excel, first
Open the template file BOM_Model.xls files of 3D standard component BOM tables；
Again by the title of the main part title of 3D standard components, specifications and models, quantity, item number and accessory, accessory specification, with number of packages
Amount, accessory item number, to newly-established BOM tables, wherein accessory can be judged the content output in note, if the name of accessory
Claim, specification is identical, then merge, i.e., number of fitting parts is overlapped, be merged into only output.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610863224.4A CN106547535A (en) | 2016-09-29 | 2016-09-29 | Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610863224.4A CN106547535A (en) | 2016-09-29 | 2016-09-29 | Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106547535A true CN106547535A (en) | 2017-03-29 |
Family
ID=58368182
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610863224.4A Pending CN106547535A (en) | 2016-09-29 | 2016-09-29 | Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106547535A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
| CN113591291A (en) * | 2021-07-21 | 2021-11-02 | 慧德敏学(北京)科技有限公司 | Method, plug-in or system for building and applying standard component library capable of realizing component-free statistics |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101013451A (en) * | 2007-01-31 | 2007-08-08 | 济南二机床集团有限公司 | Automatic generation system for designing BOM |
| CN102096745A (en) * | 2011-03-08 | 2011-06-15 | 中北大学 | Bridge crane metal structure parameterization design method based on C/S/W system architecture |
| US20130006408A1 (en) * | 2011-06-29 | 2013-01-03 | General Electric Company | Automated system for digitized product management |
| CN104252554A (en) * | 2013-06-29 | 2014-12-31 | 南京晨光集团有限责任公司 | Producing method for three-dimensional craft of final product assembly |
-
2016
- 2016-09-29 CN CN201610863224.4A patent/CN106547535A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101013451A (en) * | 2007-01-31 | 2007-08-08 | 济南二机床集团有限公司 | Automatic generation system for designing BOM |
| CN102096745A (en) * | 2011-03-08 | 2011-06-15 | 中北大学 | Bridge crane metal structure parameterization design method based on C/S/W system architecture |
| US20130006408A1 (en) * | 2011-06-29 | 2013-01-03 | General Electric Company | Automated system for digitized product management |
| CN104252554A (en) * | 2013-06-29 | 2014-12-31 | 南京晨光集团有限责任公司 | Producing method for three-dimensional craft of final product assembly |
Non-Patent Citations (2)
| Title |
|---|
| 李芳: ""基于VB的车间生产物流规划"", 《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑》 * |
| 马万杰: ""基于多软件、多平台的塑料模标准件系统的研究与开发"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
| CN113591291A (en) * | 2021-07-21 | 2021-11-02 | 慧德敏学(北京)科技有限公司 | Method, plug-in or system for building and applying standard component library capable of realizing component-free statistics |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8214797B2 (en) | Visual association creation for object relational class development | |
| CN104049957A (en) | Rapid modeling frame of general business model based on star structure | |
| US20050066287A1 (en) | User-friendly data binding, such as drag-and-drop data binding in a workflow application | |
| CN102779156B (en) | Configuration method for database of communication device in digital substation | |
| WO2007134265A2 (en) | Workflow data binding | |
| CN110807015A (en) | Big data asset value delivery management method and system | |
| TW201035789A (en) | A visual editor for editing complex expressions | |
| CN106844885B (en) | BIM technology-based drawing frame and drawing label design method | |
| CN113886362A (en) | Data storage system and storage method based on workflow engine and low-code platform | |
| CN106843887A (en) | A kind of implementation method of embedded customized development platform automatic creation system | |
| CN108241605A (en) | A kind of technical report standardization write method based on VC | |
| WO2005094500A2 (en) | Document development platform | |
| CN106547535A (en) | Based on the method that the standard component BOM tables that VB6.0 writes are automatically generated | |
| CN103810292A (en) | Method and device for configuring graphical interface | |
| CN103955429A (en) | Method and device for determining regression testing range | |
| CN110765028A (en) | Visual construction method and device of verification environment and storage medium | |
| CN109597603A (en) | A kind of requirement documents automatic generation method based on document component | |
| CN106547536A (en) | 3D standard components and accessory BOM table generating methods | |
| Yusof et al. | Interoperable CNC system for turning operations | |
| US8812965B2 (en) | Creation and publishing of virtual components | |
| CN110826185A (en) | Method for establishing bearing part library based on CAD secondary development | |
| CN105278939A (en) | Method and device for manufacturing control on the basis of DotNet Framework class library | |
| CN114281797A (en) | Method for quickly creating basic level data aggregation warehouse based on agile low-code platform | |
| Nikiforova et al. | Several issues on the layout of the UML sequence and class diagram | |
| US20200410560A1 (en) | Prefilled Owner Invoices |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170329 |
|
| RJ01 | Rejection of invention patent application after publication |