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

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_CustomerCert")]
    public class Crm_CustomerCert:EntityBase
    {
        /// <summary>
        /// 客户信息表Id
        /// </summary>
        [SugarColumn(IsNullable =true,ColumnDataType ="int")]
        public int DcId { get; set; }

        /// <summary>
        /// 证件类型表Id
        /// 773	身份证 774	护照 775	学生证 776	军人证 777	回乡证 778	台胞证 779	港澳通行证 780	国际海员证 781	外国人永久居留证 782	旅行证 783	台湾通行证 784	港澳台居住证 785	其他
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "int")]
        public int SdId { get; set; }

        /// <summary>
        /// 护照类型 Id(数据类型表Id)
        /// SdId == 774 该字段有值 使用stid=74的值
        /// 1010 外交护照 1011 公务护照 1012 因公普通护照 1013 因私普通护照 1014 特区护照
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "int")]
        public int PassportType { get; set; } = 0;

        /// <summary>
        /// 证件号
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
        [Encrypted]
        public string CertNo { get; set; }
        /// <summary>
        /// 签发国
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string Country { get; set; }
        
        /// <summary>
        /// 签发地区
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string Area { get; set; }

        /// <summary>
        /// 目的地国家
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
        public string TargetCountry { get; set; }

        /// <summary>
        /// 有效期起始时间
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
        public DateTime? IssueDt { get; set; } = null;
        /// <summary>
        /// 有效期截止时间
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
        public DateTime? ExpiryDt { get; set; } = null;

        /// <summary>
        /// 身份证户籍地址
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
        public string IDCardAddress { get; set; }
    }

}