| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// 工单指令表 |
| | | /// </summary> |
| | |
| | | /// <summary> |
| | | /// 自增列 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, IsIdentity = true)] |
| | | public decimal Id { get; set; } |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] |
| | | public decimal? Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// PID |
| | | /// 排产ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PID")] |
| | | public decimal? Pid { get; set; } |
| | |
| | | public string? Daa001 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产品编码 |
| | | /// 产品ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DAA002")] |
| | | public string? Daa002 { get; set; } |
| | |
| | | public string? Daa005 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 预计开工时间 |
| | | /// ERP预计开工时间 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DAA006")] |
| | | public DateTime? Daa006 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 预计完工时间 |
| | | /// ERP预计完工时间 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DAA007")] |
| | | public DateTime? Daa007 { get; set; } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DAA028")] |
| | | public string? Daa028 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 标准工时 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PROD_HOUR")] |
| | | public decimal? ProdHour { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单人小时产能 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")] |
| | | public decimal? PersonHourCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 理论标产 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_CAPACITY")] |
| | | public decimal? TheCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计划用人数 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PLAN_PERSONNEL")] |
| | | public decimal? PlanPersonnel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计划标准产能 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PLAN_CAPACITY")] |
| | | public decimal? PlanCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 理论用时/M |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_MIN")] |
| | | public decimal? TheMin { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 理论用时/H |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_HOUR")] |
| | | public decimal? TheHour { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 线体类别 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "LINE_TYPE")] |
| | | public string? LineType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 标准人数 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PERSONNEL")] |
| | | public decimal? Personnel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 换线时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CHANGE_LINE_TIME")] |
| | | public decimal? ChangeLineTime { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 休息时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "REST_TIME")] |
| | | public decimal? RestTime { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 排产序号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "SCHEDULE_ORDER")] |
| | | public decimal? ScheduleOrder { get; set; } |
| | | |
| | | /// <summary> |
| | | /// MES预计开工时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MES_START_PROD")] |
| | | public DateTime? MesStartProd { get; set; } |
| | | |
| | | /// <summary> |
| | | /// MES预计完工时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MES_END_PROD")] |
| | | public DateTime? MesEndProd { get; set; } |
| | | } |
| | | } |