attendance.cs

来自「ASP C#代码实例 适合初学人士学习使用」· CS 代码 · 共 77 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace OfficeAuto.Components
{
	/// <summary>
	/// Attendance 的摘要说明。
	/// </summary>
	public class Attendance
	{
		public SqlDataReader GetAttendanceByUser(int nStaffID)
		{
			SqlDataReader dataReader = null;
			Database data = new Database();
			SqlParameter[] prams = {
									   data.CreateInParam("@StaffID",SqlDbType.Int,4,nStaffID)
									   
								   };
			try 
			{	
				///获取用户信息
				data.RunProc("Pr_GetAttendanceByUser",prams,out dataReader);
				return dataReader;
			}
			catch(Exception ex) 
			{
				SystemError.SystemLog(ex.ToString());
				throw new Exception("考勤信息读取出错!",ex);
			}			
		}

		public SqlDataReader GetAttendanceByUserDay(int nStaffID)
		{
			SqlDataReader dataReader = null;
			Database data = new Database();
			SqlParameter[] prams = {
									   data.CreateInParam("@StaffID",SqlDbType.Int,4,nStaffID)
									   
								   };
			try 
			{	
				///获取用户信息
				data.RunProc("Pr_GetAttendanceByUserDay",prams,out dataReader);
				return dataReader;
			}
			catch(Exception ex) 
			{
				SystemError.SystemLog(ex.ToString());
				throw new Exception("考勤信息读取出错!",ex);
			}			
		}

		public int AddAttendanceOnDuty(int nStaffID,int nOnDutyStatus)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.CreateInParam("@StaffID",SqlDbType.Int,4,nStaffID),
									   db.CreateInParam("@OnDutyStatus",SqlDbType.Int,4,nOnDutyStatus)
								   };
			///添加上下版信息
			return(db.RunProc("Pr_AddAttendanceOnDuty",prams));
		}

		public int AddAttendanceOffDuty(int nStaffID,int nOffDutyStatus)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.CreateInParam("@StaffID",SqlDbType.Int,4,nStaffID),
									   db.CreateInParam("@OffDutyStatus",SqlDbType.Int,4,nOffDutyStatus)
								   };
			///添加上下版信息
			return(db.RunProc("Pr_AddAttendanceOffDuty",prams));
		}
	}
}