kjh.api.55128.cn_old/CP.Model/AreaCz.cs

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

namespace CP.Model
{
    /// <summary>
	/// 地区彩种表
	/// </summary>
	[TableName("area_cz"), PrimaryKey("id")]
    public class AreaCz
    {
        /// <summary>
        /// 自动编号
        /// </summary>
        public int id { get; set; }
        /// <summary>
        /// 地区id
        /// </summary>
        public int areaid { get; set; }
        /// <summary>
        /// 彩种id
        /// </summary>
        public int cid { get; set; }
        /// <summary>
        /// 彩种名称
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 英文名
        /// </summary>
        public string ename { get; set; }
        /// <summary>
        /// 排序	
        /// </summary>
        public int seq { get; set; }
        /// <summary>
        /// 创建时间
        /// </summary>
        public int cdate { get; set; }
    }

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

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

        public static void SetAreaCzList(int areaid, List<AreaCz> models)
        {
            if (models == null || models.Count == 0)
                throw new OperationExceptionFacade("未接收到参数");
            DataConnect dc = new DataConnect();
            dc.db.Delete<AreaCz>($"where areaid={areaid}");
            foreach (var item in models)
            {
                item.cdate = TypeConverter.DateTimeToInt(DateTime.Now);
                dc.db.Insert(item);
            }
        }
    }
}