From 2389c8496f97aa2c15c5e4e7475de39b967d678c Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期三, 23 七月 2025 09:03:52 +0800
Subject: [PATCH] 产测查询工单数据接口调整，改为按站位号反查产线，再通过产线查出工单信息

---
 StandardPda/MES.Service/Modes/MesInvItemOutItems.cs |   44 +++++++++++++++++++++++++++++++++++++-------
 1 files changed, 37 insertions(+), 7 deletions(-)

diff --git a/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs b/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
index 41d01b8..6260f6a 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
@@ -11,7 +11,7 @@
     /// <summary>
     ///     SEQ_ITEM_ID
     /// </summary>
-    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_OUT_ID",
         IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
@@ -34,21 +34,25 @@
     public decimal? Quantity { 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 = "LASTUPDATE_BY")]
     public string? LastupdateBy { get; set; }
 
     /// <summary>
+    ///     淇敼鏃堕棿
     /// </summary>
     [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
@@ -60,11 +64,13 @@
     public string? Remark { get; set; }
 
     /// <summary>
+    ///     宸ュ巶
     /// </summary>
     [SugarColumn(ColumnName = "FACTORY")]
     public string? Factory { get; set; }
 
     /// <summary>
+    ///     鍏徃
     /// </summary>
     [SugarColumn(ColumnName = "COMPANY")]
     public string? Company { get; set; }
@@ -165,11 +171,13 @@
     public string? BoardItem { get; set; }
 
     /// <summary>
+    ///     鏄惁濮斿
     /// </summary>
     [SugarColumn(ColumnName = "F_TYPE")]
     public decimal? FType { get; set; }
 
     /// <summary>
+    ///     鏄惁瀹岀粨
     /// </summary>
     [SugarColumn(ColumnName = "STATUS")]
     public decimal? Status { get; set; }
@@ -199,7 +207,7 @@
     public string? RkNo { get; set; }
 
     /// <summary>
-    ///     宸插叆搴撴暟
+    ///     鍏ュ簱鍗曟暟閲�
     /// </summary>
     [SugarColumn(ColumnName = "RK_QTY")]
     public decimal? RkQty { get; set; }
@@ -217,13 +225,35 @@
     public decimal? ItemId { get; set; }
 
     /// <summary>
-    ///     鐗╂枡鎶曟枡鍗旾D
+    ///     鐗╂枡鎶曟枡鍗旾D(鍙戞枡鎵爜浣跨敤)
     /// </summary>
     [SugarColumn(ColumnName = "ITEM_DABID")]
     public decimal? ItemDabid { get; set; }
 
-    [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
-    [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
-    [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
-    [SugarColumn(IsIgnore = true)] public string? QuantityOk { get; set; }
+    /// <summary>
+    ///     鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "UNIT")]
+    public string? Unit { get; set; }
+
+    /// <summary>
+    ///     鍏ュ簱鍗曡鍐呯爜
+    /// </summary>
+    [SugarColumn(ColumnName = "RK_LINE")]
+    public decimal? RkLine { get; set; }
+
+    /// <summary>
+    ///     璁″垝璺熻釜鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "FMTONO")]
+    public string? Fmtono { get; set; }
+
+    // <summary>
+    ///     鐢宠琛屽彿
+    /// </summary>
+    [SugarColumn(ColumnName = "SQ_NO")]
+    public string? SqNo { get; set; }
+
+    //[SugarColumn(ColumnName = "ZZITEM_ID")]
+    //public string? ZzitemId{ get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3