From 505e0d47a72f51b0dc4dc315f8fce36cc73abc89 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期二, 29 七月 2025 17:28:28 +0800
Subject: [PATCH] 添加看板获取货位状态接口, 修复容器插入, 货位容器绑定货位字段未更新的问题
---
api/DebugController.cs | 24 +++++++++++++++++++++++-
1 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/api/DebugController.cs b/api/DebugController.cs
index f83777f..181c631 100644
--- a/api/DebugController.cs
+++ b/api/DebugController.cs
@@ -202,7 +202,7 @@
var cntrListToUpdate = new List<TN_Container>();
var cntrListToInsert = new List<TN_Container>();
foreach (var cntr in result) {
- var oldCntr = cntrList.Where(c => c.S_CODE == cntr.S_CNTR_CODE).First();
+ var oldCntr = cntrList.Where(c => c.S_CODE == cntr.S_CNTR_CODE).FirstOrDefault();
if (oldCntr == null) {
cntrListToUpdate.Add(new TN_Container { S_CODE = cntr.S_CNTR_CODE, N_DETAIL_COUNT = cntr.Count });
}
@@ -231,6 +231,28 @@
return "success";
}
+
+ [HttpPost]
+
+ public string RefreshCgDetail() {
+ var db = new SqlHelper<object>().GetInstance();
+ try {
+ var locCntrRelList = db.Queryable<TN_Loc_Container>().ToList();
+ var cgDetailList = db.Queryable<TN_CG_Detail>().ToList();
+ cgDetailList.ForEach(d => {
+ var locCntrRel = locCntrRelList.Where(c => c.S_CNTR_CODE == d.S_CNTR_CODE).FirstOrDefault();
+ if (locCntrRel != null) {
+ d.S_LOC_CODE = locCntrRel.S_LOC_CODE;
+ }
+ });
+
+ var res = db.Updateable(cgDetailList).UpdateColumns(it => new { it.S_LOC_CODE }).ExecuteCommand();
+ return $"{res}";
+ }
+ catch (Exception ex) {
+ return ex.Message;
+ }
+ }
}
public class CntrCodeCountResult {
--
Gitblit v1.9.1