Database and custom rule-based process resource dynamic automatic allocation method

Abstract

The invention discloses a process resource dynamic automatic allocation method based on a database and a user-defined rule. The method comprises the following steps: 1) process route verification: obtaining and verifying a process route; 2) material automatic distribution: obtaining material information and distributing the material information to a process / step, and verifying the material quantity and the material combination relationship; (3) automatic distribution of equipment tools and tools: selecting the equipment tools and tools on the basis of the materials distributed according to the working procedures / working steps to realize automatic distribution of the equipment tools and tools; 4) custom component verification: realizing material process attribute parameter, equipment tool capability parameter and process attribute comparison logic verification, and customizing rule component operation logic; and 5) automatically adding matters needing attention: realizing the functions of automatically acquiring and updating the matters needing attention of materials and equipment tools and tools. The method has the advantages of high distribution efficiency, high distribution precision and the like.

Description

Technical Field

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

[0002] The production and processing in the traditional automotive electronics, consumer electronics and other fields have basically realized the automation and even unmanned production process. The traditional process resource allocation requires engineers to manually allocate, such as allocating material data to the process / step one by one, and determining the specific equipment, tools and production procedures used in the corresponding process / step based on the equipment, tools and tooling ledger, and applying the corresponding data to the production control process to achieve timely and accurate material delivery to the production line station, improve production efficiency, and reduce production costs, material land costs, and management costs. Therefore, in the process of process design, allocating production resource data (materials, equipment, tools, production procedures, personnel qualifications, etc.) to the corresponding process route in advance and digitizing them is the basis for realizing the automation and even unmanned production process.

[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 view of the technical problems existing in the prior art, the present invention provides a method for dynamic and automatic allocation of 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 steps of:

[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 / step 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, and automatically allocate equipment, tools and tooling by combining the relationship between the process route and the equipment, tools and tooling, the equipment, tools and tooling substitution relationship, and the equipment, tools and tooling data;

[0010] 4) Custom component verification: realize the comparison logic verification of material process attribute parameters, equipment tool and tooling capacity parameters and process attributes, and customize the operation logic of rule components;

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

[0012] Preferably, the specific steps of the 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) Based on the product drawing number and process route number, obtain the published process route;

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

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

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

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

[0019] Preferably, in step 2), the specific steps of verifying the material quantity and material combination relationship are:

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

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

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

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

[0024] 2.5) The processed MBOM is numbered and sorted according to the specified logic to form a structured BOM;

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

[0026] 2.7) Compare the material with the design file, confirm the location attributes of the material in the product and write them 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 the quantity information in the 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 the 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 tool data information is selected from the equipment tool 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 process 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 tools according to the resource coding information of the equipment, tools and tools 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 relationship 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 and equipment tools that do not meet the custom rules, and adjust and optimize them according to 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 precautions in step 5) are:

[0048] 5.1) Material process attributes and equipment tooling 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 precautions information into the database.

[0052] The present invention also discloses a dynamic automatic allocation device for 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 / step of the process route, and verify the material quantity and material combination relationship;

[0055] The equipment tool and tooling automatic allocation function module is used to select equipment tools and tooling based on the materials allocated by the process / step, and to realize automatic allocation of equipment tools and tooling by combining the association relationship between the process route and the equipment tool and tooling, the equipment tool and tooling substitution relationship, and the equipment tool and tooling data;

[0056] The custom component verification function module is used to implement the material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison logic verification, and the custom rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of the 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 addition of precautions function module is used to realize the automatic acquisition and update functions of material precautions, equipment tool and tooling precautions.

[0058] The 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 method described above 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 the present invention mainly realizes the process route acquisition, process route version verification and process route change query function and the process route acquisition function. After acquisition, the process / step in the process route is structured according to logic and forms basic data. The process route is automatically acquired and structured for analysis, and resources are automatically matched with the process (process route) during process design to form the basis for automatic resource allocation, so as to ultimately realize automatic material distribution and logistics automation.

