OracleConnection conn = new OracleConnection(OracleHelper.ConnectionString);
OracleCommand cmd = new OracleCommand();
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "DotNet.DotNetPageRecordsCount";
cmd.Parameters.Add("SqlStr", OracleType.VarChar).Value = Sql;
cmd.Parameters.Add("TotalCount", OracleType.Number).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
TotalCount = int.Parse(cmd.Parameters["TotalCount"].Value.ToString());
cmd.Parameters.Clear(); cmd.CommandText = "DotNet.DotNetPagination";
cmd.Parameters.Add("CurrentPage", OracleType.Number).Value = CurrentPage;
cmd.Parameters.Add("SqlStr", OracleType.VarChar).Value = Sql;
cmd.Parameters.Add("PageSize", OracleType.Number).Value = PageSize;
cmd.Parameters.Add("PageCount", OracleType.Number).Direction = ParameterDirection.Output;
cmd.Parameters.Add("v_cur", OracleType.Cursor).Direction = ParameterDirection.Output; OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PageCount = int.Parse(cmd.Parameters["PageCount"].Value.ToString());
return dr;返回的dr没有结果行,那个存储过程我也没改什么 不知道为什么
OracleCommand cmd = new OracleCommand();
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "DotNet.DotNetPageRecordsCount";
cmd.Parameters.Add("SqlStr", OracleType.VarChar).Value = Sql;
cmd.Parameters.Add("TotalCount", OracleType.Number).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
TotalCount = int.Parse(cmd.Parameters["TotalCount"].Value.ToString());
cmd.Parameters.Clear(); cmd.CommandText = "DotNet.DotNetPagination";
cmd.Parameters.Add("CurrentPage", OracleType.Number).Value = CurrentPage;
cmd.Parameters.Add("SqlStr", OracleType.VarChar).Value = Sql;
cmd.Parameters.Add("PageSize", OracleType.Number).Value = PageSize;
cmd.Parameters.Add("PageCount", OracleType.Number).Direction = ParameterDirection.Output;
cmd.Parameters.Add("v_cur", OracleType.Cursor).Direction = ParameterDirection.Output; OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PageCount = int.Parse(cmd.Parameters["PageCount"].Value.ToString());
return dr;返回的dr没有结果行,那个存储过程我也没改什么 不知道为什么
直接使用单个sql即可搞定了.