Middle school salary management system v2.2

Middle school salary management system v2.2

Function introduction:

Faculty and staff can use their ID number and password to check their salary for a certain month. Have permission to change your own password.

The financial administrator can import the salary table of a certain month and query and delete the total salary table of a certain month. You have your own account and password, and you can modify certain items.

The overtime pay administrator can import overtime pay for a certain month, and can query and delete the overtime pay summary for a certain month. You have your own account and password, and you can modify certain items.

Administrators manage all data.

Excel import table information: serial number name gender department ID number salary card number

Excel import, overtime pay for middle school in March 2013: Serial number Name ID card number Position allowance Administrative class hour structure fee Super class hour fee Early reading fee Evening self-study fee Attendance Attendance notes (text) Total Spare field 1 (numeric value) Spare field 2 (numeric value) Alternate field 3 (text)

Excel import: Unified salary payment list (business type salary):

Account number, serial name, name, ID card, wages to be paid, subtotal, position salary, salary grade, high-definition salary, reserved area subsidy, reserved area subsidy, reserved amount, national hardship and remote area allowance, post allowance, living wage included in performance salary, performance salary, replacement salary (individual), basic medical insurance (Individual) Unemployment insurance for public institutions (Individual) Critical illness medical assistance (Individual) Housing provident fund Personal income tax withholding 1 Withholding 2 Total amount payable Total total amount actually paid

counting people,

Accounts and management backend for financial personnel and overtime management personnel

The attendance field in the class cannot be negative.

Configuration instructions:

1. Create a new database N25175_GZ

Restore database from backup file N25175_GZ

2. Modify the database configuration file

Open the web.config file in the publishing website with Notepad

Then modify the information of the node (used to connect to the configuration database)

Description of each node:

Connectionstring

Server=database server address (ip or website)

Userid=username to connect to the database

Password=Password to connect to the database

Initialcatalog=database name

Then save.

Administrator login account 25175 password a25175com

Operating environment: .net2.0+sql2000+Windows2003/2000/XP/vista+iis5.0 or above+ASPAJAXExtSetup.msi(2.0)