CN107025287A - A kind of AutoCAD drawing informations storage method - Google Patents

A kind of AutoCAD drawing informations storage method Download PDF

Info

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
information
autocad
attribute information
dimensional code
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
Application number
CN201710237234.1A
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.)
Shanghai Institute of Technology
Original Assignee
Shanghai 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 Shanghai Institute of Technology filed Critical Shanghai Institute of Technology
Priority to CN201710237234.1A priority Critical patent/CN107025287A/en
Publication of CN107025287A publication Critical patent/CN107025287A/en
Pending 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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational 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

本发明设计了一种AutoCAD图纸信息存储方法,包括:步骤1,固定属性信息处理步骤,存储AutoCAD图纸的固定属性信息,所述固定属性信息包括图纸出处、图纸设计信息、图纸校核信息等;步骤2,可变属性信息处理步骤,存储AutoCAD图纸的可变属性信息,所述可变属性信息包括备料的尺寸、材质和数量等;步骤3,二维码自动生成步骤,所述二维码自动生成步骤包括提取将所述固定属性信息和实时属性信息生成QR二维码;步骤4,条码自动寻址步骤,所述条码自动寻址步骤包括将已经生成的QR二维码设置在图纸的特定位置。

The present invention designs a kind of AutoCAD drawing information storage method, comprises: Step 1, fixed attribute information processing step, stores the fixed attribute information of AutoCAD drawing, and described fixed attribute information includes drawing source, drawing design information, drawing checking information etc.; Step 2, the variable attribute information processing step, stores the variable attribute information of the AutoCAD drawing, and the variable attribute information includes the size, material and quantity of the stock; Step 3, the automatic generation step of the two-dimensional code, the two-dimensional code The automatic generation step includes extracting the QR two-dimensional code generated by the fixed attribute information and real-time attribute information; Step 4, the bar code automatic addressing step, and the bar code automatic addressing step includes setting the generated QR two-dimensional code on the drawing. specific location.

Description

一种AutoCAD图纸信息存储方法A method for storing AutoCAD drawing information

技术领域technical field

本发明涉及AutoCAD软件图纸信息存储领域,更具体地说,涉及一种AutoCAD图纸信息存储方法。The invention relates to the field of AutoCAD software drawing information storage, and more specifically relates to a method for storing AutoCAD drawing information.

背景技术Background technique

AutoCAD作为当今世界应用最广泛的计算机辅助设计软件,在各行各业都有非常广泛的运用。尤其是在工程行业,因为其强大的功能更是有效的提高了产品设计的效率,缩短了产品的生产周期,创造更多的工业价值。在工业设计中,会产生数量非常巨大的图纸文件,这些图纸文件的组织结构、图档数据、图档内容也有着很大差异。随着图纸文件的越来越多,采用原有的粗放式人工管理,将会使图纸的管理变得复杂、冗沉,同时也不便于图纸、图纸内容的快速查询和检索,更无法解决面向设计过程的、动态的图纸管理问题。As the most widely used computer-aided design software in the world today, AutoCAD is widely used in all walks of life. Especially in the engineering industry, because of its powerful functions, it can effectively improve the efficiency of product design, shorten the production cycle of products, and create more industrial value. In industrial design, a very large number of drawing files will be generated, and the organizational structure, drawing data, and drawing contents of these drawing files are also very different. With the increasing number of drawing files, using the original extensive manual management will make the management of drawings complicated and redundant, and it will not be convenient for quick query and retrieval of drawings and drawing contents, and it will not be able to solve problems facing Design process, dynamic drawing management issues.

现在通过AutoCAD软件制作的图纸,其图纸信息都是简单的通过后期人工去制作表格,然后通过纸质图纸存档,但是纸质图纸存档储存信息相对少,而且没有那么完整。At present, the drawing information of the drawings made by AutoCAD software is simply manually made in the later stage, and then archived through paper drawings, but the information stored in paper drawings archives is relatively small and not so complete.

发明内容Contents of the invention

