Typical frame-type strander part drawing design query method and system

Abstract

The invention discloses a typical frame-type strander part drawing design query method and system, and belongs to the technical field of industrial part information management. The method comprises the steps that a CAD file directory is scanned through a DOS batch processing command to generate a file list, and the file list is imported into Excel to establish an initial database; utilizing a VBA program to automatically extract graph numbers, names, materials, categories and process coding attributes, and using a small amount of manual input attributes as assistance; generating category attributes based on a predefined classification rule and automatically classifying; and generating a sorted hyperlink list and a related attribute detail list in the classification form to realize rapid positioning and opening of the drawing. According to the method, the problem that the target drawing is quickly and accurately queried from a large number of drawings under the condition that the drawing number is unknown is solved, the traditional query time of tens of minutes is shortened to several seconds, and the design efficiency and accuracy are remarkably improved.

Description

TECHNICAL FIELD

[0001] The present application belongs to the technical field of industrial parts information management, and particularly relates to a typical frame stranding machine part drawing design query method and system. BACKGROUND

[0002] In the existing industrial production, the frame stranding machine full-automatic coiling production line is a typical industrial product. The shapes and specifications of the parts on the equipment are various, but most of the parts can be classified into dozens of typical parts. When designing these new typical parts, the technical personnel usually hope to search for similar part drawings from the existing product drawings, and then modify them to adapt to the new equipment, which can greatly improve the design efficiency.

[0003] However, it is an important and difficult problem to quickly find the required part drawing from among thousands of part drawings. Especially when the technical personnel only know some attributes but not the specific drawing number information, the search process is more difficult. The existing solution is usually to use the search tool of the operating system to search according to the drawing name, and then find the file with the required attribute characteristics from the search results. However, this method has two main problems: first, the file information cannot be intuitively understood, and the drawings need to be opened one by one, which is time-consuming and inefficient; second, if the expected file is directly opened, the operation is highly blind.

[0004] Therefore, how to quickly and accurately find the required part drawing from a large number of part drawings without knowing the drawing number information but only knowing some attributes is a technical problem to be solved at present. SUMMARY

[0005]

Technical problem

[0006]

Technical solution

[0007] In a first aspect, the present application provides a typical frame stranding machine part drawing design query method, comprising: Step 1: scan the frame stranding machine part CAD file storage directory by running the DOS batch command, and generate a file list text file containing the absolute path and file name of all CAD files; Step 2: import the content of the file list text file into the total file directory table of the Excel workbook to establish an initial part file path database; Step 3: automatically parsing the file path string in the total file directory form by VBA program, taking the part after the last backslash as the file name, and further splitting the file name according to the preset separator to obtain the drawing number and name attributes, and filling the attributes into the corresponding columns of the total file directory form, the preset separator including a dash or a space; Step 4: in the case of opening an external product specification table file, combining the drawing number and name information in the total file directory form with the corresponding information in the product specification table file by VBA program, and when matching, automatically extracting the material attribute and backfilling to the corresponding column of the total file directory form; Step 5: based on the pre-defined classification rule, the name attribute and the material attribute in the total file directory form are automatically analyzed by VBA program to generate a category attribute including category identifier, serial number, space and file type, and the category attribute is filled into the total file directory form; the classification rule includes a plurality of component category codes starting with different letters, and an alias list and a non-alias list are predefined for each category to match and determine the category of the name attribute; Step 6: in the case of opening an external process flow specification table file and enterprise standard process file at the same time, the drawing number and name information combination form in the total file directory form is matched with the corresponding information in the process flow specification table file by VBA program; when matching, the process code is extracted; using the category code and name defined in the A material classification form in the Excel workbook, the naming rule of the name of each form in the enterprise standard process file is consistent, according to the enterprise standard process file, the major category, medium category, small category and auxiliary category attributes of the process code are queried and parsed, and the parsing result is automatically filled into the total file directory form; Step 7: through VBA program, in response to the generation command of one or more categories, and in each previously established classification form, a hyperlink pointing to the CAD file in the database and a related attribute list are generated; the display name format of the hyperlink includes category identifier, serial number, space and file type name, and is sorted by serial number; at the same time, the related attribute specification table is extracted and generated from the total file directory form, the related attribute specification table at least includes name, material and major category, medium category, small category and auxiliary category attributes parsed from the process code.

