From 657a052c5ec133abd43ab397d679304a1a8a61e3 Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期四, 20 十一月 2025 11:03:02 +0800
Subject: [PATCH] 录入质检结果修改库存箱码
---
Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
index 369d67e..c818606 100644
--- a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
+++ b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
@@ -80,7 +80,7 @@
skuname = "%" + model.SkuName + "%", //鐗╂枡鍚嶇О
lotno = model.LotNo, //鎵规鍙�
isqualified = model.IsQualified, //鏄惁鍚堟牸
- origin=model.Origin//鏉ユ簮
+ origin = model.Origin//鏉ユ簮
});
return qualityList;
}
@@ -166,7 +166,7 @@
{
sqlStr += $" and LotNo='{model.LotNo}' ";
}
- BllArrivalNoticeDetail arrivalDetail = Db.SqlQueryable<BllArrivalNoticeDetail>(sqlStr).First();
+ BllArrivalNoticeDetail arrivalDetail = Db.SqlQueryable<BllArrivalNoticeDetail>(sqlStr).First();
if (arrivalDetail == null)
{
throw new Exception("鏈壘鍒板叆搴撳崟淇℃伅锛�");
@@ -195,7 +195,7 @@
List<DataStockDetail> detail = Db.SqlQueryable<DataStockDetail>(sqlStr2).ToList();
foreach (var item in detail)
{
- List<BllBoxInfo> box = Db.Queryable<BllBoxInfo>().Where(a => a.IsDel == "0" && a.SkuNo == model.SkuNo && a.LotNo == model.LotNo).ToList();
+ //List<BllBoxInfo> box = Db.Queryable<BllBoxInfo>().Where(a => a.IsDel == "0" && a.SkuNo == model.SkuNo && a.LotNo == model.LotNo).ToList();
//鍒ゆ柇鍚堟牸鐘舵�佹槸鍚﹀悎鏍�
if (model.IsQualified == "1")
{
@@ -211,13 +211,18 @@
item.InspectStatus = "2"; //2涓嶅悎鏍�
}
- Db.Updateable(box).ExecuteCommand();
+ //Db.Updateable(box).ExecuteCommand();
Db.Updateable(item).ExecuteCommand();
}
Db.Updateable(arrivalDetail).ExecuteCommand();
var isquality = Db.Insertable(model).ExecuteCommand();
+ //淇敼搴撳瓨绠辩爜璐ㄦ鐘舵��
+ string uptDataBoxStatusSql = $@"update DataBoxInfo set InspectStatus='1' where IsDel='0' and SkuNo='{model.SkuNo}' and LotNo='{model.LotNo}' and StockDetailId in (select Id from DataStockDetail where IsDel='0' and SkuNo='{model.SkuNo}' and LotNo='{model.LotNo}' and InspectStatus='1') ";
+ int uptDataBoxStatus = Db.Ado.ExecuteCommand(uptDataBoxStatusSql);
+
+
return isquality;
}
/// <summary>
--
Gitblit v1.8.0