CN115146327A - CAD file auxiliary processing method and system for air-conditioning industry - Google Patents

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-conditioning 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 technique

In the air-conditioning industry, a new air-conditioning product requires 3D modeling and mapping, and 2D component drawing processing work during the design process. 3D modeling mainly uses 3D modeling software for 3D modeling of air-conditioning products and 2D parts mapping work. The 2D parts drawings are mainly CAD files. The work content of 2D component drawing processing is mainly divided into the following steps: 1. Manually copy and paste the original map files of all 2D components into a CAD component general drawing file; 2. Manually find matching correspondences according to each component type Type of standard drawing frame, 3. According to the size comparison between the drawing area of the component and the drawing frame, manually scale the drawing of the component, and add the scaling ratio in the parts list of the drawing frame; 4. Manually assign the two-dimensional component according to the assembly relationship of the two-dimensional component The drawing list is filled with information such as the original names and quantities of its subordinate components; 5. Label the drawings according to different scales of the two-dimensional component drawings; 6. Manually rename the component drawings in step 4 according to the officially applied component names; 7. Manually draw up the list of parts and components according to the list of two-dimensional parts drawings for processing and material procurement; 8. Manually split the parts drawings in the two-dimensional parts general drawing into single drawings for archiving; 9. In order to facilitate the viewing of drawings by personnel in different departments, it is necessary to manually convert the CAD files into PDF texts.

The above is the basic processing flow of 2D component drawings in the air-conditioning industry. Usually, an air-conditioning product has hundreds of component drawings and dozens of frame types, which are manually copied, pasted, searched, filtered, and matched. , scaling, labeling, renaming, material list extraction, drawing splitting, PDF conversion and other mechanical repetitive tasks are time-consuming and have a high error rate, which seriously affects the design and development efficiency of new air conditioners and the accuracy of design drawings.

SUMMARY OF THE INVENTION

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

The technical scheme adopted by the present invention to solve the above-mentioned technical problems is:

On the one hand, a CAD file auxiliary processing method and system for the air-conditioning industry is provided, comprising the following steps:

Step 1. After automatically moving, zooming and copying the original map files corresponding to multiple components, calculate the world coordinate points of the original map files in the general map file according to the preset arrangement, and according to the world coordinates The coordinate point is to paste the original map of each map to the corresponding position in the general map file; and to match the original map of each map and add the corresponding standard frame, and write the corresponding map original image in the details column of each standard frame. original filename;

Step 2. According to the storage information and storage relationship of the original map file, obtain the list of parts assembly information of the original map of the map, and write the content of the list of parts assembly information into the details column of the corresponding standard frame;

Step 3. Determine the type and price of the corresponding parts in the original map of each map, determine the official part name corresponding to each part according to the type and price of the part, and replace the original file name in the details column of each standard frame with official part name;

Step 4. Extract information from the detail column of each standard frame according to the extracted identification information, and obtain a list of materials corresponding to all parts;

Step 5. Split each drawing in the general drawing file into a single drawing file, modify the file name of each drawing according to the corresponding official part name and save it to the designated directory. The drawings include the original map and its corresponding standard drawing. frame;

Step 6. Check the general drawing file and the single drawing file. The inspection contents include at least: whether the names of the official parts are duplicated or missing, whether there is any missing content in the details column of each standard drawing frame, whether each standard drawing frame overlaps, whether There are original file names that have not been replaced, whether the file names of the drawings are consistent with the corresponding official component names, and whether the drawing scale is the same as the drawing scale;

Step 7. Convert each single image file to PDF format.

Further, the step 1 specifically includes:

Step 101: Obtain the directory of the original map folder to be copied, traverse and extract the names, absolute file paths and file modification times of all DXF files in the original map folder and its subfolders, and extract the extracted content. Write CAD template to copy auxiliary table;

Step 102, obtaining the file copy storage directory, and storing the absolute path information corresponding to the file copy storage directory in the designated area of the CAD template copy auxiliary table;

Step 103 , according to the CAD template copying auxiliary table, perform map original image boundary recognition, map original image scaling, copying, pasting, standard frame filtering and matching, and original file name filling, and repeat the operation until all map original image files are copied Finish.

Further, the step 103 specifically includes:

Step 1031: Obtain a user-defined template identification list table, where the template identification list table includes the file internal information of each original map corresponding to the standard frame, and the file internal information of the standard frame at least includes: Name, frame size, parts list size, identification mark, size of the paste area of the original map, the offset of the X-axis and Y-axis of the standard frame, and the alignment of the X-axis and Y-axis of the standard frame;

Step 1032: Obtain file information of the original map of the map, where the information of the original map of the map at least includes: the original file name of the original map of the map, the size of the outer boundary of the image, and the world coordinate point at the lower left corner of the boundary;

Step 1033, obtaining user-defined external information of the standard picture frame file, the external information of the standard picture frame file at least includes the file name string and the storage absolute path of the standard picture frame;

Step 1034: Check the identification information, if no error prompt is issued after the verification is completed, proceed to step 1035; otherwise, exit the file copy operation; the verification identification information specifically includes: whether the original file name of the original map can match the Whether the identification mark and the standard frame corresponding to the identification mark are missing;

Step 1035: Obtain the internal information of the standard frame file corresponding to the original map image, which specifically includes: matching the identification mark according to the original file name string of the original map image, and determining the internal information of the standard frame file corresponding to the identification mark;

Step 1036: Determine the actual scale of the original map image that needs to be scaled according to the size of the image outer boundary and the paste position of the original map image;

Step 1037: Scale the original map image according to the actual scale that needs to be scaled for the original map image, calculate the distance to be translated according to the world coordinate point in the lower left corner of the border of the original map image, and move the original map image to the world coordinate point ( 0,0);

Step 1038: Copy the original map image based on its world coordinate point (0,0) as the base point;

Step 1039: Calculate the world coordinate point of the original map image in the master map file according to the preset arrangement, and the world coordinate point of the first map original image pasted into the master map file is (0,0) by default;

Step 10310: Paste the original map image to the corresponding position in the master map file according to the world coordinate point of the original map image in the master map file;

Step 10311, according to the offset of the X-axis and Y-axis of the standard frame and the alignment of the X-axis and Y-axis of the standard frame, calculate the world coordinate point of the standard frame corresponding to the original map of the map in the general map file;

Step 10312, search and copy the corresponding standard frame in the external information of the user-defined standard frame file according to the name of the standard frame obtained in step 1035;

Step 10313: Paste the standard drawing frame to the 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: Write the original file name of the original map of the map into the details column of the corresponding standard frame;

Step 10315, determine whether the copying of all the original maps of the map is completed, if so, go to step 10316, otherwise, repeat steps 1035 to 10314;

Step 10316, exit the file copy operation.

Further, the step 2 specifically includes:

Step 201, obtaining the text filling source directory, and obtaining the storage information and storage relationship of the original map file of the map;

Step 202, determine whether the storage relationship of the original map file is wrong, if so, end the operation, otherwise, go to step 203;

Step 203 , creating multiple parts assembly information lists according to the original map of the map;

Step 204, traversing and matching the corresponding drawings in the general drawing file under the file directory to be filled according to the parts assembly information list and the CAD template copy auxiliary table, and filling the details column content of the standard frame of the corresponding drawing, specifically including:

Step 2041, obtaining the content of the user-defined template identification list table, and writing it into an array;

Step 2042, acquiring the contents of the multiple parts assembly information lists newly created in step 203, and writing them into the dynamic array;

Step 2043: Obtain the frame information and name information of all drawings in the general drawing file, where the frame information at least includes: world coordinate information and boundary size of the lower left corner of the frame;

