From 1b972f58f15108fb3c8f2c635527c1d12bf5ba2b Mon Sep 17 00:00:00 2001 From: lg <999544862qq.com> Date: 星期四, 15 八月 2024 14:30:58 +0800 Subject: [PATCH] Merge branch 'master' of http://43.142.96.171:8080/r/~tjx/StandardPda --- MES.Service/Modes/MesInvItemMovesCDetails.cs | 341 +++--- MES.Service/Modes/MesInvItemMoves.cs | 224 ++-- MES.Service/Modes/MesQaItemsDetect01.cs | 422 +++--- MES.Service/service/Warehouse/MesInvItemMovesManager.cs | 190 +++ MES.Service/Modes/MesInvBusiness2.cs | 288 ++-- MES.Service/Modes/MesInvItemBarcodes.cs | 600 +++++----- MES.Service/Modes/MesInvItemInCItems.cs | 184 +- MES.Service/Modes/MesInvItemStocks.cs | 36 MES.Service/Modes/MesQaItemsDetectDetail5.cs | 216 +- MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs | 23 MES.Service/Modes/Purdhb.cs | 352 +++--- MES.Service/Modes/MesInvItemArn.cs | 304 ++-- MES.Service/util/CollectionUtil.cs | 2 MES.Service/Dto/service/WarehouseQuery.cs | 4 MES.Service/Modes/Purdka.cs | 160 +- 15 files changed, 1,779 insertions(+), 1,567 deletions(-) diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs index b3f0734..05428f2 100644 --- a/MES.Service/Dto/service/WarehouseQuery.cs +++ b/MES.Service/Dto/service/WarehouseQuery.cs @@ -19,8 +19,8 @@ public string? Type { get; set; } public string? DepotCode { get; set; } public string? SuppNo { get; set; } - + public string Factory { get; set; } - + public string Company { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvBusiness2.cs b/MES.Service/Modes/MesInvBusiness2.cs index 89ddce5..9ca8594 100644 --- a/MES.Service/Modes/MesInvBusiness2.cs +++ b/MES.Service/Modes/MesInvBusiness2.cs @@ -8,220 +8,220 @@ [SugarTable("MES_INV_BUSINESS2")] public class MesInvBusiness2 { - /// <summary> - /// ID(seq_inv_id) - /// </summary> - [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", + /// <summary> + /// ID(seq_inv_id) + /// </summary> + [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄� - /// </summary> - [SugarColumn(ColumnName = "STATUS")] + /// <summary> + /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄� + /// </summary> + [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } - /// <summary> - /// 鍗曟嵁绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "BILL_TYPE_ID")] + /// <summary> + /// 鍗曟嵁绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "TRANSACTION_CODE")] + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_CODE")] public string TransactionCode { get; set; } - /// <summary> - /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱 - /// </summary> - [SugarColumn(ColumnName = "BUSINESS_TYPE")] + /// <summary> + /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱 + /// </summary> + [SugarColumn(ColumnName = "BUSINESS_TYPE")] public decimal? BusinessType { get; set; } - /// <summary> - /// 鍗曟嵁ID - /// </summary> - [SugarColumn(ColumnName = "BILL_ID")] + /// <summary> + /// 鍗曟嵁ID + /// </summary> + [SugarColumn(ColumnName = "BILL_ID")] public decimal? BillId { get; set; } - /// <summary> - /// 鍗曟嵁缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍗曟嵁缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鐢熶骇璁㈠崟鍙� - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] + /// <summary> + /// 鐢熶骇璁㈠崟鍙� + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } - /// <summary> - /// 瀹㈡埛缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "CUSTOMER_NO")] + /// <summary> + /// 瀹㈡埛缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } - /// <summary> - /// 鍗曟嵁琛孖D - /// </summary> - [SugarColumn(ColumnName = "BILL_LINE_ID")] + /// <summary> + /// 鍗曟嵁琛孖D + /// </summary> + [SugarColumn(ColumnName = "BILL_LINE_ID")] public decimal? BillLineId { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE")] + /// <summary> + /// 鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } - /// <summary> - /// 鏈徃鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鏈徃鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_CODE")] + /// <summary> + /// 瀹㈡埛鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } - /// <summary> - /// 鍘傚鎵规 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鍘傚鎵规 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏄惁鐜繚(0:鍚�,1:鏄�) - /// </summary> - [SugarColumn(ColumnName = "EP_FLAG")] + /// <summary> + /// 鏄惁鐜繚(0:鍚�,1:鏄�) + /// </summary> + [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } - /// <summary> - /// 鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 婧愬瓙搴揅ODE - /// </summary> - [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] + /// <summary> + /// 婧愬瓙搴揅ODE + /// </summary> + [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] public string FromInvDepotsCode { get; set; } - /// <summary> - /// 婧愯揣浣岰ODE - /// </summary> - [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] + /// <summary> + /// 婧愯揣浣岰ODE + /// </summary> + [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] public string FromInvDepotSectionsCode { get; set; } - /// <summary> - /// 鐩殑瀛愬簱CODE - /// </summary> - [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] + /// <summary> + /// 鐩殑瀛愬簱CODE + /// </summary> + [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] public string ToInvDepotsCode { get; set; } - /// <summary> - /// 鐩殑璐т綅CODE - /// </summary> - [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] + /// <summary> + /// 鐩殑璐т綅CODE + /// </summary> + [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] public string ToInvDepotSectionsCode { get; set; } - /// <summary> - /// 浜ゆ槗寮傚父淇℃伅 - /// </summary> - [SugarColumn(ColumnName = "DESCRIPTION")] + /// <summary> + /// 浜ゆ槗寮傚父淇℃伅 + /// </summary> + [SugarColumn(ColumnName = "DESCRIPTION")] public string Description { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 瓒呮崯缁熻鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] + /// <summary> + /// 瓒呮崯缁熻鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] public short? UllageStatFlag { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 绠卞彿鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE2")] + /// <summary> + /// 绠卞彿鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } - /// <summary> - /// 鍗℃澘鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE3")] + /// <summary> + /// 鍗℃澘鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 浠诲姟鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 浠诲姟鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// 鐢熶骇绾� - /// </summary> - [SugarColumn(ColumnName = "LINE_NO")] + /// <summary> + /// 鐢熶骇绾� + /// </summary> + [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟id - /// </summary> - [SugarColumn(ColumnName = "EBELN_K3ID")] + /// <summary> + /// 閲囪喘璁㈠崟id + /// </summary> + [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟琛宨d - /// </summary> - [SugarColumn(ColumnName = "LINE_K3ID")] + /// <summary> + /// 閲囪喘璁㈠崟琛宨d + /// </summary> + [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemArn.cs b/MES.Service/Modes/MesInvItemArn.cs index 518f09f..bf0d207 100644 --- a/MES.Service/Modes/MesInvItemArn.cs +++ b/MES.Service/Modes/MesInvItemArn.cs @@ -8,232 +8,232 @@ [SugarTable("MES_INV_ITEM_ARN")] public class MesInvItemArn { - /// <summary> - /// ID(SEQ_INV_ID) - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// ID(SEQ_INV_ID) + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴 - /// </summary> - [SugarColumn(ColumnName = "STATUS")] + /// <summary> + /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴 + /// </summary> + [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } - /// <summary> - /// 鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "REASON")] + /// <summary> + /// 鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "REASON")] public string Reason { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鍗曟嵁绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "BILL_TYPE_ID")] + /// <summary> + /// 鍗曟嵁绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "TRANSACTION_ID")] + /// <summary> + /// 浜嬪姟绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } - /// <summary> - /// 閫佽揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "PAPER_BILL_NO")] + /// <summary> + /// 閫佽揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "PAPER_BILL_NO")] public string PaperBillNo { get; set; } - /// <summary> - /// 閫�鏂欎汉宸ュ彿 - /// </summary> - [SugarColumn(ColumnName = "USER_NO_BACK")] + /// <summary> + /// 閫�鏂欎汉宸ュ彿 + /// </summary> + [SugarColumn(ColumnName = "USER_NO_BACK")] public string UserNoBack { get; set; } - /// <summary> - /// 鎻愪氦浜� - /// </summary> - [SugarColumn(ColumnName = "CHECK_USER")] + /// <summary> + /// 鎻愪氦浜� + /// </summary> + [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } - /// <summary> - /// 鎻愪氦鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CHECK_DATE")] + /// <summary> + /// 鎻愪氦鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } - /// <summary> - /// 鍏ュ簱鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 鍏ュ簱鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "CHECK_RES")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } - /// <summary> - /// 宸叉崱鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] + /// <summary> + /// 宸叉崱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } - /// <summary> - /// 浠撳簱缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOTS_CODE")] + /// <summary> + /// 浠撳簱缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "TRANSCTION_NO")] + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSCTION_NO")] public string TransctionNo { get; set; } - /// <summary> - /// 渚涘簲鍟嗙紪鐮� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟嗙紪鐮� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// 鎻愪氦鐘舵�� - /// </summary> - [SugarColumn(ColumnName = "FSTATUS")] + /// <summary> + /// 鎻愪氦鐘舵�� + /// </summary> + [SugarColumn(ColumnName = "FSTATUS")] public short? Fstatus { get; set; } - /// <summary> - /// 宸ュ巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 宸ュ巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鏄惁宸插洖鍐橲AP - /// </summary> - [SugarColumn(ColumnName = "SAPSTATUS")] + /// <summary> + /// 鏄惁宸插洖鍐橲AP + /// </summary> + [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } - /// <summary> - /// 纭鍏ュ簱鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 纭鍏ュ簱鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? Insdate { get; set; } - /// <summary> - /// 鏄惁妫�楠� - /// </summary> - [SugarColumn(ColumnName = "ISCHECK")] + /// <summary> + /// 鏄惁妫�楠� + /// </summary> + [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } - /// <summary> - /// 瀹℃牳鍏ュ簱浜� - /// </summary> - [SugarColumn(ColumnName = "INSBY")] + /// <summary> + /// 瀹℃牳鍏ュ簱浜� + /// </summary> + [SugarColumn(ColumnName = "INSBY")] public string Insby { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 鎬ユ枡鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "URGENT_FLAG")] + /// <summary> + /// 鎬ユ枡鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } - /// <summary> - /// 鍐查攢浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "MTTRANSCTION_NO")] + /// <summary> + /// 鍐查攢浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "MTTRANSCTION_NO")] public decimal? MttransctionNo { get; set; } - /// <summary> - /// IQC妫�楠屽崟鍙� - /// </summary> - [SugarColumn(ColumnName = "IQC_RELEASE_NO")] + /// <summary> + /// IQC妫�楠屽崟鍙� + /// </summary> + [SugarColumn(ColumnName = "IQC_RELEASE_NO")] public string IqcReleaseNo { get; set; } - /// <summary> - /// 鏄惁鏄剧ず - /// </summary> - [SugarColumn(ColumnName = "IS_VISUAL")] + /// <summary> + /// 鏄惁鏄剧ず + /// </summary> + [SugarColumn(ColumnName = "IS_VISUAL")] public decimal? IsVisual { get; set; } - /// <summary> - /// 0=閲囪喘锛�1=濮斿 - /// </summary> - [SugarColumn(ColumnName = "F_TYPE")] + /// <summary> + /// 0=閲囪喘锛�1=濮斿 + /// </summary> + [SugarColumn(ColumnName = "F_TYPE")] public decimal? FType { get; set; } - /// <summary> - /// ERP鍒拌揣鍗旾D - /// </summary> - [SugarColumn(ColumnName = "EBELN_K3ID")] + /// <summary> + /// ERP鍒拌揣鍗旾D + /// </summary> + [SugarColumn(ColumnName = "EBELN_K3ID")] public string EbelnK3id { get; set; } - /// <summary> - /// 鏉$爜鏉″嵃杩涘害 - /// </summary> - [SugarColumn(ColumnName = "BARCODE_RATIO")] + /// <summary> + /// 鏉$爜鏉″嵃杩涘害 + /// </summary> + [SugarColumn(ColumnName = "BARCODE_RATIO")] public decimal? BarcodeRatio { get; set; } - /// <summary> - /// ERP鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "ERPNO")] + /// <summary> + /// ERP鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "ERPNO")] public string Erpno { get; set; } - /// <summary> - /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐� - /// </summary> - [SugarColumn(ColumnName = "THSTATUS")] + /// <summary> + /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐� + /// </summary> + [SugarColumn(ColumnName = "THSTATUS")] public short? Thstatus { get; set; } - /// <summary> - /// ERP閫�璐у崟鍙� - /// </summary> - [SugarColumn(ColumnName = "ERPTHNO")] + /// <summary> + /// ERP閫�璐у崟鍙� + /// </summary> + [SugarColumn(ColumnName = "ERPTHNO")] public string Erpthno { get; set; } diff --git a/MES.Service/Modes/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs index 078ac04..0e5e2c0 100644 --- a/MES.Service/Modes/MesInvItemBarcodes.cs +++ b/MES.Service/Modes/MesInvItemBarcodes.cs @@ -8,453 +8,453 @@ [SugarTable("MES_INV_ITEM_BARCODES")] public class MesInvItemBarcodes { - /// <summary> - /// SEQ_BARCODE_PSN_ID - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// SEQ_BARCODE_PSN_ID + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE")] + /// <summary> + /// 鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } - /// <summary> - /// 瀹㈡埛鎴愬搧缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "C_PRODUCT_CODE")] + /// <summary> + /// 瀹㈡埛鎴愬搧缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_PRODUCT_CODE")] public string CProductCode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_BARCODE")] + /// <summary> + /// 瀹㈡埛鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_CODE")] + /// <summary> + /// 瀹㈡埛鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } - /// <summary> - /// 鏈徃鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鏈徃鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 鍘傚鎵规 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鍘傚鎵规 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 鏄惁鐜繚(0:鍚�,1:鏄�) - /// </summary> - [SugarColumn(ColumnName = "EP_FLAG")] + /// <summary> + /// 鏄惁鐜繚(0:鍚�,1:鏄�) + /// </summary> + [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } - /// <summary> - /// 鐢熶骇宸ュ崟 - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] + /// <summary> + /// 鐢熶骇宸ュ崟 + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 瀹㈡埛缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "CUST_NO")] + /// <summary> + /// 瀹㈡埛缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙ - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] + /// <summary> + /// 鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙ + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] public string ItemBarcodeText { get; set; } - /// <summary> - /// 鍘烶SN鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] + /// <summary> + /// 鍘烶SN鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] public string OldItemBarcode { get; set; } - /// <summary> - /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "MBLNR")] + /// <summary> + /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "MBLNR")] public string Mblnr { get; set; } - /// <summary> - /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "ZEILE")] + /// <summary> + /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "ZEILE")] public decimal? Zeile { get; set; } - /// <summary> - /// 鏀舵枡琛↖D - /// </summary> - [SugarColumn(ColumnName = "ROH_IN_ID")] + /// <summary> + /// 鏀舵枡琛↖D + /// </summary> + [SugarColumn(ColumnName = "ROH_IN_ID")] public decimal? RohInId { get; set; } - /// <summary> - /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮� - /// </summary> - [SugarColumn(ColumnName = "BARCODESTATUS")] + /// <summary> + /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮� + /// </summary> + [SugarColumn(ColumnName = "BARCODESTATUS")] public short? Barcodestatus { get; set; } - /// <summary> - /// 鍘熷鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "OLDQTY")] + /// <summary> + /// 鍘熷鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "OLDQTY")] public decimal? Oldqty { get; set; } - /// <summary> - /// 浣跨敤鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "USEQTY")] + /// <summary> + /// 浣跨敤鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "USEQTY")] public decimal? Useqty { get; set; } - /// <summary> - /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾 - /// </summary> - [SugarColumn(ColumnName = "LOCATION")] + /// <summary> + /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾 + /// </summary> + [SugarColumn(ColumnName = "LOCATION")] public short? Location { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } - /// <summary> - /// 閲嶉噺锛堝崟浣嶏細鍏枻锛� - /// </summary> - [SugarColumn(ColumnName = "WEIGHT_UNIT")] + /// <summary> + /// 閲嶉噺锛堝崟浣嶏細鍏枻锛� + /// </summary> + [SugarColumn(ColumnName = "WEIGHT_UNIT")] public decimal? WeightUnit { get; set; } - /// <summary> - /// 鍗曚环 - /// </summary> - [SugarColumn(ColumnName = "PRICE")] + /// <summary> + /// 鍗曚环 + /// </summary> + [SugarColumn(ColumnName = "PRICE")] public decimal? Price { get; set; } - /// <summary> - /// 鍘熸潯鐮佹暟閲� - /// </summary> - [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] + /// <summary> + /// 鍘熸潯鐮佹暟閲� + /// </summary> + [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] public decimal? OldBarQuantity { get; set; } - /// <summary> - /// 姹囨�绘潯鐮� - /// </summary> - [SugarColumn(ColumnName = "SUM_BARCODE")] + /// <summary> + /// 姹囨�绘潯鐮� + /// </summary> + [SugarColumn(ColumnName = "SUM_BARCODE")] public string SumBarcode { get; set; } - /// <summary> - /// 鐢熶骇鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LOT_DATE")] + /// <summary> + /// 鐢熶骇鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } - /// <summary> - /// 妯″彿 - /// </summary> - [SugarColumn(ColumnName = "MOCODE")] + /// <summary> + /// 妯″彿 + /// </summary> + [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } - /// <summary> - /// 鏉ユ簮 - /// </summary> - [SugarColumn(ColumnName = "MEMO")] + /// <summary> + /// 鏉ユ簮 + /// </summary> + [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } - /// <summary> - /// 渚涘簲鍟嗙紪鐮� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟嗙紪鐮� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// 妗d綅浣庡�� - /// </summary> - [SugarColumn(ColumnName = "SPOSTION")] + /// <summary> + /// 妗d綅浣庡�� + /// </summary> + [SugarColumn(ColumnName = "SPOSTION")] public string Spostion { get; set; } - /// <summary> - /// 妗d綅楂樺�� - /// </summary> - [SugarColumn(ColumnName = "EPOSTION")] + /// <summary> + /// 妗d綅楂樺�� + /// </summary> + [SugarColumn(ColumnName = "EPOSTION")] public string Epostion { get; set; } - /// <summary> - /// 鐗╂枡绠�绉� - /// </summary> - [SugarColumn(ColumnName = "ITEM_SNAME")] + /// <summary> + /// 鐗╂枡绠�绉� + /// </summary> + [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } - /// <summary> - /// 鏄惁宸插喕缁�,1鍐荤粨 - /// </summary> - [SugarColumn(ColumnName = "VISABLE")] + /// <summary> + /// 鏄惁宸插喕缁�,1鍐荤粨 + /// </summary> + [SugarColumn(ColumnName = "VISABLE")] public short? Visable { get; set; } - /// <summary> - /// 渚涘簲鍟嗘壒娆� - /// </summary> - [SugarColumn(ColumnName = "TR_LOTNO")] + /// <summary> + /// 渚涘簲鍟嗘壒娆� + /// </summary> + [SugarColumn(ColumnName = "TR_LOTNO")] public string TrLotno { get; set; } - /// <summary> - /// 鍐荤粨鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_DATE")] + /// <summary> + /// 鍐荤粨鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_DATE")] public DateTime? FlezzDate { get; set; } - /// <summary> - /// 鍐荤粨鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_REASON")] + /// <summary> + /// 鍐荤粨鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_REASON")] public string FlezzReason { get; set; } - /// <summary> - /// 鍐荤粨浜� - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_BY")] + /// <summary> + /// 鍐荤粨浜� + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_BY")] public string FlezzBy { get; set; } - /// <summary> - /// 寤堕暱淇濊川鏈� - /// </summary> - [SugarColumn(ColumnName = "DELANY_MONTH")] + /// <summary> + /// 寤堕暱淇濊川鏈� + /// </summary> + [SugarColumn(ColumnName = "DELANY_MONTH")] public decimal? DelanyMonth { get; set; } - /// <summary> - /// 鏈�灏忓寘瑁呮爣璇� - /// </summary> - [SugarColumn(ColumnName = "MINPACK_FLAG")] + /// <summary> + /// 鏈�灏忓寘瑁呮爣璇� + /// </summary> + [SugarColumn(ColumnName = "MINPACK_FLAG")] public short? MinpackFlag { get; set; } - /// <summary> - /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁� - /// </summary> - [SugarColumn(ColumnName = "PRINT_ID")] + /// <summary> + /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁� + /// </summary> + [SugarColumn(ColumnName = "PRINT_ID")] public string PrintId { get; set; } - /// <summary> - /// 鐜繚椤圭洰 - /// </summary> - [SugarColumn(ColumnName = "EP_ITEM")] + /// <summary> + /// 鐜繚椤圭洰 + /// </summary> + [SugarColumn(ColumnName = "EP_ITEM")] public string EpItem { get; set; } - /// <summary> - /// 宸ュ巶缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 宸ュ巶缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 鍗℃澘缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "CB_NO")] + /// <summary> + /// 鍗℃澘缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } - /// <summary> - /// 鍘傚鐢熶骇绾� - /// </summary> - [SugarColumn(ColumnName = "LINFLINE")] + /// <summary> + /// 鍘傚鐢熶骇绾� + /// </summary> + [SugarColumn(ColumnName = "LINFLINE")] public string Linfline { get; set; } - /// <summary> - /// 鏈夋晥鏈� - /// </summary> - [SugarColumn(ColumnName = "VALID_TIME")] + /// <summary> + /// 鏈夋晥鏈� + /// </summary> + [SugarColumn(ColumnName = "VALID_TIME")] public DateTime? ValidTime { get; set; } - /// <summary> - /// 璐ㄦ缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "IQC_STATUS")] + /// <summary> + /// 璐ㄦ缁撴灉 + /// </summary> + [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } - /// <summary> - /// 灏忚溅鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "FCAR")] + /// <summary> + /// 灏忚溅鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } - /// <summary> - /// 姣涢噸 - /// </summary> - [SugarColumn(ColumnName = "GWEIGHT")] + /// <summary> + /// 姣涢噸 + /// </summary> + [SugarColumn(ColumnName = "GWEIGHT")] public string Gweight { get; set; } - /// <summary> - /// 鍑�閲� - /// </summary> - [SugarColumn(ColumnName = "NWEIGHT")] + /// <summary> + /// 鍑�閲� + /// </summary> + [SugarColumn(ColumnName = "NWEIGHT")] public string Nweight { get; set; } - /// <summary> - /// 淇濊川鏈� - /// </summary> - [SugarColumn(ColumnName = "EXT_DATE")] + /// <summary> + /// 淇濊川鏈� + /// </summary> + [SugarColumn(ColumnName = "EXT_DATE")] public decimal? ExtDate { get; set; } - /// <summary> - /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶� - /// </summary> - [SugarColumn(ColumnName = "BARCODETYPE")] + /// <summary> + /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶� + /// </summary> + [SugarColumn(ColumnName = "BARCODETYPE")] public string Barcodetype { get; set; } - /// <summary> - /// 渚涘簲鍟嗗悕绉� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NAME")] + /// <summary> + /// 渚涘簲鍟嗗悕绉� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鎬ユ枡鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "URGENT_FLAG")] + /// <summary> + /// 鎬ユ枡鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } - /// <summary> - /// 棰滆壊 - /// </summary> - [SugarColumn(ColumnName = "COLOR_NAME")] + /// <summary> + /// 棰滆壊 + /// </summary> + [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] + /// <summary> + /// 浜у搧鍨嬪彿 + /// </summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } - /// <summary> - /// 鏉ユ枡鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 鏉ユ枡鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } - /// <summary> - /// 鍒拌揣鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 鍒拌揣鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } - /// <summary> - /// 涓嶈壇鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "MEMO_BAD")] + /// <summary> + /// 涓嶈壇鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "MEMO_BAD")] public string MemoBad { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "COME_FLG")] + /// <summary> + /// 鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "COME_FLG")] public short? ComeFlg { get; set; } - /// <summary> - /// 鐢熶骇绾夸綋 - /// </summary> - [SugarColumn(ColumnName = "LINE_NO")] + /// <summary> + /// 鐢熶骇绾夸綋 + /// </summary> + [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } - /// <summary> - /// 涓濆嵃娆℃暟 - /// </summary> - [SugarColumn(ColumnName = "SILK_PQTY")] + /// <summary> + /// 涓濆嵃娆℃暟 + /// </summary> + [SugarColumn(ColumnName = "SILK_PQTY")] public decimal? SilkPqty { get; set; } - /// <summary> - /// 涓濆嵃娆℃暟姣� - /// </summary> - [SugarColumn(ColumnName = "SILK")] + /// <summary> + /// 涓濆嵃娆℃暟姣� + /// </summary> + [SugarColumn(ColumnName = "SILK")] public string Silk { get; set; } - /// <summary> - /// 涓濆嵃娲惧伐浠庤〃ID - /// </summary> - [SugarColumn(ColumnName = "SILK_ID")] + /// <summary> + /// 涓濆嵃娲惧伐浠庤〃ID + /// </summary> + [SugarColumn(ColumnName = "SILK_ID")] public decimal? SilkId { get; set; } - /// <summary> - /// 宸叉姤宸ユ爣璇� - /// </summary> - [SugarColumn(ColumnName = "WORK_FLG")] + /// <summary> + /// 宸叉姤宸ユ爣璇� + /// </summary> + [SugarColumn(ColumnName = "WORK_FLG")] public decimal? WorkFlg { get; set; } - /// <summary> - /// 鏈�鍚庡伐搴� - /// </summary> - [SugarColumn(ColumnName = "WORK_LAST")] + /// <summary> + /// 鏈�鍚庡伐搴� + /// </summary> + [SugarColumn(ColumnName = "WORK_LAST")] public decimal? WorkLast { get; set; } - /// <summary> - /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃 - /// </summary> - [SugarColumn(ColumnName = "HBDY")] + /// <summary> + /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃 + /// </summary> + [SugarColumn(ColumnName = "HBDY")] public decimal? Hbdy { get; set; } - /// <summary> - /// 0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥 - /// </summary> - [SugarColumn(ColumnName = "HBDYTM")] + /// <summary> + /// 0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥 + /// </summary> + [SugarColumn(ColumnName = "HBDYTM")] public decimal? Hbdytm { get; set; } - /// <summary> - /// 鎶ュ伐鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "WORK_FLGTIME")] + /// <summary> + /// 鎶ュ伐鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "WORK_FLGTIME")] public string WorkFlgtime { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemInCItems.cs b/MES.Service/Modes/MesInvItemInCItems.cs index 05e3293..9c3eb27 100644 --- a/MES.Service/Modes/MesInvItemInCItems.cs +++ b/MES.Service/Modes/MesInvItemInCItems.cs @@ -8,141 +8,141 @@ [SugarTable("MES_INV_ITEM_IN_C_ITEMS")] public class MesInvItemInCItems { - /// <summary> - /// SEQ_OUT - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// SEQ_OUT + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鍏ュ簱鍗昳d - /// </summary> - [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] + /// <summary> + /// 鍏ュ簱鍗昳d + /// </summary> + [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } - /// <summary> - /// 楠屾敹鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 楠屾敹鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 浠撳簱缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_CODE")] + /// <summary> + /// 浠撳簱缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } - /// <summary> - /// 璐т綅缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] + /// <summary> + /// 璐т綅缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } - /// <summary> - /// 鐗硅浜嬮」 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] + /// <summary> + /// 鐗硅浜嬮」 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } - /// <summary> - /// 鐗╂枡绠�绉� - /// </summary> - [SugarColumn(ColumnName = "ITEM_SNAME")] + /// <summary> + /// 鐗╂枡绠�绉� + /// </summary> + [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟 - /// </summary> - [SugarColumn(ColumnName = "EBELN")] + /// <summary> + /// 閲囪喘璁㈠崟 + /// </summary> + [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } - /// <summary> - /// 鍏ュ簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍏ュ簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "EBELN_LINE_NO")] + /// <summary> + /// 琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "CBILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } - /// <summary> - /// 浠诲姟鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 浠诲姟鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } - /// <summary> - /// 鐢熶骇宸ュ崟 - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] + /// <summary> + /// 鐢熶骇宸ュ崟 + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemMoves.cs b/MES.Service/Modes/MesInvItemMoves.cs index b65928e..07b4ba6 100644 --- a/MES.Service/Modes/MesInvItemMoves.cs +++ b/MES.Service/Modes/MesInvItemMoves.cs @@ -8,171 +8,171 @@ [SugarTable("MES_INV_ITEM_MOVES")] public class MesInvItemMoves { - /// <summary> - /// SEQ_INV_ID - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// SEQ_INV_ID + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 绉诲簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 绉诲簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 绉诲叆瀛愬簱id - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOTS_ID")] + /// <summary> + /// 绉诲叆瀛愬簱id + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } - /// <summary> - /// 绉诲叆璐т綅id - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] + /// <summary> + /// 绉诲叆璐т綅id + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鐘舵�亅0-鍒跺崟1-杩囪处 - /// </summary> - [SugarColumn(ColumnName = "STATUS")] + /// <summary> + /// 鐘舵�亅0-鍒跺崟1-杩囪处 + /// </summary> + [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } - /// <summary> - /// 鍗曟嵁绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "BILL_TYPE_ID")] + /// <summary> + /// 鍗曟嵁绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "TRANSACTION_ID")] + /// <summary> + /// 浜嬪姟绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } - /// <summary> - /// 瀹℃牳浜� - /// </summary> - [SugarColumn(ColumnName = "CHECKUSER")] + /// <summary> + /// 瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "CHECKUSER")] public string Checkuser { get; set; } - /// <summary> - /// 瀹℃牳鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CHECKDATE")] + /// <summary> + /// 瀹℃牳鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CHECKDATE")] public DateTime? Checkdate { get; set; } - /// <summary> - /// 绉诲叆瀛愬簱code - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] + /// <summary> + /// 绉诲叆瀛愬簱code + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } - /// <summary> - /// 绉诲叆璐т綅code - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] + /// <summary> + /// 绉诲叆璐т綅code + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "TRANSACTION_NO")] + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } - /// <summary> - /// 绉诲嚭瀛愬簱code - /// </summary> - [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] + /// <summary> + /// 绉诲嚭瀛愬簱code + /// </summary> + [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } - /// <summary> - /// 宸ュ巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY_CODE")] + /// <summary> + /// 宸ュ巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY_CODE")] public string FactoryCode { get; set; } - /// <summary> - /// SAP杩斿洖鍗曟嵁 - /// </summary> - [SugarColumn(ColumnName = "SAPNO")] + /// <summary> + /// SAP杩斿洖鍗曟嵁 + /// </summary> + [SugarColumn(ColumnName = "SAPNO")] public string Sapno { get; set; } - /// <summary> - /// 宸插洖鍐橲AP - /// </summary> - [SugarColumn(ColumnName = "SAPSTATUS")] + /// <summary> + /// 宸插洖鍐橲AP + /// </summary> + [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } - /// <summary> - /// SAP杩斿洖骞翠唤 - /// </summary> - [SugarColumn(ColumnName = "SAPYEAR")] + /// <summary> + /// SAP杩斿洖骞翠唤 + /// </summary> + [SugarColumn(ColumnName = "SAPYEAR")] public short? Sapyear { get; set; } - /// <summary> - /// SAP杩斿洖淇℃伅 - /// </summary> - [SugarColumn(ColumnName = "SAPTEXT")] + /// <summary> + /// SAP杩斿洖淇℃伅 + /// </summary> + [SugarColumn(ColumnName = "SAPTEXT")] public string Saptext { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 鍙嶅鏍镐簨鍔$被鍨嬬紪鐮� - /// </summary> - [SugarColumn(ColumnName = "MTRANSACTION_NO")] + /// <summary> + /// 鍙嶅鏍镐簨鍔$被鍨嬬紪鐮� + /// </summary> + [SugarColumn(ColumnName = "MTRANSACTION_NO")] public decimal? MtransactionNo { get; set; } - /// <summary> - /// 鑷姩淇濆瓨瀛楁 - /// </summary> - [SugarColumn(ColumnName = "ZD_NUM")] + /// <summary> + /// 鑷姩淇濆瓨瀛楁 + /// </summary> + [SugarColumn(ColumnName = "ZD_NUM")] public decimal? ZdNum { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚� - /// </summary> - [SugarColumn(ColumnName = "TS")] + /// <summary> + /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚� + /// </summary> + [SugarColumn(ColumnName = "TS")] public decimal? Ts { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemMovesCDetails.cs b/MES.Service/Modes/MesInvItemMovesCDetails.cs index ec6b0c2..0a6d2cf 100644 --- a/MES.Service/Modes/MesInvItemMovesCDetails.cs +++ b/MES.Service/Modes/MesInvItemMovesCDetails.cs @@ -8,224 +8,225 @@ [SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")] public class MesInvItemMovesCDetails { - /// <summary> - /// seq_inv_id - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// seq_inv_id + /// </summary> + [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", + IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "ITEM_MOVE_ID")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ITEM_MOVE_ID")] public decimal? ItemMoveId { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE")] - public string ItemBarcode { get; set; } + /// <summary> + /// 鐗╂枡鏉$爜 + /// </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 = "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> - /// 鏁伴噺锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 鏁伴噺锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�) - /// </summary> - [SugarColumn(ColumnName = "BARCODE_FLAG")] + /// <summary> + /// 鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�) + /// </summary> + [SugarColumn(ColumnName = "BARCODE_FLAG")] public short? BarcodeFlag { get; set; } - /// <summary> - /// 鐜繚鏍囧織锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 - /// </summary> - [SugarColumn(ColumnName = "EP_FLAG")] + /// <summary> + /// 鐜繚鏍囧織锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 + /// </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")] + /// <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")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 瀛愬簱id - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOTS_ID")] + /// <summary> + /// 瀛愬簱id + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } - /// <summary> - /// 璐т綅id - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] + /// <summary> + /// 璐т綅id + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { 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 = "TASK_NO")] - public string TaskNo { get; set; } + /// <summary> + /// 浠诲姟浠ゅ彿 + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] + public string? TaskNo { get; set; } - /// <summary> - /// 绉诲嚭浠撳簱缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] - public string FromDepotsCode { get; set; } + /// <summary> + /// 绉诲嚭浠撳簱缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] + public string? FromDepotsCode { get; set; } - /// <summary> - /// 绉诲嚭搴撲綅缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")] - public string FromDepotSectionsCode { get; set; } + /// <summary> + /// 绉诲嚭搴撲綅缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")] + public string? FromDepotSectionsCode { 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 = "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 = "BOX_NO")] - public string BoxNo { get; set; } + /// <summary> + /// 绠卞彿 + /// </summary> + [SugarColumn(ColumnName = "BOX_NO")] + public string? BoxNo { get; set; } - /// <summary> - /// 鍗℃澘鍙� - /// </summary> - [SugarColumn(ColumnName = "KO_NO")] - public string KoNo { get; set; } + /// <summary> + /// 鍗℃澘鍙� + /// </summary> + [SugarColumn(ColumnName = "KO_NO")] + public string? KoNo { get; set; } - /// <summary> - /// 绉诲叆浠撳簱缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] - public string InvDepotsCode { get; set; } + /// <summary> + /// 绉诲叆浠撳簱缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] + public string? InvDepotsCode { get; set; } - /// <summary> - /// 绉诲叆搴撲綅缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] - public string InvDepotSectionsCode { get; set; } + /// <summary> + /// 绉诲叆搴撲綅缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] + public string? InvDepotSectionsCode { get; set; } - /// <summary> - /// 璐ㄦ缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "IQC_STATUS")] - public string IqcStatus { get; set; } + /// <summary> + /// 璐ㄦ缁撴灉 + /// </summary> + [SugarColumn(ColumnName = "IQC_STATUS")] + public string? IqcStatus { get; set; } - /// <summary> - /// 灏忚溅缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FCAR")] - public string Fcar { get; set; } + /// <summary> + /// 灏忚溅缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FCAR")] + public string? Fcar { get; set; } - /// <summary> - /// 鍏ュ簱鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INDEP_DATE")] + /// <summary> + /// 鍏ュ簱鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { get; set; } - /// <summary> - /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆 - /// </summary> - [SugarColumn(ColumnName = "VISABLE_SUBMIT")] + /// <summary> + /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆 + /// </summary> + [SugarColumn(ColumnName = "VISABLE_SUBMIT")] public short? VisableSubmit { get; set; } - /// <summary> - /// 鎻愪氦閲嶆浜� - /// </summary> - [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] - public string VisableSubmitBy { get; set; } + /// <summary> + /// 鎻愪氦閲嶆浜� + /// </summary> + [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] + public string? VisableSubmitBy { get; set; } - /// <summary> - /// 鎻愪氦閲嶆鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] + /// <summary> + /// 鎻愪氦閲嶆鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] public DateTime? VisableSubmitDate { 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_NO")] - public string WorkNo { get; set; } + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] + public string? WorkNo { get; set; } - /// <summary> - /// 浠诲姟鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 浠诲姟鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { 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 = "MOVE_OK")] + /// <summary> + /// 璋冨叆 + /// </summary> + [SugarColumn(ColumnName = "MOVE_OK")] public decimal? MoveOk { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemStocks.cs b/MES.Service/Modes/MesInvItemStocks.cs index a867ce8..2a5a4d1 100644 --- a/MES.Service/Modes/MesInvItemStocks.cs +++ b/MES.Service/Modes/MesInvItemStocks.cs @@ -19,25 +19,25 @@ /// 鐢熶骇璁㈠崟 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] - public string TaskNo { get; set; } + public string? TaskNo { get; set; } /// <summary> /// 鐗╂枡鏉$爜 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] - public string ItemBarcode { get; set; } + public string? ItemBarcode { get; set; } /// <summary> /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] - public string CItemCode { get; set; } + public string? CItemCode { get; set; } /// <summary> /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] - public string ItemNo { get; set; } + public string? ItemNo { get; set; } /// <summary> /// 瀛愬簱id @@ -55,7 +55,7 @@ /// 鍘傚鎵规 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] - public string LotNo { get; set; } + public string? LotNo { get; set; } /// <summary> /// 鏁伴噺 @@ -73,7 +73,7 @@ /// 瀹㈡埛缂栫爜 /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] - public string CustomerNo { get; set; } + public string? CustomerNo { get; set; } /// <summary> /// 閲嶉噺 @@ -85,13 +85,13 @@ /// 瀛愬簱CODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] - public string DepotsCode { get; set; } + public string? DepotsCode { get; set; } /// <summary> /// 璐т綅CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] - public string DepotSectionsCode { get; set; } + public string? DepotSectionsCode { get; set; } /// <summary> /// 妫�楠屾棩鏈� @@ -115,25 +115,25 @@ /// 宸ュ巶缂栧彿 /// </summary> [SugarColumn(ColumnName = "FACTORY")] - public string Factory { get; set; } + public string? Factory { get; set; } /// <summary> /// 鍏徃缂栧彿 /// </summary> [SugarColumn(ColumnName = "COMPANY")] - public string Company { get; set; } + public string? Company { get; set; } /// <summary> /// 璐ㄦ鐘舵�� /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] - public string IqcStatus { get; set; } + public string? IqcStatus { get; set; } /// <summary> /// 灏忚溅鏉$爜 /// </summary> [SugarColumn(ColumnName = "FCAR")] - public string Fcar { get; set; } + public string? Fcar { get; set; } /// <summary> /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆 @@ -145,7 +145,7 @@ /// 鎻愪氦閲嶆浜� /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] - public string VisableSubmitBy { get; set; } + public string? VisableSubmitBy { get; set; } /// <summary> /// 鎻愪氦閲嶆鏃堕棿 @@ -157,13 +157,13 @@ /// 浜у搧鍨嬪彿 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] - public string BoardStyle { get; set; } + public string? BoardStyle { get; set; } /// <summary> /// 浠诲姟鍗曞彿 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] - public string WorkNo { get; set; } + public string? WorkNo { get; set; } /// <summary> /// 浠诲姟鍗曡鍙� @@ -175,19 +175,19 @@ /// 渚涘簲鍟� /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] - public string SuppNo { get; set; } + public string? SuppNo { get; set; } /// <summary> /// 鐢熶骇绾� /// </summary> [SugarColumn(ColumnName = "LINE_NO")] - public string LineNo { get; set; } + public string? LineNo { get; set; } /// <summary> /// 鍗婃垚鍝佸叆搴撳崟鍙� /// </summary> [SugarColumn(ColumnName = "BILL_NO")] - public string BillNo { get; set; } + public string? BillNo { get; set; } /// <summary> /// 閲囪喘璁㈠崟id diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs index 2a26d0c..14760fb 100644 --- a/MES.Service/Modes/MesQaItemsDetect01.cs +++ b/MES.Service/Modes/MesQaItemsDetect01.cs @@ -8,324 +8,324 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 妫�楠屽崟鍙� - /// </summary> - [SugarColumn(ColumnName = "RELEASE_NO")] + /// <summary> + /// 妫�楠屽崟鍙� + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_DATE")] + /// <summary> + /// 妫�楠屾棩鏈� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } - /// <summary> - /// 妫�楠屼汉鍛� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_BY")] + /// <summary> + /// 妫�楠屼汉鍛� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 鏉ユ枡鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FBATCH_QTY")] + /// <summary> + /// 鏉ユ枡鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } - /// <summary> - /// 鍒ゅ畾缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "FRECE_QTY")] + /// <summary> + /// 鍒ゅ畾缁撴灉 + /// </summary> + [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FNG_DESC")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_RESU")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FREVIEW")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - /// </summary> - [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } - /// <summary> - /// 妫�楠屾按骞� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_LEVEL")] + /// <summary> + /// 妫�楠屾按骞� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } - /// <summary> - /// 鎷掓敹姘村钩 - /// </summary> - [SugarColumn(ColumnName = "FAC_LEVEL")] + /// <summary> + /// 鎷掓敹姘村钩 + /// </summary> + [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } - /// <summary> - /// 鎵规鍙� --鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鎵规鍙� --鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�� - /// </summary> - [SugarColumn(ColumnName = "FMOVE")] + /// <summary> + /// 鏄惁鎺ㄩ�� + /// </summary> + [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } - /// <summary> - /// 鏄惁澶勭悊 - /// </summary> - [SugarColumn(ColumnName = "FHANDLE")] + /// <summary> + /// 鏄惁澶勭悊 + /// </summary> + [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏇存柊浜� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏇存柊鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG")] + /// <summary> + /// 鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// XRF娴嬭瘯鎶ュ憡缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FCHECK_REPNO")] + /// <summary> + /// XRF娴嬭瘯鎶ュ憡缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } - /// <summary> - /// 绗笁鏂规姤鍛� - /// </summary> - [SugarColumn(ColumnName = "FTHIRD_REP")] + /// <summary> + /// 绗笁鏂规姤鍛� + /// </summary> + [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } - /// <summary> - /// 鏄惁浣滃簾 - /// </summary> - [SugarColumn(ColumnName = "FCANCEL")] + /// <summary> + /// 鏄惁浣滃簾 + /// </summary> + [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } - /// <summary> - /// 鎻愪氦鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "FSUBMIT")] + /// <summary> + /// 鎻愪氦鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } - /// <summary> - /// 妫�楠屼緷鎹� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_ACCORD")] + /// <summary> + /// 妫�楠屼緷鎹� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } - /// <summary> - /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) - /// </summary> - [SugarColumn(ColumnName = "FTYPE")] + /// <summary> + /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) + /// </summary> + [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "ITEM_UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } - /// <summary> - /// 鍑鸿揣鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "OUT_DATE")] + /// <summary> + /// 鍑鸿揣鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } - /// <summary> - /// 鏄惁鍏嶆 - /// </summary> - [SugarColumn(ColumnName = "FEXEMPTION")] + /// <summary> + /// 鏄惁鍏嶆 + /// </summary> + [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } - /// <summary> - /// 妗d綅鏍囧噯 - /// </summary> - [SugarColumn(ColumnName = "FGEAR_STAND")] + /// <summary> + /// 妗d綅鏍囧噯 + /// </summary> + [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } - /// <summary> - /// 涓嶈壇澶勭悊鏂规硶 - /// </summary> - [SugarColumn(ColumnName = "FNG_HANDLE")] + /// <summary> + /// 涓嶈壇澶勭悊鏂规硶 + /// </summary> + [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } - /// <summary> - /// 绠$悊缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FMANAGE_NO")] + /// <summary> + /// 绠$悊缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } - /// <summary> - /// 杞崲鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FCOVERT_QTY")] + /// <summary> + /// 杞崲鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } - /// <summary> - /// 鐗堟湰 - /// </summary> - [SugarColumn(ColumnName = "FVERSION")] + /// <summary> + /// 鐗堟湰 + /// </summary> + [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FSECOND_RESU")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } - /// <summary> - /// 鏈�澶ф娊妫�鏁� - /// </summary> - [SugarColumn(ColumnName = "MAX_CHECK_QTY")] + /// <summary> + /// 鏈�澶ф娊妫�鏁� + /// </summary> + [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } - /// <summary> - /// 鐗瑰畾淇敼鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG1")] + /// <summary> + /// 鐗瑰畾淇敼鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳浜� - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } - /// <summary> - /// 灏忔壒娆″彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO1")] + /// <summary> + /// 灏忔壒娆″彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } - /// <summary> - /// 閲囪喘鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO2")] + /// <summary> + /// 閲囪喘鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] + /// <summary> + /// 浜у搧鍨嬪彿 + /// </summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 鍒拌揣鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "DHA018")] + /// <summary> + /// 鍒拌揣鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "DHB002")] + /// <summary> + /// 琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB001")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "LIFNR")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } - /// <summary> - /// 閫�鏂欐柟寮� - /// </summary> - [SugarColumn(ColumnName = "FMRMODE")] + /// <summary> + /// 閫�鏂欐柟寮� + /// </summary> + [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs index d6159cc..68ee666 100644 --- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs +++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs @@ -8,167 +8,167 @@ [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鏍囧噯鍊肩被鍨� - /// </summary> - [SugarColumn(ColumnName = "FTEXT_TYPE")] + /// <summary> + /// 鏍囧噯鍊肩被鍨� + /// </summary> + [SugarColumn(ColumnName = "FTEXT_TYPE")] public string FtextType { get; set; } - /// <summary> - /// 鏍囧噯鍊� - /// </summary> - [SugarColumn(ColumnName = "FSTAND")] + /// <summary> + /// 鏍囧噯鍊� + /// </summary> + [SugarColumn(ColumnName = "FSTAND")] public decimal? Fstand { get; set; } - /// <summary> - /// 涓婂叕宸� - /// </summary> - [SugarColumn(ColumnName = "FUP_ALLOW")] + /// <summary> + /// 涓婂叕宸� + /// </summary> + [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } - /// <summary> - /// 涓嬪叕宸� - /// </summary> - [SugarColumn(ColumnName = "FDOWN_ALLOW")] + /// <summary> + /// 涓嬪叕宸� + /// </summary> + [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - /// </summary> - [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } - /// <summary> - /// 妫�楠屾按骞� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_LEVEL")] + /// <summary> + /// 妫�楠屾按骞� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } - /// <summary> - /// 鎷掓敹姘村钩 - /// </summary> - [SugarColumn(ColumnName = "FAC_LEVEL")] + /// <summary> + /// 鎷掓敹姘村钩 + /// </summary> + [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } - /// <summary> - /// 妫�楠岄」鐩� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_ITEM")] + /// <summary> + /// 妫�楠岄」鐩� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } - /// <summary> - /// 瑙勬牸瑕佹眰 - /// </summary> - [SugarColumn(ColumnName = "FSPEC_REQU")] + /// <summary> + /// 瑙勬牸瑕佹眰 + /// </summary> + [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QYT")] + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_RESU")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } - /// <summary> - /// AC鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FAC_QTY")] + /// <summary> + /// AC鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } - /// <summary> - /// RE鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FRE_QTY")] + /// <summary> + /// RE鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } - /// <summary> - /// 涓嶅悎鏍兼暟 - /// </summary> - [SugarColumn(ColumnName = "FNG_QTY")] + /// <summary> + /// 涓嶅悎鏍兼暟 + /// </summary> + [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } - /// <summary> - /// 涓嶈壇鐜� - /// </summary> - [SugarColumn(ColumnName = "FNG_RATE")] + /// <summary> + /// 涓嶈壇鐜� + /// </summary> + [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } - /// <summary> - /// 宸插綍鍏ユ暟閲� - /// </summary> - [SugarColumn(ColumnName = "FENTER_QTY")] + /// <summary> + /// 宸插綍鍏ユ暟閲� + /// </summary> + [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "RELEASE_NO")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 妫�楠岄」鐩弿杩� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] + /// <summary> + /// 妫�楠岄」鐩弿杩� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string FcheckItemDesc { get; set; } - /// <summary> - /// 宸ュ簭鍙� - /// </summary> - [SugarColumn(ColumnName = "PROC_NO")] + /// <summary> + /// 宸ュ簭鍙� + /// </summary> + [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } - /// <summary> - /// 宸ヤ綔涓績缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] + /// <summary> + /// 宸ヤ綔涓績缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "FUNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "FUNIT")] public string Funit { get; set; } - /// <summary> - /// 鐗瑰畾淇敼 - /// </summary> - [SugarColumn(ColumnName = "GIVEN_MODIFY")] + /// <summary> + /// 鐗瑰畾淇敼 + /// </summary> + [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } - /// <summary> - /// 妫�楠屽伐鍏� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_TOOL")] + /// <summary> + /// 妫�楠屽伐鍏� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } - /// <summary> - /// 鏇存柊浜� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏇存柊鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/Purdhb.cs b/MES.Service/Modes/Purdhb.cs index 7fff6ee..b8de0cc 100644 --- a/MES.Service/Modes/Purdhb.cs +++ b/MES.Service/Modes/Purdhb.cs @@ -8,267 +8,267 @@ [SugarTable("PURDHB")] public class Purdhb { - /// <summary> - /// 鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB001")] + /// <summary> + /// 鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } - /// <summary> - /// 搴忓彿 - /// </summary> - [SugarColumn(ColumnName = "DHB002")] + /// <summary> + /// 搴忓彿 + /// </summary> + [SugarColumn(ColumnName = "DHB002")] public string Dhb002 { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DHB003")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DHB003")] public string Dhb003 { get; set; } - /// <summary> - /// 鐗╂枡鍚嶇О - /// </summary> - [SugarColumn(ColumnName = "DHB004")] + /// <summary> + /// 鐗╂枡鍚嶇О + /// </summary> + [SugarColumn(ColumnName = "DHB004")] public string Dhb004 { get; set; } - /// <summary> - /// 鐗╂枡瑙勬牸 - /// </summary> - [SugarColumn(ColumnName = "DHB005")] + /// <summary> + /// 鐗╂枡瑙勬牸 + /// </summary> + [SugarColumn(ColumnName = "DHB005")] public string Dhb005 { get; set; } - /// <summary> - /// 浜よ揣鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB006")] + /// <summary> + /// 浜よ揣鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB006")] public decimal? Dhb006 { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "DHB007")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "DHB007")] public string Dhb007 { get; set; } - /// <summary> - /// 浠撳簱 - /// </summary> - [SugarColumn(ColumnName = "DHB008")] + /// <summary> + /// 浠撳簱 + /// </summary> + [SugarColumn(ColumnName = "DHB008")] public string Dhb008 { get; set; } - /// <summary> - /// 浠撳簱鍚嶇О - /// </summary> - [SugarColumn(ColumnName = "DHB009")] + /// <summary> + /// 浠撳簱鍚嶇О + /// </summary> + [SugarColumn(ColumnName = "DHB009")] public string Dhb009 { get; set; } - /// <summary> - /// 鎵瑰彿 - /// </summary> - [SugarColumn(ColumnName = "DHB010")] + /// <summary> + /// 鎵瑰彿 + /// </summary> + [SugarColumn(ColumnName = "DHB010")] public string Dhb010 { get; set; } - /// <summary> - /// 鏉ユ簮鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB011")] + /// <summary> + /// 鏉ユ簮鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB011")] public string Dhb011 { get; set; } - /// <summary> - /// 鏉ユ簮搴忓彿 - /// </summary> - [SugarColumn(ColumnName = "DHB012")] + /// <summary> + /// 鏉ユ簮搴忓彿 + /// </summary> + [SugarColumn(ColumnName = "DHB012")] public decimal? Dhb012 { get; set; } - /// <summary> - /// 娓呯偣鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB013")] + /// <summary> + /// 娓呯偣鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB013")] public decimal? Dhb013 { get; set; } - /// <summary> - /// 鍒板巶鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "DHB014")] + /// <summary> + /// 鍒板巶鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "DHB014")] public string Dhb014 { get; set; } - /// <summary> - /// 楠屾敹鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB015")] + /// <summary> + /// 楠屾敹鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB015")] public decimal? Dhb015 { get; set; } - /// <summary> - /// 楠岄��鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB016")] + /// <summary> + /// 楠岄��鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB016")] public decimal? Dhb016 { get; set; } - /// <summary> - /// 杩涜揣鍗曚环 - /// </summary> - [SugarColumn(ColumnName = "DHB017")] + /// <summary> + /// 杩涜揣鍗曚环 + /// </summary> + [SugarColumn(ColumnName = "DHB017")] public decimal? Dhb017 { get; set; } - /// <summary> - /// 杩涜揣閲戦 - /// </summary> - [SugarColumn(ColumnName = "DHB018")] + /// <summary> + /// 杩涜揣閲戦 + /// </summary> + [SugarColumn(ColumnName = "DHB018")] public decimal? Dhb018 { get; set; } - /// <summary> - /// 瀹㈡埛鏂欏彿 - /// </summary> - [SugarColumn(ColumnName = "DHB019")] + /// <summary> + /// 瀹㈡埛鏂欏彿 + /// </summary> + [SugarColumn(ColumnName = "DHB019")] public string Dhb019 { get; set; } - /// <summary> - /// 閮ㄩ棬缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "DHB020")] + /// <summary> + /// 閮ㄩ棬缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "DHB020")] public string Dhb020 { get; set; } - /// <summary> - /// 璧犲搧鏁� - /// </summary> - [SugarColumn(ColumnName = "DHB021")] + /// <summary> + /// 璧犲搧鏁� + /// </summary> + [SugarColumn(ColumnName = "DHB021")] public decimal? Dhb021 { get; set; } - /// <summary> - /// 鏇存柊ERP - /// </summary> - [SugarColumn(ColumnName = "DHB022")] + /// <summary> + /// 鏇存柊ERP + /// </summary> + [SugarColumn(ColumnName = "DHB022")] public string Dhb022 { get; set; } - /// <summary> - /// 妫�楠岀姸鎬� - /// </summary> - [SugarColumn(ColumnName = "DHB023")] + /// <summary> + /// 妫�楠岀姸鎬� + /// </summary> + [SugarColumn(ColumnName = "DHB023")] public string Dhb023 { get; set; } - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "DHB024")] + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "DHB024")] public string Dhb024 { get; set; } - /// <summary> - /// 瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "AUDITING")] + /// <summary> + /// 瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "AUDITING")] public decimal? Auditing { get; set; } - /// <summary> - /// ERP閲囪喘鍗曞彿ID - /// </summary> - [SugarColumn(ColumnName = "DHB026")] + /// <summary> + /// ERP閲囪喘鍗曞彿ID + /// </summary> + [SugarColumn(ColumnName = "DHB026")] public decimal? Dhb026 { get; set; } - /// <summary> - /// ERP閲囪喘搴忓彿ID - /// </summary> - [SugarColumn(ColumnName = "DHB027")] + /// <summary> + /// ERP閲囪喘搴忓彿ID + /// </summary> + [SugarColumn(ColumnName = "DHB027")] public decimal? Dhb027 { get; set; } - /// <summary> - /// ERP鐗╂枡ID - /// </summary> - [SugarColumn(ColumnName = "DHB028")] + /// <summary> + /// ERP鐗╂枡ID + /// </summary> + [SugarColumn(ColumnName = "DHB028")] public decimal? Dhb028 { get; set; } - /// <summary> - /// 寰呮鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB029")] + /// <summary> + /// 寰呮鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB029")] public decimal? Dhb029 { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "DHB030")] + /// <summary> + /// 妫�楠屾棩鏈� + /// </summary> + [SugarColumn(ColumnName = "DHB030")] public string Dhb030 { get; set; } - /// <summary> - /// 妫�楠屽憳 - /// </summary> - [SugarColumn(ColumnName = "DHB031")] + /// <summary> + /// 妫�楠屽憳 + /// </summary> + [SugarColumn(ColumnName = "DHB031")] public string Dhb031 { get; set; } - /// <summary> - /// 鍏ュ簱鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB032")] + /// <summary> + /// 鍏ュ簱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB032")] public decimal? Dhb032 { get; set; } - /// <summary> - /// 鍏ュ簱浜� - /// </summary> - [SugarColumn(ColumnName = "DHB033")] + /// <summary> + /// 鍏ュ簱浜� + /// </summary> + [SugarColumn(ColumnName = "DHB033")] public string Dhb033 { get; set; } - /// <summary> - /// 鍏ュ簱鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "DHB034")] + /// <summary> + /// 鍏ュ簱鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "DHB034")] public string Dhb034 { get; set; } - /// <summary> - /// 閫�璐ф暟閲� - /// </summary> - [SugarColumn(ColumnName = "DHB035")] + /// <summary> + /// 閫�璐ф暟閲� + /// </summary> + [SugarColumn(ColumnName = "DHB035")] public decimal? Dhb035 { get; set; } - /// <summary> - /// ERPID - /// </summary> - [SugarColumn(ColumnName = "DHB037")] + /// <summary> + /// ERPID + /// </summary> + [SugarColumn(ColumnName = "DHB037")] public decimal? Dhb037 { get; set; } - /// <summary> - /// 閫�璐т汉 - /// </summary> - [SugarColumn(ColumnName = "DHB036")] + /// <summary> + /// 閫�璐т汉 + /// </summary> + [SugarColumn(ColumnName = "DHB036")] public string Dhb036 { get; set; } - /// <summary> - /// ERP鍘熷垎褰曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB038")] + /// <summary> + /// ERP鍘熷垎褰曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB038")] public decimal? Dhb038 { get; set; } - /// <summary> - /// ERP婧愬崟鍐呯爜 - /// </summary> - [SugarColumn(ColumnName = "DHB039")] + /// <summary> + /// ERP婧愬崟鍐呯爜 + /// </summary> + [SugarColumn(ColumnName = "DHB039")] public decimal? Dhb039 { get; set; } - /// <summary> - /// ERP婧愬崟绫诲瀷 - /// </summary> - [SugarColumn(ColumnName = "DHB040")] + /// <summary> + /// ERP婧愬崟绫诲瀷 + /// </summary> + [SugarColumn(ColumnName = "DHB040")] public decimal? Dhb040 { get; set; } - /// <summary> - /// ERP璁㈠崟鍐呯爜 - /// </summary> - [SugarColumn(ColumnName = "DHB041")] + /// <summary> + /// ERP璁㈠崟鍐呯爜 + /// </summary> + [SugarColumn(ColumnName = "DHB041")] public decimal? Dhb041 { get; set; } - /// <summary> - /// 鑷鍒� - /// </summary> - [SugarColumn(ColumnName = "ID")] + /// <summary> + /// 鑷鍒� + /// </summary> + [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } - /// <summary> - /// 鏄惁妫�楠岋紝1涓哄凡妫� - /// </summary> - [SugarColumn(ColumnName = "ISCHECK")] + /// <summary> + /// 鏄惁妫�楠岋紝1涓哄凡妫� + /// </summary> + [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } - /// <summary> - /// 浠撳簱 - /// </summary> - [SugarColumn(ColumnName = "DHB042")] + /// <summary> + /// 浠撳簱 + /// </summary> + [SugarColumn(ColumnName = "DHB042")] public string Dhb042 { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/Purdka.cs b/MES.Service/Modes/Purdka.cs index 1c3ea40..4330c13 100644 --- a/MES.Service/Modes/Purdka.cs +++ b/MES.Service/Modes/Purdka.cs @@ -8,123 +8,123 @@ [SugarTable("PURDKA")] public class Purdka { - /// <summary> - /// 鑷鍒� - /// </summary> - [SugarColumn(ColumnName = "ID")] + /// <summary> + /// 鑷鍒� + /// </summary> + [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } - /// <summary> - /// 鍒涘缓浜哄憳 - /// </summary> - [SugarColumn(ColumnName = "CREATEUSER")] + /// <summary> + /// 鍒涘缓浜哄憳 + /// </summary> + [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATETIME")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } - /// <summary> - /// 淇敼鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "MODIFYTIME")] + /// <summary> + /// 淇敼鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "MODIFYTIME")] public string Modifytime { get; set; } - /// <summary> - /// 淇敼浜哄憳 - /// </summary> - [SugarColumn(ColumnName = "MODIFYUSER")] + /// <summary> + /// 淇敼浜哄憳 + /// </summary> + [SugarColumn(ColumnName = "MODIFYUSER")] public string Modifyuser { get; set; } - /// <summary> - /// 瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "AUDITING")] + /// <summary> + /// 瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } - /// <summary> - /// 閫�璐у崟鍙� - /// </summary> - [SugarColumn(ColumnName = "DKA001")] + /// <summary> + /// 閫�璐у崟鍙� + /// </summary> + [SugarColumn(ColumnName = "DKA001")] public string Dka001 { get; set; } - /// <summary> - /// 閫�璐х被鍨� - /// </summary> - [SugarColumn(ColumnName = "DKA002")] + /// <summary> + /// 閫�璐х被鍨� + /// </summary> + [SugarColumn(ColumnName = "DKA002")] public string Dka002 { get; set; } - /// <summary> - /// 閫�璐ф棩鏈� - /// </summary> - [SugarColumn(ColumnName = "DKA003")] + /// <summary> + /// 閫�璐ф棩鏈� + /// </summary> + [SugarColumn(ColumnName = "DKA003")] public string Dka003 { get; set; } - /// <summary> - /// 閫�璐ф椂闂� - /// </summary> - [SugarColumn(ColumnName = "DKA004")] + /// <summary> + /// 閫�璐ф椂闂� + /// </summary> + [SugarColumn(ColumnName = "DKA004")] public string Dka004 { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "DKA005")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "DKA005")] public string Dka005 { get; set; } - /// <summary> - /// 渚涘簲鍟嗗悕绉� - /// </summary> - [SugarColumn(ColumnName = "DKA006")] + /// <summary> + /// 渚涘簲鍟嗗悕绉� + /// </summary> + [SugarColumn(ColumnName = "DKA006")] public string Dka006 { get; set; } - /// <summary> - /// 閮ㄩ棬 - /// </summary> - [SugarColumn(ColumnName = "DKA007")] + /// <summary> + /// 閮ㄩ棬 + /// </summary> + [SugarColumn(ColumnName = "DKA007")] public string Dka007 { get; set; } - /// <summary> - /// 瀹℃牳鑰� - /// </summary> - [SugarColumn(ColumnName = "DKA008")] + /// <summary> + /// 瀹℃牳鑰� + /// </summary> + [SugarColumn(ColumnName = "DKA008")] public string Dka008 { get; set; } - /// <summary> - /// 瀹℃牳鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "DKA009")] + /// <summary> + /// 瀹℃牳鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "DKA009")] public string Dka009 { get; set; } - /// <summary> - /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹� - /// </summary> - [SugarColumn(ColumnName = "DKA010")] + /// <summary> + /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹� + /// </summary> + [SugarColumn(ColumnName = "DKA010")] public string Dka010 { get; set; } - /// <summary> - /// ERPID - /// </summary> - [SugarColumn(ColumnName = "ERPID")] + /// <summary> + /// ERPID + /// </summary> + [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } - /// <summary> - /// 淇濈鍛樼紪鐮� - /// </summary> - [SugarColumn(ColumnName = "DKA011")] + /// <summary> + /// 淇濈鍛樼紪鐮� + /// </summary> + [SugarColumn(ColumnName = "DKA011")] public string Dka011 { get; set; } - /// <summary> - /// 楠屾敹鍛樼紪鐮� - /// </summary> - [SugarColumn(ColumnName = "DKA012")] + /// <summary> + /// 楠屾敹鍛樼紪鐮� + /// </summary> + [SugarColumn(ColumnName = "DKA012")] public string Dka012 { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫� - /// </summary> - [SugarColumn(ColumnName = "DKA013")] + /// <summary> + /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫� + /// </summary> + [SugarColumn(ColumnName = "DKA013")] public decimal? Dka013 { get; set; } } \ No newline at end of file diff --git a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs index 59d36c3..a529385 100644 --- a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs +++ b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs @@ -1,6 +1,7 @@ 锘縰sing MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; +using MES.Service.util; using SqlSugar; namespace MES.Service.service.Warehouse; @@ -25,6 +26,193 @@ .OrderBy(it => it.Id, OrderByType.Desc).ToList(); } + + public OutItemDto ScanMoveBarcode(WarehouseQuery query) + { + var BillTypeId = 300; + var TransctionNo = 301; + query.Factory = "1000"; + query.Company = "1000"; + + if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�"); + + var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() + .Where(s => s.ItemBarcode == query.barcode && + s.Quantity > 0 && s.DepotsCode != null).First(); + if (mesInvItemStocks == null) + throw new Exception("搴撳瓨涓棤姝ゆ潯鐮侊紝璇锋牳瀵癸紒" + query.barcode); + + var mesInvItemMoves = Db.Queryable<MesInvItemMoves>() + .Where(d => d.TransactionNo == TransctionNo + && SqlFunc.IsNull(d.Status, 0) == 1).First(); + + if (mesInvItemMoves == null) + throw new Exception("鍑哄簱鍗� " + query.billNo + "涓嶅瓨鍦紝璇风‘璁わ紒"); + + var count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>( + (a, b) => + new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId)) + .Where((a, b) => b.ItemBarcode == query.barcode + && a.TransactionNo == TransctionNo && + SqlFunc.IsNull(a.Status, 0) == 0).Count(); + if (count > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�"); + + count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) => + new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId)) + .Where((a, b) => b.ItemBarcode == query.barcode + && a.TransactionNo == TransctionNo && + SqlFunc.IsNull(b.MoveOk, 0) == 0).Count(); + + if (count > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�"); + + if (mesInvItemMoves.FromDepotsCode != mesInvItemStocks.DepotsCode) + throw new Exception("鏉$爜鐜板瓨浠撳簱涓庣敵璇峰嚭璐т粨搴撲笉涓�鑷达紝璇锋牳瀵癸紒"); + + var quantity = Db.Queryable<MesInvItemOutItems>() + .Where(b => b.ItemNo == mesInvItemStocks.ItemNo + && b.ItemOutId == mesInvItemMoves.Id) + .Sum(b => b.Quantity); + + if (quantity == null) + throw new Exception("鎵爜鐗╂枡闈炴湰娆$敵璇风墿鏂欙紝璇锋牳瀵癸紒" + query.barcode); + + var sum = Db.Queryable<MesInvItemMovesCDetails>() + .Where(b => b.ItemNo == mesInvItemStocks.ItemNo + && b.ItemMoveId == mesInvItemMoves.Id) + .Sum(b => b.Quantity) ?? 0; + + var sumqty = sum + (mesInvItemStocks.Quantity ?? 0); + + if (sumqty > quantity) + throw new Exception( + "宸叉壂鏉$爜鏁伴噺鎴栨湰娆℃壂鐮佹暟閲忥細" + sumqty + " 澶т簬鐢宠鏁伴噺锛�" + quantity + "锛岃鏍稿锛�"); + + List<InventoryItem> scanOutShowDb = null; + + UseTransaction(db => + { + SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves, + mesInvItemStocks); + + // Insert into mes_inv_business2 + SaveMesInvBusiness2(db, query, BillTypeId, TransctionNo, + mesInvItemStocks, mesInvItemMoves); + + if (TransctionNo == 303) + db.Updateable<MesInvItemStocks>() + .SetColumns(s => + s.DepotSectionsCode == mesInvItemMoves.InvDepotsCode) + .SetColumns(s => + s.DepotsCode == mesInvItemMoves.InvDepotsCode) + .Where(s => s.Id == mesInvItemStocks.Id) + .ExecuteCommand(); + else + db.Updateable<MesInvItemStocks>() + .SetColumns(s => s.DepotSectionsCode == null) + .SetColumns(s => s.DepotsCode == null) + .Where(s => s.Id == mesInvItemStocks.Id) + .ExecuteCommand(); + + scanOutShowDb = ScanOutShowDb(query); + if (CollectionUtil.IsNullOrEmpty(scanOutShowDb)) + db.Updateable<MesInvItemMoves>() + .SetColumns(s => s.Status == 1) + .SetColumns(s => s.Checkdate == DateTime.Now) + .SetColumns(s => s.Checkuser == query.userName) + .Where(s => s.BillNo == query.billNo).ExecuteCommand(); + + return 1; + }); + + var itemDto = new OutItemDto(); + itemDto.SumItem = scanOutShowDb; + + if (TransctionNo == 201) itemDto.Quantity = mesInvItemStocks.Quantity; + + itemDto.ItemNo = mesInvItemStocks.ItemNo; + + return itemDto; + } + + private void SaveMesInvBusiness2(SqlSugarScope Db, WarehouseQuery query, + int BillTypeId, + int TransctionNo, MesInvItemStocks mesInvItemStocks, + MesInvItemMoves mesInvItemMoves) + { + var executeCommand = Db.Insertable(new MesInvBusiness2 + { + Status = 1, + BillTypeId = BillTypeId, + TransactionCode = TransctionNo.ToString(), + BusinessType = 1, + ItemBarcode = query.barcode, + ItemNo = mesInvItemStocks.ItemNo, + LotNo = mesInvItemStocks.LotNo, + EpFlag = 1, + Quantity = mesInvItemStocks.Quantity, + FromInvDepotsCode = mesInvItemStocks.DepotsCode, + FromInvDepotSectionsCode = mesInvItemStocks.DepotSectionsCode, + ToInvDepotsCode = TransctionNo == 303 + ? mesInvItemMoves.InvDepotsCode + : null, + ToInvDepotSectionsCode = TransctionNo == 303 + ? mesInvItemMoves.InvDepotsCode + : null, + CreateBy = query.userName, + CreateDate = DateTime.Now, + LastupdateBy = query.userName, + LastupdateDate = DateTime.Now, + Factory = query.Factory, + Company = query.Company, + TaskNo = mesInvItemStocks.TaskNo, + BillNo = query.billNo, + WorkNo = mesInvItemStocks.WorkNo, + WorkLine = mesInvItemStocks.WorkLine, + SuppNo = mesInvItemStocks.SuppNo + }).ExecuteCommand(); + + if (executeCommand <= 0) throw new Exception("鍐欏叆MesInvBusiness2琛ㄥけ璐�"); + } + + private void SaveMesInvItemMovesCDetails(SqlSugarScope Db, + WarehouseQuery query, + MesInvItemMoves mesInvItemMoves, MesInvItemStocks mesInvItemStocks) + { + var executeCommand = Db.Insertable(new MesInvItemMovesCDetails + { + ItemMoveId = mesInvItemMoves.Id, + ItemBarcode = query.barcode, + CItemCode = mesInvItemStocks.CItemCode, + ItemNo = mesInvItemStocks.ItemNo, + LotNo = mesInvItemStocks.LotNo, + Quantity = mesInvItemStocks.Quantity, + EpFlag = mesInvItemStocks.EpFlag, + CreateBy = query.userName, + CreateDate = DateTime.Now, + LastupdateBy = query.userName, + LastupdateDate = DateTime.Now, + CustNo = mesInvItemStocks.CustomerNo, + TaskNo = mesInvItemStocks.TaskNo, + FromDepotsCode = mesInvItemStocks.DepotsCode, + FromDepotSectionsCode = mesInvItemStocks.DepotSectionsCode, + Factory = mesInvItemStocks.Factory, + Company = mesInvItemStocks.Company, + IqcStatus = mesInvItemStocks.IqcStatus, + Fcar = mesInvItemStocks.Fcar, + IndepDate = mesInvItemStocks.IndepDate, + VisableSubmit = mesInvItemStocks.VisableSubmit, + VisableSubmitBy = mesInvItemStocks.VisableSubmitBy, + VisableSubmitDate = mesInvItemStocks.VisableSubmitDate, + BoardStyle = mesInvItemStocks.BoardStyle, + WorkNo = mesInvItemStocks.WorkNo, + WorkLine = mesInvItemStocks.WorkLine, + SuppNo = mesInvItemStocks.SuppNo + }).ExecuteCommand(); + + if (executeCommand <= 0) + throw new Exception("鍐欏叆MesInvItemMovesCDetails琛ㄥけ璐�"); + } + //scan_out_show_DB public List<InventoryItem> ScanOutShowDb(WarehouseQuery query) { @@ -33,6 +221,8 @@ query.Factory = "1000"; query.Company = "1000"; + if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�"); + var sql = string.Format( "select f_get_sections_code({0}, {1}, b.item_no) sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0 and rownum < 500 AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ", query.Factory, query.Company, BillTypeId, TransctionNo, diff --git a/MES.Service/util/CollectionUtil.cs b/MES.Service/util/CollectionUtil.cs index 0652cd3..267fcd4 100644 --- a/MES.Service/util/CollectionUtil.cs +++ b/MES.Service/util/CollectionUtil.cs @@ -8,7 +8,7 @@ */ public static bool IsNullOrEmpty<T>(List<T> list) { - return list == null || !list.Any(); + return list == null || list.Count == 0; } /** diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs index d8106fb..8a5d626 100644 --- a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs +++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs @@ -13,6 +13,27 @@ { private readonly MesInvItemMovesManager m = new(); + //ScanMoveBarcode + [HttpPost("ScanMoveBarcode")] + public ResponseResult ScanMoveBarcode(WarehouseQuery query) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.ScanMoveBarcode(query); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + // GetBillNo [HttpPost("GetBillNo")] public ResponseResult GetBillNo(WarehouseQuery query) @@ -33,7 +54,7 @@ return ResponseResult.ResponseError(ex); } } - + //ScanOutShowDb [HttpPost("ScanOutShowDb")] public ResponseResult ScanOutShowDb(WarehouseQuery query) -- Gitblit v1.9.3