using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     员工信息表
/// </summary>
[SugarTable("MES_STAFF")]
public class MesStaff
{
    /// <summary>
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     ID
    /// </summary>
    [SugarColumn(ColumnName = "id")]
    public decimal Id { get; set; }

    /// <summary>
    ///     员工编码
    /// </summary>
    [SugarColumn(ColumnName = "staff_no")]
    public string? StaffNo { get; set; }

    /// <summary>
    ///     员工姓名
    /// </summary>
    [SugarColumn(ColumnName = "staff_name")]
    public string? StaffName { get; set; }

    /// <summary>
    ///     部门编码
    /// </summary>
    [SugarColumn(ColumnName = "department_no")]
    public string? DepartmentNo { get; set; }

    /// <summary>
    ///     部门名称
    /// </summary>
    [SugarColumn(ColumnName = "department_name")]
    public string? DepartmentName { get; set; }

    /// <summary>
    ///     岗位编码
    /// </summary>
    [SugarColumn(ColumnName = "position_code")]
    public string? PositionCode { get; set; }

    /// <summary>
    ///     岗位名称
    /// </summary>
    [SugarColumn(ColumnName = "position_name")]
    public string? PositionName { get; set; }

    /// <summary>
    ///     手机号
    /// </summary>
    [SugarColumn(ColumnName = "phone_number")]
    public string? PhoneNumber { get; set; }

    /// <summary>
    ///     任岗开始日期
    /// </summary>
    [SugarColumn(ColumnName = "start_date")]
    public DateTime? StartDate { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string? Remark { get; set; }

    /// <summary>
    ///     自定义字段3
    /// </summary>
    [SugarColumn(ColumnName = "remark3")]
    public string? Remark3 { get; set; }

    /// <summary>
    ///     自定义字段4
    /// </summary>
    [SugarColumn(ColumnName = "remark4")]
    public string? Remark4 { get; set; }

    /// <summary>
    ///     自定义字段5
    /// </summary>
    [SugarColumn(ColumnName = "remark5")]
    public string? Remark5 { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "create_by")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "create_date")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     更新人
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_by")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     更新时间
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_date")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "memo")]
    public string? Memo { get; set; }

    /// <summary>
    ///     生产线
    /// </summary>
    [SugarColumn(ColumnName = "line_no")]
    public string? LineNo { get; set; }

    /// <summary>
    ///     生产员工标识
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "work_mk")]
    public int? WorkMk { get; set; }

    /// <summary>
    ///     是否禁用
    /// </summary>
    [SugarColumn(ColumnName = "fforbid_status")]
    public string? FforbidStatus { get; set; }

    /// <summary>
    ///     创建组织
    /// </summary>
    [SugarColumn(ColumnName = "Fumbrella")]
    public string? Fumbrella { get; set; }

    /// <summary>
    ///     使用组织
    /// </summary>
    [SugarColumn(ColumnName = "FSubsidiary")]
    public string? FSubsidiary { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}