/// <summary>
/// 根据条件，获取员工异常记录信息
/// </summary>
/// <param name="strOwnerID">权限控制，当前记录所有者的员工序号</param>
/// <param name="strEmployeeID">异常记录对应关联的员工序号</param>
/// <param name="strSignInID">签卡ID(参数为空，则取未签卡的异常；不为空，则取对应已签卡的异常)</param>
/// <param name="strCurDateMonth">当前日期(年-月)</param>
/// <param name="strSortKey">排序字段</param>
/// <returns></returns>
public IQueryable <T_HR_EMPLOYEESIGNINDETAIL> GetAllEmployeeSignInDetailRdListByMultSearch(string strOwnerID, string strEmployeeID, string strSignInID,
string strCurDateMonth, string strSortKey)
{
EmployeeSignInDetailDAL dalEmployeeSignInDetail = new EmployeeSignInDetailDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
int iIndex = 0;
if (!string.IsNullOrEmpty(strEmployeeID))
{
strfilter.Append(" T_HR_EMPLOYEESIGNINRECORD.EMPLOYEEID == @0");
objArgs.Add(strEmployeeID);
}
if (!string.IsNullOrEmpty(strSignInID))
{
if (!string.IsNullOrEmpty(strfilter.ToString()))
{
strfilter.Append(" AND ");
}
if (objArgs.Count() > 0)
{
iIndex = objArgs.Count();
}
strfilter.Append(" T_HR_EMPLOYEESIGNINRECORD.SIGNINID == @" + iIndex.ToString());
objArgs.Add(strSignInID);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " ABNORMALDATE ";
}
string filterString = strfilter.ToString();
SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_EMPLOYEESIGNINDETAIL");
var q = dalEmployeeSignInDetail.GetEmployeeSignInDetailRdListByMultSearch(strOrderBy, strCurDateMonth, filterString, objArgs.ToArray());
return(q);
}
/// <summary>
/// 新增员工异常记录信息
/// </summary>
/// <param name="entTemp"></param>
/// <returns></returns>
public string AddEmployeeSignInDetail(T_HR_EMPLOYEESIGNINDETAIL entTemp)
{
string strMsg = string.Empty;
try
{
if (entTemp == null)
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" T_HR_EMPLOYEESIGNINRECORD.SIGNINID == @0");
strFilter.Append(" && T_HR_EMPLOYEEABNORMRECORD.ABNORMRECORDID == @1");
objArgs.Add(entTemp.T_HR_EMPLOYEESIGNINRECORD.SIGNINID);
objArgs.Add(entTemp.T_HR_EMPLOYEEABNORMRECORD.ABNORMRECORDID);
string strCurDate = entTemp.ABNORMALDATE.Value.ToShortDateString();
EmployeeSignInDetailDAL dalEmployeeSignInDetail = new EmployeeSignInDetailDAL();
flag = dalEmployeeSignInDetail.IsExistsRd(strCurDate, strFilter.ToString(), objArgs.ToArray());
if (flag)
{
return("{ALREADYEXISTSRECORD}");
}
dalEmployeeSignInDetail.Add(entTemp);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 修改员工异常记录信息
/// </summary>
/// <param name="entTemp"></param>
/// <returns></returns>
public string ModifyEmployeeSignInDetail(T_HR_EMPLOYEESIGNINDETAIL entTemp)
{
string strMsg = string.Empty;
try
{
if (entTemp == null)
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" SIGNINDETAILID == @0");
objArgs.Add(entTemp.SIGNINDETAILID);
EmployeeSignInDetailDAL dalEmployeeSignInDetail = new EmployeeSignInDetailDAL();
flag = dalEmployeeSignInDetail.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
T_HR_EMPLOYEESIGNINDETAIL entUpdate = dalEmployeeSignInDetail.GetEmployeeSignInDetailRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
Utility.CloneEntity(entTemp, entUpdate);
dalEmployeeSignInDetail.Update(entUpdate);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 根据主键索引，删除员工考勤异常信息(注：暂定为物理删除)
/// </summary>
/// <param name="strVacationId">主键索引</param>
/// <returns></returns>
public string RemoveEmployeeSignInDetail(string strSignInDetailId)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strSignInDetailId))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" SIGNINDETAILID == @0");
objArgs.Add(strSignInDetailId);
EmployeeSignInDetailDAL dalEmployeeSignInDetail = new EmployeeSignInDetailDAL();
flag = dalEmployeeSignInDetail.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
T_HR_EMPLOYEESIGNINDETAIL entDel = dalEmployeeSignInDetail.GetEmployeeSignInDetailRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
dalEmployeeSignInDetail.Delete(entDel);
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
