From f10e29b77659f6b7db1cf8d0e0fc5387b958e2c5 Mon Sep 17 00:00:00 2001 From: wxw <Administrator@DESKTOP-5BIMHQ3> Date: 星期三, 17 七月 2024 16:54:08 +0800 Subject: [PATCH] Merge branch 'wxw' --- Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs | 8 ++++++-- 1 files changed, 6 insertions(+), 2 deletions(-) diff --git a/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs b/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs index 154a06f..e746979 100644 --- a/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs +++ b/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs @@ -430,6 +430,7 @@ IsWave = "0", WaveNo = "", IsIssueLotNo = string.IsNullOrWhiteSpace(d.LotNo) ? "0" : "1", + IsMixBox = d.IsMixBox, OrderDetailCode = d.OrderDetailCode, @@ -540,7 +541,7 @@ var item = new BllExportNoticeDetail() { SONo = billNo, - OrderDetailCode=d.OrderDetailCode, + OrderDetailCode = d.OrderDetailCode, SkuNo = sku.SkuNo, SkuName = sku.SkuName, Standard = sku.Standard, @@ -559,6 +560,7 @@ IsWave = "0", WaveNo = "", IsIssueLotNo = string.IsNullOrWhiteSpace(d.LotNo) ? "0" : "1", + IsMixBox = d.IsMixBox, CreateUser = 0, }; @@ -4307,6 +4309,8 @@ var noticeDetail = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == soNo).ToList(); //搴撳瓨鎬昏〃淇℃伅 var data = Db.Queryable<DataStock>().Where(m => m.IsDel == "0").ToList(); + //搴撳瓨鏄庣粏涓楠屽悎鏍兼壒娆¢泦鍚� + var dataDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.InspectStatus == "1").GroupBy(g => g.LotNo).Select(s => s.LotNo).ToList(); //搴撳瓨鏄庣粏琛ㄤ俊鎭� var dataBoxInfo = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0").ToList(); @@ -4316,7 +4320,7 @@ { //楠岃瘉鍏堣繘鍏堝嚭鍘熷垯 - var forData = data.Where(m => m.SkuNo == item.SkuNo && m.LotNo != item.LotNo && (m.Qty - m.FrozenQty - m.LockQty) > 0 ).Select(m=>m.LotNo).ToList(); //鑾峰彇褰撳墠鐗╂枡鐨勬墍鏈夋壒娆′俊鎭�(鎺掗櫎鍗曟嵁鐨勬壒娆★紝闃叉鍗曟嵁鎵�鍦ㄦ壒娆¢攣瀹氭暟閲忓悗楠岃瘉灏忎簬绛変簬0) + var forData = data.Where(m => m.SkuNo == item.SkuNo && m.LotNo != item.LotNo && (m.Qty - m.FrozenQty - m.LockQty) > 0 && dataDetail.Contains(m.LotNo)).Select(m=>m.LotNo).ToList(); //鑾峰彇褰撳墠鐗╂枡鐨勬墍鏈夋壒娆′俊鎭�(鎺掗櫎鍗曟嵁鐨勬壒娆★紝闃叉鍗曟嵁鎵�鍦ㄦ壒娆¢攣瀹氭暟閲忓悗楠岃瘉灏忎簬绛変簬0) forData.Add(item.LotNo); //闆嗗悎娣诲姞鍗曟嵁鐨勬壒娆� //鑾峰彇鎺掑簭鍚庣殑绗竴涓壒娆� -- Gitblit v1.8.0