[0062] The automatic material allocation function of the present invention mainly realizes the automatic acquisition and processing of MBOM, the automatic allocation of materials on the process route, the MBOM quantity verification, and the material comparison function. The automatic allocation function of equipment, tools, fixtures and procedures mainly realizes the automatic acquisition, allocation and comparison of equipment, tools, fixtures and procedure data. The automatic allocation of materials and equipment, tools and fixtures is realized based on the structured process route to improve work efficiency.

[0063] The automatic adding of precautions function of the present invention mainly realizes the automatic acquisition and update of precautions for materials, equipment tools and tooling. The custom component verification function mainly realizes the functions of material process attribute parameters, equipment tool and tooling capacity parameters, process attribute comparison logic verification, etc. Based on the structured process route and its resources (materials, equipment tools and tooling), the operation instructions, parameter requirements and precautions in the processing process are automatically pushed.

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

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

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

[0067] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments.

[0068] like Figure 1-2 As shown, the method for dynamic and automatic allocation of process resources based on a database and custom rules according to an embodiment of the present invention comprises 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 / step 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, and automatically allocate equipment, tools and tooling by combining the relationship between the process route and the equipment, tools and tooling, the equipment, tools and tooling substitution relationship, and the equipment, tools and tooling data;

[0072] 4) Custom component verification: realize the comparison logic verification of material process attribute parameters, equipment tool and tooling capacity parameters and process attributes, and customize the operation logic of rule components;

[0073] 5) Automatically add precautions: realize the automatic acquisition and update functions of material precautions, equipment and 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 automatic acquisition and processing of MBOM, the automatic allocation of materials on the process route, the MBOM quantity verification, and the material comparison function.

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

[0083] Specifically, the material verification logic mainly verifies the material quantity and material combination relationship. For complex products, the same material exists in different sub-components. In this case, the material verification process should be able to accurately identify the different components to which the verified materials belong and calculate the corresponding quantity. At the same time, when there are multiple material combination relationships, it should be able to identify which relationship belongs to the same component to avoid the situation where the component under component A is used on component B. The specific work 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) The processed MBOM is numbered and sorted according to the specified logic to form a structured BOM;

[0089] 2.6) Query the specified material process attributes of the materials in the structured BOM from the material process attribute library 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 the quantity information in the structured BOM;

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

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

[0095] Specifically, the equipment, tools and tooling are selected based on the materials allocated to the process / step. At the same time, the equipment, tools and tooling are automatically allocated in combination with the relationship between the production line and the equipment, tools and tooling, the equipment, tools and tooling substitution relationship, and the equipment, tools and tooling in the system, and then passed to the APS (automatic planning and scheduling system) to 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 tool data information is selected from the equipment tool tool library and loaded into the cache;

[0098] 3.3) Compare the material information in the process with the equipment, tool 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 process 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 tools according to the resource coding information of the equipment, tools and tools 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 the functions of material process attribute parameters, equipment tool tooling capacity parameters, process attribute comparison logic verification, etc., and the custom rule component operation logic. The custom rule mainly sets the attributes of the definable rules in advance and associates them with the fields in the database, while limiting the rule logic (such as >, <, including =) and the combination logic of the rules (such as AND, OR), realizing multi-condition verification, avoiding errors in the allocation of materials, equipment tools and tooling, and working according to the following process:

[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 relationship 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 (such as >, ≤, or, ≠) in the custom rules;

[0108] 4.4) Identify materials and equipment tools that do not meet the custom rules, and adjust and optimize them according to 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 tool and tooling precautions, and works according to the following process:

[0112] 5.1) Material process attributes and equipment tooling 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 precautions information into the database.

[0116] The process route acquisition function of the present invention mainly realizes the process route acquisition, process route version verification and process route change query function and the process route acquisition function. After acquisition, the process / step in the process route is structured according to logic and forms basic data. The process route is automatically acquired and structured for analysis, and resources are automatically matched with the process (process route) during process design to form the basis for automatic resource allocation, so as to ultimately realize automatic material distribution and logistics automation.

