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

namespace HRAdmin.BLL
{
	/// <summary>
	/// PersonnelInfo 的摘要說明。
	/// </summary>
	public class PersonnelInfo
	{
		public PersonnelInfo()
		{
//			string sql = "select * from HR_Personnelinfo where usrid = '" + usrID + "'" ;
//			DataAccess.ExecuteDataTable(
		}

		#region 私有變量
		private int _personnelID ;
		private string _usrID ;
//		private string _usrPassword ;
		private string _usrName ;
		private string _sex ;
		private DateTime _birthday ;
		private string _nativePlace ;
		private string _nation ;
		private string _party ;
		private string _education ;
		private string _academy ;
		private string _major ;
		private string _telOffice ;
		private string _telMobile ;
		private string _telHome ;
		private string _email ;
		private string _idcard ;
		private string _address ;
		private string _persType ;
		private int _positionID;
		private int _deptID ;
		private string _salary ;
		private DateTime _entTime ;
		private string _contractID ;
		private DateTime _contractFrom ;
		private DateTime _contractTo ;
		private string _endowment ;
		private string _medicare ;
		private string _isSystem ;
		private string _isDept ;
		#endregion

		#region 公用屬性
		/// <summary>
		/// 員工ID
		/// </summary>
		public int PersonnelID
		{
			get { return _personnelID ;}
			set { _personnelID = value ;}
		}

		/// <summary>
		/// 用戶ID
		/// </summary>
		public string UsrID
		{
			get { return _usrID ;}
			set { _usrID = value ;}
		}

		/// <summary>
		/// 員工姓名
		/// </summary>
		public string UsrName
		{
			get { return _usrName ; }
			set { _usrName = value ;}
		}

		/// <summary>
		/// 性別
		/// </summary>
		public string Sex
		{
			get { return _sex ; }
			set { _sex = value ;}
		}

		/// <summary>
		/// 生日
		/// </summary>
		public DateTime Birthday
		{
			get { return _birthday ; }
			set { _birthday = value ;}
		}

		/// <summary>
		/// 籍貫
		/// </summary>
		public string NativePlace
		{
			get { return _nativePlace ; }
			set { _nativePlace = value ;}
		}

		/// <summary>
		/// 民族
		/// </summary>
		public string Nation
		{
			get { return _nation ; }
			set { _nation = value ;}
		}

		/// <summary>
		/// 政治面貌
		/// </summary>
		public string Party
		{
			get { return _party ; }
			set { _party = value ;}
		}

		/// <summary>
		/// 文化程度
		/// </summary>
		public string Education
		{
			get { return _education ; }
			set { _education = value ;}
		}

		/// <summary>
		/// 畢業院校
		/// </summary>
		public string Academy
		{
			get { return _academy ; }
			set { _academy = value ;}
		}

		/// <summary>
		/// 主修專業
		/// </summary>
		public string Major
		{
			get { return _major ; }
			set { _major = value ;}
		}

		/// <summary>
		/// 辦公電話
		/// </summary>
		public string TelOffice
		{
			get { return _telOffice ; }
			set { _telOffice = value ;}
		}

		/// <summary>
		/// 移動電話
		/// </summary>
		public string TelMobile
		{
			get { return _telMobile ; }
			set { _telMobile = value ;}
		}

		/// <summary>
		/// 家庭電話
		/// </summary>
		public string TelHome
		{
			get { return _telHome ; }
			set { _telHome = value ;}
		}

		/// <summary>
		/// 電子郵件
		/// </summary>
		public string Email
		{
			get { return _email ; }
			set { _email = value ;}
		}

		/// <summary>
		/// 身份證號
		/// </summary>
		public string IDCard
		{
			get { return _idcard ; }
			set { _idcard = value ;}
		}

		/// <summary>
		/// 家庭住址
		/// </summary>
		public string Address
		{
			get { return _address ; }
			set { _address = value ;}
		}

		/// <summary>
		/// 員工類型
		/// </summary>
		public string PersType
		{
			get { return _persType ; }
			set { _persType = value ;}
		}

		/// <summary>
		/// 職位
		/// </summary>
		public int PositionID
		{
			get { return _positionID ; }
			set { _positionID = value ;}
		}

		/// <summary>
		/// 部門
		/// </summary>
		public int DeptID
		{
			get { return _deptID ; }
			set { _deptID = value ;}
		}

		/// <summary>
		/// 工資級別
		/// </summary>
		public string Salary
		{
			get { return _salary ; }
			set { _salary = value ;}
		}

		/// <summary>
		/// 入職時間
		/// </summary>
		public DateTime EntTime
		{
			get { return _entTime ; }
			set { _entTime = value ;}
		}

		/// <summary>
		/// 合同編號
		/// </summary>
		public string ContractID
		{
			get { return _contractID ; }
			set { _contractID = value ;}
		}

		/// <summary>
		/// 合同開始時間
		/// </summary>
		public DateTime ContractFrom
		{
			get { return _contractFrom ; }
			set { _contractFrom = value ;}
		}

		/// <summary>
		/// 合同結束時間
		/// </summary>
		public DateTime ContractTo
		{
			get { return _contractTo ; }
			set { _contractTo = value ;}
		}

		/// <summary>
		/// 養老保險號
		/// </summary>
		public string Endowment
		{
			get { return _endowment ; }
			set { _endowment = value ;}
		}

		/// <summary>
		/// 醫療保險
		/// </summary>
		public string Medicare
		{
			get { return _medicare ; }
			set { _medicare = value ;}
		}

		/// <summary>
		/// 是否具有系統管理權限
		/// </summary>
		public string IsSystem
		{
			get { return _isSystem ;}
			set { _isSystem = value ;}
		}

		/// <summary>
		/// 是否具有部門管理權限
		/// </summary>
		public string IsDept
		{
			get { return _isDept ;}
			set { _isDept = value ;}
		}
		#endregion

		#region 公用方法
		
		/// <summary>
		/// 查詢部門所有員工信息
		/// </summary>
		/// <returns>DataTable所有員工信息</returns>
		public static DataTable GetAllPersonnel()
		{			
			//存儲過程名
			string spName = "HR_Personnel_GetAll" ;  
			//執行存儲過程，并返回DataSet
			return DataAccess.ExecuteDataTable(spName) ;			
		}

		/// <summary>
		/// 根據部門ID查詢部門員工
		/// </summary>
		/// <param name="deptid">部門ID</param>
		/// <returns>DataTable員工信息</returns>
		public static DataTable GetPersonnelByDeptID(int deptid)
		{
			//存儲過程名
			string spName = "HR_Personnel_GetByDept" ;  
			//參數
			object[] para = new object[] {deptid} ;
			//執行存儲過程，并返回DataTable
			return DataAccess.ExecuteDataTable(spName,para) ;
		}

		/// <summary>
		/// 查詢指定的員工信息
		/// </summary>
		/// <param name="id">ID</param>
		/// <returns>DataTable員工信息</returns>
		public bool GetPersonnel(int id)
		{
			bool ret = false ;

			//存儲過程名
			DataTable dt = new DataTable() ;
			string spName = "HR_Personnel_Get" ;
			//參數
			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 = true ;
				
			}
			
			return ret ;
		}

		/// <summary>
		/// 根據用戶ID查詢員工信息
		/// </summary>
		/// <param name="usrID">用戶ID</param>
		/// <returns>DataTable員工信息</returns>
		public bool GetPersonnelByUsrID(string usrID)
		{
			bool ret = false ;

			//存儲過程名
			DataTable dt = new DataTable() ;
			string spName = "HR_Personnel_GetByUsrID" ;
			//參數
			object[] para = new object[] {usrID} ;

			//執行存儲過程，并返回ds
			dt = DataAccess.ExecuteDataTable(spName,para) ;
			
			if(dt != null && dt.Rows.Count > 0 )
			{
				//查詢成功
				DataRow dr = dt.Rows[0] ;
				//指定屬性
				AssignAttribute(dr) ;

				ret = true ;
			
			}
			
			return ret ;
		}

		/// <summary>
		/// 指定員工屬性
		/// </summary>
		/// <param name="dr">dr</param>
		public void AssignAttribute(DataRow dr)
		{
			this._academy = dr["academy"].ToString() ;
			this._address = dr["address"].ToString() ;
			this._birthday = CommHandler.StringToDateTime(dr["birthday"].ToString()) ;
			this._contractFrom = CommHandler.StringToDateTime(dr["contractfrom"].ToString()) ;
			this._contractID = dr["contractid"].ToString() ;
			this._contractTo = CommHandler.StringToDateTime(dr["contractto"].ToString()) ;
			this._deptID = CommHandler.StringToInt(dr["deptid"].ToString()) ;
			this._education = dr["education"].ToString() ;
			this._email = dr["email"].ToString() ;
			this._endowment = dr["endowment"].ToString() ;
			this._entTime = CommHandler.StringToDateTime(dr["enttime"].ToString()) ;
			this._idcard = dr["idcard"].ToString() ;
			this._isDept = dr["isdept"].ToString() ;
			this._isSystem = dr["issystem"].ToString() ;
			this._major = dr["major"].ToString() ;
			this._medicare = dr["medicare"].ToString() ;
			this._nation = dr["nation"].ToString() ;
			this._nativePlace = dr["nativeplace"].ToString() ;
			this._party = dr["party"].ToString() ;
			this._personnelID = CommHandler.StringToInt(dr["personnelid"].ToString()) ;
			this._persType = dr["perstype"].ToString() ;
			this._positionID = CommHandler.StringToInt(dr["positionid"].ToString()) ;
			this._salary = dr["salary"].ToString() ;
			this._sex = dr["sex"].ToString() ;
			this._telHome = dr["telhome"].ToString() ;
			this._telMobile = dr["telmobile"].ToString() ;
			this._telOffice = dr["teloffice"].ToString() ;
			this._usrID = dr["usrid"].ToString() ;
			this._usrName = dr["usrname"].ToString() ;
		}
		
		/// <summary>
		/// 添加員工信息
		/// </summary>
		/// <returns>新產生的員工ID</returns>
		public int AddPersonnel()
		{
			//添加員工信息存儲過程
			string spName = "HR_Personnel_Add" ;
			//存儲過程得參數
			object[] para = new object[] {"",
											 _usrID,
											 _deptID,
											 _usrName,
											 _sex,
											 _email,
											 _telOffice,
											 _telMobile,
											 _telHome,
											 _positionID,
											 (_birthday.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_birthday,
											 _nativePlace,
											 _nation,
											 _party,
											 _education,
											 _academy,
											 _major,
											 _idcard,
											 _address,
											 _persType,
											 _salary,
											 (_entTime.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_entTime,
											 _contractID,
											 (_contractFrom.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_contractFrom,
											 (_contractTo.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_contractTo,											
											 _endowment,
											 _medicare,
											 _isSystem,
											 _isDept
										 } ;
			//調用數據訪問層的方法執行存儲過程
			_personnelID = DataAccess.ExecuteNonQuery(spName,true,para) ;

			//返回新員工ID
			return _personnelID ;			
		}

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

			//修改員工信息的存儲過程
			string spName = "HR_Personnel_Modify" ;
			
			//存儲過程參數
			object[] para = new object[] {_personnelID,
											 _usrID,
											 _deptID,
											 _usrName,
											 _sex,
											 _email,
										     _telOffice,
											 _telMobile,
											 _telHome,
											 _positionID,
											 (_birthday.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_birthday,
										     _nativePlace,
											 _nation,
											 _party,
											 _education,
											 _academy,
											 _major,
										     _idcard,
											 _address,
											 _persType,
											 _salary,
											 (_entTime.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_entTime,
											 _contractID,
										     (_contractFrom.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_contractFrom,
											 (_contractTo.Equals(DateTime.MinValue))?(object)DBNull.Value:(object)_contractTo,											
											 _endowment,
											 _medicare,
											 _isSystem,
											 _isDept
			                              } ;
			//調用數據訪問方法執行存儲過程
			//并返回受影響的行數
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		/// <summary>
		/// 刪除員工信息
		/// </summary>
		/// <param name="id">待刪除的員工ID</param>
		/// <returns>刪除結果</returns>
		public static int DeletePersonnel(string id)
		{
			int ret = -1 ;

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

			return ret ;
		}

		/// <summary>
		/// 用戶登錄
		/// </summary>
		/// <param name="usrid">用戶ID</param>
		/// <param name="pwd">登錄密碼</param>
		/// <returns>結果</returns>
		public static int UsrLogin(string usrid,string pwd)
		{
			int ret = -1 ;

			//存儲過程名
			string spName = "HR_Personnel_Login" ;
			//存儲過程參數
			object[] para = new object[] {"",usrid,pwd} ;

			//調用數據訪問方法執行存儲過程
			//返回受影響行數
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		/// <summary>
		/// 修改密碼
		/// </summary>
		/// <param name="oldPwd">原密碼</param>
		/// <param name="newPwd">新密碼</param>
		/// <returns>結果</returns>
		public int ChangePwd(string oldPwd,string newPwd)
		{
			int ret = -1 ;

			//存儲過程名
			string spName = "HR_Personnel_ModifyPwd" ;
			//存儲過程參數
			object[] para = new object[] {"",_personnelID,oldPwd,newPwd} ;

			//調用數據訪問方法執行存儲過程
			//返回受影響行數
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;

		}
		#endregion
	}
}