public static DataTable getdatetable(string sql, params OracleParameter[] cparams)
{
using (OracleConnection oracleCon = new OracleConnection(OracleConStr))
{
oracleCon.Open();
using (OracleCommand cmd = oracleCon.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandTimeout = 600;
if (cparams != null)
{
foreach (OracleParameter opar in cparams)
{
cmd.Parameters.Add(opar);
}
}
DataSet myds = new DataSet();
OracleDataAdapter oda = new OracleDataAdapter(cmd);
oda.Fill(myds);
return myds.Tables[0];
}
}
}
public static object getScalar(string sql)
{
object i = 0;
using (OracleConnection oracleCon = new OracleConnection(OracleConStr))
{
oracleCon.Open();
using (OracleCommand cmd = oracleCon.CreateCommand())
{
cmd.CommandText = sql;
i = Convert.ToInt64(cmd.ExecuteScalar());
}
}
return i;
}
{
using (OracleConnection oracleCon = new OracleConnection(OracleConStr))
{
oracleCon.Open();
using (OracleCommand cmd = oracleCon.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandTimeout = 600;
if (cparams != null)
{
foreach (OracleParameter opar in cparams)
{
cmd.Parameters.Add(opar);
}
}
DataSet myds = new DataSet();
OracleDataAdapter oda = new OracleDataAdapter(cmd);
oda.Fill(myds);
return myds.Tables[0];
}
}
}
public static object getScalar(string sql)
{
object i = 0;
using (OracleConnection oracleCon = new OracleConnection(OracleConStr))
{
oracleCon.Open();
using (OracleCommand cmd = oracleCon.CreateCommand())
{
cmd.CommandText = sql;
i = Convert.ToInt64(cmd.ExecuteScalar());
}
}
return i;
}