Laboratory service processing method and device based on multi-system fusion

Abstract

The invention provides a laboratory business processing method and device based on multi-system fusion, and the method comprises the steps: obtaining the historical consumption of experiment consumables in a historical experiment task according to the operation needing to be executed by each piece of experiment equipment in a basic experiment task and the planned operation time of each piece of experiment equipment; adjusting the planned usage amount of the experimental consumables in combination with the historical usage amount of the experimental consumables in the historical experimental tasks to obtain the reference usage amount of the experimental consumables; if the inventory information does not meet the planned experimental equipment of any experimental task in the basic experimental tasks or the reference usage of various experimental consumables, generating first pre-purchase information; if the inventory information does not meet the planned experimental equipment or the planned usage of various experimental consumables of any experimental task in the advanced experimental tasks, generating second pre-purchase information; and if the first proportion of the project funds meets the funds of the first pre-purchasing information and the second proportion of the project funds meets the funds of the second pre-purchasing information, generating a purchasing table and sending the purchasing table to a purchasing auditing system.

Description

Technical Field

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

[0002] In the prior art, procurement approval and financial reimbursement businesses usually require manual review and processing. The process of filling out procurement reports or financial reports is not only time-consuming and relatively cumbersome, but also involves a variety of data that need to be checked one by one by the filler, which is prone to errors. In addition, a large number of approval businesses also make it easy for the reviewers to repeat or omit the processing of reports, resulting in human error in the approval business. In addition, the existing procurement approval and financial reimbursement businesses mostly require manual approval or paper document submission, which is not conducive to preservation and subsequent audit and review. Summary of the invention

[0003] Based on this, the present invention provides a laboratory business processing method and device based on multi-system integration, which, in combination with a robotic process automation system, generates procurement forms or reimbursement forms according to laboratory experimental tasks, equipment status and project funds, and sends them to the procurement review system and the financial reimbursement system accordingly. This can greatly reduce the time spent on laboratory procurement applications or reimbursement applications and improve the efficiency of laboratory procurement management.

[0004] In a first aspect, a laboratory business processing method based on multi-system integration is applied to a robotic process automation system, wherein the robotic process automation system 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:

[0005] 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 experiment equipment, planned operation time of each experiment equipment, and planned usage of various experiment consumables;

[0006] According to the acceptance requirements of the project to which the experiment belongs, the experimental tasks are divided into a basic experimental task set and an advanced experimental task set;

[0007] 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, the historical usage of various experimental consumables in the historical experimental tasks is obtained;

[0008] 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;

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

[0010] 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;

[0011] 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;

[0012] Receive project funds that correspond to experimental tasks in a one-to-one manner from the laboratory budget system;

[0013] If the first proportion of the project funds meets the funding expenditure of the first pre-purchase information, and the second proportion of the project funds meets the funding 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.

[0014] Further, 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;

[0015] 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, the first pre-purchase information is generated, specifically:

[0016] 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;

[0017] 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;

[0018] Combining the first equipment pre-purchase information and the first consumables pre-purchase information to obtain first pre-purchase information;

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

[0020] 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;

[0021] 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;

[0022] The second equipment pre-purchase information and the second consumables pre-purchase information are combined to obtain the second pre-purchase information.

[0023] Furthermore, if the available experimental equipment in the laboratory includes planned experimental equipment, the historical experimental yield of the planned experimental equipment is obtained;

[0024] 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;

[0025] 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;

[0026] 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.

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

[0028] 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;

[0029] 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;

[0030] 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;

[0031] 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;

[0032] 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;

[0033] The first time period is shorter than the second time period.

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

[0035] 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;

[0036] 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;

[0037] 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.

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

[0039] 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;

[0040] 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;

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

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

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

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

[0045] According to the yield of historical experimental tasks, the trust of equipment suppliers or consumables suppliers in the corresponding historical procurement records is obtained;

[0046] 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.

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

[0048] 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;

[0049] 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;

[0050] 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;

[0051] 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.

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

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

[0054] 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;

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

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

[0057] 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;

[0058] 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.

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

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

[0061] 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;

[0062] 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;

[0063] 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.

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

[0065] 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;

[0066] 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;

[0067] 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.

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

[0069] 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;

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

[0071] The equipment or consumables inspection report is the same as the supplier and model of the equipment or consumables in the inventory information.

[0072] Furthermore, the robotic process automation system is in communication with a financial reimbursement system, and the method further comprises:

[0073] Generate a reimbursement application instruction based on the purchase approval instruction fed back by the purchase review system and the purchase documents;

[0074] 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.

[0075] In a second aspect, the present invention also provides a laboratory business processing device based on multi-system fusion, the device is applied to a robotic process automation system, the robotic process automation system is respectively connected to a laboratory material management system, a laboratory budget system, a procurement review system and an experiment reservation system, and the laboratory business processing device based on multi-system fusion includes the following steps:

[0076] 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;

[0077] An 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;

[0078] 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;

[0079] 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;

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

[0081] 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;

[0082] 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;

[0083] Funding query module, used to receive project funds corresponding to experimental tasks from laboratory budget system feedback;

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

[0085] In a third aspect, the present invention further provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of any one of the laboratory business processing methods based on multi-system integration in the first aspect.

[0086] In a fourth aspect, the present invention further provides a computer device, comprising a memory and a processor, wherein the memory stores a computer program, and 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 solution are as follows: this embodiment connects the laboratory material management system, laboratory budget system, procurement review system and experiment reservation system through the robotic process automation system, generates procurement forms or reimbursement forms in combination with the actual operation of the laboratory, reduces a lot of manpower processing time, and greatly improves the efficiency of generating reports; and before the procurement form or reimbursement form is generated, it is reviewed whether the project funds meet the application, thereby improving the approval process of subsequent reports. BRIEF DESCRIPTION OF THE DRAWINGS

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

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

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

[0091] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention. In order to explain the present invention in more detail, the laboratory business processing method and device based on multi-system fusion provided by the present invention are specifically described below in combination with the drawings.

[0092] Unless otherwise defined, the technical terms or scientific terms used in the disclosure of this application should be understood by people with ordinary skills in the field to which the present invention belongs. The "first", "second" and similar words used in the present invention do not indicate any order, quantity or importance, but are only used to distinguish different components. Similarly, similar words such as "one", "one" or "the" do not indicate a quantitative limit, but indicate that there is at least one. Similar words such as "include" or "include" mean that the elements or objects appearing in front of the word cover the elements or objects listed after the word and their equivalents, without excluding other elements or objects. Similar words such as "connect" or "connected" are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative positional relationships. When the absolute position of the described object changes, the relative positional relationship can also change accordingly.

[0093] The present invention provides a laboratory business processing method based on multi-system integration, combined with a robotic process automation system, to generate a procurement form or reimbursement form according to laboratory experimental tasks, equipment status and project funds, and send it to the procurement review system and financial reimbursement system accordingly, which can greatly reduce the time spent on laboratory procurement applications or reimbursement applications and improve the efficiency of laboratory procurement management. Figure 1 A schematic diagram of a laboratory business processing method based on multi-system integration is shown.

[0094] The embodiment of the present application provides an application scenario of a laboratory business processing method based on multi-system integration, and the application scenario includes a terminal device provided in the embodiment, and the terminal device includes but is not limited to a smart phone and a computer device, wherein the computer device can be at least one of a desktop computer, a portable computer, a laptop computer, a mainframe computer, a tablet computer, etc. The terminal device receives an experimental task or an equipment maintenance task, etc., and generates a procurement form or a reimbursement form in combination with the specific laboratory consumables inventory, equipment status, and project funds, and sends it to a procurement review system or a financial reimbursement system. For the specific process, please refer to the embodiment of the laboratory business processing method based on multi-system integration.

