User parameter configuration method, system, and apparatus for polymerase chain reaction technology

Abstract

A user parameter configuration method for polymerase chain reaction technology, comprising the following steps: configuring system parameters, Mix parameters and PCR program parameters; configuring PCR scheme parameters; program parsing system parameters, Mix parameters and scheme parameters; and bringing the parsed parameters into the PCR program of a PCR instrument for experiment; wherein json string processing is performed when storing data, and the json string is stored in a field in a table in a database; wherein json deserialization objects or arrays are executed when displaying data, and the page traverses the objects or arrays to display data; the method further comprises the steps of: obtaining data of a detailed table filled in by a user in a foreground interface, and performing data verification; after the data verification passes, the data is converted into a json string, and the data of the json serialized string is transmitted to a background; the background processes the json string into objects or object arrays for logical processing; and the processed objects or object arrays are converted into a json string and stored in a database.

Description

Technical Field

[0001] This invention relates to the field of computers, and more particularly to a method, system, and device for configuring user parameters for polymerase chain reaction (PCR) technology. Background Technology

[0002] Nucleic acid research has a history of over 100 years. DNA synthesis has evolved from in vivo to in vitro methods, and then to the current PCR (polymerase chain reaction) technology for DNA amplification. PCR technology has also continuously developed, gradually evolving into various PCR techniques, each with more complex and different parameter configurations. For current PCR techniques, many parameters need to be manually entered by researchers, often requiring a significant amount of time and potentially leading to errors and incorrect parameter settings. Furthermore, there are very few software programs specifically designed for PCR technology. Summary of the Invention

[0003] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology, which can replace manual parameter configuration by the user. The user no longer needs to fill in too many parameters. The user can use the pre-configured parameter table anywhere, allowing the user to have more time to do other work and improving production efficiency.

[0004] One objective of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. Data storage employs JSON stringification, and the JSON string is then stored in a field of a table in a database. Data display utilizes JSON deserialized objects or arrays, with the page iterating through these objects or arrays to display the data. This data storage and retrieval method allows for more flexible and varied data processing, enabling JSON data to be processed both on the front end and the back end. Backend JSON data processing requires a JsonConverter for serialization or deserialization.

[0005] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. It adopts the MVC pattern, with clear code hierarchy and separation of pages, logic, and data interaction. If a certain layer of logic is wrong, the corresponding layer can be quickly found and modified, which is highly efficient. The code coupling is low, which is convenient for quick modification and only requires modification of a small amount of code to achieve the desired result.

[0006] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. This method uses EF (Entity Framework) to interact with the database, eliminating the need for developers to rely on ADO.NET to write database operation code. With EF, developers can directly use the data manipulation methods provided by EF to operate the database, freeing them from the need to write database operation code and allowing them to focus on logical issues, thus shortening the program development cycle.

[0007] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. The provided module pages all use the AJAX + distributed view method, making the page data display more user-friendly, unlike traditional pages that provide a poor user experience, and making human-computer interaction more user-friendly.

[0008] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. This invention utilizes numerous jQuery plugins, including a front-end data validation plugin to verify the format of input data; and a message prompt plugin that, in conjunction with relevant stylesheet files, provides various information to the user. For example, if a user wants to delete an object, a confirmation prompt will appear, thereby improving the user experience and making the human-computer interaction more user-friendly.

[0009] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology. The parameter configuration is programmed, and users only need to fill it in once for life, avoiding the previous continuous and repetitive parameter configuration, greatly improving work efficiency, saving manpower and material resources, increasing production efficiency, and thus reducing workload.

[0010] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology, wherein the parameter configuration is implemented in the program, making the production process more simplified and standardized.

[0011] One of the objectives of this invention is to provide a user parameter configuration method, system, and device for polymerase chain reaction (PCR) technology, which streamlines business processes, makes business operations more standardized and convenient, and transforms production into intelligent and information-based processes, thereby enabling business standardization through information technology.

[0012] To achieve at least one of the above-mentioned objectives, the present invention provides a user parameter configuration method for polymerase chain reaction (PCR) technology, comprising the following steps:

[0013] Configure system parameters, mix parameters, and PCR program parameters; configure PCR protocol parameters, where each PCR protocol includes a system, a mix, a PCR program, and the status of the pipette tip; the program parses the system parameters, mix parameters, and protocol parameters; and inputs the parsed parameters into the PCR program of the PCR instrument for experiments;

[0014] When storing data, JSON stringification is performed, and the JSON string is stored in a field of a table in the database; when displaying data, JSON deserialization is performed to create an object or array, and the page iterates through the object or array to display the data.

[0015] The user parameter configuration method for polymerase chain reaction technology further includes an unstructured data storage step: obtaining data from a detailed table filled in by the user on the front-end interface and performing data validation; after the data validation is passed, the data is converted into a JSON string, and the serialized JSON string is transmitted to the back-end; the back-end processes the JSON string into an object or an array of objects for logical processing; and the processed object or array of objects is converted back into a JSON string and stored in the database.

