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

	public CRM_CUSTOMER_BIZ(string keyField,string keyValue):this()
        {
            base.KeyField =  keyField;
            this[keyField]= keyValue;
        }
		
		
        public CRM_CUSTOMER_BIZ(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 BIZ_FLAG
                    {
                        get
                        {
                            return this.TextAccess["BIZ_FLAG"];
                        }
                        set
                        {
                            this.TextAccess["BIZ_FLAG"] = value;
                        }
                    }
                    /// <summary>
                    ///  锁定状态
                    /// </summary>
                    public string LOCK_STATUS
                    {
                        get
                        {
                            return this.TextAccess["LOCK_STATUS"];
                        }
                        set
                        {
                            this.TextAccess["LOCK_STATUS"] = value;
                        }
                    }
                    /// <summary>
                    ///  关键客户
                    /// </summary>
                    public string GJKH
                    {
                        get
                        {
                            return this.TextAccess["GJKH"];
                        }
                        set
                        {
                            this.TextAccess["GJKH"] = value;
                        }
                    }
                    /// <summary>
                    ///  关系维护人
                    /// </summary>
                    public string GXWHR
                    {
                        get
                        {
                            return this.TextAccess["GXWHR"];
                        }
                        set
                        {
                            this.TextAccess["GXWHR"] = value;
                        }
                    }
                    /// <summary>
                    ///  信用等级
                    /// </summary>
                    public string XYDJ
                    {
                        get
                        {
                            return this.TextAccess["XYDJ"];
                        }
                        set
                        {
                            this.TextAccess["XYDJ"] = value;
                        }
                    }
                    /// <summary>
                    ///  EQ
                    /// </summary>
                    public string EQ
                    {
                        get
                        {
                            return this.TextAccess["EQ"];
                        }
                        set
                        {
                            this.TextAccess["EQ"] = value;
                        }
                    }
                    /// <summary>
                    ///  报价性质
                    /// </summary>
                    public string BJXZ
                    {
                        get
                        {
                            return this.TextAccess["BJXZ"];
                        }
                        set
                        {
                            this.TextAccess["BJXZ"] = value;
                        }
                    }
                    /// <summary>
                    ///  难度系数
                    /// </summary>
                    public string NDXS
                    {
                        get
                        {
                            return this.TextAccess["NDXS"];
                        }
                        set
                        {
                            this.TextAccess["NDXS"] = value;
                        }
                    }
                    /// <summary>
                    ///  授信额度
                    /// </summary>
                    public System.Nullable<double> SXED
                    {
                        get
                        {
                            return this.DoubleAccess["SXED"];
                        }
                        set
                        {
                            this.DoubleAccess["SXED"] = value;
                        }
                    }
                    /// <summary>
                    ///  临时额度
                    /// </summary>
                    public System.Nullable<double> LSED
                    {
                        get
                        {
                            return this.DoubleAccess["LSED"];
                        }
                        set
                        {
                            this.DoubleAccess["LSED"] = value;
                        }
                    }
                    /// <summary>
                    ///  临时额度截止日期
                    /// </summary>
                    public System.Nullable<DateTime> LSED_DATE
                    {
                        get
                        {
                            return this.DateAccess["LSED_DATE"];
                        }
                        set
                        {
                            this.DateAccess["LSED_DATE"] = value;
                        }
                    }
                    /// <summary>
                    ///  授信期限
                    /// </summary>
                    public System.Nullable<double> SXQX
                    {
                        get
                        {
                            return this.DoubleAccess["SXQX"];
                        }
                        set
                        {
                            this.DoubleAccess["SXQX"] = value;
                        }
                    }
                    /// <summary>
                    ///  临时期限截止日期
                    /// </summary>
                    public System.Nullable<DateTime> LSQX_DATE
                    {
                        get
                        {
                            return this.DateAccess["LSQX_DATE"];
                        }
                        set
                        {
                            this.DateAccess["LSQX_DATE"] = 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;
                        }
                    }


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

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

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

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

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

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

	internal class CRM_CUSTOMER_BIZ_COLUMN : BaseColumn
    {
        public static CRM_CUSTOMER_BIZ_COLUMN Instance;

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

        private CRM_CUSTOMER_BIZ_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 = "BIZ_FLAG", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "LOCK_STATUS", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "GJKH", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "GXWHR", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "XYDJ", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "EQ", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "BJXZ", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "NDXS", Type = "TEXT" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "SXED", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "LSED", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "LSED_DATE", Type = "DATE" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "SXQX", Type = "NUMBER" ,NText=false });
               base.ListColumn.Add(new ColumnInfo() { Name = "LSQX_DATE", Type = "DATE" ,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 });

        }
    }
	
  public class  CRM_CUSTOMER_BIZ_FIELD
  {
       private static CRM_CUSTOMER_BIZ_FIELD instance;

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

                return instance;
            }
        }
		
                    public readonly string GUID = "GUID";
        public readonly string CUSTOMER_GUID = "CUSTOMER_GUID";
        public readonly string BIZ_FLAG = "BIZ_FLAG";
        public readonly string LOCK_STATUS = "LOCK_STATUS";
        public readonly string GJKH = "GJKH";
        public readonly string GXWHR = "GXWHR";
        public readonly string XYDJ = "XYDJ";
        public readonly string EQ = "EQ";
        public readonly string BJXZ = "BJXZ";
        public readonly string NDXS = "NDXS";
        public readonly string SXED = "SXED";
        public readonly string LSED = "LSED";
        public readonly string LSED_DATE = "LSED_DATE";
        public readonly string SXQX = "SXQX";
        public readonly string LSQX_DATE = "LSQX_DATE";
        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";

   }
}