Sample registration template generation method and device, equipment and medium

Abstract

The invention relates to the technical field of data processing, and discloses a sample registration template generation method, device, equipment and medium, the method comprises the following steps: in response to field definition information input by a user, updating a sample field table in a system based on the field definition information, the sample field table comprising field information corresponding to a plurality of fields; in response to the fact that a user selects an effective field in the sample field table, a sample registration main template is generated based on the effective field in the sample field table, and the effective field is a field related to sample registration; in response to a target field selected by a user in the sample registration main template, a sample registration sub-template corresponding to a target sample type is generated based on the target field, and the sample registration sub-template is used for registering samples under the target sample type. The fields in the template can be set based on actual requirements, and the flexibility of sample registration is improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a sample registration template generation method, device, equipment and medium. Background Art

[0002] With the rapid development of scientific research, medical treatment, testing and other fields, the types and quantity of samples are increasing, and the demand for sample registration and management is becoming increasingly complex. In laboratories, scientific research institutions or enterprises, sample templates are the basis for sample registration and management in the analytical testing industry.

[0003] Sample templates play an important role in laboratories, scientific research institutions and enterprises, helping to ensure the accuracy of experimental data, standardize sample management and promote information sharing. It is very important for laboratories to establish a sound registration system and management system. However, the existing sample template registration method is mainly classified according to different types of samples. Although it can be registered for various types of samples, the sample information that can be input is fixed and other information cannot be expanded, and the flexibility of sample registration is poor. Summary of the invention

[0004] In view of this, the present invention provides a sample registration template generation method, device, equipment and medium to solve the problem of poor flexibility in sample registration when performing sample registration.

[0005] In a first aspect, the present invention provides a method for generating a sample registration template, the method comprising:

[0006] In response to the user inputting field definition information, and based on the field definition information, updating the sample field table inside the system, the sample field table includes: field information corresponding to a plurality of fields;

[0007] In response to a user selecting a valid field in the sample field table, generating a sample registration master template based on the valid fields in the sample field table, wherein the valid fields are: fields related to sample registration;

[0008] In response to the user selecting a target field in the sample registration master template, a sample registration sub-template corresponding to the target sample type is generated based on the target field, and the sample registration sub-template is used to register samples under the target sample type.

[0009] This method can update the fields that may be involved in sample registration according to actual needs through the field definition information input by the user. At the same time, according to the valid fields selected by the user, the fields in the sample registration main template can be customized according to actual needs, so that more diverse and demand-compliant sample registration templates corresponding to different sample types can be generated according to actual conditions to carry out sample registration business, ensure the flexibility of sample registration template generation, and improve sample registration effects.

[0010] In an optional implementation, the field definition information includes: a field name and a link source table corresponding to the first field that the user expects to add;

[0011] The updating of the sample field table within the system based on the field definition information includes:

[0012] Obtaining a sample field table within the system, and adding a field name corresponding to the first field and a link source table to the sample field table;

[0013] Based on the link source table, the field type and field length corresponding to the first field are acquired, and the field information corresponding to the first field in the sample field table is filled.

[0014] In this implementation, by determining the field length and field type corresponding to the first field to be added in the source link table input by the user, the field information corresponding to the first field in the sample field table can be adaptively filled to improve field definition efficiency.

[0015] In an optional implementation, the generating of the sample registration master template based on the valid fields in the sample field table includes:

[0016] Obtaining a field description input by a user, wherein the field description is used to characterize an application sample type corresponding to a valid field;

[0017] The sample registration master template is generated based on each valid field and the corresponding field description, so that the user can select the target field in the sample registration master template according to the field description.

[0018] In this embodiment, by describing the sample type to which each valid field is applied in the sample registration master template, the efficiency of selecting the target field when the user subsequently generates a sample registration sub-template of a specific type can be improved.

[0019] In an optional implementation, after generating a sample registration master template based on valid fields in the sample field table, the method further includes:

[0020] Obtaining a redundant field of a first specific field input by a user, and marking the redundant field of the first specific field in a sample registration master template;

[0021] After the user fills in the sample registration sub-template including the first specific field and generates a sample registration form, determining first registration information corresponding to the first specific field in the sample registration form;

[0022] calling a link source table corresponding to the first specific field, and determining in the link source table second registration information corresponding to the first registration information under the redundant field;

[0023] The sample registration form is supplemented based on the second registration information.

[0024] In this embodiment, redundant fields for specific fields are set in the sample registration main template, so that after the subsequent user registers information for the sample registration sub-template containing the specific field, the registration information of the redundant field can be determined through the source link table to further fill in the sample registration form, making the registration information more comprehensive, so that the relevant information of the sample can be intuitively understood during subsequent viewing.

[0025] In an optional embodiment, after generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes:

[0026] Obtaining a screening field of a second specific field input by a user, and marking the screening field corresponding to the second specific field in the sample registration sub-template;

[0027] When the user registers the second specific field based on the sample registration sub-template, the registrable items after screening under the second specific field are determined based on the registration information corresponding to the screening field, so that the user determines the registration information of the second specific field based on the registrable items.

[0028] In this embodiment, by marking the filter fields of certain specific fields in the sample registration sub-template, subsequent users can filter the optional registration items of the specific fields according to the registration information corresponding to the filter fields when actually registering, so as to improve the user's registration efficiency.

[0029] In an optional embodiment, after generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes:

[0030] Determine the default registration field and corresponding default registration information in the sample registration sub-template according to the target sample type;

[0031] Fill in the to-be-registered items corresponding to the default registration fields in the sample registration sub-template based on the default registration information.

