From 9ae9e3523c3c0e0e35e016e48db83cdfacd25b0b Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期一, 06 一月 2025 08:37:15 +0800
Subject: [PATCH] 采购退料
---
entity/MesRohInData.cs | 80 ++--
entity/TransferOut.cs | 254 +++++++++---------
entity/MesInvItemIns.cs | 202 ++++++++------
entity/MesInvItemArn.cs | 172 ++++++-----
entity/MesInvItemInCDetails.cs | 13
entity/MesInvItemBarcodes.cs | 12
service/Warehouse/MesInvItemInCDetailsManager.cs | 24 +
entity/MesRohIn.cs | 81 ++--
8 files changed, 448 insertions(+), 390 deletions(-)
diff --git a/entity/MesInvItemArn.cs b/entity/MesInvItemArn.cs
index b87f1d5..b3bd8bb 100644
--- a/entity/MesInvItemArn.cs
+++ b/entity/MesInvItemArn.cs
@@ -8,240 +8,246 @@
public class MesInvItemArn
{
/// <summary>
- /// 涓婚敭
- /// 榛樿鍊�: (newid())
- /// </summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
public Guid Guid { get; set; }
/// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
+ /// 鍒拌揣鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "bill_no")]
public string? BillNo { get; set; }
/// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "status")]
public int? Status { get; set; }
/// <summary>
- /// 鍘熷洜
- /// </summary>
+ /// 鍘熷洜
+ ///</summary>
[SugarColumn(ColumnName = "reason")]
public string? Reason { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- /// </summary>
+ /// 鍒涘缓浜�
+ ///</summary>
[SugarColumn(ColumnName = "create_by")]
public string? CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "create_date")]
public DateTime? CreateDate { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
[SugarColumn(ColumnName = "lastupdate_by")]
public string? LastupdateBy { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
[SugarColumn(ColumnName = "lastupdate_date")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
+ /// 鍗曟嵁绫诲瀷ID
+ ///</summary>
[SugarColumn(ColumnName = "bill_type_id")]
public int? BillTypeId { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷ID
- /// </summary>
+ /// 浜嬪姟绫诲瀷ID
+ ///</summary>
[SugarColumn(ColumnName = "transaction_id")]
public int? TransactionId { get; set; }
/// <summary>
- /// 澶囨敞
- /// </summary>
+ /// 澶囨敞
+ ///</summary>
[SugarColumn(ColumnName = "remark")]
public string? Remark { get; set; }
/// <summary>
- /// 閫佽揣鍗曞彿
- /// </summary>
+ /// 閫佽揣鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "paper_bill_no")]
public string? PaperBillNo { get; set; }
/// <summary>
- /// 閫�鏂欎汉宸ュ彿
- /// </summary>
+ /// 閫�鏂欎汉宸ュ彿
+ ///</summary>
[SugarColumn(ColumnName = "user_no_back")]
public string? UserNoBack { get; set; }
/// <summary>
- /// 鎻愪氦浜�
- /// </summary>
+ /// 鎻愪氦浜�
+ ///</summary>
[SugarColumn(ColumnName = "check_user")]
public string? CheckUser { get; set; }
/// <summary>
- /// 鎻愪氦鏃ユ湡
- /// </summary>
+ /// 鎻愪氦鏃ユ湡
+ ///</summary>
[SugarColumn(ColumnName = "check_date")]
public DateTime? CheckDate { get; set; }
/// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
+ /// 鍏ュ簱鏃ユ湡
+ ///</summary>
[SugarColumn(ColumnName = "ins_date")]
public DateTime? InsDate { get; set; }
/// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
+ /// 妫�楠岀粨鏋�
+ ///</summary>
[SugarColumn(ColumnName = "check_res")]
public string? CheckRes { get; set; }
/// <summary>
- /// 宸叉崱鏁伴噺
- /// </summary>
+ /// 宸叉崱鏁伴噺
+ ///</summary>
[SugarColumn(ColumnName = "check_qty")]
public int? CheckQty { get; set; }
/// <summary>
- /// 浠撳簱id
- /// </summary>
+ /// 浠撳簱id
+ ///</summary>
[SugarColumn(ColumnName = "depots_id")]
public string? DepotsId { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- /// </summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "transction_no")]
public string? TransctionNo { get; set; }
/// <summary>
- /// 渚涘簲鍟唅d
- /// </summary>
+ /// 渚涘簲鍟唅d
+ ///</summary>
[SugarColumn(ColumnName = "supp_id")]
public string? SuppId { get; set; }
/// <summary>
- /// 鎻愪氦鐘舵��
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鎻愪氦鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "fstatus")]
public bool? Fstatus { get; set; }
/// <summary>
- /// 宸ュ巶缂栫爜
- /// </summary>
+ /// 宸ュ巶缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "factory")]
public string? Factory { get; set; }
/// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "sapstatus")]
public int? Sapstatus { get; set; }
/// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
+ /// 鏄惁妫�楠�
+ ///</summary>
[SugarColumn(ColumnName = "ischeck")]
public bool? Ischeck { get; set; }
/// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- /// </summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ ///</summary>
[SugarColumn(ColumnName = "insby")]
public string? Insby { get; set; }
/// <summary>
- /// 鍏徃浠g爜
- /// </summary>
+ /// 鍏徃浠g爜
+ ///</summary>
[SugarColumn(ColumnName = "company")]
public string? Company { get; set; }
/// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "urgent_flag")]
public bool? UrgentFlag { get; set; }
/// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "mttransction_no")]
public int? MttransctionNo { get; set; }
/// <summary>
- /// IQC妫�楠屽崟鍙�
- /// </summary>
+ /// IQC妫�楠屽崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "iqc_release_no")]
public string? IqcReleaseNo { get; set; }
/// <summary>
- /// 鏄惁鏄剧ず
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鏄惁鏄剧ず
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "is_visual")]
public int? IsVisual { get; set; }
/// <summary>
- /// 0=閲囪喘锛�1=濮斿
- /// 榛樿鍊�: ((1))
- /// </summary>
+ /// 0=閲囪喘锛�1=濮斿
+ /// 榛樿鍊�: ((1))
+ ///</summary>
[SugarColumn(ColumnName = "f_type")]
public bool? FType { get; set; }
/// <summary>
- /// ERP鍒拌揣鍗旾D
- /// </summary>
+ /// ERP鍒拌揣鍗旾D
+ ///</summary>
[SugarColumn(ColumnName = "ebeln_k3id")]
public string? EbelnK3id { get; set; }
/// <summary>
- /// 鏉$爜鏉″嵃杩涘害
- /// </summary>
+ /// 鏉$爜鏉″嵃杩涘害
+ ///</summary>
[SugarColumn(ColumnName = "barcode_ratio")]
public int? BarcodeRatio { get; set; }
/// <summary>
- /// ERP鍗曞彿
- /// </summary>
+ /// ERP鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "erpno")]
public string? Erpno { get; set; }
/// <summary>
- /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
- /// </summary>
+ /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ ///</summary>
[SugarColumn(ColumnName = "thstatus")]
public int? Thstatus { get; set; }
/// <summary>
- /// ERP閫�璐у崟鍙�
- /// </summary>
+ /// ERP閫�璐у崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "erpthno")]
public string? Erpthno { get; set; }
/// <summary>
- /// 缁勭粐缂栫爜
- /// </summary>
+ /// 缁勭粐缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "organize_code")]
public string? OrganizeCode { get; set; }
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
+
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
[SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
diff --git a/entity/MesInvItemBarcodes.cs b/entity/MesInvItemBarcodes.cs
index 3fb8c2d..1a79514 100644
--- a/entity/MesInvItemBarcodes.cs
+++ b/entity/MesInvItemBarcodes.cs
@@ -493,14 +493,20 @@
public long? GxId { get; set; }
/// <summary>
+ /// 渚涘簲鍟唅d
+ /// </summary>
+ [SugarColumn(ColumnName = "supp_id")]
+ public string? SuppId { get; set; }
+
+ /// <summary>
/// 涓存椂鎵归噺guid
/// </summary>
[SugarColumn(ColumnName = "tmpGuid")]
public Guid? TmpGuid { get; set; }
/// <summary>
- /// 渚涘簲鍟唅d
+ /// 鍏宠仈琛ㄧ殑guid
/// </summary>
- [SugarColumn(ColumnName = "supp_id")]
- public string? SuppId { get; set; }
+ [SugarColumn(ColumnName = "ABOUT_GUID")]
+ public Guid? AboutGuid { get; set; }
}
\ No newline at end of file
diff --git a/entity/MesInvItemInCDetails.cs b/entity/MesInvItemInCDetails.cs
index 5dff993..6d9b030 100644
--- a/entity/MesInvItemInCDetails.cs
+++ b/entity/MesInvItemInCDetails.cs
@@ -18,7 +18,7 @@
/// 鍏ュ簱鍗昳d
/// </summary>
[SugarColumn(ColumnName = "ITEM_IN_ID")]
- public Guid ItemInId { get; set; }
+ public Guid? ItemInId { get; set; }
/// <summary>
/// 鐗╂枡鏉$爜PSN
@@ -374,7 +374,16 @@
[SugarColumn(ColumnName = "ITEM_ID")]
public long? ItemId { get; set; }
- [SugarColumn(ColumnName = "SUPP_ID")] public string? SuppId { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_ID")]
+ public string? SuppId { get; set; }
+
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
// 娣诲姞鐨勫瓧娈碉紝骞朵笖瀹冧滑涓嶅睘浜庢暟鎹簱琛�
diff --git a/entity/MesInvItemIns.cs b/entity/MesInvItemIns.cs
index e08d451..0ffde9b 100644
--- a/entity/MesInvItemIns.cs
+++ b/entity/MesInvItemIns.cs
@@ -9,296 +9,324 @@
public class MesInvItemIns
{
/// <summary>
- /// ID(SEQ_INV_ID)
- /// 榛樿鍊�: (newid())
- /// </summary>
+ /// ID(SEQ_INV_ID)
+ /// 榛樿鍊�: (newid())
+ ///</summary>
[SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
public Guid Guid { get; set; }
/// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
+ /// 鍏ュ簱鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "BILL_NO")]
public string? BillNo { get; set; }
/// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\\缁撴
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\\缁撴
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "STATUS")]
public byte? Status { get; set; }
/// <summary>
- /// 浠撳簱
- /// </summary>
+ /// 浠撳簱
+ ///</summary>
[SugarColumn(ColumnName = "DEPOTS_ID")]
public long? DepotsId { get; set; }
/// <summary>
- /// 鍘熷洜
- /// </summary>
+ /// 鍘熷洜
+ ///</summary>
[SugarColumn(ColumnName = "REASON")]
public string? Reason { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- /// </summary>
+ /// 鍒涘缓浜�
+ ///</summary>
[SugarColumn(ColumnName = "CREATE_BY")]
public string? CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string? LastupdateBy { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
+ /// 鍗曟嵁绫诲瀷ID
+ ///</summary>
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
public long? BillTypeId { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷ID
- /// </summary>
+ /// 浜嬪姟绫诲瀷ID
+ ///</summary>
[SugarColumn(ColumnName = "TRANSACTION_ID")]
public long? TransactionId { get; set; }
/// <summary>
- /// 澶囨敞
- /// </summary>
+ /// 澶囨敞
+ ///</summary>
[SugarColumn(ColumnName = "REMARK")]
public string? Remark { get; set; }
/// <summary>
- /// 閫佽揣鍗曞彿
- /// </summary>
+ /// 閫佽揣鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "PAPER_BILL_NO")]
public string? PaperBillNo { get; set; }
/// <summary>
- /// 閫�鏂欎汉宸ュ彿
- /// </summary>
+ /// 閫�鏂欎汉宸ュ彿
+ ///</summary>
[SugarColumn(ColumnName = "USER_NO_BACK")]
public string? UserNoBack { get; set; }
/// <summary>
- /// 瀹℃牳浜�
- /// </summary>
+ /// 瀹℃牳浜�
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_USER")]
public string? CheckUser { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_DATE")]
public DateTime? CheckDate { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "TASK_NO")]
public string? TaskNo { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "INS_DATE")]
public DateTime? InsDate { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_RES")]
public string? CheckRes { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_QTY")]
public long? CheckQty { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "MMLIST")]
public string? Mmlist { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "EBELN")]
public string? Ebeln { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "DEPOTS_CODE")]
public string? DepotsCode { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "TRANSCTION_NO")]
public string? TransctionNo { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "SUPP_NO")]
public string? SuppNo { get; set; }
/// <summary>
- /// 鐘舵�� | 0-鏈鏍� 1-瀹℃牳鍏ュ簱/缁撴
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 鐘舵�� | 0-鏈鏍� 1-瀹℃牳鍏ュ簱/缁撴
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "FSTATUS")]
public byte? Fstatus { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "FACTORY")]
public string? Factory { get; set; }
/// <summary>
- /// 榛樿鍊�: ((0))
- /// </summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "SAPSTATUS")]
public byte? Sapstatus { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "SAPNO")]
public string? Sapno { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "SAPYEAR")]
public short? Sapyear { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "SAPTEXT")]
public string? Saptext { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "ISCHECK")]
public byte? Ischeck { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "INSBY")]
public string? Insby { get; set; }
/// <summary>
- /// 榛樿鍊�: ((0))
- /// </summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "IS_VISUAL")]
public byte? IsVisual { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "COMPANY")]
public string? Company { get; set; }
/// <summary>
- /// 榛樿鍊�: ((0))
- /// </summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "URGENT_FLAG")]
public byte? UrgentFlag { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "LINE_NO")]
public string? LineNo { get; set; }
/// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "MTTRANSCTION_NO")]
public long? MttransctionNo { get; set; }
/// <summary>
- /// 宸ュ崟琛屽彿
- /// </summary>
+ /// 宸ュ崟琛屽彿
+ ///</summary>
[SugarColumn(ColumnName = "TASK_LINO")]
public string? TaskLino { get; set; }
/// <summary>
- /// 鎶曟枡閫氱煡鍗曞崟鍙�
- /// </summary>
+ /// 鎶曟枡閫氱煡鍗曞崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "FBILLNO")]
public string? Fbillno { get; set; }
/// <summary>
- /// 鎶曟枡鍗曡鍙�
- /// </summary>
+ /// 鎶曟枡鍗曡鍙�
+ ///</summary>
[SugarColumn(ColumnName = "FBILL_LINO")]
public string? FbillLino { get; set; }
/// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "CUST_NO")]
public string? CustNo { get; set; }
/// <summary>
- /// 瀹㈡埛鍚嶇О
- /// </summary>
+ /// 瀹㈡埛鍚嶇О
+ ///</summary>
[SugarColumn(ColumnName = "CUST_NAME")]
public string? CustName { get; set; }
/// <summary>
- /// IQC妫�楠屽崟鍙�
- /// </summary>
+ /// IQC妫�楠屽崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "IQC_RELEASE_NO")]
public string? IqcReleaseNo { get; set; }
/// <summary>
- /// 鍒拌揣鍗曞彿/鍏跺畠鍏ュ簱鍗曞彿
- /// </summary>
+ /// 鍒拌揣鍗曞彿/鍏跺畠鍏ュ簱鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "CBILL_NO")]
public string? CbillNo { get; set; }
/// <summary>
- /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
- /// 榛樿鍊�: ((0))
- /// </summary>
+ /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
[SugarColumn(ColumnName = "PICK_INS")]
public byte? PickIns { get; set; }
/// <summary>
- /// 鍏ュ簱瀹℃牳浜�
- /// </summary>
+ /// 鍏ュ簱瀹℃牳浜�
+ ///</summary>
[SugarColumn(ColumnName = "FCHECK_USER")]
public string? FcheckUser { get; set; }
/// <summary>
- /// 鍏ュ簱瀹℃牳鏃ユ湡
- /// </summary>
+ /// 鍏ュ簱瀹℃牳鏃ユ湡
+ ///</summary>
[SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
/// <summary>
- /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱銆侀��鏂欙級
- /// </summary>
+ /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱銆侀��鏂欙級
+ ///</summary>
[SugarColumn(ColumnName = "RBILL_NO")]
public string? RbillNo { get; set; }
/// <summary>
- /// 鎶ュ伐浜�
- /// </summary>
+ /// 鎶ュ伐浜�
+ ///</summary>
[SugarColumn(ColumnName = "BGR")]
public string? Bgr { get; set; }
/// <summary>
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "SUPP_ID")]
public string? SuppId { get; set; }
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
+
//鍦ㄦ暟鎹簱鏌ヨ鏃跺拷鐣ヨ繖涓瓧娈�
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
diff --git a/entity/MesRohIn.cs b/entity/MesRohIn.cs
index 2c8fc7f..5d166b1 100644
--- a/entity/MesRohIn.cs
+++ b/entity/MesRohIn.cs
@@ -19,25 +19,25 @@
/// 閲囪喘鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
+ public string? BillNo { get; set; }
/// <summary>
/// 鍗曟嵁鐘舵��
/// </summary>
[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
- public string DocumentStatus { get; set; }
+ public string? DocumentStatus { get; set; }
/// <summary>
/// 鍗曟嵁绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "DOCUMENT_TYPE")]
- public string DocumentType { get; set; }
+ public string? DocumentType { get; set; }
/// <summary>
/// 涓氬姟绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "BUSINESS_TYPE")]
- public string BusinessType { get; set; }
+ public string? BusinessType { get; set; }
/// <summary>
/// 閲囪喘鏃ユ湡
@@ -49,97 +49,97 @@
/// 渚涘簲鍟�
/// </summary>
[SugarColumn(ColumnName = "SUPPLIER")]
- public string Supplier { get; set; }
+ public string? Supplier { get; set; }
/// <summary>
/// 鍏抽棴鐘舵��
/// </summary>
[SugarColumn(ColumnName = "CLOSE_STATUS")]
- public string CloseStatus { get; set; }
+ public string? CloseStatus { get; set; }
/// <summary>
/// 閲囪喘缁勭粐
/// </summary>
[SugarColumn(ColumnName = "PURCHASE_ORG")]
- public string PurchaseOrg { get; set; }
+ public string? PurchaseOrg { get; set; }
/// <summary>
/// 閲囪喘閮ㄩ棬
/// </summary>
[SugarColumn(ColumnName = "PURCHASE_DEPT")]
- public string PurchaseDept { get; set; }
+ public string? PurchaseDept { get; set; }
/// <summary>
/// 閲囪喘缁�
/// </summary>
[SugarColumn(ColumnName = "PURCHASE_GROUP")]
- public string PurchaseGroup { get; set; }
+ public string? PurchaseGroup { get; set; }
/// <summary>
/// 鏁伴噺楠屾敹
/// </summary>
[SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
- public string QtyAcceptance { get; set; }
+ public string? QtyAcceptance { get; set; }
/// <summary>
/// 閲囪喘鍛�
/// </summary>
[SugarColumn(ColumnName = "PURCHASER")]
- public string Purchaser { get; set; }
+ public string? Purchaser { get; set; }
/// <summary>
/// 璐ㄩ噺瑕佹眰
/// </summary>
[SugarColumn(ColumnName = "QUALITY_REQ")]
- public string QualityReq { get; set; }
+ public string? QualityReq { get; set; }
/// <summary>
/// 缁撶畻鏂�
/// </summary>
[SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
- public string SettlementParty { get; set; }
+ public string? SettlementParty { get; set; }
/// <summary>
/// 鏀舵鏂�
/// </summary>
[SugarColumn(ColumnName = "PAYMENT_PARTY")]
- public string PaymentParty { get; set; }
+ public string? PaymentParty { get; set; }
/// <summary>
/// 閭
/// </summary>
[SugarColumn(ColumnName = "EMAIL")]
- public string Email { get; set; }
+ public string? Email { get; set; }
/// <summary>
/// 杩愯緭鏂瑰紡
/// </summary>
[SugarColumn(ColumnName = "TRANSPORT_METHOD")]
- public string TransportMethod { get; set; }
+ public string? TransportMethod { get; set; }
/// <summary>
/// 澶囨敞
/// </summary>
[SugarColumn(ColumnName = "REMARKS")]
- public string Remarks { get; set; }
+ public string? Remarks { get; set; }
/// <summary>
/// 娌诲叿涓舵ā鍏峰姞宸ュ強閲囪喘
/// </summary>
[SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
- public string FixtureMoldProcurement { get; set; }
+ public string? FixtureMoldProcurement { get; set; }
/// <summary>
/// 浣滃簾鐘舵��
/// </summary>
[SugarColumn(ColumnName = "CANCELLATION_STATUS")]
- public string CancellationStatus { get; set; }
+ public string? CancellationStatus { get; set; }
/// <summary>
/// 浣滃簾浜�
/// </summary>
[SugarColumn(ColumnName = "CANCELLATION_PERSON")]
- public string CancellationPerson { get; set; }
+ public string? CancellationPerson { get; set; }
/// <summary>
/// 浣滃簾鏃ユ湡
@@ -151,7 +151,7 @@
/// 鍒涘缓浜�
/// </summary>
[SugarColumn(ColumnName = "CREATE_BY")]
- public string CreateBy { get; set; }
+ public string? CreateBy { get; set; }
/// <summary>
/// 鍒涘缓鏃ユ湡
@@ -169,19 +169,19 @@
/// 鏈�鍚庝慨鏀逛汉
/// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
+ public string? LastupdateBy { get; set; }
/// <summary>
/// 瀹℃牳浜�
/// </summary>
[SugarColumn(ColumnName = "ERP_CHECK_BY")]
- public string ErpCheckBy { get; set; }
+ public string? ErpCheckBy { get; set; }
/// <summary>
/// 瀹℃牳鏃堕棿
/// </summary>
[SugarColumn(ColumnName = "ERP_CHECK_DATE")]
- public string ErpCheckDate { get; set; }
+ public string? ErpCheckDate { get; set; }
/// <summary>
/// ERP鐨処D鍙�
@@ -199,7 +199,7 @@
/// 瀹℃牳浜�
/// </summary>
[SugarColumn(ColumnName = "CHECK_BY")]
- public string CheckBy { get; set; }
+ public string? CheckBy { get; set; }
/// <summary>
/// 瀹℃牳鏍囪瘑
@@ -211,46 +211,46 @@
/// 鎵撳嵃娆℃暟
/// </summary>
[SugarColumn(ColumnName = "REMARK1")]
- public string Remark1 { get; set; }
+ public string? Remark1 { get; set; }
/// <summary>
/// 鑷畾涔夊瓧娈�2
/// </summary>
[SugarColumn(ColumnName = "REMARK2")]
- public string Remark2 { get; set; }
+ public string? Remark2 { get; set; }
/// <summary>
/// 鑷畾涔夊瓧娈�3
/// </summary>
[SugarColumn(ColumnName = "REMARK3")]
- public string Remark3 { get; set; }
+ public string? Remark3 { get; set; }
/// <summary>
/// 鑷畾涔夊瓧娈�4
/// </summary>
[SugarColumn(ColumnName = "REMARK4")]
- public string Remark4 { get; set; }
+ public string? Remark4 { get; set; }
/// <summary>
/// 鑷畾涔夊瓧娈�5
/// </summary>
[SugarColumn(ColumnName = "REMARK5")]
- public string Remark5 { get; set; }
+ public string? Remark5 { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "CHANGEREASON")]
- public string Changereason { get; set; }
+ public string? Changereason { get; set; }
/// <summary>
/// </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>
@@ -258,42 +258,43 @@
public DateTime? Prearrivaldate { get; set; }
/// <summary>
+ /// 鏀舵枡缁勭粐
/// </summary>
[SugarColumn(ColumnName = "ReceiveOrgId")]
- public string ReceiveOrgId { get; set; }
+ public string? ReceiveOrgId { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "Provider_Id")]
- public string ProviderId { get; set; }
+ public string? ProviderId { get; set; }
/// <summary>
/// 鑱旂郴浜�
/// </summary>
[SugarColumn(ColumnName = "anred")]
- public string Anred { get; set; }
+ public string? Anred { get; set; }
/// <summary>
/// 鐢佃瘽
/// </summary>
[SugarColumn(ColumnName = "telf1")]
- public string Telf1 { get; set; }
+ public string? Telf1 { get; set; }
/// <summary>
/// 鍥哄畾鐢佃瘽
/// </summary>
[SugarColumn(ColumnName = "Fixed_Telephone")]
- public string FixedTelephone { get; set; }
+ public string? FixedTelephone { get; set; }
/// <summary>
/// 閫氳鍦板潃
/// </summary>
[SugarColumn(ColumnName = "Address")]
- public string Address { get; set; }
+ public string? Address { get; set; }
/// <summary>
/// 楠屾敹鏂瑰紡
/// </summary>
[SugarColumn(ColumnName = "Acctype")]
- public string Acctype { get; set; }
+ public string? Acctype { get; set; }
}
\ No newline at end of file
diff --git a/entity/MesRohInData.cs b/entity/MesRohInData.cs
index 8c801f0..ca110d8 100644
--- a/entity/MesRohInData.cs
+++ b/entity/MesRohInData.cs
@@ -18,31 +18,31 @@
/// 閲囪喘鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
+ public string? BillNo { get; set; }
/// <summary>
/// 閿�鍞鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "SALES_ORDER_ID")]
- public string SalesOrderId { get; set; }
+ public string? SalesOrderId { get; set; }
/// <summary>
/// 閲囪喘璁㈠崟琛屽彿
/// </summary>
[SugarColumn(ColumnName = "ORDER_LINE_ID")]
- public string OrderLineId { get; set; }
+ public string? OrderLineId { get; set; }
/// <summary>
/// 鐗╂枡缂栫爜
/// </summary>
[SugarColumn(ColumnName = "ITEM_ID")]
- public string ItemId { get; set; }
+ public string? ItemId { get; set; }
/// <summary>
/// 閲囪喘鍗曚綅
/// </summary>
[SugarColumn(ColumnName = "PURCHASE_UNIT")]
- public string PurchaseUnit { get; set; }
+ public string? PurchaseUnit { get; set; }
/// <summary>
/// 閲囪喘鏁伴噺
@@ -54,13 +54,13 @@
/// 搴撳瓨鍗曚綅
/// </summary>
[SugarColumn(ColumnName = "INVENTORY_UNIT")]
- public string InventoryUnit { get; set; }
+ public string? InventoryUnit { get; set; }
/// <summary>
/// 璁′环鍗曚綅
/// </summary>
[SugarColumn(ColumnName = "PRICING_UNIT")]
- public string PricingUnit { get; set; }
+ public string? PricingUnit { get; set; }
/// <summary>
/// 璁′环鏁伴噺
@@ -90,73 +90,73 @@
/// 闇�姹傜粍缁�
/// </summary>
[SugarColumn(ColumnName = "DEMAND_ORG")]
- public string DemandOrg { get; set; }
+ public string? DemandOrg { get; set; }
/// <summary>
/// 鏀舵枡缁勭粐
/// </summary>
[SugarColumn(ColumnName = "RECEIVING_ORG")]
- public string ReceivingOrg { get; set; }
+ public string? ReceivingOrg { get; set; }
/// <summary>
/// 缁撶畻缁勭粐
/// </summary>
[SugarColumn(ColumnName = "SETTLEMENT_ORG")]
- public string SettlementOrg { get; set; }
+ public string? SettlementOrg { get; set; }
/// <summary>
/// 鏄惁璧犲搧
/// </summary>
[SugarColumn(ColumnName = "IS_GIFT")]
- public string IsGift { get; set; }
+ public string? IsGift { get; set; }
/// <summary>
/// 澶囨敞
/// </summary>
[SugarColumn(ColumnName = "REMARKS")]
- public string Remarks { get; set; }
+ public string? Remarks { get; set; }
/// <summary>
/// 渚涘簲鍟嗙墿鏂欑紪鐮�
/// </summary>
[SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
- public string SupplierItemCode { get; set; }
+ public string? SupplierItemCode { get; set; }
/// <summary>
/// 渚涘簲鍟嗙墿鏂欏悕绉�
/// </summary>
[SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
- public string SupplierItemName { get; set; }
+ public string? SupplierItemName { get; set; }
/// <summary>
/// 濮斿璁㈠崟缂栧彿
/// </summary>
[SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
- public string OutsourcingOrderId { get; set; }
+ public string? OutsourcingOrderId { get; set; }
/// <summary>
/// 鎵瑰彿
/// </summary>
[SugarColumn(ColumnName = "BATCH_NUMBER")]
- public string BatchNumber { get; set; }
+ public string? BatchNumber { get; set; }
/// <summary>
/// 涓氬姟鍏抽棴
/// </summary>
[SugarColumn(ColumnName = "BUSINESS_CLOSE")]
- public string BusinessClose { get; set; }
+ public string? BusinessClose { get; set; }
/// <summary>
/// 涓氬姟鍐荤粨
/// </summary>
[SugarColumn(ColumnName = "BUSINESS_FREEZE")]
- public string BusinessFreeze { get; set; }
+ public string? BusinessFreeze { get; set; }
/// <summary>
/// 鍐荤粨浜�
/// </summary>
[SugarColumn(ColumnName = "FREEZER")]
- public string Freezer { get; set; }
+ public string? Freezer { get; set; }
/// <summary>
/// 鍐荤粨鏃堕棿
@@ -168,13 +168,13 @@
/// 涓氬姟缁堟
/// </summary>
[SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
- public string BusinessTerminate { get; set; }
+ public string? BusinessTerminate { get; set; }
/// <summary>
/// 缁堟浜�
/// </summary>
[SugarColumn(ColumnName = "TERMINATOR")]
- public string Terminator { get; set; }
+ public string? Terminator { get; set; }
/// <summary>
/// 缁堟鏃堕棿
@@ -228,49 +228,49 @@
/// 婧愬崟绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
- public string SourceDocumentType { get; set; }
+ public string? SourceDocumentType { get; set; }
/// <summary>
/// 婧愬崟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
- public string SourceDocumentId { get; set; }
+ public string? SourceDocumentId { get; set; }
/// <summary>
/// 闇�姹傝窡韪彿
/// </summary>
[SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
- public string DemandTrackingId { get; set; }
+ public string? DemandTrackingId { get; set; }
/// <summary>
/// 璁″垝璺熻釜鍙�
/// </summary>
[SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
- public string PlanTrackingId { get; set; }
+ public string? PlanTrackingId { get; set; }
/// <summary>
/// 鍙樻洿鏍囧織
/// </summary>
[SugarColumn(ColumnName = "CHANGE_FLAG")]
- public string ChangeFlag { get; set; }
+ public string? ChangeFlag { get; set; }
/// <summary>
/// 闇�姹傛潵婧�
/// </summary>
[SugarColumn(ColumnName = "DEMAND_SOURCE")]
- public string DemandSource { get; set; }
+ public string? DemandSource { get; set; }
/// <summary>
/// 闇�姹傚崟鎹紪鍙�
/// </summary>
[SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
- public string DemandDocumentId { get; set; }
+ public string? DemandDocumentId { get; set; }
/// <summary>
/// 闇�姹傚崟鎹鍙�
/// </summary>
[SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
- public string DemandDocumentLineId { get; set; }
+ public string? DemandDocumentLineId { get; set; }
/// <summary>
/// ERP鐨処D鍙�
@@ -282,25 +282,25 @@
/// 瀹㈡埛璐у彿
/// </summary>
[SugarColumn(ColumnName = "REMARK1")]
- public string Remark1 { get; set; }
+ public string? Remark1 { get; set; }
/// <summary>
/// 鍖呰鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "REMARK2")]
- public string Remark2 { get; set; }
+ public string? Remark2 { get; set; }
/// <summary>
/// 涓讳骇鍝�
/// </summary>
[SugarColumn(ColumnName = "REMARK3")]
- public string Remark3 { get; set; }
+ public string? Remark3 { get; set; }
/// <summary>
/// SMT澶囨敞
/// </summary>
[SugarColumn(ColumnName = "REMARK4")]
- public string Remark4 { get; set; }
+ public string? Remark4 { get; set; }
/// <summary>
/// ERP鐨勫ごID鍙�
@@ -311,22 +311,22 @@
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")]
- public string PurchaseOrderLineNumber { get; set; }
+ public string? PurchaseOrderLineNumber { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "DEMAND")]
- public string Demand { get; set; }
+ public string? Demand { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "RECEIVING")]
- public string Receiving { get; set; }
+ public string? Receiving { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "SETTLEMENT")]
- public string Settlement { get; set; }
+ public string? Settlement { get; set; }
/// <summary>
/// erp鎺ㄦ潵鐨勫凡浜よ揣鏁伴噺
@@ -338,12 +338,12 @@
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "DEMAND_DEPARTMENT")]
- public string DemandDepartment { get; set; }
+ public string? DemandDepartment { get; set; }
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
- public string ReceivingDepartment { get; set; }
+ public string? ReceivingDepartment { get; set; }
/// <summary>
/// </summary>
@@ -353,5 +353,5 @@
/// <summary>
/// </summary>
[SugarColumn(ColumnName = "FDEMANDBILLNO_LINE")]
- public string FdemandbillnoLine { get; set; }
+ public string? FdemandbillnoLine { get; set; }
}
\ No newline at end of file
diff --git a/entity/TransferOut.cs b/entity/TransferOut.cs
index be97376..5a62cde 100644
--- a/entity/TransferOut.cs
+++ b/entity/TransferOut.cs
@@ -8,192 +8,192 @@
[SugarTable("Transfer_Out")]
public class TransferOut
{
- /// <summary>
- /// 涓婚敭
- /// 榛樿鍊�: (newid())
- /// </summary>
- [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ /// <summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
public Guid Guid { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "bill_type_id")]
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "bill_type_id")]
public string BillTypeId { get; set; }
- /// <summary>
- /// 璋冩嫧鏂瑰悜
- /// </summary>
- [SugarColumn(ColumnName = "transfer_direct")]
+ /// <summary>
+ /// 璋冩嫧鏂瑰悜
+ /// </summary>
+ [SugarColumn(ColumnName = "transfer_direct")]
public string TransferDirect { get; set; }
- /// <summary>
- /// 璋冩嫧绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "transfer_biz_type")]
+ /// <summary>
+ /// 璋冩嫧绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "transfer_biz_type")]
public string TransferBizType { get; set; }
- /// <summary>
- /// 璋冨嚭搴撳瓨缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "stockoutorg_id")]
+ /// <summary>
+ /// 璋冨嚭搴撳瓨缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "stockoutorg_id")]
public string StockoutorgId { get; set; }
- /// <summary>
- /// 璋冨叆搴撳瓨缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "stockorg_id")]
+ /// <summary>
+ /// 璋冨叆搴撳瓨缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "stockorg_id")]
public string StockorgId { get; set; }
- /// <summary>
- /// 璋冨嚭璐т富绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "owner_type_out_id_head")]
+ /// <summary>
+ /// 璋冨嚭璐т富绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "owner_type_out_id_head")]
public string OwnerTypeOutIdHead { get; set; }
- /// <summary>
- /// 璋冨嚭璐т富
- /// </summary>
- [SugarColumn(ColumnName = "owner_out_id_head")]
+ /// <summary>
+ /// 璋冨嚭璐т富
+ /// </summary>
+ [SugarColumn(ColumnName = "owner_out_id_head")]
public string OwnerOutIdHead { get; set; }
- /// <summary>
- /// 璋冨叆璐т富绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "owner_type_id_head")]
+ /// <summary>
+ /// 璋冨叆璐т富绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "owner_type_id_head")]
public string OwnerTypeIdHead { get; set; }
- /// <summary>
- /// 璋冨叆璐т富
- /// </summary>
- [SugarColumn(ColumnName = "owner_id_head")]
+ /// <summary>
+ /// 璋冨叆璐т富
+ /// </summary>
+ [SugarColumn(ColumnName = "owner_id_head")]
public string OwnerIdHead { get; set; }
- /// <summary>
- /// 閿�鍞粍缁�
- /// </summary>
- [SugarColumn(ColumnName = "saleorg_id")]
+ /// <summary>
+ /// 閿�鍞粍缁�
+ /// </summary>
+ [SugarColumn(ColumnName = "saleorg_id")]
public string SaleorgId { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "create_by")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "create_by")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "cteate_data")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "cteate_data")]
public DateTime? CteateData { 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 = "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>
- /// 瀹℃牳鐘舵��
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ /// 瀹℃牳鐘舵��
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
public int? Status { get; set; }
- /// <summary>
- /// 璋冩嫧绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "transferbiztype_no")]
+ /// <summary>
+ /// 璋冩嫧绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "transferbiztype_no")]
public string TransferbiztypeNo { get; set; }
- /// <summary>
- /// 璋冩嫧鏂瑰悜缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "transferdirect_no")]
+ /// <summary>
+ /// 璋冩嫧鏂瑰悜缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "transferdirect_no")]
public string TransferdirectNo { get; set; }
- /// <summary>
- /// 璋冨嚭浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "inv_code")]
+ /// <summary>
+ /// 璋冨嚭浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "inv_code")]
public string InvCode { get; set; }
- /// <summary>
- /// 璋冨嚭浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "inv_name")]
+ /// <summary>
+ /// 璋冨嚭浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "inv_name")]
public string InvName { get; set; }
- /// <summary>
- /// 璋冨叆浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "from_code")]
+ /// <summary>
+ /// 璋冨叆浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "from_code")]
public string FromCode { get; set; }
- /// <summary>
- /// 璋冨叆浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "from_name")]
+ /// <summary>
+ /// 璋冨叆浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "from_name")]
public string FromName { get; set; }
- /// <summary>
- /// 璋冨嚭搴撳瓨缁勭粐ID
- /// </summary>
- [SugarColumn(ColumnName = "stockoutorgid_no")]
+ /// <summary>
+ /// 璋冨嚭搴撳瓨缁勭粐ID
+ /// </summary>
+ [SugarColumn(ColumnName = "stockoutorgid_no")]
public int? StockoutorgidNo { get; set; }
- /// <summary>
- /// 璋冨叆搴撳瓨缁勭粐ID
- /// </summary>
- [SugarColumn(ColumnName = "stockorgid_no")]
+ /// <summary>
+ /// 璋冨叆搴撳瓨缁勭粐ID
+ /// </summary>
+ [SugarColumn(ColumnName = "stockorgid_no")]
public int? StockorgidNo { get; set; }
- /// <summary>
- /// 璋冩嫧鐢宠鍗�
- /// </summary>
- [SugarColumn(ColumnName = "bill_no")]
+ /// <summary>
+ /// 璋冩嫧鐢宠鍗�
+ /// </summary>
+ [SugarColumn(ColumnName = "bill_no")]
public string BillNo { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "billtypeid_no")]
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "billtypeid_no")]
public string BilltypeidNo { get; set; }
- /// <summary>
- /// 鍑哄簱浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "ck_depot")]
+ /// <summary>
+ /// 鍑哄簱浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "ck_depot")]
public int? CkDepot { get; set; }
- /// <summary>
- /// 鍏ュ簱浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "rk_depot")]
+ /// <summary>
+ /// 鍏ュ簱浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "rk_depot")]
public int? RkDepot { get; set; }
- /// <summary>
- /// 瀹岀粨鏍囪瘑
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "is_wc")]
+ /// <summary>
+ /// 瀹岀粨鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "is_wc")]
public int? IsWc { get; set; }
}
\ No newline at end of file
diff --git a/service/Warehouse/MesInvItemInCDetailsManager.cs b/service/Warehouse/MesInvItemInCDetailsManager.cs
index 6859801..24c96d8 100644
--- a/service/Warehouse/MesInvItemInCDetailsManager.cs
+++ b/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -42,11 +42,15 @@
if (inventory == null)
throw new Exception("姝ゆ潯鐮佹壘涓嶅埌瀵瑰簲鏀惰揣鍗曪紒");
+ // var inventoryDetails = Db.Queryable<MesInvItemArnDetail>()
+ // .Where(it => it.ParentGuid == inventory.Guid
+ // && it.ItemId == itemBarcodeDetails.ItemId
+ // && it.EbelnLine == itemBarcodeDetails.WorkLine
+ // && it.Ebeln == itemBarcodeDetails.WorkNo)
+ // .First();
+
var inventoryDetails = Db.Queryable<MesInvItemArnDetail>()
- .Where(it => it.ParentGuid == inventory.Guid
- && it.ItemId == itemBarcodeDetails.ItemId
- && it.EbelnLine == itemBarcodeDetails.WorkLine
- && it.Ebeln == itemBarcodeDetails.WorkNo)
+ .Where(it => it.Guid == itemBarcodeDetails.AboutGuid)
.First();
if (inventoryDetails == null)
@@ -171,7 +175,8 @@
: (byte)0,
CbillNo = itemBarcodeDetails.BillNo,
Fstatus = 0,
- Status = 0
+ Status = 0,
+ ReceiveOrgId = inventory.ReceiveOrgId
}).IgnoreColumns(true).ExecuteCommand();
}
@@ -287,7 +292,8 @@
TaskNo = detail.WorkNo,
EbelnK3id = detail.EbelnK3id,
LineK3id = detail.LineK3id,
- ItemId = detail.ItemId
+ ItemId = detail.ItemId,
+ ReceiveOrgId = inventory.ReceiveOrgId
}).IgnoreColumns(true).ExecuteCommand();
}
else
@@ -377,7 +383,8 @@
TaskNo = detail.WorkNo,
EbelnK3id = detail.EbelnK3id,
LineK3id = detail.LineK3id,
- ItemId = detail.ItemId
+ ItemId = detail.ItemId,
+ ReceiveOrgId = inventory.ReceiveOrgId
}).IgnoreColumns(true).ExecuteCommand();
cSyQty = 0; // Remaining quantity fulfilled
@@ -500,7 +507,8 @@
Ischeck = true,
CheckDate = inventoryDetails.CheckDate,
CheckRes = inventoryDetails.CheckRes,
- CheckStates = inventoryDetails.CheckStates
+ CheckStates = inventoryDetails.CheckStates,
+ ReceiveOrgId = inventory.ReceiveOrgId
}).IgnoreColumns(true).ExecuteCommand();
// 鎻掑叆 mes_inv_business2 琛�
--
Gitblit v1.9.3