using Business.Util;
using Common;
using Interface;
using Models;
using Models.Entity.LotteryNumDB;
using Services;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using System.Web;

namespace Business.KJH
{
    public static class KJBLL
    {
        private static LotteryNumInterface services;
        static KJBLL()
        {
            services = new LotteryService();
            
        }
        public static T GetLastItem<T>(SCCLottery lottery)
        {
            return services.GetLastItem<T>(lottery);

        }
        public delegate OpenCode21Model AsyncGetCeller(SCCLottery lottery);
       
        public static KaijiangDetailsEntity GetKaijiangEntity(string type, string entity)
        {
            return services.GetKJItem(type, entity);
        }
        /// <summary>
        /// 获取开奖信息不含倒计时和开奖规则链接
        /// </summary>
        /// <returns></returns>
        public static List<LotteryData> GetLotteryList()
        {
            try
            {


                List<LotteryData> qgc = new List<LotteryData>();
                List<LotteryData> dfc = new List<LotteryData>();
                #region 全国彩
                var ssq = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.QG_FCSSQ);//
                var _3d = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.QG_FC3D);
                var dlt = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.QG_TCDLT);
                var p3 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.QG_TCP3);
                var qxc = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.QG_TCQXC); //七星彩
                var qlc = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.QG_FCQLC); //七乐彩 
                #endregion
                #region 地方彩
                var hc1 = services.GetLastItem<OpenCode4DTModel>(Models.SCCLottery.DF_HC1_GuangDong);//地方彩好彩1
                var df6j1 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_DF6J1);//东方6+1
                var zj6j1 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_6J1_ZheJiang);//浙江6+1
                var hd15x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_HD15x5);//华东15选5
                var js7ws = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_TC7WS_JiangSu);//江苏7位数
                var hb30x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_30x5_HuBei);//湖北30选5
                var hn22x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_22x5_HeNan);//河南22选5
                var xj35x7 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_35x7_XinJiang);//新疆35选7
                var fj36x7 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_TC36x7_FuJian);//福建36选7
                var ny36x7 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_36x7_GuangDong);//南粤36选7
                var fj31x7 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_31x7_FuJian);//fj31x7

                var xj18x7 = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_18x7_XinJiang);//新疆18选7 
                var hebei20x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_20x5_HeBei);//河北20选5 
                var zhejiang20x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_20x5_ZheJiang);//浙江20选5 
                var DF_25x7_XinJiang = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.DF_25x7_XinJiang);//新疆27x7 
                var DF_26x5_GuangDong = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_26x5_GuangDong);//广东26选5 
                var DF_35x7_LiaoNing = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.DF_35x7_LiaoNing);//辽宁35选7 

                var DF_36x7_HeiLongJiang = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.DF_36x7_HeiLongJiang);//黑龙江35x7
                var DF_4J1_HaiNan = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_4J1_HaiNan);//海南4+1 
                var DF_FC25x5_AnHui = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_FC25x5_AnHui);//安徽福彩25x5 
                var DF_HYC2_HeBei = services.GetLastItem<OpenCode2DTModel>(Models.SCCLottery.DF_HYC2_HeBei);//河北好运彩2 
                var DF_HYC3_HeBei = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.DF_HYC3_HeBei);//河北好运彩3 
                var DF_KLSC_GuangXi = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_KLSC_GuangXi);//广西快乐SC3 
                var DF_LJFC22x5_HeiLongJiang = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_LJFC22x5_HeiLongJiang);//黑龙江 
                var DF_P62_HeiLongJiang = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_P62_HeiLongJiang);// 
                var DF_PL5_HeBei = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_PL5_HeBei);// 
                var DF_PL7_HeBei = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_PL7_HeBei);// 
                var DF_SMHLHC_HongKong = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_SMHLHC_HongKong);// 
                var DF_SZFC_GuangDong = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.DF_SZFC_GuangDong);// 
                var DF_TC22x5_FuJian = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.DF_TC22x5_FuJian);// 
                var DF_TC6J1_HeiLongJiang = services.GetLastItem<OpenCode7DTModel>(Models.SCCLottery.DF_TC6J1_HeiLongJiang);// 1
                var DF_TTCx4_ShangHai = services.GetLastItem<OpenCode4DTModel>(Models.SCCLottery.DF_TTCx4_ShangHai);// 

                #endregion

                #region 高频彩

                #region 黑龙江11x5
                var hlj11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_HeiLongJiang);

                #endregion
                #region 江苏11选5
                var js11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_JiangSu);

                #endregion
                #region 河北11选5
                var heb11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_HeBei);

                #endregion
                #region 广东11选5
                var gd11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_GuangDong);

                #endregion
                #region 浙江11选5
                var zj11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_ZheJiang);

                #endregion
                #region 云南11选5
                var yn11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_YunNan);

                #endregion
                #region 吉林11选5
                var jl11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_JiLin);

                #endregion
                #region 江西11选5
                var jx11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_JiangXi);

                #endregion
                #region 辽宁11选5
                var ln11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_LiaoNing);

                #endregion
                #region 山东11选5
                var sd11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_ShanDong);

                #endregion
                //--2016-12新增彩种
                #region 湖北11选5
                var hb11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_HuBei);

                #endregion
                #region 内蒙古11x5
                var nmg11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_NeiMengGu);

                #endregion
                #region 甘肃11x5
                var gs11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_GanSu);

                #endregion
                #region 福建11x5
                var fj11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_FuJian);

                #endregion
                #region 新疆11x5
                var xj11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_XinJiang);

                #endregion
                #region 陕西11x5
                var sxxa11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_ShanXiXiAn);

                #endregion
                #region 山西11x5
                var sxty11x5 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_ShanXiTaiYuan);

                #endregion
                var GP_11x5_AnHui = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_AnHui);//
                var GP_11x5_BeiJing = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_BeiJing);//
                var GP_11x5_GuangXi = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_GuangXi);//
                var GP_11x5_GuiZhou = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_GuiZhou);//
                var GP_11x5_ShangHai = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_11x5_ShangHai);//

                //--2016-12新增彩种 --end
                #region 江苏快3
                var jsk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_JiangSu);

                #endregion
                #region 河北快3
                var hebk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_HeBei);

                #endregion
                #region 安徽快3
                var ahk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_AnHui);

                #endregion
                #region 内蒙古快3
                var nmgk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_NeiMengGu);

                #endregion
                #region 吉林快3
                var jlk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_JiLin);

                #endregion
                #region 湖北快3
                var hubk3 = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_HuBei);

                #endregion
                var GP_K3_BeiJing = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_BeiJing);//
                var GP_K3_FuJian = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_FuJian);
                var GP_K3_GanSu = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_GanSu);//
                var GP_K3_GuangXi = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_GuangXi);//
                var GP_K3_GuiZhou = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_GuiZhou);//
                var GP_K3_HeNan = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_HeNan);//
                var GP_K3_JiangXi = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_JiangXi);//
                var GP_K3_QingHai = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_QingHai);//
                var GP_K3_ShangHai = services.GetLastItem<OpenCode3DTModel>(Models.SCCLottery.GP_K3_ShangHai);//

                #region 四川快乐12
                var sckl12 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_KL12_SiChuan);

                #endregion
                #region 辽宁快乐12
                var lnkl12 = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_KL12_LiaoNing);

                #endregion
                #region 浙江快乐彩
                var zjklc = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_KL12_ZheJiang);

                #endregion


                #region 山东群英会
                var sdqyh = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_QYH_ShanDong);

                #endregion
                #region 广东快乐十分
                var gdklsf = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_GuangDong);

                #endregion
                #region 广西快乐十分
                var gxklsf = services.GetLastItem<OpenCode5DTModel>(Models.SCCLottery.GP_KL10F_GuangXi);

                #endregion
                #region 山西快乐十分
                var sxtyklsf = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_ShanXiTaiYuan);

                #endregion
                #region 天津快乐十分
                var tjklsf = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_TianJin);

                #endregion
                //--2016-12新增彩种
                #region 重庆快乐十分(幸运农场)
                var cqklsf = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_ChongQing);

                #endregion
                #region 湖南快乐十分(动物总动员)
                var hnklsf = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_HuNan);

                #endregion
                var GP_KL10F_HeiLongJiang = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_HeiLongJiang);//
                var GP_KL10F_ShanXiXiAn = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_ShanXiXiAn);//
                var GP_KL10F_YunNan = services.GetLastItem<OpenCode8DTModel>(Models.SCCLottery.GP_KL10F_YunNan);//

                #region 北京快乐8
                var bjkl8 = services.GetLastItem<OpenCode21Model>(Models.SCCLottery.GP_KL8_BeiJing);

                #endregion
                #region 北京赛车pk10
                var bjpk10 = services.GetLastItem<OpenCode10Model>(Models.SCCLottery.GP_PK10_BeiJing);

                #endregion
                #region 上海时时乐
                var shssl = services.GetLastItem<OpenCode3Model>(Models.SCCLottery.GP_SSL_ShangHai);

                #endregion
                #region 快乐扑克3
                var klpk3 = services.GetLastItem<OpenCode3Model>(Models.SCCLottery.GP_KLPK3_ShanDong);

                #endregion
                #region 幸运赛车
                var xysc = services.GetLastItem<OpenCode3Model>(Models.SCCLottery.GP_XYSC_HuNan);

                #endregion
                #region 泳坛夺金
                var ytdj = services.GetLastItem<OpenCode4Model>(Models.SCCLottery.GP_KY481_HeNan);

                #endregion
                #endregion
                var GP_KZC_BeiJing = services.GetLastItem<OpenCode9Model>(Models.SCCLottery.GP_KZC_BeiJing);//1
                var GP_XLC_XinJiang = services.GetLastItem<OpenCode7Model>(Models.SCCLottery.GP_XLC_XinJiang);//1

                //var 
                #region 时时彩
                var GP_SSC_ChongQing = services.GetLastItem<OpenCode5Model>(Models.SCCLottery.GP_SSC_ChongQing);//1
                var GP_SSC_HeiLongJiang = services.GetLastItem<OpenCode5Model>(Models.SCCLottery.GP_SSC_HeiLongJiang);//1
                var GP_SSC_TianJin = services.GetLastItem<OpenCode5Model>(Models.SCCLottery.GP_SSC_TianJin);//1
                var GP_SSC_XinJiang = services.GetLastItem<OpenCode5Model>(Models.SCCLottery.GP_SSC_XinJiang);//1
                var GP_SSC_YunNan = services.GetLastItem<OpenCode5Model>(Models.SCCLottery.GP_SSC_YunNan);//1
                #endregion

                #region 组装
                if (ssq != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_FCSSQ.ToString(), int.Parse(ssq.Term.ToString()), ssq.OpenTime, ssq.ID, Array.ConvertAll<string, int>(ssq.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), ssq.Spare, "qgc"));
                }

                if (_3d != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_FC3D.ToString(), int.Parse(_3d.Term.ToString()), _3d.OpenTime, _3d.ID, Array.ConvertAll<string, int>(_3d.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), _3d.Spare, "qgc"));
                }

                if (dlt != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_TCDLT.ToString(), int.Parse(dlt.Term.ToString()), dlt.OpenTime, dlt.ID, Array.ConvertAll<string, int>(dlt.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), dlt.Spare, "qgc"));

                }

                if (p3 != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_TCP3.ToString(), int.Parse(p3.Term.ToString()), p3.OpenTime, p3.ID, Array.ConvertAll<string, int>(p3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), p3.Spare, "qgc"));
                }

                if (p3 != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_TCP5.ToString(), int.Parse(p3.Term.ToString()), p3.OpenTime, p3.ID, Array.ConvertAll<string, int>(p3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), p3.Spare, "qgc"));
                }
                if (qxc != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_TCQXC.ToString(), int.Parse(qxc.Term.ToString()), qxc.OpenTime, qxc.ID, Array.ConvertAll<string, int>(qxc.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), qxc.Spare, "qgc"));
                }
                if (qlc != null)
                {
                    qgc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.QG_FCQLC.ToString(), int.Parse(qlc.Term.ToString()), qlc.OpenTime, qlc.ID, Array.ConvertAll<string, int>(qlc.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), qlc.Spare, "qgc"));
                }
                //上面全国彩
                if (hc1 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_HC1_GuangDong.ToString(), int.Parse(hc1.Term.ToString()), hc1.OpenTime, hc1.ID, Array.ConvertAll<string, int>(hc1.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hc1.Spare, "dfc"));
                }
                if (df6j1 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_DF6J1.ToString(), int.Parse(df6j1.Term.ToString()), df6j1.OpenTime, df6j1.ID, Array.ConvertAll<string, int>(df6j1.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), df6j1.Spare, "dfc"));
                }
                if (zj6j1 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_6J1_ZheJiang.ToString(), int.Parse(zj6j1.Term.ToString()), zj6j1.OpenTime, zj6j1.ID, Array.ConvertAll<string, int>(zj6j1.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), zj6j1.Spare, "dfc"));
                }
                if (hd15x5 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_HD15x5.ToString(), int.Parse(hd15x5.Term.ToString()), hd15x5.OpenTime, hd15x5.ID, Array.ConvertAll<string, int>(hd15x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hd15x5.Spare, "dfc"));
                }
                if (js7ws != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_TC7WS_JiangSu.ToString(), int.Parse(js7ws.Term.ToString()), js7ws.OpenTime, js7ws.ID, Array.ConvertAll<string, int>(js7ws.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), js7ws.Spare, "dfc"));
                }
                if (hb30x5 != null)
                {
                    //DF_30x5_HuBei
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_30x5_HuBei.ToString(), int.Parse(hb30x5.Term.ToString()), hb30x5.OpenTime, hb30x5.ID, Array.ConvertAll<string, int>(hb30x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hb30x5.Spare, "dfc"));
                }
                if (hn22x5 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_22x5_HeNan.ToString(), int.Parse(hn22x5.Term.ToString()), hn22x5.OpenTime, hn22x5.ID, Array.ConvertAll<string, int>(hn22x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hn22x5.Spare, "dfc"));
                }
                if (xj35x7 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_35x7_XinJiang.ToString(), int.Parse(xj35x7.Term.ToString()), xj35x7.OpenTime, xj35x7.ID, Array.ConvertAll<string, int>(xj35x7.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), xj35x7.Spare, "dfc"));
                }
                if (fj36x7 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_TC36x7_FuJian.ToString(), int.Parse(fj36x7.Term.ToString()), fj36x7.OpenTime, fj36x7.ID, Array.ConvertAll<string, int>(fj36x7.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), fj36x7.Spare, "dfc"));
                }

                if (ny36x7 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_36x7_GuangDong.ToString(), int.Parse(ny36x7.Term.ToString()), ny36x7.OpenTime, ny36x7.ID, Array.ConvertAll<string, int>(ny36x7.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), ny36x7.Spare, "dfc"));
                }

                if (fj31x7 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_31x7_FuJian.ToString(), int.Parse(fj31x7.Term.ToString()), fj31x7.OpenTime, fj31x7.ID, Array.ConvertAll<string, int>(fj31x7.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), fj31x7.Spare, "dfc"));
                }
                if (xj18x7 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_18x7_XinJiang.ToString(), int.Parse(xj18x7.Term.ToString()), xj18x7.OpenTime, xj18x7.ID, Array.ConvertAll<string, int>(xj18x7.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), xj18x7.Spare, "dfc"));
                }
                if (hebei20x5 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_20x5_HeBei.ToString(), int.Parse(hebei20x5.Term.ToString()), hebei20x5.OpenTime, hebei20x5.ID, Array.ConvertAll<string, int>(hebei20x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hebei20x5.Spare, "dfc"));
                }
                if (zhejiang20x5 != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_20x5_ZheJiang.ToString(), int.Parse(zhejiang20x5.Term.ToString()), zhejiang20x5.OpenTime, zhejiang20x5.ID, Array.ConvertAll<string, int>(zhejiang20x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), zhejiang20x5.Spare, "dfc"));
                }
                if (DF_25x7_XinJiang != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_25x7_XinJiang.ToString(), int.Parse(DF_25x7_XinJiang.Term.ToString()), DF_25x7_XinJiang.OpenTime, DF_25x7_XinJiang.ID, Array.ConvertAll<string, int>(DF_25x7_XinJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_25x7_XinJiang.Spare, "dfc"));
                }
                if (DF_26x5_GuangDong != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_26x5_GuangDong.ToString(), int.Parse(DF_26x5_GuangDong.Term.ToString()), DF_26x5_GuangDong.OpenTime, DF_26x5_GuangDong.ID, Array.ConvertAll<string, int>(DF_26x5_GuangDong.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_26x5_GuangDong.Spare, "dfc"));
                }
                if (DF_35x7_LiaoNing != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_35x7_LiaoNing.ToString(), int.Parse(DF_35x7_LiaoNing.Term.ToString()), DF_35x7_LiaoNing.OpenTime, DF_35x7_LiaoNing.ID, Array.ConvertAll<string, int>(DF_35x7_LiaoNing.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_35x7_LiaoNing.Spare, "dfc"));
                }
                if (DF_36x7_HeiLongJiang != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_36x7_HeiLongJiang.ToString(), int.Parse(DF_36x7_HeiLongJiang.Term.ToString()), DF_36x7_HeiLongJiang.OpenTime, DF_36x7_HeiLongJiang.ID, Array.ConvertAll<string, int>(DF_36x7_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_36x7_HeiLongJiang.Spare, "dfc"));
                }
                if (DF_4J1_HaiNan != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_4J1_HaiNan.ToString(), int.Parse(DF_4J1_HaiNan.Term.ToString()), DF_4J1_HaiNan.OpenTime, DF_4J1_HaiNan.ID, Array.ConvertAll<string, int>(DF_4J1_HaiNan.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_4J1_HaiNan.Spare, "dfc"));

                }
                if (DF_FC25x5_AnHui != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_FC25x5_AnHui.ToString(), int.Parse(DF_FC25x5_AnHui.Term.ToString()), DF_FC25x5_AnHui.OpenTime, DF_FC25x5_AnHui.ID, Array.ConvertAll<string, int>(DF_FC25x5_AnHui.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_FC25x5_AnHui.Spare, "dfc"));
                }
                if (DF_HYC2_HeBei != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_HYC2_HeBei.ToString(), int.Parse(DF_HYC2_HeBei.Term.ToString()), DF_HYC2_HeBei.OpenTime, DF_HYC2_HeBei.ID, Array.ConvertAll<string, int>(DF_HYC2_HeBei.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_HYC2_HeBei.Spare, "dfc"));
                }
                if (DF_HYC3_HeBei != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_HYC3_HeBei.ToString(), int.Parse(DF_HYC3_HeBei.Term.ToString()), DF_HYC3_HeBei.OpenTime, DF_HYC3_HeBei.ID, Array.ConvertAll<string, int>(DF_HYC3_HeBei.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_HYC3_HeBei.Spare, "dfc"));
                }
                if (DF_KLSC_GuangXi != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_KLSC_GuangXi.ToString(), int.Parse(DF_KLSC_GuangXi.Term.ToString()), DF_KLSC_GuangXi.OpenTime, DF_KLSC_GuangXi.ID, Array.ConvertAll<string, int>(DF_KLSC_GuangXi.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_KLSC_GuangXi.Spare, "dfc"));
                }
                if (DF_LJFC22x5_HeiLongJiang != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_LJFC22x5_HeiLongJiang.ToString(), int.Parse(DF_LJFC22x5_HeiLongJiang.Term.ToString()), DF_LJFC22x5_HeiLongJiang.OpenTime, DF_LJFC22x5_HeiLongJiang.ID, Array.ConvertAll<string, int>(DF_LJFC22x5_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_LJFC22x5_HeiLongJiang.Spare, "dfc"));
                }
                if (DF_P62_HeiLongJiang != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_P62_HeiLongJiang.ToString(), int.Parse(DF_P62_HeiLongJiang.Term.ToString()), DF_P62_HeiLongJiang.OpenTime, DF_P62_HeiLongJiang.ID, Array.ConvertAll<string, int>(DF_P62_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_P62_HeiLongJiang.Spare, "dfc"));
                }
                if (DF_PL5_HeBei != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_PL5_HeBei.ToString(), int.Parse(DF_PL5_HeBei.Term.ToString()), DF_PL5_HeBei.OpenTime, DF_PL5_HeBei.ID, Array.ConvertAll<string, int>(DF_PL5_HeBei.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_PL5_HeBei.Spare, "dfc"));
                }
                if (DF_PL7_HeBei != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_PL7_HeBei.ToString(), int.Parse(DF_PL7_HeBei.Term.ToString()), DF_PL7_HeBei.OpenTime, DF_PL7_HeBei.ID, Array.ConvertAll<string, int>(DF_PL7_HeBei.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_PL7_HeBei.Spare, "dfc"));
                }
                if (DF_SMHLHC_HongKong != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_SMHLHC_HongKong.ToString(), int.Parse(DF_SMHLHC_HongKong.Term.ToString()), DF_SMHLHC_HongKong.OpenTime, DF_SMHLHC_HongKong.ID, Array.ConvertAll<string, int>(DF_SMHLHC_HongKong.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_SMHLHC_HongKong.Spare, "dfc"));
                }
                if (DF_SZFC_GuangDong != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_SZFC_GuangDong.ToString(), int.Parse(DF_SZFC_GuangDong.Term.ToString()), DF_SZFC_GuangDong.OpenTime, DF_SZFC_GuangDong.ID, Array.ConvertAll<string, int>(DF_SZFC_GuangDong.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_SZFC_GuangDong.Spare, "dfc"));
                }
                if (DF_TC22x5_FuJian != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_TC22x5_FuJian.ToString(), int.Parse(DF_TC22x5_FuJian.Term.ToString()), DF_TC22x5_FuJian.OpenTime, DF_TC22x5_FuJian.ID, Array.ConvertAll<string, int>(DF_TC22x5_FuJian.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_TC22x5_FuJian.Spare, "dfc"));
                }
                if (DF_TC6J1_HeiLongJiang != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_TC6J1_HeiLongJiang.ToString(), int.Parse(DF_TC6J1_HeiLongJiang.Term.ToString()), DF_TC6J1_HeiLongJiang.OpenTime, DF_TC6J1_HeiLongJiang.ID, Array.ConvertAll<string, int>(DF_TC6J1_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_TC6J1_HeiLongJiang.Spare, "dfc"));
                }
                if (DF_TTCx4_ShangHai != null)
                {
                    dfc.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.DF_TTCx4_ShangHai.ToString(), int.Parse(DF_TTCx4_ShangHai.Term.ToString()), DF_TTCx4_ShangHai.OpenTime, DF_TTCx4_ShangHai.ID, Array.ConvertAll<string, int>(DF_TTCx4_ShangHai.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), DF_TTCx4_ShangHai.Spare, "dfc"));
                }

                //上面是地方彩
                List<LotteryData> c11x5 = new List<LotteryData>();
                List<LotteryData> k3 = new List<LotteryData>();
                List<LotteryData> klsf = new List<LotteryData>();
                List<LotteryData> kl12 = new List<LotteryData>();
                List<LotteryData> qt = new List<LotteryData>();
                if (hlj11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_HeiLongJiang.ToString(), int.Parse(hlj11x5.Term.ToString()), hlj11x5.OpenTime, hlj11x5.ID, Array.ConvertAll<string, int>(hlj11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hlj11x5.Spare, "c11x5"));
                }

                if (js11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_JiangSu.ToString(), int.Parse(js11x5.Term.ToString()), js11x5.OpenTime, js11x5.ID, Array.ConvertAll<string, int>(js11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), js11x5.Spare, "c11x5"));
                }
                if (heb11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_HeBei.ToString(), int.Parse(heb11x5.Term.ToString()), heb11x5.OpenTime, heb11x5.ID, Array.ConvertAll<string, int>(heb11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), heb11x5.Spare, "c11x5"));
                }
                if (gd11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_GuangDong.ToString(), int.Parse(gd11x5.Term.ToString()), gd11x5.OpenTime, gd11x5.ID, Array.ConvertAll<string, int>(gd11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), gd11x5.Spare, "c11x5"));
                }

                if (zj11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_ZheJiang.ToString(), int.Parse(zj11x5.Term.ToString()), zj11x5.OpenTime, zj11x5.ID, Array.ConvertAll<string, int>(zj11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), zj11x5.Spare, "c11x5"));
                }

                if (yn11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_YunNan.ToString(), int.Parse(yn11x5.Term.ToString()), yn11x5.OpenTime, yn11x5.ID, Array.ConvertAll<string, int>(yn11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), yn11x5.Spare, "c11x5"));
                }
                if (jl11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_JiLin.ToString(), int.Parse(jl11x5.Term.ToString()), jl11x5.OpenTime, jl11x5.ID, Array.ConvertAll<string, int>(jl11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), jl11x5.Spare, "c11x5"));
                }
                if (jx11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_JiangXi.ToString(), int.Parse(jx11x5.Term.ToString()), jx11x5.OpenTime, jx11x5.ID, Array.ConvertAll<string, int>(jx11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), jx11x5.Spare, "c11x5"));
                }

                if (ln11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_LiaoNing.ToString(), int.Parse(ln11x5.Term.ToString()), ln11x5.OpenTime, ln11x5.ID, Array.ConvertAll<string, int>(ln11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), ln11x5.Spare, "c11x5"));
                }

                if (sd11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_ShanDong.ToString(), int.Parse(sd11x5.Term.ToString()), sd11x5.OpenTime, sd11x5.ID, Array.ConvertAll<string, int>(sd11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sd11x5.Spare, "c11x5"));
                }

                if (hb11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_HuBei.ToString(), int.Parse(hb11x5.Term.ToString()), hb11x5.OpenTime, hb11x5.ID, Array.ConvertAll<string, int>(hb11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hb11x5.Spare, "c11x5"));
                }
                if (nmg11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_NeiMengGu.ToString(), int.Parse(nmg11x5.Term.ToString()), nmg11x5.OpenTime, nmg11x5.ID, Array.ConvertAll<string, int>(nmg11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), nmg11x5.Spare, "c11x5"));
                }
                if (gs11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_GanSu.ToString(), int.Parse(gs11x5.Term.ToString()), gs11x5.OpenTime, gs11x5.ID, Array.ConvertAll<string, int>(gs11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), gs11x5.Spare, "c11x5"));
                }
                if (fj11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_FuJian.ToString(), int.Parse(fj11x5.Term.ToString()), fj11x5.OpenTime, fj11x5.ID, Array.ConvertAll<string, int>(fj11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), fj11x5.Spare, "c11x5"));
                }

                if (xj11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_XinJiang.ToString(), int.Parse(xj11x5.Term.ToString()), xj11x5.OpenTime, xj11x5.ID, Array.ConvertAll<string, int>(xj11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), xj11x5.Spare, "c11x5"));
                }
                if (sxxa11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_ShanXiXiAn.ToString(), int.Parse(sxxa11x5.Term.ToString()), sxxa11x5.OpenTime, sxxa11x5.ID, Array.ConvertAll<string, int>(sxxa11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sxxa11x5.Spare, "c11x5"));
                }
                if (sxty11x5 != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_ShanXiTaiYuan.ToString(), int.Parse(sxty11x5.Term.ToString()), sxty11x5.OpenTime, sxty11x5.ID, Array.ConvertAll<string, int>(sxty11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sxty11x5.Spare, "c11x5"));
                }
                if (GP_11x5_AnHui != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_AnHui.ToString(), int.Parse(GP_11x5_AnHui.Term.ToString()), GP_11x5_AnHui.OpenTime, GP_11x5_AnHui.ID, Array.ConvertAll<string, int>(GP_11x5_AnHui.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_11x5_AnHui.Spare, "c11x5"));
                }
                if (GP_11x5_BeiJing != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_BeiJing.ToString(), int.Parse(GP_11x5_BeiJing.Term.ToString()), GP_11x5_BeiJing.OpenTime, GP_11x5_BeiJing.ID, Array.ConvertAll<string, int>(GP_11x5_BeiJing.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_11x5_BeiJing.Spare, "c11x5"));
                }
                if (GP_11x5_GuangXi != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_GuangXi.ToString(), int.Parse(GP_11x5_GuangXi.Term.ToString()), GP_11x5_GuangXi.OpenTime, GP_11x5_GuangXi.ID, Array.ConvertAll<string, int>(GP_11x5_GuangXi.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_11x5_GuangXi.Spare, "c11x5"));
                }
                if (GP_11x5_GuiZhou != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_GuiZhou.ToString(), int.Parse(GP_11x5_GuiZhou.Term.ToString()), GP_11x5_GuiZhou.OpenTime, GP_11x5_GuiZhou.ID, Array.ConvertAll<string, int>(GP_11x5_GuiZhou.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_11x5_GuiZhou.Spare, "c11x5"));
                }
                if (GP_11x5_ShangHai != null)
                {
                    c11x5.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_11x5_ShangHai.ToString(), int.Parse(GP_11x5_ShangHai.Term.ToString()), GP_11x5_ShangHai.OpenTime, GP_11x5_ShangHai.ID, Array.ConvertAll<string, int>(GP_11x5_ShangHai.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_11x5_ShangHai.Spare, "c11x5"));
                }

                //上面是11x5

                if (jsk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_JiangSu.ToString(), int.Parse(jsk3.Term.ToString()), jsk3.OpenTime, jsk3.ID, Array.ConvertAll<string, int>(jsk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), jsk3.Spare, "k3"));
                }
                if (hebk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_HeBei.ToString(), int.Parse(hebk3.Term.ToString()), hebk3.OpenTime, hebk3.ID, Array.ConvertAll<string, int>(hebk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hebk3.Spare, "k3"));
                }
                if (ahk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_AnHui.ToString(), int.Parse(ahk3.Term.ToString()), ahk3.OpenTime, ahk3.ID, Array.ConvertAll<string, int>(ahk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), ahk3.Spare, "k3"));
                }
                if (nmgk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_NeiMengGu.ToString(), int.Parse(nmgk3.Term.ToString()), nmgk3.OpenTime, nmgk3.ID, Array.ConvertAll<string, int>(gs11x5.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), nmgk3.Spare, "k3"));
                }
                if (jlk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_JiLin.ToString(), int.Parse(jlk3.Term.ToString()), jlk3.OpenTime, jlk3.ID, Array.ConvertAll<string, int>(jlk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), jlk3.Spare, "k3"));
                }
                if (hubk3 != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_HuBei.ToString(), int.Parse(hubk3.Term.ToString()), hubk3.OpenTime, hubk3.ID, Array.ConvertAll<string, int>(hubk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hubk3.Spare, "k3"));
                }
                if (GP_K3_BeiJing != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_BeiJing.ToString(), int.Parse(GP_K3_BeiJing.Term.ToString()), GP_K3_BeiJing.OpenTime, GP_K3_BeiJing.ID, Array.ConvertAll<string, int>(GP_K3_BeiJing.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_BeiJing.Spare, "k3"));
                }
                if (GP_K3_FuJian != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_FuJian.ToString(), int.Parse(GP_K3_FuJian.Term.ToString()), GP_K3_FuJian.OpenTime, GP_K3_FuJian.ID, Array.ConvertAll<string, int>(GP_K3_FuJian.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_FuJian.Spare, "k3"));
                }
                if (GP_K3_GanSu != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_GanSu.ToString(), int.Parse(GP_K3_GanSu.Term.ToString()), GP_K3_GanSu.OpenTime, GP_K3_GanSu.ID, Array.ConvertAll<string, int>(GP_K3_GanSu.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_GanSu.Spare, "k3"));
                }
                if (GP_K3_GuangXi != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_GuangXi.ToString(), int.Parse(GP_K3_GuangXi.Term.ToString()), GP_K3_GuangXi.OpenTime, GP_K3_GuangXi.ID, Array.ConvertAll<string, int>(GP_K3_GuangXi.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_GuangXi.Spare, "k3"));
                }
                if (GP_K3_GuiZhou != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_GuiZhou.ToString(), int.Parse(GP_K3_GuiZhou.Term.ToString()), GP_K3_GuiZhou.OpenTime, GP_K3_GuiZhou.ID, Array.ConvertAll<string, int>(GP_K3_GuiZhou.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_GuiZhou.Spare, "k3"));
                }
                if (GP_K3_HeNan != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_HeNan.ToString(), int.Parse(GP_K3_HeNan.Term.ToString()), GP_K3_HeNan.OpenTime, GP_K3_HeNan.ID, Array.ConvertAll<string, int>(GP_K3_HeNan.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_HeNan.Spare, "k3"));
                }
                if (GP_K3_JiangXi != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_JiangXi.ToString(), int.Parse(GP_K3_JiangXi.Term.ToString()), GP_K3_JiangXi.OpenTime, GP_K3_JiangXi.ID, Array.ConvertAll<string, int>(GP_K3_JiangXi.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_JiangXi.Spare, "k3"));
                }
                if (GP_K3_QingHai != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_QingHai.ToString(), int.Parse(GP_K3_QingHai.Term.ToString()), GP_K3_QingHai.OpenTime, GP_K3_QingHai.ID, Array.ConvertAll<string, int>(GP_K3_QingHai.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_QingHai.Spare, "k3"));
                }
                if (GP_K3_ShangHai != null)
                {
                    k3.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_K3_ShangHai.ToString(), int.Parse(GP_K3_ShangHai.Term.ToString()), GP_K3_ShangHai.OpenTime, GP_K3_ShangHai.ID, Array.ConvertAll<string, int>(GP_K3_ShangHai.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_K3_ShangHai.Spare, "k3"));
                }

                //上面是快3
                if (sckl12 != null)
                {
                    kl12.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL12_SiChuan.ToString(), int.Parse(sckl12.Term.ToString()), sckl12.OpenTime, sckl12.ID, Array.ConvertAll<string, int>(sckl12.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sckl12.Spare, "kl12"));
                }
                if (lnkl12 != null)
                {
                    kl12.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL12_LiaoNing.ToString(), int.Parse(lnkl12.Term.ToString()), lnkl12.OpenTime, lnkl12.ID, Array.ConvertAll<string, int>(lnkl12.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), lnkl12.Spare, "kl12"));
                }
                if (zjklc != null)
                {
                    kl12.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL12_ZheJiang.ToString(), int.Parse(zjklc.Term.ToString()), zjklc.OpenTime, zjklc.ID, Array.ConvertAll<string, int>(zjklc.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), zjklc.Spare, "kl12"));
                }
                if (sdqyh != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_QYH_ShanDong.ToString(), int.Parse(sdqyh.Term.ToString()), sdqyh.OpenTime, sdqyh.ID, Array.ConvertAll<string, int>(sdqyh.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sdqyh.Spare, "qt"));
                }
                if (gdklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_GuangDong.ToString(), int.Parse(gdklsf.Term.ToString()), gdklsf.OpenTime, gdklsf.ID, Array.ConvertAll<string, int>(gdklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), gdklsf.Spare, "klsf"));
                }
                if (gxklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_GuangXi.ToString(), int.Parse(gxklsf.Term.ToString()), gxklsf.OpenTime, gxklsf.ID, Array.ConvertAll<string, int>(gxklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), gxklsf.Spare, "klsf"));
                }
                if (sxtyklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_ShanXiTaiYuan.ToString(), int.Parse(sxtyklsf.Term.ToString()), sxtyklsf.OpenTime, sxtyklsf.ID, Array.ConvertAll<string, int>(sxtyklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), sxtyklsf.Spare, "klsf"));
                }
                if (tjklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_TianJin.ToString(), int.Parse(tjklsf.Term.ToString()), tjklsf.OpenTime, tjklsf.ID, Array.ConvertAll<string, int>(tjklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), tjklsf.Spare, "klsf"));
                }
                if (cqklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_ChongQing.ToString(), int.Parse(cqklsf.Term.ToString()), cqklsf.OpenTime, cqklsf.ID, Array.ConvertAll<string, int>(cqklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), cqklsf.Spare, "klsf"));
                }

                if (hnklsf != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_HuNan.ToString(), int.Parse(hnklsf.Term.ToString()), hnklsf.OpenTime, hnklsf.ID, Array.ConvertAll<string, int>(hnklsf.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), hnklsf.Spare, "klsf"));
                }
                if (GP_KL10F_HeiLongJiang != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_HeiLongJiang.ToString(), int.Parse(GP_KL10F_HeiLongJiang.Term.ToString()), GP_KL10F_HeiLongJiang.OpenTime, GP_KL10F_HeiLongJiang.ID, Array.ConvertAll<string, int>(GP_KL10F_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_KL10F_HeiLongJiang.Spare, "klsf"));
                }
                if (GP_KL10F_ShanXiXiAn != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_ShanXiXiAn.ToString(), int.Parse(GP_KL10F_ShanXiXiAn.Term.ToString()), GP_KL10F_ShanXiXiAn.OpenTime, GP_KL10F_ShanXiXiAn.ID, Array.ConvertAll<string, int>(GP_KL10F_ShanXiXiAn.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_KL10F_ShanXiXiAn.Spare, "klsf"));
                }
                if (GP_KL10F_YunNan != null)
                {
                    klsf.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL10F_YunNan.ToString(), int.Parse(GP_KL10F_YunNan.Term.ToString()), GP_KL10F_YunNan.OpenTime, GP_KL10F_YunNan.ID, Array.ConvertAll<string, int>(GP_KL10F_YunNan.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_KL10F_YunNan.Spare, "klsf"));
                }

                // 上面是快乐10分



                if (GP_SSC_ChongQing != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSC_ChongQing.ToString(), int.Parse(GP_SSC_ChongQing.Term.ToString()), GP_SSC_ChongQing.OpenTime, GP_SSC_ChongQing.ID, Array.ConvertAll<string, int>(GP_SSC_ChongQing.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_SSC_ChongQing.Spare, "ssc"));
                }
                if (GP_SSC_HeiLongJiang != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSC_HeiLongJiang.ToString(), int.Parse(GP_SSC_HeiLongJiang.Term.ToString()), GP_SSC_HeiLongJiang.OpenTime, GP_SSC_HeiLongJiang.ID, Array.ConvertAll<string, int>(GP_SSC_HeiLongJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_SSC_HeiLongJiang.Spare, "ssc"));
                }

                if (GP_SSC_TianJin != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSC_TianJin.ToString(), int.Parse(GP_SSC_TianJin.Term.ToString()), GP_SSC_TianJin.OpenTime, GP_SSC_TianJin.ID, Array.ConvertAll<string, int>(GP_SSC_TianJin.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_SSC_TianJin.Spare, "ssc"));
                }
                if (GP_SSC_XinJiang != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSC_XinJiang.ToString(), int.Parse(GP_SSC_XinJiang.Term.ToString()), GP_SSC_XinJiang.OpenTime, GP_SSC_XinJiang.ID, Array.ConvertAll<string, int>(GP_SSC_XinJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_SSC_XinJiang.Spare, "ssc"));
                }
                if (GP_SSC_YunNan != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSC_YunNan.ToString(), int.Parse(GP_SSC_YunNan.Term.ToString()), GP_SSC_YunNan.OpenTime, GP_SSC_YunNan.ID, Array.ConvertAll<string, int>(GP_SSC_YunNan.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_SSC_YunNan.Spare, "ssc"));
                }


                //上面是时时彩
                if (GP_KZC_BeiJing != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KZC_BeiJing.ToString(), int.Parse(GP_KZC_BeiJing.Term.ToString()), GP_KZC_BeiJing.OpenTime, GP_KZC_BeiJing.ID, Array.ConvertAll<string, int>(GP_KZC_BeiJing.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_KZC_BeiJing.Spare, "qt"));
                }
                if (GP_XLC_XinJiang != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_XLC_XinJiang.ToString(), int.Parse(GP_XLC_XinJiang.Term.ToString()), GP_XLC_XinJiang.OpenTime, GP_XLC_XinJiang.ID, Array.ConvertAll<string, int>(GP_XLC_XinJiang.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), GP_XLC_XinJiang.Spare, "qt"));
                }
                if (bjkl8 != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KL8_BeiJing.ToString(), int.Parse(bjkl8.Term.ToString()), bjkl8.OpenTime, bjkl8.ID, Array.ConvertAll<string, int>(bjkl8.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), bjkl8.Spare, "qt"));
                }
                if (bjpk10 != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_PK10_BeiJing.ToString(), int.Parse(bjpk10.Term.ToString()), bjpk10.OpenTime, bjpk10.ID, Array.ConvertAll<string, int>(bjpk10.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), bjpk10.Spare, "qt"));
                }

                if (shssl != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_SSL_ShangHai.ToString(), int.Parse(shssl.Term.ToString()), shssl.OpenTime, shssl.ID, Array.ConvertAll<string, int>(shssl.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), shssl.Spare, "qt"));

                }
                if (klpk3 != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KLPK3_ShanDong.ToString(), int.Parse(klpk3.Term.ToString()), klpk3.OpenTime, klpk3.ID, Array.ConvertAll<string, int>(klpk3.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), klpk3.Spare, "qt"));
                }

                if (xysc != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_XYSC_HuNan.ToString(), int.Parse(xysc.Term.ToString()), xysc.OpenTime, xysc.ID, Array.ConvertAll<string, int>(xysc.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), xysc.Spare, "qt"));
                }
                if (ytdj != null)
                {
                    qt.Add(LottryDataHandle.GetLotteryData(Models.SCCLottery.GP_KY481_HeNan.ToString(), int.Parse(ytdj.Term.ToString()), ytdj.OpenTime, ytdj.ID, Array.ConvertAll<string, int>(ytdj.GetCodeStr().Split(',').ToArray(), s => int.Parse(s)), ytdj.Spare, "qt"));
                }
                #endregion
                List<LotteryData> list = new List<LotteryData>();
                list.AddRange(qgc);
                list.AddRange(dfc);
                list.AddRange(qt);
                list.AddRange(c11x5);
                list.AddRange(k3);
                list.AddRange(klsf);
                list.AddRange(kl12);
                for (int i = 0; i < list.Count; i++)
                {
                    var lottery = Enum.Parse(typeof(SCCLottery), list[i].LotteryType);

                    if (ZSlotterType.TypeOfNameDict.Keys.Contains(list[i].LotteryType))
                    {
                        list[i].HasLotteryZS = true;
                    }
                    list[i].LotteryText = EnumHelper.GetLotteryText((SCCLottery)lottery);
                   // MlotteryData[list[i].LotteryType] = list[i];
                }
                return list;
            }
            catch (Exception ee)
            {

                LogHelper.Error(typeof(KJBLL), ee.Message + "GetLotteryList");
                return null;
            }
        }


        public static List<LotteryData> GetLotteryListAsync()
        {
            try
            {

                var typelist = LottryDataHandle.GetLotteryCode();
                List<LotteryData> qgc = new List<LotteryData>();
                List<LotteryData> dfc = new List<LotteryData>();
                List<LotteryData> list = new List<LotteryData>();
                Parallel.For(0, typelist.Count, new ParallelOptions() { MaxDegreeOfParallelism = 10 }, item => {
                    SCCLottery em = (SCCLottery)Enum.Parse(typeof(SCCLottery), typelist[item].lotteryCode);
                    var data = GetLastItem<OpenCode21Model>(em);
                    if (data == null)
                    {

                    }
                    else
                    {


                        string menuname = "";
                        if (typelist[item].lotteryCode.Contains("QG"))
                        {
                            menuname = "qgc";
                        }
                        else if (typelist[item].lotteryCode.Contains("DF"))
                        {
                            menuname = "dfc";
                        }

                        else if (typelist[item].lotteryCode.Contains("11x5"))
                        {
                            menuname = "c11x5";

                        }
                        else if (typelist[item].lotteryCode.Contains("KL10F"))
                        {
                            menuname = "klsf";
                        }
                        else if (typelist[item].lotteryCode.Contains("SSC") || typelist[item].lotteryCode.Contains("SSL"))
                        {
                            menuname = "ssc";
                        }
                        else if (typelist[item].lotteryCode.Contains("KL12"))
                        {
                            menuname = "kl12";
                        }
                        else if (em == SCCLottery.GP_KLPK3_ShanDong)
                        {
                            menuname = "qt";
                        }
                        else if (em == SCCLottery.GP_QYH_ShanDong)
                        {
                            menuname = "klsf";
                        }
                        else if (typelist[item].lotteryCode.Contains("K3"))
                        {
                            menuname = "k3";
                        }
                        else
                        {
                            menuname = "qt";
                        }
                        var ary = Array.ConvertAll<string, int>(data.GetCodeStr().Split(',').ToArray(), s => int.Parse(s));
                        var tmp = LottryDataHandle.GetLotteryData(typelist[item].lotteryCode, int.Parse(data.Term.ToString()), data.OpenTime, data.ID, ary, data.Spare, menuname, data.KaiJiHao == null ? "" : data.KaiJiHao == null ? "" : data.KaiJiHao, data.ShiJiHao);
                        list.Add(tmp);
                    }


                });
            


                for (int i = 0; i < list.Count; i++)
                {
                    var lottery = Enum.Parse(typeof(SCCLottery), list[i].LotteryType);

                    if (ZSlotterType.TypeOfNameDict.Keys.Contains(list[i].LotteryType))
                    {
                        list[i].HasLotteryZS = true;
                    }
                    list[i].LotteryText = EnumHelper.GetLotteryText((SCCLottery)lottery);
                    // MlotteryData[list[i].LotteryType] = list[i];
                }
                return list;
            }
            catch (Exception ee)
            {

                LogHelper.Error(typeof(KJBLL), ee.Message + "GetLotteryListAsync");
                return null;
            }
        }
      
        /// <summary>
        /// 查指定类别的数据并且加入缓存(任务调用)
        /// </summary>
        /// <param name="TypeList"></param>
        /// <param name="menuname"></param>
        /// <returns></returns>

      
        /// <summary>
        /// 查指定天数开奖信息包含倒计时和中奖规则链接
        /// </summary>
        /// <returns></returns>
        /// 
        public static List<LotteryData> GetLotteryList(string lotterytype,int day)
        {
            List<LotteryData> result = new List<LotteryData>();

            var lottery = (SCCLottery)Enum.Parse(typeof(SCCLottery), lotterytype);
            var data = services.GetLastItems<OpenCode21Model>(lottery, day);
            if (data==null)
            {
                return new List<LotteryData>();
            }
            for (int i = 0; i < data.Count; i++)
            {
                var ary = Array.ConvertAll<string, int>(data[i].GetCodeStr().Split(',').ToArray(), s => int.Parse(s));
               var tmp= LottryDataHandle.GetLotteryData(lotterytype, int.Parse(data[i].Term.ToString()), data[i].OpenTime, data[i].ID, ary, data[i].Spare, "",data[i].KaiJiHao==null?"":data[i].KaiJiHao==null?"": data[i].KaiJiHao, data[i].ShiJiHao);
                result.Add(tmp);
            }
            return result;
        }
        public static List<LotteryData> GetTopNumList(string lottery, string order, int count = 1, Boolean isdesc = true)
        {
            List<LotteryData> result = new List<LotteryData>();
            var lotterytype = (SCCLottery)Enum.Parse(typeof(SCCLottery), lottery);
            var data= services.GetTopNumList<OpenCode21Model>(lotterytype, order, count, isdesc);
            if (data==null)
            {
                return new List<LotteryData>();
            }
            for (int i = 0; i < data.Count; i++)
            {
                var ary = Array.ConvertAll<string, int>(data[i].GetCodeStr().Split(',').ToArray(), s => int.Parse(s));
                var tmp = LottryDataHandle.GetLotteryData(lottery, int.Parse(data[i].Term.ToString()), data[i].OpenTime, data[i].ID, ary, data[i].Spare, "", data[i].KaiJiHao == null ? "" : data[i].KaiJiHao == null ? "" : data[i].KaiJiHao, data[i].ShiJiHao);
                result.Add(tmp);
            }
            return result;

        }
        public static List<LotteryData> GetLotteryList(string lotterytype, Dictionary<string, Object> queryParam)
        {
            try
            {


                var ltype = (SCCLottery)Enum.Parse(typeof(SCCLottery), lotterytype);
                var TableName = EnumHelper.GetSCCLotteryTableName(ltype);
                List<LotteryData> result = new List<LotteryData>();
                List<EExpression> listexp = new List<EExpression>();
                if (queryParam.Keys.Count > 0)
                {
                    if (queryParam.ContainsKey("Num"))
                    {

                        string Num = queryParam["Num"].ToString();
                        listexp.Add(new EExpression("Term", "=", int.Parse(Num)));
                    }
                    if (queryParam.ContainsKey("MinYear"))
                    {

                        string Year = queryParam["MinYear"].ToString();
                        int intyear = 1;
                        int.TryParse(Year, out intyear);
                        if (intyear < 1)
                        {
                            intyear = DateTime.Now.Year;
                        }
                        DateTime time = new DateTime(intyear, 1, 1, 0, 0, 0);
                        listexp.Add(new EExpression("OpenTime", ">", time.ToString()));
                    }
                    if (queryParam.ContainsKey("MaxYear"))
                    {

                        string Year = queryParam["MaxYear"].ToString();
                        int intyear = 1;
                        int.TryParse(Year, out intyear);
                        if (intyear < 1)
                        {
                            intyear = DateTime.Now.Year;
                        }
                        DateTime time = new DateTime(intyear, 1, 1, 0, 0, 0);
                        listexp.Add(new EExpression("OpenTime", "<", time.ToString()));
                    }
                    if (queryParam.ContainsKey("MaxDate"))
                    {

                        string date = queryParam["MaxDate"].ToString();
                        DateTime time = DateTime.Now;
                        DateTime.TryParse(date, out time);
                        listexp.Add(new EExpression("OpenTime", "<", time.ToString()));
                    }
                    if (queryParam.ContainsKey("MinDate"))
                    {

                        string date = queryParam["MinDate"].ToString();
                        DateTime time = DateTime.Now;
                        DateTime.TryParse(date, out time);
                        listexp.Add(new EExpression("OpenTime", ">", time.ToString()));
                    }
                    if (queryParam.ContainsKey("MinTerm"))
                    {
                        int minterm = int.Parse(queryParam["MinTerm"].ToString());
                        listexp.Add(new EExpression("Term", ">=", minterm));
                    }
                    if (queryParam.ContainsKey("MaxTerm"))
                    {
                        int minterm = int.Parse(queryParam["MaxTerm"].ToString());
                        listexp.Add(new EExpression("Term", "<=", minterm));
                    }
                    if (queryParam.ContainsKey("InTerm"))
                    {
                        var inkeylist = queryParam["InTerm"] as List<string>;
                        listexp.Add(new EExpression("Term", EnumExpression.In, inkeylist));
                    }

                }
                var data = services.GetList<OpenCode21Model>(TableName, listexp, "Term", true);
                if (data == null)
                {
                    return new List<LotteryData>();
                }
                for (int i = 0; i < data.Count; i++)
                {
                    var ary = Array.ConvertAll<string, int>(data[i].GetCodeStr().Split(',').ToArray(), s => int.Parse(s));
                    var tmp = LottryDataHandle.GetLotteryData(lotterytype, int.Parse(data[i].Term.ToString()), data[i].OpenTime, data[i].ID, ary, data[i].Spare, "", data[i].KaiJiHao == null ? "" : data[i].KaiJiHao == null ? "" : data[i].KaiJiHao, data[i].ShiJiHao);
                    result.Add(tmp);
                }
                return result;
            }
            catch (Exception ee)
            {
                LogHelper.Error(typeof(KJBLL), "GetLotteryList");
                return null;
            }
        }

        public static LotteryData GetLotteryData(string Typename, int Term, DateTime Opentime, string ID, IList<int> OpenCode, string Detail, string MenuName = "", string KaiJiHao = "", string ShiJiHao = "")
        {
            return LottryDataHandle.GetLotteryData(Typename, Term, Opentime, ID, OpenCode, Detail, MenuName, KaiJiHao, ShiJiHao);
        }


        /// <summary>
        /// 拦截器日志
        /// </summary>
        /// <param name="url"></param>
        /// <param name="ip"></param>
        public static void AddActionFilterLog(string url, string ip)
        {
            var sql = @"
INSERT INTO VisitIP(IP,Url,Time)
VALUES (@IP,@Url,@Time)
";
            var para = new SqlParameter[] {
                new SqlParameter(@"IP",ip),
                new SqlParameter(@"Url",url),
                new SqlParameter(@"Time",DateTime.Now),
            };
            services.CBAdd(sql, para);
        }


        public static List<string> GetProhibitIP()
        {
            var sql = @"
SELECT Id,IP FROM ProhibitIP
";
            return services.FindeList<ProhibitIPEntity>(sql).Select(p=>p.IP).ToList();
        }





    }
}