CN103324681B - Process chart data creation method based on CAD - Google Patents
Process chart data creation method based on CAD Download PDFInfo
- Publication number
- CN103324681B CN103324681B CN201310213098.4A CN201310213098A CN103324681B CN 103324681 B CN103324681 B CN 103324681B CN 201310213098 A CN201310213098 A CN 201310213098A CN 103324681 B CN103324681 B CN 103324681B
- Authority
- CN
- China
- Prior art keywords
- data
- link table
- data link
- cad
- process chart
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of process chart data creation method based on CAD, relate to the manufacture method of a kind of process chart, the present invention is by CAD and EXCEL communication, the part data of poll coupling CAD part drawing and the part data of setting in Microsoft Excel, can effectively check and ensure the accuracy of part data in CAD part drawing, and directly can fill in process data in CAD so that it is be no longer necessary to the process chart of papery, reduce cost, greatly improve efficiency.
Description
Technical field
The present invention relates to the manufacture method of a kind of process chart, particularly relate to a kind of writing process sheet method based on CAD.
Background technology
Steel tower industry is a special industry, the parts of steel tower are very many, few person's hundreds of part, many persons are thousands of, adding man-hour will to each component-making processes card, difference according to quantity on order, the radix of each tower is different, and when causing producing, the quantity on process chart, weight are ceaselessly changing.
Specify according to processing process, add indispensable two kinds of data in man-hour; One is material list, and for showing that the data such as the dash number of this batch of converted products, material, specification, length, quantity are easy to blanking, clear part and typewriting use, two are part drawings and are attached to above process card, for Product processing and do operation record. Traditional process chart manufacture method is loaded down with trivial details, will fill in the process chart glue of process data and stick to above part drawing, its shortcoming is: error rate is high, cost is high, and speed is slow, efficiency is low, the demand of production can not be met so that imbalance between supply and demand constantly increases.
Summary of the invention
Because the drawbacks described above of prior art, the technical problem to be solved is to provide one and makes CAD(AutoComputerAidedDesign, automatic computing engine aided design system) accurately can quickly fill in the process plan sheet generation method of process data.
For achieving the above object, the invention provides a kind of process chart data creation method based on CAD, sequentially include the following steps:
Step one, open CAD part drawing and Microsoft Excel;
Step 2, extracting part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data extracted in Microsoft Excel forms the second data link table;
Step 3, described first data link table and the second data link table are mated;
Set described first data link table and the second data link table all includes n part data, n is positive integer, first part data in first data link table is mated with first part data in described second data link table, second part data in second data link table is mated with second part data in described second data link table, until the part data that in the first data link table, all part datas are corresponding with described second data link table has mated;When the n-th part data in described first data link table is with corresponding part data coupling in described second data link table, perform step 4; When the n-th part data in described first data link table does not mate with corresponding part data in described second data link table, perform step 5;
Step 4, on CAD part drawing, fill in process data, then terminate;
Step 5, in CAD command bar, carry out miscue, then terminate.
Owing to adopting CAD and EXCEL communication, the part data of poll coupling CAD part drawing and the part data of setting in Microsoft Excel, can effectively check and ensure the accuracy of part data in CAD part drawing, and directly can fill in process data in CAD, it is made to be no longer necessary to the process chart of papery, reduce cost, greatly improve efficiency.
It is also preferred that the left described first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is made up of engineering name, processing radix, processing total quantity, gross weight and Product Status, adopts above technical scheme to disclosure satisfy that the steel tower processing technology demand of routine.
The invention has the beneficial effects as follows: the present invention can effectively check and ensure the accuracy of part data in CAD part drawing, and directly can fill in process data in CAD, make it be no longer necessary to the process chart of papery, reduce cost, greatly improve efficiency.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the embodiment of the invention.
Detailed description of the invention
Below in conjunction with drawings and Examples, the invention will be further described:
As it is shown in figure 1, a kind of process chart data creation method based on CAD, sequentially include the following steps:
Step one, open CAD part drawing and Microsoft Excel;
Step 2, extracting part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data extracted in Microsoft Excel forms the second data link table;
Step 3, judge whether described first data link table and the second data link table mate;
Set described first data link table and the second data link table all includes n part data, n is positive integer, first part data in first data link table is mated with first part data in described second data link table, second part data in the second data link table is mated with second part data in described second data link table ... until the part data that in the first data link table, all part datas are corresponding with described second data link table has mated;
When the n-th part data in described first data link table is with corresponding part data coupling in described second data link table, perform step 4; When the n-th part data in described first data link table does not mate with corresponding part data in described second data link table, perform step 5;
Step 4, on CAD part drawing, fill in process data, then terminate;
Step 5, carrying out miscue in CAD command bar, then terminate, wherein miscue includes the parameter type of mistake and the sample bar coordinate of wrong data.
Described first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is made up of engineering name, processing radix, processing total quantity, gross weight and Product Status.
The preferred embodiment of the present invention described in detail above.Should be appreciated that those of ordinary skill in the art just can make many modifications and variations according to the design of the present invention without creative work. Therefore, all technical staff in the art, all should in the protection domain being defined in the patent claims under this invention's idea on the basis of existing technology by the available technical scheme of logical analysis, reasoning, or a limited experiment.
Claims (2)
1. the process chart data creation method based on CAD, it is characterised in that sequentially include the following steps:
Step one, open CAD part drawing and Microsoft Excel;
Step 2, extracting part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data extracted in Microsoft Excel forms the second data link table;
Step 3, described first data link table and the second data link table are mated;
Set described first data link table and the second data link table all includes n part data, n is positive integer, first part data in first data link table is mated with first part data in described second data link table, second part data in second data link table is mated with second part data in described second data link table, until the part data that in the first data link table, all part datas are corresponding with described second data link table has mated; When the n-th part data in described first data link table is with corresponding part data coupling in described second data link table, perform step 4; When the n-th part data in described first data link table does not mate with corresponding part data in described second data link table, perform step 5;
Step 4, on CAD part drawing, fill in process data, then terminate;
Step 5, carrying out miscue in CAD command bar, then terminate, wherein miscue includes the parameter type of mistake and the sample bar coordinate of wrong data.
2. the process chart data creation method based on CAD as claimed in claim 1, is characterized in that: described first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is made up of engineering name, processing radix, processing total quantity, gross weight and Product Status.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213098.4A CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213098.4A CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103324681A CN103324681A (en) | 2013-09-25 |
| CN103324681B true CN103324681B (en) | 2016-06-08 |
Family
ID=49193424
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310213098.4A Active CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103324681B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281727A (en) * | 2014-06-04 | 2015-01-14 | 河南金牌山模具有限公司 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
| CN104460523A (en) * | 2014-10-31 | 2015-03-25 | 沈阳黎明航空发动机(集团)有限责任公司 | Part machining method based on excel software |
| CN107273417A (en) * | 2017-05-11 | 2017-10-20 | 广东卓信环境科技股份有限公司 | The generation method and device of a kind of pipeline rout figure BOM |
| CN108228866A (en) * | 2018-01-15 | 2018-06-29 | 苏州索及信息技术有限公司 | A kind of method and system for matching parts to be processed and processing producer's manufacturing process |
| CN109408999A (en) * | 2018-11-08 | 2019-03-01 | 中铁山桥集团有限公司 | A method of intelligence generates steel construction part manufacturing process card |
| CN112182684A (en) * | 2020-08-31 | 2021-01-05 | 大明重工有限公司 | Batch head parameterized process card generation method and system |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101068635A (en) * | 2004-04-08 | 2007-11-07 | 工业纸折品有限公司 | Method of designing fold lines in sheet material |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002082994A (en) * | 2000-06-28 | 2002-03-22 | Fujitsu Ltd | Internet data base |
-
2013
- 2013-05-31 CN CN201310213098.4A patent/CN103324681B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101068635A (en) * | 2004-04-08 | 2007-11-07 | 工业纸折品有限公司 | Method of designing fold lines in sheet material |
Non-Patent Citations (3)
| Title |
|---|
| CAPP系统中工艺卡片生成过程的研究;杜春涛等;《现代制造工程》;20030618(第06期);第41-43页 * |
| 基于XML的CAPP数据库设计;董加强等;《矿山机械》;20060420(第04期);第119-121页 * |
| 工艺卡片中AutoCAD的应用;严正江;《工艺》;19960430;第47-48页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103324681A (en) | 2013-09-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103324681B (en) | Process chart data creation method based on CAD | |
| CN102930114B (en) | Electronic product EDA designs the visible detection method of manufacturability | |
| CN103235996A (en) | Material coding management method and material coding management system | |
| CN103955577A (en) | Computer automatic design method for mechanical equipment | |
| CN103279622A (en) | Method for dispatching distributed simulation models in aircraft simulation system | |
| CN104111867B (en) | A kind of virtual machine (vm) migration device and method | |
| CN108073688A (en) | A kind of method and device of Data Migration | |
| Song et al. | Advances in shape-free finite element methods: a review | |
| CN103870540A (en) | Database based on structural design and analysis integration | |
| CN101706837A (en) | Mathematical model based method for establishing database of fixture components | |
| CN107562808B (en) | Method for verifying heterogeneous double-chain automatic data | |
| CN102902769A (en) | Database benchmark test system of cloud computing platform and method thereof | |
| CN101777151A (en) | Realization method for packing list BOM | |
| CN105573972A (en) | Report check formula generation method and apparatus | |
| CN103902516A (en) | Data generating method and device | |
| CN104808961B (en) | The scripting adjusting method of display interface module parameter | |
| CN103870906A (en) | Encoding method of airplane parts | |
| CN106682275B (en) | Load processing method and device for industrial factory building structure modeling | |
| CN206274113U (en) | It is a kind of can auto-folder computer support frame | |
| CN105095538B (en) | The dimensionally-optimised system and method for connector | |
| CN107957983A (en) | A kind of automatic after-treatment system and implementation method based on Abaqus | |
| CN105259879A (en) | Remote control system for 3D printers | |
| CN105975696A (en) | Rule-based three-dimensional procedure size layout method | |
| CN106202697B (en) | A kind of method and system convenient for doing steel tower design comparison in difference | |
| CN101149595A (en) | Production executive system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |