/// <summary>
/// 计算奖金
/// </summary>
/// <param name="dbc"></param>
/// <param name="order"></param>
/// <param name="user"></param>
public async Task <CalcAmountResult> CalcCount()
{
using (MyDbContext dbc = new MyDbContext())
{
CalcAmountResult res = new CalcAmountResult();
var users = dbc.GetAll <UserEntity>().AsNoTracking().Where(u => u.IsNull == false);
var takeCash = dbc.GetAll <TakeCashEntity>().AsNoTracking().Where(t => t.State.Name == "已结款");
res.TotalAmount = users.Any() ? await users.SumAsync(u => u.Amount) : 0;
res.TotalTakeCash = takeCash.Any() ? await takeCash.SumAsync(u => u.Amount) : 0;
res.TotalBuyAmount = users.Any() ? await users.SumAsync(u => u.BuyAmount) : 0;
return(res);
}
}
public async Task <ActionResult> List(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
await orderService.AutoConfirmAsync();
long journalTypeId = await idNameService.GetIdByNameAsync("佣金收入");
JournalSearchResult result = await journalService.GetModelListAsync(null, journalTypeId, keyword, startTime, endTime, pageIndex, pageSize);
CalcAmountResult res = await userService.CalcCount();
ListViewModel model = new ListViewModel();
model.Journals = result.Journals;
model.PageCount = result.PageCount;
model.TotalAmount = res.TotalAmount;
model.TotalTakeCash = res.TotalTakeCash;
model.TotalBuyAmount = res.TotalBuyAmount;
return(Json(new AjaxResult {
Status = 1, Data = model
}));
}