[0016] In some embodiments, the user parameter configuration method for polymerase chain reaction (PCR) technology further includes a dbfirst development mode step: preparing a database using SQL Server; using a database model in Visual Studio with an empty dbfirst mode; selecting a server, selecting the required database, and testing the connection; if a connection success message is displayed, clicking OK, and writing the database connection string in the configuration, the backend database connection is established, thus enabling the use of EF language to operate the database in the code. When it is necessary to operate on other databases, a new database model is created with an empty dbfirst mode, and the corresponding connection string is filled in the configuration, thereby performing operations on both databases.

[0017] In some embodiments, the user parameter configuration method for polymerase chain reaction technology further includes a data persistence step: inputting data on the page and transmitting the data to the backend; the backend processing the data according to business requirements; EF operation data interacting with the database; and persisting the data to the database.

[0018] In some embodiments, the user parameter configuration method for polymerase chain reaction technology further includes a deserialization method for displaying loaded data steps: the backend obtains a JSON string or array of JSON strings stored in SQL Server; deserializes the JSON string or array of JSON strings into an object or an array of objects; the backend processes the object or array of objects, converts the processed object or array of objects into a JSON string, and passes it to the frontend; and the frontend processes the JSON string and displays the data.

[0019] In some embodiments, the user parameter configuration method for polymerase chain reaction technology further includes a step of displaying parameter results in an MVC manner: the controller obtains data from the database and processes it; the data is converted into a model or model array and passed to the view; and the view displays the data.

[0020] In some embodiments, the user parameter configuration method for polymerase chain reaction technology further includes a formula-based linear calculation PCR reaction configuration step: inputting formula parameters in the front end; calculating the required results in the background based on the formula parameters and the formula; and storing the results in a database.

[0021] According to another aspect of the present invention, a user parameter configuration device for polymerase chain reaction (PCR) technology is also provided, comprising:

[0022] Memory, used to store software applications.

[0023] A processor for executing the software application, wherein each program of the software application correspondingly performs the steps in the user parameter configuration method for polymerase chain reaction technology.

[0024] According to another aspect of the present invention, a user parameter configuration system for polymerase chain reaction (PCR) technology is also provided. This system configures system parameters, mix parameters, PCR program parameters, and PCR protocol parameters; parses the system parameters, mix parameters, and protocol parameters; and inputs the parsed parameters into the PCR program of a PCR instrument for experimentation. Specifically, when storing data, JSON stringification is performed, and the JSON string is stored in a field of a table in a database. When displaying data, JSON deserialization is performed on objects or arrays, and the page iterates through the objects or arrays to display the data.

[0025] In some embodiments, the user parameter configuration system for polymerase chain reaction (PCR) technology further includes an EF entity framework unit. The EF entity framework unit includes an entity data model module, a LINQ to entity module, an entity SQL module, an object service module, an entity client data provider module, an ADO.Net data provider module, and a database module. The LINQ to entity module is a query language written based on the object model, returning entities designed in the conceptual model. The object service module is the entry point for database data access, converting the data returned by the entity client data provider into entity objects. The entity client data provider module is used to convert LINQ to entity or entity SQL into database SQL and interact with the ADO.Net data provider. The ADO.Net data provider module uses standard ADO.Net and database interaction.

[0026] In some embodiments, after the backend processes the data according to the business logic, it interacts with the database through the EF entity framework unit operation data, and the data is persisted to the database. Attached Figure Description

[0027] Figure 1 This is a flowchart of the steps of a user parameter configuration method for polymerase chain reaction technology according to an embodiment of the present invention.

[0028] Figure 2 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention.

[0029] Figure 3 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention.

[0030] Figure 4 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention.

[0031] Figure 5 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention.

[0032] Figure 6 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention.

[0033] Figure 7 This is a flowchart of the steps of the user parameter configuration method for polymerase chain reaction technology according to the above embodiments of the present invention. Detailed Implementation

[0034] The following description is intended to disclose the present invention and enable those skilled in the art to implement it. The preferred embodiments described below are merely examples, and other obvious variations will occur to those skilled in the art. The basic principles of the invention defined in the following description can be applied to other embodiments, modifications, improvements, equivalents, and other technical solutions that do not depart from the spirit and scope of the invention.

[0035] It is 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, while in another embodiment, the number of the element can be multiple, and the term "a" should not be understood as a limitation on the number.

[0036] This invention relates to computer programs. For example... Figure 1 The diagram illustrates a user parameter configuration method for polymerase chain reaction (PCR) technology based on the present invention. It describes a solution for addressing the problems proposed in this invention, which uses a computer program processing flow as a basis to control or process external or internal objects of a computer by executing a computer program compiled according to the above flow.

[0037] Specifically, the user parameter configuration method for polymerase chain reaction technology includes the following steps:

[0038] S100: Configure system parameters, Mix parameters, and PCR program parameters;

[0039] S200: Configure PCR protocol parameters, where each PCR protocol includes a system, a mix, a PCR program, and the status of the pipette tip;

[0040] S300: Program parsing system parameters, Mix parameters, and scheme parameters; and

[0041] S400: Input the parsed parameters into the PCR program of the PCR instrument for experimentation.

[0042] Furthermore, the user parameter configuration method for polymerase chain reaction technology includes the following steps:

[0043] Perform JSON stringification processing when storing data;

[0044] Store the JSON string into a field of a table in the database; and

[0045] When displaying data, a JSON deserialization object or array is performed, and the page iterates through the object or array to display the data. For example... Figure 2 The following is a flowchart of the steps involved in storing unstructured JSON data:

[0046] Front desk parameter details form:

[0047] The parameter details table data has passed validation.

[0048] The parameter details table data is converted into a JSON string and sent to the backend;

[0049] The backend processes JSON strings as objects or arrays of objects for logical processing; and

[0050] Convert the processed object or array of objects into a JSON string and store it in the database.

[0051] In a specific embodiment, unstructured JSON data storage is performed, taking the parameter table and detail table as examples: (1) Parameter table:

[0052]

[0053] (2) Mixing details:

[0054]

[0055]

[0056] (3) System Details Table:

[0057] Volume Deflection int Volume deviation Type string type Name string name Amount int Amount of substance Volume int volume MinAddSampleVolume int Minimum sample volume

[0058] (4) PCR protocol details:

[0059] PCRProgramId Guid? PCR program number MixId Guid? Mix well and number IsChangeGun bool? Should the nozzle be replaced?

[0060] The parameter table uses a database object format, while the detail table uses a C# class data object format. Specifically, the process includes the following steps for storing unstructured JSON data: The data from the detail table entered by the user on the front-end interface is retrieved. After successful data validation, the serialized JSON string is transmitted to the back-end via AJAX. The back-end uses a JsonConverter to convert the JSON string into a C# object or array. Based on business requirements, the C# object or array is processed, and then serialized back into a JSON string using the JsonConverter. Finally, according to Entity Framework (EF), the JSON string is stored in the ParameterValue field of an object in the parameter table of the database.

[0061] It's worth noting that the JSON unstructured data generated through the aforementioned JSON unstructured data storage steps has the following advantages compared to structured data: JSON unstructured data has a single format, always in JSON format, allowing for processing anywhere, with corresponding processing methods available on both the front-end and back-end; while structured data can only be processed on the back-end and is less convenient to process compared to structured data; JSON unstructured data does not require pre-definition, so programs can quickly and easily collect data, while structured data requires pre-definition, making data collection relatively slower; JSON unstructured data can be stored in massive quantities, while structured data is not suitable for massive storage; JSON unstructured data can be permanently stored on disk, such as in a text document, while structured data cannot, and most can only be stored in a database.

[0062] Furthermore, the Entity Framework (EF) in the user parameter configuration method for polymerase chain reaction (PCR) technology described in this invention is an Object-Relational Mapping (O / RM) framework, which allows developers to easily manipulate relational databases, reducing most of the database operation functions that require code implementation. It is an upgrade to ADO.NET, eliminating the need to write database operation code; developers only need to focus on the logic. LINQ can be used in EF to query data, and strong typing can be used to retrieve and manipulate data.

[0063] Specifically, such as Figure 3 The diagram shows the specific structure of the EF Entity Framework. The EF Entity Framework includes an Entity Data Model module, a LINQ to Entity module, an Entity SQL module, an Object Service module, an Entity Client Data Provider module, an ADO.Net Data Provider module, and a Database module. The Entity Data Model module includes a conceptual model, a storage model, and a mapping module. The conceptual model is used for class definitions, the storage model includes database tables, views, stored procedures, and keys, and the mapping module maps the conceptual model to the storage model. The LINQ to Entity module is a query language written based on the object model, returning the entities designed in the conceptual model. The Entity SQL module uses a query language similar to LINQ to Entity. The Object Service module is the main entry point for database data access, converting the data returned by the Entity Client Data Provider into entity objects. The Entity Client Data Provider module converts LINQ to Entity or Entity SQL into database SQL and interacts with the ADO.Net Data Provider. The ADO.Net Data Provider module uses standard ADO.Net to interact with the database.

[0064] In specific implementations, EF has three development modes: code first, database first, and model first. Code first: This mode prioritizes code implementation and allows for changes to database table structures, etc., through migrations. Database first: This mode directly synchronizes changes to database tables to the code. Model first: This mode generates database and domain classes based on the database model.

