OracleDataReader GetReaderBySQL(OracleConnection Connection, string strSql, params OracleParameter[] dbParams)
{
OracleCommand command = OracleHelp.buidOracleCommand(Connection, strSql, dbParams);
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
return(command.ExecuteReader(CommandBehavior.CloseConnection));
}
public object getScalar(string sqlWhere = null, OracleParameter[] dbParams = null, string colList = "*", string orderBy = null, uint skip = 0, uint take = 0)
{
string strSql = buildSelectSql(sqlWhere: sqlWhere, colList: colList, orderBy: orderBy, skip: skip, take: take);
using (OracleConnection conn = new OracleConnection(connString))
{
OracleCommand command = OracleHelp.buidOracleCommand(conn, strSql, dbParams);
conn.Open();
return(command.ExecuteScalar());
}
}
/// <summary>
/// 用SQL存储过程获得一个Model
/// </summary>
///
public T getModelByStorePro(string StoredProcedure, params OracleParameter[] dbParams)
{
using (OracleConnection conn = new OracleConnection(connString))
{
OracleCommand command = OracleHelp.buidOracleCommand(conn, StoredProcedure, dbParams);
command.CommandType = CommandType.StoredProcedure;
conn.Open();
OracleDataReader reader = command.ExecuteReader();
return(BuildModel(reader));
}
}
public override DataTable getDataTable(string sqlWhere = null, OracleParameter[] dbParams = null, string colList = "*", string orderBy = null, uint skip = 0, uint take = 0, string tableName = null)
{
string strSql = buildSelectSql(sqlWhere: sqlWhere, colList: colList, orderBy: orderBy, take: take, skip: skip, tableName: tableName);
using (OracleConnection conn = new OracleConnection(connString))
{
OracleCommand command = OracleHelp.buidOracleCommand(conn, strSql, dbParams);
DataSet ds = new DataSet();
conn.Open();
OracleDataAdapter da = new OracleDataAdapter(command);
da.Fill(ds);
return(ds.Tables[0]);
}
}
/// <summary>
/// 返回一个SqlDataReader，记得调用方要关闭连接
/// </summary>
public static OracleDataReader ExecuteReader(string SQL, string connection, params OracleParameter[] dbParams)
{
return(ExecuteReader(SQL, connection, CommandType.Text, OracleHelp.buidCommandParams(SQL, dbParams)));
}
/// <summary>
/// 返回一个数据表
/// </summary>
public static DataTable ExecuteDataTable(string SQL, string connection, params object[] dbParams)
{
return(ExecuteDataTable(SQL, connection, CommandType.Text, OracleHelp.buidCommandParams(SQL, dbParams)));
}
/// <summary>
/// 返回受影响的记录数
/// </summary>
public static int ExecuteNonQuery(string SQL, string connection, params object[] dbParams)
{
return(ExecuteNonQuery(SQL, connection, CommandType.Text, OracleHelp.buidCommandParams(SQL, dbParams)));
}
