using CP.Common;
using MC.ORM;
using NIU.Core;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;

namespace CP.Model
{
    /// <summary>
    /// 地区表
    /// </summary>
    [TableName("area"), PrimaryKey("areaid")]
    public class Area
    {
        /// <summary>
        /// 自动编号
        /// </summary>
        public int areaid { get; set; }
        /// <summary>
        /// 名称
        /// </summary>
        [Display(Name = "地区名称")]
        public string name { get; set; }
        /// <summary>
        /// 英文名称（用于地址显示）
        /// </summary>
        [Display(Name = "英文名称")]
        public string ename { get; set; }
        /// <summary>
        /// 排序	
        /// </summary>
        [Display(Name = "排序号")]
        public int seq { get; set; }
        /// <summary>
        /// 创建时间
        /// </summary>
        public int cdate { get; set; }

        /// <summary>
        /// title
        /// </summary>
        [Display(Name = "title")]
        public string title { get; set; }
        /// <summary>
        /// keywords
        /// </summary>
        [Display(Name = "Key")]
        public string keywords { get; set; }
        /// <summary>
        /// descriptions
        /// </summary>
        [Display(Name = "Desc")]
        public string descriptions { get; set; }
        /// <summary>
        /// 类型--1：地区  2：彩种
        /// </summary>
        [Ignore]
        public int type { set; get; }

        /// <summary>
        /// treegrid属性
        /// </summary>
        [Ignore]
        public List<Area> children { set; get; }
    }

    public class AreaData : DataConnect
    {
        /// <summary>
        /// 数据库中取出所有七乐彩数据
        /// </summary>
        /// <returns></returns>
        public static List<FcqlcInfo> GetFcqlcList()
        {
            List<FcqlcInfo> list = new List<FcqlcInfo>();

            string sql = string.Format("order by qi asc");
            DataConnect dc = new DataConnect();
            list = dc.db.Fetch<FcqlcInfo>(sql);
            if (list != null && list.Count > 0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    list[i].rank = i + 1;
                }
            }
            return list;
        }

        /// <summary>
        /// 添加 更新
        /// </summary>
        /// <returns></returns>
        public static void AddOrUpdate(Area model)
        {
            if (model == null)
                throw new OperationExceptionFacade("未接收到参数");
            if (string.IsNullOrEmpty(model.name))
                throw new OperationExceptionFacade("名称不可为空");
            DataConnect dc = new DataConnect();
            if (dc.db.Exists<Area>($"Where name='{model.name}' and areaid<>{model.areaid}"))
                throw new OperationExceptionFacade("已存在此客户类型");
            if (model.areaid == 0)
            {
                model.cdate = TypeConverter.DateTimeToInt(DateTime.Now);
                dc.db.Insert(model);
            }
            else
            {
                var entity = dc.db.SingleOrDefault<Area>(model.areaid);
                if (entity == null)
                    throw new OperationExceptionFacade("数据不存在，请刷新");
                entity.name = model.name;
                entity.title = model.title;
                entity.keywords = model.keywords;
                entity.descriptions = model.descriptions;
                entity.seq = 2;
                entity.cdate = TypeConverter.DateTimeToInt(DateTime.Now);
                dc.db.Update(entity);
            }
        }
        /// <summary>
        /// 根据Id获取
        /// </summary>
        /// <returns></returns>
        public static Area GetById(long id)
        {
            DataConnect dc = new DataConnect();
            return dc.db.SingleOrDefault<Area>(id);
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static void Delete(long id)
        {
            var entity = GetById(id);
            if (entity == null)
            {
                throw new OperationExceptionFacade("数据不存在，请刷新");
            }
            DataConnect dc = new DataConnect();
            dc.db.Delete<Area>(id);
        }

        /// <summary>
        /// 获取所有
        /// </summary>
        /// <returns></returns>
        public static List<Area> GetList()
        {
            DataConnect dc = new DataConnect();
            return dc.db.Fetch<Area>($"ORDER BY seq asc");
        }
    }
}