From 17e3ef45fe0a6b6f8a147b50740834ac734f9317 Mon Sep 17 00:00:00 2001
From: lss <2538410689@qq.com>
Date: 星期二, 15 七月 2025 17:30:13 +0800
Subject: [PATCH] 1111
---
HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/ContainerHelper.cs | 34 ++++++++++++++++++----------------
1 files changed, 18 insertions(+), 16 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/ContainerHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/ContainerHelper.cs
index 8b48a1d..5161b55 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/ContainerHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/ContainerHelper.cs
@@ -21,7 +21,7 @@
var date = DateTime.Now.ToString("yyMMdd");
return $"TP{date}{id.ToString().PadLeft(4, '0')}";
}
-
+
internal static bool CreateCntrItem(string loc, string cntr, string itemcode)
{
@@ -136,7 +136,7 @@
//}
/// <summary>
- /// 鍒ゆ柇瀹瑰櫒鏄惁鏈夌墿鏂欎俊鎭�+ /// 鍒ゆ柇瀹瑰櫒鏄惁缁戝畾璐т綅
/// </summary>
/// <param name="cntr"></param>
/// <returns></returns>
@@ -147,6 +147,8 @@
return db.Queryable<LocCntrRel>().Count(a => a.S_LOC_CODE.Trim() == cntr) == 0;
}
+
+
/// <summary>
/// 鏍规嵁鎵樼洏缂栫爜鏌ヨ鎵樼洏鐗╂枡缁戝畾
/// </summary>
@@ -156,7 +158,7 @@
{
//1.0 鏌ヨ揣浣嶅鍣ㄨ〃
var db = new SqlHelper<object>().GetInstance();
- return db.Queryable<CntrItemDetail>().Where(a => a.S_ITEM_CODE.Trim() == cntr).First();
+ return db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE.Trim() == cntr).First();
}
@@ -169,8 +171,8 @@
{
//1.0 鏌ヨ揣浣嶅鍣ㄨ〃
var db = new SqlHelper<object>().GetInstance();
- cntrItem.T_INBOUND_TIME=DateTime.Now.ToString("yyyy-MM-dd");
- return db.Updateable<CntrItemDetail>(cntrItem).UpdateColumns(a => new { a.T_INBOUND_TIME }).ExecuteCommand()>0;
+ cntrItem.T_INBOUND_TIME = DateTime.Now.ToString("yyyy-MM-dd");
+ return db.Updateable<CntrItemDetail>(cntrItem).UpdateColumns(a => new { a.T_INBOUND_TIME }).ExecuteCommand() > 0;
}
/// <summary>
@@ -185,18 +187,18 @@
return db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE.Trim() == cntr).First();
}
- internal static bool AddCntr(string cntrCode, string itemCode)
+ internal static bool AddCntr(string cntrCode,string source="1")
{
var res = false;
var db = new SqlHelper<object>().GetInstance();
- var TN_Container = new Container { S_CODE = cntrCode };
- var cntrItemRel = new CntrItemDetail { S_CNTR_CODE = cntrCode, S_ITEM_CODE = itemCode };
+ var TN_Container = new Container { S_CODE = cntrCode, S_SOURCE = source };
+
try
{
db.BeginTran();
db.Insertable<Container>(TN_Container).ExecuteCommand();
- db.Insertable<CntrItemDetail>(cntrItemRel).ExecuteCommand();
+
db.CommitTran();
res = true;
@@ -300,11 +302,11 @@
return res;
}
-
-
-
-
-
+
+
+
+
+
internal static bool UpdateCntrState(List<string> cntrs, int state)
{
var res = false;
@@ -322,8 +324,8 @@
return res;
}
-
-
+
+
/// <summary>
/// enable 璁╂墭鐩樺厑璁歌鍑哄簱璁＄畻鍒帮紝鍚屾椂澧炲姞閲忚〃鏁版嵁
/// </summary>
--
Gitblit v1.9.1