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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CP.Common;
using MC.ORM;
using MySql.Data.MySqlClient;

namespace CP.Model
{

    #region 遗漏模型

    /// <summary>
    /// 好彩1季节走势图遗漏模型
    /// </summary>
    public class Hc1SxMissInfo
    {

        /// <summary>
        /// 名称
        /// </summary>
        public string name { get; set; }

        /// <summary>
        /// 生肖
        /// </summary>
        public int[] sx { get; set; }

        /// <summary>
        /// 季节
        /// </summary>
        public int[] jj { get; set; }

        /// <summary>
        /// 方位
        /// </summary>
        public int[] fw { get; set; }

        /// <summary>
        /// 大小
        /// </summary>
        public int[] dx { get; set; }

        /// <summary>
        /// 奇偶
        /// </summary>
        public int[] jo { get; set; }

        /// <summary>
        /// 质合
        /// </summary>
        public int[] zh { get; set; }

    }

    /// <summary>
    /// 好彩1出号走势图遗漏模型
    /// </summary>
    public class Hc1ChzsMissInfo
    {

        /// <summary>
        /// 名称
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 号码
        /// </summary>
        public int[] fb { get; set; }
    }

    #endregion

    #region 广东好彩1基本模型
    /// <summary>
    /// 广东好彩1模型
    /// </summary>
    [TableName("gdhc1"), PrimaryKey("id")]
    public class Dfgdhc1Info
    {
        /// <summary>
        /// 期数
        /// </summary>
        public int qi { get; set; }

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

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

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

        /// <summary>
        /// 在列表中的排名
        /// </summary>
        [Ignore]
        public int rank { get; set; }

    }
    #endregion

    #region 完整模型
    /// <summary>
    /// 广东好彩1完整模型
    /// </summary>
    [TableName("gdhc1"), PrimaryKey("id")]
    public class Dfgdhc1LongInfo : Dfgdhc1Info
    {
        /// <summary>
        /// 自动编号ID
        /// </summary>
        public int id { get; set; }

        /// <summary>
        /// 数字中奖注数
        /// </summary>
        public string zj1 { get; set; }

        /// <summary>
        /// 数字中奖金额
        /// </summary>
        public string jo1 { get; set; }

        /// <summary>
        /// 生肖中奖注数
        /// </summary>
        public string sx { get; set; }

        /// <summary>
        /// 生肖中奖金额
        /// </summary>
        public string sxjo { get; set; }

        /// <summary>
        /// 季节中奖注数
        /// </summary>
        public string jj { get; set; }

        /// <summary>
        /// 季节中奖金额
        /// </summary>
        public string jjjo { get; set; }

        /// <summary>
        /// 方位中奖注数
        /// </summary>
        public string fw { get; set; }

        /// <summary>
        /// 方位中奖金额
        /// </summary>
        public string fwjo { 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; }

        /// <summary>
        /// 第1步(开奖号）状态  -1：未添加    2：完成   3：复查完成
        /// </summary>
        public int step1state { set; get; }

        /// <summary>
        /// 第2步(开奖详情）状态  -1：未添加  1：完成一半  2：完成   3：复查完成
        /// </summary>
        public int step2state { set; get; }

        [Ignore]
        public string isComplete
        {
            get
            {
                if (step2state == 3)
                    return "<span style='color:green;'>是</span>";
                return "<span style='color:red;'>否</span>";
            }
        }


    }
    #endregion

    /// <summary>
    /// 广东好彩1的数据库操作
    /// </summary>
    public class Dfgdhc1Data : DataConnect
    {

        /// <summary>
        /// 返回所有广东好彩1的数据..
        /// </summary>
        /// <returns></returns>
        public static List<Dfgdhc1Info> GetDfgdhc1Data()
        {
            List<Dfgdhc1Info> list = new List<Dfgdhc1Info>();
            string sql = string.Format("order by qi asc");
            DataConnect dc = new DataConnect();
            list = dc.db.Fetch<Dfgdhc1Info>(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>
        /// <param name="n">条数</param>
        /// <param name="type">默认0只有开奖号数据 1 带有开机号 2 带有试机号</param>
        /// <returns></returns>
        public static List<Dfgdhc1LongInfo> 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<Dfgdhc1LongInfo>(sql);
            }
        }
        /// <summary>
        /// 最新开奖数据
        /// </summary>
        /// <returns></returns>
        public static Dfgdhc1LongInfo GetDfgdHc1NewInfo()
        {
            string sql = string.Format("where n1>-1 order by qi desc limit 1 ");
            DataConnect dc = new DataConnect();
            return dc.db.SingleOrDefault<Dfgdhc1LongInfo>(sql);
        }
        /// <summary>
        /// 最新30期完整开奖数据
        /// </summary>
        /// <returns></returns>
        public static List<Dfgdhc1LongInfo> GetDfgdHc1Top30(int n = 30)
        {
            string sql = string.Format($"order by qi desc limit {30}");
            DataConnect dc = new DataConnect();
            return dc.db.Fetch<Dfgdhc1LongInfo>(sql);
        }

        /// <summary>
        /// 返回指定期数的完整开奖信息
        /// </summary>
        /// <param name="qi"></param>
        /// <returns></returns>
        public static Dfgdhc1LongInfo GetDfgdHc1InfoByQi(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();
            Dfgdhc1LongInfo info = dc.db.SingleOrDefault<Dfgdhc1LongInfo>(sql);

            return info;
        }


        /// <summary>
        /// 根据年份取出当年所有期数
        /// </summary>
        /// <param name="year"></param>
        /// <returns></returns>
        public static List<int> GetDfgdHc1QiListByYear(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<Dfgdhc1Info>(sql);
            if (list != null && list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    rlist.Add(list[i].qi);
                }
            }
            return rlist;
        }


        #endregion

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

        private static readonly object _lock = new object();

        public static void Add(Dfgdhc1LongInfo info)
        {
            if (info == null)
                return;
            if (info.qi <= 0)
                return;
            info.opencode = $"{info.n1:00}+{ZstUtils.GetShengXiao(info.n1)},{ZstUtils.GetJiJie(info.n1)},{ZstUtils.GetFangWei(info.n1)}";
            //星期
            info.week = Utils.GetIntWeek(info.date.DayOfWeek.ToString());

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

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

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

        #endregion
    }
}