📄 staff.cs
字号:
using System;
using System.ComponentModel;
using System.Collections;
using System.Diagnostics;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace OASelfManage.Components
{
/// <summary>
/// Staffer 的摘要说明。
/// </summary>
public class Staff
{
public Staff()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
#region 登录验证
/// <summary>
/// 登录验证
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <returns>返回用户ID</returns>
public string Login(string userName, string password)
{
string UserID,IsNeedKey;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@username", SqlDbType.VarChar, 25, userName),
data.MakeInParam("@password", SqlDbType.VarChar, 25, password),
data.MakeOutParam("@UserID", SqlDbType.VarChar, 25),
data.MakeOutParam("@IsNeedKey", SqlDbType.Bit, 1)
};
data.RunProc("sp_StaffLogin", prams);
UserID = (string) prams[2].Value;
IsNeedKey = prams[3].Value.ToString();
if (UserID == string.Empty)
return null;
else
return UserID+"-"+IsNeedKey;
}
#endregion
#region 用户退出
/// <summary>
/// 用户退出
/// </summary>
/// <param name="userName">用户名</param>
public void Logout(string userName)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@username", SqlDbType.VarChar, 25, userName)
};
data.RunProc("sp_StaffLogout", prams);
}
#endregion
#region 获取用户基本信息
/// <summary>
/// 获取用户基本信息
/// </summary>
/// <param name="StaffID">用户ID</param>
/// <returns>返回DataReader</returns>
public SqlDataReader GetStaffInfo(long StaffID)
{
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@StaffID", SqlDbType.Int, 4, StaffID),
};
try
{
// run the stored procedure
data.RunProc("sp_GetStaffInfo",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员信息读取出错!",ex);
}
}
#endregion
#region 获取用户基本信息
/// <summary>
/// 获取用户基本信息
/// </summary>
/// <param name="StaffID">用户ID</param>
/// <returns>返回DataReader</returns>
public SqlDataReader GetStaffInfo(string StaffIDs)
{
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@StaffIDs", SqlDbType.VarChar, 10000, StaffIDs),
};
try
{
// run the stored procedure
data.RunProc("sp_GetStaffInfoEx",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员信息读取出错!",ex);
}
}
#endregion
#region 根据用户代号获取用户真实姓名
/// <summary>
/// 获取用户基本信息
/// </summary>
/// <param name="Username">用户代号</param>
/// <returns>返回真实姓名</returns>
public static string GetRealNameByUsername(string Username)
{
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@Username", SqlDbType.NVarChar, 30, Username),
};
try
{
// run the stored procedure
data.RunProc("sp_GetRealNameByUsername",prams,out dataReader);
if(dataReader.Read())
{
return dataReader[0].ToString();
}
else
{
return "";
}
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员信息读取出错!",ex);
}
finally
{
dataReader.Close();
data.Dispose();
}
}
#endregion
#region 根据用户代号字符串返回用户真实姓名字符串
/// <summary>
/// 根据用户代号字符串返回用户真实姓名字符串
/// </summary>
/// <param name="Username">用户代号字符串</param>
/// <param name="Username">返回的个数</param>
/// <returns>返回真实姓名字符串</returns>
public static string GetRealNameStrByUsernameStr(string Username,int number)
{
string RealNameStr = "";
if(Username=="")
return "";
if(Username.EndsWith(","))
Username = Username.Substring(0,Username.Length-1);
string[] UnameAr = System.Text.RegularExpressions.Regex.Split(Username ,",");
if(number==0)
{
number=UnameAr.Length;
}
if(number>UnameAr.Length)
number = UnameAr.Length;
try
{
for(int k=0;k<number;k++)
{
RealNameStr+=GetRealNameByUsername(UnameAr[k].ToString())+",";
}
RealNameStr = RealNameStr.Substring(0,RealNameStr.Length-1);
if(number<UnameAr.Length)
{
RealNameStr+="..";
}
return RealNameStr;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("根据用户代号字符串返回用户真实姓名字符串出错!",ex);
}
}
#endregion
#region 得到所有在职人员
public SqlDataReader GetAllStaffs()
{
SqlDataReader dataReader = null;
Database data = new Database();
try
{
// run the stored procedure
data.RunProc("sp_GetAllStaff",out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员信息读取出错!",ex);
}
}
#endregion
#region 所有的岗位信息
public SqlDataReader GetAllPosition()
{
SqlDataReader dataReader = null;
Database data = new Database();
try
{
// run the stored procedure
data.RunProc("sp_GetAllPosition",out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("读取信息出错!",ex);
}
}
#endregion
#region 返回用户信息接口，包括用户名和用户中文名
/// <summary>
/// 返回用户信息接口，包括用户ID和用户中文名
/// </summary>
public ICollection GetStaffInTeam(int teamID)
{
// create data object and params
SqlDataReader dataReader = null;
Database data = new Database();
DataTable datatable = new DataTable ();
SqlParameter[] prams = {
data.MakeInParam("@ClassID", SqlDbType.Int, 8, teamID),
};
try
{
// run the stored procedure
data.RunProc("sp_GetMemberInClass", prams,out dataReader);
data = null;
datatable = Tools.ConvertDataReaderToDataTable (dataReader);
return datatable.DefaultView ;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 返回某部门用户信息接口，包括用户名和用户中文名
/// <summary>
/// 返回用户信息接口，包括用户ID和用户中文名
/// </summary>
public ICollection GetStaffInDetp(int PositionID)
{
// create data object and params
SqlDataReader dataReader = null;
Database data = new Database();
DataTable datatable = new DataTable ();
SqlParameter[] prams = {
data.MakeInParam("@Position_id", SqlDbType.Int, 8, PositionID),
};
try
{
// run the stored procedure
data.RunProc("sp_GetStaffInPosition", prams,out dataReader);
data = null;
datatable = Tools.ConvertDataReaderToDataTable (dataReader);
return datatable.DefaultView ;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 获取部门信息
/// <summary>
/// 获取部门信息
/// </summary>
/// <param name="RootPositionID">根部门ID</param>
/// <returns>返回DataReader</returns>
public SqlDataReader GetPositionList(int RootPositionID)
{
RootPositionID=1;
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@Position_id", SqlDbType.Int , 5, RootPositionID),
};
try
{
// run the stored procedure
data.RunProc("sp_GetAllChildPosition",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("读取信息出错!",ex);
}
}
#endregion
#region 返回某部门及下级部门用户信息接口，包括用户名和用户中文名
/// <summary>
/// 返回用户信息接口，包括用户ID和用户中文名
/// </summary>
public ICollection GetStaffByPosition(int PositionID)
{
// create data object and params
SqlDataReader dataReader = null;
Database data = new Database();
DataTable datatable = new DataTable ();
SqlParameter[] prams = {
data.MakeInParam("@PositionID", SqlDbType.Int, 8, PositionID),
};
try
{
// run the stored procedure
data.RunProc("sp_GetStaffByPosition", prams,out dataReader);
data = null;
datatable = Tools.ConvertDataReaderToDataTable (dataReader);
return datatable.DefaultView ;
}
catch
{
return null;
}
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -