kjh.api.55128.cn_old/CP.Model/df/Fcah25x5.cs

using CP.Common;
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.Model
{
    /// <summary>
    /// 安徽25选5
    /// </summary>
    [TableName("fcah25x5"), PrimaryKey("id")]
    public class Fcah25x5
    {
        /// <summary>
        /// 开奖信息自动编号
        /// </summary>
        public int id { get; set; }

        /// <summary>
        /// 期数
        /// </summary>
        public int qi { get; set; }

        /// <summary>
        /// 开奖号第1位
        /// </summary>
        public int n1 { get; set; }

        /// <summary>
        /// 开奖号第2位
        /// </summary>
        public int n2 { get; set; }

        /// <summary>
        /// 开奖号第3位
        /// </summary>
        public int n3 { get; set; }

        /// <summary>
        /// 开奖号第4位
        /// </summary>
        public int n4 { get; set; }

        /// <summary>
        /// 开奖号第5位
        /// </summary>
        public int n5 { get; set; }

        /// <summary>
        /// 和值
        /// </summary>
        public int hz { get; set; }

        /// <summary>
        /// 跨度
        /// </summary>
        public int kd { get; set; }

        /// <summary>
        /// AC值 
        /// </summary>
        public int ac { get; set; }

        /// <summary>
        /// 星期 
        /// </summary>
        public int week { get; set; }

        /// <summary>
        /// 开奖日期
        /// </summary>
        public DateTime date { get; set; }

        /// <summary>
        /// 在列表中的排名..
        /// 用于遗漏计算.
        /// </summary>
        [Ignore]
        public int rank { get; set; }

        /// <summary>
        /// 一等奖注数
        /// </summary>
        public string zj1 { get; set; }

        /// <summary>
        /// 一等奖金额
        /// </summary>
        public string jo1 { get; set; }

        /// <summary>
        /// 二等奖注数
        /// </summary>
        public string zj2 { get; set; }

        /// <summary>
        /// 二等奖金额
        /// </summary>
        public string jo2 { get; set; }

        /// <summary>
        /// 三等奖注数
        /// </summary>
        public string zj3 { get; set; }

        /// <summary>
        /// 三等奖金额
        /// </summary>
        public string jo3 { get; set; }

        /// <summary>
        /// 开奖详情json
        /// </summary>
        public string winbonus { set; get; }

        /// <summary>
        /// 添加开奖日期
        /// </summary>
        public DateTime addtime { get; set; }

        /// <summary>
        /// 投注金额
        /// </summary>
        public string tzmoney { get; set; }

        /// <summary>
        /// 奖池
        /// </summary>
        public string nextmoney { get; set; }

        /// <summary>
        ///是否复查 
        /// </summary>
        public int ischeck { get; set; }

        /// <summary>
        /// 号码
        /// </summary>
        public string opencode { get; set; }
    }


    #region 安徽25选5基本模型 
    [TableName("fcah25x5"), PrimaryKey("id")]
    public class Fcah25x5Info
    {
        /// <summary>
        /// 期数
        /// </summary>
        public int qi { get; set; }

        /// <summary>
        /// 开奖号第1位
        /// </summary>
        public int n1 { get; set; }

        /// <summary>
        /// 开奖号第2位
        /// </summary>
        public int n2 { get; set; }

        /// <summary>
        /// 开奖号第3位
        /// </summary>
        public int n3 { get; set; }

        /// <summary>
        /// 开奖号第4位
        /// </summary>
        public int n4 { get; set; }

        /// <summary>
        /// 开奖号第5位
        /// </summary>
        public int n5 { get; set; }

        /// <summary>
        /// 和值
        /// </summary>
        public int hz { get; set; }

        /// <summary>
        /// 跨度
        /// </summary>
        public int kd { get; set; }

        /// <summary>
        /// AC值 
        /// </summary>
        public int ac { get; set; }

        /// <summary>
        /// 星期 
        /// </summary>
        public int week { get; set; }

        /// <summary>
        /// 开奖日期
        /// </summary>
        public DateTime date { get; set; }

        /// <summary>
        /// 在列表中的排名..
        /// 用于遗漏计算.
        /// </summary>
        [Ignore]
        public int rank { get; set; }
    }
    #endregion

    #region 安徽25选5开奖信息完整模型
    /// <summary>
    /// 福彩湖北22选5开奖信息完整模型
    /// </summary>
    [TableName("fchb22x5"), PrimaryKey("id")]
    public class Fcah25x5LongInfo : Fcah25x5Info
    {
        /// <summary>
        /// 开奖信息自动编号
        /// </summary>
        public int id { get; set; }
        /// <summary>
        /// 一等奖注数
        /// </summary>
        public string zj1 { get; set; }

        /// <summary>
        /// 一等奖金额
        /// </summary>
        public string jo1 { get; set; }

        /// <summary>
        /// 二等奖注数
        /// </summary>
        public string zj2 { get; set; }

        /// <summary>
        /// 二等奖金额
        /// </summary>
        public string jo2 { get; set; }

        /// <summary>
        /// 三等奖注数
        /// </summary>
        public string zj3 { get; set; }

        /// <summary>
        /// 三等奖金额
        /// </summary>
        public string jo3 { get; set; }

        /// <summary>
        /// 开奖详情json
        /// </summary>
        public string winbonus { set; get; }

        /// <summary>
        /// 添加开奖日期
        /// </summary>
        public DateTime addtime { get; set; }

        /// <summary>
        /// 投注金额
        /// </summary>
        public string tzmoney { get; set; }

        /// <summary>
        /// 奖池
        /// </summary>
        public string nextmoney { get; set; }

        /// <summary>
        ///是否复查 
        /// </summary>
        public int ischeck { get; set; }

        /// <summary>
        /// 号码
        /// </summary>
        public string opencode { get; set; }

    }
    #endregion

    #region 走势图上的遗漏模型

    /// <summary>
    /// 22x5出号走势图上的遗漏模型
    /// </summary>
    public class ah25x5ChzsMissInfo
    {
        public string name { get; set; }

        /// <summary>
        /// 出号
        /// </summary>
        public int[] ch { get; set; }

    }

    /// <summary>
    /// 和值走势图上的遗漏
    /// </summary>
    public class ah25x5hzMissInfo
    {
        public string name { get; set; }

        public int[] hz { get; set; }

        public int[] hzjo { get; set; }

        public int[] hw { get; set; }

        public int[] hwdx { get; set; }

        public int[] hwjo { get; set; }

    }

    /// <summary>
    /// 22x5AC值走势图遗漏模型
    /// </summary>
    public class ah25x5AcMissInfo
    {
        public string name { get; set; }

        public int[] ac { get; set; }

        public int[] dx { get; set; }

        public int[] jo { get; set; }

        public int[] zh { get; set; }

        public int[] _012 { get; set; }

        public int[] zf { get; set; }
    }


    /// <summary>
    /// 22x5 跨度走势图遗漏模型
    /// </summary>
    public class ah25x5KdMissInfo
    {
        public string name { get; set; }

        public int[] kd { get; set; }

        public int[] dx { get; set; }

        public int[] jo { get; set; }

        public int[] zh { get; set; }

        public int[] _012 { get; set; }

    }

    /// <summary>
    /// 012路走势图上的遗漏模型
    /// </summary>
    public class ah25x5012MissInfo
    {
        /// <summary>
        /// 名称
        /// </summary>
        public string name { get; set; }

        /// <summary>
        /// 号码1形态
        /// </summary>
        public int[] w1 { get; set; }

        /// <summary>
        /// 号码2形态
        /// </summary>
        public int[] w2 { get; set; }

        public int[] w3 { get; set; }

        public int[] w4 { get; set; }

        public int[] w5 { get; set; }

        /// <summary>
        /// 大个数走势
        /// </summary>
        public int[] xt1 { get; set; }

        /// <summary>
        /// 小个数
        /// </summary>
        public int[] xt2 { get; set; }

        /// <summary>
        /// 3个数
        /// </summary>
        public int[] xt3 { get; set; }
    }

    /// <summary>
    /// 大小走势图上的遗漏模型
    /// </summary>
    public class ah25x5DxMissInfo
    {
        /// <summary>
        /// 名称
        /// </summary>
        public string name { get; set; }

        /// <summary>
        /// 号码1形态
        /// </summary>
        public int[] w1 { get; set; }

        /// <summary>
        /// 号码2形态
        /// </summary>
        public int[] w2 { get; set; }

        public int[] w3 { get; set; }

        public int[] w4 { get; set; }

        public int[] w5 { get; set; }

        /// <summary>
        /// 比值走势
        /// </summary>
        public int[] bz { get; set; }

        /// <summary>
        /// 大个数走势
        /// </summary>
        public int[] xt1 { get; set; }

        /// <summary>
        /// 小个数
        /// </summary>
        public int[] xt2 { get; set; }
    }
    #endregion

    /// <summary>
    /// 安徽25选5
    /// </summary>
    public class Fcah25x5Data : DataConnect
    {
        /// <summary>
        /// 根据期数获取某期开奖信息
        /// </summary>
        /// <param name="qi"></param>
        /// <returns></returns>
        public static Fcah25x5 GetQi(int qi)
        {
            string sql = string.Empty;
            if (qi == 0)
                sql = string.Format("order by qi desc limit 1");
            else
                sql = string.Format("where qi={0} limit 1", qi);
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                Fcah25x5 info = db.SingleOrDefault<Fcah25x5>(sql);
                return info;
            }
        }
        /// <summary>
        /// 最新30期完整开奖数据
        /// </summary>
        /// <returns></returns>
        public static List<Fcah25x5> GetList(int n = 30, bool isall = false)
        {
            string sql = $"where n1 > -1 order by qi desc limit {n}";
            if (isall)
            {
                sql = $"where n1 > -1 order by qi desc";
            }
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                return db.Fetch<Fcah25x5>(sql);
            }
        }

        #region 开奖号抓取相关数据层方法

        private static readonly object _lock = new object();

        public static void Add(Fcah25x5 info)
        {
            if (info == null)
                return;
            if (info.qi <= 0)
                return;
            info.opencode = $"{info.n1:00},{info.n2:00},{info.n3:00},{info.n4:00},{info.n5:00}";
            //和值
            info.hz = info.n1 + info.n2 + info.n3 + info.n4 + info.n5 ;
            //星期
            info.week = Utils.GetIntWeek(info.date.DayOfWeek.ToString());

            //AC值
            string[] kjhstr = { info.n1.ToString(), info.n2.ToString(), info.n3.ToString(), info.n4.ToString(), info.n5.ToString()};
            info.ac = ToolUtils.GetAC(kjhstr);
            info.kd = info.n5 - info.n1;

            lock (_lock)
            {
                using (Database db = new Database(mysql, MySqlClientFactory.Instance))
                {
                    if (db.Exists<Fcah25x5>($"where qi={info.qi}"))
                        return;
                    db.Insert(info);
                    try
                    {
                        //更新api
                        DoHttpHelp.UpdateWebApi(DFEnum.fcah25x5.ToString());
                    }
                    catch (Exception) { }
                }
            }
        }

        public static void Update(Fcah25x5 model)
        {
            if (model == null)
                return;
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                var entity = db.SingleOrDefault<Fcah25x5>(model.id);
                db.Update(entity);
            }
        }

        public static Fcah25x5 GetLastOne()
        {
            using (Database db = new Database(mysql, MySqlClientFactory.Instance))
            {
                var entity = db.SingleOrDefault<Fcah25x5>($"order by qi desc limit 1");
                return entity;
            }
        }

        #endregion


        /// <summary>
        /// 所有的湖北22选5的数据
        /// </summary>
        /// <returns></returns>
        public static List<Fcah25x5Info> GetFcah25x5List()
        {
            List<Fcah25x5Info> list = new List<Fcah25x5Info>();
            string sql = string.Format("order by qi asc");
            DataConnect dc = new DataConnect();
            list = dc.db.Fetch<Fcah25x5Info>(sql);
            if (list != null && list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    list[i].rank = i + 1;
                }
            }
            return list;
        }

        #region 开奖公告相关方法
        /// <summary>
        /// 获取最新开奖信息
        /// </summary>
        /// <returns></returns>
        public static Fcah25x5LongInfo GetFchb22X5NewInfo()
        {
            string sql = string.Format("where n1>-1 order by qi desc limit 1 ");
            DataConnect dc = new DataConnect();
            return dc.db.SingleOrDefault<Fcah25x5LongInfo>(sql);
        }
        /// <summary>
        /// 获取最新30条开奖信息
        /// </summary>
        /// <returns></returns>
        public static List<Fcah25x5LongInfo> GetFcah25x5Top30()
        {
            string sql = string.Format("order by qi desc limit 30");
            DataConnect dc = new DataConnect();
            return dc.db.Fetch<Fcah25x5LongInfo>(sql);
        }

        #region 根据期数获取某期开奖信息
        /// <summary>
        /// 根据期数获取某期开奖信息
        /// </summary>
        /// <param name="qi"></param>
        /// <returns></returns>
        public static Fcah25x5LongInfo GetFcah25x5InfoByQi(int qi)
        {
            string sql = string.Empty;
            if (qi == 0)
                sql = string.Format("order by qi desc limit 1");
            else
                sql = string.Format("where qi={0} limit 1", qi);

            DataConnect dc = new DataConnect();
            Fcah25x5LongInfo info = dc.db.SingleOrDefault<Fcah25x5LongInfo>(sql);

            return info;
        }
        #endregion

        #region 根据年份取出当年所有期数
        /// <summary>
        /// 根据年份取出当年所有期数
        /// </summary>
        /// <param name="year"></param>
        /// <returns></returns>
        public static List<int> GetFcah25x5QiListByYear(int year)
        {
            List<int> rlist = new List<int>();
            string sql = string.Format("where qi like '{0}%' order by qi desc", year);
            DataConnect dc = new DataConnect();
            var list = dc.db.Fetch<Fcah25x5Info>(sql);
            if (list != null && list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    rlist.Add(list[i].qi);
                }
            }
            return rlist;
        }
        #endregion


        #endregion
    }
}