[0032] In this embodiment, after the sample registration sub-template is generated, the sample registration sub-template is registered and filled with default information according to the corresponding sample type, so as to reduce the workload of subsequent users when registering information on the sample registration sub-template.

[0033] In an optional embodiment, after generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes:

[0034] Determining the editing attribute of the third specific field in the sample registration sub-template according to the attribute information input by the user;

[0035] When the user views the sample registration information table generated based on the sample registration sub-template, it is determined whether to display the registration information corresponding to the third specific field according to the editing attribute of the third specific field.

[0036] In this embodiment, by setting the editing properties of specific fields in the sample registration sub-template, when subsequent users view the sample registration information table, they can decide whether to display the registration information of the specific field according to the specific editing properties, thereby achieving confidentiality of the specific registration information.

[0037] In a second aspect, the present invention provides a sample registration template generation device, the device comprising:

[0038] The sample table definition module is used to respond to the user inputting the field definition information and update the sample field table inside the system based on the field definition information, wherein the sample field table includes: field information corresponding to a plurality of fields;

[0039] A master template generation module, for generating a sample registration master template based on the valid fields in the sample field table in response to a user selecting a valid field in the sample field table, wherein the valid fields are fields related to sample registration;

[0040] The sub-template generation module is used to generate a sample registration sub-template corresponding to the target sample type based on the target field in response to the user selecting the target field in the sample registration main template, and the sample registration sub-template is used to register samples under the target sample type.

[0041] In a third aspect, the present invention provides a computer device, comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the sample registration template generation method of the first aspect or any corresponding embodiment thereof by executing the computer instructions.

[0042] In a fourth aspect, the present invention provides a computer-readable storage medium having computer instructions stored thereon, the computer instructions being used to enable a computer to execute the sample registration template generation method of the first aspect or any corresponding embodiment thereof. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0044] Figure 1 is a flow chart of a method for generating a sample registration template according to an embodiment of the present invention;

[0045] Figure 2 is a flow chart of another sample registration template generation method according to an embodiment of the present invention;

[0046] Figure 3 is a schematic diagram of a sample registration process according to an embodiment of the present invention;

[0047] Figure 4 is an overall flow chart of a sample registration system according to an embodiment of the present invention;

[0048] Figure 5 This is an example diagram of a calling process of a redundant field specific value according to an embodiment of the present invention.

[0049] Figure 6 is an example diagram of a cascade filtering process of field information according to an embodiment of the present invention

[0050] Figure 7 is a structural block diagram of a sample registration template generating device according to an embodiment of the present invention;

[0051] Figure 8 It is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0052] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0053] With the rapid development of scientific research, medical treatment, testing and other fields, the types and quantity of samples are increasing, and the demand for sample registration and management is becoming increasingly complex. In laboratories, scientific research institutions or enterprises, sample templates are the basis for sample registration and management in the analytical testing industry.

[0054] Sample templates play an important role in laboratories, scientific research institutions and enterprises, helping to ensure the accuracy of experimental data, standardize sample management and promote information sharing. It is very important for laboratories to establish a sound registration system and management system. However, the existing sample template registration method is mainly classified according to different types of samples. Although it can be registered for various types of samples, the sample information that can be input is fixed and other information cannot be expanded, and the flexibility of sample registration is poor.

[0055] To this end, an embodiment of the present invention provides a sample registration template generation method. Through the field definition information input by the user, the fields that may be involved in the sample registration can be updated according to actual needs. At the same time, according to the valid fields selected by the user, the fields in the sample registration main template can be customized according to actual needs, so that finally, more diverse and demand-compliant sample registration templates corresponding to different sample types can be generated according to actual conditions to carry out sample registration services, ensure the flexibility of sample registration template generation, and improve the sample registration effect.

[0056] According to an embodiment of the present invention, an embodiment of a method for generating a sample registration template is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0057] In this embodiment, a sample registration template generation method is provided, which can be used for the customized generation of the above-mentioned sample registration template. Figure 1 is a flow chart of a method for generating a sample registration template according to an embodiment of the present invention. Figure 1 As shown, the process includes the following steps:

[0058] Step S101, in response to the user inputting field definition information, and based on the field definition information, updating the sample field table inside the system, the sample field table includes: field information corresponding to a plurality of fields.

[0059] At present, when registering relevant samples or items in laboratories, medical treatment, monitoring and other industries, samples are often registered through intelligent information registration systems to record specific information of samples. In some cases, if the user wants to register some other information of the sample when registering information of the sample, that is, to add some registerable fields to improve the amount of information in the sample registration. At this time, the user can define new fields through the information registration system, so that when the sample registration template for registering sample information is generated later, the newly added fields can be selected to enrich the registration information.

[0060] A table definition module can be added to the information registration system, through which users can upload specific information corresponding to the fields they want to add in the sample field table, such as field name, field type, field length and other specific data information.

[0061] The sample field table mainly records all fields and corresponding field information that may be involved in sample registration. For example, taking the information registration system of the petrochemical industry as an example, its sample field table can be shown in Table 1 below:

[0062] Table 1

[0063]

[0064]

[0065] As shown in the above table, multiple fields that may be involved in sample registration are given as examples. For the field information corresponding to these fields, the above table is only an illustrative example and can be further configured based on actual data processing requirements. There is no limitation here. When generating the sample registration sub-template later, it is necessary to select the required fields from the above sample field table to generate the registration template.

[0066] When users need to further enrich sample fields due to actual business needs, they can upload newly defined fields and the specific information corresponding to the fields through relevant modules within the system, such as the table definition module. After receiving the definition information uploaded by the user, the information registration system will update the sample field table according to the uploaded specific field information.

