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