Sample management method, system and equipment for biological laboratory

Abstract

A sample management method for a biological laboratory comprises the following steps: providing a user side, and acquiring input sample information in real time; providing a front-end interface, acquiring sample information data input in real time, transmitting a data object to a processing end through an AJAX request, and storing the data in a database; obtaining a preset rule, and generating a sample serial number according to the preset rule; a ZXing.Net library is called, and a corresponding bar code is generated; in response to the printing instruction, executing printing of the bar code; acquiring and matching bar code information of the management end and position information of the corresponding pasted sample tube; when a code scanning instruction of the code scanning gun is detected, reading information of the code scanning gun based on serial port communication, calling a C # SeralPort class to open a serial port, monitoring data sent by the code scanning gun, and reading and processing the data when the data is finished; and querying and displaying corresponding sample information and sample states based on an EFCore technology.

Description

Technical Field

[0001] The present invention relates to the field of computers, and particularly to a sample management method, system and device for biological laboratories. Background Art

[0002] In traditional laboratory systems, sample management is usually carried out manually by offline sorting of relevant paper documents such as Excel spreadsheets. This method is not only inefficient but also error-prone. Especially when there are a large number of samples to be managed, it is very difficult and error-prone for laboratory personnel to receive and return relevant samples. Summary of the Invention

[0003] One object of the present invention is to provide a sample management method, system and device for biological laboratories, which can realize online management of samples in biological laboratories and improve work efficiency.

[0004] One object of the present invention is to provide a sample management method, system and device for biological laboratories, which can timely obtain sample information sent by the user terminal, generate and print corresponding sample barcodes, and query sample information by scanning the code, so as to conveniently, quickly and accurately manage samples in biological laboratories and improve work efficiency.

[0005] One object of the present invention is to provide a sample management method, system and device for biological laboratories, which can provide a standardized process for sample management in biological laboratories, uniformly store and manage sample information, assign responsibilities to specific responsible persons, and enable query of the usage records of samples, ensuring the traceability and safety of samples.

[0006] To achieve at least one object of the present invention, the present invention provides a sample management method for biological laboratories, including the following steps:

[0007] Provide a user terminal to obtain the input sample information in real time;

[0008] Provide a front-end interface to obtain the real-time input sample information data, transmit the data object to the processing end through an AJAX request, and save the data in the database;

[0009] Obtain a preset rule, and generate a sample serial number according to the preset rule;

[0010] Call the ZXing.Net library to generate the corresponding barcode;

[0011] In response to a print instruction, execute the printing of the barcode;

[0012] Obtain and match the barcode information of the management end and the position information of the corresponding pasted sample tube;

[0013] When a barcode scanner scanning instruction is detected, read the barcode scanner information based on serial communication, call the SerialPort class in C# to open the serial port, listen for the data sent by the barcode scanner, and read and process the data when the data ends; and

[0014] Query and display the corresponding sample information and sample status based on the EFCore technology.

[0015] In some embodiments, the sample management method for a biological laboratory includes the following steps: Call the System.Drawing technology in.Net to convert the generated barcode into a stream and save it as a file.

[0016] In some embodiments, the sample management method for a biological laboratory includes the following steps: Call the window.print method to print the specified barcode.

[0017] In some embodiments, the sample management method for a biological laboratory includes the following steps: Install it through the NuGet Package Manager Console in the project.

[0018] In some embodiments, the sample management method for a biological laboratory includes the following steps: Call the BarcodeWriter class to generate a barcode and create a barcode encoder.

[0019] In some embodiments, the sample information is selected from the biological laboratory name, sample name, storage room, shelf, refrigerator, layer, plate number, and location information.

[0020] According to another aspect of the present invention, there is also provided a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, it executes the steps of the sample management method for a biological laboratory.

[0021] According to another aspect of the present invention, there is also provided a sample management device for a biological laboratory, including:

[0022] A memory for storing software application programs,

[0023] A processor for executing the software application programs, and each program of the software application programs correspondingly executes each step of the sample management method for a biological laboratory.