[0067] Step S102, in response to the user selecting a valid field in the sample field table, a sample registration master template is generated based on the valid fields in the sample field table, where the valid fields are fields related to sample registration.

[0068] When generating sample registration sub-templates under various sample types, it is necessary to use the sample registration main template to select the fields needed in the sample registration sub-templates under each sample type. Therefore, in order to ensure the richness of the fields that can be selected in the sub-template when generating the sample registration sub-template, the sample registration main template needs to be improved according to actual business needs.

[0069] It can be understood that the fields involved in the sample field table are all the fields that may be involved when the information system processes data, but not all of these fields need to be used during registration. Therefore, based on the sample information field table, users can further summarize the fields that may need to be used during actual sample registration, that is, valid fields, into the sample registration main template to ensure the richness of the selectable fields when subsequently generating sample registration sub-templates.

[0070] Specifically, the user can select valid fields, ie, fields related to sample registration, in the sample field table through the main template generation module within the information registration system. These fields may be used later when different types of sample registration sub-templates are generated.

[0071] After receiving the valid fields selected by the user, the system will inherit some field information in the sample field information table, such as field name, field type, source link library, and other field information that may be used later, to the sample registration master template.

[0072] Furthermore, users can also further refine the valid fields in the sample registration master template, such as determining the entry method, field description, redundant configuration information, etc. of each valid field, so as to facilitate the selection of target fields when subsequently generating a sample registration sub-master template or assist in subsequent information registration.

[0073] Exemplarily, the specific fields in the sample registration master template may be as shown in Table 2:

[0074] Table 2

[0075]

[0076]

[0077] The field description is mainly used to characterize which types of samples need to use the field, and the entry method refers to whether the field is actually entered by filling in or selecting.

[0078] Redundant configuration information refers to the redundant field corresponding to this field. Taking the device code as an example, after the device name is configured as a redundant field of the device code, when subsequent users register information for the registered device code, they only need to enter the device code to store the device name in the sample information table, which is convenient for subsequent data query applications.

[0079] Step S103, in response to the user selecting a target field in the sample registration master template, a sample registration sub-template corresponding to the target sample type is generated based on the target field, and the sample registration sub-template is used to register samples under the target sample type.

[0080] The sample registration sub-template is the registration template used by users to register samples in actual business scenarios. Users upload specific information in the sample registration sub-template to generate the final sample registration information table, which records the specific registration information of a sample. Therefore, generating a sample registration sub-template through custom settings can ensure the flexibility of setting the items that can be registered when registering samples.

[0081] When generating a sample registration sub-template, the user can select the target field required by the sample registration sub-template corresponding to a certain sample type from the sample registration main template in the sub-template generation module within the information system to generate the sample registration sub-template. The information registration system can generate a sample registration sub-template corresponding to a certain sample type according to the user's target field selection instruction under actual business needs.

[0082] Specifically, after generating the sample registration sub-template, the user can further set each target field in the sample registration sub-template, such as determining the filter field corresponding to a specific target field in the sample registration sub-template, where the filter field also belongs to the target field in the sub-template.

[0083] By setting the filter field, when the user subsequently registers information for the sample registration sub-template, after the user registers the filter field, when registering a specific target field mentioned above, the options for the specific target sub-segment can be simplified according to the specific registration information of the filter field, thereby improving registration efficiency.

[0084] The sample registration template generation method provided in this embodiment can update the fields that may be involved in sample registration according to actual needs through the field definition information input by the user. At the same time, according to the valid fields selected by the user, the fields in the sample registration main template can be customized according to actual needs, so that more diverse and demand-compliant sample registration templates corresponding to different sample types can be generated according to actual conditions to carry out sample registration services, ensure the flexibility of sample registration template generation, and improve sample registration effects.

[0085] According to an embodiment of the present invention, another sample registration template generation method embodiment is provided, which can be used for custom generation of sample registration templates. Figure 2 FIG. 1 is a flow chart of another sample registration template generation method according to an embodiment of the present invention. Figure 2 As shown, the process includes the following steps:

[0086] Step S201, in response to the user inputting field definition information, and based on the field definition information, updating the sample field table inside the system, the sample field table includes: field information corresponding to a plurality of fields.

[0087] Specifically, the field definition information includes: the field name and the link source table corresponding to the first field that the user expects to add.

[0088] In the database of the information registration system, in actual business scenarios, there will be a large number of data tables, which have a large number of fields. For different fields, there is a corresponding main table, which has specific field information of the field and other fields related to the field.

[0089] The source link table can be understood as the main table of the first field, which contains the specific field information of the first field that the user expects to add, such as field length, field type, etc.

[0090] In step S201, the sample field table in the system is updated based on the field definition information, including:

[0091] Step S201 - 1 , obtaining a sample field table within the system, and adding a field name corresponding to the first field and a link source table to the sample field table.

[0092] It can be understood that when a user adds a new field in the sample field table, he can upload the specific name and link source table corresponding to the first field he wants to add, so that the information registration system can directly call the specific field information under the corresponding name of the first field in the link source table, that is, the field type, field length, etc., thereby adding a new field to the sample field table.

[0093] Step S201 - 2 : acquiring the field type and field length corresponding to the first field based on the link source table, and filling in the field information corresponding to the first field in the sample field table.

[0094] The system can search for specific field information under the corresponding name of the first field in the link source table, i.e., field type, field length, etc., based on the specific field name corresponding to the first field that the user expects to add in the sample field table and the link source table input by the user, thereby filling in the specific information of the newly added first field in the sample field table, thereby completing the update of the sample field table.

