/// <summary> /// 根据发放名、发放内容获取福利发放信息 /// </summary> /// <param name="WelfareProvisionName">福利发放名</param> /// <param name="strContent">发放内容</param> /// <returns></returns> public List <V_WelfareProvision> GetWelfareProvisionRoomInfosListBySearch(string WelfareProvisionName, string strContent) { try { WelfareProvision wp = new WelfareProvision(); var q = from p in dal.GetTable().ToList() select new V_WelfareProvision { welfareProvision = p }; if (!string.IsNullOrEmpty(WelfareProvisionName)) { q = q.Where(s => WelfareProvisionName.Contains(s.welfareProvision.WELFAREDISTRIBUTETITLE)); } if (!string.IsNullOrEmpty(strContent)) { q = q.Where(s => s.welfareProvision.CONTENT.Contains(strContent)); } if (q.Count() > 0) { return(q.ToList()); } return(null); } catch (Exception ex) { Tracer.Debug("福利标准WelfareProvisionBLL-GetWelfareProvisionRoomInfosListBySearch" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(null); } }
/// <summary> /// 根据发放ID获取福利发放信息 /// </summary> /// <param name="WelfareID">申请ID</param> /// <returns>返回结果</returns> public T_OA_WELFAREDISTRIBUTEMASTER GetWelfareProvisionById(string WelfareProvisionID) { WelfareProvision wp = new WelfareProvision(); var ents = from a in dal.GetObjects() where a.WELFAREDISTRIBUTEMASTERID == WelfareProvisionID select a; return(ents.Count() > 0 ? ents.FirstOrDefault() : null); }
/// <summary> /// 获取所有的福利发放信息 /// </summary> /// <returns>返回结果</returns> public IQueryable <T_OA_WELFAREDISTRIBUTEMASTER> GetWelfareProvisionStandard() { WelfareProvision wp = new WelfareProvision(); var entity = from p in wp.GetTable() orderby p.CREATEDATE descending select p; return(entity.Count() > 0 ? entity : null); }
/// <summary> /// 获取福利发放信息 /// </summary> /// <returns></returns> public List <T_OA_WELFAREDISTRIBUTEMASTER> GetWelfareRooms() { WelfareProvision wp = new WelfareProvision(); var query = from p in wp.GetTable() orderby p.CREATEDATE descending select p; return(query.ToList <T_OA_WELFAREDISTRIBUTEMASTER>()); }
public List <string> GetWelfareProvisionRoomNameInfos() { WelfareProvision wp = new WelfareProvision(); var query = from p in wp.GetTable() orderby p.CREATEDATE descending select p.WELFAREDISTRIBUTETITLE; return(query.ToList <string>()); }
/// <summary> /// 获取用户福利发放的申请记录 /// </summary> /// <param name="userID">用户ID</param> /// <param name="searchObj"></param> /// <param name="flowInfoList"></param> /// <param name="checkState">状态</param> /// <returns></returns> public List <V_WelfareProvision> GetWelfareProvisionInfo(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, List <V_FlowAPP> flowInfoList, string checkState, string userID) { try { WelfareProvision wp = new WelfareProvision(); var ents = from p in dal.GetObjects() select new V_WelfareProvision { welfareProvision = p, OWNERCOMPANYID = p.OWNERCOMPANYID, OWNERID = p.OWNERID, OWNERPOSTID = p.OWNERPOSTID, OWNERDEPARTMENTID = p.OWNERDEPARTMENTID, CREATEUSERID = p.CREATEUSERID }; if (ents.Count() > 0) { if (flowInfoList != null) { ents = (from a in ents.ToList().AsQueryable() join l in flowInfoList on a.welfareProvision.WELFAREDISTRIBUTEMASTERID equals l.FormID select new V_WelfareProvision { welfareProvision = a.welfareProvision, OWNERCOMPANYID = a.OWNERCOMPANYID, OWNERID = a.OWNERID, OWNERPOSTID = a.OWNERPOSTID, OWNERDEPARTMENTID = a.OWNERDEPARTMENTID, CREATEUSERID = a.CREATEUSERID }); } if (!string.IsNullOrEmpty(checkState)) { ents = ents.Where(s => checkState == s.welfareProvision.CHECKSTATE); } List <object> queryParas = new List <object>(); queryParas.AddRange(paras); UtilityClass.SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_OA_WELFAREDISTRIBUTEMASTER"); if (!string.IsNullOrEmpty(filterString)) { ents = ents.ToList().AsQueryable().Where(filterString, queryParas.ToArray()); } ents = ents.AsQueryable().OrderBy(sort); ents = Utility.Pager <V_WelfareProvision>(ents.AsQueryable(), pageIndex, pageSize, ref pageCount); return(ents.ToList()); } return(null); } catch (Exception ex) { return(null); } }
public IQueryable <V_WelfareProvision> GetWelfareProvisionInfoById(string lendingID) { WelfareProvision wp = new WelfareProvision(); var ents = from a in dal.GetObjects() join b in dal.GetObjects <T_OA_WELFAREMASERT>() on a.WELFAREDISTRIBUTEMASTERID equals b.WELFAREID where b.WELFAREID == lendingID select new V_WelfareProvision { welfareProvision = a }; if (ents.Count() > 0) { return(ents); } return(null); }