| | |
|---|
| | | public static class BillNo |
|---|
| | | { |
|---|
| | | /// <summary> |
|---|
| | | /// TL(采购退料单),DH(到货单),JY(检验单),IN(入库单) |
|---|
| | | /// TL(采购退料单),DH(到货单),JY(检验单),IN(入库单),TMBH(条码编号) |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="billType"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public static string GetBillNo(string billType) |
|---|
| | | 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"); |
|---|
| | | sbSql.Append(" EXEC [getOrderNo] '" + billType + "',@hNo output,'" + |
|---|
| | | itemNo + "'"); |
|---|
| | | sbSql.Append(" select @hNo as t1"); |
|---|
| | | var str = ""; |
|---|
| | | try |
|---|