为了解决AutoCAD绘图的图纸信息的存储,本发明提供了一种AutoCAD图纸信息存储方法,用于图纸信息的有效存储。In order to solve the storage of drawing information of AutoCAD drawing, the present invention provides an AutoCAD drawing information storage method for effective storage of drawing information.

本发明提供的一种AutoCAD图纸信息存储方法,包括:A kind of AutoCAD drawing information storage method provided by the present invention comprises:

步骤1,固定属性信息处理步骤,存储AutoCAD图纸的固定属性信息,所述固定属性信息包括图纸出处、图纸设计信息、图纸校核信息;Step 1, the fixed attribute information processing step, stores the fixed attribute information of the AutoCAD drawing, and the fixed attribute information includes drawing source, drawing design information, drawing check information;

步骤2,可变属性信息处理步骤,存储AutoCAD图纸的可变属性信息,所述可变属性信息包括备料的尺寸、材质和数量;Step 2, the variable attribute information processing step, stores the variable attribute information of the AutoCAD drawing, and the variable attribute information includes the size, material and quantity of the stock;

步骤3,二维码自动生成步骤,所述二维码自动生成步骤包括提取将所述固定属性信息和实时属性信息生成QR二维码;Step 3, the two-dimensional code automatic generation step, the two-dimensional code automatic generation step includes extracting the fixed attribute information and real-time attribute information to generate a QR two-dimensional code;

步骤4,条码自动寻址步骤,所述条码自动寻址步骤包括将已经生成的QR二维码设置在图纸的特定位置。Step 4, the barcode automatic addressing step, the barcode automatic addressing step includes setting the generated QR two-dimensional code at a specific position on the drawing.

作为一种优化方案,所述步骤1之前还包括:As an optimization scheme, before the step 1, it also includes:

在外部数据库建立用于依据图纸规格信息的分类建立相应的数据库表格的SQLSever数据库,所述数据库表格对应的内容格式依据导入信息而定制。An SQL Server database is established in the external database for establishing corresponding database tables according to the classification of drawing specification information, and the content format corresponding to the database tables is customized according to the imported information.

作为一种优化方案,所述步骤2进一步包括:As an optimization scheme, the step 2 further includes:

步骤2.1,在AutoCAD系统中将AutoCAD和SQL Sever数据库配置为在AutoCAD系统中直接存储、调用图纸信息的连接关系;Step 2.1, in AutoCAD system, AutoCAD and SQL Sever database are configured as the connection relationship of directly storing and calling drawing information in AutoCAD system;

步骤2.2,在AutoCAD系统环境下,启动信息输入界面;Step 2.2, under the AutoCAD system environment, start the information input interface;

步骤2.3,在启动的所述信息输入界面,手动输入图纸的所述可变属性信息。Step 2.3, manually input the variable attribute information of the drawing on the information input interface that starts.

作为一种优化方案,所述步骤2.3中手动输入图纸的所述可变属性信息的过程还包括:自动检测并存储手动输入的信息,并将当前手动输入的信息与历史输入信息进行对比,获得匹配度最高的历史输入信息后自动填充。As an optimization solution, the process of manually inputting the variable attribute information of the drawings in step 2.3 further includes: automatically detecting and storing the manually input information, and comparing the current manually input information with historical input information to obtain Autofill after the historical input information with the highest matching degree.

作为一种优化方案,所述步骤3为在AutoCAD系统环境下自动生成所述QR二维码。As an optimization scheme, the step 3 is to automatically generate the QR two-dimension code under the AutoCAD system environment.

作为一种优化方案,所述步骤3进一步包括:As an optimization scheme, the step 3 further includes:

步骤3.1,数据信息提取步骤,在AutoCAD软件环境下,根据预设的数据提取标准,将已经设计好的图纸信息提取出来;Step 3.1, the data information extraction step, in the AutoCAD software environment, according to the preset data extraction standard, the designed drawing information is extracted;

步骤3.2,数据信息整合步骤,将提取的数据信息通过检索,剔除重复信息,并重新排列;Step 3.2, the data information integration step, retrieves the extracted data information, eliminates duplicate information, and rearranges;

