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

	public CRM_CUSTOMER_HT(string keyField,string keyValue):this()
        {
            base.KeyField =  keyField;
            this[keyField]= keyValue;
        }
		
		
        public CRM_CUSTOMER_HT(EntityBase entityBase)
            : this()
        {
            this.Data = entityBase.Data;
        }
 
		#region DataMember
		
                                                     /// <summary>
                    ///  GUID
                    /// </summary>
                    public string GUID
                    {
                        get
                        {
                            return this.TextAccess["GUID"];
                        }
                        set
                        {
                            this.TextAccess["GUID"] = value;
                        }
                    }
                    /// <summary>
                    ///  CUSTOMER.GUID
                    /// </summary>
                    public string CUSTOMER_GUID
                    {
                        get
                        {
                            return this.TextAccess["CUSTOMER_GUID"];
                        }
                        set
                        {
                            this.TextAccess["CUSTOMER_GUID"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同编号
                    /// </summary>
                    public string HT_NO
                    {
                        get
                        {
                            return this.TextAccess["HT_NO"];
                        }
                        set
                        {
                            this.TextAccess["HT_NO"] = value;
                        }
                    }
                    /// <summary>
                    ///  生效日期
                    /// </summary>
                    public System.Nullable<DateTime> EFFECT_DATE
                    {
                        get
                        {
                            return this.DateAccess["EFFECT_DATE"];
                        }
                        set
                        {
                            this.DateAccess["EFFECT_DATE"] = value;
                        }
                    }
                    /// <summary>
                    ///  失效日期
                    /// </summary>
                    public System.Nullable<DateTime> UNEFFECT_DATE
                    {
                        get
                        {
                            return this.DateAccess["UNEFFECT_DATE"];
                        }
                        set
                        {
                            this.DateAccess["UNEFFECT_DATE"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同类型
                    /// </summary>
                    public string HTLX
                    {
                        get
                        {
                            return this.TextAccess["HTLX"];
                        }
                        set
                        {
                            this.TextAccess["HTLX"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同模板
                    /// </summary>
                    public string HTMB
                    {
                        get
                        {
                            return this.TextAccess["HTMB"];
                        }
                        set
                        {
                            this.TextAccess["HTMB"] = value;
                        }
                    }
                    /// <summary>
                    ///  经办人
                    /// </summary>
                    public string JBR
                    {
                        get
                        {
                            return this.TextAccess["JBR"];
                        }
                        set
                        {
                            this.TextAccess["JBR"] = value;
                        }
                    }
                    /// <summary>
                    ///  结算周期
                    /// </summary>
                    public string JSZQ
                    {
                        get
                        {
                            return this.TextAccess["JSZQ"];
                        }
                        set
                        {
                            this.TextAccess["JSZQ"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同账期
                    /// </summary>
                    public System.Nullable<double> HTZQ
                    {
                        get
                        {
                            return this.DoubleAccess["HTZQ"];
                        }
                        set
                        {
                            this.DoubleAccess["HTZQ"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同额度
                    /// </summary>
                    public System.Nullable<double> HTED
                    {
                        get
                        {
                            return this.DoubleAccess["HTED"];
                        }
                        set
                        {
                            this.DoubleAccess["HTED"] = value;
                        }
                    }
                    /// <summary>
                    ///  附件地址
                    /// </summary>
                    public string FILE_PATH
                    {
                        get
                        {
                            return this.TextAccess["FILE_PATH"];
                        }
                        set
                        {
                            this.TextAccess["FILE_PATH"] = value;
                        }
                    }
                    /// <summary>
                    ///  附件名称
                    /// </summary>
                    public string FILE_NAME
                    {
                        get
                        {
                            return this.TextAccess["FILE_NAME"];
                        }
                        set
                        {
                            this.TextAccess["FILE_NAME"] = value;
                        }
                    }
                    /// <summary>
                    ///  合同备注
                    /// </summary>
                    public string REMARK
                    {
                        get
                        {
                            return this.TextAccess["REMARK"];
                        }
                        set
                        {
                            this.TextAccess["REMARK"] = value;
                        }
                    }
                    /// <summary>
                    ///  生效状态
                    /// </summary>
                    public string STATUS
                    {
                        get
                        {
                            return this.TextAccess["STATUS"];
                        }
                        set
                        {
                            this.TextAccess["STATUS"] = 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 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 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 FZ_MEMO
                    {
                        get
                        {
                            return this.TextAccess["FZ_MEMO"];
                        }
                        set
                        {
                            this.TextAccess["FZ_MEMO"] = value;
                        }
                    }


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

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

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

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

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

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

	internal class CRM_CUSTOMER_HT_COLUMN : BaseColumn
    {
        public static CRM_CUSTOMER_HT_COLUMN Instance;

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

        private CRM_CUSTOMER_HT_COLUMN()
        {
               base.ListColumn.Add(new ColumnInfo() { Name = "GUID", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "CUSTOMER_GUID", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "HT_NO", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "EFFECT_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "UNEFFECT_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "HTLX", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "HTMB", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "JBR", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "JSZQ", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "HTZQ", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "HTED", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "FILE_PATH", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "FILE_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "REMARK", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "STATUS", 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 = "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 = "NODE_CODE", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NODE_NAME", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "FZ_MEMO", Type = "TEXT" ,NText=false });

        }
    }
	
  public class  CRM_CUSTOMER_HT_FIELD
  {
       private static CRM_CUSTOMER_HT_FIELD instance;

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

                return instance;
            }
        }
		
                    public readonly string GUID = "GUID";
        public readonly string CUSTOMER_GUID = "CUSTOMER_GUID";
        public readonly string HT_NO = "HT_NO";
        public readonly string EFFECT_DATE = "EFFECT_DATE";
        public readonly string UNEFFECT_DATE = "UNEFFECT_DATE";
        public readonly string HTLX = "HTLX";
        public readonly string HTMB = "HTMB";
        public readonly string JBR = "JBR";
        public readonly string JSZQ = "JSZQ";
        public readonly string HTZQ = "HTZQ";
        public readonly string HTED = "HTED";
        public readonly string FILE_PATH = "FILE_PATH";
        public readonly string FILE_NAME = "FILE_NAME";
        public readonly string REMARK = "REMARK";
        public readonly string STATUS = "STATUS";
        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 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 NODE_CODE = "NODE_CODE";
        public readonly string NODE_NAME = "NODE_NAME";
        public readonly string FZ_MEMO = "FZ_MEMO";

   }
}