在网上查了大多数的资料代码都不全。今天实现了一下完美的实现;需要以下步骤
第一:
public class DocNoClass : FullAuditedEntity<string>
{
public string sBillNo { get; set; }
}
第二步:
/// <summary>
/// 根据单据类型获取对应的单号
/// </summary>
/// <param name="DocType">单据类型</param>
/// <returns></returns>
public string GetDocNoByDocTypes(string DocType)
{
SqlParameter[] param ={
new SqlParameter("@sBillType",SqlDbType.NChar,40),
new SqlParameter("@sBillNo",SqlDbType.NChar,40)};
param[0].Value = DocType;
param[1].Direction = ParameterDirection.Output;
string DocNo = string.Empty;
try
{
_sqlExecuter.SqlQuery<DocNoClass>("exec sp_bill_no @sBillType, @sBillNo out", param[0], param[1]);
DocNo = (string)param[1].Value;
}
catch (Exception ex)
{
DocNo = "0";
}
return DocNo;
}
完美的把单号获取出来了