SycnSpActiveService.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using MySystem.SpModels;
  5. using Library;
  6. using LitJson;
  7. using System.Threading;
  8. namespace MySystem
  9. {
  10. public class SycnSpActiveService
  11. {
  12. public readonly static SycnSpActiveService Instance = new SycnSpActiveService();
  13. private SycnSpActiveService()
  14. { }
  15. public void Start()
  16. {
  17. Thread th = new Thread(StartDo);
  18. th.IsBackground = true;
  19. th.Start();
  20. }
  21. public void StartDo()
  22. {
  23. while (true)
  24. {
  25. try
  26. {
  27. WebCMSEntities spdb = new WebCMSEntities();
  28. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  29. MpMainModels2.WebCMSEntities mpdb = new MpMainModels2.WebCMSEntities();
  30. string Month = DateTime.Now.ToString("yyyyMM");
  31. string Date = DateTime.Now.ToString("yyyyMMdd");
  32. DateTime start = DateTime.Now.AddDays(-5);
  33. DateTime end = DateTime.Now.AddMinutes(-1);
  34. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/ActivateRecordId.txt")));
  35. IQueryable<ActivateRecord> acts = spdb.ActivateRecord.Where(m => m.Id >= StartId && m.CreateDate >= start && m.CreateDate < end && m.Status == 1).OrderByDescending(m => m.Id);
  36. foreach (ActivateRecord act in acts.ToList())
  37. {
  38. // PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == act.MerNo) ?? new PxcModels.MachineForMerNo();
  39. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == act.SnNo);
  40. if (pos != null)
  41. {
  42. if(pos.BrandId == 18 || pos.BrandId == 19 || pos.BrandId == 20 || pos.BrandId == 21)
  43. {
  44. pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == act.SnNo);
  45. }
  46. }
  47. if (pos != null)
  48. {
  49. PxcModels.KqProducts kqproduct = db.KqProducts.FirstOrDefault(m => m.Id == pos.BrandId) ?? new PxcModels.KqProducts();
  50. if (kqproduct.SingleDepositApi == 1)
  51. {
  52. if(string.IsNullOrEmpty(pos.SeoKeyword) && decimal.Parse(function.CheckNum(act.SeoTitle)) > 0) Utils.Instance.SendActData(pos);
  53. pos.SeoKeyword = act.SeoTitle;
  54. decimal Deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  55. if(Deposit > 1000) Deposit = Deposit / 100;
  56. pos.PrizeParams = Deposit.ToString("f0");
  57. if(pos.BrandId == 15 || pos.BrandId == 16) //来客吧
  58. {
  59. pos.Detail = ""; //清除激活奖励标记
  60. RedisDbconn.Instance.AddList("OpenRewardQueue", pos.Id.ToString()); //发开机奖励
  61. }
  62. db.SaveChanges();
  63. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  64. if(pos.BrandId < 18 || pos.BrandId > 21) //来客吧
  65. {
  66. StatService.Instance.PreActPrize(db, pos, merchant, act.SeoTitle);
  67. }
  68. }
  69. if(pos.BrandId == 7 || pos.BrandId == 12 || pos.BrandId == 13 || pos.BrandId == 15 || pos.BrandId == 16 || pos.BrandId == 22)
  70. {
  71. decimal CheckMoney = kqproduct.ActTradeAmount > 0 ? kqproduct.ActTradeAmount : 1000;
  72. int CheckDays = 30;
  73. SycnSpTradeService.Instance.ActPos(db, pos, CheckMoney, CheckDays);
  74. if(pos.ActivationState == 1)
  75. {
  76. decimal Deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  77. DateTime now = DateTime.Now;
  78. if(Deposit > 1000) Deposit = Deposit / 100;
  79. pos.PrizeParams = Deposit.ToString("f0");
  80. function.WriteLog("大盟主---Deposit:" + Deposit + ";LeaderUserId:" + pos.LeaderUserId + ";pos.IsFirst:" + pos.IsFirst + ";pos.BindingTime:" + pos.BindingTime + ";now.AddDays(-CheckDays):" + now.AddDays(-CheckDays) + ";", "押金推送发放奖励监控");
  81. if (Deposit > 0 && pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100)
  82. {
  83. function.WriteLog("大盟主奖发放", "押金推送发放奖励监控");
  84. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  85. }
  86. //发放运营中心奖励
  87. if (Deposit > 0 && pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100)
  88. {
  89. function.WriteLog("运营中心奖发放", "押金推送发放奖励监控");
  90. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  91. }
  92. }
  93. }
  94. if(pos.BrandId == 18 || pos.BrandId == 19 || pos.BrandId == 20 || pos.BrandId == 21)
  95. {
  96. int CheckDays = 30;
  97. DateTime now = DateTime.Now;
  98. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  99. if(pos.BindingTime > now.AddDays(-CheckDays))
  100. {
  101. pos.PrizeParams = pos.SeoKeyword;
  102. decimal Deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  103. MpMainModels2.MerchantAddInfo merchantAddInfo = mpdb.MerchantAddInfo.FirstOrDefault(m => m.MchtNo == merchant.KqMerNo) ?? new MpMainModels2.MerchantAddInfo();
  104. decimal Prize = 0;
  105. if(pos.BindingTime > DateTime.Parse("2024-07-02 00:00:00"))
  106. {
  107. if(Deposit == 198)
  108. {
  109. if(merchantAddInfo.SubjectType == "SUBJECT_TYPE_SMALL")
  110. {
  111. Prize = 0;
  112. }
  113. else
  114. {
  115. Prize = 120;
  116. }
  117. }
  118. else if(Deposit == 249)
  119. {
  120. if(merchantAddInfo.SubjectType == "SUBJECT_TYPE_SMALL")
  121. {
  122. Prize = 50;
  123. }
  124. else
  125. {
  126. Prize = 150;
  127. }
  128. }
  129. else if(Deposit == 228)
  130. {
  131. if(merchantAddInfo.SubjectType == "SUBJECT_TYPE_SMALL")
  132. {
  133. Prize = 0;
  134. }
  135. else
  136. {
  137. Prize = 110;
  138. }
  139. }
  140. else if(Deposit == 380)
  141. {
  142. if(merchantAddInfo.SubjectType == "SUBJECT_TYPE_SMALL")
  143. {
  144. Prize = 100;
  145. }
  146. else
  147. {
  148. Prize = 200;
  149. }
  150. }
  151. else if(Deposit == 399)
  152. {
  153. if(merchantAddInfo.SubjectType == "SUBJECT_TYPE_SMALL")
  154. {
  155. Prize = 0;
  156. }
  157. else
  158. {
  159. Prize = 150;
  160. }
  161. }
  162. }
  163. else
  164. {
  165. if(Deposit == 198) Prize = 70;
  166. if(Deposit == 249) Prize = 100;
  167. if(Deposit == 228) Prize = 61;
  168. if(Deposit == 380) Prize = 151;
  169. if(Deposit == 399) Prize = 100;
  170. }
  171. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new PxcModels.Users();
  172. int TopUserId = 0;
  173. if (!string.IsNullOrEmpty(user.ParentNav))
  174. {
  175. TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  176. }
  177. pos.ActivationState = 1;
  178. pos.ActivationTime = now;
  179. merchant.ActiveStatus = 1;
  180. merchant.MerStandardDate = now;
  181. db.SaveChanges();
  182. if (Prize > 0)
  183. {
  184. StatService.Instance.doActiveReward(db, merchant, pos, pos.BuyUserId, user.ParentNav, TopUserId, Prize);
  185. }
  186. if (pos.CardType < 100)
  187. {
  188. RedisDbconn.Instance.AddList("OpenRewardQueue", pos.Id.ToString());
  189. }
  190. if (Deposit > 0 && pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.CardType < 100)
  191. {
  192. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  193. }
  194. //发放运营中心奖励
  195. if (Deposit > 0 && pos.CardType < 100)
  196. {
  197. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  198. }
  199. }
  200. else
  201. {
  202. pos.ActivationState = 1;
  203. pos.ActivationTime = now;
  204. merchant.ActiveStatus = 1;
  205. merchant.MerStandardDate = now;
  206. db.SaveChanges();
  207. }
  208. }
  209. ActivateRecord edit = spdb.ActivateRecord.FirstOrDefault(m => m.Id == act.Id);
  210. if (edit != null)
  211. {
  212. edit.Status = 2;
  213. }
  214. }
  215. pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == act.SnNo && m.ActivationState == 1);
  216. if (pos != null)
  217. {
  218. ActivateRecord edit = spdb.ActivateRecord.FirstOrDefault(m => m.Id == act.Id);
  219. if (edit != null)
  220. {
  221. edit.Status = 2;
  222. }
  223. }
  224. }
  225. spdb.SaveChanges();
  226. spdb.Dispose();
  227. db.SaveChanges();
  228. db.Dispose();
  229. mpdb.Dispose();
  230. }
  231. catch (Exception ex)
  232. {
  233. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP激活数据到MAIN异常");
  234. }
  235. Thread.Sleep(1000);
  236. }
  237. }
  238. }
  239. }