LeaderApplyCouponsHelper.cs 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. using System;
  2. using System.Threading;
  3. using System.Linq;
  4. using System.Data;
  5. using Library;
  6. using MySystem.Models;
  7. using LitJson;
  8. using System.Collections.Generic;
  9. namespace MySystem
  10. {
  11. public class LeaderApplyCouponsHelper
  12. {
  13. public readonly static LeaderApplyCouponsHelper Instance = new LeaderApplyCouponsHelper();
  14. private LeaderApplyCouponsHelper()
  15. {
  16. }
  17. public void Start()//启动
  18. {
  19. Thread thread = new Thread(doSomething);
  20. thread.IsBackground = true;
  21. thread.Start();
  22. }
  23. public void doSomething()
  24. {
  25. while (true)
  26. {
  27. string content = RedisDbconn.Instance.RPop<string>("LeaderApplyCouponsQueue");
  28. if (!string.IsNullOrEmpty(content))
  29. {
  30. try
  31. {
  32. var Id = int.Parse(content);
  33. WebCMSEntities db = new WebCMSEntities();
  34. var LeaderUserId = 0;
  35. var queryList = db.LeaderReserveRecord.FirstOrDefault(m => m.Id == Id) ?? new LeaderReserveRecord();
  36. var userInfo = db.Users.FirstOrDefault(m => m.Id == queryList.UserId) ?? new Users();
  37. if (userInfo.LeaderLevel == 2)
  38. {
  39. LeaderUserId = queryList.UserId;
  40. }
  41. else
  42. {
  43. string[] ParentNavList = userInfo.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  44. for (int j = ParentNavList.Length; j > 0; j--)
  45. {
  46. int userId = int.Parse(ParentNavList[j - 1]);
  47. var user = db.Users.FirstOrDefault(m => m.Id == userId) ?? new Users();
  48. //如果是小盟主,则查找该小盟主关联的大盟主储蓄金是否充足,是则给券打上关联大盟主标记
  49. if(user.LeaderLevel == 1)
  50. {
  51. // LeaderAccountRecord leaderItem = db.LeaderAccountRecord.FirstOrDefault(m => m.Sort == user.Id && m.LeaderId > 0 && m.LeaderReserve >= 400 * pro.ProductCount);
  52. // if(leaderItem != null)
  53. // {
  54. // leaderItem.LeaderReserve -= 400 * pro.ProductCount;
  55. // foreach(int couponId in couponIds)
  56. // {
  57. // PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  58. // if(coupon != null)
  59. // {
  60. // coupon.LeaderUserId = leaderItem.LeaderId;
  61. // }
  62. // }
  63. // db.SaveChanges();
  64. // bigLeaderPrize = true;
  65. // }
  66. }
  67. if (user.LeaderLevel == 2)
  68. {
  69. LeaderUserId = userId;
  70. break;
  71. }
  72. else
  73. {
  74. continue;
  75. }
  76. }
  77. }
  78. JsonData ApplyList = JsonMapper.ToObject(queryList.SeoTitle);
  79. var SnList = "";
  80. for (int i = 0; i < ApplyList.Count; i++)
  81. {
  82. int num = Convert.ToInt32(ApplyList[i]["Num"].ToString());
  83. int type = Convert.ToInt32(ApplyList[i]["Type"].ToString());
  84. //电签
  85. if (type == 1)
  86. {
  87. var dposCoupons = db.PosCoupons.Where(m => m.QueryCount == 1 && m.UserId == 0 && m.LeaderUserId == 0 && m.IsUse == 0 && m.IsLock == 0 && m.OpId == 0).Take(num).ToList();//电签券
  88. foreach (var item in dposCoupons)
  89. {
  90. var posCoupon = db.PosCoupons.FirstOrDefault(m => m.Id == item.Id) ?? new PosCoupons();
  91. posCoupon.UserId = queryList.UserId;
  92. posCoupon.LeaderUserId = LeaderUserId;
  93. // SnList += posCoupon.ExchangeCode + ",";
  94. db.UserSnDelayChange.Add(new UserSnDelayChange()
  95. {
  96. CreateDate = DateTime.Now,
  97. QueryCount = Id,
  98. SnNo = posCoupon.ExchangeCode,
  99. });
  100. }
  101. }
  102. //大机
  103. if (type == 2)
  104. {
  105. var bposCoupons = db.PosCoupons.Where(m => m.QueryCount == 2 && m.UserId == 0 && m.LeaderUserId == 0 && m.IsUse == 0 && m.IsLock == 0 && m.OpId == 0).Take(num).ToList();//大机券
  106. foreach (var items in bposCoupons)
  107. {
  108. var posCoupon = db.PosCoupons.FirstOrDefault(m => m.Id == items.Id) ?? new PosCoupons();
  109. posCoupon.UserId = queryList.UserId;
  110. posCoupon.LeaderUserId = LeaderUserId;
  111. // SnList += posCoupon.ExchangeCode + ",";
  112. db.UserSnDelayChange.Add(new UserSnDelayChange()
  113. {
  114. CreateDate = DateTime.Now,
  115. QueryCount = Id,
  116. SnNo = posCoupon.ExchangeCode,
  117. });
  118. }
  119. }
  120. db.SaveChanges();
  121. }
  122. // queryList.SeoDescription = SnList.TrimEnd(',');
  123. db.SaveChanges();
  124. }
  125. catch (Exception ex)
  126. {
  127. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "盟主兑换机具券异常");
  128. }
  129. }
  130. else
  131. {
  132. Thread.Sleep(5000);
  133. }
  134. }
  135. }
  136. }
  137. }