using System;
using System.Data;
using System.Collections;

using MyOA.DataAccessLayer;
using MyOA.DataAccessHelper;
using MyOA.CommonComponent;

namespace MyOA.BusinessLogicLayer
{
	/// <summary>
	/// Plan 的摘要說明。
	/// </summary>
	public class Plan
	{
		#region 私有成員

		private int _planId;			//計劃安排ID
		private string _loginName;		//用戶登錄名
		private DateTime _planDate;		//計劃日期
		private string _planContent;	//計劃內容

		private bool _exist;				//是否存在標志

		#endregion 私有成員

		#region 屬性
		
		public int PlanID
		{
			set
			{
				this._planId=value;
			}
			get
			{
				return this._planId;
			}
		}
		public string LoginName
		{
			set
			{
				this._loginName=value;
			}
			get
			{
				return this._loginName;
			}
		}
		public DateTime PlanDate
		{
			set
			{
				this._planDate=value;
			}
			get
			{
				return this._planDate;
			}
		}
		public string PlanContent
		{
			set
			{
				this._planContent=value;
			}
			get
			{
				return this._planContent;
			}
		}
		public bool Exist
		{
			get
			{
				return this._exist;
			}
		}

		#endregion 屬性

		#region 方法
		
		/// <summary>
		/// 根據用戶登錄名和日期，獲取計劃安排
		/// </summary>
		/// <param name="loginName">用戶登錄名</param>
		/// <param name="planDate">日期</param>
		public void LoadData(string loginName,DateTime planDate)
		{
			Database db=new Database();		//實例化一個Database類

			string sql="";
			sql="Select * from [Plan] where LoginName = "
				+ SqlStringConstructor.GetQuotedString(loginName) 
				+" And PlanDate = "
				+ SqlStringConstructor.GetQuotedString(planDate.Date.ToString());

			DataRow dr=db.GetDataRow(sql);	//利用Database類的GetDataRow方法查詢數據

			//根據查詢得到的數據，對成員賦值
			if(dr!=null)
			{
				this._planId=GetSafeData.ValidateDataRow_N(dr,"PlanId");
				this._loginName=GetSafeData.ValidateDataRow_S(dr,"LoginName");
				this._planDate=GetSafeData.ValidateDataRow_T(dr,"PlanDate");
				this._planContent=GetSafeData.ValidateDataRow_S(dr,"PlanContent");
				
				this._exist=true;
			}
			else
			{
				this._exist=false;
			}
		}
		/// <summary>
		/// 添加計劃信息
		/// </summary>
		/// <param name="htUserInfo">計劃信息哈希表</param>
		public static void Add(Hashtable userInfo)
		{
			Database db=new Database();		//實例化一個Database類
			db.Insert("[Plan]",userInfo );	//利用Database類的Insert方法添加數據
		}

		/// <summary>
		/// 修改計劃信息
		/// </summary>
		/// <param name="planInfo">計劃信息哈希表</param>
		public void Update()
		{
			Database db=new Database();			//實例化一個Database類
			Hashtable planInfo=new Hashtable();
			planInfo.Add("PlanContent",SqlStringConstructor.GetQuotedString(this._planContent));

				string where=" Where PlanId="+this._planId;
			db.Update("[Plan]",planInfo,where);	//利用Database類的Update方法修改數據
		}
		#endregion 方法
	}
}