SycnSpActiveService.cs 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  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. if (Utils.PushTimeCheck())
  28. {
  29. List<string> SaveDataBindIds = Utils.Instance.SaveDataBindIds();
  30. SaveDataBindIds.Add("36");
  31. WebCMSEntities spdb = new WebCMSEntities();
  32. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  33. MpMainModels2.WebCMSEntities mpdb = new MpMainModels2.WebCMSEntities();
  34. JavaProductModels.WebCMSEntities javaprodb = new JavaProductModels.WebCMSEntities();
  35. string Month = DateTime.Now.ToString("yyyyMM");
  36. string Date = DateTime.Now.ToString("yyyyMMdd");
  37. DateTime start = DateTime.Now.AddDays(-30);
  38. DateTime end = DateTime.Now.AddMinutes(-1);
  39. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/ActivateRecordId.txt")));
  40. IQueryable<ActivateRecord> acts = spdb.ActivateRecord.Where(m => m.Id >= StartId && m.CreateDate >= start && m.CreateDate < end && SaveDataBindIds.Contains(m.ProductType) && m.Status == 1).OrderByDescending(m => m.Id).Take(20);
  41. foreach (ActivateRecord act in acts.ToList())
  42. {
  43. PosPushDataNewHelper.Deposit(act);
  44. decimal PrizeAmt = decimal.Parse(function.CheckNum(act.Field3));
  45. if (Utils.Instance.IsHaoDa(int.Parse(function.CheckInt(act.ProductType))) && PrizeAmt > 0)
  46. {
  47. string PrizeKind = act.SeoKeyword;
  48. if ((
  49. PrizeKind == "830_01" ||
  50. PrizeKind == "830_21" ||
  51. PrizeKind == "830_22" ||
  52. PrizeKind == "833_01" ||
  53. PrizeKind == "833_02" ||
  54. PrizeKind == "833_11" ||
  55. PrizeKind == "833_12" ||
  56. PrizeKind == "836_01" ||
  57. PrizeKind == "836_02" ||
  58. PrizeKind == "836_11" ||
  59. PrizeKind == "836_12" ||
  60. PrizeKind == "972" ||
  61. PrizeKind == "972_01" ||
  62. PrizeKind == "985" ||
  63. PrizeKind == "987" ||
  64. PrizeKind == "990" ||
  65. PrizeKind == "993" ||
  66. PrizeKind == "995_21" ||
  67. PrizeKind == "995_22" ||
  68. PrizeKind == "995"
  69. ) && PrizeAmt > 0)
  70. {
  71. JavaProductModels.KxsMachine pos = javaprodb.KxsMachine.FirstOrDefault(m => m.PosSn == act.SnNo && m.UserId > 0);
  72. if (pos != null)
  73. {
  74. Dictionary<string, object> prizeData = new Dictionary<string, object>();
  75. prizeData.Add("brand_id", int.Parse(function.CheckInt(act.ProductType)));
  76. prizeData.Add("ext_field", PrizeKind);
  77. prizeData.Add("pos_sn", act.SnNo);
  78. prizeData.Add("user_id", pos.UserId);
  79. prizeData.Add("prize", PrizeAmt);
  80. string req = Newtonsoft.Json.JsonConvert.SerializeObject(prizeData);
  81. string ids = PrizeKind == "833_02" ? "82" : "81,85,86,87";
  82. function.GetWebRequest("http://logic-executor-api.kexiaoshuang.com/noauth/prize/pushbyone?n=QUEUE_KXS_HAODA_PRIZE_CONFIG_DIVISION&m=" + req + "&ids=" + ids + ",83");
  83. }
  84. }
  85. // JavaProductModels.KxsMachine pos = javaprodb.KxsMachine.FirstOrDefault(m => m.PosSn == act.SnNo && m.UserId > 0);
  86. // if(pos != null)
  87. // {
  88. // RedisDbconn.Instance.AddList("HaoDaPrizeDataQueue", "{\"brand_id\":36,\"ext_field\":\"" + act.Field3 + "\",\"pos_sn\":\"" + act.SnNo + "\",\"user_id\":" + pos.UserId + "}");
  89. // }
  90. }
  91. ActivateRecord edit = spdb.ActivateRecord.FirstOrDefault(m => m.Id == act.Id);
  92. if (edit != null)
  93. {
  94. edit.Status = 2;
  95. }
  96. }
  97. spdb.SaveChanges();
  98. spdb.Dispose();
  99. db.SaveChanges();
  100. db.Dispose();
  101. mpdb.Dispose();
  102. javaprodb.Dispose();
  103. }
  104. }
  105. catch (Exception ex)
  106. {
  107. Utils.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP激活数据到MAIN异常");
  108. }
  109. Thread.Sleep(1000);
  110. }
  111. }
  112. }
  113. }