using System.Text;
|
using NewPdaSqlServer.DB;
|
|
namespace NewPdaSqlServer.util;
|
|
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 = "")
|
{
|
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
|
{
|
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;
|
}
|
}
|
