employee.cs

人事管理系统源码 主要功能有： 员工管理：员工信息管理 员工调动管理 部门管理：部门信息管理 部门人员管理 用户管理：用户管理 修改密码

using System;
using System.Data;

namespace PMS.Components
{
	/// <summary>
	/// Employee 的摘要说明。
	/// </summary>
	public class Employee
	{
		/// <summary>
		/// 
		/// </summary>
		/// <returns></returns>
		public DataTable GetEmployee()
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Employee]") ;
				return(DT) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}

		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="EmployeeID"></param>
		/// <returns></returns>
		public DataTable GetEmployee(string EmployeeID)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Employee] where EmployeeID='"+EmployeeID+"'") ;
				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 AddEmployee(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="EmployeeID"></param>
		/// <returns></returns>
		public bool DeleteEmployee(string EmployeeID) 
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				bool bResult = DataAs.ExecSql("delete from [Employee] where EmployeeID = '"+EmployeeID+"'") ;
				return(bResult) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="UserID"></param>
		/// <param name="sPwd"></param>
		/// <returns></returns>
		public bool UpdateEmployee(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 EmployID)
		{
			DataTable DT = GetEmployee(EmployID);
			if(DT.Rows.Count == 0)
			{
				return true ;
			}
			else
			{
				return false ;
			}
		}
	}
}