FCS/FCS.Crawler/Content/Jobs/FootJobs/ZCLotterySizeIndex/SizeIndexJob.cs

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

namespace FCS.Crawler.ZCLotterySizeIndex
{
    class SizeIndexJob : CommonJob, IJob
    {
        public SizeIndexJob()
        {
            log = new LogHelper();
            services = IOC.Resolve<IDTOpenCode>();
        }
        public void Execute(IJobExecutionContext context)
        {
            //Config = CommonHelper.GetConfigFromDataMap(context.JobDetail.JobDataMap);
            // Click();
        }

        private static List<int> listCuringint = new List<int>();
        private static List<int> listDetailint = new List<int>();
        private static List<int> listAnalysisint = new List<int>();
        private static List<string> listGameId = new List<string>();
        public void Click(List<F_Games> glist, List<F_Games> listxg)
        {
            try
            {
                string Season = DateTime.Now.ToString("yyyy");
                Gamelistq = glist;
                teamlist = services.Query<F_Team>().ToList();

                int number = glist.Count;
                int page = number % 1000 == 0 ? number / 1000 : number / 1000 + 1;

                //要删除的



                //插入之前 获取要删除的旧数据的所有PK
                for (int i = 0; i < listxg.Count; i++)
                {
                    listGameId.Add(listxg[i].Id);
                }
                if (listGameId.Count > 0)
                {
                    var query1 = services.Query<F_SizeIndex>(" and GameId  in ('" + string.Join("','", listGameId) + "') and ChangeDateTime>'" + Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")).ToString("yyyy-MM-dd HH:mm:ss.fff") + "'") == null ? new List<F_SizeIndex>() : services.Query<F_SizeIndex>(" and GameId  in ('" + string.Join("','", listGameId) + "') and ChangeDateTime>'" + Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")).ToString("yyyy-MM-dd HH:mm:ss.fff") + "'").ToList();
                    for (int i = 0; i < query1.Count; i++)
                    {
                        listDetailint.Add(query1[i].PK);
                    }
                    if (listGameId.Count > 0)
                    {
                        var query2 = services.Query<F_SizeIndexCuring>(" and GameId  in ('" + string.Join("','", listGameId) + "')") == null ? new List<F_SizeIndexCuring>() : services.Query<F_SizeIndexCuring>(" and GameId  in ('" + string.Join("','", listGameId) + "')").ToList();
                        for (int i = 0; i < query2.Count; i++)
                        {
                            listCuringint.Add(query2[i].PK);
                        }
                        var query3 = services.Query<F_CuringAnalysis>(" and GameId  in ('" + string.Join("','", listGameId) + "') and CuringType='308d6413438ee811af5a2c4d54d3f5a9'") == null ? new List<F_CuringAnalysis>() : services.Query<F_CuringAnalysis>(" and GameId  in ('" + string.Join("','", listGameId) + "') and CuringType='308d6413438ee811af5a2c4d54d3f5a9'").ToList();
                        for (int i = 0; i < query3.Count; i++)
                        {
                            listAnalysisint.Add(query3[i].PK);
                        }
                    }
                }


                for (int j = 0; j < page; j++)
                {
                    Trace.WriteLine("第几个J 开始 SizeIndexJob：" + (j));
                    Gamelist = Gamelistq.Skip(j * 1000).Take(1000).ToList();
                    finishcount = 0;
                    threadCount = Gamelist.Count;
                    Stopwatch sw = new Stopwatch();
                    sw.Start();
                    Gamelist.ForEach(p =>
                    {
                        taskList.Add( Task.Run(() =>
                        {
                            // Trace.WriteLine("大小分析 开始：" + Gamelist.IndexOf(p));
                            Getbjop_new(p.Remark, p);

                        }));
                      
                    });
                    Task.WaitAll(taskList.ToArray());
                    sw.Stop();
                    Trace.WriteLine("大小分析 结束" + sw.ElapsedMilliseconds + "毫秒");
                    Companylist = Companylist.Distinct().ToList();
                    InsertBankerCompany(Companylist);
                    InsertBankerCompany1();
                    {
                        List<F_SeasonAnalysis> teamlist = new List<F_SeasonAnalysis>();
                        try
                        {
                            teamlist = services.Query<F_SeasonAnalysis>().ToList();
                        }
                        catch (Exception e)
                        {

                        }

                        salist = salist.Distinct().ToList();
                        List<F_SeasonAnalysis> salist1 = salist.Where((x, i) => salist.FindIndex(z => z.TeamId == x.TeamId) == i).ToList();//Lambda表达式去重
                        List<F_SeasonAnalysis> salist2 = new List<F_SeasonAnalysis>();
                        foreach (var item in salist1)
                        {
                            if (teamlist.Where(a => a.TeamId == item.TeamId).ToList().Count == 0)
                                salist2.Add(item);
                        }

                        Trace.WriteLine("插入赛季分析数据 开始：" + salist2.Count);
                        if (salist2.Count != 0)
                            services.SqlBulkCopyAdd(salist2);
                    }

                    var listbk = services.Query<BankerCompany>().ToList();
                    //var oclist_1 = oclist;
                    //oclist = new List<F_SizeIndexCuring>();
                    //lock (oclist_new)
                    //{
                    //    foreach (var item in oclist_1)
                    //    {
                    //        F_SizeIndexCuring oc_new = new F_SizeIndexCuring();
                    //        if (item != null)
                    //        {
                    //            oc_new = item;
                    //            oc_new.BankerCompanyId = listbk.Where(a => a.Name == item.BankerCompanyId).FirstOrDefault().Id;
                    //            oclist_new.Add(oc_new);

                    //        }
                    //    }
                    //}

                    var oclist_1 = oclist;
                    oclist = new List<F_SizeIndexCuring>();
                    for (int i = 0; i < oclist_1.Count; i++)
                    {
                        lock (oclist_1)
                        {
                            F_SizeIndexCuring oc_new = new F_SizeIndexCuring();
                            if (i < oclist_1.Count)
                            {
                                oc_new = oclist_1[i];
                                lock (listbk)
                                {
                                    oc_new.BankerCompanyId = listbk.Where(a => a.Name == oclist_1[i].BankerCompanyId).FirstOrDefault().Id;
                                }
                                lock (oclist_new)
                                {
                                    oclist_new.Add(oc_new);
                                }
                            }
                            
                        }
                        
                    }

                    //finishcount = 0;
                    //threadCount = oclist.Count;
                    //oclist.ForEach(async p =>
                    //{
                    //    await Task.Run(() =>
                    //    {
                    //       // Trace.WriteLine("更换公司Id：");
                    //        F_SizeIndexCuring oc_new = new F_SizeIndexCuring();
                    //        if (p != null)
                    //        {
                    //            oc_new = p;
                    //            oc_new.BankerCompanyId = listbk.Where(a => a.Name == p.BankerCompanyId).FirstOrDefault().Id;
                    //            oclist_new.Add(oc_new);
                    //        }

                    //    });
                    //    lock (locker)
                    //    {
                    //        finishcount++;
                    //        Monitor.Pulse(locker); //完成，通知等待队列,告知已完，执行下一个。
                    //    }
                    //});
                    //lock (locker)
                    //{
                    //    while (finishcount != threadCount)
                    //    {
                    //        Thread.Sleep(5000);
                    //        Monitor.Wait(locker);//等待
                    //    }
                    //}
                    var csalist_1 = csalist;
                    csalist = new List<F_SizeIndex>();
                    foreach (var item in csalist_1)
                    {
                        F_SizeIndex cp = new F_SizeIndex();
                        cp = item;

                        // Getbjop(p.Remark, p);

                        lock (listbk)
                        {
                            cp.BankerCompanyId = listbk.Where(a => a.Name == item.BankerCompanyId).FirstOrDefault().Id;
                        }
                        lock (oclist_new)
                        {
                            csalist_new.Add(cp);
                        }
                    }
                    //finishcount = 0;
                    //threadCount = csalist.Count;
                    //csalist.ForEach(async p =>
                    //{
                    //    await Task.Run(() =>
                    //    {
                    //        if (p != null)
                    //        {
                    //            lock (csalist_new)
                    //            {
                    //               // Trace.WriteLine("更换公司Id：" + csalist.IndexOf(p));
                    //                F_SizeIndex cp = new F_SizeIndex();
                    //                cp = p;
                    //                cp.BankerCompanyId = listbk.Where(a => a.Name == p.BankerCompanyId).FirstOrDefault().Id;
                    //                // Getbjop(p.Remark, p);
                    //                csalist_new.Add(cp);

                    //            }

                    //        }

                    //    });
                    //    lock (locker)
                    //    {
                    //        finishcount++;
                    //        Monitor.Pulse(locker); //完成，通知等待队列,告知已完，执行下一个。
                    //    }
                    //});
                    //lock (locker)
                    //{
                    //    while (finishcount != threadCount)
                    //    {
                    //        Thread.Sleep(5000);
                    //        Monitor.Wait(locker);//等待
                    //    }
                    //}

                    List<F_CuringAnalysis> calist1 = calist.Where((x, i) => calist.FindIndex(z => z.GameId == x.GameId && z.CuringAnalysisType == x.CuringAnalysisType) == i).ToList();//Lambda表达式去重


                    Trace.WriteLine("插入大小固化数据 开始：" + oclist_new.Count);
                    CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入大小固化数据 开始：" + oclist_new.Count);
                    if (oclist_new.Count > 0)
                        services.SqlBulkCopyAdd(oclist_new);
                    Trace.WriteLine("插入大小详情数据 开始：" + csalist_new.Count);
                    CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入大小详情数据 开始：" + csalist_new.Count);
                    if (csalist_new.Count > 0)
                        services.SqlBulkCopyAdd(csalist_new);
                    Trace.WriteLine("插入固化分析数据 开始：" + calist1.Count);
                    CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入固化分析数据 开始：" + calist1.Count);
                    if (calist1.Count > 0)
                        services.SqlBulkCopyAdd(calist1);

                    urllist = new List<string>();
                    urllist1 = new List<string>();
                    Companylist = new List<string>();//所有公司
                    bclist = new List<BankerCompany>();
                    bcrlist = new List<BankerCompanyRelation>();
                    calist = new List<F_CuringAnalysis>();
                    salist = new List<F_SeasonAnalysis>();
                    oclist = new List<F_SizeIndexCuring>();
                    oclist_new = new List<F_SizeIndexCuring>();
                    csalist = new List<F_SizeIndex>();
                    csalist_new = new List<F_SizeIndex>();
                }



                Trace.WriteLine("删除数据 F_CuringAnalysis 开始：" + listAnalysisint.Count);
                if (listAnalysisint.Count > 0)
                    services.Delete<F_CuringAnalysis>(" and PK in (" + string.Join(",", listAnalysisint) + ")");
                Trace.WriteLine("删除数据 F_CuringAnalysis 结束：" + listAnalysisint.Count);

                Trace.WriteLine("删除数据 F_SizeIndex 开始：" + listDetailint.Count);
                if (listDetailint.Count > 0)
                    services.Delete<F_SizeIndex>(" and PK in (" + string.Join(",", listDetailint) + ")");
                Trace.WriteLine("删除数据 F_SizeIndex 结束：" + listDetailint.Count);

                Trace.WriteLine("删除数据 F_SizeIndexCuring 开始：" + listCuringint.Count);
                if (listCuringint.Count > 0)
                    services.Delete<F_SizeIndexCuring>(" and PK in (" + string.Join(",", listCuringint) + ")");
                Trace.WriteLine("删除数据 F_SizeIndexCuring 结束：" + listCuringint.Count);
            }
            catch (Exception e)
            {
                Click(glist, listxg);
                
            }

            

        }
        public void DoMainUrl()
        {

            teamlist = services.Query<F_Team>().ToList();
            Gamelistq = services.Query<F_Games>().ToList();
            int number = Gamelistq.Count;
            int page = number % 200 == 0 ? number / 200 : number / 200 + 1;
            ThreadPool.SetMinThreads(1, 1);
            ThreadPool.SetMaxThreads(500, 500);
            CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "j的结束值：" + ConfigurationManager.AppSettings["end"].TryToInt32() + "____j的最大值：" + page);
            if (ConfigurationManager.AppSettings["end"].TryToInt32() != -1)
            {
                if (ConfigurationManager.AppSettings["end"].TryToInt32() > page)
                {
                    CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "超出页数的最大值");
                    return;
                }
                page = ConfigurationManager.AppSettings["end"].TryToInt32();//1520
            }

            for (int j = ConfigurationManager.AppSettings["j"].TryToInt32(); j < page; j++)
            {
                Trace.WriteLine("第几个J 开始：" + (j));
                CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "第几个J 开始：" + (j));
                Gamelist = Gamelistq.Skip(j * 200).Take(200).ToList();
                Gamelist.ForEach(p =>
                {
                    Task.Run(() =>
                    {
                        Trace.WriteLine("大小分析 开始：" + Gamelist.IndexOf(p));
                        Getbjop(p.Remark, p);

                    });
                });
                while (true)
                {
                    if (CommonHelper.ThreadsFinsh())
                        break;
                }

                Companylist = Companylist.Distinct().ToList();
                InsertBankerCompany(Companylist);
                InsertBankerCompany1();
                {
                    List<F_SeasonAnalysis> teamlist = new List<F_SeasonAnalysis>();
                    try
                    {
                        teamlist = services.Query<F_SeasonAnalysis>().ToList();
                    }
                    catch (Exception e)
                    {

                    }

                    salist = salist.Distinct().ToList();
                    List<F_SeasonAnalysis> salist1 = salist.Where((x, i) => salist.FindIndex(z => z.TeamId == x.TeamId) == i).ToList();//Lambda表达式去重
                    List<F_SeasonAnalysis> salist2 = new List<F_SeasonAnalysis>();
                    foreach (var item in salist1)
                    {
                        if (teamlist.Where(a => a.TeamId == item.TeamId).ToList().Count == 0)
                            salist2.Add(item);
                    }

                    Trace.WriteLine("插入赛季分析数据 开始：" + salist2.Count);
                    if (salist2.Count != 0)
                        services.SqlBulkCopyAdd(salist2);
                }

                var listbk = services.Query<BankerCompany>().ToList();
                try
                {
                    //oclist.ForEach(p =>
                    //{
                    //    Task.Run(() =>
                    //    {
                    //        try
                    //        {
                    //            Trace.WriteLine("更换公司Id：");
                    //            F_SizeIndexCuring oc_new = new F_SizeIndexCuring();
                    //            if (p != null)
                    //            {
                    //                oc_new = p;
                    //                oc_new.BankerCompanyId = listbk.Where(a => a.Name == p.BankerCompanyId).FirstOrDefault().Id;
                    //                // Getbjop(p.Remark, p);
                    //                oclist_new.Add(oc_new);
                    //            }

                    //        }
                    //        catch (Exception e)
                    //        {

                    //        }

                    //    });
                    //});

                    Task[] processors = new Task[oclist.Count];
                    for (int i = 0; i < oclist.Count; i++)
                    {
                        int processId = i;
                        processors[i] = Task.Run(
                            () => {
                                try
                                {
                                    Trace.WriteLine("更换公司Id：");
                                    F_SizeIndexCuring oc_new = new F_SizeIndexCuring();
                                    if (oclist[processId] != null)
                                    {
                                        oc_new = oclist[processId];
                                        oc_new.BankerCompanyId = listbk.Where(a => a.Name == oclist[processId].BankerCompanyId).FirstOrDefault().Id;
                                        // Getbjop(p.Remark, p);
                                        oclist_new.Add(oc_new);
                                    }

                                }
                                catch (Exception e)
                                {

                                }

                            }
                            );
                    }

                }
                catch (Exception r)
                {


                }

                while (true)
                {
                    if (CommonHelper.ThreadsFinsh())
                        break;
                }

                csalist.ForEach(p =>
                {
                    Task.Run(() =>
                    {
                        if (p != null)
                        {
                            lock (csalist)
                            {
                                Trace.WriteLine("更换公司Id：" + csalist.IndexOf(p));
                                F_SizeIndex cp = new F_SizeIndex();
                                cp = p;
                                cp.BankerCompanyId = listbk.Where(a => a.Name == p.BankerCompanyId).FirstOrDefault().Id;
                                // Getbjop(p.Remark, p);
                                csalist_new.Add(cp);
                            }

                        }

                    });
                });
                while (true)
                {
                    if (CommonHelper.ThreadsFinsh())
                        break;
                }

                List<F_CuringAnalysis> calist1 = calist.Where((x, i) => calist.FindIndex(z => z.GameId == x.GameId && z.CuringAnalysisType == x.CuringAnalysisType) == i).ToList();//Lambda表达式去重


                Trace.WriteLine("插入大小固化数据 开始：" + oclist_new.Count);
                CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入固化分析数据 开始：" + oclist_new.Count);
                if (oclist_new.Count > 0)
                    services.SqlBulkCopyAdd(oclist_new);
                Trace.WriteLine("插入大小详情数据 开始：" + csalist_new.Count);
                CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入固化分析数据 开始：" + csalist_new.Count);
                if (csalist_new.Count > 0)
                    services.SqlBulkCopyAdd(csalist_new);
                Trace.WriteLine("插入固化分析数据 开始：" + calist1.Count);
                CommonHelper.Write(ConfigurationManager.AppSettings["SizeIndexJob"], "插入固化分析数据 开始：" + calist1.Count);
                if (calist1.Count > 0)
                    services.SqlBulkCopyAdd(calist1);

                urllist = new List<string>();
                urllist1 = new List<string>();
                Companylist = new List<string>();//所有公司
                bclist = new List<BankerCompany>();
                bcrlist = new List<BankerCompanyRelation>();
                calist = new List<F_CuringAnalysis>();
                salist = new List<F_SeasonAnalysis>();
                oclist = new List<F_SizeIndexCuring>();
                oclist_new = new List<F_SizeIndexCuring>();
                csalist = new List<F_SizeIndex>();
                csalist_new = new List<F_SizeIndex>();
            }
        }
        public List<string> urllist = new List<string>();
        public List<string> urllist1 = new List<string>();
        public List<string> Companylist = new List<string>();//所有公司
        public static List<BankerCompany> bclist = new List<BankerCompany>();
        public static List<BankerCompanyRelation> bcrlist = new List<BankerCompanyRelation>();
        public static List<F_CuringAnalysis> calist = new List<F_CuringAnalysis>();
        public static List<F_Team> teamlist = new List<F_Team>();
        public static List<F_Games> Gamelist = new List<F_Games>();
        public static List<F_SeasonAnalysis> salist = new List<F_SeasonAnalysis>();
        public static List<F_SizeIndexCuring> oclist = new List<F_SizeIndexCuring>();
        public static List<F_SizeIndexCuring> oclist_new = new List<F_SizeIndexCuring>();
        public static List<F_SizeIndex> csalist = new List<F_SizeIndex>();
        public static List<F_SizeIndex> csalist_new = new List<F_SizeIndex>();
        public static List<F_Games> Gamelistq = new List<F_Games>();

        public void Getbjop(string url, F_Games game)
        {
            url = url.Replace(":80", "").Replace("ypdb", "dxdb");
            //class="bf-tab-02"
            // Trace.WriteLine("大小分析 开始：" + url);
            string yurl = url;
            ;
            var htmlResource = CommonHelper.GetHtmlString(url, "足彩");
            HtmlDocument doc = new HtmlDocument();
            if (htmlResource == null)
                return;
            doc.LoadHtml(htmlResource);

            //赔率集合
            HtmlNodeCollection bjopHtml = doc.DocumentNode.SelectNodes("//*[@class='bf-tab-02']/tr");
            if (bjopHtml == null)
                return;


            HtmlNodeCollection homenameHtml = doc.DocumentNode.SelectNodes("//*[@class='host-name']/a");
            var q1 = teamlist.Where(a => a.Name == homenameHtml[0].InnerText.Trim()).FirstOrDefault();
            string HomeTeamName = "";
            string data = "";
            if (q1 != null)
            {
                HomeTeamName = q1.Name;
                HtmlNodeCollection homepmHtml = doc.DocumentNode.SelectNodes("//*[@class='team-add-info-zd']");
                if (homepmHtml[0].InnerText.Trim().Contains("上赛季排名"))
                {
                    data = "" + string.Join("|", homepmHtml[0].InnerText.Trim().Replace("上赛季排名：", "").Replace("本赛季排名", "").Split('：'));
                    HtmlNodeCollection homedfHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-h']");
                    data += "|" + homedfHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "");

                }
                else
                {

                    data = "" + homepmHtml[0].InnerText.Trim().Replace("FIFA排名：", "");
                    HtmlNodeCollection homedfHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-h']");
                    data += "|" + homedfHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "").Replace("积分", "");
                }
                InsertSeasonAnalysis(data, q1.Id, url, game.Season);
            }

            HtmlNodeCollection visitingnameHtml = doc.DocumentNode.SelectNodes("//*[@class='visit-name']/a");
            var q2 = teamlist.Where(a => a.Name == visitingnameHtml[0].InnerText.Trim()).FirstOrDefault();
            string VisitingTeamName = "";
            if (q2 != null)
            {
                VisitingTeamName = q2.Name;
                HtmlNodeCollection homepmkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-add-info-kd']");

                if (homepmkHtml[0].InnerText.Trim().Contains("上赛季排名"))
                {
                    data = "" + string.Join("|", homepmkHtml[0].InnerText.Trim().Replace("上赛季排名：", "").Replace("本赛季排名", "").Split('：'));
                    HtmlNodeCollection homedfkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-v']");
                    data += "|" + homedfkHtml[0].InnerText.Trim().Replace("客队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "");

                }
                else
                {

                    data = "" + homepmkHtml[0].InnerText.Trim().Replace("FIFA排名：", "");
                    HtmlNodeCollection homedfkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-v']");
                    data += "|" + homedfkHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "").Replace("积分", "");
                }
                InsertSeasonAnalysis(data, q2.Id, url, game.Season);
            }



            List<string> listdetail = new List<string>();
            foreach (var item in bjopHtml)
            {
                HtmlDocument doc1 = new HtmlDocument();
                doc1.LoadHtml(item.InnerHtml);
                HtmlNodeCollection bjoptdHtml = doc1.DocumentNode.SelectNodes("//td");
                int i = 1;
                string shuju = "", nurl = "";

                foreach (var item1 in bjoptdHtml)
                {
                    if (i == 2)
                    {
                        // shuju +=  item1.InnerText.Trim()+"|";
                        Companylist.Add(item1.InnerText.Trim() + "|" + item1.Attributes["data"].Value);
                        // Companylist = Companylist.Distinct().ToList();
                        // InsertBankerCompany();
                    }
                    if (i == 6)
                    {
                        shuju += item1.InnerText.Trim() + "|";
                        nurl = item1.SelectNodes("//a")[0].Attributes["href"].Value.Trim();
                    }
                    else if (i == 9)
                    {
                        HtmlDocument doc2 = new HtmlDocument();
                        doc2.LoadHtml(item1.InnerHtml);
                        HtmlNodeCollection timehtml = doc2.DocumentNode.SelectNodes("//em");
                        shuju += item.Attributes["firsttime"].Value + "|";
                    }
                    else
                    {
                        shuju += item1.InnerText.Trim() + "|";
                    }
                    i++;
                }
                listdetail.Add(shuju + "@" + nurl);
            }
            listdetail.ForEach(p =>
            {
                Task.Run(() =>
                {
                    try
                    {
                        var lis = p.Split('@')[0];
                        //Trace.WriteLine("大小分析多线程 开始：" + listdetail.IndexOf(p));
                        InsertOddsCuring(p.Split('@')[0], game.Id, p.Split('@')[1], game.StartDateTime.TryToDateTime(), game.HomeTeamId, game.VisitingTeamId, HomeTeamName, VisitingTeamName);
                    }
                    catch (Exception e)
                    {

                        Trace.WriteLine("大小分析多线程 报错：" + listdetail.IndexOf(p));
                    }


                });
            });
            //class="bf-tab-03"
            HtmlNodeCollection bjopfxHtml = doc.DocumentNode.SelectNodes("//*[@class='bf-tab-03']/tr");
            foreach (var item in bjopfxHtml)
            {
                HtmlDocument doc1 = new HtmlDocument();
                doc1.LoadHtml(item.InnerHtml);
                HtmlNodeCollection bjopfxtdHtml = doc1.DocumentNode.SelectNodes("//td");
                if (bjopfxtdHtml.Count == 15)
                {
                    string shuju = "";
                    foreach (var item1 in bjopfxtdHtml)
                    {
                        shuju += item1.InnerText.Trim() + "|";
                    }
                    InsertCuringAnalysis(shuju, game.Id, url);
                }
            }
        }
        public void Getbjopdetail(string url, F_SizeIndexCuring oc,string date)
        {
            try
            {
                //插入初始
                InsertCompensate_start(oc,date);
                //Trace.WriteLine("大小所有分析获取 开始：" + "http://fenxi.zgzcw.com" + url);
                string yurl = url;
                if (!url.Contains("http://fenxi.zgzcw.com"))
                    url = "http://fenxi.zgzcw.com" + url.Replace(":80", "");
                var htmlResource = CommonHelper.GetHtmlString(url, "足彩");
                HtmlDocument doc = new HtmlDocument();
                if (htmlResource == null)
                    return;
                doc.LoadHtml(htmlResource);
                HtmlNodeCollection detailHtml = doc.DocumentNode.SelectNodes("//*[@class='dxzkt-tab']/tr");
                if (detailHtml == null)
                    return;
                int i = 0;
                foreach (var item in detailHtml)
                {
                    if (i > 10)
                        return;
                    HtmlDocument doc1 = new HtmlDocument();
                    doc1.LoadHtml(item.InnerHtml);
                    HtmlNodeCollection bjopfxtdHtml = doc1.DocumentNode.SelectNodes("//td");
                    if (bjopfxtdHtml != null)
                    {
                        if (bjopfxtdHtml.Count == 11)
                        {
                            string shuju = "";
                            foreach (var item1 in bjopfxtdHtml)
                            {
                                shuju += item1.InnerText.Trim() + "|";
                            }
                            InsertCompensate(shuju, oc, url);
                        }
                    }
                    i++;
                }
            }
            catch (Exception e)
            {
                Trace.WriteLine("报错开始 开始：" + "http://fenxi.zgzcw.com" + url);
                //Getbjopdetail(url, oc);
            }
        }

        /// <summary>
        /// 插入数据公司
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertBankerCompany(List<string> Companylist)
        {
            List<BankerCompany> listbk = new List<BankerCompany>();
            try
            {
                listbk = services.Query<BankerCompany>().ToList();
            }
            catch (Exception e)
            {

            }

            foreach (var item in Companylist)
            {
                if (item.IsEmpty())
                    continue;
                var query = item.Split('|');
                if (listbk.Where(a => a.Name == query[0]).ToList().Count > 0)
                    continue;
                BankerCompany bc = new BankerCompany();
                bc.CreateDateTime = DateTime.Now;
                bc.Id = CommonHelper.GetGuid().ToString();
                bc.Name = query[0];
                bclist.Add(bc);
            }
            List<BankerCompany> bclist1 = bclist.Where((x, i) => bclist.FindIndex(z => z.Name == x.Name) == i).ToList();//Lambda表达式去重
            Trace.WriteLine("插入公司数据 开始：" + bclist1.Count);
            if (bclist1.Count != 0)
                services.SqlBulkCopyAdd(bclist1);

        }
        public void InsertBankerCompany1()
        {
            List<BankerCompany> listbk = new List<BankerCompany>();
            List<BankerCompanyRelation> listbkrs = new List<BankerCompanyRelation>();
            try
            {
                listbk = services.Query<BankerCompany>().ToList();
                listbkrs = services.Query<BankerCompanyRelation>().ToList();
            }
            catch (Exception e)
            {

            }
            foreach (var item in Companylist)
            {
                var query = item.Split('|');
                if (listbk.Where(a => a.Name == query[0]).ToList().Count > 0)
                {
                    var query2 = query[1].Split(',');
                    foreach (var item1 in query2)
                    {
                        //if (!item1.Trim().IsEmpty())
                        {
                            BankerCompanyRelation bcr = new BankerCompanyRelation();
                            bcr.BankerCompanyId = listbk.Where(a => a.Name == query[0]).FirstOrDefault().Id;
                            bcr.BankerCompanyType = a6;
                            bcr.Remark = "";
                            bcr.Id = CommonHelper.GetGuid().ToString();
                            bcr.CreateDateTime = DateTime.Now;
                            if (listbkrs.Where(a => a.BankerCompanyType == bcr.BankerCompanyType && a.BankerCompanyId == bcr.BankerCompanyId).ToList().Count == 0)
                            {
                                bcrlist.Add(bcr);
                            }
                        }
                    }
                }
                   

            }

            Trace.WriteLine("插入公司分类数据 开始：" + bcrlist.Count);
            if (bcrlist.Count != 0)
                services.SqlBulkCopyAdd(bcrlist);

        }
        public static string a1 = "c06f47ca4f8ee811af5a2c4d54d3f5a9", a2 = "00ae03d14f8ee811af5a2c4d54d3f5a9", a3 = "30d122dc4f8ee811af5a2c4d54d3f5a9", a4 = "f08de6e64f8ee811af5a2c4d54d3f5a9", a5 = "904f40ef4f8ee811af5a2c4d54d3f5a9", a6 = "a0a07a33fea0e811a35c00ac6a4a134f";
        
        //百家欧赔 c06f47ca4f8ee811af5a2c4d54d3f5a9
        //主流公司 00ae03d14f8ee811af5a2c4d54d3f5a9 0
        //交易公司 30d122dc4f8ee811af5a2c4d54d3f5a9 1
        //亚洲公司 f08de6e64f8ee811af5a2c4d54d3f5a9 2
        //普通公司 904f40ef4f8ee811af5a2c4d54d3f5a9 5

        /// <summary>
        /// 插入数据大小数据
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertCompensate(string data, F_SizeIndexCuring oc, string url)
        {
            try
            {
                var query = data.Replace("↓", "").Replace("↑", "").Split('|');
                F_SizeIndex ca = new F_SizeIndex();
                ca.BankerCompanyId = oc.BankerCompanyId;
                ca.ChangeDateTime = Convert.ToDateTime(query[1]);
                ca.SizeIndexType = "f1ff31dbda6ae811ab3100ac6a4a134f";//及时大小赔率 f1ff31dbda6ae811ab3100ac6a4a134f
                ca.CreateDateTime = DateTime.Now;
                ca.SOdd = Convert.ToDouble(query[3]);
                ca.POdd = -1;
                ca.Disc = Convert.ToString(query[4]) == null ? "" : Convert.ToString(query[4]);
                ca.FOdd = Convert.ToDouble(query[5]);
                ca.Remark = url;
                ca.Id = CommonHelper.GetGuid().ToString();
                ca.GameId = oc.GameId;
                csalist.Add(ca);
            }
            catch (Exception e)
            {


            }

        }

        /// <summary>
        /// 插入数据大小数据-初始
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertCompensate_start(F_SizeIndexCuring oc,string date)
        {
            try
            {
                F_SizeIndex ca = new F_SizeIndex();
                ca.BankerCompanyId = oc.BankerCompanyId;
                try
                {
                    ca.ChangeDateTime = Convert.ToDateTime(date);
                }
                catch (Exception e)
                {
                    ca.ChangeDateTime = Convert.ToDateTime("1999-01-01 00:01");

                }
                
                ca.SizeIndexType = "f0ff31dbda6ae811ab3100ac6a4a134f";//初始大小赔率 f0ff31dbda6ae811ab3100ac6a4a134f
                ca.CreateDateTime = DateTime.Now;
                ca.SOdd = Convert.ToDouble(oc.Init_SOdd);
                ca.POdd = -1;
                ca.Disc = oc.Init_DiscName;
                ca.FOdd = Convert.ToDouble(oc.Init_FOdds);
                ca.Remark = "";
                ca.Id = CommonHelper.GetGuid().ToString();
                ca.GameId = oc.GameId;
                csalist.Add(ca);
            }
            catch (Exception e)
            {


            }

        }
        /// <summary>
        /// 插入数据大小固化数据
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertOddsCuring(string data, string Id, string url, DateTime date, string HomeTeamId, string VisitingTeamId, string HomeTeamName, string VisitingTeamName)
        {
            try
            {
                var query = data.Replace("↓", "").Replace("↑", "").Split('|');
                F_SizeIndexCuring oc = new F_SizeIndexCuring();
                oc.Init_SOdd = Convert.ToDouble(query[2]);
                oc.Init_DiscName = query[3];
                oc.Init_FOdds = Convert.ToDouble(query[4]);
                oc.Newest_SOdd = Convert.ToDouble(query[5]);
                oc.Newest_DiscName = query[6];
                oc.Newest_FOdd = Convert.ToDouble(query[7]);
                oc.Probability_SOdd = Convert.ToDouble(query[9]);
                oc.Probability_FOdd = Convert.ToDouble(query[10]);
                oc.Kelly_SOdd = Convert.ToDouble(query[11]);
                oc.Kelly_FOdd = Convert.ToDouble(query[12]);
                oc.Loss_Odd = Convert.ToDouble(query[13]);
                oc.BankerCompanyName = query[1];
                oc.BankerCompanyId = query[1];
                oc.Remark = url;
                oc.Id = CommonHelper.GetGuid().ToString();
                oc.CreateDateTime = DateTime.Now;
                oc.GameId = Id;
                try
                {
                    oc.ChangeDateTime = Convert.ToDateTime(query[8]);
                }
                catch (Exception e)
                {

                    oc.ChangeDateTime = DateTime.Now;
                }

                oc.HomeTeamId = HomeTeamId;
                oc.HomeTeamName = HomeTeamName;
                oc.VisitingTeamId = VisitingTeamId;
                oc.VisitingTeamName = VisitingTeamName;
                oclist.Add(oc);
                Getbjopdetail(url, oc,query[8]);
            }
            catch (Exception s)
            {

            }

        }
        public DateTime GetDate(string time, DateTime date)
        {
            time = time.Replace("更新时间：赛前", "").Replace("时", "|").Replace("分", "").Trim();
            var query = time.Split('|');
            if (query.Length == 1)
                date.AddMinutes(Convert.ToInt32(query[0]));
            if (query.Length == 2)
                date.AddMinutes(Convert.ToInt32(query[1])).AddHours(Convert.ToInt32(query[0]));
            return date;
        }


        /// <summary>
        /// 插入数据大小固化分析数据
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertCuringAnalysis(string data, string Id, string url)
        {
            try
            {
                var query = data.Split('|');
                F_CuringAnalysis ca = new F_CuringAnalysis();
                ca.Remark = url;
                ca.Id = CommonHelper.GetGuid().ToString();
                ca.CreateDateTime = DateTime.Now;
                ca.CuringType = "308d6413438ee811af5a2c4d54d3f5a9";
                if (query[1] == "平均值")
                    ca.CuringAnalysisType = b1;
                if (query[1] == "最大值")
                    ca.CuringAnalysisType = b2;
                if (query[1] == "最小值")
                    ca.CuringAnalysisType = b3;
                ca.GameId = Id;
                ca.Init_SOdd = Convert.ToDouble(query[2]);
                ca.Init_POdd = -1;
                ca.Init_FOdd = Convert.ToDouble(query[4]);
                ca.Newest_SOdd = Convert.ToDouble(query[5]);
                ca.Newest_POdd = -1;
                ca.Newest_FOdd = Convert.ToDouble(query[7]);
                ca.Probability_SOdd = Convert.ToDouble(query[9]);
                ca.Probability_POdd = -1;
                ca.Probability_FOdd = Convert.ToDouble(query[10]);
                ca.Kelly_SOdd = Convert.ToDouble(query[11]);
                ca.Kelly_POdd = -1;
                ca.Kelly_FOdd = Convert.ToDouble(query[12]);
                ca.Loss_Odd = -1;
                calist.Add(ca);
            }
            catch (Exception e)
            {

            }

        }
        //public static string b1 = "c06f47ca4f8ee811af5a2c4d54d3f5a9", b2 = "00ae03d14f8ee811af5a2c4d54d3f5a9", b3 = "30d122dc4f8ee811af5a2c4d54d3f5a9";
        public static string b1 = "b1b112fa278ee811a04200ac6a4a134f", b2 = "b2b112fa278ee811a04200ac6a4a134f", b3 = "b1bf8c08288ee811a04200ac6a4a134f";
        //平均值 b1b112fa278ee811a04200ac6a4a134f 
        //最小值 b2b112fa278ee811a04200ac6a4a134f 
        //最大值 b1bf8c08288ee811a04200ac6a4a134f 
        /// <summary>
        /// 插入数据赛季分析表
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertSeasonAnalysis(string data, string Id, string url, string Season)
        {
            // List<F_SeasonAnalysis> salist1 = salist;
            //if (salist1.Where(a => a.Id == Id).ToList().Count > 0)
            //return;
            var query = data.Split('|');
            try
            {
                F_SeasonAnalysis sa = new F_SeasonAnalysis();
                sa.Remark = url;
                sa.Id = CommonHelper.GetGuid().ToString();
                sa.CreateDateTime = DateTime.Now;
                sa.Season = Season;
                sa.TeamId = Id;
                sa.OldRanking = query[0].TryToInt32();
                sa.NowOldRanking = query[1].TryToInt32();
                sa.Win = query[2].TryToInt32();
                sa.Draw = query[3].TryToInt32();
                sa.Lose = query[4].TryToInt32();
                sa.Number = query[5].TryToInt32();
                salist.Add(sa);
            }
            catch (Exception e)
            {
                F_SeasonAnalysis sa = new F_SeasonAnalysis();
                sa.Remark = url;
                sa.Id = CommonHelper.GetGuid().ToString();
                sa.CreateDateTime = DateTime.Now;
                sa.Season = Season;
                sa.TeamId = Id;
                sa.OldRanking = query[0].TryToInt32();
                sa.NowOldRanking = query[0].TryToInt32();
                sa.Win = 0;
                sa.Draw = 0;
                sa.Lose = 0;
                sa.Number = query[1].TryToInt32();
                salist.Add(sa);
            }
        }
        #region 更新

        public void Getbjop_new(string url, F_Games game)
        {
            url = url.Replace(":80", "").Replace("ypdb", "dxdb");
            string jsonall = CommonHelper.GetHtmlString(url.Replace("fenxi.zgzcw.com", "fenxi.zgzcw.com/json"), "", 20 * 1000);
            var htmlResource = CommonHelper.GetHtmlString(url, "", 20* 1000);
            HtmlDocument doc = new HtmlDocument();
            if (htmlResource == null)
                return;
            if (htmlResource == ConfigurationManager.AppSettings["HttpException"].ToString())
                return;

            doc.LoadHtml(htmlResource);

            //赔率集合
            HtmlNodeCollection bjopHtml = doc.DocumentNode.SelectNodes("//*[@class='bf-tab-02']/tr");
            if (bjopHtml == null)
                return;


            HtmlNodeCollection homenameHtml = doc.DocumentNode.SelectNodes("//*[@class='host-name']/a");
            var q1 = teamlist.Where(a => a.Name == homenameHtml[0].InnerText.Trim()).FirstOrDefault();
            string HomeTeamName = "";
            string data = "";
            if (q1 != null)
            {
                HomeTeamName = q1.Name;
                HtmlNodeCollection homepmHtml = doc.DocumentNode.SelectNodes("//*[@class='team-add-info-zd']");
                if (homepmHtml[0].InnerText.Trim().Contains("上赛季排名"))
                {
                    data = "" + string.Join("|", homepmHtml[0].InnerText.Trim().Replace("上赛季排名：", "").Replace("本赛季排名", "").Split('：'));
                    HtmlNodeCollection homedfHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-h']");
                    data += "|" + homedfHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "");

                }
                else
                {

                    data = "" + homepmHtml[0].InnerText.Trim().Replace("FIFA排名：", "");
                    HtmlNodeCollection homedfHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-h']");
                    data += "|" + homedfHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "").Replace("积分", "");
                }
                InsertSeasonAnalysis(data, q1.Id, url, game.Season);
            }

            HtmlNodeCollection visitingnameHtml = doc.DocumentNode.SelectNodes("//*[@class='visit-name']/a");
            var q2 = teamlist.Where(a => a.Name == visitingnameHtml[0].InnerText.Trim()).FirstOrDefault();
            string VisitingTeamName = "";
            if (q2 != null)
            {
                VisitingTeamName = q2.Name;
                HtmlNodeCollection homepmkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-add-info-kd']");

                if (homepmkHtml[0].InnerText.Trim().Contains("上赛季排名"))
                {
                    data = "" + string.Join("|", homepmkHtml[0].InnerText.Trim().Replace("上赛季排名：", "").Replace("本赛季排名", "").Split('：'));
                    HtmlNodeCollection homedfkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-v']");
                    data += "|" + homedfkHtml[0].InnerText.Trim().Replace("客队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "");

                }
                else
                {

                    data = "" + homepmkHtml[0].InnerText.Trim().Replace("FIFA排名：", "");
                    HtmlNodeCollection homedfkHtml = doc.DocumentNode.SelectNodes("//*[@class='team-info-v']");
                    data += "|" + homedfkHtml[0].InnerText.Trim().Replace("主队：", "").Replace("胜", "|").Replace("平", "|").Replace("负", "|").Replace("分", "").Replace("积分", "");
                }
                InsertSeasonAnalysis(data, q2.Id, url, game.Season);
            }



            List<string> listdetail = new List<string>();
            foreach (var item in bjopHtml)
            {
                HtmlDocument doc1 = new HtmlDocument();
                doc1.LoadHtml(item.InnerHtml);
                HtmlNodeCollection bjoptdHtml = doc1.DocumentNode.SelectNodes("//td");
                int i = 1;
                string shuju = "", nurl = "";
                DateTime lasttime =DateTime.Now;

                foreach (var item1 in bjoptdHtml)
                {
                    if (i == 2)
                    {
                        // shuju +=  item1.InnerText.Trim()+"|";
                        Companylist.Add(item1.InnerText.Trim() + "|" + item1.Attributes["data"].Value);
                        // Companylist = Companylist.Distinct().ToList();
                        // InsertBankerCompany();
                    }
                    if (i == 6)
                    {
                        shuju += item1.InnerText.Trim() + "|";
                        nurl = item1.SelectNodes("//a")[0].Attributes["href"].Value.Trim();
                    }
                    else if (i == 9)
                    {
                        HtmlDocument doc2 = new HtmlDocument();
                        doc2.LoadHtml(item1.InnerHtml);
                        HtmlNodeCollection timehtml = doc2.DocumentNode.SelectNodes("//em");
                        shuju += item.Attributes["firsttime"].Value + "|";
                        string datestring = timehtml[0].InnerText.Trim().Replace("更新时间：赛前", "").Replace("时", "|").Replace("分", "");
                        string Hours = "0";
                        string Minute = "0";
                        if (datestring.Split('|').Length == 2)
                        {
                            Hours = datestring.Split('|')[0];
                            Minute = datestring.Split('|')[1];
                        }
                        else if (datestring.Split('|').Length == 1)
                        {
                            Hours = "0";
                            Minute = datestring.Split('|')[0];

                        }
                        int Minutes = Minute.TryToInt32() + Hours.TryToInt32() * 60;
                        lasttime = Convert.ToDateTime(game.StartDateTime).AddMinutes(-Minutes);
                    }
                    else
                    {
                        shuju += item1.InnerText.Trim() + "|";
                    }
                    i++;
                }
                DateTime lastdate = lasttime;
                DateTime date = Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"));
              //  if (lastdate > date)
                {
                    listdetail.Add(shuju + "@" + nurl + "@" + lasttime);
                }
                //listdetail.Add(shuju + "@" + nurl);
            }
            int num = 0, max = listdetail.Count;
            listdetail.ForEach(async p =>
            {
                await Task.Run(() =>
                {
                    try
                    {
                        var lis = p.Split('@')[0];
                        //Trace.WriteLine("大小分析多线程 开始：" + listdetail.IndexOf(p));
                        InsertOddsCuring_new(p.Split('@')[0], game.Id, p.Split('@')[1], game.StartDateTime.TryToDateTime(), game.HomeTeamId, game.VisitingTeamId, HomeTeamName, VisitingTeamName, jsonall, Convert.ToDateTime(p.Split('@')[2]));
                    }
                    catch (Exception e)
                    {

                        Trace.WriteLine("大小分析多线程 报错：" + listdetail.IndexOf(p));
                    }


                });
                lock (locker)
                {
                    num++;
                    Monitor.Pulse(locker); //完成，通知等待队列,告知已完，执行下一个。
                }
            });
                lock (locker)
                {
                    while (num != max)
                    {
                    Thread.Sleep(5000);
                    Monitor.Wait(locker);//等待
                    }
                }
            //class="bf-tab-03"
            HtmlNodeCollection bjopfxHtml = doc.DocumentNode.SelectNodes("//*[@class='bf-tab-03']/tr");
            foreach (var item in bjopfxHtml)
            {
                HtmlDocument doc1 = new HtmlDocument();
                doc1.LoadHtml(item.InnerHtml);
                HtmlNodeCollection bjopfxtdHtml = doc1.DocumentNode.SelectNodes("//td");
                if (bjopfxtdHtml.Count == 15)
                {
                    string shuju = "";
                    foreach (var item1 in bjopfxtdHtml)
                    {
                        shuju += item1.InnerText.Trim() + "|";
                    }
                    InsertCuringAnalysis(shuju, game.Id, url);
                }
            }
        }
        public void Getbjopdetail_new(string url, F_SizeIndexCuring oc, string date)
        {
            try
            {
                //插入初始
                InsertCompensate_start(oc, date);
                //Trace.WriteLine("大小所有分析获取 开始：" + "http://fenxi.zgzcw.com" + url);
                string yurl = url;
                if (!url.Contains("http://fenxi.zgzcw.com"))
                    url = "http://fenxi.zgzcw.com" + url.Replace(":80", "");
                var htmlResource = CommonHelper.GetHtmlString(url, "足彩");
                HtmlDocument doc = new HtmlDocument();
                if (htmlResource == null)
                    return;
                doc.LoadHtml(htmlResource);
                HtmlNodeCollection detailHtml = doc.DocumentNode.SelectNodes("//*[@class='dxzkt-tab']/tr");
                if (detailHtml == null)
                    return;
                DateTime date1 = Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"));
                DateTime jdate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
                foreach (var item in detailHtml)
                {
                    
                    HtmlDocument doc1 = new HtmlDocument();
                    doc1.LoadHtml(item.InnerHtml);
                    HtmlNodeCollection bjopfxtdHtml = doc1.DocumentNode.SelectNodes("//td");
                    if (bjopfxtdHtml != null)
                    {
                        if (bjopfxtdHtml.Count == 11)
                        {
                            string shuju = "";
                            DateTime newdate = DateTime.Now;
                            int i = 0;
                            foreach (var item1 in bjopfxtdHtml)
                            {
                                shuju += item1.InnerText.Trim() + "|";
                                if (i == 1)
                                {
                                    try
                                    {
                                        newdate = Convert.ToDateTime(item1.InnerText.Trim());
                                    }
                                    catch (Exception e)
                                    {
                                    }

                                }
                                i++;
                            }
                            if (newdate > date1 && newdate < jdate)
                            {
                                InsertCompensate(shuju, oc, url);
                            }
                        }
                    }
                    
                }
            }
            catch (Exception e)
            {
                Trace.WriteLine("报错开始 开始：" + "http://fenxi.zgzcw.com" + url);
                //Getbjopdetail(url, oc);
            }
        }
        /// <summary>
        /// 插入数据大小固化数据
        /// </summary>
        /// <param name="data"></param>
        /// <param name="Id"></param>
        /// <param name="Season"></param>
        public void InsertOddsCuring_new(string data, string Id, string url, DateTime date, string HomeTeamId, string VisitingTeamId, string HomeTeamName, string VisitingTeamName, string jsonall, DateTime lastdate)
        {
            try
            {
                var query = data.Replace("↓", "").Replace("↑", "").Split('|');
                F_SizeIndexCuring oc = new F_SizeIndexCuring();
                oc.Init_SOdd = Convert.ToDouble(query[2]);
                oc.Init_DiscName = query[3];
                oc.Init_FOdds = Convert.ToDouble(query[4]);
                oc.Newest_SOdd = Convert.ToDouble(query[5]);
                oc.Newest_DiscName = query[6];
                oc.Newest_FOdd = Convert.ToDouble(query[7]);
                oc.Probability_SOdd = Convert.ToDouble(query[9]);
                oc.Probability_FOdd = Convert.ToDouble(query[10]);
                oc.Kelly_SOdd = Convert.ToDouble(query[11]);
                oc.Kelly_FOdd = Convert.ToDouble(query[12]);
                oc.Loss_Odd = Convert.ToDouble(query[13]);
                oc.BankerCompanyName = query[1];
                oc.BankerCompanyId = query[1];
                oc.Remark = url;
                oc.Id = CommonHelper.GetGuid().ToString();
                oc.CreateDateTime = DateTime.Now;
                oc.GameId = Id;
                try
                {
                    oc.ChangeDateTime = Convert.ToDateTime(query[8]);
                }
                catch (Exception e)
                {

                    oc.ChangeDateTime = DateTime.Now;
                }

                oc.HomeTeamId = HomeTeamId;
                oc.HomeTeamName = HomeTeamName;
                oc.VisitingTeamId = VisitingTeamId;
                oc.VisitingTeamName = VisitingTeamName;
                oclist.Add(oc);
                //Getbjopdetail_new(url, oc, query[8]);


                
                F_SizeIndex ca = new F_SizeIndex();
                ca.BankerCompanyId = oc.BankerCompanyId;
                ca.ChangeDateTime = lastdate;
                ca.SizeIndexType = "f1ff31dbda6ae811ab3100ac6a4a134f";//及时大小赔率 f1ff31dbda6ae811ab3100ac6a4a134f
                ca.CreateDateTime = DateTime.Now;
                ca.SOdd = Convert.ToDouble(query[5]);
                ca.POdd = -1;
                ca.Disc = query[6];
                ca.FOdd = Convert.ToDouble(query[7]);
                ca.Remark = "";
                ca.Id = CommonHelper.GetGuid().ToString();
                ca.GameId = oc.GameId;

               
                //csalist.Add(ca);
                lock (oclist)
                {
                    csalist.Add(ca);
                }



                Getbjopdetail_new_json(jsonall, query[1], lastdate, oc);
            }
            catch (Exception s)
            {

            }

        }

        public void Getbjopdetail_new_json(string jsonurl, string BankerCompanyName, DateTime lastdate, F_SizeIndexCuring oc)
        {
            var obj = JsonConvert.DeserializeObject<JObject>(jsonurl);
            var list = obj["company5List"];
            var objw = JsonConvert.DeserializeObject<List<company5List>>(list.ToString());
            var objw1 = objw.Where(a => a.attribute.name == BankerCompanyName).FirstOrDefault();

            foreach (var item in objw1.c)
            {
                if (lastdate == item.attribute.wdate.TryToDateTime())
                    continue;
                if (item.attribute.wdate.TryToDateTime() > Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")))
                {
                    F_SizeIndex ca = new F_SizeIndex();
                    ca.BankerCompanyId = oc.BankerCompanyId;
                    ca.ChangeDateTime = Convert.ToDateTime(item.attribute.wdate.TryToDateTime());
                    ca.SizeIndexType = "f1ff31dbda6ae811ab3100ac6a4a134f";//及时大小赔率 f1ff31dbda6ae811ab3100ac6a4a134f
                    ca.CreateDateTime = DateTime.Now;
                    ca.SOdd = Convert.ToDouble(item.attribute.win);
                    ca.POdd = -1;
                    ca.Disc = item.attribute.same;
                    ca.FOdd = Convert.ToDouble(item.attribute.lost);
                    ca.Remark = "";
                    ca.Id = CommonHelper.GetGuid().ToString();
                    ca.GameId = oc.GameId;
                    lock (csalist)
                    {
                        csalist.Add(ca);
                    }
                }
                else
                {
                    var s1 = item.attribute.wdate.TryToDateTime();
                    var s2 = Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"));
                }


            }

        }
        public class company5List
        {
            public company5List()
            {
                c = new List<sk>();
            }
            public Attribute attribute { get; set; }
            public List<sk> c { get; set; }
        }
        public class Attribute
        {
            public string name { get; set; }
            public string cid { get; set; }
        }
        public class sk
        {
            public sk2 attribute { get; set; }
            public string value { get; set; }
        }
        public class sk2
        {
            public string lost { get; set; }
            public string lostch { get; set; }
            public string arq { get; set; }
            public string wdate { get; set; }
            public string win { get; set; }
            public string wdate1 { get; set; }
            public string same { get; set; }
            public string cid { get; set; }

            public string samech { get; set; }
            public string alost { get; set; }
            public string awin { get; set; }
            public string winch { get; set; }
            public string returnPer { get; set; }

            public string arq_num { get; set; }
            public string same_handicap { get; set; }
        }
        #endregion
    }
}