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