[0095] Step S202, in response to the user selecting a valid field in the sample field table, a sample registration master template is generated based on the valid fields in the sample field table, where the valid fields are fields related to sample registration.

[0096] Specifically, in step S202, a sample registration master template is generated based on valid fields in the sample field table, including:

[0097] Step S202-1, obtaining a field description input by a user, where the field description is used to characterize an application sample type corresponding to a valid field.

[0098] It can be understood that when creating a sample registration master template, after selecting the target field, the user can enter the specific field description corresponding to the target field, where the field description mainly includes which type of sample registration the target field applies to. Figure 1 In Table 2 of the illustrated embodiment, the field description corresponding to the sampling point is for chemical products, indicating that the field is mainly used for sample registration under the chemical product type; the field description corresponding to the sample name is shared, indicating that the field can be used for sample registration under all product types.

[0099] Step S202-2, generating a sample registration master template based on each valid field and the corresponding field description, so that the user can select a target field in the sample registration master template according to the field description.

[0100] After receiving the relevant information input by the user, the information registration system can inherit the field information in the sample field table, such as field length, field type, etc., according to the specific fields selected by the user when generating the sample registration master template, and at the same time set the field description corresponding to the selected field according to the specific field description entered by the user to generate the sample registration master template.

[0101] Step S203, obtaining the redundant field of the first specific field input by the user, and marking the redundant field of the first specific field in the sample registration master template.

[0102] It can be understood that after the user generates the sample registration master template, he can further set redundant fields for certain fields in the master template, that is, set redundant fields for the first specific field. Before explaining the redundant fields, the redundant relationship is explained first. The redundant relationship can be understood as the information represented by certain fields corresponding to each other. For example, for a certain device code, its corresponding device name is also determined. The device code and the device name are in a redundant relationship, and the two are redundant fields to each other. Taking Table 2 in the above-mentioned embodiment 1 as an example, the redundant field of the first specific field, that is, the device code, can be set to the device name. The specific redundant configuration needs to be set in combination with the actual business scenario. For some other fields, redundant configuration can also be performed based on the above principles, which will not be repeated here. The specific role of the redundant field can be seen. Figure 3 The embodiment shown.

[0103] Step S204: In response to the user selecting a target field in the sample registration master template, a sample registration sub-template corresponding to the target sample type is generated based on the target field. The sample registration sub-template is used to register samples under the target sample type. Figure 1 Step S103 of the embodiment will not be described in detail here.

[0104] Step S205, obtaining the screening field of the second specific field input by the user, and marking the screening field corresponding to the second specific field in the sample registration sub-template.

[0105] After the sample registration sub-template is generated according to the user's selection, the system can receive the user's input for certain fields, that is, the second specific field's screening field, so as to mark the second specific extreme in the sample registration sub-template and set its corresponding screening field. For example, reference can be made to Table 3, which is a sample registration sub-template after the screening field is set.

[0106] Table 3

[0107]

[0108] As shown in Table 3 above, the filtering conditions for the sampling point code are the device code field and the sample type field. It can be understood that in the entire information registration system, the number of sampling points involved is extremely large. By setting the filtering conditions, that is, the specific filtering fields, when the user subsequently registers the sampling points, the optional sampling points can be filtered according to the specific registration information of the sample type and the device name, thereby simplifying the user's screening workload when registering samples through the sample registration sub-template.

[0109] Step S206, determining the default registration field and corresponding default registration information in the sample registration sub-template according to the target sample type;

[0110] Fill in the unregistered items corresponding to the default registration fields in the sample registration sub-template based on the default registration information.

[0111] It can be understood that for different sample types, the system can pre-set the default registration fields and corresponding registration information corresponding to the sample type. After obtaining the sample registration sub-template under a certain sample type, the default registration fields and corresponding default registration information corresponding to the sample type can be called.

[0112] After the sample registration sub-template is generated, the default registration fields in the sample registration sub-template can be directly filled with corresponding registration information to reduce the registration workload of the user in subsequent actual registration services.

[0113] Exemplarily, which fields belong to the default registration fields can be marked in the sample field table, so that after the sample registration sub-template is generated, the corresponding mark is inherited, and the corresponding default registration information is called to complete the information filling.

[0114] Step S207: determining the editing attribute of the third specific field in the sample registration sub-template according to the attribute information input by the user.

[0115] It can be understood that after generating the sample registration sub-template, the user can further set the editing properties of certain fields, such as setting the editing properties of certain specific fields to be unreadable. In this case, after the subsequent user completes the registration of the specific field and generates the actual sample registration form, when viewing the sample registration form, the specific registration information of the specific field cannot be viewed, thereby achieving confidentiality of information.

[0116] The above steps S201-S207 are the main process of the system in generating a sample registration sub-template. When performing sample registration based on the sample registration sub-template generated in the above steps, according to an embodiment of the present invention, a sample registration process example diagram is provided, as shown in FIG. Figure 3 As shown, including:

[0117] Step S301, when the user registers the second specific field based on the sample registration sub-template, the screened registrable items under the second specific field are determined based on the registration information corresponding to the screening field, so that the user determines the registration information of the second specific field based on the registrable items.

[0118] With the above Figure 2Corresponding to the screening field set in step S205 of the illustrated embodiment, during the actual registration business processing, when the user registers the corresponding information according to a sample registration sub-template, when registering the second specific field involved in the above step S205, the system can determine the registrable items of the second specific field based on the registration information of the corresponding screening field, thereby allowing the user to determine the registration information of the second specific field more efficiently.