[0065] In a specific embodiment of the present invention, the EF Entity Framework is implemented using the DB First mode. This includes the following steps: preparing a database using SQL Server; using a database model in Visual Studio with an empty DB First mode; selecting a server, selecting the required database, and testing the connection; if a connection success message appears, clicking OK, and entering the database connection string in the configuration, the backend database connection is established, allowing database operations to be performed using EF's language in the code. When it is necessary to operate on other databases, a new database model is created with an empty DB First mode, and the corresponding connection string is entered in the configuration, thus enabling operations on both databases.

[0066] It's worth noting that the Entity Framework (EF) has many advantages over ADO.NET: With EF, there's no need to write code to manipulate the database, allowing you to focus on logic, which is very convenient. ADO.NET, on the other hand, requires writing code to manipulate the database, which is less convenient. EF can use three schemas to design the database, which is more intuitive, while ADO.NET can only use statements to manipulate the database. EF can connect to multiple databases by adding one or more connection strings in the configuration file, while ADO.NET cannot and can only connect to one database at a time. EF integrates better with Visual Studio, while ADO.NET integrates relatively poorly with Visual Studio.

[0067] Furthermore, such as Figure 4 The flowchart shown illustrates that the user parameter configuration method for polymerase chain reaction (PCR) technology includes a data persistence step to a database.

[0068] Input data on the page and transmit the data to the backend;

[0069] The backend processes the data according to the business logic;

[0070] EF interacts with databases and manipulates data; and

[0071] Data is persisted to a database.

[0072] Furthermore, such as Figure 5The flowchart shown illustrates that the user parameter configuration method for polymerase chain reaction (PCR) technology includes a deserialization method display and loading data step. This deserialization method display and loading data step includes the following steps:

[0073] The backend retrieves the JSON string or array of JSON strings stored in SQL Server;

[0074] Deserializes a JSON string or array of JSON strings into an object or an array of objects;

[0075] The backend processes objects or arrays of objects, converts the processed objects or arrays of objects into JSON strings, and then passes them to the frontend;

[0076] The front-end processes JSON strings and displays the data.

[0077] In a specific embodiment, the deserialization method displays the data loading steps as follows: retrieve the JSON string array or JSON string stored in the database to the backend; convert the JSON string array or JSON string into an object or an array of objects and perform business logic processing; convert the processed object or array of objects into a JSON string and pass it to the frontend; the frontend converts the JSON string into an array, iterates through the array objects and their members, and displays them on the page in a loop.

[0078] In a specific embodiment of the present invention, taking a system detail table as an example, the system detail table is currently stored in the ParameterValue field of the parameter table in the database as a JSON string. First, in the backend, an object from the parameter table is obtained through EF; then, the ParameterValue field of this parameter object is obtained; then, JsonConvert is used to convert this JSON string formatted ParameterValue field into a C# object or object array, and this C# object or object array is processed according to business logic; finally, the processed C# object or object array is converted back to a JSON string using JsonConvert and passed to the frontend, where the frontend processes this JSON string and displays a detail table of objects.

[0079] It is worth mentioning that, in the data loading step of the deserialization method described in this invention, the advantages of displaying data using the deserialization method compared to displaying data without using the deserialization method are as follows: displaying data using the deserialization method allows for the looping of adding tags to the JS file to display the data, while displaying data without using the deserialization method requires iterating through objects or arrays of objects on the page to display the data, thus slowing down the front-end page loading speed; the former does not require the code to be written on the page, while the latter does, making the former more standardized than the latter.

[0080] Furthermore, such as Figure 6 The flowchart shown illustrates that the user parameter configuration method for polymerase chain reaction (PCR) technology includes a step of displaying parameter results using the MVC (Multi-View-Concept) approach. This step includes the following steps:

[0081] The controller retrieves and processes data from the database.

[0082] Transform the data into a model or array of models and pass it to the view; and

[0083] The view displays the data.

[0084] In the MVC pattern, M stands for Model, V for View, and C for Controller. Data exists as an object model, the view displays objects or arrays of objects, and the controller processes objects or arrays of objects retrieved from the database. Using the MVC pattern, the code hierarchy is clear, separating page layout, logic, and data interaction. If any layer has a logical error, the corresponding layer can be quickly located and modified, resulting in extremely high efficiency. The code coupling is low, facilitating rapid modification with only minor code changes required to achieve the desired result.

[0085] In a specific embodiment of the present invention, taking a system detail table as an example, the system detail table JSON field is obtained from the database, and the business module processes the system detail table JSON field according to business logic; then, the processed data is passed to the controller; then, the controller passes the data to the view, and the view displays the data.

[0086] It is worth mentioning that, compared with the traditional three-tier or multi-tier architecture, the MVC approach for displaying parameter results in this invention has the following advantages: reduced code coupling, easier maintenance, and better division of labor and collaboration. If the requirements of any layer change, only the code of that layer needs to be modified, without affecting the code in other layers. In contrast, multi-tier architecture has very high code coupling, which is not conducive to maintenance or division of labor. Once a requirement changes, the logic of many layers needs to be modified. Pages, classes, controllers, etc., can be reused. For example, a template page can be written and used in other pages. Similarly, controllers, etc., can also be reused. In contrast, most pages written in a multi-tier architecture cannot be reused.

[0087] Furthermore, such as Figure 7 The flowchart shown illustrates that the user parameter configuration method for polymerase chain reaction (PCR) technology includes a formula-based linear calculation step for PCR reaction configuration. This formula-based linear calculation step for PCR reaction configuration includes:

[0088] Enter formula parameters in the front end;

[0089] The backend calculates the required result based on the formula parameters and the formula; and

[0090] Store the results in the database.

[0091] The PCR reaction configuration uses a standardized formula. Users input standardized formula parameters on the front end, and the back end calculates the required temperature, temperature gradient, etc. for the PCR reaction based on the formula.

[0092] In a specific embodiment of the present invention, for example, in the system parameter table, the system parameter details interface states: V (total system) = V1 + V2 + V3 (sum of volumes of all solvents in μL), SolV (solution volume in μL) = 4 * a (solution concentration in pmol). In the system parameter details, if the total system volume is 100 μL and the volume deviation is 10%, it is allowed if the sum of the volumes of all solvents is less than 100 μL and within a volume deviation of 10 μL. If only the concentration of the solution type is specified, the volume is calculated using the concentration-to-volume formula described above.

[0093] It is worth mentioning that the formula-based linear calculation method for PCR reaction preparation in this invention adopts a formulaic approach, which has the advantages of being more user-friendly than the traditional direct calculation method: the calculation function does not need to be processed at the front end, resulting in a better user experience; formulaic calculation can improve program performance and reduce code volume and logic.

[0094] Those skilled in the art will understand that embodiments of the present invention can be provided in the form of methods, systems, or computer program products. Therefore, the present invention can take the form of an all-hardware embodiment, an all-software embodiment, or an embodiment combining software and hardware.

[0095] Those skilled in the art will understand that the method of the present invention can be implemented by hardware, software, or a combination of both. The present invention can be implemented centrally in at least one computer system, or distributed in a decentralized manner by different parts distributed across several interconnected computer systems. Any computer system or other device capable of implementing the method is applicable. A common combination of hardware and software can be a general-purpose computer system with computer programs installed, controlling the computer system to operate according to the method by installing and executing the programs.

[0096] This invention can be embedded in a computer program product, which includes all the features that enable the methods described herein to be implemented. The computer program product is contained in one or more computer-readable storage media having computer-readable program code contained therein. According to another aspect of the invention, a computer-readable storage medium is also provided, on which a computer program is stored, which, when executed by a processor, is capable of performing the steps of the methods of the invention. A computer storage medium is a medium in a computer memory used to store some discontinuous physical quantity. Computer storage media include, but are not limited to, semiconductors, disk drives, magnetic cores, magnetic drums, magnetic tapes, laser disks, etc. Those skilled in the art will understand that computer storage media are not limited to the foregoing examples, which are merely illustrative and not intended to limit the invention.

[0097] Corresponding to the embodiments of the method of the present invention, according to another aspect of the present invention, a user parameter configuration system for polymerase chain reaction (PCR) technology is also provided. This user parameter configuration system for PCR technology is an application of the user parameter configuration method for PCR technology of the present invention in the form of computer program improvements. The user parameter configuration system for PCR technology configures system parameters, mix parameters, PCR program parameters, and PCR protocol parameters; parses the system parameters, mix parameters, and protocol parameters; and inputs the parsed parameters into the PCR program of the PCR instrument for experimentation. In parameter configuration, the user parameter configuration system for PCR technology performs JSON stringification processing when storing data, storing the JSON string in a field of a table in the database; when displaying data, it performs JSON deserialization of objects or arrays, and the page iterates through the objects or arrays to display the data. Specifically, the user parameter configuration system for PCR technology includes a JSON unstructured data storage unit, an EF entity framework unit, a data persistence to database unit, a deserialization method for displaying loaded data unit, an MVC method for displaying parameter results unit, and a formula-based linear calculation unit for PCR reaction configuration.

[0098] More specifically, the JSON unstructured storage data unit is used to perform JSON stringification processing when storing data and store the JSON string into a field of a table in the database. More specifically, the JSON unstructured storage data unit includes a detail table data acquisition module, a data validation module, a data transformation and transmission module, a logic processing module, and a JSON string conversion and storage module. The detail table data acquisition module is used to acquire parameter detail table data filled in by the front end; the data validation module is used to validate the acquired parameter detail table data; the data transformation and transmission module is used to convert the parameter detail table data into a JSON string and send it to the back end; the logic processing module is used for the back end to process the JSON string into objects or object arrays for logical processing; and the JSON string conversion and storage module is used to convert the processed objects or object arrays back into JSON strings and store them in the database.

