tjx
2025-11-13 2f4699ff377f0e5ea3640bb3670b2fbfbd56e3fb
StandardPda/MES.Service/Modes/MesItemQtDatall.cs
@@ -1,122 +1,123 @@
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; }
}