SycnSpActiveService.cs 5.5 KB

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