步骤3.3,数据信息生成步骤,在AutoCAD系统环境下,将重新排列的数据生成QR条形码。Step 3.3, the step of generating data information, generates a QR barcode from the rearranged data in the environment of the AutoCAD system.

作为一种优化方案,所述步骤3.3还包括:As an optimization scheme, said step 3.3 also includes:

在AutoCAD系统环境下调用AutoCAD系统内部函数来生成二维码图片,并与AutoCAD系统共享存储空间。In the AutoCAD system environment, the internal functions of the AutoCAD system are called to generate the two-dimensional code image, and the storage space is shared with the AutoCAD system.

作为一种优化方案,所述步骤4中还包括:通过AutoCAD图纸框的边线交点和边线建立的虚拟坐标系确定设置QR二维码的所述特定位置。As an optimization scheme, the step 4 further includes: determining the specific position for setting the QR two-dimensional code through the virtual coordinate system established by the edge intersection point and the edge of the AutoCAD drawing frame.

作为一种优化方案,在所述步骤4之后还包括:在接收到输出信息之后,按照Excel表格的格式将输出信息中AutoCAD图纸对应的所述固定属性信息和/或可变属性信息制定成BOM表输出。As an optimization scheme, after the step 4, it also includes: after receiving the output information, formulating the fixed attribute information and/or variable attribute information corresponding to the AutoCAD drawing in the output information into a BOM in the format of an Excel table table output.

本申请通过设计一款AutoCAD图纸信息存储的功能模块,将图纸信息的存储应用于数据库和QR二维码的结合技术上,从而简便了图纸的管理、查询。This application designs a functional module for storing AutoCAD drawing information, and applies the storage of drawing information to the combination technology of database and QR two-dimensional code, thereby simplifying the management and query of drawings.

附图说明Description of drawings

为了更清楚的表达该发明实施过程的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍。In order to express the technical solution of the implementation process of the invention more clearly, the following will briefly introduce the drawings required for the embodiments or the description of the prior art.

图1为本发明的一种流程图;Fig. 1 is a kind of flowchart of the present invention;

图2为本发明的SQL Sever数据库结构图;Fig. 2 is the SQL Sever database structural diagram of the present invention;

图3为本发明的一种二维码自动生成步骤流程示意图;Fig. 3 is a schematic flow chart of the automatic generation steps of a two-dimensional code of the present invention;

图4为本发明一种二维码设置示意图;Fig. 4 is a schematic diagram of setting a two-dimensional code of the present invention;

图5为本发明的整个功能原理图。Fig. 5 is a schematic diagram of the whole function of the present invention.

具体实施方式detailed description

为了使本发明的目的、技术方案和优点更加清楚,下面将结合对本发明的实施例附图进行详细描述。In order to make the purpose, technical solution and advantages of the present invention clearer, the following will describe in detail the embodiments of the present invention with reference to the accompanying drawings.

本发明提供的一种AutoCAD图纸信息存储方法,参见图1,包括:A kind of AutoCAD drawing information storage method provided by the present invention, referring to Fig. 1, comprises:

步骤1,固定属性信息处理步骤,存储AutoCAD图纸的固定属性信息,所述固定属性信息包括图纸出处、图纸设计信息、图纸校核信息;图纸出处主要包括设计者的信息。所述图纸设计信息主要包括该图纸所绘制的零件用于哪一个结构装配以及装配关系。所述图纸校核信息主要包括校核人员信息。Step 1, the fixed attribute information processing step, stores the fixed attribute information of the AutoCAD drawing, and the fixed attribute information includes drawing source, drawing design information, and drawing verification information; the drawing source mainly includes designer information. The drawing design information mainly includes which structural assembly and assembly relationship the parts drawn on the drawing are used for. The drawing checking information mainly includes checking personnel information.

步骤2,可变属性信息处理步骤,存储AutoCAD图纸的可变属性信息,所述可变属性信息包括备料的尺寸、材质和数量。Step 2, the variable attribute information processing step, stores the variable attribute information of the AutoCAD drawing, and the variable attribute information includes the size, material and quantity of the prepared material.

