//private bool IsExistWelfareDetails(T_OA_WELFAREDETAIL DetailsWelfare)//检查子表 //{ // SMT_OA_EFModelContext context = new SMT_OA_EFModelContext(); // bool IsExist = false; // var ents = from a in context.T_OA_WELFAREDETAIL // where ((a.ISLEVEL == DetailsWelfare.ISLEVEL && a.POSTLEVELA == DetailsWelfare.POSTLEVELA && a.POSTLEVELB == DetailsWelfare.POSTLEVELB) || // (a.ISLEVEL == DetailsWelfare.ISLEVEL && a.POSTID == DetailsWelfare.POSTID)) // select a; // //var ents = from a in context.T_OA_WELFAREDETAIL // // where a.POSTID == DetailsWelfare.POSTID && a.POSTLEVELA == DetailsWelfare.POSTLEVELA && a.POSTLEVELB == DetailsWelfare.POSTLEVELB // // select a; // if (ents.Count() > 0) // { // IsExist = true; // } // return IsExist; //} #endregion #region 根据福利备注检查 public List <string> GetWelfareRoomNameInfos() { BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL(); var query = from p in bad.GetTable() orderby p.CREATEDATE descending select p.REMARK; return(query.ToList <string>()); }
/// <summary> /// 获取福利标准信息 /// </summary> /// <returns></returns> public List <T_OA_WELFAREMASERT> GetWelfareRooms() { BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL(); var query = from p in bad.GetTable() orderby p.CREATEDATE descending select p; return(query.ToList <T_OA_WELFAREMASERT>()); }
/// <summary> /// 获取所有的福利标准信息 /// </summary> /// <returns>返回结果</returns> public IQueryable <T_OA_WELFAREMASERT> GetWelfareStandard() { BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL(); var entity = from p in bad.GetTable() orderby p.CREATEDATE descending select p; return(entity.Count() > 0 ? entity : null); }