/// <summary> /// 根据条件,获取考勤方案带薪假信息 /// </summary> /// <param name="strAttendanceSolutionID"></param> /// <param name="strFreeLeaveDaySetID"></param> /// <param name="strSortKey"></param> /// <returns></returns> public IQueryable <T_HR_ATTENDFREELEAVE> GetAllAttendFreeLeaveRdListByMultSearch(string strAttendanceSolutionID, string strFreeLeaveDaySetID, string strSortKey) { AttendFreeLeaveDAL dalAttendFreeLeave = new AttendFreeLeaveDAL(); StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); string strOrderBy = string.Empty; int iIndex = 0; if (!string.IsNullOrEmpty(strAttendanceSolutionID)) { strfilter.Append(" T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID = @0"); objArgs.Add(strAttendanceSolutionID); } if (!string.IsNullOrEmpty(strFreeLeaveDaySetID)) { if (!string.IsNullOrEmpty(strfilter.ToString())) { strfilter.Append(" &&"); } if (objArgs.Count() > 0) { iIndex = objArgs.Count(); } strfilter.Append(" T_HR_ATTENDANCESOLUTION.FREELEAVEDAYSETID == @" + iIndex.ToString()); objArgs.Add(strFreeLeaveDaySetID); } if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " ATTENDFREELEAVEID "; } var q = dalAttendFreeLeave.GetAttendFreeLeaveRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs.ToArray()); return(q); }
/// <summary> /// 根据条件,获取考勤方案带薪假信息 /// </summary> /// <param name="strAttendSolID"></param> /// <returns></returns> public IQueryable <T_HR_ATTENDFREELEAVE> GetAttendFreeLeaveByAttendSolID(string strAttendSolID) { if (string.IsNullOrEmpty(strAttendSolID)) { return(null); } AttendFreeLeaveDAL dalAttendFreeLeave = new AttendFreeLeaveDAL(); StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); if (!string.IsNullOrEmpty(strAttendSolID)) { strfilter.Append(" T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID == @0"); objArgs.Add(strAttendSolID); } string strOrderBy = " ATTENDFREELEAVEID "; var q = dalAttendFreeLeave.GetAttendFreeLeaveRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs.ToArray()); return(q); }