Laboratory Business Processing Method and Device Based on Multi-System Integration

Abstract

The present invention provides a laboratory business processing method and device based on multi-system integration, including: obtaining the historical consumption of experimental consumables in historical experimental tasks according to the operations to be performed by each experimental device in the basic experimental tasks and the planned operation time of each experimental device; adjusting the planned consumption of experimental consumables in combination with the historical consumption of experimental consumables in historical experimental tasks to obtain the reference consumption of experimental consumables; if the inventory information does not meet the planned experimental devices or the reference consumption of various experimental consumables in any one of the basic experimental tasks, generating first pre-purchase information; if the inventory information does not meet the planned experimental devices or the planned consumption of various experimental consumables in any one of the advanced experimental tasks, generating second pre-purchase information; if the first ratio of the project funds meets the expenditure of the first pre-purchase information and the second ratio of the project funds meets the expenditure of the second pre-purchase information, generating a purchase form and sending it to the purchase audit system.

Description

Technical Field

[0001] The present invention relates to the field of laboratory management, and particularly to a method and device for laboratory business processing based on multi-system integration. Background Art

[0002] In the prior art, the procurement approval business and the financial reimbursement business usually require manual review and processing. The process of filling out procurement reports or financial reports not only consumes a large amount of time and is relatively cumbersome, but also involves various data in the report filling process, which requires the filler to check one by one, and there is a problem of easy filling errors. Moreover, a large number of approval operations are also likely to cause approval personnel to repeatedly process reports or miss processing reports, resulting in human factor errors in the approval business. In addition, the existing procurement approval business and financial reimbursement business mostly require manual approval or paper document submission, which is not conducive to preservation and subsequent audit review. Summary of the Invention

[0003] Based on this, the present invention provides a method and device for laboratory business processing based on multi-system integration. Combining with the robotic process automation system, procurement forms or reimbursement forms are generated according to laboratory experiment tasks, equipment status, and project funds, and are correspondingly sent to the procurement review system and the financial reimbursement system, which can greatly reduce the time-consuming of laboratory procurement applications or reimbursement applications and improve the efficiency of laboratory procurement management.

[0004] In the first aspect, a method for laboratory business processing based on multi-system integration is provided. The method is applied to a robotic process automation system, and the robotic process automation system is respectively communicatively connected to a laboratory material management system, a laboratory budget system, a procurement review system, and an experiment reservation system. The method for laboratory business processing based on multi-system integration includes the following steps:

[0005] Obtain an experiment task list sent by the experiment reservation system. The experiment task list includes at least one experiment task, and the experiment task includes the project to which the experiment belongs, at least one planned experiment device, at least one type of experimental consumable, the operations to be performed by each experimental device, the planned operation time of each experimental device, and the planned usage amount of various experimental consumables;

[0006] Divide the experiment tasks into a basic experiment task set and an advanced experiment task set according to the acceptance requirements of the project to which the experiment belongs;

[0007] According to the operations to be performed by each experimental device in the basic experiment task set and the planned operation time of each experimental device, obtain the historical usage amount of various experimental consumables in historical experiment tasks;

[0008] Adjust the planned usage amount of various experimental consumables in combination with the historical usage amount of various experimental consumables in the historical experiment tasks to obtain the reference usage amount of various experimental consumables;

[0009] Receive the inventory information fed back by the laboratory material management system;

[0010] If the inventory information does not meet the reference usage of the planned experimental equipment or various experimental consumables for any one of the basic experimental tasks, generate the first pre-purchase information;

[0011] If the inventory information does not meet the planned usage of the planned experimental equipment or various experimental consumables for any one of the advanced experimental tasks, generate the second pre-purchase information;

[0012] Receive the project funds corresponding to the experimental tasks one by one fed back by the laboratory budget system;

[0013] If the first ratio of the project funds meets the fund expenditure of the first pre-purchase information, and the second ratio of the project funds meets the fund expenditure of the second pre-purchase information, generate a purchase form and send it to the purchase audit system, where the first ratio of the project funds is higher than the second ratio.

[0014] Further, the inventory information includes at least one laboratory available experimental equipment, the available appointment time of the laboratory available experimental equipment, at least one kind of inventory consumables, and the inventory quantity of the inventory consumables;

[0015] If the inventory information does not meet the reference usage of the planned experimental equipment or various experimental consumables for any one of the basic experimental tasks, generate the first pre-purchase information, specifically:

[0016] If the laboratory available experimental equipment does not include the planned experimental equipment, or the available appointment time of the laboratory available experimental equipment exceeds the longest waiting period, generate the first equipment pre-purchase information;

[0017] If the inventory consumables do not include the experimental consumables, or the inventory quantity of the inventory consumables is less than the reference usage of the experimental consumables, generate the first consumable pre-purchase information;

[0018] Merge the first equipment pre-purchase information and the first consumable pre-purchase information to obtain the first pre-purchase information;

[0019] If the inventory information does not meet the planned usage of the planned experimental equipment or various experimental consumables for any one of the advanced experimental tasks, generate the second pre-purchase information, specifically:

[0020] If the laboratory available equipment does not include the planned experimental equipment, the historical purchase request times of the planned experimental equipment exceed the request threshold, and the predicted usage frequency of the planned experimental equipment exceeds the set threshold, generate the second equipment pre-purchase information;

[0021] If the inventory consumables do not include experimental consumables, or the inventory quantity of the inventory consumables is less than the planned usage quantity of the experimental consumables, generate second consumable pre-purchase information;

[0022] Merge the second equipment pre-purchase information and the second consumable pre-purchase information to obtain second pre-purchase information.

[0023] Further, if the available experimental equipment in the laboratory includes the planned experimental equipment, obtain the historical experimental yield rate of the planned experimental equipment;

[0024] If the historical experimental yield rate is lower than the equipment yield rate threshold, input the historical experimental information into the trained equipment monitoring model to obtain an experimental equipment maintenance work order or an experimental equipment spare parts replacement work order;

[0025] Generate a maintenance service purchase order according to the experimental equipment maintenance work order, and send the maintenance service purchase order to the procurement audit system;

[0026] Generate a spare parts replacement request according to the experimental equipment spare parts replacement work order. If the spare parts inventory information feedback by the laboratory material management system does not meet the spare parts replacement request, generate spare parts procurement information and send it to the procurement audit system.

[0027] Further, after generating the first consumable pre-purchase information and / or generating the second consumable pre-purchase information, it further includes:

[0028] Obtain the historical purchase records of the consumables to be purchased, where the consumables to be purchased include any one of the experimental consumables in the first consumable pre-purchase information and the second consumable pre-purchase information;

[0029] Count the historical delivery times in the historical purchase records of the consumables to be purchased, and obtain the reference delivery time of the consumables to be purchased according to the historical delivery times;

[0030] If the reference delivery time is less than the first time period, obtain the latest purchase time of the consumables to be purchased according to the appointment time of the experimental task and the average value of the historical delivery times;

[0031] If the reference delivery time is greater than the first time period and less than the second time period, obtain the latest purchase time of the consumables to be purchased according to the appointment time of the experimental task and the median value of the historical delivery times;

[0032] If the reference delivery time is greater than the second time period, obtain the latest purchase time of the consumables to be purchased according to the appointment time of the experimental task and the maximum value of the historical delivery times;

[0033] Where the first time period is less than the second time period.

[0034] Further, the laboratory business processing method based on multi-system integration further includes:

[0035] If the minimum historical delivery time of the experimental consumables in the first consumable pre-purchase information does not meet the appointment time of the experimental task, send cross-group consumable query information to the laboratory material management system;

[0036] If the cross-group consumable inventory feedback by the laboratory material management system meets the first consumable pre-purchase information, generate a consumable call request and send it to the management end of the laboratory material management system;

[0037] If the minimum historical delivery time of the experimental consumables in the second consumable pre-purchase information does not meet the appointment time of the experimental task, generate an experimental task schedule delay request in combination with the maximum historical delivery time of the experimental consumables, and send the experimental task schedule delay request to the experimental appointment system.

[0038] Further, after generating the first pre-purchase information and / or the second pre-purchase information, it further includes:

[0039] Obtain the historical purchase records of the assets to be purchased in the first pre-purchase information and / or the second pre-purchase information, the assets to be purchased include equipment to be purchased and consumables to be purchased, and the historical purchase records include historical planned delivery time and historical delivery time;

[0040] If the historical delivery time of the asset to be purchased is delayed relative to the historical planned delivery time, adjust the supplier trust value of the historical purchase record;

[0041] When the supplier trust value is lower than the first trust threshold, generate a supplier delivery warning prompt or a payment mode adjustment warning;

[0042] When the supplier trust value is lower than the second trust threshold, generate a supplier replacement prompt or a late fee prompt;

[0043] Wherein, the second trust threshold is lower than the first trust threshold.

[0044] Further, the laboratory business processing method based on multi-system integration further includes:

[0045] Obtain the trust degree of the equipment supplier or consumable supplier in the corresponding historical purchase record according to the yield rate of the historical experimental task;

[0046] If the trust degree of the equipment supplier or consumable supplier is lower than the third trust threshold, generate an equipment supplier or consumable supplier replacement prompt.

[0047] Further, the laboratory business processing method based on multi-system integration further includes:

[0048] If the reference delivery time of the consumables to be purchased is less than the first time period, send an inventory query request for the consumables to be purchased to the laboratory material management system;

[0049] If the inventory of the consumables to be purchased is less than the minimum inventory threshold, generate the third consumables pre-purchase information and send it to the procurement audit system;

[0050] If the reference delivery time of the consumables to be purchased is greater than the first time period and less than the second time period, obtain the predicted demand for the consumables to be purchased during the experiment reservation period, generate the fourth consumables pre-purchase information in combination with the predicted demand, and send it to the procurement audit system;

[0051] If the reference delivery time of the consumables to be purchased is greater than the second time period, obtain the predicted demand for the consumables to be purchased during the longest experiment reservation period, generate the fifth consumables pre-purchase information in combination with the predicted demand, and send it to the procurement audit system.

[0052] Furthermore, the laboratory business processing method based on multi-system integration further includes:

[0053] Obtain the historical purchase quantity and historical purchase unit price of the consumables to be purchased;

[0054] Input the historical purchase quantity, historical purchase unit price, historical supplier, real-time purchase quantity, real-time purchase unit price, and real-time supplier of the consumables to be purchased in the first pre-purchase information and the second pre-purchase information into the trained price prediction model to obtain the price trend of the consumables to be purchased within the preset period;

[0055] If the rising rate of the price trend of the consumables to be purchased is higher than the premium ratio threshold, increase the real-time purchase quantity of the consumables to be purchased in combination with the predicted demand for the consumables to be purchased during the longest experiment reservation period.

[0056] Furthermore, the laboratory business processing method based on multi-system integration further includes:

[0057] Send a query message to the laboratory material management system to obtain the historical purchase quantity of the consumables to be purchased and the corresponding validity information;

[0058] If the quantity of the consumables whose historical purchase quantity exceeds the set ratio exceeds the expiration date, adjust the planned usage or reference usage of the consumables to be purchased to the usage required for the experiment in combination with the usage required for the experiment corresponding to the consumables to be purchased.

[0059] Furthermore, the laboratory business processing method based on multi-system integration further includes:

[0060] Obtain the level information of the person in charge of the experimental task, and the level information of the person in charge includes the ordinary level and the highest level;

[0061] If the first proportion of the project funds does not meet the fund expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is the ordinary level, a project fund proportion adjustment request is sent to the laboratory budget system and the procurement audit system;

[0062] If the first proportion of the project funds does not meet the fund expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is the highest level, a project fund proportion adjustment instruction is sent to the laboratory budget system, and the adjusted project fund proportion is sent to the procurement audit system for update;

[0063] If the second proportion of the project funds does not meet the fund expenditure of the second pre-purchase information, and the level of the person in charge of the experimental task is the highest level, a budget increase request is sent to the laboratory budget system and the procurement audit system.

[0064] Furthermore, the laboratory service processing method based on multi-system integration further includes:

[0065] A historical experiment task yield query instruction is sent to the experiment reservation system, and the historical experiment task yield query instruction includes historical experimental equipment and historical operations performed by the historical experimental equipment;

[0066] If the frequency of the yield of the historical operations performed by any historical experimental equipment fed back by the experiment reservation system is lower than the equipment yield threshold and higher than the maintenance threshold, the historical maintenance record of the historical experimental equipment is obtained;

[0067] If the cumulative maintenance cost and cumulative maintenance duration of the historical maintenance record meet the scrapping standard, an experimental equipment scrapping request is generated and sent to the laboratory material management system.

[0068] Furthermore, the robotic process automation system is also connected to the information management system, and the laboratory service processing method based on multi-system integration further includes:

[0069] Combined with the inventory information of the laboratory material management system, equipment or consumable inspection reports sent by the information management system are received at a preset cycle;

[0070] According to the equipment or consumable inspection report, if the inspection report of any equipment or consumable in the inventory information fails the inspection, an equipment or consumable quality warning information is generated and sent to the laboratory material management system and the experiment reservation system,

[0071] wherein, the equipment or consumable inspection report is the same as the supplier and model of the equipment or consumable in the inventory information.

[0072] Further, the robotic process automation system is communicatively connected to the financial reimbursement system, and the method further includes:

[0073] Generating a reimbursement application instruction according to the procurement approval instruction and the procurement documents fed back by the procurement audit system;

[0074] If the reimbursement application instruction is consistent with the warehousing information of experimental equipment or experimental consumables fed back by the laboratory material management system, generating a reimbursement form according to the reimbursement application instruction and sending it to the financial reimbursement system.

[0075] In a second aspect, the present invention further provides a laboratory service processing device based on multi-system integration. The device is applied to a robotic process automation system, and the robotic process automation system is communicatively connected to a laboratory material management system, a laboratory budget system, a procurement audit system, and an experiment reservation system respectively. The laboratory service processing device based on multi-system integration includes the following steps:

[0076] An experiment task acquisition module, configured to acquire an experiment task list sent by the experiment reservation system. The experiment task list includes at least one experiment task, and the experiment task includes an experiment belonging project, at least one planned experiment equipment, at least one type of experimental consumable, operations to be performed by each experiment equipment, planned operation time of each experiment equipment, and planned usage amount of various experimental consumables;

[0077] An experiment task classification module, configured to divide the experiment tasks into a basic experiment task set and an advanced experiment task set according to the acceptance requirements of the experiment belonging project;

[0078] A historical data acquisition module, configured to acquire the historical usage amount of various experimental consumables in historical experiment tasks according to the operations to be performed by each experiment equipment in the basic experiment task set and the planned operation time of each experiment equipment;

[0079] A consumable usage amount adjustment module, configured to adjust the planned usage amount of various experimental consumables in combination with the historical usage amount of various experimental consumables in the historical experiment tasks to obtain the reference usage amount of various experimental consumables;

[0080] An inventory query module, configured to receive the inventory information fed back by the laboratory material management system;

[0081] A first information generation module, configured to generate first pre-purchase information if the inventory information does not meet the planned experiment equipment or the reference usage amount of various experimental consumables of any one of the experiment tasks in the basic experiment task;

[0082] A second information generation module, configured to generate second pre-purchase information if the inventory information does not meet the planned experiment equipment or the planned usage amount of various experimental consumables of any one of the experiment tasks in the advanced experiment task;

[0083] The funding query module is used to receive the project funds corresponding to the experimental tasks one by one from the laboratory budget system;

[0084] The procurement generation module is used to generate a procurement form and send it to the procurement audit system if the first ratio of the project funds meets the fund expenditure of the first pre-procurement information and the second ratio of the project funds meets the fund expenditure of the second pre-procurement information, wherein the first ratio of the project funds is higher than the second ratio.

[0085] Thirdly, the present invention also provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of any one of the laboratory business processing methods based on multi-system integration in the first aspect are realized.

[0086] Fourthly, the present invention also provides a computer device, including a memory and a processor. The memory stores a computer program. When the processor executes the computer program, it executes any one of the laboratory business processing methods based on multi-system integration in the first aspect.

[0087] The beneficial effects of adopting the above technical solutions are as follows: In this embodiment, the robotic process automation system is connected to the laboratory material management system, the laboratory budget system, the procurement audit system, the experiment reservation system, etc., and a procurement form or a reimbursement form is generated in combination with the actual operation situation of the laboratory, reducing a large amount of manual processing time and greatly improving the efficiency of generating reports; and before generating the procurement form or the reimbursement form, it is verified whether the project funds meet the application, improving the subsequent approval process of the reports. BRIEF DESCRIPTION OF THE DRAWINGS

[0088] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for use in the description of the embodiments or the prior art.

[0089] Figure 1 It is a schematic diagram of a laboratory business processing method based on multi-system integration in an embodiment of the present application;

[0090] Figure 2 It is a schematic diagram of a laboratory business processing device based on multi-system integration in an embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0091] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention. To describe the present invention in more detail, the method and device for laboratory business processing based on multi-system integration provided by the present invention will be specifically described below in conjunction with the accompanying drawings.

[0092] Unless otherwise defined, the technical terms or scientific terms used in the disclosure of this application should have the ordinary meaning understood by those of ordinary skill in the art to which the present invention belongs. The "first", "second" and similar terms used in the present invention do not denote any order, quantity or importance, but are only used to distinguish different components. Similarly, the terms such as "a", "one" or "the" do not denote a quantity limitation, but mean that there is at least one. The terms such as "including" or "comprising" mean that the elements or objects appearing before this term cover the elements or objects listed after this term and their equivalents, without excluding other elements or objects. The terms such as "connected" or "coupled" are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. The terms such as "upper", "lower", "left" and "right" are only used to represent relative positional relationships, and when the absolute position of the object being described changes, the relative positional relationship may also change accordingly.

[0093] The present invention provides a method for laboratory business processing based on multi-system integration. By combining with a robotic process automation system, a procurement form or a reimbursement form is generated according to laboratory experiment tasks, equipment status and project funds, and is correspondingly sent to a procurement audit system and a financial reimbursement system, which can greatly reduce the time-consuming of laboratory procurement applications or reimbursement applications and improve the efficiency of laboratory procurement management. Taking the application of this method to a terminal device as an example for illustration, in combination with the Figure 1 schematic diagram of the method for laboratory business processing based on multi-system integration shown.

[0094] The embodiments of the present application provide an application scenario of the method for laboratory business processing based on multi-system integration. This application scenario includes the terminal device provided in the embodiment. The terminal device includes, but is not limited to, a smart phone and a computer device, where the computer device may be at least one of devices such as a desktop computer, a portable computer, a laptop computer, a mainframe computer, and a tablet computer. The terminal device receives experiment tasks or equipment maintenance tasks, etc., generates a procurement form or a reimbursement form in combination with the specific consumable inventory, equipment status and project funds in the laboratory, and sends it to the procurement audit system or the financial reimbursement system. For the specific process, please refer to the embodiments of the method for laboratory business processing based on multi-system integration.

[0095] It should be noted that the robotic process automation system of this embodiment is a processor integrating artificial intelligence (AI), machine learning, and robotic process automation (RPA) functions. The robotic process automation system includes a processor and a database. The processor can automatically generate a corresponding procurement report based on the experimental task information sent by the experimental reservation system, the inventory information sent by the laboratory material management system, and the project fund budget sent by the laboratory budget system, and send it to the procurement review system. The database can store the historical experimental data fed back by laboratory equipment, experimental operators, or the laboratory management terminal, and call the historical experimental data when necessary. In addition, the database can also record the historical maintenance records of laboratory equipment or the yield of corresponding experimental tasks performed by experimental equipment.

[0096] The robotic process automation system of this embodiment is communicatively connected to the laboratory material management system, the laboratory budget system, the procurement review system, and the experimental reservation system respectively. Among them, the specific communication connection methods include, but are not limited to, serial connection, wireless connection, Bluetooth connection, etc.

[0097] The laboratory material management system is used to manage the existing experimental equipment and consumables in the laboratory and record them in the warehouse. The laboratory material management system includes a storage device, a processor, and an electronic tag. The electronic tag is used to record the inbound and outbound situations of the experimental equipment and consumables in the laboratory. The processor is used to modify the records of the experimental equipment in use, the experimental equipment not in use, the damaged experimental equipment, and the inventory records of the consumables in the laboratory according to the inbound and outbound situations of the experimental equipment and consumables, and send the above data to the storage device for subsequent query of the specific experimental equipment situation or the consumable inventory situation.

[0098] The laboratory budget system is used to manage the project budgets registered in the laboratory and record them in the warehouse. The laboratory budget system includes a processor and a storage device. The processor receives the available project funds budget sent by the user terminal or the administrator terminal, including but not limited to the total project budget, the project equipment budget, the project consumables budget, the project service budget, the project intellectual property budget, and the project personnel budget. It should be noted that the sum of the specific budgets within the project is equal to the total project budget. In principle, the specific budgets within the project cannot be called, but after being approved by the administrator terminal, the specific budgets within the project can be called and adjusted. Moreover, the processor also makes real-time adjustments to the total project budget and the specific budgets within the project according to the project reimbursement amount fed back by the financial reimbursement system, and sends them to the storage device for storage to facilitate subsequent query of the specific project budget.

[0099] The procurement review system is used to review the received procurement applications, including but not limited to whether the procurement applications meet the requirements of laboratory material management, whether the procurement applications meet the project budget, whether the procurement applications meet the laboratory or project requirements, and approve the procurement applications, and return the approval results to the robotic process automation system and the storage device.

[0100] The experiment reservation system is used to reserve the experiment tasks to be executed in the laboratory. This experiment reservation system is a part of the laboratory management system. The experiment reservation system includes a processor and a storage device. The processor receives the experiment tasks sent by the user side or the administrator side. The experiment tasks include but are not limited to the model of the experimental equipment to be used, the time of the experimental equipment to be used, the model of the experimental consumables required for the experiment, and the amount of the experimental consumables required for the experiment.

[0101] Furthermore, encrypted communication can be set between the robotic process automation system and the laboratory material management system, the laboratory budget system, and the procurement review system, including but not limited to encrypting the communication content using a preset encryption method, encrypting the communication content using the public key and private key methods, etc.

[0102] The following describes the steps of the laboratory business processing method based on multi-system integration applied to the robotic process automation system:

[0103] Step S101, obtain the experiment task list sent by the experiment reservation system. The experiment task list includes at least one experiment task. The experiment task includes the project to which the experiment belongs, at least one planned experimental equipment, at least one type of experimental consumable, the operations to be performed on each planned experimental equipment, the planned operation time of each experimental equipment, and the planned usage amount of various experimental consumables.

[0104] Specifically, the experiment reservation system receives the experiment tasks sent by each project in the laboratory and sorts several experiment tasks according to preset rules to generate an experiment task list. Among them, the preset rules for sorting the experiment tasks can be sorted from the nearest to the farthest according to the experiment task reservation start time, or sorted from the nearest to the farthest according to the time when the experiment task is sent to the experiment reservation system. The experiment task list contains multiple experiment tasks of the semiconductor laboratory, and even experiment tasks of multiple semiconductor laboratories. Each experiment task belongs to the same project or different projects.

[0105] Considering that the semiconductor experiment task may include multiple semiconductor experiment processes, the experiment task needs to record the planned experimental equipment to be used in this experiment task, the operations to be performed on each planned experimental equipment, the planned reservation operation time of each planned experimental equipment, and the types of experimental consumables used in supporting the planned experimental equipment and the planned usage amount of various experimental consumables.

[0106] When the robotic process automation system can identify the experimental equipment and consumables to be scheduled in the semiconductor laboratory at various time periods according to the specific experimental task content received.

[0107] Step S102: Divide the experimental tasks into a basic experimental task set and an advanced experimental task set according to the acceptance requirements of the project to which the experiment belongs.

[0108] Specifically, considering that the semiconductor laboratory mentioned in this embodiment has scientific research requirements, and considering the uncertainty of the results of scientific research projects, that is, there are basic acceptance criteria and advanced acceptance criteria for the projects that the semiconductor laboratory needs to execute. Most of the experimental tasks that meet the basic acceptance criteria of the project are improvements on existing experiments, and the historical experimental records have a certain predictability of results. However, the experimental tasks that further explore under the condition of the basic acceptance criteria of the project are mostly guided by tentativeness or experimentation, and may have partial or even most differences from the existing experiments, and the results of these advanced experimental tasks are difficult to predict. Therefore, in this embodiment, the experimental tasks can be divided into basic experimental tasks and advanced experimental tasks according to the comparison between the specific operation steps or experimental expectations of the experimental tasks and the acceptance requirements of the project to which they belong. Among them, the basic experimental tasks are used to meet the basic acceptance criteria of the project to which they belong, and the project can be concluded when it reaches the basic acceptance criteria; the advanced experimental tasks are used to meet the advanced acceptance criteria of the project to which they belong, and whether the advanced experimental tasks reach the advanced acceptance criteria does not affect the conclusion of the project.

[0109] Taking the semiconductor lithography project as an example, the basic acceptance criteria for this project are that the minimum line width of the pattern is 5 μm and the overlay error is controlled within 20%; the advanced acceptance criteria are that the minimum pattern is 3 μm and the overlay error is controlled within 10%. This project includes two experimental tasks. The experimental purpose of experimental task A is to obtain a micro-pattern with a minimum line width of 5 μm and an overlay error of less than 20%; the experimental purpose of experimental task B is to obtain a micro-pattern with a minimum line width of 3 μm and an overlay error of less than 10%. According to the comparison between the experimental purpose and the project acceptance criteria, experimental task A is divided into a basic experimental task, and experimental task B is divided into an advanced experimental task.

[0110] It should be noted that due to different project acceptance criteria, the same experimental task can be a basic experimental task in project A and an advanced experimental task in project B. The division of the basic experimental tasks and advanced experimental tasks in this embodiment is only determined according to the specific project acceptance criteria, and has nothing to do with the implementation difficulty or technical difficulty of the experimental tasks.

[0111] Step S103: Obtain the historical usage amounts of various experimental consumables in historical experimental tasks according to the operations to be performed by each experimental equipment in the basic experimental tasks.

[0112] Step S104, adjust the planned usage of various experimental consumables in combination with the historical usage of various experimental consumables in the historical experimental tasks to obtain the reference usage of various experimental consumables.

[0113] Among them, the operations to be performed by each experimental device include the specific operation steps to be performed and the duration of each operation step.

[0114] Regarding the characteristic that the basic experimental task is an improvement based on the existing experimental tasks, the data in the historical experimental tasks has high reference value. Specifically, the planned usage of various experimental consumables in the experimental tasks to be executed can be adjusted according to the historical usage of various experimental consumables in the historical experimental tasks. For example, at least one historical experimental task with the same operation is obtained according to the same operation steps and the same duration of the corresponding operation steps in the historical experimental tasks, and the planned usage of the experimental consumables in the experimental tasks is adjusted according to the average historical usage of various experimental consumables in the historical experimental tasks to obtain the reference usage of various experimental consumables.

[0115] Through the adjustment of the above steps, the influence of specific experimental devices or experimental environments on the usage of experimental consumables required for the same experimental operation steps can be overcome, so that the usage of experimental consumables can be more accurately grasped during the scheduling or procurement of experimental consumables.

[0116] Step S105, receive the inventory information fed back by the laboratory material management system.

[0117] Specifically, the inventory information includes at least one laboratory available experimental device, the available reservation time of the laboratory available experimental device, at least one kind of inventory consumables, and the inventory quantity of the inventory consumables.

[0118] It should be noted that the laboratory available experimental devices here not only include the experimental devices that are in the running state in the laboratory, but also include the experimental devices that are not in the running state, such as the experimental devices that can be used and not scrapped in the laboratory inventory. The available reservation time of the experimental devices in the running state is the idle time determined according to the schedule of the experimental reservation system, and the available reservation time of the experimental devices that are not in the running state can be determined by combining the installation time of the experimental devices.

[0119] Step S106, if the inventory information does not meet the planned experimental devices or the reference usage of various experimental consumables in any one of the experimental tasks in the basic experimental task, generate the first pre-purchase information.

[0120] Specifically, if the available experimental equipment in the laboratory does not include the planned experimental equipment, or the available reservation time of the available experimental equipment in the laboratory exceeds the maximum waiting period, generate the first equipment pre-purchase information. If the inventory consumables do not include the experimental consumables, or the inventory quantity of the inventory consumables is less than the reference usage quantity of the experimental consumables, generate the first consumables pre-purchase information. Merge the first equipment pre-purchase information and the first consumables pre-purchase information to obtain the first pre-purchase information.

[0121] It should be noted that the situation where the available reservation time of the available experimental equipment in the laboratory exceeds the maximum waiting period means that the experimental equipment is in a running state, but due to the excessive number of reserved experiments for the experimental equipment, the experimental tasks in the current time period cannot be reserved to execute the specific experimental task steps within the maximum waiting period, and it is easy to occur that the experimental tasks are not executed, affecting the acceptance and conclusion of the project. Here, the maximum waiting period can be the preset waiting limit for the experimental task schedule, or can be determined according to the acceptance time of the project to which the specific experimental task belongs. In this embodiment, the inventory quantity of the inventory consumables refers to the inventory quantity of the inventory consumables managed in the project to which the experimental task belongs, rather than the inventory quantity of the inventory consumables in the entire semiconductor laboratory.

[0122] Step S107, if the inventory information does not meet the planned experimental equipment or the planned usage quantity of various experimental consumables for any one of the advanced experimental tasks, generate the second pre-purchase information.

[0123] Specifically, if the available equipment in the laboratory does not include the planned experimental equipment, the historical purchase request times of the planned experimental equipment exceed the request threshold, and the predicted usage frequency of the planned experimental equipment exceeds the set threshold, generate the second equipment pre-purchase information; if the inventory consumables do not include the experimental consumables, or the inventory quantity of the inventory consumables is less than the planned usage quantity of the experimental consumables, generate the second consumables pre-purchase information; merge the second equipment pre-purchase information and the second consumables pre-purchase information to obtain the second pre-purchase information.

[0124] It should be noted that considering that the purchase of semiconductor experimental equipment is comprehensively considered in the long term, whether the advanced experimental tasks can be fully executed to achieve the expected effect does not affect the acceptance of the project, but only as an exploratory experiment. Then, in the case where there is a need for equipment purchase in such experimental tasks, it is necessary to jointly judge whether to purchase by combining the historical purchase request times and the predicted usage frequency of the experimental equipment in the subsequent experimental tasks. In this embodiment, the historical purchase request threshold can be set to 3 times, and the set threshold of the predicted usage frequency can be set to once every six months, etc., and can be adjusted according to the actual situation.

[0125] Step S108, receive the project funds corresponding to the experimental tasks feedback by the laboratory budget system.

[0126] Step S109, if the first proportion of the project funds meets the expenditure of the first pre-purchase information and the second proportion of the project funds meets the expenditure of the second pre-purchase information, generate a purchase form and send it to the purchase audit system, where the first proportion of the project funds is higher than the second proportion.

[0127] It should be noted that in the project funds, the basic experimental tasks and advanced experimental tasks can be divided according to a proportion. Considering that the project funds are mainly used to complete the basic necessary acceptance part of the project, therefore, the first proportion of the project funds for the basic experimental tasks needs to be higher than the second proportion of the project funds for the advanced experimental tasks.

[0128] In addition, the project funds feedback by the laboratory budget system should include the types of equipment that can be purchased for the project, the supplier restriction conditions for the equipment that can be purchased, the upper price limit for a single piece of equipment that can be purchased for the project, the types of consumables that can be purchased for the project, the supplier restriction conditions for the consumables that can be purchased, and the upper unit price limit for the consumables that can be purchased for the project. When the first pre-purchase information and the second pre-purchase information meet the above limit conditions and price upper limits, then generate a specific purchase form according to the pre-purchase information and send it to the purchase audit system. This setting can audit the purchase requests, avoid pre-purchase requests that do not comply with regulations or exceed the project budget from being sent to the purchase audit system, affecting the efficiency of the audit process, or improving the purchase approval efficiency of the audit staff.

[0129] The purchase form includes but is not limited to the equipment model to be purchased, the quantity of equipment to be purchased, the supplier information of the equipment to be purchased, the price of the equipment to be purchased, the pre-delivery date of the equipment to be purchased, the specifications of the consumables to be purchased, the quantity of consumables to be purchased, the supplier information of the consumables to be purchased, the price of the consumables to be purchased, and the pre-delivery date of the consumables to be purchased.

[0130] Based on the above embodiments, considering that the experimental equipment in the semiconductor laboratory is aging or the spare parts of the experimental equipment are prone to affecting the operation effect after long-term use, the laboratory business processing method based on multi-system integration of the present invention further includes the following steps:

[0131] Step S201, if the available experimental equipment in the laboratory includes the planned experimental equipment, obtain the historical experimental yield of the planned experimental equipment.

[0132] Among them, the historical experimental yield of the planned experimental equipment here can be obtained according to the feedback of the experimental personnel or the average or median of the historical experimental yield statistics by the experimental reservation system.

[0133] Step S202, if the historical experimental yield is lower than the equipment yield threshold, input the historical experimental information into the trained equipment monitoring model to obtain an experimental equipment maintenance work order or an experimental equipment spare parts replacement work order.

[0134] Specifically, the device monitoring model is trained using the historical experiment yield, maintenance records, and spare part replacement records of experimental devices of the same model and specification as the training set, so that the trained device monitoring model can predict damaged parts of the experimental device or spare parts that need to be replaced based on the historical experiment yield of the specific experimental device. The device monitoring model can be an LSTM model, a BERT model, or a neural network model.

[0135] Step S203: Generate a maintenance service purchase order based on the maintenance work order of the experimental device, and send the maintenance service purchase order to the procurement audit system.

[0136] Step S204: Generate a spare part replacement request based on the spare part replacement work order of the experimental device. If the spare part inventory information feedback by the laboratory material management system does not meet the spare part replacement request, generate spare part procurement information and send it to the procurement audit system.

[0137] In addition, in the case where the above device monitoring model fails to predict the damage of experimental device components or the need to replace spare parts, it is possible to further consider whether the historical experiment yield is related to the devices or consumables provided by the supplier, and make corresponding prompts, which specifically include the following steps:

[0138] Step S301: Obtain the trust level of the device supplier or consumable supplier in the corresponding historical procurement records based on the historical experiment yield.

[0139] Step S302: If the trust level of the device supplier or consumable supplier is lower than the third trust threshold, generate a replacement prompt for the device supplier or consumable supplier.

[0140] It should be noted that in this embodiment, each device supplier or consumable supplier has an initial trust level. When the historical experiment yield is lower than the preset yield threshold (for example, 50%), the initial trust level is reduced; when the number of times the historical experiment yield continuously exceeds the expected experiment task yield reaches the preset number of times (for example, the historical experiment yield of 10 consecutive times exceeds the expected experiment task yield), the initial trust level is increased. The trust level of the supplier is constantly changing, but when the trust level is lower than the third trust threshold, it indicates that there may be quality problems with the devices or consumables provided by the supplier. At this time, a replacement prompt for the device supplier or consumable supplier can be issued.