[0095] It should be noted that the robotic process automation system of this embodiment is a processor that integrates 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 corresponding procurement reports and send them to the procurement review system in combination with the experimental task information sent by the experimental reservation system, the inventory information sent by the laboratory material management system, and the project budget sent by the laboratory budget system; the database can store historical experimental data fed back by laboratory equipment, experimental operators or laboratory management terminals, and call 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 respectively connected to the laboratory material management system, the laboratory budget system, the procurement review system and the experiment reservation system, wherein the specific communication connection methods include but are not limited to serial port connection, wireless connection, Bluetooth connection and the like.

[0097] The laboratory material management system is used to manage the laboratory's existing experimental equipment and consumables 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 in-and-out situation of the laboratory's experimental equipment and consumables. The processor is used to modify the records of experimental equipment put into use, unused experimental equipment, damaged experimental equipment and inventory records of consumables in the laboratory according to the in-and-out situation of the experimental equipment and consumables, and send the above data to the storage device to facilitate subsequent inquiries on the specific experimental equipment situation or consumables inventory situation.

[0098] The laboratory budget system is used to manage the project budgets registered in the laboratory and record them in the library. The laboratory budget system includes a processor and a storage device. The processor receives the available budget of the project funds sent by the user end or the administrator end, including but not limited to the total project budget, project equipment budget, project consumables budget, project service budget, project intellectual property budget and project personnel budget. It should be noted that the sum of the specific budgets in the project is equal to the total project budget. In principle, the specific budgets in the project cannot be called, but the specific budgets in the project can be called and adjusted after approval by the administrator end; and the processor also adjusts the total project budget and the specific budgets in the project in real time according to the project reimbursement amount fed back by the financial reimbursement system, and sends them to the storage device for storage, so as to facilitate subsequent inquiries on the specific project budgets.

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

[0100] The experiment reservation system is used to make reservations for the experimental tasks to be performed in the laboratory. The experiment reservation system is part of the laboratory management system. The experiment reservation system includes a processor and a storage device. The processor receives the experimental tasks sent by the user or the administrator. The experimental 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 consumables required for the experiment, and the amount of consumables required for the experiment.

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

[0102] The following is an explanation of the steps for applying the laboratory business processing method based on multi-system integration 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 experiment equipment, at least one experiment consumable, the operations to be performed by each planned experiment equipment, the planned operation time of each experiment equipment and the planned usage of various experiment consumables.

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

[0105] Considering that a semiconductor experimental task may include multiple semiconductor experimental processes, the experimental task needs to record the planned experimental equipment needed for the experimental task, the operations to be performed by each planned experimental equipment, the planned scheduled operation time of each planned experimental equipment, as well as the types of experimental consumables used in conjunction with the planned experimental equipment and the planned usage of various experimental consumables.

[0106] When the robotic process automation system is able to clearly identify the experimental equipment and experimental consumables that the semiconductor laboratory needs to schedule in different time periods based on the specific experimental task content received.

[0107] Step S102, dividing 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 needs, and considering that there is uncertainty in the results of scientific research projects, that is to say, the projects that the semiconductor laboratory needs to execute have basic acceptance standards and advanced acceptance standards. Most of the experimental tasks that meet the basic acceptance standards of the project are improved on existing experiments, and have certain predictability of results in combination with historical experimental records. Under the basic acceptance standards of the project, the experimental tasks that are further explored are mostly guided by tentative or experimental, and there may be some or even most differences from the existing experiments. The results of the 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 of the specific operating steps or experimental expectations of the experimental tasks with the acceptance requirements of the projects to which they belong. The basic experimental tasks are used to meet the basic acceptance standards of the projects to which they belong, and the projects can be concluded when they meet the basic acceptance standards; the advanced experimental tasks are used to meet the advanced acceptance standards of the projects to which they belong, and whether the advanced experimental tasks meet the advanced acceptance standards 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 strip width of the pattern is 5μm, and the overlay error is controlled within 20%; the advanced acceptance criteria are that the minimum strip width of the pattern is 3μm, and the overlay error is controlled within 10%. This project includes two experimental tasks, of which the experimental purpose of experimental task A is to obtain a micro-pattern with a minimum strip 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 strip width of 3μm and an overlay error of less than 10%. According to the comparison of 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 acceptance criteria for different projects, the same experimental task can be a basic experimental task in Project A and an advanced experimental task in Project B. The division of basic experimental tasks and advanced experimental tasks in this embodiment is only determined according to the acceptance criteria of specific projects and has nothing to do with the difficulty of implementing the experimental tasks or the technical difficulty.

