From ed670b6b4a44a11060a7527809c84ff4c32ba6a6 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期六, 12 七月 2025 15:39:52 +0800
Subject: [PATCH] 1.AGV接口开发 2.采购扫描验退
---
util/BillNo.cs | 67 ++++++++++++++++++++++-----------
1 files changed, 45 insertions(+), 22 deletions(-)
diff --git a/util/BillNo.cs b/util/BillNo.cs
index 2bd4eed..5b985cf 100644
--- a/util/BillNo.cs
+++ b/util/BillNo.cs
@@ -1,31 +1,54 @@
锘縰sing System.Text;
using NewPdaSqlServer.DB;
-namespace NewPdaSqlServer.util
+namespace NewPdaSqlServer.util;
+
+public static class BillNo
{
- public static class BillNo
+ /// <summary>
+ /// TL(閲囪喘閫�鏂欏崟),DH(鍒拌揣鍗�),JY(妫�楠屽崟),IN(鍏ュ簱鍗�),TMBH(鏉＄爜缂栧彿)
+ /// </summary>
+ /// <param name="billType"></param>
+ /// <returns></returns>
+ public static string GetBillNo(string billType, string itemNo = "")
{
- /// <summary>
- /// TL(閲囪喘閫�鏂欏崟),DH(鍒拌揣鍗�),JY(妫�楠屽崟),IN(鍏ュ簱鍗�)
- /// </summary>
- /// <param name="billType"></param>
- /// <returns></returns>
- public static string GetBillNo(string billType)
+ var sbSql = new StringBuilder();
+ sbSql.Append(" DECLARE @hNo nvarchar(50) ");
+ sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output,'" +
+ itemNo + "'");
+ sbSql.Append(" select @hNo as t1");
+ var str = "";
+ try
{
- StringBuilder sbSql = new StringBuilder();
- sbSql.Append(" DECLARE @hNo nvarchar(50) ");
- sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output");
- sbSql.Append(" select @hNo as t1");
- string str = "";
- try
- {
- str = DbHelperSQL.GetSingle(sbSql.ToString()).ToString();
- }
- catch (Exception ex)
- {
- str = Guid.NewGuid().ToString();
- }
- return str;
+ str = DbHelperSQL.GetSingle(sbSql.ToString()).ToString();
}
+ catch (Exception ex)
+ {
+ str = Guid.NewGuid().ToString();
+ }
+
+ return str;
+ }
+
+ 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