public IEnumerable<CompanyNoticeViewModel> GetCompanyNoticeList(int MemberID, CompanyNoticeStatus CompanyNoticeStatus, bool inCludeUpLevel = false) { var NoticeStatus = (int)CompanyNoticeStatus; var company = DB_Service.Set<Company>() .Include(x => x.CompanyNotice).Where(x => x.MemberID == MemberID).First(); var query = company.CompanyNotice.AsQueryable(); if (inCludeUpLevel) { query = query.Where(x => x.Status >= NoticeStatus); } else { query = query.Where(x => x.Status == NoticeStatus); } return query.Select(x => new CompanyNoticeViewModel() { ID = x.ID, AddTime = x.AddTime, Content = x.Content, Name = x.Title, Status = x.Status }); }
public ServiceResult ChangeCompanyNoticeStatus(string Ids, CompanyNoticeStatus CompanyNoticeStatus) { ServiceResult result = new ServiceResult(); try { var IdsArray = Ids.Split(',').Select(x => Convert.ToInt32(x)); var StatusValue = (int)CompanyNoticeStatus; DB_Service.Set<CompanyNotice>().Where(x => IdsArray.Contains(x.ID)).ToList().ForEach(x => x.Status = StatusValue); DB_Service.Commit(); } catch (DbEntityValidationException ex) { result.AddServiceError(Utilities.GetInnerMostException(ex)); } return result; }