A process resource dynamic automatic allocation method based on database and custom rules

Abstract

The application discloses a kind of based on database and the process resource dynamic automatic allocation method of custom rule, comprising the following steps:1) process route verification: obtain process route and carry out verification;2) material automatic allocation: obtain material information and distribute to process / step, and the quantity of material and material combination relationship are verified;3) equipment tooling automatic allocation: based on the material of process / step distribution selects equipment tooling, realizes equipment tooling automatic allocation;4) custom component verification: realize material process attribute parameter, equipment tooling capacity parameter and process attribute comparison logic verification, custom rule component operation logic;5) automatically add matters needing attention: realize material matters needing attention, equipment tooling matters needing attention automatic acquisition and update function.The application has the advantages of high allocation efficiency, high allocation precision.

Description

Technical Field

[0001] The present invention mainly relates to the field of production and processing technology, and in particular to a method for dynamically and automatically allocating process resources based on a database and user-defined rules. Background Art

[0002] Traditional production and processing in the automotive electronics and consumer electronics sectors has largely achieved automation, even to the point of unmanned production. Traditionally, process resource allocation requires manual allocation by engineers, such as assigning material data to processes / steps one by one. The specific equipment, tools, and fixtures used in the corresponding process / step, as well as production procedures, are then determined based on the equipment, tools, and fixtures ledger. This data is then applied to production control to ensure timely and accurate material delivery to production line workstations, improving production efficiency and reducing production costs, material floor space, and management costs. Therefore, pre-allocating and digitizing production resource data (materials, equipment, tools, fixtures, production procedures, personnel qualifications, etc.) to the corresponding process routes during process design is fundamental to achieving automation and even unmanned production.

[0003] Therefore, it is necessary to invent a method for dynamic and automatic allocation of process resources based on a database and custom rules. Summary of the Invention

[0004] The technical problem to be solved by the present invention is: in response to the technical problems existing in the prior art, the present invention provides a dynamic automatic allocation method for process resources based on a database and custom rules with high allocation efficiency and high allocation accuracy.

[0005] In order to solve the above technical problems, the technical solution proposed by the present invention is:

[0006] A method for dynamically and automatically allocating process resources based on a database and custom rules, comprising the following steps:

[0007] 1) Process route verification: obtain the process route and verify the process route version;

[0008] 2) Automatic material allocation: Obtain material information, automatically allocate materials to the process / steps of the process route, and verify the material quantity and material combination relationship;

[0009] 3) Automatic allocation of equipment, tools and tooling: Select equipment, tools and tooling based on the materials allocated to the process / step. Automatic allocation of equipment, tools and tooling is achieved by combining the relationship between process routes and equipment, tools and tooling substitution relationships, and equipment, tools and tooling data.

[0010] 4) Custom component verification: Implement logic verification of material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison, and customize rule component operation logic;

[0011] 5) Automatic addition of notes: realize the automatic acquisition and update function of material notes, equipment tooling notes.

[0012] Preferably, the specific steps of process route verification in step 1) are as follows:

[0013] 1.1) Obtain the drawing number and process route number information of the current product;

[0014] 1.2) Obtain the published process route based on the product drawing number and process route number;

[0015] 1.3) Query the process route change information and problem feedback report information based on the process route number;

[0016] 1.4) Compare the obtained process route data version number with the queried change information and problem feedback information, and give comparison information;

[0017] 1.5) Reduce the process route to a structure tree and display the process route;

[0018] 1.6) Re-write the process route data into a new database according to a fixed format.

[0019] Preferably, in step 2), the specific steps for checking the quantity and combination relationship of materials are:

[0020] 2.1) Obtain the MBOM information of the current product drawing number, and structure the data and store it in the database;

[0021] 2.2) Query the MBOM change information and problem feedback report information based on the product drawing number;

[0022] 2.3) Compare the obtained process route data version number with the queried change information and problem feedback information and give comparison information;

[0023] 2.4) Delete unnecessary data according to the specified logic;

[0024] 2.5) Number and sort the processed MBOM according to the specified logic to form a structured BOM;

[0025] 2.6) Query the specified material process attribute of the material from the material process attribute library in the structured BOM;

[0026] 2.7) Compare the material with the design file, confirm the position attribute of the material in the product and write it into the structured BOM;

[0027] 2.8) The structured BOM is compared and matched with the process / step information in the process route according to the specified logic, and the qualified materials and their special supporting materials are attached to the current process / step;

