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