From 00a72fff219241eb5b0405a066cc859d07cf7735 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 17 九月 2025 10:23:44 +0800
Subject: [PATCH] 1111
---
service/Warehouse/MesXkyShdManager.cs | 45 ++++++++++++++++++++++-----------------------
1 files changed, 22 insertions(+), 23 deletions(-)
diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs
index 5b50dd9..cdb3113 100644
--- a/service/Warehouse/MesXkyShdManager.cs
+++ b/service/Warehouse/MesXkyShdManager.cs
@@ -1,15 +1,17 @@
锘縰sing System.Data;
using System.Data.SqlClient;
+using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
-using NewPdaSqlServer.util;
using SqlSugar;
+using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
namespace NewPdaSqlServer.service.Warehouse;
public class MesXkyShdManager : Repository<MesCgthSq>
{
+
public dynamic GetShdhItems(dynamic unity)
{
//// 浣跨敤鍙傛暟鍖栨煡璇㈤槻姝QL娉ㄥ叆
@@ -21,13 +23,13 @@
if (shdh.Count < 1)
throw new Exception($"閫佽揣鍗曞彿銆恵unity.shdh}銆戜笉瀛樺湪鎴栨湭鍚屾!");
- // var sql3 = @"SELECT ISNULL((SELECT SUM(delivery_qty) FROM DELIVERY_NOTICE_DETAIL WHERE delivery_no = @shdh), 0) -
- //ISNULL((SELECT SUM(include_qty) FROM TBL_BARCODE_INFORMATION WHERE delivery_no = @shdh), 0) AS Diffnum ";
+ // var sql3 = @"SELECT ISNULL((SELECT SUM(delivery_qty) FROM DELIVERY_NOTICE_DETAIL WHERE delivery_no = @shdh), 0) -
+ //ISNULL((SELECT SUM(include_qty) FROM TBL_BARCODE_INFORMATION WHERE delivery_no = @shdh), 0) AS Diffnum ";
- // var diffNum = Db.Ado.SqlQuery<dynamic>(sql3, sqlParams).First();
+ // var diffNum = Db.Ado.SqlQuery<dynamic>(sql3, sqlParams).First();
- // if (diffNum.Diffnum != 0)
- // throw new Exception($"閫佽揣鍗曞彿銆恵unity.shdh}銆戞潯鐮佹湭鍏ㄩ儴鎵撳嵃鎴栨湭鍚屾锛屾棤娉曟敹璐э紒");
+ // if (diffNum.Diffnum != 0)
+ // throw new Exception($"閫佽揣鍗曞彿銆恵unity.shdh}銆戞潯鐮佹湭鍏ㄩ儴鎵撳嵃鎴栨湭鍚屾锛屾棤娉曟敹璐э紒");
var sql2 = @"WITH dhmx AS(
SELECT E.line_k3id,B.paper_bill_no,B.guid,E.quantity FROM dbo.MES_INV_ITEM_ARN B LEFT JOIN MES_INV_ITEM_ARN_DETAIL E ON B.guid = E.parent_Guid
@@ -56,6 +58,7 @@
public dynamic GetShdhBar(dynamic unity)
{
+
//// 浣跨敤鍙傛暟鍖栨煡璇㈤槻姝QL娉ㄥ叆
var sqlParams = new List<SugarParameter> { new("@shdh", unity.shdh) };
@@ -102,14 +105,12 @@
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
// 鏂板绌哄璞℃牎楠�
- if (unity == null)
- throw new ArgumentNullException(nameof(unity), "鍙傛暟瀵硅薄涓嶈兘涓� null");
-
+ if (unity == null) throw new ArgumentNullException(nameof(unity), "鍙傛暟瀵硅薄涓嶈兘涓� null");
+
// 鍙傛暟鏍￠獙澧炲己
if (string.IsNullOrEmpty(unity.userName?.ToString()))
- throw new ArgumentException("鐢ㄦ埛璐︽埛涓嶅厑璁镐负绌�",
- nameof(unity.userName));
-
+ throw new ArgumentException("鐢ㄦ埛璐︽埛涓嶅厑璁镐负绌�", nameof(unity.userName));
+
if (string.IsNullOrEmpty(unity.shdh?.ToString()))
throw new ArgumentException("閫佽揣鍗曞彿涓嶅厑璁镐负绌�", nameof(unity.shdh));
@@ -124,16 +125,11 @@
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameters =
{
- new("@po_outMsg", SqlDbType.NVarChar, 300)
- { Direction = ParameterDirection.Output },
- new("@po_outSum", SqlDbType.NVarChar, 300)
- { Direction = ParameterDirection.Output },
- new("@pi_user", SqlDbType.NVarChar)
- { Value = unity.userName.ToString() }, // 鏄惧紡绫诲瀷杞崲
- new("@pi_barcode", SqlDbType.NVarChar)
- { Value = unity.barcode.ToString() },
- new("@pi_shdh", SqlDbType.NVarChar)
- { Value = unity.shdh.ToString() }
+ new("@po_outMsg", SqlDbType.NVarChar, 300) { Direction = ParameterDirection.Output },
+ new("@po_outSum", SqlDbType.NVarChar, 300) { Direction = ParameterDirection.Output },
+ new("@pi_user", SqlDbType.NVarChar) { Value = unity.userName.ToString() }, // 鏄惧紡绫诲瀷杞崲
+ new("@pi_barcode", SqlDbType.NVarChar) { Value = unity.barcode.ToString() },
+ new("@pi_shdh", SqlDbType.NVarChar) { Value = unity.shdh.ToString() }
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
@@ -150,6 +146,7 @@
return _strMsg;
//return 0;
+
}
catch (Exception ex)
{
@@ -162,4 +159,6 @@
}
}
}
-}
\ No newline at end of file
+}
+
+
--
Gitblit v1.9.3