CN115146327A

CN115146327A - CAD file auxiliary processing method and system for air conditioner industry

Info

Publication number: CN115146327A
Application number: CN202210711009.8A
Authority: CN
Inventors: 田龙飞; 赵军; 张少龙; 李波
Original assignee: Sichuan Changhong Air Conditioner Co Ltd
Current assignee: Sichuan Changhong Air Conditioner Co Ltd
Priority date: 2022-06-22
Filing date: 2022-06-22
Publication date: 2022-10-04

Abstract

The invention relates to the technical field of file auxiliary processing, discloses a CAD file auxiliary processing method and system for the air-conditioning industry, aims to solve the problems of low efficiency and accuracy of the existing CAD file processing method, and mainly comprises the following steps: by adopting the mutual coordination work of the CADVBA program, the EXCELVBA program and the EXCEL form, the automatic batch copying, pasting, sorting, searching, screening, matching, zooming, labeling, renaming, list extraction, drawing splitting, PDF conversion, drawing content error checking and the like of the CAD files are carried out. The method is particularly suitable for scenes with more part drawing papers.

Description

CAD file auxiliary processing method and system for air conditioner industry

Technical Field

The invention relates to the technical field of file auxiliary processing, in particular to a CAD file auxiliary processing method and system for the air-conditioning industry.

Background

In the air-conditioning industry, a new air-conditioning product needs to perform three-dimensional modeling and drawing guide of the product and two-dimensional part drawing paper processing work in the design process. The three-dimensional modeling mainly adopts three-dimensional modeling software to carry out three-dimensional modeling and two-dimensional part drawing guiding work on the air-conditioning product, and the two-dimensional part drawing paper is mainly a CAD file. The two-dimensional part drawing paper processing work content mainly comprises the following steps: 1. manually copying and pasting all two-dimensional part original image files into a CAD part general image file; 2. manually searching a standard drawing frame matched with the corresponding type according to each part type, 3, manually scaling the part drawing paper according to the comparison of the part drawing paper area and the size of the drawing frame, and adding a scaling to the detailed column part of the drawing frame; 4. manually filling information such as original name and weight of subordinate parts in a drawing detail table of the two-dimensional part according to the assembly relation of the two-dimensional part; 5. marking the drawing according to different scaling scales of the two-dimensional part drawing; 6. manually renaming the part drawing paper in the step 4 according to the part name of the official application; 7. manually simulating a part bill of materials for processing and material purchasing according to the two-dimensional part drawing paper detail column; 8. manually splitting the part drawing paper in the two-dimensional part general drawing into single drawings for archiving; 9. in order to facilitate the reference of drawings by different department personnel, the CAD file needs to be manually converted into a PDF text.

The above is a basic processing flow of two-dimensional part drawing paper in the air-conditioning industry, generally, one air-conditioning product has hundreds of parts drawing paper and dozens of picture frames, and mechanical repeated work such as manual copying, pasting, searching, screening, matching, scaling, labeling, renaming, material list extraction, drawing splitting, PDF conversion and the like is manually carried out, so that the time consumption is huge, the error rate is extremely high, and the design development efficiency of a new air-conditioning product and the accuracy of a design drawing are seriously influenced.

Disclosure of Invention

The invention aims to solve the problems of low efficiency and accuracy of the traditional CAD file processing method in the air-conditioning industry, and provides a CAD file auxiliary processing method and a CAD file auxiliary processing system for the air-conditioning industry.

The technical scheme adopted by the invention for solving the technical problems is as follows:

on one hand, the CAD file auxiliary processing method and system for the air conditioning industry are provided, and the method comprises the following steps:

step 1, automatically moving, zooming and copying a guide picture original picture file corresponding to a plurality of parts, calculating world coordinate points of each guide picture original picture in a general picture file according to a preset arrangement mode, and pasting each guide picture original picture to a corresponding position in the general picture file according to the world coordinate points; matching each guide picture original drawing, adding a corresponding standard picture frame, and writing an original file name of the corresponding guide picture original drawing in a detail column of each standard picture frame;

step 2, acquiring a part assembly information list of the guide picture original according to the storage information and the storage relation of the guide picture original file, and writing the content of the part assembly information list into a detail column corresponding to a standard picture frame;

step 3, determining the type and price of the parts corresponding to the original images of the guide pictures, determining formal part names corresponding to the parts according to the type and price of the parts, and replacing the original file names in the detailed columns of the standard picture frames with the formal part names;

step 4, extracting information of the detail column of each standard drawing frame according to the extracted identification information to obtain a bill of materials corresponding to all parts;

step 5, splitting each drawing in the general drawing file into single drawing files, modifying the file name of each drawing according to the name of a corresponding formal part, and storing the file name of each drawing to an appointed directory, wherein each drawing comprises a guide drawing original drawing and a corresponding standard drawing frame;

step 6, checking the total image file and the single image file, wherein the checking content at least comprises the following steps: whether the formal part names are repeated or lost, whether the detailed columns of the standard drawing frames have content loss, whether the standard drawing frames have overlapping, whether original file names which are not replaced are existed, whether the file names of the drawings are consistent with the corresponding formal part names and whether the drawing marking proportion is consistent with the drawing proportion;

and 7, converting each single image file into a PDF format.

Further, the step 1 specifically includes:

101, acquiring a directory of a guide picture original image folder to be copied, traversing and extracting names, file absolute paths and file modification time of all DXF files in the guide picture original image folder and subfolders thereof, and writing extracted contents into a CAD template copy auxiliary table;

102, acquiring a file copying and storing directory, and storing absolute path information corresponding to the file copying and storing directory in a specified area of the CAD template copying auxiliary form;

and 103, performing boundary identification, scaling, copying, pasting, standard frame screening and matching and original file name filling on the guide image original image according to the CAD template copying auxiliary table, and performing cycle operation until all guide image original image files are copied.

Further, the step 103 specifically includes:

1031, obtaining a template identification list form customized by a user, wherein the template identification list form comprises file internal information of a standard frame corresponding to each guide picture original drawing, and the file internal information of the standard frame at least comprises: the method comprises the following steps of (1) obtaining the name of a standard picture frame, the size of the picture frame, the size of a detail column, an identification mark, the size of a pasting area of an original drawing guide picture, the offset of an X axis and a Y axis of the standard picture frame and the alignment mode of the X axis and the Y axis of the standard picture frame;

step 1032, obtaining the information of the guide picture original image file, wherein the information of the guide picture original image file at least comprises: the method comprises the steps of (1) guiding an original file name of an original image, the size of the outer boundary of the image and a world coordinate point at the lower left corner of the boundary;

