GetHaoDaFTPInfoService.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Data;
  5. using System.Threading;
  6. using Library;
  7. using System.Net;
  8. using System.IO;
  9. using MySystem.SpModels;
  10. namespace MySystem
  11. {
  12. /// <summary>
  13. /// 获取好哒ftp数据
  14. /// </summary>
  15. public class GetHaoDaFTPInfoService
  16. {
  17. public readonly static GetHaoDaFTPInfoService Instance = new GetHaoDaFTPInfoService();
  18. private GetHaoDaFTPInfoService()
  19. { }
  20. // 47.108.253.46
  21. // 用户名:hdftp
  22. // 密:haodatradeftp2024
  23. // 目录:/haoda-trade
  24. public string ftpServerAddress = "ftp://47.108.253.46";
  25. public string ftpUser = "hdftp";
  26. public string ftpPassword = "haodatradeftp2024";
  27. public void Start()
  28. {
  29. //每天凌晨执行获取好哒FTP昨日交易数据
  30. Thread th2 = new Thread(GetDepositDataReady);
  31. th2.IsBackground = true;
  32. th2.Start();
  33. }
  34. /// <summary>
  35. /// 获取好哒FTP昨日交易数据
  36. /// </summary>
  37. public void GetDepositDataReady()
  38. {
  39. while (true)
  40. {
  41. if (DateTime.Now.Hour > 10 && DateTime.Now.Hour < 22)
  42. {
  43. string check = function.ReadInstance("/GetFTPDepositYesterday/check" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + ".txt");
  44. if (string.IsNullOrEmpty(check))
  45. {
  46. function.WritePage("/GetFTPDepositYesterday/", "check" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + ".txt", DateTime.Now.ToString());
  47. SaveDepositData(DateTime.Now.AddDays(-1).ToString("yyyyMMdd"));
  48. Thread.Sleep(2000);
  49. GetDepositData();
  50. Thread.Sleep(60000);
  51. SaveTradeData(DateTime.Now.AddDays(-1).ToString("yyyyMMdd"));
  52. }
  53. }
  54. Thread.Sleep(1800000);
  55. }
  56. }
  57. public void Start2()
  58. {
  59. //每天凌晨执行获取好哒FTP昨日交易数据
  60. Thread th2 = new Thread(GetDepositDataReady2);
  61. th2.IsBackground = true;
  62. th2.Start();
  63. }
  64. /// <summary>
  65. /// 获取好哒FTP昨日交易数据
  66. /// </summary>
  67. public void GetDepositDataReady2()
  68. {
  69. while (true)
  70. {
  71. if (DateTime.Now > DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 10:05:00"))
  72. {
  73. SaveDepositData("d_" + DateTime.Now.ToString("yyyyMMdd"));
  74. Thread.Sleep(2000);
  75. GetDepositData();
  76. }
  77. SaveTradeData(DateTime.Now.ToString("yyyyMMdd"));
  78. Thread.Sleep(180000);
  79. }
  80. }
  81. public void StartListen()
  82. {
  83. //每天凌晨执行获取好哒FTP昨日交易数据
  84. Thread th2 = new Thread(ListenDepositDataReady);
  85. th2.IsBackground = true;
  86. th2.Start();
  87. }
  88. /// <summary>
  89. /// 获取好哒FTP昨日交易数据
  90. /// </summary>
  91. public void ListenDepositDataReady()
  92. {
  93. while (true)
  94. {
  95. string content = RedisDbconn.Instance.RPop<string>("ListenDepositDataQueue2");
  96. if (!string.IsNullOrEmpty(content))
  97. {
  98. SaveDepositData(content);
  99. Thread.Sleep(2000);
  100. GetDepositData();
  101. Thread.Sleep(2000);
  102. }
  103. else
  104. {
  105. Thread.Sleep(60000);
  106. }
  107. }
  108. }
  109. public void SaveDepositData(string Date)
  110. {
  111. // 要下载的文件路径
  112. string filePath = "/haoda-deposit/deposit_" + Date + ".csv";
  113. try
  114. {
  115. // 创建FtpWebRequest对象
  116. FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpServerAddress + filePath);
  117. request.Method = WebRequestMethods.Ftp.DownloadFile;
  118. request.Credentials = new NetworkCredential(ftpUser, ftpPassword);
  119. // 使用WebResponse获取响应
  120. FtpWebResponse response = (FtpWebResponse)request.GetResponse();
  121. // 打开数据流
  122. Stream responseStream = response.GetResponseStream();
  123. StreamReader reader = new StreamReader(responseStream);
  124. // 读取数据
  125. string fileContents = reader.ReadToEnd();
  126. if (!string.IsNullOrEmpty(fileContents))
  127. {
  128. MpMainModels2.WebCMSEntities db = new MpMainModels2.WebCMSEntities();
  129. List<string> SnNos = db.HdDepositTmp.Select(m => m.SnNo).ToList();
  130. List<string> ChkSnNos = new List<string>();
  131. var DataInfo = fileContents.TrimEnd('\n').Split('\n', 2);
  132. if(DataInfo.Length > 1)
  133. {
  134. int index = 0;
  135. var DataList = DataInfo[1].Split('\n');
  136. foreach (var DataListItem in DataList)
  137. {
  138. index += 1;
  139. var DataListInfo = DataListItem.Split(',');
  140. string SnNo = DataListInfo[0]; //sn
  141. string MerNo = DataListInfo[1]; //商户编号
  142. string PosKind = DataListInfo[2]; //机具型号
  143. string ActDate = DataListInfo[3]; //激活时间
  144. string Deposit = DataListInfo[4]; //押金金额
  145. string PrizeAmt = "0"; //奖励金额
  146. string PrizeDate = "None"; //奖励发放时间
  147. string Name = ""; //发放人姓名
  148. string MerName = ""; //商户名称
  149. string PassDate = ""; //审核通过时期
  150. string MerKind = ""; //商户类型
  151. string DepositActCode = ""; //押金活动编号
  152. if(Date.StartsWith("d_"))
  153. {
  154. MerName = DataListInfo[5]; //商户名称
  155. PassDate = DataListInfo[6]; //审核通过时期
  156. MerKind = DataListInfo[7]; //商户类型
  157. DepositActCode = DataListInfo[8]; //押金活动编号
  158. }
  159. else
  160. {
  161. PrizeAmt = DataListInfo[5]; //奖励金额
  162. PrizeDate = DataListInfo[6]; //奖励发放时间
  163. Name = DataListInfo[7]; //发放人姓名
  164. MerName = DataListInfo[8]; //商户名称
  165. PassDate = DataListInfo[9]; //审核通过时期
  166. if(DataListInfo.Length > 10) MerKind = DataListInfo[10]; //商户类型
  167. if(DataListInfo.Length > 11) DepositActCode = DataListInfo[11]; //押金活动编号
  168. }
  169. if(!SnNos.Contains(SnNo) && !ChkSnNos.Contains(SnNo))
  170. {
  171. function.WriteLog(DateTime.Now.ToString() + ":" + SnNo, "好哒押金数据入库");
  172. ChkSnNos.Add(SnNo);
  173. db.HdDepositTmp.Add(new MpMainModels2.HdDepositTmp()
  174. {
  175. SnNo = SnNo,
  176. MerKind = MerKind,
  177. PassDate = PassDate,
  178. MerName = MerName,
  179. SendMan = Name,
  180. PrizeDate = PrizeDate,
  181. PrizeAmount = decimal.Parse(function.CheckNum(PrizeAmt)),
  182. DepositAmount = decimal.Parse(function.CheckNum(Deposit)),
  183. ActDate = ActDate,
  184. DeviceKind = PosKind,
  185. DepositActCode = DepositActCode,
  186. MerNo = MerNo,
  187. });
  188. if(index % 200 == 0)
  189. {
  190. db.SaveChanges();
  191. }
  192. }
  193. }
  194. db.SaveChanges();
  195. }
  196. db.Dispose();
  197. }
  198. // 关闭响应
  199. reader.Dispose();
  200. responseStream.Dispose();
  201. response.Close();
  202. }
  203. catch (WebException ex)
  204. {
  205. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "获取好哒FTP文件数据异常");
  206. }
  207. }
  208. public void GetDepositData()
  209. {
  210. try
  211. {
  212. WebCMSEntities db = new WebCMSEntities();
  213. MpMainModels2.WebCMSEntities mpdb2 = new MpMainModels2.WebCMSEntities();
  214. List<MpMainModels2.HdDepositTmp> deposits = mpdb2.HdDepositTmp.Where(m => m.Status == 0).ToList();
  215. if(deposits.Count > 0)
  216. {
  217. foreach (var deposit in deposits)
  218. {
  219. string SnNo = deposit.SnNo; //sn
  220. string MerNo = deposit.MerNo; //商户编号
  221. string PosKind = deposit.DeviceKind; //机具型号
  222. string ActDate = deposit.ActDate; //激活时间
  223. string Deposit = deposit.DepositAmount.ToString(); //押金金额
  224. string PrizeAmt = deposit.PrizeAmount.ToString(); //奖励金额
  225. string PrizeDate = deposit.PrizeDate; //奖励发放时间
  226. string Name = deposit.SendMan; //发放人姓名
  227. string MerName = deposit.MerName; //商户名称
  228. string PassDate = deposit.PassDate; //审核通过时期
  229. string MerKind = deposit.MerKind; //商户类型
  230. string DepositActCode = deposit.DepositActCode; //商户类型
  231. if(!db.ActivateRecord.Any(m => m.SnNo == SnNo && m.MerNo == MerNo))
  232. {
  233. MpMainModels2.MerchantAddInfo meradd = mpdb2.MerchantAddInfo.FirstOrDefault(m => m.MchtNo == MerNo) ?? new MpMainModels2.MerchantAddInfo();
  234. MpMainModels2.MerchantInfo merchant = mpdb2.MerchantInfo.FirstOrDefault(m => m.Id == meradd.Id) ?? new MpMainModels2.MerchantInfo();
  235. if(!string.IsNullOrEmpty(meradd.CertMerchantName)) MerName = meradd.CertMerchantName;
  236. string ActDateString = ActDate.Substring(0, 4) + "-" + ActDate.Substring(4, 2) + "-" + ActDate.Substring(6, 2);
  237. string ProductType = "0";
  238. if(PosKind == "好哒语音王Y512") ProductType = "18";
  239. if(PosKind == "4G收款王M820") ProductType = "19";
  240. if(PosKind == "4G收款王M826") ProductType = "20";
  241. if(PosKind == "好哒S312") ProductType = "21";
  242. if(PosKind == "好哒扫码通M837") ProductType = "29";
  243. BindRecord mer = db.BindRecord.Add(new BindRecord()
  244. {
  245. CreateDate = DateTime.Now,
  246. UpdateTime = DateTime.Now, //机具绑定、解绑时间
  247. CreateTime = DateTime.Now, //商户操作时间
  248. MerSnNo = SnNo, //序列号
  249. MerNo = MerNo, //商户编号
  250. MerName = MerName,
  251. SeoTitle = PrizeAmt,
  252. SeoKeyword = ActDateString,
  253. ProductType = ProductType,
  254. Field1 = Deposit,
  255. Field2 = PrizeDate,
  256. Field3 = Name,
  257. Field4 = PassDate,
  258. Field5 = MerKind,
  259. Status = 1,
  260. QueryCount = merchant.UserId,
  261. }).Entity;
  262. db.Merchants.Add(new Merchants()
  263. {
  264. SnNo = SnNo,
  265. CreateTime = DateTime.Now,
  266. UpdateTime = DateTime.Now,
  267. AgentName = Name,
  268. MerRealName = Name,
  269. MerNo = MerNo,
  270. MerName = Name,
  271. ProductType = ProductType,
  272. Status = 1,
  273. QueryCount = merchant.UserId,
  274. });
  275. db.SaveChanges();
  276. Thread.Sleep(1000);
  277. ActivateRecord act = db.ActivateRecord.Add(new ActivateRecord()
  278. {
  279. SnNo = SnNo,
  280. CreateDate = DateTime.Now,
  281. SeoTitle = Deposit,
  282. ActivateDate = DateTime.Now,
  283. AgentNo = MerNo,
  284. MerRealName = Name,
  285. MerNo = MerNo,
  286. MerName = Name,
  287. ProductType = ProductType,
  288. ChannelSerial = DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8),
  289. Status = 1,
  290. Field1 = PassDate,
  291. Field2 = MerKind,
  292. Field3 = ActDateString,
  293. Field4 = DepositActCode,
  294. QueryCount = merchant.UserId,
  295. }).Entity;
  296. db.SaveChanges();
  297. //推送MQ给创业帮
  298. var merchantAddInfo = mpdb2.MerchantAddInfo.FirstOrDefault(m => m.MchtNo == MerNo) ?? new MpMainModels2.MerchantAddInfo();
  299. if (merchantAddInfo.BrandId == 1 && !string.IsNullOrEmpty(merchantAddInfo.CybMakerCode))
  300. {
  301. SortedList<string, string> obj = new SortedList<string, string>();
  302. obj.Add("create_time", ActDateString);
  303. obj.Add("sn", SnNo);
  304. obj.Add("deposit", Deposit);
  305. obj.Add("subject_type", merchantAddInfo.SubjectType);
  306. obj.Add("merch_no", merchantAddInfo.MchtNo);
  307. obj.Add("maker_code", merchantAddInfo.CybMakerCode);
  308. PushHelper.Instance.Do(obj, "cashNotify");
  309. // PosPushDataNewHelper.Bind(mer, PosKind);
  310. // PosPushDataNewHelper.Deposit(act);
  311. }
  312. }
  313. MpMainModels2.HdDepositTmp edit = mpdb2.HdDepositTmp.FirstOrDefault(m => m.SnNo == SnNo);
  314. if(edit != null)
  315. {
  316. edit.Status = 1;
  317. mpdb2.SaveChanges();
  318. }
  319. }
  320. }
  321. db.Dispose();
  322. mpdb2.Dispose();
  323. }
  324. catch (WebException ex)
  325. {
  326. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "获取好哒FTP文件数据异常");
  327. }
  328. }
  329. public void StartTrade()
  330. {
  331. //每天凌晨执行获取好哒FTP昨日交易数据
  332. Thread th2 = new Thread(GetTradeDataReady);
  333. th2.IsBackground = true;
  334. th2.Start();
  335. }
  336. /// <summary>
  337. /// 获取好哒FTP昨日交易数据
  338. /// </summary>
  339. public void GetTradeDataReady()
  340. {
  341. while (true)
  342. {
  343. if (DateTime.Now.Hour > 10 && DateTime.Now.Hour < 22)
  344. {
  345. string check = function.ReadInstance("/GetFTPTradeYesterday/check" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + ".txt");
  346. if (string.IsNullOrEmpty(check))
  347. {
  348. function.WritePage("/GetFTPTradeYesterday/", "check" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + ".txt", DateTime.Now.ToString());
  349. SaveTradeData(DateTime.Now.AddDays(-1).ToString("yyyyMMdd"));
  350. Thread.Sleep(600000);
  351. }
  352. }
  353. else
  354. {
  355. Thread.Sleep(1800000);
  356. }
  357. }
  358. }
  359. public void StartTradeListen()
  360. {
  361. //每天凌晨执行获取好哒FTP昨日交易数据
  362. Thread th2 = new Thread(ListenTradeDataReady);
  363. th2.IsBackground = true;
  364. th2.Start();
  365. }
  366. /// <summary>
  367. /// 获取好哒FTP昨日交易数据
  368. /// </summary>
  369. public void ListenTradeDataReady()
  370. {
  371. while (true)
  372. {
  373. string content = RedisDbconn.Instance.RPop<string>("ListenTradeDataQueue");
  374. if (!string.IsNullOrEmpty(content))
  375. {
  376. SaveTradeData(content);
  377. Thread.Sleep(2000);
  378. }
  379. else
  380. {
  381. Thread.Sleep(60000);
  382. }
  383. }
  384. }
  385. public void SaveTradeData(string Date)
  386. {
  387. // 要下载的文件路径
  388. string filePath = "/haoda-trade/" + Date + ".csv";
  389. function.WriteLog(DateTime.Now.ToString() + ":" + filePath, "获取好哒FTP文件交易数据");
  390. try
  391. {
  392. // 创建FtpWebRequest对象
  393. FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpServerAddress + filePath);
  394. request.Method = WebRequestMethods.Ftp.DownloadFile;
  395. request.Credentials = new NetworkCredential(ftpUser, ftpPassword);
  396. // 使用WebResponse获取响应
  397. FtpWebResponse response = (FtpWebResponse)request.GetResponse();
  398. // 打开数据流
  399. Stream responseStream = response.GetResponseStream();
  400. StreamReader reader = new StreamReader(responseStream);
  401. // 读取数据
  402. string fileContents = reader.ReadToEnd();
  403. if (!string.IsNullOrEmpty(fileContents))
  404. {
  405. MpMainModels2.WebCMSEntities db = new MpMainModels2.WebCMSEntities();
  406. List<string> orderNos = db.HdOrderTmp.Select(m => m.OrderNo).ToList();
  407. List<string> chkOrderNos = new List<string>();
  408. var DataInfo = fileContents.TrimEnd('\n').Split('\n', 2);
  409. if(DataInfo.Length > 1)
  410. {
  411. var DataList = DataInfo[1].Split('\n');
  412. int index = 0;
  413. foreach (var DataListItem in DataList)
  414. {
  415. index += 1;
  416. var DataListInfo = DataListItem.Split(',');
  417. var MerchantNo = ""; // 商户号
  418. var BaseNo = ""; // 设备号
  419. var DeviceKind = ""; // 终端类型
  420. var OrderNo = ""; // 订单号
  421. var PayWay = ""; // 支付方式(微信 支付宝)
  422. var TradeType = ""; // 交易类型
  423. var TradeAmount = ""; // 交易金额
  424. var TradeFee = ""; // 交易手续费
  425. var TradeDate = ""; // 交易时间
  426. var TradeCycle = ""; // 结算周期
  427. MerchantNo = DataListInfo[0];
  428. BaseNo = DataListInfo[1];
  429. DeviceKind = DataListInfo[2];
  430. OrderNo = DataListInfo[3];
  431. PayWay = DataListInfo[4];
  432. TradeType = DataListInfo[5];
  433. TradeAmount = DataListInfo[6];
  434. TradeFee = DataListInfo[7];
  435. TradeDate = DataListInfo[8];
  436. TradeCycle = DataListInfo[9];
  437. if(!orderNos.Contains(OrderNo) && !chkOrderNos.Contains(OrderNo))
  438. {
  439. function.WriteLog(DateTime.Now.ToString() + ":" + OrderNo, "好哒交易数据入库");
  440. chkOrderNos.Add(OrderNo);
  441. db.HdOrderTmp.Add(new MpMainModels2.HdOrderTmp()
  442. {
  443. OrderNo = OrderNo,
  444. SettleDuration = TradeCycle,
  445. TradeTime = TradeDate,
  446. TradeFee = decimal.Parse(function.CheckNum(TradeFee)),
  447. TradeAmount = decimal.Parse(function.CheckNum(TradeAmount)),
  448. TradeType = TradeType,
  449. PayMode = PayWay,
  450. DeviceKind = DeviceKind,
  451. SnNo = BaseNo,
  452. MerNo = MerchantNo,
  453. });
  454. if(index % 200 == 0)
  455. {
  456. db.SaveChanges();
  457. }
  458. }
  459. }
  460. db.SaveChanges();
  461. }
  462. db.Dispose();
  463. }
  464. // 关闭响应
  465. reader.Dispose();
  466. responseStream.Dispose();
  467. response.Close();
  468. }
  469. catch (WebException ex)
  470. {
  471. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "获取好哒FTP文件交易数据入库异常");
  472. }
  473. }
  474. public void StartGetTradeData()
  475. {
  476. //每天凌晨执行获取好哒FTP昨日交易数据
  477. Thread th2 = new Thread(ListenGetTradeData);
  478. th2.IsBackground = true;
  479. th2.Start();
  480. }
  481. /// <summary>
  482. /// 获取好哒FTP昨日交易数据
  483. /// </summary>
  484. public void ListenGetTradeData()
  485. {
  486. while (true)
  487. {
  488. // if(DateTime.Now.Hour < 9)
  489. // {
  490. GetTradeData();
  491. // Thread.Sleep(2000);
  492. // }
  493. // else
  494. // {
  495. Thread.Sleep(10000);
  496. // }
  497. }
  498. }
  499. public void GetTradeData()
  500. {
  501. try
  502. {
  503. MpMainModels2.WebCMSEntities db = new MpMainModels2.WebCMSEntities();
  504. List<MpMainModels2.HdOrderTmp> orders = db.HdOrderTmp.Where(m => m.Status == 0).Take(200).ToList();
  505. if(orders.Count > 0)
  506. {
  507. foreach (var order in orders)
  508. {
  509. var MerchantNo = order.MerNo; // 商户号
  510. var BaseNo = order.SnNo; // 设备号
  511. var DeviceKind = order.DeviceKind; // 终端类型
  512. var OrderNo = order.OrderNo; // 订单号
  513. var PayWay = order.PayMode; // 支付方式(微信 支付宝)
  514. var TradeType = order.TradeType; // 交易类型
  515. var TradeAmount = order.TradeAmount; // 交易金额
  516. var TradeFee = order.TradeFee; // 交易手续费
  517. var TradeDate = order.TradeTime; // 交易时间
  518. var TradeCycle = order.SettleDuration; // 结算周期
  519. TradeDate = TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2) + " " + TradeDate.Substring(8, 2) + ":" + TradeDate.Substring(10, 2) + ":" + TradeDate.Substring(12, 2);
  520. function.WriteLog("OrderNo:" + OrderNo, "获取好哒FTP文件交易数据");
  521. function.WriteLog("MerchantNo:" + MerchantNo, "获取好哒FTP文件交易数据");
  522. var PayMode = 0;
  523. if (PayWay.Contains("支付宝")) PayMode = 1;
  524. if (PayWay.Contains("微信")) PayMode = 2;
  525. var merchantAddInfo = db.MerchantAddInfo.FirstOrDefault(m => m.MchtNo == MerchantNo) ?? new MpMainModels2.MerchantAddInfo();
  526. if (merchantAddInfo.Id > 0)
  527. {
  528. function.WriteLog("找到商户", "获取好哒FTP文件交易数据");
  529. var merchantInfo = db.MerchantInfo.FirstOrDefault(m => m.Id == merchantAddInfo.Id) ?? new MpMainModels2.MerchantInfo();
  530. if(merchantInfo.IsAct == 0)
  531. {
  532. merchantInfo.IsAct = 1;
  533. }
  534. function.WriteLog("订单号不存在,开始入库", "获取好哒FTP文件交易数据");
  535. var query = db.ConsumerOrders.FirstOrDefault(m => m.OrderNo == OrderNo);
  536. if(query == null)
  537. {
  538. decimal FeeRate = decimal.Parse(function.CheckNum(merchantAddInfo.FeeRate)) * 100;
  539. query = db.ConsumerOrders.Add(new MpMainModels2.ConsumerOrders()
  540. {
  541. Status = 1,
  542. CreateDate = DateTime.Parse(TradeDate),
  543. UpdateDate = DateTime.Parse(TradeDate),
  544. SnNo = BaseNo,
  545. PayMoney = TradeAmount,
  546. PayMode = PayMode,
  547. SeoTitle = OrderNo,
  548. OrderNo = OrderNo,
  549. MerchantId = merchantAddInfo.Id,
  550. UserId = merchantInfo.UserId,
  551. SeoKeyword = merchantAddInfo.CybMakerCode,
  552. Sort = (int)FeeRate,
  553. TradePayNo = MerchantNo,
  554. }).Entity;
  555. }
  556. MpMainModels2.HdOrderTmp edit = db.HdOrderTmp.FirstOrDefault(m => m.OrderNo == OrderNo);
  557. if(edit != null)
  558. {
  559. edit.Status = 1;
  560. }
  561. db.SaveChanges();
  562. function.WriteLog("入库完毕", "获取好哒FTP文件交易数据");
  563. //推送MQ给创业帮
  564. if (merchantAddInfo.BrandId == 1)
  565. {
  566. if(!string.IsNullOrEmpty(merchantAddInfo.CybMakerCode))
  567. {
  568. SortedList<string, string> obj = new SortedList<string, string>();
  569. obj.Add("create_time", TradeDate);
  570. obj.Add("sn", BaseNo);
  571. obj.Add("pay_money", TradeAmount.ToString());
  572. obj.Add("pay_mode", PayMode.ToString());
  573. obj.Add("order_no", OrderNo);
  574. obj.Add("merch_no", merchantAddInfo.MchtNo);
  575. obj.Add("maker_code", merchantAddInfo.CybMakerCode);
  576. PushHelper.Instance.Do(obj);
  577. }
  578. OrderMessageHelper.SendOrderMsg(query);
  579. }
  580. PosPushDataNewHelper.Trade(query, DeviceKind);
  581. if(DeviceKind.Contains("好哒二维码"))
  582. {
  583. if(!db.HdQrCodeTmp.Any(m => m.SnNo == BaseNo && m.MerNo == MerchantNo))
  584. {
  585. db.HdQrCodeTmp.Add(new MpMainModels2.HdQrCodeTmp()
  586. {
  587. SnNo = BaseNo,
  588. MerNo = MerchantNo,
  589. });
  590. db.SaveChanges();
  591. // PosPushDataNewHelper.Bind(new SpModels.BindRecord()
  592. // {
  593. // MerSnNo = BaseNo,
  594. // MerNo = MerchantNo,
  595. // MerName = merchantAddInfo.CertMerchantName,
  596. // CreateTime = DateTime.Parse(TradeDate),
  597. // QueryCount = merchantInfo.UserId,
  598. // }, "好哒二维码");
  599. }
  600. }
  601. }
  602. else
  603. {
  604. MpMainModels2.HdOrderTmp edit = db.HdOrderTmp.FirstOrDefault(m => m.OrderNo == OrderNo);
  605. if(edit != null)
  606. {
  607. edit.Status = -1;
  608. }
  609. db.SaveChanges();
  610. }
  611. Thread.Sleep(100);
  612. }
  613. }
  614. db.Dispose();
  615. }
  616. catch (WebException ex)
  617. {
  618. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "获取好哒FTP文件交易数据异常");
  619. }
  620. }
  621. }
  622. }