dutytime.cs

本系统以采用一种结合B/S和Web的方式开发的中小企业办公自动化系统为例讨论办公自动化系统的设计与实现。

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);
			//
		}
	}
}