[0141] In addition, if the historical experiment task yield is lower than the device yield threshold for a long time, it indicates that the device may not meet the operating requirements. For this, the laboratory business processing method based on multi-system integration of the present invention further includes:

[0142] Step S401: Send a historical experiment task yield query instruction to the experiment reservation system. The historical experiment task yield query instruction includes the historical experimental equipment and the historical operations performed by the historical experimental equipment.

[0143] Step S402: If the frequency of the yield of the historical operations performed by any historical experimental equipment feedback by the experiment reservation system is lower than the equipment yield threshold and higher than the maintenance threshold, obtain the historical maintenance records of the historical experimental equipment.

[0144] Step S403: If the cumulative maintenance cost and the cumulative maintenance duration of the historical maintenance records meet the scrapping standard, generate an experimental equipment scrapping request and send it to the laboratory materials management system.

[0145] Furthermore, considering that the delivery time of consumables or equipment to be purchased will affect the progress of the experimental task, which may in turn affect the project acceptance and conclusion, and this problem is particularly obvious in the procurement process of consumables. Therefore, after generating the first consumable pre-purchase information and / or generating the second consumable pre-purchase information, the laboratory business processing method based on multi-system integration of the present invention further includes the following specific steps:

[0146] Step S501: Obtain the historical purchase records of the consumables to be purchased, where the consumables to be purchased include any one of the experimental consumables in the first consumable pre-purchase information and the second consumable pre-purchase information.

[0147] It should be noted that for the control of the delivery time in the consumable procurement process, the requirements for basic experimental tasks and advanced experimental tasks are the same. Therefore, the first consumable pre-purchase information and the second consumable pre-purchase information are uniformly discussed as the consumables to be purchased here.

[0148] Step S502: Statistically analyze the historical delivery times in the historical purchase records of the consumables to be purchased, and obtain the reference delivery time of the consumables to be purchased based on the historical delivery times.

[0149] It should be noted that the historical delivery time in the historical purchase records can be the average or median of the historical delivery times in multiple historical purchase records.

[0150] Step S503: If the reference delivery time is less than the first time period, obtain the latest purchase time of the consumables to be purchased based on the reservation time of the experimental task and the average historical delivery time.

[0151] Specifically, when the reference delivery time is less than the first time period, it indicates that the delivery time of the consumables is quite rapid and mostly early delivery. That is to say, there is no need to worry about the delay in the delivery of consumables during the procurement process of the consumables. Therefore, the latest procurement time of the consumables can be inferred forward based on the reservation time of the experimental task and the average value of the historical delivery time, and the procurement task can be initiated before the latest procurement time.

[0152] Step S504, if the reference delivery time is greater than the first time period and less than the second time period, obtain the latest procurement time of the consumables to be purchased according to the reservation time of the experimental task and the median value of the historical delivery time.

[0153] Specifically, when the reference delivery time is greater than the first time period and less than the second time period, it indicates that the delivery of the consumables can be achieved before the latest delivery deadline. In this case, to ensure that the experimental task can be carried out on time as scheduled, the latest procurement time of the consumables can be inferred forward based on the reservation time of the experimental task and the median value of the historical delivery time, and the procurement task can be initiated before the latest procurement time.

[0154] Step S505, if the reference delivery time is greater than the second time period, obtain the latest procurement time of the consumables to be purchased according to the reservation time of the experimental task and the maximum value of the historical delivery time. Among them, the first time period is less than the second time period.

[0155] Specifically, when the reference delivery time is greater than the second time period, it indicates that the delivery time of the consumables is mostly delayed. In this case, to ensure that the experimental task can be carried out on time as scheduled, it is necessary to infer forward the latest procurement time of the consumables based on the reservation time of the experimental task and the maximum value of the historical delivery time, and the procurement task can be initiated before the latest procurement time.

[0156] Furthermore, after determining the latest procurement time of the consumables to be purchased as described above, in combination with the procurement record information, if the record information of the consumables to be purchased cannot be retrieved after the latest procurement time of the consumables to be purchased, a procurement prompt message is generated to ensure that the consumables for the experimental task can be purchased in a timely manner.

[0157] Furthermore, for the situation where the above experimental consumables cannot meet the requirements for the experimental task to be carried out on time, the laboratory business processing method based on multi-system integration in this embodiment is provided with the following countermeasures:

[0158] Step S601, if the minimum value of the historical delivery time of the experimental consumables in the first consumable pre-purchase information does not meet the reservation time of the experimental task, send cross-group consumable query information to the laboratory material management system.

[0159] Step S602: If the cross-group consumable inventory feedback by the laboratory material management system meets the first consumable pre-purchase information, generate a consumable call request and send it to the management terminal of the laboratory material management system.

[0160] Considering that whether the basic experimental tasks can be carried out on time directly affects whether the project can be accepted and completed. In the case where the minimum value of the historical delivery time cannot meet the appointment time of the experimental tasks, to ensure that the basic experimental tasks can be carried out on time, a cross-group consumable query can be sent to the laboratory material management system to find out whether there are the same consumables in other projects or other laboratories that can be used for this experimental task. If there are the same consumables in other projects or other laboratories that can be used for this experimental task, generate a consumable call request for invocation. It should be noted that the existence of the same consumables in other projects or other laboratories that can be used for this experimental task means that the total inventory of this consumable in the project to which the experimental task belongs and the inventory of this consumable in other projects or other laboratories meet the reference usage of this consumable in this experimental task.

[0161] Step S603: If the minimum value of the historical delivery time of the experimental consumables in the second consumable pre-purchase information does not meet the appointment time of the experimental task, generate an experimental task schedule delay request in combination with the maximum value of the historical delivery time of the experimental consumables, and send the experimental task schedule delay request to the experimental appointment system.

[0162] Since whether the advanced experimental tasks can be carried out on time does not affect the acceptance and conclusion of the affiliated project, after the minimum value of the historical delivery time cannot meet the appointment time of the experimental task, the schedule of this experimental task can be postponed. To avoid that the postponed experimental task can be processed according to the postponed time, the schedule delay request should be based on the maximum value of the historical delivery time of the consumables as a reference.

[0163] In addition, whether the consumables or equipment can be delivered in time is an important reference value for the laboratory to screen suppliers. Therefore, the multi-system integration laboratory business processing method of this embodiment further includes the following steps:

[0164] Step S701: Obtain the historical purchase records of the assets to be purchased in the first pre-purchase information and / or the second pre-purchase information. The assets to be purchased include equipment to be purchased and consumables to be purchased, and the historical purchase records include historical planned delivery time and historical delivery time.

[0165] Step S702: If the historical delivery time of the assets to be purchased is postponed relative to the historical planned delivery time, adjust the supplier trust value of the historical purchase record.

[0166] Specifically, for the historical delivery time of the assets to be purchased in the historical purchase record being postponed relative to the historical planned delivery time, reduce the supplier trust value of this historical purchase record.

[0167] Step S703: When the supplier trust value is lower than the first trust threshold, generate a supplier delivery warning prompt or a payment mode adjustment warning.

[0168] Step S704: When the supplier trust value is lower than the second trust threshold, generate a supplier replacement prompt or a late fee prompt; wherein, the second trust threshold is lower than the first trust threshold.

[0169] In this embodiment, different processing methods can be adopted according to the different trust values caused by the supplier's delayed delivery.

[0170] In addition, the laboratory business processing method based on multi-system integration of the present invention can also adjust the procurement plan of consumables in combination with the reference delivery time of consumables, specifically:

[0171] Step S801: If the reference delivery time of the consumables to be purchased is less than the first time period, send an inventory query request for the consumables to be purchased to the laboratory material management system.

[0172] Step S802: If the inventory of the consumables to be purchased is less than the minimum inventory threshold, generate a third consumable pre-purchase information and send it to the procurement audit system.

[0173] Specifically, for the consumables to be purchased that can be delivered in advance (which can also be called consumables with a short delivery cycle), there is no need to worry about whether the consumables can be delivered in time, and specific procurement information can be generated in combination with the prompt of whether the inventory is less than the minimum inventory threshold.

[0174] Step S803: If the reference delivery time of the consumables to be purchased is greater than the first time period and less than the second time period, obtain the predicted demand for the consumables to be purchased within the experiment reservation period, and generate a fourth consumable pre-purchase information in combination with the predicted demand and send it to the procurement audit system.

[0175] Specifically, for the consumables to be purchased that need to be delivered before the latest delivery deadline, in order to reduce the potential hidden danger of delayed delivery, the demand for the consumables to be purchased can be predicted in combination with the experiment reservation period (such as one week or one month, etc.), and pre-purchase information can be generated in combination with the predicted demand.

[0176] Step S804: If the reference delivery time of the consumables to be purchased is greater than the second time period, obtain the predicted demand for the consumables to be purchased within the longest experiment reservation period, and generate a fifth consumable pre-purchase information in combination with the predicted demand and send it to the procurement audit system.