[0119] Step S302, after the user fills in the sample registration sub-template containing the first specific field and generates a sample registration form, determining the first registration information corresponding to the first specific field in the sample registration form;

[0120] Calling the link source table corresponding to the first specific field, and determining the second registration information corresponding to the first registration information under the redundant field in the link source table;

[0121] The sample registration form is supplemented based on the second registration information.

[0122] It can be understood that, corresponding to the redundant fields set in the above step S203, when the user fills in the sample registration sub-template, a specific sample registration information table is generated, and the information of the redundant fields can be adaptively supplemented in the table.

[0123] Specifically, the system obtains the first registration information of the first specific field, then searches for the redundant field corresponding to the first specific field in the source link table corresponding to the first specific field, and determines the second registration information of the corresponding redundant field based on the first registration information corresponding to the first specific field.

[0124] For example, the source link table includes a plurality of specific information corresponding to the device name, which may be shown in Table 4 below:

[0125] Table 4

[0126] Device Code Device Name Additional Information 0001 First device ...... 0002 Second device ...... 0003 The third device ......

[0127] Assuming that the first registration information entered by the user is the first device, the second registration information under the redundant field of device code can be determined in the table, that is, 0001. A new device code field can be created in the sample registration table and its corresponding registration information, 0001, can be filled in at the same time.

[0128] In another example, there are two fields in a sample registration sub-template that are redundant with each other. After the user registers one of the fields, the other field can be adaptively registered using the above implementation to reduce the registration workload.

[0129] Step S303: when the user views the sample registration information table generated based on the sample registration sub-template, it is determined whether to display the registration information corresponding to the third specific field according to the editing attribute of the third specific field.

[0130] Corresponding to the editing attribute set in step S207, when the user subsequently views a sample registration form, the editing attribute of the specific field can be used to determine whether to display it to the user. Further editing attributes can also be: editable, non-editable, etc., to further ensure the security of registration information.

[0131] Exemplarily, the registration information table generated by the above method embodiment may be shown in Table 5 below:

[0132] Table 5

[0133]

[0134] As shown in the table above, the sample name, specification model, sampling date, device name, and sampling point name are automatically filled in according to the default settings in the above related steps, and the sampling point is selected after filtering according to the actual filter fields.

[0135] The sample registration template generation method provided in the embodiment of the present invention can update the fields that may be involved in sample registration according to actual needs through the field definition information input by the user. At the same time, according to the valid fields selected by the user, the fields in the sample registration main template can be customized according to actual needs, so that more diverse and demand-compliant sample registration templates corresponding to different sample types can be generated according to actual conditions to carry out sample registration services, ensure the flexibility of sample registration template generation, and improve sample registration effects.

[0136] At the same time, the field information corresponding to the first field in the sample field table is adaptively filled according to the source link table input by the user to improve the field definition efficiency; and the field descriptions corresponding to each field are set in the sample registration main template to improve the selection efficiency of the target field; in the sample registration main template, redundant fields of specific fields are set, and the registration information of the redundant fields is determined through the source link table to further fill in the sample registration form, so that the registration information is more comprehensive; the screening fields of certain specific fields are marked in the sample registration sub-template to improve the user's registration efficiency; after the sample registration sub-template is generated, the default information is registered and filled to reduce the workload of information registration; the editing properties of specific fields in the sample registration sub-template are set to keep specific registration information confidential.

[0137] In order to facilitate understanding of the above method embodiment, according to an embodiment of the present invention, a flow chart of the overall sample registration system is provided, as shown in FIG. Figure 4 shown.

[0138] The first step is to create a table definition system, which is used to define the structure of the sample table and the field link relationship, that is, the output data table sample. The table structure can be dynamically adjusted according to industry characteristics and laboratory needs to adapt to different types of samples and test items. The flexibility of this dynamic table structure design ensures that the system can be widely used in various laboratory environments.

[0139] The system provides data definition, query, update and management functions for the standard SQL language. By defining the column name, data type, field length, constraints, etc. of the table structure, data can be stored and managed efficiently. It also allows users to set the link relationship between the fields of this table and other data tables to achieve data association query and field synchronization update. For example, the device code field of the sample table is derived from the code field of the device table. If the length of the device table code field is increased from 10 to 20, the length of the device code field of the sample table will be increased to 20 at the same time. A sample table is obtained through table definition, which contains the link source of each field in the sample table.

[0140] The second step is to create a master template definition system. Based on the sample table definition information, the master template system is created to set the comprehensive main information of the sample. Users are supported to customize input fields according to actual needs to meet the specific needs of different laboratories.

[0141] By selecting valid sample registration business fields from the table definition of the sample table, the definition of all types of sample attributes is supported, such as the device, sampling point, sample name, product specification model of chemical products, the sample supplier, production batch, vehicle number, etc. of raw materials, as well as other information required for various types of samples. The information required for various sample registrations is integrated and created into the main template.

[0142] The master template system also supports the setting of redundant fields and the configuration of redundant logic to meet the user's needs for recording specific attribute information. For example: when configuring the device code and device name in the sample master template, the device name is configured as a redundant field for the device code. Then, when registering a sample, you only need to enter the device code, and the device code and device name can be stored at the same time. In order to facilitate subsequent data queries, it is usually necessary to redundantly provide some sample information. Through this redundant method, when other redundant information is required, there is no need to modify the code. You only need to configure the redundant fields in the master template to achieve this, which greatly reduces the workload of secondary development. For the redundant steps in this example, please refer to Figure 5 , is a diagram showing an example of a calling process of a specific value of a redundant field according to an embodiment of the present invention, as follows:

