| | |
| | | using SqlSugar; |
| | | using System.ComponentModel; |
| | | using System.ComponentModel; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes |
| | | namespace MES.Service.Modes; |
| | | |
| | | [SugarTable("MES_ITEM_QT_DATALL")] |
| | | public class MesItemQtDatall |
| | | { |
| | | [SugarTable("MES_ITEM_QT_DATALL")] |
| | | public class MesItemQtDatall |
| | | { |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_QTCKD")] |
| | | [Description("ID")] |
| | | public decimal Id { get; set; } |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, |
| | | OracleSequenceName = "SEQ_QTCKD")] |
| | | [Description("ID")] |
| | | public decimal Id { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "MID")] |
| | | [Description("MID")] |
| | | public decimal Mid { get; set; } |
| | | [SugarColumn(ColumnName = "MID")] |
| | | [Description("MID")] |
| | | public decimal Mid { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD001")] |
| | | [Description("工单号")] |
| | | public string Qd001 { get; set; } |
| | | [SugarColumn(ColumnName = "QD001")] |
| | | [Description("工单号")] |
| | | public string Qd001 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD002")] |
| | | [Description("物料编号")] |
| | | public string Qd002 { get; set; } |
| | | [SugarColumn(ColumnName = "QD002")] |
| | | [Description("物料编号")] |
| | | public string Qd002 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD003")] |
| | | [Description("物料名称")] |
| | | public string Qd003 { get; set; } |
| | | [SugarColumn(ColumnName = "QD003")] |
| | | [Description("物料名称")] |
| | | public string Qd003 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD004")] |
| | | [Description("规格型号")] |
| | | public string Qd004 { get; set; } |
| | | [SugarColumn(ColumnName = "QD004")] |
| | | [Description("规格型号")] |
| | | public string Qd004 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD005")] |
| | | [Description("颜色")] |
| | | public string Qd005 { get; set; } |
| | | [SugarColumn(ColumnName = "QD005")] |
| | | [Description("颜色")] |
| | | public string Qd005 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD006")] |
| | | [Description("计划数量")] |
| | | public decimal? Qd006 { get; set; } |
| | | [SugarColumn(ColumnName = "QD006")] |
| | | [Description("计划数量")] |
| | | public decimal? Qd006 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD007")] |
| | | [Description("申请数量")] |
| | | public decimal? Qd007 { get; set; } |
| | | [SugarColumn(ColumnName = "QD007")] |
| | | [Description("申请数量")] |
| | | public decimal? Qd007 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD008", DefaultValue = "0")] |
| | | [Description("已领数量")] |
| | | public decimal Qd008 { get; set; } = 0; |
| | | [SugarColumn(ColumnName = "QD008", DefaultValue = "0")] |
| | | [Description("已领数量")] |
| | | public decimal Qd008 { get; set; } = 0; |
| | | |
| | | [SugarColumn(ColumnName = "QD009")] |
| | | [Description("单位")] |
| | | public string Qd009 { get; set; } |
| | | [SugarColumn(ColumnName = "QD009")] |
| | | [Description("单位")] |
| | | public string Qd009 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD010")] |
| | | [Description("备注")] |
| | | public string Qd010 { get; set; } |
| | | [SugarColumn(ColumnName = "QD010")] |
| | | [Description("备注")] |
| | | public string Qd010 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "QD011", DefaultValue = "0")] |
| | | [Description("完结标识")] |
| | | public decimal Qd011 { get; set; } = 0; |
| | | [SugarColumn(ColumnName = "QD011", DefaultValue = "0")] |
| | | [Description("完结标识")] |
| | | public decimal Qd011 { get; set; } = 0; |
| | | |
| | | [SugarColumn(ColumnName = "QD012")] |
| | | [Description("物料内码")] |
| | | public decimal? Qd012 { get; set; } |
| | | [SugarColumn(ColumnName = "QD012")] |
| | | [Description("物料内码")] |
| | | public decimal? Qd012 { get; set; } |
| | | |
| | | /* 新增字段 */ |
| | | /* 新增字段 */ |
| | | |
| | | [SugarColumn(ColumnName = "LINE_NUMBER")] |
| | | [Description("行号(物料顺序)")] |
| | | public int? LineNumber { get; set; } |
| | | [SugarColumn(ColumnName = "LINE_NUMBER")] |
| | | [Description("行号(物料顺序)")] |
| | | public int? LineNumber { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "PRODUCTION_RELATED")] |
| | | [Description("生产相关")] |
| | | public string ProductionRelated { get; set; } |
| | | [SugarColumn(ColumnName = "PRODUCTION_RELATED")] |
| | | [Description("生产相关")] |
| | | public string ProductionRelated { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "STORAGE_TYPE")] |
| | | [Description("存储类型")] |
| | | public string StorageType { get; set; } |
| | | [SugarColumn(ColumnName = "STORAGE_TYPE")] |
| | | [Description("存储类型")] |
| | | public string StorageType { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "OWNER_ORGANIZATION")] |
| | | [Description("货主组织")] |
| | | public string OwnerOrganization { get; set; } |
| | | [SugarColumn(ColumnName = "OWNER_ORGANIZATION")] |
| | | [Description("货主组织")] |
| | | public string OwnerOrganization { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "STORAGE_LOCATION")] |
| | | [Description("存储地点")] |
| | | public string StorageLocation { get; set; } |
| | | [SugarColumn(ColumnName = "STORAGE_LOCATION")] |
| | | [Description("存储地点")] |
| | | public string StorageLocation { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "SUPPLIER_CODE")] |
| | | [Description("供应商编码")] |
| | | public string SupplierCode { get; set; } |
| | | [SugarColumn(ColumnName = "SUPPLIER_CODE")] |
| | | [Description("供应商编码")] |
| | | public string SupplierCode { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "CUSTOMER_CODE")] |
| | | [Description("客户编码")] |
| | | public string CustomerCode { get; set; } |
| | | [SugarColumn(ColumnName = "CUSTOMER_CODE")] |
| | | [Description("客户编码")] |
| | | public string CustomerCode { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "PROJECT_CODE")] |
| | | [Description("关联项目编码")] |
| | | public string ProjectCode { get; set; } |
| | | [SugarColumn(ColumnName = "PROJECT_CODE")] |
| | | [Description("关联项目编码")] |
| | | public string ProjectCode { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "TASK_CODE")] |
| | | [Description("关联任务编码")] |
| | | public string TaskCode { get; set; } |
| | | [SugarColumn(ColumnName = "TASK_CODE")] |
| | | [Description("关联任务编码")] |
| | | public string TaskCode { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "PRODUCTION_ORDER")] |
| | | [Description("生产订单号")] |
| | | public string ProductionOrder { get; set; } |
| | | [SugarColumn(ColumnName = "PRODUCTION_ORDER")] |
| | | [Description("生产订单号")] |
| | | public string ProductionOrder { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "DAILY_PLAN")] |
| | | [Description("生产线日计划编号")] |
| | | public string DailyPlan { get; set; } |
| | | [SugarColumn(ColumnName = "DAILY_PLAN")] |
| | | [Description("生产线日计划编号")] |
| | | public string DailyPlan { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "PRODUCTION_ACTIVITY")] |
| | | [Description("生产活动")] |
| | | public string ProductionActivity { get; set; } |
| | | [SugarColumn(ColumnName = "PRODUCTION_ACTIVITY")] |
| | | [Description("生产活动")] |
| | | public string ProductionActivity { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FINISHED_PRODUCT")] |
| | | [Description("产成品编码")] |
| | | public string FinishedProduct { get; set; } |
| | | [SugarColumn(ColumnName = "PICKING_USAGE")] |
| | | [Description("领料用途")] |
| | | public string PickingUsage { get; set; } |
| | | } |
| | | [SugarColumn(ColumnName = "FINISHED_PRODUCT")] |
| | | [Description("产成品编码")] |
| | | public string FinishedProduct { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "PICKING_USAGE")] |
| | | [Description("领料用途")] |
| | | public string PickingUsage { get; set; } |
| | | } |