From 48df8080d7befac9fff4f5345750699c592512f6 Mon Sep 17 00:00:00 2001
From: chengsc <11752@DESKTOP-DS49RCP>
Date: 星期三, 07 五月 2025 08:21:28 +0800
Subject: [PATCH] 修改问题
---
Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs | 45 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 45 insertions(+), 0 deletions(-)
diff --git a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
index 09749f0..6b68462 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
@@ -1847,6 +1847,51 @@
}
}
+ /// <summary>
+ /// 鏍规嵁鍗曟嵁鑾峰彇鏍囩鏁伴噺
+ /// </summary>
+ /// <param name="asnNo">鍏ュ簱鍗�</param>
+ /// <param name="asnDetailId">鍏ュ簱鍗曟槑缁嗗彿</param>
+ /// <returns></returns>
+ public BoxListInfoDto GetBoxCountByAsn(string asnNo,int? asnDetailId)
+ {
+ try
+ {
+
+ var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == asnDetailId);
+ if (detail == null)
+ {
+ throw new Exception("娌℃湁鏌ヨ鍒板崟鎹槑缁嗕俊鎭�");
+ }
+ var data = new BoxListInfoDto()
+ {
+ SkuNo = detail.SkuNo,
+ SkuName = detail.SkuName,
+ LotNo = detail.LotNo,
+
+ };
+ //鑾峰彇鐘舵�佹槸鏈粍鎵樼殑鏍囩淇℃伅
+ var models = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo && m.ASNDetailNo == asnDetailId ).GroupBy(m=> new { m.ProductionTime,m.ExpirationTime }).Select(m=>new { m.ProductionTime ,m.ExpirationTime}).OrderBy(m=>m.ProductionTime).ToList();//&& m.Status == "0"
+ foreach (var item in models)
+ {
+ var boxNoList = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo && m.ASNDetailNo == asnDetailId && m.ProductionTime == item.ProductionTime).Select(m => m.BoxNo).ToList();
+ if (boxNoList.Count > 0)
+ {
+ data.BoxNoList = boxNoList;
+ data.Date1 = item.ProductionTime.ToString();
+ data.Date2 = item.ExpirationTime.ToString();
+
+ break;
+ }
+ }
+ return data;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
#endregion
--
Gitblit v1.8.0