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