[0099] In a specific embodiment, the parameter table data format is a database object format, and the detail table is a C# class data object format. Specifically, it includes the following steps for storing unstructured JSON data: the detail table data acquisition module acquires the data from the detail table filled in by the user on the front-end interface; the data verification module performs data verification; after the data verification is successful, the data conversion and transmission module transmits the serialized JSON string to the back-end via AJAX; the logic processing module is configured to: use a JsonConverter to convert the JSON string into a C# object or array; process the C# object or array according to business requirements; the JSON string conversion and storage module serializes the processed C# object or array into a JSON string using a JsonConverter; and store the JSON string into the ParameterValue field of an object in the parameter table of the database according to EF (Entity Framework).

[0100] More specifically, the EF Entity Framework unit includes an Entity Data Model module, a LINQ to Entity module, an Entity SQL module, an Object Service module, an Entity Client Data Provider module, an ADO.Net Data Provider module, and a Database module. The Entity Data Model module includes a conceptual model, a storage model, and a mapping module. The conceptual model is used for class definitions, the storage model includes database tables, views, stored procedures, and keys, and the mapping module maps the conceptual model to the storage model. The LINQ to Entity module is a query language written based on the object model, returning the entities designed in the conceptual model. The Entity SQL module uses a query language similar to LINQ to Entity. The Object Service module is the main entry point for database data access, converting the data returned by the Entity Client Data Provider into entity objects. The Entity Client Data Provider module converts LINQ to Entity or Entity SQL into database SQL and interacts with the ADO.Net Data Provider. The ADO.Net Data Provider module uses standard ADO.Net to interact with the database. Furthermore, the EF Entity Framework unit includes three development modes: code-first mode, database-first mode, and model-first mode. Code First: This mode prioritizes code implementation and allows for changes to database table structures through migrations. DB First: This mode directly synchronizes changes to database tables with the code. Model First: This mode generates the database and domain classes based on the database model. Specifically, the DB First development mode in the EF Entity Framework unit is configured as follows: Prepare a database using SQL Server; use an empty DB First model in Visual Studio; select a server and the required database, and test the connection; if the connection is successful, click OK, and enter the database connection string in the configuration. The backend database connection is then established, allowing you to manipulate the database using EF's language in the code. When you need to operate on other databases, create a new database model using an empty DB First model, and then enter the corresponding connection string in the configuration to perform operations on both databases.

[0101] More specifically, the data persistence to the database unit is configured to perform: inputting data on the page, transmitting the data to the backend; the backend processing the data according to business logic; EF operations interacting with the database; and persisting the data to the database.

[0102] More specifically, the deserialization method displays a data loading unit comprising a data acquisition and transmission module, a deserialization processing module, a data interaction module, and a data display module. The data acquisition and transmission module is used to acquire JSON strings or arrays of JSON strings stored in SQL Server on the backend. The deserialization processing module is used to deserialize the JSON strings or arrays of JSON strings into objects or arrays of objects. The data interaction module is used to perform EF operations to interact with the database: the backend processes the objects or arrays of objects, converts the processed objects or arrays of objects into JSON strings, and sends them to the frontend. The data display module is used by the frontend to process the JSON strings and display the data. In a specific embodiment, the data acquisition and transmission module acquires and transmits the JSON string array or JSON string stored in the database to the backend; the deserialization processing module converts the JSON string array or JSON string into objects or arrays of objects and performs business logic processing; the data interaction module converts the processed objects or arrays of objects into JSON strings and sends them to the frontend; the data display module is configured to: convert the JSON strings into arrays on the frontend, iterate through the array objects and their members, and display them on the page in a loop. More specifically, in an embodiment using a system detail table as an example, the system detail table data is stored in the ParameterValue field of the parameter table in the database in JSON string format. The deserialization method for loading data units is specifically configured as follows: First, in the backend, an object from the parameter table is obtained via EF; then, the ParameterValue field of this parameter object is obtained; then, JsonConvert is used to convert this JSON string formatted ParameterValue field into a C# object or object array, and this C# object or object array is processed according to business logic; finally, the processed C# object or object array is converted back to a JSON string via JsonConvert and passed to the frontend, where the frontend processes this JSON string and displays a detail table of objects.

[0103] More specifically, the MVC-based parameter result display unit includes a controller acquisition and processing module, a data transformation and input module, and a view display module. The controller acquisition and processing module retrieves and processes data from the database within the controller. The data transformation and input module transforms the data into a model or model array and inputs it into the view. The view display module displays the data in the view. The MVC-based parameter result display unit adopts the M(Model)V(View)C(Controller) pattern, where data exists in the form of object models, the view displays objects or object arrays, and the controller processes the objects or object arrays retrieved from the database. More specifically, in an embodiment using a system detail table as an example, the controller acquisition and processing module retrieves the JSON fields of the system detail table from the database, the business module processes the JSON fields of the system detail table according to business logic, the data transformation and input module inputs the processed data into the controller, the controller inputs the data into the view, and the view display module displays the data in the view.

