You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
608 lines
17 KiB
C#
608 lines
17 KiB
C#
using System;
|
|
using System.Data;
|
|
|
|
namespace DSWeb.Models
|
|
{
|
|
/// <summary>
|
|
/// CRM系统客户信息表
|
|
/// </summary>
|
|
public class CRMClientEntity
|
|
{
|
|
#region 私有成员
|
|
private string _gid;//主键唯一值
|
|
private string _code_name;//客户代码
|
|
private string _short_name;//客户简称
|
|
private string _name;//客户英文名称
|
|
private string _description;//客户中文名称或者描述信息
|
|
private int _status;//客户状态
|
|
private string _address;//通讯地址
|
|
private string _email;//电子邮箱地址
|
|
private string _web_url;//网页
|
|
private string _tel_num;//电话
|
|
private string _fax;//传真
|
|
private string _chief;//负责人
|
|
private string _sale;//所属揽货人
|
|
private string _op;//所属操作
|
|
private bool _is_carrier;//是否船公司
|
|
private bool _is_booking;//是否订舱代理
|
|
private bool _is_yard;//是否场站
|
|
private bool _is_truck;//是否车队
|
|
private bool _is_controller;//是否委托单位
|
|
private bool _is_custom;//是否报关行
|
|
private bool _is_agent;//是否代理(国外)
|
|
private bool _is_airlines;//是否航空公司
|
|
private bool _is_shipper;//是否发货人
|
|
private bool _is_consignee;//是否收货人
|
|
private bool _is_notify_party;//是否通知人
|
|
private bool _is_warehouse;//是否仓库
|
|
private string _country;//国家
|
|
private string _province;//省或者州
|
|
private string _city;//城市
|
|
private string _corpid;//所属分公司代码
|
|
private string _blcontent;//详细信息
|
|
private string _en_full_name;//客户英文全称
|
|
private string _doc;//所属单证
|
|
private bool _is_agent_cn;//是否代理(国内)
|
|
private bool _is_express;//是否快递公司
|
|
private bool _is_stop;//是否停用该客户信息
|
|
private string _bill_rises1;//发票抬头1
|
|
private string _bill_rises2;//发票抬头2
|
|
private string _usd_bill_rises;//美元支票抬头
|
|
private string _rmb_bill_rises;//人民币支票抬头
|
|
private string _rmb_bank;//人民币开户银行
|
|
private string _rmb_account;//人民币账户
|
|
private string _rmb_online_no;//人民币联机行号
|
|
private string _usd_bank;//美元开户银行
|
|
private string _usd_account;//美元账号
|
|
private string _usd_online_no;//美元联机行号
|
|
private string _custom_attribute1;//自定义属性1
|
|
private string _custom_attribute2;//自定义属性2
|
|
private string _FARCODE;//财务应收帐款代码
|
|
private string _FAPCODE;//财务应付帐款代码
|
|
private decimal _usd_max_amount_credit;//美元信用最大金额
|
|
private decimal _rmb_max_amount_credit;//人民币信用最大金额
|
|
private decimal _max_amount_credit;//信用最大金额(RMB+USD)
|
|
private string _stl_name;//结算方式
|
|
private string _op_name;//处理人
|
|
private DateTime _op_time;//处理时间
|
|
private string _remark;//备注
|
|
private decimal _usd_exchange_rate;//美金汇率
|
|
private string _stl_date;//月结时间
|
|
private string _stl_first_half_date;//上半月结时间
|
|
private string _stl_middle_date;//下半月结时间
|
|
private string _stl_date_pj;//票结时间
|
|
private string _level;//运价级别
|
|
private string _login_name;//用户代码名
|
|
private string _login_password;//登录密码
|
|
|
|
#endregion
|
|
|
|
public CRMClientEntity()
|
|
{
|
|
}
|
|
|
|
#region 读写属性
|
|
/// <summary>
|
|
/// 主键唯一值
|
|
/// </summary>
|
|
public string GID
|
|
{
|
|
get { return _gid; }
|
|
set { _gid = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户代码
|
|
/// </summary>
|
|
public string CodeName
|
|
{
|
|
get { return _code_name; }
|
|
set { _code_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户简称
|
|
/// </summary>
|
|
public string ShortName
|
|
{
|
|
get { return _short_name; }
|
|
set { _short_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户英文名称
|
|
/// </summary>
|
|
public string Name
|
|
{
|
|
get { return _name; }
|
|
set { _name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户中文名称或者描述信息
|
|
/// </summary>
|
|
public string Description
|
|
{
|
|
get { return _description; }
|
|
set { _description = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户状态
|
|
/// </summary>
|
|
public int Status
|
|
{
|
|
get { return _status; }
|
|
set { _status = value; }
|
|
}
|
|
/// <summary>
|
|
/// 通讯地址
|
|
/// </summary>
|
|
public string Address
|
|
{
|
|
get { return _address; }
|
|
set { _address = value; }
|
|
}
|
|
/// <summary>
|
|
/// 电子邮箱地址
|
|
/// </summary>
|
|
public string Email
|
|
{
|
|
get { return _email; }
|
|
set { _email = value; }
|
|
}
|
|
/// <summary>
|
|
/// 网页
|
|
/// </summary>
|
|
public string WebUrl
|
|
{
|
|
get { return _web_url; }
|
|
set { _web_url = value; }
|
|
}
|
|
/// <summary>
|
|
/// 电话
|
|
/// </summary>
|
|
public string TelNumber
|
|
{
|
|
get { return _tel_num; }
|
|
set { _tel_num = value; }
|
|
}
|
|
/// <summary>
|
|
/// 传真
|
|
/// </summary>
|
|
public string Fax
|
|
{
|
|
get { return _fax; }
|
|
set { _fax = value; }
|
|
}
|
|
/// <summary>
|
|
/// 负责人
|
|
/// </summary>
|
|
public string Chief
|
|
{
|
|
get { return _chief; }
|
|
set { _chief = value; }
|
|
}
|
|
/// <summary>
|
|
/// 所属揽货人
|
|
/// </summary>
|
|
public string Sale
|
|
{
|
|
get { return _sale; }
|
|
set { _sale = value; }
|
|
}
|
|
/// <summary>
|
|
/// 所属操作
|
|
/// </summary>
|
|
public string OP
|
|
{
|
|
get { return _op; }
|
|
set { _op = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否船公司
|
|
/// </summary>
|
|
public bool IsCarrier
|
|
{
|
|
get { return _is_carrier; }
|
|
set { _is_carrier = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否订舱代理
|
|
/// </summary>
|
|
public bool IsBooking
|
|
{
|
|
get { return _is_booking; }
|
|
set { _is_booking = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否场站
|
|
/// </summary>
|
|
public bool IsYard
|
|
{
|
|
get { return _is_yard; }
|
|
set { _is_yard = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否车队
|
|
/// </summary>
|
|
public bool IsTruck
|
|
{
|
|
get { return _is_truck; }
|
|
set { _is_truck = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否委托单位
|
|
/// </summary>
|
|
public bool IsController
|
|
{
|
|
get { return _is_controller; }
|
|
set { _is_controller = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否报关行
|
|
/// </summary>
|
|
public bool IsCustom
|
|
{
|
|
get { return _is_custom; }
|
|
set { _is_custom = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否代理
|
|
/// </summary>
|
|
public bool IsAgent
|
|
{
|
|
get { return _is_agent; }
|
|
set { _is_agent = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否航空公司
|
|
/// </summary>
|
|
public bool IsAirLines
|
|
{
|
|
get { return _is_airlines; }
|
|
set { _is_airlines = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否发货人
|
|
/// </summary>
|
|
public bool IsShipper
|
|
{
|
|
get { return _is_shipper; }
|
|
set { _is_shipper = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否收货人
|
|
/// </summary>
|
|
public bool IsConsignee
|
|
{
|
|
get { return _is_consignee; }
|
|
set { _is_consignee = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否通知人
|
|
/// </summary>
|
|
public bool IsNotifyParty
|
|
{
|
|
get { return _is_notify_party; }
|
|
set { _is_notify_party = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否仓库
|
|
/// </summary>
|
|
public bool IsWarehouse
|
|
{
|
|
get { return _is_warehouse; }
|
|
set { _is_warehouse = value; }
|
|
}
|
|
/// <summary>
|
|
/// 国家
|
|
/// </summary>
|
|
public string Country
|
|
{
|
|
get { return _country; }
|
|
set { _country = value; }
|
|
}
|
|
/// <summary>
|
|
/// 省或者州
|
|
/// </summary>
|
|
public string Province
|
|
{
|
|
get { return _province; }
|
|
set { _province = value; }
|
|
}
|
|
/// <summary>
|
|
/// 城市
|
|
/// </summary>
|
|
public string City
|
|
{
|
|
get { return _city; }
|
|
set { _city = value; }
|
|
}
|
|
/// <summary>
|
|
/// 所属分公司代码
|
|
/// </summary>
|
|
public string CORPID
|
|
{
|
|
get { return _corpid; }
|
|
set { _corpid = value; }
|
|
}
|
|
/// <summary>
|
|
/// 详细信息
|
|
/// </summary>
|
|
public string Blcontent
|
|
{
|
|
get { return _blcontent; }
|
|
set { _blcontent = value; }
|
|
}
|
|
/// <summary>
|
|
/// 客户英文全称
|
|
/// </summary>
|
|
public string EnFullName
|
|
{
|
|
get { return _en_full_name; }
|
|
set { _en_full_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 所属单证
|
|
/// </summary>
|
|
public string Doc
|
|
{
|
|
get { return _doc; }
|
|
set { _doc = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否代理(国内)
|
|
/// </summary>
|
|
public bool IsAgentCN
|
|
{
|
|
get { return _is_agent_cn; }
|
|
set { _is_agent_cn = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否快递公司
|
|
/// </summary>
|
|
public bool IsExpress
|
|
{
|
|
get { return _is_express; }
|
|
set { _is_express = value; }
|
|
}
|
|
/// <summary>
|
|
/// 是否停用该客户信息
|
|
/// </summary>
|
|
public bool IsStop
|
|
{
|
|
get { return _is_stop; }
|
|
set { _is_stop = value; }
|
|
}
|
|
/// <summary>
|
|
/// 发票抬头1
|
|
/// </summary>
|
|
public string BillRises1
|
|
{
|
|
get { return _bill_rises1; }
|
|
set { _bill_rises1 = value; }
|
|
}
|
|
/// <summary>
|
|
/// 发票抬头2
|
|
/// </summary>
|
|
public string BillRises2
|
|
{
|
|
get { return _bill_rises2; }
|
|
set { _bill_rises2 = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美元支票抬头
|
|
/// </summary>
|
|
public string USDBillRises
|
|
{
|
|
get { return _usd_bill_rises; }
|
|
set { _usd_bill_rises = value; }
|
|
}
|
|
/// <summary>
|
|
/// 人民币支票抬头
|
|
/// </summary>
|
|
public string RMBBillRises
|
|
{
|
|
get { return _rmb_bill_rises; }
|
|
set { _rmb_bill_rises = value; }
|
|
}
|
|
/// <summary>
|
|
/// 人民币开户银行
|
|
/// </summary>
|
|
public string RMBBank
|
|
{
|
|
get { return _rmb_bank; }
|
|
set { _rmb_bank = value; }
|
|
}
|
|
/// <summary>
|
|
/// 人民币账户
|
|
/// </summary>
|
|
public string RMBAccount
|
|
{
|
|
get { return _rmb_account; }
|
|
set { _rmb_account = value; }
|
|
}
|
|
/// <summary>
|
|
/// 人民币联机行号
|
|
/// </summary>
|
|
public string RMBOnLineNO
|
|
{
|
|
get { return _rmb_online_no; }
|
|
set { _rmb_online_no = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美元开户银行
|
|
/// </summary>
|
|
public string USDBank
|
|
{
|
|
get { return _usd_bank; }
|
|
set { _usd_bank = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美元账号
|
|
/// </summary>
|
|
public string USDAccount
|
|
{
|
|
get { return _usd_account; }
|
|
set { _usd_account = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美元联机账号
|
|
/// </summary>
|
|
public string USDOnLineNO
|
|
{
|
|
get { return _usd_online_no; }
|
|
set { _usd_online_no = value; }
|
|
}
|
|
/// <summary>
|
|
/// 自定义属性1
|
|
/// </summary>
|
|
public string CustomAttributes1
|
|
{
|
|
get { return _custom_attribute1; }
|
|
set { _custom_attribute1 = value; }
|
|
}
|
|
/// <summary>
|
|
/// 自定义属性2
|
|
/// </summary>
|
|
public string CustomAttributes2
|
|
{
|
|
get { return _custom_attribute2; }
|
|
set { _custom_attribute2 = value; }
|
|
}
|
|
/// <summary>
|
|
/// 财务应收帐款代码
|
|
/// </summary>
|
|
public string FARCODE
|
|
{
|
|
get { return _FARCODE; }
|
|
set { _FARCODE = value; }
|
|
}
|
|
/// <summary>
|
|
/// 财务应付帐款代码
|
|
/// </summary>
|
|
public string FAPCODE
|
|
{
|
|
get { return _FAPCODE; }
|
|
set { _FAPCODE = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美元信用最大金额
|
|
/// </summary>
|
|
public decimal USDMaxAmountCredit
|
|
{
|
|
get { return _usd_max_amount_credit; }
|
|
set { _usd_max_amount_credit = value; }
|
|
}
|
|
/// <summary>
|
|
/// 人民币信用最大金额
|
|
/// </summary>
|
|
public decimal RMBMaxAmountCredit
|
|
{
|
|
get { return _rmb_max_amount_credit; }
|
|
set { _rmb_max_amount_credit = value; }
|
|
}
|
|
/// <summary>
|
|
/// 信用最大金额(RMB+USD)
|
|
/// </summary>
|
|
public decimal MaxAmountCredit
|
|
{
|
|
get { return _max_amount_credit; }
|
|
set { _max_amount_credit = value; }
|
|
}
|
|
/// <summary>
|
|
/// 结算方式
|
|
/// </summary>
|
|
public string StlName
|
|
{
|
|
get { return _stl_name; }
|
|
set { _stl_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 处理人
|
|
/// </summary>
|
|
public string OpName
|
|
{
|
|
get { return _op_name; }
|
|
set { _op_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 处理时间
|
|
/// </summary>
|
|
public DateTime OpTime
|
|
{
|
|
get { return _op_time; }
|
|
set { _op_time = value; }
|
|
}
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
public string Remark
|
|
{
|
|
get { return _remark; }
|
|
set { _remark = value; }
|
|
}
|
|
/// <summary>
|
|
/// 美金汇率
|
|
/// </summary>
|
|
public decimal USDExchangeRate
|
|
{
|
|
get { return _usd_exchange_rate; }
|
|
set { _usd_exchange_rate = value; }
|
|
}
|
|
/// <summary>
|
|
/// 月结时间
|
|
/// </summary>
|
|
public string StlDate
|
|
{
|
|
get { return _stl_date; }
|
|
set { _stl_date = value; }
|
|
}
|
|
/// <summary>
|
|
/// 上半月结时间
|
|
/// </summary>
|
|
public string StlFirstHalfDate
|
|
{
|
|
get { return _stl_first_half_date; }
|
|
set { _stl_first_half_date = value; }
|
|
}
|
|
/// <summary>
|
|
/// 下半月结时间
|
|
/// </summary>
|
|
public string StlMiddleDate
|
|
{
|
|
get { return _stl_middle_date; }
|
|
set { _stl_middle_date = value; }
|
|
}
|
|
/// <summary>
|
|
/// 运价级别
|
|
/// </summary>
|
|
public string StlDatePJ
|
|
{
|
|
get { return _stl_date_pj; }
|
|
set { _stl_date_pj = value; }
|
|
}
|
|
/// <summary>
|
|
/// 运价级别
|
|
/// </summary>
|
|
public string Level
|
|
{
|
|
get { return _level; }
|
|
set { _level = value; }
|
|
}
|
|
/// <summary>
|
|
/// 用户代码名
|
|
/// </summary>
|
|
public string LoginName
|
|
{
|
|
get { return _login_name; }
|
|
set { _login_name = value; }
|
|
}
|
|
/// <summary>
|
|
/// 登录密码
|
|
/// </summary>
|
|
public string LoginPassWord
|
|
{
|
|
get { return _login_password; }
|
|
set { _login_password = value; }
|
|
}
|
|
#endregion
|
|
}
|
|
}
|