Business processing methods, computing devices, and storage media
By using a metadata-driven approach, computational items and their rules are determined based on object identifiers and business metadata. This solves the problem of low business processing efficiency in existing technologies, enables rapid storage and management of extended fields, and improves the flexibility and efficiency of business processing.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- HENAN QINWEI DIGITAL TECHNOLOGY CO LTD
- Filing Date
- 2026-02-11
- Publication Date
- 2026-06-02
AI Technical Summary
In existing technologies, adding or modifying computing projects requires modifying business code and redeploying, resulting in low business processing efficiency.
By using a metadata-driven approach, the computational items and their computational rules are determined based on the object's identifier and pre-configured business metadata. The computational results are generated, and the location of the computational items is determined and stored in the business processing result table based on the storage information, thus avoiding the development of different business code for different objects.
It improves business processing efficiency, enables dynamic management of extended fields, supports quick determination of storage location for new calculation projects, and reduces the frequency of code modification and deployment.
Smart Images

Figure CN122132134A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of business processing technology, and in particular to a business processing method, computing device, and storage medium. Background Technology
[0002] The business process requires calculating the values of multiple items. For example, the business process could be payroll calculation, and the calculation items could be salary items.
[0003] Currently, programming languages can be used to write the business code corresponding to the business processing procedures, and the business code can be deployed. However, if a new calculation project is added, or the calculation method of a calculation project is modified, the business code needs to be modified and redeployed, resulting in low business processing efficiency. Summary of the Invention
[0004] This application provides a business processing method, a computing device, and a storage medium to solve the technical problem of low business processing efficiency.
[0005] In a first aspect, embodiments of this application provide a business processing method applied to a computing device, the method comprising:
[0006] Based on the object's object identifier and pre-configured business metadata, determine at least one computing item corresponding to the object, as well as the computing rules for each computing item;
[0007] Based on the calculation rules of each calculation item corresponding to the object, the calculation result of the object is generated. The calculation result includes each calculation item corresponding to the object and the item value corresponding to each calculation item.
[0008] Based on the pre-configured storage information, the storage location of each calculation item in the calculation result is determined in the business processing result table. The storage location of each calculation item in the calculation result is located in a different column of the business processing result table. The storage information is used to indicate the storage location of the calculation item in the business processing result table.
[0009] Write the item values corresponding to each calculation item in the calculation results to the storage location of the corresponding calculation item in the business processing result table.
[0010] In the above solution, the computing device can determine the calculation results of different objects based on pre-configured business metadata, eliminating the need to develop different business codes for different objects and improving business processing efficiency.
[0011] In one possible implementation, the business processing result table includes at least one field group, with different field types corresponding to different field groups, including numeric and character types;
[0012] For any field group, the field group includes at least one extension group, and the extension group includes at most a first preset number of extension fields. Different extension fields are stored in different columns of the business processing result table.
[0013] The stored information includes: a field management table and a calculation item mapping table;
[0014] The field management table is used to record: the field groups included in the business processing result table, the extended groups included in each field group, the number of used extended fields in each extended group, and the number of available unused extended fields;
[0015] The calculation project mapping table is used to record the mapping information of calculation projects. The mapping information of calculation projects includes at least: the project identifier of the calculation project, the group identifier of the extension group corresponding to the calculation project, and the field identifier of the extension field assigned to the calculation project in the extension group corresponding to the calculation project.
[0016] In the above scheme, the field management table can be used to record the usage of extended fields in each field group of the business processing result table, and the calculation item mapping table can be used to record the correspondence between calculation items and extended fields. Through this scheme, the goal of managing the extended fields in the business processing result table can be achieved.
[0017] In one possible implementation, for any calculation item in the calculation result, the storage location of the calculation item in the business processing result table is determined based on pre-configured storage information, including:
[0018] Determine if mapping information for a calculation project exists in the calculation project mapping table;
[0019] If the calculation project mapping table contains mapping information for the calculation project, determine the storage location of the calculation project in the business processing result table based on the mapping information of the calculation project;
[0020] If the calculation project mapping table does not contain mapping information for the calculation project, an extended field corresponding to the calculation project is assigned to the business processing result table, the mapping information of the calculation project is recorded in the calculation project mapping table, and the storage location of the calculation project in the business processing result table is determined based on the mapping information of the calculation project.
[0021] In the above scheme, if the calculation project mapping information exists in the calculation project mapping table, the storage location of the calculation project in the business processing result table can be determined based on the mapping information. If the calculation project mapping table does not contain mapping information, an extended field can be assigned to the calculation project, and the storage location of the calculation project in the business processing result table can be determined based on the assigned extended field. This scheme achieves the goal of determining the storage location of the calculation project in the business processing result table.
[0022] One possible implementation involves determining the storage location of a computation item in the business processing result table based on the mapping information of the computation item, including:
[0023] The target extended field is determined based on the mapping information of the calculation project. The target extended field is the extended field assigned to the calculation project in the business processing result table.
[0024] The column containing the target extended field is determined as the storage column for the calculated item in the business processing result table;
[0025] The row containing the object identifier is determined as the storage row for the calculation item in the business processing result table;
[0026] Determining the storage location of calculated items in the business processing results table includes: storing columns and storing rows.
[0027] In the above scheme, the storage location of the calculation item in the business processing result table can be determined based on the target extended field assigned to the calculation item, thus achieving the purpose of determining the storage location of the calculation item in the business processing result table.
[0028] One possible implementation involves assigning extended fields corresponding to the calculated items in the business processing result table, including:
[0029] Determine the field types corresponding to the calculation items;
[0030] Based on the field type corresponding to the calculation item, determine the target field group in the business processing result table. The field type corresponding to the target field group is the same as the field type corresponding to the calculation item.
[0031] Determine if there are any available extended fields in the target field group. Available extended fields are those that are not assigned in the target field group.
[0032] If there are available extended fields in the target field group, assign the extended field with the smallest number among the available extended fields to the calculation project;
[0033] If no available extended fields are available in the target field group, a second preset number of extended fields are created in the target field group according to the extended configuration, and the extended field with the smallest number among the second preset number of extended fields is assigned to the calculation item. The second preset number is less than or equal to the first preset number.
[0034] In the above scheme, extended fields can be assigned to calculation projects according to the field types corresponding to the calculation projects, thus achieving the purpose of assigning extended fields to calculation projects.
[0035] One possible implementation involves creating a second preset number of extended fields in the target field group based on the extended configuration, including:
[0036] Determine whether there is an available extended group in the target field group, and the number of extended fields included in the available extended group is less than the first preset number;
[0037] If an available extended group exists in the target field group, create a second preset number of extended fields in the available extended group according to the extended configuration;
[0038] If no available extended group exists in the target field group, create a target extended group in the target field group according to the extended configuration, and create a second preset number of extended fields in the target extended group.
[0039] In the above scheme, extended fields can be created in available extended groups or target extended groups, thus achieving the purpose of creating extended fields.
[0040] In one possible implementation, the business metadata includes: computation scheme metadata for at least one computation scheme, computation project metadata for at least one computation item, and computation rule metadata for each computation item; wherein,
[0041] The computation scheme metadata is used to indicate at least the computational items included in the computation scheme;
[0042] The computation project metadata serves at least to indicate the data source required when generating the project value corresponding to the computation project;
[0043] The computation rules metadata for a computation project are used to indicate at least the priority of the computation project and the computation formula or function used to generate the corresponding project value.
[0044] In the above scheme, the business metadata may include the computing scheme metadata of at least one computing scheme, the computing project metadata of at least one computing project, and the computing rule metadata of each computing project. Through the above scheme, the purpose of configuring business metadata can be achieved.
[0045] In one possible implementation, based on the object's object identifier and pre-configured business metadata, at least one computational item corresponding to the object and the computational rules for each computational item are determined, including:
[0046] Based on the object identifier, determine the target computation scheme corresponding to the object in at least one computation scheme;
[0047] Based on the computation scheme metadata of the target computation scheme, the target computation items included in the target computation scheme are identified as at least one computation item corresponding to the object;
[0048] Based on the computation rule metadata of the target computation item, determine the computation rules of at least one computation item corresponding to the object.
[0049] In the above scheme, the target computing scheme can be determined based on the object identifier, and at least one computing item corresponding to the object and the computing rules of each computing item can be determined based on the target computing scheme and business metadata, thus achieving the purpose of determining the computing item corresponding to the object and the computing rules of the computing item.
[0050] Secondly, embodiments of this application provide a service processing apparatus, which includes: a determining module, a generating module, and a writing module, wherein:
[0051] The determination module is used to determine at least one computing item corresponding to the object and the computing rules of each computing item based on the object identifier and pre-configured business metadata.
[0052] The generation module is used to generate the calculation results of the object according to the calculation rules of each calculation item corresponding to the object. The calculation results include each calculation item corresponding to the object and the item value corresponding to each calculation item.
[0053] The determination module is also used to determine the storage location of each calculation item in the calculation result in the business processing result table based on the pre-configured storage information. The storage location of each calculation item in the calculation result is located in a different column of the business processing result table. The storage information is used to indicate the storage location of the calculation item in the business processing result table.
[0054] The write module is used to write the item values corresponding to each calculation item in the calculation results to the storage location of the corresponding calculation item in the business processing result table.
[0055] In the above solution, the computing device can determine the calculation results of different objects based on pre-configured business metadata, eliminating the need to develop different business codes for different objects and improving business processing efficiency.
[0056] In one possible implementation, the business processing result table includes at least one field group, with different field types corresponding to different field groups, including numeric and character types;
[0057] For any field group, the field group includes at least one extension group, and the extension group includes at most a first preset number of extension fields. Different extension fields are stored in different columns of the business processing result table.
[0058] The stored information includes: a field management table and a calculation item mapping table;
[0059] The field management table is used to record: the field groups included in the business processing result table, the extended groups included in each field group, the number of used extended fields in each extended group, and the number of available unused extended fields;
[0060] The calculation project mapping table is used to record the mapping information of calculation projects. The mapping information of calculation projects includes at least: the project identifier of the calculation project, the group identifier of the extension group corresponding to the calculation project, and the field identifier of the extension field assigned to the calculation project in the extension group corresponding to the calculation project.
[0061] In the above scheme, the field management table can be used to record the usage of extended fields in each field group of the business processing result table, and the calculation item mapping table can be used to record the correspondence between calculation items and extended fields. Through this scheme, the goal of managing the extended fields in the business processing result table can be achieved.
[0062] In one possible implementation, the determination module is specifically used for:
[0063] Determine if mapping information for a calculation project exists in the calculation project mapping table;
[0064] If the calculation project mapping table contains mapping information for the calculation project, determine the storage location of the calculation project in the business processing result table based on the mapping information of the calculation project;
[0065] If the calculation project mapping table does not contain mapping information for the calculation project, an extended field corresponding to the calculation project is assigned to the business processing result table, the mapping information of the calculation project is recorded in the calculation project mapping table, and the storage location of the calculation project in the business processing result table is determined based on the mapping information of the calculation project.
[0066] In the above scheme, if the calculation project mapping information exists in the calculation project mapping table, the storage location of the calculation project in the business processing result table can be determined based on the mapping information. If the calculation project mapping table does not contain mapping information, an extended field can be assigned to the calculation project, and the storage location of the calculation project in the business processing result table can be determined based on the assigned extended field. This scheme achieves the goal of determining the storage location of the calculation project in the business processing result table.
[0067] In one possible implementation, the determination module is specifically used for:
[0068] The target extended field is determined based on the mapping information of the calculation project. The target extended field is the extended field assigned to the calculation project in the business processing result table.
[0069] The column containing the target extended field is determined as the storage column for the calculated item in the business processing result table;
[0070] The row containing the object identifier is determined as the storage row for the calculation item in the business processing result table;
[0071] Determining the storage location of calculated items in the business processing results table includes: storing columns and storing rows.
[0072] In the above scheme, the storage location of the calculation item in the business processing result table can be determined based on the target extended field assigned to the calculation item, thus achieving the purpose of determining the storage location of the calculation item in the business processing result table.
[0073] In one possible implementation, the determination module is specifically used for:
[0074] Determine the field types corresponding to the calculation items;
[0075] Based on the field type corresponding to the calculation item, determine the target field group in the business processing result table. The field type corresponding to the target field group is the same as the field type corresponding to the calculation item.
[0076] Determine if there are any available extended fields in the target field group. Available extended fields are those that are not assigned in the target field group.
[0077] If there are available extended fields in the target field group, assign the extended field with the smallest number among the available extended fields to the calculation project;
[0078] If no available extended fields are available in the target field group, a second preset number of extended fields are created in the target field group according to the extended configuration, and the extended field with the smallest number among the second preset number of extended fields is assigned to the calculation item. The second preset number is less than or equal to the first preset number.
[0079] In the above scheme, extended fields can be assigned to calculation projects according to the field types corresponding to the calculation projects, thus achieving the purpose of assigning extended fields to calculation projects.
[0080] In one possible implementation, the determination module is specifically used for:
[0081] Determine whether there is an available extended group in the target field group, and the number of extended fields included in the available extended group is less than the first preset number;
[0082] If an available extended group exists in the target field group, create a second preset number of extended fields in the available extended group according to the extended configuration;
[0083] If no available extended group exists in the target field group, create a target extended group in the target field group according to the extended configuration, and create a second preset number of extended fields in the target extended group.
[0084] In the above scheme, extended fields can be created in available extended groups or target extended groups, thus achieving the purpose of creating extended fields.
[0085] In one possible implementation, the business metadata includes: computation scheme metadata for at least one computation scheme, computation project metadata for at least one computation item, and computation rule metadata for each computation item; wherein,
[0086] The computation scheme metadata is used to indicate at least the computational items included in the computation scheme;
[0087] The computation project metadata serves at least to indicate the data source required when generating the project value corresponding to the computation project;
[0088] The computation rules metadata for a computation project are used to indicate at least the priority of the computation project and the computation formula or function used to generate the corresponding project value.
[0089] In the above scheme, the business metadata may include the computing scheme metadata of at least one computing scheme, the computing project metadata of at least one computing project, and the computing rule metadata of each computing project. Through the above scheme, the purpose of configuring business metadata can be achieved.
[0090] In one possible implementation, the determination module is specifically used for:
[0091] Based on the object identifier, determine the target computation scheme corresponding to the object in at least one computation scheme;
[0092] Based on the computation scheme metadata of the target computation scheme, the target computation items included in the target computation scheme are identified as at least one computation item corresponding to the object;
[0093] Based on the computation rule metadata of the target computation item, determine the computation rules of at least one computation item corresponding to the object.
[0094] In the above scheme, the target computing scheme can be determined based on the object identifier, and at least one computing item corresponding to the object and the computing rules of each computing item can be determined based on the target computing scheme and business metadata, thus achieving the purpose of determining the computing item corresponding to the object and the computing rules of the computing item.
[0095] Thirdly, embodiments of this application provide a computing device, including: a memory and a processor;
[0096] The memory stores the instructions that the computer executes;
[0097] The processor executes computer execution instructions stored in memory, causing the processor to perform the first aspect and / or various possible implementations of the first aspect as described above.
[0098] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement the first aspect and / or various possible implementations of the first aspect.
[0099] Fifthly, embodiments of this application provide a computer program product, including a computer program that, when executed by a processor, implements the first aspect and / or various possible implementations of the first aspect. Attached Figure Description
[0100] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0101] Figure 1 A flowchart illustrating a business processing method provided in an embodiment of this application;
[0102] Figure 2 A flowchart illustrating another business processing method provided in an embodiment of this application;
[0103] Figure 3 A flowchart illustrating another business processing method provided in an embodiment of this application;
[0104] Figure 4 This is a schematic diagram of the structure of a service processing device provided in an embodiment of this application;
[0105] Figure 5 This is a schematic diagram of the structure of a computing device provided in an embodiment of this application. Detailed Implementation
[0106] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with those of this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of the embodiments of this application as detailed in the appended claims.
[0107] This application provides a business processing method, a computing device, and a storage medium to solve the technical problem of low business processing efficiency.
[0108] This application's embodiments involve salary calculation. For ease of understanding, salary calculation will be explained first.
[0109] Salary calculation: This refers to the process of determining the amount of each salary item an employee is entitled to through a series of calculations based on preset business rules and specific employee data. For example, business rules may include social security rules, individual income tax rules, etc., specific data may include attendance data, performance data, etc., and salary items may include base salary, performance-based salary, deductions, and total amount items, etc.
[0110] The technical solutions of the embodiments of this application will be described in detail below with specific examples. These specific examples can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments.
[0111] Figure 1 This is a flowchart illustrating a business processing method provided in an embodiment of this application. The execution subject of this method can be a computing device, or a processor or processing chip located within the computing device. For ease of understanding, the following description uses a computing device as the execution subject. Please refer to... Figure 1 The method may include:
[0112] S101. Based on the object identifier and pre-configured business metadata, determine at least one computing item corresponding to the object and the computing rules for each computing item.
[0113] In this embodiment, the service can be a payroll calculation service.
[0114] The target can be any employee whose salary needs to be calculated.
[0115] An object identifier can be a unique identifier for an object. For example, an object identifier can be an object's employee ID or a worker's number.
[0116] The business processing method provided in this embodiment is a metadata-driven business processing method. Business metadata may include: computing scheme metadata of at least one computing scheme, computing project metadata of at least one computing item, and computing rule metadata of each computing item.
[0117] The calculation scheme can be a salary scheme. For example, the calculation scheme can be a salary scheme for the technical department or the marketing department, etc.
[0118] The calculation items can be salary items. For example, calculation items can include basic salary, performance-based salary, etc.
[0119] The calculation rules for a calculation item can serve as the basis for generating the corresponding item value. These rules may include the calculation formulas used to generate the item value.
[0120] It should be noted that for any given calculation scheme, the calculation scheme may include at least one calculation item. Different calculation schemes may include the same and / or different calculation items.
[0121] For example, suppose the calculation scheme includes salary plans for the technical department and the marketing department. The technical department's salary plan may include a base salary and project performance bonuses. The marketing department's salary plan may include a base salary and sales performance bonuses.
[0122] In this embodiment, the computation scheme metadata of the computation scheme is used to indicate at least the computation items included in the computation scheme; the computation item metadata of the computation item is used to indicate at least the data source required to generate the item value corresponding to the computation item; and the computation rule metadata of the computation item is used to indicate at least the priority of the computation item and the computation formula or computation function used to generate the item value corresponding to the computation item.
[0123] The priority of calculation items refers to the order in which the calculation items included in the calculation scheme are calculated. For example, suppose the calculation items include basic salary and tax amount. Since the tax amount is calculated based on the basic salary, the basic salary needs to be calculated first and then the tax amount is calculated. Therefore, the priority of basic salary is higher than the priority of tax amount.
[0124] In this embodiment, the computing device can determine the target computing scheme corresponding to the object in at least one computing scheme based on the object identifier; determine the target computing items included in the target computing scheme as at least one computing item corresponding to the object based on the computing scheme metadata of the target computing scheme; and determine the computing rules of at least one computing item corresponding to the object based on the computing rule metadata of the target computing item.
[0125] Specifically, a mapping relationship exists between object identifiers and computing schemes. The computing device can match the target computing scheme for an object among multiple computing schemes based on this mapping relationship and the object identifier itself. The computing device can also determine the corresponding computing project for the object based on the computing scheme metadata of the target computing scheme. Furthermore, the computing device can obtain the computing rules for all computing projects corresponding to the object from the business user data.
[0126] For example, assuming the object identifier is "001", and the computing device determines the target calculation scheme for the object to be "formal employee salary scheme" based on the mapping relationship between the object identifier and the calculation scheme, then the computing device can determine all salary items included in the "formal employee salary scheme" as the corresponding calculation items for the object based on the calculation scheme metadata of the "formal employee salary scheme". Assuming the calculation items corresponding to the object include: basic salary, performance-based salary, pension insurance deduction, medical insurance deduction, and individual income tax, the computing device can obtain the calculation rules for basic salary, performance-based salary, pension insurance deduction, medical insurance deduction, and individual income tax from the business metadata.
[0127] It should be noted that different objects can correspond to the same or different calculation schemes, and different calculation schemes can include the same and / or different calculation items. Therefore, different objects can correspond to the same and / or different calculation items.
[0128] S102. Generate the calculation results of the object according to the calculation rules of each calculation item corresponding to the object.
[0129] The calculation results include each calculation item corresponding to the object, and the item value corresponding to each calculation item.
[0130] For any given calculation item, the item value refers to the specific numerical value obtained after calculation. For example, the item value corresponding to basic salary could be 6000 yuan.
[0131] In this embodiment, the computing device can calculate the item value of each computing item sequentially according to the priority value of each computing item corresponding to the object. For any given computing item, the computing device can calculate the item value of that computing item according to the formula or function indicated by the computing rules of that computing item.
[0132] In some embodiments, the calculation item may include "actual amount paid out," that is, the calculation result may include the specific value of the actual amount paid out.
[0133] In this embodiment, a business processing engine can be pre-configured, which can be the core execution module of a metadata-driven business processing method. The computing device can load and execute the business processing engine to generate the calculation results of the object.
[0134] S103. Based on the pre-configured storage information, determine the storage location of each calculation item in the business processing result table.
[0135] The business processing result table refers to the database table used to store the final results of business processing.
[0136] The business processing result table can include at least one field group, with different field types corresponding to different field groups. Field types include numeric and character types. Specifically, the business processing result table can include field groups of numeric types and field groups of character types, etc.
[0137] For any given field group, the field group includes at least one extension group, and the extension group includes at most a first preset number of extension fields. Different extension fields are stored in different columns of the business processing result table. For example, extension fields can be extension field 1, extension field 2, etc.
[0138] The extension group can be a unit of measurement used to indicate a first preset number of extension fields. The first preset number can be set according to actual needs, and this embodiment does not limit it. For example, the first preset number can be 100, 80, 60, 40, or 20, etc.
[0139] In this embodiment, the number of extended groups in a field group and the number of extended fields in an extended group can change dynamically. Specifically, after an extended group is created in a field group, a first preset number of extended fields can be created in that extended group through at least one extended operation. If the number of extended fields in an extended group is less than the first preset number, extended fields can be created in that extended group the next time they need to be created. If the number of extended fields in an extended group is equal to the first preset number, a new extended group can be created the next time extended fields need to be created in that field group, and extended fields can be created in the new extended group.
[0140] For example, suppose the business processing result includes a field group with a first preset quantity of 100. This field group currently includes two extension groups: the first extension group contains 100 extension fields, and the second extension group contains 60 extension fields. Then, the next time an extension field needs to be created in this field group, it can be created in the second extension group.
[0141] For any extended field, it can correspond to a calculated item, and the column containing the extended field can be used to store the item value of the corresponding calculated item. For example, assuming extended field 1 corresponds to basic salary, the column containing extended field 1 can be used to store the employee's basic salary.
[0142] The storage locations of each calculation item in the calculation results are located in different columns of the business processing results table.
[0143] The storage location of a calculated item in the business processing result table can be its coordinates within the table. These coordinates can be represented by rows and columns within the business processing result table.
[0144] In this embodiment, the storage information is used to indicate the storage location of the calculation item in the business processing result table. The storage information may include: a field management table and a calculation item mapping table.
[0145] The field management table is used to record: the field groups included in the business processing result table, the extended groups included in each field group, the number of used extended fields in each extended group, and the number of available unused extended fields.
[0146] The calculation project mapping table is used to record the mapping information of calculation projects. The mapping information of calculation projects includes at least: the project identifier of the calculation project, the group identifier of the extension group corresponding to the calculation project, and the field identifier of the extension field assigned to the calculation project in the extension group corresponding to the calculation project.
[0147] In this embodiment, the computing device can determine the storage row corresponding to an object in the business processing result table based on the object identifier. For any calculation item in the calculation result, the computing device can query the field identifier corresponding to the calculation item according to the calculation item mapping table, and then determine the column where the extended field indicated by the field identifier is located as the storage column corresponding to the calculation item.
[0148] S104. Write the item values corresponding to each calculation item in the calculation results to the storage location of the corresponding calculation item in the business processing result table.
[0149] Specifically, for any calculation item in the calculation result, the computing device can write the corresponding item value to the storage location of that calculation item in the business processing result table.
[0150] For example, suppose the storage row corresponding to the object is row 5, and the calculation items include: basic salary, performance-based salary, and individual income tax. Assume the basic salary is stored in column 3 of the business processing result table, the performance-based salary in column 4, and the individual income tax in column 5. Then, the computing device can write the item value corresponding to the basic salary in the calculation result to column 3 of row 5 of the business processing result table, the item value corresponding to the performance-based salary in the calculation result to column 4 of row 5, and the item value corresponding to the individual income tax in the calculation result to column 5 of row 5.
[0151] In the business processing method provided in this embodiment, the computing device can determine at least one calculation item corresponding to an object and the calculation rules for each calculation item based on the object identifier and pre-configured business metadata; it can generate the calculation result of the object based on the calculation rules for each calculation item corresponding to the object; it can determine the storage location of each calculation item in the business processing result table based on pre-configured storage information; and it can write the item value corresponding to each calculation item in the calculation result to the storage location of the corresponding calculation item in the business processing result table. In the above method, the computing device can determine the calculation result of different objects based on pre-configured business metadata, eliminating the need to develop different business code for different objects and improving business processing efficiency.
[0152] Based on the above embodiments, the method for determining the storage location of each calculation item in the calculation result table is the same. The following example uses any calculation item in the calculation result. Figure 2 The method for determining the storage location of calculation items in the business processing result table is explained.
[0153] Figure 2 This is a flowchart illustrating another business processing method provided in an embodiment of this application. The executing entity of this method can be a computing device, or a processor or processing chip located within the computing device. For ease of understanding, the following description uses a computing device as the executing entity. Please refer to... Figure 2 The method may include:
[0154] S201. Determine whether the calculation project mapping table contains mapping information for the calculation project.
[0155] It should be noted that if the calculation item is newly added, the mapping information for the calculation item may not exist in the calculation item mapping table. For example, assuming "transportation subsidy" is a newly added calculation item, the mapping information for "transportation subsidy" may not exist in the calculation item mapping table.
[0156] If the calculation project mapping table contains mapping information for the calculation project, execute S202;
[0157] If the mapping information for a calculation project does not exist in the calculation project mapping table, execute S203.
[0158] S202. Determine the storage location of the calculation item in the business processing result table based on the mapping information of the calculation item.
[0159] In this embodiment, if the mapping information of the computing project exists in the computing project mapping table, the computing device can determine the target extended field based on the mapping information of the computing project. The target extended field is the extended field assigned to the computing project in the business processing result table. The column where the target extended field is located is determined as the storage column of the computing project in the business processing result table. The row where the object identifier is located is determined as the storage row of the computing project in the business processing result table. Determining the storage location of the computing project in the business processing result table includes: storage column and storage row.
[0160] For example, suppose the computing device determines, based on the mapping information of the computing item, that the extended field assigned to the computing item in the business processing result table is extended field 1, and the column where extended field 1 is located in the business processing result table is column 8. Suppose the object identifier is located in row 5 of the business processing result table. Then the computing device can determine that the storage location of the computing item in the business processing result table is: row 5, column 8.
[0161] S203. Assign extended fields corresponding to the calculation items in the business processing result table, record the mapping information of the calculation items in the calculation item mapping table, and determine the storage location of the calculation items in the business processing result table based on the mapping information of the calculation items.
[0162] In this embodiment, when allocating extended fields corresponding to calculation items in the business processing result table, the computing device can determine the field type corresponding to the calculation item; based on the field type corresponding to the calculation item, a target field group is determined in the business processing result table, and the field type corresponding to the target field group is the same as the field type corresponding to the calculation item; it is determined whether there are available extended fields in the target field group, and the available extended fields are the unallocated extended fields in the target field group; if there are available extended fields in the target field group, the extended field with the smallest number among the available extended fields is allocated to the calculation item; if there are no available extended fields in the target field group, a second preset number of extended fields are created in the target field group according to the extended configuration, and the extended field with the smallest number among the second preset number of extended fields is allocated to the calculation item, the second preset number being less than or equal to the first preset number.
[0163] The second preset quantity can be the number of extended fields created in a single instance. The specific value of the second preset quantity can be set according to actual needs, but the second preset quantity is less than or equal to the first preset quantity. In some embodiments, the second preset quantity can be less than the first preset quantity; for example, the first preset quantity can be 100, and the second preset quantity can be 20. In some embodiments, the second preset quantity can be equal to the first preset quantity; for example, the first preset quantity can be 20, and the second preset quantity can also be 20.
[0164] Extended configurations can refer to the creation rules for pre-configured extended fields. For example, extended configurations could include setting the number of fields created at once to a second preset number.
[0165] Specifically, if the field type of the calculation item is numeric, the computing device can determine the numeric field group in the business processing table as the target field group. If the field type of the calculation item is character, the computing device can determine the character field group in the business processing table as the target field group.
[0166] The computing device can also determine whether there are available extended fields in the target field group based on the records in the field management table. If there are available extended fields in the target field group, one of the available extended fields can be assigned to the computing project. If there are no available extended fields in the target field group, extended fields can be created, and the extended field with the smallest number among the created extended fields can be assigned to the computing project.
[0167] In this embodiment, when assigning available extended fields to a computing item, the computing device can assign the available extended field with the smallest number to the computing item. For example, assuming that the available extended fields include extended field 13, extended field 14, extended field 15... extended field 19, and extended field 20, the computing device can assign extended field 13 to the computing item.
[0168] In this embodiment, when creating extended fields in the target field group, the computing device can determine whether there is an available extended group in the target field group, and the number of extended fields included in the available extended group is less than a first preset number; if there is an available extended group in the target field group, a second preset number of extended fields are created in the available extended group according to the extended configuration; if there is no available extended group in the target field group, a target extended group is created in the target field group according to the extended configuration, and a second preset number of extended fields are created in the target extended group.
[0169] Available extension groups refer to extension groups containing fewer than a first preset number of extension fields. Available extension groups are those that can continue to have additional extension fields added.
[0170] A target extension group refers to a new extension group added within a target field group. Target extension groups can be used to hold newly created extension fields.
[0171] Specifically, when assigning and creating extended fields for a calculation project, at least the following situations exist:
[0172] Case 1: The target field group has an available extended group.
[0173] In this case, the computing device can create a second preset number of extended fields in the available extended groups and assign the extended field with the smallest number among the created extended fields to the computing item.
[0174] Case 2: There is no available extended group in the target field group.
[0175] In this case, the number of extended fields in all extended groups within the target field group is equal to the first preset number. The computing device can create target extended groups within the target field group, create a second preset number of extended fields within the target extended groups, and assign the smallest-numbered extended field among the created extended fields to the computing item.
[0176] In this embodiment, after allocating available extended fields to a computing item, the computing device can record the mapping information of the computing item in the computing item mapping table. The computing device can also update the extended groups included in the target field group, as well as the number of used extended fields and the number of available unused extended fields in each extended group, in the field management table.
[0177] It should be noted that the method for determining the storage location of a calculation item in the business processing result table based on the mapping information of the calculation item can be found in S202, and will not be repeated here.
[0178] In the business processing method provided in this embodiment, the computing device can determine whether mapping information for a computing item exists in the computing item mapping table. If mapping information exists in the computing item mapping table, the computing device can determine the storage location of the computing item in the business processing result table based on the mapping information. If mapping information does not exist in the computing item mapping table, the computing device can allocate an extended field corresponding to the computing item in the business processing result table, record the mapping information of the computing item in the computing item mapping table, and determine the storage location of the computing item in the business processing result table based on the mapping information. In the above method, if a new computing item is added, the extended field can be dynamically allocated to the new computing item, making the determination of the storage location of the computing item faster, thereby improving business processing efficiency.
[0179] It should be noted that in the business processing method provided in this embodiment, the item values corresponding to each calculation item in the calculation result can be stored in different columns of the same row in the business processing result table. This storage method facilitates the computing device in querying or displaying the item values of each calculation item corresponding to the object.
[0180] In related technologies, there exists an Entity-Attribute-Value (EAV) storage model. When using the EAV storage model to store the item values of each computational item corresponding to an object, the item value of each computational item can be stored in one row. When a computing device queries or displays the item values of each computational item corresponding to an object, it needs to obtain the item value of each computational item separately and store all the item values of computational items in one row by converting rows to columns. The following uses an object as an example, combined with Tables 1 and 2, to illustrate the storage method of the EAV storage model.
[0181] First, referring to Table 1, the method for storing the item values of each calculated item corresponding to this object using the EAV model is explained:
[0182] Table 1
[0183]
[0184] Please refer to Table 1. The object identifier for this object is "001". Each row of Table 1 can store a calculated item for this object and its corresponding item value.
[0185] Secondly, referring to Table 2, the method for storing the item values of each calculated item corresponding to the object after row-to-column conversion is explained:
[0186] Table 2
[0187]
[0188] Please refer to Table 2. After row-to-column conversion, the item values of each calculated item corresponding to this object can be stored in one row.
[0189] Compared to the EAV storage model, the method provided in this embodiment can store the item values corresponding to each calculation item in the calculation result in different columns of the same row of the business processing result table, without the need for row-to-column conversion, thus improving query efficiency.
[0190] Based on any of the above embodiments, the following is combined with Figure 3 The following is a further explanation of the business processing methods provided in the embodiments of this application.
[0191] Figure 3 This is a flowchart illustrating another business processing method provided in an embodiment of this application. The executing entity of this method can be a computing device, or a processor or processing chip located within the computing device. For ease of understanding, the following description uses a computing device as the executing entity. Please refer to... Figure 3 The method may include:
[0192] S301. Based on the object identifier, determine the target computation scheme corresponding to the object in at least one computation scheme.
[0193] In this embodiment, there is a mapping relationship between the object identifier and the computing scheme. The computing device can match the target computing scheme of the object in at least one computing scheme according to the mapping relationship between the object identifier and the computing scheme, as well as the object identifier.
[0194] S302. Based on the calculation scheme metadata of the target calculation scheme, determine the target calculation items included in the target calculation scheme as at least one calculation item corresponding to the object.
[0195] For example, assuming the target calculation items include: basic salary, performance-based salary, pension insurance deduction, medical insurance deduction, unemployment insurance deduction, housing provident fund deduction, and individual income tax, the calculation device can determine that at least one calculation item corresponding to the object may include basic salary, performance-based salary, pension insurance deduction, medical insurance deduction, unemployment insurance deduction, housing provident fund deduction, and individual income tax.
[0196] S303. Based on the calculation rule metadata of the target calculation item, determine the calculation rule of at least one calculation item corresponding to the object.
[0197] Specifically, the computing device can obtain the calculation rule metadata of each target computing project from the salesperson data, and can determine the calculation rules of the corresponding computing project based on the calculation rule metadata of the target computing project.
[0198] S304. Generate the calculation results of the object according to the calculation rules of each calculation item corresponding to the object.
[0199] It should be noted that the specific implementation of S304 can be found in S102, and will not be repeated here.
[0200] S305. For any calculation item in the calculation results, determine whether there is mapping information for the calculation item in the calculation item mapping table.
[0201] If the calculation project mapping table contains mapping information for the calculation project, execute S306;
[0202] If the mapping information for a calculation project does not exist in the calculation project mapping table, execute S307.
[0203] S306. Determine the storage location of the calculation item in the business processing result table based on the mapping information of the calculation item.
[0204] S307. Assign extended fields corresponding to the calculation items in the business processing result table, record the mapping information of the calculation items in the calculation item mapping table, and determine the storage location of the calculation items in the business processing result table based on the mapping information of the calculation items.
[0205] It should be noted that the specific implementation methods of S305 to S307 can be found in S201 to S203, and will not be repeated here.
[0206] In the business processing method provided in this embodiment, the computing device can determine the target computing scheme corresponding to the object in at least one computing scheme based on the object identifier; it can determine the target computing items included in the target computing scheme as at least one computing item corresponding to the object based on the computing scheme metadata of the target computing scheme; it can determine the computing rules of at least one computing item corresponding to the object based on the computing rule metadata of the target computing item; and it can generate the computing result of the object based on the computing rules of each computing item corresponding to the object. For any computing item in the computing result, if the computing item mapping table contains the mapping information of the computing item, the storage location of the computing item in the business processing result table can be determined based on the mapping information of the computing item; if the computing item mapping table does not contain the mapping information of the computing item, an extended field corresponding to the computing item can be allocated in the business processing result table, the mapping information of the computing item can be recorded in the computing item mapping table, and the storage location of the computing item in the business processing result table can be determined based on the mapping information of the computing item. In the above method, the computing device can generate the computing result of the object based on metadata, without developing different business code for different objects, thus improving the efficiency of business processing. In addition, when adding new computing projects, extended fields can be dynamically assigned to the new computing projects without redeploying the business code, which makes the business processing methods highly scalable, flexible and adaptable.
[0207] Based on any of the above embodiments, the following uses the payroll calculation business of an object as an example to further illustrate the business processing method provided in the embodiments of this application.
[0208] Assume the object identifier is "002", and assume the computing device determines the target computing scheme for the object as "the salary scheme of the technical department" based on the mapping relationship between the object identifier and the computing scheme, as well as the object identifier.
[0209] The computing device can determine all salary items included in the "Technical Department's Salary Scheme" as the corresponding calculation items for an object based on the calculation scheme metadata. Assume the calculation items for the object include: basic salary, performance-based salary, transportation allowance, social insurance and housing fund deductions, tax amount, and net salary.
[0210] The computing device can obtain the calculation rules for basic salary, performance-based salary, social insurance and housing fund deductions, tax payment, and net salary from business metadata.
[0211] The computing device can also obtain the data source required to generate the corresponding project value for each computing project based on the computing project metadata of each computing project.
[0212] Assuming that the calculation items corresponding to the object are sorted according to priority, the calculation items corresponding to the object are as follows: basic salary, performance salary, transportation allowance, social insurance and housing fund deductions, tax amount, and net salary.
[0213] The computing device can calculate the item value corresponding to basic salary, performance salary, transportation allowance, social insurance and housing fund deductions, tax payment, and net salary in sequence according to the priority of each calculation item.
[0214] Assume the project mapping table contains mapping information for basic salary, performance-based salary, social insurance and housing fund deductions, tax amount, and net salary. The computing device can determine the storage location of the basic salary in the business processing result table based on the basic salary mapping information, and store the corresponding item values in the appropriate storage locations; it can determine the storage location of the performance-based salary based on the performance-based salary mapping information, and store the corresponding item values in the appropriate storage locations; it can determine the storage location of the social insurance and housing fund deductions based on the social insurance and housing fund deductions mapping information, and store the corresponding item values in the appropriate storage locations; it can determine the storage location of the tax amount based on the tax amount mapping information, and store the corresponding item values in the appropriate storage locations; and it can determine the storage location of the net salary based on the net salary mapping information, and store the corresponding item values in the net salary in the appropriate storage locations.
[0215] Assume that there is no mapping information for transportation subsidies in the calculation project mapping table. The computing device can assign an extended field corresponding to transportation subsidies in the business processing result table, record the mapping information of transportation subsidies in the calculation project mapping table, determine the storage location of transportation subsidies in the business processing result table based on the mapping information of transportation subsidies, and store the project value corresponding to transportation subsidies in the corresponding storage location.
[0216] Using the method provided in this embodiment, the computing device can determine the calculation results of the payroll business of an object based on pre-configured business metadata, and store the item values of each calculation item in the calculation results into a business processing result table. This method eliminates the need to develop different business code for different objects, improving business processing efficiency. Furthermore, for newly added calculation items, extended fields can be dynamically allocated, allowing for faster determination of the storage location of calculation items and further improving business processing efficiency.
[0217] Figure 4 This is a schematic diagram of a service processing apparatus provided in an embodiment of this application. The service processing apparatus 10 can be applied to a computing device. Please refer to... Figure 4 The service processing device 10 may include: a determining module 11, a generating module 12, and a writing module 13, wherein:
[0218] The determination module 11 is used to determine at least one computing item corresponding to the object and the computing rules of each computing item based on the object identifier of the object and the pre-configured business metadata.
[0219] The generation module 12 is used to generate the calculation results of the object according to the calculation rules of each calculation item corresponding to the object. The calculation results include each calculation item corresponding to the object and the item value corresponding to each calculation item.
[0220] The determining module 11 is also used to determine the storage location of each calculation item in the calculation result in the business processing result table according to the pre-configured storage information. The storage location of each calculation item in the calculation result is located in a different column of the business processing result table. The storage information is used to indicate the storage location of the calculation item in the business processing result table.
[0221] The writing module 13 is used to write the item values corresponding to each calculation item in the calculation result to the storage location of the corresponding calculation item in the business processing result table.
[0222] The business processing apparatus provided in this embodiment can execute the business processing method executed by the computing device in any of the above method embodiments. Its implementation principle and beneficial effects are similar, and will not be described again here.
[0223] In one possible implementation, the business processing result table includes at least one field group, with different field types corresponding to different field groups, including numeric and character types;
[0224] For any field group, the field group includes at least one extension group, and the extension group includes at most a first preset number of extension fields. Different extension fields are stored in different columns of the business processing result table.
[0225] The stored information includes: a field management table and a calculation item mapping table;
[0226] The field management table is used to record: the field groups included in the business processing result table, the extended groups included in each field group, the number of used extended fields in each extended group, and the number of available unused extended fields;
[0227] The calculation project mapping table is used to record the mapping information of calculation projects. The mapping information of calculation projects includes at least: the project identifier of the calculation project, the group identifier of the extension group corresponding to the calculation project, and the field identifier of the extension field assigned to the calculation project in the extension group corresponding to the calculation project.
[0228] In one possible implementation, the determining module 11 is specifically used for:
[0229] Determine if mapping information for a calculation project exists in the calculation project mapping table;
[0230] If the calculation project mapping table contains mapping information for the calculation project, determine the storage location of the calculation project in the business processing result table based on the mapping information of the calculation project;
[0231] If the calculation project mapping table does not contain mapping information for the calculation project, an extended field corresponding to the calculation project is assigned to the business processing result table, the mapping information of the calculation project is recorded in the calculation project mapping table, and the storage location of the calculation project in the business processing result table is determined based on the mapping information of the calculation project.
[0232] In one possible implementation, the determining module 11 is specifically used for:
[0233] The target extended field is determined based on the mapping information of the calculation project. The target extended field is the extended field assigned to the calculation project in the business processing result table.
[0234] The column containing the target extended field is determined as the storage column for the calculated item in the business processing result table;
[0235] The row containing the object identifier is determined as the storage row for the calculation item in the business processing result table;
[0236] Determining the storage location of calculated items in the business processing results table includes: storing columns and storing rows.
[0237] In one possible implementation, the determining module 11 is specifically used for:
[0238] Determine the field types corresponding to the calculation items;
[0239] Based on the field type corresponding to the calculation item, determine the target field group in the business processing result table. The field type corresponding to the target field group is the same as the field type corresponding to the calculation item.
[0240] Determine if there are any available extended fields in the target field group. Available extended fields are those that are not assigned in the target field group.
[0241] If there are available extended fields in the target field group, assign the extended field with the smallest number among the available extended fields to the calculation project;
[0242] If no available extended fields are available in the target field group, a second preset number of extended fields are created in the target field group according to the extended configuration, and the extended field with the smallest number among the second preset number of extended fields is assigned to the calculation item. The second preset number is less than or equal to the first preset number.
[0243] In one possible implementation, the determining module 11 is specifically used for:
[0244] Determine whether there is an available extended group in the target field group, and the number of extended fields included in the available extended group is less than the first preset number;
[0245] If an available extended group exists in the target field group, create a second preset number of extended fields in the available extended group according to the extended configuration;
[0246] If no available extended group exists in the target field group, create a target extended group in the target field group according to the extended configuration, and create a second preset number of extended fields in the target extended group.
[0247] In one possible implementation, the business metadata includes: computation scheme metadata for at least one computation scheme, computation project metadata for at least one computation item, and computation rule metadata for each computation item; wherein,
[0248] The computation scheme metadata is used to indicate at least the computational items included in the computation scheme;
[0249] The computation project metadata serves at least to indicate the data source required when generating the project value corresponding to the computation project;
[0250] The computation rules metadata for a computation project are used to indicate at least the priority of the computation project and the computation formula or function used to generate the corresponding project value.
[0251] In one possible implementation, the determining module 11 is specifically used for:
[0252] Based on the object identifier, determine the target computation scheme corresponding to the object in at least one computation scheme;
[0253] Based on the computation scheme metadata of the target computation scheme, the target computation items included in the target computation scheme are identified as at least one computation item corresponding to the object;
[0254] Based on the computation rule metadata of the target computation item, determine the computation rules of at least one computation item corresponding to the object.
[0255] The business processing apparatus provided in this embodiment can execute the business processing method executed by the computing device in any of the above method embodiments. Its implementation principle and beneficial effects are similar, and will not be described again here.
[0256] Figure 5 This is a schematic diagram of the structure of a computing device provided in an embodiment of this application. Figure 5 As shown, the computing device 20 may include a processor 21 and a memory 22, wherein the processor 21 and the memory 22 can communicate; for example, the processor 21 and the memory 22 communicate through a communication bus 23, the memory 22 is used to store computer execution instructions, and the processor 21 is used to call the computer execution instructions in the memory to execute the business processing method shown in any of the above method embodiments.
[0257] Optionally, the computing device 20 may also include a communication interface, which may include a transmitter and / or a receiver.
[0258] The computing device 20 can be the computing device shown in any of the above method embodiments, and can execute the business processing method shown in any of the above method embodiments.
[0259] Optionally, the processor mentioned above can be a CPU, or a GPU, a Baseboard Management Controller (BMC), other general-purpose processors, a Digital Signal Processor (DSP), or an Application Specific Integrated Circuit (ASIC), etc. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in the embodiments of this application can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules in the processor.
[0260] This application provides a computer-readable storage medium storing computer-executable instructions; the computer-executable instructions are used to implement the business processing methods as described in any of the above embodiments.
[0261] This application provides a computer program product, which includes a computer program. When the computer program is executed, it causes the computer to perform the above-described business processing method.
[0262] All or part of the steps in the above method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a readable memory. When the program is executed, it performs the steps of the above method embodiments; and the aforementioned memory (storage medium) includes: read-only memory (ROM), RAM, flash memory, hard disk, solid-state drive, magnetic tape, floppy disk, optical disk, and any combination thereof.
[0263] This application describes embodiments of methods, apparatus (systems), and computer program products according to embodiments of this application with reference to flowchart illustrations and / or block diagrams. It should be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processing unit of a general-purpose computer, special-purpose computer, embedded processor, or other programmable terminal device to produce a machine, such that the instructions, which execute via the processing unit of the computer or other programmable terminal device, generate instructions for implementing the flowchart illustrations. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0264] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable terminal device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0265] These computer program instructions can also be loaded onto a computer or other programmable terminal device, causing a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable device for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0266] Obviously, those skilled in the art can make various modifications and variations to the embodiments of this application without departing from the spirit and scope of the embodiments of this application. Therefore, if these modifications and variations to the embodiments of this application fall within the scope of the claims of this application and their equivalents, the embodiments of this application are also intended to include these modifications and variations.
[0267] In the embodiments of this application, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element. The term "or" and its variations can mean "and / or." In the embodiments of this application, the terms "first," "second," etc., are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. In the embodiments of this application, "multiple" refers to two or more. "And / or" describes the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, and B alone. The character " / " generally indicates that the preceding and following related objects have an "or" relationship.
[0268] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the invention disclosed in the specification and in practice. The embodiments of this application are intended to cover any variations, uses, or adaptations of the embodiments of this application that follow the general principles of the embodiments of this application and include common knowledge or customary technical means in the art not disclosed in the embodiments of this application.
Claims
1. A business processing method, characterized in that, Applied to a computing device, the method includes: Based on the object's object identifier and pre-configured business metadata, determine at least one computing item corresponding to the object, as well as the computing rules for each computing item; Based on the calculation rules of each calculation item corresponding to the object, the calculation result of the object is generated, and the calculation result includes each calculation item corresponding to the object and the item value corresponding to each calculation item; Based on the pre-configured storage information, the storage location of each calculation item in the calculation result in the business processing result table is determined. The storage location of each calculation item in the calculation result is located in a different column of the business processing result table. The storage information is used to indicate the storage location of the calculation item in the business processing result table. Write the item values corresponding to each calculation item in the calculation results to the storage location of the corresponding calculation item in the business processing result table.
2. The method according to claim 1, characterized in that, The business processing result table includes at least one field group, and different field groups correspond to different field types, including numeric and character types; For any field group, the field group includes at least one extension group, and the extension group includes at most a first preset number of extension fields, with different extension fields stored in different columns of the business processing result table; The stored information includes: a field management table and a calculation item mapping table; The field management table is used to record: the field groups included in the business processing result table, the extended groups included in each field group, the number of used extended fields in each extended group, and the number of available unused extended fields; The computation project mapping table is used to record the mapping information of computation projects. The mapping information of the computation project includes at least: the project identifier of the computation project, the group identifier of the extension group corresponding to the computation project, and the field identifier of the extension field assigned to the computation project in the extension group corresponding to the computation project.
3. The method according to claim 2, characterized in that, For any calculation item in the calculation results, determine the storage location of the calculation item in the business processing result table based on pre-configured storage information, including: Determine whether the mapping information for the computing project exists in the computing project mapping table; If the mapping information for the computing item exists in the computing item mapping table, the storage location of the computing item in the business processing result table is determined based on the mapping information of the computing item. If the mapping information for the computing item does not exist in the computing item mapping table, an extended field corresponding to the computing item is allocated in the business processing result table, the mapping information of the computing item is recorded in the computing item mapping table, and the storage location of the computing item in the business processing result table is determined based on the mapping information of the computing item.
4. The method according to claim 3, characterized in that, Determining the storage location of the calculation item in the business processing result table based on the mapping information of the calculation item includes: The target extended field is determined based on the mapping information of the calculation project, and the target extended field is the extended field assigned to the calculation project in the business processing result table; The column containing the target extended field is determined as the storage column of the calculation item in the business processing result table; The row containing the object identifier is determined as the storage row of the calculation item in the business processing result table; Determining the storage location of the calculated item in the business processing result table includes: the storage column and the storage row.
5. The method according to claim 3, characterized in that, The process of allocating the extended fields corresponding to the calculation items in the business processing result table includes: Determine the field type corresponding to the calculation item; Based on the field type corresponding to the calculation item, a target field group is determined in the business processing result table, and the field type corresponding to the target field group is the same as the field type corresponding to the calculation item. Determine whether there are available extended fields in the target field group, wherein the available extended fields are the unassigned extended fields in the target field group; If there are available extended fields in the target field group, assign the extended field with the smallest number among the available extended fields to the calculation item; If no available extended fields are available in the target field group, a second preset number of extended fields are created in the target field group according to the extended configuration, and the calculation item is assigned the extended field with the smallest number among the second preset number of extended fields, wherein the second preset number is less than or equal to the first preset number.
6. The method according to claim 5, characterized in that, The step of creating a second preset number of extended fields in the target field group according to the extended configuration includes: Determine whether there is an available extended group in the target field group, wherein the number of extended fields included in the available extended group is less than the first preset number; If an available extension group exists in the target field group, create a second preset number of extension fields in the available extension group according to the extension configuration; If no available extended group exists in the target field group, a target extended group is created in the target field group according to the extended configuration, and a second preset number of extended fields are created in the target extended group.
7. The method according to any one of claims 1-6, characterized in that, The business metadata includes: computation scheme metadata for at least one computation scheme, computation project metadata for at least one computation item, and computation rule metadata for each computation item; wherein, The computation scheme metadata of the computation scheme is used at least to indicate the computation items included in the computation scheme; The computation project metadata of the computation project is used at least to indicate the data source required when generating the project value corresponding to the computation project; The computation rule metadata of the computation project is used to indicate at least the priority of the computation project and the computation formula or function used to generate the project value corresponding to the computation project.
8. The method according to claim 7, characterized in that, The step of determining at least one computing item corresponding to the object and the computing rules for each computing item based on the object identifier and pre-configured business metadata includes: Based on the object identifier, determine the target computing scheme corresponding to the object in the at least one computing scheme; Based on the computation scheme metadata of the target computation scheme, the target computation items included in the target computation scheme are determined as at least one computation item corresponding to the object; Based on the computation rule metadata of the target computation project, determine the computation rules of at least one computation project corresponding to the object.
9. A computing device, characterized in that, include: Memory and processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory, causing the processor to perform the method according to any one of claims 1-8.
10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1-8.