SycnSpTradeService.cs 69 KB

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