[0008] Optionally, the matching in steps 4 and 6 includes: comparing the drawing number and name information combination form in the total file directory form with the corresponding information in the external file, the combination form including the connection of drawing number and name through dash, the connection of drawing number and name through space, or the direct connection of drawing number and name.

[0009] Optionally, in the step 5 of generating the category attribute, the same-named parts are distinguished into the welding part category and the non-welding part category by judging whether the welding keyword is contained in the material attribute; the same-named parts are distinguished into the component part category and the non-component category by judging whether the component keyword is contained in the material attribute.

[0010] Optionally, in the step 5 of generating the category attribute, the serial number is automatically generated according to the name attribute and the category identifier after the parts under the same category are sorted in the logical order of their drawing numbers in the total file directory form. Optionally, in the step 6 of process coding, the 7-8 digit mixed coding of letters and numbers is used, and the parsing process includes: extracting the first 2 digit coding corresponding to the part category, and the subsequent digit coding corresponding to the major category, the medium category, the minor category and the auxiliary category attribute, and completing the semantic mapping of the coding to the specific attribute meaning by querying the enterprise standard process file form with the same category name.

[0011] Optionally, in the step 7, the generated command for one or more categories is configured as a group of independent VBA macro commands, wherein each macro command is predefined to establish a hyperlink and a related attribute list in a classification form of a specific category or a group of predefined associated categories.

[0012] Optionally, the method further includes: on the basis of keeping the hyperlink name in the specified category form unchanged, after manually inputting or modifying the attribute information in the specified classification form, triggering the reverse save command of the VBA program to automatically update and save the attribute information in the classification form to the corresponding entry in the total file directory form; when the material attribute is set to a specific identifier indicating that the entry is invalid, the reverse save command is executed to automatically clean up the corresponding entry in the total file directory form.

[0013] Optionally, the method further includes: after manually inputting the process code in the total file directory form, opening the enterprise standard process file, triggering the VBA program to automatically associate the form with the same category name in the file, batch-parsing the major category, the medium category, the minor category and the auxiliary category attributes of the input process code, and automatically filling in the corresponding position of the total file directory form.

[0014] In a second aspect, the present application provides a typical frame winch part drawing design query system, which comprises: A file list generation module is used to scan the frame winch part CAD file storage directory by running a DOS batch command, and generate a file list text file containing the absolute path and file name of all CAD files. A data import module for importing the content of the file list text file into a total file directory table of an Excel workbook to establish an initial spare part file path database; An attribute extraction module for operating the total file directory table to automatically extract and fill in a drawing number name attribute, a material attribute, a category attribute and a process code attribute through a VBA program; A hyperlink generation module for reading the category attribute in the total file directory table through the VBA program and generating a hyperlink pointing to a CAD file in the database and a related attribute list in each previously established classification table; An artificial interaction module for receiving user input and updating the total file directory table by triggering a VBA program to execute a reverse save command or a batch parsing command.

[0015]

Advantages

[0016] 2. Step 3 of the present application automatically parses the file path string through a VBA program to extract the drawing number and name attribute, and step 4 automatically extracts the material attribute by string comparison between the drawing number name and an external product specification table, which together realizes the automatic and batch filling of key spare part attribute information. This greatly reduces manual input errors and ensures the accuracy and consistency of the "drawing number-name-material" information chain, thereby improving the quality of the database from the source.

[0017] 3. Step 5 of the present application automatically analyzes the name and material attributes based on predefined classification rules through a VBA program to generate a category attribute containing a category identifier, a serial number, a space and a file type. This step makes full use of the way of describing spare part attributes with letters and numbers, in which: by judging whether the material contains the "welding" keyword, the accurate classification problem of spare parts with the same name is effectively solved; according to the order of appearance of spare parts under the same category, a serial number is automatically generated to give each spare part a unique identifier; based on the rules (corresponding to claim 5) stored in the A material classification table, which contains an alias list and a non-alias list, the classification process is intelligentized and highly accurate.