[0028] 2.9) Update quantity information in structured BOM;

[0029] 2.10) Display the materials that have not been automatically hung and complete the hanging manually. After the hanging is completed, the process route containing the hanging information will be written into the cache.

[0030] Preferably, in step 3), corresponding material information and a material matching library are obtained based on the design document to automatically allocate materials to the process / step.

[0031] Preferably, the specific steps of automatically allocating equipment, tools and fixtures in step 3) are:

[0032] 3.1) Obtain the process route containing the hanging material information in the cache;

[0033] 3.2) Based on the production line information in the process route, the corresponding equipment, tool and tool data information is filtered from the equipment, tool and tool library and loaded into the cache;

[0034] 3.3) Compare the material information in the process with the equipment, tool and fixture information in the cache according to the specified logic;

[0035] 3.4) List all equipment, tool, and fixture data under the current work step / process, and remove equipment, tool, and fixture data with lower priority and that can be replaced according to the replacement relationship table;

[0036] 3.5) Write the eliminated equipment, tool and fixture data into the current process / step;

[0037] 3.6) Repeat steps 3.1) to 3.5);

[0038] 3.7) Read the operation requirements and precautions of the equipment, tools and fixtures according to the resource coding information of the equipment, tools and fixtures in the process / step and write them into the cache;

[0039] 3.8) Record log information.

[0040] Preferably, the specific steps of the custom component verification in step 4) are:

[0041] 4.1) The production line information, process / step information, material code and equipment tool resource code in the current process route and read the corresponding process attributes;

[0042] 4.2) Read the verification rules, parse the process attribute keywords of materials, equipment, tools and fixtures in the verification rules, and establish an association with the actual process attributes;

[0043] 4.3) Analyze the process attributes of materials and equipment tools and perform logical operations based on the logical symbols in the custom rules;

[0044] 4.4) Identify materials, equipment, tools, and fixtures that do not meet custom rules, and adjust and optimize them based on the custom rule prompts;

[0045] 4.5) Rewrite the data that meets the requirements into the database;

[0046] 4.6) Repeat steps 4.2) to 4.4) during the verification process.

[0047] Preferably, the specific steps of automatically adding notes in step 5) are:

[0048] 5.1) Material process attributes and equipment, tooling, and operation requirements and precautions data in the database;

[0049] 5.2) Search for corresponding precautions data from the process expert database based on the material code;

[0050] 5.3) Search for corresponding precautions data from the process expert database based on the tool and fixture equipment resource code;

[0051] 5.4) Compare and remove duplicates from the PFMEA in the current drawing number and write the obtained precautions information into the database.

[0052] The present invention also discloses a device for dynamically and automatically allocating process resources based on a database and custom rules, which is used to execute the steps of the above method, including:

[0053] The process route verification function module is used to obtain the process route and verify the process route version;

[0054] The material automatic allocation function module is used to obtain material information, automatically allocate materials to the process / steps of the process route, and verify the material quantity and material combination relationship;

[0055] The equipment, tooling and fixture automatic allocation function module is used to select equipment, tooling and fixtures based on materials allocated to processes / steps. It also combines the relationship between process routes and equipment, tooling and fixtures, the equipment, tooling and fixtures substitution relationship, and equipment, tooling and fixtures data to achieve automatic allocation of equipment, tooling and fixtures.

[0056] The custom component verification function module is used to implement logical verification of material process attribute parameters, equipment tool and tooling capability parameters, and process attribute comparison, and customize the rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of rules by configuring parameters; the custom build supports the rapid creation of rules, and secondary creation and execution of rules based on the material process attribute parameter fields and the equipment tool and tooling process attribute parameter fields;

[0057] The automatic adding of precautions function module is used to realize the automatic acquisition and update of material precautions, equipment, tooling precautions.

[0058] An embodiment of the present invention further discloses a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the above method are executed.

[0059] An embodiment of the present invention further discloses a computer device, including a memory and a processor, wherein a computer program is stored in the memory, and when the computer program is executed by the processor, the steps of the above method are executed.

[0060] Compared with the prior art, the advantages of the present invention are:

[0061] The process route acquisition function of this invention primarily implements process route acquisition, process route version verification, and process route change query functions. After acquisition, the process steps / operations in the process route are logically structured to form basic data. Automated process route acquisition and structured analysis automatically match resources with the process (process route) during process design, forming the basis for automatic resource allocation, ultimately achieving automatic material distribution and logistics automation.