[0117] The automatic material allocation function of the present invention mainly realizes the automatic acquisition and processing of MBOM, the automatic allocation of materials on the process route, the MBOM quantity verification, and the material comparison function. The automatic allocation function of equipment, tools, fixtures and procedures mainly realizes the automatic acquisition, allocation and comparison of equipment, tools, fixtures and procedure data. The automatic allocation of materials and equipment, tools and fixtures is realized based on the structured process route to improve work efficiency.

[0118] The automatic adding of precautions function of the present invention mainly realizes the automatic acquisition and update of precautions for materials, equipment tools and tooling. The custom component verification function mainly realizes the functions of material process attribute parameters, equipment tool and tooling capacity parameters, process attribute comparison logic verification, etc. Based on the structured process route and its resources (materials, equipment tools and tooling), the operation instructions, parameter requirements and precautions in the processing process are automatically pushed.

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

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

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

[0122] The tool method of the present invention has strong flexibility and is compatible with all types of products of 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 / step of the process route, and verify the material quantity and material combination relationship;

[0126] The equipment tool and tooling automatic allocation function module is used to select equipment tools and tooling based on the materials allocated by the process / step, and to realize automatic allocation of equipment tools and tooling by combining the association relationship between the process route and the equipment tool and tooling, the equipment tool and tooling substitution relationship, and the equipment tool and tooling data;

[0127] The custom component verification function module is used to implement the material process attribute parameters, equipment tool and tooling capability parameters and process attribute comparison logic verification, and the custom rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of the 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 addition of precautions function module is used to realize the automatic acquisition and update functions of material precautions, equipment tool and tooling precautions.

[0129] The embodiment of the present invention further discloses a computer-readable storage medium, on which a computer program is stored, and the computer program executes the steps of the above method when it is executed by a processor. The embodiment of the present invention also discloses a computer device, including a memory and a processor, on which a computer program is stored, and the computer program executes the steps of the above method when it is executed by the processor. The device, medium and system of the present invention correspond to the above method and also have the advantages described in the above method.

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

[0131] like Figure 1As shown, after the software starts, it executes the function of obtaining the process route, and the program automatically reads the information of the current project to obtain the current drawing number and process route number and downloads the data to the cache, and then executes the process route verification function to ensure that the process route data is complete and valid. The software then executes the function of obtaining the BOM, and after processing the BOM data, it executes the automatic material allocation function and the automatic equipment tool and fixture allocation function. After all materials, equipment tools and fixture data are allocated, the software executes the custom component verification function. The custom component verification function starts to execute the verification after obtaining the rule data and operation logic based on the digital process platform. After the verification passes, the software executes the automatic addition of precautions function. After the execution is completed, the program ends.

[0132] like Figure 2As shown, specifically, after the software starts, the software performs version verification, verifies with the software update library on the server to obtain the program path and package verification information. After obtaining the program path, the software automatically accesses the program report under the specified path and executes the download package action. After the program package is downloaded to the local, the package verification action is executed 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, queries the process route based on the product drawing number and process route number and downloads the data to the cache, then queries the process route change and problem feedback information, and confirms the impact of the change and the problem. If there is an impact, perform change impact data analysis to confirm whether to wait until the change is completed before executing further. If there is no impact or the data change is completed, obtain the BOM data and download the BOM data to the cache, then query the BOM change and problem feedback information, and confirm the impact of the change and the problem. If there is an impact, perform change impact data analysis to confirm whether to wait until the change is completed before executing further. If there is no impact or the data change is completed, perform BOM data processing, delete the material data under the actual part in the BOM and delete the unnecessary fields in the BOM data. 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. Then the structured BOM is 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 automatically allocate the material 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 relationship of materials, production lines, and processes / steps, and the program is automatically allocated to the process / step according to the logic; according to the logical relationship between production line materials, production lines, processes / steps and equipment, tools and fixtures, automatic acquisition of precautions is performed, standardized precautions information is obtained from the basic precautions library, and data is processed (specific data is supplemented, such as torque, angle) and repeated precautions information is removed. Then the tool executes custom component rule reading, reads the attributes and judgment logic information in the rules, and executes rule parameter reading and configuration. After the configuration is completed, the rule logic operation is executed and whether it passes the check. 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 only preferred embodiments of the present invention, and the protection scope of the present invention is not limited to the above embodiments. All technical solutions under the concept of the present invention belong to the protection scope of the present invention. It should be pointed out that for ordinary technicians in this technical field, some improvements and modifications without departing from the principle of the present invention should be regarded as the protection scope of the present invention.