Step 2044 , according to matching the content of the parts assembly information list with the name information of the drawing, determine the parts assembly information that needs to be filled in the list of the current standard drawing frame;

Step 2045, according to the size of the detail column and the boundary size of the drawing frame, calculate the world coordinate point where the component assembly information is written into the general drawing file;

Step 2046: Write the component assembly information according to the world coordinate point in the general drawing file and the font size selected by the user according to the component assembly information;

Step 2047 , judging whether the writing work of all the component assembly information is completed, if so, exit the text writing work, otherwise, repeat steps 2044 to 2046 .

Further, the step 3 specifically includes:

Step 301: Obtain the folder directory of the original map of the map to be copied, obtain the file name string of the original map of the map according to the folder of the original map of the map, and write the CAD text to replace the auxiliary table;

Step 302: Input price calculation parameters in the parts price list table, and determine the price of the corresponding parts of each original map according to the price calculation parameters, the price calculation parameters at least include: corresponding parts size, material unit price and processing fee ;

Step 303: Determine the official component name corresponding to each component according to the type and price of the component;

Step 304, paste the corresponding official part name in the replacement area in the CAD text replacement auxiliary table;

Step 305, check the file name string of the original map and the name information of the official part name, if there is no error, go to step 307, otherwise go to step 306;

Step 306, after modifying the name information, go to step 305;

Step 307, obtaining the general drawing file directory, and writing all the component names and storage path information in the general drawing file directory into the CAD text replacement auxiliary table;

Step 308 , replace the original file names of all components with the corresponding official component names according to the content of the CAD text replacement auxiliary table;

Step 309 , judging whether the name replacement work of all components is completed, if so, exit the name replacement work, otherwise, repeat the execution of step 308 .

Further, the step 4 specifically includes:

Step 401, adding extraction identification information to the detail column of the standard picture frame;

Step 402: Select the list extraction source directory, and write the storage information of the general drawing files in the list extraction source directory into the CAD list extraction auxiliary table, and the list extracting source directory is the general drawing file storage directory after adding the extraction identification information. ;

Step 403 , extracting the list of materials corresponding to all the parts and components according to the list extraction source directory extraction list.

Further, the step 403 specifically includes:

Step 4031, obtaining a user-defined template identification list table, and writing the internal information of the file corresponding to the standard picture frame into an array;

Step 4032: Obtain the content of the CAD list extraction auxiliary table;

Step 4033: Obtain the standard frame information and name information of all drawings in the general drawing file, where the standard frame information at least includes: the world coordinate and boundary size of the lower left corner of the standard frame;

Step 4034: Obtain the extracted identification information corresponding to all standard picture frames in the general drawing file, and determine whether the extracted identification information is incorrect, if so, go to step 4035, otherwise, go to step 4036;

Step 4035, re-enter step 4034 after modifying the extracted identification information;

Step 4036: Perform information loop traversal and extraction on the detail column of each standard frame according to the extracted identification information, and obtain a list of materials corresponding to all parts;

Step 4037: Determine whether the information extraction work of all the detail columns is completed, if so, exit the information extraction work, otherwise, repeat step 4036.

Further, the step 5 specifically includes:

Step 501: Select the source directory for splitting drawings, obtain the file name and storage path information of the general drawing to be split according to the source directory for splitting drawings, and write them into the CAD drawing splitting auxiliary table;

Step 502: Select the split drawing storage directory, and write the path information in the split drawing storage directory into the CAD drawing splitting auxiliary table;

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

Step 5031, obtain the file internal information of the standard picture frame in the user-defined template identification list table, and write it into the array;

Step 5032: Obtain the file name and storage path information of the general drawing to be split in the CAD drawing splitting auxiliary table, and write them into the array;

Step 5033: Obtain all drawing information to be split according to the name of the general drawing file to be split, the drawing information at least includes: the drawing name, the world coordinate of the lower left corner of the drawing frame, and the boundary size of the drawing frame;

Step 5034: Determine whether the drawing information to be split is incorrect, if so, go to Step 5035; otherwise, go to Step 5036;

Step 5035, re-enter step 5034 after modifying the drawing name;

Step 5036: Calculate the boundary coordinates of the drawing to be split according to the drawing information;

Step 5037, create a corresponding DWG file according to the drawing name;

Step 5038: Copy and paste the drawing to be split into the corresponding DWG format file according to the boundary coordinates of the drawing to be split, and save the DWG format file to the split drawing storage directory;

Step 5039: Determine whether all the drawing splitting work is completed, if so, exit the drawing splitting work, otherwise, repeat steps 5036 to 5038.

Further, the step 7 specifically includes:

Step 701: Select the source directory of the file to be converted, write the path information of the source directory to be converted into the CAD-PDF conversion auxiliary table, and the source directory to be converted is the general drawing file storage directory or the single drawing file storage directory;

Step 702: Convert the drawings in DWG format to PDF format according to the source directory to be converted, which specifically includes:

Step 7021: Obtain the file internal information of the standard frame in the user-defined template identification list table, and write it into an array;

Step 7022, obtain the CAD-PDF conversion auxiliary table, and write the path information of the source directory to be converted into the array;

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

Step 7024: Determine whether the drawing information to be converted is incorrect, if so, go to Step 7035; otherwise, go to Step 7036;

Step 7025, re-enter step 7024 after modifying the name of the drawing to be converted;

Step 7026: Select the drawing area to be converted according to the world coordinate frame in the lower left corner of the standard drawing frame, and save the content of the frame selection as a PDF format document, the name of the PDF format document is the name of the corresponding drawing, and the storage location is the source directory of the file to be converted ;

Step 7027 , determine whether all the drawing conversion work is completed, if so, exit the drawing conversion work, otherwise, repeat steps 7026 to 7027 .

On the other hand, a CAD file auxiliary processing system for the air-conditioning industry is provided, including:

The CAD template file copying module is used to automatically move, zoom and copy the original map files corresponding to multiple components, and calculate the world coordinate points of the original map files in the general drawing file according to the preset arrangement. And paste each map original image to the corresponding position in the general map file according to the world coordinate point; and match and add the corresponding standard frame for each map original image, and write the corresponding standard frame in the detail column of each standard frame The original filename of the original map;

The CAD initial list generation and text filling module is used to obtain the component assembly information list of the original map file according to the storage information and storage relationship of the original map file, and write the content of the component assembly information list into the corresponding standard frame details column;

The CAD component price estimation and text replacement module is used to determine the type and price of the corresponding components in the original map of each map, and determine the official component name corresponding to each component according to the type and price of the component. Replace the original file name in the parts list with the official component name;

The CAD bill of materials extraction module is used to extract information from the details column of each standard frame according to the extracted identification information, and obtain the bill of materials corresponding to all parts;

The CAD drawing splitting module is used to split each drawing in the general drawing file into a single drawing file, modify the file name of each drawing according to the corresponding official component name and save it to the specified directory, the drawings include the original map and Its corresponding standard frame;

The CAD file content inspection module is used to inspect the general drawing file and the single drawing file. The inspection contents include at least: whether the official component names are duplicated or missing, whether the parts list of each standard drawing frame is missing content, each standard drawing frame Whether there is overlap, whether there is an unreplaced original file name, whether the file name of the drawing is consistent with the corresponding official component name, and whether the drawing scale is consistent with the drawing scale;

The CAD-PDF conversion module is used to convert each single drawing file into PDF format.

The beneficial effects of the present invention are: the CAD file auxiliary processing method and system used in the air-conditioning industry of the present invention can perform automatic batch copying, pasting, sorting, Searching, filtering, matching, scaling, marking, renaming, list extraction, drawing splitting, PDF conversion and drawing content error checking, etc., greatly reduce the workload of 2D component drawings, reduce the probability of errors, simplify operation methods, and improve operational efficiency.

