public JsonResult List(int limit = 20, int page = 1, String type = "") { GridDataResult<WxUser> result = new GridDataResult<WxUser>(); try { result.items = BaseRepository<WxUser>.getInstance().List(page, limit); result.limit = limit; result.page = page; result.total = BaseRepository<WxUser>.getInstance().Count(); result.totalPage = result.total % limit == 0 ? result.total / limit : result.total / limit + 1; } catch (Exception ex) { Log.Error(ex); } return Json(result, JsonRequestBehavior.AllowGet); }
public async Task <GridDataResult <ProductViewModel> > GetProducts(int pageSize, int pageNum) { var gridData = new GridDataResult <ProductViewModel>(); gridData.total = await _salesDbContextReadOnly.Product.AsNoTracking().CountAsync(); gridData.data = await(from p in _salesDbContextReadOnly.Product .AsNoTracking() .Skip(pageNum) .Take(pageSize) join pu in _salesDbContextReadOnly.ProductUnit.AsNoTracking() on p.ProductUnitId equals pu.Id select new ProductViewModel() { Id = p.Id, Name = p.Name, Price = p.UnitPricing.Value, UnitName = pu.Name }).ToListAsync(); return(gridData); }
public JsonResult List(int limit = 20, int page = 1, String type = "") { GridDataResult<Manager> result = new GridDataResult<Manager>(); try { Role role = RoleRepository.getInstance().GetByName(type); result.items = ManagerRepository.getInstance().List(page, limit, role); result.limit = limit; result.page = page; result.total = ManagerRepository.getInstance().Count(role); result.totalPage = result.total % limit == 0 ? result.total / limit : result.total / limit + 1; } catch (Exception ex) { Log.Error(ex); } return Json(result, JsonRequestBehavior.AllowGet); }