From a619299816f2f632c7c6ba3a1bb869e2c212797d Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期五, 19 十二月 2025 14:12:33 +0800
Subject: [PATCH] 对添加巡检单物料编码进行去重
---
StandardPda/MES.Service/Modes/MesQa.cs | 73 ++++++++++++++++++++++++++++++++++++
1 files changed, 73 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/MesQa.cs b/StandardPda/MES.Service/Modes/MesQa.cs
new file mode 100644
index 0000000..198761e
--- /dev/null
+++ b/StandardPda/MES.Service/Modes/MesQa.cs
@@ -0,0 +1,73 @@
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 妫�楠岄」鐩富琛�
+/// </summary>
+[Table("MES_QA")]
+[SugarTable("MES_QA")] //鐢ㄤ簬SqlSugar
+public class MesQa
+{
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [Column("CREATE_BY")]
+ [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(20, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�20")]
+ public string? CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [Column("CREATE_DATE")]
+ [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鐘舵��
+ /// </summary>
+ [Column("FSUBMIT")]
+ [SugarColumn(ColumnName = "FSUBMIT")] //鐢ㄤ簬SqlSugar
+ public decimal? Fsubmit { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [Column("FSUBMIT_BY")]
+ [SugarColumn(ColumnName = "FSUBMIT_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(50, ErrorMessage = "瀹℃牳浜洪暱搴︿笉鑳借秴鍑�50")]
+ public string? FsubmitBy { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ /// </summary>
+ [Column("FSUBMIT_DATE")]
+ [SugarColumn(ColumnName = "FSUBMIT_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? FsubmitDate { get; set; }
+
+ /// <summary>
+ /// 搴忓垪SEQ_QS
+ /// </summary>
+ [Column("ID")]
+ [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
+ public decimal? Id { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡缂栧彿
+ /// </summary>
+ [Column("ITEM_NO")]
+ [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(50, ErrorMessage = "鐗╂枡缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
+ public string? ItemNo { get; set; }
+
+ /// <summary>
+ /// 1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴
+ /// </summary>
+ [Column("QS_TYPE")]
+ [SugarColumn(ColumnName = "QS_TYPE")] //鐢ㄤ簬SqlSugar
+ [StringLength(1, ErrorMessage = "1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴闀垮害涓嶈兘瓒呭嚭1")]
+ public string? QsType { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3