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

using MyOA.DataAccessLayer;
using MyOA.DataAccessHelper;

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

		private int _roleId;			//角色（職務）ID
		private string _roleName;		//角色（職務）名

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

		#endregion 私有成員

		#region 屬性
		
		public int RoleID
		{
			set
			{
				this._roleId=value;
			}
			get
			{
				return this._roleId;
			}
		}
		public string RoleName
		{
			set
			{
				this._roleName=value;
			}
			get
			{
				return this._roleName;
			}
		}
		public bool Exist
		{
			get
			{
				return this._exist;
			}
		}

		#endregion 屬性

		#region 方法
		
		/// <summary>
		/// 根據參數roleId，獲取角色（職務）詳細信息
		/// </summary>
		/// <param name="topicID">角色（職務）ID</param>
		public void LoadData(int roleId)
		{
			Database db=new Database();		//實例化一個Database類

			string sql="";
			sql="Select * from [Role] where RoleId = "+ roleId ;

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

			//根據查詢得到的數據，對成員賦值
			if(dr!=null)
			{
				this._roleId=GetSafeData.ValidateDataRow_N(dr,"RoleId");
				this._roleName=GetSafeData.ValidateDataRow_S(dr,"RoleName");
				
				this._exist=true;
			}
			else
			{
				this._exist=false;
			}
		}

		/// <summary>
		/// 根據查詢條件哈希表,查詢數據
		/// </summary>
		/// <param name="queryItems">查詢條件哈希表</param>
		/// <returns>查詢結果數據DataTable</returns>
		public static DataTable Query(Hashtable queryItems)
		{
			string where=SqlStringConstructor.GetConditionClause(queryItems);
			string sql="Select * From [Role]"+where;
			Database db = new Database();
			return db.GetDataTable(sql);
		}

		/// <summary>
		/// 修改角色權限信息
		/// </summary>
		/// <param name="roleInfo">角色權限信息哈希表</param>
		public static void Update(Hashtable roleInfo,string where)
		{
			Database db=new Database();			//實例化一個Database類
			db.Update("[Role]",roleInfo,where);	//利用Database類的Update方法修改數據
		}
		#endregion 方法
	}
}