using SqlSugar;
using System.ComponentModel;

namespace MES.Service.Modes;

[SugarTable("MES_ITEM_QTRR_DETAIL")]
    public class MesItemQtrrDetail
    {
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_QTRKD")]
        [Description("ID")]
        public decimal Id { get; set; }

        [SugarColumn(ColumnName = "MID")]
        [Description("MID")]
        public decimal Mid { get; set; }

        [SugarColumn(ColumnName = "QD001")]
        [Description("工单号")]
        public string Qd001 { get; set; }

        [SugarColumn(ColumnName = "QD002")]
        [Description("物料编号")]
        public string Qd002 { get; set; }

        [SugarColumn(ColumnName = "QD003")]
        [Description("物料名称")]
        public string Qd003 { get; set; }

        [SugarColumn(ColumnName = "QD004")]
        [Description("规格型号")]
        public string Qd004 { get; set; }

        [SugarColumn(ColumnName = "QD005")]
        [Description("颜色")]
        public string Qd005 { get; set; }

        [SugarColumn(ColumnName = "QD006")]
        [Description("计划数量")]
        public decimal? Qd006 { 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 = "QD009", Length = 30)]
        [Description("单位")]
        public string Qd009 { get; set; }

        [SugarColumn(ColumnName = "QD010", Length = 500)]
        [Description("备注")]
        public string Qd010 { get; set; }

        [SugarColumn(ColumnName = "QD011", DefaultValue = "0")]
        [Description("完结标识")]
        public decimal Qd011 { get; set; } = 0;

        [SugarColumn(ColumnName = "QD012")]
        [Description("物料内码")]
        public decimal? Qd012 { get; set; }

    /* 新增字段 */

    [SugarColumn(ColumnName = "LINE_NUMBER")]
    [Description("行号(物料顺序)")]
    public int? LineNumber { get; set; }

    [SugarColumn(ColumnName = "PRODUCTION_RELATED")]
    [Description("生产相关")]
    public string ProductionRelated { get; set; }

    [SugarColumn(ColumnName = "STORAGE_TYPE")]
    [Description("存储类型")]
    public string StorageType { get; set; }

    [SugarColumn(ColumnName = "OWNER_ORGANIZATION")]
    [Description("货主组织")]
    public string OwnerOrganization { get; set; }

    [SugarColumn(ColumnName = "STORAGE_LOCATION")]
    [Description("存储地点")]
    public string StorageLocation { get; set; }

    [SugarColumn(ColumnName = "SUPPLIER_CODE")]
    [Description("供应商编码")]
    public string SupplierCode { get; set; }

    [SugarColumn(ColumnName = "CUSTOMER_CODE")]
    [Description("客户编码")]
    public string CustomerCode { get; set; }

    [SugarColumn(ColumnName = "PROJECT_CODE")]
    [Description("关联项目编码")]
    public string ProjectCode { get; set; }

    [SugarColumn(ColumnName = "TASK_CODE")]
    [Description("关联任务编码")]
    public string TaskCode { get; set; }

    [SugarColumn(ColumnName = "PRODUCTION_ORDER")]
    [Description("生产订单号")]
    public string ProductionOrder { get; set; }

    [SugarColumn(ColumnName = "DAILY_PLAN")]
    [Description("生产线日计划编号")]
    public string DailyPlan { get; set; }

    [SugarColumn(ColumnName = "PRODUCTION_ACTIVITY")]
    [Description("生产活动")]
    public string ProductionActivity { get; set; }

    [SugarColumn(ColumnName = "FINISHED_PRODUCT")]
    [Description("产成品编码")]
    public string FinishedProduct { get; set; }
}