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;
    }
}