Description of drawings

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 flowchart of a CAD file auxiliary processing method for the air-conditioning industry according to an embodiment of the present invention;

3 is a schematic flowchart of a method for implementing a CAD template file copy module according to an embodiment of the present invention;

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

5 is a schematic diagram of a map original image identification rule according to an embodiment of the present invention;

6 is a schematic flowchart of a method for implementing a CAD initial list generation and text filling module according to an embodiment of the present invention;

7 is a schematic flowchart of a text filling operation according to an embodiment of the present invention;

8 is a schematic flowchart of a method for implementing a CAD component price estimation and text replacement module according to an embodiment of the present invention;

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

10 is a schematic flowchart of a list extraction operation according to an embodiment of the present invention;

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

12 is a schematic flowchart of a drawing splitting operation according to an embodiment of the present invention;

13 is a schematic flowchart of a method for implementing a CAD-PDF conversion module according to an embodiment of the present invention;

14 is a schematic flowchart of a PDF conversion operation according to an embodiment of the present invention;

15 is a schematic flowchart of a method for implementing a CAD file content checking module according to an embodiment of the present invention;

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

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

FIG. 18 is a schematic diagram of a frame information identification principle 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 present invention.

Detailed ways

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

The CAD file auxiliary processing system for the air-conditioning industry provided by the present invention, as shown in FIG. 1, includes: a CAD template file copying module, a CAD initial list generation and text filling module, a CAD component price estimation and text replacement module, a CAD The material list extraction module, the CAD drawing splitting module, the CAD file content checking module and the CAD-PDF conversion module, based on the above system, the CAD file auxiliary processing method for the air-conditioning industry provided by the present invention, as shown in Figure 2, includes the following step:

Step 1. After the CAD template file copying module automatically moves, zooms and copies the original map files corresponding to multiple components, it calculates the world coordinate points of the original map files in the general map file according to the preset arrangement. And paste each map original image to the corresponding position in the general map file according to the world coordinate point; and match and add the corresponding standard frame for each map original image, and write the corresponding standard frame in the detail column of each standard frame The original filename of the original map;

Specifically, this step is mainly used to match the original two-dimensional component map in the file directory of the Windows system specified by the user to the corresponding frame, automatically zoom and paste it into the CAD general drawing file in the storage directory specified by the user, and press Arrange in a user-preset arrangement. When selecting the zoom type, the user can choose to keep the frame unchanged and zoom the original image of the map, or choose to keep the original image of the map unchanged and zoom the frame; the preset arrangement can be arranged according to the loading relationship, or can be selected Arranged by row and column, when arranging according to the loading relationship, the module will arrange the upper-level components to the leftmost, and the lower-level components of the component will be arranged in sequence on the right. The number of columns is not fixed. When you choose to arrange by row and column, the module will arrange the component drawings according to the formula. The number of columns is arranged; the user can also select the row height and column width to control the row spacing and column spacing of each drawing; Allows the user to select the drawing capacity of a single total drawing. The drawing capacity is the upper limit of the number of drawings stored in the total drawing. The value is greater than or equal to 1. As shown in Figure 3, the detailed steps of its implementation method are as follows:

Step 101: Obtain the original map folder directory to be copied, and the EXCELVBA program traverses and extracts the names, file absolute paths and file modification times of all DXF files under the obtained map original image folder and its subfolders, Write the extracted content into the CAD template to copy the auxiliary table; the reason for choosing the DXF file format here is that the DXF format file is both a CAD file, which is convenient for distinguishing it from the processed DWG format file in the later stage;

Step 102, obtain the file replication storage directory, and the EXCELVBA program stores the absolute path information corresponding to the file replication storage directory in the designated area of the CAD template replication auxiliary table;

Step 103, the EXCELVBA program performs the map original image boundary recognition, map original image scaling, copying, pasting, standard frame filtering and matching, and original file name filling according to the CAD template copy auxiliary table, and the cycle operation until all the original map images File copying is complete. As shown in Figure 4, its implementation method includes the following steps:

Step 1031: Obtain a user-defined template identification list table, where the template identification list table includes the file internal information of each original map corresponding to the standard frame, and the file internal information of the standard frame at least includes: Name, frame size, parts list size, identification mark, size of the paste area of the original map, the offset of the X-axis and Y-axis of the standard frame, and the alignment of the X-axis and Y-axis of the standard frame;

Specifically, the CADVBA program opens the template identification list table, and writes the user-defined frame template name and identification mark in the table into the array for temporary storage. The content of the template identification list includes the name of the frame template, the identification mark, the length of the map paste area, the unit mm, the width of the map paste area, the unit mm, the offset of the map frame in the X axis direction, the unit mm, the map frame Y Offset in the axis direction, alignment in the X-axis direction (proportion of distance from the left, input value: 0 to 1), alignment in the y-axis direction (proportion of distance from the left, input value: 0 to 1), standard frame length , the standard frame width, the border size of the frame details column, etc., all contents in the template identification list table can be defined by the user;

Step 1032, traversing through the CADVAB program to obtain the information of the original map file, the information of the original map file at least includes: the original file name of the original map of the map, the size of the outer border of the image (including the border length and the border width) and the The world coordinate point in the lower left corner of the boundary;

Step 1033: Obtain the user-defined external information of the standard drawing frame file through the CADVAB program, and the external information of the standard drawing frame file at least includes the file name string and the storage absolute path of the standard drawing frame;

Step 1034: Check the identification information, if no error prompt is issued after the verification is completed, proceed to step 1035; otherwise, exit the file copy operation; the verification identification information specifically includes: whether the original file name of the original map can match the Whether the identification mark and the standard frame corresponding to the identification mark are missing;

Specifically, when the original file name of the original map does not match the identification mark, the user will be prompted with an error message that the name of the original map cannot be identified. When the original file name of the original map can be matched with the identification mark, When the custom standard frame corresponding to the identification mark is missing, the user will be prompted for the missing information of the custom standard frame, and the original file names, unrecognized error messages, and missing information of the custom standard frame will be written in all the original map images that appear. Exit the file copy operation after entering the EXCEL table and output; if no error message is prompted when the traversal check is completed, proceed to the next step.

Among them, the identification mark is used to compare the original name string of the map with the identification mark when the CADVBA program traverses to the original map of the specified map. When the name string of the original map of the map contains the specified identification mark, the CADVBA program will The standard frame information corresponding to the identification mark will be obtained. As shown in Figure 5, for example, there are two original maps, one of which is named "ABCdef.dxf" and the other is named "DEFghi.dxf". The user defines it in the specified area of the template identification list table. There are three identification marks, which are "abc" corresponding to the frame file name "A.dwg", "efg" corresponding to the frame file name "E.dwg", "ce" corresponding to the frame file name "C.dwg", The user defines three standard drawing frame files A.dwg, E.dwg, C.dwg in the "CAD template source directory" folder. During identification, the CADVBA program will pair the original map "ABCdef.dxf" with the identification mark "abc" and the corresponding frame file name "A.dwg" and A.dwg under the "template source directory" folder, and the map The original picture "DEFghi.dxf" is paired with the identification mark "efg" and the corresponding picture frame file name "E.dwg" and E.dwg under the "template source directory" folder. Therefore, when customizing the identification mark, it is required that the identification mark defined by the user cannot be repeated. If there is an inclusion relationship, the long identification mark should be placed before the short identification mark. For example, identification mark 1 is "ABCDE", identification mark 2 is "ABC", Then in the template identification list, the identification mark 1 should be ranked before the identification mark 2. When performing 3D modeling, the user is required to name the parts, and the part names must contain custom identification information. When mapping, the original file name of the map will automatically carry the identification information.