[0024] According to another aspect of the present invention, there is also provided a sample management system for a biological laboratory, which applies the above-mentioned sample management method for a biological laboratory. The sample management system for a biological laboratory is provided with a sample serial number generation module and a ZXing.Net library call module. The sample serial number generation module automatically generates a sample serial number according to a preset rule. The ZXing.Net library call module calls the BarcodeWriter class of ZXing.Net to generate a barcode picture according to the sample serial number and saves it to a specified path on the server.

[0025] In some embodiments, the sample management system for a biological laboratory is further provided with a serial communication reading barcode scanner unit for reading barcode scanner information through a serial port. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 is a flowchart of the steps of a sample management method for a biological laboratory according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0027] The following description is used to disclose the present invention so that those skilled in the art can implement the present invention. The preferred embodiments described below are only examples, and those skilled in the art can think of other obvious variations. The basic principles defined in the following description can be applied to other embodiments, variations, improvements, equivalent solutions, and other technical solutions that do not depart from the spirit and scope of the present invention.

[0028] It can be understood that the term "a" should be understood as "at least one" or "one or more". That is, in one embodiment, the number of an element can be one, and in other embodiments, the number of the element can be multiple. The term "a" cannot be understood as a limitation on the number.

[0029] The present invention is an invention related to a computer program. As Figure 1The figure shows a flowchart of a sample management method for a biological laboratory based on the present invention, which elaborates on a solution for controlling or processing external or internal objects of a computer by a computer executing a computer program compiled according to the above process to solve the problems proposed by the present invention based on the computer program processing flow. Through the sample management method for a biological laboratory of the present invention, a computer system can be utilized to provide a user end, a processing end, and a management end, capable of timely obtaining sample information sent by the user end, processing data, generating and printing corresponding sample barcodes according to instructions for the management end to scan and query sample information, facilitating, quickly, and accurately managing samples in a biological laboratory, realizing online management of samples in a biological laboratory, and improving work efficiency. It can be understood that the "computer" referred to in the present invention not only refers to devices such as desktop computers, laptop computers, and tablets, but also includes other intelligent electronic devices capable of running according to programs and processing data.

[0030] As Figure 1 shown, the sample management method for a biological laboratory includes the following steps:

[0031] S100: Provide a user end to obtain the entered sample information in real time, where the sample information includes sample name, storage room, shelf / refrigerator, layer, plate number, location, etc.;

[0032] S200: Provide a front-end interface to obtain the real-time entered sample information data, transmit the data object to the processing end through an AJAX request, and save the data to the database;

[0033] S300: Generate a sample number and a barcode;

[0034] S310: Obtain a preset rule and generate a sample serial number according to the preset rule; preferably, generate a unique serial number in the way of timestamp + random number;

[0035] S320: Call the ZXing.Net library to generate the corresponding barcode; preferably, according to the serial number, call the BarcodeWriter class of ZXing.Net to generate a barcode picture and save it to the specified path of the processing end server;

[0036] S400: Respond to the print instruction and execute the printing of the barcode;

[0037] S410: Respond to the print barcode instruction of the management end, call the browser to print, and print the barcode;

[0038] S420: The processing end passes the barcode picture address to the front-end interface, and the front-end interface displays the barcode through a label and provides a print button. When responding to the print instruction, call the window.print() method;

[0039] S500: Obtain and match the barcode information of the management terminal and the corresponding sample tube position information pasted by the sampler.

[0040] S600: When receiving the instruction of the user terminal to query sample information by scanning the code, obtain the barcode scanned by the barcode scanner on the sample tube, and read the information of the barcode scanner through serial port communication; preferably, call the SerialPort class in C# to open the serial port, monitor the data sent by the barcode scanner, and when the data ends (such as detecting a line feed character), read and process the data.

[0041] S700:: Query and display the corresponding sample information, status, etc. based on the EFCore technology; preferably, obtain the barcode information read by the barcode scanner, query the corresponding sample information in the database, and display it on the front-end interface.

