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_CustomerCert")] public class Crm_CustomerCert:EntityBase { /// /// 客户信息表Id /// [SugarColumn(IsNullable =true,ColumnDataType ="int")] public int DcId { get; set; } /// /// 证件类型表Id /// 773 身份证 774 护照 775 学生证 776 军人证 777 回乡证 778 台胞证 779 港澳通行证 780 国际海员证 781 外国人永久居留证 782 旅行证 783 台湾通行证 784 港澳台居住证 785 其他 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int SdId { get; set; } /// /// 护照类型 Id(数据类型表Id) /// SdId == 774 该字段有值 使用stid=74的值 /// 1010 外交护照 1011 公务护照 1012 因公普通护照 1013 因私普通护照 1014 特区护照 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int PassportType { get; set; } = 0; /// /// 证件号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] [Encrypted] public string CertNo { get; set; } /// /// 签发国 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string Country { get; set; } /// /// 签发地区 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string Area { get; set; } /// /// 目的地国家 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string TargetCountry { get; set; } /// /// 有效期起始时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime? IssueDt { get; set; } = null; /// /// 有效期截止时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime? ExpiryDt { get; set; } = null; /// /// 身份证户籍地址 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")] public string IDCardAddress { get; set; } } }