From 2276feb4375d99c0424091bb32c1d5d92b67d41b Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期二, 26 十一月 2024 09:31:27 +0800
Subject: [PATCH] 委外变更单更新运行存储过程
---
MES.Service/Modes/MesInvItemInCDetails.cs | 104 +++++++++++++++++-----------------------------------
1 files changed, 34 insertions(+), 70 deletions(-)
diff --git a/MES.Service/Modes/MesInvItemInCDetails.cs b/MES.Service/Modes/MesInvItemInCDetails.cs
index 3d9399a..0bf8253 100644
--- a/MES.Service/Modes/MesInvItemInCDetails.cs
+++ b/MES.Service/Modes/MesInvItemInCDetails.cs
@@ -13,31 +13,31 @@
/// </summary>
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
IsPrimaryKey = true)]
- public decimal? Id { get; set; }
+ public decimal Id { get; set; }
/// <summary>
/// 鍏ュ簱鍗昳d
/// </summary>
[SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
- public decimal? ItemInId { get; set; }
+ public decimal ItemInId { get; set; }
/// <summary>
/// 鐗╂枡鏉＄爜PSN
/// </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 = "C_ITEM_BARCODE")]
- public string? CItemBarcode { get; set; }
+ public string CItemBarcode { get; set; }
/// <summary>
/// 楠屾敹鏁伴噺
@@ -61,7 +61,7 @@
/// 鍒涘缓浜�
/// </summary>
[SugarColumn(ColumnName = "CREATE_BY")]
- public string? CreateBy { get; set; }
+ public string CreateBy { get; set; }
/// <summary>
/// 鍒涘缓鏃堕棿
@@ -73,7 +73,7 @@
/// 鏈�鍚庢洿鏂颁汉
/// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
+ public string LastupdateBy { get; set; }
/// <summary>
/// 鏈�鍚庢洿鏂版椂闂�
@@ -91,13 +91,13 @@
/// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
/// </summary>
[SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
+ public string ItemNo { get; set; }
/// <summary>
/// 鍘傚鎵规
/// </summary>
[SugarColumn(ColumnName = "LOT_NO")]
- public string? LotNo { get; set; }
+ public string LotNo { get; set; }
/// <summary>
/// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�)
@@ -109,13 +109,13 @@
/// 瀹㈡埛缂栫爜
/// </summary>
[SugarColumn(ColumnName = "CUST_NO")]
- public string? CustNo { get; set; }
+ public string CustNo { get; set; }
/// <summary>
/// 妫�楠岀粨鏋�
/// </summary>
[SugarColumn(ColumnName = "CHECK_RES")]
- public string? CheckRes { get; set; }
+ public string CheckRes { get; set; }
/// <summary>
/// 杩涜揣鏁伴噺
@@ -127,7 +127,7 @@
/// 妫�楠岀姸鎬�
/// </summary>
[SugarColumn(ColumnName = "CHECK_STATES")]
- public string? CheckStates { get; set; }
+ public string CheckStates { get; set; }
/// <summary>
/// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤
@@ -139,31 +139,31 @@
/// 浠撳簱缂栫爜
/// </summary>
[SugarColumn(ColumnName = "DEPOT_CODE")]
- public string? DepotCode { get; set; }
+ public string DepotCode { get; set; }
/// <summary>
/// 璐т綅缂栫爜
/// </summary>
[SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
- public string? DepotSectionCode { get; set; }
+ public string DepotSectionCode { get; set; }
/// <summary>
/// 鐗硅浜嬮」
/// </summary>
[SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
+ public string Remark { get; set; }
/// <summary>
/// 鐗╂枡鏉＄爜
/// </summary>
[SugarColumn(ColumnName = "ITEM_BARCODE2")]
- public string? ItemBarcode2 { get; set; }
+ public string ItemBarcode2 { get; set; }
/// <summary>
/// 鏂版潯鐮�
/// </summary>
[SugarColumn(ColumnName = "ITEM_BARCODE3")]
- public string? ItemBarcode3 { get; set; }
+ public string ItemBarcode3 { get; set; }
/// <summary>
/// 浣跨敤鏁伴噺
@@ -181,7 +181,7 @@
/// 鐗╂枡绠�绉�
/// </summary>
[SugarColumn(ColumnName = "ITEM_SNAME")]
- public string? ItemSname { get; set; }
+ public string ItemSname { get; set; }
/// <summary>
/// 妗ｄ綅浣庡��
@@ -205,7 +205,7 @@
/// 鍗曚綅
/// </summary>
[SugarColumn(ColumnName = "UNIT")]
- public string? Unit { get; set; }
+ public string Unit { get; set; }
/// <summary>
/// 鏄惁妫�楠�
@@ -217,19 +217,19 @@
/// 閲囪喘璁㈠崟
/// </summary>
[SugarColumn(ColumnName = "EBELN")]
- public string? Ebeln { get; set; }
+ public string Ebeln { get; set; }
/// <summary>
/// 鐢熶骇鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "LOT_DATE")]
- public string? LotDate { get; set; }
+ public string LotDate { get; set; }
/// <summary>
/// 鍏ュ簱鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
- public string? BillNo { get; set; }
+ public string BillNo { get; set; }
/// <summary>
/// 鍏ュ簱瀹℃牳鏍囧織
@@ -241,25 +241,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 = "CB_NO")]
- public string? CbNo { get; set; }
+ public string CbNo { get; set; }
/// <summary>
/// 绠卞彿
/// </summary>
[SugarColumn(ColumnName = "BOX_NO")]
- public string? BoxNo { get; set; }
+ public string BoxNo { get; set; }
/// <summary>
/// 浠撳簱ID
@@ -277,7 +277,7 @@
/// 琛屽彿
/// </summary>
[SugarColumn(ColumnName = "LINE_NUM")]
- public string? LineNum { get; set; }
+ public string LineNum { get; set; }
/// <summary>
/// 鎵爜鏁伴噺
@@ -289,7 +289,7 @@
/// 閿�鍞鍗�
/// </summary>
[SugarColumn(ColumnName = "VGBEL")]
- public string? Vgbel { get; set; }
+ public string Vgbel { get; set; }
/// <summary>
/// 閿�鍞鍗曡鍙�
@@ -301,7 +301,7 @@
/// 浠诲姟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "WORK_NO")]
- public string? WorkNo { get; set; }
+ public string WorkNo { get; set; }
/// <summary>
/// 琛屽彿
@@ -313,7 +313,7 @@
/// 鍒拌揣鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CBILL_NO")]
- public string? CbillNo { get; set; }
+ public string CbillNo { get; set; }
/// <summary>
/// 鎬ユ枡鏍囪瘑
@@ -325,7 +325,7 @@
/// 浜у搧鍨嬪彿
/// </summary>
[SugarColumn(ColumnName = "BOARD_STYLE")]
- public string? BoardStyle { get; set; }
+ public string BoardStyle { get; set; }
/// <summary>
/// 浠诲姟鍗曡鍙�
@@ -337,55 +337,19 @@
/// 鐢熶骇宸ュ崟
/// </summary>
[SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
+ public string TaskNo { get; set; }
/// <summary>
/// 渚涘簲鍟�
/// </summary>
[SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
+ public string SuppNo { get; set; }
/// <summary>
/// 浠诲姟姹囨姤鍗�
/// </summary>
[SugarColumn(ColumnName = "RBILL_NO")]
- public string? RbillNo { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟id
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public decimal? EbelnK3id { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟琛宨d
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public decimal? LineK3id { get; set; }
-
- /// <summary>
- /// 鐗╂枡id
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public decimal? ItemId { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟id
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public decimal? EbelnK3id { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟琛宨d
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public decimal? LineK3id { get; set; }
-
- /// <summary>
- /// 鐗╂枡id
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public decimal ItemId { get; set; }
+ public string RbillNo { get; set; }
// 娣诲姞鐨勫瓧娈碉紝骞朵笖瀹冧滑涓嶅睘浜庢暟鎹簱琛�
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
--
Gitblit v1.9.3