applyinfo.cs

客户订单管理系统

using System;
using System.Data ;
using HRAdmin.COMMON ;
using HRAdmin.DAL ;

namespace HRAdmin.BLL
{
	/// <summary>
	/// ApplyInfo 的摘要说明。
	/// </summary>
	public class ApplyInfo
	{
		public ApplyInfo()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
		#region 私有变量
		private int _applyID ;
		private string _type ;
		private string _status ;
		private DateTime _startDate ;
		private DateTime _endDate ;		
		private string _dsc ;
		private int _persID ;
		private int _deptID ;
		private DateTime _putDate ;
		#endregion

		#region 公共属性
		public int ApplyID
		{
			get {return _applyID ;}
			set {_applyID = value ;}
		}

		public string Type
		{
			get {return _type ;}
			set { _type = value ;}
		}

		public string Status
		{
			get {return _status ;}
			set {_status = value ;}
		}

		public DateTime StartDate
		{
			get { return _startDate ;}
			set { _startDate = value ;}
		}

		public DateTime EndDate
		{
			get { return _endDate ;}
			set { _endDate = value ;}
		}

		public string Dsc
		{
			get {return _dsc ;}
			set { _dsc = value ;}
		}

		public int PersID
		{
			get {return _persID ;}
			set { _persID = value ;}
		}

		public int DeptID
		{
			get{ return _deptID ; }
			set{ _deptID = value ;}
		}

		public DateTime PutDate
		{
			get{return _putDate ;}
			set{_putDate=value ;}
		}
		#endregion

		#region 公共方法

		/// <summary>
		/// 根据申请信息ID查询申请信息
		/// </summary>
		/// <param name="applyid"></param>
		/// <returns></returns>
		public int GetApplyInfo(int applyid)
		{
			int ret = -1 ;

			//存储过程名
			string spName = "HR_Apply_Get" ;  
			//参数
			object[] para = new object[] {applyid} ;
			//执行存储过程
			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count > 0)
			{
				//查询成功，初始化申请信息的各个属性
				DataRow dr = dt.Rows[0] ;
				AssignAttribute(dr) ;

				//返回成功
				ret = 0 ;
			}

			return ret ;
		}

		/// <summary>
		/// 员工查询个人申请信息
		/// </summary>
		/// <returns>DataTable个人的申请信息</returns>
		public static DataTable GetApplyInfo_Psn(string type,DateTime startDate,DateTime endDate,int pID)
		{			
			//存储过程名
			string spName = "HR_Apply_GetPsn" ;  
			//参数
			object[] para = new object[] {type,startDate,endDate,pID} ;
			//执行存储过程，并返回DataTable
			return DataAccess.ExecuteDataTable(spName,para) ;			
		}

		/// <summary>
		/// 部门经理查询申请信息
		/// </summary>
		/// <param name="id">ID</param>
		/// <returns>DataTable部门的申请信息</returns>
		public static DataTable GetApplyInfo_Mgr(string type,int deptID)
		{	
			//存储过程名			
			string spName = "HR_Apply_GetMgr" ;

			//参数
			object[] para = new object[] {type,deptID} ;

			//执行存储过程，并返回DataTable
			return DataAccess.ExecuteDataTable(spName,para) ;			
		}

		/// <summary>
		/// 指定申请信息属性
		/// </summary>
		/// <param name="dr">dr</param>
		public void AssignAttribute(DataRow dr)
		{
			this._applyID = CommHandler.StringToInt(dr["APPLYID"].ToString()) ;		
			this._type = dr["TYPE"].ToString() ;
			this._status = dr["STATUS"].ToString() ;
			this._startDate = CommHandler.StringToDateTime(dr["STARTDATE"].ToString()) ;
			this._endDate = CommHandler.StringToDateTime(dr["ENDDATE"].ToString()) ;
			this._dsc = dr["Dsc"].ToString() ;
			
		}
		
		/// <summary>
		/// 添加申请信息
		/// </summary>
		/// <returns>新产生的申请信息ID</returns>
		public int AddApply()
		{
			//存储过程名
			string spName = "HR_Apply_Add" ;
			//存储过程参数
			object[] para = new object[] {"",_type,_status,_startDate,_endDate,_dsc,_persID,_deptID,_putDate} ;
			//调用数据访问层的方法访问存储过程
			_applyID = DataAccess.ExecuteNonQuery(spName,true,para) ;

			//返回新申请信息ID
			return _applyID ;			
		}

		/// <summary>
		/// 修改申请信息
		/// </summary>
		/// <returns>修改的命令所影响的行数</returns>
		public int ModifyApply()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "HR_Apply_Modify" ;
			//存储过程参数
			object[] para = new object[] {_applyID,_type,_status,_startDate,_endDate,_dsc} ;
			//调用数据访问层的方法执行存储过程，并返回受影响的行数
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		/// <summary>
		/// 删除申请信息
		/// </summary>
		/// <param name="id">申请信息ID</param>
		/// <returns>删除结果</returns>
		public static int DeleteApply(string id)
		{
			int ret = -1 ;

			//删除申请信息的存储过程
			string spName = "HR_Apply_Delete" ;
			//存储过程参数
			object[] para = new object[] {id} ;
			//调用数据访问方法执行存储过程，并返回受影响的行数
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		/// <summary>
		/// 审批申请
		/// </summary>
		/// <param name="id">申请信息ID</param>
		/// <param name="result">审批结果</param>
		/// <param name="response">批复内容</param>
		/// <returns>受影响的行数</returns>
		public static int ExamineApply(int id,string result,string response)
		{
			int ret = -1 ;

			//存储过程名
			string spName = "HR_Apply_Examine" ;
			//存储过程参数
			object[] para = new object[] {id,result,response} ;
			//调用数据访问层的方法执行存储过程，并返回受影响的行数
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}
		#endregion


	}
}