Step 1035: Obtain the internal information of the standard frame file corresponding to the original image of the map, which specifically includes: the CADVBA program matches the identification mark according to the original file name string of the original map of the map, and determines the internal information of the standard frame file corresponding to the identification mark (Including the name of the corresponding standard frame, the length of the map paste area, the unit mm, the width of the map paste area, the unit mm, the offset of the map frame in the X-axis direction, the unit of mm, the offset of the map frame in the Y-axis direction , X-axis alignment (proportion of distance from the left, input value: 0 to 1), y-axis alignment (proportion of distance from the left, input value: 0 to 1), standard frame length, standard frame width )Wait;

Step 1036: Determine the actual scale of the original map image that needs to be scaled according to the size of the image outer boundary and the paste position of the original map image;

Step 1037: Scale the original map image according to the actual scale that needs to be scaled for the original map image, calculate the distance to be translated according to the world coordinate point in the lower left corner of the border of the original map image, and move the original map image to the world coordinate point ( 0,0);

Step 1038: Copy the original map image based on its world coordinate point (0,0) as the base point;

Step 1039: Calculate the world coordinate point of the original map image in the master map file according to the preset arrangement, and the world coordinate point of the first map original image pasted into the master map file is (0,0) by default;

Step 10310: Paste the original map image to the corresponding position in the master map file according to the world coordinate point of the original map image in the master map file;

Step 10311, according to the offset of the X-axis and Y-axis of the standard frame and the alignment of the X-axis and Y-axis of the standard frame, calculate the world coordinate point of the standard frame corresponding to the original map of the map in the general map file;

When the user chooses to arrange in rows and columns, when calculating the world coordinates (x, y) of the paste point, the following rules are satisfied: when n<=n1, and n<n2, x=x0+a*n, y=y0, When n<=n1 and n=n2, x=x0, y=y0+b*m, when n<=n1 and n>n2, x=x0+a*(n-n1*m), y= y0+b*m. When n>n1 and n=n1*f+1, x=x0, y=y0. Where (x, y) is the world coordinate of the current paste point when the user chooses to arrange in rows and columns, n is the current cumulative number of original maps in the map, n1 is the number of drawings in a single total map file, n2 is the number of columns selected by the user, x0 =0, y0=0, a is the column width selected by the user, b is the row height selected by the user, m is the current cumulative map original image number n divided by the column number n2 rounded up, f is the current cumulative map original image number Divide n by the number of drawings of a single total drawing file n1 and round up.

When the user chooses to arrange by loading relationship, when calculating the world coordinates (x, y) of the paste point, the following rules are satisfied: when n<=n1, and n<=h, x=x1+a, y=y1, When n<=n1 and n=h+1, x=x1-h*a, y=y1+b, when n<=n1 and n>h+1, x=x1+a, y=y1. When n>n1 and n=n1*f+1, x=x0, y=y0. Where (x, y) is the world coordinate of the current paste point when the user chooses to arrange in rows and columns, n is the current cumulative number of original maps in the map, n1 is the number of drawings in a single general map file, and h is the assembly relationship corresponding to the current component drawings number of subordinate drawings. x1, y1 are the world coordinates of the previous drawing, 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 current cumulative number of original maps divided by n Round up to the number n1 of drawings in a single general drawing file.

Step 10312, search and copy the corresponding standard frame in the external information of the user-defined standard frame file according to the name of the standard frame obtained in step 1035;

Step 10313: Paste the standard drawing frame to the 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: Write the original file name of the original map of the map into the details column of the corresponding standard frame;

Step 10315, determine whether the copying of all the original maps of the map is completed, if so, go to step 10316, otherwise, repeat steps 1035 to 10314;

Step 10316, exit the file copy operation.

Step 2. The CAD initial list generation and text filling module obtains the parts assembly information list of the map original image according to the storage information and storage relationship of the original map file, and writes the content of the parts assembly information list into the corresponding standard frame details column;

This step is used to select the original two-dimensional component map in the file directory of the Windows system by the user, traverse and extract the file name string of the original map of each map according to its storage relationship through the EXCELVBA program, and generate an EXCEL form for the component assembly information list . The user can choose whether to modify the contents of the EXCEL table. After the modification of the component assembly information list is completed, the CADVBA program will open all the drawings in the list directory to be filled specified by the user, and automatically match the corresponding drawings according to the contents of the list and specify them in the drawing frame details column. Fill in the original names and quantities of components in the initial parts list in the area. Before filling in the text, the user can set the font size of the text filling in different areas to suit the size of the parts list in the parts list. As shown in Figure 6, the detailed steps of the implementation method are as follows:

Step 201, obtaining the text filling source directory, and obtaining the storage information and storage relationship of the original map file of the map;

Among them, the text filling source directory refers to the list information source that the user needs to fill in the parts list. The component assembly information list is mainly constructed through the storage relationship of the original map in the windos system. The principles and rules are as follows: The original map of the component drawing needs to be stored in the same name as the original map without the suffix. Under the folder, the original map of its subordinate components is stored in this folder, and the original map of the subordinate components must be stored in a folder with the same name as the original map without the suffix, and go down level by level. For example, there are eight original map file drawings, they are A.dxf, B.dxf, C.dxf, D.dxf, E.dxf, F.dxf, G.dxf, H.dxf, of which A.dxf , B.dxf, C.dxf, D.dxf are component drawings, E.dxf, F.dxf, G.dxf, H.dxf are component drawings, A.dxf its subordinate parts are C.dxf, and the subordinate parts are E .dxf, B.dxf, its subordinate parts are D.dxf, and the subordinate parts are F.dxf, the subordinate parts of C.dxf are G.dxf, and the subordinate parts of D.dxf are H.dxf. Folders named A, B, C, and D need to be created when the component map is operated, and the original map A.dxf, E.dxf and folder C are stored in the folder A, and the folder B is in the folder B. Store the original maps B.dxf, F.dxf and folder D, store C.dxf and G.dxf in folder C, and store D.dxf and H.dxf in folder D. Because the windos system does not allow users to store files of the same type with the same name in the same folder, it can indirectly prevent users from repeatedly saving images. When selecting the text to fill the source directory in step S201, the EXECLVBA program will automatically obtain the storage relationship of the original map of the map under the directory specified by the user;

Step 202, determine whether the storage relationship of the original map file is wrong, if so, end the operation, otherwise, go to step 203;

Specifically, the EXCELVBA program will make a right or wrong judgment on the storage relationship in the process of generating the component assembly information list. When the component drawing with the same name as the folder is missing from the component folder, a folder or component drawing with the same name appears. Or if different original maps are stored under the same folder name, the EXCELVBA program will prompt that the storage relationship of the original maps is incorrect, and output the error information in the form of EXCEL form, and end the operation. If there is no problem, it will be carried out. next step;

Step 203: Create multiple parts assembly information lists according to the original map; the user can choose whether to modify the information in the table, such as the number of parts assembly, which defaults to 1 if it is not modified, whether to add some conventional material information, etc., the modification is completed After closing, save the component assembly information list.

Step 204 , traversing and matching the corresponding drawings in the general drawing file under the to-be-filled file directory according to the component assembly information list and the CAD template copy auxiliary table, and filling the details column content of the standard frame of the corresponding drawing. As shown in Figure 7, its implementation method includes the following steps:

Step 2041: Obtain the content of the user-defined template identification list table, including information such as the standard frame border size, the border size of each detail column, and write it into an array;

Step 2042, acquiring the contents of the multiple parts assembly information lists newly created in step 203, and writing them into the dynamic array;

