From f7b58cf11dad9b6acfbe3eab4352d72a57fb7ecf Mon Sep 17 00:00:00 2001
From: hudong <Administrator@PC-20250329JZUF>
Date: 星期四, 15 五月 2025 18:07:53 +0800
Subject: [PATCH] 1.冲销出库流程联调 2.冲销入库流程联调 3.普通出库 回调逻辑测试 4.物料凭证表结构修改，逻辑修改
---
wms/WMSHelper.cs | 50 +++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 49 insertions(+), 1 deletions(-)
diff --git a/wms/WMSHelper.cs b/wms/WMSHelper.cs
index 66c650f..8702291 100644
--- a/wms/WMSHelper.cs
+++ b/wms/WMSHelper.cs
@@ -135,7 +135,11 @@
var db = new SqlHelper<object>().GetInstance();
return db.Queryable<TN_Inbound_Order>().Includes(a => a.Details).Where(a => a.S_NO == no).First();
}
-
+ internal static TN_Supplier GetGYSBMOrder(string no)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<TN_Supplier>().Includes(a => a.Details).Where(a => a.S_GYSBM == no).First();
+ }
internal static TN_ASN_Order GetASNOrder(string no)
{
var db = new SqlHelper<object>().GetInstance();
@@ -412,6 +416,50 @@
}
}
+ internal static void addOnShelves(TN_Outbound_Order task,string cntr_code, int action)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ var s_action = "";
+ if (action == 1)
+ {
+ s_action = "涓婃灦";
+ }
+ else
+ {
+ s_action = "涓嬫灦";
+ }
+ try
+ {
+ var itemlist = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr_code).ToList();
+ if (itemlist.Count > 0)
+ {
+ foreach (var item in itemlist)
+ {
+ var info = new TN_OnOff_Shelves
+ {
+ S_NO = task.S_NO,
+ N_ACTION = action,
+ S_ACTION = s_action,
+ S_ITEM_CODE = item.S_ITEM_CODE,
+ S_ITEM_NAME = item.S_ITEM_NAME,
+ S_LOC_CODE = task.S_END_LOC,
+ S_AREA_CODE = task.S_END_AREA,
+ S_CNTR_CODE = cntr_code,
+ S_BATCH_NO = item.S_BATCH_NO,
+ S_SERIAL_NO = item.S_SERIAL_NO,
+ //D_PRD_DATE = item.D_PRD_DATE,
+ F_QTY = item.F_QTY
+ };
+ db.Insertable(info).ExecuteCommand();
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Error($"涓婃灦璁板綍娣诲姞寮傚父 寮傚父淇℃伅={ex.Message}", ex);
+ }
+ }
+
internal static void AddChange(WCSTask task)
{
var db = new SqlHelper<object>().GetInstance();
--
Gitblit v1.9.1