SycnSpTradeService.cs 67 KB

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