From e9269528ae01bc4572b68148b9c801b51f23b669 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 04 9月 2025 10:41:45 +0800 Subject: [PATCH] 查询优化 --- wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs index 86a42a7..cb25b19 100644 --- a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs +++ b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs @@ -946,7 +946,7 @@ { sql = sql + " and supplier like '%" + value.supplier + "%'"; } - if (value.isSendToMes != null && value.isSendToMes != 0) + if (value.isSendToMes != null) { sql = sql + " and isSendToMes = '" + value.isSendToMes + "' "; } @@ -2325,7 +2325,8 @@ preLog = "浜哄伐鍒嗘嫞"; } - OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.鍑哄簱, "浜哄伐鍒犻櫎搴撳瓨:" + preLog, record_delteList, modfiyStock);//鍫嗗灈鏈轰换鍔″畬鎴愬悗鐨勫嚭搴� + OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.鍑哄簱, "浜哄伐鍒犻櫎搴撳瓨:" + preLog, + record_delteList, modfiyStock, (currentStock != null ? currentStock.positionName : ""));//鍫嗗灈鏈轰换鍔″畬鎴愬悗鐨勫嚭搴� int res = mod.SaveChanges(); if (res > 0) -- Gitblit v1.9.3