public EntityObject[] GetLookupData(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID)
{
FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
string strOrderBy = string.Empty;
strOrderBy = "FREELEAVEDAYSETID";
IQueryable <T_HR_FREELEAVEDAYSET> ents = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs);
return(ents.Count() > 0 ? ents.ToArray() : null);
}
/// <summary>
/// 根据条件，获取带薪假设置信息
/// </summary>
/// <param name="strOwnerID">权限控制所有人的员工序号</param>
/// <param name="strLeaveTypeSetID">考勤方案外键索引</param>
/// <param name="strIsFactor">是否扣全勤</param>
/// <param name="strSortKey">排序字段</param>
/// <returns></returns>
public IQueryable <T_HR_FREELEAVEDAYSET> GetAllFreeLeaveDaySetRdListByMultSearch(string strOwnerID, string strLeaveTypeSetID, string strIsFactor, string strSortKey)
{
FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
int iIndex = 0;
if (!string.IsNullOrEmpty(strLeaveTypeSetID))
{
strfilter.Append(" T_HR_LEAVETYPESET.LEAVETYPESETID == @0");
objArgs.Add(strLeaveTypeSetID);
}
if (!string.IsNullOrEmpty(strIsFactor))
{
if (!string.IsNullOrEmpty(strfilter.ToString()))
{
strfilter.Append(" AND");
}
if (objArgs.Count() > 0)
{
iIndex = objArgs.Count();
}
strfilter.Append(" ISPERFECTATTENDANCEFACTOR == @" + iIndex.ToString());
objArgs.Add(strIsFactor);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " FREELEAVEDAYSETID ";
}
string filterString = strfilter.ToString();
//T_HR_LEAVETYPESET
//SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_FREELEAVEDAYSET");
//注释原因，使用的是T_HR_FREELEAVEDAYSET，T_HR_FREELEAVEDAYSET没有权限设置
SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_LEAVETYPESET");
var q = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray());
return(q);
}
