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