Two ways for wage system design

zhaozj2021-02-16  67

GM: Features: 1: A project is another subset of another project: A project can be arbitrarily operated. Three: A project is different depending on the conditions limit. User Operation Interface Improvements in Wages System: Text Description: For individual elements in salary, you can arbitrarily do different operational combinations. Design Database: In the wage list, find basic data (data that directly needs to be entered) is listed in the wage list. Some subsets, single in another table. Find basic data. Each project loop calculation is only incremented by a storage table. Date, month, quarter, year, and compiled databases. Date table

Solution: 1, physical model

2, salary table attribute model

There are two kinds of wage system practices, one: 1 Any adding data items in the database. 2 Any item in the database can be called the formula for - * /. (Evaluation: This kind of good, although it is shortcut, but did not have passed, similar list. Programming method unknown?) Specific Description: 1. Example of authority selection. 2. For each of the payroll, you can help online. For PB programming functions, the SQL language, etc., etc. 2: Data item view is fixed, and the operation formula for each item is written in the program. (Evaluation: Method is intuitive, simple programming, complex thinking, process cumbersome) specifically; conducive to the production of data windows, pre-promigted for illegal operations. The calculation formula of the result is huge.

转载请注明原文地址:https://www.9cbs.com/read-22340.html

New Post(0)