| | |
| | | using SqlSugar; |
| | | |
| | | namespace NewPdaSqlServer.entity |
| | | namespace NewPdaSqlServer.entity; |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | [SugarTable("MES_STAFF")] |
| | | public class MesStaff |
| | | { |
| | | /// <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 int 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; } |
| | | } |
| | | } |
| | | /// 默认值: (newid()) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] |
| | | public Guid Guid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "id")] |
| | | public int 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; } |
| | | } |