[0042] More specifically, the sample management method for the biological laboratory includes the following steps: Call the System.Drawing technology in.Net to convert the generated barcode into a stream and save it as a file.

[0043] More specifically, the sample management method for the biological laboratory includes the following steps: Call the window.print method to print the specified barcode.

[0044] More specifically, the sample management method for the biological laboratory includes the following steps: When detecting the input action of sample information data, issue an input instruction for the operator information. If the operator information is not obtained, the sample information input is not executed. When the operator information is obtained, the sample information input is executed, and the sample information and the operator information for inputting the sample information are matched and saved to the traceable and secure database.

[0045] More specifically, the sample management method for the biological laboratory includes the following steps: When detecting the sample use instruction, issue an input instruction for the user information. If the user information is not obtained, the sample query and use are not allowed. When the user information is obtained, the sample query and use are allowed, and the sample query and use records are matched with the user information and saved to the traceable and secure database.

[0046] It is worth mentioning that through the above standardized process, the workload of sample preservation in the biological laboratory can be reduced. Only by inputting the sample information, printing and pasting the barcode can the online management of samples be realized. When querying the sample information later, only the barcode needs to be scanned.

[0047] It is worth mentioning that through the above standardization process, the sample information of biological laboratory samples can be uniformly stored and managed, with the responsibility assigned to specific input personnel and users. The usage records of samples can be queried to ensure the traceability and safety of samples.

[0048] Furthermore, the sample management method for a biological laboratory includes the following steps: performing sample information data storage.

[0049] Specifically, in a preferred embodiment, the sample information data storage table is as follows:

[0050] Id uniqueidentifier Sample number Name nvarchar(256) Sample name Room nvarchar(256) Storage room Bridge nvarchar(256) Storage shelf / fridge Storey nvarchar(256) Floor Board nvarchar(256) Board number Coordinate nvarchar(256) Location SampleNo nvarchar(256) Serial number

[0051] Among them, the parameter table data format is the object format of the database. When a user at the user end fills in the relevant data of the sample information on the interface and transmits the corresponding data object to the background of the processing end through an ajax request, the background will store each corresponding data object in the corresponding table of the database one by one.

[0052] Furthermore, the sample management method for a biological laboratory includes the following steps: calling ZXing.Net to generate a barcode image and performing printing.

[0053] More specifically, call ZXing.Net as a barcode and QR code processing library. Preferably, use the.NET porting version of the ZXing (Zebra Crossing) library implemented based on Java.

[0054] It can be understood that by calling ZXing.Net to generate a barcode image, it can provide high customization. ZXing.Net provides a fine-grained API that allows developers to finely control key parameters such as size and error correction level; it can improve cross-platform compatibility: support running on multiple operating systems such as Windows, Linux, and macOS, and at the same time be compatible with multiple.NET platforms such as.NET Framework,.NET Core,.NET 5 and above; it can improve scalability, support developers to implement encoding / decoding logic according to business needs to meet specific business requirements; it can have high performance, provide optimized reading algorithms that can accurately identify barcodes even in low-quality pictures; it has ease of use, and the intuitive API reduces the complexity of the code.

[0055] In a specific preferred embodiment, the sample management method for a biological laboratory includes the following steps:

[0056] Install through the NuGet Package Manager Console in the project, implemented as:

[0057] Install-Package ZXing.Net

[0058] Use the BarcodeWriter class to generate barcodes. Create a barcode encoder implemented as follows:

[0059]

[0060] / / The text to be encoded, which is the sample serial number in this system

[0061] string text = "123456789012";

[0062] / / Generate a barcode image

[0063] Bitmap barcodeBitmap = writer.Write(text);

[0064] / / Use System.Drawing to save or display the barcode image

[0065] barcodeBitmap.Save("barcode.png", System.Drawing.Imaging.ImageFormat.Png);

[0066] On the front end, display the barcode image through a label and provide a print button. When the button is clicked, call the window.print() method to print the page.

