public async Task <int> CheckChatEnd() { var endChats = mySqlContent.ZJ_Chats.Where(a => a.Status == 1 && a.IsDelete == 0 && a.EndTime <= DateTime.Now).ToList(); foreach (var item in endChats) { item.Status = 2; //转移到账上 var zj_UserA = mySqlContent.ZJ_Users.Where(a => a.FId == item.AnswerId) .FirstOrDefault(); var _payOrder = mySqlContent.ZJ_PayOrders.Where(a => a.ChatId == item.FId).FirstOrDefault(); if (zj_UserA != null && _payOrder != null) { var totalMoney = zj_UserA.TotalMoney + _payOrder.Money; var zj_balance = new ZJ_Balance { FId = UtilHelper.GetNewGuid(), UserId = zj_UserA.FId, AdverseId = item.FId, AfterMoney = totalMoney, BeforeMoney = zj_UserA.TotalMoney, ChangeMoney = _payOrder.Money, ChangeType = 0, CreateTime = DateTime.Now, }; zj_UserA.TotalMoney = totalMoney; mySqlContent.ZJ_Users.Update(zj_UserA); mySqlContent.ZJ_Balances.Add(zj_balance); } } var res = await mySqlContent.SaveChangesAsync(); return(res); }