CN115376636A - Method, system and device for generating gauge and computer readable storage medium - Google Patents

Method, system and device for generating gauge and computer readable storage medium Download PDF

Info

Publication number
CN115376636A
CN115376636A CN202210937747.4A CN202210937747A CN115376636A CN 115376636 A CN115376636 A CN 115376636A CN 202210937747 A CN202210937747 A CN 202210937747A CN 115376636 A CN115376636 A CN 115376636A
Authority
CN
China
Prior art keywords
scale
annotation
generating
data
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210937747.4A
Other languages
Chinese (zh)
Inventor
何永正
刘林奎
马登伟
钱钰琦
刘笛
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Henan Xiangyu Medical Equipment Co Ltd
Original Assignee
Henan Xiangyu Medical Equipment Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Henan Xiangyu Medical Equipment Co Ltd filed Critical Henan Xiangyu Medical Equipment Co Ltd
Priority to CN202210937747.4A priority Critical patent/CN115376636A/en
Publication of CN115376636A publication Critical patent/CN115376636A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G16INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
    • G16HHEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
    • G16H10/00ICT specially adapted for the handling or processing of patient-related medical or healthcare data
    • G16H10/20ICT specially adapted for the handling or processing of patient-related medical or healthcare data for electronic clinical trials or questionnaires

Abstract

The application discloses a method for generating a gauge, which comprises the following steps: receiving a quantity table generation instruction; reading the structure information of a base table corresponding to the table generation instruction from a database; and analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result. According to the method and the device, all information required by the scale is written into the library table in the form of the table annotation and the table field annotation respectively, the additional data table is not needed to be set to store the scale information, the scale can be generated by directly utilizing the library table, the additional tool is not needed to maintain and call the scale information, the compatibility problem is avoided, the modification of the scale is not needed to be additionally set, the setting information is stored in other library tables or other files, the manual checking corresponding link between different files or library tables is omitted, the scale corresponding relation is directly established on the table annotation and the table field annotation, errors are avoided, and the possibility of data deviation is reduced.

Description

