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; }
}
}