FCS/FCS.Crawler/Content/Jobs/FootJobs/ZCLotteryGames/GamesJob.cs

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using FCS.Common;
using FCS.Interface;
using FCS.Models;
using HtmlAgilityPack;
using Quartz;

namespace FCS.Crawler.ZCLotteryGames
{
    class GamesJob : CommonJob, IJob
    {
        
        public GamesJob()
        {
            log = new LogHelper();
            services = IOC.Resolve<IDTOpenCode>();
            g = new F_Grouping();
        }
        public void Execute(IJobExecutionContext context)
        {
            //Config = CommonHelper.GetConfigFromDataMap(context.JobDetail.JobDataMap);
            // Click();
        }
        public static List<string> gamelist = new List<string>();
        public static List<string> urllist = new List<string>();
        public static List<string> urllist2 = new List<string>();
        public static List<F_Grouping> Group = new List<F_Grouping>();
        public static List<F_Grouping> Group1 = new List<F_Grouping>();
        public static List<F_Grouping> GroupParent = new List<F_Grouping>();
        public static List<F_Team> teamlist = new List<F_Team>();
        public static List<F_Grouping> GroupList = null;
        public static List<F_Grouping> GroupList1 = null;
        public static List<F_Games> Gamelist = null;
        public static List<F_Games> gamesList = new List<F_Games>();
        public static List<F_Games> gamesList_new = new List<F_Games>();
        public static List<F_Games> gamesList_new1 = new List<F_Games>();
        public static List<F_Games> gamesList_new2 = new List<F_Games>();
        public static List<int> listint = new List<int>();//需要删除的比赛PK
        F_Grouping g;

        public List<F_Games> Click()
        {
            
            string Season = DateTime.Now.ToString("yyyy");
            Group = services.Query<F_Grouping>().ToList(); 
            Group1 = services.Query<F_Grouping>(" and Id in( select aa.Id from F_Grouping as aa left join F_Games as b on aa.Id=b.GroupingId where b.[Status]!='a058ec2ec96ae811ab3100ac6a4a134f' and aa.Season like '%{0}%' and b.Season like '%{0}%' group by aa.Id)".FormatMe(Season)).ToList();
            Group1.AddRange(services.Query<F_Grouping>(" and Id in ( select aa.Id from F_Grouping as aa left join F_Games as b on aa.Id=b.GroupingId where b.Id is null and aa.Season like '%{0}%' group by aa.Id)".FormatMe(Season)).ToList());
            Gamelist = services.Query<F_Games>(" AND Season LIKE '%{0}%'".FormatMe(Season)).ToList();
            teamlist = services.Query<F_Team>().ToList();
            GroupList = Group1.Where(a => !a.Remark.Contains("/cup/41/")&&((a.ParentId.Length == 0 && a.Remark.Contains("/cup/")) || a.Remark.Contains("/league/"))).ToList();
            GroupParent = services.Query<F_Grouping>("and ParentId!=''").ToList();
            //GetClick("http://saishi.zgzcw.com:80/soccer/cup/59/2018-2019/", "第一圈", "ed091448f5c2e8118a7b2c4d54d3f5a9");
            int max = GroupList.Count;
            int num = 0;
            //比赛
            GroupList.ForEach(async p =>
            {
                await Task.Run(() =>
                {
                    Trace.WriteLine("获取比赛 开始：" + GroupList.IndexOf(p));
                    GetClick(p.Remark, p.Name.Trim(), p.Id);

                });
                lock (g)
                {

                    num++;
                    Monitor.Pulse(g); //完成，通知等待队列,告知已完，执行下一个。
                }
            });
            lock (g)
            {
                while (num < max)
                {
                    Monitor.Wait(g);//等待
                }
            }
            Trace.WriteLine("获取比赛 完结");


            //球队联谊
            var q = Group.Where(a => a.Remark.Contains("/cup/41/") && a.Season.Contains(Season)).ToList();
            List<string> ulist = new List<string>();
            foreach (var item in q)
            {
                ulist.Add(item.Remark);
            }
            ulist = ulist.Distinct().ToList();
            foreach (var item in ulist)
            {
                GetCupData_yy(item, q);
            }

            ////检查缺漏
            List<string> new_urllist = new List<string>();
            new_urllist = urllist;
            max = new_urllist.Count;
            num = 0;
            urllist = new List<string>();
            new_urllist.ForEach(async p =>
            {
                await Task.Run(() =>
                {
                    Trace.WriteLine("获取比赛 缺漏 开始：" + new_urllist.IndexOf(p));
                    var query = p.Split('|');
                    GetLeagueData(query[0], query[1], query[2]);

                });
                lock (g)
                {
                    num++;
                    Monitor.Pulse(g); //完成，通知等待队列,告知已完，执行下一个。
                }
            });
            lock (g)
            {
                while (num != max)
                {
                    Monitor.Wait(g);//等待
                }
            }
            //  Gamelist= Gamelist.Where((x, i) => Gamelist.FindIndex(z => z.GroupingId == x.GroupingId && z.VisitingTeamId == x.VisitingTeamId && z.HomeTeamId == x.HomeTeamId && z.HomeTeamScore_All == x.HomeTeamScore_All && z.VisitingTeamScore_All == x.VisitingTeamScore_All && z.HomeTeamScore_Half == x.HomeTeamScore_Half && z.VisitingTeamScore_Half == x.VisitingTeamScore_Half && z.EventId == x.EventId && z.Season == x.Season) == i).ToList();//Lambda表达式去重
            gamesList =gamesList.Where((x, i) => gamesList.FindIndex(z => z.GroupingId == x.GroupingId && z.VisitingTeamId == x.VisitingTeamId && z.HomeTeamId == x.HomeTeamId && z.HomeTeamScore_All == x.HomeTeamScore_All && z.VisitingTeamScore_All == x.VisitingTeamScore_All && z.HomeTeamScore_Half == x.HomeTeamScore_Half && z.VisitingTeamScore_Half == x.VisitingTeamScore_Half && z.EventId == x.EventId && z.Season == x.Season) == i).ToList();//Lambda表达式去重
            max = gamesList.Count;
            num = 0;
            int sss = 0;
            //比较比赛
            gamesList.ForEach(async p =>
            {
                await Task.Run(() =>
                {

                    var istrue = Gamelist.Where(a => a.Season == p.Season && a.GroupingId == p.GroupingId && a.HomeTeamId == p.HomeTeamId && a.VisitingTeamId == p.VisitingTeamId && a.EventId == p.EventId&&a.StartDateTime==p.StartDateTime).ToList();
                    //if(Gamelist.Where(a=>a.HomeTeamId== "ff8d81fa-3444-4e5d-955c-79049a722daa"&&a.VisitingTeamId== "5629c466-a3e4-4a1a-9826-0a5c86244f08"&&a.CreateDateTime>))
                    if (istrue.Count > 0)
                    {//已有比赛 判断是否需要更新数据
                        var onegame = istrue.FirstOrDefault();
                        if (onegame.HomeTeamScore_All != p.HomeTeamScore_All || onegame.HomeTeamScore_Half != p.HomeTeamScore_Half || onegame.VisitingTeamScore_All != p.VisitingTeamScore_All|| onegame.VisitingTeamScore_Half != p.VisitingTeamScore_Half || onegame.Status != "a058ec2ec96ae811ab3100ac6a4a134f")
                        {
                            lock (gamesList_new)
                            {
                                p.Id = onegame.Id;
                                gamesList_new.Add(p);
                                gamesList_new2.Add(p);
                            }
                            foreach (var item in istrue)
                            {
                                lock (listint)
                                {
                                    listint.Add(item.PK);
                                }
                            }
                           
                        }
                        else
                        {
                            //数据不做修改
                        }
                    }
                    else
                    {//没有次比赛 新增
                        lock (gamesList_new)
                        {
                            gamesList_new.Add(p);
                        }

                    }


                });
                lock (locker)
                {
                    num++;
                    Monitor.Pulse(locker); //完成，通知等待队列,告知已完，执行下一个。
                }
            });
            lock (locker)
            {
                while (num < max)
                {
                    Monitor.Wait(locker);//等待
                }
            }
            Thread.Sleep(5000);
            var gamesList_new1 = gamesList_new.Where(a => a.StartDateTime < DateTime.Now.AddDays(5)).ToList();
            var salist1 = gamesList_new.Where((x, i) => gamesList_new.FindIndex(z => z.GroupingId == x.GroupingId&&z.VisitingTeamId==x.VisitingTeamId && z.HomeTeamId == x.HomeTeamId && z.HomeTeamScore_All == x.HomeTeamScore_All && z.VisitingTeamScore_All == x.VisitingTeamScore_All && z.HomeTeamScore_Half == x.HomeTeamScore_Half && z.VisitingTeamScore_Half == x.VisitingTeamScore_Half&&z.EventId==x.EventId&&z.Season==x.Season && z.Id == x.Id) == i).ToList();//Lambda表达式去重
            //gamesList2 = gamesList_new2.Where(a => a.StartDateTime < Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))&& a.StartDateTime > Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"))).ToList();
            Trace.WriteLine("插入数据 开始：" + salist1.Count);
            services.SqlBulkCopyAdd<F_Games>(salist1);
            Trace.WriteLine("插入数据 结束：" + salist1.Count);

            Trace.WriteLine("删除数据 开始：" + listint.Count);
            if (listint.Count > 0)
            {
                int pg = listint.Count % 10000 == 0 ? listint.Count / 10000 : listint.Count / 10000 + 1;
                for (int i = 0; i < pg; i++)
                {
                    var listint1 = listint.Skip(i * 10000).Take(10000).ToList();
                    services.Delete<F_Games>(" and PK in (" + string.Join(",", listint1) + ")");
                }
                
            }
                
            Trace.WriteLine("删除数据 结束：" + listint.Count);



            List<int> rlist = new List<int>();
            var querygame = services.Query<F_Games>(" and Id in (select Id from ( select Id,COUNT(Id) as num from F_Games group by Id) as s where s.num>1 ) ").ToList();
            var q1 = querygame.Where((x, i) => querygame.FindIndex(z => z.Id == x.Id) == i).ToList();//Lambda表达式去重
            foreach (var item in querygame)
            {
                if (q1.Where(a => a.PK == item.PK).ToList().Count > 0)
                {
                    continue;
                }
                else
                {
                    rlist.Add(item.PK);
                }
            }
            if (rlist.Count > 0)
            {
                int pg = rlist.Count % 10000 == 0 ? rlist.Count / 10000 : rlist.Count / 10000 + 1;
                for (int i = 0; i < pg; i++)
                {
                    var listint1 = rlist.Skip(i * 10000).Take(10000).ToList();
                    services.Delete<F_Games>(" and PK in (" + string.Join(",", listint1) + ")");
                }
            }
            return gamesList_new1;
        }
        public void DoMainUrl()
        {
            Group = services.Query<F_Grouping>().ToList();
            teamlist = services.Query<F_Team>().ToList();
            ThreadPool.SetMinThreads(1, 1);
            ThreadPool.SetMaxThreads(100, 100);

            GroupList = Group.Where(a => a.Remark.Contains("cup") && !a.Remark.Contains("/cup/41/")).ToList();
            //比赛杯
            GroupList.ForEach(p =>
            {
                Task.Run(() =>
                {
                    Trace.WriteLine("获取比赛杯 开始：" + GroupList.IndexOf(p));
                    GetCupData(p.Remark, p.Name.Trim(), p.Id);

                });
            });
            while (true)
            {
                if (CommonHelper.ThreadsFinsh())
                    break;
            }
            Trace.WriteLine("获取比赛杯 完结");


            //球队联谊
            var q = Group.Where(a => a.Remark.Contains("cup") && a.Remark.Contains("/cup/41/")).ToList();
            List<string> ulist = new List<string>();
            foreach (var item in q)
            {
                ulist.Add(item.Remark);
            }
            ulist = ulist.Distinct().ToList();
            foreach (var item in ulist)
            {
                GetCupData_yy(item, q);
            }

            //国家比赛
            GroupList1 = Group.Where(a => a.Remark.Contains("league") && a.Name != "常规赛").ToList();
            GroupList1.ForEach(p =>
            {
                Task.Run(() =>
                {
                    Trace.WriteLine("获取比赛 开始：" + GroupList1.IndexOf(p));
                    GetLeagueData(p.Remark, p.Name.Trim(), p.Id);

                });
            });
            while (true)
            {
                if (CommonHelper.ThreadsFinsh())
                    break;
            }
            //检查缺漏
            List<string> new_urllist = new List<string>();
            new_urllist = urllist;
            urllist = new List<string>();
            foreach (var item in new_urllist)
            {
                var query = item.Split('|');
                GetLeagueData(query[0], query[1], query[2]);
            }
            Trace.WriteLine("插入数据 开始：" + gamesList.Count);
            services.SqlBulkCopyAdd<F_Games>(gamesList);
            Trace.WriteLine("插入数据 结束：" + gamesList.Count);

        }

