employee.cs

办公室系统包括上下班打卡

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using GUCAS.SC.SqlHelper;

public class Department
{
	public SqlDataReader GetDepartments()
	{
		return (DataCommon.GetDataByReader("Pr_GetDepartments"));
	}

	public SqlDataReader GetSingleDepartment(int departmentID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleDepartment",departmentID));
	}

	public int AddDepartment(string name,string no,string desn,string phone)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@No",SqlDbType.VarChar,10,no),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn),
			SqlHelper.CreateInParam("@Phone",SqlDbType.VarChar,20,phone)
		};
		return (SqlHelper.RunProc("Pr_AddDepartment",parameters));
	}

	public int UpdateDepartment(int departmentID,string name,
		string desn,string phone)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,departmentID),
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn),
			SqlHelper.CreateInParam("@Phone",SqlDbType.VarChar,20,phone)
		};
		return (SqlHelper.RunProc("Pr_UpdateDepartment",parameters));
	}

	public int DeleteDepartment(int departmentID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteDepartment",departmentID));
	}
}

public class Employee
{
	public SqlDataReader GetEmployees()
	{
		return (DataCommon.GetDataByReader("Pr_GetEmployees"));
	}

	public SqlDataReader GetEmployeeLogin(string name,string password)
	{
		///定义保存从数据库获取的结果的DataReader
		SqlDataReader dr = null;

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@Password",SqlDbType.VarChar,255,password)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetEmployeeLogin",parameters,out dr);

		///返回从数据库获取的结果
		return dr;
	}

	public SqlDataReader GetEmployeeByDepartment(int departmentID)
	{
		///定义保存从数据库获取的结果的DataReader
		SqlDataReader dr = null;

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@DepartmentID",SqlDbType.Int,4,departmentID)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetEmployeeByDepartment",parameters,out dr);

		///返回从数据库获取的结果
		return dr;
	}

	public SqlDataReader GetSingleEmployee(int employeeID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleEmployee",employeeID));
	}

	public int AddEmployee(string name,bool sex,DateTime birthday,
		string nationality,byte political,byte degree,byte marital,
		string familyPlace,string identityCard,string phone,
		DateTime hireDate,int departmentID,string position,
		string remark)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@Sex",SqlDbType.Bit,1,sex),
			SqlHelper.CreateInParam("@Birthday",SqlDbType.DateTime,8,birthday),
			SqlHelper.CreateInParam("@Nationality",SqlDbType.VarChar,20,nationality),
			SqlHelper.CreateInParam("@Political",SqlDbType.TinyInt,1,political),
			SqlHelper.CreateInParam("@Degree",SqlDbType.TinyInt,1,degree),
			SqlHelper.CreateInParam("@Marital",SqlDbType.TinyInt,1,marital),
			SqlHelper.CreateInParam("@familyPlace",SqlDbType.VarChar,100,familyPlace),
			SqlHelper.CreateInParam("@identityCard",SqlDbType.VarChar,20,identityCard),
			SqlHelper.CreateInParam("@Phone",SqlDbType.VarChar,50,phone),
			SqlHelper.CreateInParam("@HireDate",SqlDbType.DateTime,8,hireDate),
			SqlHelper.CreateInParam("@DepartmentID",SqlDbType.Int,4,departmentID),
			SqlHelper.CreateInParam("@Position",SqlDbType.VarChar,50,position),
			SqlHelper.CreateInParam("@Remark",SqlDbType.NVarChar,1000,remark)
		};
		return (SqlHelper.RunProc("Pr_AddEmployee",parameters));
	}

	public int UpdateEmployee(int employeeID,string name,bool sex,
		DateTime birthday,string nationality,byte political,
		byte degree,byte marital,string familyPlace,string identityCard,
		string phone,DateTime hireDate,int departmentID,string position,
		string remark)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@Sex",SqlDbType.Bit,1,sex),
			SqlHelper.CreateInParam("@Birthday",SqlDbType.DateTime,8,birthday),
			SqlHelper.CreateInParam("@Nationality",SqlDbType.VarChar,20,nationality),
			SqlHelper.CreateInParam("@Political",SqlDbType.TinyInt,1,political),
			SqlHelper.CreateInParam("@Degree",SqlDbType.TinyInt,1,degree),
			SqlHelper.CreateInParam("@Marital",SqlDbType.TinyInt,1,marital),
			SqlHelper.CreateInParam("@familyPlace",SqlDbType.VarChar,100,familyPlace),
			SqlHelper.CreateInParam("@identityCard",SqlDbType.VarChar,20,identityCard),
			SqlHelper.CreateInParam("@Phone",SqlDbType.VarChar,50,phone),
			SqlHelper.CreateInParam("@HireDate",SqlDbType.DateTime,8,hireDate),
			SqlHelper.CreateInParam("@DepartmentID",SqlDbType.Int,4,departmentID),
			SqlHelper.CreateInParam("@Position",SqlDbType.VarChar,50,position),
			SqlHelper.CreateInParam("@Remark",SqlDbType.NVarChar,1000,remark)
		};
		return (SqlHelper.RunProc("Pr_UpdateEmployee",parameters));
	}

	public int UpdateEmployeePwd(int employeeID,string password)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@Password",SqlDbType.VarChar,255,password)
		};
		return (SqlHelper.RunProc("Pr_UpdateEmployeePwd",parameters));
	}

	public int DeleteEmployee(int employeeID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteEmployee",employeeID));
	}
}