From 0aa54059b26e6641196e9953490dd18616e916e3 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 10 九月 2025 17:26:47 +0800 Subject: [PATCH] 精简修正代码 --- service/Warehouse/MesSctkManager.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/service/Warehouse/MesSctkManager.cs b/service/Warehouse/MesSctkManager.cs index 7a1d9bf..befa0c8 100644 --- a/service/Warehouse/MesSctkManager.cs +++ b/service/Warehouse/MesSctkManager.cs @@ -1,12 +1,11 @@ 锘縰sing System.Data; using System.Data.SqlClient; using Masuit.Tools; -using MES.Service.Models; using NewPdaSqlServer.DB; using NewPdaSqlServer.Dto.service; using NewPdaSqlServer.entity; using NewPdaSqlServer.entity.Base; -using SqlSugar; +using NewPdaSqlServer.util; namespace NewPdaSqlServer.service.Warehouse; @@ -27,7 +26,8 @@ var mesInvItemOuts = base.GetSingle(it => it.BillNo == 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.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty, + var sql = string.Format( + @"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty, dbo.F_QX_GETRECODEPOTSE(A.ITEM_ID,'','','') as RecoKw fROM MES_SCTH_SQ_DETAIL A LEFT JOIN MES_SCTH_SQ B ON A.MID = B.ID -- Gitblit v1.9.3