[0111] Step S103, obtaining the historical usage of various experimental consumables in the historical experimental tasks according to the operations to be performed by each experimental device in the basic experimental tasks.

[0112] Step S104, adjusting 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.

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

[0114] In view of the fact that basic experimental tasks are improvements made on the basis of existing experimental tasks, the data in historical experimental tasks are of 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, according to the same operation steps and the same duration of the corresponding operation steps in the historical experimental tasks, at least one historical experimental task with the same operation is obtained, and according to the historical average usage of various experimental consumables in the historical experimental tasks, the evolutionary usage of the experimental consumables in the experimental tasks is adjusted to obtain the reference usage of various experimental consumables.

[0115] By adjusting the above steps, the influence of specific experimental equipment or experimental environment on the amount of experimental consumables required for the same experimental operation steps can be overcome, so that the amount of experimental consumables can be more accurately grasped during the scheduling or procurement of experimental consumables.

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

[0117] Specifically, the inventory information includes at least one laboratory-available experimental equipment, a reservation time for the laboratory-available experimental equipment, at least one inventory consumable, and the inventory quantity of the inventory consumable.

[0118] It should be noted that the laboratory available experimental equipment here includes not only the experimental equipment in operation, but also the experimental equipment that is not in operation, such as the experimental equipment in the laboratory inventory that can be used and not scrapped. The available reservation time for the experimental equipment in operation is the idle time determined by the experiment reservation system schedule, and the available reservation time for the experimental equipment that is not in operation can be determined by combining the installation time of the experimental equipment to determine the idle time.

[0119] Step S106: 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 tasks, generate first pre-purchase information.

[0120] Specifically, if the laboratory's available experimental equipment does not include the planned experimental equipment, or the available time for booking the laboratory's available experimental equipment exceeds the maximum waiting period, the first equipment pre-purchase information is generated. If the inventory consumables do not include experimental consumables, or the inventory of the inventory consumables is less than the reference amount of experimental consumables, the first consumables pre-purchase information is generated. The first equipment pre-purchase information and the first consumables pre-purchase information are combined to obtain the first pre-purchase information.

[0121] It should be noted that the situation where the available experimental equipment in the laboratory has a reservation time that exceeds the maximum waiting period means that the experimental equipment is in operation, but due to the excessive number of scheduled experiments with the experimental equipment, the experimental tasks of the current time period cannot be scheduled to execute specific experimental task steps within the maximum waiting period, which may easily lead to the situation where the experimental tasks are not executed and affect the project acceptance and conclusion. The maximum waiting period here can be a preset experimental task scheduling waiting limit, or it can be determined according to the acceptance time of the project to which the specific experimental task belongs. The inventory of inventory consumables in this embodiment refers to the inventory of inventory consumables managed in the project to which the experimental task belongs, rather than the inventory of inventory consumables in the entire semiconductor laboratory.

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

[0123] Specifically, if the available equipment in the laboratory 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, generate second equipment pre-purchase information; 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, generate second consumables pre-purchase information; the second equipment pre-purchase information and the second consumables pre-purchase information are merged to obtain the second pre-purchase information.

[0124] It should be noted that, considering that the purchase of semiconductor experimental equipment is a comprehensive and long-term consideration, whether the advanced experimental tasks can be fully executed to achieve the expected results does not affect the acceptance of the project. It is just an exploratory experiment. If there is a need to purchase equipment for such experimental tasks, it is necessary to combine the number of historical purchase requests and the predicted frequency of use of the experimental equipment in subsequent experimental tasks to jointly determine whether it is necessary to purchase. In this embodiment, the historical purchase request threshold can be set to 3 times, and the threshold for the predicted frequency of use can be set to once every six months, etc., which can be adjusted according to actual conditions.

[0125] Step S108, receiving the project funds corresponding to the experimental tasks from the laboratory budget system.