[0062] The automatic material allocation function of this invention primarily enables automatic acquisition and processing of MBOMs, automatic material allocation along process routes, MBOM quantity verification, and material comparison. The automatic equipment, tooling, and program allocation function primarily enables automatic acquisition, allocation, and comparison of equipment, tooling, and program data. Automatic allocation of materials, equipment, tooling, and program data based on structured process routes improves work efficiency.

[0063] The automatic note-adding feature of this invention primarily enables the automatic acquisition and updating of material notes and equipment, tooling, and fixture notes. The custom component verification feature primarily enables the verification of material process attribute parameters, equipment, tooling capability parameters, and process attribute comparison logic. Based on the structured process route and its resources (materials, equipment, tools, and fixtures), the system automatically pushes operating instructions, parameter requirements, and precautions during the processing process.

[0064] The present invention greatly improves the efficiency of material distribution. Manual distribution of materials and equipment tools and fixtures takes 3 hours, but this method can be completed in 5 minutes. The engineer's working hours will be reduced to 3% of the original time. At the same time, the distribution accuracy rate reaches more than 99%, which is much higher than the 91% of manual distribution. BRIEF DESCRIPTION OF THE DRAWINGS

[0065] Figure 1 The present invention is a flowchart of an embodiment of the method.

[0066] Figure 2 This is a diagram illustrating an embodiment of the method of the present invention in a specific application. DETAILED DESCRIPTION

[0067] The present invention will be further described below with reference to the accompanying drawings and specific embodiments.

[0068] like Figure 1-2 As shown, the method for dynamic automatic allocation of process resources based on a database and custom rules according to an embodiment of the present invention includes the following steps:

[0069] 1) Process route verification: obtain the process route and verify the process route version;

[0070] 2) Automatic material allocation: Obtain material information, automatically allocate materials to the process / steps of the process route, and verify the material quantity and material combination relationship;

[0071] 3) Automatic allocation of equipment, tools and tooling: Select equipment, tools and tooling based on the materials allocated to the process / step. Automatic allocation of equipment, tools and tooling is achieved by combining the relationship between process routes and equipment, tools and tooling substitution relationships, and equipment, tools and tooling data.

[0072] 4) Custom component verification: Implement logic verification of material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison, and customize rule component operation logic;

[0073] 5) Automatically add precautions: realize the automatic acquisition and update function of material precautions, equipment, tooling precautions.

[0074] In a specific embodiment, in step 1), the process route acquisition, process route version verification, and process route change query functions are mainly implemented. After the process route acquisition function is started, it works according to the following process:

[0075] 1.1) Obtain the drawing number and process route number information of the current product;

[0076] 1.2) Obtain the published process route from the system based on the product drawing number and process route number;

[0077] 1.3) Query process route change information and problem feedback report information from the system based on the process route number;

[0078] 1.4) Compare the obtained process route data version number with the queried change information and problem feedback information and provide comparison information;

[0079] 1.5) Restore the process route to a structure tree and display the process route;

[0080] 1.6) The process route data is rewritten into the new database in a fixed format.

[0081] In a specific embodiment, in step 2), the automatic material allocation mainly realizes the functions of automatic acquisition and processing of MBOM, automatic allocation of materials on the process route, MBOM quantity verification, and material comparison.

[0082] Specifically, the automatic material allocation logic is mainly based on obtaining the corresponding material information (such as position number, package, location, etc.) from the design file (PCB / CAD), and the material supporting library (mainly auxiliary materials or general materials, such as screws, flat washers, terminals) to automatically allocate materials to the process / step, and improve the accuracy of material allocation.

[0083] Specifically, the material verification logic primarily verifies material quantities and material combination relationships. For complex products, where the same material exists in different sub-components, the material verification process must accurately identify which materials belong to which sub-components and calculate the corresponding quantities. Furthermore, when there are multiple material combination relationships, it must be able to identify which relationships belong to the same sub-component to avoid situations where a component under component A is used in component B. The specific process is as follows:

[0084] 2.1) Obtain the MBOM information of the current product drawing number, structure the data and store it in the database;

[0085] 2.2) Query MBOM change information and problem feedback report information from the system based on the product drawing number;

