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