生活缴费api
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zhengyuxuan
2025-03-25 2eed7efc24e7e784e2e215bbfd395e258a178985 
 LifePayment/LifePayment.Application/LifePay/LifePayService.cs


@@ -26,6 +26,7 @@


using Volo.Abp.Domain.Entities;


using Volo.Abp.ObjectMapping;


using NPOI.SS.Formula.Functions;


using StackExchange.Redis;




namespace LifePayment.Application;




@@ -60,7 +61,6 @@


                          IRepository<LifePayUser, Guid> lifePayUserRepository,


                          IRepository<LifePayPremium, Guid> lifePayPremiumRepository,


                          IRepository<LifePayIntroInfo, Guid> lifePayIntroInfoRepository,


                          IRepository<DallyStatistics, Guid> dallyStatisticsRepository,


                          IRepository<OperateHistory, Guid> operateHistory,


                          IAliPayApi aliPayApi,


                          IAlipayInterfaceManager aliPayInterfaceManager,


@@ -78,7 +78,6 @@


        _lifePayUserRepository = lifePayUserRepository;


        _lifePayPremiumRepository = lifePayPremiumRepository;


        _lifePayIntroInfoRepository = lifePayIntroInfoRepository;


        _dallyStatisticsRepository = dallyStatisticsRepository;


        _aliPayApi = aliPayApi;


        _alipayInterfaceManager = aliPayInterfaceManager;


        _wxPayApi = wxPayApi;


@@ -93,43 +92,6 @@




    #region 查询




    public async Task<TopStatisticsOutput> GetTopStatistics()


    {


        var today = DateTime.Now.Date;


        var statistics = await _dallyStatisticsRepository.Where(x => x.CreationTime.Date == today).FirstOrDefaultAsync();


        if (statistics == null)


        {


            var accumulatedReceipts = await _lifePayOrderRepository.Where(x => x.CreationTime < today).SumAsync(x => x.PayAmount);


            var receiptsYesterday = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today).SumAsync(x => x.PayAmount);


            var accumulatedOrders = await _lifePayOrderRepository.Where(x => x.CreationTime < today).CountAsync();


            var ordersNumYesterday = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today).CountAsync();


            var yesterdaySuccess = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.已完成).CountAsync();


            var yesterdayFail = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.已失败).CountAsync();


            var accumulatedUsers = await _lifePayUserRepository.CountAsync();




            var entity = new DallyStatistics()


            {


                Id = GuidGenerator.Create(),


                CreationTime = DateTime.Now,


                Amount = "0",


                AccumulatedReceipts = accumulatedReceipts.ToString(),


                ReceiptsYesterday = receiptsYesterday.ToString(),


                AccumulatedOrders = accumulatedOrders.ToString(),


                OrdersNumYesterday = ordersNumYesterday.ToString(),


                YesterdaySuccess = yesterdaySuccess.ToString(),


                YesterdayFail = yesterdayFail.ToString(),


                AccumulatedUsers = accumulatedUsers.ToString(),


            };


            await _dallyStatisticsRepository.InsertAsync(entity);


            var result = ObjectMapper.Map<DallyStatistics, TopStatisticsOutput>(entity);


            return result;


        }


        else


        {


            var result = ObjectMapper.Map<DallyStatistics, TopStatisticsOutput>(statistics);


            return result;


        }


    }




    /// <summary>


    /// 获取电费面值


@@ -187,6 +149,16 @@


    {


        return await _lifePayRateRepository.Where(x => x.IsDeleted == false).Select(x => new LifePayRateListOutput() { Id = x.Id, Rate = x.Rate, RateType = x.RateType })


                                           .ToListAsync();


    }




    /// <summary>


    /// 获取渠道折扣


    /// </summary>


    /// <returns></returns>


    public async Task<ChannelRateOutput> GetChannelRate(ChannelsBaseInput input)


    {


        return  _lifePayChannlesRep.Where(x => x.IsDeleted == false && x.ChannlesNum == input.CheckChannelId).Select(x => new ChannelRateOutput() { ChannlesRate = x.ChannlesRate })


                                           .FirstOrDefault();


    }




    /// <summary>


