CN110543480A - hole table creating and updating system based on CAD system and use method of system - Google Patents

hole table creating and updating system based on CAD system and use method of system Download PDF

Info

Publication number
CN110543480A
CN110543480A CN201910777035.9A CN201910777035A CN110543480A CN 110543480 A CN110543480 A CN 110543480A CN 201910777035 A CN201910777035 A CN 201910777035A CN 110543480 A CN110543480 A CN 110543480A
Authority
CN
China
Prior art keywords
hole
data set
characteristic information
coordinates
hole table
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.)
Withdrawn
Application number
CN201910777035.9A
Other languages
Chinese (zh)
Inventor
刘建钊
刘元珍
黄曙荣
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yangcheng Institute of Technology
Original Assignee
Yangcheng Institute of Technology
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yangcheng Institute of Technology filed Critical Yangcheng Institute of Technology
Priority to CN201910777035.9A priority Critical patent/CN110543480A/en
Publication of CN110543480A publication Critical patent/CN110543480A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Numerical Control (AREA)

Abstract

the invention discloses a hole table creating and updating system based on a CAD system, which comprises a data acquisition module and a hole table processing module, wherein the data acquisition module is used for traversing all holes in a three-dimensional model in the CAD system, acquiring hole characteristic information of each hole and sending the hole characteristic information to the hole table processing module, and the hole table processing module generates or updates a hole table in an engineering drawing in the CAD system through the hole characteristic information, wherein the hole characteristic information comprises coordinates, diameters and depths of the holes in the three-dimensional model. The invention can record the processing information of all holes in the three-dimensional model, improve the creating speed, the updating speed and the deleting speed of the hole table, reduce the error rate and improve the design efficiency.

Description

Hole table creating and updating system based on CAD system and use method of system
Technical Field
the invention relates to the technical field of computer assistance, in particular to a hole table creating and updating system based on a computer-aided design (CAD) system and a using method of the system.
background
with the development of the mechanical industry, three-dimensional CAD software represented by NX and Catia is more and more widely applied. Many mechanical parts contain a large number of holes of different forms and specifications, and if the relevant data of each hole is marked in the drawing of the drawing, the drawing is very messy, and a process designer is inconvenient to compile a part machining process. It is therefore common practice to assign a separate number to each hole, create a table in the drawing sheet, record the number, position, diameter, depth, notes, etc. of a hole in each row, and identify the number of the hole in the view. However, the method has a plurality of complex defects in the actual related process, which are mainly reflected in the following aspects:
(1) engineers need to measure or calculate the coordinates, diameters and the like of each hole and fill the information into the form one by one, and the process is not only complicated but also easy to make mistakes;
(2) For ease of processing before filling in the form data, it is usually necessary to order all the holes according to a certain rule, such as: holes of the same diameter should be adjacent in the table;
(3) in mechanical design, it is a very common practice to modify the design, such as modifying the diameter, coordinates, etc. of a hole, or to modify a simple hole into a stepped hole, etc., at which time the engineer must manually modify the existing hole table, or even delete or reconstruct the table.
Disclosure of Invention
The purpose of the invention is as follows: aiming at the problems of high labor consumption, high error rate and low efficiency in the process of creating, updating and deleting the hole table, the invention provides a hole table creating and updating system based on a CAD system and a using method of the hole table creating and updating system.
the technical scheme is as follows: in order to realize the purpose of the invention, the technical scheme adopted by the invention is as follows:
A hole table creating and updating system based on a CAD system comprises a data acquisition module and a hole table processing module, wherein the data acquisition module is used for traversing all holes in a three-dimensional model in the CAD system, acquiring hole characteristic information of each hole and sending the hole characteristic information to the hole table processing module, and the hole table processing module generates or updates a hole table in an engineering drawing in the CAD system through the hole characteristic information, wherein the hole characteristic information comprises coordinates, diameters and depths of the holes in the three-dimensional model.
A use method of a hole table creation and update system specifically comprises the following steps:
S1: acquiring hole characteristic information corresponding to all holes in the three-dimensional model through the data acquisition module, and establishing a data set according to the hole characteristic information;
S2: processing the data set according to the hole characteristic information in the data set, and transmitting the processed data set to a hole table processing module;
S3: and checking whether a hole table exists in the engineering drawing, if not, the hole table processing module creates the hole table in the engineering drawing according to the processed data set, and if so, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set.
further, in step S2, the data set is processed as follows:
S2.1: merging different hole characteristic information corresponding to the same coordinate in the three-dimensional model in the data set, and sequencing the hole characteristic information in the merged data set according to the coordinate of the hole in the three-dimensional model;
S2.2: and arranging hole characteristic information corresponding to holes with the same diameter in the three-dimensional model together in the data set ordered according to the coordinates.
further, in step S3, the hole table processing module creates a hole table in the engineering drawing according to the processed data set, specifically as follows:
SA 3.1: the hole table processing module creates a table in the engineering drawing according to the processed data set and fills the created table according to hole characteristic information corresponding to each hole in the processed data set;
SA 3.2: creating a numbered label for each hole in the view of the engineering drawing according to the ranking of each hole in the processed dataset.
further, in step S3, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set, specifically as follows:
SB 3.1: comparing the coordinates in the existing hole table with the coordinates in the processed data set, and judging whether the coordinates in the existing hole table have the same coordinates in the processed data set, if so, executing step SB3.2, and if not, executing step SB 3.3;
SB 3.2: comparing the diameter and depth of the coordinates corresponding to the existing hole table with the diameter and depth of the coordinates corresponding to the processed data set, and if the diameters and depths are equal, keeping the diameters and depths of the coordinates corresponding to the existing hole table unchanged;
If not, modifying the corresponding diameter and depth in the existing hole table into the corresponding diameter and depth in the processed data set;
SB 3.3: inserting a new row into the existing hole table according to the sorting information corresponding to the coordinates in the processed data set, writing the hole characteristic information corresponding to the coordinates into the row, and adding the number label of the hole corresponding to the coordinates in the view of the engineering drawing;
SB 3.4: judging whether the type of the hole corresponding to the coordinates in the existing hole table is changed from a simple hole to a stepped hole or not, if so, inserting a new column into the existing hole table, and recording the diameter and the depth of the stepped hole in the column;
And if the simple hole is not changed into the stepped hole, deleting the hole characteristic information corresponding to the coordinate in the existing hole table, and deleting the number label of the hole corresponding to the coordinate in the view of the engineering drawing.
Has the advantages that: compared with the prior art, the technical scheme of the invention has the following beneficial technical effects:
According to the hole table creating and updating system and the using method of the hole table creating and updating system, the data acquisition module is used for collecting hole characteristic information in the three-dimensional model, the data set is established, and the hole table processing module can rapidly create, update and delete the hole table in the engineering drawing according to the received data set, so that processing information of all holes in the three-dimensional model can be recorded, the creating speed, the updating speed and the deleting speed of the hole table are improved, the error rate is reduced, and the design efficiency is improved.
Drawings
FIG. 1 is a flow chart schematic of a method of use of the hole table creation and update system of the present invention;
FIG. 2 is a schematic flow chart of the hole table creation and update operation of the present invention;
FIG. 3 is a flow diagram illustrating a hole table delete operation of the present invention.
Detailed Description
in order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention. The described embodiments are a subset of the embodiments of the invention and are not all embodiments of the invention. Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention.
Example 1
Referring to fig. 1, the present embodiment provides a hole table creating and updating system based on a CAD system, which includes a data acquiring module and a hole table processing module.
the data acquisition module is used for traversing all holes in the three-dimensional model in the CAD system, and acquiring hole characteristic information corresponding to each hole in the three-dimensional model, wherein the hole characteristic information comprises coordinates, diameters and depths of the holes in the three-dimensional model. Meanwhile, the data acquisition module can also establish a data set according to the hole characteristic information corresponding to each hole, and after the data set is processed, the processed data set is sent to the hole table processing module.
the hole table processing module is used for receiving the processed data set and generating or updating a hole table in the engineering drawing in the CAD system according to the processed data set.
referring to fig. 2 and fig. 3, the present embodiment further provides a method for using a hole table creating and updating system, which specifically includes the following steps:
Step S1: and acquiring the coordinates, the diameter and the depth of each hole in the three-dimensional model in the CAD system in the three-dimensional model through a data acquisition module, and establishing a data set according to the coordinates, the diameter and the depth corresponding to each hole. In this embodiment, one of the data sets stores hole characteristic information of one hole, i.e., coordinates, diameter, and depth corresponding to one hole. Specifically, the hole characteristic information of each hole is recorded by using a structured data format in the form of { X coordinate, Y coordinate, diameter 1, depth 1 }. Thus, the number of data in the data set is the same as the number of holes in the three-dimensional model.
step S2: processing the data set according to the hole characteristic information corresponding to each data in the data set, and transmitting the processed data set to the hole table processing module, wherein the specific steps are as follows:
Step S2.1: in the data set created in step S1, different hole feature information corresponding to the same coordinate in the three-dimensional model is merged, that is, when the X coordinate value and the Y coordinate value corresponding to different data in the data set are the same, the data with the same coordinate are merged together.
and in the data set after the data are combined, sequencing all the data in sequence according to the coordinate size corresponding to each data in the data set. The coordinates corresponding to each datum comprise an X coordinate and a Y coordinate, so that when the data are sequenced in sequence, the data can be sequenced according to the size of the X coordinate value in a descending order, or sequenced according to the size of the Y coordinate value in a descending order, or sequenced according to a descending order.
step S2.2: and in the data sets sorted according to the coordinate sizes, sorting the data in the data sets again according to the diameter size corresponding to each data. Specifically, different data having the same diameter are arranged in accordance with the diameter size corresponding to each data.
step S3: and verifying whether a perforated table exists in the engineering drawing in the CAD system, and if so, creating the perforated table in the engineering drawing according to the processed data set by the perforated table processing module. And if the hole table does not exist, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set.
In this embodiment, specifically, the hole table processing module creates a hole table in the engineering drawing according to the processed data set, specifically as follows:
step SA 3.1: the hole table processing module creates a table in the engineering drawing according to the processed data set, and fills each row of the created table according to each data in the processed data set, namely, a row of tables is filled with hole characteristic information corresponding to one data.
Step SA 3.2: a number label is created for each hole in the CAD system in the order of arrangement in the view of the engineering drawing according to the order in which each hole is arranged in the processed dataset.
in this embodiment, specifically, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set, specifically as follows:
step SB 3.1: comparing the coordinates in the existing hole table with the coordinates in the processed data set, determining whether the coordinates in the existing hole table have the same coordinates in the processed data set, and if so, indicating that the holes corresponding to the two coordinates are the same hole, then executing step SB 3.2.
If the three-dimensional model does not exist, the hole corresponding to the coordinate in the existing hole table is modified or deleted, and then the steps SB3.3 to SB3.4 are sequentially executed.
step SB 3.2: the diameter and depth of the coordinate in the existing hole table and the diameter and depth of the coordinate in the processed data set are compared, and when the two are equal, the diameter and depth of the coordinate in the existing hole table will remain the same.
when the two are not equal, the corresponding diameter and depth of the coordinate in the existing hole table are modified into the corresponding diameter and depth of the coordinate in the processed data set.
Step SB 3.3: inserting a new row into the existing hole table according to the sorting information corresponding to the coordinates in the processed data set, writing the hole feature information corresponding to the coordinates in the processed data set into the row, and adding the number label of the hole corresponding to the coordinates in the view of the engineering drawing in the CAD system.
Step SB 3.4: for a hole corresponding to the coordinate in the existing hole table, the type of the hole corresponding to the coordinate needs to be further determined. Specifically, it is determined whether the type of hole corresponding to the coordinates in the existing hole table is changed from a simple hole to a stepped hole, and if the type of hole is changed from a simple hole to a stepped hole, a new column is inserted into the existing hole table, and the diameter and depth of the stepped hole are recorded in the column.
If the simple hole is not changed into the stepped hole, the hole characteristic information corresponding to the coordinate is deleted from the existing hole table, and the number label of the hole corresponding to the coordinate is deleted from the view of the engineering drawing.
The present invention and its embodiments have been described in an illustrative manner, and are not to be considered limiting, as illustrated in the accompanying drawings, which are merely exemplary embodiments of the invention and not limiting of the actual constructions and methods. Therefore, if the person skilled in the art receives the teaching, the structural modes and embodiments similar to the technical solutions are not creatively designed without departing from the spirit of the invention, and all of them belong to the protection scope of the invention.

Claims (5)

1. the hole table creating and updating system based on the CAD system is characterized by comprising a data acquisition module and a hole table processing module, wherein the data acquisition module is used for traversing all holes in a three-dimensional model in the CAD system, acquiring hole characteristic information of each hole and sending the hole characteristic information to the hole table processing module, and the hole table processing module generates or updates a hole table in an engineering drawing in the CAD system through the hole characteristic information, wherein the hole characteristic information comprises coordinates, diameters and depths of the holes in the three-dimensional model.
2. A method for using the hole table creation and update system according to claim 1, wherein the method specifically comprises the steps of:
s1: acquiring hole characteristic information corresponding to all holes in the three-dimensional model through the data acquisition module, and establishing a data set according to the hole characteristic information;
S2: processing the data set according to the hole characteristic information in the data set, and transmitting the processed data set to a hole table processing module;
S3: and checking whether a hole table exists in the engineering drawing, if not, the hole table processing module creates the hole table in the engineering drawing according to the processed data set, and if so, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set.
3. The method for using a hole table creating and updating system as claimed in claim 2, wherein in the step S2, the data set is processed as follows:
S2.1: merging different hole characteristic information corresponding to the same coordinate in the three-dimensional model in the data set, and sequencing the hole characteristic information in the merged data set according to the coordinate of the hole in the three-dimensional model;
S2.2: and arranging hole characteristic information corresponding to holes with the same diameter in the three-dimensional model together in the data set ordered according to the coordinates.
4. the method for using the hole table creating and updating system as claimed in claim 2 or 3, wherein in the step S3, the hole table processing module creates the hole table in the engineering drawing according to the processed data set, specifically as follows:
SA 3.1: the hole table processing module creates a table in the engineering drawing according to the processed data set and fills the created table according to hole characteristic information corresponding to each hole in the processed data set;
SA 3.2: creating a numbered label for each hole in the view of the engineering drawing according to the ranking of each hole in the processed dataset.
5. the method for using a hole table creating and updating system according to claim 2 or 3, wherein in the step S3, the hole table processing module updates or deletes the hole table in the engineering drawing according to the processed data set, specifically as follows:
SB 3.1: comparing the coordinates in the existing hole table with the coordinates in the processed data set, judging whether the coordinates in the existing hole table have the same coordinates in the processed data set, if so, executing a step SB3.2, and if not, sequentially executing the steps SB 3.3-SB 3.4;
SB 3.2: comparing the diameter and depth of the coordinates corresponding to the existing hole table with the diameter and depth of the coordinates corresponding to the processed data set, and if the diameters and depths are equal, keeping the diameters and depths of the coordinates corresponding to the existing hole table unchanged;
If not, modifying the corresponding diameter and depth in the existing hole table into the corresponding diameter and depth in the processed data set;
SB 3.3: inserting a new row into the existing hole table according to the sorting information corresponding to the coordinates in the processed data set, writing the hole characteristic information corresponding to the coordinates into the row, and adding the number label of the hole corresponding to the coordinates in the view of the engineering drawing;
SB 3.4: judging whether the type of the hole corresponding to the coordinates in the existing hole table is changed from a simple hole to a stepped hole or not, if so, inserting a new column into the existing hole table, and recording the diameter and the depth of the stepped hole in the column;
and if the simple hole is not changed into the stepped hole, deleting the hole characteristic information corresponding to the coordinate in the existing hole table, and deleting the number label of the hole corresponding to the coordinate in the view of the engineering drawing.
CN201910777035.9A 2019-08-22 2019-08-22 hole table creating and updating system based on CAD system and use method of system Withdrawn CN110543480A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910777035.9A CN110543480A (en) 2019-08-22 2019-08-22 hole table creating and updating system based on CAD system and use method of system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910777035.9A CN110543480A (en) 2019-08-22 2019-08-22 hole table creating and updating system based on CAD system and use method of system

Publications (1)

Publication Number Publication Date
CN110543480A true CN110543480A (en) 2019-12-06

Family

ID=68711860

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910777035.9A Withdrawn CN110543480A (en) 2019-08-22 2019-08-22 hole table creating and updating system based on CAD system and use method of system

Country Status (1)

Country Link
CN (1) CN110543480A (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110157157A1 (en) * 2009-12-24 2011-06-30 Hong Fu Jin Precision Industry (Shenzhen) Co., Ltd. System and method for displaying a three-dimensional object
CN109448091A (en) * 2018-11-12 2019-03-08 广东工业大学 Information extracting method, device, system and the storage medium of CAD engineering drawing

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110157157A1 (en) * 2009-12-24 2011-06-30 Hong Fu Jin Precision Industry (Shenzhen) Co., Ltd. System and method for displaying a three-dimensional object
CN109448091A (en) * 2018-11-12 2019-03-08 广东工业大学 Information extracting method, device, system and the storage medium of CAD engineering drawing

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
周南宁 等: "基于UG的塑料模三维设计与二维标注的自动关联处理技术研究", 《机电工程技术》 *
曾心延 等: "基于NX的关联式孔表创建技术研究", 《模具工业》 *

Similar Documents

Publication Publication Date Title
CN110765523A (en) BIM technology-based rapid construction method for deep foundation pit support structure
CN113051885B (en) AutoCAD-based design drawing rapid typesetting method
CN101027672A (en) Automatic drawing creation system
CN105718653A (en) Automatic checking method of annotated information completeness for MBD (Model Based Definition) process model
CN110866024B (en) Vector database increment updating method and system
CN105468869B (en) Topological relation analysis method of PDS model
CN103164489A (en) Quick comparative method for integrated circuit domain data base
CN111143478A (en) Two-three-dimensional file association method based on lightweight model and engineering object bit number
CN108776660B (en) ArcGIS-based method for matching road attributes in batches
CN110795835A (en) Three-dimensional process model reverse generation method based on automatic synchronous modeling
CN108279013B (en) Method and device for checking and correcting incremental data of electronic map and navigation system
CN110597821B (en) Method and device for changing database table structure
CN106557881B (en) Business process system construction method based on business activity execution sequence
CN113704343A (en) Data blood margin visualization implementation method and system in data processing
US20210333777A1 (en) Section identification system
CN104145223B (en) Processing program generating device and processor generate method
CN110543480A (en) hole table creating and updating system based on CAD system and use method of system
CN109947705A (en) A kind of access System and method for of petroleum works data
CN103729516A (en) Three-dimensional technology inverted sequence modeling method and device
JP2016532897A (en) Method and apparatus for building an intermediate character library
CN111199086A (en) Three-dimensional geometric discretization processing system
CN107229687A (en) A kind of batch is converted to dft file the system and method for DWG file
CN103729513A (en) Three-dimensional technology sequential modeling method and device
CN103377050A (en) SMT (surface mounted technology) machine program coordinate transformation method
CN114331135A (en) Process flow management method, device, equipment and storage medium

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
WW01 Invention patent application withdrawn after publication
WW01 Invention patent application withdrawn after publication

Application publication date: 20191206