From 7d772840712a8dd5be125ba70060a1bf1bf322d6 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期三, 22 十月 2025 15:48:38 +0800
Subject: [PATCH] 采购入库优化
---
service/Warehouse/MesInvItemInCDetailsManager.cs | 38 ++++++++++++++++++++------------------
1 files changed, 20 insertions(+), 18 deletions(-)
diff --git a/service/Warehouse/MesInvItemInCDetailsManager.cs b/service/Warehouse/MesInvItemInCDetailsManager.cs
index bb925b3..ee58fca 100644
--- a/service/Warehouse/MesInvItemInCDetailsManager.cs
+++ b/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -23,7 +23,7 @@
public ItemInBaseModel SaveBarCodes(WarehouseQuery entity)
{
ItemInBaseModel res = new ItemInBaseModel();
- string connectionString = DbHelperSQL.strConn;
+ string connectionString = DB.DbHelperSQL.strConn;
// 鍙傛暟楠岃瘉
if (string.IsNullOrEmpty(entity.userName)) throw new ArgumentNullException(nameof(entity.userName), "鐢ㄦ埛鍚嶄笉鍏佽涓虹┖");
@@ -34,8 +34,8 @@
{
using (var cmd = new SqlCommand("[prc_pda_inv_cgrk]", conn))
{
- try
- {
+ //try
+ //{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
@@ -45,6 +45,7 @@
new SqlParameter("@pi_user", SqlDbType.NVarChar, 100) { Value = entity.userName },
new SqlParameter("@pi_barcode", SqlDbType.NVarChar, 100) { Value = entity.barcode.Trim().ToLower() },
new SqlParameter("@pi_sectionCode", SqlDbType.NVarChar, 30) { Value = entity.sectionCode },
+ new SqlParameter("@pi_cgrkType", SqlDbType.NVarChar, 30) { Value = "姝ｅ父鍏ュ簱" },
new SqlParameter("@pi_weight", SqlDbType.Decimal) { Value = entity.weight },
new SqlParameter("@po_outMsg", SqlDbType.NVarChar, 300) { Direction = ParameterDirection.Output },
new SqlParameter("@po_outSum", SqlDbType.NVarChar, 300) { Direction = ParameterDirection.Output }
@@ -54,8 +55,8 @@
cmd.ExecuteNonQuery();
// 鑾峰彇杈撳嚭鍙傛暟
- string? outMessage = parameters[4].Value?.ToString();
- string? outSum = parameters[5].Value?.ToString();
+ string? outMessage = parameters[5].Value?.ToString();
+ string? outSum = parameters[6].Value?.ToString();
// 妫�鏌ュ弬鏁版槸鍚︿负绌猴紝骞跺湪寮傚父涓樉绀哄疄闄呭��
@@ -135,16 +136,16 @@
return res;
- }
- catch (Exception ex)
- {
+ //}
+ //catch (Exception ex)
+ //{
- // 璁板綍寮傚父鏃ュ織锛堝缓璁坊鍔犳棩蹇楄褰曪級
- res.Message = $"鎿嶄綔澶辫触: {ex.Message}";
- res.SumQuantity = -1;
- return res;
- }
+ // // 璁板綍寮傚父鏃ュ織锛堝缓璁坊鍔犳棩蹇楄褰曪級
+ // res.Message = $"鎿嶄綔澶辫触: {ex.Message}";
+ // res.SumQuantity = -1;
+ // return res;
+ //}
}
}
}
@@ -1412,7 +1413,7 @@
string intSum = "";
string cfBar = "";
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ using (var conn = new SqlConnection(DB.DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("[prc_pda_bar_cf_before]", conn))
{
@@ -1448,7 +1449,7 @@
string ytSum = "";
string ytdh = "";
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ using (var conn = new SqlConnection(DB.DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("prc_pda_scan_CGYT", conn))
{
@@ -1478,7 +1479,7 @@
string rkMsg = "";
string rkSum = "";
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ using (var conn = new SqlConnection(DB.DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("prc_pda_inv_cgrk", conn))
{
@@ -1489,6 +1490,7 @@
new("@pi_user", SqlDbType.NVarChar, 100) { Value = entity.userName },
new("@pi_barcode", SqlDbType.NVarChar, 100) { Value = entity.returnBarcode }, // 浣跨敤鍘熷鏉＄爜
new("@pi_sectionCode", SqlDbType.NVarChar, 100) { Value = entity.sectionCode },
+ new("@pi_cgrkType", SqlDbType.NVarChar, 30) { Value = "姝ｅ父鍏ュ簱" },
new("@pi_weight", SqlDbType.Decimal) { Value = entity.weight },
new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
new("@po_outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }
@@ -1497,8 +1499,8 @@
cmd.Parameters.AddRange(rkParameters);
cmd.ExecuteNonQuery();
- rkMsg = rkParameters[4].Value.ToString();
- rkSum = rkParameters[5].Value.ToString();
+ rkMsg = rkParameters[5].Value.ToString();
+ rkSum = rkParameters[6].Value.ToString();
if (rkSum == "-1") throw new Exception(rkMsg);
}
--
Gitblit v1.9.3