From 6ec09f73c6515297294d24cdec4c815927450607 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 05 六月 2025 09:51:19 +0800
Subject: [PATCH] 1.其他入库sql执行优化
---
service/Warehouse/MesItemQtrkManager.cs | 17 +++++++++++------
1 files changed, 11 insertions(+), 6 deletions(-)
diff --git a/service/Warehouse/MesItemQtrkManager.cs b/service/Warehouse/MesItemQtrkManager.cs
index 81eceda..14e0390 100644
--- a/service/Warehouse/MesItemQtrkManager.cs
+++ b/service/Warehouse/MesItemQtrkManager.cs
@@ -26,13 +26,18 @@
var mesInvItemOuts = base.GetSingle(it => it.Qtck == query.billNo);
if (mesInvItemOuts == null) throw new Exception("鍏朵粬鍏ュ簱鐢宠鍗曚笉瀛樺湪");
- var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.qd007 FQty,A.qd008 SQty,A.qd007 - A.qd008 DSQty
-fROM MES_ITEM_QTRR_DETAIL A
- LEFT JOIN MES_ITEM_QTRK B ON A.qtrkGuid = B.guid
- LEFT JOIN MES_ITEMS C ON A.itemId = C.item_id
-WHERE B.qtck = '{0}'", query.billNo);
+ var sql = @"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,
+ A.qd007 FQty,A.qd008 SQty,A.qd007 - A.qd008 DSQty
+ FROM MES_ITEM_QTRR_DETAIL A
+ LEFT JOIN MES_ITEM_QTRK B ON A.qtrkGuid = B.guid
+ LEFT JOIN MES_ITEMS C ON A.itemId = C.item_id
+ WHERE B.qtck = @billNo";
- var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
+ var sqlParams = new List<SugarParameter> {
+ new("@billNo", query.billNo)
+ };
+
+ var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql, sqlParams);
var DS_list = womdabs.Where(s => s.DSQty > 0).ToList();
--
Gitblit v1.9.3