[0086] 2.3) Compare the obtained process route data version number with the queried change information and problem feedback information and provide comparison information;

[0087] 2.4) Delete unnecessary data from MBOM data according to the specified logic, such as BOM data under the actual part;

[0088] 2.5) Number and sort the processed MBOM according to the specified logic to form a structured BOM;

[0089] 2.6) Query the specified material process attributes from the material process attribute library for the materials in the structured BOM in turn;

[0090] 2.7) Compare the material with the design file (such as PCB, 3D), confirm the location attributes of the material in the product and write it into the structured BOM;

[0091] 2.8) The structured BOM is compared and matched with the process / step information in the process route according to the specified logic, and the qualified materials and their special supporting materials are attached to the current process / step;

[0092] 2.9) Update quantity information in structured BOM;

[0093] 2.10) Display the materials that were not automatically hung and manually complete the hanging. After the hanging is completed, the process route containing the hanging information is written to the cache. Repeat steps 2.8) to 2.9) during the execution process.

[0094] In a specific embodiment, in step 3), the automatic allocation function of equipment, tools, fixtures and procedures mainly realizes the automatic acquisition, allocation and comparison functions of equipment, tools, fixtures and procedure data, and the automatic allocation logic of equipment, tools and fixtures.

[0095] Specifically, equipment, tools, and fixtures are selected based on the materials allocated to the process / step. The automatic allocation of equipment, tools, and fixtures is achieved by combining the association between production lines and equipment, tools, and fixtures, the substitution relationship between equipment, tools, and fixtures, and the equipment, tools, and fixtures in the system. These are then passed to the APS (Automatic Planning and Scheduling System) and work according to the following process:

[0096] 3.1) Obtain the process route containing the hanging material information in the cache;

[0097] 3.2) Based on the production line information in the process route, the corresponding equipment, tool and tool data information is filtered from the equipment, tool and tool library and loaded into the cache;

[0098] 3.3) Compare the material information in the process with the equipment, tooling, and fixture information in the cache according to the specified logic, such as the relationship between bolts and torque tools, and the relationship between terminals and crimping tools;

[0099] 3.4) List all equipment, tool, and fixture data under the current work step / process, and remove equipment, tool, and fixture data with lower priority and that can be replaced according to the replacement relationship table;

[0100] 3.5) Write the eliminated equipment, tool and fixture data into the current process / step;

[0101] 3.6) Repeat steps 3.1) to 3.5);

[0102] 3.7) Read the operation requirements and precautions of the equipment, tools and fixtures according to the resource coding information of the equipment, tools and fixtures in the process / step and write them into the cache;

[0103] 3.8) Record log information.

[0104] In a specific embodiment, in step 4), the custom component verification function mainly implements functions such as material process attribute parameters, equipment tool and tooling capability parameters, process attribute comparison logic verification, and custom rule component operation logic. Custom rules mainly pre-set the attributes of the definable rules and associate them with the fields in the database. At the same time, the rule logic (such as >, <, including =) and the rule combination logic (such as AND, OR) are limited to implement multi-condition verification to avoid errors in the allocation of materials, equipment, tools and tooling. The process works as follows:

[0105] 4.1) The production line information, process / step information, material code and equipment tool resource code in the current process route and read the corresponding process attributes;

[0106] 4.2) Read the verification rules, parse the process attribute keywords of materials, equipment, tools and fixtures in the verification rules, and establish an association with the actual process attributes;

[0107] 4.3) Analyze the process attributes of materials and equipment tools and perform logical operations based on the logical symbols in the custom rules (such as >, ≤, or, ≠);

[0108] 4.4) Identify materials, equipment, tools, and fixtures that do not meet custom rules, and adjust and optimize them based on the custom rule prompts;

[0109] 4.5) Rewrite the data that meets the requirements into the database;

[0110] 4.6) Repeat steps 4.2) to 4.4) during the verification process.

[0111] In a specific embodiment, in step 5), the automatic adding of precautions function mainly realizes the automatic acquisition and update of material precautions, equipment and tool precautions, and works according to the following process:

[0112] 5.1) Material process attributes and equipment, tooling, and operation requirements and precautions data in the database;

[0113] 5.2) Search for corresponding precautions data from the process expert database based on the material code;

[0114] 5.3) Search for corresponding precautions data from the process expert database based on the tool and fixture equipment resource code;

