AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/S0/Warehouse/AdoS0EmployeeMaster.cs

namespace Admin.NET.Plugin.AiDOP.Entity.S0.Warehouse;

/// <summary>
/// 雇员主数据（复刻 EmployeeMaster）
/// </summary>
[SugarTable("EmployeeMaster", "雇员主数据（复刻 EmployeeMaster）")]
[SugarIndex("uk_EmployeeMaster_domain_employee", nameof(DomainCode), OrderByType.Asc, nameof(Employee), OrderByType.Asc, IsUnique = true)]
public class AdoS0EmployeeMaster : ITenantIdFilter
{
    [SugarColumn(ColumnName = "RecID", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "company_ref_id", ColumnDescription = "关联公司 ID", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnName = "factory_ref_id", ColumnDescription = "关联工厂 ID", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnName = "Domain", ColumnDescription = "工厂域编码", Length = 50)]
    public string DomainCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "Employee", ColumnDescription = "员工编码", Length = 100)]
    public string Employee { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "Name", ColumnDescription = "姓名", Length = 200, IsNullable = true)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "Sex", ColumnDescription = "性别", Length = 10, IsNullable = true)]
    public string? Sex { get; set; }

    [SugarColumn(ColumnName = "Phone", ColumnDescription = "电话", Length = 50, IsNullable = true)]
    public string? Phone { get; set; }

    [SugarColumn(ColumnName = "Email", ColumnDescription = "邮箱", Length = 200, IsNullable = true)]
    public string? Email { get; set; }

    [SugarColumn(ColumnName = "BirthDate", ColumnDescription = "出生日期", IsNullable = true)]
    public DateTime? BirthDate { get; set; }

    [SugarColumn(ColumnName = "Department", ColumnDescription = "部门编码", Length = 100, IsNullable = true)]
    public string? Department { get; set; }

    [SugarColumn(ColumnName = "DateEmployed", ColumnDescription = "入职日期", IsNullable = true)]
    public DateTime? DateEmployed { get; set; }

    [SugarColumn(ColumnName = "EmploymentStatus", ColumnDescription = "在职状态", Length = 50, IsNullable = true)]
    public string? EmploymentStatus { get; set; }

    [SugarColumn(ColumnName = "MaritalStatus", ColumnDescription = "婚姻状况", Length = 50, IsNullable = true)]
    public string? MaritalStatus { get; set; }

    [SugarColumn(ColumnName = "JobTitle", ColumnDescription = "岗位", Length = 100, IsNullable = true)]
    public string? JobTitle { get; set; }

    [SugarColumn(ColumnName = "DateTerminated", ColumnDescription = "离职日期", IsNullable = true)]
    public DateTime? DateTerminated { get; set; }

    [SugarColumn(ColumnName = "WorkCtr", ColumnDescription = "工作中心", Length = 100, IsNullable = true)]
    public string? WorkCtr { get; set; }

    [SugarColumn(ColumnName = "CarId", ColumnDescription = "工号/卡号", Length = 100, IsNullable = true)]
    public string? CarId { get; set; }

    [SugarColumn(ColumnName = "DefaultWorkLocation", ColumnDescription = "默认工作地点", Length = 100, IsNullable = true)]
    public string? DefaultWorkLocation { get; set; }

    [SugarColumn(ColumnName = "City", ColumnDescription = "城市", Length = 100, IsNullable = true)]
    public string? City { get; set; }

    [SugarColumn(ColumnName = "Country", ColumnDescription = "国家", Length = 100, IsNullable = true)]
    public string? Country { get; set; }

    [SugarColumn(ColumnName = "BusinessPhone", ColumnDescription = "业务电话", Length = 50, IsNullable = true)]
    public string? BusinessPhone { get; set; }

    [SugarColumn(ColumnName = "IsActive", ColumnDescription = "是否启用", ColumnDataType = "boolean")]
    public bool IsActive { get; set; } = true;

    [SugarColumn(ColumnName = "CreateUser", ColumnDescription = "创建人", Length = 100, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "CreateTime", ColumnDescription = "创建时间")]
    public DateTime CreateTime { get; set; } = DateTime.Now;

    [SugarColumn(ColumnName = "UpdateUser", ColumnDescription = "更新人", Length = 100, IsNullable = true)]
    public string? UpdateUser { get; set; }

    [SugarColumn(ColumnName = "UpdateTime", ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdateTime { get; set; }

    [SugarColumn(ColumnName = "sys_user_id", ColumnDescription = "关联系统账号ID（SysUser.Id；为空表示未绑定）", ColumnDataType = "bigint", IsNullable = true)]
    public long? SysUserId { get; set; }

    /// <summary>列表展示：部门说明（不落库，来自 DepartmentMaster 关联）</summary>
    [SugarColumn(IsIgnore = true)]
    public string? DepartDescr { get; set; }

    /// <summary>列表展示：岗位名称（不落库，来自 GeneralizedCodeMaster 翻译）</summary>
    [SugarColumn(IsIgnore = true)]
    public string? JobTitleDisplay { get; set; }

    [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
    public long? TenantId { get; set; }
}