old-ssc/SCC.Crawler/GP/JL11X5Job.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Xml;

using Quartz;
using SCC.Common;
using SCC.Models;
using SCC.Interface;
using HtmlAgilityPack;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace SCC.Crawler.GP
{
    /// <summary>
    /// 数据爬取类
    /// 吉林11选5
    /// </summary>
    [DisallowConcurrentExecution]
    [PersistJobDataAfterExecution]
    public class JL11X5Job : IJob
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        public JL11X5Job()
        {
            log = new LogHelper();
            services = IOC.Resolve<IOpen5Code>();
            email = IOC.Resolve<IEmail>();
        }

        /// <summary>
        /// 作业执行入口
        /// </summary>
        /// <param name="context">作业执行上下文</param>
        public void Execute(IJobExecutionContext context)
        {
            Config = CommonHelper.GetConfigFromDataMap(context.JobDetail.JobDataMap);
            //预设节假日不开奖
            if (Config.SkipDate.Contains(CommonHelper.SCCSysDateTime.ToString("yyyyMMdd"))) return;
            LatestQiHao = context.JobDetail.JobDataMap.GetString("LatestQiHao");
            try
            {
                //服务启动时配置初始数据
                if (string.IsNullOrEmpty(LatestQiHao))
                {
                    var lastItem = services.GetLastItem(currentLottery);
                    if (lastItem != null)
                    {
                        LatestQiHao = lastItem.Term.ToString();
                    }
                }
                //第一次启动服务或最新期号为昨天的开奖期号，则自检昨天开奖数据是否抓取完毕(否则插入邮件数据)，并重置当天期号和失败列表
                if (string.IsNullOrEmpty(LatestQiHao) || !LatestQiHao.StartsWith(CommonHelper.SCCSysDateTime.ToString("yyMMdd")))
                {
                    CheckingYesterdayTheLotteryData();
                    LatestQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(0);
                }
                //当最新期号不符合当天总期数，执行当天作业
                if (Convert.ToInt32(LatestQiHao.Substring(6)) != Config.TimesPerDay)
                {
                    DoTodayJobByDB();
                    //DoTodayJobByMainUrl();
                    //DoTodayJobByBackUrl();
                }
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】抓取时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            //保存最新期号和失败期号列表
            context.JobDetail.JobDataMap["LatestQiHao"] = LatestQiHao;
        }

        /// <summary>
        /// 自检昨天开奖数据
        /// </summary>
        private void CheckingYesterdayTheLotteryData()
        {
            if (Config.SkipDate.Contains(CommonHelper.SCCSysDateTime.AddDays(-1).ToString("yyyyMMdd"))) return;//如果昨日设定不开奖则不自检昨日开奖数据
            //从数据库中获取昨天数据抓取失败列表
            FailedQiHaoList = services.GetYesterdayFailQQList(currentLottery, Config.TimesPerDay);
            if (FailedQiHaoList.Count > 0)
            {
                DoYesterdayFailedListByMainUrl_New();
                //DoYesterdayFailedListByMainUrl();
                //DoYesterdayFailedListByBackUrl();
                foreach (var fQiHao in FailedQiHaoList)
                {
                    //将抓取失败数据推送至邮件列表，待邮件服务发送至配置管理员的邮箱中
                    if (email.AddEmail(Config.Area + Config.LotteryName, fQiHao, CommonHelper.GenerateYesterdayOpenTime(Config, fQiHao)))
                        log.Error(typeof(JL11X5Job), CommonHelper.GetJobLogError(Config, fQiHao));
                }
            }
        }
        /// <summary>
        /// 新开奖号数据库拿取
        /// </summary>
        private void DoYesterdayFailedListByMainUrl_New()
        {
            var OpenList = GetYesterdayOpenListFromDB_new();
            if (OpenList.Count == 0) return;//无抓取数据
            var SuccessList = new List<string>();
            foreach (string failedQiHao in FailedQiHaoList)
            {
                var matchItem = OpenList.Where(R => R.Key == failedQiHao).FirstOrDefault();
                if (matchItem.Key != null && SaveRecord(failedQiHao, matchItem.Value, true))
                {
                    //处理成功写入日志
                    log.Info(typeof(JL11X5Job), CommonHelper.GetJobMainLogInfo(Config, failedQiHao));
                    SuccessList.Add(failedQiHao);
                    continue;
                }
            }
            foreach (var successQiHao in SuccessList)
            {
                FailedQiHaoList.Remove(successQiHao);
            }
        }
        /// <summary>
        /// 通过数据库点抓取昨日开奖列表
        /// </summary>
        /// <returns></returns>
        private Dictionary<string, string> GetYesterdayOpenListFromDB_new()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                var list = services.GetYesterdayFailQQListDB5(currentLottery, Config.TimesPerDay);
                result = list;
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过主站点抓取昨日开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            return result;
        }
        /// <summary>
        /// 通过数据库获取开奖数据
        /// </summary>
        private void DoTodayJobByDB()
        {

            var OpenList = services.GetYesterdayFailQQListDB5_toDay(currentLottery, Config.TimesPerDay);
            if (OpenList.Count == 0) return;//无抓取数据
            var newestQiHao = OpenList.OrderBy(a => a.Key).Last().Key;
            var startQiNum = Convert.ToInt32(LatestQiHao.Substring(6)) + 1;
            var newestQiNum = Convert.ToInt32(newestQiHao.Substring(6));
            if (startQiNum > newestQiNum) return;//无最新数据
                                                 //处理最新开奖数据
            string getQiHao = string.Empty;
            for (var i = startQiNum; i <= newestQiNum; i++)
            {
                getQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(i);
                var matchItem = OpenList.Where(R => R.Key == getQiHao).FirstOrDefault();
                if (matchItem.Key != null && SaveRecord(getQiHao, matchItem.Value, false))
                {
                    //处理成功写入日志
                    log.Info(typeof(JL11X5Job), CommonHelper.GetJobMainLogInfo(Config, getQiHao));
                    LatestQiHao = getQiHao;
                }
            }
        }
        /// <summary>
        /// 通过主站点抓取开奖数据
        /// (吉林体彩官网)
        /// </summary>
        private void DoTodayJobByMainUrl()
        {
            if (!string.IsNullOrEmpty(Config.MainUrl))
            {
                var OpenList = GetTodayOpenListFromMainUrl();
                if (OpenList.Count == 0) return;//无抓取数据
                var newestQiHao = OpenList.First().Key;
                var startQiNum = Convert.ToInt32(LatestQiHao.Substring(6)) + 1;
                var newestQiNum = Convert.ToInt32(newestQiHao.Substring(6));
                if (startQiNum > newestQiNum) return;//无最新数据
                //处理最新开奖数据
                string getQiHao = string.Empty;
                for (var i = startQiNum; i <= newestQiNum; i++)
                {
                    getQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(i);
                    var matchItem = OpenList.Where(R => R.Key == getQiHao).FirstOrDefault();
                    if (matchItem.Key != null && SaveRecord(getQiHao, matchItem.Value, false))
                    {
                        //处理成功写入日志
                        log.Info(typeof(JL11X5Job), CommonHelper.GetJobMainLogInfo(Config, getQiHao));
                        LatestQiHao = getQiHao;
                    }
                }

                //foreach (KeyValuePair<string, string> pair in OpenList)
                //{
                //    if (SaveRecord(pair.Key, pair.Value, false))
                //    {
                //        //处理成功写入日志
                //        log.Info(typeof(JL11X5Job), CommonHelper.GetJobMainLogInfo(Config, getQiHao));
                //        LatestQiHao = getQiHao;
                //    }
                //}

            }
        }

        /// <summary>
        /// 通过主站抓取错误期号列表中每一个期号
        /// (吉林体彩官网)
        /// </summary>
        private void DoYesterdayFailedListByMainUrl()
        {
            if (!string.IsNullOrEmpty(Config.MainUrl) && FailedQiHaoList.Count > 0)
            {
                var OpenList = GetYesterdayOpenListFromMainUrl();
                if (OpenList.Count == 0) return;//无抓取数据
                var SuccessList = new List<string>();
                foreach (string failedQiHao in FailedQiHaoList)
                {
                    var matchItem = OpenList.Where(R => R.Key == failedQiHao).FirstOrDefault();
                    if (matchItem.Key != null && SaveRecord(failedQiHao, matchItem.Value, true))
                    {
                        //处理成功写入日志
                        log.Info(typeof(JL11X5Job), CommonHelper.GetJobMainLogInfo(Config, failedQiHao));
                        SuccessList.Add(failedQiHao);
                        continue;
                    }
                }
                foreach (var successQiHao in SuccessList)
                {
                    FailedQiHaoList.Remove(successQiHao);
                }
            }
        }

        /// <summary>
        /// 通过主站点抓取今日最新开奖列表
        /// </summary>
        /// <returns></returns>
        private Dictionary<string, string> GetTodayOpenListFromMainUrl()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                var HtmlResource = NetHelper.GetUrlResponse(Config.MainUrl);
                if (string.IsNullOrWhiteSpace(HtmlResource)) return result;
                HtmlDocument doc = new HtmlDocument();
                doc.LoadHtml(HtmlResource);

                #region 历史代码，已废弃 By 大师兄
                //var table = doc.GetElementbyId("ContentPlaceHolder1_DataListHistory");
                //if (table == null) return result;
                //var trs = table.ChildNodes.Where(n => n.Name == "tr").ToList();
                //string matchQiHao = string.Empty;
                //string matchKJHaoMa = string.Empty;
                //foreach (var tr in trs)
                //{
                //    var tds = tr.ChildNodes.Where(n => n.Name == "td").ToList();
                //    foreach (var td in tds)
                //    {
                //        var tdtable = td.ChildNodes.Where(n => n.Name == "table").FirstOrDefault();
                //        if (tdtable != null)
                //        {
                //            var tdtr = tdtable.ChildNodes.Where(n => n.Name == "tr").FirstOrDefault();
                //            if (tdtr != null)
                //            {
                //                var tdtds = tdtr.ChildNodes.Where(n => n.Name == "td").ToList();
                //                matchQiHao = tdtds[0].InnerText.Replace("\r\n", "").Trim();
                //                matchKJHaoMa = tdtds[1].InnerText.Replace("\r\n", "").Trim();
                //                if (!string.IsNullOrWhiteSpace(matchQiHao) && !string.IsNullOrWhiteSpace(matchKJHaoMa))
                //                {
                //                    result.Add(matchQiHao, matchKJHaoMa.Replace("&nbsp;&nbsp;", ","));
                //                }
                //            }
                //        }
                //    }
                //} 
                #endregion

                HtmlNodeCollection tbody_collection = doc.DocumentNode.SelectNodes("/html/body/div[2]/div[3]/div[1]/table/tbody");
                if (tbody_collection != null && tbody_collection.Count > 0)
                {
                    List<HtmlNode> tr_collection = tbody_collection[0].ChildNodes.Where(n => n.Name.Equals("tr")).ToList();
                    foreach (HtmlNode htmlNode in tr_collection)
                    {
                        //开始分析td
                        List<HtmlNode> td_node = htmlNode.ChildNodes.Where(n => n.Name.Equals("td")).ToList();
                        if (td_node.Count > 0)
                        {
                            //期号
                            string qihao = td_node[0].InnerText.Trim();
                            //开奖号
                            string kjh = td_node[1].InnerText.Trim().Replace("\n", ",").Replace(" ", "");
                            //开奖时间
                            //string opentime = "2018-" + td_node[5].InnerText.Trim();

                            //result.Add(qihao + "|" + opentime, kjh);
                            result.Add(qihao, kjh);
                        }
                    }
                }
                result = result.OrderByDescending(s => s.Key).ToDictionary(k => k.Key, v => v.Value);
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过主站点抓取今日最新开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            return result;
        }
        /// <summary>
        /// 抓取主站点开奖数据
        /// </summary>
        /// <returns></returns>
        private Dictionary<string, string> GetYesterdayOpenListFromMainUrl_ByeBye()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                #region Code
                var HtmlResource = NetHelper.GetJL11X5UrlResponse(Config.MainUrl, string.Format("ctl00%24ScriptManagerLottery=ctl00%24ContentPlaceHolder1%24UpdatePanel1%7Cctl00%24ContentPlaceHolder1%24DropDownListDays&ctl00%24ContentPlaceHolder1%24DropDownListDays={0}&__EVENTTARGET=ctl00%24ContentPlaceHolder1%24DropDownListDays&__EVENTARGUMENT=&__LASTFOCUS=&__VIEWSTATE=%2FwEPDwUIODY2MjY3MjAPZBYCZg9kFgICAw9kFgICAw9kFgQCAQ8WAh4LXyFJdGVtQ291bnQCChYUAgEPZBYCZg8VAwgxMTA1NDc4ND3lkInmnpfkvZPlvakxMemAiTXnjqnms5Xnm5jngrnvvJrku7vpgInkuInlj5jljJblpJog5Y%2BX5qyi6L%2BOAThkAgIPZBYCZg8VAwgxMTA1NDc3Mzfpq5jpopHkvZPlvakxMemAiTUg5Lu76YCJ5LqU5oCO5LmI546p6IO96L275p2%2B5Lit5aWW77yfATdkAgMPZBYCZg8VAwgxMTA1NDc2NT%2FlkInmnpfkvZPlvakxMemAiTXku7vpgInkuIPnjqnms5XvvJrlj6%2FnlKjog4bmi5bkuI7mnYDlj7fmipXms6gBNmQCBA9kFgJmDxUDCDExMDU0Njg3POmrmOmikeKAnDEx6YCJNeKAneaKleazqOaKgOW3p%2B%2B8muS7peiDhueggeaWueW8j%2BmAieWPlumHjeWPtwIyNGQCBQ9kFgJmDxUDCDExMDU0Njc5PeS9k%2BW9qemrmOmikTEx6YCJNemAieWPt%2BS5i%2BeDreaegeW%2FheWGtyDlsLrluqbmjozmj6HopoHmjqjmlbICMjNkAgYPZBYCZg8VAwgxMTA1NDYzMDrpq5jpopHkvZPlvanigJwxMemAiTXigJ3vvJrlpb3njqnlj4jlpb3kuK0g6LWi5aWW5LmQ57%2B75aSpAjE5ZAIHD2QWAmYPFQMIMTEwNTQ2MDY55ZCJ5p6XMTHpgIk15oqV5rOo5oqA5ben77ya6YCG5ZCR6YCJ5Y%2B35rOV5o%2BQ6auY5Lit5aWW546HAjE2ZAIID2QWAmYPFQMIMTEwNTQ1NjI%2F5ZCJ5p6XMTHpgIk15oqV5rOo5pS755Wl5YiG5Lqr77ya5YWr5aaZ5oub5bim5L2g546p6L2s55u06YCJ5LqMAjEzZAIJD2QWAmYPFQMIMTEwNTQ1NjA%2F5ZCJ5p6XMTHpgIk15oqV5rOo5pS755Wl5YiG5Lqr77ya5aaZ5oub5pWZ5Lya5L2g56iz6LWa5Lu76YCJ5LiDAjEzZAIKD2QWAmYPFQMIMTEwNTQ0OTk96auY6aKR4oCcMTHpgIk14oCd5LmL5Lu76YCJ5YWr77yaMuWFg%2BWPr%2BS5sDjnoIHlpI3lvI%2FpgIk45LitNQE2ZAIDD2QWAmYPZBYEAgEPEGQQFQ8KMDLmnIgwOeaXpQowMuaciDA45pelCjAy5pyIMDfml6UKMDLmnIgwNuaXpQowMuaciDA15pelCjAy5pyIMDTml6UKMDLmnIgwM%2BaXpQowMuaciDAy5pelCjAy5pyIMDHml6UKMDHmnIgzMeaXpQowMeaciDMw5pelCjAx5pyIMjnml6UKMDHmnIgyOOaXpQowMeaciDI35pelCjAx5pyIMjbml6UVDwYxNzAyMDkGMTcwMjA4BjE3MDIwNwYxNzAyMDYGMTcwMjA1BjE3MDIwNAYxNzAyMDMGMTcwMjAyBjE3MDIwMQYxNzAxMzEGMTcwMTMwBjE3MDEyOQYxNzAxMjgGMTcwMTI3BjE3MDEyNhQrAw9nZ2dnZ2dnZ2dnZ2dnZ2cWAWZkAgUPPCsACQEADxYEHghEYXRhS2V5cxYAHwACT2QWngFmD2QWAmYPFQIIMTcwMjA5MDE6MDgmbmJzcDsmbmJzcDswNCZuYnNwOyZuYnNwOzA1Jm5ic3A7Jm5ic3A7MDEmbmJzcDsmbmJzcDswMmQCAQ9kFgJmDxUCCDE3MDIwOTAyOjExJm5ic3A7Jm5ic3A7MDEmbmJzcDsmbmJzcDswMyZuYnNwOyZuYnNwOzA1Jm5ic3A7Jm5ic3A7MDZkAgIPZBYCZg8VAggxNzAyMDkwMzoxMCZuYnNwOyZuYnNwOzA0Jm5ic3A7Jm5ic3A7MDcmbmJzcDsmbmJzcDswNiZuYnNwOyZuYnNwOzA5ZAIDD2QWAmYPFQIIMTcwMjA5MDQ6MTAmbmJzcDsmbmJzcDswMiZuYnNwOyZuYnNwOzA2Jm5ic3A7Jm5ic3A7MTEmbmJzcDsmbmJzcDswM2QCBA9kFgJmDxUCCDE3MDIwOTA1OjA3Jm5ic3A7Jm5ic3A7MDMmbmJzcDsmbmJzcDswMiZuYnNwOyZuYnNwOzA4Jm5ic3A7Jm5ic3A7MTFkAgUPZBYCZg8VAggxNzAyMDkwNjowOSZuYnNwOyZuYnNwOzA0Jm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDswNiZuYnNwOyZuYnNwOzAyZAIGD2QWAmYPFQIIMTcwMjA5MDc6MTEmbmJzcDsmbmJzcDswMyZuYnNwOyZuYnNwOzA3Jm5ic3A7Jm5ic3A7MDUmbmJzcDsmbmJzcDswOGQCBw9kFgJmDxUCCDE3MDIwOTA4OjAyJm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDswMyZuYnNwOyZuYnNwOzAxJm5ic3A7Jm5ic3A7MDdkAggPZBYCZg8VAggxNzAyMDkwOTowMiZuYnNwOyZuYnNwOzA2Jm5ic3A7Jm5ic3A7MTEmbmJzcDsmbmJzcDswOCZuYnNwOyZuYnNwOzA5ZAIJD2QWAmYPFQIIMTcwMjA5MTA6MDMmbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzExJm5ic3A7Jm5ic3A7MDUmbmJzcDsmbmJzcDswOWQCCg9kFgJmDxUCCDE3MDIwOTExOjA0Jm5ic3A7Jm5ic3A7MDYmbmJzcDsmbmJzcDswNSZuYnNwOyZuYnNwOzAzJm5ic3A7Jm5ic3A7MTBkAgsPZBYCZg8VAggxNzAyMDkxMjoxMCZuYnNwOyZuYnNwOzA5Jm5ic3A7Jm5ic3A7MDQmbmJzcDsmbmJzcDswNiZuYnNwOyZuYnNwOzAyZAIMD2QWAmYPFQIIMTcwMjA5MTM6MTEmbmJzcDsmbmJzcDswMyZuYnNwOyZuYnNwOzA1Jm5ic3A7Jm5ic3A7MDcmbmJzcDsmbmJzcDswMWQCDQ9kFgJmDxUCCDE3MDIwOTE0OjA3Jm5ic3A7Jm5ic3A7MTAmbmJzcDsmbmJzcDswMSZuYnNwOyZuYnNwOzA0Jm5ic3A7Jm5ic3A7MDlkAg4PZBYCZg8VAggxNzAyMDkxNTowNCZuYnNwOyZuYnNwOzA4Jm5ic3A7Jm5ic3A7MDImbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzA1ZAIPD2QWAmYPFQIIMTcwMjA5MTY6MDcmbmJzcDsmbmJzcDswMiZuYnNwOyZuYnNwOzA5Jm5ic3A7Jm5ic3A7MTEmbmJzcDsmbmJzcDswNWQCEA9kFgJmDxUCCDE3MDIwOTE3OjEwJm5ic3A7Jm5ic3A7MDEmbmJzcDsmbmJzcDsxMSZuYnNwOyZuYnNwOzA2Jm5ic3A7Jm5ic3A7MDdkAhEPZBYCZg8VAggxNzAyMDkxODoxMCZuYnNwOyZuYnNwOzExJm5ic3A7Jm5ic3A7MDEmbmJzcDsmbmJzcDswOSZuYnNwOyZuYnNwOzA2ZAISD2QWAmYPFQIIMTcwMjA5MTk6MTAmbmJzcDsmbmJzcDswNSZuYnNwOyZuYnNwOzExJm5ic3A7Jm5ic3A7MDcmbmJzcDsmbmJzcDswMWQCEw9kFgJmDxUCCDE3MDIwOTIwOjA4Jm5ic3A7Jm5ic3A7MDImbmJzcDsmbmJzcDswMSZuYnNwOyZuYnNwOzA5Jm5ic3A7Jm5ic3A7MTFkAhQPZBYCZg8VAggxNzAyMDkyMTowMyZuYnNwOyZuYnNwOzA2Jm5ic3A7Jm5ic3A7MDQmbmJzcDsmbmJzcDswMSZuYnNwOyZuYnNwOzA3ZAIVD2QWAmYPFQIIMTcwMjA5MjI6MTEmbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzA0Jm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDswMWQCFg9kFgJmDxUCCDE3MDIwOTIzOjA3Jm5ic3A7Jm5ic3A7MTEmbmJzcDsmbmJzcDswNCZuYnNwOyZuYnNwOzA1Jm5ic3A7Jm5ic3A7MDZkAhcPZBYCZg8VAggxNzAyMDkyNDoxMCZuYnNwOyZuYnNwOzA2Jm5ic3A7Jm5ic3A7MDQmbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzAxZAIYD2QWAmYPFQIIMTcwMjA5MjU6MDImbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzEwJm5ic3A7Jm5ic3A7MTEmbmJzcDsmbmJzcDswM2QCGQ9kFgJmDxUCCDE3MDIwOTI2OjA0Jm5ic3A7Jm5ic3A7MDMmbmJzcDsmbmJzcDswNiZuYnNwOyZuYnNwOzA3Jm5ic3A7Jm5ic3A7MTBkAhoPZBYCZg8VAggxNzAyMDkyNzowNCZuYnNwOyZuYnNwOzA1Jm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDswNiZuYnNwOyZuYnNwOzA3ZAIbD2QWAmYPFQIIMTcwMjA5Mjg6MDUmbmJzcDsmbmJzcDswMiZuYnNwOyZuYnNwOzA5Jm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDswM2QCHA9kFgJmDxUCCDE3MDIwOTI5OjA5Jm5ic3A7Jm5ic3A7MTAmbmJzcDsmbmJzcDswMyZuYnNwOyZuYnNwOzA4Jm5ic3A7Jm5ic3A7MDJkAh0PZBYCZg8VAggxNzAyMDkzMDowMyZuYnNwOyZuYnNwOzExJm5ic3A7Jm5ic3A7MDImbmJzcDsmbmJzcDswNyZuYnNwOyZuYnNwOzA5ZAIeD2QWAmYPFQIIMTcwMjA5MzE6MDMmbmJzcDsmbmJzcDswMiZuYnNwOyZuYnNwOzExJm5ic3A7Jm5ic3A7MDUmbmJzcDsmbmJzcDswNGQCHw9kFgJmDxUCCDE3MDIwOTMyOjEwJm5ic3A7Jm5ic3A7MDgmbmJzcDsmbmJzcDsxMSZuYnNwOyZuYnNwOzAyJm5ic3A7Jm5ic3A7MDdkAiAPZBYCZg8VAggxNzAyMDkzMzowNSZuYnNwOyZuYnNwOzA0Jm5ic3A7Jm5ic3A7MTAmbmJzcDsmbmJzcDsxMSZuYnNwOyZuYnNwOzA2ZAIhD2QWAmYPFQIIMTcwMjA5MzQ6MDImbmJzcDsmbmJzcDsxMSZuYnNwOyZuYnNwOzA3Jm5ic3A7Jm5ic3A7MDQmbmJzcDsmbmJzcDswNmQCIg9kFgJmDxUCCDE3MDIwOTM1AGQCIw9kFgJmDxUCCDE3MDIwOTM2AGQCJA9kFgJmDxUCCDE3MDIwOTM3AGQCJQ9kFgJmDxUCCDE3MDIwOTM4AGQCJg9kFgJmDxUCCDE3MDIwOTM5AGQCJw9kFgJmDxUCCDE3MDIwOTQwAGQCKA9kFgJmDxUCCDE3MDIwOTQxAGQCKQ9kFgJmDxUCCDE3MDIwOTQyAGQCKg9kFgJmDxUCCDE3MDIwOTQzAGQCKw9kFgJmDxUCCDE3MDIwOTQ0AGQCLA9kFgJmDxUCCDE3MDIwOTQ1AGQCLQ9kFgJmDxUCCDE3MDIwOTQ2AGQCLg9kFgJmDxUCCDE3MDIwOTQ3AGQCLw9kFgJmDxUCCDE3MDIwOTQ4AGQCMA9kFgJmDxUCCDE3MDIwOTQ5AGQCMQ9kFgJmDxUCCDE3MDIwOTUwAGQCMg9kFgJmDxUCCDE3MDIwOTUxAGQCMw9kFgJmDxUCCDE3MDIwOTUyAGQCNA9kFgJmDxUCCDE3MDIwOTUzAGQCNQ9kFgJmDxUCCDE3MDIwOTU0AGQCNg9kFgJmDxUCCDE3MDIwOTU1AGQCNw9kFgJmDxUCCDE3MDIwOTU2AGQCOA9kFgJmDxUCCDE3MDIwOTU3AGQCOQ9kFgJmDxUCCDE3MDIwOTU4AGQCOg9kFgJmDxUCCDE3MDIwOTU5AGQCOw9kFgJmDxUCCDE3MDIwOTYwAGQCPA9kFgJmDxUCCDE3MDIwOTYxAGQCPQ9kFgJmDxUCCDE3MDIwOTYyAGQCPg9kFgJmDxUCCDE3MDIwOTYzAGQCPw9kFgJmDxUCCDE3MDIwOTY0AGQCQA9kFgJmDxUCCDE3MDIwOTY1AGQCQQ9kFgJmDxUCCDE3MDIwOTY2AGQCQg9kFgJmDxUCCDE3MDIwOTY3AGQCQw9kFgJmDxUCCDE3MDIwOTY4AGQCRA9kFgJmDxUCCDE3MDIwOTY5AGQCRQ9kFgJmDxUCCDE3MDIwOTcwAGQCRg9kFgJmDxUCCDE3MDIwOTcxAGQCRw9kFgJmDxUCCDE3MDIwOTcyAGQCSA9kFgJmDxUCCDE3MDIwOTczAGQCSQ9kFgJmDxUCCDE3MDIwOTc0AGQCSg9kFgJmDxUCCDE3MDIwOTc1AGQCSw9kFgJmDxUCCDE3MDIwOTc2AGQCTA9kFgJmDxUCCDE3MDIwOTc3AGQCTQ9kFgJmDxUCCDE3MDIwOTc4AGQCTg9kFgJmDxUCCDE3MDIwOTc5AGQYAQUeX19Db250cm9sc1JlcXVpcmVQb3N0QmFja0tleV9fFgEFLmN0bDAwJENvbnRlbnRQbGFjZUhvbGRlcjEkSW1hZ2VCdXR0b25SZWxvYWREYXlVigAZL2x9to1HjoUiGZfLAkwgezJMMOcXX2HvfG9syA%3D%3D&__EVENTVALIDATION=%2FwEWEgLVxejnCQLj%2FoKoDQLs6sLJBALs6sbJBALs6orJBALs6o7JBALs6pLJBALs6pbJBALs6prJBALs6p7JBALs6qLJBALx6raUDwLx6rqUDwLy6taUDwLy6tqUDwLy6p6UDwLy6qKUDwLI36HCCxTV72knBxbc8cRwGCWmrSCVT32AwEZAWUoArrhnCfYR&__ASYNCPOST=true&", CommonHelper.SCCSysDateTime.AddDays(-1).ToString("yyMMdd"))); 
                #endregion

                if (!string.IsNullOrWhiteSpace(HtmlResource))
                {
                    var splitList = HtmlResource.Split(new char[] { '|' });
                    if (splitList.Length < 8) return result;
                    var tableString = splitList[7].Trim();
                    HtmlDocument doc = new HtmlDocument();
                    doc.LoadHtml(tableString);
                    var table = doc.GetElementbyId("ContentPlaceHolder1_DataListHistory");
                    var trs = table.ChildNodes.Where(n => n.Name == "tr").ToList();
                    string matchQiHao = string.Empty;
                    string matchKJHaoMa = string.Empty;
                    foreach (var tr in trs)
                    {
                        var tds = tr.ChildNodes.Where(n => n.Name == "td").ToList();
                        foreach (var td in tds)
                        {
                            var tdtable = td.ChildNodes.Where(n => n.Name == "table").FirstOrDefault();
                            if (tdtable != null)
                            {
                                var tdtr = tdtable.ChildNodes.Where(n => n.Name == "tr").FirstOrDefault();
                                if (tdtr != null)
                                {
                                    var tdtds = tdtr.ChildNodes.Where(n => n.Name == "td").ToList();
                                    matchQiHao = tdtds[0].InnerText.Replace("\r\n", "").Trim();
                                    matchKJHaoMa = tdtds[1].InnerText.Replace("\r\n", "").Trim();
                                    if (!string.IsNullOrWhiteSpace(matchQiHao) && !string.IsNullOrWhiteSpace(matchKJHaoMa))
                                    {
                                        result.Add(matchQiHao, matchKJHaoMa.Replace("&nbsp;&nbsp;", ","));
                                    }
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过主站点抓取昨日开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            result = result.OrderByDescending(s => s.Key).ToDictionary(k => k.Key, v => v.Value);
            return result;
        }

        private Dictionary<string, string> GetYesterdayOpenListFromMainUrl()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                var HtmlResource = NetHelper.GetUrlResponse("http://jl11x5kjjg.icaile.com/?n=zt");

                if (string.IsNullOrWhiteSpace(HtmlResource)) return result;
                HtmlDocument doc = new HtmlDocument();
                doc.LoadHtml(HtmlResource);

                HtmlNodeCollection tbody_collection = doc.DocumentNode.SelectNodes("/html/body/div[2]/div[3]/div[1]/table/tbody");
                if (tbody_collection != null && tbody_collection.Count > 0)
                {
                    List<HtmlNode> tr_collection = tbody_collection[0].ChildNodes.Where(n => n.Name.Equals("tr")).ToList();
                    foreach (HtmlNode htmlNode in tr_collection)
                    {
                        //开始分析td
                        List<HtmlNode> td_node = htmlNode.ChildNodes.Where(n => n.Name.Equals("td")).ToList();
                        if (td_node.Count > 0)
                        {
                            //期号
                            string qihao = td_node[0].InnerText.Trim();
                            //开奖号
                            string kjh = td_node[1].InnerText.Trim().Replace("\n", ",").Replace(" ", "");
                            //开奖时间
                            //string opentime = "2018-" + td_node[5].InnerText.Trim();

                            //result.Add(qihao + "|" + opentime, kjh);
                            result.Add(qihao, kjh);
                        }
                    }
                }
                result = result.OrderByDescending(s => s.Key).ToDictionary(k => k.Key, v => v.Value);
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过主站点抓取今日最新开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            return result;
        }

        /// <summary>
        /// 通过备用站点抓取开奖数据
        /// (爱彩乐)
        /// </summary>
        private void DoTodayJobByBackUrl()
        {
            if (!string.IsNullOrEmpty(Config.BackUrl))
            {
                var OpenList = GetTodayOpenListFromBackUrl();
                if (OpenList.Count == 0) return;//无抓取数据
                var newestQiHao = OpenList.First().Key;
                var startQiNum = Convert.ToInt32(LatestQiHao.Substring(6)) + 1;
                var newestQiNum = Convert.ToInt32(newestQiHao.Substring(6));
                if (startQiNum > newestQiNum) return;//无最新数据
                //处理最新开奖数据
                var getQiHao = string.Empty;
                for (var i = startQiNum; i <= newestQiNum; i++)
                {
                    getQiHao = CommonHelper.GenerateTodayQiHaoYYMMDDQQ(i);
                    var matchItem = OpenList.Where(R => R.Key == getQiHao).FirstOrDefault();
                    if (matchItem.Key != null && SaveRecord(getQiHao, matchItem.Value, false))
                    {
                        //处理成功写入日志
                        log.Info(typeof(JL11X5Job), CommonHelper.GetJobBackLogInfo(Config, getQiHao));
                        LatestQiHao = getQiHao;
                    }
                }
            }
        }

        /// <summary>
        /// 通过备用地址抓取错误期号列表中每一个期号
        /// (爱彩乐)
        /// </summary>
        private void DoYesterdayFailedListByBackUrl()
        {
            if (!string.IsNullOrEmpty(Config.BackUrl) && FailedQiHaoList.Count > 0)
            {
                var OpenList = GetYesterdayOpenListFromBackUrl();
                if (OpenList.Count == 0) return;//无抓取数据
                var SuccessList = new List<string>();
                foreach (var failedQiHao in FailedQiHaoList)
                {
                    var matchItem = OpenList.Where(R => R.Key == failedQiHao).FirstOrDefault();
                    if (matchItem.Key != null && SaveRecord(failedQiHao, matchItem.Value, true))
                    {
                        //处理成功写入日志
                        log.Info(typeof(JL11X5Job), CommonHelper.GetJobBackLogInfo(Config, failedQiHao));
                        SuccessList.Add(failedQiHao);
                        continue;
                    }
                }
                foreach (var successQiHao in SuccessList)
                {
                    FailedQiHaoList.Remove(successQiHao);
                }
            }
        }
        /// <summary>
        /// 通过备用站点抓取今日最新开奖列表
        /// </summary>
        /// <returns></returns>
        private Dictionary<string, string> GetTodayOpenListFromBackUrl()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                var HtmlResource = NetHelper.GetUrlResponse(Config.BackUrl);
                if (!string.IsNullOrWhiteSpace(HtmlResource))
                {
                    HtmlDocument doc = new HtmlDocument();
                    doc.LoadHtml(HtmlResource);
                    var table = doc.DocumentNode.SelectSingleNode("//table");
                    if (table == null) return result;
                    var trs = table.ChildNodes.Where(R => R.Name.ToLower() == "tr").ToList();
                    List<HtmlNode> tds = null, ems = null;
                    var matchQiHao = string.Empty;
                    var matchKJHaoMa = string.Empty;
                    for (var i = 1; i < trs.Count; i++)//第一行为表头
                    {
                        tds = trs[i].ChildNodes.Where(R => R.Name.ToLower() == "td").ToList();
                        if (tds.Count < 3) continue;
                        matchQiHao = tds[0].InnerText.Trim();
                        ems = tds[2].ChildNodes.Where(R => R.Name.ToLower() == "em").ToList();
                        if (ems.Count < 5) continue;
                        matchKJHaoMa = string.Format("{0},{1},{2},{3},{4}", ems[0].InnerText.Trim(), ems[1].InnerText.Trim(), ems[2].InnerText.Trim(), ems[3].InnerText.Trim(), ems[4].InnerText.Trim());
                        if (!result.ContainsKey(matchQiHao))
                            result.Add(matchQiHao, matchKJHaoMa);
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过备用站点抓取今日最新开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            return result;
        }
        /// <summary>
        /// 通过备用站点抓取昨日开奖列表
        /// </summary>
        /// <returns></returns>
        private Dictionary<string, string> GetYesterdayOpenListFromBackUrl()
        {
            Dictionary<string, string> result = new Dictionary<string, string>();
            try
            {
                var HtmlResource = NetHelper.GetUrlResponse(Config.BackUrl + "?action=chart&date=yesterday&id=511&async=true");
                if (!string.IsNullOrWhiteSpace(HtmlResource))
                {
                    var obj = JsonConvert.DeserializeObject<JObject>(HtmlResource);
                    if (obj != null && obj["data"] != null)
                    {
                        var matchQiHao = string.Empty;
                        var matchKJHaoMa = string.Empty;
                        JArray openCodeList = null;
                        foreach (var item in obj["data"])
                        {
                            matchQiHao = item["dateNumber"].ToString();
                            openCodeList = (JArray)item["list"];
                            matchKJHaoMa = string.Format("{0},{1},{2},{3},{4}", openCodeList[0].ToString(), openCodeList[1].ToString(), openCodeList[2].ToString(), openCodeList[3].ToString(), openCodeList[4].ToString());
                            if (!result.ContainsKey(matchQiHao))
                                result.Add(matchQiHao, matchKJHaoMa);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error(typeof(JL11X5Job), string.Format("【{0}】通过备用站点抓取昨日开奖列表时发生错误，错误信息【{1}】", Config.Area + Config.LotteryName, ex.Message));
            }
            return result;
        }

        /// <summary>
        /// 将此彩种指定期号和开奖号码保存至数据库
        /// </summary>
        /// <param name="QiHao">期号</param>
        /// <param name="OpenCode">开奖号码(形如01,02,03,04,05)</param>
        /// <param name="IsYesterdayRecord">是否是保存昨天的记录</param>
        /// <returns></returns>
        private bool SaveRecord(string QiHao, string OpenCode, bool IsYesterdayRecord)
        {
            if (!string.IsNullOrWhiteSpace(QiHao) && !string.IsNullOrWhiteSpace(OpenCode))
            {
                //string[] arr = QiHao.Split("|".ToCharArray());

                OpenCode5Model model = new OpenCode5Model();
                model.Term = Convert.ToInt64(QiHao);
                //model.Term = Convert.ToInt64(arr[0]);
                var haoMaArray = OpenCode.Split(new char[] { ',' });
                model.OpenCode1 = Convert.ToInt32(haoMaArray[0]);
                model.OpenCode2 = Convert.ToInt32(haoMaArray[1]);
                model.OpenCode3 = Convert.ToInt32(haoMaArray[2]);
                model.OpenCode4 = Convert.ToInt32(haoMaArray[3]);
                model.OpenCode5 = Convert.ToInt32(haoMaArray[4]);
                if (IsYesterdayRecord)
                    model.OpenTime = CommonHelper.GenerateYesterdayOpenTime(Config, QiHao);
                else
                    model.OpenTime = CommonHelper.GenerateTodayOpenTime(Config, QiHao);//Convert.ToDateTime(arr[1])
                return services.AddOpen5Code(currentLottery, model);
            }
            return false;
        }

        #region Attribute
        /// <summary>
        /// 配置信息
        /// </summary>
        private SCCConfig Config = null;
        /// <summary>
        /// 当天抓取的最新一期期号
        /// </summary>
        private string LatestQiHao = null;
        /// <summary>
        /// 当天抓取失败列表
        /// </summary>
        private List<string> FailedQiHaoList = null;
        /// <summary>
        /// 日志对象
        /// </summary>
        private LogHelper log = null;
        /// <summary>
        /// 数据服务
        /// </summary>
        private IOpen5Code services = null;
        /// <summary>
        /// 当前彩种
        /// </summary>
        private SCCLottery currentLottery
        {
            get
            {
                return SCCLottery.JiLin11X5;
            }
        }
        /// <summary>
        /// 邮件接口
        /// </summary>
        private IEmail email = null;
        #endregion
    }
}