?? department.cs
字號:
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) ;
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -