/// <summary> /// 执行查询语句,返回一个DataSet对象 /// </summary> /// <param name="cmdType">命令类型</param> /// <param name="cmdText">查询语句</param> /// <param name="objParams">查询语句参数</param> /// <returns>返回结果</returns> public static DataSet Query(CommandType cmdType, string cmdText, params ObjectParameter[] objParams) { DataSet dsResult = null; switch (DbType.ToLower()) { case "oracle": dsResult = OracleDbHelper.Query(DbConnectionString, cmdType, FormatCommandText(cmdText), ObjectParamterToOracleParameter(objParams)); break; case "sql": dsResult = SqlDbHelper.Query(DbConnectionString, cmdType, FormatCommandText(cmdText), ObjectParamterToSqlParameter(objParams)); break; } return(dsResult); }
/// <summary> /// 执行查询语句,返回DataSet对象 /// </summary> /// <param name="cmdText">查询语句</param> /// <returns>返回结果</returns> public static DataSet Query(string cmdText) { DataSet dsResult = null; switch (DbType.ToLower()) { case "oracle": dsResult = OracleDbHelper.Query(DbConnectionString, cmdText); break; case "sql": dsResult = SqlDbHelper.Query(DbConnectionString, cmdText); break; } return(dsResult); }