From 2f48267f8b9b7ffa912933f651add73da35fe15f Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期三, 07 五月 2025 09:37:17 +0800
Subject: [PATCH] 销售订单插入bug修复

---
 MES.Service/Modes/MesQaItemsDetectDetail5.cs |  269 ++++++++++++++++++++++++++++-------------------------
 1 files changed, 140 insertions(+), 129 deletions(-)

diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index 68ee666..0aa4263 100644
--- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,4 +1,5 @@
-锘縰sing SqlSugar;
+锘縰sing System.ComponentModel.DataAnnotations.Schema;
+using SqlSugar;
 
 namespace MES.Service.Modes;
 
@@ -8,167 +9,177 @@
 [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
 public class MesQaItemsDetectDetail5
 {
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
-    public decimal Id { get; set; }
+ /// <summary>
+ /// </summary>
+ [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; }
+ /// <summary>
+ ///     鏍囧噯鍊肩被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTEXT_TYPE")]
+    public string? FtextType { get; set; }
 
-   /// <summary>
-   ///     鏍囧噯鍊�
-   /// </summary>
-   [SugarColumn(ColumnName = "FSTAND")]
-    public decimal? Fstand { get; set; }
+ /// <summary>
+ ///     鏍囧噯鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTAND")]
+    public string? Fstand { get; set; }
 
-   /// <summary>
-   ///     涓婂叕宸�
-   /// </summary>
-   [SugarColumn(ColumnName = "FUP_ALLOW")]
-    public string FupAllow { get; set; }
+ /// <summary>
+ ///     涓婂叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FUP_ALLOW")]
+    public string? FupAllow { get; set; }
 
-   /// <summary>
-   ///     涓嬪叕宸�
-   /// </summary>
-   [SugarColumn(ColumnName = "FDOWN_ALLOW")]
-    public string FdownAllow { get; set; }
+ /// <summary>
+ ///     涓嬪叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+    public string? FdownAllow { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按鍑�
-   /// </summary>
-   [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
-    public string SampleSizeNo { get; set; }
+ /// <summary>
+ ///     妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+    public string? SampleSizeNo { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按骞�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_LEVEL")]
-    public string FcheckLevel { 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 = "FAC_LEVEL")]
+    public string? FacLevel { get; set; }
 
-   /// <summary>
-   ///     妫�楠岄」鐩�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_ITEM")]
-    public string FcheckItem { get; set; }
+ /// <summary>
+ ///     妫�楠岄」鐩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM")]
+    public string? FcheckItem { get; set; }
 
-   /// <summary>
-   ///     瑙勬牸瑕佹眰
-   /// </summary>
-   [SugarColumn(ColumnName = "FSPEC_REQU")]
-    public string FspecRequ { get; set; }
+ /// <summary>
+ ///     瑙勬牸瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "FSPEC_REQU")]
+    public string? FspecRequ { get; set; }
 
-   /// <summary>
-   ///     鎶芥鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_QYT")]
+ /// <summary>
+ ///     鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QYT")]
     public decimal? CheckQyt { get; set; }
 
-   /// <summary>
-   ///     妫�楠岀粨鏋�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_RESU")]
-    public string FcheckResu { get; set; }
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
+    public string? FcheckResu { get; set; }
 
-   /// <summary>
-   ///     AC鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FAC_QTY")]
+ /// <summary>
+ ///     AC鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_QTY")]
     public decimal? FacQty { get; set; }
 
-   /// <summary>
-   ///     RE鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FRE_QTY")]
+ /// <summary>
+ ///     RE鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FRE_QTY")]
     public decimal? FreQty { get; set; }
 
-   /// <summary>
-   ///     涓嶅悎鏍兼暟
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_QTY")]
+ /// <summary>
+ ///     涓嶅悎鏍兼暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_QTY")]
     public decimal? FngQty { get; set; }
 
-   /// <summary>
-   ///     涓嶈壇鐜�
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_RATE")]
+ /// <summary>
+ ///     涓嶈壇鐜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_RATE")]
     public decimal? FngRate { get; set; }
 
-   /// <summary>
-   ///     宸插綍鍏ユ暟閲�
-   /// </summary>
-   [SugarColumn(ColumnName = "FENTER_QTY")]
+ /// <summary>
+ ///     宸插綍鍏ユ暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "FENTER_QTY")]
     public decimal? FenterQty { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "RELEASE_NO")]
-    public string ReleaseNo { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
+    public string? ReleaseNo { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
-    public string Company { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+    public string? Company { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
-    public string Factory { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+    public string? Factory { get; set; }
 
-   /// <summary>
-   ///     妫�楠岄」鐩弿杩�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
-    public string FcheckItemDesc { get; set; }
+ /// <summary>
+ ///     妫�楠岄」鐩弿杩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
+    public string? FcheckItemDesc { get; set; }
 
-   /// <summary>
-   ///     宸ュ簭鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "PROC_NO")]
-    public string ProcNo { get; set; }
+ /// <summary>
+ ///     宸ュ簭鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_NO")]
+    public string? ProcNo { get; set; }
 
-   /// <summary>
-   ///     宸ヤ綔涓績缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
-    public string WorkshopCenterCode { get; set; }
+ /// <summary>
+ ///     宸ヤ綔涓績缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+    public string? WorkshopCenterCode { get; set; }
 
-   /// <summary>
-   ///     鍗曚綅
-   /// </summary>
-   [SugarColumn(ColumnName = "FUNIT")]
-    public string Funit { get; set; }
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "FUNIT")]
+    public string? Funit { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼
-   /// </summary>
-   [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+ /// <summary>
+ ///     鐗瑰畾淇敼
+ /// </summary>
+ [SugarColumn(ColumnName = "GIVEN_MODIFY")]
     public short? GivenModify { get; set; }
 
-   /// <summary>
-   ///     妫�楠屽伐鍏�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_TOOL")]
-    public string FcheckTool { get; set; }
+ /// <summary>
+ ///     妫�楠屽伐鍏�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_TOOL")]
+    public string? FcheckTool { get; set; }
 
-   /// <summary>
-   ///     鏇存柊浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_BY")]
-    public string LastupdateBy { get; set; }
+ /// <summary>
+ ///     鏇存柊浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string? LastupdateBy { get; set; }
 
-   /// <summary>
-   ///     鏇存柊鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <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; }
 }
\ No newline at end of file

--
Gitblit v1.9.3