GuangXiKLSCJob.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using HtmlAgilityPack;
  6. using Quartz;
  7. using SCC.Common;
  8. using SCC.Crawler.Tools;
  9. using SCC.Interface;
  10. using SCC.Models;
  11. namespace SCC.Crawler.DT
  12. {
  13. /// <summary>
  14. /// 广西快乐双彩
  15. /// </summary>
  16. public class GuangXiKLSCJob : IJob
  17. {
  18. /// <summary>
  19. /// 构造函数
  20. /// </summary>
  21. public GuangXiKLSCJob()
  22. {
  23. log = new LogHelper();
  24. services = IOC.Resolve<IDTOpenCode>();
  25. email = IOC.Resolve<IEmail>();
  26. }
  27. /// <summary>
  28. /// 作业执行入口
  29. /// </summary>
  30. /// <param name="context">作业执行上下文</param>
  31. public void Execute(IJobExecutionContext context)
  32. {
  33. Config = CommonHelper.GetConfigFromDataMap(context.JobDetail.JobDataMap);
  34. //预设节假日不开奖
  35. if (Config.SkipDate.Contains(CommonHelper.SCCSysDateTime.ToString("yyyyMMdd"))) return;
  36. LatestItem = context.JobDetail.JobDataMap["LatestItem"] as OpenCode7DTModel;
  37. try
  38. {
  39. //服务启动时配置初始数据
  40. if (LatestItem == null)
  41. {
  42. LatestItem = services.GetOpenCode7DTLastItem(currentLottery);
  43. if (LatestItem == null)
  44. LatestItem = new OpenCode7DTModel
  45. {
  46. Term = CommonHelper.GenerateQiHaoYYYYQQQ(0),
  47. OpenTime = new DateTime(CommonHelper.SCCSysDateTime.Year, 1, 1)
  48. };
  49. }
  50. //程序时间第二天,程序根据配置检查是否昨天有开奖
  51. isGetData = false;
  52. if (CommonHelper.CheckDTIsNeedGetData(Config))
  53. {
  54. DoMainUrl();
  55. DoBackUrl();
  56. }
  57. if (!LatestItem.Term.ToString().StartsWith(CommonHelper.SCCSysDateTime.ToString("yy")))
  58. LatestItem = new OpenCode7DTModel
  59. {
  60. Term = CommonHelper.GenerateQiHaoYYYYQQQ(0),
  61. OpenTime = new DateTime(CommonHelper.SCCSysDateTime.Year, 1, 1)
  62. };
  63. //当今日开奖并且当前时间是晚上8点过后开始抓取
  64. if (CommonHelper.CheckTodayIsOpenDay(Config) && CommonHelper.SCCSysDateTime.Hour > 12)
  65. {
  66. DoMainUrl();
  67. DoBackUrl();
  68. }
  69. }
  70. catch (Exception ex)
  71. {
  72. log.Error(GetType(), string.Format("【{0}】抓取时发生错误,错误信息【{1}】", Config.Area + currentLottery, ex.Message));
  73. }
  74. //保存最新期号
  75. context.JobDetail.JobDataMap["LatestItem"] = LatestItem;
  76. }
  77. /// <summary>
  78. /// 通过主站点爬取开奖数据
  79. /// (福建体彩网)
  80. /// </summary>
  81. private void DoMainUrl()
  82. {
  83. if (!string.IsNullOrEmpty(Config.MainUrl))
  84. {
  85. var openList = GetOpenListFromMainUrl(Config.MainUrl);
  86. if (openList.Count == 0) return; //无抓取数据
  87. //抓取到的最新期数
  88. var newestQiHao = Convert.ToInt32(openList.First().Term.ToString());
  89. //数据库里面最新期数
  90. var startQiNum = Convert.ToInt32(LatestItem.Term.ToString());
  91. if (startQiNum > newestQiHao) return; //无最新数据
  92. //处理最新开奖数据
  93. var getQiHao = string.Empty;
  94. OpenCode7DTModel matchItem = null;
  95. for (var i = startQiNum; i <= newestQiHao; i++)
  96. {
  97. getQiHao = i.ToString();
  98. matchItem = openList.FirstOrDefault(r => r.Term.ToString() == getQiHao);
  99. if (matchItem != null && services.AddDTOpen7Code(currentLottery, matchItem))
  100. {
  101. //Do Success Log
  102. log.Info(GetType(), CommonHelper.GetJobMainLogInfo(Config, getQiHao));
  103. LatestItem = matchItem;
  104. isGetData = true;
  105. }
  106. }
  107. }
  108. }
  109. /// <summary>
  110. /// 根据主站获取数据列表
  111. /// </summary>
  112. /// <param name="mainUrl"></param>
  113. /// <returns></returns>
  114. private List<OpenCode7DTModel> GetOpenListFromMainUrl(string mainUrl)
  115. {
  116. var result = new List<OpenCode7DTModel>();
  117. try
  118. {
  119. var url = new Uri(mainUrl);
  120. var htmlResource = NetHelper.GetUrlResponse(mainUrl, Encoding.GetEncoding("utf-8"));
  121. if (htmlResource == null) return result;
  122. var doc = new HtmlDocument();
  123. doc.LoadHtml(htmlResource);
  124. var table = doc.DocumentNode.SelectSingleNode("//table");
  125. if (table == null) return result;
  126. var trs = table.ChildNodes.Where(node => node.Name == "tr").ToList();
  127. OpenCode7DTModel model = null;
  128. HtmlNode nodeA = null;
  129. var optimizeUrl = string.Empty;
  130. for (var i = 2; i < trs.Count; i++) //第一二行为表头
  131. {
  132. var trstyle = trs[i].Attributes["style"];
  133. if (trstyle != null && trstyle.Value == "display:none") continue;
  134. var tds = trs[i].ChildNodes.Where(node => node.Name == "td").ToList();
  135. if (tds.Count < 14) continue;
  136. model = new OpenCode7DTModel();
  137. nodeA = tds[24].ChildNodes.Where(n => n.Name == "a").FirstOrDefault();
  138. if (nodeA == null) continue;
  139. model.Term = Convert.ToInt64(tds[0].InnerText.Trim());
  140. model.DetailUrl = new Uri(url, optimizeUrl).AbsoluteUri;
  141. model.OpenTime = Convert.ToDateTime(tds[1].InnerText.Substring(0, 10));
  142. if (tds[2].ChildNodes.Count == 0) continue;
  143. var opencodeNode = tds[2].ChildNodes.Where(n => n.Name.ToLower() == "em").ToList();
  144. if (opencodeNode.Count < 7) continue;
  145. model.OpenCode1 = Convert.ToInt32(opencodeNode[0].InnerText.Trim());
  146. model.OpenCode2 = Convert.ToInt32(opencodeNode[1].InnerText.Trim());
  147. model.OpenCode3 = Convert.ToInt32(opencodeNode[2].InnerText.Trim());
  148. model.OpenCode4 = Convert.ToInt32(opencodeNode[3].InnerText.Trim());
  149. model.OpenCode5 = Convert.ToInt32(opencodeNode[4].InnerText.Trim());
  150. model.OpenCode6 = Convert.ToInt32(opencodeNode[5].InnerText.Trim());
  151. model.OpenCode7 = Convert.ToInt32(opencodeNode[6].InnerText.Trim());
  152. var details = GetKaijiangDetails(tds);
  153. model.Spare = details;
  154. result.Add(model);
  155. }
  156. var checkDataHelper = new CheckDataHelper();
  157. var dbdata = services.GetListS<OpenCode7DTModel>(currentLottery)
  158. .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
  159. checkDataHelper.CheckData(dbdata, result.ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr()),
  160. Config.Area, currentLottery);
  161. result = result.OrderByDescending(S => S.Term).ToList();
  162. }
  163. catch (Exception ex)
  164. {
  165. log.Error(GetType(),
  166. string.Format("【{0}】通过主站点抓取开奖列表时发生错误,错误信息【{1}】", Config.Area + currentLottery, ex.Message));
  167. }
  168. return result;
  169. }
  170. /// <summary>
  171. /// 获取主站的数据详情
  172. /// </summary>
  173. /// <param name="nodes"></param>
  174. /// <returns></returns>
  175. private string GetKaijiangDetails(List<HtmlNode> nodes)
  176. {
  177. var entity = new KaijiangDetailsEntity
  178. {
  179. Gdje = "",
  180. Trje = (double.Parse(nodes[3].InnerText.Trim().Replace("万", "")) * 10000).ToString()
  181. };
  182. //TODO
  183. var list1 = new List<Kaijiangitem>();
  184. //组装详情
  185. var list = new List<Kaijiangitem>
  186. {
  187. new Kaijiangitem
  188. {
  189. Name = "一等奖",
  190. Total = nodes[4].InnerText.Replace(",", ""),
  191. TotalMoney = nodes[5].InnerText.Replace(",", "")
  192. },
  193. new Kaijiangitem
  194. {
  195. Name = "二等奖",
  196. Total = nodes[6].InnerText.Replace(",", ""),
  197. TotalMoney = nodes[7].InnerText.Replace(",", "")
  198. },
  199. new Kaijiangitem
  200. {
  201. Name = "三等奖",
  202. Total = nodes[8].InnerText.Replace(",", ""),
  203. TotalMoney = "200"
  204. },
  205. new Kaijiangitem
  206. {
  207. Name = "四等奖",
  208. Total = nodes[9].InnerText.Replace(",", ""),
  209. TotalMoney = "50"
  210. },
  211. new Kaijiangitem
  212. {
  213. Name = "五等奖",
  214. Total = nodes[10].InnerText,
  215. TotalMoney = "10"
  216. },
  217. new Kaijiangitem
  218. {
  219. Name = "六等奖",
  220. Total = nodes[11].InnerText,
  221. TotalMoney = "4"
  222. },
  223. new Kaijiangitem
  224. {
  225. Name = "好运特",
  226. Total = nodes[12].InnerText,
  227. TotalMoney = nodes[13].InnerText
  228. },
  229. new Kaijiangitem
  230. {
  231. Name = "好运二",
  232. Total = nodes[14].InnerText,
  233. TotalMoney = nodes[15].InnerText
  234. },
  235. new Kaijiangitem
  236. {
  237. Name = "好运三",
  238. Total = nodes[16].InnerText,
  239. TotalMoney = nodes[17].InnerText
  240. },
  241. new Kaijiangitem
  242. {
  243. Name = "好运四",
  244. Total = nodes[18].InnerText,
  245. TotalMoney = nodes[19].InnerText
  246. },
  247. new Kaijiangitem
  248. {
  249. Name = "好运五",
  250. Total = nodes[20].InnerText,
  251. TotalMoney = nodes[21].InnerText
  252. },
  253. new Kaijiangitem
  254. {
  255. Name = "幸运奖",
  256. Total = nodes[22].InnerText,
  257. TotalMoney = nodes[23].InnerText
  258. }
  259. };
  260. entity.KaiJiangItems = list;
  261. return entity.TryToJson();
  262. }
  263. #region 通过副站爬取数据
  264. /// <summary>
  265. /// 副站数据爬取 地址:https://fx.cp2y.com/draw/history_10065_Y/
  266. /// </summary>
  267. /// <returns></returns>
  268. private List<OpenCode7DTModel> GetOpenListFromBackUrl()
  269. {
  270. var result = new List<OpenCode7DTModel>();
  271. try
  272. {
  273. var url = new Uri(Config.BackUrl);
  274. var htmlResource = NetHelper.GetUrlResponse(Config.BackUrl, Encoding.GetEncoding("gb2312"));
  275. if (htmlResource == null) return result;
  276. var doc = new HtmlDocument();
  277. doc.LoadHtml(htmlResource);
  278. var table = doc.DocumentNode.SelectSingleNode("//table");
  279. if (table == null) return result;
  280. var trs = table.ChildNodes.Where(node => node.Name == "tr").ToList();
  281. OpenCode7DTModel model = null;
  282. HtmlNode nodeA = null;
  283. var optimizeUrl = string.Empty;
  284. for (var i = 1; i < trs.Count; i++) //第一二行为表头
  285. {
  286. var trstyle = trs[i].Attributes["style"];
  287. if (trstyle != null && trstyle.Value == "display:none") continue;
  288. var tds = trs[i].ChildNodes.Where(node => node.Name == "td").ToList();
  289. if (tds.Count < 4) continue;
  290. model = new OpenCode7DTModel();
  291. nodeA = tds[0].ChildNodes.Where(n => n.Name == "a").FirstOrDefault();
  292. if (nodeA == null) continue;
  293. model.Term = Convert.ToInt64(nodeA.InnerText.Trim());
  294. optimizeUrl = nodeA.Attributes["href"].Value;
  295. model.DetailUrl = new Uri(url, optimizeUrl).AbsoluteUri;
  296. model.OpenTime = Convert.ToDateTime(tds[3].InnerText);
  297. if (tds[1].ChildNodes.Count == 0) continue;
  298. var opencodeNode = tds[1].ChildNodes.Where(n => n.Name.ToLower() == "i").ToList();
  299. if (opencodeNode.Count < 7) continue;
  300. model.OpenCode1 = Convert.ToInt32(opencodeNode[0].InnerText.Trim());
  301. model.OpenCode2 = Convert.ToInt32(opencodeNode[1].InnerText.Trim());
  302. model.OpenCode3 = Convert.ToInt32(opencodeNode[2].InnerText.Trim());
  303. model.OpenCode4 = Convert.ToInt32(opencodeNode[3].InnerText.Trim());
  304. model.OpenCode5 = Convert.ToInt32(opencodeNode[4].InnerText.Trim());
  305. model.OpenCode6 = Convert.ToInt32(opencodeNode[5].InnerText.Trim());
  306. model.OpenCode7 = Convert.ToInt32(opencodeNode[6].InnerText.Trim());
  307. result.Add(model);
  308. }
  309. var checkDataHelper = new CheckDataHelper();
  310. var dbdata = services.GetListS<OpenCode7DTModel>(currentLottery)
  311. .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
  312. checkDataHelper.CheckData(dbdata, result.ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr()),
  313. Config.Area, currentLottery);
  314. result = result.OrderByDescending(S => S.Term).ToList();
  315. }
  316. catch (Exception ex)
  317. {
  318. log.Error(GetType(),
  319. string.Format("【{0}】通过备用站点抓取开奖列表时发生错误,错误信息【{1}】", Config.Area + currentLottery, ex.Message));
  320. }
  321. return result;
  322. }
  323. /// <summary>
  324. /// 执行备用站爬取的数据插入
  325. /// </summary>
  326. private void DoBackUrl()
  327. {
  328. if (!string.IsNullOrEmpty(Config.BackUrl))
  329. {
  330. var OpenList = GetOpenListFromBackUrl();
  331. if (OpenList.Count == 0) return; //无抓取数据
  332. var newestQiHao = OpenList.First().Term.ToString();
  333. var startQiNum = Convert.ToInt32(LatestItem.Term.ToString().Substring(4)) + 1;
  334. var newestQiNum = Convert.ToInt32(newestQiHao.Substring(4));
  335. if (startQiNum > newestQiNum) return; //无最新数据
  336. //处理最新开奖数据
  337. var getQiHao = string.Empty;
  338. OpenCode7DTModel matchItem = null;
  339. for (var i = startQiNum; i <= newestQiNum; i++)
  340. {
  341. getQiHao = i.ToString();
  342. matchItem = OpenList.Where(R => R.Term.ToString() == getQiHao).FirstOrDefault();
  343. if (matchItem != null && services.AddDTOpen7Code(currentLottery, matchItem))
  344. {
  345. //Do Success Log
  346. log.Info(GetType(), CommonHelper.GetJobBackLogInfo(Config, getQiHao));
  347. LatestItem = matchItem;
  348. isGetData = true;
  349. }
  350. }
  351. }
  352. }
  353. #endregion
  354. #region Attribute
  355. /// <summary>
  356. /// 配置信息
  357. /// </summary>
  358. private SCCConfig Config;
  359. /// <summary>
  360. /// 当天抓取的最新一期开奖记录
  361. /// </summary>
  362. private OpenCode7DTModel LatestItem;
  363. /// <summary>
  364. /// 当天抓取失败列表
  365. /// </summary>
  366. private List<string> FailedQiHaoList = null;
  367. /// <summary>
  368. /// 日志对象
  369. /// </summary>
  370. private readonly LogHelper log;
  371. /// <summary>
  372. /// 数据服务
  373. /// </summary>
  374. private readonly IDTOpenCode services;
  375. /// <summary>
  376. /// 当前彩种
  377. /// </summary>
  378. private SCCLottery currentLottery => SCCLottery.GuangXiKLSC;
  379. /// <summary>
  380. /// 邮件接口
  381. /// </summary>
  382. private IEmail email;
  383. /// <summary>
  384. /// 是否本次运行抓取到开奖数据
  385. /// </summary>
  386. private bool isGetData;
  387. #endregion
  388. }
  389. }