@@ -272,6 +244,7 @@


    /// <returns></returns>


    public async Task<PageOutput<LifePayOrderListOutput>> GetLifePayOrderPage(QueryLifePayOrderListInput input)


    {


        var channles = await _lifePayChannlesRep.Where(x => x.ChannlesName.Contains(input.KeyWords)).Select(x => x.ChannlesNum).ToListAsync();


        var result = await (from a in _channelFilter.GetChannelLifePayOrderFilter(_lifePayOrderRepository)


                      .WhereIf(input.BeginFinishTime.HasValue, x => x.FinishTime >= input.BeginFinishTime)


                                            .WhereIf(input.EndFinishTime.HasValue, x => x.FinishTime <= input.EndFinishTime)


@@ -283,7 +256,7 @@


                                            .WhereIf(input.ACOOLYStatus.HasValue, x => x.ACOOLYStatus == input.ACOOLYStatus.Value)


                                            .WhereIf(input.LifePayOrderType.HasValue, x => x.LifePayOrderType == input.LifePayOrderType.Value)


                                            .WhereIf(input.UserId.HasValue, x => x.UserId == input.UserId.Value)


                                            .WhereIf(input.KeyWords.IsNotNullOrEmpty(), x => x.PhoneNumber.Contains(input.KeyWords) || x.OrderNo.Contains(input.KeyWords) || x.OutOrderNo.Contains(input.KeyWords) || x.ACOOLYOrderNo.Contains(input.KeyWords))


                                            .WhereIf(input.KeyWords.IsNotNullOrEmpty(), x => x.OrderNo.Contains(input.KeyWords) || x.OutOrderNo.Contains(input.KeyWords) || x.ACOOLYOrderNo.Contains(input.KeyWords) || channles.Contains(x.ChannelId))


                            join b in _lifePayChannlesRep on a.ChannelId equals b.ChannlesNum into temp


                            from b in temp.DefaultIfEmpty()


                            select new LifePayOrderListOutput


@@ -304,12 +277,13 @@


                                PayTime = a.PayTime,


                                ACOOLYOrderNo = a.ACOOLYOrderNo,


                                RefundCredentialsImgUrl = a.RefundCredentialsImgUrl.GetOssPath(),


                                RefundPrice = a.RefundPrice,


                                CreationTime = a.CreationTime,


                                RefundCheckRemark = a.RefundCheckRemark,


                                RefundApplyRemark = a.RefundApplyRemark,


                                RefundTime = a.RefundTime,


                                ChannelName = b.ChannlesName,


                                ActualRechargeAmount = a.ActualRechargeAmount,


                                ActualRechargeAmount = a.RechargeAmount,


                                PlatformDeductionAmount = a.PlatformDeductionAmount,


                                ACOOLYStatus = a.ACOOLYStatus,


                                LifePayRefundStatus = a.LifePayRefundStatus,


@@ -318,19 +292,23 @@


        return result;


    }




    /// <summary>


    /// 退款订单分页


    /// </summary>


    /// <param name="input"></param>


    /// <returns></returns>


    public async Task<PageOutput<LifePayOrderListOutput>> GetLifePayRefundOrderPage(QueryLifePayRefundOrderListInput input)


    {




        var result = await (from a in _channelFilter.GetChannelLifePayOrderFilter(_lifePayOrderRepository)


        .Where(x => x.PayStatus == LifePayStatusEnum.待退款 || x.PayStatus == LifePayStatusEnum.已退款 || x.PayStatus == LifePayStatusEnum.退款中


        || x.LifePayOrderStatus == LifePayOrderStatusEnum.退款待审核 || x.LifePayOrderStatus == LifePayOrderStatusEnum.已退款 || x.LifePayOrderStatus == LifePayOrderStatusEnum.退款失败


        || x.LifePayRefundStatus > LifePayRefundStatusEnum.无需退款)


                                            .WhereIf(input.BeginFinishTime.HasValue, x => x.FinishTime >= input.BeginFinishTime)


                                            .WhereIf(input.EndFinishTime.HasValue, x => x.FinishTime <= input.EndFinishTime)


        .Where(x => x.LifePayOrderStatus == LifePayOrderStatusEnum.待退款 || x.LifePayOrderStatus == LifePayOrderStatusEnum.已退款 || x.LifePayOrderStatus == LifePayOrderStatusEnum.退款中


        || (x.LifePayRefundStatus > LifePayRefundStatusEnum.无需退款 && x.LifePayRefundStatus != LifePayRefundStatusEnum.退款驳回))


                                            .WhereIf(input.BeginRefundTime.HasValue, x => x.RefundTime >= input.BeginRefundTime)


                                            .WhereIf(input.EndRefundTime.HasValue, x => x.RefundTime <= input.EndRefundTime)


                                            .WhereIf(input.BeginRefundApplyTime.HasValue, x => x.RefundApplyTime >= input.BeginRefundApplyTime)


                                            .WhereIf(input.LifePayType.HasValue, x => x.LifePayType == input.LifePayType)


                                            .WhereIf(input.EndRefundApplyTime.HasValue, x => x.RefundApplyTime <= input.EndRefundApplyTime)


                                            .WhereIf(input.LifePayOrderStatus.HasValue, x => x.LifePayOrderStatus == input.LifePayOrderStatus.Value)


                                            .WhereIf(input.LifePayRefundStatus.HasValue, x => x.LifePayRefundStatus == input.LifePayRefundStatus.Value)


                                            .WhereIf(input.ACOOLYStatus.HasValue, x => x.ACOOLYStatus == input.ACOOLYStatus.Value)


                                            .WhereIf(input.LifePayOrderType.HasValue, x => x.LifePayOrderType == input.LifePayOrderType.Value)


                                            .WhereIf(input.UserId.HasValue, x => x.UserId == input.UserId.Value)


@@ -360,8 +338,9 @@


                                RefundApplyRemark = a.RefundApplyRemark,


                                RefundApplyTime = a.RefundApplyTime,


                                RefundTime = a.RefundTime,


                                RefundPrice = a.RefundPrice,


                                ChannelName = b.ChannlesName,


                                ActualRechargeAmount = a.ActualRechargeAmount,


                                ActualRechargeAmount = a.RechargeAmount,


                                PlatformDeductionAmount = a.PlatformDeductionAmount,


                                ACOOLYStatus = a.ACOOLYStatus,


                                LifePayRefundStatus = a.LifePayRefundStatus,


@@ -370,16 +349,60 @@


        return result;


    }




    /// <summary>


    /// 退款订单分页


    /// </summary>


    /// <param name="input"></param>


    /// <returns></returns>


    public async Task<List<LifePayRefundOrderListTemplate>> GetLifePayRefudOrderPageExport(QueryLifePayRefundOrderListInput input)


    {


        var result = await (await GetLifePayRefundOrderListFilter(input)).Select(x => new LifePayRefundOrderListTemplate


        {


            FinishTime = x.RefundTime,


            RefundPrice = x.RefundPrice,


            LifePayOrderType = x.LifePayOrderType,


            LifePayType = x.LifePayType,


            PayAmount = x.PayAmount,


            PhoneNumber = x.PhoneNumber,


            RefundOrderNo = x.RefundOrderNo,


            RefundApplyTime = x.RefundApplyTime,


            ChannelName = x.ChannelName,


            CreationTime = x.CreationTime,


            ACOOLYStatus = x.ACOOLYStatus,


            RefundApplyRemark = x.RefundApplyRemark,


            RechargeAmount = x.RechargeAmount,


            ActualReceivedAmount = x.ActualReceivedAmount.ToString("F2"),


            LifePayRefundStatus = x.LifePayRefundStatus,




        }).OrderByDescending(r => r.CreationTime).ToListAsync();


        var i = 0;


        result.ForEach(s =>


        {


            s.SerialNumber = ++i;


            s.ACOOLYStatusStr = s.ACOOLYStatus.GetDescription();


            s.LifePayOrderTypeStr = s.LifePayOrderType.GetDescription();


            s.RechargeAmountStr = s.RechargeAmount.ToString("F2");


            s.ActualReceivedAmount = s.ActualReceivedAmount;


            s.LifePayRefundStatusStr = s.LifePayRefundStatus.GetDescription();


            s.PayAmountStr = s.PayAmount.ToString("F2");


            s.LifePayTypeStr = s.LifePayType.GetDescription();


            s.FinishTimeStr = !s.FinishTime.HasValue ? string.Empty : s.FinishTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmm);


            s.RefundApplyTimeStr = !s.RefundApplyTime.HasValue? string.Empty:s.RefundApplyTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmm);


        });


        return result;


    }






    public async Task<LifePayOrderOutput> GetLifePayOrderDetail(string orderNo)


    {


        var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();


        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.供应商折扣价);


        var channle = await _lifePayChannlesRep.FirstOrDefaultAsync(r => r.ChannlesNum == order.ChannelId);


        var premium = await _lifePayPremiumRepository.Where(x => x.IsDeleted == false && x.PremiumType == order.LifePayType).FirstOrDefaultAsync();


        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");


         CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");


        var user = await _lifePayUserRepository.FirstOrDefaultAsync(x => x.Id == order.UserId);


        


        var channlesRakePrice = (order.PayAmount - (order.PlatformDeductionAmount == null ? 0 : order.PlatformDeductionAmount)) * channle.ChannlesRakeRate / 100;


        var orderpirce = await GetOrderPrice(order.RechargeAmount, order.PayAmount,order.PlatformRate, order.ChannleRate, order.ChannlesRakeRate,order.PremiumRate);






        var result = new LifePayOrderOutput()


                {


            UserName = user.Name,


@@ -405,17 +428,18 @@


            RefundTime = order.RefundTime,


            ACOOLYOrderNo = order.ACOOLYOrderNo,


            LifePayRefundStatus = order.LifePayRefundStatus,


            ActualRechargeAmount = order.ActualRechargeAmount,


            ActualRechargeAmount = order.RechargeAmount,


            RefundPrice = order.RefundPrice,


            PlatformRate = platformRate.Rate,


            PlatformRate = order.PlatformRate,


            PlatformPrice = order.PlatformDeductionAmount,


            ElecBillUrl = order.ElecBillUrl.GetOssPath(),


            ChannleRate = channle.ChannlesRate,


            ChannlesRakeRate = channle.ChannlesRakeRate,


            ChannlesRakePrice = channlesRakePrice.HasValue ? 0 : Math.Round(channlesRakePrice.Value, 2),


            PremiumRate = premium == null ? 0 : premium.Rate,


            PremiumPrice = premium == null ? 0 : Math.Round(order.PayAmount * premium.Rate, 2),


            Profit = (order.PayAmount - order.PlatformDeductionAmount) * (1.00m - channle.ChannlesRakeRate / 100) - (premium == null ? 0 : Math.Round(order.PayAmount * premium.Rate, 2))


            RefundElecBillUrl = order.RefundElecBillUrl.GetOssPath(),


            ChannleRate = order.ChannleRate,


            ChannlesRakeRate = order.ChannlesRakeRate,


            ChannlesRakePrice = orderpirce.ChannlesRakePrice,


            PremiumRate = order.PremiumRate,


            PremiumPrice = orderpirce.PremiumPrice,


            Profit = orderpirce.Profit


        };




        return result;


@@ -458,8 +482,10 @@


            ACOOLYOrderNo = order.ACOOLYOrderNo,


            LifePayRefundStatus = order.LifePayRefundStatus,


            ActualRechargeAmount = order.ActualRechargeAmount,


            ActualReceivedAmount = order.ActualReceivedAmount,


            RefundPrice = order.RefundPrice,


            ElecBillUrl = order.ElecBillUrl.GetOssPath(),


            RefundElecBillUrl = order.RefundElecBillUrl.GetOssPath(),


        };




        return result;


@@ -505,8 +531,11 @@


                                                        CreationTime = x.CreationTime,


                                                        RefundCheckRemark = x.RefundCheckRemark,


                                                        RefundApplyRemark = x.RefundApplyRemark,


                                                        RefundApplyTime = x.RefundApplyTime,


                                                        RefundTime = x.RefundTime,


                                                        ACOOLYOrderNo = x.ACOOLYOrderNo,


                                                        LifePayRefundStatus = x.LifePayRefundStatus,


                                                        ACOOLYStatus = x.ACOOLYStatus,


                                                    })


                                            .GetPageResult(input.PageModel);


    }


@@ -697,11 +726,12 @@


        {


            DiscountAmount = x.DiscountAmount,


            FinishTime = x.FinishTime,


            LifePayOrderStatus = x.LifePayOrderStatus,


            //LifePayOrderStatus = x.LifePayOrderStatus,


            LifePayOrderType = x.LifePayOrderType,


            LifePayType = x.LifePayType,


            OrderNo = x.OrderNo,


            PayAmount = x.PayAmount,


            ActualRechargeAmount = x.ActualRechargeAmount.HasValue?x.ActualRechargeAmount.Value:0,


            PhoneNumber = x.PhoneNumber,


            RechargeAmount = x.RechargeAmount,


            OutOrderNo = x.OutOrderNo,


@@ -709,22 +739,28 @@


            PayTime = x.PayTime,


            ACOOLYOrderNo = x.ACOOLYOrderNo,


            CreationTime = x.CreationTime,


            RefundApplyRemark = x.RefundApplyRemark,


            ChannelName = x.ChannelName


            LifePayRefundStatus = x.LifePayRefundStatus,


            ACOOLYStatus = x.ACOOLYStatus,


            //RefundApplyRemark = x.RefundApplyRemark,


            ChannelName = x.ChannelName,


            PlatformPrice = x.PlatformDeductionAmount.HasValue ? x.PlatformDeductionAmount.Value : 0.00m


        }).OrderByDescending(r => r.CreationTime).ToListAsync();


        var i = 0;


        result.ForEach(s =>


        {


            s.SerialNumber = ++i;


            s.LifePayOrderTypeStr = s.LifePayOrderType.GetDescription();


            s.CreationTimeStr = s.CreationTime.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmm);


            s.CreationTimeStr = s.CreationTime.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmmss);


            s.RechargeAmountStr = s.RechargeAmount.ToString("F2");


            s.PayAmountStr = s.PayAmount.ToString("F2");


            s.PayTimeStr = !s.PayTime.HasValue ? string.Empty : s.PayTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmm);


            s.PayTimeStr = !s.PayTime.HasValue ? string.Empty : s.PayTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmmss);


            s.LifePayTypeStr = s.LifePayType.GetDescription();


            s.PayStatusStr = s.PayStatus.GetDescription();


            s.LifePayOrderStatusStr = s.LifePayOrderStatus.GetDescription();


            s.FinishTimeStr = !s.FinishTime.HasValue ? string.Empty : s.FinishTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmm);


            s.ActualRechargeAmountStr = s.ActualRechargeAmount.ToString("F2");


            s.LifePayRefundStatusStr = s.LifePayRefundStatus.GetDescription();


            s.ACOOLYStatusStr = s.ACOOLYStatus.GetDescription();


            //s.LifePayOrderStatusStr = s.LifePayOrderStatus.GetDescription();


            s.FinishTimeStr = !s.FinishTime.HasValue ? string.Empty : s.FinishTime.Value.ToString(LifePaymentConstant.DateTimeFormatStr.yyyyMMddHHmmss);


        });


        return result;


    }


@@ -799,12 +835,17 @@


        var rate = await GetRate();


        CheckExtensions.IfTrueThrowUserFriendlyException(rate.IsNullOrEmpty(), "未配置折扣");




        //var rate = await GetLifePayRate();




        var amount = CalculateAmount(input.ProductData.ParValue, rate.FirstOrDefault(x => x.RateType == LifePayRateTypeEnum.默认话费折扣).Rate);




        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.供应商折扣价);


        




        var orderInput = new CreateLifePayOrderInput


        {


            OrderNo = channle.ChannlesNum + CreateOrderNo(),


            LifePayOrderStatus = LifePayOrderStatusEnum.待确认,


            LifePayOrderStatus = LifePayOrderStatusEnum.充值中,


            LifePayOrderType = LifePayOrderTypeEnum.话费订单,


            //LifePayType = input.LifePayType,


            OrderParamDetailJsonStr = JsonConvert.SerializeObject(input.ProductData),


@@ -814,7 +855,12 @@


            PayAmount = amount.PayAmont,


            DiscountAmount = amount.DiscountAmount,


            RechargeAmount = amount.RechargeAmount,


            ChannelId = channle.ChannlesNum


            ChannelId = channle.ChannlesNum,


            PlatformRate = platformRate.Rate,


            PlatformDeductionAmount = amount.RechargeAmount * platformRate.Rate /100,


            ChannleRate = channle.ChannlesRate,


            ChannlesRakeRate = channle.ChannlesRakeRate,


            //ChannlesRakePrice = amount.RechargeAmount * (channle.ChannlesRate - platformRate.Rate) / 100 * channle.ChannlesRakeRate / 100


        };




        await CreateLifePayOrder(orderInput);


@@ -845,10 +891,12 @@




        var amount = CalculateAmount(input.ProductData.ParValue, rate.FirstOrDefault(x => x.RateType == LifePayRateTypeEnum.默认电费折扣).Rate);




        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.供应商折扣价);




        var orderInput = new CreateLifePayOrderInput


        {


            OrderNo = channle.ChannlesNum + CreateOrderNo(),


            LifePayOrderStatus = LifePayOrderStatusEnum.待确认,


            LifePayOrderStatus = LifePayOrderStatusEnum.充值中,


            LifePayOrderType = LifePayOrderTypeEnum.电费订单,


            // LifePayType = input.LifePayType,


            OrderParamDetailJsonStr = JsonConvert.SerializeObject(input.ProductData),


@@ -858,7 +906,10 @@


            PayAmount = amount.PayAmont,


            DiscountAmount = amount.DiscountAmount,


            RechargeAmount = amount.RechargeAmount,


            ChannelId = channle.ChannlesNum


            ChannelId = channle.ChannlesNum,


            PlatformRate = platformRate.Rate,


            ChannleRate = channle.ChannlesRate,


            ChannlesRakeRate = channle.ChannlesRakeRate,


        };




        await CreateLifePayOrder(orderInput);


@@ -889,10 +940,12 @@




        var amount = CalculateAmount(input.ProductData.ParValue, rate.FirstOrDefault(x => x.RateType == LifePayRateTypeEnum.默认燃气折扣).Rate);




        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.供应商折扣价);




        var orderInput = new CreateLifePayOrderInput


        {


            OrderNo = channle.ChannlesNum + CreateOrderNo(),


            LifePayOrderStatus = LifePayOrderStatusEnum.待确认,


            LifePayOrderStatus = LifePayOrderStatusEnum.充值中,


            LifePayOrderType = LifePayOrderTypeEnum.燃气订单,


            // LifePayType = input.LifePayType,


            OrderParamDetailJsonStr = JsonConvert.SerializeObject(input.ProductData),


@@ -927,7 +980,8 @@


        CheckExtensions.IfTrueThrowUserFriendlyException(order.LifePayType.HasValue, "当前订单已选择支付类型");




        order.LifePayType = input.LifePayType;




        var premium = await _lifePayPremiumRepository.Where(x => x.IsDeleted == false && x.PremiumType == order.LifePayType).FirstOrDefaultAsync();


        order.PremiumRate = premium == null ? 0 : premium.Rate;


        await _lifePayOrderRepository.UpdateAsync(order);




        var desc = "生活缴费-";


@@ -938,6 +992,9 @@


                break;


            case LifePayOrderTypeEnum.电费订单:


                desc += "电费";


                break;


            case LifePayOrderTypeEnum.燃气订单:


                desc += "燃气";


                break;


            default:


                break;


@@ -1201,7 +1258,7 @@


            }




            order.LifePayRefundStatus = LifePayRefundStatusEnum.无需退款;


            order.LifePayOrderStatus = LifePayOrderStatusEnum.待确认;


            order.LifePayOrderStatus = LifePayOrderStatusEnum.充值中;


            //SetOrderStatus(order, result.Code);


            order.OutRequestNo = result.RequestNo.IsNullOrEmpty() ? null : result.RequestNo;


            order.ACOOLYOrderNo = result.ACOOLYOrderNo.IsNullOrEmpty() ? null : result.ACOOLYOrderNo;


@@ -1209,11 +1266,29 @@


        catch (Exception ex)


        {


            _logger.LogError(ex, "处理生活缴费支付成功回调时异常");


            order.LifePayOrderStatus = LifePayOrderStatusEnum.已失败;


            order.LifePayOrderStatus = LifePayOrderStatusEnum.待退款;


            order.LifePayRefundStatus = LifePayRefundStatusEnum.待退款;


        }


        _logger.LogError("生活缴费订单状态：" + order.LifePayOrderStatus.ToString());


        await _lifePayOrderRepository.UpdateAsync(order);


    }




    public async Task WxPayDomesticRefundsHandler(string orderNo, LifePayRefundStatusEnum refundStatus)


    {


        var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();


        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");


        order.LifePayRefundStatus = refundStatus;


        switch (refundStatus)


        {


            case LifePayRefundStatusEnum.已退款:


                order.LifePayOrderStatus = LifePayOrderStatusEnum.已退款;


                order.ACOOLYStatus = ACOOLYStatusEnum.已退款;


                break;


            case LifePayRefundStatusEnum.退款中:


                order.LifePayOrderStatus = LifePayOrderStatusEnum.退款中;


                break;


            default:break;


        }


    }




    /// <summary>


@@ -1222,35 +1297,35 @@


    /// <param name="orderNo"></param>


    /// <param name="outOrderNo"></param>


    /// <returns></returns>


    public async Task ACOOLYOrderNotifyHandler(string orderNo, string acoolyOrderNo, LifePayOrderStatusEnum status, ACOOLYStatusEnum acoolyStatus, decimal payAmount)


    public async Task ACOOLYOrderNotifyHandler(string orderNo, string acoolyOrderNo, LifePayOrderStatusEnum status, ACOOLYStatusEnum acoolyStatus, decimal payAmount,string refundApplyRemark)


    {


        var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();


        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");




        if (order.LifePayOrderStatus == LifePayOrderStatusEnum.已完成)


        {


            return;


        }


        //if (order.LifePayOrderStatus == LifePayOrderStatusEnum.已完成)


        //{


        //    return;


        //}




        order.LifePayOrderStatus = status;


        order.ACOOLYStatus = acoolyStatus;


        order.PlatformDeductionAmount = payAmount;


        if (acoolyOrderNo.IsNotNullOrEmpty())


        {


            order.ACOOLYOrderNo = acoolyOrderNo;


        }




        if (order.LifePayOrderStatus == LifePayOrderStatusEnum.已完成)


        if (status == LifePayOrderStatusEnum.待退款)


        {


            order.FinishTime = DateTime.Now;


            order.LifePayRefundStatus = LifePayRefundStatusEnum.待退款;


        }




        if (order.LifePayOrderStatus == LifePayOrderStatusEnum.已失败 && order.PayStatus != LifePayStatusEnum.已退款)


        if (refundApplyRemark.IsNotNullOrEmpty())


        {


            order.PayStatus = LifePayStatusEnum.待退款;


            order.RefundApplyRemark = refundApplyRemark;


        }






        order.LifePayOrderStatus = status;


        order.ACOOLYStatus = acoolyStatus;


        order.FinishTime = DateTime.Now;


        await _lifePayOrderRepository.UpdateAsync(order);


    }




@@ -1265,12 +1340,22 @@


        var order = await _lifePayOrderRepository.FirstOrDefaultAsync(x => x.Id == input.Id);


        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");




        if (order.PayStatus == LifePayStatusEnum.已退款)


        if (order.LifePayRefundStatus == LifePayRefundStatusEnum.已退款)


        {


            return;


        }




        if (order.LifePayOrderStatus != LifePayOrderStatusEnum.已失败 && order.PayStatus != LifePayStatusEnum.待退款 && order.LifePayOrderStatus != LifePayOrderStatusEnum.退款待审核)


        if (input.RefundPrice > order.PayAmount)


        {


            throw new UserFriendlyException("退款的金额不能大于实付金额");


        }




        if (input.LifePayRefundType == LifePayRefundTypeEnum.全额退款)


        {


            input.RefundPrice = order.PayAmount;


        }




        if (order.LifePayOrderStatus != LifePayOrderStatusEnum.待退款 || order.PayStatus != LifePayStatusEnum.已支付 || order.LifePayRefundStatus != LifePayRefundStatusEnum.待退款)


        {


            throw new UserFriendlyException("当前订单状态无法退款");


        }


