OA2023/OASystem/OASystem.Domain/Entities/Customer/Crm_DeleClient.cs

using OASystem.Domain.Attributes;

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>
        /// 客户公司Id
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "int")]
        public int CrmCompanyId { get; set; }

        /// <summary>
        /// 邮编
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string PostCodes { 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 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>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string GetUPPlace { 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, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<VisaRefusalRecord> RefusalRecords { get; set; } = new List<VisaRefusalRecord>();
        /// <summary>
        /// 出行历史
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<TravelHistory> TravelHistories { get; set; } = new List<TravelHistory>();
        /// <summary>
        /// 军事信息
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<MilitaryInfo> Militaries { get; set; } = new List<MilitaryInfo>();
        /// <summary>
        /// 已出访的国家
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<CountryVisited> CountryVisiteds { get; set; } = new List<CountryVisited>();
        /// <summary>
        /// 申根签证记录
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<SchengenVisaRecord> SchengenVisaRecords { get; set; } = new List<SchengenVisaRecord>();
        /// <summary>
        /// 社交账号
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<SocialAccount> SocialAccounts { get; set; } = new List<SocialAccount>();
        /// <summary>
        /// 亲属朋友信息
        /// </summary>
        [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
        public List<PersonInfo> PersonInfos { get; set; } = new List<PersonInfo>();


        /// <summary>
        /// 赴美目的
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
        public string USAPurpose { get; set; }

        /// <summary>
        /// 是否曾获得过因公美国签证 0否1是
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "int")]
        public int IsUSAVia { get; set; }

        /// <summary>
        /// 因公美国签证最近获得时间 / 有效期
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
        public DateTime? GetUSAVisaDate { 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 IsFinger { get; set; } = 0;
        /// <summary>
        /// 申根指纹录入时间
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
        public DateTime? FingerDate { 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(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 = "varchar(500)")]
        public string DivorceRsn { 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(100)")]
        public string USAContact‌ { get; set; }

        /// <summary>
        /// 美国联系人电话
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string USAContact‌Tel‌ { get; set; }
        /// <summary>
        /// 美国联系人邮箱
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string USAContact‌Email { 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 = "DateTime")]
        public DateTime? USAImmVisa‌Date { get; set; }
        /// <summary>
        /// 美国移民签证地点
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string USAImmVisa‌Place { 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 string ServeDuration { get; set; }

    }

    /// <summary>
    /// 拒签记录
    /// </summary>
    public class VisaRefusalRecord
    {
        public string Country { get; set; }

        public DateTime? Date { get; set; }
        public string Address { get; set; }

        public string VisaType { get; set; }

        public string Reason { get; set; }
    }

    /// <summary>
    /// 旅行历史
    /// </summary>
    public class TravelHistory
    {
        public string Country { get; set; }

        public DateTime? ArrivalDate { get; set; }

        public DateTime? DepartureDate { get; set; }

        public string VisaType { get; set; }
    }

    /// <summary>
    /// 已出访的国家
    /// </summary>
    public class CountryVisited
    {
        public string Country { get; set; }

        public string VisitDate { get; set; }
    }

    /// <summary>
    /// 定义申根签证记录类
    /// </summary>
    public class SchengenVisaRecord
    {
        public string VisaType { get; set; }        // 签证类型
        public string VisaNumber { get; set; }      // 签证号码
        public DateTime? IssueDate { get; set; }     // 签发日期
        public DateTime? ExpiryDate { get; set; }    // 有效期至
        //public string IssuingCountry { get; set; }  // 签发国家
    }

    /// <summary>
    /// 定义社交账号类
    /// </summary>
    public class SocialAccount
    {
        public string Platform { get; set; }       // 平台名称
        public string Account { get; set; }    // 账号
    }

    /// <summary>
    /// 亲属朋友信息
    /// </summary>
    public class PersonInfo
    {
        /// <summary>
        /// 类型（亲属/朋友/联系人）
        /// </summary>
        public string Type { get; set; }
        public string Name { get; set; }       // 姓名
        public DateTime? BirthDay { get; set; }
        public string Address { get; set; }   // 地址
        public string ContactInfo { get; set; } // 联系方式
    }

}