From 4db3ba3f84456c27fdd9be76ff76c17101270914 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 24 九月 2025 14:12:48 +0800
Subject: [PATCH] 111
---
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 befa0c8..7a1d9bf 100644
--- a/service/Warehouse/MesSctkManager.cs
+++ b/service/Warehouse/MesSctkManager.cs
@@ -1,11 +1,12 @@
锘縰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 NewPdaSqlServer.util;
+using SqlSugar;
namespace NewPdaSqlServer.service.Warehouse;
@@ -26,8 +27,7 @@
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