/// <summary>
/// 获取员工异常记录信息
/// </summary>
/// <param name="strOwnerID">权限控制，当前记录所有者的员工序号</param>
/// <param name="strEmployeeID">异常记录对应关联的员工序号</param>
/// <param name="strSignInState">签卡状态(参数为"1"，则取未签卡的异常；参数为"2"，则取对应已签卡的异常)</param>
/// <param name="strCurDateMonth">当前日期(年-月)</param>
/// <param name="strSortKey">排序字段</param>
/// <returns>员工异常记录信息</returns>
public IQueryable <T_HR_EMPLOYEEABNORMRECORD> GetAllAbnormRecordRdListByMultSearch(string strOwnerID, string strEmployeeID, string strSignInState,
string strCurStartDate, string strCurEndDate, string strSortKey)
{
AbnormRecordDAL dalAbnormRecord = new AbnormRecordDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strEmployeeID))
{
strfilter.Append(" T_HR_ATTENDANCERECORD.EMPLOYEEID == @0");
objArgs.Add(strEmployeeID);
}
if (!string.IsNullOrEmpty(strSignInState))
{
if (!string.IsNullOrEmpty(strfilter.ToString()))
{
strfilter.Append(" AND");
}
strfilter.Append(" (SINGINSTATE == @" + objArgs.Count().ToString());
objArgs.Add("1");
strfilter.Append(" OR ");
strfilter.Append(" SINGINSTATE == @" + objArgs.Count().ToString() + ")");
objArgs.Add("3");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " ABNORMALDATE ";
}
string filterString = strfilter.ToString();
SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_EMPLOYEEABNORMRECORD");
var q = dalAbnormRecord.GetAbnormRecordRdListByMultSearch(strOrderBy, strCurStartDate, strCurEndDate, filterString, objArgs.ToArray());
return(q);
}
/// <summary>
/// 修改员工考勤异常信息
/// </summary>
/// <param name="entLTRd"></param>
/// <returns></returns>
public string ModifyAbnormRecord(T_HR_EMPLOYEEABNORMRECORD 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(" ABNORMRECORDID == @0");
objArgs.Add(entTemp.ABNORMRECORDID);
AbnormRecordDAL dalAbnormRecord = new AbnormRecordDAL();
flag = dalAbnormRecord.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
T_HR_EMPLOYEEABNORMRECORD entUpdate = dalAbnormRecord.GetAbnormRecordRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
Utility.CloneEntity(entTemp, entUpdate);
dalAbnormRecord.Update(entUpdate);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 获取员工考勤异常信息
/// </summary>
/// <param name="strAbnormRecordId">主键索引</param>
/// <returns></returns>
public T_HR_EMPLOYEEABNORMRECORD GetAbnormRecordByID(string strAbnormRecordId)
{
if (string.IsNullOrEmpty(strAbnormRecordId))
{
return(null);
}
AbnormRecordDAL dalAbnormRecord = new AbnormRecordDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strAbnormRecordId))
{
strfilter.Append(" ABNORMRECORDID == @0");
objArgs.Add(strAbnormRecordId);
}
T_HR_EMPLOYEEABNORMRECORD entRd = dalAbnormRecord.GetAbnormRecordRdByMultSearch(strfilter.ToString(), objArgs.ToArray());
return(entRd);
}
/// <summary>
/// 根据主键索引，删除员工考勤异常信息(注：暂定为物理删除)
/// </summary>
/// <param name="strVacationId">主键索引</param>
/// <returns></returns>
public string RemoveAbnormRecord(string strAbnormRecordId)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strAbnormRecordId))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" ABNORMRECORDID == @0");
objArgs.Add(strAbnormRecordId);
AbnormRecordDAL dalAbnormRecord = new AbnormRecordDAL();
flag = dalAbnormRecord.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
T_HR_EMPLOYEEABNORMRECORD entDel = dalAbnormRecord.GetAbnormRecordRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
dalAbnormRecord.Delete(entDel);
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
