From f5e16cc4ddb1f890d9629511b64a8e282316c424 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期三, 03 九月 2025 15:51:47 +0800
Subject: [PATCH] 其他入库修改存储过程名称
---
util/BillNo.cs | 31 +++++++++++++++++++++++++++----
1 files changed, 27 insertions(+), 4 deletions(-)
diff --git a/util/BillNo.cs b/util/BillNo.cs
index 3065ded..5b985cf 100644
--- a/util/BillNo.cs
+++ b/util/BillNo.cs
@@ -6,15 +6,16 @@
public static class BillNo
{
/// <summary>
- /// TL(閲囪喘閫�鏂欏崟),DH(鍒拌揣鍗�),JY(妫�楠屽崟),IN(鍏ュ簱鍗�)
+ /// TL(閲囪喘閫�鏂欏崟),DH(鍒拌揣鍗�),JY(妫�楠屽崟),IN(鍏ュ簱鍗�),TMBH(鏉＄爜缂栧彿)
/// </summary>
/// <param name="billType"></param>
/// <returns></returns>
- public static string GetBillNo(string billType)
+ public static string GetBillNo(string billType, string itemNo = "")
{
var sbSql = new StringBuilder();
sbSql.Append(" DECLARE @hNo nvarchar(50) ");
- sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output");
+ sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output,'" +
+ itemNo + "'");
sbSql.Append(" select @hNo as t1");
var str = "";
try
@@ -28,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