department.cs

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

using System;
using System.Data;

namespace PMS.Components
{
	/// <summary>
	/// Department 的摘要说明。
	/// </summary>
	public class Department
	{
		/// <summary>
		/// 得到关于部门的所有信息
		/// </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>
		/// 根据部门编号，得到其它信息
		/// </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) ;
			}

		}
	}
}