From 85f6fe8f419a7dc04ae2e2e8d2314162bd0cfb6e Mon Sep 17 00:00:00 2001 From: bklLiudl <673013083@qq.com> Date: 星期六, 09 三月 2024 16:38:02 +0800 Subject: [PATCH] 修复bug --- HTML/views/ASNSetting/PalletBind.html | 12 +++++++++--- Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs | 16 ++++++++++++++-- 2 files changed, 23 insertions(+), 5 deletions(-) diff --git a/HTML/views/ASNSetting/PalletBind.html b/HTML/views/ASNSetting/PalletBind.html index 27cd3e6..f59ebdd 100644 --- a/HTML/views/ASNSetting/PalletBind.html +++ b/HTML/views/ASNSetting/PalletBind.html @@ -929,7 +929,12 @@ colsJson2 = DetailColsArr } var param = { - BindNo: parseInt(BindNo) + BindNo: parseInt(BindNo), + ASNNo: $("#ASNNo").val(), + PalletNo: $("#PalletNo").val(), + SkuNo: $("#SkuNo").val(), + SkuName: $("#SkuName").val(), + LotNo: $("#LotNo").val(), }; table.render({ id: 'BoxInfo', @@ -1042,8 +1047,9 @@ time: 2000 //2绉掑叧闂紙濡傛灉涓嶉厤缃紝榛樿鏄�3绉掞級 }, function () { bindPalletBind(); - bindBoxInfo(quanSkuNo); }); + + } else { //涓嶆垚鍔� layer.msg(res.msg, { icon: 2, @@ -1138,7 +1144,7 @@ time: 2000 //2绉掑叧闂紙濡傛灉涓嶉厤缃紝榛樿鏄�3绉掞級 }, function () { bindPalletBind(); - bindBoxInfo("0"); + bindBoxInfo(quanSkuNo); }); } else { //涓嶆垚鍔� layer.msg(res.msg, { diff --git a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs index adb86a9..a9b7c7a 100644 --- a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs +++ b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs @@ -114,8 +114,19 @@ { try { + Expression<Func<BllBoxInfo, bool>> item1 = Expressionable.Create<BllBoxInfo>() + .AndIF(!string.IsNullOrWhiteSpace(model.ASNNo), it => it.ASNNo.Contains(model.ASNNo.Trim())) + .AndIF(!string.IsNullOrWhiteSpace(model.PalletNo), it => it.PalletNo.Contains(model.PalletNo.Trim())) + .AndIF(!string.IsNullOrWhiteSpace(model.LotNo), it => it.LotNo.Contains(model.LotNo.Trim())) + .AndIF(!string.IsNullOrWhiteSpace(model.SkuNo), it => it.SkuNo.Contains(model.SkuNo.Trim())) + .AndIF(!string.IsNullOrWhiteSpace(model.SkuName), it => it.SkuName.Contains(model.SkuName.Trim())) + .AndIF((model.BindNo != 0 && !string.IsNullOrWhiteSpace(model.BindNo.ToString())),it=>it.BindNo == model.BindNo) + .And(m => m.IsDel == "0") + .ToExpression(); + var total = 0; - var data = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BindNo == model.BindNo) + DbHelper<BllBoxInfo> helper = new DbHelper<BllBoxInfo>(Db); + var data = helper.GetAllWhereAsync(item1).Where(m => m.IsDel == "0") .LeftJoin<BllPalletBind>((a, b) => a.BindNo == b.Id) .GroupBy((a, b) => new { @@ -380,7 +391,8 @@ Db.Updateable(boxInfos).ExecuteCommand(); //淇敼鎵樼洏缁戝畾淇℃伅 - bind.Qty -= qty; + bind.Qty -= qty; // 鏁伴噺鍙樻洿 + bind.BitPalletMark = "1"; // 闆舵墭鏍囪鍙樻洿 if (bind.Qty == 0) { -- Gitblit v1.8.0