步骤3,二维码自动生成步骤,所述二维码自动生成步骤包括提取将所述固定属性信息和实时属性信息生成QR二维码。Step 3, a step of automatically generating a two-dimensional code, the step of automatically generating a two-dimensional code includes extracting the fixed attribute information and real-time attribute information to generate a QR two-dimensional code.

步骤4,条码自动寻址步骤,所述条码自动寻址步骤包括将已经生成的QR二维码设置在图纸的特定位置。Step 4, the barcode automatic addressing step, the barcode automatic addressing step includes setting the generated QR two-dimensional code at a specific position on the drawing.

作为一种优化方案,所述步骤1之前还包括:As an optimization scheme, before the step 1, it also includes:

在外部数据库建立用于依据图纸规格信息的分类建立相应的数据库表格的SQLSever数据库,所述数据库表格对应的内容格式依据导入信息而定制。An SQL Server database is established in the external database for establishing corresponding database tables according to the classification of drawing specification information, and the content format corresponding to the database tables is customized according to the imported information.

作为一种优化方案,所述步骤2进一步包括:As an optimization scheme, the step 2 further includes:

步骤2.1,在AutoCAD系统中将AutoCAD和SQL Sever数据库配置为在AutoCAD系统中直接存储、调用图纸信息的连接关系;Step 2.1, in AutoCAD system, AutoCAD and SQL Sever database are configured as the connection relationship of directly storing and calling drawing information in AutoCAD system;

步骤2.2,在AutoCAD系统环境下,启动信息输入界面;Step 2.2, under the AutoCAD system environment, start the information input interface;

步骤2.3,在启动的所述信息输入界面,手动输入图纸的所述可变属性信息。Step 2.3, manually input the variable attribute information of the drawing on the information input interface that starts.

作为一种优化方案,所述步骤2.3中手动输入图纸的所述可变属性信息的过程还包括:自动检测并存储手动输入的信息,并将当前手动输入的信息与历史输入信息进行对比,获得匹配度最高的历史输入信息后自动填充。As an optimization solution, the process of manually inputting the variable attribute information of the drawings in step 2.3 further includes: automatically detecting and storing the manually input information, and comparing the current manually input information with historical input information to obtain Autofill after the historical input information with the highest matching degree.

作为一种优化方案,所述步骤3为在AutoCAD系统环境下自动生成所述QR二维码。As an optimization scheme, the step 3 is to automatically generate the QR two-dimension code under the AutoCAD system environment.

作为一种优化方案,所述步骤3进一步包括:As an optimization scheme, the step 3 further includes:

步骤3.1,数据信息提取步骤,在AutoCAD软件环境下,根据预设的数据提取标准,将已经设计好的图纸信息提取出来;Step 3.1, the data information extraction step, in the AutoCAD software environment, according to the preset data extraction standard, the designed drawing information is extracted;

步骤3.2,数据信息整合步骤,将提取的数据信息通过检索,剔除重复信息,并重新排列;Step 3.2, the data information integration step, retrieves the extracted data information, eliminates duplicate information, and rearranges;

步骤3.3,数据信息生成步骤,在AutoCAD系统环境下,将重新排列的数据生成QR条形码。QR码是二维条码的一种,QR来自英文“Quick Response”的缩写,即快速反应的意思,源自发明者希望QR码可让其内容快速被解码。QR码比普通条码可储存更多资料,亦无需像普通条码般在扫描时需直线对准扫描器。Step 3.3, the step of generating data information, generates a QR barcode from the rearranged data in the environment of the AutoCAD system. QR code is a kind of two-dimensional barcode. QR comes from the abbreviation of "Quick Response" in English, which means quick response. It comes from the inventor's hope that the content of QR code can be decoded quickly. QR codes can store more data than ordinary barcodes, and do not need to be aligned with the scanner when scanning like ordinary barcodes.

作为一种优化方案,所述步骤3.3还包括:As an optimization scheme, said step 3.3 also includes:

在AutoCAD系统环境下调用AutoCAD系统内部函数来生成二维码图片,并与AutoCAD系统共享存储空间。In the AutoCAD system environment, the internal functions of the AutoCAD system are called to generate the two-dimensional code image, and the storage space is shared with the AutoCAD system.

作为一种优化方案,所述步骤4中还包括:通过AutoCAD图纸框的边线交点和边线建立的虚拟坐标系确定设置QR二维码的所述特定位置。As an optimization scheme, the step 4 further includes: determining the specific position for setting the QR two-dimensional code through the virtual coordinate system established by the edge intersection point and the edge of the AutoCAD drawing frame.

作为一种优化方案,在所述步骤4之后还包括:在接收到输出信息之后,按照Excel表格的格式将输出信息中AutoCAD图纸对应的所述固定属性信息和/或可变属性信息制定成BOM表输出。As an optimization scheme, after the step 4, it also includes: after receiving the output information, formulating the fixed attribute information and/or variable attribute information corresponding to the AutoCAD drawing in the output information into a BOM in the format of an Excel table table output.

图1为本发明实施例公开的一种AutoCAD图纸信息存储方法流程图。FIG. 1 is a flow chart of a method for storing AutoCAD drawing information disclosed by an embodiment of the present invention.

如图1所示,该功能包括:As shown in Figure 1, this functionality includes:

步骤S100,设计数据库结构框架并建立对应的数据库表格;Step S100, designing the database structure framework and establishing corresponding database tables;

具体地,依据固定属性信息和可变属性信息的关联性,设计关系型数据库结构,在可变属性信息表中关键字段设置为主键,同时设置为固定属性信息的外键,用于确保数据的关联性,具体见图2。Specifically, according to the correlation between fixed attribute information and variable attribute information, a relational database structure is designed. In the variable attribute information table, the key field is set as the primary key, and at the same time, it is set as the foreign key of the fixed attribute information to ensure that the data The correlation, see Figure 2 for details.

步骤S110,将建立好的BOM表中的固定属性信息导入数据库;Step S110, importing the fixed attribute information in the established BOM table into the database;

步骤S120,将可变属性信息通过输入界面输入并传入数据库;Step S120, input variable attribute information through the input interface and transfer it to the database;

具体地,依据Excel建表格式制定BOM表,依据名称排列,添加图纸信息和相关数据,然后通过数据库导入接口将数据导入。同时还包括手动在数据表格中输入、更改信息。然后运用基于ActiveX技术的组件对象模型(COM)技术,将AutoCAD与数据库进行通信连接,并在AutoCAD环境下启动可变属性信息输入界面,通过手动将设计时如备料尺寸、材质、数量等的信息输入,并传输到后台数据库中。Specifically, formulate the BOM table according to the Excel table-building format, arrange it according to the name, add drawing information and related data, and then import the data through the database import interface. It also includes manually entering and changing information in the data form. Then use the Component Object Model (COM) technology based on ActiveX technology to connect AutoCAD with the database, and start the variable attribute information input interface in the AutoCAD environment, and manually enter the design information such as material size, material, quantity, etc. Input and transfer to the background database.

步骤S130,通过数据提取单元提取数据库中存储的图纸信息并整合,通过数据生成单元生成QR二维码。In step S130, the drawing information stored in the database is extracted and integrated by the data extraction unit, and a QR two-dimensional code is generated by the data generation unit.

具体地,通过如图3中数据提取单元S301从数据库中提取相关图纸信息,提取的信息的方法是依据阵列线性排列,然后通过数据信息整理单元S302,进行首行关键字检索,将固定属性信息表和可变属性信息表中重复列搜索出来,并通过完全检索将重复部分查找出来,并提出重复部分,最后将整合好的数据按照依次的顺序排列并存在相应的存储单元(定义的数组)。Specifically, the relevant drawing information is extracted from the database through the data extraction unit S301 as shown in Figure 3, the extracted information is arranged linearly according to the array, and then the first line keyword search is performed through the data information sorting unit S302, and the fixed attribute information Search out the duplicate columns in tables and variable attribute information tables, and find out the duplicate parts through complete retrieval, and propose the duplicate parts, and finally arrange the integrated data in order and store them in corresponding storage units (defined arrays) .

