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 | 54 +++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 41 insertions(+), 13 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 1261ea9..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>
@@ -145,6 +145,34 @@
//1.0 鏌ヨ揣浣嶅鍣ㄨ〃
var db = new SqlHelper<object>().GetInstance();
return db.Queryable<LocCntrRel>().Count(a => a.S_LOC_CODE.Trim() == cntr) == 0;
+
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁鎵樼洏缂栫爜鏌ヨ鎵樼洏鐗╂枡缁戝畾
+ /// </summary>
+ /// <param name="cntr"></param>
+ /// <returns></returns>
+ internal static CntrItemDetail FindCntrItemByCntr(string cntr)
+ {
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE.Trim() == cntr).First();
+
+ }
+
+ /// <summary>
+ /// 淇敼鍏ュ簱鏃堕棿
+ /// </summary>
+ /// <param name="cntr"></param>
+ /// <returns></returns>
+ internal static bool UpdateInTime(CntrItemDetail cntrItem)
+ {
+ //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;
}
/// <summary>
@@ -159,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;
@@ -274,11 +302,11 @@
return res;
}
-
-
-
-
-
+
+
+
+
+
internal static bool UpdateCntrState(List<string> cntrs, int state)
{
var res = false;
@@ -296,8 +324,8 @@
return res;
}
-
-
+
+
/// <summary>
/// enable 璁╂墭鐩樺厑璁歌鍑哄簱璁＄畻鍒帮紝鍚屾椂澧炲姞閲忚〃鏁版嵁
/// </summary>
--
Gitblit v1.9.1