生成流水号,数字序号可以指定长度,SP下载

C# Code:


/// <summary>
/// 在同一事务内生成流水号
/// </summary>
/// <param name="tran">当前事务</param>
/// <param name="dataCode">字头</param>
/// <param name="asHeader">当号码表没有该字头的定义，自动初始化一条序号为1的记录</param>
/// <param name="asLength">数字序号的长度,如: 000001, 完整流水号 字头: XX000001</param>
/// <returns></returns>
public static string GetDataSN(SqlTransaction tran, string dataCode, bool asHeader, int asLength)
{
   string SQL = "sp_sys_GetDataSN '" dataCode "','" (asHeader ? "Y" : "N") "','" asLength "'";
   SqlCommand cmd = new SqlCommand(SQL, tran.Connection, tran);
   object no = cmd.ExecuteScalar();
   return ConvertEx.ToString(no);
}

//来源:C/S框架网(www.csframework.com) QQ:1980854898