step 1033, obtaining external information of the standard drawing frame file customized by a user, wherein the external information of the standard drawing frame file at least comprises a file name character string and a storage absolute path of the standard drawing frame;

step 1034, checking the identification information, if no error prompt is sent after the checking is finished, entering step 1035, otherwise, exiting the file copying operation; the checking identification information specifically includes: whether the original file name of the original picture guide picture can be matched with the identification mark and whether the standard picture frame corresponding to the identification mark is missing or not;

step 1035, obtaining internal information of the standard frame file corresponding to the guide picture original, specifically comprising: matching an identification mark according to an original file name character string of the guide picture original picture, and determining the internal information of a standard picture frame file corresponding to the identification mark;

step 1036, determining the actual scaling of the original map guide image required to be scaled according to the image outer boundary size and the pasting position of the original map guide image;

step 1037, zooming the original map according to the actual scale of the original map needing to be zoomed, calculating the distance needing to be translated according to the world coordinate point at the lower left corner of the boundary of the original map, and moving the original map to the world coordinate point (0, 0);

1038, copying the original map guide image by taking the world coordinate points (0, 0) as base points;

1039, calculating world coordinate points of the guide map original drawings in the general map file according to a preset arrangement mode, and defaulting the world coordinate points of the first guide map original drawings pasted in the general map file to (0, 0);

10310, pasting the map guide original drawing to a corresponding position in the general drawing file according to the world coordinate point of the map guide original drawing in the general drawing file;

10311, calculating a world coordinate point of the standard drawing frame corresponding to the guide drawing original drawing in the general drawing file according to the offset of the X axis and the Y axis of the standard drawing frame and the alignment mode of the X axis and the Y axis of the standard drawing frame;

step 10312, searching and copying a corresponding standard drawing frame in external information of the standard drawing frame file customized by the user according to the name of the standard drawing frame acquired in the step 1035;

10313, pasting the standard drawing frame to a corresponding position in the general drawing file according to the calculated world coordinate point of the standard drawing frame in the general drawing file;

step 10314, writing the original file name of the guide picture original image into the detail column of the corresponding standard picture frame;

step 10315, judging whether the copying work of all the guide image original images is finished, if so, entering step 10316, otherwise, repeatedly executing steps 1035 to 10314;

step 10316, quitting the file copy operation.

Further, the step 2 specifically includes:

step 201, acquiring a text filling source directory, and acquiring storage information and storage relation of an original picture guide file;

step 202, judging whether the storage relation of the guide picture original image file is wrong or not, if so, ending the operation, otherwise, entering step 203;

step 203, creating a plurality of part assembly information lists according to the guide picture original drawing;

204, traversing and matching the parts assembly information list and the CAD template copy auxiliary form with corresponding drawings in a general drawing file under a file directory to be filled, and filling the contents of the detail column of the standard drawing frame of the corresponding drawing, wherein the method specifically comprises the following steps:

2041, acquiring the content of a template identification list table customized by a user, and writing the content into an array;

step 2042, obtaining the contents of the multiple component assembly information lists newly created in step 203, and writing the contents into a dynamic array;

2043, obtaining drawing frame information and name information of all drawings in the general drawing file, wherein the drawing frame information at least comprises: world coordinate information and boundary dimensions at the lower left corner of the picture frame;

2044, matching the component assembly information list contents with the name information of the drawing, and determining the component assembly information required to be filled in the current standard drawing frame detail column;

2045, calculating a world coordinate point of the part assembly information written in the general diagram file according to the size of the detail column and the boundary size of the diagram frame;

2046, writing the part assembly information according to the world coordinate points written in the general diagram file of the part assembly information and the word size selected by the user;

step 2047, judging whether the writing work of all the part assembly information is finished, if so, quitting the writing work, otherwise, repeatedly executing the steps 2044 to 2046.

Further, the step 3 specifically includes:

301, acquiring a directory of a guide picture original folder to be copied, acquiring a file name character string of the guide picture original according to the directory of the guide picture original folder, and writing the file name character string into a CAD character replacement auxiliary table;

step 302, inputting price calculation parameters in a part price list table, and determining the price of the part corresponding to each guide picture original drawing according to the price calculation parameters, wherein the price calculation parameters at least comprise: corresponding to the size of parts, unit price of materials and processing cost;

step 303, determining formal part names corresponding to the parts according to the types and prices of the parts;

step 304, pasting corresponding formal part names in the replacement areas in the CAD character replacement auxiliary table;

step 305, checking the file name character string of the guide picture original drawing and the name information of the formal part name, if no, entering step 307, otherwise, entering step 306;

step 306, modifying the name information and then entering step 305;

step 307, acquiring a total image file directory, and writing all part names and storage path information in the total image file directory into a CAD character replacement auxiliary table;

step 308, replacing the original file names of all parts with corresponding formal part names according to the content of the CAD character replacement auxiliary table;

step 309, judging whether the name replacement work of all the parts is finished, if so, quitting the name replacement work, otherwise, repeatedly executing step 308.

Further, the step 4 specifically includes:

step 401, adding extracted identification information to a detail column of a standard drawing frame;

step 402, selecting a list extraction source directory, and writing storage information of a general picture file in the list extraction source directory into a CAD list extraction auxiliary table, wherein the list extraction source directory is a general picture file storage directory added with extraction identification information;

and 403, extracting the bill of materials corresponding to all the parts according to the list extraction source catalog extraction list.

Further, the step 403 specifically includes:

4031, obtaining a template identification list table customized by a user, and writing the internal information of the file corresponding to the standard drawing frame into an array;

4032, acquiring the content of the CAD list extraction auxiliary table;

step 4033, standard drawing frame information and name information of all drawings in the general drawing file are obtained, wherein the standard drawing frame information at least comprises: world coordinates and boundary dimensions of the lower left corner of the standard drawing frame;

4034, extracting identification information corresponding to all standard frames in the general diagram file is obtained, whether the extracted identification information is wrong or not is judged, if yes, the step 4035 is executed, and if not, the step 4036 is executed;

4035, the extracted identification information is modified and the procedure reenters 4034;

4036, performing information cycle traversal extraction on the detailed columns of each standard drawing frame according to the extracted identification information to obtain a bill of materials corresponding to all parts;

4037, whether the information extraction of all the detail columns is finished is judged, if yes, the information extraction is quitted, and if not, the 4036 is repeatedly executed.

Further, the step 5 specifically includes:

step 501, selecting a drawing splitting source directory, acquiring a general drawing file name and storage path information to be split according to the drawing splitting source directory, and writing the general drawing file name and the storage path information into a CAD drawing splitting auxiliary table;

step 502, selecting a split drawing storage catalog, and writing path information in the split drawing storage catalog into a CAD drawing splitting auxiliary table;