[0067] Furthermore, the sample management method for a biological laboratory includes the following steps: Read the information of the barcode scanner through the serial port. Based on serial communication, it is possible to reduce costs and improve long-distance communication capabilities. In addition, it can also improve compatibility.

[0068] In a specific preferred embodiment, the sample management method for a biological laboratory includes the following steps: Read the information of the barcode scanner based on serial communication. Preferably, it is implemented as follows:

[0069]

[0070]

[0071] Those skilled in the art can understand that the embodiments of the present invention can be provided in the form of a method, a system, or a computer program product. Therefore, the present invention can take the form of an all-hardware embodiment, an all-software embodiment, or an embodiment combining software and hardware.

[0072] The present invention can be embedded in a computer program product, which includes all the features enabling the implementation of the sample management method for a biological laboratory described herein. The computer program product is contained in one or more computer-readable storage media, which have computer-readable program code contained therein. According to another aspect of the present invention, there is also provided a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, it can execute the steps of the sample management method for a biological laboratory of the present invention. A computer storage medium is a medium in a computer memory for storing certain discontinuous physical quantities. Computer storage media include but are not limited to semiconductors, disk memories, magnetic cores, magnetic drums, magnetic tapes, laser discs, etc. Those skilled in the art can understand that computer storage media are not limited to the foregoing examples, and the foregoing examples are merely for illustration and not limited to the present invention.

[0073] According to another aspect of the present invention, there is also provided a sample management device for a biological laboratory, which includes: a software application program, a memory for storing the software application program, and a processor for executing the software application program. Each program of the software application program can correspondingly execute the steps in the sample management method for a biological laboratory of the present invention.

[0074] A typical combination of hardware and software can be a general computer system with a computer program, and when the program is loaded and executed, it controls the computer system, so that the sample management method disclosed in the present invention can be executed.

[0075] Those skilled in the art can understand that the device can be embodied as a desktop computer, a notebook, a mobile intelligent device, etc., but the foregoing are merely for illustration and also include other intelligent analysis devices equipped with the software application program of the present invention.

[0076] Those skilled in the art can understand that the sample management method for a biological laboratory of the present invention can be implemented by hardware, software, or a combination of software and hardware. The present invention can be implemented in a centralized manner in at least one computer system, or be implemented in a decentralized manner by different parts distributed in several interconnected computer systems. Any computer system or other device that can implement the method is applicable. A common combination of software and hardware can be a general computer system installed with a computer program, and by installing and executing the program, it controls the computer system to run according to the method.

[0077] Corresponding to the embodiments of the method of the present invention, according to another aspect of the present invention, there is also provided a sample management system for a biological laboratory, and the sample management system for the biological laboratory is an application of the method for the sample management of the biological laboratory in computer program improvement.

[0078] Specifically, the sample management system for the biological laboratory includes a sample information input unit, a sample number and barcode generation unit, a barcode printing processing unit, a barcode sample tube matching unit, a sample information scanning and query processing unit, and a sample information query display unit.

[0079] The sample information input unit includes a sample information input acquisition module and an input information processing module. The sample information input acquisition module acquires the input sample-related information, including sample name, storage room, shelf / fridge, layer, plate number, location, etc. The input information processing module transmits the data object to the backend through an AJAX request, and the backend saves the data into the database.

[0080] The sample number and barcode generation unit includes a sample serial number generation module and a ZXing.Net library call module. The sample serial number generation module automatically generates a sample serial number according to a preset rule. Preferably, a unique serial number is generated in the way of timestamp + random number. The ZXing.Net library call module calls the BarcodeWriter class of ZXing.Net to generate a barcode picture according to the serial number and saves it to the specified path on the server.

[0081] The barcode printing processing unit is configured to execute: in response to a barcode printing instruction, call the browser printing function to print out the barcode. Specifically, the barcode printing processing unit passes the barcode picture address to the front end, and the front end displays the barcode through a label and provides a printing button. When the button is clicked, the window.print() method is called.

[0082] The barcode sample tube matching unit acquires the barcode information printed by the sampler at the management end and the position information of the sample tube to which the barcode is pasted, performs matching, and establishes a barcode sample tube matching database.