[0115] 5.4) Compare and remove duplicates from the PFMEA in the current drawing number and write the obtained precautions information into the database.

[0116] The process route acquisition function of this invention primarily implements process route acquisition, process route version verification, and process route change query functions. After acquisition, the process steps / operations in the process route are logically structured to form basic data. Automated process route acquisition and structured analysis automatically match resources with the process (process route) during process design, forming the basis for automatic resource allocation, ultimately achieving automatic material distribution and logistics automation.

[0117] The automatic material allocation function of this invention primarily enables automatic acquisition and processing of MBOMs, automatic material allocation along process routes, MBOM quantity verification, and material comparison. The automatic equipment, tooling, and program allocation function primarily enables automatic acquisition, allocation, and comparison of equipment, tooling, and program data. Automatic allocation of materials, equipment, tooling, and program data based on structured process routes improves work efficiency.

[0118] The automatic note-adding feature of this invention primarily enables the automatic acquisition and updating of material notes and equipment, tooling, and fixture notes. The custom component verification feature primarily enables the verification of material process attribute parameters, equipment, tooling capability parameters, and process attribute comparison logic. Based on the structured process route and its resources (materials, equipment, tools, and fixtures), the system automatically pushes operating instructions, parameter requirements, and precautions during the processing process.

[0119] The present invention greatly improves the efficiency of material distribution. Manual distribution of materials and equipment tools and fixtures takes 3 hours, but this method can be completed in 5 minutes. The engineer's working hours will be reduced to 3% of the original time. At the same time, the distribution accuracy rate reaches more than 99%, which is much higher than the 91% of manual distribution.

[0120] The present invention integrates and interacts with the program server, MES server and test data server to automatically obtain, verify and upload data to realize automatic operation of information.

[0121] The automatic allocation process of the present invention does not require human intervention. Only a few new materials need to be manually allocated. The manpower demand for engineers in this part of the work is reduced by more than 80%, while also reducing the energy-saving requirements of engineers.

[0122] The tool method of the present invention is highly flexible and compatible with all types of products from multiple companies.

[0123] The embodiment of the present invention further discloses a device for dynamically and automatically allocating process resources based on a database and custom rules, which is used to execute the steps of the above method, including:

[0124] The process route verification function module is used to obtain the process route and verify the process route version;

[0125] The material automatic allocation function module is used to obtain material information, automatically allocate materials to the process / steps of the process route, and verify the material quantity and material combination relationship;

[0126] The equipment, tooling and fixture automatic allocation function module is used to select equipment, tooling and fixtures based on materials allocated to processes / steps. It also combines the relationship between process routes and equipment, tooling and fixtures, the equipment, tooling and fixtures substitution relationship, and equipment, tooling and fixtures data to achieve automatic allocation of equipment, tooling and fixtures.

[0127] The custom component verification function module is used to implement logical verification of material process attribute parameters, equipment tool and tooling capability parameters, and process attribute comparison, and customize the rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of rules by configuring parameters; the custom build supports the rapid creation of rules, and secondary creation and execution of rules based on the material process attribute parameter fields and the equipment tool and tooling process attribute parameter fields;

[0128] The automatic adding of precautions function module is used to realize the automatic acquisition and update of material precautions, equipment, tooling precautions.

[0129] Embodiments of the present invention further disclose a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, performs the steps of the above-described method. Embodiments of the present invention also disclose a computer device comprising a memory and a processor, wherein the memory has a computer program stored thereon, which, when executed by the processor, performs the steps of the above-described method. The apparatus, medium, and system of the present invention correspond to the above-described method and similarly possess the advantages described for the above-described method.

[0130] In order to better understand the above technical solution, the above technical solution will be described in detail below with reference to the accompanying drawings and specific implementation methods.

[0131] like Figure 1As shown, after the software starts, it executes the process route acquisition function, automatically reading the current project information to obtain the current drawing number and process route number, and downloads the data to the cache. It then executes the process route verification function to ensure the integrity and validity of the process route data. The software then executes the bill of materials acquisition function and, after processing the BOM data, executes the automatic material allocation function and the automatic equipment, tooling, and fixture allocation function. After all materials, equipment, tools, and fixture data are allocated, the software executes the custom component verification function. This custom component verification function begins by acquiring rule data and operation logic based on the digital process platform. After the verification passes, the software executes the automatic note addition function, and the program ends after completion.

