SycnSpTradeService.cs 69 KB

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