AH11X5Job.cs 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Xml;
  5. using HtmlAgilityPack;
  6. using Newtonsoft.Json.Linq;
  7. using Quartz;
  8. using SCC.Common;
  9. using SCC.Crawler.Tools;
  10. using SCC.Interface;
  11. using SCC.Models;
  12. using SCC.Services;
  13. namespace SCC.Crawler.GP
  14. {
  15. /// <summary>
  16. /// 安徽11选5
  17. /// </summary>
  18. [DisallowConcurrentExecution]
  19. [PersistJobDataAfterExecution]
  20. public class AH11X5Job : IJob
  21. {
  22. /// <summary>
  23. /// 构造函数
  24. /// </summary>
  25. public AH11X5Job()
  26. {
  27. log = new LogHelper();
  28. services = IOC.Resolve<IOpen5Code>();
  29. email = IOC.Resolve<IEmail>();
  30. }
  31. /// 作业执行入口
  32. /// </summary>
  33. /// <param name="context">作业执行上下文</param>
  34. public void Execute(IJobExecutionContext context)
  35. {
  36. Config = CommonHelper.GetConfigFromDataMap(context.JobDetail.JobDataMap);
  37. //预设节假日不开奖
  38. if (Config.SkipDate.Contains(CommonHelper.SCCSysDateTime.ToString("yyyyMMdd"))) return;
  39. LatestQiHao = context.JobDetail.JobDataMap.GetString("LatestQiHao");
  40. try
  41. {
  42. //服务启动时配置初始数据
  43. if (string.IsNullOrEmpty(LatestQiHao))
  44. {
  45. var lastItem = services.GetLastItem(currentLottery);
  46. if (lastItem != null) LatestQiHao = lastItem.Term.ToString();
  47. }
  48. //第一次启动服务或最新期号为昨天的开奖期号,则自检昨天开奖数据是否抓取完毕(否则插入邮件数据),并重置当天期号和失败列表
  49. if (string.IsNullOrEmpty(LatestQiHao) ||
  50. !LatestQiHao.StartsWith(CommonHelper.SCCSysDateTime.ToString("yyMMdd")))
  51. {
  52. CheckingYesterdayTheLotteryData();
  53. LatestQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(0);
  54. }
  55. //当最新期号不符合当天总期数,执行当天作业
  56. if (Convert.ToInt32(LatestQiHao.Substring(6)) != Config.TimesPerDay)
  57. {
  58. DoTodayJobByMainUrl();
  59. DoTodayJobByBackUrl();
  60. }
  61. }
  62. catch (Exception ex)
  63. {
  64. log.Error(GetType(), string.Format("【{0}】抓取时发生错误,错误信息【{1}】", Config.Area + currentLottery, ex.Message));
  65. }
  66. //保存最新期号和失败期号列表
  67. context.JobDetail.JobDataMap["LatestQiHao"] = LatestQiHao;
  68. }
  69. /// <summary>
  70. /// 自检昨天开奖数据
  71. /// </summary>
  72. private void CheckingYesterdayTheLotteryData()
  73. {
  74. if (Config.SkipDate.Contains(CommonHelper.SCCSysDateTime.AddDays(-1).ToString("yyyyMMdd")))
  75. return; //如果昨日设定不开奖则不自检昨日开奖数据
  76. //从数据库中获取昨天数据抓取失败列表
  77. FailedQiHaoList = services.GetYesterdayFailQQList(currentLottery, Config.TimesPerDay);
  78. if (FailedQiHaoList.Count > 0)
  79. {
  80. DoYesterdayFailedListByMainUrl();
  81. DoYesterdayFailedListByBackUrl();
  82. //foreach (var fQiHao in FailedQiHaoList)
  83. //{
  84. // //将抓取失败数据推送至邮件列表,待邮件服务发送至配置管理员的邮箱中
  85. // // if (email.AddEmail(Config.Area +currentLottery, fQiHao, CommonHelper.GenerateYesterdayOpenTime(Config, fQiHao))) 目前没有配置邮件信息数据库
  86. // log.Error(this.GetType(), CommonHelper.GetJobLogError(Config, fQiHao));
  87. //}
  88. }
  89. }
  90. /// <summary>
  91. /// 从备用地址执行今天任务
  92. /// </summary>
  93. private void DoTodayJobByBackUrl()
  94. {
  95. if (!string.IsNullOrEmpty(Config.BackUrl))
  96. {
  97. var OpenList = GetDocByBackUrl();
  98. if (OpenList.Count == 0) return; //无抓取数据
  99. var newestQiHao = OpenList.Max(w => w.Id).ToString();
  100. var startQiNum = Convert.ToInt32(LatestQiHao.Substring(6)) + 1;
  101. var newestQiNum = Convert.ToInt32(newestQiHao.Substring(6));
  102. if (startQiNum > newestQiNum) return; //无最新数据
  103. //处理最新开奖数据
  104. var total = OpenList.Count;
  105. var getQiHao = string.Empty;
  106. for (var i = startQiNum; i <= newestQiNum; i++)
  107. {
  108. getQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(i);
  109. var matchItem = OpenList.Where(R => R.Id.ToString() == getQiHao).FirstOrDefault();
  110. var step = 0;
  111. var nowQiHao = Convert.ToInt32(getQiHao);
  112. while (matchItem == null)
  113. if (step <= total)
  114. {
  115. nowQiHao++;
  116. step++;
  117. matchItem = OpenList.Where(R => R.Id.ToString() == nowQiHao.ToString()).FirstOrDefault();
  118. }
  119. else
  120. {
  121. matchItem = null;
  122. break;
  123. }
  124. if (matchItem != null && SaveRecord(matchItem))
  125. {
  126. //处理成功写入日志
  127. log.Info(GetType(), CommonHelper.GetJobBackLogInfo(Config, getQiHao));
  128. LatestQiHao = getQiHao;
  129. }
  130. }
  131. }
  132. }
  133. /// <summary>
  134. /// 通过主站点抓取开奖数据
  135. /// </summary>
  136. private void DoTodayJobByMainUrl()
  137. {
  138. var OpenList = GetDocByMainUrl();
  139. if (OpenList.Count == 0) return; //无抓取数据
  140. var newestQiHao = OpenList.Max(W => W.Id).ToString();
  141. var startQiNum = Convert.ToInt32(LatestQiHao.Substring(6)) + 1;
  142. var newestQiNum = Convert.ToInt32(newestQiHao.Substring(6));
  143. if (startQiNum > newestQiNum) return; //无最新数据
  144. var total = OpenList.Count;
  145. //处理最新开奖数据
  146. var getQiHao = string.Empty;
  147. for (var i = startQiNum; i <= newestQiNum; i++)
  148. {
  149. getQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(i);
  150. var matchItem = OpenList.Where(R => R.Id.ToString() == getQiHao).FirstOrDefault();
  151. var step = 0;
  152. var nowQiHao = Convert.ToInt32(getQiHao);
  153. while (matchItem == null)
  154. if (step <= total)
  155. {
  156. nowQiHao++;
  157. step++;
  158. matchItem = OpenList.Where(R => R.Id.ToString() == nowQiHao.ToString()).FirstOrDefault();
  159. }
  160. else
  161. {
  162. matchItem = null;
  163. break;
  164. }
  165. if (matchItem != null && SaveRecord(matchItem))
  166. {
  167. //处理成功写入日志
  168. log.Info(GetType(), CommonHelper.GetJobMainLogInfo(Config, getQiHao));
  169. LatestQiHao = getQiHao;
  170. }
  171. }
  172. }
  173. /// <summary>
  174. /// 从备用网址处理昨天失败的开彩
  175. /// </summary>
  176. public void DoYesterdayFailedListByBackUrl()
  177. {
  178. if (!string.IsNullOrEmpty(Config.BackUrl) && FailedQiHaoList.Count > 0)
  179. {
  180. var OpenList = GetDocByBackUrl(false);
  181. if (OpenList.Count == 0) return; //无抓取数据
  182. var SuccessList = new List<string>();
  183. var total = OpenList.Count;
  184. foreach (var failedQiHao in FailedQiHaoList)
  185. {
  186. var matchItem = OpenList.Where(R => R.Id.ToString() == failedQiHao).FirstOrDefault();
  187. var step = 0;
  188. var nowQiHao = Convert.ToInt32(failedQiHao);
  189. while (matchItem == null)
  190. if (step <= total)
  191. {
  192. nowQiHao++;
  193. step++;
  194. matchItem = OpenList.Where(R => R.Id.ToString() == nowQiHao.ToString()).FirstOrDefault();
  195. }
  196. else
  197. {
  198. matchItem = null;
  199. break;
  200. }
  201. if (matchItem != null && SaveRecord(matchItem))
  202. {
  203. //处理成功写入日志
  204. log.Info(GetType(), CommonHelper.GetJobBackLogInfo(Config, failedQiHao));
  205. SuccessList.Add(failedQiHao);
  206. }
  207. }
  208. foreach (var successQiHao in SuccessList) FailedQiHaoList.Remove(successQiHao);
  209. }
  210. }
  211. /// <summary>
  212. /// 保存开奖信息到数据库中
  213. /// </summary>
  214. /// <param name="list"></param>
  215. /// <summary>
  216. /// 通过主站抓取错误期号列表中每一个期号
  217. /// </summary>
  218. private void DoYesterdayFailedListByMainUrl()
  219. {
  220. var OpenList = GetDocByMainUrl(false);
  221. if (OpenList.Count == 0) return; //无抓取数据
  222. var SuccessList = new List<string>();
  223. var total = OpenList.Count;
  224. foreach (var failedQiHao in FailedQiHaoList)
  225. {
  226. var matchItem = OpenList.Where(R => R.Id.ToString() == failedQiHao).FirstOrDefault();
  227. var step = 0;
  228. var nowQiHao = Convert.ToInt32(failedQiHao);
  229. while (matchItem == null)
  230. if (step <= total)
  231. {
  232. nowQiHao++;
  233. step++;
  234. matchItem = OpenList.Where(R => R.Id.ToString() == nowQiHao.ToString()).FirstOrDefault();
  235. }
  236. else
  237. {
  238. matchItem = null;
  239. break;
  240. }
  241. if (matchItem != null && SaveRecord(matchItem))
  242. {
  243. //处理成功写入日志
  244. log.Info(GetType(), CommonHelper.GetJobMainLogInfo(Config, failedQiHao));
  245. SuccessList.Add(failedQiHao);
  246. }
  247. }
  248. foreach (var successQiHao in SuccessList) FailedQiHaoList.Remove(successQiHao);
  249. }
  250. /// <summary>
  251. /// 从备用站抓取开奖数据 昨天/今天
  252. /// </summary>
  253. /// <param name="IsToday"></param>
  254. /// <returns></returns>
  255. /// <summary>
  256. /// 从主站抓取开奖数据 昨天/今天
  257. /// </summary>
  258. /// <param name="IsToday"></param>
  259. /// <returns></returns>
  260. private List<AH11X5Enitity> GetDocByMainUrl(bool IsToday = true)
  261. {
  262. var list = new List<AH11X5Enitity>();
  263. try
  264. {
  265. var time = DateTime.Now;
  266. var arg = new OpenCaiApiArg
  267. {
  268. code = EnumHelper.GetLotteryCode(SCCLottery.AnHui11x5),
  269. // rows = int.Parse(GetPeriodsNumberToDay(time, IsToday)),
  270. date = time.ToString("yyyy-MM-dd")
  271. };
  272. if (!IsToday) arg.date = time.AddDays(-1).ToString("yyyy-MM-dd");
  273. var data = OpenCaiApiServices.GetOpenCaiApiData(arg);
  274. if (data == null) return list;
  275. if (data.data != null)
  276. {
  277. if (data.data.Count == 0) return list;
  278. for (var i = 0; i < data.data.Count; i++)
  279. {
  280. var tmp = new AH11X5Enitity
  281. {
  282. Id = int.Parse(data.data[i].GetTermStr()),
  283. OpenCode = data.data[i].GetOpenCodeStr(),
  284. OpenTime = DateTime.Parse(data.data[i].opentime)
  285. };
  286. list.Add(tmp);
  287. }
  288. var checkDataHelper = new CheckDataHelper();
  289. if (services.GetListIn(currentLottery, IsToday) == null)
  290. {
  291. log.Warn(GetType(), string.Format("【{0}】昨天没有数据更新,请检查【{0}】。", Config.Area + currentLottery));
  292. return list;
  293. }
  294. var dbdata = services.GetListIn(currentLottery, IsToday)
  295. .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
  296. checkDataHelper.CheckData(dbdata, list.ToDictionary(w => w.Id.ToString(), w => w.OpenCode),
  297. Config.Area, currentLottery);
  298. }
  299. }
  300. catch (Exception ee)
  301. {
  302. log.Error(GetType(),
  303. string.Format("【{0}】通过主站点抓取开奖列表时发生错误,错误信息【{1}】", Config.Area + currentLottery, ee.Message));
  304. }
  305. return list;
  306. }
  307. /// <summary>
  308. /// 从备用站抓取开奖数据 昨天/今天
  309. /// </summary>
  310. /// <param name="IsToday"></param>
  311. /// <returns></returns>
  312. private List<AH11X5Enitity> GetDocByBackUrl(bool IsToday = true)
  313. {
  314. var list = new List<AH11X5Enitity>();
  315. try
  316. {
  317. var day = DateTime.Now.ToString("yyyyMMdd");
  318. if (!IsToday) day = DateTime.Now.AddDays(-1).ToString("yyyyMMdd");
  319. var url = string.Format(Config.BackUrl, day);
  320. var HtmlResource = NetHelper.GetUrlResponse(url);
  321. if (HtmlResource == null) return list;
  322. var doc = new XmlDocument();
  323. doc.LoadXml(HtmlResource);
  324. var records = doc.SelectNodes("//row");
  325. if (records == null) return list;
  326. foreach (XmlNode xmlnode in records)
  327. {
  328. if (xmlnode.Attributes["expect"] == null ||
  329. string.IsNullOrWhiteSpace(xmlnode.Attributes["expect"].Value) ||
  330. xmlnode.Attributes["opencode"] == null ||
  331. string.IsNullOrWhiteSpace(xmlnode.Attributes["opencode"].Value)) continue;
  332. var num = xmlnode.Attributes["expect"].Value.Replace("-", "");
  333. var opencode = xmlnode.Attributes["opencode"].Value;
  334. var opentime = xmlnode.Attributes["opentime"].Value;
  335. var tmp = new AH11X5Enitity
  336. {
  337. Id = int.Parse(num),
  338. OpenCode = opencode,
  339. OpenTime = DateTime.Parse(opentime)
  340. };
  341. list.Add(tmp);
  342. }
  343. var checkDataHelper = new CheckDataHelper();
  344. var dbdata = services.GetListIn(currentLottery, IsToday)
  345. .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
  346. checkDataHelper.CheckData(dbdata, list.ToDictionary(w => w.Id.ToString(), w => w.OpenCode), Config.Area,
  347. currentLottery);
  348. }
  349. catch (Exception ee)
  350. {
  351. log.Error(GetType(),
  352. string.Format("【{0}】通过副站点抓取开奖列表时发生错误,错误信息【{1}】", Config.Area + currentLottery, ee.Message));
  353. }
  354. return list;
  355. }
  356. /// <summary>
  357. /// 将此彩种指定期号和开奖号码保存至数据库
  358. /// </summary>
  359. /// <param name="QiHao">期号</param>
  360. /// <param name="OpenCode">开奖号码(形如01,02,03)</param>
  361. /// <param name="IsYesterdayRecord">是否是保存昨天的记录</param>
  362. /// <returns></returns>
  363. private bool SaveRecord(AH11X5Enitity data)
  364. {
  365. var model = new OpenCode5Model();
  366. model.Term = Convert.ToInt64(data.Id); //期号
  367. var haoMaArray = data.OpenCode.Split(',');
  368. model.OpenCode1 = Convert.ToInt32(haoMaArray[0]);
  369. model.OpenCode2 = Convert.ToInt32(haoMaArray[1]);
  370. model.OpenCode3 = Convert.ToInt32(haoMaArray[2]);
  371. model.OpenCode4 = Convert.ToInt32(haoMaArray[3]);
  372. model.OpenCode5 = Convert.ToInt32(haoMaArray[4]);
  373. model.OpenTime = data.OpenTime;
  374. if (services.AddOpen5Code(currentLottery, model))
  375. {
  376. GetMaxPeriodNum((int)model.Term); //添加成功存放期数
  377. return true;
  378. }
  379. return false;
  380. }
  381. /// <summary>
  382. /// 获取今天期数
  383. /// </summary>
  384. /// <param name="time"></param>
  385. /// <param name="IsToday"></param>
  386. /// <returns></returns>
  387. public string GetPeriodsNumberToDay(DateTime time, bool IsToday = false)
  388. {
  389. if (!IsToday) return Config.TimesPerDay.ToString();
  390. int hc = 0, mc = 0;
  391. if (time.Hour >= Config.StartHour) //
  392. {
  393. hc = (time.Hour - Config.StartHour) * 6; //已开期数小时部分
  394. mc = time.Minute / 10; //已开期分钟部分
  395. if (Config.StartMinute == 0) mc += 1;
  396. }
  397. return hc + mc >= 10 ? (hc + mc).ToString() : "0" + (hc + mc); //;
  398. }
  399. /// <summary>
  400. /// 比较期号大的存入LatestQiHao
  401. /// </summary>
  402. /// <param name="PeriodNum"></param>
  403. public void GetMaxPeriodNum(int PeriodNum)
  404. {
  405. var lastqihao = 0;
  406. int.TryParse(LatestQiHao, out lastqihao);
  407. if (lastqihao < PeriodNum) LatestQiHao = PeriodNum.ToString();
  408. }
  409. #region Attribute
  410. /// <summary>
  411. /// 配置信息
  412. /// </summary>
  413. private SCCConfig Config;
  414. /// <summary>
  415. /// 当天抓取的最新一期期号
  416. /// </summary>
  417. private string LatestQiHao;
  418. /// <summary>
  419. /// 当天抓取失败列表
  420. /// </summary>
  421. private List<string> FailedQiHaoList;
  422. /// <summary>
  423. /// 日志对象
  424. /// </summary>
  425. private readonly LogHelper log;
  426. /// <summary>
  427. /// 数据服务
  428. /// </summary>
  429. private readonly IOpen5Code services;
  430. /// <summary>
  431. /// 当前彩种
  432. /// </summary>
  433. private SCCLottery currentLottery => SCCLottery.AnHui11x5;
  434. /// <summary>
  435. /// 邮件接口
  436. /// </summary>
  437. private IEmail email;
  438. #endregion
  439. }
  440. /// <summary>
  441. /// 开奖号实体
  442. /// </summary>
  443. public class AH11X5Enitity
  444. {
  445. public int Id { get; set; }
  446. public string OpenCode { get; set; }
  447. public DateTime OpenTime { get; set; }
  448. }
  449. }