进一步,运用ObjectARX二次开发技术,在AutoCAD中通过信息生成单元S303生成QR二维码。Further, using ObjectARX secondary development technology, the QR two-dimensional code is generated in AutoCAD through the information generation unit S303.

具体地,QR二维码的实质就是多个黑、白小正方形组成的大正方形,在AutoCAD中通过画矩形框,通过填充,可以实现在系统环境下自动生成二维码。首先,AutoCAD软件默认的背景环境S402是纯黑色,通过图4中二维码生成图S401,通过设定一个50×50mm的纯白色正方形背景框,然后依据二维码版本号X,将背景框划分成(4X+17)×(4X+17)的网格,最后依据QR二维码的生成规则,将相应的网格填充成黑色,从而在AutoCAD环境下,共享储存空间,生成QR二维码。Specifically, the essence of a QR two-dimensional code is a large square composed of multiple small black and white squares. In AutoCAD, by drawing a rectangular frame and filling it, the two-dimensional code can be automatically generated in the system environment. First of all, the default background environment S402 of AutoCAD software is pure black. Through the QR code in Fig. Divide into (4X+17)×(4X+17) grids, and finally fill the corresponding grids with black according to the generation rules of QR codes, so that in the AutoCAD environment, share storage space and generate QR 2D codes code.

步骤S140,通过二维码寻址功能将生成的二维码放置在指定的生成位置。Step S140, placing the generated two-dimensional code at a designated generating location through the two-dimensional code addressing function.

具体地,如图4,通过抓取图框S403,获得图框的比例大小,选择图框右下角的角点作为虚拟的直角坐标系的原点,对应的图框边线分别作为横轴和竖轴。然后将附着二维码的白底框放置在相对位置的图纸框中,同时按照获取的图纸框的框图比例进行放大缩小,从而AutoCAD图纸框中生成了带有图纸信息的QR二维码。Specifically, as shown in Figure 4, by grabbing the picture frame S403, the scale of the picture frame is obtained, and the corner point at the lower right corner of the picture frame is selected as the origin of the virtual Cartesian coordinate system, and the corresponding picture frame borders are respectively used as the horizontal axis and the vertical axis . Then place the white-bottomed frame attached with the QR code in the drawing frame at the relative position, and zoom in and out according to the frame size of the obtained drawing frame, so that a QR code with drawing information is generated in the AutoCAD drawing frame.

综上所述,如图5,本发明是通过前期的数据处理,将图纸信息通过固定属性信息和可变属性信息两种存入数据库中,通过信息提取单元提取信息,并生成对应的二维码,在AutoCAD环境下,在图纸框指定位置放置二维码。In summary, as shown in Figure 5, the present invention stores drawing information in the database through two types of fixed attribute information and variable attribute information through the early data processing, extracts information through the information extraction unit, and generates the corresponding two-dimensional Code, in the AutoCAD environment, place the QR code at the specified position in the drawing frame.

以上所述仅为本发明的较佳实施例,本领域技术人员知悉,在不脱离本发明的精神和范围的情况下,可以对这些特征和实施例进行各种改变或等同替换。另外,在本发明的教导下,可以对这些特征和实施例进行修改以适应具体的情况及材料而不会脱离本发明的精神和范围。因此,本发明不受此处所公开的具体实施例的限制,所有落入本申请的权利要求范围内的实施例都属于本发明的保护范围。The above descriptions are only preferred embodiments of the present invention, and those skilled in the art know that various changes or equivalent replacements can be made to these features and embodiments without departing from the spirit and scope of the present invention. In addition, the features and examples may be modified to adapt a particular situation and material to the teachings of the invention without departing from the spirit and scope of the invention. Therefore, the present invention is not limited by the specific embodiments disclosed here, and all embodiments falling within the scope of the claims of the present application belong to the protection scope of the present invention.

Claims (9)