[0143] First, assuming that the sample device code is CHLH, its corresponding redundant field is the device name, and the field name of the system redundant field needs to be passed in, such as sample table.device name.

[0144] Next, the redundant dependencies and link sources are queried based on the device name, and it is determined that the device name depends on the device code field, and the link source is: device table.name field (location.name).

[0145] Next, search the link source table (device table location) for the record with the link field (code) = the sample device code ("CHLH");

[0146] Get the redundant field location.name value corresponding to this record ("catalytic cracking unit");

[0147] Write this value ("Fluidic Cracking Unit") to SampleTable.UnitName.

[0148] The third step is to create detailed and specific sample templates. Through the sample template design system, based on the main template, create detailed, extended, and dedicated sample information registration templates. Form a dynamic registration form that meets the needs of different types of samples in the laboratory. These templates can inherit the attribute settings of the main template, greatly reducing the workload of maintaining templates, and allowing users to add, delete, or modify attributes according to specific needs.

[0149] The sample template supports setting default values ​​and cascade filtering between fields. For specific filtering steps, refer to Figure 6 , is an example diagram of a cascade filtering process of field information according to an embodiment of the present invention, such as Figure 6 As shown below:

[0150] First, find the data table that needs to be filtered, such as sample_point; then search for filtering conditions one by one, such as point_location = {device code}, Sample_type = 'central control', and the value of the device code passed in is "CHLH"; pass the parameters into the filtering conditions, and combine the filtering conditions point_location = 'CHLH'and Sample_type = 'central control', filter in the sample_point table according to the filtering conditions, obtain multiple records, and sort the filtered records; display the filtered and sorted records in multiple columns on the page according to the settings.

[0151] The fourth step is to apply the sample template to the sample registration business and implement sample registration through the sample template. Through the sample template, users can quickly enter and manage the information of specific samples, reducing duplication of work and human errors. At the same time, the system can also automatically generate sample labels, sample handover forms, etc. When registering samples, all attributes in the registration form are derived from the configured sample template fields, and the form is dynamically expanded and flexibly displayed according to the configuration information. By setting hidden fields, data confidentiality is achieved and information tampering is avoided. By setting field default values, the workload of repeated entry by personnel is reduced. By setting filtering conditions, the range of data selection can be reduced, so that the amount of displayed information data is small and accurate, which is easy to select.

[0152] The importance of sample templates mainly includes the following aspects:

[0153] (1) Recording the source, processing method, and storage status of experimental samples helps researchers accurately trace the experimental process and avoid data confusion or misuse.

[0154] (2) It helps to establish a standardized sample management system. By keeping detailed records of samples, it can ensure that the storage, use and processing of samples comply with relevant standards and regulations, and reduce experimental errors or safety accidents caused by improper management of different types of samples.

[0155] (3) Facilitate information sharing and collaboration within laboratories and scientific research institutions as well as with other institutions. Through a unified registration template, researchers can easily query and obtain the required sample information, promoting scientific research cooperation, academic exchanges, and data reuse.

[0156] (4) It helps reduce the operational risks of enterprises. By registering and reviewing the source, quality and processing of samples, enterprises can promptly identify and resolve potential problems and avoid customer complaints and legal disputes caused by product quality issues.

[0157] Embodiments of the invention The invention realizes dynamic expansion and flexible and convenient application of the sample template registration page by configuring the sample template. The method is convenient and easy to operate, and is convenient for ordinary operators to make instant adjustments. For repeated input information, the workload of repeated input is reduced by setting default values ​​and redundant information, and has the following effects:

[0158] 1) High flexibility: The sample template can be flexibly configured to achieve dynamic expansion of the sample template registration form. It has high functional flexibility and supports a variety of sample registration form requirements.

[0159] 2) Reduce the workload of data entry: The default values ​​of various information in the sample template registration form can be set according to the actual situation, which can reduce the amount of information input by personnel when registering samples; for redundant information, such as setting the "sampling point name" as a redundant field of "sampling point ID", after setting, the sampling point name will be automatically redundant to the library table according to the "sampling point ID", without the need for personnel to enter it repeatedly.

[0160] 3) Strong confidentiality: The editing properties of each field of the sample template can be configured. When it is set to hidden, the property will be hidden when viewing the sample information. For example, the supplier information of the raw coal sample can be hidden to facilitate blind sample analysis, thereby ensuring the confidentiality of key sample information and preventing users from tampering with the information.

[0161] The embodiment of the present invention can be used in the sample analysis and testing industry, targeting the sample registration business. Traditional sample registration generally divides the sample registration form into multiple categories according to the actual business, and develops and implements it. The development work is large, the sample template is not flexible, and it cannot be easily expanded. When registering the sample template, there is a lot of repeated input information. When it is aimed at different industries, such as chemical, pharmaceutical, new energy, cement, food and other industries, it cannot be popularized and promoted.

[0162] The present invention conveniently performs sample registration through a dynamically extensible sample registration method, helps business personnel to conveniently and flexibly adjust the sample registration form in daily work, is easy to operate, and does not require high technical level of business personnel; for attributes with default information in the system, the input workload of the same sample of different batches is reduced by setting default values; for redundant field information, only the information of the main dependent field can be filled in to avoid repeated input of the same field result; in the face of confidential information, the sample attributes can be hidden so that it is not displayed in the sample registration form, so as to achieve confidentiality and anti-tampering effects. The present invention brings great convenience to business personnel, realizes flexible configuration and free expansion of the sample template registration form, improves the sample registration effect, and greatly improves the sample registration efficiency.