[0104] More specifically, the formula-based linear calculation PCR reaction configuration unit is configured to perform: inputting formula parameters in the foreground; calculating the required results in the background based on the formula parameters and formula; and storing the results in the database. More specifically, in an embodiment using a system detail table as an example, in the system parameter detail interface: V (total system) = V1 + V2 + V3 (sum of volumes of various solvents in μL), SolV (solution volume in μL) = 4 * a (solution concentration in pmol). In the system parameter detail, if the total system volume is 100 μL and the volume deviation is 10%, it is allowed if the sum of the volumes of various solvents is less than 100 μL and within a volume deviation of 10 μL. If only the concentration of the solution type is specified, the volume is calculated using the concentration-to-volume formula described above.

[0105] According to another aspect of the present invention, a user parameter configuration device for polymerase chain reaction (PCR) technology is also provided. The device includes: a software application, a memory for storing the software application, and a processor for executing the software application. Each program of the software application is capable of correspondingly executing the steps in the user parameter configuration method for PCR technology of the present invention.

[0106] A typical combination of hardware and software can be a general-purpose computer system with computer programs that, when loaded and executed, control the computer system to perform the methods disclosed in this invention.

[0107] Those skilled in the art will understand that the invention has been described with reference to flowchart illustrations and / or block diagrams of methods, systems, and computer program products according to the invention. Each block in the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can obviously 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 apparatus to produce a machine, thereby instructing (the instructions via the processor of the computer or other programmable data processing apparatus) to generate means for implementing the functions specified in one or more blocks of the flowchart illustrations and / or block diagrams.

[0108] Those skilled in the art should understand that the embodiments of the present invention described above and shown in the accompanying drawings are merely examples and do not limit the present invention. The objectives of the present invention have been fully and effectively achieved. The functional and structural principles of the present invention have been demonstrated and explained in the embodiments, and any modifications or variations of the embodiments of the present invention may be made without departing from these principles.

Claims

1. A method for configuring user parameters for polymerase chain reaction (PCR) technology, characterized in that, The user parameter configuration method for polymerase chain reaction technology includes the following steps: Configure system parameters, mix parameters, and PCR program parameters; configure PCR protocol parameters, where each PCR protocol includes a system, a mix, a PCR program, and the status of the pipette tip; the program parses the system parameters, mix parameters, and protocol parameters; and inputs the parsed parameters into the PCR program of the PCR instrument for experiments; When storing data, JSON stringification is performed, and the JSON string is stored in a field of a table in the database; when displaying data, JSON deserialization is performed to create an object or array, and the page iterates through the object or array to display the data. The user parameter configuration method for polymerase chain reaction (PCR) technology further includes an unstructured data storage step: obtaining data from a detail table filled in by the user on the front-end interface and performing data validation; after successful data validation, the data is converted into a JSON string, and the serialized JSON string is transmitted to the back-end; the back-end processes the JSON string into objects or object arrays for logical processing; and converts the processed objects or object arrays back into JSON strings and stores them in the database, wherein the parameter table data format is the database object format, and the detail table is a C# class data object format; the unstructured data storage step further includes the following steps: obtaining data from a detail table filled in by the user on the front-end interface, validating the data, and then transmitting the serialized JSON string to the back-end via AJAX; the back-end uses a JsonConverter to convert the JSON string into a C# object or array, processes the C# object or array according to business requirements, and then serializes the processed C# object or array back into a JSON string using a JsonConverter, and stores the JSON string in the ParameterValue field of an object in the parameter table of the database according to the Entity Framework. The Entity Framework includes an Entity Data Model module, a LINQ to Entity module, an Entity SQL module, an Object Services module, an Entity Client Data Provider module, an ADO.Net Data Provider module, and a Database module. The Entity Data Model module comprises a conceptual model, a storage model, and a mapping module. The conceptual model defines classes, the storage model includes database tables, views, stored procedures, and keys, and the mapping module maps the conceptual model to the storage model. The LINQ to Entity module is a query language written based on the object model, returning entities designed in the conceptual model. The Entity SQL module uses a query language similar to LINQ to Entity. The Object Services module is the main entry point for database data access, converting data returned by the Entity Client Data Provider into entity objects. The Entity Client Data Provider module converts LINQ to Entity or Entity SQL into database SQL and interacts with the ADO.Net Data Provider. The ADO.Net Data Provider module uses standard ADO.Net to interact with the database. The user parameter configuration method for polymerase chain reaction (PCR) technology further includes the following steps in the Entity Framework's db-first development mode: Prepare a database using SQL Server; use an empty db-first model in Visual Studio; select the server, select the required database, and test the connection; if the connection is successful, click OK, and enter the database connection string in the configuration. The backend database connection is then established, allowing you to manipulate the database using the Entity Framework's language in your code. When you need to operate on other databases, create a new database model, use an empty db-first model, and enter the corresponding connection string in the configuration to perform operations on both databases. The user parameter configuration method for polymerase chain reaction (PCR) technology further includes a data persistence step: inputting data on the page and transmitting the data to the backend; the backend processing the data according to business logic; the Entity Framework interacting with the database; and persisting the data to the database. The user parameter configuration method for polymerase chain reaction technology further includes a deserialization method for displaying loaded data steps: the backend obtains a JSON string or array of JSON strings stored in SQL Server; deserializes the JSON string or array of JSON strings into an object or array of objects; the backend processes the object or array of objects, converts the processed object or array of objects into a JSON string and passes it to the frontend; and the frontend processes the JSON string and displays the data. The deserialization method for loading data further includes the following steps: obtaining a JSON string array or JSON string stored in the database from the backend; converting the JSON string array or JSON string into an object or an array of objects and performing business logic processing; converting the processed object or array of objects into a JSON string and passing it to the frontend; and converting the JSON string into an array on the frontend, iterating through the array objects and their members, and displaying them on the page in a loop. The user parameter configuration method for polymerase chain reaction technology further includes a step of displaying parameter results in an MVC pattern: the controller obtains and processes data from the database; the data is converted into a model or model array and passed to the view; and the view displays the data; wherein, in the MVC pattern, M is the model, V is the view, and C is the controller; the data exists in the form of an object model, the view is used to display objects or object arrays, and the controller is used to process objects or object arrays retrieved from the database; The user parameter configuration method for polymerase chain reaction (PCR) technology includes a formula-based linear calculation PCR reaction configuration step, which includes: inputting formula parameters on the front end; calculating the required results in the back end based on the formula parameters and formulas; and storing the results in a database. The PCR reaction configuration is processed using a formula, obtaining uniform formula parameters input by the user on the front end, and the back end calculates the required temperature and temperature gradient for the PCR reaction based on the formulas.