[0177] Specifically, for the consumables to be purchased with delayed delivery, in order to reduce the potential risks caused by the delayed delivery, the experimental reservation period (such as two months, three months, etc.) can be extended to predict the demand for such consumables, and the pre-purchase information can be deployed in advance.

[0178] In addition, considering that the price of consumables is not constant, to control the full utilization of project funds, the laboratory business processing method based on multi-system integration of the present invention further includes:

[0179] Step S901, obtaining the historical purchase quantity and historical purchase unit price of the consumables to be purchased.

[0180] Step S902, inputting the historical purchase quantity, historical purchase unit price, historical supplier, real-time purchase quantity, real-time purchase unit price, and real-time supplier of the consumables to be purchased in the first pre-purchase information and the second pre-purchase information into the trained price prediction model to obtain the price trend of the consumables to be purchased within a preset period.

[0181] Step S903, if the price increase rate of the consumables to be purchased is higher than the premium rate threshold, combine the predicted demand for the consumables to be purchased within the longest experimental reservation period and increase the real-time purchase quantity of the consumables to be purchased.

[0182] Specifically, predict the price of the consumables to be purchased in combination with historical data. If it is found that the price trend of the consumables is higher than the premium rate threshold, such as a large increase in the price of the consumables in a short period of time, the real-time purchase quantity of the consumables in the current purchase form can be increased in combination with the predicted demand for the consumables within the longest experimental reservation period to reduce the impact of the large price increase on the completion of the experimental tasks.

[0183] Furthermore, considering that some consumables are prone to expiration when stored for a long time, the laboratory business processing method based on multi-system integration of the present invention further includes:

[0184] Step S1001, sending a query message to the laboratory material management system to obtain the historical purchase quantity of the consumables to be purchased and the corresponding validity information. Among them, the validity period information includes within the shelf life and exceeding the validity period.

[0185] Step S1002, if the quantity of the consumables to be purchased that exceeds the set proportion in the historical purchase quantity exceeds the validity period, combine the required quantity for the experiment corresponding to the consumables to be purchased, and adjust the planned quantity or reference quantity of the consumables to be purchased to the required quantity for the experiment.

[0186] It should be noted that in this embodiment, a small amount of expiration is allowed for the historical purchase volume of consumables. However, when the consumable volume exceeding the set ratio in the historical purchase volume exceeds the expiration date, it indicates that the historical purchase volume is unreasonable. Therefore, it is necessary to adjust it in combination with the required usage of the experiment. Through the above technical means, it is possible to further ensure that the consumable volume to be purchased is more in line with the specific consumable usage situation in the laboratory, avoid unnecessary waste of consumables, and also improve the effective utilization rate of project funds.

[0187] Furthermore, different levels of the person in charge corresponding to the experimental task may lead to different situations of schedulable resources or funds for the experimental task. In this regard, the laboratory service processing method based on multi-system integration of the present invention further includes the following steps:

[0188] Step S1101, obtain the level information of the person in charge of the experimental task, and the level information of the person in charge includes the ordinary level and the highest level.

[0189] Step S1102, if the first ratio of the project funds does not meet the fund expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is the ordinary level, send a project fund ratio adjustment request to the laboratory budget system and the procurement audit system.

[0190] Step S1103, if the first ratio of the project funds does not meet the fund expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is the highest level, send a project fund ratio adjustment instruction to the laboratory budget system, and send the adjusted project fund ratio to the procurement audit system for update.

[0191] Step S1104, if the second ratio of the project funds does not meet the fund expenditure of the second pre-purchase information, and the level of the person in charge of the experimental task is the highest level, send a budget increase request to the laboratory budget system and the procurement audit system.

[0192] Among them, the level information of the person in charge can be divided according to the position held by the person in charge in the project to which the experimental task belongs. The project principal person in charge is at the highest level and can directly adjust the ratio of the project funds; the project participants are at the ordinary level. When the fund expenditure of the pre-purchase information of the basic experimental task cannot be met, a corresponding project fund ratio adjustment request is initiated, and the specific project fund ratio is adjusted by the project fund administrator.

[0193] In addition, considering that the quality information of equipment or consumables can be reflected in public inspection reports, the above-mentioned robotic process automation system is also connected to an information management system. The information management system controls the quality of existing equipment or consumables in the laboratory by sorting out publicly available information on the network or regularly obtaining detection information of experimental equipment or experimental consumables from a specific database. The laboratory business processing method based on multi-system integration of the present invention further includes:

[0194] Step S1201: Combine the inventory information of the laboratory material management system and receive the inspection reports of equipment or consumables sent by the information management system at a preset cycle.

[0195] Step S1202: According to the inspection report of the equipment or consumables, if the inspection report of any piece of equipment or consumable in the inventory information fails the inspection, generate a quality warning message for the equipment or consumables and send it to the laboratory material management system and the experiment reservation system;

[0196] Among them, the inspection report of the equipment or consumables is the same as the supplier and model of the equipment or consumables in the inventory information.

[0197] Furthermore, the above-mentioned robotic process automation system is communicatively connected to a financial reimbursement system, and the method further includes:

[0198] Step S1301: Generate a reimbursement application instruction according to the procurement approval instruction and the procurement documents fed back by the procurement audit system.

[0199] Step S1302: If the reimbursement application instruction is consistent with the warehousing information of experimental equipment or experimental consumables fed back by the laboratory material management system, generate a reimbursement form according to the reimbursement application instruction and send it to the financial reimbursement system.

[0200] It should be understood that although each step in the attached Figure 1 flowchart is shown in sequence according to the arrow indication, these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise clearly stated in this article, the execution of these steps has no strict order limit, and these steps can be executed in other orders. Moreover, Figure 1 at least a part of the steps in the attachment may include multiple sub-steps or sub-phases. These sub-steps or phases are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or phases is not necessarily sequential, but can be executed alternately or in turn with at least a part of other steps or sub-steps or phases of other steps.

[0201] In the above-described embodiments disclosed by the present invention, a laboratory business processing method based on multi-system integration is described in detail. The above method disclosed by the present invention can be implemented by various forms of devices. Therefore, the present invention also discloses a laboratory business processing device based on multi-system integration. The device is applied to a robotic process automation system, and the robotic process automation system is respectively communicatively connected to a laboratory material management system, a laboratory budget system, a procurement review system, and an experiment reservation system. Combining the attached Figure 2 , specific embodiments are given below for detailed description.

[0202] An experiment task acquisition module 1401 is configured to acquire an experiment task list sent by an experiment reservation system. The experiment task list includes at least one experiment task, and the experiment task includes an experiment belonging project, at least one planned experiment device, at least one type of experiment consumables, operations to be performed by each experiment device, planned operation times of each experiment device, and planned usage amounts of various experiment consumables.

[0203] An experiment task classification module 1402 is configured to divide the experiment tasks into a basic experiment task set and an advanced experiment task set according to the acceptance requirements of the experiment belonging project.

[0204] A historical data acquisition module 1403 is configured to acquire historical usage amounts of various experiment consumables in historical experiment tasks according to the operations to be performed by each experiment device in the basic experiment task set and the planned operation times of each experiment device.

[0205] A consumable usage adjustment module 1404 is configured to adjust the planned usage amounts of various experiment consumables in combination with the historical usage amounts of various experiment consumables in the historical experiment tasks to obtain reference usage amounts of various experiment consumables.

[0206] An inventory query module 1405 is configured to receive inventory information fed back by a laboratory material management system.

[0207] A first information generation module 1406 is configured to generate first pre-purchase information if the inventory information does not meet the planned experiment devices or reference usage amounts of various experiment consumables of any one of the experiment tasks in the basic experiment tasks.

[0208] A second information generation module 1407 is configured to generate second pre-purchase information if the inventory information does not meet the planned experiment devices or planned usage amounts of various experiment consumables of any one of the experiment tasks in the advanced experiment tasks.

[0209] A funds query module 1408 is configured to receive project funds corresponding one-to-one to the experiment tasks fed back by a laboratory budget system.

[0210] A procurement generation module 1409, configured to generate a procurement form and send it to a procurement review system if the first ratio of the project funds meets the fund expenditure of the first pre-procurement information and the second ratio of the project funds meets the fund expenditure of the second pre-procurement information, wherein the first ratio of the project funds is higher than the second ratio. For the laboratory service processing device based on multi-system integration, all can refer to the above limitations on the method and will not be elaborated here. Each module in the above device can be implemented in whole or in part by software, hardware, and their combination. The above modules can be embedded in the processor of the terminal device in hardware form or independent of it, or stored in the memory of the terminal device in software form for the processor to call and execute the operations corresponding to the above modules.

[0211] In one embodiment, the present invention also provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the above-mentioned laboratory service processing method based on multi-system integration are implemented.

