From 71d1dcdf796f08fa01cbc2d3faab86eea28b295b Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期三, 17 十二月 2025 08:59:03 +0800
Subject: [PATCH] 物料管理页面修改
---
Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs | 40 ++++++++++++++++++++++++++++++++++++++--
1 files changed, 38 insertions(+), 2 deletions(-)
diff --git a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
index 959b073..f7ce021 100644
--- a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
+++ b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
@@ -96,6 +96,11 @@
throw new Exception("璐ㄦ鍙蜂笉鍙负绌猴紝璇锋牳鏌ワ紒");
}
//楠岃瘉鎵规鍙锋槸鍚︿负绌�
+ if (string.IsNullOrEmpty(model.SkuNo))
+ {
+ throw new Exception("鐗╂枡缂栫爜涓嶅彲涓虹┖锛岃鏍告煡锛�");
+ }
+ //楠岃瘉鎵规鍙锋槸鍚︿负绌�
if (string.IsNullOrEmpty(model.LotNo))
{
throw new Exception("鎵规鍙蜂笉鍙负绌猴紝璇锋牳鏌ワ紒");
@@ -103,14 +108,17 @@
model.Origin = "WMS"; //鏉ユ簮
model.CreateTime = Db.GetDate(); //鍒涘缓鏃ユ湡
- model.SkuNo = ""; //鐗╂枡鍙�
model.SkuName = ""; //鐗╂枡鍚嶇О
model.PassQty = 0; //鍚堟牸鏁伴噺
model.FailQty = 0; //涓嶅悎鏍兼暟閲�
model.Standard = ""; //瑙勬牸
//鏌ユ壘搴撳瓨鏄庣粏淇℃伅
- List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.LotNo == model.LotNo).ToList();
+ List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo).ToList();
+ if (detail.Count == 0)
+ {
+ throw new Exception("鏈壘鍒板綋鍓嶇墿鏂欏綋鍓嶆壒娆＄殑搴撳瓨");
+ }
foreach (var item in detail)
{
//鍒ゆ柇鍚堟牸鐘舵�佹槸鍚﹀悎鏍�
@@ -151,6 +159,34 @@
throw new Exception(ex.Message);
}
}
+
+ /// <summary>
+ /// 鑾峰彇搴撳瓨鎵规鍙烽泦鍚�
+ /// </summary>
+ /// <returns></returns>
+ /// <exception cref="Exception"></exception>
+ public List<DataStockDetail> GetLotNoList(string skuNo)
+ {
+ try
+ {
+ string str = "select skuNo from DataStockDetail where isDel = '0'";
+ if (!string.IsNullOrEmpty(skuNo))
+ {
+ str += " and skuNo = @skuNo";
+ }
+
+ str += " group by skuNo";
+ List<DataStockDetail> skulist = Db.Ado.SqlQuery<DataStockDetail>(str, new
+ {
+ SkuNo = "%" + skuNo + "%", //鐗╂枡鍙�
+ });
+ return skulist;
+ }
+ catch (Exception ex)
+ {
+ throw new Exception(ex.Message);
+ }
+ }
#endregion
}
--
Gitblit v1.8.0