From e80da1ea0baacf0cf324f1f6b699490d67cbb565 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 12 九月 2024 09:05:37 +0800
Subject: [PATCH] 来料检验：分页查询增加排序，增加提交功能

---
 MES.Service/Modes/MesQaItemsDetectDetail5.cs |   51 ++++++++++++++++++++++++++++++---------------------
 1 files changed, 30 insertions(+), 21 deletions(-)

diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index 9421a04..24e9cbb 100644
--- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,5 +1,6 @@
 锘縰sing System;
 using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations.Schema;
 using System.Linq;
 using SqlSugar;
 namespace MES.Service.Modes
@@ -13,53 +14,54 @@
         /// <summary>
         ///  
         ///</summary>
-         [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true   )]
-         public decimal Id { get; set; }
+        [Column("ID")]
+         [SugarColumn(ColumnName="ID",OracleSequenceName = "SEQ_QM_ID",IsPrimaryKey = true   )]
+         public decimal ?Id { get; set; }
         /// <summary>
         /// 鏍囧噯鍊肩被鍨� 
         ///</summary>
          [SugarColumn(ColumnName="FTEXT_TYPE"    )]
-         public string FtextType { get; set; }
+         public string? FtextType { get; set; }
         /// <summary>
         /// 鏍囧噯鍊� 
         ///</summary>
          [SugarColumn(ColumnName="FSTAND"    )]
-         public decimal? Fstand { get; set; }
+         public string? Fstand { get; set; }
         /// <summary>
         /// 涓婂叕宸� 
         ///</summary>
          [SugarColumn(ColumnName="FUP_ALLOW"    )]
-         public string FupAllow { get; set; }
+         public string? FupAllow { get; set; }
         /// <summary>
         /// 涓嬪叕宸� 
         ///</summary>
          [SugarColumn(ColumnName="FDOWN_ALLOW"    )]
-         public string FdownAllow { get; set; }
+         public string? FdownAllow { get; set; }
         /// <summary>
         /// 妫�楠屾按鍑� 
         ///</summary>
          [SugarColumn(ColumnName="SAMPLE_SIZE_NO"    )]
-         public string SampleSizeNo { get; set; }
+         public string? SampleSizeNo { get; set; }
         /// <summary>
         /// 妫�楠屾按骞� 
         ///</summary>
          [SugarColumn(ColumnName="FCHECK_LEVEL"    )]
-         public string FcheckLevel { get; set; }
+         public string? FcheckLevel { get; set; }
         /// <summary>
         /// 鎷掓敹姘村钩 
         ///</summary>
          [SugarColumn(ColumnName="FAC_LEVEL"    )]
-         public string FacLevel { get; set; }
+         public string? FacLevel { get; set; }
         /// <summary>
         /// 妫�楠岄」鐩� 
         ///</summary>
          [SugarColumn(ColumnName="FCHECK_ITEM"    )]
-         public string FcheckItem { get; set; }
+         public string? FcheckItem { get; set; }
         /// <summary>
         /// 瑙勬牸瑕佹眰 
         ///</summary>
          [SugarColumn(ColumnName="FSPEC_REQU"    )]
-         public string FspecRequ { get; set; }
+         public string? FspecRequ { get; set; }
         /// <summary>
         /// 鎶芥鏁伴噺 
         ///</summary>
@@ -69,7 +71,7 @@
         /// 妫�楠岀粨鏋� 
         ///</summary>
          [SugarColumn(ColumnName="FCHECK_RESU"    )]
-         public string FcheckResu { get; set; }
+         public string? FcheckResu { get; set; }
         /// <summary>
         /// AC鏁伴噺 
         ///</summary>
@@ -99,37 +101,37 @@
         ///  
         ///</summary>
          [SugarColumn(ColumnName="RELEASE_NO"    )]
-         public string ReleaseNo { get; set; }
+         public string? ReleaseNo { get; set; }
         /// <summary>
         ///  
         ///</summary>
          [SugarColumn(ColumnName="COMPANY"    )]
-         public string Company { get; set; }
+         public string? Company { get; set; }
         /// <summary>
         ///  
         ///</summary>
          [SugarColumn(ColumnName="FACTORY"    )]
-         public string Factory { get; set; }
+         public string? Factory { get; set; }
         /// <summary>
         /// 妫�楠岄」鐩弿杩� 
         ///</summary>
          [SugarColumn(ColumnName="FCHECK_ITEM_DESC"    )]
-         public string FcheckItemDesc { get; set; }
+         public string? FcheckItemDesc { get; set; }
         /// <summary>
         /// 宸ュ簭鍙� 
         ///</summary>
          [SugarColumn(ColumnName="PROC_NO"    )]
-         public string ProcNo { get; set; }
+         public string? ProcNo { get; set; }
         /// <summary>
         /// 宸ヤ綔涓績缂栫爜 
         ///</summary>
          [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE"    )]
-         public string WorkshopCenterCode { get; set; }
+         public string? WorkshopCenterCode { get; set; }
         /// <summary>
         /// 鍗曚綅 
         ///</summary>
          [SugarColumn(ColumnName="FUNIT"    )]
-         public string Funit { get; set; }
+         public string? Funit { get; set; }
         /// <summary>
         /// 鐗瑰畾淇敼 
         ///</summary>
@@ -139,16 +141,23 @@
         /// 妫�楠屽伐鍏� 
         ///</summary>
          [SugarColumn(ColumnName="FCHECK_TOOL"    )]
-         public string FcheckTool { get; set; }
+         public string? FcheckTool { get; set; }
         /// <summary>
         /// 鏇存柊浜� 
         ///</summary>
          [SugarColumn(ColumnName="LASTUPDATE_BY"    )]
-         public string LastupdateBy { get; set; }
+         public string? LastupdateBy { get; set; }
         /// <summary>
         /// 鏇存柊鏃堕棿 
         ///</summary>
          [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
          public DateTime? LastupdateDate { get; set; }
+         /// <summary>
+         /// 涓嶈壇鎻忚堪 
+         ///</summary>
+         [SugarColumn(ColumnName="REMARKS"    )]
+         public string? Remarks { get; set; }
+         
+         [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; }
     }
 }

--
Gitblit v1.9.3