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);
}
