SycnSpTradeService.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  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 SycnSpTradeService
  11. {
  12. public readonly static SycnSpTradeService Instance = new SycnSpTradeService();
  13. private SycnSpTradeService()
  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. WebCMSEntities spdb = new WebCMSEntities();
  28. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  29. DateTime start = DateTime.Now.AddDays(-30);
  30. IQueryable<TradeRecord> trades = spdb.TradeRecord;
  31. trades = trades.Where(m => m.CreateDate >= start && m.Status == 1);
  32. trades = trades.OrderBy(m => m.CreateDate);
  33. foreach (TradeRecord trade in trades.ToList())
  34. {
  35. bool op = true;
  36. if (trade.SerEntryMode == "N")
  37. {
  38. if (trade.TradeAmount == 9900 || trade.TradeAmount == 19900 || trade.TradeAmount == 29900)
  39. {
  40. op = false;
  41. PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == trade.MerNo) ?? new PxcModels.MachineForMerNo();
  42. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  43. if (pos != null)
  44. {
  45. if (trade.SerEntryMode == "N" && trade.ProductType == "1")
  46. {
  47. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  48. // pos.IsPurchase = 0;
  49. db.SaveChanges();
  50. }
  51. }
  52. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  53. if (edit != null)
  54. {
  55. edit.Status = 2;
  56. }
  57. spdb.SaveChanges();
  58. }
  59. }
  60. if (trade.DiscountRateFlag == "True")
  61. {
  62. op = false;
  63. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  64. if (edit != null)
  65. {
  66. edit.Status = 2;
  67. }
  68. spdb.SaveChanges();
  69. }
  70. if (op)
  71. {
  72. PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == trade.MerNo) ?? new PxcModels.MachineForMerNo();
  73. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  74. if (pos != null)
  75. {
  76. if (pos.BindMerchantId > 0)
  77. {
  78. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.UserId) ?? new PxcModels.Users();
  79. int TopUserId = 0;
  80. if (!string.IsNullOrEmpty(user.ParentNav))
  81. {
  82. TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  83. }
  84. // TODO: 交易记录表,每月的Id单独存放,解决查询效率问题
  85. bool check = db.TradeRecord.Any(m => m.Id >= 700000 && m.RecordNo == trade.TradeSerialNo);
  86. if (!check)
  87. {
  88. decimal TradeAmount = trade.TradeAmount;
  89. int BankCardType = -1;
  90. int QrPayFlag = 0;
  91. int VipFlag = 0;
  92. int PayType = 0;
  93. if (pos.BrandId == 1 || pos.BrandId == 3)
  94. {
  95. TradeAmount = TradeAmount / 100;
  96. BankCardType = int.Parse(trade.BankCardType);
  97. if (trade.TradeType == "02") QrPayFlag = 1;
  98. else if (trade.TradeType == "NQ") PayType = 1;
  99. if (trade.SettleMethod == "E") VipFlag = 1;
  100. }
  101. else if (pos.BrandId == 2)
  102. {
  103. if (trade.TradeType == "CREDIT_BY_CARD")
  104. {
  105. BankCardType = 1;
  106. }
  107. else if (trade.TradeType == "DEBIT_BY_CARD")
  108. {
  109. BankCardType = 0;
  110. }
  111. if (trade.TradeType == "CLOUD_PAY") QrPayFlag = 1;
  112. }
  113. else if (pos.BrandId == 4 || pos.BrandId == 5)
  114. {
  115. TradeAmount = TradeAmount / 100;
  116. if (trade.BankCardType == "100")
  117. {
  118. BankCardType = 1;
  119. }
  120. else if (trade.BankCardType == "200")
  121. {
  122. BankCardType = 0;
  123. }
  124. if (trade.TradeType == "200") QrPayFlag = 1;
  125. if (trade.Field1 == "1") VipFlag = 1;
  126. }
  127. else if (pos.BrandId == 6)
  128. {
  129. TradeAmount = TradeAmount / 100;
  130. if (trade.BankCardType == "01" || trade.BankCardType == "11")
  131. {
  132. BankCardType = 0;
  133. }
  134. else
  135. {
  136. BankCardType = 1;
  137. }
  138. }
  139. else if (pos.BrandId == 7)
  140. {
  141. TradeAmount = TradeAmount / 100;
  142. if (trade.BankCardType == "OA" || trade.BankCardType == "CC" || trade.BankCardType == "SCC")
  143. {
  144. BankCardType = 1;
  145. }
  146. else
  147. {
  148. BankCardType = 0;
  149. }
  150. }
  151. int BrandId = int.Parse(trade.ProductType);
  152. if (BrandId == 1 && trade.MerNo.StartsWith("M900"))
  153. {
  154. BrandId = 3;
  155. }
  156. if (BrandId == 4 && trade.DeviceType == "200")
  157. {
  158. BrandId = 5;
  159. }
  160. decimal SourceTradeAmount = TradeAmount;
  161. if (pos.Sort == 0 && pos.BrandId == 7)
  162. {
  163. decimal deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  164. if (deposit > 0)
  165. {
  166. TradeAmount -= deposit;
  167. pos.Sort = 1;
  168. }
  169. }
  170. if (TradeAmount > 0)
  171. {
  172. ulong MerHelpFlag = 0;
  173. decimal DepositAmt = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  174. if (DepositAmt > 0)
  175. {
  176. int Days = int.Parse(RedisDbconn.Instance.Get<string>("pobjrule:" + pos.BrandId + ":HelpPolicy:Days")); //天数
  177. if (pos.BindingTime != null)
  178. {
  179. if (pos.BindingTime.Value.AddDays(Days) > DateTime.Now)
  180. {
  181. MerHelpFlag = 1;
  182. }
  183. }
  184. }
  185. int CapFlag = 0;
  186. if(BankCardType == 0 && TradeAmount >= 1666.67M)
  187. {
  188. CapFlag = 1;
  189. }
  190. db.TradeRecord.Add(new PxcModels.TradeRecord()
  191. {
  192. CreateDate = trade.CreateDate,
  193. UpdateDate = trade.UpdateDate,
  194. RecordNo = trade.TradeSerialNo, //单号
  195. UserId = pos.UserId, //创客
  196. MerchantId = pos.BindMerchantId, //商户
  197. MerNo = trade.MerNo, //渠道商户编号
  198. MerHelpFlag = MerHelpFlag, //是否属于扶持周期内商户
  199. HelpMonthCount = 0, //扶持第几个月
  200. MerBuddyType = user.MerchantType, //商户创客类型
  201. SnNo = trade.TradeSnNo, //渠道SN号
  202. TradeSerialNo = trade.ChannelSerial, //交易流水号
  203. TradeAmount = TradeAmount, //交易金额
  204. BankCardType = BankCardType, //银行卡类型
  205. QrPayFlag = QrPayFlag, //云闪付标识
  206. CapFlag = CapFlag, //借记卡是否封顶
  207. VipFlag = VipFlag, //会员标记
  208. PayType = PayType, //支付方式
  209. BrandId = BrandId, //品牌
  210. Remark = trade.Remark, //备注
  211. TopUserId = TopUserId, //顶级创客
  212. MerUserId = pos.UserId, //商户直属创客
  213. ParentNav = user.ParentNav,
  214. });
  215. }
  216. decimal CheckMoney = 1000;
  217. int CheckDays = 30;
  218. if (pos.BrandId == 6)
  219. {
  220. CheckMoney = 5000;
  221. }
  222. if (BankCardType == 1 || (BankCardType == 2 && pos.BrandId == 1) || (BankCardType == 2 && pos.BrandId == 3))
  223. {
  224. pos.CreditTrade += SourceTradeAmount;
  225. }
  226. else if (BankCardType == 0)
  227. {
  228. pos.DebitCardTrade += TradeAmount;
  229. }
  230. // if (pos.CreditTrade < CheckMoney)
  231. // {
  232. // decimal deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  233. // if (deposit > 0 && pos.IsPurchase != 1)
  234. // {
  235. // pos.IsPurchase = 0;
  236. // }
  237. // }
  238. if (pos.CreditTrade >= CheckMoney && pos.ActivationState == 0 && pos.TransferTime < pos.BindingTime && pos.BindingTime > DateTime.Now.AddDays(-CheckDays))
  239. {
  240. // decimal deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  241. // if (deposit == 0 && pos.IsPurchase != 1)
  242. // {
  243. // pos.IsPurchase = 0;
  244. // }
  245. pos.ActivationState = 1;
  246. pos.ActivationTime = DateTime.Now;
  247. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  248. if (merchant != null)
  249. {
  250. merchant.ActiveStatus = 1;
  251. merchant.MerStandardDate = DateTime.Now;
  252. db.SaveChanges();
  253. RedisDbconn.Instance.Set("PosMerchantInfo:" + merchant.Id, merchant);
  254. }
  255. }
  256. // 立刷60天内刷满10000,再返40
  257. if (pos.BrandId == 6 && pos.ActivationState == 1 && pos.CreditTrade >= 10000 && pos.BindingTime > DateTime.Now.AddDays(-60))
  258. {
  259. // PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  260. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  261. if(merchant != null)
  262. {
  263. PxcModels.Users getUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new PxcModels.Users();
  264. int BuyTopUserId = 0;
  265. string ParentNav = getUser.ParentNav;
  266. if (!string.IsNullOrEmpty(ParentNav))
  267. {
  268. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  269. if (ParentNavList.Length > 1)
  270. {
  271. BuyTopUserId = int.Parse(ParentNavList[1]);
  272. }
  273. else if (ParentNavList.Length == 1)
  274. {
  275. BuyTopUserId = int.Parse(ParentNavList[0]);
  276. }
  277. }
  278. StatService.Instance.doActiveReward(db, merchant, pos, getUser.Id, getUser.ParentNav, BuyTopUserId, 40, 12);
  279. }
  280. }
  281. db.SaveChanges();
  282. }
  283. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  284. if (edit != null)
  285. {
  286. edit.Status = 2;
  287. }
  288. spdb.SaveChanges();
  289. }
  290. }
  291. }
  292. }
  293. spdb.Dispose();
  294. db.Dispose();
  295. }
  296. catch (Exception ex)
  297. {
  298. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP交易数据到MAIN异常");
  299. }
  300. Thread.Sleep(1000);
  301. }
  302. }
  303. public void StartTest()
  304. {
  305. DateTime today = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
  306. DateTime check = DateTime.Parse("2022-04-19");
  307. while (check <= today)
  308. {
  309. Thread th = new Thread(StartTestDo);
  310. th.IsBackground = true;
  311. th.Start(check.ToString("yyyy-MM-dd"));
  312. check = check.AddDays(1);
  313. }
  314. }
  315. public void StartTestDo(object sender)
  316. {
  317. string date = sender.ToString();
  318. DateTime start = DateTime.Parse(date);
  319. DateTime end = start.AddDays(1);
  320. try
  321. {
  322. WebCMSEntities spdb = new WebCMSEntities();
  323. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  324. IQueryable<TradeRecord> trades = spdb.TradeRecord;
  325. trades = trades.Where(m => m.CreateDate >= start && m.CreateDate < end);
  326. trades = trades.OrderBy(m => m.Id);
  327. foreach (TradeRecord trade in trades.ToList())
  328. {
  329. bool op = true;
  330. if (trade.SerEntryMode == "N")
  331. {
  332. if (trade.TradeAmount == 9900 || trade.TradeAmount == 19900 || trade.TradeAmount == 29900)
  333. {
  334. op = false;
  335. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  336. if (edit != null)
  337. {
  338. edit.Status = 2;
  339. }
  340. spdb.SaveChanges();
  341. }
  342. }
  343. if (trade.DiscountRateFlag == "True")
  344. {
  345. op = false;
  346. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  347. if (edit != null)
  348. {
  349. edit.Status = 2;
  350. }
  351. spdb.SaveChanges();
  352. }
  353. if (op)
  354. {
  355. PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == trade.MerNo) ?? new PxcModels.MachineForMerNo();
  356. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  357. if (pos != null)
  358. {
  359. if (pos.BindMerchantId > 0)
  360. {
  361. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.UserId) ?? new PxcModels.Users();
  362. int TopUserId = 0;
  363. if (!string.IsNullOrEmpty(user.ParentNav))
  364. {
  365. TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  366. }
  367. bool check = db.TradeRecord.Any(m => m.RecordNo == trade.TradeSerialNo);
  368. if (!check)
  369. {
  370. decimal TradeAmount = trade.TradeAmount;
  371. int BankCardType = -1;
  372. int QrPayFlag = 0;
  373. if (pos.BrandId == 1 || pos.BrandId == 3)
  374. {
  375. TradeAmount = TradeAmount / 100;
  376. BankCardType = int.Parse(trade.BankCardType);
  377. if (trade.TradeType == "02") QrPayFlag = 1;
  378. }
  379. else if (pos.BrandId == 2)
  380. {
  381. if (trade.TradeType == "CREDIT_BY_CARD")
  382. {
  383. BankCardType = 1;
  384. }
  385. else if (trade.TradeType == "DEBIT_BY_CARD")
  386. {
  387. BankCardType = 0;
  388. }
  389. if (trade.TradeType == "CLOUD_PAY") QrPayFlag = 1;
  390. }
  391. else if (pos.BrandId == 4 || pos.BrandId == 5)
  392. {
  393. TradeAmount = TradeAmount / 100;
  394. if (trade.BankCardType == "100")
  395. {
  396. BankCardType = 1;
  397. }
  398. else if (trade.BankCardType == "200")
  399. {
  400. BankCardType = 0;
  401. }
  402. if (trade.TradeType == "200") QrPayFlag = 1;
  403. }
  404. int BrandId = int.Parse(trade.ProductType);
  405. if (trade.MerNo.StartsWith("M900"))
  406. {
  407. BrandId = 3;
  408. }
  409. db.TradeRecord.Add(new PxcModels.TradeRecord()
  410. {
  411. CreateDate = trade.CreateDate,
  412. UpdateDate = trade.UpdateDate,
  413. RecordNo = trade.TradeSerialNo, //单号
  414. UserId = pos.UserId, //创客
  415. MerchantId = pos.BindMerchantId, //商户
  416. MerNo = trade.MerNo, //渠道商户编号
  417. MerHelpFlag = 0, //是否属于扶持周期内商户
  418. HelpMonthCount = 0, //扶持第几个月
  419. MerBuddyType = user.MerchantType, //商户创客类型
  420. SnNo = trade.TradeSnNo, //渠道SN号
  421. // TradeDate = DateTime.Parse(trade.TradeTime), //交易日期
  422. TradeSerialNo = trade.ChannelSerial, //交易流水号
  423. TradeAmount = TradeAmount, //交易金额
  424. BankCardType = BankCardType, //银行卡类型
  425. QrPayFlag = QrPayFlag, //云闪付标识
  426. BrandId = BrandId, //品牌
  427. Remark = trade.Remark, //备注
  428. TopUserId = TopUserId, //顶级创客
  429. MerUserId = pos.UserId, //商户直属创客
  430. });
  431. db.SaveChanges();
  432. }
  433. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  434. if (edit != null)
  435. {
  436. edit.Status = 2;
  437. }
  438. spdb.SaveChanges();
  439. }
  440. }
  441. }
  442. }
  443. spdb.Dispose();
  444. db.Dispose();
  445. }
  446. catch (Exception ex)
  447. {
  448. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP交易数据到MAIN异常");
  449. }
  450. }
  451. }
  452. }