Utils.cs 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using Library;
  5. using MySystem.PxcModels;
  6. namespace MySystem
  7. {
  8. public class Utils
  9. {
  10. public readonly static Utils Instance = new Utils();
  11. private Utils()
  12. { }
  13. /// <summary>
  14. /// 操作收支明细
  15. /// </summary>
  16. /// <param name="UserId"></param>
  17. /// <param name="Money"></param>
  18. /// <param name="ChangeType"></param>
  19. public void OpAccount(int UserId, decimal Money, int ChangeType, bool IsTotal = true)
  20. {
  21. WebCMSEntities db = new WebCMSEntities();
  22. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  23. if (account == null)
  24. {
  25. account = db.UserAccount.Add(new UserAccount()
  26. {
  27. Id = UserId,
  28. UserId = UserId,
  29. }).Entity;
  30. db.SaveChanges();
  31. }
  32. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  33. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  34. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  35. account.BalanceAmount += Money;
  36. if(IsTotal)
  37. {
  38. account.TotalAmount += Money;
  39. }
  40. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  41. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  42. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  43. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  44. {
  45. CreateDate = DateTime.Now,
  46. UpdateDate = DateTime.Now,
  47. UserId = UserId, //创客
  48. ChangeType = ChangeType, //变动类型
  49. ChangeAmount = Money, //变更金额
  50. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  51. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  52. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  53. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  54. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  55. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  56. }).Entity;
  57. db.SaveChanges();
  58. db.Dispose();
  59. }
  60. public void ToChargeAmount(int UserId, decimal Money)
  61. {
  62. WebCMSEntities db = new WebCMSEntities();
  63. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  64. if (account == null)
  65. {
  66. account = db.UserAccount.Add(new UserAccount()
  67. {
  68. Id = UserId,
  69. UserId = UserId,
  70. }).Entity;
  71. db.SaveChanges();
  72. }
  73. account.ToChargeAmount += Money;
  74. db.SaveChanges();
  75. db.Dispose();
  76. }
  77. /// <summary>
  78. /// 预设职级
  79. /// </summary>
  80. /// <param name="UserId"></param>
  81. /// <param name="LeaderKind"></param>
  82. public void LeaderPreUserLevel(int UserId, int UserLevel, DateTime ExpiredDate)
  83. {
  84. WebCMSEntities db = new WebCMSEntities();
  85. UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  86. if(rank == null)
  87. {
  88. rank = db.UserRankWhite.Add(new UserRankWhite()
  89. {
  90. CreateDate = DateTime.Now, //设置时间
  91. UserId = UserId, //用户
  92. Id = UserId,
  93. }).Entity;
  94. db.SaveChanges();
  95. }
  96. rank.Rank = UserLevel;
  97. rank.UpdateDate = ExpiredDate;
  98. db.SaveChanges();
  99. db.Dispose();
  100. }
  101. #region 获取创客职级
  102. public int GetUserLevel(int Id)
  103. {
  104. WebCMSEntities db = new WebCMSEntities();
  105. DateTime now = DateTime.Now;
  106. List<int> Levels = new List<int>();
  107. Users user = db.Users.FirstOrDefault(m => m.Id == Id) ?? new Users();
  108. UserRankWhite userRank = db.UserRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new UserRankWhite();
  109. LeaderRankWhite leaderRank = db.LeaderRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new LeaderRankWhite();
  110. OperatorRankWhite operatorRank = db.OperatorRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new OperatorRankWhite();
  111. Levels.Add(user.UserLevel);
  112. Levels.Add(userRank.Rank);
  113. Levels.Add(leaderRank.Rank);
  114. Levels.Add(operatorRank.Rank);
  115. db.Dispose();
  116. return Levels.Max();
  117. }
  118. #endregion
  119. #region 解析机具押金值,单位转换
  120. public string TransferDeposit(PosMachinesTwo newpos, string Deposit)
  121. {
  122. decimal DepositNumber = decimal.Parse(function.CheckNum(Deposit));
  123. if(DepositNumber == 0)
  124. {
  125. return "";
  126. }
  127. WebCMSEntities db = new WebCMSEntities();
  128. int BrandId = newpos.BrandId;
  129. KqProducts pro = db.KqProducts.FirstOrDefault(m => m.Id == BrandId) ?? new KqProducts();
  130. if(pro.NoticeMoneyUnit == 1 && DepositNumber > 1000)
  131. {
  132. DepositNumber = DepositNumber / 100;
  133. }
  134. if(pro.NoticeMoneyUnit == 2 && DepositNumber < 1000)
  135. {
  136. DepositNumber = DepositNumber * 100;
  137. }
  138. db.Dispose();
  139. return DepositNumber.ToString("f2");
  140. }
  141. #endregion
  142. #region 打控制台日志
  143. public static void WriteLog(string msg, string filename = "message")
  144. {
  145. Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "--" + filename + "--" + msg);
  146. }
  147. #endregion
  148. }
  149. }