?? empsystem.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using qminoa.Common.Data;
using qminoa.DA;
namespace qminoa.BLL
{
public class EmpSystem
{
/// <summary>
///
/// </summary>
/// <param name="conID"></param>
/// <returns></returns>
public DataTable GetEmpConTB_By_ConID(int conID)
{
DataTable conTB ;
using(MrBaseInf empAccess = new MrBaseInf())
{
conTB = empAccess.GetEmpConData_By_ConID(conID).Tables[0];
}
return conTB;
}
/// <summary>
///
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateMrContact(EmpConData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateMrContact(empData);
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool InsertMrContact(EmpConData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.InsertMrContact(empData);
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="conID"></param>
/// <returns></returns>
public bool DeleteMrContact(int conID)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.DeleteMrContact(conID);
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="empID"></param>
/// <returns></returns>
public DataTable GetEmpConTB(int empID)
{
DataTable table ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
table = EmpAccess.GetEmpConData(empID).Tables[0];
}
return table;
}
/// <summary>
///
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool InsertMrArchive(EmpArcData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.InsertMrArchive(empData);
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateMrArchive(EmpArcData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateMrArchive(empData);
}
return result;
}
/// <summary>
/// 獲得指定用戶的指定的檔案信息
/// </summary>
/// <param name="arcID"></param>
/// <returns></returns>
public DataTable GetEmpArcTB_By_ArcID(int arcID)
{
DataTable table;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
table = EmpAccess.GetEmpArcData_By_ArcID(arcID).Tables[0];
}
return table;
}
/// <summary>
/// 刪除指定用戶的檔案
/// </summary>
/// <param name="arcID"></param>
/// <returns></returns>
public bool DeleteMrArchive(int arcID)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.DeleteMrArchive(arcID);
}
return result;
}
/// <summary>
/// 更新指定的用戶的履歷
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateMrVita(EmpVisaData empData)
{
bool result ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateMrVita(empData);
}
return result;
}
/// 添加新的履歷給指定的用戶
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool InsertMrVita(EmpVisaData empData)
{
bool result ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.InsertMrVita(empData);
}
return result;
}
/// <summary>
/// 刪除指定的用戶的履歷
/// </summary>
/// <param name="visaID"></param>
/// <returns></returns>
public bool DeleteMrVita(int visaID)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.DeleteMrVita(visaID);
}
return result;
}
/// <summary>
/// 獲取指定用戶的檔案列表
/// </summary>
/// <param name="empID"></param>
/// <returns></returns>
public DataTable GetEmpArcTB(int empID)
{
DataTable table ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
table = EmpAccess.GetEmpArcData(empID).Tables[0];
}
return table;
}
/// <summary>
/// 更新指定用戶的學歷信息
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateEmpEduInf(EmpBaseData empData)
{
bool result ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateEmpEduInf(empData);
}
return result ;
}
/// <summary>
/// 獲取指定用戶的指定的履歷信息
/// </summary>
/// <param name="visaID"></param>
/// <returns></returns>
public DataTable GetEmpVisaTB_By_VisaID(int visaID)
{
DataTable table ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
table = EmpAccess.GetEmpVisaData_By_VisaID(visaID).Tables[0];
}
return table;
}
/// <summary>
/// 獲取指定用戶的履歷列表
/// </summary>
/// <param name="empID"></param>
/// <returns></returns>
public DataTable GetEmpVisaTB(int empID)
{
DataTable empTB;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
empTB = EmpAccess.GetEmpVisaData(empID).Tables[0];
}
return empTB;
}
/// <summary>
/// 獲取所有被停用賬號的用戶的信息
/// </summary>
/// <returns></returns>
public DataTable GetEmpTBStoped()
{
DataTable empTB;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
empTB = EmpAccess.GetEmpDataStoped().Tables[0];
}
return empTB;
}
/// <summary>
/// 更新用戶的個人信息
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateEmpPersInf(EmpBaseData empData)
{
bool result ;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateEmpPersInf(empData);
}
return result;
}
/// <summary>
/// 更新用戶的福利信息信息
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateEmpWelInf(EmpBaseData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateEmpWelInf(empData);
}
return result;
}
/// <summary>
/// 獲取符合條件的用戶的照片信息
/// </summary>
/// <param name="branchID"></param>
/// <param name="depID"></param>
/// <param name="empName"></param>
/// <returns></returns>
public DataTable GetEmpPhotoTB_By_QueryStr(string branchID,string depID,string empName)
{
//讀取人員信息數據
DataTable empTB = GetEmpTB_By_QueryStr(branchID,depID,empName);
//創建數據結構表
DataTable photoTB = (new EmpPhotoData()).Tables[EmpPhotoData.EMPPHOTO_TABLE_NAME];
DataRowCollection empRows = empTB.Rows;
DataRow photoRow = null;
//此變量控件列序號
int j = 0;
//循環讀取人員照片信息
for(int i=0;i<empRows.Count;i++)
{
//判斷行是否結束
if(j%5==0)
{
//判斷是否是第一次循環
if(j>0)
{
photoTB.Rows.Add(photoRow);
}
photoRow = photoTB.NewRow();
//行結束，列序號重置為0
j = 0;
}
//將數據庫中的照片數據進行轉換，并在每張照片加上到人員詳細信息的頁面超鏈接
if(empRows[i][EmpBaseData.PHOTO_SIZE_FIELD]!=DBNull.Value)
{
photoRow[j] = "<a href=empbase.aspx?empid="+empRows[i][EmpBaseData.EMPID_FIELD].ToString()+" title=顯示人員詳細信息><img src=emppicdown.aspx?EmpID="+empRows[i][EmpBaseData.EMPID_FIELD].ToString()+" border=0 ></a><br><a href=empbase.aspx?empid="+empRows[i][EmpBaseData.EMPID_FIELD].ToString()+" title=顯示人員詳細信息>"+empRows[i][EmpBaseData.EMPNAME_FIELD].ToString()+"</a>";
}
//如果數據庫在照片數據為空時，顯示缺省圖片
else
{
photoRow[j] = "<a href=empbase.aspx?empid="+empRows[i][EmpBaseData.EMPID_FIELD].ToString()+" title=顯示人員詳細信息><img src=../img/logo2.jpg border=0 ></a><br><a href=empbase.aspx?empid="+empRows[i][EmpBaseData.EMPID_FIELD].ToString()+" title=顯示人員詳細信息>"+empRows[i][EmpBaseData.EMPNAME_FIELD].ToString()+"</a>";
}
//列序號加1
j++;
//如果最后一行不滿5，直接顯示
if(i==empRows.Count-1)
{
photoTB.Rows.Add(photoRow);
}
}
//返回處理后的照片數據表
return photoTB;
}
/// <summary>
/// 獲取符合條件的用戶的信息
/// </summary>
/// <param name="branchID">機構ID號</param>
/// <param name="depID">部門ID號</param>
/// <param name="empName">用戶姓名</param>
/// <returns></returns>
public DataTable GetEmpTB_By_QueryStr(string branchID,string depID,string empName)
{
DataTable empTB;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
empTB = EmpAccess.GetEmpData_By_QueryStr(branchID,depID,empName).Tables[0];
}
return empTB;
}
/// <summary>
/// 獲取指定ID的用戶的信息
/// </summary>
/// <param name="empID"></param>
/// <returns></returns>
public DataTable GetEmpTB_By_EmpID(int empID)
{
DataTable empTB ;
using(MrBaseInf empAccess = new MrBaseInf())
{
empTB = empAccess.GetEmpBaseData_By_EmpID(empID).Tables[0];
}
return empTB;
}
/// <summary>
/// 更新用戶的信息
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public bool UpdateEmp(EmpBaseData empData)
{
bool result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.UpdateMrBaseInf(empData);
}
return result ;
}
/// <summary>
/// 建立一個新的用戶
/// </summary>
/// <param name="empData"></param>
/// <returns></returns>
public int CreateEmp(EmpBaseData empData)
{
int result;
using(MrBaseInf EmpAccess = new MrBaseInf())
{
result = EmpAccess.InsertMrBaseInf(empData);
}
return result ;
}
/// <summary>
/// 獲得指定用戶的照片
/// </summary>
/// <param name="empID"></param>
/// <returns></returns>
public DataTable GetEmpPicTB(int empID)
{
DataTable table;
using(MrBaseInf PhotoAccess = new MrBaseInf())
{
table = PhotoAccess.GetEmpPicData(empID).Tables[0];
}
return table;
}
public EmpSystem()
{
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -