From 72e71a7a31b14f30f38a2a3acecb7311049c608a Mon Sep 17 00:00:00 2001 From: 移动系统liao <liaoxujun@qq.com> Date: 星期二, 24 九月 2024 14:55:25 +0800 Subject: [PATCH] 完成微信转账到零钱所有逻辑 --- cylsg/EzInitQ/Mapper.cs | 4 cylsg/cylsg.utility/StaticStringDef.cs | 24 cylsg/cylsg.Model/TransferOrder/WeChartTransferOrder.cs | 34 cylsg/cylsg.redis/IEzCoreNetRedisService.cs | 17 cylsg/cylsg.Web.Core/Startup.cs | 1 cylsg/EzInitQ/PayServiceMessageQ.cs | 119 ++++ cylsg/EzInitqMessageDef/InitQMessages.cs | 12 cylsg/EzJob/ClearWorkOnDay.cs | 29 + cylsg/cylsg.Web.Entry/application.log | 851 +++++++++++++++++++++++++++++++ cylsg/cylsg.Application/LogoInController.cs | 20 cylsg/cylsg.Web.Entry/appsettings.json | 10 cylsg/EzWechat/WecharPayServicecs.cs | 8 cylsg/EzWechat/EzWechat.csproj | 2 cylsg/EzWechat/IWecharPayServicecs.cs | 2 cylsg/EzJob/WeChatJob.cs | 76 + cylsg/cylsg.Application/Transfer/UserTransfer.cs | 326 +++++++++++ cylsg/cylsg.redis/EzCoreNetRedisService.cs | 54 + cylsg/EzJob/StartUpcs.cs | 3 18 files changed, 1,511 insertions(+), 81 deletions(-) diff --git a/cylsg/EzInitQ/Mapper.cs b/cylsg/EzInitQ/Mapper.cs index 51ef636..c49e11b 100644 --- a/cylsg/EzInitQ/Mapper.cs +++ b/cylsg/EzInitQ/Mapper.cs @@ -14,8 +14,8 @@ { public void Register(TypeAdapterConfig config) { - config.ForType<CreateTransferBatchRequest, WeChatTransferOrder>(); - + config.ForType<CreateTransferBatchRequest, WeChatTransferOrder>().Map(x=>x.TotalNum,x=>x.TotalNumber); + config.ForType<WeChatTransferOrder,CreateTransferBatchRequest>().Map(x => x.TotalNumber, x => x.TotalNum); } } } diff --git a/cylsg/EzInitQ/PayServiceMessageQ.cs b/cylsg/EzInitQ/PayServiceMessageQ.cs index a4224b7..1b98ba1 100644 --- a/cylsg/EzInitQ/PayServiceMessageQ.cs +++ b/cylsg/EzInitQ/PayServiceMessageQ.cs @@ -8,6 +8,7 @@ using Furion; using Furion.DatabaseAccessor; using Furion.FriendlyException; +using Furion.Logging; using InitQ.Abstractions; using InitQ.Attributes; using Mapster; @@ -29,14 +30,7 @@ { private IEzCoreNetRedisService _ezCoreNetRedisService; private IWecharPayServicecs _wecharPayServicecs; - private IMapper _mapper; - //public PayServiceMessageQ(IEzCoreNetRedisService ezCoreNetRedisService,IWecharPayServicecs wecharPayServicecs,IMapper mapper) { - - // _ezCoreNetRedisService = ezCoreNetRedisService; - // _wecharPayServicecs = wecharPayServicecs; - // _mapper = mapper; - - //} + private IMapper _mapper; /// <summary> /// 寰俊杞处闃熷垪澶勭悊 @@ -191,5 +185,114 @@ } + + [Subscribe(InitQMessages.WxTransfer)] + public async void WxTransfer(string msg) + { + _ezCoreNetRedisService = App.GetService<IEzCoreNetRedisService>(); + _wecharPayServicecs = App.GetService<IWecharPayServicecs>(); + _mapper = App.GetService<IMapper>(); + + + var WeChatTransferOrderwork = new BaseRepository<WeChatTransferOrder>(); + var TransferOrder = await WeChatTransferOrderwork.AsQueryable().Includes(x => x.TransferDetailList).Where(x=>x.Id==msg.toInt()).FirstAsync(); + if(TransferOrder == null) + { + Log.Error($"WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屽師鍥犳槸娌℃湁鎵惧埌TransferOrder 锛屼紶閫扞d涓簕msg}"); + + return; + } + if(!string.IsNullOrEmpty(TransferOrder.BatchStatus)) + { + + return; + } + + // 鍙戣捣鏀粯 + var requit = _mapper.Map<CreateTransferBatchRequest>(TransferOrder); + requit.AppId = App.Configuration["WechatAPP:AppId"]; + requit.BatchName = "灏忛晣涓存椂宸ュ伐璧勮浆璐�"; + requit.BatchRemark = "宸濆嵃涓存椂宸ュ伐璧勶紝鎿嶈繃200鐨勫绗旀敮浠�"; + + var ret = await _wecharPayServicecs.Transfer(requit); + if (ret.IsSuccessful()) + { + var retdata = await WeChatTransferOrderwork.GetByIdAsync(TransferOrder.Id); + retdata.BatchId = ret.BatchId; + retdata.BatchStatus = ret.BatchStatus; + retdata.UpDataBy = "寰俊浠樻璇锋眰涔嬪悗"; + retdata.UpDataTime = DateTime.Now; + await WeChatTransferOrderwork.UpdateAsync(retdata); + } + else + { + var retdata = await WeChatTransferOrderwork.GetByIdAsync(TransferOrder.Id); + retdata.ErrorCode = ret.ErrorCode; + retdata.ErrorMsg = ret.ErrorMessage; + retdata.BatchStatus = ret.BatchStatus; + retdata.UpDataBy = "寰俊浠樻璇锋眰涔嬪悗"; + retdata.UpDataTime = DateTime.Now; + await WeChatTransferOrderwork.UpdateAsync(retdata); + Log.Error($"WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓簕msg} 閿欒鍘熷洜:{retdata.ErrorMsg}"); + return; + } + + + } + + + [Subscribe(InitQMessages.WxTransferAg)] + public async void WxTransferAg(string msg) + { + _ezCoreNetRedisService = App.GetService<IEzCoreNetRedisService>(); + _wecharPayServicecs = App.GetService<IWecharPayServicecs>(); + _mapper = App.GetService<IMapper>(); + + + var WeChatTransferOrderwork = new BaseRepository<WeChatTransferOrder>(); + var TransferOrder = await WeChatTransferOrderwork.AsQueryable().Includes(x => x.TransferDetailList).Where(x => x.Id == msg.toInt()).FirstAsync(); + if (TransferOrder == null) + { + Log.Error($" 鍐嶆璋冪敤WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屽師鍥犳槸娌℃湁鎵惧埌TransferOrder 锛屼紶閫扞d涓簕msg}"); + + return; + } + if (!string.IsNullOrEmpty(TransferOrder.BatchStatus)) + { + + return; + } + + // 鍙戣捣鏀粯 + var requit = _mapper.Map<CreateTransferBatchRequest>(TransferOrder); + requit.AppId = App.Configuration["WechatAPP:AppId"]; + requit.BatchName = "灏忛晣涓存椂宸ュ伐璧勮浆璐�"; + requit.BatchRemark = "宸濆嵃涓存椂宸ュ伐璧勶紝鎿嶈繃200鐨勫绗旀敮浠�"; + + var ret = await _wecharPayServicecs.Transfer(requit); + if (ret.IsSuccessful()) + { + var retdata = await WeChatTransferOrderwork.GetByIdAsync(TransferOrder.Id); + retdata.BatchId = ret.BatchId; + retdata.BatchStatus = ret.BatchStatus; + retdata.UpDataBy = "鍐嶆寰俊浠樻璇锋眰"; + retdata.UpDataTime = DateTime.Now; + await WeChatTransferOrderwork.UpdateAsync(retdata); + } + else + { + var retdata = await WeChatTransferOrderwork.GetByIdAsync(TransferOrder.Id); + retdata.ErrorCode = ret.ErrorCode; + retdata.ErrorMsg = ret.ErrorMessage; + retdata.BatchStatus = ret.BatchStatus; + retdata.UpDataBy = "鍐嶅井淇′粯娆捐姹�"; + retdata.UpDataTime = DateTime.Now; + await WeChatTransferOrderwork.UpdateAsync(retdata); + Log.Error($"WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓簕msg} 閿欒鍘熷洜:{retdata.ErrorMsg}"); + return; + } + + + } } } diff --git a/cylsg/EzInitqMessageDef/InitQMessages.cs b/cylsg/EzInitqMessageDef/InitQMessages.cs index 531a373..53d333a 100644 --- a/cylsg/EzInitqMessageDef/InitQMessages.cs +++ b/cylsg/EzInitqMessageDef/InitQMessages.cs @@ -14,7 +14,14 @@ /// 杞处 /// </summary> public const string WxTransferMSQ = "WxTransferMSQ"; - + /// <summary> + ///寰俊鎻愮幇鍙紶閫扞D + /// </summary> + public const string WxTransfer = "WxTransfer"; + /// <summary> + ///閲嶆柊鏀粯 + /// </summary> + public const string WxTransferAg = "WxTransferAg"; /// <summary> /// 鍚戝爢鏍堜腑鍘嬪叆涓�涓秷鎭� /// </summary> @@ -22,7 +29,7 @@ /// <param name="MessageName"> 娑堟伅鍚嶇О</param> /// <param name="msg">绫诲瀷</param> /// <returns></returns> - public static async Task<bool> SendMessageAsync<T>(string MessageName,T msg) + public static async Task<bool> SendMessageAsync<T>(string MessageName,T msg) { var _redis= App.GetService<ICacheService>(); @@ -40,6 +47,7 @@ var _redis = App.GetService<ICacheService>(); await _redis.ListRightPushAsync(MessageName, msg); + return true; } } diff --git a/cylsg/EzJob/ClearWorkOnDay.cs b/cylsg/EzJob/ClearWorkOnDay.cs new file mode 100644 index 0000000..e2c862d --- /dev/null +++ b/cylsg/EzJob/ClearWorkOnDay.cs @@ -0,0 +1,29 @@ +锘縰sing cylsg.utility; +using EzCoreNet.Redis; +using Furion.Schedule; +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace EzJob +{ + /// <summary> + /// 娓呴櫎姣忔棩鎻愮幇缁熻key + /// </summary> + public class ClearWorkOnDay : IJob + { + private readonly IEzCoreNetRedisService _redisService; + + public ClearWorkOnDay(IEzCoreNetRedisService ezCoreNetRedis) + { + _redisService = ezCoreNetRedis; + } + + public async Task ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) + { + await _redisService.delegateAllKeyWith(StaticStringDef.TransferMoneyManKey); + } + } +} diff --git a/cylsg/EzJob/StartUpcs.cs b/cylsg/EzJob/StartUpcs.cs index 8659fdd..dec56c5 100644 --- a/cylsg/EzJob/StartUpcs.cs +++ b/cylsg/EzJob/StartUpcs.cs @@ -18,7 +18,8 @@ services.AddSchedule(options => { - options.AddJob<WeChatJob>(concurrent: false, Triggers.Hourly()); // 涓茶 + options.AddJob<WeChatJob>(concurrent: false, Triggers.PeriodMinutes(1)); // 涓茶Triggers.PeriodMinutes(1) + options.AddJob<ClearWorkOnDay>(concurrent: false, Triggers.DailyAt(0)); }); } diff --git a/cylsg/EzJob/WeChatJob.cs b/cylsg/EzJob/WeChatJob.cs index 60c5e9a..3003768 100644 --- a/cylsg/EzJob/WeChatJob.cs +++ b/cylsg/EzJob/WeChatJob.cs @@ -5,6 +5,7 @@ using Furion.FriendlyException; using Furion.Schedule; using Microsoft.AspNetCore.Http.HttpResults; +using SKIT.FlurlHttpClient.Wechat.TenpayV3.Models; using System; using System.Collections.Generic; using System.Linq; @@ -32,20 +33,21 @@ } var WeChatTransferOrderRs = new BaseRepository<WeChatTransferOrder>(); - var OderList = await WeChatTransferOrderRs.AsQueryable().Includes(x=>x.TransferDetailList).Where(x => (x.BatchId != null && x.BatchId != "") || x.BatchStatus == "ACCEPTED" || x.BatchStatus == "PROCESSING").ToListAsync(); + var OderList = await WeChatTransferOrderRs.AsQueryable().Includes(x=>x.TransferDetailList).Where(x => (x.BatchId != null && x.BatchId != "")&&(x.BatchStatus==null|| x.BatchStatus == "ACCEPTED" || x.BatchStatus == "PROCESSING")).ToListAsync(); foreach( var o in OderList ) { - var ret = await payServices.TransferBatches(new SKIT.FlurlHttpClient.Wechat.TenpayV3.Models.GetTransferBatchByBatchIdRequest + var ret = await payServices.TransferBatches(new GetTransferBatchByOutBatchNumberRequest { - BatchId = o.BatchId + OutBatchNumber = o.OutBatchNumber + + - }); + }); ; if(ret != null) { if(ret.IsSuccessful()) - { - + { if (ret.TransferBatch.BatchStatus == "FINISHED") { @@ -61,28 +63,32 @@ foreach (var item in o.TransferDetailList) { var del =ret.TransferDetailList.Where(x=>x.OutDetailNumber==item.OutDetailNumber).FirstOrDefault(); - item.DetailStatus = del?.DetailStatus; - switch (item.DetailStatus) + if (del != null) + { - case "FAIL": - //澶辫触锛岃幏鍙栧け璐ュ師鍥� - var retde = await payServices.TransferBatchesDetails(new SKIT.FlurlHttpClient.Wechat.TenpayV3.Models.GetTransferBatchDetailByDetailIdRequest - { - BatchId = o.BatchId, - DetailId = del.DetailId, + item.DetailStatus = del?.DetailStatus; + switch (item.DetailStatus) + { + case "FAIL": + //澶辫触锛岃幏鍙栧け璐ュ師鍥� + var retde = await payServices.TransferBatchesDetails(new SKIT.FlurlHttpClient.Wechat.TenpayV3.Models.GetTransferBatchDetailByDetailIdRequest + { + BatchId = o.BatchId, + DetailId = del.DetailId, - }); + }); - item.FailReason = retde?.FailReason; - break; - case "SUCCESS": - item.DetailStatus = "SUCCESS"; + item.FailReason = retde?.FailReason; + break; + case "SUCCESS": + item.DetailStatus = "SUCCESS"; - break; + break; - default: - item.DetailStatus = del?.DetailStatus; - break; + default: + item.DetailStatus = del?.DetailStatus; + break; + } } @@ -92,7 +98,31 @@ } + else + if(ret.TransferBatch.BatchStatus== "PROCESSING") + { + o.BatchStatus = ret.TransferBatch.BatchStatus; + o.UpDataBy = "ExecuteAsync"; + o.UpDataTime = DateTime.Now; + o.CloseReason = ret.TransferBatch.CloseReason; + o.FailAmount = ret.TransferBatch.FailAmount; + o.FailNum = ret.TransferBatch.FailNumber; + o.SuccessNum = ret.TransferBatch.SuccessNumber; + o.SuccessAmount = ret.TransferBatch.SuccessAmount; + } } + else + { + //澶勭悊澶辫触 + o.ErrorCode = ret.ErrorCode; + o.ErrorMsg = ret.ErrorMessage; + o.UpDataBy = "ExecuteAsync"; + o.UpDataTime = DateTime.Now; + + + } + + await WeChatTransferOrderRs.UpdateRangeAsync(OderList); } } } diff --git a/cylsg/EzWechat/EzWechat.csproj b/cylsg/EzWechat/EzWechat.csproj index ed480b7..d1092ad 100644 --- a/cylsg/EzWechat/EzWechat.csproj +++ b/cylsg/EzWechat/EzWechat.csproj @@ -7,7 +7,7 @@ </PropertyGroup> <ItemGroup> - <PackageReference Include="SKIT.FlurlHttpClient.Wechat.Api" Version="3.4.0" /> + <PackageReference Include="SKIT.FlurlHttpClient.Wechat.Api" Version="3.5.0" /> <PackageReference Include="SKIT.FlurlHttpClient.Wechat.TenpayV3" Version="3.7.0" /> </ItemGroup> diff --git a/cylsg/EzWechat/IWecharPayServicecs.cs b/cylsg/EzWechat/IWecharPayServicecs.cs index 6f973fa..f1c337e 100644 --- a/cylsg/EzWechat/IWecharPayServicecs.cs +++ b/cylsg/EzWechat/IWecharPayServicecs.cs @@ -20,7 +20,7 @@ /// </summary> /// <param name="request"></param> /// <returns></returns> - Task<GetTransferBatchByBatchIdResponse> TransferBatches(GetTransferBatchByBatchIdRequest request); + Task<GetTransferBatchByOutBatchNumberResponse> TransferBatches(GetTransferBatchByOutBatchNumberRequest request); /// <summary> /// 鏍规嵁Detail id 鏌ヨ鍚嶅崟璇︾粏 /// </summary> diff --git a/cylsg/EzWechat/WecharPayServicecs.cs b/cylsg/EzWechat/WecharPayServicecs.cs index a679bee..2c871c1 100644 --- a/cylsg/EzWechat/WecharPayServicecs.cs +++ b/cylsg/EzWechat/WecharPayServicecs.cs @@ -1,5 +1,6 @@ 锘縰sing Furion; using Furion.DependencyInjection; +using Microsoft.Extensions.FileSystemGlobbing; using SKIT.FlurlHttpClient.Wechat.TenpayV3; using SKIT.FlurlHttpClient.Wechat.TenpayV3.Models; using SKIT.FlurlHttpClient.Wechat.TenpayV3.Settings; @@ -8,6 +9,7 @@ using System.Linq; using System.Text; using System.Threading.Tasks; +using static SKIT.FlurlHttpClient.Wechat.Api.Events.TransferCustomerServiceReply.Types; using static SKIT.FlurlHttpClient.Wechat.Api.Models.CgibinOpenApiRequestIdGetResponse.Types; namespace EzWechat @@ -40,10 +42,10 @@ } - public async Task<GetTransferBatchByBatchIdResponse> TransferBatches(GetTransferBatchByBatchIdRequest request) + public async Task<GetTransferBatchByOutBatchNumberResponse> TransferBatches(GetTransferBatchByOutBatchNumberRequest request) { - - var response = await _V3Client.ExecuteGetTransferBatchByBatchIdAsync(request); + + var response = await _V3Client.ExecuteGetTransferBatchByOutBatchNumberAsync(request); return response; } diff --git a/cylsg/cylsg.Application/LogoInController.cs b/cylsg/cylsg.Application/LogoInController.cs index 92d8070..9e941e7 100644 --- a/cylsg/cylsg.Application/LogoInController.cs +++ b/cylsg/cylsg.Application/LogoInController.cs @@ -84,6 +84,9 @@ //娌℃湁鐢ㄦ埛 锛岄渶瑕佹柊寤虹敤鎴� var phone = await _wechatService.GetPhone(Param.Bindgetphonenumber); + + user = await UserRes.GetFirstAsync(x => x.ItCode == phone); + if(user == null) { user = new User { @@ -94,14 +97,21 @@ ItCode = phone, PassWord = "123456", WxOpenId = opeid, - + CreateBy="寰俊娉ㄥ唽鐧诲綍", + CreateTime = DateTime.UtcNow, }; - await UserRes.EzInsertAsync(user); + user= await UserRes.InsertReturnEntityAsync(user); + } + else + { + user.WxOpenId = opeid; + await UserRes.EzUpdateAsync(user); + } - + } var jwt = new EzJwtModel() { @@ -123,9 +133,7 @@ } - - - + } /// <summary> diff --git a/cylsg/cylsg.Application/Transfer/UserTransfer.cs b/cylsg/cylsg.Application/Transfer/UserTransfer.cs index a5dcbdf..4446678 100644 --- a/cylsg/cylsg.Application/Transfer/UserTransfer.cs +++ b/cylsg/cylsg.Application/Transfer/UserTransfer.cs @@ -1,14 +1,25 @@ 锘縰sing cylsg.Core; +using cylsg.Model.TransferOrder; using cylsg.Model.UserModel; +using cylsg.utility; +using cylsg.utility.Extend; using Cylsg.Filter; +using EzCoreNet.Redis; using EzInitqMessageDef; +using EzWechat; +using Furion.LinqBuilder; +using MapsterMapper; +using Newtonsoft.Json; using SKIT.FlurlHttpClient.Wechat.Api.Models; using System; using System.Collections.Generic; using System.Linq; +using System.Linq.Expressions; using System.Security.Claims; using System.Text; using System.Threading.Tasks; +using TencentCloud.Ame.V20190916.Models; +using static SKIT.FlurlHttpClient.Wechat.Api.Models.ChannelsLeadsGetLeadsInfoByComponentIdResponse.Types; namespace cylsg.Application.Transfer { @@ -21,16 +32,30 @@ public class UserTransfer { - - public UserTransfer() { } + private readonly IEzCoreNetRedisService _redisService; + private readonly IWecharPayServicecs _wecharPayServicecs; + + public UserTransfer(IEzCoreNetRedisService ezCoreNetRedisService,IWecharPayServicecs wecharPayServicecs) { + + _redisService = ezCoreNetRedisService; + _wecharPayServicecs = wecharPayServicecs; + } + + /// <summary> /// 鎻愮幇 /// </summary> /// <param name="Money"></param> - [LimitFilter(LimiType = Limttype.User,timespan =10,ResponseMeg ="璇峰嬁鍦�10绉掑唴閲嶅璇锋眰")] - public async Task GetTransferMoney( [FromQuery]decimal Money) + [LimitFilter(LimiType = Limttype.User, timespan = 10, ResponseMeg = "璇峰嬁鍦�10绉掑唴閲嶅璇锋眰")] + public async Task GetTransferMoney([FromQuery] decimal Money) { - var rs= new BaseRepository<UserWorker>(); + + if (Money < 0.3m) + throw Oops.Oh("蹇呴』澶т簬0.3鍏�"); + if (Money > 2000) + throw Oops.Oh("姣忎汉姣忓ぉ鏈�澶氬彧鑳芥彁鍙�2000鍏�"); + + var rs = new BaseRepository<UserWorker>(); var UserID = App.User?.FindFirstValue("UserID"); int userid = 0; if (!string.IsNullOrEmpty(UserID)) @@ -42,17 +67,292 @@ throw Oops.Oh("娌℃湁璇嗗埆鍒扮敤鎴锋敹鍏�"); } - var uw= await rs.GetByIdAsync(userid); - if((uw.TiXianZonge-uw.YiTiXianJine)< Money) + + if (await _redisService.TryLock(StaticStringDef.TransferMoneyLockKey + userid.ToString(), 300)) { - throw Oops.Oh("鐢ㄦ埛浣欓涓嶈冻"); + + try + { + var UserRs = new BaseRepository<User>(); + var user = await UserRs.GetByIdAsync(userid); + if (user == null) + { + throw Oops.Oh($"娌℃湁鎵惧埌鐢ㄦ埛"); + } + if (string.IsNullOrEmpty(user.WxOpenId)) + { + throw Oops.Oh($"鐢ㄦ埛寰俊OpenID纭疄"); + } + var uw = await rs.GetFirstAsync(x => x.UserId == userid); + if (uw == null) + { + throw Oops.Oh("璇ョ敤鎴锋病鏈夋敹鍏�"); + } + if ((uw.TiXianZonge - uw.YiTiXianJine) < Money) + { + throw Oops.Oh("鐢ㄦ埛浣欓涓嶈冻"); + } + + + var totle = _redisService.Get<decimal>(StaticStringDef.TransferMoneyManKey + userid.ToString()); + if (totle + Money > 2000) + { + throw Oops.Oh("鎻愮幇閲戦涓嶅彲瓒呭嚭2000"); + } + + + + + var UserTiXianDetailwork = new BaseRepository<UserTiXianDetail>(); + var WeChatTransferOrderwork = new BaseRepository<WeChatTransferOrder>(); + if ((uw != null) && ((uw.TiXianZonge - uw.YiTiXianJine) >= Money)) + { + //婊¤冻鏉′欢锛屽彂璧锋敮浠� + var TransferOrder = new WeChatTransferOrder + { + + CreateBy = uw.UserId.ToString(), + CreateTime = DateTime.Now, + // BatchId = _redisService.Get32sn(), + OutBatchNumber = _redisService.Get32sn(), + Remake = "宸濆嵃宸ヨ祫鏀粯", + TransferDetailList = new List<WeChatTransferItem>(), + UserID = uw.UserId, + + + + + }; + try + { + + await UserTiXianDetailwork.AsTenant().BeginTranAsync(); + + + + + var moneylist = Money; + + var maxPayItem = Convert.ToDecimal(App.Configuration["WechartPay:PayMoneyMax"].toInt()); ; + while ((moneylist > maxPayItem)) + { + TransferOrder.TransferDetailList.Add(new WeChatTransferItem + { + CreateBy = uw.UserId.ToString(), + CreateTime = TransferOrder.CreateTime, + IsEn = true, + OpenId = user.WxOpenId, + OutDetailNumber = _redisService.Get32sn(), + + TransferAmount = (int)maxPayItem * 100, + TransferRemark = "宸濆嵃宸ヨ祫鏀粯", + + }); + + moneylist -= maxPayItem; + } + if (moneylist <= 0.3m) + { + //濡傛灉杩欓噷浣庝簬0.3姣涳紝灏嗙ぞ鍖洪妫�锛岀暀涓嬫澶勭悊 + Money -= moneylist; + } + else + + { + TransferOrder.TransferDetailList.Add(new WeChatTransferItem + { + CreateBy = uw.UserId.ToString(), + CreateTime = TransferOrder.CreateTime, + IsEn = true, + OpenId = user.WxOpenId, + OutDetailNumber = _redisService.Get32sn(), + + TransferAmount = (int)(moneylist * 100), + TransferRemark = "宸濆嵃宸ヨ祫鏀粯", + + }); + } + + TransferOrder.TotalAmount = (int)(Money * 100); + TransferOrder.TotalNum = TransferOrder.TransferDetailList.Count(); + + TransferOrder = await WeChatTransferOrderwork.AsSugarClient().InsertNav(TransferOrder).Include(x => x.TransferDetailList).ExecuteReturnEntityAsync(); + await UserTiXianDetailwork.InsertAsync(new UserTiXianDetail + { + CreateBy = uw.UserId.ToString(), + CreateTime = DateTime.Now, + UserId = user.Id, + ZhiChuShouRu = 0, + YiTiXianJine = Money, + WeChatTransferOrderID = TransferOrder.Id, + + }); + //閽卞寘浣欓璋冩暣 + uw.YiTiXianJine += Money; + uw.UpDataBy = uw.UserId.ToString(); + uw.UpDataTime = DateTime.Now; + await rs.UpdateAsync(uw); + + + await UserTiXianDetailwork.AsTenant().CommitTranAsync(); + + totle += Money; + //璁剧疆姣忔棩鎻愮幇闄愰 + _redisService.Add(StaticStringDef.TransferMoneyManKey + userid.ToString(), totle, 60 * 60 * 24); + //鍙戣捣鏀粯 + await InitQMessages.SendMessageAsync(InitQMessages.WxTransfer, TransferOrder.Id.ToString()); + } + catch (Exception) + { + await UserTiXianDetailwork.AsTenant().RollbackTranAsync(); + throw; + } + // 鍙戣捣鏀粯 + + + + } + + } + catch (Exception) + { + + throw; + } + finally + { + await _redisService.TryUnLock(StaticStringDef.TransferMoneyLockKey + userid.ToString()); + } + + + + + + + + + + + + + } - var b = await InitQMessages.SendMessageAsync(InitQMessages.WxTransferMSQ, Money.ToString()); - if (b) - return; - else - throw Oops.Oh("璇锋眰澶辫触"); + else + throw Oops.Oh("璇蜂笉瑕侀绻侀噸澶嶇敵璇�"); + + + + + } + /// <summary> + /// 鑾峰彇涓烘敮浠樺垪琛� + /// </summary> + [AllowAnonymous] + [HttpPost] + public async Task<TransferOderOut> GetTransferOder(SearchTransferOder param) + { + + var WeChatTransferOrderwork = new BaseRepository<WeChatTransferOrder>(); + PageModel pageModel = new PageModel + { PageIndex = param.PageIndex, PageSize = param.PageSize }; + + + Expression<Func<WeChatTransferOrder, bool>> SearchList = (x) => true; + + + if (!string.IsNullOrEmpty(param.BatchStatus)) + { + SearchList= SearchList.And(x => x.BatchStatus.Contains(param.BatchStatus)); + } + if (!string.IsNullOrEmpty(param.NoTBatchStatus)) + { + var lisstring = param.NoTBatchStatus?.Split('|'); + foreach (var lis in lisstring) + { + SearchList= SearchList.And(x => x.BatchStatus != lis); + } + } + if (param.HasSendOk == false) + SearchList= SearchList.And(x => x.BatchId == null); + else + SearchList= SearchList.And(x => x.BatchId != null); + var data = await WeChatTransferOrderwork.GetPageListAsync(SearchList, pageModel); + + return new TransferOderOut + { + listdata = data, + TotalCount=pageModel.TotalCount, + }; + } + /// <summary> + /// 閲嶆柊鏀粯 + /// </summary> + /// <param name="Id"> 鎸夎鍗曟壒娆℃搷浣�</param> + /// <returns></returns> + [AllowAnonymous] + [HttpGet] + // [ApiExplorerSettings(IgnoreApi = true)] + public async Task<bool> ReSendTransferOder([FromQuery] string ids) + { + var itmsRes = new BaseRepository<WeChatTransferOrder>(); + if (string.IsNullOrEmpty(ids)) + throw Oops.Oh("鍙傛暟閿欒"); + var idsr= ids.Split(',').Select(x=>x.toInt()).ToList(); + + foreach (var id in idsr) + { + + + if (itmsRes.GetById(id) != null) + await InitQMessages.SendMessageAsync(InitQMessages.WxTransferAg, id.ToString()); + + + } + return true; + + + + + } + + } + /// <summary> + /// + /// </summary> + public class SearchTransferOder + { + + /// <summary> + /// 鎼滅储鐘舵�佸�� 妯$硦鏌ヨ + /// </summary> + public string BatchStatus { get; set; } + /// <summary> + /// 鎺掗櫎鎼滅储鍊肩姸鎬� 瑕佹帓闄ょ殑鐘舵�佸�煎繀椤绘槸鍏ㄧО锛屽涓箣闂寸敤 鈥渱鈥濋棿闅� + /// </summary> + public string NoTBatchStatus { get; set; } + /// <summary> + /// 鏄惁宸茬粡鎴愬姛鍙戣捣浜� + /// </summary> + public bool HasSendOk { get; set; } = false; + /// <summary> + /// 褰撳墠椤电爜 + /// </summary> + public int PageIndex { get; set; } + /// <summary> + /// 椤甸潰澶у皬 + /// </summary> + public int PageSize { get; set; } + + } + + public class TransferOderOut + { + public List<WeChatTransferOrder> listdata { get; set; } + public int TotalCount { get; set; } + } + + } diff --git a/cylsg/cylsg.Model/TransferOrder/WeChartTransferOrder.cs b/cylsg/cylsg.Model/TransferOrder/WeChartTransferOrder.cs index 697153d..36193e0 100644 --- a/cylsg/cylsg.Model/TransferOrder/WeChartTransferOrder.cs +++ b/cylsg/cylsg.Model/TransferOrder/WeChartTransferOrder.cs @@ -33,18 +33,22 @@ /// <summary> /// 鑾峰彇鎴栬缃井淇℃壒娆″崟鍙枫�� /// </summary> - [SugarColumn(ColumnDescription = "鑾峰彇鎴栬缃井淇℃壒娆″崟鍙�")] - public string BatchId { get; set; } + [SugarColumn(ColumnDescription = "鑾峰彇鎴栬缃井淇℃壒娆″崟鍙�",IsNullable =true)] + public string? BatchId { get; set; } /// <summary> /// 鑾峰彇鎴栬缃壒娆$姸鎬併�� /// </summary> - [SugarColumn(ColumnDescription = "鑾峰彇鎴栬缃壒娆$姸鎬�")] + [SugarColumn(ColumnDescription = "鑾峰彇鎴栬缃壒娆$姸鎬�",IsNullable =true)] public string? BatchStatus { get; set; } - + /// <summary> + /// 鐢ㄦ埛ID銆� + /// </summary> + [SugarColumn(ColumnDescription = "鐢ㄦ埛ID")] + public int UserID { get; set; } @@ -130,14 +134,21 @@ /// </summary> [SugarColumn(ColumnDescription = "鑾峰彇鎴栬缃浆璐﹀満鏅爣璇嗙", IsNullable = true)] public string? TransferSceneId { get; set; } - + /// <summary> + /// 閿欒娑堟伅 + /// </summary> + [SugarColumn(ColumnDescription = "閿欒娑堟伅", IsNullable = true)] + public string? ErrorMsg { get; set; } - - - /// <summary> - /// 鑾峰彇鎴栬缃壒娆′腑鐨勮缁嗚浆璐﹀垪琛ㄣ�� - /// </summary> - [Navigate(NavigateType.OneToMany,nameof(WeChatTransferItem.WeChatTransferOrderID))] + /// <summary> + /// 閿欒鏍囪瘑 + /// </summary> + [SugarColumn(ColumnDescription = "閿欒鏍囪瘑", IsNullable = true)] + public string? ErrorCode { get; set; } + /// <summary> + /// 鑾峰彇鎴栬缃壒娆′腑鐨勮缁嗚浆璐﹀垪琛ㄣ�� + /// </summary> + [Navigate(NavigateType.OneToMany,nameof(WeChatTransferItem.WeChatTransferOrderID))] public List<WeChatTransferItem> TransferDetailList { get; set; } } @@ -146,6 +157,7 @@ /// 杞处鍗曞垪琛� /// </summary> [SugarTable(TableDescription = "杞处鍗曡处璇︾粏鍒楄〃妯″瀷")] + [CoderFirst] public class WeChatTransferItem:BaseModel { /// <summary> diff --git a/cylsg/cylsg.Web.Core/Startup.cs b/cylsg/cylsg.Web.Core/Startup.cs index 17e5e41..2a5ead3 100644 --- a/cylsg/cylsg.Web.Core/Startup.cs +++ b/cylsg/cylsg.Web.Core/Startup.cs @@ -47,6 +47,7 @@ services.AddControllersWithViews() .AddInjectWithUnifyResult<EzCoreRESTFulResultProvider>(); + services.AddFileLogging(); } public void Configure(IApplicationBuilder app, IWebHostEnvironment env) diff --git a/cylsg/cylsg.Web.Entry/application.log b/cylsg/cylsg.Web.Entry/application.log new file mode 100644 index 0000000..d870172 --- /dev/null +++ b/cylsg/cylsg.Web.Entry/application.log @@ -0,0 +1,851 @@ +info: 2024-09-23 13:36:52.2664650 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 13:36:52.2765928 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 13:36:52.3043312 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 13:36:52.3060328 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 13:36:52.3359823 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 13:36:52.3371717 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 13:36:52.6364889 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 13:36:52.9831605 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 13:36:52.9848197 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 13:36:52.9861580 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 13:36:52.9874925 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 13:36:55.0478393 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #9 + Failed to determine the https port for redirect. +fail: 2024-09-23 13:37:16.6104140 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #9 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�13 +info: 2024-09-23 14:00:46.6082543 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:00:46.6142101 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:00:46.6802725 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:00:46.6899284 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:00:46.7318145 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:00:46.7383479 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:00:46.7637335 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:00:47.3614695 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:00:47.3633122 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:00:47.3650832 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:00:47.3678673 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:00:49.2721843 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +info: 2024-09-23 14:02:27.9331431 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:02:27.9367602 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:02:27.9639120 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:02:27.9656695 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:02:27.9960536 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:02:27.9977078 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:02:28.0175458 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:02:28.4584772 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:02:28.4602953 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:02:28.4618578 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:02:28.4632871 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:02:30.0460079 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #11 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:06:45.9432071 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #29 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�15 閿欒鍘熷洜:杈撳叆婧愨��/body/appid鈥濇槧灏勫埌鍊煎瓧娈碘�滃晢鎴穉ppid鈥濆瓧绗︿覆瑙勫垯鏍¢獙澶辫触锛屽瓧绗︽暟 0锛屽皬浜庢渶灏忓�� 1 +info: 2024-09-23 14:31:51.3999964 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:31:51.4032483 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:31:51.4344110 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:31:51.4371032 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:31:51.4638304 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:31:51.4652740 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:31:51.4787085 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:31:51.9123886 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:31:51.9159328 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:31:51.9178419 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:31:51.9193491 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:31:52.8784652 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:32:08.6002157 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #11 + 涓嶈兘灏嗗�� NULL 鎻掑叆鍒� 'BatchId'锛岃〃 'CyLsgDb.dbo.WeChatTransferOrder'锛涘垪涓嶅厑璁告湁 Null 鍊笺�侷NSERT 澶辫触銆� + 璇彞宸茬粓姝€�� + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Microsoft.Data.SqlClient.SqlException (0x80131904): 涓嶈兘灏嗗�� NULL 鎻掑叆鍒� 'BatchId'锛岃〃 'CyLsgDb.dbo.WeChatTransferOrder'锛涘垪涓嶅厑璁告湁 Null 鍊笺�侷NSERT 澶辫触銆� + 璇彞宸茬粓姝€�� + at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) + at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) + at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) + at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) + at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() + at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() + at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) + at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) + at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) + at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) + at Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar() + at SqlSugar.AdoProvider.GetScalar(String sql, SugarParameter[] parameters) + at SqlSugar.InsertableProvider`1.ExecuteReturnBigIdentity() + at SqlSugar.InsertableProvider`1.ExecuteCommandIdentityIntoEntity() + at SqlSugar.InsertNavProvider`2.InsertIdentity[Type](List`1 datas) + at SqlSugar.InsertNavProvider`2.InitData[TChild](EntityColumnInfo pkColumn, List`1 insertData) + at SqlSugar.InsertNavProvider`2.InsertDatas[TChild](List`1 children, EntityColumnInfo pkColumn, EntityColumnInfo NavColumn) + at SqlSugar.InsertNavProvider`2.GetRootList[Type](List`1 datas) + at SqlSugar.InsertNavProvider`2.InitParentList() + at SqlSugar.InsertNavProvider`2._ThenInclude[TChild](Expression`1 expression) + at SqlSugar.InsertNavProvider`2.ThenInclude[TChild](Expression`1 expression) + at SqlSugar.InsertNavTaskInit`2.<>c__DisplayClass16_0`1.<Include>b__0() + at SqlSugar.InsertNavTask`2.ExecuteReturnEntity() + at SqlSugar.InsertNavTask`2.<>c__DisplayClass21_0.<<ExecuteReturnEntityAsync>b__0>d.MoveNext() + --- End of stack trace from previous location --- + at SqlSugar.InsertNavTask`2.ExecuteReturnEntityAsync() + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 173 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 202 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 219 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ClientConnectionId:caedac11-0b46-4ec9-9c4c-dd2948fc2da6 + Error Number:515,State:2,Class:16 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +info: 2024-09-23 14:35:45.4411130 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:35:45.4484565 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:35:45.4760164 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:35:45.4776454 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:35:45.5039342 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:35:45.5056716 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:35:45.5219281 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:35:45.8342568 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:35:45.8365740 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:35:45.8381350 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:35:45.8396577 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:35:47.2003366 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:36:57.2492386 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #34 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�17 閿欒鍘熷洜:杈撳叆婧愨��/body/total_num鈥濇槧灏勫埌鏁板�煎瓧娈碘�滆浆璐︽�荤瑪鏁扳�濊鍒欐牎楠屽け璐ワ紝鍊间綆浜庢渶灏忓�� 1 +info: 2024-09-23 14:43:23.0226138 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:43:23.0271235 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:43:23.0572611 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:43:23.0602453 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:43:23.1037625 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:43:23.1062700 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:43:23.1321587 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:43:23.4783428 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:43:23.4802400 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:43:23.4815763 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:43:23.4830813 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:43:25.0484868 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #11 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:43:37.8528472 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #7 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�18 閿欒鍘熷洜:杈撳叆婧愨��/body/total_num鈥濇槧灏勫埌鏁板�煎瓧娈碘�滆浆璐︽�荤瑪鏁扳�濊鍒欐牎楠屽け璐ワ紝鍊间綆浜庢渶灏忓�� 1 +info: 2024-09-23 14:45:02.1078677 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:45:02.1121860 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:45:02.1426928 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:45:02.1447821 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:45:02.1880266 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:45:02.1908109 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:45:02.2194824 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:45:02.6504734 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:45:02.6518315 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:45:02.6531232 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:45:02.6542808 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:45:04.1163611 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #10 + Failed to determine the https port for redirect. +info: 2024-09-23 14:46:37.3087436 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:46:37.3117122 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:46:37.3301505 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:46:37.3314574 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:46:37.3581957 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:46:37.3592679 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:46:37.3746618 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:46:37.7323203 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:46:37.7343512 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:46:37.7356846 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:46:37.7372003 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:46:38.8765836 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:47:12.8392163 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #14 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�21 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 +info: 2024-09-23 14:55:41.1540010 +08:00 鏄熸湡涓� L InitQ.InitQCore[0] #10 + Timeout awaiting response (outbound=0KiB, inbound=0KiB, 14516ms elapsed, timeout is 10000ms), command=LLEN, next: LLEN WxTransferMSQ, inst: 0, qu: 0, qs: 1, aw: True, rs: DequeueResult, ws: Writing, in: 0, in-pipe: 4, out-pipe: 0, serverEndpoint: 127.0.0.1:6379, mc: 1/1/0, mgr: 9 of 10 available, clientName: MS-FSEUTNLCXFDB, IOCP: (Busy=0,Free=1000,Min=200,Max=1000), WORKER: (Busy=6,Free=32761,Min=200,Max=32767), v: 2.2.4.27433 (Please take a look at this article for some common client-side issues that can cause timeouts: https://stackexchange.github.io/StackExchange.Redis/Timeouts) +info: 2024-09-23 14:56:51.0725315 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 14:56:51.0771881 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 14:56:51.1076792 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:56:51.1094803 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 14:56:51.1406151 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 14:56:51.1424125 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 14:56:51.1792958 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 14:56:51.5397280 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 14:56:51.5417216 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 14:56:51.5436118 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 14:56:51.5447948 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 14:56:53.0539633 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #10 + Failed to determine the https port for redirect. +fail: 2024-09-23 14:57:13.4197233 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #5 + 璇蜂笉瑕侀绻侀噸澶嶇敵璇� + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 璇蜂笉瑕侀绻侀噸澶嶇敵璇� + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 235 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() + --- End of stack trace from previous location --- + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 14:59:02.0154094 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #28 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�22 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 +fail: 2024-09-23 15:03:58.0937635 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #28 + 鐢ㄦ埛浣欓涓嶈冻 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 鐢ㄦ埛浣欓涓嶈冻 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 88 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 219 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 15:05:03.7549777 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #30 + 鎻愮幇閲戦涓嶅彲瓒呭嚭2000 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 鎻愮幇閲戦涓嶅彲瓒呭嚭2000 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 95 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 219 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 15:05:12.4823645 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #31 + 璇峰嬁鍦�10绉掑唴閲嶅璇锋眰 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 璇峰嬁鍦�10绉掑唴閲嶅璇锋眰 + at Cylsg.Filter.LimitFilterAttribute.OnActionExecutionAsync(ActionExecutingContext context, ActionExecutionDelegate next) in D:\workdir\宸濆嵃涓存椂宸cylsg\Cylsg.Filter\LimitFilterAttribute.cs:line 108 + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() + --- End of stack trace from previous location --- + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 15:05:38.4429895 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #10 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�23 閿欒鍘熷洜:璧勯噾涓嶈冻 +fail: 2024-09-23 15:06:19.7975426 +08:00 鏄熸湡涓� L System.Logging.FriendlyException[0] #31 + 鐢ㄦ埛浣欓涓嶈冻 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 鐢ㄦ埛浣欓涓嶈冻 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 88 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 219 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 15:07:56.9769790 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #9 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�24 閿欒鍘熷洜:璧勯噾涓嶈冻 +warn: 2024-09-23 15:15:35.8012903 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #36 + 09/23/2024 15:15:28: The <job1_trigger1> trigger of job <job1> failed to execute as scheduled due to blocking. +info: 2024-09-23 15:15:36.8259267 +08:00 鏄熸湡涓� L InitQ.InitQCore[0] #34 + Timeout awaiting response (outbound=0KiB, inbound=0KiB, 51360ms elapsed, timeout is 10000ms), command=LLEN, next: LLEN WxTransferMSQ, inst: 0, qu: 0, qs: 2, aw: False, rs: DequeueResult, ws: Idle, in: 0, in-pipe: 8, out-pipe: 0, serverEndpoint: 127.0.0.1:6379, mc: 1/1/0, mgr: 9 of 10 available, clientName: MS-FSEUTNLCXFDB, IOCP: (Busy=0,Free=1000,Min=200,Max=1000), WORKER: (Busy=2,Free=32765,Min=200,Max=32767), v: 2.2.4.27433 (Please take a look at this article for some common client-side issues that can cause timeouts: https://stackexchange.github.io/StackExchange.Redis/Timeouts) +info: 2024-09-23 15:15:36.8279921 +08:00 鏄熸湡涓� L InitQ.InitQCore[0] #7 + Timeout awaiting response (outbound=0KiB, inbound=0KiB, 51360ms elapsed, timeout is 10000ms), command=LLEN, next: LLEN WxTransferMSQ, inst: 0, qu: 0, qs: 2, aw: False, rs: DequeueResult, ws: Idle, in: 0, in-pipe: 8, out-pipe: 0, serverEndpoint: 127.0.0.1:6379, mc: 1/1/0, mgr: 9 of 10 available, clientName: MS-FSEUTNLCXFDB, IOCP: (Busy=0,Free=1000,Min=200,Max=1000), WORKER: (Busy=3,Free=32764,Min=200,Max=32767), v: 2.2.4.27433 (Please take a look at this article for some common client-side issues that can cause timeouts: https://stackexchange.github.io/StackExchange.Redis/Timeouts) +warn: 2024-09-23 15:21:44.8731507 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #28 + 09/23/2024 15:19:35: The <job1_trigger1> trigger of job <job1> failed to execute as scheduled due to blocking. +info: 2024-09-23 15:30:39.0349299 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 15:30:39.0396842 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 15:30:39.0643298 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:30:39.0662244 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:30:39.0982203 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 15:30:39.1000363 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 15:30:39.1636366 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 15:30:39.4806132 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 15:30:39.4824656 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 15:30:39.4840162 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 15:30:39.4854883 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 15:30:40.7220603 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #7 + Failed to determine the https port for redirect. +fail: 2024-09-23 15:31:16.8639261 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #13 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�26 閿欒鍘熷洜:杈撳叆婧愨��/body/total_amount鈥濇槧灏勫埌鏁板�煎瓧娈碘�滆浆璐︽�婚噾棰濃�濊鍒欐牎楠屽け璐ワ紝鍊间綆浜庢渶灏忓�� 1 +warn: 2024-09-23 15:32:44.6759488 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #34 + 09/23/2024 15:32:39: The <job1_trigger1> trigger of job <job1> failed to execute as scheduled due to blocking. +info: 2024-09-23 15:50:58.3760301 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 15:50:58.3804998 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 15:50:58.3997129 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:50:58.4014725 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:50:58.4293806 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 15:50:58.4324852 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 15:50:58.4608446 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 15:50:58.8539174 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 15:50:58.8555097 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 15:50:58.8568782 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 15:50:58.8581314 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 15:51:00.3848733 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +info: 2024-09-23 15:58:56.5937859 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 15:58:56.5977324 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 15:58:56.6174277 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:58:56.6193079 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 15:58:56.6459357 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 15:58:56.6472740 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 15:58:56.6605841 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 15:58:56.9992485 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 15:58:57.0009262 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 15:58:57.0022136 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 15:58:57.0048558 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 15:58:57.9839820 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #5 + Failed to determine the https port for redirect. +info: 2024-09-23 16:01:02.9717668 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 16:01:02.9756160 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 16:01:02.9952243 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:01:02.9972545 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:01:03.0241898 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 16:01:03.0261578 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 16:01:03.0439405 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 16:01:03.3503914 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 16:01:03.3528612 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 16:01:03.3545228 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 16:01:03.3558233 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 16:01:04.2541995 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +warn: 2024-09-23 16:03:04.4201320 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #29 + 09/23/2024 16:03:03: The <job1_trigger1> trigger of job <job1> failed to execute as scheduled due to blocking. +warn: 2024-09-23 16:05:37.7910061 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #33 + 09/23/2024 16:04:04: The <job1_trigger1> trigger of job <job1> failed to execute as scheduled due to blocking. +fail: 2024-09-23 16:07:19.1742797 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #35 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�27 閿欒鍘熷洜:杈撳叆婧愨��/body/total_amount鈥濇槧灏勫埌鏁板�煎瓧娈碘�滆浆璐︽�婚噾棰濃�濊鍒欐牎楠屽け璐ワ紝鍊间綆浜庢渶灏忓�� 1 +fail: 2024-09-23 16:11:31.0444225 +08:00 鏄熸湡涓� L System.Logging.StringLogging[0] #30 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�30 閿欒鍘熷洜:璧勯噾涓嶈冻 +info: 2024-09-23 16:17:09.3679528 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 16:17:09.3710141 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 16:17:09.3915274 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:17:09.3928775 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:17:09.4196898 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 16:17:09.4210032 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 16:17:09.4355131 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 16:17:09.7444775 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 16:17:09.7462675 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 16:17:09.7474036 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 16:17:09.7487147 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 16:17:11.1023717 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #9 + Failed to determine the https port for redirect. +fail: 2024-09-23 16:18:09.5167919 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #30 + Error occurred executing in <job1> [S] <job1 job1_trigger1> 1min 1ts 2024-09-23 16:18:09.387 +08:00 -> 2024-09-23 16:19:09.408 +08:00. + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Microsoft.Data.SqlClient.SqlException (0x80131904): 鍒楀悕 'UserID' 鏃犳晥銆� + at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__189_0(Task`1 result) + at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + --- End of stack trace from previous location --- + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) + --- End of stack trace from previous location --- + at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters) + at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj) + at SqlSugar.QueryableProvider`1._ToListAsync[TResult]() + at EzJob.WeChatJob.ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) in D:\workdir\宸濆嵃涓存椂宸cylsg\EzJob\WeChatJob.cs:line 36 + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_3.<<BackgroundProcessing>b__3>d.MoveNext() + --- End of stack trace from previous location --- + at Furion.FriendlyException.Retry.InvokeAsync(Func`1 action, Int32 numRetries, Int32 retryTimeout, Boolean finalThrow, Type[] exceptionTypes, Func`2 fallbackPolicy, Action`2 retryAction) + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_2.<<BackgroundProcessing>b__2>d.MoveNext() + ClientConnectionId:3c1df1ea-4f49-4a33-a493-7a2bf0040448 + Error Number:207,State:1,Class:16 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 16:19:09.4665398 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #29 + Error occurred executing in <job1> [S] <job1 job1_trigger1> 1min 2ts 2024-09-23 16:19:09.408 +08:00 -> 2024-09-23 16:20:09.437 +08:00. + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Microsoft.Data.SqlClient.SqlException (0x80131904): 鍒楀悕 'UserID' 鏃犳晥銆� + at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__189_0(Task`1 result) + at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + --- End of stack trace from previous location --- + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) + --- End of stack trace from previous location --- + at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters) + at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj) + at SqlSugar.QueryableProvider`1._ToListAsync[TResult]() + at EzJob.WeChatJob.ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) in D:\workdir\宸濆嵃涓存椂宸cylsg\EzJob\WeChatJob.cs:line 36 + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_3.<<BackgroundProcessing>b__3>d.MoveNext() + --- End of stack trace from previous location --- + at Furion.FriendlyException.Retry.InvokeAsync(Func`1 action, Int32 numRetries, Int32 retryTimeout, Boolean finalThrow, Type[] exceptionTypes, Func`2 fallbackPolicy, Action`2 retryAction) + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_2.<<BackgroundProcessing>b__2>d.MoveNext() + ClientConnectionId:3c1df1ea-4f49-4a33-a493-7a2bf0040448 + Error Number:207,State:1,Class:16 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +info: 2024-09-23 16:20:01.1341502 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 16:20:01.1387841 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 16:20:01.1680035 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:20:01.1706680 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:20:01.2150602 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 16:20:01.2171469 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 16:20:01.2863903 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 16:20:01.7172746 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 16:20:01.7198597 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 16:20:01.7221022 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 16:20:01.7237265 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 16:20:03.3617073 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #5 + Failed to determine the https port for redirect. +fail: 2024-09-23 16:21:01.3016384 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #30 + Error occurred executing in <job1> [S] <job1 job1_trigger1> 1min 1ts 2024-09-23 16:21:01.162 +08:00 -> 2024-09-23 16:22:01.197 +08:00. + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Microsoft.Data.SqlClient.SqlException (0x80131904): 鍒楀悕 'UserID' 鏃犳晥銆� + at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__189_0(Task`1 result) + at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + --- End of stack trace from previous location --- + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) + --- End of stack trace from previous location --- + at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters) + at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj) + at SqlSugar.QueryableProvider`1._ToListAsync[TResult]() + at EzJob.WeChatJob.ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) in D:\workdir\宸濆嵃涓存椂宸cylsg\EzJob\WeChatJob.cs:line 36 + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_3.<<BackgroundProcessing>b__3>d.MoveNext() + --- End of stack trace from previous location --- + at Furion.FriendlyException.Retry.InvokeAsync(Func`1 action, Int32 numRetries, Int32 retryTimeout, Boolean finalThrow, Type[] exceptionTypes, Func`2 fallbackPolicy, Action`2 retryAction) + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_2.<<BackgroundProcessing>b__2>d.MoveNext() + ClientConnectionId:e118c4ee-2086-42f4-b064-8d03f4085d87 + Error Number:207,State:1,Class:16 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-23 16:22:01.2506239 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #12 + Error occurred executing in <job1> [S] <job1 job1_trigger1> 1min 2ts 2024-09-23 16:22:01.197 +08:00 -> 2024-09-23 16:23:01.218 +08:00. + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Microsoft.Data.SqlClient.SqlException (0x80131904): 鍒楀悕 'UserID' 鏃犳晥銆� + at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__189_0(Task`1 result) + at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + --- End of stack trace from previous location --- + at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) + at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) + --- End of stack trace from previous location --- + at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters) + at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj) + at SqlSugar.QueryableProvider`1._ToListAsync[TResult]() + at EzJob.WeChatJob.ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) in D:\workdir\宸濆嵃涓存椂宸cylsg\EzJob\WeChatJob.cs:line 36 + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_3.<<BackgroundProcessing>b__3>d.MoveNext() + --- End of stack trace from previous location --- + at Furion.FriendlyException.Retry.InvokeAsync(Func`1 action, Int32 numRetries, Int32 retryTimeout, Boolean finalThrow, Type[] exceptionTypes, Func`2 fallbackPolicy, Action`2 retryAction) + at Furion.Schedule.ScheduleHostedService.<>c__DisplayClass23_2.<<BackgroundProcessing>b__2>d.MoveNext() + ClientConnectionId:e118c4ee-2086-42f4-b064-8d03f4085d87 + Error Number:207,State:1,Class:16 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +info: 2024-09-23 16:23:12.9207269 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 16:23:12.9309828 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 16:23:12.9570276 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:23:12.9599588 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:23:12.9905584 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 16:23:12.9921506 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 16:23:13.0109442 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 16:23:13.3990257 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 16:23:13.4004400 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 16:23:13.4018665 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 16:23:13.4029919 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 16:23:14.3157038 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #10 + Failed to determine the https port for redirect. +info: 2024-09-23 16:24:29.1499836 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 16:24:29.1544933 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 16:24:29.1805233 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:24:29.1828544 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 16:24:29.2196832 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 16:24:29.2218375 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 16:24:29.2452993 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 16:24:29.5497702 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 16:24:29.5524173 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 16:24:29.5544934 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 16:24:29.5559871 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 16:24:30.7095204 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #7 + Failed to determine the https port for redirect. +info: 2024-09-23 17:08:27.3739030 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 17:08:27.3807427 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 17:08:27.4292049 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:08:27.4348473 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:08:27.4698868 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 17:08:27.4718058 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 17:08:27.4922517 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 17:08:27.9135760 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 17:08:27.9165018 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 17:08:27.9191360 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 17:08:27.9210380 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 17:08:28.9099171 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #10 + Failed to determine the https port for redirect. +info: 2024-09-23 17:09:23.0344646 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 17:09:23.0382051 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 17:09:23.0599985 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:09:23.0623523 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:09:23.0897299 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 17:09:23.0913549 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 17:09:23.1112223 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 17:09:23.5894618 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 17:09:23.5912073 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 17:09:23.5926698 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 17:09:23.5947297 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 17:09:25.1097193 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #9 + Failed to determine the https port for redirect. +info: 2024-09-23 17:12:51.8725523 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-23 17:12:51.8775489 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-23 17:12:51.9113077 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:12:51.9135751 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-23 17:12:51.9477146 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-23 17:12:51.9495728 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-23 17:12:51.9844577 +08:00 鏄熸湡涓� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-23 17:12:52.3592228 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-23 17:12:52.3609039 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-23 17:12:52.3623843 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-23 17:12:52.3637356 +08:00 鏄熸湡涓� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-23 17:12:53.6008893 +08:00 鏄熸湡涓� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #10 + Failed to determine the https port for redirect. +info: 2024-09-24 13:17:35.3013930 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-24 13:17:35.3053152 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-24 13:17:35.3528560 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 13:17:35.3554190 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 13:17:35.3956054 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-24 13:17:35.3991770 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-24 13:17:35.4311376 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-24 13:17:35.7977879 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-24 13:17:35.7992007 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-24 13:17:35.8004690 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-24 13:17:35.8017062 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-24 13:17:37.1671495 +08:00 鏄熸湡浜� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #7 + Failed to determine the https port for redirect. +info: 2024-09-24 14:09:31.4058074 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-24 14:09:31.4096170 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-24 14:09:31.4379648 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:09:31.4410524 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:09:31.4715036 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-24 14:09:31.4730893 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-24 14:09:31.4891918 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-24 14:09:31.8002189 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-24 14:09:31.8017175 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-24 14:09:31.8029676 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-24 14:09:31.8041779 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-24 14:09:33.2136491 +08:00 鏄熸湡浜� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #11 + Failed to determine the https port for redirect. +info: 2024-09-24 14:10:18.6238234 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-24 14:10:18.6277965 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-24 14:10:18.6494252 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:10:18.6516777 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:10:18.6797729 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-24 14:10:18.6813466 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-24 14:10:18.6946833 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-24 14:10:18.9955055 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-24 14:10:18.9972638 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-24 14:10:18.9984633 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-24 14:10:18.9998318 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-24 14:10:19.8712870 +08:00 鏄熸湡浜� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #13 + Failed to determine the https port for redirect. +fail: 2024-09-24 14:15:18.3345051 +08:00 鏄熸湡浜� L System.Logging.StringLogging[0] #11 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�31 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 +fail: 2024-09-24 14:16:27.8266695 +08:00 鏄熸湡浜� L System.Logging.StringLogging[0] #7 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�31 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 +fail: 2024-09-24 14:16:58.0520807 +08:00 鏄熸湡浜� L System.Logging.FriendlyException[0] #28 + 鐢ㄦ埛浣欓涓嶈冻 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 鐢ㄦ埛浣欓涓嶈冻 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 93 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 225 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-24 14:17:31.0870260 +08:00 鏄熸湡浜� L System.Logging.FriendlyException[0] #28 + 鐢ㄦ埛浣欓涓嶈冻 + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Furion.FriendlyException.AppFriendlyException: 鐢ㄦ埛浣欓涓嶈冻 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 93 + at cylsg.Application.Transfer.UserTransfer.GetTransferMoney(Decimal Money) in D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Application\Transfer\UserTransfer.cs:line 225 + at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) + ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +fail: 2024-09-24 14:18:54.1384126 +08:00 鏄熸湡浜� L System.Logging.StringLogging[0] #13 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�32 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 +info: 2024-09-24 14:26:50.2783622 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is running. +info: 2024-09-24 14:26:50.2838034 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service is preloading... +info: 2024-09-24 14:26:50.3119716 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job1_trigger1> trigger for scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:26:50.3135638 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job1> successfully appended to the schedule. +info: 2024-09-24 14:26:50.3414776 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The <job2_trigger1> trigger for scheduler of <job2> successfully appended to the schedule. +info: 2024-09-24 14:26:50.3427284 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + The scheduler of <job2> successfully appended to the schedule. +warn: 2024-09-24 14:26:50.3569685 +08:00 鏄熸湡浜� L System.Logging.ScheduleService[0] #1 + Schedule hosted service preload completed, and a total of <2> schedulers are appended. +info: 2024-09-24 14:26:50.7046033 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[14] #1 + Now listening on: http://0.0.0.0:5000 +info: 2024-09-24 14:26:50.7064688 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Application started. Press Ctrl+C to shut down. +info: 2024-09-24 14:26:50.7076348 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Hosting environment: Development +info: 2024-09-24 14:26:50.7089316 +08:00 鏄熸湡浜� L Microsoft.Hosting.Lifetime[0] #1 + Content root path: D:\workdir\宸濆嵃涓存椂宸cylsg\cylsg.Web.Entry +warn: 2024-09-24 14:26:52.1013098 +08:00 鏄熸湡浜� L Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] #5 + Failed to determine the https port for redirect. +fail: 2024-09-24 14:28:39.9122308 +08:00 鏄熸湡浜� L System.Logging.StringLogging[0] #29 + WxTransfer寰俊鏀粯澶勭悊 澶辫触锛屼紶閫扞d涓�32 閿欒鍘熷洜:姝P鍦板潃涓嶅厑璁歌皟鐢ㄨ鎺ュ彛 diff --git a/cylsg/cylsg.Web.Entry/appsettings.json b/cylsg/cylsg.Web.Entry/appsettings.json index bb50097..6982c20 100644 --- a/cylsg/cylsg.Web.Entry/appsettings.json +++ b/cylsg/cylsg.Web.Entry/appsettings.json @@ -5,6 +5,14 @@ "Default": "Information", "Microsoft.AspNetCore": "Warning", "Microsoft.EntityFrameworkCore": "Information" + }, + + "File": { + "FileName": "application.log", // 鏃ュ織鏂囦欢瀹屾暣璺緞鎴栨枃浠跺悕锛屾帹鑽� .log 浣滀负鎷撳睍鍚� + "Append": true, // 杩藉姞鍒板凡瀛樺湪鏃ュ織鏂囦欢鎴栬鐩栧畠浠� + "MinimumLevel": "Information", // 鏈�浣庢棩蹇楄褰曠骇鍒� + "FileSizeLimitBytes": 0, // 鎺у埗姣忎竴涓棩蹇楁枃浠舵渶澶у瓨鍌ㄥぇ灏忥紝鍗曚綅鏄� B锛屼篃灏辨槸 1024 鎵嶇瓑浜� 1KB锛岄粯璁ゆ棤闄愬埗锛屽鏋滄寚瀹氫簡璇ュ�硷紝閭d箞鏃ュ織鏂囦欢澶у皬瓒呭嚭浜嗚閰嶇疆灏变細鍒涘缓鏂扮殑鏃ュ織鏂囦欢锛屾柊鍒涘缓鐨勬棩蹇楁枃浠跺懡鍚嶈鍒欙細鏂囦欢鍚�+[閫掑搴忓彿].log + "MaxRollingFiles": 0 // 鎺у埗鏈�澶у垱寤虹殑鏃ュ織鏂囦欢鏁伴噺锛岄粯璁ゆ棤闄愬埗锛岄厤鍚� FileSizeLimitBytes 浣跨敤锛屽鏋滄寚瀹氫簡璇ュ�硷紝閭d箞瓒呭嚭璇ュ�煎皢浠庢渶鍒濇棩蹇楁枃浠朵腑浠庡ご鍐欏叆瑕嗙洊 } }, "AllowedHosts": "*", @@ -39,7 +47,7 @@ "ValidateAudience": true, // 鏄惁楠岃瘉绛炬敹鏂癸紝bool 绫诲瀷锛岄粯璁rue "ValidAudience": "www.51zhengcai.com", // 绛炬敹鏂癸紝string 绫诲瀷 "ValidateLifetime": true, // 鏄惁楠岃瘉杩囨湡鏃堕棿锛宐ool 绫诲瀷锛岄粯璁rue锛屽缓璁畉rue - "ExpiredTime": 20, // 杩囨湡鏃堕棿锛宭ong 绫诲瀷锛屽崟浣嶅垎閽燂紝榛樿20鍒嗛挓 + "ExpiredTime": 1440, // 杩囨湡鏃堕棿锛宭ong 绫诲瀷锛屽崟浣嶅垎閽燂紝榛樿20鍒嗛挓 "ClockSkew": 5, // 杩囨湡鏃堕棿瀹归敊鍊硷紝long 绫诲瀷锛屽崟浣嶇锛岄粯璁� 5绉� "Algorithm": "HS256", // 鍔犲瘑绠楁硶锛宻tring 绫诲瀷锛岄粯璁� HS256 "RefreshTokenExpires": 1440 //鍒嗛挓 1澶� 1440鍒嗛挓 diff --git a/cylsg/cylsg.redis/EzCoreNetRedisService.cs b/cylsg/cylsg.redis/EzCoreNetRedisService.cs index 5137422..5ce6426 100644 --- a/cylsg/cylsg.redis/EzCoreNetRedisService.cs +++ b/cylsg/cylsg.redis/EzCoreNetRedisService.cs @@ -10,7 +10,7 @@ namespace EzCoreNet.Redis { - public class EzCoreNetRedisService : IEzCoreNetRedisService,IScoped + public class EzCoreNetRedisService : IEzCoreNetRedisService, IScoped { public bool Add(string key, object value, int expireSeconds) { @@ -35,9 +35,9 @@ return RedisHelper.Ttl(key); } - public bool SetTtl(string key, int ttl) + public bool SetTtl(string key, int ttl) { - return RedisHelper.Expire(key, ttl); + return RedisHelper.Expire(key, ttl); } /// <summary> @@ -70,7 +70,7 @@ { return RedisHelper.Keys(Prefix + "*"); } - + /// <summary> /// 鍚庡幓涓�涓紦瀛橈紝濡傛灉娌℃湁锛屽垯浠庢暟鎹簱涓幏鍙栵紝 /// </summary> @@ -102,23 +102,61 @@ public long Incrby(string key) { - return RedisHelper.IncrBy(key); + return RedisHelper.IncrBy(key); } public string Get32sn() { string formattedDate = DateTime.Now.ToString("yyyyMMdd"); - + var sn = Incrby($"CreatSnKey:{formattedDate}"); - if(sn<1) + if (sn < 1) { //璁剧疆鏈夋晥鏈熼檺涓�24灏忔椂 SetTtl($"CreatSnKey:{formattedDate}", 24 * 60 * 60); } - string re = "Ez" + formattedDate + sn.ToString(); + string re = "EZCoreCanYinLingShiGon" + formattedDate + sn.ToString(); return re; } + + /// <summary> + /// + /// </summary> + /// <param name="LockKey"></param> + /// <param name="expireSeconds"></param> + /// <param name="value"></param> + /// <returns></returns> + + public async Task<bool> TryLock(string LockKey, int expireSeconds = 600, string value = "Lock") + { + if (await RedisHelper.SetNxAsync(LockKey, value) == true) + { + if( await RedisHelper.ExpireAsync(LockKey, expireSeconds)==false) + return false; + return true; + } + else + return false; + + + } + + + /// <summary> + /// + /// </summary> + /// <param name="LockKey"></param> + /// <returns></returns> + public async Task<bool > TryUnLock(string LockKey) + { + var b= await RedisHelper.DelAsync(LockKey); + if(b>0) + return true; + else + return false; + + } } } diff --git a/cylsg/cylsg.redis/IEzCoreNetRedisService.cs b/cylsg/cylsg.redis/IEzCoreNetRedisService.cs index e92bb05..e7ae2af 100644 --- a/cylsg/cylsg.redis/IEzCoreNetRedisService.cs +++ b/cylsg/cylsg.redis/IEzCoreNetRedisService.cs @@ -86,6 +86,21 @@ /// 鑾峰彇32浣峴n /// </summary> string Get32sn(); - + /// <summary> + /// 璁剧疆閿� + /// </summary> + /// <param name="LockKey"> 閿並ey</param> + /// <param name="value"> 鍊� 榛樿lock</param> + /// <param name="expireSeconds"> 鏈�闀块攣瀹氭椂闂� 榛樿600</param> + /// <returns></returns> + Task<bool> TryLock(string LockKey, int expireSeconds = 600,string value = "Lock"); + + /// <summary> + /// 瑙i攣 + /// </summary> + /// <param name="LockKey"></param> + /// <returns></returns> + Task<bool> TryUnLock(string LockKey); + } } diff --git a/cylsg/cylsg.utility/StaticStringDef.cs b/cylsg/cylsg.utility/StaticStringDef.cs new file mode 100644 index 0000000..ffccbdb --- /dev/null +++ b/cylsg/cylsg.utility/StaticStringDef.cs @@ -0,0 +1,24 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace cylsg.utility +{ + /// <summary> + /// 甯哥敤瀛楃涓插畾涔� + /// </summary> + public static class StaticStringDef + { + /// <summary> + /// 鎻愮幇鑷攣KeY + /// </summary> + public static string TransferMoneyLockKey = "TransferMoneyLockKey:"; + + /// <summary> + /// 鎻愮幇缁熻绱閿� + /// </summary> + public static string TransferMoneyManKey = "TransferMoneyManKey:"; + } +} -- Gitblit v1.9.1