CheckAlipaySignService.cs 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  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 CheckAlipaySignService
  10. {
  11. public readonly static CheckAlipaySignService Instance = new CheckAlipaySignService();
  12. private CheckAlipaySignService()
  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>("AliaySignList", 1, 10000000);
  21. foreach (MerchantSign sign in signs)
  22. {
  23. string content = new AlipayFunction().CommonSignConfirm(sign.BusinessCode);
  24. JsonData dic = JsonMapper.ToObject(content);
  25. if (dic["alipay_open_agent_order_query_response"]["code"].ToString() == "10000")
  26. {
  27. if (dic["alipay_open_agent_order_query_response"]["order_status"].ToString() == "MERCHANT_CONFIRM")
  28. {
  29. string sign_url = dic["alipay_open_agent_order_query_response"]["confirm_url"].ToString();
  30. MerchantAddInfo merchantadd = db.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.QueryCount == 0);
  31. if (merchantadd != null)
  32. {
  33. merchantadd.QueryCount = 1;
  34. string SignUrlList = function.CheckNull(merchantadd.SeoKeyword);
  35. if (string.IsNullOrEmpty(SignUrlList))
  36. {
  37. SignUrlList = "Alipay:" + sign_url + ";";
  38. }
  39. else
  40. {
  41. SignUrlList = "Alipay:" + sign_url+ ";" + SignUrlList;
  42. }
  43. merchantadd.SeoKeyword = SignUrlList;
  44. db.SaveChanges();
  45. PxcModels.WebCMSEntities dbpxc = new PxcModels.WebCMSEntities();
  46. PxcModels.MerchantAddInfo merchantadd2 = dbpxc.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.QueryCount == 0);
  47. if (merchantadd2 != null)
  48. {
  49. merchantadd2.QueryCount = 1;
  50. merchantadd2.SeoKeyword = SignUrlList;
  51. dbpxc.SaveChanges();
  52. }
  53. dbpxc.Dispose();
  54. BothdisDbconn.Instance.Set("MerchantAddInfo:" + sign.MerchantAddInfoId, merchantadd);
  55. }
  56. }
  57. else if (dic["alipay_open_agent_order_query_response"]["order_status"].ToString() == "MERCHANT_CONFIRM_SUCCESS")
  58. {
  59. MerchantAddInfo merchantadd = db.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.QueryCount == 1);
  60. if (merchantadd != null)
  61. {
  62. merchantadd.QueryCount = 2;
  63. db.SaveChanges();
  64. PxcModels.WebCMSEntities dbpxc = new PxcModels.WebCMSEntities();
  65. PxcModels.MerchantAddInfo merchantadd2 = dbpxc.MerchantAddInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId && m.QueryCount == 1);
  66. if (merchantadd2 != null)
  67. {
  68. merchantadd2.QueryCount = 2;
  69. dbpxc.SaveChanges();
  70. }
  71. dbpxc.Dispose();
  72. BothdisDbconn.Instance.Set("MerchantAddInfo:" + sign.MerchantAddInfoId, merchantadd);
  73. MerchantInfo merchant = db.MerchantInfo.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId);
  74. List<MerchantInfo> merchants = RedisDbconn.Instance.GetList<MerchantInfo>("TmpMerchantInfo:" + merchant.UserId, 1, 1000000);
  75. MerchantInfo check = merchants.FirstOrDefault(m => m.Id == sign.MerchantAddInfoId);
  76. if (check != null)
  77. {
  78. merchants.Remove(check);
  79. RedisDbconn.Instance.Clear("TmpMerchantInfo:" + merchant.UserId);
  80. RedisDbconn.Instance.AddList("TmpMerchantInfo:" + merchant.UserId, merchants.ToArray());
  81. }
  82. deletes.Add(sign);
  83. }
  84. }
  85. }
  86. }
  87. if (deletes.Count > 0)
  88. {
  89. foreach (MerchantSign delete in deletes)
  90. {
  91. signs.Remove(delete);
  92. }
  93. TendisDbconn.Instance.Clear("AliaySignList");
  94. TendisDbconn.Instance.AddList("AliaySignList", signs.ToArray());
  95. }
  96. jobInfo.Status = 1;
  97. jobInfo.Msg = "执行完成";
  98. RabbitMQClient.Instance.SendMsg(Newtonsoft.Json.JsonConvert.SerializeObject(jobInfo), "PublicBack");
  99. }
  100. catch (Exception ex)
  101. {
  102. TendisDbconn.Instance.AddList("public:merchant:signerr", DateTime.Now.ToString() + ":" + ex.ToString());
  103. }
  104. }
  105. }
  106. }