public PartialViewResult ReadListGetPage(long id, string name, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
int pageSize = 3;
ReadListViewModel model = new ReadListViewModel();
ReadSearchResult result = readNumberService.GetPageList(id, name, startTime, endTime, pageIndex, pageSize);
model.ReadNumbers = result.ReadNumbers;
//分页
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("ReadListPaging", model));
}
public ReadSearchResult GetPageList(long id, string name, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
CommonService <ReadNumberEntity> cs = new CommonService <ReadNumberEntity>(dbc);
ReadSearchResult result = new ReadSearchResult();
var entities = cs.GetAll().Where(r => r.NewsId == id);
if (!string.IsNullOrEmpty(name))
{
entities = entities.Where(r => r.Holder.Name == name);
}
if (startTime != null)
{
entities = entities.Where(r => r.CreateTime >= startTime);
}
if (endTime != null)
{
entities = entities.Where(r => r.CreateTime <= endTime);
}
result.TotalCount = entities.LongCount();
result.ReadNumbers = entities.OrderBy(r => r.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(r => ToDTO(r)).ToArray();
return(result);
}
}
