/// <summary> /// 根据条件,获取考勤异常扣款明细信息 /// </summary> /// <param name="strOwnerID">登录用户的员工ID(权限控制)</param> /// <param name="strDeductMasterID">外键索引</param> /// <param name="strSortKey">排序字段</param> /// <returns></returns> public IQueryable <T_HR_ATTENDANCEDEDUCTDETAIL> GetAllAttendanceDeductDetailRdListByMultSearch(string strOwnerID, string strDeductMasterID, string strSortKey) { AttendanceDeductDetailDAL dalAttendanceDeductDetail = new AttendanceDeductDetailDAL(); StringBuilder strfilter = new StringBuilder(); List <object> objArgs = new List <object>(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strDeductMasterID)) { strfilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0"); objArgs.Add(strDeductMasterID); } if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " DEDUCTDETAILID "; } string filterString = strfilter.ToString(); //SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDANCEDEDUCTDETAIL"); var q = dalAttendanceDeductDetail.GetAttendanceDeductDetailRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray()); return(q); }
public string DeleteDeductDetailByMasterID(string strAttendanceDeductMasterId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strAttendanceDeductMasterId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0"); objArgs.Add(strAttendanceDeductMasterId); AttendanceDeductDetailDAL dalDeductDetail = new AttendanceDeductDetailDAL(); flag = dalDeductDetail.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } string strOrderBy = " DEDUCTMASTERID "; var q = dalDeductDetail.GetAttendanceDeductDetailRdListByMultSearch(strOrderBy, strFilter.ToString(), objArgs.ToArray()); if (q == null) { return(strMsg); } if (q.Count() == 0) { return(strMsg); } foreach (T_HR_ATTENDANCEDEDUCTDETAIL item in q) { dalDeductDetail.Delete(item); } strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }