//
//AliexPRessEntities MyaliexpressEntities 為了事物一致性 在別的方法里面傳過來的 實質還是 ( AliexpressEntities aliexpressEntities = new AliexpressEntities();)
和 userBll.GetUser 方法里面的一樣
public YH_AmountAccount AmountAccountSaveChanges(AliexpressEntities MyaliexpressEntities, int amountAccounUserId, string transactionRemark, int transactionType, string transactionNumber, decimal? transactionAmount, decimal? transactionAmountMMB) { YH_AmountAccount AmountAccount = new YH_AmountAccount(); YH_UserBLL userBll = new YH_UserBLL(); var getuser = userBll.GetUser(amountAccounUserId); //為什么 這里是 51.2 (正確 ) var userNow = MyaliexpressEntities.YH_User.Where(p => p.userId == amountAccounUserId).Single(); //這里是 63.8 (還是之前的數據) AmountAccount.createTime = DateTime.Now; AmountAccount.isActive = true; AmountAccount.createUserId = userNow.userId; AmountAccount.amountAccounUserId = userNow.userId; AmountAccount.transactionRemark = transactionRemark; AmountAccount.transactionType = transactionType; //(transactionType 1發布任務 2刪除任務 3完成任務 4賬戶充值) AmountAccount.transactionNumber = transactionNumber; AmountAccount.initialAmount = userNow.Balance + userNow.BalanceLocked; AmountAccount.initialAmountMMB = userNow.MMCoin + userNow.MMCoinLocked; AmountAccount.transactionAmount = transactionAmount; AmountAccount.transactionAmountMMB = transactionAmountMMB; AmountAccount.accountBalance = AmountAccount.initialAmount - AmountAccount.transactionAmount; AmountAccount.accountBalanceMMB = AmountAccount.initialAmountMMB - AmountAccount.transactionAmountMMB; userNow.MMCoin = AmountAccount.accountBalanceMMB - userNow.MMCoinLocked; userNow.Balance = AmountAccount.accountBalance - userNow.BalanceLocked; if (userNow.Balance < 0) { throw new Exception("您賬戶的可用余額不足,請充值!"); } return AmountAccount; }
userBll.GetUser 方法namespace Aliexpress.BLL{ public class YH_UserBLL { AliexpressEntities aliexpressEntities = new AliexpressEntities(); public YH_User GetUser(int userId) { var user = aliexpressEntities.YH_User.Where(p => p.userId == userId&&p.isActive==true).SingleOrDefault(); return user; } }}
//調試數據
新聞熱點
疑難解答