[0126] Step S109, if the first proportion of the project funds meets the funding expenditure of the first pre-purchase information, and the second proportion of the project funds meets the funding 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.

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

[0128] In addition, the project funds fed back by the laboratory budget system should include the types of equipment that can be purchased by the project, restrictions on suppliers that can purchase equipment, the upper limit of the price of a single device that can be purchased by the project, the types of consumables that can be purchased by the project, restrictions on suppliers that can purchase consumables, and the upper limit of the unit price of consumables that can be purchased by the project. When the first pre-purchase information and the second pre-purchase information meet the above-mentioned limit conditions and price upper limit, a specific procurement form is generated based on the pre-purchase information and sent to the procurement review system. This setting can review procurement requests to avoid sending non-compliant or over-project budget pre-purchase requests to the procurement review system, affecting the efficiency of the review process, or improving the procurement approval efficiency of the review staff.

[0129] The procurement 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 expected delivery date of the equipment to be purchased, the specifications of the consumables to be purchased, the amount of consumables to be purchased, the supplier information of the consumables to be purchased, the price of the consumables to be purchased and the expected delivery date of the consumables to be purchased.

[0130] Based on the above embodiments, considering that the experimental equipment in the semiconductor laboratory is aged or the spare parts of the experimental equipment are easily affected by long-term use, the laboratory business processing method based on multi-system integration of the present invention also includes the following steps:

[0131] Step S201: If the available experimental equipment in the laboratory includes planned experimental equipment, the historical experimental yield of the planned experimental equipment is obtained.

[0132] The historical experimental yield of the experimental equipment planned here can be obtained based on the feedback from the experimenters or the average or median of the historical experimental yield statistics of the experiment reservation system.

[0133] Step S202: 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 / part replacement work order.

[0134] Specifically, the equipment monitoring model is trained based on the historical experimental yield, maintenance records, and spare parts replacement records of experimental equipment of the same model and specification as a training set, so that the trained equipment monitoring model can predict the damaged parts of the experimental equipment or the spare parts that need to be replaced based on the historical experimental yield of the specific experimental equipment. The equipment 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 experimental equipment maintenance work order, and send the maintenance service purchase order to a procurement review system.

[0136] Step S204, generating a spare parts replacement request 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, generating spare parts procurement information and sending it to the procurement review system.

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

[0138] Step S301, obtaining the trustworthiness of the equipment supplier or consumables supplier in the corresponding historical procurement records according to the historical experimental yield.

[0139] Step S302: 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.

[0140] It should be noted that, in this embodiment, each equipment supplier or consumables supplier has an initial trust level. When the historical experimental yield is lower than the preset yield threshold (e.g., 50%), the initial trust level is reduced; when the historical experimental yield is higher than the expected yield of the experimental task for a preset number of times (e.g., the historical experimental yield exceeds the expected yield of the experimental task for 10 consecutive times), 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 means that the equipment or consumables provided by the supplier may have quality problems, and a reminder to replace the equipment supplier or consumables supplier may be issued.

[0141] In addition, if the historical experimental task yield rate is lower than the equipment yield rate threshold for a long time, it means that the equipment may not meet the operation requirements. For this, the laboratory business processing method based on multi-system integration of the present invention also includes:

[0142] Step S401, 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.

[0143] Step S402: if the experiment reservation system reports that the yield of historical operations performed by any historical experiment equipment is lower than the equipment yield threshold and the frequency is higher than the maintenance threshold, the historical maintenance record of the historical experiment equipment is obtained.

[0144] Step S403: If the accumulated maintenance cost and accumulated maintenance time of the historical maintenance record meet the scrapping standard, a laboratory equipment scrapping request is generated and sent to the laboratory material management system.

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

[0146] Step S501, obtaining 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.

[0147] It should be noted that for the control of delivery time during the consumables procurement process, the requirements for basic experimental tasks and advanced experimental tasks are the same, so the first consumables pre-purchase information and the second consumables pre-purchase information are unified as consumables to be purchased for discussion.

