增加qms实体

Rodney Chen

2024-06-26 6e76fdf5313abfa5bfc252cca0507d2c266f2315

增加qms实体

 Tiger.Business/BizSettings.json

@@ -27,8 +27,8 @@
      "DbType": "SqlServer",
      //"ConnectionString": "server=172.18.8.57;uid=sa;pwd=bmsEia9IS4VByWJr;database=SharetronicWmsDb_DGSC;",
      //"ConnectionString": "server=172.16.80.40;uid=sa;pwd=Yada@321654;database=MES;"
      "ConnectionString": "server=(localdb)\\MSSQLLocalDB;uid=sa;pwd=p@ssw0rd;database=MES;"
      //"ConnectionString": "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=MES;Integrated Security=True;Connect Timeout=30;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False"
      //"ConnectionString": "server=(localdb)\\ProjectsV13;uid=sa;pwd=p@ssw0rd;database=MES;",
      "ConnectionString": "server=47.115.28.255;uid=sa;pwd=p@ssw0rd;database=MES;"
      //"DbType": "Sqlite",
      //"ConnectionString": "DataSource=..\\apidata\\Automate.db"
      //"DbType": "MySql",

 Tiger.Model.Net/Entitys/QMS/QMS_AQL_PLAN.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,112 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：AQL抽样计划
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("AQL抽样计划")]
    [Serializable]
    [SugarTable("QMS_AQL_PLAN")]
    public class QMS_AQL_PLAN : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：AQL抽样计划
        /// </summary>
        public QMS_AQL_PLAN() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// æ‰¹é‡æœ€å°å€¼
        /// </summary>
        [DisplayName("批量最小值")]
        public int LOT_MIN { get; set; }
        /// <summary>
        /// æ‰¹é‡æœ€å¤§å€¼
        /// </summary>
        [DisplayName("批量最大值")]
        public int LOT_MAX { get; set; }
        /// <summary>
        /// æ£€éªŒæ°´å¹³(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)
        /// </summary>
        [DisplayName("检验水平(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)")]
        public int INS_LEVEL { get; set; }
        /// <summary>
        /// æ ·æœ¬é‡å­—码
        /// </summary>
        [DisplayName("样本量字码")]
        public string AQL_CODE { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是QMS_AQL_PLAN类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.QMS_AQL_PLANId))]//ClassA表中的QMS_AQL_PLANId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.QMS_AQL_PLANId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šæ£€éªŒæ°´å¹³(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)
        /// </summary>
        public enum INS_LEVELs
        {
            [Description("一般检验水平 â… ")]
            GeneralLevel1 = 0,
            [Description("一般检验水平 â…¡")]
            GeneralLevel2 = 1,
            [Description("一般检验水平 â…¢")]
            GeneralLevel3 = 2,
            [Description("特殊检验水平 S-1")]
            SpecialLevel1 = 3,
            [Description("特殊检验水平 S-2")]
            SpecialLevel2 = 4,
            [Description("特殊检验水平 S-3")]
            SpecialLevel3 = 5,
            [Description("特殊检验水平 S-4")]
            SpecialLevel4 = 6,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Entitys/QMS/QMS_AQL_STD.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,119 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：AQL判定标准
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("AQL判定标准")]
    [Serializable]
    [SugarTable("QMS_AQL_STD")]
    public class QMS_AQL_STD : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：AQL判定标准
        /// </summary>
        public QMS_AQL_STD() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// æ ·æœ¬é‡å­—码
        /// </summary>
        [DisplayName("样本量字码")]
        public string AQL_CODE { get; set; }
        /// <summary>
        /// æŽ¥å—质量限
        /// </summary>
        [DisplayName("接受质量限")]
        public string AQL_VALUE { get; set; }
        /// <summary>
        /// æ ·æœ¬é‡
        /// </summary>
        [DisplayName("样本量")]
        public double AQL_QTY { get; set; }
        /// <summary>
        /// ä¸¥æ ¼åº¦(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        [DisplayName("严格度(0Normal正常|1Tightened加严|2Reduced放宽)")]
        public int STRICTNESS { get; set; }
        /// <summary>
        /// å…æ”¶æ•°é‡
        /// </summary>
        [DisplayName("允收数量")]
        public double AC_QTY { get; set; }
        /// <summary>
        /// æ‹’收数量
        /// </summary>
        [DisplayName("拒收数量")]
        public double RE_QTY { get; set; }
        /// <summary>
        /// æ˜¯å¦å¯ç”¨(Y/N)
        /// </summary>
        [DisplayName("是否启用(Y/N)")]
        public string IS_ACTIVE { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是QMS_AQL_STD类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.QMS_AQL_STDId))]//ClassA表中的QMS_AQL_STDId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.QMS_AQL_STDId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šä¸¥æ ¼åº¦(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        public enum STRICTNESSs
        {
            [Description("正常")]
            Normal = 0,
            [Description("加严")]
            Tightened = 1,
            [Description("放宽")]
            Reduced = 2,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Entitys/QMS/QMS_INS_DTL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,385 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：检验结果明细
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("检验结果明细")]
    [Serializable]
    [SugarTable("QMS_INS_DTL")]
    public class QMS_INS_DTL : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：检验结果明细
        /// </summary>
        public QMS_INS_DTL() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// ä¸šåŠ¡ç¼–码
        /// </summary>
        [DisplayName("业务编码")]
        public string TRANS_CODE { get; set; }
        /// <summary>
        /// å•æ®å·ç 
        /// </summary>
        [DisplayName("单据号码")]
        public string TRANS_NO { get; set; }
        /// <summary>
        /// å•æ®è¡Œå·
        /// </summary>
        [DisplayName("单据行号")]
        public int TRANS_LINE { get; set; }
        /// <summary>
        /// æ£€éªŒæ‰¹æ¬¡
        /// </summary>
        [DisplayName("检验批次")]
        public string INS_BATCH { get; set; }
        /// <summary>
        /// æ£€éªŒæ¡ç 
        /// </summary>
        [DisplayName("检验条码")]
        public string SN { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Waiting待检|1Finished已检)
        /// </summary>
        [DisplayName("状态(0Waiting待检|1Finished已检)")]
        public int STATUS { get; set; }
        /// <summary>
        /// å·¥åºèŠ‚点ID
        /// </summary>
        [DisplayName("工序节点ID")]
        public string NODE_ID { get; set; }
        /// <summary>
        /// å·¥åºèŠ‚点名称
        /// </summary>
        [DisplayName("工序节点名称")]
        public string NODE_NAME { get; set; }
        /// <summary>
        /// æ£€éªŒç±»åˆ«ç¼–码
        /// </summary>
        [DisplayName("检验类别编码")]
        public string CTGY_CODE { get; set; }
        /// <summary>
        /// æ£€éªŒç±»åˆ«åç§°
        /// </summary>
        [DisplayName("检验类别名称")]
        public string CTGY_NAME { get; set; }
        /// <summary>
        /// æ£€éªŒé¡¹ç›®ç¼–码
        /// </summary>
        [DisplayName("检验项目编码")]
        public string INS_CODE { get; set; }
        /// <summary>
        /// æ£€éªŒé¡¹ç›®åç§°
        /// </summary>
        [DisplayName("检验项目名称")]
        public string INS_NAME { get; set; }
        /// <summary>
        /// æ£€éªŒå·¥å…·
        /// </summary>
        [DisplayName("检验工具")]
        public string INS_TOOL { get; set; }
        /// <summary>
        /// æŠ€æœ¯è¦æ±‚
        /// </summary>
        [DisplayName("技术要求")]
        public string TECH_STD { get; set; }
        /// <summary>
        /// æ£€éªŒç»“æžœ(OK/NG)
        /// </summary>
        [DisplayName("检验结果(OK/NG)")]
        public string RESULT { get; set; }
        /// <summary>
        /// ä¸è‰¯æ•°é‡
        /// </summary>
        [DisplayName("不良数量")]
        public int NG_QTY { get; set; }
        /// <summary>
        /// ä¸è‰¯ä»£ç 
        /// </summary>
        [DisplayName("不良代码")]
        public string DFT_CODE { get; set; }
        /// <summary>
        /// ç¼ºé™·ç­‰çº§(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)
        /// </summary>
        [DisplayName("缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)")]
        public int DFT_LEVEL { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼1
        /// </summary>
        [DisplayName("定量测试值1")]
        public double QNTV_VALUE1 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼2
        /// </summary>
        [DisplayName("定量测试值2")]
        public double QNTV_VALUE2 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼3
        /// </summary>
        [DisplayName("定量测试值3")]
        public double QNTV_VALUE3 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼4
        /// </summary>
        [DisplayName("定量测试值4")]
        public double QNTV_VALUE4 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼5
        /// </summary>
        [DisplayName("定量测试值5")]
        public double QNTV_VALUE5 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼6
        /// </summary>
        [DisplayName("定量测试值6")]
        public double QNTV_VALUE6 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼7
        /// </summary>
        [DisplayName("定量测试值7")]
        public double QNTV_VALUE7 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼8
        /// </summary>
        [DisplayName("定量测试值8")]
        public double QNTV_VALUE8 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼9
        /// </summary>
        [DisplayName("定量测试值9")]
        public double QNTV_VALUE9 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼10
        /// </summary>
        [DisplayName("定量测试值10")]
        public double QNTV_VALUE10 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼11
        /// </summary>
        [DisplayName("定量测试值11")]
        public double QNTV_VALUE11 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼12
        /// </summary>
        [DisplayName("定量测试值12")]
        public double QNTV_VALUE12 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼13
        /// </summary>
        [DisplayName("定量测试值13")]
        public double QNTV_VALUE13 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼14
        /// </summary>
        [DisplayName("定量测试值14")]
        public double QNTV_VALUE14 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼15
        /// </summary>
        [DisplayName("定量测试值15")]
        public double QNTV_VALUE15 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼16
        /// </summary>
        [DisplayName("定量测试值16")]
        public double QNTV_VALUE16 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼17
        /// </summary>
        [DisplayName("定量测试值17")]
        public double QNTV_VALUE17 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼18
        /// </summary>
        [DisplayName("定量测试值18")]
        public double QNTV_VALUE18 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼19
        /// </summary>
        [DisplayName("定量测试值19")]
        public double QNTV_VALUE19 { get; set; }
        /// <summary>
        /// å®šé‡æµ‹è¯•å€¼20
        /// </summary>
        [DisplayName("定量测试值20")]
        public double QNTV_VALUE20 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼1
        /// </summary>
        [DisplayName("定性测试值1")]
        public string QLTV_VALUE1 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼2
        /// </summary>
        [DisplayName("定性测试值2")]
        public string QLTV_VALUE2 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼3
        /// </summary>
        [DisplayName("定性测试值3")]
        public string QLTV_VALUE3 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼4
        /// </summary>
        [DisplayName("定性测试值4")]
        public string QLTV_VALUE4 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼5
        /// </summary>
        [DisplayName("定性测试值5")]
        public string QLTV_VALUE5 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼6
        /// </summary>
        [DisplayName("定性测试值6")]
        public string QLTV_VALUE6 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼7
        /// </summary>
        [DisplayName("定性测试值7")]
        public string QLTV_VALUE7 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼8
        /// </summary>
        [DisplayName("定性测试值8")]
        public string QLTV_VALUE8 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼9
        /// </summary>
        [DisplayName("定性测试值9")]
        public string QLTV_VALUE9 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼10
        /// </summary>
        [DisplayName("定性测试值10")]
        public string QLTV_VALUE10 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼11
        /// </summary>
        [DisplayName("定性测试值11")]
        public string QLTV_VALUE11 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼12
        /// </summary>
        [DisplayName("定性测试值12")]
        public string QLTV_VALUE12 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼13
        /// </summary>
        [DisplayName("定性测试值13")]
        public string QLTV_VALUE13 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼14
        /// </summary>
        [DisplayName("定性测试值14")]
        public string QLTV_VALUE14 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼15
        /// </summary>
        [DisplayName("定性测试值15")]
        public string QLTV_VALUE15 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼16
        /// </summary>
        [DisplayName("定性测试值16")]
        public string QLTV_VALUE16 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼17
        /// </summary>
        [DisplayName("定性测试值17")]
        public string QLTV_VALUE17 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼18
        /// </summary>
        [DisplayName("定性测试值18")]
        public string QLTV_VALUE18 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼19
        /// </summary>
        [DisplayName("定性测试值19")]
        public string QLTV_VALUE19 { get; set; }
        /// <summary>
        /// å®šæ€§æµ‹è¯•å€¼20
        /// </summary>
        [DisplayName("定性测试值20")]
        public string QLTV_VALUE20 { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是QMS_INS_DTL类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.QMS_INS_DTLId))]//ClassA表中的QMS_INS_DTLId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.QMS_INS_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šçŠ¶æ€(0Waiting待检|1Finished已检)
        /// </summary>
        public enum STATUSs
        {
            [Description("待检")]
            Waiting = 0,
            [Description("已检")]
            Finished = 1,
        }

        /// <summary>
        /// æžšä¸¾ï¼šç¼ºé™·ç­‰çº§(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)
        /// </summary>
        public enum DFT_LEVELs
        {
            [Description("轻微缺陷")]
            MI = 0,
            [Description("严重缺陷")]
            MA = 1,
            [Description("致命缺陷")]
            CR = 2,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Entitys/QMS/QMS_INS_ITEM.cs

@@ -34,6 +34,11 @@
        [DisplayName("检验项目名称")]
        public string INS_NAME { get; set; }
        /// <summary>
        /// æ£€éªŒæ ‡å‡†ç¼–码
        /// </summary>
        [DisplayName("检验标准编码")]
        public string STD_CODE { get; set; }
        /// <summary>
        /// æ£€éªŒç±»åˆ«ç¼–码
        /// </summary>
        [DisplayName("检验类别编码")]

 Tiger.Model.Net/Entitys/QMS/QMS_SAMPLE_RULE.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,248 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：抽样规则
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("抽样规则")]
    [Serializable]
    [SugarTable("QMS_SAMPLE_RULE")]
    public class QMS_SAMPLE_RULE : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：抽样规则
        /// </summary>
        public QMS_SAMPLE_RULE() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// æŠ½æ ·è§„则编码
        /// </summary>
        [DisplayName("抽样规则编码")]
        public string RULE_CODE { get; set; }
        /// <summary>
        /// æŠ½æ ·è§„则名称
        /// </summary>
        [DisplayName("抽样规则名称")]
        public string RULE_NAME { get; set; }
        /// <summary>
        /// æŠ½æ ·è§„则类型(0ByAQL按AQL方案|1ByPercentage按比例抽样|2ByLotSize按批量抽样|3ByAll全检抽样)
        /// </summary>
        [DisplayName("抽样规则类型(0ByAQL按AQL方案|1ByPercentage按比例抽样|2ByLotSize按批量抽样|3ByAll全检抽样)")]
        public int RULE_TYPE { get; set; }
        /// <summary>
        /// æŒ‰AQL方案：严格度(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        [DisplayName("按AQL方案：严格度(0Normal正常|1Tightened加严|2Reduced放宽)")]
        public int AQL_STRICTNESS { get; set; }
        /// <summary>
        /// æŒ‰AQL方案：检验水平(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)
        /// </summary>
        [DisplayName("按AQL方案：检验水平(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)")]
        public int AQL_LEVEL { get; set; }
        /// <summary>
        /// æŒ‰AQL方案：AQL值
        /// </summary>
        [DisplayName("按AQL方案：AQL值")]
        public double AQL_VALUE { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：所有缺陷（ALL）AQL值
        /// </summary>
        [DisplayName("按其他类型：所有缺陷（ALL）AQL值")]
        public double ALL_SPL_AQL { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：所有缺陷（ALL）样本数/比例
        /// </summary>
        [DisplayName("按其他类型：所有缺陷（ALL）样本数/比例")]
        public double ALL_SPL_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：所有缺陷（ALL）允收
        /// </summary>
        [DisplayName("按其他类型：所有缺陷（ALL）允收")]
        public double ALL_AC_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：所有缺陷（ALL）拒收
        /// </summary>
        [DisplayName("按其他类型：所有缺陷（ALL）拒收")]
        public double ALL_RE_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：致命缺陷（CR）AQL值
        /// </summary>
        [DisplayName("按其他类型：致命缺陷（CR）AQL值")]
        public double CR_SPL_AQL { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：致命缺陷（CR）样本数/比例
        /// </summary>
        [DisplayName("按其他类型：致命缺陷（CR）样本数/比例")]
        public double CR_SPL_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：致命缺陷（CR）允收
        /// </summary>
        [DisplayName("按其他类型：致命缺陷（CR）允收")]
        public double CR_AC_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：致命缺陷（CR）拒收
        /// </summary>
        [DisplayName("按其他类型：致命缺陷（CR）拒收")]
        public double CR_RE_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：严重缺陷（MA）AQL值
        /// </summary>
        [DisplayName("按其他类型：严重缺陷（MA）AQL值")]
        public double MA_SPL_AQL { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：严重缺陷（MA）样本数/比例
        /// </summary>
        [DisplayName("按其他类型：严重缺陷（MA）样本数/比例")]
        public double MA_SPL_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：严重缺陷（MA）允收
        /// </summary>
        [DisplayName("按其他类型：严重缺陷（MA）允收")]
        public double MA_AC_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：严重缺陷（MA）拒收
        /// </summary>
        [DisplayName("按其他类型：严重缺陷（MA）拒收")]
        public double MA_RE_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：轻微缺陷（MI）AQL值
        /// </summary>
        [DisplayName("按其他类型：轻微缺陷（MI）AQL值")]
        public double MI_SPL_AQL { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：轻微缺陷（MI）样本数/比例
        /// </summary>
        [DisplayName("按其他类型：轻微缺陷（MI）样本数/比例")]
        public double MI_SPL_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：轻微缺陷（MI）允收
        /// </summary>
        [DisplayName("按其他类型：轻微缺陷（MI）允收")]
        public double MI_AC_QTY { get; set; }
        /// <summary>
        /// æŒ‰å…¶ä»–类型：轻微缺陷（MI）拒收
        /// </summary>
        [DisplayName("按其他类型：轻微缺陷（MI）拒收")]
        public double MI_RE_QTY { get; set; }
        /// <summary>
        /// ä¸¥æ ¼åº¦(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        [DisplayName("严格度(0Normal正常|1Tightened加严|2Reduced放宽)")]
        public int STRICTNESS { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是QMS_SAMPLE_RULE类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.QMS_SAMPLE_RULEId))]//ClassA表中的QMS_SAMPLE_RULEId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.QMS_SAMPLE_RULEId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šæŠ½æ ·è§„则类型(0ByAQL按AQL方案|1ByPercentage按比例抽样|2ByLotSize按批量抽样|3ByAll全检抽样)
        /// </summary>
        public enum RULE_TYPEs
        {
            [Description("按AQL方案")]
            ByAQL = 0,
            [Description("按比例抽样")]
            ByPercentage = 1,
            [Description("按批量抽样")]
            ByLotSize = 2,
            [Description("全检抽样")]
            ByAll = 3,
        }

        /// <summary>
        /// æžšä¸¾ï¼šæŒ‰AQL方案：严格度(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        public enum AQL_STRICTNESSs
        {
            [Description("正常")]
            Normal = 0,
            [Description("加严")]
            Tightened = 1,
            [Description("放宽")]
            Reduced = 2,
        }

        /// <summary>
        /// æžšä¸¾ï¼šæŒ‰AQL方案：检验水平(0GeneralLevel1一般检验水平 â… |1GeneralLevel2一般检验水平 â…¡|2GeneralLevel3一般检验水平 â…¢|3SpecialLevel1特殊检验水平 S-1|4SpecialLevel2特殊检验水平 S-2|5SpecialLevel3特殊检验水平 S-3|6SpecialLevel4特殊检验水平 S-4)
        /// </summary>
        public enum AQL_LEVELs
        {
            [Description("一般检验水平 â… ")]
            GeneralLevel1 = 0,
            [Description("一般检验水平 â…¡")]
            GeneralLevel2 = 1,
            [Description("一般检验水平 â…¢")]
            GeneralLevel3 = 2,
            [Description("特殊检验水平 S-1")]
            SpecialLevel1 = 3,
            [Description("特殊检验水平 S-2")]
            SpecialLevel2 = 4,
            [Description("特殊检验水平 S-3")]
            SpecialLevel3 = 5,
            [Description("特殊检验水平 S-4")]
            SpecialLevel4 = 6,
        }

        /// <summary>
        /// æžšä¸¾ï¼šä¸¥æ ¼åº¦(0Normal正常|1Tightened加严|2Reduced放宽)
        /// </summary>
        public enum STRICTNESSs
        {
            [Description("正常")]
            Normal = 0,
            [Description("加严")]
            Tightened = 1,
            [Description("放宽")]
            Reduced = 2,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Tiger.Model.Net.csproj

@@ -147,9 +147,13 @@
    <Compile Include="Entitys\MES\SMT_TOOL.cs" />
    <Compile Include="Entitys\MES\SMT_TOOL_HIS.cs" />
    <Compile Include="Entitys\MES\SMT_WO_TABLE.cs" />
    <Compile Include="Entitys\QMS\QMS_AQL_PLAN.cs" />
    <Compile Include="Entitys\QMS\QMS_AQL_STD.cs" />
    <Compile Include="Entitys\QMS\QMS_INS_CTGY.cs" />
    <Compile Include="Entitys\QMS\QMS_INS_DTL.cs" />
    <Compile Include="Entitys\QMS\QMS_INS_ITEM.cs" />
    <Compile Include="Entitys\QMS\QMS_INS_STD.cs" />
    <Compile Include="Entitys\QMS\QMS_SAMPLE_RULE.cs" />
    <Compile Include="Entitys\SYS\LOG_CS_LOGIN.cs" />
    <Compile Include="Entitys\SYS\LOG_PDA_LOGIN.cs" />
    <Compile Include="Entitys\SYS\SYS_CS_LOGIN.cs" />