| | |
| | | public class MesStaff |
| | | { |
| | | /// <summary> |
| | | /// ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] |
| | | /// |
| | | /// 默认值: (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")] |
| | | /// 员工编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "staff_no")] |
| | | public string? StaffNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 员工姓名 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STAFF_NAME")] |
| | | /// 员工姓名 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "staff_name")] |
| | | public string? StaffName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 部门编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPARTMENT_NO")] |
| | | /// 部门编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "department_no")] |
| | | public string? DepartmentNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 部门名称 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPARTMENT_NAME")] |
| | | /// 部门名称 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "department_name")] |
| | | public string? DepartmentName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 岗位编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "POSITION_CODE")] |
| | | /// 岗位编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "position_code")] |
| | | public string? PositionCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 岗位名称 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "POSITION_NAME")] |
| | | /// 岗位名称 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "position_name")] |
| | | public string? PositionName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 手机号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PHONE_NUMBER")] |
| | | /// 手机号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "phone_number")] |
| | | public string? PhoneNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任岗开始日期 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "START_DATE")] |
| | | /// 任岗开始日期 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "start_date")] |
| | | public DateTime? StartDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK")] |
| | | /// 备注 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark")] |
| | | public string? Remark { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段1 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段2 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段3 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK3")] |
| | | /// 自定义字段3 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark3")] |
| | | public string? Remark3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段4 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK4")] |
| | | /// 自定义字段4 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark4")] |
| | | public string? Remark4 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段5 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK5")] |
| | | /// 自定义字段5 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark5")] |
| | | public string? Remark5 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 创建人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_BY")] |
| | | /// 创建人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "create_by")] |
| | | public string? CreateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 创建时间 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_DATE")] |
| | | /// 创建时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "create_date")] |
| | | public DateTime? CreateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 更新人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LASTUPDATE_BY")] |
| | | /// 更新人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "lastupdate_by")] |
| | | public string? LastupdateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 更新时间 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LASTUPDATE_DATE")] |
| | | /// 更新时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "lastupdate_date")] |
| | | public DateTime? LastupdateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MEMO")] |
| | | /// 备注 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "memo")] |
| | | public string? Memo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产线 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINE_NO")] |
| | | /// 生产线 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "line_no")] |
| | | public string? LineNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产员工标识 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WORK_MK")] |
| | | public decimal? WorkMk { get; set; } |
| | | /// 生产员工标识 |
| | | /// 默认值: ((1)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "work_mk")] |
| | | public int? WorkMk { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否禁用 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FFORBID_STATUS")] |
| | | /// 是否禁用 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "fforbid_status")] |
| | | public string? FforbidStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使用組織 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 創建組織 |
| | | /// </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; } |
| | | } |