public Tuple <List <ExpenseDto>, int> LoadData(RootCategoryEnum rootCategoryType, DateTime startTime, DateTime endTime, int page, int pageSize) { var rootCategory = Enum.GetName(typeof(RootCategoryEnum), rootCategoryType); var payers = _payerService.getData(); var query = (from expense in _unitOfWorfkMedia.Expenses join category in _unitOfWorfkMedia.Categories on expense.CategoryId equals category.Id join payer in _unitOfWorfkMedia.Payers on expense.Payer equals payer.Code where category.Type == rootCategory && (expense.PayTime >= startTime.Date && expense.PayTime <= endTime.Date) select new ExpenseDto { Id = expense.Id, CategoryId = category.Id, CategoryName = category.Name, Payer = payer.Code, PayerName = payer.Name, PayTime = expense.PayTime, Money = expense.Money, Description = expense.Description } ); var model = query //.Skip((page - 1) * pageSize) //.Take(pageSize) .ToList(); var total = query.Count(); return(new Tuple <List <ExpenseDto>, int>(model, total)); }
public JsonResult LoadData(RootCategoryEnum rootCategoryType, DateTime startTime, DateTime endTime, [DataSourceRequest] DataSourceRequest request) { var model = _expenseService.LoadData(rootCategoryType, startTime, endTime, request.Page, request.PageSize); var response = new DataResponeCommon <List <ExpenseDto> >() { Data = model.Item1, Total = model.Item2, Message = "OK", Statu = StatuCodeEnum.OK }; return(Json(response)); }