kjh.api.55128.cn_old/SCC.Crawler/DT/GD36X7Job.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CP.Model;
using HtmlAgilityPack;
using Newtonsoft.Json;
using Quartz;
using SCC.Common;
using SCC.Crawler.Tools;
using SCC.Interface;
using SCC.Models;

namespace SCC.Crawler.DT
{
    /// <summary>
    ///     广东36选7  南粤36X7
    /// </summary>
    [DisallowConcurrentExecution]
    [PersistJobDataAfterExecution]
    public class GD36X7Job : IJob
    {
        /// <summary>
        ///     构造函数
        /// </summary>
        public GD36X7Job()
        {
            log = new LogHelper();
            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;
            LatestItem = context.JobDetail.JobDataMap["LatestItem"] as Fcny36x7LongInfo;
            try
            {
                //服务启动时配置初始数据
                if (LatestItem == null)
                {
                    LatestItem = new Fcny36x7LongInfo
                    {
                        qi = CommonHelper.GenerateQiHaoYYYYQQQ(0),
                        date = new DateTime(CommonHelper.SCCSysDateTime.Year, 1, 1)
                    };
                }

                //程序时间第二天，程序根据配置检查是否昨天有开奖
                //isGetData = false;
                //if (!LatestItem.Term.ToString().StartsWith(CommonHelper.SCCSysDateTime.ToString("yyyy")))
                //    LatestItem = new OpenCode7DTModel
                //    {
                //        Term = CommonHelper.GenerateQiHaoYYYYQQQ(0),
                //        OpenTime = new DateTime(CommonHelper.SCCSysDateTime.Year, 1, 1)
                //    };
                ////当今日开奖并且当前时间是晚上8点过后开始抓取
                //if (CommonHelper.CheckTodayIsOpenDay(Config) && CommonHelper.SCCSysDateTime.Hour > 12)
                //{
                DoBackUrl();//因为back获取详情详细些，但是后面发现这个地址做了安全防护
                DoMainUrl();

                //}
            }
            catch (Exception ex)
            {
                log.Error(GetType(), string.Format("【{0}】抓取时发生错误，错误信息【{1}】", Config.Area + currentLottery, ex.Message));
            }

            //保存最新期号
            context.JobDetail.JobDataMap["LatestItem"] = LatestItem;
        }
        /// <summary>
        /// 执行主站的数据插入
        /// </summary>
        private void DoMainUrl()
        {
            if (!string.IsNullOrEmpty(Config.MainUrl))
            {
                var openList = GetOpenListFromMainUrl(Config.MainUrl);
                if (openList == null || openList.Count == 0) return; //无抓取数据
                //抓取到的最新期数
                var newestQiHao = Convert.ToInt32(openList.OrderByDescending(m => m.qi).First().qi.ToString());
                //数据库里面最新期数
                LatestItem = Fcny36x7Data.GetLastOne();
                var startQiNum = Convert.ToInt32(LatestItem.qi.ToString());
                if (startQiNum > newestQiHao) return; //无最新数据
                //处理最新开奖数据
                Fcny36x7LongInfo matchItem = null;
                for (var i = startQiNum; i <= newestQiHao; i++)
                {
                    matchItem = openList.FirstOrDefault(r => r.qi.ToString() == i.ToString());

                    if (matchItem != null)
                    {
                        //add db
                        matchItem.addtime = DateTime.Now;
                        Fcny36x7Data.Add(matchItem);
                        //Do Success Log
                        log.Info(GetType(), CommonHelper.GetJobMainLogInfo(Config, i.ToString()));
                        LatestItem = matchItem;
                        isGetData = true;
                    }
                }
            }
        }
        /// <summary>
        /// 执行副站的数据插入
        /// </summary>
        private void DoBackUrl()
        {
            if (!string.IsNullOrEmpty(Config.BackUrl))
            {
                var openList = GetOpenListFromBackUrl(Config.BackUrl);
                if (openList == null || openList.Count == 0) return; //无抓取数据
                //抓取到的最新期数
                var newestQiHao = Convert.ToInt32(openList.OrderByDescending(m => m.qi).First().qi.ToString());
                //数据库里面最新期数
                //LatestItem = Fcny36x7Data.GetLastOne();
                var startQiNum = Convert.ToInt32(LatestItem.qi.ToString());
                if (startQiNum > newestQiHao) return; //无最新数据
                //处理最新开奖数据
                Fcny36x7LongInfo matchItem = null;
                for (var i = startQiNum; i <= newestQiHao; i++)
                {
                    matchItem = openList.FirstOrDefault(r => r.qi.ToString() == i.ToString());
                    if (matchItem != null)
                    {
                        //add db
                        matchItem.addtime = DateTime.Now;
                        Fcny36x7Data.Add(matchItem);
                        //Do Success Log
                        log.Info(GetType(), CommonHelper.GetJobBackLogInfo(Config, i.ToString()));
                        LatestItem = matchItem;
                        isGetData = true;
                    }
                }
            }
        }
        /// <summary>
        /// 根据主站获取数据列表
        /// </summary>
        /// <param name="mainUrl"></param>
        /// <returns></returns>
        private List<Fcny36x7LongInfo> GetOpenListFromMainUrl(string mainUrl)
        {
            var result = new List<Fcny36x7LongInfo>();
            try
            {
                var url = new Uri(mainUrl);
                var htmlResource = NetHelper.GetUrlResponse(mainUrl, Encoding.GetEncoding("gb2312"));
                if (htmlResource == null) return result;

                var doc = new HtmlDocument();
                doc.LoadHtml(htmlResource);
                var table = doc.DocumentNode.SelectSingleNode("//table");
                if (table == null) return result;
                var trs = table.ChildNodes.Where(node => node.Name == "tr").ToList();
                Fcny36x7LongInfo model = null;
                var optimizeUrl = string.Empty;
                for (var i = 2; i < trs.Count; i++) //第一二行为表头
                {
                    var tds = trs[i].ChildNodes.Where(node => node.Name == "td").ToList();
                    if (tds.Count < 4) continue;
                    model = new Fcny36x7LongInfo();
                    model.qi = Convert.ToInt32(tds[0].InnerText.Trim());
                    model.date = Convert.ToDateTime(tds[1].InnerText.Remove(10));
                    var opencodeNode = tds[2].ChildNodes.Where(n => n.Name.ToLower() == "span").ToList();
                    if (opencodeNode.Count < 7) continue;
                    model.n1 = Convert.ToInt32(opencodeNode[0].InnerText.Trim());
                    model.n2 = Convert.ToInt32(opencodeNode[1].InnerText.Trim());
                    model.n3 = Convert.ToInt32(opencodeNode[2].InnerText.Trim());
                    model.n4 = Convert.ToInt32(opencodeNode[3].InnerText.Trim());
                    model.n5 = Convert.ToInt32(opencodeNode[4].InnerText.Trim());
                    model.n6 = Convert.ToInt32(opencodeNode[5].InnerText.Trim());
                    model.n7 = Convert.ToInt32(opencodeNode[6].InnerText.Trim());
                    GetKaijiangDetails(ref model, model.qi.ToString());
                    result.Add(model);
                }
                //var checkDataHelper = new CheckDataHelper();
                //var dbdata = services.GetListS<OpenCode5DTModel>(currentLottery)
                //    .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
                //checkDataHelper.CheckData(dbdata, result.ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr()),
                //    Config.Area, currentLottery);
                //result = result.OrderByDescending(S => S.Term).ToList();
            }
            catch (Exception ex)
            {
                log.Error(GetType(),
                    string.Format("【{0}】通过主站点抓取开奖列表时发生错误，错误信息【{1}】", Config.Area + currentLottery, ex.Message));
            }

            return result;
        }


