1.其他入库优化 2.条码入库前拆分优化 3.携客云送货单签收显示优化

南骏 池

2025-07-04 a12a74003597af2d6a7fd37e54509909bd4b23bb

 util/BillNo.cs

@@ -1,31 +1,54 @@
using 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;
    }
}