@@ -1280,36 +1365,38 @@


        switch (order.LifePayType)


        {


            case LifePayTypeEnum.WxPay:


                var wxRefundResult = await WxPayDomesticRefunds(order.OrderNo, outRefundNo,order.RefundApplyRemark, Convert.ToInt32(order.PayAmount * 100), Convert.ToInt32(order.PayAmount * 100));


                var wxRefundResult = await WxPayDomesticRefunds(order.OrderNo, outRefundNo,order.RefundApplyRemark, Convert.ToInt32(input.RefundPrice * 100), Convert.ToInt32(order.PayAmount * 100));


                if (wxRefundResult.Status == "SUCCESS")


                {


                    order.PayStatus = LifePayStatusEnum.已退款;


                    order.LifePayOrderStatus = LifePayOrderStatusEnum.已退款;


                    order.LifePayRefundStatus = LifePayRefundStatusEnum.已退款;


                }


                else if (wxRefundResult.Status == "PROCESSING")


                {


                    order.PayStatus = LifePayStatusEnum.退款中;


                    order.LifePayOrderStatus = LifePayOrderStatusEnum.退款中;


                    order.LifePayRefundStatus = LifePayRefundStatusEnum.退款中;


                }


                else if (wxRefundResult.Message == "订单已全额退款")


                {


                    order.LifePayOrderStatus = LifePayOrderStatusEnum.已退款;


                    order.LifePayRefundStatus = LifePayRefundStatusEnum.已退款;


                }


                else


                {


                    order.PayStatus = LifePayStatusEnum.待退款;


                    order.LifePayOrderStatus = LifePayOrderStatusEnum.退款失败;


                    order.LifePayOrderStatus = LifePayOrderStatusEnum.待退款;


                    order.LifePayRefundStatus = LifePayRefundStatusEnum.待退款;


                }




                break;


            case LifePayTypeEnum.AliPay:


                var aliRefundResult = await AliTradeRefund(new AlipayTradeRefundRequest() { OutTradeNo = order.OrderNo, RefundAmount = order.PayAmount.ToString() });


                var aliRefundResult = await AliTradeRefund(new AlipayTradeRefundRequest() { OutTradeNo = order.OrderNo, RefundAmount = input.RefundPrice.ToString() });


                if (aliRefundResult.Code != AlipayResultCode.Success)


                {


                    throw new UserFriendlyException("退款失败");


                    throw new UserFriendlyException("退款失败:" + aliRefundResult.SubMsg);


                }




                order.PayStatus = LifePayStatusEnum.已退款;


                order.LifePayOrderStatus = LifePayOrderStatusEnum.已退款;


                order.LifePayRefundStatus = LifePayRefundStatusEnum.已退款;


                break;


            default: throw new UserFriendlyException("退款失败");


        }


@@ -1318,9 +1405,9 @@


        order.RefundCheckRemark = input.RefundCheckRemark;


        order.RefundTime = DateTime.Now;


        order.RefundCheckUserId = CurrentUser.Id;


        order.RefundPrice = order.PayAmount;


        order.RefundPrice = input.RefundPrice;




        await _lifePayOrderRepository.UpdateAsync(order);


        //await _lifePayOrderRepository.UpdateAsync(order);




        #region 记录日志




@@ -1345,22 +1432,30 @@


            throw new UserFriendlyException("非用户本人退款");


        }




        if (order.PayStatus == LifePayStatusEnum.已退款)


        if (order.LifePayRefundStatus == LifePayRefundStatusEnum.已退款)


        {


            return;


        }




        if (order.LifePayOrderStatus != LifePayOrderStatusEnum.待确认 && order.LifePayOrderStatus != LifePayOrderStatusEnum.已失败


            && order.PayStatus != LifePayStatusEnum.已支付)


        if (order.PayStatus == LifePayStatusEnum.已支付 && order.LifePayOrderStatus != LifePayOrderStatusEnum.已完成


            && order.LifePayOrderStatus != LifePayOrderStatusEnum.待退款 && order.LifePayOrderStatus != LifePayOrderStatusEnum.已退款)


        {


            order.LifePayOrderStatus = LifePayOrderStatusEnum.待退款;


            order.LifePayRefundStatus = LifePayRefundStatusEnum.待退款;


            order.RefundApplyRemark = input.RefundApplyRemark;


            order.RefundApplyTime = DateTime.Now;


            await _lifePayOrderRepository.UpdateAsync(order);


        }


        else if (order.LifePayOrderStatus == LifePayOrderStatusEnum.待退款 || order.LifePayRefundStatus == LifePayRefundStatusEnum.待退款 ||


            order.LifePayOrderStatus == LifePayOrderStatusEnum.退款中 || order.LifePayRefundStatus == LifePayRefundStatusEnum.退款中 ||


            order.LifePayOrderStatus == LifePayOrderStatusEnum.已退款 || order.LifePayRefundStatus == LifePayRefundStatusEnum.已退款)


        {


            throw new UserFriendlyException("当前订单无法重复申请退款");


        }


        else


        {


            throw new UserFriendlyException("当前订单状态无法申请退款");


        }




        order.LifePayOrderStatus = LifePayOrderStatusEnum.退款待审核;


        order.RefundApplyRemark = input.RefundApplyRemark;


        order.RefundApplyTime = DateTime.Now;




        await _lifePayOrderRepository.UpdateAsync(order);


    }




    /// <summary>


