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 |  259 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 259 insertions(+), 0 deletions(-)

diff --git a/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs b/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
new file mode 100644
index 0000000..6260f6a
--- /dev/null
+++ b/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
@@ -0,0 +1,259 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     鍑哄簱鐢宠鐗╂枡琛�
+/// </summary>
+[SugarTable("MES_INV_ITEM_OUT_ITEMS")]
+public class MesInvItemOutItems
+{
+    /// <summary>
+    ///     SEQ_ITEM_ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_OUT_ID",
+        IsPrimaryKey = true)]
+    public decimal Id { get; set; }
+
+    /// <summary>
+    ///     鍑哄簱ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_OUT_ID")]
+    public decimal? ItemOutId { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_NO")]
+    public string? ItemNo { get; set; }
+
+    /// <summary>
+    ///     鐢宠鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "QUANTITY")]
+    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; }
+
+    /// <summary>
+    ///     澶囨敞淇℃伅
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARK")]
+    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; }
+
+    /// <summary>
+    ///     鎺ㄤ粙浠撳簱
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_CODE")]
+    public string? DepotCode { get; set; }
+
+    /// <summary>
+    ///     鎺ㄤ粙搴撲綅
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
+    public string? DepotSectionCode { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "TASK_NO")]
+    public string? TaskNo { get; set; }
+
+    /// <summary>
+    ///     鍒拌揣鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "WORK_NO")]
+    public string? WorkNo { get; set; }
+
+    /// <summary>
+    ///     鍒拌揣鍗曡鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "WORK_LINE")]
+    public decimal? WorkLine { get; set; }
+
+    /// <summary>
+    ///     ERP 涓昏〃ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_ID")]
+    public decimal? ErpId { get; set; }
+
+    /// <summary>
+    ///     ERP 浠庤〃ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_AUTOID")]
+    public decimal? ErpAutoid { get; set; }
+
+    /// <summary>
+    ///     ERP_鏂欏彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+    public string? ErpItemNo { get; set; }
+
+    /// <summary>
+    ///     棰滆壊
+    /// </summary>
+    [SugarColumn(ColumnName = "COLOR_NAME")]
+    public string? ColorName { get; set; }
+
+    /// <summary>
+    ///     鏈�鏂颁笅杞芥洿鏂版爣璇�
+    /// </summary>
+    [SugarColumn(ColumnName = "UPDATE_FLG")]
+    public decimal? UpdateFlg { get; set; }
+
+    /// <summary>
+    ///     閲囪喘鍗旾D
+    /// </summary>
+    [SugarColumn(ColumnName = "EBELN_K3ID")]
+    public decimal? EbelnK3id { get; set; }
+
+    /// <summary>
+    ///     閲囪喘鍗曡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "LINE_K3ID")]
+    public decimal? LineK3id { get; set; }
+
+    /// <summary>
+    ///     閲囪喘鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "EBELN")]
+    public string? Ebeln { get; set; }
+
+    /// <summary>
+    ///     閲囪喘璁㈠崟琛屽彿
+    /// </summary>
+    [SugarColumn(ColumnName = "EBELN_LINE")]
+    public decimal? EbelnLine { get; set; }
+
+    /// <summary>
+    ///     閲囪喘璁㈠崟鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "EBELN_QTY")]
+    public decimal? EbelnQty { get; set; }
+
+    /// <summary>
+    ///     浜у搧缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "BOARD_ITEM")]
+    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; }
+
+    /// <summary>
+    ///     瀛愬瓙琛↖D
+    /// </summary>
+    [SugarColumn(ColumnName = "ALLOCATEID")]
+    public decimal? Allocateid { get; set; }
+
+    /// <summary>
+    ///     棰嗘枡缂栧彿/鐢熶骇宸ュ崟
+    /// </summary>
+    [SugarColumn(ColumnName = "PBILL_NO")]
+    public string? PbillNo { get; set; }
+
+    /// <summary>
+    ///     erp鎺ュ彛杩斿洖
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_MARK")]
+    public string? ErpMark { get; set; }
+
+    /// <summary>
+    ///     鍏ュ簱鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "RK_NO")]
+    public string? RkNo { get; set; }
+
+    /// <summary>
+    ///     鍏ュ簱鍗曟暟閲�
+    /// </summary>
+    [SugarColumn(ColumnName = "RK_QTY")]
+    public decimal? RkQty { get; set; }
+
+    /// <summary>
+    ///     宸叉壂鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "TL_QTY")]
+    public decimal? TlQty { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_ID")]
+    public decimal? ItemId { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡鎶曟枡鍗旾D(鍙戞枡鎵爜浣跨敤)
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_DABID")]
+    public decimal? ItemDabid { 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