25175 Middle School Salary Management System 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
Count the accounts of financial personnel and overtime pay managers and the attendance field in the management backend, which 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. Use Notepad to open the web.config file in the publishing website and modify the node information (used to connect to the configuration database)
Description of each node:
Connection string
Server=database server address (ip or website)
Userid=username to connect to the database
Password=Password to connect to the database
Initialcatalog=database name and save.
Administrator login account 25175 password a25175com
Operating environment: .net2.0+sql2000+Windows2003/2000/XPista+iis5.0 or above+ASPAJAXExtSetup.msi(2.0)