[0018] 4. The step 6 of the present application matches the combination of drawing number and name information of the file with the corresponding information in the process flow detail table file through VBA program under the condition of opening the file, process flow detail table file and enterprise standard process file at the same time, to extract the process code. The category of the item is parsed first, and then associated to the form of the same category name in the enterprise standard process file, and the major category, medium category, minor category and auxiliary category attributes are parsed accordingly. This step perfectly solves the problems of time-consuming and laborious manual interpretation of complex process code, and easy to produce ambiguity, realizes the automatic conversion of 7-8 bit code data which is difficult to use directly into intuitive and queryable business attributes, completes the deep fusion and intelligent filling of information from multiple heterogeneous data sources (total file directory form, process flow detail table file, enterprise standard process file), and finally, the three categories + auxiliary code are reflected in the category detail table. The present application uses process code attribute to describe the part graphic attribute, which is a kind of refinement, generalization and reorganization of graphic information. Users can understand the key information of the drawing without the help of the drawing, making it more suitable for process design and management and other subsequent links. The efficient and accurate conversion from graphic attribute to process code attribute is one of the key links to promote the development of digital and intelligent manufacturing.

[0019] 5. The step 7 of the present application generates a sorted hyperlink list and related attribute detail table in each classification form. The two steps work together to reconstruct the total directory into a clear classification and complete attribute view, so that users only need to click the form corresponding to the typical part, and then select and query the hyperlink closest to the demand by observing the part attribute content, to open the target drawing. This design has strong pertinence and practicality, and realizes the amazing effect of shortening the original 3-30 minutes of file query work to a few seconds, greatly improving the accuracy and efficiency of the query.

[0020] In summary, the method steps of the present application constitute an organic whole, and the dispersed and heterogeneous part information (drawing, detail table, process file) is automatically collected, extracted, fused, classified and reconstructed, finally providing a clear classification, intuitive attribute and one-key direct intelligent query system for users, fundamentally solving the problems of low efficiency, blind operation and easy error in traditional query methods. BRIEF DESCRIPTION OF DRAWINGS

[0021] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed in the embodiment description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0022] Figure 1 is the framework diagram of the typical frame winch component drawing design query system provided by the application.

[0023] Figure 2 is the software main interface schematic diagram of the query method provided by the application.

[0024] Figure 3 is the content schematic diagram of the file list text file generated by the DOS batch command provided by the application.

[0025] Figure 4 is the initial database schematic diagram established after the file list content is imported into the Excel total file directory table provided by the application.

[0026] Figure 5 is the A material classification Excel table schematic diagram for defining the component classification rules and details provided by the application.

[0027] Figure 6 is the writing rule of the process code and the description diagram of each code meaning provided by the application.

[0028] Figure 7 is the query and mapping relationship schematic diagram of the specific attribute meaning of the process code in the enterprise standard process file provided by the application.

[0029] Figure 8 is the hyperlink and its attribute detail example diagram automatically generated by the VBA program in the AB sleeve classification table according to the serial number sorting provided by the application.

[0030] Figure 9 is the hyperlink and its attribute detail example diagram automatically generated by the VBA program in the AO screw rod classification table according to the serial number sorting provided by the application.

[0031] Figure 10 is the example diagram for quickly opening the target CAD drawing by clicking the hyperlink in the AB sleeve classification table provided by the application. DETAILED DESCRIPTION

[0032] The technical solutions of the application will be described clearly and completely below in combination with the drawings. Obviously, the described embodiments are part of the embodiments of the application, rather than all the embodiments. Based on the embodiments in the application, all other embodiments obtained by those skilled in the art without creative labor fall within the protection scope of the application.

[0033] Embodiment one: This embodiment shows the automatic process of the method of the application, which is suitable for the quick retrieval of most typical components. The specific implementation process is as follows: Step 1: Run DOS batch commands in the upper directory of the directory storing the CAD files of the basket stranding machine components @echo off dir / s / b *.*>aa.txt Exit Scan the storage directory of the CAD files of the basket stranding machine components, and automatically generate a text file list aa.txt containing the absolute paths and file names of all CAD files, as Figure 3 shown.

[0034] Step 2: Manually select and copy all the contents in the text file list aa.txt, and then paste them into the general file directory form of the Excel workbook to establish an initial database of component file paths. As Figure 4 shown on the left. This database contains component file path information, laying a foundation for subsequent attribute extraction.

[0035] Step 3: Parse the file path strings in the general file directory form through a VBA program, and intercept the part after the last backslash as the file name. For example, extract "DPTXJ.006-08A spacer.exb" from "E:\drawing\...\DPTXJ.006-08A spacer.exb" as the file name, and split the file name into the drawing number "DPTXJ.006-08A" and the name "spacer" according to preset delimiters such as the dash "-" and spaces, and回填 the attributes to the corresponding columns of the general file directory form.

[0036] Step 4: With the external product parts list file open, use a VBA program to compare the drawing numbers and names in the general file directory form, such as "DPTXJ.006-08A" and "spacer", with the product parts list. After successful matching, automatically extract the material attribute, such as "45 steel", and回填 it to the corresponding column of the general file directory form.

[0037] The string comparison specifically includes: matching the combined form of the drawing number and name information in the general file directory form with the corresponding information in the product parts list file, where the combined form of the drawing number and name information includes multiple preset forms. For example, the drawing number and name are connected by a dash (such as "DPTXJ.006-08A-spacer"), the drawing number and name are connected by a space (such as "DPTXJ.006-08A spacer"), or the drawing number and name are directly connected (such as "DPTXJ.006-08A spacer"); when the match is consistent, automatically extract the material attribute.

[0038] Step 5: The category attribute is automatically generated by VBA program based on the name attribute and material attribute in the total file directory form, such as the name attribute "separate sleeve" and the material attribute "45 steel", referring to the pre-defined classification rules stored in the A data classification form of Excel workbook, such as Figure 5 .

[0039] The pre-defined classification rules include multiple part category codes starting with different letters, at least including 42 A-starting part categories (such as AB separate sleeve), 28 B-starting welding parts, and 14 C-starting assemblies. In a preferred embodiment of the present application, the classification rules pre-define 6 aliases and 6 non-aliases for each category (such as the aliases of AB separate sleeve including "separate sleeve", "sleeve", etc.), which are used for accurate name attribute matching and category determination.

[0040] By judging whether the material attribute contains the keyword "welding", the parts with the same name are distinguished into welding part category and non-welding part category, such as "45 steel" is a non-welding part category. By judging whether the material attribute contains the keyword "assembly", the parts with the same name are distinguished into assembly part category and non-assembly category, such as "assembly" is an assembly category.

[0041] The serial number is automatically generated in the total file directory form according to the name attribute and category identification, and the parts under the same category are sorted in logical order according to their drawing numbers, such as "009".

[0042] The final generated category attribute format includes category identification, serial number, space, and file type, such as "separate sleeve 009 (electronic drawing board format)".

[0043] The category attribute is backfilled into the total file directory form, as shown on the right side. Figure 4

[0044] Step 6: In the case of opening the external process flow detail table and enterprise standard process file at the same time, the VBA program combines the drawing number and name information in the total file directory form with the corresponding information in the process flow detail table file, and the combination form includes multiple pre-set forms, such as drawing number and name connected by a short line (such as "drawing number-name"), drawing number and name connected by a space (such as "drawing number name"), or drawing number and name directly connected (such as "drawing number name"). When any pre-set combination form matches, the system automatically extracts the corresponding process code, which is a 7-8 digit mixed code of letters and numbers, such as "ABOFA04", and the process code writing example is as follows Figure 6 ​The category code and name (such as "AB spacer") defined in the A data classification form in the Excel workbook are automatically associated with the "AB spacer" form of the file, and the naming rules of the various forms in the enterprise standard process file are consistent (i.e. the category code in the A data classification form corresponds to the form name in the enterprise standard process file), according to the same category name form query and parse each part of the process code in the enterprise standard process file, and the semantic mapping rules are shown in Figure 7 , which is mapped to the large class, medium class, small class and auxiliary class attribute. For example, the first two digits "AB" of the process code "ABOFA04" correspond to the part class (spacer), the third digit "O" corresponds to the large class (shape attribute), the fourth digit "F" corresponds to the medium class (tolerance attribute), the fifth digit "A" corresponds to the small class (structure feature), and the sixth and seventh digits "04" correspond to the auxiliary class attribute. Finally, the parsing result is automatically backfilled into the total file directory form, thereby completing the attribute filling.

[0045] Step 7: Through the VBA program, in response to the generation command for one or more categories, and in each previously established classification form, generate hyperlinks pointing to CAD files in the database and related attribute lists; The display name format of the hyperlink contains the category identifier, serial number, space and file type name, such as "spacer 009 (electronic drawing board format)", and is sorted by serial number; At the same time, extract and generate related attribute details from the total file directory form, which at least includes name, material and large class, medium class, small class and auxiliary class attributes parsed from the process code, such as Figure 8 and Figure 9 as shown.

[0046] Specifically, in step 7, in response to the generation command for one or more categories, the system provides a set of predefined VBA macro commands, each of which is directed to a specific category (such as "AB spacer sleeve") or a group of related categories. The user can select one or more macro commands to execute as needed, and the program will subsequently operate on the selected categories rather than processing all data at once, effectively avoiding program running errors caused by excessive data volume. Subsequently, in the pre-established classification form (such as the "AB spacer sleeve" form), the program creates a hyperlink with a display name such as "spacer sleeve 009 (electronic drawing board format)", where "spacer sleeve" is the category identifier and "009" is the serial number. The generated attribute detail table, in addition to the name and material, focuses on the structured process code attributes parsed from the process code, such as the major category "outer diameter: 306 width: 144 inner diameter: 287 width: 144", the middle category "inner diameter T: (+0.1 +0.3)", the minor category "no requirements", and the auxiliary category "no grinding, no blackening treatment", so that the user can quickly understand the key features of the parts by browsing the attribute detail table without opening the CAD drawing.

[0047] When the technician finds that an attribute is missing in an entry in the "AB spacer sleeve" form, such as the material not being identified, the attribute information can be manually input in the form, such as the material being "stainless steel". By selecting the form name through the software interface as shown in Figure 2 and clicking the "reverse save command", the VBA program automatically updates the input information to the corresponding entry in the general file directory form while keeping the hyperlink name in the specified category form unchanged. When the hyperlink of an entry is invalid, "invalid" is input in the material column, and after clicking the "reverse save command", the program automatically cleans up the entry in the general file directory form. In the preferred embodiment of the present application, the specific identifier for indicating that an entry is invalid is the user input "invalid".

[0048] The technician can manually input multiple process codes in the general file directory form, such as ABLJA03 and ACEAA05, open the enterprise standard process file, and by triggering the relevant VBA program, automatically associate the form with the same category name in the file, and batch automatically parse each process code: extract the first two codes corresponding to the category, such as AB for spacer sleeve and AC for bending piece; automatically associate the form with the same category name in the enterprise standard process file, and parse the large, medium, and small categories and auxiliary attributes of the subsequent codes through semantic mapping as shown in Figure 7 The results of the parsing are batch automatically filled back to the corresponding positions in the general file directory form.

[0049] If the technician needs to find the spacer part with an outer diameter of 306, click the "AB spacer" form, and by observing the information in the "major attribute" column, such as "outer diameter 306", the hyperlink "AB spacer 009 (electronic drawing board format)" can be located within 2-3 seconds; if the drawing number is known, by observing the information in the "drawing number + name" column, such as "DPTXJ.006-08A spacer", the hyperlink "AB spacer 009 (electronic drawing board format)" can also be located within 2-3 seconds. Clicking the hyperlink can directly open the drawing, and the drawing style is as shown in Figure 10 .