1.一种AutoCAD图纸信息存储方法,其特征在于,包括:1. A method for storing AutoCAD drawing information, characterized in that, comprising: 步骤1,固定属性信息处理步骤,存储AutoCAD图纸的固定属性信息,所述固定属性信息包括图纸出处、图纸设计信息、图纸校核信息;Step 1, the fixed attribute information processing step, stores the fixed attribute information of the AutoCAD drawing, and the fixed attribute information includes drawing source, drawing design information, drawing check information; 步骤2,可变属性信息处理步骤,存储AutoCAD图纸的可变属性信息,所述可变属性信息包括备料的尺寸、材质和数量;Step 2, the variable attribute information processing step, stores the variable attribute information of the AutoCAD drawing, and the variable attribute information includes the size, material and quantity of the stock; 步骤3,二维码自动生成步骤,所述二维码自动生成步骤包括提取将所述固定属性信息和实时属性信息生成QR二维码;Step 3, the two-dimensional code automatic generation step, the two-dimensional code automatic generation step includes extracting the fixed attribute information and real-time attribute information to generate a QR two-dimensional code; 步骤4,条码自动寻址步骤,所述条码自动寻址步骤包括将已经生成的QR二维码设置在图纸的特定位置。Step 4, the barcode automatic addressing step, the barcode automatic addressing step includes setting the generated QR two-dimensional code at a specific position on the drawing. 2.根据权利要求1所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤1之前还包括:2. a kind of AutoCAD drawing information storage method according to claim 1, is characterized in that, also comprises before described step 1: 在外部数据库建立用于依据图纸规格信息的分类建立相应的数据库表格的SQL Sever数据库,所述数据库表格对应的内容格式依据导入信息而定制。An SQL Sever database is established in the external database for establishing corresponding database tables according to the classification of drawing specification information, and the content format corresponding to the database tables is customized according to the imported information. 3.根据权利要求2所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤2进一步包括:3. a kind of AutoCAD drawing information storage method according to claim 2, is characterized in that, described step 2 further comprises: 步骤2.1,在AutoCAD系统中将AutoCAD和SQL Sever数据库配置为在AutoCAD系统中直接存储、调用图纸信息的连接关系;Step 2.1, in AutoCAD system, AutoCAD and SQL Sever database are configured as the connection relationship of directly storing and calling drawing information in AutoCAD system; 步骤2.2,在AutoCAD系统环境下,启动信息输入界面;Step 2.2, under the AutoCAD system environment, start the information input interface; 步骤2.3,在启动的所述信息输入界面,手动输入图纸的所述可变属性信息。Step 2.3, manually input the variable attribute information of the drawing on the information input interface that starts. 4.根据权利要求3所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤2.3中手动输入图纸的所述可变属性信息的过程还包括:自动检测并存储手动输入的信息,并将当前手动输入的信息与历史输入信息进行对比,获得匹配度最高的历史输入信息后自动填充。4. A kind of AutoCAD drawing information storage method according to claim 3, is characterized in that, the process of manually inputting the described variable attribute information of drawing in the described step 2.3 also comprises: automatically detecting and storing the information of manual input, And compare the current manual input information with the historical input information, and automatically fill in the historical input information with the highest matching degree. 5.根据权利要求1所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤3为在AutoCAD系统环境下自动生成所述QR二维码。5. A kind of AutoCAD drawing information storage method according to claim 1, is characterized in that, described step 3 is to automatically generate described QR two-dimension code under AutoCAD system environment. 6.根据权利要求1所述一种AutoCAD图纸信息存储方法,其特征在于,所述步骤3进一步包括:6. a kind of AutoCAD drawing information storage method according to claim 1, is characterized in that, described step 3 further comprises: 步骤3.1,数据信息提取步骤,在AutoCAD软件环境下,根据预设的数据提取标准,将已经设计好的图纸信息提取出来;Step 3.1, the data information extraction step, in the AutoCAD software environment, according to the preset data extraction standard, the designed drawing information is extracted; 步骤3.2,数据信息整合步骤,将提取的数据信息通过检索,剔除重复信息,并重新排列;Step 3.2, the data information integration step, retrieves the extracted data information, eliminates duplicate information, and rearranges; 步骤3.3,数据信息生成步骤,在AutoCAD系统环境下,将重新排列的数据生成QR条形码。Step 3.3, the step of generating data information, generates a QR barcode from the rearranged data in the environment of the AutoCAD system. 7.根据权利要求6所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤3.3还包括:7. A kind of AutoCAD drawing information storage method according to claim 6, is characterized in that, described step 3.3 also comprises: 在AutoCAD系统环境下调用AutoCAD系统内部函数来生成二维码图片,并与AutoCAD系统共享存储空间。In the AutoCAD system environment, the internal functions of the AutoCAD system are called to generate the two-dimensional code image, and the storage space is shared with the AutoCAD system. 8.根据权利要求1所述的一种AutoCAD图纸信息存储方法,其特征在于,所述步骤4中还包括:通过AutoCAD图纸框的边线交点和边线建立的虚拟坐标系确定设置QR二维码的所述特定位置。8. A kind of AutoCAD drawing information storage method according to claim 1, is characterized in that, also comprises in the described step 4: determine setting QR two-dimension code by the virtual coordinate system that the edge intersection of AutoCAD drawing frame and edge establish the specific location. 9.根据权利要求1所述的一种AutoCAD图纸信息存储方法,其特征在于,在所述步骤4之后还包括:在接收到输出信息之后,按照Excel表格的格式将输出信息中AutoCAD图纸对应的所述固定属性信息和/或可变属性信息制定成BOM表输出。9. A kind of AutoCAD drawing information storage method according to claim 1, is characterized in that, after described step 4, also comprises: after receiving output information, according to the format of Excel form, will output information corresponding to AutoCAD drawing The fixed attribute information and/or variable attribute information is formulated as a BOM for output.
CN201710237234.1A 2017-04-12 2017-04-12 A kind of AutoCAD drawing informations storage method Pending CN107025287A (en)

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 (3)

