From 799a463b41e84aa265f109035c08892614ea9fd8 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期四, 24 七月 2025 21:12:32 +0800
Subject: [PATCH] 首检排序

---
 MES.Service/Modes/MesQualityStandard.cs |  370 ++++++++++++++++++++++++++--------------------------
 1 files changed, 188 insertions(+), 182 deletions(-)

diff --git a/MES.Service/Modes/MesQualityStandard.cs b/MES.Service/Modes/MesQualityStandard.cs
index bf414fa..a0186a3 100644
--- a/MES.Service/Modes/MesQualityStandard.cs
+++ b/MES.Service/Modes/MesQualityStandard.cs
@@ -1,204 +1,210 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
 using SqlSugar;
 
 namespace MES.Service.Modes;
 
 /// <summary>
-///     璐ㄩ噺鏍囧噯琛�
 /// </summary>
-[Table("MES_QUALITY_STANDARD")]
-[SugarTable("MES_QUALITY_STANDARD")] //鐢ㄤ簬SqlSugar
+[SugarTable("MES_QUALITY_STANDARD")]
 public class MesQualityStandard
 {
-    /// <summary>
-    ///     搴忓垪SEQ_QS
-    /// </summary>
-    [Key]
-    [Column("ID")]
-    [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-    /// <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("FAC_LEVEL")]
-    [SugarColumn(ColumnName = "FAC_LEVEL")] //鐢ㄤ簬SqlSugar
-    [StringLength(100, ErrorMessage = "鎺ユ敹姘村钩闀垮害涓嶈兘瓒呭嚭100")]
-    public string FacLevel { get; set; }
-
-    /// <summary>
-    ///     妫�楠屾按骞�
-    /// </summary>
-    [Column("FCHECK_LEVEL")]
-    [SugarColumn(ColumnName = "FCHECK_LEVEL")] //鐢ㄤ簬SqlSugar
-    [StringLength(100, ErrorMessage = "妫�楠屾按骞抽暱搴︿笉鑳借秴鍑�100")]
-    public string FcheckLevel { 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>
-    ///     妯℃暟
-    /// </summary>
-    [Column("INSPECTION_LEVEL")]
-    [SugarColumn(ColumnName = "INSPECTION_LEVEL")] //鐢ㄤ簬SqlSugar
-    public decimal? InspectionLevel { get; set; }
-
-    /// <summary>
-    ///     妫�楠屾柟娉�
-    /// </summary>
-    [Column("INSPECTION_METHOD")]
-    [SugarColumn(ColumnName = "INSPECTION_METHOD")] //鐢ㄤ簬SqlSugar
-    [StringLength(50, ErrorMessage = "妫�楠屾柟娉曢暱搴︿笉鑳借秴鍑�50")]
-    public string InspectionMethod { get; set; }
-
-    /// <summary>
-    ///     璐ㄩ噺瑕佹眰
-    /// </summary>
-    [Column("ITEM_MOD")]
-    [SugarColumn(ColumnName = "ITEM_MOD")] //鐢ㄤ簬SqlSugar
-    [StringLength(500, ErrorMessage = "璐ㄩ噺瑕佹眰闀垮害涓嶈兘瓒呭嚭500")]
-    public string ItemMod { get; set; }
-
-    /// <summary>
-    ///     鐗╂枡缂栧彿
-    /// </summary>
-    [Column("ITEM_NO")]
-    [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
-    [StringLength(50, ErrorMessage = "鐗╂枡缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
-    public string ItemNo { get; set; }
-
-    /// <summary>
-    ///     姣忔ā澶氬皯涓�
-    /// </summary>
-    [Column("LEVEL_NUM")]
-    [SugarColumn(ColumnName = "LEVEL_NUM")] //鐢ㄤ簬SqlSugar
-    public decimal? LevelNum { get; set; }
-
-    /// <summary>
-    ///     鏈�澶у��
-    /// </summary>
-    [Column("MAX_VALUE")]
-    [SugarColumn(ColumnName = "MAX_VALUE")] //鐢ㄤ簬SqlSugar
-    public decimal? MaxValue { get; set; }
-
-    /// <summary>
-    ///     鏈�灏忓��
-    /// </summary>
-    [Column("MIN_VALUE")]
-    [SugarColumn(ColumnName = "MIN_VALUE")] //鐢ㄤ簬SqlSugar
-    public decimal? MinValue { get; set; }
-
-    /// <summary>
-    ///     妯″叿鍙�
-    /// </summary>
-    [Column("MOID_NUM")]
-    [SugarColumn(ColumnName = "MOID_NUM")] //鐢ㄤ簬SqlSugar
-    [StringLength(50, ErrorMessage = "妯″叿鍙烽暱搴︿笉鑳借秴鍑�50")]
+ /// <summary>
+ ///     妯″叿鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "MOID_NUM")]
     public string MoidNum { get; set; }
 
-    /// <summary>
-    ///     澶囨敞
-    /// </summary>
-    [Column("NOTES")]
-    [SugarColumn(ColumnName = "NOTES")] //鐢ㄤ簬SqlSugar
-    [StringLength(100, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭100")]
-    public string Notes { get; set; }
-
-    /// <summary>
-    ///     鍥剧墖鍦板潃
-    /// </summary>
-    [Column("PICTURE")]
-    [SugarColumn(ColumnName = "PICTURE")] //鐢ㄤ簬SqlSugar
-    public byte[]? Picture { get; set; }
-
-    /// <summary>
-    ///     鍥剧墖鍚嶇О
-    /// </summary>
-    [Column("PICTURENAME")]
-    [SugarColumn(ColumnName = "PICTURENAME")] //鐢ㄤ簬SqlSugar
-    [StringLength(32, ErrorMessage = "Picturename闀垮害涓嶈兘瓒呭嚭32")]
-    public string? Picturename { get; set; }
-
-    /// <summary>
-    ///     椤圭洰鍚嶇О
-    /// </summary>
-    [Column("PROJ_NAME")]
-    [SugarColumn(ColumnName = "PROJ_NAME")] //鐢ㄤ簬SqlSugar
-    [StringLength(50, ErrorMessage = "椤圭洰鍚嶇О闀垮害涓嶈兘瓒呭嚭50")]
+ /// <summary>
+ ///     椤圭洰鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJ_NAME")]
     public string ProjName { get; set; }
 
-    /// <summary>
-    ///     妫�楠屾爣鍑嗙紪鐮�
-    /// </summary>
-    [Column("QS_CODE")]
-    [SugarColumn(ColumnName = "QS_CODE")] //鐢ㄤ簬SqlSugar
-    [StringLength(100, ErrorMessage = "妫�楠屾爣鍑嗙紪鐮侀暱搴︿笉鑳借秴鍑�100")]
-    public string QsCode { get; set; }
+ /// <summary>
+ ///     璐ㄩ噺瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_MOD")]
+    public string ItemMod { get; set; }
 
-    /// <summary>
-    ///     妫�楠屾爣鍑嗗悕绉�
-    /// </summary>
-    [Column("QS_NAME")]
-    [SugarColumn(ColumnName = "QS_NAME")] //鐢ㄤ簬SqlSugar
-    [StringLength(100, ErrorMessage = "妫�楠屾爣鍑嗗悕绉伴暱搴︿笉鑳借秴鍑�100")]
-    public string QsName { get; set; }
+ /// <summary>
+ ///     妫�楠屾柟娉�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSPECTION_METHOD")]
+    public string InspectionMethod { get; set; }
 
-    /// <summary>
-    ///     1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴
-    /// </summary>
-    [Column("QS_TYPE")]
-    [SugarColumn(ColumnName = "QS_TYPE")] //鐢ㄤ簬SqlSugar
-    [StringLength(1, ErrorMessage = "1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴闀垮害涓嶈兘瓒呭嚭1")]
+ /// <summary>
+ ///     浣跨敤浠〃
+ /// </summary>
+ [SugarColumn(ColumnName = "USING_INSTRUMENTS")]
+    public string UsingInstruments { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSPECTION_LEVEL")]
+    public string InspectionLevel { get; set; }
+
+ /// <summary>
+ ///     姣忔ā澶氬皯涓�
+ /// </summary>
+ [SugarColumn(ColumnName = "LEVEL_NUM")]
+    public string LevelNum { get; set; }
+
+ /// <summary>
+ ///     涓婇檺
+ /// </summary>
+ [SugarColumn(ColumnName = "MAX_VALUE")]
+    public string MaxValue { get; set; }
+
+ /// <summary>
+ ///     鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "STANDARD_VALUE")]
+    public string StandardValue { get; set; }
+
+ /// <summary>
+ ///     涓嬮檺
+ /// </summary>
+ [SugarColumn(ColumnName = "MIN_VALUE")]
+    public string MinValue { get; set; }
+
+ /// <summary>
+ ///     澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "NOTES")]
+    public string Notes { get; set; }
+
+ /// <summary>
+ ///     绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "QS_TYPE")]
     public string QsType { get; set; }
 
-    /// <summary>
-    ///     鏍囧噯鍊�
-    /// </summary>
-    [Column("STANDARD_VALUE")]
-    [SugarColumn(ColumnName = "STANDARD_VALUE")] //鐢ㄤ簬SqlSugar
-    public decimal? StandardValue { get; set; }
+ /// <summary>
+ ///     妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+    public string FcheckLevel { get; set; }
 
+ /// <summary>
+ ///     鎺ュ彈姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
+    public string FacLevel { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾爣鍑嗙紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "QS_CODE")]
+    public string QsCode { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾爣鍑嗗悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "QS_NAME")]
+    public string QsName { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+    public string CreateBy { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+    public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ ///     瀹℃牳鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT")]
+    public decimal? Fsubmit { get; set; }
+
+ /// <summary>
+ ///     瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT_BY")]
+    public string FsubmitBy { get; set; }
+
+ /// <summary>
+ ///     瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT_DATE")]
+    public DateTime? FsubmitDate { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "PICTURE")]
+    public byte[]? Picture { get; set; }
+
+ /// <summary>
+ ///     鍥剧墖
+ /// </summary>
+ [SugarColumn(ColumnName = "PICTURENAME")]
+    public string Picturename { get; set; }
+
+ /// <summary>
+ ///     鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+    public string ItemNo { get; set; }
+
+ /// <summary>
+ ///     鐗╂枡id
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+    public decimal? ItemId { get; set; }
+
+ /// <summary>
+ ///     鎸夎溅闂村垎绫荤埗ID
+ /// </summary>
+ [SugarColumn(ColumnName = "PID")]
+    public decimal? Pid { get; set; }
+
+ /// <summary>
+ ///     绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE_NO")]
+    public string ItemTypeNo { get; set; }
+
+ /// <summary>
+ ///     绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE_ID")]
+    public decimal? ItemTypeId { get; set; }
+
+ /// <summary>
+ ///     杞﹂棿id
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP_ID")]
+    public decimal? WorkshopId { get; set; }
+
+ /// <summary>
+ ///     缁勭粐id
+ /// </summary>
+ [SugarColumn(ColumnName = "ORGID")]
+    public decimal? Orgid { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾爣鍑唅d
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL1_ID")]
+    public decimal? Aql1Id { get; set; }
+
+ /// <summary>
+ ///     椤圭洰鎻忚堪
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
+    public string Memo { get; set; }
     /// <summary>
-    ///     浣跨敤浠〃
+    ///     搴忓彿
     /// </summary>
-    [Column("USING_INSTRUMENTS")]
-    [SugarColumn(ColumnName = "USING_INSTRUMENTS")] //鐢ㄤ簬SqlSugar
-    [StringLength(50, ErrorMessage = "浣跨敤浠〃闀垮害涓嶈兘瓒呭嚭50")]
-    public string UsingInstruments { get; set; }
+    [SugarColumn(ColumnName = "XH")]
+    public string Xh { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3