@@ -1378,7 +1473,7 @@


        {


            OutTradeNo = outTradeNo,


            OutRefundNo = outRefundNo,


            Reason = reason,


            //Reason = reason,


            Amount = new Model_WxPayDomesticRefunds_Amount


            {


                Refund = refund,


@@ -1442,7 +1537,7 @@


        if (input.LifePayType == LifePayOrderTypeEnum.话费订单)


        {


            var extraProperties = JsonConvert.DeserializeObject<Model_UserAccountExtraProperties>(input.ExtraProperties);


            if (!string.IsNullOrEmpty(extraProperties.Name))


            if (!string.IsNullOrEmpty(extraProperties.Name) && extraProperties.Phone == user.PhoneNumber)


            {


                user.Name = extraProperties.Name;


            }


@@ -1479,17 +1574,21 @@


        var order = await _lifePayOrderRepository.FirstOrDefaultAsync(x => x.Id == input.Id);


        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "订单不存在");




        if (order.PayStatus == LifePayStatusEnum.已退款)


        if (order.LifePayRefundStatus == LifePayRefundStatusEnum.已退款)


        {


            return;


        }




        if ((order.LifePayOrderStatus == LifePayOrderStatusEnum.已失败 && order.PayStatus == LifePayStatusEnum.待退款) ||


            order.LifePayOrderStatus == LifePayOrderStatusEnum.退款待审核 || order.LifePayOrderStatus == LifePayOrderStatusEnum.待确认)


        if (order.LifePayOrderStatus == LifePayOrderStatusEnum.待退款 || order.LifePayRefundStatus == LifePayRefundStatusEnum.待退款)


        {


            order.LifePayOrderStatus = LifePayOrderStatusEnum.退款失败;


            if (order.ACOOLYStatus == ACOOLYStatusEnum.已完成 || order.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || order.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功)


            {


                order.LifePayOrderStatus = LifePayOrderStatusEnum.已完成;


            }




            order.RefundCheckRemark = input.RefundCheckRemark;


            order.RefundCheckUserId = CurrentUser.Id;


            order.LifePayRefundStatus = LifePayRefundStatusEnum.退款驳回;




            await _lifePayOrderRepository.UpdateAsync(order);




@@ -1686,7 +1785,7 @@


                order.FinishTime = DateTime.Now;


                break;


            case ACOOLYConstant.Code.PROCESSING:


                order.LifePayOrderStatus = LifePayOrderStatusEnum.待确认;


                order.LifePayOrderStatus = LifePayOrderStatusEnum.充值中;


                break;


            default:


                break;


@@ -1875,45 +1974,105 @@




    private async Task<IQueryable<LifePayOrderListOutput>> GetLifePayOrderListFilter(QueryLifePayOrderListInput input)


    {


        var result = (from a in _lifePayOrderRepository.Where(x => x.PayStatus != LifePayStatusEnum.未支付)


                                            .WhereIf(input.BeginFinishTime.HasValue, x => x.FinishTime >= input.BeginFinishTime)


        var channles = await _lifePayChannlesRep.Where(x => x.ChannlesName.Contains(input.KeyWords)).Select(x => x.ChannlesNum).ToListAsync();


        var result = (from a in _channelFilter.GetChannelLifePayOrderFilter(_lifePayOrderRepository)


                      .WhereIf(input.BeginFinishTime.HasValue, x => x.FinishTime >= input.BeginFinishTime)


                                            .WhereIf(input.EndFinishTime.HasValue, x => x.FinishTime <= input.EndFinishTime)


                                            .WhereIf(input.BeginPayTime.HasValue, x => x.PayTime >= input.BeginPayTime)


                                            .WhereIf(input.LifePayType.HasValue, x => x.LifePayType == input.LifePayType)


                                            .WhereIf(input.EndPayTime.HasValue, x => x.PayTime <= input.EndPayTime)


                                            .WhereIf(input.LifePayOrderStatus.HasValue, x => x.LifePayOrderStatus == input.LifePayOrderStatus.Value)


                                            .WhereIf(input.PayStatus.HasValue, x => x.PayStatus == input.PayStatus.Value)


                                            .WhereIf(input.ACOOLYStatus.HasValue, x => x.ACOOLYStatus == input.ACOOLYStatus.Value)


                                            .WhereIf(input.LifePayOrderType.HasValue, x => x.LifePayOrderType == input.LifePayOrderType.Value)


                                            .WhereIf(input.UserId.HasValue, x => x.UserId == input.UserId.Value)


                                            .WhereIf(input.KeyWords.IsNotNullOrEmpty(), x => x.PhoneNumber.Contains(input.KeyWords) || x.OrderNo.Contains(input.KeyWords) || x.OutOrderNo.Contains(input.KeyWords) || x.ACOOLYOrderNo.Contains(input.KeyWords))


                      join b in _lifePayChannlesRep on a.ChannelId equals b.ChannlesNum into temp


                      from b in temp.DefaultIfEmpty()


                      select new LifePayOrderListOutput


                      {


                          DiscountAmount = a.DiscountAmount,


                          FinishTime = a.FinishTime,


                          Id = a.Id,


                          LifePayOrderStatus = a.LifePayOrderStatus,


                          LifePayOrderType = a.LifePayOrderType,


                          LifePayType = a.LifePayType,


                          OrderNo = a.OrderNo,


                          PayAmount = a.PayAmount,


                          PhoneNumber = a.PhoneNumber,


                          RechargeAmount = a.RechargeAmount,


                          UserId = a.UserId,


                          OutOrderNo = a.OutOrderNo,


                          PayStatus = a.PayStatus,


                          PayTime = a.PayTime,


                          ACOOLYOrderNo = a.ACOOLYOrderNo,


                          RefundCredentialsImgUrl = a.RefundCredentialsImgUrl.GetOssPath(),


                          CreationTime = a.CreationTime,


                          RefundCheckRemark = a.RefundCheckRemark,


                          RefundApplyRemark = a.RefundApplyRemark,


                          RefundTime = a.RefundTime,


                          ChannelName = b.ChannlesName


                      });


                                            .WhereIf(input.KeyWords.IsNotNullOrEmpty(), x => x.OrderNo.Contains(input.KeyWords) || x.OutOrderNo.Contains(input.KeyWords) || x.ACOOLYOrderNo.Contains(input.KeyWords) || channles.Contains(x.ChannelId))


                            join b in _lifePayChannlesRep on a.ChannelId equals b.ChannlesNum into temp


                            from b in temp.DefaultIfEmpty()


                            select new LifePayOrderListOutput


                            {


                                DiscountAmount = a.DiscountAmount,


                                FinishTime = a.FinishTime,


                                Id = a.Id,


                                LifePayOrderStatus = a.LifePayOrderStatus,


                                LifePayOrderType = a.LifePayOrderType,


                                LifePayType = a.LifePayType,


                                OrderNo = a.OrderNo,


                                PayAmount = a.PayAmount,


                                PhoneNumber = a.PhoneNumber,


                                RechargeAmount = a.RechargeAmount,


                                UserId = a.UserId,


                                OutOrderNo = a.OutOrderNo,


                                PayStatus = a.PayStatus,


                                PayTime = a.PayTime,


                                ACOOLYOrderNo = a.ACOOLYOrderNo,


                                RefundCredentialsImgUrl = a.RefundCredentialsImgUrl.GetOssPath(),


                                RefundPrice = a.RefundPrice,


                                CreationTime = a.CreationTime,


                                RefundCheckRemark = a.RefundCheckRemark,


                                RefundApplyRemark = a.RefundApplyRemark,


                                RefundTime = a.RefundTime,


                                ChannelName = b.ChannlesName,


                                ActualRechargeAmount = a.ActualRechargeAmount,


                                PlatformDeductionAmount = a.PlatformDeductionAmount,


                                ACOOLYStatus = a.ACOOLYStatus,


                                LifePayRefundStatus = a.LifePayRefundStatus,


                            });




        


        return result;


    }




    private async Task<IQueryable<LifePayOrderListOutput>> GetLifePayRefundOrderListFilter(QueryLifePayRefundOrderListInput input)


    {


        var result = (from a in _channelFilter.GetChannelLifePayOrderFilter(_lifePayOrderRepository)


     .Where(x => x.LifePayOrderStatus == LifePayOrderStatusEnum.待退款 || x.LifePayOrderStatus == LifePayOrderStatusEnum.已退款 || x.LifePayOrderStatus == LifePayOrderStatusEnum.退款中


     || (x.LifePayRefundStatus > LifePayRefundStatusEnum.无需退款 && x.LifePayRefundStatus != LifePayRefundStatusEnum.退款驳回))


                                         .WhereIf(input.BeginRefundTime.HasValue, x => x.RefundTime >= input.BeginRefundTime)


                                         .WhereIf(input.EndRefundTime.HasValue, x => x.RefundTime <= input.EndRefundTime)


                                         .WhereIf(input.BeginRefundApplyTime.HasValue, x => x.RefundApplyTime >= input.BeginRefundApplyTime)


                                         .WhereIf(input.LifePayType.HasValue, x => x.LifePayType == input.LifePayType)


                                         .WhereIf(input.EndRefundApplyTime.HasValue, x => x.RefundApplyTime <= input.EndRefundApplyTime)


                                         .WhereIf(input.LifePayOrderStatus.HasValue, x => x.LifePayOrderStatus == input.LifePayOrderStatus.Value)


                                         .WhereIf(input.ACOOLYStatus.HasValue, x => x.ACOOLYStatus == input.ACOOLYStatus.Value)


                                         .WhereIf(input.LifePayOrderType.HasValue, x => x.LifePayOrderType == input.LifePayOrderType.Value)


                                         .WhereIf(input.UserId.HasValue, x => x.UserId == input.UserId.Value)


                                         .WhereIf(input.KeyWords.IsNotNullOrEmpty(), x => x.PhoneNumber.Contains(input.KeyWords) || x.OrderNo.Contains(input.KeyWords) || x.OutOrderNo.Contains(input.KeyWords) || x.ACOOLYOrderNo.Contains(input.KeyWords))


                            join b in _lifePayChannlesRep on a.ChannelId equals b.ChannlesNum into temp


                            from b in temp.DefaultIfEmpty()


                            select new LifePayOrderListOutput


                            {


                                DiscountAmount = a.DiscountAmount,


                                FinishTime = a.FinishTime,


                                Id = a.Id,


                                LifePayOrderStatus = a.LifePayOrderStatus,


                                LifePayOrderType = a.LifePayOrderType,


                                LifePayType = a.LifePayType,


                                OrderNo = a.OrderNo,


                                PayAmount = a.PayAmount,


                                PhoneNumber = a.PhoneNumber,


                                RechargeAmount = a.RechargeAmount,


                                UserId = a.UserId,


                                OutOrderNo = a.OutOrderNo,


                                PayStatus = a.PayStatus,


                                PayTime = a.PayTime,


                                ACOOLYOrderNo = a.ACOOLYOrderNo,


                                RefundCredentialsImgUrl = a.RefundCredentialsImgUrl.GetOssPath(),


                                CreationTime = a.CreationTime,


                                RefundCheckRemark = a.RefundCheckRemark,


                                RefundApplyRemark = a.RefundApplyRemark,


                                RefundApplyTime = a.RefundApplyTime,


                                RefundTime = a.RefundTime,


                                RefundPrice = a.RefundPrice,


                                ChannelName = b.ChannlesName,


                                ActualRechargeAmount = a.ActualRechargeAmount,


                                PlatformDeductionAmount = a.PlatformDeductionAmount,


                                ACOOLYStatus = a.ACOOLYStatus,


                                LifePayRefundStatus = a.LifePayRefundStatus,


                                ActualReceivedAmount = a.ActualReceivedAmount.HasValue? a.ActualReceivedAmount.Value : 0


                            });


        return result;


    }


    private IQueryable<CreateEditPayChannelsInput> GetLifePayChannlesListFilter()


    {


        return _lifePayChannlesRep.Select(x =>


@@ -1930,5 +2089,50 @@


                    });


    }




    public async Task<OrderPriceReturn> GetOrderPrice(decimal price, decimal priceAmount, decimal? platformRate,decimal? channleRate,


        decimal? channlesRakeRate,decimal? premiumRate)


    {


        /// 毛利


        var grossProfit = price * (channleRate - platformRate) / 100;




        /// 平台扣款金额  充值面额 * 平台折扣比例


        var platformPrice = price * platformRate / 100;




        /// 手续费


        var premiumPrice = priceAmount * premiumRate / 100;




        /// 渠道佣金  （(充值面额 * 渠道折扣比例)-(充值面额 * 平台折扣比例)）* 佣金比例


        var channlesRakePrice = grossProfit * channlesRakeRate / 100;




        /// 利润


        var profit = grossProfit - channlesRakePrice - premiumPrice;




        return new OrderPriceReturn()


        {


            PlatformPrice = platformPrice.HasValue? platformPrice.Value :0,


            PremiumPrice = premiumPrice.HasValue ? premiumPrice.Value : 0,


            ChannlesRakePrice = channlesRakePrice.HasValue? channlesRakePrice.Value:0,


            Profit = profit.HasValue ? profit.Value : 0


        };


    }




    public async Task<decimal> GetLifePayRate(string channelId, LifePayRateTypeEnum lifePayRateType)


    {


        if (string.IsNullOrEmpty(channelId))


        {


            var rate = await GetRate();


            CheckExtensions.IfTrueThrowUserFriendlyException(rate.IsNullOrEmpty(), "未配置折扣");


            var result = rate.FirstOrDefault(x => x.RateType == lifePayRateType).Rate;


            return result;


        }


        else


        {


            var channel = await _lifePayChannlesRep.Where(x => x.ChannlesNum == channelId).FirstOrDefaultAsync();




            CheckExtensions.IfTrueThrowUserFriendlyException(channel == null, "未找到对应渠道");


            return channel.ChannlesRate;


        }


    }




    #endregion


}