SycnSpTradeService.cs 71 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164
  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. List<string> BrandIds = new List<string>();
  28. BrandIds.Add("14");
  29. BrandIds.Add("17");
  30. BrandIds.Add("23");
  31. BrandIds.Add("24");
  32. BrandIds.Add("25");
  33. BrandIds.Add("26");
  34. WebCMSEntities spdb = new WebCMSEntities();
  35. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  36. DateTime start = DateTime.Now.AddDays(-10);
  37. DateTime end = DateTime.Now.AddMinutes(-3);
  38. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/TradeRecordId.txt")));
  39. IQueryable<TradeRecord> trades = spdb.TradeRecord.Where(m => m.Id >= StartId && !BrandIds.Contains(m.ProductType) && m.CreateDate >= start && m.Status == 1).OrderBy(m => m.CreateDate).Take(20);
  40. foreach (TradeRecord trade in trades.ToList())
  41. {
  42. string TradeSnNo = trade.TradeSnNo;
  43. bool op = true;
  44. bool isDeposit = false;
  45. //判断盒易付吱码交易
  46. if(trade.ProductType == "12" && trade.TradeType == "2")
  47. {
  48. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == trade.MerNo);
  49. if(merchant != null)
  50. {
  51. TradeSnNo = merchant.KqSnNo;
  52. }
  53. }
  54. if (trade.SerEntryMode == "N" && trade.ProductType == "1") //金控押金获取
  55. {
  56. if (trade.TradeAmount == 9900 || trade.TradeAmount == 19900 || trade.TradeAmount == 29900)
  57. {
  58. op = false;
  59. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  60. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  61. if (pos != null)
  62. {
  63. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  64. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  65. db.SaveChanges();
  66. isDeposit = true;
  67. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  68. }
  69. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  70. if (edit != null)
  71. {
  72. edit.Status = 2;
  73. }
  74. spdb.SaveChanges();
  75. PosPushDataNewHelper.Deposit(trade);
  76. }
  77. }
  78. else if (trade.SerEntryMode == "1" && trade.ProductType == "27") //金控押金获取
  79. {
  80. if (trade.TradeAmount == 9900 || trade.TradeAmount == 19900 || trade.TradeAmount == 29900)
  81. {
  82. op = false;
  83. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  84. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  85. if (pos != null)
  86. {
  87. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  88. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  89. db.SaveChanges();
  90. isDeposit = true;
  91. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  92. }
  93. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  94. if (edit != null)
  95. {
  96. edit.Status = 2;
  97. }
  98. spdb.SaveChanges();
  99. PosPushDataNewHelper.Deposit(trade);
  100. }
  101. }
  102. else if ((trade.ProductType == "4" || trade.ProductType == "8" || trade.ProductType == "9") && (trade.Field2 == "5200" || trade.Field2 == "5800")) //乐刷海科费率0.52,0.58的不入库
  103. {
  104. op = false;
  105. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  106. if (edit != null)
  107. {
  108. edit.Status = 2;
  109. }
  110. spdb.SaveChanges();
  111. }
  112. else if (trade.SerEntryMode == "1" && trade.ProductType == "10") //联动押金获取
  113. {
  114. if (trade.TradeAmount == 99 || trade.TradeAmount == 199 || trade.TradeAmount == 299)
  115. {
  116. op = false;
  117. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  118. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  119. if (pos != null)
  120. {
  121. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  122. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  123. db.SaveChanges();
  124. isDeposit = true;
  125. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  126. }
  127. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  128. if (edit != null)
  129. {
  130. edit.Status = 2;
  131. }
  132. spdb.SaveChanges();
  133. PosPushDataNewHelper.Deposit(trade);
  134. }
  135. }
  136. else if (trade.SerEntryMode == "40" && trade.ProductType == "12") //盒易付押金获取
  137. {
  138. if (trade.TradeAmount == 99 || trade.TradeAmount == 199 || trade.TradeAmount == 299)
  139. {
  140. op = false;
  141. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  142. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  143. if (pos != null)
  144. {
  145. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  146. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  147. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  148. db.MerchantDepositRecord.Add(new PxcModels.MerchantDepositRecord()
  149. {
  150. CreateDate = DateTime.Now,
  151. SnNo = pos.PosSn,
  152. MerNo = function.CheckNull(merchant.KqMerNo),
  153. DepositAmount = trade.TradeAmount,
  154. UserId = pos.BuyUserId,
  155. AgentNo = function.CheckNull(merchant.MgrNo),
  156. OrderId = DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8),
  157. });
  158. db.SaveChanges();
  159. isDeposit = true;
  160. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  161. }
  162. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  163. if (edit != null)
  164. {
  165. edit.Status = 2;
  166. }
  167. spdb.SaveChanges();
  168. PosPushDataNewHelper.Deposit(trade);
  169. }
  170. }
  171. else if (trade.TradeType == "40" && trade.ProductType == "15") //联客宝押金获取
  172. {
  173. if (trade.TradeAmount == 99 || trade.TradeAmount == 199 || trade.TradeAmount == 299)
  174. {
  175. op = false;
  176. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  177. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  178. if (pos != null)
  179. {
  180. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  181. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  182. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  183. db.MerchantDepositRecord.Add(new PxcModels.MerchantDepositRecord()
  184. {
  185. CreateDate = DateTime.Now,
  186. SnNo = pos.PosSn,
  187. MerNo = merchant.KqMerNo,
  188. DepositAmount = trade.TradeAmount,
  189. UserId = pos.BuyUserId,
  190. AgentNo = function.CheckNull(merchant.MgrNo),
  191. OrderId = DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8),
  192. });
  193. db.SaveChanges();
  194. isDeposit = true;
  195. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  196. }
  197. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  198. if (edit != null)
  199. {
  200. edit.Status = 2;
  201. }
  202. spdb.SaveChanges();
  203. PosPushDataNewHelper.Deposit(trade);
  204. }
  205. }
  206. else if (trade.SerEntryMode == "DEPOSIT" && trade.ProductType == "30") //拉卡拉押金获取
  207. {
  208. if (trade.TradeAmount == 9900 || trade.TradeAmount == 19900 || trade.TradeAmount == 29900)
  209. {
  210. op = false;
  211. PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new PxcModels.MachineForSnNo();
  212. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
  213. if (pos != null)
  214. {
  215. if(string.IsNullOrEmpty(pos.SeoKeyword)) Utils.Instance.SendActData(pos);
  216. pos.SeoKeyword = trade.TradeAmount.ToString("f2");
  217. db.SaveChanges();
  218. isDeposit = true;
  219. function.WriteLog("押金监控:" + trade.MerNo, "服务费奖励发放日志");
  220. }
  221. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  222. if (edit != null)
  223. {
  224. edit.Status = 2;
  225. }
  226. spdb.SaveChanges();
  227. if(trade.ProductType == "30")
  228. {
  229. PxcModels.LklMerNo mer = db.LklMerNo.FirstOrDefault(m => m.ExtMerNo == trade.MerNo);
  230. if(mer != null)
  231. {
  232. trade.MerNo = mer.MerNo;
  233. }
  234. }
  235. PosPushDataNewHelper.Deposit(trade);
  236. }
  237. }
  238. if (trade.DiscountRateFlag == "True")
  239. {
  240. op = false;
  241. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  242. if (edit != null)
  243. {
  244. edit.Status = 2;
  245. }
  246. spdb.SaveChanges();
  247. }
  248. if(trade.ProductType == "7" && trade.TradeStatus != "00")
  249. {
  250. op = false;
  251. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  252. if (edit != null)
  253. {
  254. edit.Status = 2;
  255. }
  256. spdb.SaveChanges();
  257. }
  258. if (op)
  259. {
  260. bool check = db.SpOrderNos.Any(m => m.OrderNo == trade.TradeSerialNo);
  261. if (!check)
  262. {
  263. if(trade.ProductType == "30")
  264. {
  265. trade.MerNo = trade.Field2;
  266. }
  267. PosPushDataNewHelper.Trade(trade);
  268. }
  269. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == TradeSnNo);
  270. if (pos != null)
  271. {
  272. PxcModels.KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Id == pos.BrandId) ?? new PxcModels.KqProducts();
  273. if (pos.BindMerchantId > 0)
  274. {
  275. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.UserId) ?? new PxcModels.Users();
  276. int TopUserId = 0;
  277. if (!string.IsNullOrEmpty(user.ParentNav))
  278. {
  279. TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  280. }
  281. if (!check)
  282. {
  283. decimal TradeAmount = trade.TradeAmount;
  284. int BankCardType = -1;
  285. int QrPayFlag = 0;
  286. int VipFlag = 0;
  287. int PayType = 0;
  288. if (pos.BrandId == 1 || pos.BrandId == 3)
  289. {
  290. TradeAmount = TradeAmount / 100;
  291. BankCardType = int.Parse(trade.BankCardType);
  292. if (trade.TradeType == "02") QrPayFlag = 1;
  293. else if (trade.TradeType == "NQ") PayType = 1;
  294. if (trade.SettleMethod == "E") VipFlag = 1;
  295. }
  296. else if (pos.BrandId == 2)
  297. {
  298. if (trade.TradeType == "CREDIT_BY_CARD")
  299. {
  300. BankCardType = 1;
  301. }
  302. else
  303. {
  304. BankCardType = 0;
  305. }
  306. if (trade.TradeType == "CLOUD_PAY") QrPayFlag = 1;
  307. }
  308. else if (pos.BrandId == 4 || pos.BrandId == 5)
  309. {
  310. TradeAmount = TradeAmount / 100;
  311. if (trade.BankCardType == "100")
  312. {
  313. BankCardType = 1;
  314. }
  315. else if (trade.BankCardType == "200")
  316. {
  317. BankCardType = 0;
  318. }
  319. if (trade.TradeType == "200") QrPayFlag = 1;
  320. if (trade.Field1 == "1") VipFlag = 1;
  321. }
  322. else if (pos.BrandId == 6 || pos.BrandId == 22)
  323. {
  324. TradeAmount = TradeAmount / 100;
  325. if (trade.BankCardType == "02" || trade.BankCardType == "12")
  326. {
  327. BankCardType = 1;
  328. }
  329. else
  330. {
  331. BankCardType = 0;
  332. }
  333. }
  334. else if (pos.BrandId == 7)
  335. {
  336. TradeAmount = TradeAmount / 100;
  337. if (trade.BankCardType == "OA" || trade.BankCardType == "CC" || trade.BankCardType == "SCC")
  338. {
  339. BankCardType = 1;
  340. }
  341. else
  342. {
  343. BankCardType = 0;
  344. }
  345. }
  346. else if (pos.BrandId == 8 || pos.BrandId == 9)
  347. {
  348. TradeAmount = TradeAmount / 100;
  349. if (trade.BankCardType == "100")
  350. {
  351. BankCardType = 1;
  352. }
  353. else if (trade.BankCardType == "200")
  354. {
  355. BankCardType = 0;
  356. }
  357. if (trade.TradeType == "200") QrPayFlag = 1;
  358. if (trade.Field1 == "1") VipFlag = 1;
  359. }
  360. else if (pos.BrandId == 10 || pos.BrandId == 11)
  361. {
  362. if (trade.BankCardType == "01")
  363. {
  364. BankCardType = 1;
  365. }
  366. else if (trade.BankCardType == "00")
  367. {
  368. BankCardType = 0;
  369. }
  370. if (trade.TradeType == "F010") QrPayFlag = 1;
  371. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  372. if(merchant != null)
  373. {
  374. bool flag = false;
  375. if(function.CheckNull(merchant.MerchantName).Contains("*")) merchant.MerchantName = trade.MerName;
  376. if(string.IsNullOrEmpty(merchant.MerIdcardNo) && !string.IsNullOrEmpty(trade.Field2))
  377. {
  378. merchant.MerIdcardNo = trade.Field2.ToUpper(); //商户身份证号
  379. flag = true;
  380. }
  381. if(!string.IsNullOrEmpty(trade.Field1))
  382. {
  383. merchant.MerchantMobile = trade.Field1; //商户手机号
  384. }
  385. if(flag)
  386. {
  387. string startNo = merchant.MerIdcardNo.Substring(0, 6);
  388. string endNo = merchant.MerIdcardNo.Substring(merchant.MerIdcardNo.Length - 4, 4).ToUpper();
  389. string Name = merchant.MerchantName;
  390. Name = Name.Replace("*", "");
  391. function.WriteLog(DateTime.Now.ToString() + "-----startNo:" + startNo + ",endNo:" + endNo + ",Name:" + Name, "监控机具是否互斥");
  392. PxcModels.PosMerchantInfo chk = db.PosMerchantInfo.FirstOrDefault(m => m.MerIdcardNo.StartsWith(startNo) && m.MerIdcardNo.EndsWith(endNo) && m.MerchantName.Contains(Name));
  393. if(chk != null)
  394. {
  395. function.WriteLog("互斥机具---sn:" + chk.KqSnNo + ",merno:" + chk.KqMerNo + ",name:" + chk.MerchantName, "监控机具是否互斥");
  396. pos.IsFirst = 0;
  397. }
  398. }
  399. db.SaveChanges();
  400. }
  401. }
  402. else if (pos.BrandId == 12 || pos.BrandId == 13) //盒易付
  403. {
  404. if (trade.BankCardType == "C")
  405. {
  406. BankCardType = 1;
  407. }
  408. else if (trade.BankCardType == "D")
  409. {
  410. BankCardType = 0;
  411. }
  412. if (trade.Field3 == "1") QrPayFlag = 1;
  413. }
  414. else if (pos.BrandId == 15 || pos.BrandId == 16) //联客宝
  415. {
  416. TradeAmount = TradeAmount / 100;
  417. // 支付类型
  418. // 01-内卡借记卡
  419. // 02-内卡贷记卡
  420. // 03-银联二维码
  421. // 11-外卡借记卡
  422. // 12-外卡贷记卡
  423. // 30-微信
  424. // 31-支付宝
  425. // M3-扫码(银联二维码、微信、支付宝)
  426. if (trade.BankCardType == "02")
  427. {
  428. BankCardType = 1;
  429. }
  430. else
  431. {
  432. BankCardType = 0;
  433. }
  434. // if (trade.SerEntryMode == "1") QrPayFlag = 1;
  435. }
  436. else if (pos.BrandId == 30 || pos.BrandId == 31) //拉卡拉
  437. {
  438. TradeAmount = TradeAmount / 100;
  439. if (trade.BankCardType == "01" || trade.BankCardType == "61")
  440. {
  441. BankCardType = 1;
  442. }
  443. else
  444. {
  445. BankCardType = 0;
  446. }
  447. // if (trade.SerEntryMode == "1") QrPayFlag = 1;
  448. }
  449. int BrandId = pos.BrandId;
  450. // int BrandId = int.Parse(trade.ProductType);
  451. // if (BrandId == 1 && trade.MerNo.StartsWith("M900"))
  452. // {
  453. // BrandId = 3;
  454. // }
  455. // if (BrandId == 4 && trade.DeviceType == "200")
  456. // {
  457. // BrandId = 5;
  458. // }
  459. decimal SourceTradeAmount = TradeAmount;
  460. if (pos.Sort == 0 && pos.BrandId == 7)
  461. {
  462. decimal deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  463. if (deposit > 0)
  464. {
  465. int SftStartId = RedisDbconn.Instance.Get<int>("SftTradeChkId");
  466. PxcModels.TradeRecord chk = db.TradeRecord.FirstOrDefault(m => m.Id > SftStartId && m.SnNo == pos.PosSn);
  467. if(chk == null)
  468. {
  469. TradeAmount -= deposit;
  470. }
  471. else
  472. {
  473. chk.TradeAmount -= deposit;
  474. }
  475. pos.Sort = 1;
  476. }
  477. }
  478. decimal CheckMoney = brand.ActTradeAmount > 0 ? brand.ActTradeAmount : 1000;
  479. int CheckDays = 30;
  480. //联动
  481. if(BankCardType == 1 && trade.TradeType == "M015" && (pos.BrandId == 10 || pos.BrandId == 11))
  482. {
  483. pos.CreditTrade += SourceTradeAmount;
  484. }
  485. //盒易付
  486. else if(BankCardType == 1 && trade.TradeType == "0" && trade.SerEntryMode != "40" && (pos.BrandId == 12 || pos.BrandId == 13))
  487. {
  488. pos.CreditTrade += SourceTradeAmount;
  489. }
  490. //联客宝
  491. else if(BankCardType == 1 && trade.TradeType != "40" && (pos.BrandId == 15 || pos.BrandId == 16))
  492. {
  493. pos.CreditTrade += SourceTradeAmount;
  494. }
  495. //金控
  496. else if((BankCardType == 1 || BankCardType == 2) && (pos.BrandId == 1 || pos.BrandId == 3))
  497. {
  498. pos.CreditTrade += SourceTradeAmount;
  499. }
  500. //开店宝
  501. else if (BankCardType == 1 && pos.BrandId == 2)
  502. {
  503. pos.CreditTrade += SourceTradeAmount;
  504. }
  505. //乐刷or海科
  506. else if (BankCardType == 1 && (trade.TradeType == "100" || trade.TradeType == "200" || trade.TradeType == "300" || trade.TradeType == "400" || trade.TradeType == "500" || trade.TradeType == "600") && (pos.BrandId == 4 || pos.BrandId == 5 || pos.BrandId == 8 || pos.BrandId == 9))
  507. {
  508. pos.CreditTrade += SourceTradeAmount;
  509. }
  510. //立刷
  511. else if(BankCardType == 1 && trade.Field2 == "0104" && (pos.BrandId == 6 || pos.BrandId == 22))
  512. {
  513. pos.CreditTrade += SourceTradeAmount;
  514. }
  515. //盛付通
  516. else if(BankCardType == 1 && pos.BrandId == 7)
  517. {
  518. pos.CreditTrade += SourceTradeAmount;
  519. }
  520. //拉卡拉
  521. else if(BankCardType == 1 && (pos.BrandId == 30 || pos.BrandId == 31))
  522. {
  523. pos.CreditTrade += SourceTradeAmount;
  524. }
  525. //广电卡
  526. else if(pos.BrandId == 14)
  527. {
  528. pos.CreditTrade += SourceTradeAmount;
  529. }
  530. else if (BankCardType == 0)
  531. {
  532. pos.DebitCardTrade += TradeAmount;
  533. }
  534. //判断激活条件并激活
  535. ActPos(db, pos, CheckMoney, CheckDays);
  536. if (TradeAmount > 0)
  537. {
  538. ulong MerHelpFlag = 0;
  539. decimal DepositAmt = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  540. if (pos.DownFeeFlag == 1)
  541. {
  542. if (pos.DownFee == 0.6M)
  543. {
  544. MerHelpFlag = 3;
  545. }
  546. else
  547. {
  548. MerHelpFlag = 2;
  549. }
  550. }
  551. else if (pos.IsFirst == 1 || pos.BrandId == 14)
  552. {
  553. string DayString = RedisDbconn.Instance.Get<string>("pobjrule:1:HelpPolicy:Days");
  554. int Days = int.Parse(DayString); //天数
  555. if (pos.BindingTime != null)
  556. {
  557. DateTime CheckTime = pos.BindingTime.Value.AddDays(Days);
  558. if(pos.BrandId == 7)
  559. {
  560. CheckTime = DateTime.Parse(pos.BindingTime.Value.AddDays(Days + 1).ToString("yyyy-MM-dd") + " 03:00:00");
  561. }
  562. if (CheckTime > DateTime.Now)
  563. {
  564. MerHelpFlag = 1;
  565. }
  566. }
  567. }
  568. if((pos.BrandId == 12 || pos.BrandId == 13) && pos.UpFeeFlag == 1 && pos.DownFeeFlag == 0)
  569. {
  570. MerHelpFlag = 2;
  571. }
  572. if((pos.BrandId == 10 || pos.BrandId == 11) && trade.TradeType == "T015" && MerHelpFlag == 1)
  573. {
  574. MerHelpFlag = 0;
  575. }
  576. int CapFlag = 0;
  577. if(BankCardType == 0 && TradeAmount >= 1666.67M)
  578. {
  579. CapFlag = 1;
  580. }
  581. string HelpProfitFlag = "";
  582. bool checkHelpProfit = db.HelpProfitMerchantForUser.Any(m => m.MerchantId == pos.BindMerchantId);
  583. if(checkHelpProfit)
  584. {
  585. HelpProfitFlag = "HelpProfit";
  586. }
  587. int ActStatus = pos.ActivationState;
  588. // if(BrandId == 4 || BrandId == 5 || BrandId == 8 || BrandId == 9)
  589. // {
  590. // ActStatus = GetLeShuaHaiKe(pos.UserId, BrandId);
  591. // }
  592. int Version = 0;
  593. if(MerHelpFlag == 2) Version = 1;
  594. if(MerHelpFlag == 3) Version = 2;
  595. //盒易付和来客吧电签,稳定期自动转到稳定期A
  596. if((pos.BrandId == 12 || pos.BrandId == 13) && MerHelpFlag == 0 && Version == 0)
  597. {
  598. Version = 1;
  599. }
  600. if(Utils.Instance.IsWifi(pos.BrandId))
  601. {
  602. MerHelpFlag = 1;
  603. Version = 0;
  604. }
  605. decimal SettleFee = trade.SettleFee * 100;
  606. PxcModels.TradeRecord add = db.TradeRecord.Add(new PxcModels.TradeRecord()
  607. {
  608. ParentNav = user.ParentNav,
  609. CreateDate = trade.CreateDate,
  610. UpdateDate = trade.UpdateDate,
  611. RecordNo = trade.TradeSerialNo, //单号
  612. UserId = pos.UserId, //创客
  613. MerchantId = pos.BindMerchantId, //商户
  614. MerNo = trade.MerNo, //渠道商户编号
  615. MerHelpFlag = MerHelpFlag >= 2 ? 1 : MerHelpFlag, //1扶持周,0稳定期,2盈利期
  616. HelpMonthCount = 0, //扶持第几个月
  617. MerBuddyType = user.MerchantType, //商户创客类型
  618. SnNo = TradeSnNo, //渠道SN号
  619. TradeSerialNo = trade.ChannelSerial, //交易流水号
  620. TradeAmount = TradeAmount, //交易金额
  621. BankCardType = BankCardType, //银行卡类型
  622. QrPayFlag = QrPayFlag, //云闪付标识
  623. CapFlag = CapFlag, //借记卡是否封顶
  624. VipFlag = VipFlag, //会员标记
  625. PayType = PayType, //支付方式
  626. BrandId = BrandId, //品牌
  627. Remark = trade.TradeType == "2" && trade.ProductType == "12" ? "吱码SN:" + trade.TradeSnNo : trade.Remark, //备注
  628. TopUserId = TopUserId, //顶级创客
  629. MerUserId = pos.UserId, //商户直属创客M
  630. SeoTitle = HelpProfitFlag,
  631. Version = Version,
  632. ActStatus = ActStatus,
  633. CreateMan = trade.AgentNo,
  634. UpdateMan = trade.BankCardType,
  635. SeoKeyword = trade.SerEntryMode,
  636. SeoDescription = trade.TradeType,
  637. Sort = (int)SettleFee,
  638. TradeDate = pos.BindingTime,
  639. }).Entity;
  640. db.SaveChanges();
  641. string TradeMonth = trade.CreateDate == null ? DateTime.Now.ToString("yyyyMM") : trade.CreateDate.Value.ToString("yyyyMM");
  642. PublicFunction.SplitTradeRecord(add, TradeMonth);
  643. //统计商户交易额
  644. string TradeDate = trade.CreateDate == null ? DateTime.Now.ToString("yyyyMMdd") : trade.CreateDate.Value.ToString("yyyyMMdd");
  645. RedisDbconn.Instance.AddList("StatMerTradeAmountQueue", "{\"TradeDate\":\"" + TradeDate + "\",\"TradeAmount\":\"" + TradeAmount + "\",\"MerchantId\":\"" + pos.BindMerchantId + "\",\"BrandId\":\"" + BrandId + "\"}");
  646. }
  647. db.SpOrderNos.Add(new PxcModels.SpOrderNos()
  648. {
  649. OrderNo = trade.TradeSerialNo
  650. });
  651. db.SaveChanges();
  652. // 推荐王逻辑(交易)
  653. // if(TradeAmount > 0)
  654. // {
  655. // string Send = "{\"Kind\":\"4\",\"Data\":{\"PosId\":\"" + pos.Id + "\",\"TradeMonth\":\"" + trade.CreateDate.Value.ToString("yyyyMM") + "\",\"TradeAmount\":\"" + TradeAmount + "\"}}";
  656. // RedisDbconn.Instance.AddList("RecommendActStatQueue", Send);
  657. // }
  658. }
  659. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  660. if (edit != null)
  661. {
  662. edit.Status = 2;
  663. }
  664. spdb.SaveChanges();
  665. }
  666. else
  667. {
  668. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  669. if (edit != null)
  670. {
  671. edit.Status = 0;
  672. }
  673. spdb.SaveChanges();
  674. }
  675. }
  676. else
  677. {
  678. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  679. if (edit != null)
  680. {
  681. edit.Status = 0;
  682. }
  683. spdb.SaveChanges();
  684. }
  685. }
  686. if(isDeposit)
  687. {
  688. // function.WriteLog("押金收到:" + trade.MerNo, "服务费奖励发放日志");
  689. // PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == trade.MerNo) ?? new PxcModels.MachineForMerNo();
  690. // function.WriteLog("MachineForMerNo:" + posFor.MerNo, "服务费奖励发放日志");
  691. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == TradeSnNo) ?? new PxcModels.PosMachinesTwo();
  692. function.WriteLog("PosMachinesTwo:" + pos.PosSn, "服务费奖励发放日志");
  693. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  694. function.WriteLog("PosMerchantInfo:" + merchant.KqMerNo, "服务费奖励发放日志");
  695. StatService.Instance.PreActPrize(db, pos, merchant, pos.SeoKeyword);
  696. }
  697. }
  698. spdb.Dispose();
  699. db.Dispose();
  700. }
  701. catch (Exception ex)
  702. {
  703. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP交易数据到MAIN异常");
  704. }
  705. Thread.Sleep(500);
  706. }
  707. }
  708. public void StartSim()
  709. {
  710. Thread th = new Thread(StartSimDo);
  711. th.IsBackground = true;
  712. th.Start();
  713. }
  714. public void StartSimDo()
  715. {
  716. while (true)
  717. {
  718. try
  719. {
  720. WebCMSEntities spdb = new WebCMSEntities();
  721. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  722. DateTime start = DateTime.Now.AddDays(-40);
  723. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/TradeRecordId.txt")));
  724. IQueryable<TradeRecord> trades = spdb.TradeRecord.Where(m => m.Id >= StartId && m.ProductType == "14" && m.CreateDate >= start && m.Status == 1).OrderBy(m => m.CreateDate).Take(20);
  725. foreach (TradeRecord trade in trades.ToList())
  726. {
  727. bool op = true;
  728. if (op)
  729. {
  730. // PxcModels.MachineForMerNo posFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == trade.MerNo) ?? new PxcModels.MachineForMerNo();
  731. PosPushDataNewHelper.Trade(trade);
  732. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == trade.TradeSnNo);
  733. if (pos == null)
  734. {
  735. PxcModels.PosMerchantInfo mer = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == trade.MerNo && m.BrandId == 14 && m.KqSnNo.StartsWith("CS")) ?? new PxcModels.PosMerchantInfo();
  736. pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == mer.KqSnNo);
  737. }
  738. if (pos != null)
  739. {
  740. PxcModels.KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Id == pos.BrandId) ?? new PxcModels.KqProducts();
  741. if (pos.BindMerchantId > 0)
  742. {
  743. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.UserId) ?? new PxcModels.Users();
  744. int TopUserId = 0;
  745. if (!string.IsNullOrEmpty(user.ParentNav))
  746. {
  747. TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  748. }
  749. bool check = db.SpOrderNos.Any(m => m.OrderNo == trade.TradeSerialNo);
  750. if (!check)
  751. {
  752. decimal TradeAmount = trade.TradeAmount;
  753. int BankCardType = -1;
  754. int QrPayFlag = 0;
  755. int VipFlag = 0;
  756. int PayType = 0;
  757. BankCardType = int.Parse(trade.BankCardType);
  758. int BrandId = pos.BrandId;
  759. decimal SourceTradeAmount = TradeAmount;
  760. if (TradeAmount > 0)
  761. {
  762. ulong MerHelpFlag = 0;
  763. string DayString = RedisDbconn.Instance.Get<string>("pobjrule:" + pos.BrandId + ":HelpPolicy:Days");
  764. int Days = int.Parse(DayString); //天数
  765. if (pos.BindingTime != null)
  766. {
  767. if (pos.BindingTime.Value.AddDays(Days) > DateTime.Now)
  768. {
  769. MerHelpFlag = 1;
  770. }
  771. }
  772. int ActStatus = pos.ActivationState;
  773. decimal SettleFee = trade.SettleFee * 100;
  774. PxcModels.TradeRecord add = db.TradeRecord.Add(new PxcModels.TradeRecord()
  775. {
  776. ParentNav = user.ParentNav,
  777. CreateDate = trade.CreateDate,
  778. UpdateDate = trade.UpdateDate,
  779. RecordNo = trade.TradeSerialNo, //单号
  780. UserId = pos.UserId, //创客
  781. MerchantId = pos.BindMerchantId, //商户
  782. MerNo = trade.MerNo, //渠道商户编号
  783. MerHelpFlag = MerHelpFlag >= 2 ? 1 : MerHelpFlag, //1扶持周,0稳定期,2盈利期
  784. HelpMonthCount = 0, //扶持第几个月
  785. MerBuddyType = user.MerchantType, //商户创客类型
  786. SnNo = trade.TradeSnNo, //渠道SN号
  787. TradeSerialNo = trade.ChannelSerial, //交易流水号
  788. TradeAmount = TradeAmount, //交易金额
  789. BankCardType = BankCardType, //银行卡类型
  790. QrPayFlag = QrPayFlag, //云闪付标识
  791. VipFlag = VipFlag, //会员标记
  792. PayType = PayType, //支付方式
  793. BrandId = BrandId, //品牌
  794. Remark = trade.Remark, //备注
  795. TopUserId = TopUserId, //顶级创客
  796. MerUserId = pos.UserId, //商户直属创客
  797. ActStatus = ActStatus,
  798. CreateMan = trade.AgentNo,
  799. UpdateMan = trade.BankCardType,
  800. SeoKeyword = trade.SerEntryMode,
  801. SeoDescription = trade.TradeType,
  802. Sort = (int)SettleFee,
  803. TradeDate = pos.BindingTime,
  804. }).Entity;
  805. db.SaveChanges();
  806. string TradeMonth = trade.CreateDate == null ? DateTime.Now.ToString("yyyyMM") : trade.CreateDate.Value.ToString("yyyyMM");
  807. PublicFunction.SplitTradeRecord(add, TradeMonth);
  808. //统计商户交易额
  809. string TradeDate = trade.CreateDate == null ? DateTime.Now.ToString("yyyyMMdd") : trade.CreateDate.Value.ToString("yyyyMMdd");
  810. RedisDbconn.Instance.AddList("StatMerTradeAmountQueue", "{\"TradeDate\":\"" + TradeDate + "\",\"TradeAmount\":\"" + TradeAmount + "\",\"MerchantId\":\"" + pos.BindMerchantId + "\",\"BrandId\":\"" + BrandId + "\"}");
  811. }
  812. db.SpOrderNos.Add(new PxcModels.SpOrderNos()
  813. {
  814. OrderNo = trade.TradeSerialNo
  815. });
  816. db.SaveChanges();
  817. }
  818. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  819. if (edit != null)
  820. {
  821. edit.Status = 2;
  822. }
  823. spdb.SaveChanges();
  824. }
  825. else
  826. {
  827. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  828. if (edit != null)
  829. {
  830. edit.Status = 0;
  831. }
  832. spdb.SaveChanges();
  833. }
  834. }
  835. else
  836. {
  837. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  838. if (edit != null)
  839. {
  840. edit.Status = 0;
  841. }
  842. spdb.SaveChanges();
  843. }
  844. }
  845. }
  846. spdb.Dispose();
  847. db.Dispose();
  848. }
  849. catch (Exception ex)
  850. {
  851. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步SP交易数据到MAIN异常");
  852. }
  853. Thread.Sleep(500);
  854. }
  855. }
  856. public void StartTradeStatus()
  857. {
  858. Thread th = new Thread(StartTradeStatusDo);
  859. th.IsBackground = true;
  860. th.Start();
  861. }
  862. public void StartTradeStatusDo()
  863. {
  864. while (true)
  865. {
  866. try
  867. {
  868. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  869. WebCMSEntities spdb = new WebCMSEntities();
  870. DateTime start = DateTime.Now.AddDays(-10);
  871. DateTime end = DateTime.Now.AddMinutes(-10);
  872. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/TradeRecordId.txt")));
  873. IQueryable<TradeRecord> trades = spdb.TradeRecord.Where(m => m.Id >= StartId && m.CreateDate >= start && m.CreateDate < end && m.Status == 0).OrderBy(m => m.CreateDate).Take(20);
  874. foreach (TradeRecord trade in trades.ToList())
  875. {
  876. int Status = 1;
  877. bool op = db.PosMachinesTwo.Any(m => m.PosSn == trade.TradeSnNo);
  878. if(!op)
  879. {
  880. Status = -1;
  881. }
  882. else
  883. {
  884. op = db.PosMerchantInfo.Any(m => m.KqSnNo == trade.TradeSnNo);
  885. if(!op)
  886. {
  887. Status = -2;
  888. }
  889. }
  890. TradeRecord edit = spdb.TradeRecord.FirstOrDefault(m => m.Id == trade.Id);
  891. if (edit != null)
  892. {
  893. edit.Status = Status;
  894. spdb.SaveChanges();
  895. }
  896. }
  897. db.Dispose();
  898. spdb.Dispose();
  899. }
  900. catch (Exception ex)
  901. {
  902. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "恢复原始交易没有统计上的数据异常");
  903. }
  904. Thread.Sleep(10000);
  905. }
  906. }
  907. //机具激活逻辑
  908. public void ActPos(PxcModels.WebCMSEntities db, PxcModels.PosMachinesTwo pos, decimal CheckMoney, int CheckDays, bool PrizeFlag = true, string ActivationTime = "")
  909. {
  910. DateTime now = DateTime.Now;
  911. if(!string.IsNullOrEmpty(ActivationTime))
  912. {
  913. now = DateTime.Parse(ActivationTime);
  914. }
  915. DateTime TransferTime = pos.TransferTime == null ? DateTime.Parse("2050-01-01") : pos.TransferTime.Value;
  916. int minute = 30;
  917. if(pos.BrandId == 14 && pos.PosSn.StartsWith("CS"))
  918. {
  919. minute = 60 * 24 * 30;
  920. }
  921. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:贷记卡是否刷满" + CheckMoney + ";贷记卡交易:" + pos.CreditTrade + "");
  922. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:是否有机具所属人;机具所属人Id:" + pos.BuyUserId + "");
  923. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:是否未激活;机具激活状态:" + pos.ActivationState + "");
  924. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:划拨时间不能超过绑定时间" + minute + "分钟;划拨时间:" + TransferTime.ToString() + ",绑定时间:" + pos.BindingTime.Value.ToString());
  925. if (pos.CreditTrade >= CheckMoney && pos.BuyUserId > 0 && pos.ActivationState == 0 && TransferTime.AddMinutes(-minute) < pos.BindingTime)
  926. {
  927. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件");
  928. pos.ActivationState = 1;
  929. pos.ActivationTime = now;
  930. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:是否营训");
  931. if(pos.CardType == 101)
  932. {
  933. Utils.Instance.PrizeRecord(1, pos.PosSn, "是营训");
  934. pos.IsPurchase = 1;
  935. Utils.Instance.PrizeRecord(1, pos.PosSn, "取消循环资格");
  936. }
  937. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:是否关联商户信息");
  938. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  939. if (merchant != null)
  940. {
  941. merchant.ActiveStatus = 1;
  942. merchant.MerStandardDate = now;
  943. db.SaveChanges();
  944. if(pos.BrandId != 14)
  945. {
  946. //发放奖励MQ
  947. PrizeSetHelper.Do("1", pos.PosSn);
  948. }
  949. Utils.Instance.PrizeRecord(1, pos.PosSn, "已关联");
  950. //发放开机奖励
  951. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:绑定时间不超过" + CheckDays + "天;当前绑定时间:" + pos.BindingTime.ToString() + "");
  952. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:非营训;当前类型:" + pos.CardType);
  953. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:奖励开关;当前:" + PrizeFlag);
  954. if(pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100 && PrizeFlag)
  955. {
  956. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放开机奖励");
  957. RedisDbconn.Instance.AddList("OpenRewardQueue", pos.Id.ToString());
  958. if(pos.BrandId == 14)
  959. {
  960. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放运营中心奖励");
  961. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  962. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:大盟主标记;当前大盟主Id:" + pos.LeaderUserId);
  963. PxcModels.Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == pos.LeaderUserId) ?? new PxcModels.Leaders();
  964. DateTime ExpiredDate = leader.ExpiredDate == null ? DateTime.Parse("1900-01-01") : leader.ExpiredDate.Value;
  965. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:盟主是否过期;过期时间:" + pos.LeaderUserId);
  966. if(pos.LeaderUserId > 0 && ExpiredDate > now)
  967. {
  968. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放大盟主奖励");
  969. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  970. }
  971. }
  972. }
  973. }
  974. //发放大盟主奖励
  975. decimal Deposit = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  976. if(pos.BrandId != 14)
  977. {
  978. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:有押金;当前押金:" + Deposit);
  979. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:大盟主标记;当前大盟主Id:" + pos.LeaderUserId);
  980. PxcModels.Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == pos.LeaderUserId) ?? new PxcModels.Leaders();
  981. DateTime ExpiredDate = leader.ExpiredDate == null ? DateTime.Parse("1900-01-01") : leader.ExpiredDate.Value;
  982. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:盟主是否过期;过期时间:" + pos.LeaderUserId);
  983. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:绑定时间不超过" + CheckDays + "天;绑定时间:" + pos.BindingTime.Value.ToString() + "");
  984. }
  985. if (Deposit > 0 && pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100 && PrizeFlag)
  986. {
  987. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放大盟主奖励");
  988. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  989. }
  990. //发放运营中心奖励
  991. if (Deposit > 0 && pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100 && PrizeFlag)
  992. {
  993. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放运营中心奖励");
  994. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  995. }
  996. if(pos.CardType < 100)
  997. {
  998. //统计激活数
  999. RedisDbconn.Instance.AddList("StatActQueue", "{\"TradeDate\":\"" + now.ToString("yyyyMMdd") + "\",\"UserId\":\"" + pos.BuyUserId + "\",\"BrandId\":\"" + pos.BrandId + "\"}");
  1000. //运营中心额度变更
  1001. OpAmountItem item = new OpAmountItem()
  1002. {
  1003. UserId = pos.OpId,
  1004. OperateType = 1,
  1005. ChangeType = 9,
  1006. Remark = "机具激活",
  1007. UseAmount = pos.OpReserve1 + pos.OpReserve2 + pos.OpReserve3,
  1008. UseValidForGetAmount = pos.OpReserve2,
  1009. UseTotalAmt = pos.OpReserve1,
  1010. UseValidAmount = pos.OpReserve3,
  1011. DataType = 2,
  1012. DataId = pos.Id,
  1013. };
  1014. RedisDbconn.Instance.AddList("OperateAmountRecordServiceQueue", item);
  1015. }
  1016. //清理预扣款
  1017. RedisDbconn.Instance.AddList("PosWithholdQueue", "{\"UserId\":\"" + pos.BuyUserId + "\",\"SnNo\":\"" + pos.PosSn + "\"}");
  1018. //推送激活数据
  1019. if(Deposit == 0) Utils.Instance.SendActData(pos);
  1020. }
  1021. else if (pos.ActivationState == 1 && pos.BrandId == 14)
  1022. {
  1023. if(pos.BindingTime > now.AddDays(-CheckDays) && pos.CardType < 100 && PrizeFlag)
  1024. {
  1025. RedisDbconn.Instance.AddList("OpenRewardQueue", pos.Id.ToString());
  1026. if(pos.BrandId == 14)
  1027. {
  1028. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  1029. PxcModels.Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == pos.LeaderUserId) ?? new PxcModels.Leaders();
  1030. DateTime ExpiredDate = leader.ExpiredDate == null ? DateTime.Parse("1900-01-01") : leader.ExpiredDate.Value;
  1031. if(pos.LeaderUserId > 0 && ExpiredDate > now)
  1032. {
  1033. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  1034. }
  1035. }
  1036. }
  1037. }
  1038. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:已激活;当前状态:" + pos.ActivationState);
  1039. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:绑定后台30天到60天之间;绑定时间:" + pos.BindingTime.Value.ToString() + "");
  1040. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:贷记卡是否刷满10000;贷记卡交易:" + pos.CreditTrade + "");
  1041. Utils.Instance.PrizeRecord(1, pos.PosSn, "条件:非营训;当前类型:" + pos.CardType);
  1042. if(pos.ActivationState == 1 && pos.BindingTime.Value.AddDays(30) <= DateTime.Now && pos.BindingTime.Value.AddDays(60) > DateTime.Now && pos.CreditTrade >= 10000 && pos.CardType < 100)
  1043. {
  1044. Utils.Instance.PrizeRecord(1, pos.PosSn, "满足条件,发放盟主开机奖励");
  1045. RedisDbconn.Instance.AddList("LeaderRewardQueue", pos.Id.ToString());
  1046. //发放奖励MQ
  1047. PrizeSetHelper.Do("1", pos.PosSn);
  1048. }
  1049. }
  1050. //立刷格外奖励
  1051. public void LiShuaActPrize(PxcModels.WebCMSEntities db, PxcModels.PosMachinesTwo pos, int prize)
  1052. {
  1053. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  1054. if(merchant != null)
  1055. {
  1056. PxcModels.Users getUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new PxcModels.Users();
  1057. int BuyTopUserId = 0;
  1058. string ParentNav = getUser.ParentNav;
  1059. if (!string.IsNullOrEmpty(ParentNav))
  1060. {
  1061. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1062. if (ParentNavList.Length > 1)
  1063. {
  1064. BuyTopUserId = int.Parse(ParentNavList[1]);
  1065. }
  1066. else if (ParentNavList.Length == 1)
  1067. {
  1068. BuyTopUserId = int.Parse(ParentNavList[0]);
  1069. }
  1070. }
  1071. if(prize == 50)
  1072. {
  1073. StatService.Instance.doActiveReward(db, merchant, pos, getUser.Id, getUser.ParentNav, BuyTopUserId, prize);
  1074. }
  1075. if(prize == 40)
  1076. {
  1077. StatService.Instance.doActiveReward(db, merchant, pos, getUser.Id, getUser.ParentNav, BuyTopUserId, prize, 12);
  1078. }
  1079. if(prize == 30)
  1080. {
  1081. StatService.Instance.doActiveReward(db, merchant, pos, getUser.Id, getUser.ParentNav, BuyTopUserId, prize, 133);
  1082. }
  1083. }
  1084. }
  1085. private int GetLeShuaHaiKe(int UserId, int BrandId)
  1086. {
  1087. if(DateTime.Now >= DateTime.Parse("2023-08-01 00:00:00"))
  1088. {
  1089. return 0;
  1090. }
  1091. int ActStatus = 1;
  1092. try
  1093. {
  1094. string Date = DateTime.Now.ToString("yyyyMMdd");
  1095. int checkNum = 0;
  1096. if(Date == "20230720") checkNum = 12;
  1097. if(Date == "20230721") checkNum = 11;
  1098. if(Date == "20230722") checkNum = 10;
  1099. if(Date == "20230723") checkNum = 9;
  1100. if(Date == "20230724") checkNum = 8;
  1101. if(Date == "20230725") checkNum = 7;
  1102. if(Date == "20230726") checkNum = 6;
  1103. if(Date == "20230727") checkNum = 5;
  1104. if(Date == "20230728") checkNum = 4;
  1105. if(Date == "20230729") checkNum = 3;
  1106. if(Date == "20230730") checkNum = 2;
  1107. if(Date == "20230731") checkNum = 1;
  1108. int check = int.Parse(function.CheckInt(RedisDbconn.Instance.Get<string>("lscut:" + UserId + ":" + BrandId + ":" + Date)));
  1109. if(check <= checkNum)
  1110. {
  1111. check += 1;
  1112. RedisDbconn.Instance.Set("lscut:" + UserId + ":" + BrandId + ":" + Date, check.ToString());
  1113. }
  1114. else
  1115. {
  1116. ActStatus = -1;
  1117. RedisDbconn.Instance.Set("lscut:" + UserId + ":" + BrandId + ":" + Date, "0");
  1118. }
  1119. }
  1120. catch(Exception ex)
  1121. {
  1122. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "乐刷海科计数异常");
  1123. }
  1124. return ActStatus;
  1125. }
  1126. }
  1127. }