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