[0083] The sample information scanning and query processing unit executes the scanning and query of sample information in response to an instruction to scan and query sample information or when a barcode scanner information processing instruction is detected. Specifically, the sample information scanning and query processing unit is provided with a serial port communication processing module. The serial port communication processing module reads the barcode scanner information through serial port communication, calls the SerialPort class in C# to open the serial port, listens to the data sent by the barcode scanner, and reads and processes the data when the data ends (such as when a line feed character is detected).

[0084] The sample information query and display unit queries and displays the corresponding sample information and status through the EFCore technology. Preferably, the sample information query and display unit queries the corresponding sample information in the database according to the barcode information read by the barcode scanner and displays it on the front-end interface.

[0085] More specifically, the sample management system for a biological laboratory further includes a barcode conversion stream module that uses the System.Drawing technology in.Net to convert the generated barcode into a stream and save it as a file.

[0086] More specifically, the sample management system for a biological laboratory further includes a barcode printing execution module configured to execute: calling the window.print method of the browser to print the specified barcode.

[0087] Through the sample management system for a biological laboratory, the workload of sample storage in the biological laboratory can be reduced. Only by entering the sample information, printing and pasting the barcode can the online management of samples be realized. When querying the sample information later, only the barcode needs to be scanned; the sample information of the samples in the biological laboratory can be uniformly stored and managed, with the responsibility assigned to specific input personnel and users, and the usage records of the samples can be queried to ensure the traceability and safety of the samples.

[0088] Preferably, in a specific preferred embodiment, the sample management system for a biological laboratory sets a sample information data storage module for executing sample information data storage.

[0089] In a preferred embodiment, the sample information data storage table of the sample information data storage module is as follows:

[0090] Id uniqueidentifier Sample number Name nvarchar(256) Sample name Room nvarchar(256) Storage room Bridge nvarchar(256) Storage shelf / fridge Storey nvarchar(256) Floor Board nvarchar(256) Board number Coordinate nvarchar(256) Location SampleNo nvarchar(256) Serial number

[0091] Among them, the parameter table data format is the object format of the database. When the user at the user end fills in the relevant data of the sample information on the interface and transmits the corresponding data object to the background of the processing end through an ajax request, the background will store the corresponding data object in the corresponding table of the database one by one.

[0092] In a preferred embodiment, the ZXing.Net library call module includes a NuGet package manager module, a barcode encoder module, a barcode area generation and judgment module, a sample serial number encoding text processing module, a barcode image generation module, and a barcode image saving and display module.

[0093] The NuGet package manager module is installed in the project through the NuGet package manager console and is implemented as:

[0094] Install-Package ZXing.Net。

[0095] The barcode encoder module uses the BarcodeWriter class to generate barcodes to create a barcode encoder. The barcode area generation judgment module judges whether to generate only the barcode area without blank margins. The sample serial number encoding text processing module obtains the sample serial number and processes the text to be encoded. The barcode image generation module generates barcode images. The barcode image saving and displaying module uses System.Drawing to save or display barcode images.

[0096] More specifically, in a preferred embodiment, the ZXing.Net library calling module is implemented to execute:

[0097] Installed through the NuGet Package Manager Console in the project, implemented as:

[0098] Install-Package ZXing.Net

[0099] Using the BarcodeWriter class to generate barcodes to create a barcode encoder, implemented as:

[0100]

[0101]

[0102] The sample management system for a biological laboratory further includes a serial communication reading barcode scanner unit, and the serial communication reading barcode scanner unit reads barcode scanner information through a serial port.

[0103] The serial communication reading barcode scanner unit includes a serial port number definition module, a baud rate definition module, a serial port opening module, a barcode scanner data reading module, a reading end judgment module, a barcode data processing module, a data string reset module, a serial port data error handling module, and a serial port closing module.

