From 1483d0e74b4dde9eb22e022276390bfa1f24495b Mon Sep 17 00:00:00 2001
From: hudong <Administrator@PC-20250329JZUF>
Date: 星期五, 30 五月 2025 08:58:53 +0800
Subject: [PATCH] wsdl文件替换 大屏接口开发
---
wms/WMSHelper.cs | 60 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 59 insertions(+), 1 deletions(-)
diff --git a/wms/WMSHelper.cs b/wms/WMSHelper.cs
index 66c650f..ff45bca 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();
@@ -397,6 +401,50 @@
S_LOC_CODE = task.S_END_LOC,
S_AREA_CODE = task.S_END_AREA,
S_CNTR_CODE = task.S_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 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,
@@ -870,7 +918,17 @@
WMSHelper.UpdateTaskState(wmsTask);
WCSHelper.UpdateStorStatus(task.S_CNTR_CODE, 4);
}
+ internal static void Fail(WCSTask task)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ var wmsTask = db.Queryable<WMSTask>().Where(a => a.S_CODE == task.S_OP_CODE).First();
+ //淇敼浣滀笟鐘舵� 閲嶆柊鍚姩
+ wmsTask.N_B_STATE = 5;
+ wmsTask.S_B_STATE = "鍙栨秷";
+ WMSHelper.UpdateTaskState(wmsTask);
+ //WCSHelper.UpdateStorStatus(task.S_CNTR_CODE, 4);
+ }
internal static void EndTn(string S_CNTR_CODE)
{
var db = new SqlHelper<object>().GetInstance();
--
Gitblit v1.9.1