CheckWeChatSignService.cs 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using MySystem.Models;
  5. using Library;
  6. using LitJson;
  7. namespace MySystem
  8. {
  9. public class CheckWeChatSignService
  10. {
  11. public readonly static CheckWeChatSignService Instance = new CheckWeChatSignService();
  12. private CheckWeChatSignService()
  13. { }
  14. public void Start(JobMqMsg jobInfo)
  15. {
  16. try
  17. {
  18. WebCMSEntities db = new WebCMSEntities();
  19. List<MerchantSign> deletes = new List<MerchantSign>();
  20. List<MerchantSign> signs = TendisDbconn.Instance.GetList<MerchantSign>("WeChatSignList", 1, 10000000);
  21. foreach (MerchantSign sign in signs)
  22. {
  23. Dictionary<string, object> dic = new WeChatFunction().QueryMerchant(sign.BusinessCode);
  24. if (dic["applyment_state"].ToString() == "APPLYMENT_STATE_TO_BE_SIGNED")
  25. {
  26. string sign_url = dic["sign_url"].ToString();
  27. string sub_mchid = dic["sub_mchid"].ToString();
  28. MerchantAddInfo merchantadd = db.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.Status == 0);
  29. if (merchantadd != null)
  30. {
  31. merchantadd.Status = 1;
  32. merchantadd.SubMchid = sub_mchid;
  33. string SignUrlList = function.CheckNull(merchantadd.SeoKeyword);
  34. if (string.IsNullOrEmpty(SignUrlList))
  35. {
  36. SignUrlList = "WeChat:" + sign_url + ";";
  37. }
  38. else
  39. {
  40. SignUrlList += "WeChat:" + sign_url+ ";";
  41. }
  42. merchantadd.SeoKeyword = SignUrlList;
  43. db.SaveChanges();
  44. PxcModels.WebCMSEntities dbpxc = new PxcModels.WebCMSEntities();
  45. PxcModels.MerchantAddInfo merchantadd2 = dbpxc.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.Status == 0);
  46. if (merchantadd2 != null)
  47. {
  48. merchantadd2.Status = 1;
  49. merchantadd2.SeoKeyword = SignUrlList;
  50. dbpxc.SaveChanges();
  51. }
  52. dbpxc.Dispose();
  53. BothdisDbconn.Instance.Set("MerchantAddInfo:" + sign.MerchantAddInfoId, merchantadd);
  54. }
  55. }
  56. else if (dic["applyment_state"].ToString() == "APPLYMENT_STATE_FINISHED")
  57. {
  58. MerchantAddInfo merchantadd = db.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.Status == 1);
  59. if (merchantadd != null)
  60. {
  61. merchantadd.Status = 2;
  62. db.SaveChanges();
  63. PxcModels.WebCMSEntities dbpxc = new PxcModels.WebCMSEntities();
  64. PxcModels.MerchantAddInfo merchantadd2 = dbpxc.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.Status == 1);
  65. if (merchantadd2 != null)
  66. {
  67. merchantadd2.Status = 2;
  68. dbpxc.SaveChanges();
  69. }
  70. dbpxc.Dispose();
  71. BothdisDbconn.Instance.Set("MerchantAddInfo:" + sign.MerchantAddInfoId, merchantadd);
  72. MerchantInfo merchant = db.MerchantInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId);
  73. List<MerchantInfo> merchants = RedisDbconn.Instance.GetList<MerchantInfo>("TmpMerchantInfo:" + merchant.UserId, 1, 1000000);
  74. MerchantInfo check = merchants.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId);
  75. if (check != null)
  76. {
  77. merchants.Remove(check);
  78. RedisDbconn.Instance.Clear("TmpMerchantInfo:" + merchant.UserId);
  79. RedisDbconn.Instance.AddList("TmpMerchantInfo:" + merchant.UserId, merchants.ToArray());
  80. }
  81. deletes.Add(sign);
  82. }
  83. }
  84. }
  85. if (deletes.Count > 0)
  86. {
  87. foreach (MerchantSign delete in deletes)
  88. {
  89. signs.Remove(delete);
  90. }
  91. TendisDbconn.Instance.Clear("WeChatSignList");
  92. TendisDbconn.Instance.AddList("WeChatSignList", signs.ToArray());
  93. }
  94. jobInfo.Status = 1;
  95. jobInfo.Msg = "执行完成";
  96. RabbitMQClient.Instance.SendMsg(Newtonsoft.Json.JsonConvert.SerializeObject(jobInfo), "PublicBack");
  97. }
  98. catch (Exception ex)
  99. {
  100. TendisDbconn.Instance.AddList("public:merchant:signerr", DateTime.Now.ToString() + ":" + ex.ToString());
  101. }
  102. }
  103. }
  104. }