Step 2043: Obtain the frame information and name information of all drawings in the general drawing file, where the frame information at least includes: world coordinate information and boundary size of the lower left corner of the frame;

Step 2044 , according to matching the content of the parts assembly information list with the name information of the drawing, determine the parts assembly information that needs to be filled in the list of the current standard drawing frame;

Step 2045, according to the size of the detail column and the boundary size of the drawing frame, calculate the world coordinate point where the component assembly information is written into the general drawing file;

Step 2046: Write the component assembly information according to the world coordinate point in the general drawing file and the font size selected by the user according to the component assembly information;

Step 2047 , judging whether the writing work of all the component assembly information is completed, if so, exit the text writing work, otherwise, repeat steps 2044 to 2046 .

Step 3. The CAD component price estimation and text replacement module determines the type and price of the corresponding components in the original map of each map, determines the official component name corresponding to each component according to the type and price of the component, and frames each standard diagram. Replace the original file name in the parts list with the official component name;

This step is mainly divided into two parts, one is to estimate the price of the parts, and the other is to replace the original names of the parts drawings. Estimated price of parts is obtained by obtaining the original map file string in the specified directory to form a list, and the price is estimated according to the user-defined price calculation rules. Usually, the price calculation rules include the size of the parts, the unit price of the material of the parts, the density of the parts, Parts processing fees, etc., users can define this part of the rules themselves. After calculating the estimated price of the parts, they can apply for the official name according to the price and type of the parts. It is necessary to replace the original names of component drawings because firstly, in the 3D modeling stage, in order to distinguish different components and name the drawings with the fastest efficiency, designers often name the components in a simple way. Consists of letters and numbers or pure numbers. These names are long, and the type of components cannot be simply identified from their names. In the final modeling stage, the dimensions of the components are unknown before they are named, and the price cannot be calculated. When the official component name is applied The estimated price of the parts needs to be calculated in advance, so the official application name cannot be used for modeling, so the original name needs to be replaced with the official name during the drawing process. As shown in Figure 8, it includes the following steps:

Step 301: Obtain the folder directory of the original map of the map to be copied, obtain the file name string of the original map of the map according to the folder of the original map of the map, and write the CAD text to replace the auxiliary table;

Step 302: Input price calculation parameters in the parts price list table, and calculate the price of the corresponding parts of each original map according to the price calculation parameters and the pre-defined calculation formula, the price calculation parameters at least include: the size of the corresponding parts , material unit price and processing fee;

Step 303: Determine the official component name corresponding to each component according to the type and price of the component;

Step 304, paste the corresponding official part name in the replacement area in the CAD text replacement auxiliary table;

Step 305, check the file name string of the original map and the name information of the official part name, if there is no error, go to step 307, otherwise go to step 306;

Among them, the inspection items include whether the original name is duplicated or missing, whether the official name is duplicated or missing, whether the original name to be replaced is consistent with the corresponding category of the replaced official name, the original name to be replaced corresponds to the estimated price and the replaced official name. Whether the corresponding price is the same. Through the above-mentioned information checking, the user can effectively avoid wrong input. If the table replacement information is incorrect, the user will be prompted to modify the CAD text replacement auxiliary table and output the modification information. If the table replacement information is correct, the next step will be performed.

Step 306, after modifying the name information, go to step 305;

Step 307, obtaining the general drawing file directory, and writing all the component names and storage path information in the general drawing file directory into the CAD text replacement auxiliary table;

Step 308 , replace the original file names of all components with the corresponding official component names according to the content of the CAD text replacement auxiliary table;

Step 309 , judging whether the name replacement work of all components is completed, if so, exit the name replacement work, otherwise, repeat the execution of step 308 .

Step 4. The CAD material list extraction module extracts information from the detail column of each standard frame according to the extracted identification information, and obtains the material list corresponding to all parts;

This step is used to identify all the drawing frames of the component drawings under the Windows system file directory selected by the user through the CADVBA program, and extract and integrate the parts list information into the EXCEL table to form a component material list. As shown in Figure 9, the detailed steps of its implementation method are as follows:

Step 401 , adding extraction identification information to the detail column of the standard drawing frame; wherein, the extraction identification information can be customized by the user, and the requirement cannot be the same as the official name of the component, and the default is "#". The reason for adding "#" is that the content in different parts lists is somewhat different, and the extraction identification information is added to mark the boundaries of different drawing parts lists.

Step 402: Select the list extraction source directory, and write the storage information of the general drawing files in the list extraction source directory into the CAD list extraction auxiliary table, and the list extracting source directory is the general drawing file storage directory after adding the extraction identification information. ;

Step 403 , extracting the list of materials corresponding to all the parts and components according to the list extraction source directory extraction list. As shown in Figure 10, it mainly includes the following steps:

Step 4031, obtaining a user-defined template identification list table, and writing the internal information of the file corresponding to the standard picture frame into an array;

Step 4032: Obtain the content of the CAD list extraction auxiliary table;

Step 4033: Obtain the standard frame information and name information of all drawings in the general drawing file, where the standard frame information at least includes: the world coordinate and boundary size of the lower left corner of the standard frame;

Step 4034: Obtain the extracted identification information corresponding to all standard picture frames in the general drawing file, and determine whether the extracted identification information is incorrect, if so, go to step 4035, otherwise, go to step 4036;

Among them, judging the extracted identification information mainly includes judging whether the extracted identification information is missing, duplicated, etc. If the extracted identification information is wrong, the user will be prompted to modify the extracted identification information, and if it is correct, the next operation will be performed;

Step 4035, re-enter step 4034 after modifying the extracted identification information;

Step 4036: Perform information loop traversal and extraction on the detail column of each standard frame according to the extracted identification information, and obtain a list of materials corresponding to all parts;

Step 4037: Determine whether the information extraction work of all the detail columns is completed, if so, exit the information extraction work, otherwise, repeat step 4036.

Step 5. The CAD drawing splitting module splits each drawing in the general drawing file into a single drawing file, and modifies the file name of each drawing according to the corresponding official part name and saves it to the designated directory. The drawings include the original map and Its corresponding standard frame;

This step is used to split a plurality of component drawings stored in the general drawing under the Windows system file directory specified by the user into single drawing forms corresponding to their drawing names. As shown in Figure 11, the detailed steps of the implementation method are as follows:

Step 501: Select the source directory for splitting drawings, obtain the file name and storage path information of the general drawing to be split according to the source directory for splitting drawings, and write them into the CAD drawing splitting auxiliary table;

Step 502: Select the split drawing storage directory, and write the path information in the split drawing storage directory into the CAD drawing splitting auxiliary table;

Step 503, performing drawing splitting operation according to the CAD drawing splitting auxiliary table, as shown in Figure 12, specifically including:

Step 5031, obtain the file internal information of the standard picture frame in the user-defined template identification list table, and write it into the array;

Step 5032: Obtain the file name and storage path information of the general drawing to be split in the CAD drawing splitting auxiliary table, and write them into the array;

Step 5033: Obtain all drawing information to be split according to the name of the general drawing file to be split, the drawing information at least includes: the drawing name, the world coordinate of the lower left corner of the drawing frame, and the boundary size of the drawing frame;

Step 5034: Determine whether the drawing information to be split is incorrect, if so, go to Step 5035; otherwise, go to Step 5036;

Specifically, the CADVBA program checks whether the information of the drawings to be split is incorrect, and the checking contents include whether the drawing names are repeated or missing, because the split single drawing needs to be named after its corresponding drawing, and the duplicate or missing drawing names will cause problems. An error occurred during storage. If the name of the drawing is duplicated or missing, the user will be prompted to modify the name of the drawing to be split. If there is no error message, proceed to the next step;

