/// <summary>
/// 根据SQL语句获得相应的记录数
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="sql">原始SQL语句</param>
/// <param name="cmdParms">参数数组</param>
/// <returns>记录数</returns>
public static int GetRecordCount(OracleConnection conn, string sql, params OracleParameter[] cmdParms)
{
string newSql = string.Format("select count(*) from ({0}) temp001", sql);
object count = DbHelperOracle.ExecuteScalar(conn, newSql, cmdParms);
if (count == null || count == DBNull.Value)
{
return(0);
}
else
{
return(Convert.ToInt32(count));
}
}
