kjh.api.55128.cn_old/CP.Business/gp/other/Fcsdqyh.cs

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 Fcsdqyh : BaseBll
    {
        /// <summary>
        /// 缓存
        /// </summar>y
        static WMCache cache = WMCache.GetCacheService();

        /// <summary>
        /// 某号码上一次出现时的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastNumFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            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 };
                    if (kjh.Contains(val))
                    {
                        info = list[i];
                        return info;
                    }
                }
            }

            return info;
        }

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

        /// <summary>
        /// 上一次和尾的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastHwFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            if (list != null && list.Count > 0)
            {
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (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 FcsdqyhInfo GetLastNumWeFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            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 };
                    if (kjh.Contains(val))
                    {
                        info = list[i];
                        return info;
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 某围三号码上一次出现时的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastNumWsFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            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 };
                    if (kjh.Contains(val))
                    {
                        info = list[i];
                        return info;
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 某围四号码上一次出现时的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastNumWsiFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            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 };
                    if (kjh.Contains(val))
                    {
                        info = list[i];
                        return info;
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 根据当前出号和排名，查询出上一次出此号时的数据
        /// 主要用在算遗漏时
        /// </summary>
        /// <param name="val">值</param>
        /// <param name="rank">当前排名</param>
        /// <param name="dnw"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank, int dnw)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();

            int size = list.Count;

            ///升序的情况
            ///未实现走势图倒序的情况..
            for (int i = rank - 2; i >= 0; i--)
            {
                if (dnw == 1)
                {
                    if (list[i].n1 == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
                if (dnw == 2)
                {
                    if (list[i].n2 == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
                if (dnw == 3)
                {
                    if (list[i].n3 == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
                if (dnw == 4)
                {
                    if (list[i].n4 == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
                if (dnw == 5)
                {
                    if (list[i].n5 == val)
                    {
                        info = list[i];
                        return info;
                    }
                }
            }
            return info;
        }

        /// <summary>
        /// 上一次大小的数据
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastDxFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank, int dnw)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            if (list != null && list.Count > 0)
            {
                var hm = 0;
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (dnw == 1)
                        hm = info.n1;
                    else if (dnw == 2)
                        hm = info.n2;
                    else if (dnw == 3)
                        hm = info.n3;
                    else if (dnw == 4)
                        hm = info.n4;
                    else if (dnw == 5)
                        hm = info.n5;
                    if (ZstUtils.GetDxBymiddle(hm, 12) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次奇偶的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastJoFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank, int dnw)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            if (list != null && list.Count > 0)
            {
                var hm = 0;
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (dnw == 1)
                        hm = info.n1;
                    else if (dnw == 2)
                        hm = info.n2;
                    else if (dnw == 3)
                        hm = info.n3;
                    else if (dnw == 4)
                        hm = info.n4;
                    else if (dnw == 5)
                        hm = info.n5;
                    if (ZstUtils.GetJo(hm) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次质合的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLastZhFcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank, int dnw)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            if (list != null && list.Count > 0)
            {
                var hm = 0;
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (dnw == 1)
                        hm = info.n1;
                    else if (dnw == 2)
                        hm = info.n2;
                    else if (dnw == 3)
                        hm = info.n3;
                    else if (dnw == 4)
                        hm = info.n4;
                    else if (dnw == 5)
                        hm = info.n5;
                    if (ZstUtils.GetZh(hm) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 上一次012路的情况
        /// </summary>
        /// <param name="val"></param>
        /// <param name="rank"></param>
        /// <returns></returns>
        public static FcsdqyhInfo GetLast012FcsdqyhInfo(ref List<FcsdqyhInfo> list, int val, int rank, int dnw)
        {
            FcsdqyhInfo info = new FcsdqyhInfo();
            if (list != null && list.Count > 0)
            {
                var hm = 0;
                for (int i = rank - 2; i >= 0; i--)
                {
                    if (dnw == 1)
                        hm = info.n1;
                    else if (dnw == 2)
                        hm = info.n2;
                    else if (dnw == 3)
                        hm = info.n3;
                    else if (dnw == 4)
                        hm = info.n4;
                    else if (dnw == 5)
                        hm = info.n5;
                    if (ZstUtils.Get012(hm) == val)
                    {
                        return list[i];
                    }
                }
            }

            return info;
        }

        /// <summary>
        /// 按条件筛选数据
        /// </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<FcsdqyhInfo> GetFcsdqyhList(ref List<FcsdqyhInfo> datalist, int pagesize, string day)
        {
            List<FcsdqyhInfo> list = datalist;
            List<FcsdqyhInfo> rlist = new List<FcsdqyhInfo>();
            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<FcsdqyhInfo> GetList(string ename, int pagesize, int n = 30)
        {
            string key = $"DATA-{ename}-{pagesize * n}";
            List<FcsdqyhInfo> list = cache.GetObject<List<FcsdqyhInfo>>(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<FcsdqyhInfo> GetList(int limit = 2000)
        {
            string sql = $"order by qi desc limit {limit}";
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                var list = db.Fetch<FcsdqyhInfo>(sql).OrderBy(n => n.qi).ToList();
                var outlist = new List<FcsdqyhInfo>();
                if (list != null && list.Count > 0)
                {
                    var size = list.Count;
                    for (int i = 0; i < size; i++)
                    {
                        FcsdqyhInfo 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<FcsdqyhInfo> GetDayKjList(string ename, DateTime sqi, DateTime eqi)
        {
            string key = $"DATA-{ename}-{sqi}-{eqi}";
            List<FcsdqyhInfo> list = cache.GetObject<List<FcsdqyhInfo>>(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<FcsdqyhInfo> 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<FcsdqyhInfo>(sql);
                var outlist = new List<FcsdqyhInfo>();
                if (list != null && list.Count > 0)
                {
                    var size = list.Count;
                    for (int i = 0; i < size; i++)
                    {
                        FcsdqyhInfo info = list[i];
                        info.rank = i + 1;
                        outlist.Add(info);
                    }
                }
                return outlist;
            }
        }

    }
}