[0132] like Figure 2Specifically, after the software starts, it performs a version check, verifying the program path and package verification information against the software update repository on the server. After obtaining the program path, the software automatically accesses the program directory under the specified path and downloads the package. After the package is downloaded locally, the package verification is performed and the software is automatically updated. The program automatically reads the information of the current project to obtain the current drawing number and process route number, executes the query of the process route based on the product drawing number and process route number and downloads the data to the cache, and then executes the query of process route change and problem feedback information, and confirms the impact of changes and problems. If there is an impact, the change impact data analysis is performed to confirm whether to wait until the change is completed before executing further. If there is no impact or the data change is completed, the BOM data is obtained and downloaded to the cache, and then the BOM change and problem feedback information query is performed, and the change and problem impact confirmation is performed. If there is an impact, the change impact data analysis is performed to confirm whether to wait until the change is completed before executing further. If there is no impact or the data change is completed, the BOM data is processed, the material data under the physical part in the BOM is deleted, and the unnecessary fields in the BOM data are deleted. After the data processing is completed, a structured BOM is generated and the material process attributes in the structured BOM are queried from the database. The structured BOM is then matched with design files such as PCB / CAD to clarify the material position number / installation position information. After the information is obtained, the material matching relationship database is combined to execute the automatic allocation of materials to the process / step according to the logic, and the material data is dynamically calculated according to the material location, parent item information, etc. After the automatic allocation is completed, the material quantity is confirmed. If there are materials that have not been allocated, the remaining materials need to be manually allocated. After the material allocation is completed, the equipment, tools and fixtures are automatically allocated to the process / step according to the logic, and the program is automatically allocated to the process / step according to the logic according to the logic of the material, production line, process / step and equipment, tools and fixtures. Precautions are automatically obtained according to the logical relationship between production line materials, production lines, processes / steps and equipment, tools and fixtures. Standardized precautions information is obtained from the basic precautions library, and the data is processed (supplemented with specific data such as torque and angle) and duplicate precautions information is removed. Then the tool executes the custom component rule reading, reads the attributes and judgment logic information in the rule, and executes the rule parameter reading and configuration. After the configuration is completed, the rule logic operation is executed and checked whether it passes. If it fails, the error resource is manually adjusted. If it passes, the data is written to the database and the program ends.

[0133] The above are merely preferred embodiments of the present invention. The scope of protection of the present invention is not limited to the above embodiments. All technical solutions based on the principles of the present invention are within the scope of protection of the present invention. It should be noted that for those skilled in the art, various improvements and modifications that do not depart from the principles of the present invention should be considered within the scope of protection of the present invention.

Claims

1. A method for dynamic and automatic allocation of process resources based on a database and custom rules, characterized in that: Including steps: 1) Process route verification: obtain the process route and verify the process route version; 2) Automatic material allocation: Obtain material information, automatically allocate materials to the process or steps of the process route, and verify the material quantity and material combination relationship; 3) Automatic allocation of equipment, tools and tooling: Equipment, tools and tooling are selected based on the materials allocated to the process or step. The automatic allocation of equipment, tools and tooling is achieved by combining the relationship between the process route and the equipment, tools and tooling substitution relationship, and equipment, tools and tooling data; 4) Custom component verification: Implement logic verification of material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison, and customize rule component operation logic; 5) Automatically add notes: realize the automatic acquisition and update of material notes, equipment, tools and tooling notes; In step 2), the specific steps for verifying the material quantity and material combination relationship are: 2.1) Obtain the MBOM information of the current product drawing number, structure the data and store it in the database; 2.2) Query MBOM change information and problem feedback report information based on product drawing number; 2.3) Compare the obtained process route data version number with the queried change information and problem feedback information and provide comparison information; 2.4) Delete unnecessary data from MBOM data according to the specified logic; 2.5) Number and sort the processed MBOM according to the specified logic to form a structured BOM; 2.6) Query the specified material process attributes from the material process attribute library for the materials in the structured BOM in turn; 2.7) Compare the material with the design file, confirm the material's location attributes in the product and write them into the structured BOM; 2.8) The structured BOM is compared and matched with the process or step information in the process route according to the specified logic, and the qualified materials and their special supporting materials are attached to the current process or step; 2.9) Update quantity information in structured BOM; 2.10) Display the materials that have not been automatically hung and complete the hanging manually. After the hanging is completed, the process route containing the hanging information will be written into the cache.