        /// <summary>
        /// 某某杯
        /// </summary>
        /// <param name="url"></param>
        public void GetCupData(string url, string currentRound, string Id)
        {

            try
            {
                Trace.WriteLine("某某杯 开始：" + url);
                string yurl = url;
                url = url.Replace(":80", "");
                var htmlResource = CommonHelper.GetHtmlString(url, "足彩");
                HtmlDocument doc = new HtmlDocument();
                if (htmlResource == null)
                    return;
                doc.LoadHtml(htmlResource);
                //比赛分组集合
                HtmlNodeCollection GamegroupHtml = doc.DocumentNode.SelectNodes("//*[@id='tabs9']/li");
                foreach (var item in GamegroupHtml.Where(a => a.InnerText.Trim() == currentRound))
                {//获取父下所有子分组+比赛
                    string shuju1 = "";
                    if (GroupParent.Where(a => a.ParentId == Id).ToList().Count > 0)
                    {//有子集比赛集合
                        HtmlNodeCollection groupHtml = doc.DocumentNode.SelectNodes("//*[@id='tabs9_" + item.Id + "']");
                        if (groupHtml == null)
                            return;
                        HtmlDocument doc_1 = new HtmlDocument();
                        doc_1.LoadHtml(groupHtml[0].OuterHtml);
                        HtmlNodeCollection groupHtmlnew = doc_1.DocumentNode.SelectNodes("//li");
                        foreach (var item1 in groupHtmlnew)
                        {
                            var zj = GroupParent.Where(a => a.ParentId == Id && a.Name == item1.InnerText.Trim()).ToList();
                            if(zj.Count==0)
                                continue;
                            //获取所有子集
                            HtmlNodeCollection itemlist_1 = doc_1.DocumentNode.SelectNodes("//*[@id='div_" + item1.Id + "']/table");
                            if (itemlist_1 == null)
                                return;
                            HtmlDocument doc2 = new HtmlDocument();
                            doc2.LoadHtml(itemlist_1[0].OuterHtml);
                            HtmlNodeCollection itemlist = doc2.DocumentNode.SelectNodes("//tr");
                            foreach (HtmlNode node in itemlist)
                            {
                                var list = node.SelectNodes("td");
                                if (list == null)
                                    continue;
                                string shuju = shuju1;
                                foreach (var item3 in list)
                                {
                                    shuju += item3.InnerText.Trim() + "|";
                                }
                                //gamelist.Add(shuju);
                                var listurl = url.Split('/');
                                string season = listurl[6];
                                HtmlDocument doc3 = new HtmlDocument();
                                doc3.LoadHtml(list.Last().InnerHtml);
                                HtmlNodeCollection itemlist2 = doc3.DocumentNode.SelectNodes("//a");
                                Insert(shuju, zj[0].Id, season, itemlist2[0].Attributes["href"].Value);
                            }
                        }
                       

                    }
                    else {
                        //比赛集合
                        HtmlNodeCollection GameHtml = doc.DocumentNode.SelectNodes("//*[@id='tabs9_" + item.Id + "']");
                        foreach (var item1 in GameHtml)
                        {
                            HtmlDocument doc1 = new HtmlDocument();
                            doc1.LoadHtml(item1.OuterHtml);
                            HtmlNodeCollection itemlist = doc1.DocumentNode.SelectNodes("//table").Last().SelectNodes("//tr");
                            foreach (HtmlNode node in itemlist)
                            {
                                var list = node.SelectNodes("td");
                                if (list == null)
                                    continue;
                                string shuju = shuju1;
                                foreach (var item3 in list)
                                {
                                    shuju += item3.InnerText.Trim() + "|";
                                }
                                //gamelist.Add(shuju);
                                var listurl = url.Split('/');
                                string season = listurl[6];
                                HtmlDocument doc2 = new HtmlDocument();
                                doc2.LoadHtml(list.Last().InnerHtml);
                                HtmlNodeCollection itemlist2 = doc2.DocumentNode.SelectNodes("//a");
                                Insert(shuju, Id, season, itemlist2[0].Attributes["href"].Value);
                            }
                        }
                    }
                    
                    
                }

            }
            catch (Exception e)
            {

                Trace.WriteLine("某某杯 发生异常：" + url);
            }



        }

