dutytime.cs

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

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

namespace OfficeAuto.Components
{
	/// <summary>
	/// 上下班时间
	/// </summary>
	public struct DutyTime
	{
		private DateTime ondutytime;//上班时间
		private DateTime offdutytime;//下班时间
		public DateTime OnDutyTime
		{
			get
			{
				return ondutytime;
			}
			set
			{
				ondutytime = value;
			}
		}
		public DateTime OffDutyTime
		{
			get
			{
				return offdutytime;
			}
			set
			{
				offdutytime = value;
			}
		}

		public SqlDataReader GetDutyTimes()
		{
		
			Database db = new Database();
			SqlDataReader dr = null;
			db.RunProc("Pr_GetDutyTimes",out dr);
			
			///返回数据
			return(dr);
		}

		public SqlDataReader GetDutyTimeByType(string sType)
		{
		
			Database db = new Database();
			SqlDataReader dr = null;
			SqlParameter[] param = {
									   db.CreateInParam("@Type",SqlDbType.VarChar,100,sType)
									   
								   };
			db.RunProc("Pr_GetDutyTimeByType",param,out dr);
			
			///返回数据
			return(dr);
		}

		public void UpdateDutyTime(DateTime dOnDutyTime,DateTime dOffDutyTime)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.CreateInParam("@Ondutytime",SqlDbType.DateTime,8,dOnDutyTime),
									   db.CreateInParam("@Offdutytime",SqlDbType.DateTime,8,dOffDutyTime)
									   
								   };
			db.RunProc("Pr_UpdateDutyTime",prams);				
		}

		public SqlDataReader GetAttendances(DateTime dBeginTime,DateTime dEndTime,int nStaffID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   db.CreateInParam("@BeginTime",SqlDbType.DateTime,8,dBeginTime),
									   db.CreateInParam("@EndTime",SqlDbType.DateTime,8,dEndTime),
									   db.CreateInParam("@StaffID",SqlDbType.Int,4,nStaffID)};
			db.RunProc("Pr_GetAttendences",prams,out dr);
			
			return(dr);
			//
		}
	}
}