using CP.Cache;
using CP.Common;
using CP.Model;
using MC.ORM;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CP.Business
{
    public class Fcbjkl8 : BaseBll
    {
        /// <summary>
        /// 缓存
        /// </summar>y
        static WMCache cache = WMCache.GetCacheService();

        /// <summary>
        /// 取出个排名的上一次数据
        /// </summary>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastFcbjkl8Info(ref List<Fcbjkl8Info> list, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (list[i].rank == rank - 1)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 取出个排名的下一次数据， 用于开奖公告
        /// </summary>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetNextFcbjkl8Info(ref List<Fcbjkl8Info> list, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 1; i < list.Count; i++)
                {
                    if (list[i].rank == rank + 1)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        #region 上一次出现时的情况
        /// <summary>
        /// 上次某个号码出现时的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastFcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                int size = list.Count;
                for (int i = rank - 2; i >= 0; i--)
                {
                    List<int> kjh = new List<int> {
                        list[i].n1, list[i].n2, list[i].n3, list[i].n4, list[i].n5, list[i].n6, list[i].n7,
                        list[i].n8, list[i].n9, list[i].n10, list[i].n11, list[i].n12, list[i].n13, list[i].n14,
                        list[i].n15, list[i].n16, list[i].n17, list[i].n18, list[i].n19, list[i].n20
                    };
                    if (kjh.Contains(val))
                    {
                        info = list[i];
                        return info;
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次和值val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHzFcbjkl8Info(ref List<Fcbjkl8Info> list, int shz, int ehz, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (list[i].hz >= shz && list[i].hz <= ehz)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一次和值奇偶形态的数据
        /// </summary>
        /// <param name="xt"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHzJoFcbjkl8Info(ref List<Fcbjkl8Info> list, int xt, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (xt == 0)
                    {
                        if (list[i].hz % 2 != 0)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                    if (xt == 1)
                    {
                        if (list[i].hz % 2 == 0)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一其和尾val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHwFcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (ZstUtils.GetHw(list[i].hz) == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一次跨度val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastkdFcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (list[i].kd == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一次跨度奇偶的情况
        /// </summary>
        /// <param name="xt"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastKdJoFcbjkl8Info(ref List<Fcbjkl8Info> list, int xt, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (xt == 0)
                    {
                        if (list[i].kd % 2 != 0)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                    if (xt == 1)
                    {
                        if (list[i].kd % 2 == 0)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上次跨度大小的情况
        /// </summary>
        /// <param name="xt"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastKdDxFcbjkl8Info(ref List<Fcbjkl8Info> list, int xt, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (xt == 0)
                    {
                        if (list[i].kd > 0)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                    if (xt == 1)
                    {
                        if (list[i].kd < 21)
                        {
                            info = list[i];
                            return info;
                        }
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上次跨度质合的情况
        /// </summary>
        /// <param name="xt"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastKdZhFcbjkl8Info(ref List<Fcbjkl8Info> list, int xt, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            List<int> zh = new List<int> { 6, 8, 9, 10, 12, 14, 15, 16, 18, 20, 21, 22, 24, 25, 26, 27, 28, 30, 32, 33, 34, 35, 36 };
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (xt == 0)
                    {
                        if (!zh.Contains(list[i].kd))
                        {
                            info = list[i];
                            return info;
                        }
                    }
                    if (xt == 1)
                    {
                        if (zh.Contains(list[i].kd))
                        {
                            info = list[i];
                            return info;
                        }
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一次和尾大小的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHwDxFcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (ZstUtils.GetDx(ZstUtils.GetHw(list[i].hz)) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次和尾奇偶的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHwJoFcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (ZstUtils.GetJo(ZstUtils.GetHw(list[i].hz)) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次和尾012路的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastHw012Fcbjkl8Info(ref List<Fcbjkl8Info> list, int val, int rank)
        {
            Fcbjkl8Info info = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (ZstUtils.Get012(ZstUtils.GetHw(list[i].hz)) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次质合比val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastZhbFcbjkl8Info(ref List<Fcbjkl8Info> list, int szh, int ezh, int rank)
        {
            Fcbjkl8Info data = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    var info = list[i];
                    List<int> kjh = new List<int> { info.n1, info.n2, info.n3, info.n4, info.n5, info.n6,info.n7,info.n8,
                        info.n9,info.n10,info.n11,info.n12,info.n13,info.n14,info.n15,info.n16,info.n17,info.n18,
                        info.n19,info.n20
                    };
                    var zhb = ZstUtils.GetZhb(kjh);
                    if (zhb == $"{szh}:{ezh}")
                    {
                        data = list[i];
                        return data;
                    }
                }
            }
            return data;
        }

        /// <summary>
        /// 上一次奇偶比val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastJobFcbjkl8Info(ref List<Fcbjkl8Info> list, int sjo, int ejo, int rank)
        {
            Fcbjkl8Info data = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    var info = list[i];
                    List<int> kjh = new List<int> { info.n1, info.n2, info.n3, info.n4, info.n5, info.n6,info.n7,info.n8,
                        info.n9,info.n10,info.n11,info.n12,info.n13,info.n14,info.n15,info.n16,info.n17,info.n18,
                        info.n19,info.n20
                    };
                    var job = ZstUtils.GetJob(kjh);
                    if (job == $"{sjo}:{ejo}")
                    {
                        data = list[i];
                        return data;
                    }
                }
            }
            return data;
        }

        /// <summary>
        /// 上一次大小比val的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static Fcbjkl8Info GetLastDxbFcbjkl8Info(ref List<Fcbjkl8Info> list, int sdx, int edx, int rank)
        {
            Fcbjkl8Info data = new Fcbjkl8Info();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    var info = list[i];
                    List<int> kjh = new List<int> { info.n1, info.n2, info.n3, info.n4, info.n5, info.n6,info.n7,info.n8,
                        info.n9,info.n10,info.n11,info.n12,info.n13,info.n14,info.n15,info.n16,info.n17,info.n18,
                        info.n19,info.n20
                    };
                    var job = ZstUtils.GetDxb(kjh, 41);
                    if (job == $"{sdx}:{edx}")
                    {
                        data = list[i];
                        return data;
                    }
                }
            }
            return data;
        }

        #endregion

        /// <summary>
        /// 按条件筛选的36x7数据
        /// </summary>
        /// <param name="pagesize"></param>
        /// <param name="year"></param>
        /// <param name="sqi"></param>
        /// <param name="eqi"></param>
        /// <param name="week"></param>
        /// <returns></returns>
        public static List<Fcbjkl8Info> GetFcbjkl8List(ref List<Fcbjkl8Info> datalist, int pagesize, string day)
        {
            List<Fcbjkl8Info> list = datalist;
            List<Fcbjkl8Info> rlist = new List<Fcbjkl8Info>();
            if (list != null && list.Count > 0)
            {
                int size = list.Count;
                if (pagesize > 0)
                {
                    for (int i = (size - pagesize); i < size; i++)
                    {
                        rlist.Add(list[i]);
                    }
                    return rlist;
                }
                if (!string.IsNullOrWhiteSpace(day))
                {
                    rlist.Clear();
                    var stime = TypeConverter.ObjectToDateTime(day);
                    var etime = stime.AddDays(1);
                    rlist = datalist.Where(n => n.date > stime && n.date < etime).ToList();
                    return rlist;
                }
            }
            return rlist;
        }

        /// <summary>
        /// 获取最近多少天数据
        /// </summary>
        /// <param name="ename"></param>
        /// <param name="pagesize"></param>
        /// <param name="n"></param>
        /// <returns></returns>
        public static List<Fcbjkl8Info> GetList(string ename, int pagesize, int n = 30)
        {
            string key = $"DATA-{ename}-{pagesize * n}";
            List<Fcbjkl8Info> list = cache.GetObject<List<Fcbjkl8Info>>(key);
            if (list == null)
            {
                #region 获取数据

                list = GetList(pagesize * n);

                #endregion
                cache.AddObject(key, list, (int)CacheTime.Mintime);
            }
            return list;
        }

        /// <summary>
        /// 最近N期的数据列表
        /// </summary>
        /// <returns></returns>
        public static List<Fcbjkl8Info> GetList(int limit = 2000)
        {
            string sql = $"order by qi desc limit {limit}";
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                var list = db.Fetch<Fcbjkl8Info>(sql).OrderBy(n => n.qi).ToList();
                var outlist = new List<Fcbjkl8Info>();
                if (list != null && list.Count > 0)
                {
                    var size = list.Count;
                    for (int i = 0; i < size; i++)
                    {
                        Fcbjkl8Info info = list[i];
                        info.rank = i + 1;
                        outlist.Add(info);
                    }
                }
                return outlist;
            }
        }


        /// <summary>
        /// 获取指定时间内的数据
        /// </summary>
        /// <param name="ename"></param>
        /// <param name="sqi"></param>
        /// <param name="eqi"></param>
        /// <returns></returns>
        public static List<Fcbjkl8Info> GetDayKjList(string ename, DateTime sqi, DateTime eqi)
        {
            string key = $"DATA-{ename}-{sqi}-{eqi}";
            List<Fcbjkl8Info> list = cache.GetObject<List<Fcbjkl8Info>>(key);
            if (list == null)
            {
                #region 获取数据
                list = GetOneDayKjList(sqi, eqi);
                #endregion
                cache.AddObject(key, list, (int)CacheTime.Expert);
            }
            return list;
        }

        /// <summary>
        /// 某一天的
        /// </summary>
        /// <param name="sqi"></param>
        /// <param name="eqi"></param>
        /// <returns></returns>
        public static List<Fcbjkl8Info> GetOneDayKjList(DateTime sqi, DateTime eqi)
        {
            string sql = string.Format("where date BETWEEN '{0}' AND '{1}'", sqi, eqi);
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                var list = db.Fetch<Fcbjkl8Info>(sql);
                var outlist = new List<Fcbjkl8Info>();
                if (list != null && list.Count > 0)
                {
                    var size = list.Count;
                    for (int i = 0; i < size; i++)
                    {
                        Fcbjkl8Info info = list[i];
                        info.rank = i + 1;
                        outlist.Add(info);
                    }
                }
                return outlist;
            }
        }
    }
}