personnelinfo.cs

人力资源管理系统 读者须安装好IIS和Microsoft Visual Stutio.NET相关开发环境

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
	}
}