        public void GetClick(string url, string currentRound, string Id)
        {
            if (url.Contains("cup"))
            {
                GetCupData(url, currentRound, Id);
            }
            else
            {
                GetLeagueData(url, currentRound, Id);
            }
        }
        /// <summary>
        /// 某某杯 友谊
        /// </summary>
        /// <param name="url"></param>
        public void GetCupData_yy(string url, List<F_Grouping> glist)
        {
            string currentRound, Id;
            try
            {
                Trace.WriteLine("某某杯 开始：" + url);
                url = url.Replace(":80", "");
                var htmlResource = CommonHelper.GetHtmlString(url, "足彩");
                HtmlDocument doc = new HtmlDocument();
                if (htmlResource == null)
                    return;
                doc.LoadHtml(htmlResource);
                //比赛分组集合
                HtmlNodeCollection GamegroupHtml = doc.DocumentNode.SelectNodes("//*[@id='tabs9']/li");
                foreach (var item in GamegroupHtml)
                {
                    string shuju1 = "";
                    //比赛集合
                    HtmlNodeCollection GameHtml = doc.DocumentNode.SelectNodes("//*[@id='tabs9_" + item.Id + "']");
                    foreach (var item1 in GameHtml)
                    {
                        HtmlDocument doc1 = new HtmlDocument();
                        doc1.LoadHtml(item1.OuterHtml);
                        HtmlNodeCollection itemlist = doc1.DocumentNode.SelectNodes("//table").Last().SelectNodes("//tr");
                        foreach (HtmlNode node in itemlist)
                        {
                            var list = node.SelectNodes("td");
                            if (list == null)
                                continue;
                            string shuju = shuju1;
                            foreach (var item3 in list)
                            {
                                shuju += item3.InnerText.Trim() + "|";
                            }
                            //gamelist.Add(shuju);
                            var listurl = url.Split('/');
                            string season = listurl[6];
                            HtmlDocument doc2 = new HtmlDocument();
                            doc2.LoadHtml(list.Last().InnerHtml);
                            HtmlNodeCollection itemlist2 = doc2.DocumentNode.SelectNodes("//a");
                            var sss = glist.Where(a => a.Name.Trim() == item.InnerText.Trim() && a.Remark.Replace(":80", "") == url).FirstOrDefault();
                            Id = glist.Where(a => a.Name.Trim() == item.InnerText.Trim() && a.Remark.Replace(":80", "") == url).FirstOrDefault() == null ? "" : glist.Where(a => a.Name.Trim() == item.InnerText.Trim() && a.Remark.Replace(":80", "") == url).FirstOrDefault().Id;
                            Insert(shuju, Id, season, itemlist2[0].Attributes["href"].Value);
                        }
                    }
                }

            }
            catch (Exception e)
            {

                Trace.WriteLine("某某杯 发生异常：" + url);
            }



        }
        /// <summary>
        /// 国家赛事
        /// </summary>
        /// <param name="url"></param>
        public void GetLeagueData(string url, string currentRound, string Id)
        {
            string msg = "";
            try
            {
                Trace.WriteLine("国家赛事 开始：" + url);
                url = url.Replace(":80", "");
                int Round = -1;
                try
                {
                    Round = Convert.ToInt32(currentRound);
                }
                catch (Exception e)
                {

                    Round = -1;
                }
                if (Round != -1)
                {
                    var listurl = url.Split('/');
                    string source_league_id = listurl[5];
                    string season = listurl[6];
                    var html = CommonHelper.GetPostHtmlString(url, new HttpItem
                    {
                        Url = "http://saishi.zgzcw.com/summary/liansaiAjax.action",
                        Method = "Post",
                        WebProxy = new WebProxy(CommonHelper.GetIp()),
                        FormData = new Dictionary<string, string>()
                    {
                        { "source_league_id" , source_league_id },
                        { "currentRound",currentRound},
                        { "season",season},
                        { "seasonType",""},
                    },
                        ContentType = "application/x-www-form-urlencoded",
                    });
                    //常规赛
                    msg = html.Html;
                    HtmlDocument doc = new HtmlDocument();
                    if (html.Html == null)
                        return;
                    doc.LoadHtml(html.Html);

                    //比赛集合
                    HtmlNodeCollection itemlist = doc.DocumentNode.SelectNodes("//table/tr");
                    foreach (HtmlNode node in itemlist)
                    {
                        var list = node.SelectNodes("td");
                        string shuju = "";
                        foreach (var item3 in list)
                        {
                            shuju += item3.InnerText.Trim() + "|";
                        }
                        //gamelist.Add(shuju);
                        HtmlDocument doc2 = new HtmlDocument();
                        doc2.LoadHtml(list.Last().InnerHtml);
                        HtmlNodeCollection itemlist2 = doc2.DocumentNode.SelectNodes("//a");
                        Insert(shuju, Id, season, itemlist2[0].Attributes["href"].Value);

                    }
                }
                else
                {
                    var listurl = url.Split('/');
                    string source_league_id = listurl[5];
                    string season = listurl[6];
                    var html = CommonHelper.GetPostHtmlString(url, new HttpItem
                    {
                        Url = "http://saishi.zgzcw.com/summary/liansaifjAction.action",
                        Method = "Post",
                        WebProxy = new WebProxy(CommonHelper.GetIp()),
                        FormData = new Dictionary<string, string>()
                    {
                       { "source_league_id" , source_league_id},
                        { "hostTeamId","0"},
                        { "guestTeamId","0"},
                        { "season",season},
                        { "seasonType","1"},
                    },
                        ContentType = "application/x-www-form-urlencoded",
                    });
                    msg = html.Html;
                    HtmlDocument doc = new HtmlDocument();
                    if (html.Html == null)
                        return;
                    doc.LoadHtml(html.Html);

                    //附加比赛集合
                    HtmlNodeCollection itemlist = doc.DocumentNode.SelectNodes("//*[@id ='fjtab']/tr");
                    if (itemlist == null)
                    {
                        Trace.WriteLine("附加赛没有数据" + url);
                        return;
                    }
                    foreach (HtmlNode node1 in itemlist)
                    {
                        var list1 = node1.SelectNodes("td");
                        string shuju = "";
                        foreach (var item3 in list1)
                        {
                            shuju += item3.InnerText.Trim() + "|";
                        }
                        // gamelist.Add(shuju);
                        HtmlDocument doc2 = new HtmlDocument();
                        doc2.LoadHtml(list1.Last().InnerHtml);
                        HtmlNodeCollection itemlist2 = doc2.DocumentNode.SelectNodes("//a");
                        Insert(shuju, Id, season, itemlist2[0].Attributes["href"].Value);

                    }


                }
            }
            catch (Exception e)
            {
                urllist.Add(url + "|" + currentRound + "|" + Id);
                Trace.WriteLine("某某杯 发生异常：" + url + "_:" + currentRound + ":_" + "__" + msg);
            }



        }

        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void Insert(string data, string Id, string Season, string url)
        {
            var query = data.Split('|');
            F_Games game = new F_Games();
            game.Id = CommonHelper.GetGuid().ToString();
            game.CreateDateTime = DateTime.Now;
            game.EventId = Group.Where(a => a.Id == Id).FirstOrDefault().EventId;
            game.EventType = Group.Where(a => a.Id == Id).FirstOrDefault().EventType;
            game.Heat = 0;
            var team = teamlist.Where(a => a.Name == query[1]).FirstOrDefault();
            if (team == null)
                return;
            game.HomeTeamId = team == null ? "" : team.Id;
            game.HomeTeamScore_All = query[2].Split(':')[0].TryToInt32();
            game.HomeTeamScore_Half = query[4].Split(':')[0].TryToInt32();
            game.IsOvertime = false;
            game.Remark = url;
            game.Season = Season;
            game.StartDateTime = Convert.ToDateTime(query[0]);
            game.Status = query[4] == "-:-" ? g1 : query[2] == "-:-" ? g2 : g3;
            team = teamlist.Where(a => a.Name == query[3]).FirstOrDefault();
            if (team == null)
                return;
            game.VisitingTeamId = team.Id;
            game.VisitingTeamScore_All = query[2].Split(':')[1].TryToInt32();
            game.VisitingTeamScore_Half = query[4].Split(':')[1].TryToInt32();
            game.GroupingId = Id;
            game.IsObtain = false;
            lock (gamesList)
            {
                gamesList.Add(game);
            }
            
        }
        private string g1 = "d0da55f0c86ae811ab3100ac6a4a134f", g2 = "907dbd11c96ae811ab3100ac6a4a134f", g3 = "a058ec2ec96ae811ab3100ac6a4a134f";
    }
}