using OASystem.Domain.Attributes;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace OASystem.Domain.Entities.Customer
{
///
/// 客户信息表
///
[SugarTable("Crm_DeleClient")]
public class Crm_DeleClient : EntityBase
{
///
/// 团组Id
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int DiId { get; set; }
///
/// 中文姓
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
[Encrypted]
public string LastName { get; set; }
///
/// 中文名
///
[Encrypted]
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string FirstName { get; set; }
///
/// 曾用名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string OldName { get; set; }
///
/// 名字拼音
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
[Encrypted]
public string Pinyin { get; set; }
///
/// 性别
/// 0男1女 -1未选择
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int Sex { get; set; } = -1;
///
/// 婚姻状况 0、1、2、3、4 (未设置、未婚、已婚、离异、丧偶)
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int Marriage { get; set; } = 0;
///
/// 客户手机号
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
[Encrypted]
public string Phone { get; set; } = "";
///
/// 出生省份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string BirthProvince { get; set; }
///
/// 出生城市
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string BirthCity { get; set; }
///
/// 出生日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "datetime")]
public DateTime? BirthDay { get; set; } = null;
///
/// 机票喜好舱位
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string AirType { get; set; }
///
/// 是否靠窗
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int SeatPref { get; set; }
///
/// 机票备注
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string AirRemark { get; set; }
///
/// 酒店喜好房型
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string RoomType { get; set; }
///
/// 酒店需求
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string RoomPref { get; set; }
///
/// 家庭联系方式
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string Tel { get; set; }
///
/// 客户电子邮件
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string Email { get; set; }
///
/// 住址
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string Address { get; set; }
///
/// 最高学历
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string HighestEducation { get; set; }
///
/// 邮编
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string PostCodes { get; set; }
///
/// 客户公司Id
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int CrmCompanyId { get; set; }
///
/// 职位
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
[Encrypted]
public string Job { get; set; }
///
/// 本人工作内容
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string WorkState { get; set; }
///
/// 入职时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "Datetime")]
public string WorkDate { get; set; }
///
/// 薪资
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string Wage { get; set; }
///
/// (单位/部门)电话
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string ClientPhone { get; set; }
///
/// (单位/部门)传真
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string ClientFax { get; set; }
///
/// (单位/部门)邮箱
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string ClientEmail { get; set; }
///
/// (单位/部门)负责人姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string ClientLeader { get; set; }
///
/// (单位/部门)负责人职务
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string ClientLeaderJob { get; set; }
///
/// 是否有获批的申根签证
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsGetSchengen { get; set; } = 0;
///
/// 申根有效期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime StartTime { get; set; }
///
/// 申根有效期
///
[SugarColumn(IsNullable = true, ColumnDataType = "Datetime")]
public DateTime EndTime { get; set; }
///
/// 申根是否在使馆有指纹记录
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsFinger { get; set; } = 0;
///
/// 申根指纹录入时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime FingerDate { get; set; }
///
/// 是否因公去过美国/加拿大
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsVisitUC { get; set; } = 0;
///
/// 美国抵达日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime? USADate { get; set; }
///
/// 美国停留天数
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int? USADays { get; set; } = 0;
///
/// 加拿大抵达日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime CanDate { get; set; }
///
/// 加拿大停留天数
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int CanDays { get; set; } = 0;
///
/// 是否曾获得过因公美国签证 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsUSAVia { get; set; }
///
/// 因公美国签证最近获得时间
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime GetUSAVisaDate { get; set; }
///
/// 因公美国签证地点
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string GetUPPlace { get; set; }
///
/// 因公美国签证种类
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAVisaCate { get; set; }
///
/// 因公美国签证编码
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAVisaCode { get; set; }
///
/// 是否在使馆留过十指的指纹 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int USAFinger { get; set; } = 0;
///
/// 是否曾经被拒签 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsRejected { get; set; } = 0;
///
/// 被拒时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime? RejectedDate { get; set; }
///
/// 被拒地点
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string RejectedPlace { get; set; }
///
/// 被拒签证种类
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string RejectedVisa { get; set; }
///
/// 美国签证是否被吊销过 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsRevoke { get; set; } = 0;
///
/// 护照是否曾经丢失 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsLose { get; set; } = 0;
///
/// 丢失护照时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime LoseDate { get; set; }
///
/// 丢失护照编号
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string LoseCode { get; set; }
///
/// 丢失的护照是否有美国签证 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsUSAVisa { get; set; } = 0;
///
/// 夫/妻是否已在美国
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int MateUSA { get; set; } = 0;
///
/// 夫/妻身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MateIden { get; set; }
///
/// 未婚夫/妻是否已在美国 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int WHUSA { get; set; } = 0;
///
/// 未婚夫/妻身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string WHIden { get; set; }
///
/// 父/母是否已在美国
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int ParentUSA { get; set; } = 0;
///
/// 父/母身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string ParentIden { get; set; }
///
/// 子/女是否已在美国 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int ChildUSA { get; set; } = 0;
///
/// 子/女身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string ChildIden { get; set; }
///
/// 兄弟/姐妹是否已在美国 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int BroUSA { get; set; } = 0;
///
/// 兄弟/姐妹身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string BroIden { get; set; }
///
/// 所属/捐助/工作过的职业协会、社会团体和慈善机构
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string Social { get; set; }
///
/// 是否参军
/// 0否1是
///
[SugarColumn(IsNullable = true, ColumnDataType = "int")]
public int IsArmy { get; set; } = 0;
///
/// 参军详情
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string ArmyState { get; set; }
///
/// 在外期间费用承担人
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string CostBearers { get; set; }
///
/// 填表经办人
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string TableOpName { get; set; }
///
/// 填表经办人联系电话
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string TableOpTel { get; set; }
///
/// 填表日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime TableDate { get; set; }
///
/// 所属党派或宗教
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string Party { get; set; }
///
/// 国籍
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
public string Nationality { get; set; }
///
/// 结婚日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime? WeddingDate { get; set; }
///
/// 离婚日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime? DivorceDate { get; set; }
///
/// 配偶姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MateName { get; set; }
///
/// 配偶出生日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime MateBirthDay { get; set; }
///
/// 配偶出生城市
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MateBirthCity { get; set; }
///
/// 配偶出生国家省份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MateBirthCountry { get; set; }
///
/// 配偶住址
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string MateAddress { get; set; }
///
/// 配偶工作单位
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string MateClient { get; set; }
///
/// 配偶工作单位地址
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string MateClientAddress { get; set; }
///
/// 配偶职务
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MateJob { get; set; }
///
/// 因公出访国家
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string VisitCountry { get; set; }
///
/// 发表的期刊/论文
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string Paper { get; set; }
///
/// 专利
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string Papent { get; set; }
///
/// 发表的博士论文
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string PhD { get; set; }
//----------增加字段------------
///
/// 离婚原因
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
public string DivorceRsn { get; set; }
///
/// 美国驾照No
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USA_DLNo { get; set; }
///
/// 美国驾照签发地
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USA_DLPlace { get; set; }
///
/// 美国社会安全号或者纳税ID号
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USA_SSNOrITIN { get; set; }
///
/// 是否是其他国家的永久居民
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string Resident { get; set; }
///
/// 近五年内是否使用过任何社交账号
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
public string HasSocialAcc { get; set; }
///
/// 请提供美国详细住址
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
public string USAAddress { get; set; }
///
/// 赴美目的
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
public string USAPurpose { get; set; }
///
/// 美国联系人或组织
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USAContact { get; set; }
///
/// 美国联系人电话
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAContactTel { get; set; }
///
/// 美国联系人邮箱
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAContactEmail { get; set; }
///
/// 赴美的到达城市
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USAArrivalCity { get; set; }
///
/// 赴美的离开城市
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USADepartCity { get; set; }
///
/// 计划在美国访问的景点
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USAVisitSites { get; set; }
///
/// 赴美同行人姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USACmpName { get; set; }
///
/// 赴美同行人关系
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string USACmpRelation { get; set; }
///
/// 过去5年内到过的国家
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string Cntry5Y { get; set; }
///
/// 签时能流利交流的语言
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
public string LangSkill { get; set; }
///
/// 曾被哪些国家拒签/拒签原因
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
public string DenyNationRsn { get; set; }
///
/// 曾抵达过美国时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAHadArrival { get; set; }
///
/// 曾停留美国天数
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
public string USAHadDays { get; set; }
///
/// 美国移民签证时间
///
[SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
public DateTime? USAImmVisaDate { get; set; }
///
/// 美国移民签证地点
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAImmVisaPlace { get; set; }
///
/// 美国移民签证种类
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAImmVisa { get; set; }
///
/// 直系亲属在美国 姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAImmedFamName { get; set; }
///
/// 直系亲属在美国 关系
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAImmedFamRel { get; set; }
///
/// 直系亲属在美国 身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAImmedFamStat { get; set; }
///
/// 旁系亲属在美国 姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAUncleFamName { get; set; }
///
/// 旁系亲属在美国 关系
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAUncleFamRel { get; set; }
///
/// 旁系亲属在美国 身份
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string USAUncleFamStat { get; set; }
///
/// 父亲姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string FthName { get; set; }
///
/// 父亲出生日期
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public DateTime? FthBirth { get; set; }
///
/// 母亲姓名
///
[SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
public string MthName { get; set; }
///
/// 母亲出生日期
///
[SugarColumn( IsNullable = true, ColumnDataType = "varchar(50)")]
public DateTime? MthBirth { get; set; }
}
public class GroupClints
{
public int Id { get; set; }
public string Name { get; set; }
///
/// 是否陪同
/// 1 否 2 是
/// 默认:1
///
public int IsAccompany { get; set; }
[Encrypted]
public string CompanyFullName { get; set; }
}
///
/// 军事信息
///
public class MilitaryInfo
{
///
/// 军种(陆军/海军/空军等)
///
public string MilBranch { get; set; }
///
/// 军衔(列兵/上校等)
///
public string MilRank { get; set; }
///
/// 军事特长(狙击/医疗等)
///
public string MilSkill { get; set; }
///
/// 服役时间(单位:xxxx年xx月xx日) 起
///
public DateTime? ServeTimeBegin { get; set; }
///
/// 服役时间(单位:xxxx年xx月xx日)止
///
public DateTime? ServeTimeEnd { get; set; }
}
}