attendance.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 Attendance
{
	public SqlDataReader GetCurrentAttendance(int employeeID,
		DateTime currentDate)
	{
		///定义保存从数据库获取的结果的SqlDataReader
		SqlDataReader dr;

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@CurrentDate",SqlDbType.DateTime,8,currentDate)
		};

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

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

	public DataSet GetAttendanceByEmployee(int employeeID)
	{
		///定义保存从数据库获取的结果的DataSet
		DataSet ds = new DataSet();

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

		///执行存储过程
		SqlHelper.RunProc("Pr_GetAttendanceByEmployee",parameters,ref ds);

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

	public DataSet GetAttendanceByEmployeeAndDate(int employeeID,
		DateTime attendanceDate)
	{
		///定义保存从数据库获取的结果的DataSet
		DataSet ds = new DataSet();

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@AttendanceDate",SqlDbType.DateTime,8,attendanceDate)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetAttendanceByEmployeeAndDate",parameters,ref ds);

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

	public SqlDataReader GetSingleAttendanceExplain(
		int attendanceExplainID)
	{
		return (DataCommon.GetDataByReaderIDParam(
			"Pr_GetSingleAttendanceExplain",attendanceExplainID));
	}

	public SqlDataReader GetSingleAttendance(int attendanceID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleAttendance",attendanceID));
	}

	public int AddNoNormalAttendance(DateTime currentDate,int employeeID)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@CurrentDate",SqlDbType.DateTime,8,currentDate),
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID)
		};
		return (SqlHelper.RunProc("Pr_AddNoNormalAttendance",parameters));
	}

	public int AddOnAttendance(DateTime currentDate,DateTime onDate,
		int employeeID)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@CurrentDate",SqlDbType.DateTime,8,currentDate),
			SqlHelper.CreateInParam("@OnDate",SqlDbType.DateTime,8,onDate),
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID)
		};
		return (SqlHelper.RunProc("Pr_AddOnAttendance",parameters));
	}

	public int AddOffAttendance(DateTime currentDate,DateTime offDate,
		int employeeID)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@CurrentDate",SqlDbType.DateTime,8,currentDate),
			SqlHelper.CreateInParam("@OffDate",SqlDbType.DateTime,8,offDate),
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID)
		};
		return (SqlHelper.RunProc("Pr_AddOffAttendance",parameters));
	}

	public int AddAttendanceExplain(int attendanceID,string desn)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@AttendanceID",SqlDbType.Int,4,attendanceID),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn)
		};
		return (SqlHelper.RunProc("Pr_AddAttendanceExplain",parameters));
	}

	public int UpdateAttendanceExplain(int attendanceExplainID,string desn)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,attendanceExplainID),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn)
		};
		return (SqlHelper.RunProc("Pr_UpdateAttendanceExplain",parameters));
	}
	
	public int DeleteAttendance(int attendanceID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteAttendance",attendanceID));
	}
	
	public int DeleteAttendanceExplain(int attendanceExplainID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteAttendanceExplain",attendanceExplainID));
	}
}