From b2be3b6939b4382f9165c78857a072f1aa7b01d0 Mon Sep 17 00:00:00 2001 From: zyf <1071160500@qq.com> Date: 星期六, 12 四月 2025 12:34:02 +0800 Subject: [PATCH] 更新平板功能,首检页面生成巡检单 --- MES.Service/Modes/MesInvItemInCDetails2.cs | 606 ++++++++++++++++++++++++++++--------------------------- 1 files changed, 308 insertions(+), 298 deletions(-) diff --git a/MES.Service/Modes/MesInvItemInCDetails2.cs b/MES.Service/Modes/MesInvItemInCDetails2.cs index 145b44c..4d50f32 100644 --- a/MES.Service/Modes/MesInvItemInCDetails2.cs +++ b/MES.Service/Modes/MesInvItemInCDetails2.cs @@ -1,358 +1,368 @@ -锘縰sing SqlSugar; +锘縰sing System; +using System.Collections.Generic; +using System.Linq; +using SqlSugar; -namespace MES.Service.Modes; - -/// <summary> -/// 鐗╂枡鎴愬搧鍏ュ簱鐢宠鏉$爜鏄庣粏 -/// </summary> -[SugarTable("MES_INV_ITEM_IN_C_DETAILS2")] -public class MesInvItemInCDetails2 +namespace MES.Service.Modes { - /// <summary> - /// SEQ_OUT - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] - public decimal Id { get; set; } + /// <summary> + /// 鐗╂枡鎴愬搧鍏ュ簱鐢宠鏉$爜鏄庣粏 + ///</summary> + [SugarTable("MES_INV_ITEM_IN_C_DETAILS2")] + public class MesInvItemInCDetails2 + { + /// <summary> + /// SEQ_OUT + ///</summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + public decimal Id { get; set; } - /// <summary> - /// 鍏ュ簱鍗昳d - /// </summary> - [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] - public decimal ItemInId { get; set; } + /// <summary> + /// 鍏ュ簱鍗昳d + ///</summary> + [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] + public decimal ItemInId { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜PSN - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE")] - public string ItemBarcode { get; set; } + /// <summary> + /// 鐗╂枡鏉$爜PSN + ///</summary> + [SugarColumn(ColumnName = "ITEM_BARCODE")] + public string ItemBarcode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_CODE")] - public string CItemCode { get; set; } + /// <summary> + /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 + ///</summary> + [SugarColumn(ColumnName = "C_ITEM_CODE")] + public string CItemCode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_BARCODE")] - public string CItemBarcode { get; set; } + /// <summary> + /// 瀹㈡埛鐗╂枡鏉$爜 + ///</summary> + [SugarColumn(ColumnName = "C_ITEM_BARCODE")] + public string CItemBarcode { get; set; } - /// <summary> - /// 楠屾敹鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] - public decimal? Quantity { get; set; } + /// <summary> + /// 楠屾敹鏁伴噺 + ///</summary> + [SugarColumn(ColumnName = "QUANTITY")] + public decimal? Quantity { get; set; } - /// <summary> - /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�) - /// </summary> - [SugarColumn(ColumnName = "BARCODE_FLAG")] - public short? BarcodeFlag { get; set; } + /// <summary> + /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�) + ///</summary> + [SugarColumn(ColumnName = "BARCODE_FLAG")] + public short? BarcodeFlag { get; set; } - /// <summary> - /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛� - /// </summary> - [SugarColumn(ColumnName = "EP_FLAG")] - public short? EpFlag { get; set; } + /// <summary> + /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛� + ///</summary> + [SugarColumn(ColumnName = "EP_FLAG")] + public short? EpFlag { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] - public string CreateBy { 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 = "CREATE_DATE")] + public DateTime? CreateDate { 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")] - public DateTime? LastupdateDate { get; set; } + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + ///</summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉$爜鏋�1-鏃犵嚎鏉$爜鏋� - /// </summary> - [SugarColumn(ColumnName = "WORK_TYPE")] - public decimal? WorkType { get; set; } + /// <summary> + /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉$爜鏋�1-鏃犵嚎鏉$爜鏋� + ///</summary> + [SugarColumn(ColumnName = "WORK_TYPE")] + public decimal? WorkType { get; set; } - /// <summary> - /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] - public string ItemNo { get; set; } + /// <summary> + /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 + ///</summary> + [SugarColumn(ColumnName = "ITEM_NO")] + public string ItemNo { get; set; } - /// <summary> - /// 鍘傚鎵规 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] - public string LotNo { get; set; } + /// <summary> + /// 鍘傚鎵规 + ///</summary> + [SugarColumn(ColumnName = "LOT_NO")] + public string LotNo { get; set; } - /// <summary> - /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�) - /// </summary> - [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")] - public short? ComanagementFlag { get; set; } + /// <summary> + /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�) + ///</summary> + [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")] + public short? ComanagementFlag { get; set; } - /// <summary> - /// 瀹㈡埛缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "CUST_NO")] - public string CustNo { get; set; } + /// <summary> + /// 瀹㈡埛缂栫爜 + ///</summary> + [SugarColumn(ColumnName = "CUST_NO")] + public string CustNo { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "CHECK_RES")] - public string CheckRes { get; set; } + /// <summary> + /// 妫�楠岀粨鏋� + ///</summary> + [SugarColumn(ColumnName = "CHECK_RES")] + public string CheckRes { get; set; } - /// <summary> - /// 杩涜揣鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] - public decimal? CheckQty { get; set; } + /// <summary> + /// 杩涜揣鏁伴噺 + ///</summary> + [SugarColumn(ColumnName = "CHECK_QTY")] + public decimal? CheckQty { get; set; } - /// <summary> - /// 妫�楠岀姸鎬� - /// </summary> - [SugarColumn(ColumnName = "CHECK_STATES")] - public string CheckStates { get; set; } + /// <summary> + /// 妫�楠岀姸鎬� + ///</summary> + [SugarColumn(ColumnName = "CHECK_STATES")] + public string CheckStates { get; set; } - /// <summary> - /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤 - /// </summary> - [SugarColumn(ColumnName = "FORCE_IN_FLAG")] - public short? ForceInFlag { get; set; } + /// <summary> + /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤 + ///</summary> + [SugarColumn(ColumnName = "FORCE_IN_FLAG")] + public short? ForceInFlag { get; set; } - /// <summary> - /// 浠撳簱缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_CODE")] - public string DepotCode { 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 = "DEPOT_SECTION_CODE")] + public string DepotSectionCode { get; set; } - /// <summary> - /// 鐗硅浜嬮」 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] - public string Remark { get; set; } + /// <summary> + /// 鐗硅浜嬮」 + ///</summary> + [SugarColumn(ColumnName = "REMARK")] + public string Remark { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE2")] - public string ItemBarcode2 { get; set; } + /// <summary> + /// 鐗╂枡鏉$爜 + ///</summary> + [SugarColumn(ColumnName = "ITEM_BARCODE2")] + public string ItemBarcode2 { get; set; } - /// <summary> - /// 鏂版潯鐮� - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE3")] - public string ItemBarcode3 { get; set; } + /// <summary> + /// 鏂版潯鐮� + ///</summary> + [SugarColumn(ColumnName = "ITEM_BARCODE3")] + public string ItemBarcode3 { get; set; } - /// <summary> - /// 浣跨敤鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "USE_QTY")] - public decimal? UseQty { get; set; } + /// <summary> + /// 浣跨敤鏁伴噺 + ///</summary> + [SugarColumn(ColumnName = "USE_QTY")] + public decimal? UseQty { get; set; } - /// <summary> - /// 棰嗘枡鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "OUT_QTY")] - public decimal? OutQty { get; set; } + /// <summary> + /// 棰嗘枡鏁伴噺 + ///</summary> + [SugarColumn(ColumnName = "OUT_QTY")] + public decimal? OutQty { get; set; } - /// <summary> - /// 鐗╂枡绠�绉� - /// </summary> - [SugarColumn(ColumnName = "ITEM_SNAME")] - public string ItemSname { get; set; } + /// <summary> + /// 鐗╂枡绠�绉� + ///</summary> + [SugarColumn(ColumnName = "ITEM_SNAME")] + public string ItemSname { get; set; } - /// <summary> - /// 妗d綅浣庡�� - /// </summary> - [SugarColumn(ColumnName = "SPOSTION")] - public decimal? Spostion { get; set; } + /// <summary> + /// 妗d綅浣庡�� + ///</summary> + [SugarColumn(ColumnName = "SPOSTION")] + public decimal? Spostion { get; set; } - /// <summary> - /// 妗d綅楂樺�� - /// </summary> - [SugarColumn(ColumnName = "EPOSTION")] - public decimal? Epostion { get; set; } + /// <summary> + /// 妗d綅楂樺�� + ///</summary> + [SugarColumn(ColumnName = "EPOSTION")] + public decimal? Epostion { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "CHECK_DATE")] - public DateTime? CheckDate { get; set; } + /// <summary> + /// 妫�楠屾棩鏈� + ///</summary> + [SugarColumn(ColumnName = "CHECK_DATE")] + public DateTime? CheckDate { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "UNIT")] - public string Unit { get; set; } + /// <summary> + /// 鍗曚綅 + ///</summary> + [SugarColumn(ColumnName = "UNIT")] + public string Unit { get; set; } - /// <summary> - /// 鏄惁妫�楠� - /// </summary> - [SugarColumn(ColumnName = "ISCHECK")] - public decimal? Ischeck { get; set; } + /// <summary> + /// 鏄惁妫�楠� + ///</summary> + [SugarColumn(ColumnName = "ISCHECK")] + public decimal? Ischeck { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟 - /// </summary> - [SugarColumn(ColumnName = "EBELN")] - public string Ebeln { get; set; } + /// <summary> + /// 閲囪喘璁㈠崟 + ///</summary> + [SugarColumn(ColumnName = "EBELN")] + public string Ebeln { get; set; } - /// <summary> - /// 鐢熶骇鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LOT_DATE")] - public string LotDate { get; set; } + /// <summary> + /// 鐢熶骇鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "LOT_DATE")] + public string LotDate { get; set; } - /// <summary> - /// 鍏ュ簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] - public string BillNo { get; set; } + /// <summary> + /// 鍏ュ簱鍗曞彿 + ///</summary> + [SugarColumn(ColumnName = "BILL_NO")] + public string BillNo { get; set; } - /// <summary> - /// 鍏ュ簱瀹℃牳鏍囧織 - /// </summary> - [SugarColumn(ColumnName = "STOCK_OK")] - public short? StockOk { get; set; } + /// <summary> + /// 鍏ュ簱瀹℃牳鏍囧織 + ///</summary> + [SugarColumn(ColumnName = "STOCK_OK")] + public short? StockOk { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] - public string Factory { get; set; } + /// <summary> + /// 鍒嗗巶缂栫爜 + ///</summary> + [SugarColumn(ColumnName = "FACTORY")] + public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] - public string Company { get; set; } + /// <summary> + /// 鍏徃浠g爜 + ///</summary> + [SugarColumn(ColumnName = "COMPANY")] + public string Company { get; set; } - /// <summary> - /// 鍗℃澘缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "CB_NO")] - public string CbNo { get; set; } + /// <summary> + /// 鍗℃澘缂栫爜 + ///</summary> + [SugarColumn(ColumnName = "CB_NO")] + public string CbNo { get; set; } - /// <summary> - /// 绠卞彿 - /// </summary> - [SugarColumn(ColumnName = "BOX_NO")] - public string BoxNo { get; set; } + /// <summary> + /// 绠卞彿 + ///</summary> + [SugarColumn(ColumnName = "BOX_NO")] + public string BoxNo { get; set; } - /// <summary> - /// 浠撳簱ID - /// </summary> - [SugarColumn(ColumnName = "DEPOT_ID")] - public decimal? DepotId { get; set; } + /// <summary> + /// 浠撳簱ID + ///</summary> + [SugarColumn(ColumnName = "DEPOT_ID")] + public decimal? DepotId { get; set; } - /// <summary> - /// 璐т綅ID - /// </summary> - [SugarColumn(ColumnName = "DEPOT_SECTION_ID")] - public decimal? DepotSectionId { get; set; } + /// <summary> + /// 璐т綅ID + ///</summary> + [SugarColumn(ColumnName = "DEPOT_SECTION_ID")] + public decimal? DepotSectionId { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "LINE_NUM")] - public string LineNum { get; set; } + /// <summary> + /// 琛屽彿 + ///</summary> + [SugarColumn(ColumnName = "LINE_NUM")] + public string LineNum { get; set; } - /// <summary> - /// 鎵爜鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "SM_QTY")] - public decimal? SmQty { get; set; } + /// <summary> + /// 鎵爜鏁伴噺 + ///</summary> + [SugarColumn(ColumnName = "SM_QTY")] + public decimal? SmQty { get; set; } - /// <summary> - /// 閿�鍞鍗� - /// </summary> - [SugarColumn(ColumnName = "VGBEL")] - public string Vgbel { get; set; } + /// <summary> + /// 閿�鍞鍗� + ///</summary> + [SugarColumn(ColumnName = "VGBEL")] + public string Vgbel { get; set; } - /// <summary> - /// 閿�鍞鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "KDPOS")] - public decimal? Kdpos { get; set; } + /// <summary> + /// 閿�鍞鍗曡鍙� + ///</summary> + [SugarColumn(ColumnName = "KDPOS")] + public decimal? Kdpos { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] - public string WorkNo { get; set; } + /// <summary> + /// 浠诲姟鍗曞彿 + ///</summary> + [SugarColumn(ColumnName = "WORK_NO")] + public string WorkNo { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "EBELN_LINE_NO")] - public decimal? EbelnLineNo { get; set; } + /// <summary> + /// 琛屽彿 + ///</summary> + [SugarColumn(ColumnName = "EBELN_LINE_NO")] + public decimal? EbelnLineNo { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "CBILL_NO")] - public string CbillNo { get; set; } + /// <summary> + /// 鍒拌揣鍗曞彿 + ///</summary> + [SugarColumn(ColumnName = "CBILL_NO")] + public string CbillNo { get; set; } - /// <summary> - /// 鎬ユ枡鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "URGENT_FLAG")] - public decimal? UrgentFlag { get; set; } + /// <summary> + /// 鎬ユ枡鏍囪瘑 + ///</summary> + [SugarColumn(ColumnName = "URGENT_FLAG")] + public decimal? UrgentFlag { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] - public string BoardStyle { get; set; } + /// <summary> + /// 浜у搧鍨嬪彿 + ///</summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] + public string BoardStyle { get; set; } - /// <summary> - /// 浠诲姟鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] - public decimal? WorkLine { get; set; } + /// <summary> + /// 浠诲姟鍗曡鍙� + ///</summary> + [SugarColumn(ColumnName = "WORK_LINE")] + public decimal? WorkLine { get; set; } - /// <summary> - /// 鐢熶骇宸ュ崟 - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] - public string TaskNo { get; set; } + /// <summary> + /// 鐢熶骇宸ュ崟 + ///</summary> + [SugarColumn(ColumnName = "TASK_NO")] + public string TaskNo { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] - public string SuppNo { get; set; } + /// <summary> + /// 渚涘簲鍟� + ///</summary> + [SugarColumn(ColumnName = "SUPP_NO")] + public string SuppNo { get; set; } - /// <summary> - /// 浠诲姟姹囨姤鍗� - /// </summary> - [SugarColumn(ColumnName = "RBILL_NO")] - public string RbillNo { get; set; } + /// <summary> + /// 浠诲姟姹囨姤鍗� + ///</summary> + [SugarColumn(ColumnName = "RBILL_NO")] + public string RbillNo { get; set; } - /// <summary> - /// 鐗╂枡ID - /// </summary> - [SugarColumn(ColumnName = "ITEM_ID")] - public decimal? ItemId { get; set; } + /// <summary> + /// 鐗╂枡ID + ///</summary> + [SugarColumn(ColumnName = "ITEM_ID")] + public decimal? ItemId { get; set; } + + /// <summary> + /// 宸ュ崟鎶ュ伐ID (鐢ㄤ簬妫�楠屽崟鏇存柊鎶ュ伐琛ㄤ笂鐨勬楠岀粨鏋�) + ///</summary> + [SugarColumn(ColumnName = "MES_SCGD_GX_ID")] + public decimal? MesScgdGxId { get; set; } + } } \ No newline at end of file -- Gitblit v1.9.3