啊鑫
8 天以前 0aa54059b26e6641196e9953490dd18616e916e3
util/BillNo.cs
@@ -30,25 +30,27 @@
        return str;
    }
    public static string ExecuteBarcodeSplit(string cUser, string oldBarcode, decimal? qty)
    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(
            "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 ");
            .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();
            str = DbHelperSQL.GetSingle(sbSql.ToString())?.ToString();
        }
        catch (Exception ex)
        {
            // 记录日志或处理异常
             str = "";
            str = "";
        }
        return str;
    }
}
}