Method and device for judging whether form data items are quoted

Abstract

The invention provides a method for judging whether form data items are quoted, comprising the following steps: step 102: selecting a data item in a form to obtain a corresponding data class; step 104: obtaining one or more corresponding data classes according to a precedence table, judging whether the data classes contain the data class of step 102, if yes, going to step 106, and if not, going to step 108; step 106: searching a specified field of the data class of step 102 in a corresponding form, judging whether the corresponding item comprises an item with the same content of the data item, if yes, determining the data item is quoted, if not, going to step 108; step 108: searching a system preset table, judging whether the item with the same content of the data item exists in the system preset table, if yes, determining the data item is quoted; and step 110: searching a user defined table, and judging whether the item with the same content of the data item exists in the user defined table, if yes, determining the data item is quoted, and if not, determining the data item is not quoted. Through the invention, whether the basic data items are allowed to be deleted can be judged quickly.

Description

Technical field [0001] The present invention relates to database technology, and more specifically, to a method and device for judging whether a form data item is quoted. Background technique [0002] Due to the business needs of flexibly adding personnel information and adding forms at will in the personnel system and human resource system, there are special requirements for the database table design: [0003] 1. Users can customize basic file items; [0004] 2. Customize the data table and expand the fields in the existing table, and most of the field data sources in the table are basic file items; [0005] 3. The business requires that the referenced basic archive item is not allowed to be deleted, and the table to which the basic archive item is referenced and the fields in the table cannot be controlled (because the user can add a table arbitrarily, and the fields in the table arbitrarily refer to the basic archive item). [0006] Therefore, it is very important to quickly determi...

AI Technical Summary

Problems solved by technology

[0005] 3. The business requires that the referenced basic file items are not allowed to be deleted, and the tables and fields in the tables that are referenced by the basic file items cannot be controlled (because users can add tables arbitrarily, and the fields in the tables can refer to the basic file items arbitrarily)

With this solution, if it happens that the last data item refers to the basic file item, it needs to traverse to the last data item, the efficiency is relatively low, and this solution is not particularly suitable for business scenarios and human resources business

[0009] 2. After the data table is created, it can be flexibly changed by the business: Currently, more solutions are provided, that is, the basic file item is not allowed to be deleted, or only control the reference to the system-preset data table of the basic file item, and create it for the customer himself. The table or the modified table is basically not controlled, and the algorithm of cyclic traversal is also used for judgment. The idea of ​​this solution is consistent with the first one, and it is not very consistent with the business scenario. There are unconsidered situations

Images