/// <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); }