[0148] Step S502, 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.

[0149] It should be noted that the historical delivery time in the historical procurement record may be the average or median value of the historical delivery time in multiple historical procurement records.

[0150] Step S503: 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 value of the historical delivery time.

[0151] Specifically, when the reference delivery time is less than the first time period, it means that the delivery time of the consumables is quite fast or even ahead of schedule. In other words, there is no need to worry about delayed delivery of consumables during the procurement of consumables. Therefore, the latest procurement time of the consumables can be inferred based on the appointment time of the experimental task and the average 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 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 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 means that the consumables can be delivered before the latest delivery deadline. In this case, to ensure that the experimental task can be carried out on time at the scheduled time, the latest purchase time of the consumables can be inferred based on the median value of the scheduled time of the experimental task and the historical delivery time, and the purchase task can be initiated before the latest purchase time.

[0154] Step S505, 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 less than the second time period.

[0155] Specifically, when the reference delivery time is greater than the second time period, it means that the delivery time of the consumables is mostly delayed. In this case, in order to ensure that the experimental task can be carried out on time at the scheduled time, it is necessary to infer the latest purchase time of the consumables based on the maximum value of the scheduled time of the experimental task and the historical delivery time, and initiate the purchase task before the latest purchase time.

[0156] Furthermore, after the latest purchase time of the consumables to be purchased is determined as above, combined with the purchase registration information, if the registration information of the consumables to be purchased is still not retrieved after the latest purchase time of the consumables to be purchased, a purchase reminder message is generated to ensure that the consumables for the experimental task can be purchased in time.

[0157] Furthermore, if the above-mentioned experimental consumables cannot meet the experimental tasks on time, the laboratory business processing method based on multi-system integration of this embodiment is provided with the following coping solutions:

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

[0159] Step S602: 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.

[0160] Considering that whether the basic experimental tasks can be carried out on time directly affects whether the project can be accepted and concluded, when the minimum historical delivery time cannot meet the appointment time of the experimental tasks, in order to ensure that the basic experimental tasks can be carried out on time, a cross-group consumables query can be sent to the laboratory material management system to find out whether other projects or other laboratories have the same consumables available for the experimental tasks. If other projects or other laboratories have the same consumables available for the experimental tasks, a consumables call request is generated for the call. It should be noted that the existence of the same consumables available for the experimental tasks in other projects or other laboratories means that the total inventory of the consumables in the project to which the experimental tasks belong and the inventory of the consumables in other projects or other laboratories meet the reference usage of the consumables in the experimental tasks.

[0161] Step S603, 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.

[0162] Since whether the advanced experimental task can be executed on time does not affect the acceptance and completion of the project to which it belongs, the experimental task can be scheduled for postponement after the historical minimum delivery time cannot meet the appointment time of the experimental task. In order to avoid the delayed experimental task being processed according to the delayed time, the scheduling postponement request should be based on the historical maximum delivery time of the consumables as a reference.

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

[0164] Step S701, obtaining 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.

[0165] Step S702: 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.

[0166] Specifically, if the historical delivery time of the asset to be purchased in the historical procurement record is delayed relative to the historical planned delivery time, the supplier trust value of the historical procurement record is reduced.

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

[0168] Step S704: When the supplier trust value is lower than a second trust threshold, a supplier change reminder or a late payment fee reminder is generated; wherein the second trust threshold is lower than the first trust threshold.

[0169] In this embodiment, different processing methods can be adopted according to different trust values ​​caused by delayed delivery of suppliers.

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

[0171] Step S801: If the reference delivery time of the consumables to be purchased is less than the first time period, an inventory query request for the consumables to be purchased is sent 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, third consumables pre-purchase information is generated and sent to the purchase review system.

[0173] Specifically, for the consumables to be purchased that can be delivered in advance (also known as short-delivery cycle consumables), there is no need to worry about whether the consumables can be delivered in time. Specific procurement information can be generated in combination with a prompt of whether the inventory quantity 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 the reference delivery time is less than the second time period, obtain the predicted demand for the consumables to be purchased within the experiment reservation period, generate the fourth consumables pre-purchase information based on the predicted demand, and send it to the procurement review system.

[0175] Specifically, for the consumables to be purchased that need to be delivered before the latest delivery deadline, in order to reduce the possible risk of delayed delivery, the demand for the consumables to be purchased can be predicted based on the experiment reservation cycle (such as one week or one month), and pre-purchase information can be generated based on 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, generate fifth consumables pre-purchase information based on the predicted demand, and send it to the procurement review system.

[0177] Specifically, for consumables to be purchased that are delayed in delivery, in order to reduce the hidden dangers of delayed delivery, the experiment reservation cycle can be extended (for example, two months, three months, etc.) to predict the demand for the consumables and deploy the pre-purchase information in advance.

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

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

[0180] Step S902, 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.

[0181] Step S903: 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.

[0182] Specifically, the price of the consumables to be purchased is predicted based on historical data. If it is found that the price trend of the consumables is higher than the premium rate threshold, such as a sharp increase in the price of the consumables in a short period of time, the predicted demand for the consumables within the longest experimental reservation cycle can be combined to increase the real-time purchase quantity of the consumables in this procurement form to reduce the impact of the sharp price increase on the completion of the experimental task.

[0183] Furthermore, considering that some consumables are likely to expire due to long-term storage, the laboratory business processing method based on multi-system integration of the present invention also includes:

[0184] Step S1001, sending query information to the laboratory material management system to obtain the historical purchase volume and corresponding validity information of the consumables to be purchased, wherein the validity period information includes within the shelf life and exceeded the validity period.

[0185] Step S1002, if the amount of consumables exceeding the set ratio in the historical purchase amount of the consumables to be purchased exceeds the validity period, combined with the amount required for the experiment corresponding to the consumables to be purchased, the planned amount or reference amount of the consumables to be purchased is adjusted to the amount required for the experiment.

[0186] It should be noted that in this embodiment, a small amount of expired consumables are allowed in the historical purchase volume, but when the amount of consumables exceeding the set ratio in the historical purchase volume exceeds the validity period, it means that the historical purchase volume is unreasonable, so it is necessary to adjust it in combination with the amount required for the experiment. Through the above technical means, it can further ensure that the amount of consumables to be purchased is more in line with the specific consumables usage of the laboratory, avoid unnecessary waste of consumables, and improve the effective utilization rate of project funds.

[0187] Furthermore, different levels of persons in charge corresponding to the experimental tasks may result in different resources or funds that can be scheduled for the experimental tasks. In this regard, the laboratory business processing method based on multi-system integration of the present invention further includes the following steps:

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

[0189] Step S1102: 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 project fund proportion is sent to the laboratory budget system and the procurement review system.

[0190] Step S1103: 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.

[0191] Step S1104: 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.

[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 main person in charge of the project is the highest level and can directly adjust the proportion of project funds; the project participants are at an ordinary level. When the pre-purchase information funding expenditure of the basic experimental task cannot be met, the corresponding project funding ratio adjustment request is initiated, and the specific project funding ratio is adjusted by the project funding administrator.

[0193] In addition, considering that the quality information of equipment or consumables can be reflected in the public inspection report, the above-mentioned robot process automation system is also connected to the information management system, which controls the quality of the existing equipment or consumables in the laboratory by collating the public information on the Internet or regularly obtaining the inspection information of the experimental equipment or experimental consumables from a specific database. The laboratory business processing method based on multi-system integration of the present invention also includes:

[0194] Step S1201, combining the inventory information of the laboratory material management system, receiving the equipment or consumables inspection report sent by the information management system according to a preset period.

[0195] Step S1202: Based on the equipment or consumables inspection report, if any equipment or consumables in the inventory information fails the inspection report, generate equipment or consumables quality warning information and send it to the laboratory material management system and the experiment reservation system;

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

[0197] Furthermore, the robotic process automation system is in communication with a financial reimbursement system, and the method further comprises:

[0198] Step S1301, generating a reimbursement application instruction according to the purchase approval instruction fed back by the purchase review system and the purchase document.

[0199] Step S1302: 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.

[0200] It should be understood that although the Figure 1 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Figure 1 At least part of the steps may include multiple sub-steps or sub-stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least part of the sub-steps or stages of other steps.

[0201] The above embodiments disclosed in the present invention describe in detail a laboratory business processing method based on multi-system integration. The above methods disclosed in the present invention can be implemented using various forms of equipment. 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. The robotic process automation system is respectively connected to a laboratory material management system, a laboratory budget system, a procurement review system, and an experiment reservation system. Figure 2 , specific embodiments are given below to explain in detail.

[0202] The experimental task acquisition module 1401 is used to acquire 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;

[0203] An experimental task classification module 1402 is used to classify 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;

[0204] The historical data acquisition module 1403 is used to acquire the historical usage of various experimental consumables in the 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;

[0205] The consumables usage adjustment module 1404 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;

[0206] Inventory query module 1405, used to receive inventory information fed back by the laboratory material management system;

[0207] The first information generating module 1406 is used 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 task;

[0208] The second information generating module 1407 is used to generate second 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;

[0209] Fund query module 1408, used to receive project funds corresponding to experimental tasks from laboratory budget system;

[0210] The procurement generation module 1409 is used to generate a procurement form and send it to the 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. Regarding the laboratory business processing device based on multi-system fusion, all of them can refer to the above definition of the method, which will not be repeated here. Each module in the above device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules can be embedded in or independent of the processor of the terminal device in the form of hardware, or can be stored in the memory of the terminal device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

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

[0212] The computer-readable storage medium may be an electronic memory such as a flash memory, an EEPROM (electrically erasable programmable read-only memory), an 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 step of the above method. These program codes may be read from or written into one or more computer program products, and the program codes may be compressed in an appropriate form.

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

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

[0215] The processor may include one or more processing cores. The processor uses various interfaces and lines to connect the various parts of the entire computer device, and executes various functions of the computer device and processes data by running or executing instructions, programs, code sets or instruction sets stored in the memory, and calling data stored in the memory. Optionally, the processor can be implemented in at least one hardware form of digital signal processing (Digital Signal Processing, DSP), field programmable gate array (Field-Programmable Gate Array, FPGA), and programmable logic array (Programmable Logic Array, PLA). The processor can integrate one or more combinations of a central processing unit (Central Processing Unit, CPU), a reporting verifier (Graphics Processing Unit, GPU) for buried data, and a modem. Among them, the CPU mainly processes the operating system, user interface, and application programs; the GPU is responsible for rendering and drawing display content; and the modem is used to process wireless communications. It can be understood that the above-mentioned modem may not be integrated into the processor, but may be implemented separately through a communication chip.

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

[0217] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the 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; 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 funding expenditure of the first pre-purchase information, and the second proportion of the project funds meets the funding 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.

2. The laboratory business processing method based on multi-system integration according to claim 1 is characterized in that: 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 planned experimental equipment or various experimental consumables for any experimental task in the basic experimental task, the first pre-purchase information is generated, specifically: 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; 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; 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 experimental equipment or various experimental consumables for any of the advanced experimental tasks, the second pre-purchase information is generated, specifically: 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; 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; 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 4 is characterized in that: Also includes: 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.

6. The laboratory business processing method based on multi-system integration according to claim 5 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.

7. The laboratory business processing method based on multi-system integration according to claim 6 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.

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

9. The laboratory business processing method based on multi-system integration according to claim 8, 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.

10. The laboratory business processing method based on multi-system integration according to claim 9, 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.

11. The laboratory business processing method based on multi-system integration according to claim 10, 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.

12. The laboratory business processing method based on multi-system integration according to claim 11, 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.

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

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

15. 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; An 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; 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; The procurement generation module is used to generate a procurement form and send it to the procurement review system if the first proportion of the project funds meets the funding expenditure of the first pre-procurement information and the second proportion of the project funds meets the funding expenditure of the second pre-procurement information, wherein the first proportion of the project funds is higher than the second proportion.

16. 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-14 are implemented.

17. 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-14.

Images