AlipayPayBack2Service.cs 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using MySystem.PxcModels;
  5. using Library;
  6. using LitJson;
  7. namespace MySystem
  8. {
  9. public class AlipayPayBack2Service
  10. {
  11. public readonly static AlipayPayBack2Service Instance = new AlipayPayBack2Service();
  12. private AlipayPayBack2Service()
  13. { }
  14. public void Start(JobMqMsg jobInfo)
  15. {
  16. string content = "";
  17. try
  18. {
  19. dosomething();
  20. string Msg = "success";
  21. jobInfo.Status = Msg == "success" ? 1 : 0;
  22. jobInfo.Msg = Msg == "success" ? "执行完成" : Msg;
  23. RabbitMQClient.Instance.SendMsg(Newtonsoft.Json.JsonConvert.SerializeObject(jobInfo), "PublicBack");
  24. }
  25. catch (Exception ex)
  26. {
  27. if (!string.IsNullOrEmpty(content))
  28. {
  29. Dictionary<string, string> data = new Dictionary<string, string>();
  30. data.Add("ErrTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  31. data.Add("ErrMsg", ex.ToString());
  32. function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(data), "public_err");
  33. }
  34. else
  35. {
  36. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "public_service");
  37. }
  38. }
  39. }
  40. private void dosomething()
  41. {
  42. bool op = true;
  43. while (op)
  44. {
  45. string content = RedisDbconn.Instance.RPop<string>("PayCallBack2");
  46. if (!string.IsNullOrEmpty(content))
  47. {
  48. sloveAlipayCallBack(content);
  49. }
  50. else
  51. {
  52. op = false;
  53. }
  54. }
  55. }
  56. public void sloveAlipayCallBack(string content)
  57. {
  58. JsonData jsonObj = JsonMapper.ToObject(content);
  59. string OrderNo = jsonObj["out_trade_no"].ToString();
  60. string TradeNo = jsonObj["transaction_id"].ToString();
  61. decimal TotalFee = decimal.Parse(function.CheckNum(jsonObj["total_fee"].ToString()));
  62. WebCMSEntities db = new WebCMSEntities();
  63. OrderForNo forNo = db.OrderForNo.FirstOrDefault(m => m.OrderNo == OrderNo);
  64. if (forNo != null)
  65. {
  66. string[] ids = forNo.OrderIds.Split(',');
  67. foreach (string idString in ids)
  68. {
  69. int OrderId = int.Parse(idString);
  70. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId && m.Status == 0);
  71. if (order != null)
  72. {
  73. order.Status = 1;
  74. order.PayDate = DateTime.Now;
  75. order.PayStatus = 1;
  76. db.SaveChanges();
  77. RedisDbconn.Instance.Set("Orders:" + order.Id, order);
  78. OrderProduct pro = db.OrderProduct.FirstOrDefault(m => m.OrderId == OrderId);
  79. if (pro != null)
  80. {
  81. KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Sort == pro.ProductId);
  82. if (brand != null)
  83. {
  84. order.Status = 2;
  85. db.SaveChanges();
  86. int BuyCount = pro.ProductCount;
  87. int Kind = 0;
  88. if(pro.ProductPrice == 200) Kind = 1;
  89. if(pro.ProductPrice == 300) Kind = 2;
  90. string Codes = "";
  91. var coupons = db.PosCoupons.Where(m => m.IsLock == 0 && m.IsUse == 0 && m.UserId == 0 && m.QueryCount == Kind).OrderBy(m => m.Id).Take(BuyCount).ToList();
  92. foreach (var coupon in coupons)
  93. {
  94. PosCoupons item = db.PosCoupons.FirstOrDefault(m => m.Id == coupon.Id);
  95. if (item != null)
  96. {
  97. item.CreateDate = DateTime.Now;
  98. item.UserId = order.UserId;
  99. item.UpdateDate = DateTime.Now.AddDays(180);
  100. Codes += item.ExchangeCode + ",";
  101. }
  102. }
  103. order.SnNos = Codes.TrimEnd(',');
  104. string ChangeRecordNo = "SC" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8);
  105. PosCouponForUser forUser = db.PosCouponForUser.FirstOrDefault(m => m.Id == order.UserId);
  106. if (forUser == null)
  107. {
  108. forUser = db.PosCouponForUser.Add(new PosCouponForUser()
  109. {
  110. Id = order.UserId,
  111. }).Entity;
  112. db.SaveChanges();
  113. }
  114. int BeforeOut = forUser.OutNum;
  115. int BeforeTotal = forUser.TotalNum;
  116. int BeforeStock = forUser.StockNum;
  117. forUser.OutNum += BuyCount;
  118. forUser.StockNum -= BuyCount;
  119. int AfterOut = forUser.OutNum;
  120. int AfterTotal = forUser.TotalNum;
  121. int AfterStock = forUser.StockNum;
  122. PosCouponOrders stat = db.PosCouponOrders.Add(new PosCouponOrders()
  123. {
  124. QueryCount = Kind,
  125. CreateDate = DateTime.Now,
  126. ChangeKind = 2,
  127. ChangeCount = BuyCount,
  128. AfterOut = AfterOut,
  129. AfterTotal = AfterTotal,
  130. AfterStock = AfterStock,
  131. BeforeOut = BeforeOut,
  132. BeforeTotal = BeforeTotal,
  133. BeforeStock = BeforeStock,
  134. OrderNo = ChangeRecordNo,
  135. ToUserId = order.UserId,
  136. FromUserId = 0,
  137. }).Entity;
  138. db.SaveChanges();
  139. RedisDbconn.Instance.Clear("Orders:" + order.Id);
  140. }
  141. }
  142. }
  143. }
  144. }
  145. db.Dispose();
  146. }
  147. }
  148. }