/// <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);
}
}
