/// <summary>
/// Get Card Authorizations By Employee Id.
/// </summary>
/// <param name="EmpId">Employee Id</param>
/// <returns>Card Authorizations</returns>
public List <CardAuthInfo> GetCardAuth(String EmpId, EnmWorkerType WorkType)
{
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50),
new SqlParameter("@EmpType", SqlDbType.Int) };
parms[0].Value = EmpId;
parms[1].Value = (Int32)WorkType;
var auths = new List <CardAuthInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CA_GetCardAuthByEmpId, parms)) {
while (rdr.Read())
{
var auth = new CardAuthInfo();
auth.CardSn = ComUtility.DBNullStringHandler(rdr["CardSn"]);
auth.RtuId = ComUtility.DBNullInt32Handler(rdr["RtuId"]);
auth.DevId = ComUtility.DBNullInt32Handler(rdr["DevId"]);
auth.LimitId = ComUtility.DBNullLimitIDHandler(rdr["LimitId"]);
auth.LimitIndex = ComUtility.DBNullInt32Handler(rdr["LimitIndex"]);
auth.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
auth.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
auth.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
auth.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
auth.Remark = String.Empty;
auth.CardSn = ComUtility.GetCardSn16to10(auth.CardSn);
auths.Add(auth);
}
}
return(auths);
}
/// <summary>
/// Class Constructor
/// </summary>
public BitchUpdateEndTimeForm(EnmWorkerType WorkerType, List <CardInfo> Cards)
{
InitializeComponent();
CardAuthEntity = new CardAuth();
CurWorkerType = WorkerType;
CurCards = Cards;
Devices = Common.CurUser.Role.Devices;
TotalRecords = new List <ValuesPair <DeviceInfo, CardAuthInfo, CardInfo, String, String> >();
Text = WorkerType == EnmWorkerType.WXRY ? String.Format("{0} - [外协人员]", Text) : String.Format("{0} - [正式员工]", Text);
}
/// <summary>
/// Class Constructor
/// </summary>
public BatchCancelCardAuthForm(EnmWorkerType WorkerType, List <CardInfo> Cards, List <NodeLevelInfo> Nodes, List <DepartmentInfo> Departments, List <OrgEmployeeInfo> OrgEmployees, List <OutEmployeeInfo> OutEmployees)
{
InitializeComponent();
CardAuthEntity = new CardAuth();
CurWorkerType = WorkerType;
CurCards = Cards;
CurNodes = Nodes;
CurDepartments = Departments;
CurOrgEmployees = OrgEmployees;
CurOutEmployees = OutEmployees;
}
/// <summary>
/// Get worker type text.
/// </summary>
/// <param name="workerType">worker Type</param>
/// <returns>worker type text</returns>
public static String GetWorkerTypeText(EnmWorkerType workerType)
{
switch (workerType)
{
case EnmWorkerType.WXRY:
return("外协人员");
case EnmWorkerType.ZSYG:
return("正式员工");
case EnmWorkerType.JZYG:
return("兼职员工");
case EnmWorkerType.WPYG:
return("外聘员工");
case EnmWorkerType.QT:
return("其他");
default:
return("未定义");
}
}
