using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OASystem.Domain.Entities.Groups { /// /// 签证进度表 /// [SugarTable("Grp_VisaProgress")] public class Grp_VisaProgress : EntityBase { /// /// 团组表Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int DiId { get; set; } /// /// 国家 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string Country { get; set; } /// /// 收集资料 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string GetData { get; set; } /// /// 收集资料时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime GetDataTime { get; set; } /// /// 取护照 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string GetPassport { get; set; } /// /// 取护照时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime GetPassportTime { get; set; } /// /// 填资料 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string FillData { get; set; } /// /// 填资料时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime FillDataTime { get; set; } /// /// 送签 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string SendVisa { get; set; } /// /// 送签时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime SendVisaTime { get; set; } /// /// 出签 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string SignOut { get; set; } /// /// 出签时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime SignOutTime { get; set; } /// /// 归还护照 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string SendBackPassport { get; set; } /// /// 归还护照时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public string SendBackPassporTime { get; set; } /// /// 护照接收者 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string Receiver { get; set; } } /// /// 签证进度客户表 /// 同团组下同一客户在不同国家数据是重复的 /// [SugarTable("Grp_VisaProgressCustomer")] public class Grp_VisaProgressCustomer : EntityBase { /// /// 团组表Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int DiId { get; set; } /// /// 客户表Id /// DeleClient.Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int CustomerId { get; set; } /// /// 客户姓 /// 正式使用新版OA后弃用 /// [SugarColumn(IsNullable = false, ColumnDataType = "varchar(50)")] public string LastName { get; set; } /// /// 客户名 /// 正式使用新版OA后弃用 /// [SugarColumn(IsNullable = false, ColumnDataType = "varchar(50)")] public string FirstName { get; set; } /// /// 签证国家 /// [SugarColumn(IsNullable = false, ColumnDataType = "varchar(50)")] public string Country { get; set; } /// /// 该国家签证进度 /// 0:未完成,1:已完成,2:忽略,3:签证未通过 /// [SugarColumn(IsNullable = false, ColumnDataType = "int")] public int WorkStatus { get; set; } /// /// 最后操作人Id /// 新增时为空 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int LastOperatorId { get; set; } /// /// 最后操作时间 /// 新增时为空 /// [SugarColumn(IsNullable = true, ColumnDataType = "datetime")] public DateTime LastOperatorDt { get; set; } } public enum Enum_DelegationVisaPicType { [Description("护照首页")] FirstPage, [Description("批件")] Documents, [Description("免签证明")] Exemption, [Description("派遣函红头文件")] Dispatch, [Description("签证页")] Visa, [Description("发票")] Invoice } [SugarTable("Grp_VisaProgressCustomerPicture")] public class Grp_VisaProgressCustomerPicture : EntityBase { /// /// 签证进度客户表Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisaProgressCustomerId { get; set; } /// /// 图片名称 /// [SugarColumn(IsNullable = false, ColumnDataType = "varchar(100)")] public string PicName { get; set; } /// /// 图片路径 /// [SugarColumn(IsNullable = false, ColumnDataType = "nvarchar(200)")] public string PicPath { get; set; } /// /// 图片所属签证上传类型 /// 0:护照首页 /// 1:批件 /// 2:免签证明 /// 3:派遣函红头文件 /// 4:签证页 /// 5:发票 /// [SugarColumn(IsNullable = false, ColumnDataType = "int")] public Enum_DelegationVisaPicType PicType { get; set; } } }