public MessageSearchResult GetPageList(long?holderId, string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
CommonService <MessageEntity> cs = new CommonService <MessageEntity>(dbc);
MessageSearchResult result = new MessageSearchResult();
var entity = cs.GetAll();
if (holderId != null)
{
entity = entity.Where(m => m.HolderId == holderId);
}
if (!string.IsNullOrEmpty(mobile))
{
entity = entity.Where(m => m.Holder.Mobile.Contains(mobile));
}
if (!string.IsNullOrEmpty(name))
{
entity = entity.Where(m => m.Holder.Name.Contains(name));
}
if (startTime != null)
{
entity = entity.Where(m => m.CreateTime >= startTime);
}
if (endTime != null)
{
entity = entity.Where(m => m.CreateTime <= endTime);
}
result.TotalCount = entity.LongCount();
result.Messages = entity.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(result);
}
}
public PartialViewResult ListGetPage(long?holderId, string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
MessageListViewModel model = new MessageListViewModel();
MessageSearchResult result = messageService.GetPageList(holderId, name, mobile, startTime, endTime, pageIndex, pageSize);
model.Messages = result.Messages;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("MessageListPaging", model));
}
