/// <summary> /// 获取通知数据 /// </summary> /// <param name="name">发布人</param> /// <param name="title">标题</param> /// <param name="page">第几页</param> /// <param name="rows">行</param> /// <param name="total">总数</param> /// <param name="deptId">部门ID</param> /// <returns></returns> public List <RegulationsViewModel> GetAllRegulations(string name, string title, int page, int rows, out int total, int deptId) { if (page.Equals(0)) { total = 0; return(null); } using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Regulations.Where(s => s.DeptIdList.Contains(deptId.ToString()) && s.IsDelete == false); if (!string.IsNullOrWhiteSpace(name)) { data = data.Where(s => s.StaffName.Contains(name)); } if (!string.IsNullOrWhiteSpace(title)) { data = data.Where(s => s.Title.Contains(title)); } total = data.Count(); data = data.OrderByDescending(s => s.EstablishDate).Skip((page - 1) * rows).Take(rows); List <RegulationsViewModel> listV = new List <RegulationsViewModel>(); foreach (Regulations item in data.ToList()) { RegulationsViewModel r = new RegulationsViewModel(); r.Id = item.Id; r.StaffName = item.StaffName; r.Title = item.Title; r.RegulationsContent = item.RegulationsContent.Count() > 5 ? item.RegulationsContent.Substring(0, 5) + "......" : item.RegulationsContent; r.EstablishDate = item.EstablishDate.ToString("D"); listV.Add(r); } return(listV); } }
/// <summary> /// 根据通知编号获取通知对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public RegulationsViewModel GetRegulationsById(int id) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Regulations.Where(s => s.Id == id); RegulationsViewModel r = new RegulationsViewModel(); foreach (var item in data) { r.Title = item.Title; r.RegulationsContent = item.RegulationsContent; r.StaffName = item.StaffName; r.EstablishDate = item.EstablishDate.ToString("F"); } return(r); } }