CN107025287A - A kind of AutoCAD drawing informations storage method - Google Patents
A kind of AutoCAD drawing informations storage method Download PDFInfo
- Publication number
- CN107025287A CN107025287A CN201710237234.1A CN201710237234A CN107025287A CN 107025287 A CN107025287 A CN 107025287A CN 201710237234 A CN201710237234 A CN 201710237234A CN 107025287 A CN107025287 A CN 107025287A
- Authority
- CN
- China
- Prior art keywords
- autocad
- information
- attribute information
- quick response
- storage method
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Processing Or Creating Images (AREA)
Abstract
The present invention devises a kind of AutoCAD drawing informations storage method, including：Step 1, fixed attribute information handling step, stores the fixed attribute information of AutoCAD drawings, and the fixed attribute information includes drawing source, Drawing design information, drawing check information etc.；Step 2, variable attribute information handling step, stores the variable attribute information of AutoCAD drawings, and the variable attribute information includes size, material and quantity got the raw materials ready etc.；Step 3, Quick Response Code automatically generates step, and the Quick Response Code, which automatically generates step, to be included extracting the fixed attribute information and real-time property information generation QR Quick Response Codes；Step 4, bar code automatic addressing step, the bar code automatic addressing step includes being arranged on the QR Quick Response Codes generated into the ad-hoc location of drawing.
Description
Technical field
The present invention relates to AutoCAD software drawing information field of storage, more specifically to a kind of AutoCAD drawings
Information storage means.
Background technology
AutoCAD has very as the most widely used computer aided design software in the world today in all trades and professions
It is extensive to use.Especially in construction industry, because its powerful function is even more the efficiency for effectively raising product design, contracting
The short production cycle of product, create more industrial values.In industrial design, the very huge drawing text of quantity can be produced
Part, institutional framework, chart file data, the map file content of these drawing files also have very big difference.It is more next with drawing file
It is more, using original extensive style labor management, it will making the management of drawing becomes complicated, superfluous heavy, while be also not easy to drawing,
The quick search of drawing content and retrieval, can not more solve the problems, such as Design-Oriented process, dynamic management of blueprint.
Now by the drawing of AutoCAD software development, its drawing information is all manually to go to make simply by the later stage
Form, is then achieved by paper drawing, but paper drawing archival storage information is relatively few, and without so complete.
The content of the invention
In order to solve the storage for the drawing information that AutoCAD draws, deposited the invention provides a kind of AutoCAD drawing informations
Method for storing, effective storage for drawing information.
A kind of AutoCAD drawing informations storage method that the present invention is provided, including：
Step 1, fixed attribute information handling step, stores the fixed attribute information of AutoCAD drawings, the fixed attribute
Information includes drawing source, Drawing design information, drawing check information；
Step 2, variable attribute information handling step, stores the variable attribute information of AutoCAD drawings, the variable attribute
Information includes size, material and the quantity got the raw materials ready；
Step 3, Quick Response Code automatically generates step, and the Quick Response Code, which automatically generates step, to be included extracting the fixed attribute
Information and real-time property information generation QR Quick Response Codes；
Step 4, bar code automatic addressing step, the bar code automatic addressing step includes setting the QR Quick Response Codes generated
Put the ad-hoc location in drawing.
As a kind of prioritization scheme, also include before the step 1：
It is used for the SQL that corresponding database table is set up according to the classification of drawing specification information in outside Database
Sever databases, the corresponding content format of the database table is customized according to import information.
As a kind of prioritization scheme, the step 2 further comprises：
Step 2.1, AutoCAD and SQL Sever databases are configured in AutoCAD systems in AutoCAD systems
In directly store, call the annexation of drawing information；
Step 2.2, under AutoCAD system environments, information input interface is started；
Step 2.3, in the described information inputting interface of startup, it is manually entered the variable attribute information of drawing.
As a kind of prioritization scheme, the process of the variable attribute information of drawing is manually entered in the step 2.3 also
Including：Automatic detection simultaneously stores the information being manually entered, and the information that current manual is inputted and history input information progress pair
Than being filled automatically after obtaining matching degree highest history input information.
As a kind of prioritization scheme, the step 3 is that the QR Quick Response Codes are automatically generated under AutoCAD system environments.
As a kind of prioritization scheme, the step 3 further comprises：
Step 3.1, data message extraction step, under AutoCAD software environments, according to default data extraction standard,
Designed drawing information is extracted；
Step 3.2, data message integration step, by the data message of extraction by retrieval, rejects duplicate message, and again
Arrangement；
Step 3.3, the data rearranged under AutoCAD system environments, are generated QR bars by data message generation step
Shape code.
As a kind of prioritization scheme, the step 3.3 also includes：
AutoCAD built-in functions are called under AutoCAD system environments to generate two-dimension code image, and with
AutoCAD systems share memory space.
As a kind of prioritization scheme, also include in the step 4：Sideline intersection point and sideline by AutoCAD drawing frames
The virtual coordinate system of foundation determines to set the ad-hoc location of QR Quick Response Codes.
As a kind of prioritization scheme, also include after the step 4：After output information is received, according to Excel
The form of form formulates AutoCAD drawings in output information corresponding the fixed attribute information and/or variable attribute information
Into the output of BOM tables.
The application is by designing the functional module that a AutoCAD drawing informations are stored, by the storage application of drawing information
In on the combination technology of database and QR Quick Response Codes, so that the easy management of drawing, inquiry.
Brief description of the drawings
, below will be to embodiment or description of the prior art for the technical scheme of the clearer expression invention implementation process
In required for the accompanying drawing that uses be briefly described.
Fig. 1 is a kind of flow chart of the invention；
Fig. 2 is SQL Sever database structure figures of the invention；
Fig. 3 automatically generates steps flow chart schematic diagram for a kind of Quick Response Code of the present invention；
Fig. 4 sets schematic diagram for a kind of Quick Response Code of the invention；
Fig. 5 is whole schematic diagram of the function of the invention.
Embodiment
In order that the object, technical solutions and advantages of the present invention are clearer, below in conjunction with to embodiments of the invention
Accompanying drawing is described in detail.
A kind of AutoCAD drawing informations storage method that the present invention is provided, referring to Fig. 1, including：
Step 1, fixed attribute information handling step, stores the fixed attribute information of AutoCAD drawings, the fixed attribute
Information includes drawing source, Drawing design information, drawing check information；Drawing source mainly includes the information of designer.It is described
Which Standard and assembly relation mainly be used for including the part that the drawing is drawn for Drawing design information.The drawing
Checking information mainly includes checking personal information.
Step 2, variable attribute information handling step, stores the variable attribute information of AutoCAD drawings, the variable attribute
Information includes size, material and the quantity got the raw materials ready.
Step 3, Quick Response Code automatically generates step, and the Quick Response Code, which automatically generates step, to be included extracting the fixed attribute
Information and real-time property information generation QR Quick Response Codes.
Step 4, bar code automatic addressing step, the bar code automatic addressing step includes setting the QR Quick Response Codes generated
Put the ad-hoc location in drawing.
As a kind of prioritization scheme, also include before the step 1：
It is used for the SQL that corresponding database table is set up according to the classification of drawing specification information in outside Database
Sever databases, the corresponding content format of the database table is customized according to import information.
As a kind of prioritization scheme, the step 2 further comprises：
Step 2.1, AutoCAD and SQL Sever databases are configured in AutoCAD systems in AutoCAD systems
In directly store, call the annexation of drawing information；
Step 2.2, under AutoCAD system environments, information input interface is started；
Step 2.3, in the described information inputting interface of startup, it is manually entered the variable attribute information of drawing.
As a kind of prioritization scheme, the process of the variable attribute information of drawing is manually entered in the step 2.3 also
Including：Automatic detection simultaneously stores the information being manually entered, and the information that current manual is inputted and history input information progress pair
Than being filled automatically after obtaining matching degree highest history input information.
As a kind of prioritization scheme, the step 3 is that the QR Quick Response Codes are automatically generated under AutoCAD system environments.
As a kind of prioritization scheme, the step 3 further comprises：
Step 3.1, data message extraction step, under AutoCAD software environments, according to default data extraction standard,
Designed drawing information is extracted；
Step 3.2, data message integration step, by the data message of extraction by retrieval, rejects duplicate message, and again
Arrangement；
Step 3.3, the data rearranged under AutoCAD system environments, are generated QR bars by data message generation step
Shape code.QR codes are one kind of two-dimensional bar code, QR from English " meaning of Quick Response " abbreviation, i.e. fast reaction,
Wish that QR codes can allow its content to be quickly decoded from inventor.QR codes can store additional information than common bar code, also without picture
As common bar code adjusting to a line scanner is needed in scanning.
As a kind of prioritization scheme, the step 3.3 also includes：
AutoCAD built-in functions are called under AutoCAD system environments to generate two-dimension code image, and with
AutoCAD systems share memory space.
As a kind of prioritization scheme, also include in the step 4：Sideline intersection point and sideline by AutoCAD drawing frames
The virtual coordinate system of foundation determines to set the ad-hoc location of QR Quick Response Codes.
As a kind of prioritization scheme, also include after the step 4：After output information is received, according to Excel
The form of form formulates AutoCAD drawings in output information corresponding the fixed attribute information and/or variable attribute information
Into the output of BOM tables.
Fig. 1 is a kind of AutoCAD drawing informations storage method flow chart disclosed in the embodiment of the present invention.
As shown in figure 1, the function includes：
Step S100, design database structural framing simultaneously sets up corresponding database table；
Specifically, according to fixed attribute information and the relevance of variable attribute information, design relation type database structure,
Critical field is set to major key in variable attribute information table, while the external key of fixed attribute information is set to, for ensuring data
Relevance, be specifically shown in Fig. 2.
Step S110, database is imported by the fixed attribute information in the BOM tables established；
Step S120, inputting interface input and incoming data storehouse are passed through by variable attribute information；
Specifically, build sheet format according to Excel and formulate BOM tables, according to title arrangement, addition drawing information and dependency number
According to then being imported data to by database introducting interface.Also include inputting in data form manually simultaneously, change information.
Then The Component Object Model (COM) technology based on ActiveX technologies is used, AutoCAD is communicatively coupled with database,
And start variable attribute information input interface under AutoCAD environment, by manually by size, material, the number of such as being got the raw materials ready when designing
The information input of amount etc., and be transferred in background data base.
Step S130, extracts the drawing information stored in database and integration by data extracting unit, is given birth to by data
QR Quick Response Codes are generated into unit.
Specifically, related drawing information, the letter of extraction are extracted from database by data extracting unit S301 in such as Fig. 3
The method of breath is, according to array linear array, then to arrange cell S 302 by data message, carry out first trip key search, will
Row are repeated in fixed attribute information table and variable attribute information table to search out, and are found out repeating part by retrieving completely
Come, and propose repeating part, finally the data integrated are arranged according to order successively and there is corresponding memory cell and (are determined
The array of justice).
Further, with ObjectARX secondary exploitation technologies, generated in AutoCAD by information generating unit S303
QR Quick Response Codes.
Specifically, the essence of QR Quick Response Codes is exactly multiple black, white small square composition big squares, in AutoCAD
By drawing rectangle frame, pass through filling, it is possible to achieve automatically generate Quick Response Code under system environments.First, AutoCAD software defaults
Background environment S402 be ater, by Fig. 4 Quick Response Code generation figure S401, pass through set a 50 × 50mm pure white
Square background frame, then according to Quick Response Code version number X, background frame is divided into (4X+17) × (4X+17) grid, finally
According to the create-rule of QR Quick Response Codes, corresponding grid is filled into black, so as under AutoCAD environment, share storage empty
Between, generate QR Quick Response Codes.
Step S140, addresses function by Quick Response Code and the Quick Response Code of generation is placed on to the generation position specified.
Specifically, such as Fig. 4, by capturing picture frame S403, the scale of picture frame, the angle point in the selection picture frame lower right corner are obtained
As the origin of virtual rectangular coordinate system, corresponding picture frame sideline is respectively as transverse axis and vertical pivot.Then Quick Response Code will be adhered to
White background frame be placed in the drawing frame of relative position, while be amplified diminution according to the block diagram ratio of the drawing frame of acquisition,
So as to generate the QR Quick Response Codes with drawing information in AutoCAD drawing frames.
In summary, such as Fig. 5, the present invention is the data processing by early stage, and drawing information is passed through into fixed attribute information
In two kinds of deposit databases of variable attribute information, information is extracted by information extraction unit, and generates corresponding Quick Response Code,
Under AutoCAD environment, Quick Response Code is placed in drawing frame specified location.
Presently preferred embodiments of the present invention is the foregoing is only, those skilled in the art know, do not departing from the essence of the present invention
In the case of refreshing and scope, various changes or equivalent substitution can be carried out to these features and embodiment.In addition, the present invention's
Under teaching, these features and embodiment can be modified to adapt to particular situation and material without departing from the present invention's
Spirit and scope.Therefore, the present invention is not limited to the particular embodiment disclosed, and the right for falling with the application will
Embodiment in the range of asking belongs to protection scope of the present invention.
Claims (9)
1. a kind of AutoCAD drawing informations storage method, it is characterised in that including：
Step 1, fixed attribute information handling step, stores the fixed attribute information of AutoCAD drawings, the fixed attribute information
Information is checked including drawing source, Drawing design information, drawing；
Step 2, variable attribute information handling step, stores the variable attribute information of AutoCAD drawings, the variable attribute information
Including the size, material and quantity got the raw materials ready；
Step 3, Quick Response Code automatically generates step, and the Quick Response Code, which automatically generates step, to be included extracting the fixed attribute information
QR Quick Response Codes are generated with real-time property information；
Step 4, bar code automatic addressing step, the bar code automatic addressing step includes the QR Quick Response Codes generated being arranged on
The ad-hoc location of drawing.
2. a kind of AutoCAD drawing informations storage method according to claim 1, it is characterised in that before the step 1
Also include：
It is used for the SQL Sever that corresponding database table is set up according to the classification of drawing specification information in outside Database
Database, the corresponding content format of the database table is customized according to import information.
3. a kind of AutoCAD drawing informations storage method according to claim 2, it is characterised in that the step 2 enters one
Step includes：
Step 2.1, AutoCAD and SQL Sever databases are configured in AutoCAD systems directly in AutoCAD systems
Connect storage, call the annexation of drawing information；
Step 2.2, under AutoCAD system environments, information input interface is started；
Step 2.3, in the described information inputting interface of startup, it is manually entered the variable attribute information of drawing.
4. a kind of AutoCAD drawing informations storage method according to claim 3, it is characterised in that in the step 2.3
Being manually entered the process of the variable attribute information of drawing also includes：Automatic detection simultaneously stores the information being manually entered, and will
The information of current manual input is contrasted with history input information, is filled out automatically after obtaining matching degree highest history input information
Fill.
5. a kind of AutoCAD drawing informations storage method according to claim 1, it is characterised in that the step 3 be
The QR Quick Response Codes are automatically generated under AutoCAD system environments.
6. a kind of AutoCAD drawing informations storage method according to claim 1, it is characterised in that the step 3 is further
Including：
Step 3.1, data message extraction step, under AutoCAD software environments, according to default data extraction standard, by
Extracted through designed drawing information；
Step 3.2, data message integration step, by the data message of extraction by retrieval, rejects duplicate message, and arrange again
Row；
Step 3.3, the data rearranged under AutoCAD system environments, are generated QR bar shapeds by data message generation step
Code.
7. a kind of AutoCAD drawing informations storage method according to claim 6, it is characterised in that the step 3.3 is also
Including：
AutoCAD built-in functions are called under AutoCAD system environments to generate two-dimension code image, and with AutoCAD systems
Altogether enjoy memory space.
8. a kind of AutoCAD drawing informations storage method according to claim 1, it is characterised in that in the step 4 also
Including：The virtual coordinate system set up by the sideline intersection point of AutoCAD drawing frames and sideline determines to set described in QR Quick Response Codes
Ad-hoc location.
9. a kind of AutoCAD drawing informations storage method according to claim 1, it is characterised in that the step 4 it
Also include afterwards：It is according to the form of Excel forms that AutoCAD drawings in output information is corresponding after output information is received
The fixed attribute information and/or variable attribute information be formulated to BOM tables output.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710237234.1A CN107025287A (en) | 2017-04-12 | 2017-04-12 | A kind of AutoCAD drawing informations storage method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710237234.1A CN107025287A (en) | 2017-04-12 | 2017-04-12 | A kind of AutoCAD drawing informations storage method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107025287A true CN107025287A (en) | 2017-08-08 |
Family
ID=59526435
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710237234.1A Pending CN107025287A (en) | 2017-04-12 | 2017-04-12 | A kind of AutoCAD drawing informations storage method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107025287A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697297A (en) * | 2017-10-24 | 2019-04-30 | 上海嘉实（集团）有限公司 | Management method, system, memory and the electronic equipment of engineering drawing |
| CN110942128A (en) * | 2019-12-06 | 2020-03-31 | 中铁第四勘察设计院集团有限公司 | Method and system for drawing two-dimensional code based on AutoCAD |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102208053A (en) * | 2011-05-17 | 2011-10-05 | 香港华艺设计顾问(深圳)有限公司 | Two-dimensional code-based design drawing management system and method |
| JP2012226525A (en) * | 2011-04-19 | 2012-11-15 | Shinryo Corp | Construction management system and construction management method |
| CN104200330A (en) * | 2014-09-11 | 2014-12-10 | 广西桂能软件有限公司 | Management method of digital archives in power industry |
-
2017
- 2017-04-12 CN CN201710237234.1A patent/CN107025287A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2012226525A (en) * | 2011-04-19 | 2012-11-15 | Shinryo Corp | Construction management system and construction management method |
| CN102208053A (en) * | 2011-05-17 | 2011-10-05 | 香港华艺设计顾问(深圳)有限公司 | Two-dimensional code-based design drawing management system and method |
| CN104200330A (en) * | 2014-09-11 | 2014-12-10 | 广西桂能软件有限公司 | Management method of digital archives in power industry |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697297A (en) * | 2017-10-24 | 2019-04-30 | 上海嘉实（集团）有限公司 | Management method, system, memory and the electronic equipment of engineering drawing |
| CN110942128A (en) * | 2019-12-06 | 2020-03-31 | 中铁第四勘察设计院集团有限公司 | Method and system for drawing two-dimensional code based on AutoCAD |
| CN110942128B (en) * | 2019-12-06 | 2022-03-29 | 中铁第四勘察设计院集团有限公司 | Method and system for drawing two-dimensional code based on AutoCAD |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8892990B2 (en) | Automatic creation of a table and query tools | |
| JP5851607B2 (en) | Kanji composition method and apparatus, character composition method and apparatus, and font library construction method | |
| CN110516370A (en) | Prefabricated components deepen drawing creation method, apparatus, computer equipment and medium | |
| CN110727741A (en) | Knowledge graph construction method and system of power system | |
| CN108595402A (en) | A kind of system of extraction PDF form datas | |
| CN106600700B (en) | Three-dimensional model data processing system | |
| CN109214068A (en) | BIM-based bottom assembled building information extraction method | |
| CN114676368B (en) | Geographic entity information display method, device, equipment and medium based on identification code | |
| CN101025805A (en) | Product-based bill of material generating method | |
| CN110516015B (en) | Method for manufacturing geographical PDF map based on map graphic data and DLG | |
| CN107025287A (en) | A kind of AutoCAD drawing informations storage method | |
| JPH0314184A (en) | Document image rearrangement filing device | |
| CN114880295A (en) | Heterogeneous file archiving method suitable for digital file cabinet | |
| CN103915035B (en) | A kind of data transfer device and DTU | |
| CN115146327A (en) | CAD file auxiliary processing method and system for air conditioner industry | |
| JP2011090376A (en) | Pictograph input device | |
| CN111177812A (en) | Web map construction method and device containing closed space | |
| CN111507430B (en) | Feature coding method, device, equipment and medium based on matrix multiplication | |
| CN116503572A (en) | Intelligent recruitment platform and space modeling method thereof | |
| JPH0423185A (en) | Table reader provided with automatic cell attribution deciding function | |
| CN115934715A (en) | Tabular construction method of program data structure | |
| CN105740374A (en) | Distributed memory based three-dimensional platform data fuzzy query method | |
| CN110134684B (en) | Database storage method of BIM model data | |
| CN115471582A (en) | Map generation method and device, computer equipment and storage medium | |
| CN111753346B (en) | Linear member profile generating method, revit platform 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170808 |
|
| RJ01 | Rejection of invention patent application after publication |