[0104] The serial port number definition module defines the serial port number of the barcode scanner, the baud rate definition module defines the baud rate of the barcode scanner, the serial port opening module opens the serial port. After the serial port is opened, the barcode scanner data reading module reads data, the reading end judgment module judges whether the reading is over, the barcode data processing module processes barcode data, such as saving it to a database or sending it to the Web front end, the data string reset module resets the input data string, when an error occurs when reading serial port data, the serial port data error handling module performs corresponding processing on the occurred error, and the serial port closing module closes the serial port.

[0105] More specifically, in a preferred embodiment, the serial communication barcode scanner reading unit is configured to perform:

[0106]

[0107]

[0108]

[0109] Those skilled in the art can understand that the present invention has been described with reference to the flowcharts and / or block diagrams of methods, systems, and computer program products according to the present invention. Each block in the flowchart and / or block diagram, as well as combinations of blocks in the flowchart and / or block diagram, can clearly be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, such that the instructions (through the processor of the computer or other programmable data processing device) produce a device for implementing the functions specified in one or more blocks of the flowchart and / or block diagram.

[0110] Those skilled in the art should understand that the embodiments of the present invention described above and shown in the drawings are only examples and do not limit the present invention. The objectives of the present invention have been fully and effectively achieved. The functions and structural principles of the present invention have been demonstrated and illustrated in the embodiments, and without departing from this principle, the embodiments of the present invention can have any deformation or modification.

Claims

1. A sample management method for a biological laboratory, characterized in that: The sample management method for a biological laboratory comprises the following steps: Provide the user end with real-time access to the entered sample information; Provides a front-end interface to obtain real-time input sample information data, transmits data objects to the processing end through AJAX requests, and saves the data in the database; Obtain preset rules, and generate sample serial numbers according to the preset rules; Call the ZXing.Net library to generate the corresponding barcode; In response to the print instruction, executing the printing of the barcode; Obtain and match the barcode information of the management end and the corresponding pasted sample tube position information; When a barcode scanner command is detected, the barcode scanner information is read based on serial port communication, the C# SerialPort class is called to open the serial port, the data sent by the barcode scanner is monitored, and the data is read and processed when the data ends; and Based on EFCore technology, query and display the corresponding sample information and sample status.

2. The method for sample management in a biological laboratory according to claim 1, wherein the method for sample management in a biological laboratory comprises the following steps: Call the System.Drawing technology in .Net to convert the generated barcode into a stream and save it as a file.

3. The sample management method for a biological laboratory according to claim 1, wherein the sample management method for a biological laboratory comprises the following steps: Call the window.print method to print the specified barcode.

4. The sample management method for a biological laboratory according to claim 1, wherein the sample management method for a biological laboratory comprises the following steps: Install it in your project through the NuGet Package Manager Console.

5. The sample management method for a biological laboratory according to claim 4, wherein the sample management method for a biological laboratory comprises the following steps: Call the BarcodeWriter class to generate a barcode and create a barcode encoder.

6. The sample management method for a biological laboratory as claimed in any one of claims 1 to 5, wherein the sample information is selected from the group consisting of biological laboratory name, sample name, storage room, shelf, refrigerator, layer, plate number, and location information.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the computer program performs the steps of the sample management method for a biological laboratory as claimed in any one of claims 1 to 6.

8. A sample management device for a biological laboratory, characterized in that: include: Memory, for storing software applications, A processor is used to execute the software application, each program of the software application correspondingly executes each step of the sample management method for a biological laboratory as described in any one of claims 1 to 6.

9. A sample management system for a biological laboratory, applying the sample management method for a biological laboratory as claimed in any one of claims 1 to 6, characterized in that: The sample management system for biological laboratories is provided with a sample serial number generation module and a ZXing.Net library calling module. The sample serial number generation module automatically generates a sample serial number according to a preset rule. The ZXing.Net library calling module calls the BarcodeWriter class of ZXing.Net according to the sample serial number to generate a barcode image and saves it to a specified path on the server.

10. The sample management system for biological laboratories as claimed in claim 9, wherein the sample management system for biological laboratories is further provided with a serial communication barcode scanner reading unit for reading barcode scanner information through the serial port.

Images