Step 5035, re-enter step 5034 after modifying the drawing name;

Step 5036: Calculate the boundary coordinates of the drawing to be split according to the drawing information;

Step 5037, create a corresponding DWG file according to the drawing name;

Step 5038: Copy and paste the drawing to be split into the corresponding DWG format file according to the boundary coordinates of the drawing to be split, and save the DWG format file to the split drawing storage directory;

Step 5039: Determine whether all the drawing splitting work is completed, if so, exit the drawing splitting work, otherwise, repeat steps 5036 to 5038.

Step 6. The CAD file content checking module checks the general drawing file and the single drawing file, and the checking contents include at least: whether the names of the official parts are duplicated or missing, whether the details of each standard drawing frame have missing content, and whether each standard drawing frame is missing. Whether there is overlap, whether there is an unreplaced original file name, whether the file name of the drawing is consistent with the corresponding official component name, and whether the drawing scale is consistent with the drawing scale;

This step is used to check the drawing content information in the file directory of the Windows system specified by the user. The checking contents include whether the drawing name is repeated or missing, whether the content of the drawing list is missing, whether the list extraction identifier is repeated or missing, and whether the drawing frame is missing or not. Whether there is overlap in the area, whether there is original name identification information that has not been replaced in the drawing, and for the content of a single drawing, the file name of the single drawing and the corresponding drawing name are also checked. As shown in Figure 13, the detailed steps of the implementation method are as follows:

Step S601, select the file check source directory, the file check source directory refers to the file storage directory that the user needs to check, which can be any DWG format drawing storage directory processed in steps S2 to S6, after the selection, the EXCELVBA program will check the file check source directory. The file name and path information in the CAD file are written into the specified area of the CAD file check auxiliary table;

In step S602, the file inspection operation is performed, and the file inspection source directory is selected according to step S601 to perform the file content inspection operation. As shown in FIG. 14, the detailed steps of the implementation method are as follows:

Step S6021, obtain the corresponding standard frame content in the user-defined template identification list table through the CADVBA program, including information such as the standard frame boundary size, the boundary size of each detail column, and write the information into the array;

Step S6022, obtain the content of the template identification list table, obtain all file storage information in step S601 through CADVBA, and write the information into the array;

Step S6023, traverse the CADVBA program to obtain the names of all drawings in the file in step S6022, the world coordinate information of the lower left corner of all drawing frames, the boundary size information of all drawing frames, the content information of the parts list, the drawing annotation scale information, and the extracted identification content information, etc. ;

Step S6024, according to the information obtained in step S6023, the CADVBA program compares the information, and outputs the comparison information to the EXCEL table, and ends the inspection operation.

Step 7: The CAD-PDF conversion module converts each single drawing file into PDF format. As shown in Figure 15, the following steps are included:

Step 701: Select the source directory of the file to be converted, write the path information of the source directory to be converted into the CAD-PDF conversion auxiliary table, and the source directory to be converted is the general drawing file storage directory or the single drawing file storage directory;

Step 702: Convert the drawings in DWG format into PDF format according to the source directory to be converted, as shown in Figure 16, which specifically includes:

Step 7021: Obtain the file internal information of the standard frame in the user-defined template identification list table, and write it into an array;

Step 7022, obtain the CAD-PDF conversion auxiliary table, and write the path information of the source directory to be converted into the array;

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

Step 7024: Determine whether the drawing information to be converted is incorrect, if so, go to Step 7035; otherwise, go to Step 7036;

Among them, the check content includes whether the drawing name is repeated or missing, because during the PDF conversion process, the single drawing after PDF conversion needs to be named after the corresponding drawing. When the name of the drawing is duplicated or missing, the user will be prompted to modify the name of the drawing to be converted. If there is no error message, proceed to the next step.

Step 7025, re-enter step 7024 after modifying the name of the drawing to be converted;

Step 7026: Select the drawing area to be converted according to the world coordinate frame in the lower left corner of the standard drawing frame, and save the content of the frame selection as a PDF format document, the name of the PDF format document is the name of the corresponding drawing, and the storage location is the source directory of the file to be converted ;

Step 7027 , determine whether all the drawing conversion work is completed, if so, exit the drawing conversion work, otherwise, repeat steps 7026 to 7027 .

Parts drawings often used in the air-conditioning industry are mainly composed of two parts, as shown in Figure 17, including a two-dimensional drawing of parts and a drawing frame. In terms of drawing name, drawing quantity, loading relationship filling, etc., the outer boundary of the standard drawing frame is a rectangular primitive, and the perimeter and area of the rectangular primitive can be obtained through the EXCELVBA program. The user fills in the name of the standard frame, the length of the map pasting area, the unit mm, the width of the map pasting area, the unit mm, and the offset of the map frame in the X-axis direction in the specified area in the template identification list form, the unit is mm, the guide Figure frame Y-axis direction offset, X-axis direction alignment (proportion of distance from the left, input value: 0 to 1), y-axis alignment (proportion of distance from the left, input value: 0 to 1), The standard frame length (the length of the rectangular primitive), the standard frame width (the width of the rectangular primitive), and the offset distance of each boundary of the parts list relative to the lower left corner of the standard frame in the x and y-axis directions can be used to complete different types of standards. The frame definition works.

In this embodiment, the principles and steps for identifying the frame and extracting text information in the frame are shown in Figure 18, and the detailed method steps are as follows:

Step S801, acquiring the content of the template identification list table. Obtain the information about frame identification in the "template identification list.xls" table through the CADVBA program, including the standard frame length (the length of the rectangular primitive), the standard frame width (the width of the rectangular primitive), and the relative borders of the parts list. Parameters such as offset distance in the x and y axis directions in the lower left corner of the standard frame;

Step S802 , acquiring the rectangular primitive information of the drawing. Obtaining drawing primitive information through CADVBA program includes the perimeter of the rectangular primitive, the area of the rectangular primitive, and the world coordinate point of the rectangular primitive;

Step S803: Determine whether the rectangular primitive is a frame. The CADVBA program performs comparative analysis according to the user-defined picture frame information in step S801 and all the rectangular primitive information obtained in step S802, and the rectangular primitives that satisfy the picture frame identification rules can be regarded as a picture frame. The frame recognition rules are as follows: when m/c=(a*b)/(2*(a+b)), the rectangular primitive is the frame, where m is the area of the rectangular primitive, and c is the perimeter of the rectangular primitive , a is the length of the user-defined frame, and b is the width of the user-defined frame. For example, the user defines two standard frames in the "Template Recognition List.xls" table, frame 1 has a length of a1 and a width of b1, frame 2 has a length of a2 and a width of b2, and there are two rectangles in the CAD drawing file. Primitive, the area of the rectangular primitive 1 is m1=a1*b1, the perimeter is 2*(a1+b1), the area of the rectangular primitive 2 is m2=a2*b3, the perimeter is 2*(a2+b3), where b2<>b3, at this time, the rectangular primitive 1 can be judged as a picture frame, and the rectangular primitive 2 cannot be judged as a picture frame;

Step S804, extracting text information in the frame. Through step S803, the world coordinate point of the lower left corner of the frame that complies with the rules can be obtained, and the frame can be calculated according to the parameters such as the offset distance of each boundary of the detail column of the frame relative to the lower left corner of the standard frame in the x and y-axis directions obtained in step S801. The world coordinate points of each boundary of the parts list, all the text information obtained by the CADVBA program, when the text coordinates are within the range of the world coordinate points of each boundary of the parts list of the drawing frame, the text is the text information in the corresponding area of the corresponding drawing frame.

