#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
///
/// GUID
///
public string GUID
{
get
{
return this.TextAccess["GUID"];
}
set
{
this.TextAccess["GUID"] = value;
}
}
///
/// CUSTOMER.GUID
///
public string CUSTOMER_GUID
{
get
{
return this.TextAccess["CUSTOMER_GUID"];
}
set
{
this.TextAccess["CUSTOMER_GUID"] = value;
}
}
///
/// 合同编号
///
public string HT_NO
{
get
{
return this.TextAccess["HT_NO"];
}
set
{
this.TextAccess["HT_NO"] = value;
}
}
///
/// 生效日期
///
public System.Nullable EFFECT_DATE
{
get
{
return this.DateAccess["EFFECT_DATE"];
}
set
{
this.DateAccess["EFFECT_DATE"] = value;
}
}
///
/// 失效日期
///
public System.Nullable UNEFFECT_DATE
{
get
{
return this.DateAccess["UNEFFECT_DATE"];
}
set
{
this.DateAccess["UNEFFECT_DATE"] = value;
}
}
///
/// 合同类型
///
public string HTLX
{
get
{
return this.TextAccess["HTLX"];
}
set
{
this.TextAccess["HTLX"] = value;
}
}
///
/// 合同模板
///
public string HTMB
{
get
{
return this.TextAccess["HTMB"];
}
set
{
this.TextAccess["HTMB"] = value;
}
}
///
/// 经办人
///
public string JBR
{
get
{
return this.TextAccess["JBR"];
}
set
{
this.TextAccess["JBR"] = value;
}
}
///
/// 结算周期
///
public string JSZQ
{
get
{
return this.TextAccess["JSZQ"];
}
set
{
this.TextAccess["JSZQ"] = value;
}
}
///
/// 合同账期
///
public System.Nullable HTZQ
{
get
{
return this.DoubleAccess["HTZQ"];
}
set
{
this.DoubleAccess["HTZQ"] = value;
}
}
///
/// 合同额度
///
public System.Nullable HTED
{
get
{
return this.DoubleAccess["HTED"];
}
set
{
this.DoubleAccess["HTED"] = value;
}
}
///
/// 附件地址
///
public string FILE_PATH
{
get
{
return this.TextAccess["FILE_PATH"];
}
set
{
this.TextAccess["FILE_PATH"] = value;
}
}
///
/// 附件名称
///
public string FILE_NAME
{
get
{
return this.TextAccess["FILE_NAME"];
}
set
{
this.TextAccess["FILE_NAME"] = value;
}
}
///
/// 合同备注
///
public string REMARK
{
get
{
return this.TextAccess["REMARK"];
}
set
{
this.TextAccess["REMARK"] = value;
}
}
///
/// 生效状态
///
public string STATUS
{
get
{
return this.TextAccess["STATUS"];
}
set
{
this.TextAccess["STATUS"] = value;
}
}
///
/// 集团代码
///
public string GROUP_CODE
{
get
{
return this.TextAccess["GROUP_CODE"];
}
set
{
this.TextAccess["GROUP_CODE"] = value;
}
}
///
/// 集团名称
///
public string GROUP_NAME
{
get
{
return this.TextAccess["GROUP_NAME"];
}
set
{
this.TextAccess["GROUP_NAME"] = value;
}
}
///
/// 公司代码
///
public string COMPANY_CODE
{
get
{
return this.TextAccess["COMPANY_CODE"];
}
set
{
this.TextAccess["COMPANY_CODE"] = value;
}
}
///
/// 公司名称
///
public string COMPANY_NAME
{
get
{
return this.TextAccess["COMPANY_NAME"];
}
set
{
this.TextAccess["COMPANY_NAME"] = value;
}
}
///
/// 创建人
///
public string CREATE_USER
{
get
{
return this.TextAccess["CREATE_USER"];
}
set
{
this.TextAccess["CREATE_USER"] = value;
}
}
///
/// 创建日期
///
public System.Nullable CREATE_DATE
{
get
{
return this.DateAccess["CREATE_DATE"];
}
set
{
this.DateAccess["CREATE_DATE"] = value;
}
}
///
/// 修改人
///
public string UPDATE_USER
{
get
{
return this.TextAccess["UPDATE_USER"];
}
set
{
this.TextAccess["UPDATE_USER"] = value;
}
}
///
/// 修改日期
///
public System.Nullable UPDATE_DATE
{
get
{
return this.DateAccess["UPDATE_DATE"];
}
set
{
this.DateAccess["UPDATE_DATE"] = value;
}
}
///
/// 创建人
///
public string CREATE_USER_NAME
{
get
{
return this.TextAccess["CREATE_USER_NAME"];
}
set
{
this.TextAccess["CREATE_USER_NAME"] = value;
}
}
///
/// 修改人
///
public string UPDATE_USER_NAME
{
get
{
return this.TextAccess["UPDATE_USER_NAME"];
}
set
{
this.TextAccess["UPDATE_USER_NAME"] = value;
}
}
///
/// 组织代码
///
public string NODE_CODE
{
get
{
return this.TextAccess["NODE_CODE"];
}
set
{
this.TextAccess["NODE_CODE"] = value;
}
}
///
/// 组织名称
///
public string NODE_NAME
{
get
{
return this.TextAccess["NODE_NAME"];
}
set
{
this.TextAccess["NODE_NAME"] = value;
}
}
///
/// 废止备注
///
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().ToEntityBySql(this.SQLSelect);
}
public CRM_CUSTOMER_HT SingleOrDefault(object ts)
{
return new EntityBuilder().ToEntityBySql(this.SQLSelect, ts);
}
public List ToList()
{
return new EntityBuilder().ToListBySql(this.SQLSelect);
}
public List ToList(object ts)
{
return new EntityBuilder().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 list = ToListBySql(sql, ts);
if (list.Count == 0) return null;
else
{
return list[0];
}
}
public static List ToListBySql(string sql)
{
return ToListBySql(sql, null);
}
public static List ToListBySql(string sql, object ts)
{
return new EntityBuilder().ToListBySql(sql, ts);
}
public static List ToList(DataTable data)
{
return new EntityBuilder().ToList(data);
}
#endregion
public static TDAL DAL
{
get
{
return new TDAL();
}
}
public static CRM_CUSTOMER_HT_FIELD Fields
{
get { return CRM_CUSTOMER_HT_FIELD.Instance; }
}
public static EntityBuilder EntityBuilder = new EntityBuilder();
}
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";
}
}