using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OASystem.Domain.Entities.Groups { /// /// 团组信息表 /// [SugarTable("Grp_DelegationInfo")] public class Grp_DelegationInfo:EntityBase { /// /// 销售报价号 /// [SugarColumn(IsNullable =true,ColumnDataType = "varchar(50)")] public string SalesQuoteNo { get; set; } /// /// 销售日期 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime SalesDate { get; set; } /// /// 客户名称 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string ClientName { get; set; } /// /// 客户单位 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")] public string ClientUnit { get; set; } /// /// 团组号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string TourCode { get; set; } /// /// 团组名称 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")] public string TeamName { get; set; } /// /// 团组类型Id /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int TeamDid { get; set; } /// /// 出访时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime VisitDate { get; set; } /// /// 出团时间起 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime VisitStartDate { get; set; } /// /// 出团时间止 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime VisitEndDate { get; set; } /// /// 出访国家 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")] public string VisitCountry { get; set; } /// /// 出访目的 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string VisitPurpose { get; set; } /// /// 出访天数 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisitDays { get; set; } /// /// 出访人数 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisitPNumber { get; set; } /// /// 特殊需求 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")] public string SpecialNeeds { get; set; } /// /// 其他需求 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")] public string OtherNeeds { get; set; } /// /// 客户需求 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")] public string ClientNeeds { get; set; } /// /// 状态标识 /// [SugarColumn(IsNullable =true,ColumnDataType ="int")] public int IsState { get; set; } /// /// 接团操作人 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int JietuanOperator { get; set; } /// /// 接团操作时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime JietuanTime { get; set; } /// /// 团信息操作人 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int GroupsOperator { get; set; } /// /// 团信息操作时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime GroupsTime { get; set; } /// /// 预算成本 /// [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")] public decimal BudgetCost { get; set; } /// /// 是否操作完成 /// 0否1是 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsSure { get; set; } /// /// 预算成本时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime SureTime { get; set; } /// /// 手机号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string TellPhone { get; set; } /// /// 微信号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string WeChatNo { get; set; } /// /// 团组客户级别 /// 数据类型外键 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int TeamLevSId { get; set; } /// /// 酒店投诉标识 0-未投诉1-已投诉 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int HotelComplain { get; set; } /// /// OP投诉标识 0-未投诉1-已投诉 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int OPComplain { get; set; } /// /// 签证投诉标识 0-未投诉1-已投诉 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int VisaComplain { get; set; } /// /// 商邀投诉标识 0-未投诉1-已投诉 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int OAComplain { get; set; } /// /// 机票投诉标识 0-未投诉1-已投诉 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int AirComplain { get; set; } /// /// 团组负责人 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string Director { get; set; } /// /// 合同时间 /// [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")] public DateTime? TontractTime { get; set; } /// /// 是否用于投标 /// 0 否 1 是 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int IsBid { get; set; } /// /// 支付款项(预付) /// [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")] public decimal PaymentMoney { get; set; } /// /// 预付期限 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int PayDay { get; set; } /// /// 出国任务审批部门名称 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string CGRWSPBMMC { get; set; } /// /// 出国任务审批文号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string CGRWSPWH { get; set; } /// /// 政治审查部门名称 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string ZZSCBMMC { get; set; } /// /// 政治审查部门审批文号 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")] public string ZZSCSPWH { get; set; } #region 新增团组op提成等级 /// /// Op提成等级 /// [SugarColumn(IsNullable = true, ColumnDataType = "int")] public int OpRoyaltyLv { get; set; } /// /// 等级说明 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")] public string OpRoyaltyRemark { get; set; } /// /// 公务需求 /// [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")] public string Officialneeds { get; set; } #endregion } }