FMS24/FMS24/FMS.Entity/Entity/BD_SERVICE_KM.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_SERVICE_KM : EntityBase
	{
	     public BD_SERVICE_KM()
		 {
		    base.Table = new TableInfo { Name = "FMS_BD_SERVICE_KM" };
		    base.Columns = BD_SERVICE_KM_COLUMN.Instance;
			this.Init();
		 }
		
		public BD_SERVICE_KM(string keyField):this()
        {
            base.KeyField =  keyField;
        }

	public BD_SERVICE_KM(string keyField,string keyValue):this()
        {
            base.KeyField =  keyField;
            this[keyField]= keyValue;
        }
		
		
        public BD_SERVICE_KM(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 GLMS
                    {
                        get
                        {
                            return this.TextAccess["GLMS"];
                        }
                        set
                        {
                            this.TextAccess["GLMS"] = value;
                        }
                    }
                    /// <summary>
                    ///  辅助账设置
                    /// </summary>
                    public string FZZSZ
                    {
                        get
                        {
                            return this.TextAccess["FZZSZ"];
                        }
                        set
                        {
                            this.TextAccess["FZZSZ"] = value;
                        }
                    }
                    /// <summary>
                    ///  是否启用
                    /// </summary>
                    public string STATUS
                    {
                        get
                        {
                            return this.TextAccess["STATUS"];
                        }
                        set
                        {
                            this.TextAccess["STATUS"] = value;
                        }
                    }
                    /// <summary>
                    ///  科目备注
                    /// </summary>
                    public string REAMRK
                    {
                        get
                        {
                            return this.TextAccess["REAMRK"];
                        }
                        set
                        {
                            this.TextAccess["REAMRK"] = value;
                        }
                    }
                    /// <summary>
                    ///  创建人
                    /// </summary>
                    public string CREATE_USER
                    {
                        get
                        {
                            return this.TextAccess["CREATE_USER"];
                        }
                        set
                        {
                            this.TextAccess["CREATE_USER"] = 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 System.Nullable<DateTime> UPDATE_DATE
                    {
                        get
                        {
                            return this.DateAccess["UPDATE_DATE"];
                        }
                        set
                        {
                            this.DateAccess["UPDATE_DATE"] = 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 string UPDATE_USER_NAME
                    {
                        get
                        {
                            return this.TextAccess["UPDATE_USER_NAME"];
                        }
                        set
                        {
                            this.TextAccess["UPDATE_USER_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;
                        }
                    }
                    /// <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 BIZ_FLAG
                    {
                        get
                        {
                            return this.TextAccess["BIZ_FLAG"];
                        }
                        set
                        {
                            this.TextAccess["BIZ_FLAG"] = value;
                        }
                    }
                    /// <summary>
                    ///  父级ID
                    /// </summary>
                    public string PARENTID
                    {
                        get
                        {
                            return this.TextAccess["PARENTID"];
                        }
                        set
                        {
                            this.TextAccess["PARENTID"] = value;
                        }
                    }
                    /// <summary>
                    ///  顺序
                    /// </summary>
                    public System.Nullable<double> SEQ
                    {
                        get
                        {
                            return this.DoubleAccess["SEQ"];
                        }
                        set
                        {
                            this.DoubleAccess["SEQ"] = value;
                        }
                    }
                    /// <summary>
                    ///  所属服务类别名称
                    /// </summary>
                    public string OWNERNAME
                    {
                        get
                        {
                            return this.TextAccess["OWNERNAME"];
                        }
                        set
                        {
                            this.TextAccess["OWNERNAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  所属服务类别备注
                    /// </summary>
                    public string MEMO
                    {
                        get
                        {
                            return this.TextAccess["MEMO"];
                        }
                        set
                        {
                            this.TextAccess["MEMO"] = value;
                        }
                    }
                    /// <summary>
                    ///  所属服务类别
                    /// </summary>
                    public string OWNED_SERVICE
                    {
                        get
                        {
                            return this.TextAccess["OWNED_SERVICE"];
                        }
                        set
                        {
                            this.TextAccess["OWNED_SERVICE"] = value;
                        }
                    }


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

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

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

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

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

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

	internal class BD_SERVICE_KM_COLUMN : BaseColumn
    {
        public static BD_SERVICE_KM_COLUMN Instance;

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

        private BD_SERVICE_KM_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 = "GLMS", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "FZZSZ", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "STATUS", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "REAMRK", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER", Type = "TEXT" ,NText=true });
               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_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_USER_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 });
               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 = "BIZ_FLAG", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "PARENTID", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "SEQ", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "OWNERNAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "MEMO", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "OWNED_SERVICE", Type = "TEXT" ,NText=false });

        }
    }
	
  public class  BD_SERVICE_KM_FIELD
  {
       private static BD_SERVICE_KM_FIELD instance;

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

                return instance;
            }
        }
		
                    public readonly string GUID = "GUID";
        public readonly string CODE = "CODE";
        public readonly string NAME = "NAME";
        public readonly string GLMS = "GLMS";
        public readonly string FZZSZ = "FZZSZ";
        public readonly string STATUS = "STATUS";
        public readonly string REAMRK = "REAMRK";
        public readonly string CREATE_USER = "CREATE_USER";
        public readonly string CREATE_DATE = "CREATE_DATE";
        public readonly string UPDATE_USER = "UPDATE_USER";
        public readonly string UPDATE_DATE = "UPDATE_DATE";
        public readonly string CREATE_USER_NAME = "CREATE_USER_NAME";
        public readonly string UPDATE_USER_NAME = "UPDATE_USER_NAME";
        public readonly string GROUP_CODE = "GROUP_CODE";
        public readonly string GROUP_NAME = "GROUP_NAME";
        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 BIZ_FLAG = "BIZ_FLAG";
        public readonly string PARENTID = "PARENTID";
        public readonly string SEQ = "SEQ";
        public readonly string OWNERNAME = "OWNERNAME";
        public readonly string MEMO = "MEMO";
        public readonly string OWNED_SERVICE = "OWNED_SERVICE";

   }
}