step 503, performing drawing splitting operation according to the CAD drawing splitting auxiliary table, specifically including:

step 5031, obtaining the file internal information of the standard drawing frame in the template identification list table customized by the user, and writing the file internal information into an array;

step 5032, obtaining the name of the general drawing file to be split and the storage path information in the CAD drawing splitting auxiliary table, and writing the name and the storage path information into an array;

step 5033, obtaining all the drawing information to be split according to the general drawing file name to be split, wherein the drawing information at least comprises: the method comprises the following steps of (1) obtaining a drawing name, world coordinates of the lower left corner of a drawing frame and the boundary size of the drawing frame;

step 5034, judging whether the drawing information to be split is wrong, if so, entering step 5035, otherwise, entering step 5036;

step 5035, the drawing name is modified and the step 5034 is re-executed;

step 5036, calculating the boundary coordinates of the drawing to be split according to the drawing information;

step 5037, creating a corresponding DWG format file according to the drawing name;

step 5038, copying and pasting the drawing to be split into a corresponding DWG format file according to the boundary coordinates of the drawing to be split, and storing the DWG format file into a split drawing storage directory;

step 5039, judging whether all the drawing splitting work is finished, if so, quitting the drawing splitting work, otherwise, repeating the steps 5036 to 5038.

Further, the step 7 specifically includes:

step 701, selecting a source directory of a file to be converted, and writing path information of the source directory to be converted into a CAD-PDF conversion auxiliary table, wherein the source directory to be converted is a general picture file storage directory or a single picture file storage directory;

step 702, converting the DWG format drawing into the PDF format according to the source directory to be converted, which specifically comprises the following steps:

7021, obtaining internal information of a file of a standard drawing frame in a template identification list form customized by a user, and writing the internal information into an array;

7022, obtaining a CAD-PDF conversion auxiliary table, and writing path information of a source directory to be converted in the CAD-PDF conversion auxiliary table into an array;

step 7023, obtaining standard drawing frame information and name information corresponding to all drawings in the general drawing file, where the standard drawing frame information includes: the boundary size of the standard drawing frame and the world coordinate of the lower left corner of the standard drawing frame;

7024, judging whether the drawing information to be converted is wrong, if so, entering 7035, and otherwise, entering 7036;

7025, after the name of the drawing to be converted is modified, the step 7024 is re-entered;

7026, selecting a drawing area to be converted according to a world coordinate frame at the lower left corner of the standard drawing frame, and storing the frame selection content as a PDF format document, wherein the name of the PDF format document is a corresponding drawing name, and the storage position is a source directory of a file to be converted;

and 7027, judging whether all drawing conversion work is finished, if so, quitting the drawing conversion work, and otherwise, repeatedly executing the step 7026 to the step 7027.

In another aspect, a CAD file auxiliary processing system for the air conditioning industry is provided, including:

the CAD template file copying module is used for automatically moving, zooming and copying the guide picture original image files corresponding to the parts, calculating world coordinate points of the guide picture original images in the general picture file according to a preset arrangement mode, and pasting the guide picture original images to corresponding positions in the general picture file according to the world coordinate points; matching each guide picture original drawing, adding a corresponding standard picture frame, and writing an original file name of the corresponding guide picture original drawing in a detail column of each standard picture frame;

the CAD initial list generation and character filling module is used for acquiring a part assembly information list of the guide picture original according to the storage information and the storage relation of the guide picture original file, and writing the content of the part assembly information list into a detail column corresponding to a standard picture frame;

the CAD part price estimation and character replacement module is used for determining the type and price of the part corresponding to each guide picture original image, determining a formal part name corresponding to each part according to the type and price of the part, and replacing the original file name in the detailed column of each standard picture frame with the formal part name;

the CAD bill of materials extraction module is used for extracting information of the detailed column of each standard drawing frame according to the extracted identification information to obtain bills of materials corresponding to all parts;

the CAD drawing splitting module is used for splitting each drawing in the general drawing file into a single drawing file, modifying the file name of each drawing according to the name of a corresponding formal part and storing the file name to an appointed directory, wherein the drawing comprises a guide drawing original drawing and a corresponding standard drawing frame;

the CAD file content inspection module is used for inspecting the general picture file and the single picture file, and the inspection content at least comprises the following steps: whether the formal part names are repeated or lost, whether the detailed columns of the standard drawing frames have content loss, whether the standard drawing frames have overlapping, whether original document names which are not replaced are existed, whether the document names of the drawings are consistent with the corresponding formal part names and whether the drawing marking proportions are consistent with the drawing proportions;

and the CAD-PDF conversion module is used for converting each single image file into a PDF format.

The invention has the beneficial effects that: according to the CAD file auxiliary processing method and system for the air conditioning industry, provided by the invention, the CADVBA program, the EXCELVBA program and the EXCEL form are adopted to work in a coordinated mode, so that the automatic batch copying, pasting, sorting, searching, screening, matching, zooming, labeling, renaming, list extraction, drawing splitting, PDF conversion, drawing content error checking and the like of the CAD file are carried out, the workload of two-dimensional part drawing is greatly reduced, the error probability is reduced, the operation method is simplified, and the operation efficiency is improved.

Drawings

Fig. 1 is a schematic structural diagram of a CAD file auxiliary processing system for the air conditioning industry according to an embodiment of the present invention;

FIG. 2 is a schematic flow chart of a CAD file auxiliary processing method for the air-conditioning industry according to an embodiment of the present invention;

FIG. 3 is a schematic flowchart of a CAD template file copying module implementation method according to an embodiment of the present invention;

FIG. 4 is a flowchart illustrating a file copy operation according to an embodiment of the present invention;

FIG. 5 is a diagram illustrating an identification rule of an original image of a guide map according to an embodiment of the present invention;

FIG. 6 is a schematic flow chart of a CAD initial list generation and text filling module implementation method according to an embodiment of the present invention;

FIG. 7 is a flowchart illustrating a text fill operation according to an embodiment of the present invention;

FIG. 8 is a schematic flow chart of a CAD component price estimation and text replacement module implementation method according to an embodiment of the present invention;

FIG. 9 is a schematic flowchart of a CAD bill of materials extraction module implementation method according to an embodiment of the present invention;

FIG. 10 is a flowchart illustrating a manifest extraction operation according to an embodiment of the present invention;

FIG. 11 is a schematic flow chart of a method for implementing a CAD drawing splitting module according to an embodiment of the present invention;

FIG. 12 is a schematic flow chart illustrating a drawing splitting operation according to an embodiment of the present invention;

FIG. 13 is a schematic flow chart diagram of a CAD-PDF conversion module implementation method according to an embodiment of the present invention;

FIG. 14 is a schematic flow chart of a PDF conversion operation according to an embodiment of the present invention;

FIG. 15 is a schematic flowchart of a CAD file content inspection module implementation method according to an embodiment of the present invention;

FIG. 16 is a flowchart illustrating a file checking operation according to an embodiment of the present invention;

FIG. 17 is a schematic diagram of a CAD drawing according to an embodiment of the present invention;

FIG. 18 is a schematic diagram illustrating a schematic diagram of frame information identification according to an embodiment of the present invention;

fig. 19 is a schematic diagram of a human-computer interaction interface according to an embodiment of the invention.

Detailed Description

Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

The invention provides a CAD file auxiliary processing system for air conditioning industry, as shown in fig. 1, comprising: the CAD template file copying module, the CAD initial list generating and character filling module, the CAD part price estimating and character replacing module, the CAD material list extracting module, the CAD drawing splitting module, the CAD file content checking module and the CAD-PDF converting module are based on the system, and the CAD file auxiliary processing method for the air conditioning industry, as shown in figure 2, comprises the following steps:

step 1, a CAD template file copying module automatically moves, zooms and copies guide picture original image files corresponding to a plurality of parts, calculates world coordinate points of each guide picture original image in a general picture file according to a preset arrangement mode, and pastes each guide picture original image to a corresponding position in the general picture file according to the world coordinate points; matching each guide picture original drawing, adding a corresponding standard picture frame, and writing an original file name of the corresponding guide picture original drawing in a detail column of each standard picture frame;

specifically, the method is mainly used for matching the two-dimensional part drawing guide original drawing under the file directory of the windows system specified by the user with the corresponding drawing frame, automatically zooming the two-dimensional part drawing guide original drawing, pasting the two-dimensional part drawing guide original drawing in the CAD general drawing file under the storage directory specified by the user, and arranging the two-dimensional part drawing guide original drawing according to the arrangement mode preset by the user. When the zooming type is selected, a user can select to keep the picture frame unchanged and zoom the original picture of the guide picture, and can also select to keep the original picture of the guide picture unchanged and zoom the picture frame; the preset arrangement mode can be selected to be arranged according to a loading relation or be arranged in rows and columns, when the module is arranged according to the loading relation, the module can arrange the superior part to the leftmost side, the lower part columns of the part are arranged on the right side in sequence, and when the module is arranged in rows and columns, the module can arrange the part drawing paper according to the established column number; the user can also select the line height and the column width to control the line spacing and the column spacing of the arrangement of each drawing; in order to avoid the problems that the windows system is slow in processing and even stuck due to the fact that the number of the part drawings in a single general diagram is too large, a user is allowed to select the drawing capacity of the single general diagram, the drawing capacity is the upper limit of the number of the drawings in the general diagram, and the value is larger than or equal to 1. As shown in fig. 3, the detailed steps of the implementation method are as follows:

101, acquiring a directory of a guide picture original folder to be copied, traversing and extracting names, file absolute paths and file modification time of all DXF files in the guide picture original folder and subfolders thereof by an EXCELVBA program, and writing the extracted contents into a CAD template copying auxiliary table; the reason for selecting the DXF file format is that the DXF file format is the CAD file, which is convenient for distinguishing the DWG format file after the post-processing;

102, acquiring a file copying and storing directory, and storing absolute path information corresponding to the file copying and storing directory in a specified area of the CAD template copying auxiliary table by the EXCELVBA program;

and 103, the EXCELVBA program performs the boundary identification, the scaling, the copying and the pasting of the guide picture original, the screening and the matching of the standard frame and the filling of the original file name according to the CAD template copying auxiliary table, and the operation is circulated until all the guide picture original files are copied. As shown in fig. 4, the implementation method comprises the following steps:

specifically, the CADVBA program opens a template identification list table, and writes information such as a user-defined frame template name and an identification mark in the table into an array for temporary storage. The template identification list content comprises a picture frame template name, an identification mark, a picture guide pasting area length, a unit mm, a picture guide pasting area width, a unit mm, a picture guide picture frame X-axis direction offset, a unit mm, a picture guide picture frame Y-axis direction offset, an X-axis direction alignment mode (distance from the left is proportional, an input numerical value is 0-1), a Y-axis direction alignment mode (distance from the left is proportional, an input numerical value is 0-1), a standard picture frame length, a standard picture frame width, picture frame detail column boundary sizes and the like, and all contents in a template identification list table can be defined by a user;

step 1032, obtaining the guide picture original image file information through CADVAB program circulation traversal, wherein the guide picture original image file information at least comprises: the original file name of the original image of the guide map, the size of the outer boundary of the image (including the length and the width of the boundary) and the world coordinate point at the lower left corner of the boundary;

1033, obtaining external information of the standard drawing frame file customized by a user through a CADVAB program, wherein the external information of the standard drawing frame file at least comprises a file name character string and a storage absolute path of a standard drawing frame;

step 1034, checking the identification information, entering step 1035 if no error prompt is sent after the checking is finished, otherwise, exiting the file copying operation; the checking identification information specifically includes: whether the original file name of the original picture guide picture can be matched with the identification mark and whether the standard picture frame corresponding to the identification mark is missing or not;

specifically, when the original file name of the original picture guide is not matched with the identification mark, error information that the original picture guide cannot be identified is prompted to a user, when the original file name of the original picture guide can be matched with the identification mark but a custom standard picture frame corresponding to the identification mark is absent, custom standard picture frame missing information is prompted to the user, the original file names, the error information which cannot be identified, the custom standard picture frame missing information and the like of all the original picture guide are written into an EXCEL table and output, and then the file copying operation is quitted; and if no error information is prompted when the traversal check is completed, performing the next operation.

When the name character string of the guide picture original picture contains the designated identification mark, the CADVBA program acquires standard picture frame information corresponding to the identification mark. As shown in fig. 5, for example, two pieces of original guide drawings are provided, wherein one drawing file name is "abcdeff.dxf", and the other drawing file name is "defghi.dxf", the user defines three identifiers in the area specified by the template identification list table, which are "abc" corresponding to the frame file name "a.dwg", "efg" corresponding to the frame file name "e.dwg", and "ce" corresponding to the frame file name "c.dwg", and the user defines three standard frame files a.dwg, e.dwg, and c.dwg under the "CAD template source directory" folder. Upon recognition, the CADVBA program will pair the guide artwork "abcdeff.dxf" with the identifier "abc" and the corresponding frame file name "a.dwg" and template source directory "folder under a.dwg, and pair the guide artwork" defghi.dxf "with the identifier" efg "and the corresponding frame file name" e.dwg "and template source directory" folder under e.dwg. Therefore, the user-defined identifiers cannot be repeated when the identifiers are customized, and if the long identifiers need to be arranged before the short identifiers when the inclusion relationship exists, for example, identifier 1 is "ABCDE" and identifier 2 is "ABC", identifier 1 should be arranged before identifier 2 in the template identifier list. When the three-dimensional modeling is carried out, a user is required to name the parts, the names of the parts need to contain self-defined identification information, and the names of original files of the guide map can automatically carry the identification information during the guide map.