[0050] The method of the present application is developed for the need of quickly querying the required typical parts, and most of the information of the parts is automatically extracted, quickly and automatically established into the part attribute database of various typical parts and related hyperlinks, and automatically placed in the corresponding form according to the category through the effective connection of the software shown in Figure 2 and the various part drawing data, detail table, process flow detail and enterprise standard process flow card file drawn before, and a small amount of information is imported by manual input. When used, after the part attribute input work is completed, only the typical part corresponding form needs to be clicked, and then the part attribute content is observed to select the hyperlink of the column closest to the customer's query demand, so that the part drawing with the hyperlink can be opened, which has very strong pertinence and practicality. After the method of the present application is applied, the file query work of 3-30 minutes is shortened to 2-3 seconds, which greatly improves the accuracy and work efficiency of querying the typical part drawing.

[0051] Example two The embodiment provides a typical frame winch part drawing design query system, and the system is constructed based on Excel and VBA, and specifically comprises the following steps: A file list generation module (see module 1 in Figure 1 ), which is used for scanning the frame winch part CAD file storage directory by running a DOS batch command, and generating a file list text file containing the absolute path and file name of all CAD files; A data import module (see module 2 in Figure 1 ), which is used for importing the content of the file list text file into the total file directory form of the Excel workbook, so as to establish an initial part file path database; An attribute extraction module (see modules 3, 4 and 5 in Figure 1 ), which is used for operating the total file directory form, and automatically extracting and filling in the drawing number name attribute, material attribute, category attribute and process code attribute through a VBA program; A hyperlink generation module (see module 6 in Figure 1a module (see module 8 in FIG. 8) for reading the category attribute in the total file directory form by the VBA program, and generating a hyperlink list pointing to the CAD files in the database and a related attribute detail table in the classification form established in advance; a manual interaction module (see modules 6 and 7 in FIG. 6 and FIG. 7) for receiving user input and triggering the VBA program to execute the reverse save command or batch parsing command to update the total file directory form. Figure 1

[0052] The above embodiments are only used to illustrate the technical solutions of the present application, rather than limit the same. Although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those skilled in the art that the technical solutions recorded in the foregoing embodiments can be modified, or some technical features can be replaced by equivalents. Such modifications or replacements do not change the essence of the corresponding technical solutions, and should be included in the protection scope of the present application.​

Claims

1. A typical frame rigging machine parts drawing design query method, characterized in that, The application comprises the following steps: Step 1: scanning the CAD file storage directory of the frame stranding machine parts by running a DOS batch command to generate a file list text file containing the absolute path and file name of all CAD files; Step 2: importing the content of the file list text file into the total file directory table of the Excel workbook to establish an initial parts file path database; Step 3: automatically parsing the file path string in the total file directory table by VBA program, extracting the part after the last backslash in the file path string as the file name, and further splitting the file name according to the preset separator to obtain the drawing number and name attributes, and filling the attributes into the corresponding columns of the total file directory table, wherein the preset separator includes a dash or a space; Step 4: in the case of opening an external product specification table file, combining the drawing number and name information in the total file directory table with the corresponding information in the product specification table file by VBA program, and when the matching is consistent, automatically extracting the material attribute and filling it back to the corresponding column of the total file directory table; Step 5: based on the pre-defined classification rules, the name attribute and material attribute in the total file directory table are automatically analyzed by VBA program to generate a category attribute containing category identifier, serial number, space and file type, and the category attribute is filled into the total file directory table; the classification rules include a plurality of part category codes starting with different letters, and an alias list and a non-alias list are predefined for each category to match and determine the category of the name attribute; Step 6: in the case of opening an external process flow specification table file and enterprise standard process file at the same time, the drawing number and name information combination in the total file directory table are matched with the corresponding information in the process flow specification table file by VBA program; when the matching is consistent, the process code is extracted; Using the category code and name defined in the A material classification table in the Excel workbook, and the naming rule of the name of each table form in the enterprise standard process file is consistent, the major category, medium category, small category and auxiliary category attributes of the process code are queried and parsed according to the enterprise standard process file, and the parsing result is automatically filled into the total file directory table; Step 7: by VBA program, in response to the generation command for one or more categories, and in each previously established classification table, a hyperlink pointing to the CAD file in the database and a related attribute list are generated; the display name format of the hyperlink contains category identifier, serial number, space and file type name, and is sorted by serial number; at the same time, the related attribute specification table is extracted and generated from the total file directory table, and the related attribute specification table at least includes name, material and the major category, medium category, small category and auxiliary category attributes parsed from the process code.

2. The method of claim 1, wherein, The matching in the step 4 and the step 6 both include: matching the combined form of the drawing number and name information in the total file directory form with the corresponding information in the external file, the combined form including the drawing number and name being connected by a short line, the drawing number and name being connected by a space, or the drawing number and name being directly connected.

3. The method of claim 1, wherein, In the step 5 of generating the category attribute, the same-named parts are distinguished into the welding part category and the non-welding part category by judging whether the welding keyword is contained in the material attribute; and the same-named parts are distinguished into the component part category and the non-component category by judging whether the component keyword is contained in the material attribute.

4. The method of claim 1, wherein, In the step 5 of generating the category attribute, the serial number is automatically generated according to the name attribute and the category identifier after the parts under the same category are sorted in the logical order of the drawing numbers in the total file directory form.

5. The method of claim 1, wherein, In the step 6, the process code is a 7-digit to 8-digit mixed code of letters and numbers, and the parsing process includes: extracting the first 2-digit code corresponding to the part category, and each subsequent digit code corresponding to the large category, the medium category, the small category and the auxiliary category attribute, and completing the semantic mapping of the code to the specific attribute meaning by querying the same category name form in the enterprise standard process file.

6. The method of claim 1, wherein, In the step 7, the generated command for one or more categories is configured as a group of independent VBA macro commands, and each macro command is predefined to establish a hyperlink and a related attribute list in a classification form of a specific category or a group of predefined associated categories.

7. The method of claim 1, wherein, The method further includes: on the basis of keeping the hyperlink name in the specified category form unchanged, after manually inputting or modifying the attribute information in the specified classification form, automatically updating and saving the attribute information in the classification form to the corresponding entry in the total file directory form by triggering the reverse save command of the VBA program; when the material attribute is set to a specific identifier for indicating that the entry is invalid, the corresponding entry in the total file directory form is automatically cleaned up when the reverse save command is executed.

8. The method of claim 1, wherein, The method further includes: after manually inputting the process code in the total file directory form, the enterprise standard process file is opened, the VBA program is triggered to automatically associate the form with the same category name in the file, batch parse the large category, the medium category, the small category and the auxiliary category attributes of the input process code, and automatically fill in the corresponding position of the total file directory form.

9. A typical frame rigging machine parts drawing design inquiry system, characterized by, The system comprises: a file list generation module, configured to scan a CAD file storage directory of the frame winch parts by running a DOS batch command, and generate a file list text file containing absolute paths and file names of all CAD files; a data import module, configured to import the content of the file list text file into a total file directory form of an Excel workbook to establish an initial part file path database; an attribute extraction module, configured to operate the total file directory form, and automatically extract and fill in a drawing number and name attribute, a material attribute, a category attribute and a process code attribute through a VBA program; an attribute extraction module, configured to operate the total file directory form, and automatically extract and fill in a drawing number and name attribute, a material attribute, a category attribute and a process code attribute through a VBA program; A hyperlink generation module for reading the category attributes in the master file directory form by a VBA program, and generating hyperlinks to CAD files in the database and a list of related attributes in each previously established category form; An artificial interaction module for receiving user input and triggering a VBA program to execute a reverse save command or a batch parsing command to update the master file directory form.

Images