The advantages of using the CAD file auxiliary processing method and system in the air-conditioning industry are as follows:

1. It can automatically copy and paste the original map of the map in batches, automatically match the corresponding frame in batches, automatically scale the original map of the map in batches according to the size of the frame, automatically fill in the zoom ratio, the original name of the drawing, and automatically check whether the copied item is not. there is repetition;

2. It can automatically check whether there is a problem with the storage relationship of the original map of the user's map, automatically generate an initial fill list according to the storage relationship, and automatically fill in the content of the drawing frame details column according to the initial fill list matching the corresponding drawings;

3. The price can be automatically calculated according to the user's component size and material input. When the original name of the component drawing is replaced, it can automatically check whether the original name is repeated or missing, whether the official name is repeated or missing, whether the official name type is correct, the estimated price and the application price. Whether it is consistent or not, it can effectively avoid the user's wrong input and the replacement error caused by it;

4. It can automatically search for the information in the detail column of drawings in batches, and form a list of parts and materials after summarizing. The content of the material list is exactly the same as the content of the detail column of the drawings of each component, so as to avoid the user manually drafting the list according to the detail column of the drawings and manually filling in the errors that occur;

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

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

7. It can check multiple content information of drawings, avoid a lot of manual checking process, and check the efficiency is very high. This function can be checked before any other functions are used;

8. As shown in Figure 19, the modules executing each step have a visual window, which can carry out human-computer interaction, and the operation of each process is simple and clear;

9. During the operation, each module has the function of error and error correction, which can avoid a large number of manual input errors. At the same time, each module is automatically processed by the VBA program, which is highly efficient and has a very low error rate;

10. Users can customize the frame type, frame size, identification mark, drawing paste area, drawing alignment, etc. in the template identification list table according to the types of parts they need to use.

Claims (10)