Step 1035, obtaining internal information of the standard drawing frame file corresponding to the guide drawing original drawing, specifically comprising: the CADVBA program matches an identification mark according to an original file name character string of a guide picture original drawing, and determines the internal information (including the name of a corresponding standard picture frame, the length of a guide picture pasting area, the unit mm, the width of the guide picture pasting area, the unit mm, the offset of the guide picture frame in the X-axis direction, the unit mm, the offset of the guide picture frame in the Y-axis direction, the alignment mode in the X-axis direction (the distance from the left is proportional, the input numerical value is 0-1), the alignment mode in the Y-axis direction (the distance from the left is proportional, the input numerical value is 0-1), the length of the standard picture frame and the width of the standard picture frame) and the like of the standard picture frame file corresponding to the identification mark;

step 1036, determining the actual scaling ratio of the original image guide image to be scaled according to the image outer boundary size and the pasting position of the original image guide image;

when the user selects to arrange in rows and columns, the following rule is satisfied when the world coordinates (x, y) of the pasting point are calculated: x = x0+ a n, y = y0 when n < = n1, and n < n2, x = x0, y = y0+ b m when n < = n1, and n = n2, and x = x0+ a (n-n 1 m), y = y0+ b m when n < = n1, and n > n 2. When n > n1 and n = n1 f +1, x = x0, y = y0. The method comprises the steps that (x, y) is world coordinates of a current pasting point when a user selects to arrange according to rows and columns, n is the number of current accumulated guide picture original pictures, n1 is the number of single total picture file drawings, n2 is the number of columns selected by the user, x0=0, y0=0, a is the width of the columns selected by the user, b is the height selected by the user, m is the number n of the current accumulated guide picture original pictures divided by the number n2 of the columns to be rounded, and f is the number n of the current accumulated guide picture original pictures divided by the number n1 of the single total picture file drawings to be rounded.

When the user selects to arrange in the load relationship, the following rule is satisfied when calculating the world coordinates (x, y) of the pasting point: x = x1+ a, y = y1 when n < = n1, and n < = h, x = x1-h a, y = y1+ b when n < = n1, and n = h +1, and x = x1+ a, y = y1 when n < = n1, and n > h + 1. When n > n1 and n = n1 f +1, x = x0, y = y0. And (x, y) world coordinates of a current pasting point when the user selects to arrange according to rows and columns, n is the number of the current accumulated guide picture original drawings, n1 is the number of the single total picture file drawings, and h is the number of the lower level drawings of the assembly relation of the current part drawings. x1 and y1 are world coordinates of the previous drawing respectively, the first drawing x1=0, y1=0, a is the column width selected by the user, b is the row height selected by the user, and f is the number n of the current accumulated guide picture original drawings divided by the number n1 of the drawings of the single total picture file.

step 10313, pasting the standard drawing frame to a corresponding position in the general drawing file according to the calculated world coordinate point of the standard drawing frame in the general drawing file;

10314, writing the original file name of the guide picture original image into the detail column of the corresponding standard picture frame;

and step 10316, quitting the file copying operation.

Step 2, the CAD initial list generation and character filling module acquires a part assembly information list of the guide picture original according to the storage information and the storage relation of the guide picture original file, and writes the content of the part assembly information list into a detail column corresponding to a standard picture frame;

the method comprises the steps of traversing and extracting file name character strings of the two-dimensional part original drawings under the file directory of the windows system selected by a user through an EXCELVBA program according to the storage relation of the two-dimensional part original drawings, and generating an EXCEL table of a part assembly information list. The user can select whether to modify the contents of the EXCEL form, after the modification of the part assembly information list is completed, the CADVBA program opens all drawings under the list catalog to be filled specified by the user, automatically matches the corresponding drawings according to the content of the list and fills the contents such as the original naming, the quantity and the like of the parts in the initial detailed list in the specified area of the drawing picture frame detailed list, and before the character filling, the user can set character filling character numbers in different areas so as to adapt to the size of the detailed list form. As shown in fig. 6, the detailed steps of the implementation method are as follows:

step 201, acquiring a text filling source directory, and acquiring storage information and a storage relation of an original picture file of a guide picture;

the text filling source directory refers to a list information source which the user needs to fill in the component detail column. The component assembly information list is mainly built through the storage relation of the original drawing guide image under the windows system, and the principle and the rule are that the original drawing guide image of the component drawing needs to be stored under a file which does not contain a suffix with the original drawing guide image and is named as the same as the original drawing guide image, the original drawing guide image of the component drawing at the lower level is stored under the file, and the original drawing guide image of the component drawing at the lower level needs to be stored under the file which does not contain the suffix with the original drawing guide image and is named as the same as the original drawing guide image and is arranged downwards step by step. For example, there are eight original file drawings of guide map, which are a.dxf, b.dxf, c.dxf, d.dxf, e.dxf, f.dxf, g.dxf, and h.dxf, respectively, where a.dxf, b.dxf, c.dxf, and d.dxf are component drawings, e.dxf, f.dxf, g.dxf, and h.dxf are part drawings, a lower component of a.dxf is c.dxf, a lower component of b.dxf is d.dxf, a lower component of f is f.dxf, a lower component of c.dxf is g.dxf, a lower component of d.dxf is h.dxf, and when a user performs a three-dimensional zero-component guide map operation, a directory name of a folder is created, a directory name of a directory is b.dxf, a directory name of a directory is created, a directory name of a directory is stored, a directory name of a.dxf, a directory name of a folder is stored, a directory name of b.dxf, a directory is stored, a directory name of the original file, a directory is stored, and a folder is stored. Because the windows system does not allow the user to store the same named files of the same type in the same folder, the repeated graph storing operation of the user can be avoided indirectly. When the text filling source directory is selected in step S201, the EXECLVBA program automatically obtains the storage relationship of the guide picture original drawing in the directory specified by the user;

step 202, judging whether the storage relation of the guide picture original image file is wrong, if so, ending the operation, otherwise, entering step 203;

specifically, the EXCELVBA program can perform correct and incorrect judgment on the storage relationship in the process of generating the part assembly information list, when part drawings with the same name as the folder are missing under the part folder, the folders or the part drawings with the same name appear, or different guide image original drawings are stored under the same folder name, and the like, the EXCELVBA program can prompt that the storage relationship of the guide image original drawings is incorrect, output the error information in the form of an EXCEL table, end the operation, and perform the next operation if no problem exists;

