From 6e76fdf5313abfa5bfc252cca0507d2c266f2315 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期三, 26 六月 2024 15:29:09 +0800
Subject: [PATCH] 增加qms实体
---
Tiger.Model.Net/Entitys/QMS/QMS_AQL_PLAN.cs | 112 +++++++
Tiger.Model.Net/Entitys/QMS/QMS_SAMPLE_RULE.cs | 248 ++++++++++++++++
Tiger.Model.Net/Entitys/QMS/QMS_INS_DTL.cs | 385 +++++++++++++++++++++++++
Tiger.Model.Net/Tiger.Model.Net.csproj | 4
Tiger.Business/BizSettings.json | 4
Tiger.Model.Net/Entitys/QMS/QMS_INS_ITEM.cs | 5
Tiger.Model.Net/Entitys/QMS/QMS_AQL_STD.cs | 119 +++++++
7 files changed, 875 insertions(+), 2 deletions(-)
diff --git a/Tiger.Business/BizSettings.json b/Tiger.Business/BizSettings.json
index f435cf1..edb6e4b 100644
--- a/Tiger.Business/BizSettings.json
+++ b/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",
diff --git a/Tiger.Model.Net/Entitys/QMS/QMS_AQL_PLAN.cs b/Tiger.Model.Net/Entitys/QMS/QMS_AQL_PLAN.cs
new file mode 100644
index 0000000..6470c67
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Entitys/QMS/QMS_AQL_STD.cs b/Tiger.Model.Net/Entitys/QMS/QMS_AQL_STD.cs
new file mode 100644
index 0000000..131e232
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Entitys/QMS/QMS_INS_DTL.cs b/Tiger.Model.Net/Entitys/QMS/QMS_INS_DTL.cs
new file mode 100644
index 0000000..090d743
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Entitys/QMS/QMS_INS_ITEM.cs b/Tiger.Model.Net/Entitys/QMS/QMS_INS_ITEM.cs
index 30d0195..dafdd04 100644
--- a/Tiger.Model.Net/Entitys/QMS/QMS_INS_ITEM.cs
+++ b/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("检验类别编码")]
diff --git a/Tiger.Model.Net/Entitys/QMS/QMS_SAMPLE_RULE.cs b/Tiger.Model.Net/Entitys/QMS/QMS_SAMPLE_RULE.cs
new file mode 100644
index 0000000..517436e
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Tiger.Model.Net.csproj b/Tiger.Model.Net/Tiger.Model.Net.csproj
index a18ba46..52ac319 100644
--- a/Tiger.Model.Net/Tiger.Model.Net.csproj
+++ b/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" />
--
Gitblit v1.9.3