Claims

1. A method for dynamic and automatic allocation of process resources based on database and custom rules, characterized in that: Includes 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 / step of the process route, and verify the material quantity and material combination relationship; 3) Automatic allocation of equipment, tools and tooling: Select equipment, tools and tooling based on the materials allocated to the process / step, and automatically allocate equipment, tools and tooling by combining the relationship between the process route and the equipment, tools and tooling, the equipment, tools and tooling substitution relationship, and the equipment, tools and tooling data; 4) Custom component verification: realize the comparison logic verification of material process attribute parameters, equipment tool and tooling capacity parameters and process attributes, and customize the operation logic of rule components; 5) Automatically add precautions: realize the automatic acquisition and update functions of material precautions, equipment and tooling precautions.

2. The method for dynamic and automatic allocation of process resources based on database and custom rules according to claim 1 is characterized in that: The specific steps of 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) Based on the product drawing number and process route number, obtain the published process route; 1.3) Query process route change information and problem feedback report information based on 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 and automatic allocation of process resources based on database and custom rules according to claim 2 is characterized in that: 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) The processed MBOM is numbered and sorted according to the specified logic to form a structured BOM; 2.6) Query the specified material process attributes of the materials in the structured BOM from the material process attribute library in turn; 2.7) Compare the material with the design file, confirm the location attributes of the material in the product and write them into the structured BOM; 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; 2.9) Update the quantity information in the 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.

4. The method for dynamic and automatic allocation of process resources based on database and custom rules according to claim 3 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 / step.

5. The method for dynamic and automatic allocation of process resources based on database and custom rules according to claim 4 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 the hanging material information in the cache; 3.2) Based on the production line information in the process route, the corresponding equipment tool tool data information is selected from the equipment tool 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 under the current process step / process, and remove equipment, tool and fixture data 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 / step; 3.6) Repeat steps 3.1) to 3.5); 3.7) Read the operation requirements and precautions of the equipment, tools and tools according to the resource coding information of the equipment, tools and tools in the process / step and write them into the cache; 3.8) Record log information.

6. The method for dynamic and automatic allocation of process resources based on database and custom rules according to claim 5 is characterized in that: The specific steps for custom component verification in step 4) are: 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; 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 relationship 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 and equipment tools that do not meet the custom rules, and adjust and optimize them according to 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.

7. The method for dynamic and automatic allocation of process resources based on database and custom rules according to claim 6 is characterized in that: The specific steps for automatically adding notes in step 5) are: 5.1) Material process attributes and equipment tooling 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 precautions information into the database.

8. A device for dynamically and automatically allocating process resources based on a database and custom rules, used to execute the steps of the method according to any one of claims 1 to 7, 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 / step of the process route, and verify the material quantity and material combination relationship; The equipment tool and tooling automatic allocation function module is used to select equipment tools and tooling based on the materials allocated by the process / step, and to realize automatic allocation of equipment tools and tooling by combining the association relationship between the process route and the equipment tool and tooling, the equipment tool and tooling substitution relationship, and the equipment tool and tooling data; The custom component verification function module is used to implement the material process attribute parameters, equipment tool and tooling capacity parameters and process attribute comparison logic verification, and the custom rule component operation logic; the custom component supports the decoupling of rules and parameters, and adjusts the operation value of the rules 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 addition of precautions function module is used to realize the automatic acquisition and update functions of material precautions, equipment tool and tooling precautions.

9. 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 7.

10. 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 7.

Images