1. the CAD file auxiliary processing method for air-conditioning industry, is characterized in that, comprises the following steps: Step 1. After automatically moving, zooming and copying the original map files corresponding to multiple components, calculate the world coordinate points of the original map files in the general map file according to the preset arrangement, and according to the world coordinates The coordinate point is to paste the original map of each map to the corresponding position in the general map file; and to match the original map of each map and add the corresponding standard frame, and write the corresponding map original image in the details column of each standard frame. original filename; Step 2. According to the storage information and storage relationship of the original map file, obtain the list of parts assembly information of the original map of the map, and write the content of the list of parts assembly information into the details column of the corresponding standard frame; Step 3. Determine the type and price of the corresponding parts in the original map of each map, determine the official part name corresponding to each part according to the type and price of the part, and replace the original file name in the details column of each standard frame with official part name; Step 4. Extract information from the detail column of each standard frame according to the extracted identification information, and obtain a list of materials corresponding to all parts; Step 5. Split each drawing in the general drawing file into a single drawing file, modify the file name of each drawing according to the corresponding official part name and save it to the designated directory. The drawings include the original map and its corresponding standard drawing. frame; Step 6. Check the general drawing file and the single drawing file. The inspection contents include at least: whether the names of the official parts are duplicated or missing, whether there is any missing content in the details column of each standard drawing frame, whether each standard drawing frame overlaps, whether There are original file names that have not been replaced, whether the file names of the drawings are consistent with the corresponding official component names, and whether the drawing scale is the same as the drawing scale; Step 7. Convert each single image file to PDF format. 2. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 1, wherein the step 1 specifically comprises: Step 101: Obtain the directory of the original map folder to be copied, traverse and extract the names, absolute file paths and file modification times of all DXF files in the original map folder and its subfolders, and extract the extracted content. Write CAD template copy auxiliary table; Step 102, obtaining the file copy storage directory, and storing the absolute path information corresponding to the file copy storage directory in the designated area of the CAD template copy auxiliary table; Step 103 , according to the CAD template copying auxiliary table, perform map original image boundary recognition, map original image scaling, copying, pasting, standard frame filtering and matching, and original file name filling, and repeat the operation until all map original image files are copied Finish. 3. The CAD file auxiliary processing method for the air-conditioning industry according to claim 1, wherein the step 103 specifically comprises: Step 1031: Obtain a user-defined template identification list table, where the template identification list table includes the file internal information of each original map corresponding to the standard frame, and the file internal information of the standard frame at least includes: Name, frame size, parts list size, identification mark, size of the paste area of the original map, the offset of the X-axis and Y-axis of the standard frame, and the alignment of the X-axis and Y-axis of the standard frame; Step 1032: Obtain file information of the original map of the map, where the information of the original map of the map at least includes: the original file name of the original map of the map, the size of the outer boundary of the image, and the world coordinate point at the lower left corner of the boundary; Step 1033, obtaining user-defined external information of the standard picture frame file, the external information of the standard picture frame file at least includes the file name string and the storage absolute path of the standard picture frame; Step 1034: Check the identification information, if no error prompt is issued after the verification is completed, proceed to step 1035; otherwise, exit the file copy operation; the verification identification information specifically includes: whether the original file name of the original map can match the Whether the identification mark and the standard frame corresponding to the identification mark are missing; Step 1035: Obtain the internal information of the standard frame file corresponding to the original map image, which specifically includes: matching the identification mark according to the original file name string of the original map image, and determining the internal information of the standard frame file corresponding to the identification mark; Step 1036: Determine the actual scale of the original map image that needs to be scaled according to the size of the image outer boundary and the paste position of the original map image; Step 1037: Scale the original map according to the actual ratio of the original map to be scaled, calculate the distance to be translated according to the world coordinate point in the lower left corner of the border of the original map of the map, and move the original map to the world coordinate point ( 0,0); Step 1038: Copy the original map image based on its world coordinate point (0,0) as the base point; Step 1039: Calculate the world coordinate point of the original map image in the master map file according to the preset arrangement, and the world coordinate point of the first map original image pasted into the master map file is (0,0) by default; Step 10310: Paste the original map image to the corresponding position in the master map file according to the world coordinate point of the original map image in the master map file; Step 10311, according to the offset of the X-axis and Y-axis of the standard frame and the alignment of the X-axis and Y-axis of the standard frame, calculate the world coordinate point of the standard frame corresponding to the original map of the map in the general map file; Step 10312, search and copy the corresponding standard frame in the external information of the user-defined standard frame file according to the name of the standard frame obtained in step 1035; Step 10313: Paste the standard drawing frame to the 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: Write the original file name of the original map of the map into the details column of the corresponding standard frame; Step 10315, determine whether the copying of all the original maps of the map is completed, if so, go to step 10316, otherwise, repeat steps 1035 to 10314; Step 10316, exit the file copy operation. 4. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 3, wherein the step 2 specifically comprises: Step 201, obtaining the text filling source directory, and obtaining the storage information and storage relationship of the original map file of the map; Step 202, determine whether the storage relationship of the original map file is wrong, if so, end the operation, otherwise, go to step 203; Step 203 , creating multiple parts assembly information lists according to the original map of the map; Step 204, traversing and matching the corresponding drawings in the general drawing file under the file directory to be filled according to the component assembly information list and the CAD template copy auxiliary table, and filling the details column content of the standard frame of the corresponding drawing, specifically including: Step 2041, obtaining the content of the user-defined template identification list table, and writing it into an array; Step 2042, acquiring the contents of the multiple parts assembly information lists newly created in step 203, and writing them into the dynamic array; Step 2043: Obtain the frame information and name information of all drawings in the general drawing file, where the frame information at least includes: world coordinate information and boundary size of the lower left corner of the frame; Step 2044 , according to matching the content of the parts assembly information list with the name information of the drawing, determine the parts assembly information that needs to be filled in the list of the current standard drawing frame; Step 2045, according to the size of the detail column and the boundary size of the drawing frame, calculate the world coordinate point where the component assembly information is written into the general drawing file; Step 2046: Write the component assembly information according to the world coordinate point in the general drawing file and the font size selected by the user according to the component assembly information; Step 2047 , judging whether the writing work of all the component assembly information is completed, if so, exit the text writing work, otherwise, repeat steps 2044 to 2046 . 5. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 1, wherein the step 3 specifically comprises: Step 301: Obtain the folder directory of the original map of the map to be copied, obtain the file name string of the original map of the map according to the folder of the original map of the map, and write the CAD text to replace the auxiliary table; Step 302: Input price calculation parameters in the parts price list table, and determine the price of the corresponding parts of each original map according to the price calculation parameters, the price calculation parameters at least include: corresponding parts size, material unit price and processing fee ; Step 303: Determine the official component name corresponding to each component according to the type and price of the component; Step 304, paste the corresponding official part name in the replacement area in the CAD text replacement auxiliary table; Step 305, check the file name string of the original map and the name information of the official part name, if there is no error, go to step 307, otherwise go to step 306; Step 306, after modifying the name information, go to step 305; Step 307, obtaining the general drawing file directory, and writing all the component names and storage path information in the general drawing file directory into the CAD text replacement auxiliary table; Step 308 , replace the original file names of all components with the corresponding official component names according to the content of the CAD text replacement auxiliary table; Step 309 , judging whether the name replacement work of all components is completed, if so, exit the name replacement work, otherwise, repeat the execution of step 308 . 6. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 1, wherein the step 4 specifically comprises: Step 401, adding extraction identification information to the detail column of the standard picture frame; Step 402: Select the list extraction source directory, and write the storage information of the general drawing files in the list extraction source directory into the CAD list extraction auxiliary table, and the list extraction source directory is the general drawing file storage directory after adding the extracted identification information. ; Step 403 , extracting the list of materials corresponding to all the parts and components according to the list extraction source directory extraction list. 7. The CAD file auxiliary processing method for the air-conditioning industry according to claim 6, wherein the step 403 specifically comprises: Step 4031, obtaining a user-defined template identification list table, and writing the internal information of the file corresponding to the standard picture frame into an array; Step 4032: Obtain the content of the CAD list extraction auxiliary table; Step 4033: Obtain the standard frame information and name information of all drawings in the general drawing file, where the standard frame information at least includes: the world coordinate and boundary size of the lower left corner of the standard frame; Step 4034: Obtain the extracted identification information corresponding to all standard picture frames in the general drawing file, and determine whether the extracted identification information is incorrect, if so, go to step 4035, otherwise, go to step 4036; Step 4035, re-enter step 4034 after modifying the extracted identification information; Step 4036: Perform information loop traversal and extraction on the detail column of each standard frame according to the extracted identification information, and obtain a list of materials corresponding to all parts; Step 4037: Determine whether the information extraction work of all the detail columns is completed, if so, exit the information extraction work, otherwise, repeat step 4036. 8. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 1, wherein the step 5 specifically comprises: Step 501: Select the source directory for splitting drawings, obtain the file name and storage path information of the general drawing to be split according to the source directory for splitting drawings, and write them into the CAD drawing splitting auxiliary table; Step 502: Select the split drawing storage directory, and write the path information in the split drawing storage directory into the CAD drawing splitting auxiliary table; Step 503, performing drawing splitting operation according to the CAD drawing splitting auxiliary table, specifically including: Step 5031, obtain the file internal information of the standard picture frame in the user-defined template identification list table, and write it into the array; Step 5032: Obtain the file name and storage path information of the general drawing to be split in the CAD drawing splitting auxiliary table, and write them into the array; Step 5033: Obtain all drawing information to be split according to the name of the general drawing file to be split, the drawing information at least includes: the drawing name, the world coordinate of the lower left corner of the drawing frame, and the boundary size of the drawing frame; Step 5034: Determine whether the drawing information to be split is incorrect, if so, go to Step 5035; otherwise, go to Step 5036; Step 5035, re-enter step 5034 after modifying the drawing name; Step 5036: Calculate the boundary coordinates of the drawing to be split according to the drawing information; Step 5037, create a corresponding DWG file according to the drawing name; Step 5038: Copy and paste the drawing to be split into the corresponding DWG format file according to the boundary coordinates of the drawing to be split, and save the DWG format file to the split drawing storage directory; Step 5039: Determine whether all the drawing splitting work is completed, if so, exit the drawing splitting work, otherwise, repeat steps 5036 to 5038. 9. The CAD file auxiliary processing method for the air-conditioning industry as claimed in claim 1, wherein the step 7 specifically comprises: Step 701: Select the source directory of the file to be converted, write the path information of the source directory to be converted into the CAD-PDF conversion auxiliary table, and the source directory to be converted is the general drawing file storage directory or the single drawing file storage directory; Step 702: Convert the drawings in DWG format to PDF format according to the source directory to be converted, which specifically includes: Step 7021: Obtain the file internal information of the standard frame in the user-defined template identification list table, and write it into an array; Step 7022, obtain the CAD-PDF conversion auxiliary table, and write the path information of the source directory to be converted into the array; Step 7023: Obtain standard frame information and name information corresponding to all drawings in the general drawing file, where the standard frame information includes: the boundary size of the standard frame and the world coordinate of the lower left corner of the standard frame; Step 7024: Determine whether the drawing information to be converted is incorrect, if so, go to Step 7035; otherwise, go to Step 7036; Step 7025, re-enter step 7024 after modifying the name of the drawing to be converted; Step 7026: Select the drawing area to be converted according to the world coordinate frame in the lower left corner of the standard drawing frame, and save the content of the frame selection as a PDF format document, the name of the PDF format document is the name of the corresponding drawing, and the storage location is the source directory of the file to be converted ; Step 7027 , determine whether all the drawing conversion work is completed, if so, exit the drawing conversion work, otherwise, repeat steps 7026 to 7027 . 10. A CAD file auxiliary processing system for the air-conditioning industry, characterized in that it includes: The CAD template file copying module is used to automatically move, zoom and copy the original map files corresponding to multiple components, and calculate the world coordinate points of the original map files in the general drawing file according to the preset arrangement. And paste each map original image to the corresponding position in the general map file according to the world coordinate point; and match and add the corresponding standard frame for each map original image, and write the corresponding standard frame in the detail column of each standard frame The original file name of the original map; The CAD initial list generation and text filling module is used to obtain the component assembly information list of the original map file according to the storage information and storage relationship of the original map file, and write the content of the component assembly information list into the corresponding standard frame details column; The CAD component price estimation and text replacement module is used to determine the type and price of the corresponding components in the original map of each map, and determine the official component name corresponding to each component according to the type and price of the component. Replace the original file name in the parts list with the official component name; The CAD bill of materials extraction module is used to extract information from the details column of each standard frame according to the extracted identification information, and obtain the bill of materials corresponding to all parts; The CAD drawing splitting module is used to split each drawing in the general drawing file into a single drawing file, modify the file name of each drawing according to the corresponding official component name and save it to the specified directory, the drawings include the original map and Its corresponding standard frame; The CAD file content inspection module is used to inspect the general drawing file and the single drawing file. The inspection contents include at least: whether the official component names are duplicated or missing, whether the parts list of each standard drawing frame is missing content, each standard drawing frame Whether there is overlap, whether there is an unreplaced original file name, whether the file name of the drawing is consistent with the corresponding official component name, and whether the drawing scale is consistent with the drawing scale; The CAD-PDF conversion module is used to convert each single drawing file into PDF format.

Images