From f6e624ccbea24503d0a77e839eeb2af13038d8ac Mon Sep 17 00:00:00 2001
From: cjs <2216046164@qq.com>
Date: 星期一, 30 六月 2025 17:31:46 +0800
Subject: [PATCH] 111
---
HH.WCS.Mobox3.NongFuLinZhi/api/DebugController.cs | 18 +++++++++
HH.WCS.Mobox3.NongFuLinZhi/api/ApiModel.cs | 13 ++++++
HH.WCS.Mobox3.NongFuLinZhi/api/ApiHelper.cs | 44 ++++++++++++++++++++++
3 files changed, 75 insertions(+), 0 deletions(-)
diff --git a/HH.WCS.Mobox3.NongFuLinZhi/api/ApiHelper.cs b/HH.WCS.Mobox3.NongFuLinZhi/api/ApiHelper.cs
index 83a590a..5e3f3fa 100644
--- a/HH.WCS.Mobox3.NongFuLinZhi/api/ApiHelper.cs
+++ b/HH.WCS.Mobox3.NongFuLinZhi/api/ApiHelper.cs
@@ -673,6 +673,50 @@
return result;
}
+ internal static ReturnResult bindCntr(bindModel model)
+ {
+ ReturnResult result = new ReturnResult() {ResultCode = -1 };
+ var db = new SqlHelper<object>().GetInstance();
+
+ if (TaskProcess.BindLocCntr(model.S_LOC_CODE, model.S_CNTR_CODE, model.S_ITEM_CODE, model.S_BATCH_CODE))
+ {
+ int num = model.S_CNTR_CODE.Split(',').Count();
+ var locInfo = db.Queryable<Location>().Where(a => a.S_CODE == model.S_LOC_CODE).First();
+ if(locInfo != null)
+ {
+ locInfo.N_CURRENT_NUM = locInfo.N_CURRENT_NUM + num > locInfo.N_CAPACITY ? locInfo.N_CAPACITY : locInfo.N_CURRENT_NUM + num;
+ db.Updateable(locInfo).UpdateColumns(a => new { a.N_CURRENT_NUM }).ExecuteCommand();
+ result.ResultCode = 0;
+ }
+ }
+ return result;
+ }
+
+ internal static ReturnResult unBindCntr(unBindModel model)
+ {
+ ReturnResult result = new ReturnResult() { ResultCode = -1 };
+ var db = new SqlHelper<object>().GetInstance();
+ var locInfo = db.Queryable<Location>().Where(a => a.S_CODE == model.S_LOC_CODE).First();
+ if(locInfo != null)
+ {
+ var cntrList = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == model.S_LOC_CODE).ToList();
+ if(cntrList.Count > 0)
+ {
+ for (int i = cntrList.Count - 1; i >= 0; i --)
+ {
+ string cntrCode = cntrList[i].S_CNTR_CODE;
+ db.Deleteable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntrCode).ExecuteCommand();
+ db.Deleteable<LocCntrRel>().Where(a => a.S_CNTR_CODE == cntrCode).ExecuteCommand();
+ }
+ }
+ locInfo.N_CURRENT_NUM = locInfo.N_CURRENT_NUM - 1;
+ if (locInfo.N_CURRENT_NUM < 0) locInfo.N_CURRENT_NUM = 0;
+ db.Updateable(locInfo).UpdateColumns(a => new { a.N_CURRENT_NUM }).ExecuteCommand();
+ result.ResultCode = 0;
+ }
+ return result;
+ }
+
//public class AddTaskModel
//{
diff --git a/HH.WCS.Mobox3.NongFuLinZhi/api/ApiModel.cs b/HH.WCS.Mobox3.NongFuLinZhi/api/ApiModel.cs
index 24d3a50..c76c969 100644
--- a/HH.WCS.Mobox3.NongFuLinZhi/api/ApiModel.cs
+++ b/HH.WCS.Mobox3.NongFuLinZhi/api/ApiModel.cs
@@ -573,5 +573,18 @@
public string Name { get; set; }
public string Source { get; set; }
}
+
+ public class bindModel
+ {
+ public string S_LOC_CODE { get; set; }
+ public string S_CNTR_CODE { get; set; }
+ public string S_ITEM_CODE { get; set; }
+ public string S_BATCH_CODE { get; set; }
+ }
+
+ public class unBindModel
+ {
+ public string S_LOC_CODE { get; set; }
+ }
}
}
diff --git a/HH.WCS.Mobox3.NongFuLinZhi/api/DebugController.cs b/HH.WCS.Mobox3.NongFuLinZhi/api/DebugController.cs
index 5495862..fb4d0d8 100644
--- a/HH.WCS.Mobox3.NongFuLinZhi/api/DebugController.cs
+++ b/HH.WCS.Mobox3.NongFuLinZhi/api/DebugController.cs
@@ -39,6 +39,24 @@
}
+ [HttpPost]
+ [Route("bindCntr")]
+ public ReturnResult bindCntr(bindModel model)
+ {
+ LogHelper.Info($"bindCntr requst:{model}");
+ ApiHelper.bindCntr(model);
+ return new ReturnResult();
+ }
+
+ [HttpPost]
+ [Route("unBindCntr")]
+ public ReturnResult unBindCntr(unBindModel model)
+ {
+ LogHelper.Info($"unBindCntr requst:{model}");
+ ApiHelper.unBindCntr(model);
+ return new ReturnResult();
+
+ }
}
}
--
Gitblit v1.9.1