[0163] In this embodiment, a sample registration template generation device is also provided, which is used to implement the above-mentioned embodiments and preferred implementation modes, and the descriptions that have been made will not be repeated. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the device described in the following embodiments is preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceivable.

[0164] This embodiment provides a sample registration template generation device, such as Figure 7 As shown, including:

[0165] The sample table definition module 401 is used to respond to the user input of field definition information and update the sample field table inside the system based on the field definition information. The sample field table includes: field information corresponding to multiple fields.

[0166] The master template generation module 402 is used to generate a sample registration master template based on the valid fields in the sample field table in response to the user selecting a valid field in the sample field table. The valid fields are fields related to sample registration.

[0167] The sub-template generation module 403 is used to generate a sample registration sub-template corresponding to the target sample type based on the target field in response to the user selecting the target field in the sample registration main template. The sample registration sub-template is used to register samples under the target sample type.

[0168] In some optional implementations, the field definition information includes: a field name and a link source table corresponding to the first field that the user desires to add;

[0169] The sample table definition module 401, when updating the sample field table in the system based on the field definition information, includes:

[0170] Obtain the sample field table inside the system, and add the field name corresponding to the first field and the link source table to the sample field table;

[0171] The field type and field length corresponding to the first field are obtained based on the link source table, and the field information corresponding to the first field in the sample field table is filled.

[0172] In some optional implementations, the master template generation module 402, when generating the sample registration master template based on the valid fields in the sample field table, includes:

[0173] Get the field description entered by the user, where the field description is used to characterize the application sample type corresponding to the valid field;

[0174] A sample registration master template is generated based on each valid field and the corresponding field description, so that the user can select the target field in the sample registration master template according to the field description.

[0175] In some optional implementations, the master template generation module 402, after generating the sample registration master template based on the valid fields in the sample field table, is further configured to:

[0176] Obtaining the redundant field of the first specific field input by the user, and marking the redundant field of the first specific field in the sample registration master template;

[0177] After the user fills in the sample registration sub-template including the first specific field and generates a sample registration form, determining first registration information corresponding to the first specific field in the sample registration form;

[0178] Calling the link source table corresponding to the first specific field, and determining the second registration information corresponding to the first registration information under the redundant field in the link source table;

[0179] The sample registration form is supplemented based on the second registration information.

[0180] In some optional implementations, the sub-template generation module 403, after generating the sample registration sub-template corresponding to the target sample type based on the target field, is further configured to:

[0181] Obtaining the filter field of the second specific field input by the user, and marking the filter field corresponding to the second specific field in the sample registration sub-template;

[0182] When the user registers the second specific field based on the sample registration sub-template, the screened registrable items under the second specific field are determined based on the registration information corresponding to the screening field, so that the user determines the registration information of the second specific field based on the registrable items.

[0183] In some optional implementations, the sub-template generation module 403, after generating the sample registration sub-template corresponding to the target sample type based on the target field, is further configured to:

[0184] Determine the default registration field and corresponding default registration information in the sample registration sub-template according to the target sample type;

[0185] Fill in the unregistered items corresponding to the default registration fields in the sample registration sub-template based on the default registration information.

[0186] In some optional implementations, the sub-template generation module 403, after generating the sample registration sub-template corresponding to the target sample type based on the target field, is further configured to:

[0187] Determining the editing attribute of the third specific field in the sample registration sub-template according to the attribute information input by the user;

[0188] When the user views the sample registration information table generated based on the sample registration sub-template, it is determined whether to display the registration information corresponding to the third specific field according to the editing attribute of the third specific field.

[0189] The further functional description of each of the above modules and units is the same as that of the above corresponding embodiments and will not be repeated here.

[0190] The sample registration template generation device in this embodiment is presented in the form of a functional unit, where the unit refers to an ASIC (Application Specific Integrated Circuit) circuit, a processor and memory that executes one or more software or fixed programs, and / or other devices that can provide the above functions.

[0191] The embodiment of the present invention also provides a computer device having the above Figure 7 The sample registration template generating device shown.

[0192] See also Figure 8 , Figure 8 is a schematic diagram of the structure of a computer device provided by an optional embodiment of the present invention, such as Figure 8 As shown, the computer device includes: one or more processors 10, a memory 20, and interfaces for connecting various components, including high-speed interfaces and low-speed interfaces. Various components are connected to each other using different buses for communication, and can be installed on a common mainboard or installed in other ways as needed. The processor can process the instructions executed in the computer device, including instructions stored in or on the memory to display the graphical information of the GUI on an external input / output device (such as, a display device coupled to the interface). In some optional embodiments, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Similarly, multiple computer devices can be connected, and each device provides some necessary operations (for example, as a server array, a group of blade servers, or a multi-processor system). Figure 8 A processor 10 is taken as an example.

[0193] The processor 10 may be a central processing unit, a network processor or a combination thereof. The processor 10 may further include a hardware chip. The hardware chip may be a dedicated integrated circuit, a programmable logic device or a combination thereof. The programmable logic device may be a complex programmable logic device, a field programmable gate array, a general purpose array logic or any combination thereof.

[0194] The memory 20 stores instructions executable by at least one processor 10, so that at least one processor 10 executes the method shown in the above embodiment.

[0195] The memory 20 may include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function; the data storage area may store data created according to the use of the computer device, etc. In addition, the memory 20 may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some optional embodiments, the memory 20 may optionally include a memory remotely arranged relative to the processor 10, and these remote memories may be connected to the computer device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0196] The memory 20 may include a volatile memory, such as a random access memory; the memory may also include a non-volatile memory, such as a flash memory, a hard disk or a solid state drive; the memory 20 may also include a combination of the above types of memory.

