DbHelperSql.cs 调用存贮过程返回流水号id 运行出错!
@信心 2012-04-16 11:31:43 在winform 中调用存贮过程返回流水号id 运行出错!
#region 调用存贮过程返回流水号id
/// <summary>
/// 执行存储过程,返回影响的行数
/// </summary>
/// <param name="storedProcName">存储过程名</param>
/// <param name="parameters">存储过程参数</param>
/// <param name=" SerialNumber">流水号</param>字段 类型是int 自增长
/// /// <param name="feildName">feidName</param>
/// <returns></returns>
public static int RunProcedure(string storedProcName, IDataParameter[] parameters, string feidName, out int SerialNumber)
{
//using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlConnection connection = new SqlConnection(DatabaseConnetString1))
{
//int sn;
connection.Open();
SqlCommand command = BuildIntCommand(connection, storedProcName, parameters);
//SqlParameter sn = new SqlParameter("@SerialNumber", SqlDbType.Int);
//sn.Direction = ParameterDirection.Output;
//command.Parameters .Add(sn);
command.ExecuteNonQuery();
SerialNumber = (int)command.Parameters["feidName"].Value;
connection.Close();
return SerialNumber;
}
}
#endregion