From 1bb18b7bd0e348c71bf8e3d57d77cf1a2d0e03a9 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期一, 22 九月 2025 15:10:17 +0800
Subject: [PATCH] 1.受托退料:优化。2.受托入库：列表查询与选择改为存储过程，添加成功声音

---
 util/BillNo.cs |   24 +++++++++++++++++++++++-
 1 files changed, 23 insertions(+), 1 deletions(-)

diff --git a/util/BillNo.cs b/util/BillNo.cs
index aa7c5ef..5b985cf 100644
--- a/util/BillNo.cs
+++ b/util/BillNo.cs
@@ -29,4 +29,26 @@
 
         return str;
     }
-}
\ No newline at end of file
+
+    public static string ExecuteBarcodeSplit(string cUser, string oldBarcode, decimal? qty)
+    {
+        var sbSql = new StringBuilder();
+        sbSql.Append("DECLARE @outMsg nvarchar(2000), @outSum int, @barcodeNew varchar(200) ");
+        sbSql.Append("EXEC prc_pda_bar_cf '").Append(cUser).Append("', '")
+              .Append(oldBarcode).Append("', ").Append(qty)
+              .Append(", @outMsg OUTPUT, @outSum OUTPUT, @barcodeNew OUTPUT ");
+        sbSql.Append("SELECT @barcodeNew");
+        var str = "";
+        try
+        {
+            str =  DbHelperSQL.GetSingle(sbSql.ToString())?.ToString();
+        }
+        catch (Exception ex)
+        {
+            // 璁板綍鏃ュ織鎴栧鐞嗗紓甯�
+             str = "";
+        }
+        return str;
+    }
+}
+

--
Gitblit v1.9.3