[0197] The computer device also includes an input device 30 and an output device 40. The processor 10, the memory 20, the input device 30 and the output device 40 may be connected via a bus or other means. Figure 8 The example of connecting through bus is taken in the following.

[0198] The input device 30 can receive input digital or character information, and generate key signal input related to the user settings and function control of the computer device, such as a touch screen, a keypad, a mouse, a track pad, a touch pad, an indicator bar, one or more mouse buttons, a trackball, a joystick, etc. The output device 40 may include a display device, an auxiliary lighting device (e.g., an LED) and a tactile feedback device (e.g., a vibration motor), etc. The above-mentioned display device includes but is not limited to a liquid crystal display, a light emitting diode, a display and a plasma display. In some optional embodiments, the display device can be a touch screen.

[0199] The embodiment of the present invention also provides a computer-readable storage medium. The method according to the embodiment of the present invention can be implemented in hardware, firmware, or can be implemented as a computer code that can be recorded in a storage medium, or can be implemented as a computer code that is originally stored in a remote storage medium or a non-temporary machine-readable storage medium and will be stored in a local storage medium through a network download, so that the method described herein can be stored in such software processing on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. Among them, the storage medium can be a magnetic disk, an optical disk, a read-only storage memory, a random access memory, a flash memory, a hard disk or a solid-state hard disk, etc.; further, the storage medium can also include a combination of the above types of memories. It can be understood that a computer, a processor, a microprocessor controller, or programmable hardware includes a storage component that can store or receive software or computer code. When the software or computer code is accessed and executed by a computer, a processor, or hardware, the method shown in the above embodiment is implemented.

[0200] Although the embodiments of the present invention have been described in conjunction with the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the present invention, and such modifications and variations are all within the scope defined by the appended claims.

Claims

1. A method for generating a sample registration template, characterized in that: The method comprises: In response to the user inputting field definition information, and based on the field definition information, updating the sample field table inside the system, the sample field table includes: field information corresponding to a plurality of fields; In response to a user selecting a valid field in the sample field table, generating a sample registration master template based on the valid fields in the sample field table, wherein the valid fields are: fields related to sample registration; In response to the user selecting a target field in the sample registration master template, a sample registration sub-template corresponding to the target sample type is generated based on the target field, and the sample registration sub-template is used to register samples under the target sample type.

2. The method according to claim 1, characterized in that The field definition information includes: the field name and link source table corresponding to the first field that the user wants to add; The updating of the sample field table within the system based on the field definition information includes: Obtaining a sample field table within the system, and adding a field name corresponding to the first field and a link source table to the sample field table; Based on the link source table, the field type and field length corresponding to the first field are acquired, and the field information corresponding to the first field in the sample field table is filled.

3. The method according to claim 1, characterized in that The generating of the sample registration master template based on the valid fields in the sample field table includes: Obtaining a field description input by a user, wherein the field description is used to characterize an application sample type corresponding to a valid field; The sample registration master template is generated based on each valid field and the corresponding field description, so that the user can select the target field in the sample registration master template according to the field description.

4. The method according to claim 2, characterized in that: After generating a sample registration master template based on the valid fields in the sample field table, the method further includes: Obtaining the redundant fields of the first specific field input by the user, and marking the redundant fields of the first specific field in the sample registration master template; After the user fills in the sample registration sub-template including the first specific field and generates a sample registration form, determining first registration information corresponding to the first specific field in the sample registration form; calling a link source table corresponding to the first specific field, and determining in the link source table second registration information corresponding to the first registration information under the redundant field; The sample registration form is supplemented based on the second registration information.

5. The method according to claim 1, characterized in that: After generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes: Obtaining a screening field of a second specific field input by a user, and marking the screening field corresponding to the second specific field in the sample registration sub-template; When the user registers the second specific field based on the sample registration sub-template, the registrable items after screening under the second specific field are determined based on the registration information corresponding to the screening field, so that the user determines the registration information of the second specific field based on the registrable items.

6. The method according to claim 1, characterized in that After generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes: Determine the default registration field and corresponding default registration information in the sample registration sub-template according to the target sample type; Fill in the to-be-registered items corresponding to the default registration fields in the sample registration sub-template based on the default registration information.

7. The method according to claim 1, characterized in that After generating the sample registration sub-template corresponding to the target sample type based on the target field, the method further includes: Determining the editing attribute of the third specific field in the sample registration sub-template according to the attribute information input by the user; When the user views the sample registration information table generated based on the sample registration sub-template, it is determined whether to display the registration information corresponding to the third specific field according to the editing attribute of the third specific field.

8. A sample registration template generation device, characterized in that: The device comprises: The sample table definition module is used to respond to the user inputting the field definition information and update the sample field table inside the system based on the field definition information, wherein the sample field table includes: field information corresponding to a plurality of fields; A master template generation module, for generating a sample registration master template based on the valid fields in the sample field table in response to a user selecting a valid field in the sample field table, wherein the valid fields are fields related to sample registration; The sub-template generation module is used to generate a sample registration sub-template corresponding to the target sample type based on the target field in response to the user selecting the target field in the sample registration main template, and the sample registration sub-template is used to register samples under the target sample type.

9. A computer device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the sample registration template generation method according to any one of claims 1 to 7 by executing the computer instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the sample registration template generation method according to any one of claims 1 to 7.

Images