📄 staff.cs
字号:
return true;
else
if (GetRightInTeam(classid, username, actid, inherit))
return true;
else
return false;
}
#endregion
#region 使人员复职
/// <summary>
/// 使人员复职
/// </summary>
/// <param name="staffids">人员id集合</param>
/// <returns>是否成功</returns>
public bool ReturnPosition(string staffids)
{
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams = {
db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,staffids)
};
return((db.RunProc("sp_StaffRehab",prams)==0)?true:false);
}
#endregion
#region 人员更新
/// <summary>
/// 人员更新
/// </summary>
/// <param name="StaffID">人员ID</param>
/// <returns>返回是否成功</returns>
public int UpdateInfo(long StaffID,string RealName,int Sex,string Birthday,string Password,string Email,string Phone,string Mobile,long PositionID,int Caste)
{
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams = {
db.MakeInParam("@StaffID",SqlDbType.Int,4,StaffID),
db.MakeInParam("@RealName",SqlDbType.VarChar,50,RealName),
db.MakeInParam("@Sex",SqlDbType.Bit ,1,Sex),
db.MakeInParam("@Birthday",SqlDbType.DateTime ,8,Birthday),
db.MakeInParam("@Password",SqlDbType.VarChar,255,Password),
db.MakeInParam("@Email",SqlDbType.VarChar,500,Email),
db.MakeInParam("@Phone",SqlDbType.VarChar,50,Phone),
db.MakeInParam("@Mobile",SqlDbType.VarChar,50,Mobile),
db.MakeInParam("@PositionID",SqlDbType.Int,4,PositionID),
db.MakeInParam("@Caste",SqlDbType.Int,4,Caste)
};
return db.RunProc("sp_UpdateStaffInfo",prams);
}
#endregion
#region 人员离职
/// <summary>
/// 人员离职
/// </summary>
/// <param name="StaffID">人员ID</param>
/// <returns>返回是否成功</returns>
public bool Dimission(string StaffIDS)
{
UDS.Components.Database db = new UDS.Components.Database();
if(StaffIDS.Length>0)
{
SqlParameter[] prams = {
db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,StaffIDS.ToString())
};
return db.RunProc("sp_StaffDimission",prams)==0?true:false;
}
else
return false;
}
#endregion
#region 人员复职
/// <summary>
/// 人员复职
/// </summary>
/// <param name="StaffID">人员ID</param>
/// <returns>返回是否成功</returns>
public bool Rehab(string StaffIDS)
{
UDS.Components.Database db = new UDS.Components.Database();
if(StaffIDS.Length >0)
{
SqlParameter[] prams = {
db.MakeInParam("@StaffIDS",SqlDbType.VarChar,300,StaffIDS.ToString())
};
return db.RunProc("sp_StaffRehab",prams)==0?true:false;
}
else
return false;
}
#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);
}
}
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>
/// 得到剩余的在岗人员
/// </summary>
/// <param name="staffids">原来人员,分割</param>
/// <returns></returns>
public SqlDataReader GetRemainStaff(string staffids)
{
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@staffids",SqlDbType.VarChar,300,staffids)
};
try
{
// run the stored procedure
data.RunProc("sp_GetRemainStaff", prams,out dataReader);
return(dataReader);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
finally
{
data = null;
}
}
#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 GetTotalStaffs()
{
SqlDataReader dataReader = null;
Database data = new Database();
try
{
// run the stored procedure
data.RunProc("sp_GetTotalStaff",out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员信息读取出错!",ex);
}
}
#endregion
#region 根据用户真实姓名得到id
public SqlDataReader GetStaffIDByRealName(string realname)
{
UDS.Components.Database db = new UDS.Components.Database();
SqlDataReader dr = null;
SqlParameter[] prams = {
db.MakeInParam("@realname",SqlDbType.VarChar,100,realname)
};
db.RunProc("sp_GetStaffIDByRealName",prams,out dr);
return(dr);
}
#endregion
#region 根据roleid得到staff
public SqlDataReader GetStaffsFromRole(int role)
{
SqlDataReader dataReader = null;
Database data = new Database();
try
{
// run the stored procedure
SqlParameter[] prams = {
data.MakeInParam("@RoleID",SqlDbType.Int,4,role)
};
data.RunProc("sp_GetStaffInRole",prams,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 = UDS.Components.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 = UDS.Components.Tools.ConvertDataReaderToDataTable (dataReader);
return datatable.DefaultView ;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#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 = UDS.Components.Tools.ConvertDataReaderToDataTable (dataReader);
return datatable.DefaultView ;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 人员查询
/// <summary>
/// 人员查询
/// </summary>
/// <param name="staffname">用户名或者真实姓名</param>
/// <param name="positionid">职位id</param>
/// <param name="mobile">手机号码</param>
/// <param name="email">email</param>
/// <param name="gender">性别</param>
/// <returns></returns>
public SqlDataReader Find(string staffname,int positionid,string mobile,string email,string gender,string searchbound)
{
Database db = new Database();
SqlDataReader dr;
try
{
// run the stored procedure
SqlParameter[] prams = {
db.MakeInParam("@Name",SqlDbType.VarChar,200,staffname),
db.MakeInParam("@Mobile",SqlDbType.VarChar,100,mobile),
db.MakeInParam("@Email",SqlDbType.VarChar,100,email),
db.MakeInParam("@Gender",SqlDbType.VarChar,100,gender),
db.MakeInParam("@PositionID",SqlDbType.Int,4,positionid),
db.MakeInParam("@SearchBound",SqlDbType.VarChar,50,searchbound),
};
db.RunProc("UDS_StaffSearch",prams,out dr);
return dr;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("人员查询出错!",ex);
}
}
#endregion
#region 设置用户是否需要硬件KEY验证
/// <summary>
/// 设置用户是否需要硬件KEY验证
/// </summary>
/// <param name="StaffID">人员ID</param>
/// <param name="IsNeedKey">是否需要登陆</param>
/// <returns>返回是否成功</returns>
public bool SetIsNeedKey(string StaffIDs,bool IsNeedKey)
{
UDS.Components.Database db = new UDS.Components.Database();
if(StaffIDs.Length >0)
{
SqlParameter[] prams = {
db.MakeInParam("@StaffIDs",SqlDbType.VarChar,1000,StaffIDs),
db.MakeInParam("@IsNeedKey",SqlDbType.Bit ,1,IsNeedKey)
};
return db.RunProc("sp_Staff_SetIsNeedKey",prams)==0?true:false;
}
else
return false;
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -