| | |
| | | info.TotalSettlementAmount = await _distributionOrderRepository.GetSumAsync( |
| | | p => p.isSettlement != (int)GlobalEnumVars.DistributionOrderSettlementStatus.SettlementCancel && p.userId == userId, |
| | | p => p.amount); |
| | | var lisdata = await _unitOfWork.GetDbClient().Queryable<CoreCmsDistributionOrder>().Where(x=>x.userId == userId&&x.isSettlement== (int)GlobalEnumVars.DistributionOrderSettlementStatus.SettlementNo) |
| | | .Select(x=>new CoreCmsDistributionOrder |
| | | { |
| | | amount = x.amount, |
| | | OderState= SqlFunc.Subqueryable<CoreCmsOrder>().Where(c=>c.orderId==x.orderId).Select(c=>c.confirmStatus), |
| | | |
| | | }).WithCache(10).ToListAsync(); |
| | | //可领金额 |
| | | info.DistributionKeLingTotals = lisdata.Where(x=>x.OderState== (int)GlobalEnumVars.OrderConfirmStatus.ConfirmReceipt |
| | | || x.OderState == (int)GlobalEnumVars.OrderShipStatus.Yes).Sum(x=>x.amount); |
| | | |
| | | //应领金额 |
| | | info.DistributionYingLingTotals = lisdata.Where(x => x.OderState == (int)GlobalEnumVars.OrderConfirmStatus.ReceiptNotConfirmed |
| | | || x.OderState == (int)GlobalEnumVars.OrderShipStatus.Yes).Sum(x => x.amount); ; |
| | | //已结算金额 |
| | | info.SettlementAmount = await _distributionOrderRepository.GetSumAsync( |
| | | p => p.isSettlement == (int)GlobalEnumVars.DistributionOrderSettlementStatus.SettlementYes && p.userId == userId, |