CN103020218A - Busway design method based on database technology - Google Patents
Busway design method based on database technology Download PDFInfo
- Publication number
- CN103020218A CN103020218A CN2012105316406A CN201210531640A CN103020218A CN 103020218 A CN103020218 A CN 103020218A CN 2012105316406 A CN2012105316406 A CN 2012105316406A CN 201210531640 A CN201210531640 A CN 201210531640A CN 103020218 A CN103020218 A CN 103020218A
- Authority
- CN
- China
- Prior art keywords
- bus duct
- database
- designing
- data
- bom
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a busway design method based on a database technology. The busway design method comprises the following steps of: modeling; establishing a database; correcting the database; exporting data; and completing production, purchase and material control according to the data of the database. According to the invention, product design can be completed as long as a product process designer operates according to an operation instruction, so that the requirements for the expertise of the designer is reduced, specialization-based labor division is realized, the efficiency and accuracy for product process design are improved, errors are reduced, work hours are reduced, and wastes of raw materials, semi-finished products and finished products due to design errors are avoided.
Description
Technical field
The present invention relates to the method for designing of bus duct, particularly a kind of bus duct method for designing of based on database technology.
Background technology
In the prior art, the method for designing of bus duct is, utilizes the X-Y scheme design software directly the bus duct X-Y scheme of needs to be designed, and according to each design parameter of bus duct X-Y scheme, finishes production again.Because during reality is produced, bus duct of a great variety, a kind of bus duct of every production all needs first this bus duct to be carried out the design of X-Y scheme, if certain parameter of bus duct needs to change, means that needs redesign X-Y scheme.
This method for designing efficient is low, professional degree to the designer is had relatively high expectations, in addition, because the bus duct product structure is comparatively complicated, when design, easily make mistakes, and be not easy to find, in case mistake appears in design, namely causes the waste of starting material, semi-manufacture even finished product, design efficiency is low, cost is high, and accuracy is low.
Summary of the invention
In order to overcome the defective of above-mentioned prior art existence, the invention provides a kind of bus duct method for designing of based on database technology, by calling modelling, targetedly model is carried out individual parameters and revise, improve design efficiency, reduce design cost.
To achieve these goals, technical scheme of the present invention is as follows:
A kind of bus duct method for designing of based on database technology comprises the steps:
S1) modeling: according to bus duct designing technique standard, different classes of, specification bus duct are set up respectively the bus duct mathematical model according to product unit, bus duct length is set to variable;
S2) database construction: according to the bus duct mathematical model, in computing machine, input different length values with the formation three-dimensional picture consistent with actual product, and the foundation database corresponding with three-dimensional picture;
S3) revise database: call required mathematical model, input the variable of on-the-spot scheme, revise corresponding parameter to form new three-dimensional design figure;
S4) database data corresponding to three-dimensional design figure derived data: derive step S3);
S5) according to step S4) database data finish production, buying, thing control.
As preferably, step S1 of the present invention) be modeled as by the Changing Pattern between the parameters of bus duct, utilize priority number, preferred numbers theory to set up the functional relation of bus duct parameters.
As preferably, step S2 of the present invention) database construction comprises the steps:
S21) launch three-dimensional picture, generate X-Y scheme and BOM table;
S22) set up corresponding BOM database according to the BOM table;
S23) will store in the data importing BOM database that produce in the figure.
As preferably, step S3 of the present invention) revising database comprises the steps:
S31) in-site measurement bus duct decomposes bus duct in-site measurement scheme, presses unit specification classification, forms the product unit tabulation;
S32) call the mathematical model of corresponding bus duct unit according to classification, specification, one by one input variable;
S33) current class, three-dimensional model corresponding in the bus duct cell data storehouse are called in tabulation according to product unit, input or modification length parameter.
As preferably, step S4 of the present invention) derived data comprises the steps:
S41) generate the three-dimensional design figure of actual needs according to the data of revising;
S42) the bus duct unit X-Y scheme and the BOM that three-dimensional design figure are generated corresponding classification, specification show;
S43) X-Y scheme and the BOM that derive whole project show data.
As preferably, database of the present invention is a kind of among SQL Server, Oracle, Sybase, mySQL, Access, the FoxPro.
The invention has the beneficial effects as follows, the Product Process designer is as long as operate according to job instruction, can finish product design, attenuating is to designer's professional requirement, realize division of labor based on specialization, improved efficient and the accuracy of Product Process design, reduce the appearance of mistake, save man-hour, avoid the waste because of starting material that design mistake causes, semi-manufacture, finished product.
Description of drawings
Fig. 1 is process flow diagram of the present invention.
Embodiment:
Be easy to understand understanding in order to make creation characteristic of the present invention, technological means and to reach purpose, further set forth the present invention below in conjunction with specific embodiment.
A kind of bus duct method for designing of based on database technology, comprise the steps: modeling, according to bus duct designing technique standard, different classes of, specification bus duct are set up respectively the bus duct mathematical model according to product unit, bus duct length is set to variable, and the input different length can form the three-dimensional picture consistent with actual product automatically.Database construction, according to the bus duct mathematical model, in computing machine, input different length values to form the three-dimensional picture consistent with actual product, and the foundation database corresponding with three-dimensional picture, launch three-dimensional picture, generate the X-Y scheme and the BOM table that are used for panel beating production, set up corresponding BOM database according to the content format of BOM table, will store in the data importing BOM database that produce in the figure.Revise database: call required mathematical model, input the variable of on-the-spot scheme, revise corresponding parameter to form new three-dimensional design figure, during product design, the in-site measurement bus duct, bus duct in-site measurement scheme is decomposed, press unit specification classification, the tabulation of formation product unit, call the mathematical model of corresponding bus duct unit according to classification, specification, input variable one by one, current class, three-dimensional model corresponding in the bus duct cell data storehouse are called in tabulation according to product unit, input or revise length parameter.Derived data according to the three-dimensional design figure of the data generation actual needs of revising, generates three-dimensional design figure in bus duct unit X-Y scheme and the BOM table of corresponding classification, specification, derives X-Y scheme and the BOM table data of whole project.Form project construction technique according to database data single, finish production, buying, thing control.
Set up mathematical model for by the Changing Pattern between the parameters of bus duct, utilize priority number, preferred numbers theory to set up the functional relation of bus duct parameters.Described database is a kind of among SQL Server, Oracle, Sybase, mySQL, Access, the FoxPro.
Above demonstration and described ultimate principle of the present invention, principal character and advantage of the present invention.The technician of the industry should understand; the present invention is not restricted to the described embodiments; that describes in above-described embodiment and the instructions just illustrates principle of the present invention; the present invention also has various changes and modifications without departing from the spirit and scope of the present invention, and these changes and improvements all fall in the claimed scope of the invention.The claimed scope of the present invention is defined by appending claims and equivalent thereof.
Claims (6)
1. the bus duct method for designing of a based on database technology is characterized in that, comprises the steps:
S1) modeling: according to bus duct designing technique standard, different classes of, specification bus duct are set up respectively the bus duct mathematical model according to product unit, bus duct length is set to variable;
S2) database construction: according to the bus duct mathematical model, in computing machine, input different length values with the formation three-dimensional picture consistent with actual product, and the foundation database corresponding with three-dimensional picture;
S3) revise database: call required mathematical model, input the variable of on-the-spot scheme, revise corresponding parameter to form new three-dimensional design figure;
S4) database data corresponding to three-dimensional design figure derived data: derive step S3);
S5) according to step S4) database data finish production, buying, thing control.
2. the bus duct method for designing of a kind of based on database technology according to claim 1, it is characterized in that, described step S1) is modeled as by the Changing Pattern between the parameters of bus duct, utilizes priority number, preferred numbers theory to set up the functional relation of bus duct parameters.
3. the bus duct method for designing of a kind of based on database technology according to claim 1 is characterized in that, described step S2) database construction comprises the steps:
S21) launch three-dimensional picture, generate X-Y scheme and BOM table;
S22) set up corresponding BOM database according to the BOM table;
S23) will store in the data importing BOM database that produce in the figure.
4. the bus duct method for designing of a kind of based on database technology according to claim 1 is characterized in that, described step S3) revise database and comprise the steps:
S31) in-site measurement bus duct decomposes bus duct in-site measurement scheme, presses unit specification classification, forms the product unit tabulation;
S32) call the mathematical model of corresponding bus duct unit according to classification, specification, one by one input variable;
S33) current class, three-dimensional model corresponding in the bus duct cell data storehouse are called in tabulation according to product unit, input or modification length parameter.
5. the bus duct method for designing of a kind of based on database technology according to claim 1 is characterized in that, described step S4) derived data comprises the steps:
S41) generate the three-dimensional design figure of actual needs according to the data of revising;
S42) the bus duct unit X-Y scheme and the BOM that three-dimensional design figure are generated corresponding classification, specification show;
S43) X-Y scheme and the BOM that derive whole project show data.
6. according to claim 1 or the bus duct method for designing of 3 described a kind of based on database technology, it is characterized in that, described database is a kind of among SQL Server, Oracle, Sybase, mySQL, Access, the FoxPro.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105316406A CN103020218A (en) | 2012-12-07 | 2012-12-07 | Busway design method based on database technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105316406A CN103020218A (en) | 2012-12-07 | 2012-12-07 | Busway design method based on database technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103020218A true CN103020218A (en) | 2013-04-03 |
Family
ID=47968822
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012105316406A Pending CN103020218A (en) | 2012-12-07 | 2012-12-07 | Busway design method based on database technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103020218A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104368979A (en) * | 2014-11-19 | 2015-02-25 | 江苏华鹏智能电气股份有限公司 | Method for producing bus duct sectional materials |
| CN114756915A (en) * | 2022-06-15 | 2022-07-15 | 青岛东山集团母线智造有限公司 | Parameterization design method and parameterization design platform of bus duct |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101540221A (en) * | 2009-03-31 | 2009-09-23 | 沈阳工业大学 | Preparation method and mould of liquid-solid composite forming copper cladding aluminum bus duct platoon blank |
-
2012
- 2012-12-07 CN CN2012105316406A patent/CN103020218A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101540221A (en) * | 2009-03-31 | 2009-09-23 | 沈阳工业大学 | Preparation method and mould of liquid-solid composite forming copper cladding aluminum bus duct platoon blank |
Non-Patent Citations (2)
| Title |
|---|
| 吴锐等: "三维母线槽计算机辅助设计系统", 《低压电器》 * |
| 王萍萍等: "母线槽施工设计软件JDM-CAD中母线编辑方法的研究", 《机床电器》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104368979A (en) * | 2014-11-19 | 2015-02-25 | 江苏华鹏智能电气股份有限公司 | Method for producing bus duct sectional materials |
| CN104368979B (en) * | 2014-11-19 | 2017-01-11 | 江苏华鹏母线股份有限公司 | Method for producing bus duct sectional materials |
| CN114756915A (en) * | 2022-06-15 | 2022-07-15 | 青岛东山集团母线智造有限公司 | Parameterization design method and parameterization design platform of bus duct |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104102765A (en) | BIM (Building Information Modeling)-based curtain wall parametrization design method | |
| CN107491610A (en) | Car panel die intelligent design system and design method | |
| CN103578137A (en) | Three-dimensional modeling system and method for prefabricated parts | |
| CN110765523A (en) | BIM technology-based rapid construction method for deep foundation pit support structure | |
| CN105302978A (en) | Quantity calculation method and device | |
| CN102332049B (en) | Quick design method for lug of sheet metal process | |
| CN102298739A (en) | Method for changing bill of materials (BOM) and apparatus thereof | |
| CN103903086A (en) | Method and system for developing management information system based on service model driving | |
| CN104217063A (en) | Simulation design method for rolling hole patterns of steel rail | |
| CN105159754A (en) | On-line simulation method and device based on intelligent business cloud platform | |
| CN108334724A (en) | A kind of construction method of civil engineering BIM quantities models | |
| CN103902757A (en) | System and method for rapid creation and interaction of three-dimensional model | |
| CN103020218A (en) | Busway design method based on database technology | |
| CN104504227A (en) | Hydraulic forging press multi-dimensional virtual prototype collaborative simulation method and system | |
| CN1877585B (en) | Automatically designable and adjustable engineering graphics system and its building method and using method | |
| CN101706837A (en) | Mathematical model based method for establishing database of fixture components | |
| CN110321596B (en) | Locomotive vehicle structure simulation method based on finite element analysis | |
| CN112465953A (en) | Rapid parameterization modeling method based on template | |
| WO2023078353A1 (en) | Generative design method for prefabricated concrete component | |
| CN106372359A (en) | Universal framework for equipment virtual prototype system | |
| CN105205854B (en) | Data center 3D modeling method and device | |
| CN103279354B (en) | The automatic production generation method of DRC file and generator | |
| CN104820742A (en) | Method for automatically drawing standard fan coil manufacturing drawings | |
| CN111914380A (en) | Part model determination method and device, computer equipment and storage medium | |
| CN114676615A (en) | Tool compensation profile construction error assessment method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130403 |