using System;
using System.Data;

namespace PMS.Components
{
	/// <summary>
	/// Department 的摘要說明。
	/// </summary>
	public class Department
	{
		/// <summary>
		/// 得到關(guān)于部門的所有信息
		/// </summary>
		/// <returns></returns>
		public DataTable GetDepartment()
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Department]") ;
				return(DT) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 根據(jù)部門編號，得到其它信息
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public DataTable GetDepartment(string DepartID)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess();
				DataTable DT = DataAs.CreateDataTable("select * from Department where DepartID='"+DepartID+"'");
				return(DT);
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 添加部門記錄
		/// </summary>
		/// <param name="strSql"></param>
		/// <returns></returns>
		public bool AddDepartment(string strSql)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				bool bResult = DataAs.ExecSql(strSql) ;
				return(bResult) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 刪除一條部門記錄
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public bool DeleteDepartment(string DepartID)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				bool bResult = DataAs.ExecSql("delete from [Department] where DepartID = '"+DepartID+"'") ;
				return(bResult) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public bool UpdateDepartment(string strSql)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				bool bResult = DataAs.ExecSql(strSql) ;
				return(bResult) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 判斷部門編號是否唯一
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public bool IsUnique(string DepartID)
		{
			DataTable DT = GetDepartment(DepartID);
			if(DT.Rows.Count == 0)
			{
				return true ;
			}
			else
			{
				return false ;
			}
		}
		/// <summary>
		/// 判斷此部門編號下是否存在員工記錄
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public bool IsHaveEmployee(string DepartID)
		{
			DataTable DT = GetEmployee(DepartID);
			if(DT.Rows.Count > 0)
			{
				return true ;
			}
			else
			{
				return false ;
			}
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="DepartID"></param>
		/// <returns></returns>
		public DataTable GetEmployee(string DepartID)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Employee] where DepartID='"+DepartID+"' order by Pubdate DESC") ;
				return(DT) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}

		}
	}
}