        /// <summary>
        ///     获取主站下开奖详情
        /// </summary>
        /// <param name="nodes"></param>
        /// <returns></returns>
        private void GetKaijiangDetails(ref Fcny36x7LongInfo model, string qi)
        {
            string url = $"http://kaijiang.500.com/shtml/gdslxq/{qi}.shtml";
            var htmlResource = NetHelper.GetUrlResponse(url, Encoding.GetEncoding("gb2312"));
            if (htmlResource == null) return;
            var list = new List<Winbonus>();
            var doc = new HtmlDocument();
            doc.LoadHtml(htmlResource);
            var tables = doc.DocumentNode.SelectNodes("//table");
            if (tables == null) return;
            foreach (var table in tables)
            {
                var trs = table.ChildNodes.Where(node => node.Name == "tr").ToList();
                for (var i = 1; i < trs.Count; i++) //第一二行为表头
                {
                    var tds = trs[i].ChildNodes.Where(node => node.Name == "td").ToList();
                    if (tds.Count != 3) continue;
                    if (tds[0].InnerText.Trim() == "一等奖")
                    {
                        model.zj1 = tds[1].InnerText.Trim();
                        model.jo1 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "一等奖",
                            wincount = model.zj1,
                            winmoney = model.jo1
                        });
                    }
                    if (tds[0].InnerText.Trim() == "二等奖")
                    {
                        model.zj2 = tds[1].InnerText.Trim();
                        model.jo2 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "二等奖",
                            wincount = model.zj2,
                            winmoney = model.jo2
                        });
                    }
                    if (tds[0].InnerText.Trim() == "三等奖")
                    {
                        model.zj3 = tds[1].InnerText.Trim();
                        model.jo3 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "三等奖",
                            wincount = model.zj3,
                            winmoney = model.jo3
                        });
                    }
                    if (tds[0].InnerText.Trim() == "四等奖")
                    {
                        model.zj1 = tds[1].InnerText.Trim();
                        model.jo1 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "四等奖",
                            wincount = model.zj4,
                            winmoney = model.jo4
                        });
                    }
                    if (tds[0].InnerText.Trim() == "五等奖")
                    {
                        model.zj2 = tds[1].InnerText.Trim();
                        model.jo2 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "五等奖",
                            wincount = model.zj5,
                            winmoney = model.jo5
                        });
                    }
                    if (tds[0].InnerText.Trim() == "六等奖")
                    {
                        model.zj3 = tds[1].InnerText.Trim();
                        model.jo3 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "六等奖",
                            wincount = model.zj6,
                            winmoney = model.jo6
                        });
                    }
                    if (tds[0].InnerText.Trim() == ">好彩2")
                    {
                        model.zj2 = tds[1].InnerText.Trim();
                        model.jo2 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "好彩2",
                            wincount = model.hy2,
                            winmoney = model.ho2
                        });
                    }
                    if (tds[0].InnerText.Trim() == ">好彩3")
                    {
                        model.zj3 = tds[1].InnerText.Trim();
                        model.jo3 = tds[2].InnerText.Trim();
                        list.Add(new Winbonus()
                        {
                            item = "好彩3",
                            wincount = model.hy3,
                            winmoney = model.ho3
                        });
                    }
                }

            }

            model.winbonus = JsonConvert.SerializeObject(list);
        }

        #region 通过副站爬取数据
        /// <summary>
        /// 根据副站的网址爬取数据列表
        /// </summary>
        /// <param name="mainUrl"></param>
        /// <returns></returns>
        private List<Fcny36x7LongInfo> GetOpenListFromBackUrl(string mainUrl)
        {
            var result = new List<Fcny36x7LongInfo>();
            try
            {
                var url = new Uri(mainUrl);
                var htmlResource = NetHelper.GetUrlResponse(mainUrl, Encoding.GetEncoding("utf-8"));
                if (htmlResource == null) return result;

                var doc = new HtmlDocument();
                doc.LoadHtml(htmlResource);
                var table = doc.DocumentNode.SelectSingleNode("//table");
                if (table == null) return result;
                var trs = table.ChildNodes.Where(node => node.Name == "tr").ToList();
                Fcny36x7LongInfo model = null;
#pragma warning disable CS0219 // 变量“nodeA”已被赋值，但从未使用过它的值
                HtmlNode nodeA = null;
#pragma warning restore CS0219 // 变量“nodeA”已被赋值，但从未使用过它的值
                var optimizeUrl = string.Empty;
                for (var i = 2; i < trs.Count; i++) //第一二行为表头
                {
                    var trstyle = trs[i].Attributes["style"];
                    if (trstyle != null && trstyle.Value == "display:none") continue;
                    var tds = trs[i].ChildNodes.Where(node => node.Name == "td").ToList();
                    //if (tds.Count < 14) continue;
                    model = new Fcny36x7LongInfo();
                    //nodeA = tds[13].ChildNodes.Where(n => n.Name == "a").FirstOrDefault();
                    //if (nodeA == null) continue;
                    model.qi = Convert.ToInt32(tds[0].InnerText.Trim());
                    //model.DetailUrl = new Uri(url, optimizeUrl).AbsoluteUri;
                    //model.date = Convert.ToDateTime(tds[1].InnerText.Substring(0, 10));
                    //if (tds[2].ChildNodes.Count == 0) continue;
                    var opencodeNode = tds[1].ChildNodes.Where(n => n.Name.ToLower() == "em").ToList();
                    if (opencodeNode.Count < 7) continue;
                    model.n1 = Convert.ToInt32(opencodeNode[0].InnerText.Trim());
                    model.n2 = Convert.ToInt32(opencodeNode[1].InnerText.Trim());
                    model.n3 = Convert.ToInt32(opencodeNode[2].InnerText.Trim());
                    model.n4 = Convert.ToInt32(opencodeNode[3].InnerText.Trim());
                    model.n5 = Convert.ToInt32(opencodeNode[4].InnerText.Trim());
                    model.n6 = Convert.ToInt32(opencodeNode[5].InnerText.Trim());
                    model.n7 = Convert.ToInt32(opencodeNode[6].InnerText.Trim());
                    KaijiangDetails(ref model,tds);
                    result.Add(model);
                }
                //var checkDataHelper = new CheckDataHelper();
                //var dbdata = services.GetListS<OpenCode7DTModel>(currentLottery)
                //    .ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr());
                //checkDataHelper.CheckData(dbdata, result.ToDictionary(w => w.Term.ToString(), w => w.GetCodeStr()),
                //    Config.Area, currentLottery);
                //result = result.OrderByDescending(S => S.Term).ToList();
            }
            catch (Exception ex)
            {
                log.Error(GetType(),
                    string.Format("【{0}】通过主站点抓取开奖列表时发生错误，错误信息【{1}】", Config.Area + currentLottery, ex.Message));
            }

            return result;
        }

        /// <summary>
        ///     获取主站下开奖详情
        /// </summary>
        /// <param name="nodes"></param>
        /// <returns></returns>
        private void KaijiangDetails(ref Fcny36x7LongInfo model, List<HtmlNode> nodes)
        {
            //组装详情
            var TotalMoney = nodes[4].InnerText.Replace("万", "").Replace("元", "").Replace(" ", "0").Trim();
            //一等奖
            model.zj1 = nodes[3].InnerText;
            model.jo1 = TotalMoney = TotalMoney == "" ? "0" : (double.Parse(TotalMoney) * 1).ToString();
            //二等奖
            model.zj2 = nodes[5].InnerText;
            model.jo2 = nodes[6].InnerText.Replace("元", "");
            //三等奖
            model.zj3 = nodes[7].InnerText;
            model.jo3 = nodes[8].InnerText.Replace("元", "");
            //四等奖
            model.zj4 = nodes[9].InnerText;
            model.jo4 = "500";
            //五等奖
            model.zj5 = nodes[10].InnerText;
            model.jo5 = "100";
            //六等奖
            model.zj6 = nodes[11].InnerText;
            model.jo6 = "10";

            var list = new List<Winbonus>();

            list.Add(new Winbonus()
            {
                item = "一等奖",
                wincount = model.zj1,
                winmoney = model.jo1
            });
            list.Add(new Winbonus()
            {
                item = "二等奖",
                wincount = model.zj2,
                winmoney = model.jo2
            });

            list.Add(new Winbonus()
            {
                item = "三等奖",
                wincount = model.zj3,
                winmoney = model.jo3
            });
            list.Add(new Winbonus()
            {
                item = "四等奖",
                wincount = model.zj4,
                winmoney = model.jo4
            });
            list.Add(new Winbonus()
            {
                item = "五等奖",
                wincount = model.zj5,
                winmoney = model.jo5
            });
            list.Add(new Winbonus()
            {
                item = "六等奖",
                wincount = model.zj6,
                winmoney = model.jo6
            });

            model.winbonus = JsonConvert.SerializeObject(list);
        }

        #endregion

        #region Attribute

        /// <summary>
        ///     配置信息
        /// </summary>
        private SCCConfig Config;

        /// <summary>
        ///     当天抓取的最新一期开奖记录
        /// </summary>
        private Fcny36x7LongInfo LatestItem;

#pragma warning disable CS0414 // 字段“GD36X7Job.FailedQiHaoList”已被赋值，但从未使用过它的值
        /// <summary>
        ///     当天抓取失败列表
        /// </summary>
        private List<string> FailedQiHaoList = null;
#pragma warning restore CS0414 // 字段“GD36X7Job.FailedQiHaoList”已被赋值，但从未使用过它的值

        /// <summary>
        ///     日志对象
        /// </summary>
        private readonly LogHelper log;

        /// <summary>
        ///     当前彩种
        /// </summary>
        private SCCLottery currentLottery => SCCLottery.GuangDong36x7;

        /// <summary>
        ///     邮件接口
        /// </summary>
        private IEmail email;

#pragma warning disable CS0414 // 字段“GD36X7Job.isGetData”已被赋值，但从未使用过它的值
        /// <summary>
        ///     是否本次运行抓取到开奖数据
        /// </summary>
        private bool isGetData;
#pragma warning restore CS0414 // 字段“GD36X7Job.isGetData”已被赋值，但从未使用过它的值

        #endregion
    }
}