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

namespace HRAdmin.BLL
{
	/// <summary>
	/// BulletinInfo 的摘要說明。
	/// </summary>
	public class BulletinInfo
	{
		public BulletinInfo()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		#region 私有變量
		private int _bulletinID ;
		private string _title ;
		private string _sponsor ;
		private DateTime _createTime ;
		private DateTime _validFrom ;
		private DateTime _validTo ;
		private string _content ;
		#endregion

		#region 公共屬性
		public int BulletinID
		{
			get {return _bulletinID ;}
			set {_bulletinID = value ;}
		}

		public string Title
		{
			get {return _title ;}
			set { _title = value ;}
		}

		public string Sponsor
		{
			get {return _sponsor ;}
			set {_sponsor = value ;}
		}

		public DateTime CreateTime
		{
			get { return _createTime ;}
			set { _createTime = value ;}
		}

		public DateTime ValidFrom
		{
			get { return _validFrom ;}
			set { _validFrom = value ;}
		}

		public DateTime ValidTo
		{
			get { return _validTo ;}
			set { _validTo = value ;}
		}

		public string Content
		{
			get {return _content ;}
			set { _content = value ;}
		}
		#endregion

		#region 公共方法
		/// <summary>
		/// 查詢有效的公告信息
		/// </summary>
		/// <returns>DataTable有效的公告信息</returns>
		public static DataTable GetValidBulletin()
		{			
			//存儲過程名
			string spName = "HR_Bulletin_GetValid" ;  
			//執行存儲過程，并返回DataTable
			return DataAccess.ExecuteDataTable(spName) ;			
		}
				
		/// <summary>
		/// 查詢指定的條件公告信息
		/// </summary>
		/// <param name="title">標題</param>
		/// <param name="startDate">查詢開始日期</param>
		/// <param name="endDate">查詢結束日期</param>
		/// <returns>查詢結果DataTable</returns>
		public static DataTable GetBulletin(string title,string startDate,string endDate)
		{
			//存儲過程名			
			string spName = "HR_Bulletin_Get" ;
			//參數
			object[] para = new object[] {title,startDate,endDate} ;

			//執行存儲過程，并返回DataTable
			return DataAccess.ExecuteDataTable(spName,para) ;			
		}

		/// <summary>
		/// 查詢指定ID的公告信息
		/// </summary>
		/// <param name="id">公告信息ID</param>
		/// <returns>查詢成功標志 -1:失敗，0:成功</returns>
		public int GetBulletinByID(int id)
		{
			int ret = -1 ;

			//存儲過程名			
			string spName = "HR_Bulletin_GetByID" ;
			//參數
			object[] para = new object[] {id} ;

			//執行存儲過程
			DataTable dt =  DataAccess.ExecuteDataTable(spName,para) ;	
			//查詢成功
			if(dt != null && dt.Rows.Count > 0)
			{
				//根據查詢結果指派公告屬性
				DataRow dr = dt.Rows[0] ;
				AssignAttribute(dr) ;

				ret = 0 ;
			}

			return ret ;
		}

		/// <summary>
		/// 指定公告屬性
		/// </summary>
		/// <param name="dr">dr</param>
		public void AssignAttribute(DataRow dr)
		{
			this._bulletinID = CommHandler.StringToInt(dr["BULLETINID"].ToString()) ;
			this._content = dr["CONTENT"].ToString() ;
			this._createTime = CommHandler.StringToDateTime(dr["CREATETIME"].ToString()) ;
			this._sponsor = dr["SPONSOR"].ToString() ;
			this._title = dr["TITLE"].ToString() ;
			this._validFrom = CommHandler.StringToDateTime(dr["VALIDFROM"].ToString()) ;
			this._validTo = CommHandler.StringToDateTime(dr["VALIDTO"].ToString()) ;			
		}
		
		/// <summary>
		/// 添加公告信息
		/// </summary>
		/// <returns>新產生的公告信息ID</returns>
		public int AddBulletin()
		{
			//存儲過程名
			string spName = "HR_Bulletin_Add" ;
			//存儲過程參數
			object[] para = new object[] {"",_title,_sponsor,_validFrom,_validTo,_content,_createTime} ;
			//調用數據訪問層的方法訪問存儲過程
			_bulletinID = DataAccess.ExecuteNonQuery(spName,true,para) ;

			//返回新公告ID
			return _bulletinID ;			
		}

		/// <summary>
		/// 修改公告信息
		/// </summary>
		/// <returns>修改命令所影響的行數</returns>
		public int ModifyBulletin()
		{
			int ret = -1 ;

			//存儲過程名
			string spName = "HR_Bulletin_Modify" ;
			//存儲過程參數
			object[] para = new object[] {_bulletinID,_title,_sponsor,_validFrom,_validTo,_content} ;
			//調用數據訪問層的方法執行存儲過程，并返回受影響的行數
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		/// <summary>
		/// 刪除公告信息
		/// </summary>
		/// <param name="id">公告信息ID</param>
		/// <returns>刪除結果</returns>
		public static int DeleteBulletin(string id)
		{
			int ret = -1 ;

			//刪除公告信息的存儲過程
			string spName = "HR_Bulletin_Delete" ;
			//存儲過程參數
			object[] para = new object[] {id} ;
			//調用數據訪問方法執行存儲過程，并返回受影響的行數
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}
		#endregion
	}
}