public ActionResult Index(string allOrUnread = "unread", int?page = null)
{
ViewBag.allOrUnread = allOrUnread;
MessageRecordSearchModel q = new MessageRecordSearchModel();
int pageIndex = PagingHelper.GetPageIndex(page);
IMessageRecordService mrs = new MessageRecordService(Settings.Default.db);
IPagedList <MessageRecordView> records = mrs
.GetByCateAndAllOrUnread(MessageRecordCatetory.Alert, (allOrUnread == "all" ? true : false))
.ToPagedList <MessageRecordView>(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
return(View(records));
}
public ActionResult Search([Bind(Include = "StaffNr,StaffNrAct")] MessageRecordSearchModel q)
{
string allOrUnread = Request.QueryString["allOrUnread"];
ViewBag.allOrUnread = allOrUnread;
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
IMessageRecordService mrs = new MessageRecordService(Settings.Default.db);
IPagedList <MessageRecordView> records = mrs
.GetByCateAndAllOrUnread(MessageRecordCatetory.Alert, (allOrUnread == "all" ? true : false), q)
.ToPagedList <MessageRecordView>(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
return(View("Index", records));
}
/// <summary>
/// 根据类型和是否阅读获取列表
/// Category condition not implement yet!
/// </summary>
/// <param name="catetory"></param>
/// <param name="all"></param>
/// <returns></returns>
public IQueryable <MessageRecordView> GetByCateAndAllOrUnread(MessageRecordCatetory catetory, bool all, MessageRecordSearchModel searchModel = null)
{
DataContext dc = new DataContext(this.DbString);
IQueryable <MessageRecordView> q = dc.Context.GetTable <MessageRecordView>();
// q = q.Where(s => s.messageCategory==(int)catetory);
if (!all)
{
q = q.Where(s => s.isRead == false);
}
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.StaffNr))
{
q = q.Where(s => s.staffNr.Contains(searchModel.StaffNr));
}
if (!string.IsNullOrEmpty(searchModel.StaffNrAct))
{
q = q.Where(s => s.staffNr.Equals(searchModel.StaffNrAct));
}
}
return(q.OrderByDescending(s => s.createdAt));
}
