using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OASystem.Domain.Entities.Groups { /// /// 团组倒推表 /// Is....: 0 是 1 否 /// A:自然日 B:工作日 /// [SugarTable("Grp_InvertedList")] public class Grp_InvertedList : EntityBase { /// /// 团组Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int DiId { get; set; } /// /// 报批资料准备时间 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string ApprovalDataDt { get; set; } /// /// 报批资料准备 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsApprovalData { get; set; } = 1; /// /// 报批资料准备 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string ApprovalDataRemark { get; set; } = "准备报批资料(包括:邀请函,请示,报批行程,报批费用)"; /// /// 报批时间 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string ApprovalDt { get; set; } /// /// 报批时间 /// 1 预批件 2 正常批件 默认值??-1 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int ApprovalType { get; set; } /// /// 报批 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsApproval { get; set; } = 1; /// /// 报批 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string ApprovalRemark { get; set; } = "客户准备报批资料并递交到省外办,同时我司开始收集客户签证需要的资料"; /// /// 出批件时间 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string IssueApprovalDt { get; set; } /// /// 出批件 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsIssueApproval { get; set; } = 1; /// /// 出批件 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string IssueApprovalRemark { get; set; } = "出预批件、制作护照-护照出"; /// /// 办护照时间 - B /// 弃用 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string ApplyPassportDt { get; set; } /// /// 办护照 /// 是否完成 /// 弃用 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsApplyPassport { get; set; } = 1; /// /// 办护照 /// 备注 /// 弃用 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string ApplyPassportRemark { get; set; } /// /// 签证资料准备时间 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string VisaInformationDt { get; set; } /// /// 签证资料准备 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsVisaInformation { get; set; } = 1; /// /// 签证资料准备 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string VisaInformationRemark { get; set; } = "汇总客户签证信息,准备送签资料"; /// /// 送签时间 - B /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string SendVisaDt { get; set; } /// /// 送签 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsSendVisa { get; set; } = 1; /// /// 送签 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string SendVisaRemark { get; set; } = "签证周期暂无或免签\r\n(签证周期仅供参考)"; /// /// 出签时间 - B /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string IssueVisaDt { get; set; } /// /// 出签 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsIssueVisa { get; set; } = 1; /// /// 出签 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string IssueVisaRemark { get; set; } = "外办领取签证"; /// /// 机票 - B /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string AirTicketDt { get; set; } /// /// 机票 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsAirTicket { get; set; } = 1; /// /// 机票 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string AirTicketRemark { get; set; } = "机票预订、出票、值机"; /// /// 酒店 - B /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string HotelDt { get; set; } /// /// 酒店 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsHotel { get; set; } = 1; /// /// 酒店 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string HotelRemark { get; set; } = "酒店确认、预订、确认号"; /// /// 行前会 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string PreTripMeetingDt { get; set; } /// /// 行前会 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsPreTripMeeting { get; set; } = 1; /// /// 行前会 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string PreTripMeetingRemark { get; set; } = "开行前会为出访人员交代细节"; /// /// 送机 - A /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")] public string AirportdDropOffDt { get; set; } /// /// 送机 /// 是否完成 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsAirportdDropOff { get; set; } = 1; /// /// 送机 /// 备注 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string AirportdDropOffRemark { get; set; } = "为出访人员办理登机服务及行李打包等"; #region 每项是否选中 0 false 1 true /// /// 送机 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedAirportd { get; set; } = true; /// /// 报批/提供送签资料 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedApprovalData { get; set; } = true; /// /// 出批件 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedIssueApproval { get; set; } = true; /// /// 签证资料准备 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedVisaInfo { get; set; } = true; /// /// 送签签证 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedSendVisa { get; set; } = true; /// /// 出签 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedIssueVisa { get; set; } = true; /// /// 机票 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedAirTicket { get; set; } = true; /// /// 酒店 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedHotel { get; set; } = true; /// /// 行前会 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedPreTripMeeting { get; set; } = true; /// /// 送机 是否选中 /// [SugarColumn(IsNullable = true, ColumnDataType = "bit")] public bool IsSelectedAirportdDropOff { get; set; } = true; #endregion } /// /// 倒推表签证 国家信息 /// (数据来源:签证标准费用表 默认值) /// [SugarTable("Grp_InvertedListVisaCountry")] public class Grp_InvertedListVisaCountry : EntityBase { /// /// 倒推表Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int ILId { get; set; } /// /// 国家 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")] public string Country { get; set; } /// /// 公务类型ID /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int OfficialTypeId { get; set; } /// /// 签证类型ID /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisaTypeId { get; set; } /// /// 签证时间(工作日) /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisaDay { get; set; } } }