1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/MesQmAql3.cs

@@ -1,239 +1,279 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
///     AQL抽样基准抽样方案
/// </summary>
[SugarTable("MES_QM_AQL3")]
public class MesQmAql3
{
    /// <summary>
    /// AQL抽样基准抽样方案
    ///</summary>
    [SugarTable("MES_QM_AQL3")]
    public class MesQmAql3
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_BY"    )]
         public string CreateBy { get; set; }
        /// <summary>
        /// 创建人姓名 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_NAME"    )]
         public string CreateName { 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_NAME"    )]
         public string LastupdateName { get; set; }
        /// <summary>
        /// 最后更新时间 
        ///</summary>
         [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
         public DateTime? LastupdateDate { get; set; }
        /// <summary>
        /// 样本大小 
        ///</summary>
         [SugarColumn(ColumnName="FSAMPLE_SIZE_WORD"    )]
         public int? FsampleSizeWord { get; set; }
        /// <summary>
        /// 接收质量水平0.10 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_010"    )]
         public int? Aql0010 { get; set; }
        /// <summary>
        /// 接收质量水平0.15 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_015"    )]
         public int? Aql0015 { get; set; }
        /// <summary>
        /// 接收质量水平0.25 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_025"    )]
         public int? Aql0025 { get; set; }
        /// <summary>
        /// 接收质量水平0.40 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_040"    )]
         public int? Aql0040 { get; set; }
        /// <summary>
        /// 接收质量水平0.65 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_065"    )]
         public int? Aql0065 { get; set; }
        /// <summary>
        /// 接收质量水平1.0 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_100"    )]
         public int? Aql0100 { get; set; }
        /// <summary>
        /// 接收质量水平1.5 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_150"    )]
         public int? Aql0150 { get; set; }
        /// <summary>
        /// 接收质量水平2.5 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_250"    )]
         public int? Aql0250 { get; set; }
        /// <summary>
        /// 接收质量水平4.0 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_400"    )]
         public int? Aql0400 { get; set; }
        /// <summary>
        /// 接收质量水平6.5 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_650"    )]
         public int? Aql0650 { get; set; }
        /// <summary>
        /// 接收质量水平10 
        ///</summary>
         [SugarColumn(ColumnName="AQL_1_000"    )]
         public int? Aql1000 { get; set; }
        /// <summary>
        /// 接收质量水平15 
        ///</summary>
         [SugarColumn(ColumnName="AQL_1_500"    )]
         public int? Aql1500 { get; set; }
        /// <summary>
        /// 接收质量水平25 
        ///</summary>
         [SugarColumn(ColumnName="AQL_2_500"    )]
         public int? Aql2500 { get; set; }
        /// <summary>
        /// 接收质量水平40 
        ///</summary>
         [SugarColumn(ColumnName="AQL_4_000"    )]
         public int? Aql4000 { get; set; }
        /// <summary>
        /// 接收质量水平65 
        ///</summary>
         [SugarColumn(ColumnName="AQL_6_500"    )]
         public int? Aql6500 { get; set; }
        /// <summary>
        /// 接收质量水平100 
        ///</summary>
         [SugarColumn(ColumnName="AQL_10_000"    )]
         public int? Aql10000 { get; set; }
        /// <summary>
        /// 接收质量水平150 
        ///</summary>
         [SugarColumn(ColumnName="AQL_15_000"    )]
         public int? Aql15000 { get; set; }
        /// <summary>
        /// 接收质量水平250 
        ///</summary>
         [SugarColumn(ColumnName="AQL_25_000"    )]
         public int? Aql25000 { get; set; }
        /// <summary>
        /// 接收质量水平400 
        ///</summary>
         [SugarColumn(ColumnName="AQL_40_000"    )]
         public int? Aql40000 { get; set; }
        /// <summary>
        /// 接收质量水平650 
        ///</summary>
         [SugarColumn(ColumnName="AQL_65_000"    )]
         public int? Aql65000 { get; set; }
        /// <summary>
        /// 接收质量水平1000 
        ///</summary>
         [SugarColumn(ColumnName="AQL_100_000"    )]
         public int? Aql100000 { get; set; }
        /// <summary>
        /// 接收质量水平1500 
        ///</summary>
         [SugarColumn(ColumnName="AQL_150_000"    )]
         public int? Aql150000 { get; set; }
        /// <summary>
        /// 接收质量水平2500 
        ///</summary>
         [SugarColumn(ColumnName="AQL_250_000"    )]
         public int? Aql250000 { get; set; }
        /// <summary>
        /// 接收质量水平4000 
        ///</summary>
         [SugarColumn(ColumnName="AQL_400_000"    )]
         public int? Aql400000 { get; set; }
        /// <summary>
        /// 接收质量水平6500 
        ///</summary>
         [SugarColumn(ColumnName="AQL_650_000"    )]
         public int? Aql650000 { get; set; }
        /// <summary>
        /// 接收质量水平10000 
        ///</summary>
         [SugarColumn(ColumnName="AQL_1000_000"    )]
         public int? Aql1000000 { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="MEMO"    )]
         public string Memo { get; set; }
        /// <summary>
        /// 样本大小字码 
        ///</summary>
         [SugarColumn(ColumnName="SAMPLE_SIZE_WORD"    )]
         public string SampleSizeWord { get; set; }
        /// <summary>
        /// 修改/ 新增状态 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="EDIT_STATUS"    )]
         public byte? EditStatus { get; set; }
        /// <summary>
        /// 接收质量水平0.010 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_0010"    )]
         public int? Aql00010 { get; set; }
        /// <summary>
        /// 接收质量水平0.015 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_0015"    )]
         public int? Aql00015 { get; set; }
        /// <summary>
        /// 接收质量水平0.025 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_0025"    )]
         public int? Aql00025 { get; set; }
        /// <summary>
        /// 接收质量水平0.040 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_0040"    )]
         public int? Aql00040 { get; set; }
        /// <summary>
        /// 接收质量水平0.065 
        ///</summary>
         [SugarColumn(ColumnName="AQL_0_0065"    )]
         public int? Aql00065 { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="COMPANY"    )]
         public string Company { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="FACTORY"    )]
         public string Factory { get; set; }
        /// <summary>
        /// AQL抽样基准ID 
        ///</summary>
         [SugarColumn(ColumnName="AQL1_ID"    )]
         public Guid? Aql1Id { get; set; }
    }
}
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string CreateBy { get; set; }

    /// <summary>
    ///     创建人姓名
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_NAME")]
    public string CreateName { 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_NAME")]
    public string LastupdateName { get; set; }

    /// <summary>
    ///     最后更新时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     样本大小
    /// </summary>
    [SugarColumn(ColumnName = "FSAMPLE_SIZE_WORD")]
    public int? FsampleSizeWord { get; set; }

    /// <summary>
    ///     接收质量水平0.10
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_010")]
    public int? Aql0010 { get; set; }

    /// <summary>
    ///     接收质量水平0.15
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_015")]
    public int? Aql0015 { get; set; }

    /// <summary>
    ///     接收质量水平0.25
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_025")]
    public int? Aql0025 { get; set; }

    /// <summary>
    ///     接收质量水平0.40
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_040")]
    public int? Aql0040 { get; set; }

    /// <summary>
    ///     接收质量水平0.65
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_065")]
    public int? Aql0065 { get; set; }

    /// <summary>
    ///     接收质量水平1.0
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_100")]
    public int? Aql0100 { get; set; }

    /// <summary>
    ///     接收质量水平1.5
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_150")]
    public int? Aql0150 { get; set; }

    /// <summary>
    ///     接收质量水平2.5
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_250")]
    public int? Aql0250 { get; set; }

    /// <summary>
    ///     接收质量水平4.0
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_400")]
    public int? Aql0400 { get; set; }

    /// <summary>
    ///     接收质量水平6.5
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_650")]
    public int? Aql0650 { get; set; }

    /// <summary>
    ///     接收质量水平10
    /// </summary>
    [SugarColumn(ColumnName = "AQL_1_000")]
    public int? Aql1000 { get; set; }

    /// <summary>
    ///     接收质量水平15
    /// </summary>
    [SugarColumn(ColumnName = "AQL_1_500")]
    public int? Aql1500 { get; set; }

    /// <summary>
    ///     接收质量水平25
    /// </summary>
    [SugarColumn(ColumnName = "AQL_2_500")]
    public int? Aql2500 { get; set; }

    /// <summary>
    ///     接收质量水平40
    /// </summary>
    [SugarColumn(ColumnName = "AQL_4_000")]
    public int? Aql4000 { get; set; }

    /// <summary>
    ///     接收质量水平65
    /// </summary>
    [SugarColumn(ColumnName = "AQL_6_500")]
    public int? Aql6500 { get; set; }

    /// <summary>
    ///     接收质量水平100
    /// </summary>
    [SugarColumn(ColumnName = "AQL_10_000")]
    public int? Aql10000 { get; set; }

    /// <summary>
    ///     接收质量水平150
    /// </summary>
    [SugarColumn(ColumnName = "AQL_15_000")]
    public int? Aql15000 { get; set; }

    /// <summary>
    ///     接收质量水平250
    /// </summary>
    [SugarColumn(ColumnName = "AQL_25_000")]
    public int? Aql25000 { get; set; }

    /// <summary>
    ///     接收质量水平400
    /// </summary>
    [SugarColumn(ColumnName = "AQL_40_000")]
    public int? Aql40000 { get; set; }

    /// <summary>
    ///     接收质量水平650
    /// </summary>
    [SugarColumn(ColumnName = "AQL_65_000")]
    public int? Aql65000 { get; set; }

    /// <summary>
    ///     接收质量水平1000
    /// </summary>
    [SugarColumn(ColumnName = "AQL_100_000")]
    public int? Aql100000 { get; set; }

    /// <summary>
    ///     接收质量水平1500
    /// </summary>
    [SugarColumn(ColumnName = "AQL_150_000")]
    public int? Aql150000 { get; set; }

    /// <summary>
    ///     接收质量水平2500
    /// </summary>
    [SugarColumn(ColumnName = "AQL_250_000")]
    public int? Aql250000 { get; set; }

    /// <summary>
    ///     接收质量水平4000
    /// </summary>
    [SugarColumn(ColumnName = "AQL_400_000")]
    public int? Aql400000 { get; set; }

    /// <summary>
    ///     接收质量水平6500
    /// </summary>
    [SugarColumn(ColumnName = "AQL_650_000")]
    public int? Aql650000 { get; set; }

    /// <summary>
    ///     接收质量水平10000
    /// </summary>
    [SugarColumn(ColumnName = "AQL_1000_000")]
    public int? Aql1000000 { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "MEMO")]
    public string Memo { get; set; }

    /// <summary>
    ///     样本大小字码
    /// </summary>
    [SugarColumn(ColumnName = "SAMPLE_SIZE_WORD")]
    public string SampleSizeWord { get; set; }

    /// <summary>
    ///     修改/ 新增状态
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "EDIT_STATUS")]
    public byte? EditStatus { get; set; }

    /// <summary>
    ///     接收质量水平0.010
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_0010")]
    public int? Aql00010 { get; set; }

    /// <summary>
    ///     接收质量水平0.015
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_0015")]
    public int? Aql00015 { get; set; }

    /// <summary>
    ///     接收质量水平0.025
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_0025")]
    public int? Aql00025 { get; set; }

    /// <summary>
    ///     接收质量水平0.040
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_0040")]
    public int? Aql00040 { get; set; }

    /// <summary>
    ///     接收质量水平0.065
    /// </summary>
    [SugarColumn(ColumnName = "AQL_0_0065")]
    public int? Aql00065 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }

    /// <summary>
    ///     AQL抽样基准ID
    /// </summary>
    [SugarColumn(ColumnName = "AQL1_ID")]
    public Guid? Aql1Id { get; set; }
}