* Cited by examiner, † Cited by third party
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
CN114357566A (en) * 2021-12-09 2022-04-15 中铁四局集团有限公司 Method and system for intelligent generation of steel cage drawings

Citations (3)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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 (4)

* Cited by examiner, † Cited by third party
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
CN114357566A (en) * 2021-12-09 2022-04-15 中铁四局集团有限公司 Method and system for intelligent generation of steel cage drawings

Similar Documents

Publication Publication Date Title
US11868717B2 (en) Multi-page document recognition in document capture
US10120537B2 (en) Page-independent multi-field validation in document capture
CN101419612B (en) Image processing device and image processing method
US8892990B2 (en) Automatic creation of a table and query tools
US11080904B2 (en) Computerized systems and methods for graph data modeling
US7746341B2 (en) System and method for parsing point-cloud data
CN108319661A (en) A kind of structured storage method and device of spare part information
JP7089605B2 (en) Data transformation system and method
CN106600700B (en) Three-dimensional model data processing system
CN112286907A (en) Database configuration method and device, electronic equipment and readable storage medium
CN107025287A (en) A kind of AutoCAD drawing informations storage method
CN112732763B (en) Data aggregation method, device, electronic device and medium
CN116821223A (en) Industrial visual control platform and method based on digital twinning
JP2017134502A (en) Document management device, document management method, and program
CN115576905A (en) Archive file management method and device, electronic equipment and storage medium
CN101388018A (en) Management method of computer aided design file
CN105740374A (en) Distributed memory based three-dimensional platform data fuzzy query method
CN113779941B (en) Configurable dynamic report generation device, system and method
CN110716994B (en) A retrieval method and device supporting heterogeneous geographic data resource retrieval
CN113934729A (en) Data management method based on knowledge graph, related equipment and medium
CN112445811A (en) Data service method, device, storage medium and component based on SQL configuration
CN112883249B (en) Layout document processing method and device and application method of device
CN113934709A (en) Model construction method and device and readable storage medium
CN117171193A (en) Data generation method, device, computer equipment and storage medium
CN119248773A (en) Table synchronization method, device, storage medium and product

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20170808