Utils.cs 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using MySystem.PxcModels;
  5. namespace MySystem
  6. {
  7. public class Utils
  8. {
  9. public readonly static Utils Instance = new Utils();
  10. private Utils()
  11. { }
  12. /// <summary>
  13. /// 操作收支明细
  14. /// </summary>
  15. /// <param name="UserId"></param>
  16. /// <param name="Money"></param>
  17. /// <param name="ChangeType"></param>
  18. public void OpAccount(int UserId, decimal Money, int ChangeType)
  19. {
  20. WebCMSEntities db = new WebCMSEntities();
  21. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  22. if (account == null)
  23. {
  24. account = db.UserAccount.Add(new UserAccount()
  25. {
  26. Id = UserId,
  27. UserId = UserId,
  28. }).Entity;
  29. db.SaveChanges();
  30. }
  31. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  32. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  33. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  34. account.BalanceAmount += Money;
  35. account.TotalAmount += Money;
  36. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  37. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  38. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  39. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  40. {
  41. CreateDate = DateTime.Now,
  42. UpdateDate = DateTime.Now,
  43. UserId = UserId, //创客
  44. ChangeType = ChangeType, //变动类型
  45. ChangeAmount = Money, //变更金额
  46. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  47. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  48. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  49. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  50. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  51. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  52. }).Entity;
  53. db.SaveChanges();
  54. db.Dispose();
  55. }
  56. }
  57. }