Method, system and device for generating gauge and computer readable storage medium
Technical Field
The present application relates to the field of software development technologies, and in particular, to a method, a system, an apparatus, and a computer-readable storage medium for generating a metric table.
Background
Medical rehabilitation evaluation is frequently used in hospital rehabilitation departments, at present, a part of doctors are manual evaluation, the doctors ask questions according to a set table, the patients answer, the doctors give scores according to the answers of the patients, the patient performance such as the action, expression, behavior, attitude and the like of the patients is observed, the scores are recorded in the table, the total score is evaluated after a series of questions and answers, then diagnosis is given, the other part of the total score is recorded into a computer, and a part of the manual operation is replaced by a computer.
With the continuous popularization of computers, the computer presents tables, doctors ask patients one by one according to the tables, records each score, finally the computer gives reference diagnosis according to the total score, after the doctor confirms the report, the evaluation can be checked and compared at any time, the evaluation result can be counted according to set conditions, the effectiveness and the reliability of the tables can be obtained according to the counting result, the optimized tables are corrected step by step, the effectiveness and the reliability of the tables are improved, and the diagnosis is more and more accurate.
In order to ensure that the software is changed as little as possible and the stability is kept, part of developers use reserved entry items for later expansion, and the other part of developers designate the table information such as the table corresponding table, the table subjects, the table subject check rules and the like to be maintained by users by establishing a related database table.
However, the scale recorded by the computer is solidified and can not be updated according to the actual situation, some scale problems need to demonstrate for the patient (for example, reading the characters, follow-up reading, action or model and the like of the patient), the action or the text of the solidified scale can not be modified, and the patient may have mechanical memory after multiple evaluations, which affects the accuracy of the evaluations. The corresponding judgment standard needs to be changed after the scale questions are updated, the report printing format needs to be changed, and the solidification of the scale causes subsequent problems, so that the evaluation quality is influenced and the use of doctors is influenced. The reserved scale questions can not solve the problems of flexible expansion, quantity limitation, incapability of random expansion and the like.
Therefore, a more flexible and expandable method for generating the table is needed.
Disclosure of Invention
In view of this, an object of the present application is to provide a method, a system, a device and a computer readable storage medium for generating a table, which is more flexible and better expandable. The specific scheme is as follows:
a method of generating a meter, comprising:
receiving a quantity table generation instruction;
reading the structure information of a table corresponding to the table generation instruction from a database;
analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result;
the database table comprising the table annotation and the table field annotation is stored in the database in advance in a structure of a database table, the table annotation is used for recording a frame of the scale, and the table field annotation is used for recording a scale topic of the scale.
Optionally, the items in the frame for recording the scale annotation include a scale title, an appearance, a layout, and a scale rating result acquisition rule.
Optionally, the table field annotation is used for recording items in the table title of the table, including a validation rule, a tag, a rule of whether to be empty, a rule of whether to display, a selection range, other table association rules, and a mask display.
Optionally, after the generating the corresponding gauge table, the method further includes:
receiving input scale data, and temporarily storing the scale data into the scale;
and receiving a meter data storage instruction, and writing the meter data into the table field annotation to obtain the evaluated assessment base table.
Optionally, the receiving a gauge data saving instruction, writing the gauge data into the table field annotation to obtain a process of obtaining an assessed assessment table, including:
after receiving a meter data storage instruction, verifying the meter data by using the verification rule in the table field annotation;
if the verification is not passed, refusing to save the gauge data;
and if the verification is passed, writing the table data into the table field annotation to obtain the evaluated assessment table.
Optionally, the table annotation and the table field annotation are both character strings obtained by splitting each item by using a special symbol.
Optionally, the method further includes:
receiving gauge modification information;
and modifying the corresponding table annotation and/or table field annotation in the table according to the table modification information to obtain a modified new table.
The application also discloses a system for generating a gauge, including:
the generation instruction receiving module is used for receiving the quantity table generation instruction;
the structure information reading module is used for reading the structure information of the base table corresponding to the table generation instruction from a database;
the scale generation module is used for analyzing the table annotation and the table field annotation in the structural information and generating a corresponding scale according to an analysis result;
the database table comprising the table annotation and the table field annotation is stored in the database in advance in a structure of a database table, the table annotation is used for recording a frame of the scale, and the table field annotation is used for recording a scale topic of the scale.
The application also discloses a gauge generation device includes:
a memory for storing a computer program;
a processor for executing the computer program to implement the gauge generation method as described above.
The present application also discloses a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a gauge generating method as described above.
In the present application, a method for generating a scale includes: receiving a quantity table generation instruction; reading the structure information of a base table corresponding to the table generation instruction from a database; analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result; the database table comprising table annotations and table field annotations is stored in the database in advance in a database table structure, wherein the table annotations are used for recording frames of the tables, and the table field annotations are used for recording table titles of the tables.
According to the method and the device, all information required by the scale is written into the library table in the form of the table annotation and the table field annotation respectively, the additional data table is not needed to be set to store the scale information, the scale can be generated by directly utilizing the library table, the additional tool is not needed to maintain and call the scale information, the compatibility problem is avoided, the modification of the scale is not needed to be additionally set, the setting information is stored in other library tables or other files, the manual checking corresponding link between different files or library tables is omitted, the scale corresponding relation is directly established on the table annotation and the table field annotation, errors are avoided, and the possibility of data deviation is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only the embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a schematic flow chart illustrating a method for generating a gauge disclosed in an embodiment of the present application;
FIG. 2 is a schematic flow chart of another method for generating a scale disclosed in an embodiment of the present application;
fig. 3 is a schematic structural diagram of a meter generation system disclosed in the embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The embodiment of the application discloses a method for generating a gauge, and as shown in fig. 1, the method comprises the following steps:
s11: receiving a quantity table generation instruction;
s12: and reading the structure information of the base table corresponding to the table generation instruction from the database.
Specifically, when the scale needs to be generated, a user inputs a table generation instruction, after the system receives the table generation instruction, the system goes to the database to search for the corresponding database table which is stored in advance by using the structure of the database table and comprises the table annotation and the table field annotation, and the structure information in the database table is read, so that the table annotation and the table field annotation in the database table can be obtained.
Specifically, all information required by the scale is written into the library table in the form of the table annotation and the table field annotation respectively, no additional data table is needed to set and store the scale information, when the scale is required to be added by software, only SQL scripts for creating a table structure need to be executed through system software (software using a host of the technology) according to business requirements, tools or third-party tools provided by the database can be used, the table structure for storing data required to be stored by the scale is added into the database, the scale control information does not need to be maintained independently, a data engine or a tool developed independently is not needed to operate the database table structure, compatibility or efficiency problems can exist when the data engine is called corresponding to different development tools, tools provided by different databases are used, or the third-party tools are convenient and do not have the compatibility or efficiency problems.
Specifically, all the information of the scale is stored uniformly, the flexibility of the scale can be increased, and the structure of the table of the stored data can be directly modified according to different requirements of users on the scale, so that the evaluation requirements of the users on the scale can be met. Meanwhile, the modification of the table does not need to be additionally set and the setting information is stored in other base tables or other files, so that the link of checking correspondence between different files or base tables manually is omitted, the table correspondence is directly established on the table annotation and the table field annotation, errors are avoided, and the possibility of data deviation is reduced.
S13: and analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result.
Specifically, the table annotation is used for recording the frame of the table, and the table field annotation is used for recording the table title of the table, so that the frame and the table field annotation of the table required for generating the table can be obtained by analyzing the table annotation and the table field annotation in the structure information, the related items and the attribute information required for generating the table can be obtained, and the corresponding table can be generated according to the analyzed data analysis result.
It can be seen that all information required by the scale is completely written into the library table in the form of the table annotation and the table field annotation, the additional data table is not needed to be set for storing the scale information, the scale can be directly generated by using the library table, additional tools are not needed to maintain and call the scale information, the compatibility problem is avoided, the modification of the scale is not needed to be additionally set, the set information is stored in other library tables or other files, the manual checking corresponding link between different files or library tables is omitted, the scale corresponding relation is directly established on the table annotation and the table field annotation, the error is avoided, and the possibility of data deviation is reduced.
Specifically, the items in the frame for recording the scale of the table annotation include items for setting the overall structure and frame of the table, such as a table title, appearance, layout, and a scale rating result acquisition rule, for example, a form description, a table name, a table title display content, a red color, a frame display, a column, a rating result 1, a rating result 2, a reserved item, and the like.
Specifically, the table field note is used for recording items in the table item of the table, including items of content specific display methods such as a verification rule, a tag, whether the table item is an empty rule, whether the table item is a display rule, a selection range, data display positions, formats and the like in the table, such as a table tag, a drop-down box selection, a numeric type, a character type, a date type, an entry sequence, a data display item 1, a data display item 2, a data display item 3, a table name and a reserved item.
Specifically, the table annotation and the table field annotation both use a character string obtained by splitting each item by using a special symbol, and therefore, the table annotation and the table field annotation specific character string example can be as follows:
specifically, the table notes special format string examples:
"a description of a form; a table name; gauge title display content; red; displaying a frame; dividing columns; 10-20, evaluation result |20-60, evaluation result 1 comprises 60-80 and evaluation result 2 comprises no chlorine; a reserved item; ".
The method comprises the steps of obtaining a character string, a semicolon (;), a vertical line (|), a comma (;), a horizontal line (-), and the like, wherein the semicolon (;), the vertical line (|), the comma (;) and the horizontal line (-) are all special symbols for splitting each item, specifically, the character string is split by the semicolon (;) and then is stored into an array or a set, values of different items can be easily read, a form style is set according to the values, for example, the 6 th item is searched from the analyzed array or set when a scale diagnosis rule is set, if the character string has no sixth item, the diagnosis rule is set as a default rule, the score of an evaluation result is directly displayed, and the 6 th item is obtained; splitting the character string by a vertical line (|), storing into an array or a set, and counting according to the array or the set; and circularly splitting each item by commas (commas), wherein the specific rule can be set to judge whether the number of the split arrays and sets is more than or equal to 2 or less than 2, if the number of the split arrays and sets is less than 2, discarding the split arrays and sets, if the number of the split arrays and sets is more than or equal to 2, resolving a minimum value and a maximum value, splitting a first item by a transverse line (-) to obtain a score range and a corresponding evaluation result, finally obtaining the evaluation result obtaining rule corresponding to the evaluation result score range of the scale, and obtaining the evaluation result according to the evaluation result obtaining rule after the evaluation is finished.
Specifically, other setting attributes of the scale are the same, setting values are searched from the array or the set split by the special format characters, and no setting value or value is illegally replaced by a default value, for example, the default value may be an asterisk (#). In this way, the table annotation is a default style for the display of the empty table, the position of each attribute character string in the character string is fixed, and each attribute of each item in the split array or set is fixedly corresponding to the table.
Specifically, the table field notes special format string example:
"title tag; selecting a drop-down frame; a digital type; digital, 100-1| character, regular expression | date, 1900/01/01-9999/01/01|; displaying; recording sequence, 1; data display item 1| data display item 2| data display item 3|; a table name; * (ii) a "
Specifically, through reading the comment information of the table field of the table, the processing is carried out circularly according to the number of the fields, and each table field generates a table topic. When each scale topic attribute is set in a cycle, the corresponding field annotation special format character string is analyzed, the character string is split by a semicolon (;) and then is stored into an array or a set, the values of different items can be easily read, and the scale topic attribute is set according to the values. For example: when the type of the table title is set, a 2 nd item (selected by a drop-down box) is searched from an analyzed array or set, software sets a table item presentation mode according to the set type, a value is not obtained or the obtained value is not in the range of 'input | drop-down box selection | check box | single box |', an input box is placed by default, the obtained value is input, an input box is placed, if the value is selected by the drop-down box, an input box and a selection list box are placed, the value of the list box searches a 7 th item from the analyzed array or set, the 7 th item is split by a vertical line (|) to obtain list data through analysis, meanwhile, selection data of the list box is set, a 3 rd item is searched from the obtained array or set, the value which is not found or found is not in the range of 'digital type | character type date type', a default setting is a character type is found according to the value of the data type item, the 4 th item is split by comma, a data verification rule is obtained, the default setting is not found, a control is input into a verification event according to the default setting, and the control is input into different types according to the verification event, the verification control, and the control which is set.
Specifically, other settings of the table title are the same, corresponding values are searched from the array or the set split by the special format character string, and no set value or value is illegally replaced by a default value. Thus, the table annotations all have a default style for empty table topics.
All questions in the scale are displayed after all fields are cycled, the questions are used for a user to evaluate for the patient, and when each scale question is evaluated, the data validity is verified at the same time, the user is prompted to confirm modification, and errors are avoided. And after all the rating questions are rated, storing the scoring details of the rating questions and the rating results in corresponding library tables.
The scale subject type, the data type range and the color range are preset, corresponding processing methods are provided, a default processing mode is used when the scale subject type, the data type range and the color range exceed the range, and a new project processing mode can be added when a new project is met by upgrading a software code.
The embodiment of the application discloses a specific scale generation method, and compared with the previous embodiment, the embodiment further explains and optimizes the technical scheme. Referring to fig. 2:
s21: receiving gauge modification information;
s22: and modifying the table annotation and/or the table field annotation in the corresponding table according to the table modification information to obtain a modified new table.
Specifically, because the information required by the generation of the scale is concentrated in the table base, the customized modification of the scale is more convenient and quicker, after the modification information of the scale is received, the table annotation and/or the table field annotation in the table base can be directly modified to obtain a modified new table base, for example, the modified new table base is obtained by directly modifying ' 10-20 ' in the table annotation, the assessment result ' modifies ' into ' 10-30 ' and the assessment result 3 ' or adds a ' verification rule ' in the table field annotation, and all the attribute information is in the same table base, so that each item of data is modified based on the same format standard when modified, the compatibility problem cannot occur, and meanwhile, each item is relatively independent, and the effect corresponding to each item when the scale is generated is also established in advance, so that the addition, deletion and modification can be more freely performed, and the influence caused by attribute change is not considered excessively. Therefore, the printing requirement of the rating result of the scale can be realized through the self-defined report, the flexibility of the generation of the scale is increased, software for generating the scale does not need to be repeatedly modified, the stability of the software is ensured, the user experience degree and the satisfaction degree are improved, and the software development and after-sale cost are saved.
S23: receiving a quantity table generation instruction;
s24: reading the structure information of a base table corresponding to the table generation instruction from a database;
s25: analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result;
the database table comprising table annotations and table field annotations is stored in the database in advance in a database table structure, wherein the table annotations are used for recording frames of the tables, and the table field annotations are used for recording table titles of the tables.
S26: receiving input scale data and temporarily storing the scale data into a scale;
s27: and receiving a meter data storage instruction, and writing the meter data into the table field annotation to obtain the evaluated assessment base table.
Specifically, when the user uses the scale, the data is firstly input into the scale, at this time, the scale data is only temporarily displayed on the scale and is not really written into the library table corresponding to the scale, the scale data can be temporarily stored in a cache, only after a scale data storage instruction is received, the scale data is written into the table field for annotation, the evaluated assessment library table is obtained, and the recording of the final scale is completed. The input of the meter data storage instruction can be realized by presetting a storage button and clicking the storage button to input the meter data storage instruction.
Further, the process of receiving the instruction for saving the meter data in S27, and writing the meter data into the table field annotation to obtain the assessed assessment base table may specifically include S271 to S273; wherein the content of the first and second substances,
s271: after receiving a meter data storage instruction, verifying the meter data by using a verification rule in the table field annotation;
s272: if the verification is not passed, refusing to save the gauge data;
s273: and if the verification is passed, writing the scale data into the table field annotation to obtain the evaluated assessment base table.
Specifically, a validation rule for validating the input scale data can be saved in the table field annotation, and under the condition that the validation rule is saved, the input scale data can be saved only after the validation rule is met, so that the problem that a user inputs wrong data and saves the wrong data is avoided, the user is convenient to be reminded of modifying the data in time, for example, when the user makes a mark, the value range of the number ranges from 0 to 10, and when the user mistakenly determines that the number is a percentage, for example, 60 is input, and if the user mistakenly determines that the number is a percentage, the user does not accord with the validation rule, the scale data is rejected to be saved, and a scale data saving instruction is rejected to be executed, so that the user is reminded of having the wrong data.
Therefore, the modes of layout, assessment data storage, deletion, modification and addition of the direct corresponding base table do not need to be additionally set and the setting information is stored in other base tables or other files, the manual corresponding link is omitted, the corresponding relation of the scale is directly established in the annotation of the table and the corresponding relation of the form item is directly established in the annotation of the table field, errors are avoided, the scale title and the title assessment data presented by the scale are directly stored in the annotation of the table field in the base table, and other data validity verification methods such as data verification rules and data types are added for verification, so that errors are avoided, the additional setting is not needed, and the data storage is ensured not to have deviation.
Correspondingly, an embodiment of the present application further discloses a system for generating a scale, as shown in fig. 3, the system includes:
a generation instruction receiving module 11, configured to receive a quantity table generation instruction;
a structure information reading module 12, configured to read structure information of a base table corresponding to the table generation instruction from a database;
the scale generation module 13 is used for analyzing the table annotation and the table field annotation in the structural information and generating a corresponding scale according to an analysis result;
the database table comprising table annotations and table field annotations is stored in the database in advance in a database table structure, wherein the table annotations are used for recording frames of the tables, and the table field annotations are used for recording table titles of the tables.
It can be seen that all information required by the scale is completely written into the library table in the form of the table annotation and the table field annotation, the additional data table is not needed to be set for storing the scale information, the scale can be directly generated by using the library table, additional tools are not needed to maintain and call the scale information, the compatibility problem is avoided, the modification of the scale is not needed to be additionally set, the set information is stored in other library tables or other files, the manual checking corresponding link between different files or library tables is omitted, the scale corresponding relation is directly established on the table annotation and the table field annotation, the error is avoided, and the possibility of data deviation is reduced.
Wherein, the items in the frame for recording the scale of the table annotation comprise a table title, appearance, layout and a scale evaluation result acquisition rule.
The table field is annotated, and items in the table subject used for recording the table comprise a verification rule, a label, whether the table subject is a null rule, whether the table subject is a display rule, a selection range, other table association rules and mask display.
Specifically, after the corresponding scale is generated, the method further includes:
the gauge data temporary storage module is used for receiving input gauge data and temporarily storing the gauge data into a gauge;
and the scale data storage module is used for receiving a scale data storage instruction and writing the scale data into the table field annotation to obtain the evaluated assessment base table.
Specifically, the scale generating module 13 includes:
the gauge data verification unit is used for verifying the gauge data by using a verification rule in the table field annotation after receiving the gauge data storage instruction;
the rejection saving unit is used for rejecting to save the scale data if the verification of the scale data verification unit fails;
and the scale generation unit is used for writing the scale data into the table field annotation to obtain the evaluated assessment base table if the verification of the scale data verification unit passes.
Specifically, the table annotation and the table field annotation both use a character string obtained by splitting each item by using a special symbol.
Specifically, still include:
the modification information receiving module is used for receiving the gauge modification information;
and the table modifying module is used for modifying the table annotation and/or the table field annotation in the corresponding table according to the table modifying information to obtain a modified new table.
In addition, the embodiment of the application also discloses a meter generating device, which comprises:
a memory for storing a computer program;
a processor for executing a computer program to implement the gauge generating method as described above.
In addition, an embodiment of the present application further discloses a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the method for generating the gauge as described above is implemented.
Finally, it should also be noted that, in this document, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises the element.
Those of skill would further appreciate that the various illustrative components and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the components and steps of the various examples have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The technical content provided by the present application is described in detail above, and the principle and the implementation of the present application are explained in the present application by applying specific examples, and the description of the above examples is only used to help understanding the method and the core idea of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.

Claims (10)

1. A method of generating a gauge, comprising:
receiving a quantity table generation instruction;
reading the structure information of a table corresponding to the table generation instruction from a database;
analyzing the table annotation and the table field annotation in the structural information, and generating a corresponding table according to an analysis result;
the database table comprising the table annotation and the table field annotation is stored in the database in advance in a structure of a database table, the table annotation is used for recording a frame of the scale, and the table field annotation is used for recording a scale topic of the scale.
2. The method of claim 1, wherein the table annotation is used to document items in the frame of the table including table title, appearance, layout, and table rating result acquisition rules.
3. The method of generating a scale according to claim 2, wherein the table field comments are used to document items in the table title of the scale including validation rules, labels, whether empty rules, whether rules are displayed, selection ranges, other table association rules, and mask display.
4. The method for generating a scale according to claim 3, wherein after the generating of the corresponding scale, the method further comprises:
receiving input scale data, and temporarily storing the scale data into the scale;
and receiving a meter data storage instruction, and writing the meter data into the meter field annotation to obtain the evaluated assessment base table.
5. The method of generating a scale according to claim 4, wherein the step of receiving a scale data save command to write the scale data into the table field annotation to obtain an assessed assessment table of the assessment tables comprises:
after receiving a meter data storage instruction, verifying the meter data by using the verification rule in the table field annotation;
if the verification is not passed, refusing to save the gauge data;
and if the verification is passed, writing the table data into the table field annotation to obtain the evaluated assessment table.
6. The method of generating a scale according to claim 1, wherein the table annotation and the table field annotation are each a character string obtained by splitting each item with a special symbol.
7. The scale generation method according to any one of claims 1 to 6, further comprising:
receiving gauge modification information;
and modifying the corresponding table annotation and/or table field annotation in the table according to the table modification information to obtain a modified new table.
8. A meter generation system, comprising:
the generation instruction receiving module is used for receiving a quantity table generation instruction;
the structure information reading module is used for reading the structure information of the base table corresponding to the table generation instruction from a database;
the scale generation module is used for analyzing the table annotation and the table field annotation in the structural information and generating a corresponding scale according to an analysis result;
the database table comprising the table annotation and the table field annotation is stored in the database in advance in a structure of a database table, the table annotation is used for recording a frame of the scale, and the table field annotation is used for recording a scale topic of the scale.
9. A meter generating apparatus, comprising:
a memory for storing a computer program;
a processor for executing the computer program to implement the gauge generating method of any of claims 1 to 7.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the gauge generating method according to any one of claims 1 to 7.
CN202210937747.4A 2022-08-05 2022-08-05 Method, system and device for generating gauge and computer readable storage medium Pending CN115376636A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210937747.4A CN115376636A (en) 2022-08-05 2022-08-05 Method, system and device for generating gauge and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210937747.4A CN115376636A (en) 2022-08-05 2022-08-05 Method, system and device for generating gauge and computer readable storage medium

Publications (1)

Publication Number Publication Date
CN115376636A true CN115376636A (en) 2022-11-22

Family

ID=84064315

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210937747.4A Pending CN115376636A (en) 2022-08-05 2022-08-05 Method, system and device for generating gauge and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN115376636A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106407404A (en) * 2016-09-22 2017-02-15 成都快乐家网络技术有限公司 A data storage method, a data management method and system, a database and a client
US20170357628A1 (en) * 2016-06-08 2017-12-14 j5 International IP Corporation Spreadsheet-Based Form Design and Data Input
CN111209443A (en) * 2020-01-03 2020-05-29 苏州亿歌网络科技有限公司 Questionnaire data storage method, device, server and storage medium
CN111352986A (en) * 2020-02-28 2020-06-30 平安科技(深圳)有限公司 Method and device for exporting database table structure and terminal equipment

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170357628A1 (en) * 2016-06-08 2017-12-14 j5 International IP Corporation Spreadsheet-Based Form Design and Data Input
CN106407404A (en) * 2016-09-22 2017-02-15 成都快乐家网络技术有限公司 A data storage method, a data management method and system, a database and a client
CN111209443A (en) * 2020-01-03 2020-05-29 苏州亿歌网络科技有限公司 Questionnaire data storage method, device, server and storage medium
CN111352986A (en) * 2020-02-28 2020-06-30 平安科技(深圳)有限公司 Method and device for exporting database table structure and terminal equipment

Similar Documents

Publication Publication Date Title
US9465793B2 (en) Systems and methods for advanced grammar checking
Chaparro et al. Assessing the quality of the steps to reproduce in bug reports
CN106886509B (en) Automatic detection method for academic paper format
CN114616572A (en) Cross-document intelligent writing and processing assistant
Hopkins et al. Visualint: Sketchy in situ annotations of chart construction errors
CN108762743B (en) Data table operation code generation method and device
CN112631997A (en) Data processing method, device, terminal and storage medium
JP2002288201A (en) Question-answer processing method, question-answer processing program, recording medium for the question- answer processing program, and question-answer processor
US20070255694A1 (en) Document-drafting system using document components
US8831504B2 (en) System and method for generating individualized educational practice worksheets
KR20190095099A (en) Transaction system error detection method, apparatus, storage medium and computer device
Yen et al. WriteAhead: Mining grammar patterns in corpora for assisted writing
Gupta Accuracy of references in two Indian library and information science journals
US10089389B1 (en) Translation of unstructured text into semantic models
CN115376636A (en) Method, system and device for generating gauge and computer readable storage medium
CN111160843B (en) Self-checking method for graph and document in product data management system
US20100057708A1 (en) Method and System for Computer-Based Assessment Including a Search and Select Process
WO2022029834A1 (en) Data processing device, data processing method, and program
WO2022271385A1 (en) Automatic generation of lectures derived from generic, educational or scientific contents, fitting specified parameters
WO2020166539A1 (en) Grading support device, grading support system, grading support method, and program recording medium
US11087097B2 (en) Automatic item generation for passage-based assessment
JP2011198285A (en) Document processing system and program
CN113515588A (en) Form data detection method, computer device and storage medium
JP2019185140A (en) Image processing device, image processing method, and program
Bjärkefur et al. iefieldkit: Commands for primary data collection and cleaning

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination