Utils.cs 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  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, bool IsTotal = true)
  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. if(IsTotal)
  36. {
  37. account.TotalAmount += Money;
  38. }
  39. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  40. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  41. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  42. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  43. {
  44. CreateDate = DateTime.Now,
  45. UpdateDate = DateTime.Now,
  46. UserId = UserId, //创客
  47. ChangeType = ChangeType, //变动类型
  48. ChangeAmount = Money, //变更金额
  49. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  50. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  51. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  52. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  53. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  54. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  55. }).Entity;
  56. db.SaveChanges();
  57. db.Dispose();
  58. }
  59. public void ToChargeAmount(int UserId, decimal Money)
  60. {
  61. WebCMSEntities db = new WebCMSEntities();
  62. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  63. if (account == null)
  64. {
  65. account = db.UserAccount.Add(new UserAccount()
  66. {
  67. Id = UserId,
  68. UserId = UserId,
  69. }).Entity;
  70. db.SaveChanges();
  71. }
  72. account.ToChargeAmount += Money;
  73. db.SaveChanges();
  74. db.Dispose();
  75. }
  76. /// <summary>
  77. /// 判断是否达标创客
  78. /// </summary>
  79. /// <param name="UserId"></param>
  80. /// <returns></returns>
  81. public bool IsStandardUser(int UserId)
  82. {
  83. WebCMSEntities db = new WebCMSEntities();
  84. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == UserId && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  85. int couponCount = db.PosCoupons.Count(m => m.UserId == UserId && m.IsUse == 0); //判断是否拥有3张券
  86. // TODO:待确认条件
  87. db.Dispose();
  88. if(ActiveCount + couponCount >= 3)
  89. {
  90. return true;
  91. }
  92. return false;
  93. }
  94. /// <summary>
  95. /// 预设职级
  96. /// </summary>
  97. /// <param name="UserId"></param>
  98. /// <param name="LeaderKind"></param>
  99. public void LeaderPreUserLevel(int UserId, int UserLevel, DateTime ExpiredDate)
  100. {
  101. WebCMSEntities db = new WebCMSEntities();
  102. UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  103. if(rank == null)
  104. {
  105. rank = db.UserRankWhite.Add(new UserRankWhite()
  106. {
  107. CreateDate = DateTime.Now, //设置时间
  108. UserId = UserId, //用户
  109. Id = UserId,
  110. }).Entity;
  111. db.SaveChanges();
  112. }
  113. rank.Rank = UserLevel;
  114. rank.UpdateDate = ExpiredDate;
  115. db.SaveChanges();
  116. db.Dispose();
  117. }
  118. }
  119. }