2. The method for dynamic automatic allocation of process resources based on database and custom rules according to claim 1 is characterized in that: The specific steps for process route verification in step 1) are as follows: 1.1) Obtain the drawing number and process route number information of the current product; 1.2) Obtain the published process route based on the product drawing number and process route number; 1.3) Query process route change information and problem feedback report information based on the process route number; 1.4) Compare the obtained process route data version number with the queried change information and problem feedback information, and provide comparison information; 1.5) Restore the process route to a structure tree and display the process route; 1.6) The process route data is rewritten into the new database in a fixed format.

3. The method for dynamic automatic allocation of process resources based on database and custom rules according to claim 1 is characterized in that: In step 3), the corresponding material information and the material supporting library are obtained based on the design document to automatically allocate the materials to the process or step.

4. The method for dynamic automatic allocation of process resources based on database and custom rules according to claim 3 is characterized in that: The specific steps for automatic allocation of equipment, tools and fixtures in step 3) are as follows: 3.1) Obtain the process route containing hanging material information in the cache; 3.2) Based on the production line information in the process route, the corresponding equipment, tool and tool data information is filtered from the equipment, tool and tool library and loaded into the cache; 3.3) Compare the material information in the process with the equipment, tool and fixture information in the cache according to the specified logic; 3.4) List all equipment, tool, and fixture data for the current work step or process, and remove those with lower priority and that can be replaced according to the replacement relationship table; 3.5) Write the eliminated equipment, tool and fixture data into the current process or step; 3.6) Repeat steps 3.1) - 3.5); 3.7) Read the operating requirements and precautions of the equipment, tools and fixtures according to the resource coding information of the equipment, tools and fixtures in the process or work step and write them into the cache; 3.8) Record log information.

5. The method for dynamic automatic allocation of process resources based on database and custom rules according to claim 4 is characterized in that: The specific steps for custom component verification in step 4) are as follows: 4.1) The production line information, process or step information, material code and equipment tool resource code in the current process route and read the corresponding process attributes; 4.2) Read the verification rules, parse the process attribute keywords of materials, equipment, tools and fixtures in the verification rules, and establish an association with the actual process attributes; 4.3) Analyze the process attributes of materials and equipment tools and perform logical operations based on the logical symbols in the custom rules; 4.4) Identify materials, equipment, tools, and fixtures that do not meet custom rules, and adjust and optimize them based on the custom rule prompts; 4.5) Rewrite the data that meets the requirements into the database; 4.6) Repeat steps 4.2) to 4.4) during the verification process.

6. The method for dynamic automatic allocation of process resources based on database and custom rules according to claim 5 is characterized in that: The specific steps for automatically adding notes in step 5) are as follows: 5.1) Material process attributes and equipment, tooling, and operation requirements and precautions data in the database; 5.2) Search for corresponding precautions data from the process expert database based on the material code; 5.3) Search for corresponding precautions data from the process expert database based on the tool and fixture equipment resource code; 5.4) Compare and remove duplicates from the PFMEA in the current drawing number and write the obtained precautions information into the database.

7. A device for dynamically and automatically allocating process resources based on a database and custom rules, for executing the steps of the method according to any one of claims 1 to 6, characterized in that: include: The process route verification function module is used to obtain the process route and verify the process route version; The material automatic allocation function module is used to obtain material information, automatically allocate materials to the process or steps of the process route, and verify the material quantity and material combination relationship; The equipment, tooling and fixture automatic allocation function module is used to select equipment, tooling and fixtures based on materials allocated to processes or work steps. It also combines the relationship between process routes and equipment, tooling and fixtures, the equipment, tooling and fixtures substitution relationship, and equipment, tooling and fixtures data to achieve automatic allocation of equipment, tooling and fixtures. The custom component verification function module is used to implement the logic verification of material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison, and customize the rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of the rule by configuring parameters; Custom build supports the rapid creation of rules, and secondary creation and execution of rules based on material process attribute parameter fields and equipment tool and fixture process attribute parameter fields; The automatic adding of precautions function module is used to realize the automatic acquisition and update of material precautions, equipment, tooling precautions.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the computer program performs the steps of the method according to any one of claims 1 to 6.

9. A computer device comprising a memory and a processor, wherein a computer program is stored in the memory, wherein: When the computer program is executed by a processor, the computer program performs the steps of the method according to any one of claims 1 to 6.

Images