From 8dd9fc1a302394e1511f44ec35127e42fd20c1ea Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期五, 07 二月 2025 08:10:38 +0800 Subject: [PATCH] 1.条码拆分 --- util/BillNo.cs | 47 ++++++++++++++++++++++++----------------------- 1 files changed, 24 insertions(+), 23 deletions(-) diff --git a/util/BillNo.cs b/util/BillNo.cs index 2bd4eed..aa7c5ef 100644 --- a/util/BillNo.cs +++ b/util/BillNo.cs @@ -1,31 +1,32 @@ 锘縰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; } -} +} \ No newline at end of file -- Gitblit v1.9.3