From 8b7abd97e7b69800789134ed8e809e19a5b5ba74 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 17 九月 2025 00:30:27 +0800
Subject: [PATCH] 111
---
service/Warehouse/MesXkyShdManager.cs | 45 +++++++++++++++++++++++----------------------
1 files changed, 23 insertions(+), 22 deletions(-)
diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs
index cdb3113..5b50dd9 100644
--- a/service/Warehouse/MesXkyShdManager.cs
+++ b/service/Warehouse/MesXkyShdManager.cs
@@ -1,17 +1,15 @@
锘縰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娉ㄥ叆
@@ -23,13 +21,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
@@ -58,7 +56,6 @@
public dynamic GetShdhBar(dynamic unity)
{
-
//// 浣跨敤鍙傛暟鍖栨煡璇㈤槻姝QL娉ㄥ叆
var sqlParams = new List<SugarParameter> { new("@shdh", unity.shdh) };
@@ -105,12 +102,14 @@
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));
@@ -125,11 +124,16 @@
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;
@@ -146,7 +150,6 @@
return _strMsg;
//return 0;
-
}
catch (Exception ex)
{
@@ -159,6 +162,4 @@
}
}
}
-}
-
-
+}
\ No newline at end of file
--
Gitblit v1.9.3