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))); }