FMS24/FMS24/FMS.Entity/Entity/BD_LY_CITY.cs

#pragma warning disable  1591
using PL.Base;
using System;
using System.Collections.Generic;
using System.Data;
using PL.Server.Entity;
using PL.Server.Entity.Entity;
 
namespace FMS.Entity
{
    public partial class BD_LY_CITY : EntityBase
	{
	     public BD_LY_CITY()
		 {
		    base.Table = new TableInfo { Name = "FMS_BD_LY_CITY" };
		    base.Columns = BD_LY_CITY_COLUMN.Instance;
			this.Init();
		 }
		
		public BD_LY_CITY(string keyField):this()
        {
            base.KeyField =  keyField;
        }

	public BD_LY_CITY(string keyField,string keyValue):this()
        {
            base.KeyField =  keyField;
            this[keyField]= keyValue;
        }
		
		
        public BD_LY_CITY(EntityBase entityBase)
            : this()
        {
            this.Data = entityBase.Data;
        }
 
		#region DataMember
		
                                                     /// <summary>
                    ///  主键
                    /// </summary>
                    public string GUID
                    {
                        get
                        {
                            return this.TextAccess["GUID"];
                        }
                        set
                        {
                            this.TextAccess["GUID"] = value;
                        }
                    }
                    /// <summary>
                    ///  城市代码
                    /// </summary>
                    public string CODE
                    {
                        get
                        {
                            return this.TextAccess["CODE"];
                        }
                        set
                        {
                            this.TextAccess["CODE"] = value;
                        }
                    }
                    /// <summary>
                    ///  城市中文名称
                    /// </summary>
                    public string NAME
                    {
                        get
                        {
                            return this.TextAccess["NAME"];
                        }
                        set
                        {
                            this.TextAccess["NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  城市英文名称
                    /// </summary>
                    public string NAME_EN
                    {
                        get
                        {
                            return this.TextAccess["NAME_EN"];
                        }
                        set
                        {
                            this.TextAccess["NAME_EN"] = value;
                        }
                    }
                    /// <summary>
                    ///  国家代码
                    /// </summary>
                    public string COUNTRY
                    {
                        get
                        {
                            return this.TextAccess["COUNTRY"];
                        }
                        set
                        {
                            this.TextAccess["COUNTRY"] = value;
                        }
                    }
                    /// <summary>
                    ///  国家中文名称
                    /// </summary>
                    public string COUNTRY_NAME
                    {
                        get
                        {
                            return this.TextAccess["COUNTRY_NAME"];
                        }
                        set
                        {
                            this.TextAccess["COUNTRY_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  国家英文名称
                    /// </summary>
                    public string COUNTRY_NAME_EN
                    {
                        get
                        {
                            return this.TextAccess["COUNTRY_NAME_EN"];
                        }
                        set
                        {
                            this.TextAccess["COUNTRY_NAME_EN"] = value;
                        }
                    }
                    /// <summary>
                    ///  创建人
                    /// </summary>
                    public string CREATE_USER
                    {
                        get
                        {
                            return this.TextAccess["CREATE_USER"];
                        }
                        set
                        {
                            this.TextAccess["CREATE_USER"] = value;
                        }
                    }
                    /// <summary>
                    ///  创建人
                    /// </summary>
                    public string CREATE_USER_NAME
                    {
                        get
                        {
                            return this.TextAccess["CREATE_USER_NAME"];
                        }
                        set
                        {
                            this.TextAccess["CREATE_USER_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  创建日期
                    /// </summary>
                    public System.Nullable<DateTime> CREATE_DATE
                    {
                        get
                        {
                            return this.DateAccess["CREATE_DATE"];
                        }
                        set
                        {
                            this.DateAccess["CREATE_DATE"] = value;
                        }
                    }
                    /// <summary>
                    ///  修改人
                    /// </summary>
                    public string UPDATE_USER
                    {
                        get
                        {
                            return this.TextAccess["UPDATE_USER"];
                        }
                        set
                        {
                            this.TextAccess["UPDATE_USER"] = value;
                        }
                    }
                    /// <summary>
                    ///  修改人
                    /// </summary>
                    public string UPDATE_USER_NAME
                    {
                        get
                        {
                            return this.TextAccess["UPDATE_USER_NAME"];
                        }
                        set
                        {
                            this.TextAccess["UPDATE_USER_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  修改日期
                    /// </summary>
                    public System.Nullable<DateTime> UPDATE_DATE
                    {
                        get
                        {
                            return this.DateAccess["UPDATE_DATE"];
                        }
                        set
                        {
                            this.DateAccess["UPDATE_DATE"] = value;
                        }
                    }
                    /// <summary>
                    ///  公司代码
                    /// </summary>
                    public string COMPANY_CODE
                    {
                        get
                        {
                            return this.TextAccess["COMPANY_CODE"];
                        }
                        set
                        {
                            this.TextAccess["COMPANY_CODE"] = value;
                        }
                    }
                    /// <summary>
                    ///  公司名称
                    /// </summary>
                    public string COMPANY_NAME
                    {
                        get
                        {
                            return this.TextAccess["COMPANY_NAME"];
                        }
                        set
                        {
                            this.TextAccess["COMPANY_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  组织代码
                    /// </summary>
                    public string NODE_CODE
                    {
                        get
                        {
                            return this.TextAccess["NODE_CODE"];
                        }
                        set
                        {
                            this.TextAccess["NODE_CODE"] = value;
                        }
                    }
                    /// <summary>
                    ///  组织名称
                    /// </summary>
                    public string NODE_NAME
                    {
                        get
                        {
                            return this.TextAccess["NODE_NAME"];
                        }
                        set
                        {
                            this.TextAccess["NODE_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  集团代码
                    /// </summary>
                    public string GROUP_CODE
                    {
                        get
                        {
                            return this.TextAccess["GROUP_CODE"];
                        }
                        set
                        {
                            this.TextAccess["GROUP_CODE"] = value;
                        }
                    }
                    /// <summary>
                    ///  集团名称
                    /// </summary>
                    public string GROUP_NAME
                    {
                        get
                        {
                            return this.TextAccess["GROUP_NAME"];
                        }
                        set
                        {
                            this.TextAccess["GROUP_NAME"] = value;
                        }
                    }


		#endregion
	 
	    #region Query Method
        public BD_LY_CITY SingleOrDefault()
        {
           return new EntityBuilder<BD_LY_CITY>().ToEntityBySql(this.SQLSelect);
        }

        public BD_LY_CITY SingleOrDefault(object ts)
        {
            return new EntityBuilder<BD_LY_CITY>().ToEntityBySql(this.SQLSelect, ts);
        }

        public List<BD_LY_CITY> ToList()
        {
             return new EntityBuilder<BD_LY_CITY>().ToListBySql(this.SQLSelect);
        }
		 
        public List<BD_LY_CITY> ToList(object ts)
        {
            return new EntityBuilder<BD_LY_CITY>().ToListBySql(this.SQLSelect, ts);
        }
		
		public static BD_LY_CITY SingleOrDefault(string sql)
        {
            return SingleOrDefault(sql, null);
        }

        public static BD_LY_CITY SingleOrDefault(string sql,object ts)
        {
            List<BD_LY_CITY> list = ToListBySql(sql, ts);

            if (list.Count == 0) return null;
            else
            {
                return list[0];
            }
        }
		
		public static  List<BD_LY_CITY> ToListBySql(string sql)
        {
            return ToListBySql(sql, null);
        }

        public static List<BD_LY_CITY> ToListBySql(string sql, object ts)
        {
            return new EntityBuilder<BD_LY_CITY>().ToListBySql(sql, ts);
        }
		
		public static List<BD_LY_CITY> ToList(DataTable data)
        {
            return new EntityBuilder<BD_LY_CITY>().ToList(data);
        }
		
		
		#endregion
		
	    public static TDAL<BD_LY_CITY, BD_LY_CITY_FIELD> DAL
        {
            get
            {
                return new TDAL<BD_LY_CITY, BD_LY_CITY_FIELD>();
            }
        }
		
	    public static BD_LY_CITY_FIELD Fields
        {
            get { return BD_LY_CITY_FIELD.Instance; }
        }
		
	
		public static EntityBuilder<BD_LY_CITY> EntityBuilder = new EntityBuilder<BD_LY_CITY>();
    }

	internal class BD_LY_CITY_COLUMN : BaseColumn
    {
        public static BD_LY_CITY_COLUMN Instance;

        static BD_LY_CITY_COLUMN()
        {
            Instance = new BD_LY_CITY_COLUMN();
        }

        private BD_LY_CITY_COLUMN()
        {
               base.ListColumn.Add(new ColumnInfo() { Name = "GUID", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CODE", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NAME_EN", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "COUNTRY", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "COUNTRY_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "COUNTRY_NAME_EN", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER", Type = "TEXT" ,NText=true });
               base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_USER", Type = "TEXT" ,NText=true });
               base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_USER_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "COMPANY_CODE", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "COMPANY_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NODE_CODE", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NODE_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "GROUP_CODE", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "GROUP_NAME", Type = "TEXT" ,NText=false });

        }
    }
	
  public class  BD_LY_CITY_FIELD
  {
       private static BD_LY_CITY_FIELD instance;

        public static BD_LY_CITY_FIELD Instance
        {
            get
            {
                if (instance == null)
                {
                    instance = new BD_LY_CITY_FIELD();
                }

                return instance;
            }
        }
		
                    public readonly string GUID = "GUID";
        public readonly string CODE = "CODE";
        public readonly string NAME = "NAME";
        public readonly string NAME_EN = "NAME_EN";
        public readonly string COUNTRY = "COUNTRY";
        public readonly string COUNTRY_NAME = "COUNTRY_NAME";
        public readonly string COUNTRY_NAME_EN = "COUNTRY_NAME_EN";
        public readonly string CREATE_USER = "CREATE_USER";
        public readonly string CREATE_USER_NAME = "CREATE_USER_NAME";
        public readonly string CREATE_DATE = "CREATE_DATE";
        public readonly string UPDATE_USER = "UPDATE_USER";
        public readonly string UPDATE_USER_NAME = "UPDATE_USER_NAME";
        public readonly string UPDATE_DATE = "UPDATE_DATE";
        public readonly string COMPANY_CODE = "COMPANY_CODE";
        public readonly string COMPANY_NAME = "COMPANY_NAME";
        public readonly string NODE_CODE = "NODE_CODE";
        public readonly string NODE_NAME = "NODE_NAME";
        public readonly string GROUP_CODE = "GROUP_CODE";
        public readonly string GROUP_NAME = "GROUP_NAME";

   }
}