OperatePrizeService.cs 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. using System;
  2. using System.Collections.Generic;
  3. using Library;
  4. using LitJson;
  5. using System.Linq;
  6. using System.Data;
  7. using System.Threading;
  8. using MySystem.PxcModels;
  9. namespace MySystem
  10. {
  11. public class OperatePrizeService
  12. {
  13. public readonly static OperatePrizeService Instance = new OperatePrizeService();
  14. private OperatePrizeService()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(dosomething);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. public void dosomething()
  23. {
  24. while (true)
  25. {
  26. string data = RedisDbconn.Instance.RPop<string>("OperatePrizeQueue");
  27. if (!string.IsNullOrEmpty(data))
  28. {
  29. try
  30. {
  31. int PosId = int.Parse(function.CheckInt(data));
  32. WebCMSEntities db = new WebCMSEntities();
  33. OpModels.WebCMSEntities spdb = new OpModels.WebCMSEntities();
  34. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == PosId);
  35. if (pos != null)
  36. {
  37. bool IsGet = true;
  38. if(pos.BrandId == 23 || pos.BrandId == 24 || pos.BrandId == 25 || pos.BrandId == 26)
  39. {
  40. int Count = db.UserAccountRecord.Count(m => m.QueryCount == PosId && m.ChangeType == 121);
  41. int Count1 = db.WifiTradeRecord.Count(m => m.SnNo == pos.PosSn);
  42. IsGet = Count >= Count1;
  43. }
  44. else
  45. {
  46. IsGet = db.UserAccountRecord.Any(m => m.QueryCount == PosId && m.ChangeType == 121);
  47. }
  48. if(!IsGet)
  49. {
  50. int OpId = 0;
  51. int UserId = pos.BuyUserId;
  52. while(UserId > 0)
  53. {
  54. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  55. OpModels.SysAdmin sys = spdb.SysAdmin.FirstOrDefault(m => m.UserId == user.Id) ?? new OpModels.SysAdmin();
  56. if(user.UserType >= 1 && sys.ExpireDate > DateTime.Now)
  57. {
  58. OpId = user.Id;
  59. UserId = 0;
  60. }
  61. else
  62. {
  63. UserId = user.ParentUserId;
  64. }
  65. }
  66. if(OpId > 0)
  67. {
  68. decimal ChangeAmount = 5;
  69. if(pos.BrandId == 14)
  70. {
  71. ChangeAmount = 19 * 0.05M;
  72. }
  73. if(pos.BrandId == 23 || pos.BrandId == 24 || pos.BrandId == 25 || pos.BrandId == 26)
  74. {
  75. PxcModels.WifiTradeRecord trade = db.WifiTradeRecord.FirstOrDefault(m => m.SnNo == pos.PosSn);
  76. if (trade != null)
  77. {
  78. ChangeAmount = trade.TradeAmount * 0.005M;
  79. ChangeAmount = PublicFunction.NumberFormat(ChangeAmount);
  80. }
  81. else
  82. {
  83. ChangeAmount = 0;
  84. }
  85. }
  86. if(ChangeAmount > 0)
  87. {
  88. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == OpId);
  89. if (account == null)
  90. {
  91. account = db.UserAccount.Add(new UserAccount()
  92. {
  93. Id = OpId,
  94. UserId = OpId,
  95. }).Entity;
  96. db.SaveChanges();
  97. }
  98. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  99. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  100. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  101. account.BalanceAmount += ChangeAmount;
  102. account.TotalAmount += ChangeAmount;
  103. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  104. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  105. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  106. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  107. {
  108. CreateDate = DateTime.Now,
  109. UpdateDate = DateTime.Now,
  110. UserId = OpId, //创客
  111. ProductType = pos.BrandId, //品牌
  112. ChangeType = 121, //变动类型
  113. ChangeAmount = ChangeAmount, //变更金额
  114. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  115. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  116. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  117. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  118. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  119. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  120. QueryCount = PosId,
  121. Kind = 3,
  122. }).Entity;
  123. db.SaveChanges();
  124. //发送APP推送消息
  125. Utils.Instance.PrizePush(OpId, ChangeAmount);
  126. }
  127. }
  128. }
  129. }
  130. db.Dispose();
  131. spdb.Dispose();
  132. }
  133. catch (Exception ex)
  134. {
  135. function.WriteLog(DateTime.Now.ToString() + "\r\n" + ex.ToString(), "运营中心奖励异常");
  136. }
  137. Thread.Sleep(100);
  138. }
  139. else
  140. {
  141. Thread.Sleep(60000);
  142. }
  143. }
  144. }
  145. }
  146. }