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