[0212] The computer-readable storage medium can be an electronic memory such as a flash memory, EEPROM (Electrically Erasable Programmable Read-Only Memory), EPROM (Erasable Programmable Read-Only Memory), a hard disk, or a ROM. Optionally, the computer-readable storage medium includes a non-transitory computer-readable storage medium. The computer-readable storage medium has a storage space for program codes for executing any method steps in the above method. These program codes can be read out from or written into one or more computer program products, and the program codes can be compressed in an appropriate form.

[0213] In one embodiment, the present invention provides a computer device, including a memory and a processor, where the memory stores a computer program, and when the processor executes the computer program, it executes the above-mentioned laboratory service processing method based on multi-system integration.

[0214] The computer device includes a memory, a processor, and one or more computer programs, where one or more computer programs can be stored in the memory and configured to be executed by one or more processors, and one or more application programs are configured to execute the above-mentioned laboratory service processing method based on multi-system integration.

[0215] The processor may include one or more processing cores. The processor utilizes various interfaces and circuits to connect various parts within the entire computer device. By running or executing instructions, programs, code sets, or instruction sets stored in the memory, and by invoking data stored in the memory, it performs various functions of the computer device and processes data. Optionally, the processor may be implemented in at least one of the hardware forms of digital signal processing (DSP), field-programmable gate array (FPGA), and programmable logic array (PLA). The processor may integrate one or a combination of several of the central processing unit (CPU), the reporting validator for buried point data (Graphics Processing Unit, GPU), and the modem, etc. Among them, the CPU mainly processes the operating system, user interface, application programs, etc.; the GPU is responsible for rendering and drawing the display content; the modem is used to process wireless communication. It can be understood that the above-mentioned modem may not be integrated into the processor and can be implemented separately through a communication chip.

[0216] The memory may include random access memory (RAM) and may also include read-only memory. The memory can be used to store instructions, programs, code, code sets, or instruction sets. The memory may include a program storage area and a data storage area. Among them, the program storage area may store instructions for implementing the operating system, instructions for implementing at least one function (such as touch function, sound playback function, image playback function, etc.), instructions for implementing the above-mentioned various method embodiments, etc. The data storage area may also store data created during the use of the terminal device.

[0217] The above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments or perform equivalent replacements for some of the technical features; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A laboratory business processing method based on multi-system integration, characterized in that: The method is applied to a robotic process automation system, which is respectively connected to a laboratory material management system, a laboratory budget system, a procurement review system, and an experiment reservation system. The laboratory business processing method based on multi-system integration includes the following steps: Obtaining an experiment task list sent by the experiment reservation system, the experiment task list including at least one experiment task, the experiment task including the project to which the experiment belongs, at least one planned experiment equipment, at least one experiment consumable, operations to be performed by each planned experiment equipment, the scheduled operation time of each planned experiment equipment, and the planned usage of various experiment consumables; According to the acceptance requirements of the project to which the experiment belongs, the experimental tasks are divided into basic experimental tasks and advanced experimental tasks. The basic experimental tasks are used to meet the basic acceptance standards of the project to which they belong. The project can be concluded when the basic acceptance standards are met; the advanced experimental tasks are used to meet the advanced acceptance standards of the project to which they belong. Whether the advanced experimental tasks meet the advanced acceptance standards does not affect the conclusion of the project; According to the operations to be performed by each experimental device in the basic experimental task and the planned operation time of each experimental device, the historical usage of various experimental consumables in the historical experimental task is obtained; Adjust the planned usage of various experimental consumables in combination with the historical usage of various experimental consumables in the historical experimental tasks to obtain reference usage of various experimental consumables; Receive inventory information fed back by the laboratory material management system; If the inventory information does not meet the reference usage of planned experimental equipment or various experimental consumables for any experimental task in the basic experimental task, generate first pre-purchase information; If the inventory information does not meet the planned usage of experimental equipment or various experimental consumables for any experimental task in the advanced experimental task, generate second pre-purchase information; Receive project funds that correspond to experimental tasks in a one-to-one manner from the laboratory budget system; If the first proportion of the project funds meets the expenditure of the first pre-purchase information, and the second proportion of the project funds meets the expenditure of the second pre-purchase information, a procurement form is generated and sent to the procurement review system, wherein the first proportion of the project funds is higher than the second proportion; The inventory information includes at least one laboratory available experimental equipment, the available reservation time of the laboratory available experimental equipment, at least one inventory consumable and the inventory quantity of the inventory consumable; If the inventory information does not meet the reference usage of the computational experimental equipment or various experimental consumables of any experimental task in the basic experimental task, the first pre-purchase information is generated, including: If the inventory consumables do not include experimental consumables, or the inventory quantity of the inventory consumables is less than the reference quantity of experimental consumables, generating first consumables pre-purchase information; If the inventory information does not meet the planned usage of experimental equipment or various experimental consumables for any experimental task in the advanced experimental task, the second pre-purchase information is generated, including: If the inventory consumables do not include experimental consumables, or the inventory of the inventory consumables is less than the planned usage of experimental consumables, generating second consumables pre-purchase information; If the minimum historical delivery time of the experimental consumables in the first consumables pre-purchase information does not meet the appointment time of the experimental task, sending cross-group consumables query information to the laboratory material management system; If the cross-group consumables inventory fed back by the laboratory material management system meets the first consumables pre-purchase information, a consumables call request is generated and sent to the management end of the laboratory material management system; If the minimum historical delivery time of the experimental consumables in the second consumables pre-purchase information does not meet the appointment time of the experimental task, a request for postponing the experimental task scheduling is generated in combination with the maximum historical delivery time of the experimental consumables, and the request for postponing the experimental task scheduling is sent to the experimental appointment system.

2. The laboratory business processing method based on multi-system integration according to claim 1 is characterized in that: If the inventory information does not meet the reference usage of the planned experimental equipment or various experimental consumables for any experimental task in the basic experimental task, generating the first pre-purchase information also includes: If the experimental equipment available in the laboratory does not include the planned experimental equipment, or the available time for booking the experimental equipment available in the laboratory exceeds the maximum waiting period, generating first equipment pre-purchase information; Combining the first equipment pre-purchase information and the first consumables pre-purchase information to obtain first pre-purchase information; If the inventory information does not meet the planned usage of experimental equipment or various experimental consumables for any experimental task in the advanced experimental task, the second pre-purchase information is generated, which also includes: If the laboratory available equipment does not include the planned experimental equipment, the number of historical purchase requests for the planned experimental equipment exceeds the request threshold, and the predicted usage frequency of the planned experimental equipment exceeds the set threshold, generating second equipment pre-purchase information; The second equipment pre-purchase information and the second consumables pre-purchase information are combined to obtain the second pre-purchase information.

3. The laboratory business processing method based on multi-system integration according to claim 2 is characterized in that: Also includes: If the available experimental equipment in the laboratory includes the planned experimental equipment, obtaining the historical experimental yield of the planned experimental equipment; If the historical experimental yield is lower than the equipment yield threshold, the historical experimental information is input into the trained equipment monitoring model to obtain an experimental equipment maintenance work order or an experimental equipment spare part / spare parts replacement work order; Generate a maintenance service purchase order based on the experimental equipment maintenance work order, and send the maintenance service purchase order to the procurement review system; A spare parts replacement request is generated based on the experimental equipment spare parts replacement work order. If the spare parts inventory information fed back by the laboratory material management system does not meet the spare parts replacement request, spare parts procurement information is generated and sent to the procurement review system.

4. The laboratory business processing method based on multi-system integration according to claim 3 is characterized in that: After generating the first consumables pre-purchase information and / or generating the second consumables pre-purchase information, the method further includes: Acquire historical purchase records of consumables to be purchased, wherein the consumables to be purchased include any one of the experimental consumables in the first consumable pre-purchase information and the second consumable pre-purchase information; Counting historical delivery times in historical purchase records of the consumables to be purchased, and obtaining reference delivery times of the consumables to be purchased based on the historical delivery times; If the reference delivery time is less than the first time period, the latest purchase time of the consumables to be purchased is obtained according to the reservation time of the experimental task and the average of the historical delivery time; If the reference delivery time is greater than the first time period, and the reference delivery time is less than the second time period, the latest purchase time of the consumables to be purchased is obtained according to the appointment time of the experimental task and the median value of the historical delivery time; If the reference delivery time is greater than the second time period, the latest purchase time of the consumables to be purchased is obtained according to the maximum value of the reservation time of the experimental task and the historical delivery time; The first time period is shorter than the second time period.

5. The laboratory business processing method based on multi-system integration according to claim 1 is characterized in that: After the first pre-purchase information and / or the second pre-purchase information is generated, the method further includes: Acquire historical purchase records of the assets to be purchased in the first pre-purchase information and / or the second pre-purchase information, wherein the assets to be purchased include equipment to be purchased and consumables to be purchased, and the historical purchase records include historical planned delivery time and historical delivery time; If the historical delivery time of the asset to be purchased is delayed relative to the historical planned delivery time, the supplier trust value of the historical purchase record is adjusted; When the supplier trust value is lower than a first trust threshold, generating a supplier delivery warning or a payment mode adjustment warning; When the supplier trust value is lower than a second trust threshold, generating a supplier replacement reminder or a late payment fee reminder; The second trust threshold is lower than the first trust threshold.

