/// <summary> /// 根据时间获取Pay的数据 /// </summary> /// <param name="BillDate"></param> /// <returns></returns> public async Task <List <DetailedList> > DetailedListInPayOrder(string[] BillDate) { var datas = new List <DetailedList>(); for (var i = 0; i < BillDate.Length; i++) { var PayModel = await _ipayTableServices.Query(obj => obj.orderDate == BillDate[i]); if (PayModel.Count == 0) { //查询时间数组中 那天的数据 空表示没有数据 进行时间数组中下一天的查询 myLogger.LogWarning($"{BillDate[i]} 无数据"); continue; } decimal returnMoney = 0; decimal moneys = 0; int count = 0; myLogger.LogDebug($"{BillDate[i]} 有数据"); foreach (var pay in PayModel) //查询时间数组中 那天的数据 如果有数据 { if ("YES".Equals(pay.isRefund)) { returnMoney += Convert.ToDecimal(pay.orderAmount); } moneys += Convert.ToDecimal(pay.orderAmount); //类型不相同需要强转 count++; } if (count == 0) { return(datas); } var dt = new DetailedList { Count = count, BillDate = BillDate[i], Money = Convert.ToDouble(moneys - returnMoney), DataName = "Pay" }; datas.Add(dt); } return(datas); }
public async Task <List <PayTable> > GetOneyDay(string Billdate) { return(await _IPayTableServices.Query(obj => obj.orderDate == Billdate)); }