using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CP.Common;
using MC.ORM;
namespace CP.Model
{


    #region 彩期配置模型
    /// <summary>
    ///  彩期配置模型
    /// </summary>
    [TableName("qishu_config"), PrimaryKey("id")]
    public class QiShuConfigInfo
    {
        /// <summary>
        /// 自动编号ID
        /// </summary>
        public int Id
        {
            get;
            set;
        }

        /// <summary>
        /// 配置类别ID
        /// </summary>
        public int Tid
        {
            get;
            set;
        }

        /// <summary>
        /// 配置数据所属年份
        /// </summary>
        public int Year
        {
            get;
            set;
        }

        /// <summary>
        /// 配置名称
        /// </summary>
        public string Cname
        {
            get;
            set;
        }

        /// <summary>
        /// 除夕是否放假 0：不放; 1要放假 
        /// </summary>
        public int Cx
        {
            get;
            set;
        }

        /// <summary>
        /// 春节放几天假
        /// </summary>
        public int Nday
        {
            get;
            set;
        }



        /// <summary>
        /// 说明
        /// </summary>
        public string Notes
        {
            get;
            set;
        }

    }
    #endregion

    #region 通用彩种配置数据模型
    /// <summary>
    /// 通用彩种配置数据模型
    /// </summary>
    [TableName("public_cz_config"), PrimaryKey("id")]
    public class PublicCzConfigInfo
    {
        /// <summary>
        /// 类别
        /// </summary>
        public int Cid
        {
            get;
            set;
        }
        /// <summary>
        /// 彩种名
        /// </summary>
        public string Cname
        {
            get;
            set;
        }
        /// <summary>
        /// 开奖日期
        /// </summary>
        public string Kjdate
        {
            get;
            set;
        }
        /// <summary>
        /// 开奖时间
        /// </summary>
        public string Kjtime
        {
            get;
            set;
        }
        /// <summary>
        /// 分类ID，1：天天开奖奖;0、定期开奖
        /// </summary>
        public int Typeid
        {
            get;
            set;
        }
        /// <summary>
        /// 最后更新时间
        /// </summary>
        public DateTime Updatetime
        {
            get;
            set;
        }

        public string ename { get; set; }

    }
    #endregion

    #region 间隔开奖彩种的运算模型 适用于双色球、大乐透、七星彩、七乐彩等
    /// <summary>
    /// 间隔开奖彩种的运算模型 适用于双色球、大乐透、七星彩、七乐彩等
    /// </summary>
    public class JgKjTempInfo
    {
        /// <summary>
        /// 自动顺序编号
        /// </summary>
        public int Id
        {
            get;
            set;
        }

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

        /// <summary>
        /// 开奖日期的INT类型
        /// </summary>
        public int KjdateInt
        {
            get;
            set;
        }

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

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


    }

    #endregion

    public class CpQiShus:DataConnect
    {

        /// <summary>
        /// 数据库中的所有期数配置
        /// </summary>
        /// <returns></returns>
        public static List<QiShuConfigInfo> GetCpQiShuConfigList()
        {
            DataConnect dc = new DataConnect();
            return dc.db.Fetch<QiShuConfigInfo>("");
        }


        /// <summary>
        /// 从数据库中取出彩种开奖日期、时间等配置参数
        /// </summary>
        /// <returns></returns>
        public static List<PublicCzConfigInfo> GetPublicCzConfig()
        {
            List<PublicCzConfigInfo> list = new List<PublicCzConfigInfo>();
            DataConnect dc = new DataConnect();
            list = dc.db.Fetch<PublicCzConfigInfo>("");
            return list;
        }
    }
}