2. A user parameter configuration device for polymerase chain reaction (PCR) technology, characterized in that, include: Memory, used to store software applications. A processor for executing the software application, wherein each program of the software application correspondingly performs the steps in the user parameter configuration method for polymerase chain reaction technology as described in claim 1.

3. A user parameter configuration system for polymerase chain reaction (PCR) technology, employing the user parameter configuration method for PCR technology as described in claim 1, characterized in that, The user parameter configuration system for polymerase chain reaction (PCR) technology configures system parameters, mix parameters, PCR program parameters, and PCR protocol parameters. It parses these parameters and inputs them into the PCR program of the PCR instrument for experiments. During data storage, it performs JSON stringification, storing the JSON string in a field of a database table. When displaying data, it performs JSON deserialization into objects or arrays, and iterates through these objects or arrays on the page to display the data. The system includes a JSON unstructured data storage unit, an Entity Framework unit, a data persistence unit, a deserialization method for displaying loaded data unit, an MVC-based parameter result display unit, and a formula-based linear calculation unit for PCR reaction configuration. The JSON unstructured data storage unit performs JSON stringification during data storage and stores the JSON string in a field of a database table. The Framework entity framework unit includes an entity data model module, a LINQ to entity module, an entity SQL module, an object service module, an entity client data provider module, an ADO.Net data provider module, and a database module. The LINQ to entity module is a query language written based on the object model, returning entities designed in the conceptual model. The object service module is the entry point for database data access, converting the data returned by the entity client data provider into entity objects. The entity client data provider module is used to convert LINQ to entity or entity SQL into database SQL and interact with the ADO.Net data provider. The ADO.Net data provider module uses standard ADO.The system interacts with the database; the backend processes data according to business logic, and then interacts with the database through the Entity Framework unit, persisting the data to the database. The data persistence unit is configured to perform the following actions: inputting data on the page and transmitting it to the backend; the backend processes the data according to business logic; the Entity Framework interacts with the database; and the data is persisted to the database. The deserialization method for loading data includes a data acquisition and transmission module, a deserialization processing module, a data interaction module, and a data display module. The data acquisition and transmission module is used to obtain JSON strings or arrays of JSON strings stored in SQL Server. The deserialization processing module is used to deserialize the JSON strings or arrays of JSON strings into objects or arrays of objects. The data interaction module is used to execute Entity Framework... Framework operations involve data and database interaction: the backend processes objects or arrays of objects, converts the processed objects or arrays of objects into JSON strings, and passes them to the frontend. The data display module is used by the frontend to process the JSON strings and display the data. The MVC-based parameter result display unit includes a controller acquisition and processing module, a data transformation and input module, and a view display module. The controller acquisition and processing module retrieves and processes data from the database within the controller. The data transformation and input module converts the data into models or arrays of models and passes them to the view. The view display module displays the data in the view. The formula-based linear calculation PCR reaction configuration unit is configured to execute: the frontend inputs formula parameters; the backend calculates the required results based on the formula parameters and the formula; and the results are stored in the database.

Images