From 297eec3030b5b4388eccdea56bc1d42469921b0f Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 24 九月 2024 08:59:57 +0800
Subject: [PATCH] 接收erp任务单数据时更新工单数据

---
 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 d6159cc..0d62d6b 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