public ActionResult RemitList() { RemitListModel model = new RemitListModel(); RemitPageResult rpModel = new RemitPageResult(); //查询数据 rpModel = remitService.GetPageList(0, "", "", -1, null, null, 1, PageSize); model.remitList = rpModel.Remits; //分页 Pagination pager = new Pagination(); pager.PageIndex = 1; pager.PageSize = PageSize; pager.TotalCount = rpModel.TotalCount; if (rpModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(View(model)); }
public ActionResult RemitList(string usercode, string truename, DateTime?start, DateTime?end, int state = -1, int pageIndex = 1) { RemitListModel model = new RemitListModel(); RemitPageResult rpModel = new RemitPageResult(); //查询数据 rpModel = remitService.GetPageList(0, usercode, truename, state, start, end, pageIndex, PageSize); model.remitList = rpModel.Remits; //分页 Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = PageSize; pager.TotalCount = rpModel.TotalCount; if (rpModel.TotalCount <= PageSize) { model.Page = ""; } else { model.Page = pager.GetPagerHtml(); } return(Json(new AjaxResult { Status = "1", Data = model })); }
/// <summary> /// 分页查询 /// </summary> /// <param name="UserID"></param> /// <param name="StartTime"></param> /// <param name="EndTime"></param> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <returns></returns> public RemitPageResult GetPageList(long UserID, string UserCode, string TrueName, int State, DateTime?StartTime, DateTime?EndTime, int PageIndex, int PageSize) { using (MyDbContext dbcontext = new MyDbContext()) { CommonService <RemitEntity> csr = new CommonService <RemitEntity>(dbcontext); RemitPageResult PageResult = new RemitPageResult(); var RemitQuery = csr.GetAll(); if (UserID > 0) { RemitQuery = RemitQuery.Where(p => p.UserID == UserID); } if (!string.IsNullOrEmpty(UserCode)) { RemitQuery = RemitQuery.Where(p => p.Users.UserCode.Contains(UserCode)); } if (!string.IsNullOrEmpty(TrueName)) { RemitQuery = RemitQuery.Where(p => p.Users.TrueName.Contains(TrueName)); } if (State > -1) { RemitQuery = RemitQuery.Where(p => p.State == State); } if (StartTime != null) { RemitQuery = RemitQuery.Where(p => p.AddDate >= StartTime); } if (EndTime != null) { RemitQuery = RemitQuery.Where(p => p.AddDate <= EndTime); } PageResult.TotalCount = RemitQuery.LongCount(); PageResult.Remits = RemitQuery.OrderByDescending(p => p.CreateTime).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray(); return(PageResult); } }