using System.Text;
using NewPdaSqlServer.DB;
namespace NewPdaSqlServer.util;
public static class BillNo
{
///
/// TL(采购退料单),DH(到货单),JY(检验单),IN(入库单)
///
///
///
public static string GetBillNo(string billType)
{
var sbSql = new StringBuilder();
sbSql.Append(" DECLARE @hNo nvarchar(50) ");
sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output");
sbSql.Append(" select @hNo as t1");
var str = "";
try
{
str = DbHelperSQL.GetSingle(sbSql.ToString()).ToString();
}
catch (Exception ex)
{
str = Guid.NewGuid().ToString();
}
return str;
}
}