6. The laboratory business processing method based on multi-system integration according to claim 5 is characterized in that: Also includes: Obtain the trustworthiness of equipment suppliers or consumables suppliers in the corresponding historical procurement records based on historical experimental yields; If the trust level of the equipment supplier or consumables supplier is lower than a third trust threshold, a reminder to replace the equipment supplier or consumables supplier is generated.

7. The laboratory business processing method based on multi-system integration according to claim 4 is characterized in that: Also includes: If the reference delivery time of the consumables to be purchased is less than the first time period, sending an inventory query request for the consumables to be purchased to the laboratory material management system; If the inventory of the consumables to be purchased is less than the minimum inventory threshold, generating third consumables pre-purchase information and sending it to the purchase review system; If the reference delivery time of the consumables to be purchased is greater than the first time period, and the reference delivery time is less than the second time period, the predicted demand for the consumables to be purchased within the experiment reservation period is obtained, and the fourth consumables pre-purchase information is generated in combination with the predicted demand, and sent to the procurement review system; If the reference delivery time of the consumables to be purchased is greater than the second time period, the predicted demand for the consumables to be purchased within the longest experiment reservation period is obtained, and the fifth consumables pre-purchase information is generated based on the predicted demand and sent to the procurement review system.

8. The laboratory business processing method based on multi-system integration according to claim 7 is characterized in that: Also includes: Obtain the historical purchase quantity and unit price of the consumables to be purchased; Input the historical purchase quantity, historical purchase unit price, historical supplier, the real-time purchase quantity, real-time purchase unit price and real-time supplier of the consumables to be purchased in the first pre-purchase information and the second pre-purchase information into the trained price prediction model to obtain the price trend of the consumables to be purchased within a preset period; If the price trend increase rate of the consumables to be purchased is higher than the premium rate threshold, the real-time purchase quantity of the consumables to be purchased is increased in combination with the predicted demand for the consumables to be purchased within the longest experiment reservation period.

9. The laboratory business processing method based on multi-system integration according to claim 8, characterized in that: Also includes: Send query information to the laboratory material management system to obtain the historical purchase volume and corresponding validity information of the consumables to be purchased; If the amount of consumables in the historical purchase volume of the consumables to be purchased that exceeds the set proportion exceeds the validity period, the planned amount or reference amount of the consumables to be purchased is adjusted to the amount required for the experiment based on the amount required for the experiment corresponding to the consumables to be purchased.

10. The laboratory business processing method based on multi-system integration according to claim 9, characterized in that: Also includes: Obtain the level information of the person in charge of the experimental task, which includes the ordinary level and the highest level; If the first proportion of the project funds does not meet the expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is ordinary, a request for adjusting the proportion of project funds is sent to the laboratory budget system and the purchase review system; If the first proportion of the project funds does not meet the expenditure of the first pre-purchase information, and the level of the person in charge of the experimental task is the highest level, a project fund proportion adjustment instruction is sent to the laboratory budget system, and the adjusted project fund proportion is sent to the procurement review system for updating; If the second proportion of the project funds does not meet the funding expenditure of the second pre-purchase information, and the level of the person in charge of the experimental task is the highest level, a budget increase request is sent to the laboratory budget system and the procurement review system.

11. The laboratory business processing method based on multi-system integration according to claim 10, characterized in that: Also includes: Sending a historical experiment task yield query instruction to the experiment reservation system, wherein the historical experiment task yield query instruction includes historical experiment equipment and historical operations performed by the historical experiment equipment; If the experiment reservation system reports that the yield of historical operations performed by any historical experimental equipment is lower than the equipment yield threshold and the frequency is higher than the maintenance threshold, the historical maintenance record of the historical experimental equipment is obtained; If the accumulated maintenance cost and accumulated maintenance time of the historical maintenance records meet the scrapping standard, a laboratory equipment scrapping request is generated and sent to the laboratory material management system.

12. The laboratory business processing method based on multi-system integration according to claim 1, characterized in that: The robotic process automation system is also connected to the information management system, and the laboratory business processing method based on multi-system integration also includes: Combined with the inventory information of the laboratory material management system, receive the equipment or consumables inspection report sent by the information management system according to the preset cycle; According to the equipment or consumables inspection report, if any equipment or consumables in the inventory information fails the inspection report, equipment or consumables quality warning information is generated and sent to the laboratory material management system and the experiment reservation system; The equipment or consumables inspection report is the same as the supplier and model of the equipment or consumables in the inventory information.

13. The laboratory business processing method based on multi-system integration according to claim 1, characterized in that: The robotic process automation system is in communication with a financial reimbursement system, and the method further comprises: Generate a reimbursement application instruction based on the purchase approval instruction fed back by the purchase review system and the purchase documents; If the reimbursement application instruction is consistent with the laboratory equipment or laboratory consumables storage information fed back by the laboratory material management system, a reimbursement form is generated according to the reimbursement application instruction and sent to the financial reimbursement system.

14. The laboratory business processing device based on multi-system integration is characterized by: The device is applied to a robotic process automation system, which is respectively connected to a laboratory material management system, a laboratory budget system, a procurement review system, and an experiment reservation system. The laboratory business processing device based on multi-system integration includes: The experimental task acquisition module is used to obtain the experimental task list sent by the experimental reservation system, wherein the experimental task list includes at least one experimental task, and the experimental task includes the project to which the experiment belongs, at least one planned experimental equipment, at least one experimental consumable, the operations to be performed by each experimental equipment, the planned operation time of each experimental equipment, and the planned usage of various experimental consumables; The experimental task classification module is used to divide the experimental tasks into a basic experimental task set and an advanced experimental task set according to the acceptance requirements of the project to which the experiment belongs. The basic experimental tasks are used to meet the basic acceptance standards of the project to which they belong. The project can be concluded when the basic acceptance standards are met; the advanced experimental tasks are used to meet the advanced acceptance standards of the project to which they belong. Whether the advanced experimental tasks meet the advanced acceptance standards does not affect the conclusion of the project; A historical data acquisition module, used to acquire the historical usage of various experimental consumables in historical experimental tasks according to the operations to be performed by each experimental device in the basic experimental task set and the planned operation time of each experimental device; A consumables usage adjustment module is used to adjust the planned usage of various experimental consumables in combination with the historical usage of various experimental consumables in the historical experimental tasks to obtain reference usage of various experimental consumables; Inventory query module, used to receive inventory information fed back by the laboratory material management system; A first information generating module, configured to generate first pre-purchase information if the inventory information does not meet the reference usage of planned experimental equipment or various experimental consumables for any experimental task in the basic experimental tasks; A second information generating module, configured to generate second pre-purchase information if the inventory information does not satisfy the planned usage of experimental equipment or various experimental consumables for any of the advanced experimental tasks; Funding query module, used to receive project funds corresponding to experimental tasks from laboratory budget system feedback; A procurement generation module, configured to generate a procurement form and send it to a procurement review system if the first proportion of the project funds meets the expenditure of the first pre-procurement information and the second proportion of the project funds meets the expenditure of the second pre-procurement information, wherein the first proportion of the project funds is higher than the second proportion; The inventory information includes at least one laboratory available experimental equipment, the available reservation time of the laboratory available experimental equipment, at least one inventory consumable and the inventory quantity of the inventory consumable; If the inventory information does not meet the reference usage of the computational experimental equipment or various experimental consumables of any experimental task in the basic experimental task, the first pre-purchase information is generated, including: If the inventory consumables do not include experimental consumables, or the inventory quantity of the inventory consumables is less than the reference quantity of experimental consumables, generating first consumables pre-purchase information; If the inventory information does not meet the planned usage of experimental equipment or various experimental consumables for any experimental task in the advanced experimental task, the second pre-purchase information is generated, including: If the inventory consumables do not include experimental consumables, or the inventory of the inventory consumables is less than the planned usage of experimental consumables, generating second consumables pre-purchase information; If the minimum historical delivery time of the experimental consumables in the first consumables pre-purchase information does not meet the appointment time of the experimental task, sending cross-group consumables query information to the laboratory material management system; If the cross-group consumables inventory fed back by the laboratory material management system meets the first consumables pre-purchase information, a consumables call request is generated and sent to the management end of the laboratory material management system; If the minimum historical delivery time of the experimental consumables in the second consumables pre-purchase information does not meet the appointment time of the experimental task, a request for postponing the experimental task scheduling is generated in combination with the maximum historical delivery time of the experimental consumables, and the request for postponing the experimental task scheduling is sent to the experimental appointment system.

15. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of any one of the laboratory business processing methods based on multi-system integration in claims 1-13 are implemented.

16. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, it performs any one of the laboratory business processing methods based on multi-system integration in claims 1-13.

Images