public HolderSearchResult GetPageList(string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
CommonService <HolderEntity> cs = new CommonService <HolderEntity>(dbc);
HolderSearchResult result = new HolderSearchResult();
var holders = cs.GetAll();
if (!string.IsNullOrEmpty(name))
{
holders = holders.Where(h => h.Name.Contains(name));
}
if (!string.IsNullOrEmpty(mobile))
{
holders = holders.Where(h => h.Mobile.Contains(mobile));
}
if (startTime != null)
{
holders = holders.Where(h => h.CreateTime >= startTime);
}
if (endTime != null)
{
holders = holders.Where(h => h.CreateTime <= endTime);
}
result.TotalCount = holders.LongCount();
result.Holders = holders.OrderByDescending(h => h.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(h => ToDTO(h)).ToArray();
return(result);
}
}
public PartialViewResult ListGetPage(string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
HolderListViewModel model = new HolderListViewModel();
HolderSearchResult result = holderService.GetPageList(name, mobile, startTime, endTime, pageIndex, pageSize);
model.Holders = result.Holders;
//分页
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("HolderListPaging", model));
}