step 203, creating a plurality of part assembly information lists according to the guide picture original drawing; the user can select whether to modify the information in the form, such as the assembly quantity of the parts, defaults to 1 when not modified, whether to newly add some conventional material information and the like, and the assembly information list of the parts is closed and saved after the modification is finished.

And 204, traversing and matching the corresponding drawings in the general drawing file under the file directory to be filled according to the part assembly information list and the CAD template copying auxiliary table, and filling the contents of the detailed columns of the standard drawing frames of the corresponding drawings. As shown in fig. 7, the implementation method comprises the following steps:

2041, acquiring the contents of a template identification list form customized by a user, including information such as standard drawing frame boundary size and each detail column boundary size, and writing the contents into an array;

step 2042, acquiring the contents of the multiple component assembly information lists created in step 203, and writing the contents into a dynamic array;

Step 3, determining the type and the price of the part corresponding to each guide picture original image by a CAD part price estimation and character replacement module, determining a formal part name corresponding to each part according to the type and the price of the part, and replacing the original file name in the detailed column of each standard picture frame with the formal part name;

the method mainly comprises two parts, namely estimating the price of the part and replacing the original name of the part drawing paper. The price estimation of the parts is carried out by obtaining a list consisting of character strings of original files of a guide picture under a specified directory, and estimating the price according to a price calculation rule customized by a user, wherein the price calculation rule generally comprises the size of the parts, the material unit price of the parts, the density of the parts, the processing cost of the parts and the like, the user can define the rule by himself, and after the estimated price of the parts is calculated, formal name application is carried out according to the price and the type of the parts. The original name of the part drawing needs to be replaced because firstly, designers name the parts in a simple mode in order to distinguish different parts and carry out drawing naming most efficiently, secondly, the names of formal parts are usually formed by letters, numbers or pure numbers when applying for the parts, the naming lengths are long, the types of the parts cannot be seen from the naming of the parts, finally, the sizes of the parts in the modeling stage are unknown before naming, the price cannot be calculated, and the estimated prices of the parts need to be calculated in advance when applying for the names of the formal parts, so that the names of the formal applications cannot be used for naming during modeling, and the original names need to be replaced by the names formally in the drawing processing process. As shown in fig. 8, the method comprises the following steps:

step 302, inputting price calculation parameters in a part price list table, and calculating the price of the part corresponding to each guide picture original drawing according to the price calculation parameters and a predefined calculation formula, wherein the price calculation parameters at least comprise: corresponding to the size of parts, unit price of materials and processing cost;

the checking items comprise whether the original name is repeated or not and whether the formal name is repeated or not, whether the corresponding category of the original name to be replaced and the formal name to be replaced is consistent or not, and whether the corresponding estimated price of the original name to be replaced and the corresponding price of the formal name to be replaced are consistent or not. Through the information check, the error input of the user can be effectively avoided. If the form replacement information is wrong, the user is prompted to modify the CAD character replacement auxiliary form and output the modified information, and the next operation can be performed if the form replacement information is correct.

Step 306, modifying the name information and then entering step 305;

308, replacing original file names of all parts with corresponding formal part names according to the content of the CAD character replacement auxiliary table;

Step 4, the CAD bill of materials extraction module extracts information from the detail column of each standard drawing frame according to the extracted identification information to obtain the bill of materials corresponding to all the parts;

the step is used for identifying all drawing frames of the part drawing paper under the file directory of the windows system selected by the user through a CADVBA program, and extracting, integrating and outputting the detailed column information to an EXCEL form to form a part bill of materials. As shown in fig. 9, the detailed steps of the implementation method are as follows:

step 401, adding extracted identification information to a detail column of a standard drawing frame; the extracted identification information can be customized by a user, and the default is '#' which is required to be not the same as the formal name of the part. The reason why the "#" is added is that the content in the detail columns of different parts is different, and the extracted identification information is added to mark the boundaries of the detail columns of different drawings.

and 403, extracting the bill of materials corresponding to all the parts according to the list extraction source catalog extraction list. As shown in fig. 10, the method mainly includes the following steps:

4032, acquiring the content of the CAD list extraction auxiliary table;

the identification information extraction is judged mainly by judging whether the extracted identification information is missing, repeated and the like, if the extracted identification information is wrong, a user is prompted to modify the extracted identification information, and if the extracted identification information is wrong, next step operation is performed;

4035, after the extracted identification information is modified, the procedure reenters 4034;

4036, performing information cycle traversal extraction on the detail columns of the standard frames according to the extracted identification information to obtain material lists corresponding to all parts;

Step 5, the CAD drawing splitting module splits each drawing in the general drawing file into single drawing files, modifies the file name of each drawing according to the name of the corresponding formal part and stores the file name to an appointed directory, wherein the drawing comprises a guide drawing original drawing and a corresponding standard drawing frame;

the method is used for splitting a plurality of parts drawing papers stored in a general drawing under a file directory of a windows system specified by a user into single drawing forms corresponding to drawing names of the parts drawing papers. As shown in fig. 11, the detailed steps of the implementation method are as follows:

step 501, selecting a drawing splitting source directory, acquiring a total drawing file name and storage path information to be split according to the drawing splitting source directory, and writing the total drawing file name and the storage path information into a CAD drawing splitting auxiliary table;

step 503, performing a drawing splitting operation according to the CAD drawing splitting auxiliary table, as shown in fig. 12, specifically including:

step 5032, obtaining the total graph file name to be split and the storage path information in the CAD drawing splitting auxiliary table, and writing the total graph file name and the storage path information into an array;

step 5033, obtaining all the drawing information to be split according to the general drawing file name to be split, wherein the drawing information at least comprises: the name of the drawing, the world coordinate of the lower left corner of the drawing frame and the boundary size of the drawing frame;

specifically, the CADVBA program checks whether the drawing information to be split is wrong, and the check content includes whether the drawing name is repeated or missing, because the split single drawing needs to be stored in the name of the corresponding drawing, and errors can be caused when the drawing name is repeated or missing. If the name of the drawing is repeated or missing, prompting a user to modify the name of the drawing to be split, and if no error information is prompted, performing next operation;

step 5035, the drawing name is modified and the step 5034 is re-executed;

Step 6, the CAD file content checking module checks the general picture file and the single picture file, and the checking content at least comprises the following steps: whether the formal part names are repeated or lost, whether the detailed columns of the standard drawing frames have content loss, whether the standard drawing frames have overlapping, whether original document names which are not replaced are existed, whether the document names of the drawings are consistent with the corresponding formal part names and whether the drawing marking proportions are consistent with the drawing proportions;

the method comprises the steps of checking the drawing content information under a file directory of a windows system appointed by a user, wherein the checking content comprises whether a drawing name is duplicated or lost, whether the content of a drawing detail column is lost, whether a list extraction identifier is duplicated or lost, whether a drawing picture frame area is overlapped, whether original name identification information which is not replaced exists in the drawing, and carrying out content checking that the name of a single-drawing file is consistent with the name of the corresponding drawing, checking that the actual annotation proportion of the drawing is consistent with the proportion of the drawing and the like on the single-drawing content. As shown in fig. 13, the detailed steps of the implementation method are as follows:

step S601, selecting a file inspection source directory, wherein the file inspection source directory refers to a file storage directory which needs to be inspected by a user, and can be any DWG format drawing storage directory processed in the step S2 to the step S6, and the EXCELVBA program writes the file name and path information in the file inspection source directory into a designated area of a CAD file inspection auxiliary table after selection;

step S602 performs a file checking operation, and selects a file checking source directory according to step S601 to perform a file content checking operation, as shown in fig. 14, the detailed steps of the implementation method are as follows:

step S6021, obtaining the corresponding standard picture frame content in the template identification list table customized by the user through the CADVBA program, including the information of the standard picture frame boundary size, the boundary size of each detail column and the like, and writing the information into an array;

step S6022, acquiring template identification list table content, acquiring all file storage information in the step S601 through CADVBA, and writing the information into an array;

step S6023, traversing and acquiring all drawing names, world coordinate information of the lower left corner of all drawing frames, boundary size information of all drawing frames, detailed column content information and drawing label proportion information in the file in the step S6022 through a CADVBA program, and extracting identification content information and the like;

and step S6024, comparing the information by the CADVBA program according to the information acquired in the step S6023, outputting the comparison information to the EXCEL table, and ending the checking operation.

And 7, converting each single image file into a PDF format by the CAD-PDF conversion module. As shown in fig. 15, the method comprises the following steps:

701, selecting a source directory of a file to be converted, and writing path information of the source directory to be converted into a CAD-PDF conversion auxiliary table, wherein the source directory to be converted is a general picture file storage directory or a single picture file storage directory;

step 702, converting the DWG format drawing into the PDF format according to the to-be-converted source directory, as shown in fig. 16, specifically including:

7021, obtaining the internal information of the file of the standard drawing frame in the template identification list table customized by the user, and writing the internal information into an array;

step 7024, judging whether the drawing information to be converted is wrong, if so, entering step 7035, and otherwise, entering step 7036;

the check content includes whether the drawing name is repeated or missing, because the single drawing after the PDF conversion needs to be stored in the name of the corresponding drawing in the PDF format conversion process, and the storage error will be caused when the drawing name is repeated or missing. And when the drawing name is repeated or lost, prompting a user to modify the name of the drawing to be converted, and if no error information is prompted, performing the next operation.

7026, framing a to-be-converted drawing area according to the world coordinate at the lower left corner of the standard drawing frame, and storing framed contents as a PDF (portable document format) document, wherein the name of the PDF document is a corresponding drawing name, and the storage position is a to-be-converted file source directory;

The part drawing paper frequently used in the air conditioning industry mainly comprises two parts, as shown in fig. 17, the part drawing paper comprises a part two-dimensional drawing and a drawing frame, the two-dimensional drawing is stored in a drawing frame boundary, a drawing frame detail column is used for drawing name, drawing number, loading relation filling and the like, the standard drawing frame boundary is a rectangular drawing element, and the perimeter and the area of the rectangular drawing element can be obtained through an EXCELVBA program. The user fills in the designated area in the template identification list table with the standard frame name, the guide picture pasting area length, the unit mm, the guide picture pasting area width, the unit mm, the guide picture frame X-axis direction offset, the unit mm, the guide picture frame Y-axis direction offset, the X-axis direction alignment mode (distance to the left is proportional, input numerical value: 0-1), the Y-axis direction alignment mode (distance to the left is proportional, input numerical value: 0-1), the standard frame length (rectangular primitive length), the standard frame width (rectangular primitive width), the offset distance of each boundary of the detail column relative to the standard frame lower left corner X and the Y-axis direction, and other parameters, and the definition work of different types of standard frames can be completed.

In this embodiment, the recognition of the frame and the extraction principle and steps of the text information in the frame are shown in fig. 18, and the detailed method steps are as follows:

step S801, acquiring the template identification list table content. Obtaining information required to be obtained by frame identification in a template identification list xls table through a CADVBA program, wherein the information comprises parameters such as standard frame length (rectangular primitive length), standard frame width (rectangular primitive width), offset distance of each boundary of a detail column relative to the x and y axis directions of the lower left corner of the standard frame and the y axis direction;

and S802, obtaining drawing rectangular primitive information. Acquiring drawing primitive information including a rectangular primitive perimeter, a rectangular primitive area and a rectangular primitive world coordinate point through a CADVBA program;

step S803, determine whether the rectangular primitive is a frame. Through the comparison and analysis of the CADVBA program according to the user-defined frame information in the step S801 and all the rectangular primitive information acquired in the step S802, the rectangular primitive meeting the frame identification rule can be regarded as the frame. The frame identification rule is as follows, when m/c = (a x b)/(2 x (a + b)), the rectangular primitive is a frame, wherein m is the area of the rectangular primitive, c is the perimeter of the rectangular primitive, a is the user-defined frame length, and b is the user-defined frame width. For example, a user defines two standard drawing frames in a "template identification list. Xls" table, where a drawing frame 1 is a1 long and b1 wide, a drawing frame 2 is a2 long and b2 wide, there are two rectangular primitives in a CAD drawing file, the area of the rectangular primitive 1 is m1= a1 × b1, the perimeter is 2 (a 1+ b 1), the area of the rectangular primitive 2 is m2= a2 × b3, and the perimeter is 2 (a 2+ b 3), where b2< > b3, at this time, the rectangular primitive 1 may be determined as a drawing frame, and the rectangular primitive 2 may not be determined as a drawing frame;

step S804, extracting text information in the frame. The world coordinate points of the lower left corner of the frame conforming to the rules can be obtained through the step S803, the world coordinate points of the boundaries of the frame detail column can be calculated according to the parameters such as the offset distance of the boundaries of the frame detail column obtained in the step S801 relative to the x-axis direction and the y-axis direction of the lower left corner of the standard frame, all character information can be obtained through the CADVBA program, and when the character coordinates are within the range of the world coordinate points of the boundaries of the frame detail column, the characters are character information in the corresponding region of the corresponding frame.

The CAD file auxiliary processing method and the system in the air-conditioning industry have the advantages that:

1. the method can automatically copy and paste the original map of the guide picture in batches, automatically match the corresponding picture frames in batches, automatically scale and scale the original map of the guide picture in batches according to the size of the picture frames, automatically fill the scale, name the original drawing, and automatically check whether the copied items are repeated;

2. whether the storage relation of the original drawing of the user guide picture has a problem or not can be automatically checked, an initial filling list is automatically generated according to the storage relation, and the content of a drawing picture frame column is automatically filled according to the initial filling list and the corresponding drawing;

3. the price can be automatically calculated according to the size and material input of the user part, whether the original name is repeatedly lost or not, whether the formal name is repeatedly lost or not and whether the formal name type is correct or not can be automatically checked when the original name of the part drawing is replaced, whether the estimated price is consistent with the applied price or not can be effectively avoided, and the replacement error caused by the wrong input of the user can be effectively avoided;

4. the drawing detail column information can be automatically searched in batches, the part material list is formed after the information is collected, the material list content is completely consistent with the content of each part drawing detail column, and errors caused by manual drawing list drawing and manual filling of a user are avoided;

5. the drawings in a file can be automatically split into single drawings in batches, the drawings stored in the file do not need to be regularly arranged at equal intervals, and the drawing frames can be of various types and sizes and can be identified and split;

6. the CAD files can be automatically converted into PDF format in batches, and the drawings to be converted can be in the form of multiple drawings or a single drawing;

7. the method can check multiple items of content information of the drawing, avoids a large number of manual checking processes, has extremely high checking efficiency, and can check before any other functions are used;

8. as shown in fig. 19, the modules for executing the steps have visual windows, so that human-computer interaction can be performed, and the operation of each process is simple and clear;

9. in the operation process, each module has the functions of error correction and error correction, so that a large number of manual input errors can be avoided, and meanwhile, each module uses a VBA program for automatic processing, so that the efficiency is extremely high, and the error rate is extremely low;

10. a user can define the picture frame type, the picture frame size, the identification mark, the drawing pasting area, the drawing alignment mode and the like in the template identification list form according to the part type required by the user for personal customization.

Claims

1. The CAD file auxiliary processing method for the air conditioning industry is characterized by comprising the following steps of:

and 7, converting each single image file into a PDF format.

2. The CAD file auxiliary processing method for air conditioning industry as set forth in claim 1, wherein said step 1 specifically comprises:

101, acquiring a directory of a guide picture original folder to be copied, traversing and extracting names, file absolute paths and file modification time of all DXF files in the guide picture original folder and subfolders thereof, and writing extracted contents into a CAD template copying auxiliary table;

3. The CAD file auxiliary processing method for air conditioning industry as recited in claim 1, wherein said step 103 specifically comprises:

step 1033, obtaining external information of a standard drawing frame file customized by a user, wherein the external information of the standard drawing frame file at least comprises a file name character string and a storage absolute path of a standard drawing frame;

10310, pasting the guide picture original drawing to a corresponding position in the general picture file according to the world coordinate point of the guide picture original drawing in the general picture file;

10312, searching and copying a corresponding standard frame in external information of the standard frame file customized by the user according to the name of the standard frame obtained in the step 1035;

step 10316, quitting the file copy operation.

4. The CAD file auxiliary processing method for air conditioning industry as recited in claim 3, wherein said step 2 specifically comprises:

step 203, creating a plurality of component assembly information lists according to the original drawing guide picture;

2043, obtaining drawing frame information and name information of all drawings in the general drawing file, wherein the drawing frame information at least comprises: world coordinate information and boundary dimensions of the lower left corner of the frame;

step 2044, matching the content of the part assembly information list with the name information of a drawing, and determining part assembly information required to be filled in a current standard drawing frame detailed column;

2046, writing the component assembly information according to the world coordinate points written in the general diagram file by the component assembly information and the word size selected by the user;

5. The CAD file auxiliary processing method for air conditioning industry as recited in claim 1, wherein said step 3 specifically comprises:

301, acquiring a guide picture original image folder directory to be copied, acquiring a file name character string of a guide picture original image according to the guide picture original image folder directory, and writing the file name character string into a CAD character replacement auxiliary table;

step 302, inputting price calculation parameters in a part price list table, and determining the price of the part corresponding to each guide picture original drawing according to the price calculation parameters, wherein the price calculation parameters at least comprise: corresponding to the size of the part, the unit price of the material and the processing cost;

304, pasting corresponding formal part names in the replacement areas in the CAD character replacement auxiliary table;

step 306, modifying the name information and then entering step 305;

307, acquiring a general picture file directory, and writing the names of all parts and storage path information in the general picture file directory into a CAD character replacement auxiliary table;

6. The CAD file auxiliary processing method for air conditioning industry as recited in claim 1, wherein said step 4 specifically comprises:

7. The CAD file auxiliary processing method for the air conditioning industry as recited in claim 6, wherein said step 403 specifically comprises:

4032, acquiring the content of the CAD list extraction auxiliary table;

4033, standard drawing frame information and name information of all drawings in the general drawing file are obtained, wherein the standard drawing frame information at least comprises: world coordinates and boundary dimensions of the lower left corner of the standard drawing frame;

4034, acquiring extracted identification information corresponding to all standard drawing frames in the general drawing file, and judging whether the extracted identification information is wrong, if so, entering a 4035, otherwise, entering a 4036;

8. The CAD file auxiliary processing method for the air conditioning industry as recited in claim 1, wherein said step 5 specifically comprises:

step 5035, the drawing name is modified and the step 5034 is re-executed;

9. The CAD file auxiliary processing method for air conditioning industry as recited in claim 1, wherein said step 7 specifically comprises:

step 7025, after the name of the drawing to be converted is modified, the step 7024 is re-entered;

10. CAD file auxiliary processing system for air conditioning industry, characterized by that includes:

the CAD bill of materials extraction module is used for extracting information of the detail column of each standard drawing frame according to the extracted identification information to obtain a bill of materials corresponding to all parts;

the CAD drawing splitting module is used for splitting each drawing in the general drawing file into a single drawing file, modifying the file name of each drawing according to the name of the corresponding formal part and storing the file name of each drawing to an appointed directory, wherein each drawing comprises a guide drawing original drawing and a corresponding standard drawing frame;

the CAD file content checking module is used for checking the general picture file and the single picture file, and the checking content at least comprises the following steps: whether the formal part names are repeated or lost, whether the detailed columns of the standard drawing frames have content loss, whether the standard drawing frames have overlapping, whether original file names which are not replaced are existed, whether the file names of the drawings are consistent with the corresponding formal part names and whether the drawing marking proportion is consistent with the drawing proportion;

and the CAD-PDF conversion module is used for converting each single-figure file into a PDF format.