/// <summary>
/// 获取自定义sql返回的结果
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public DataSet getSearchResult(string sql, Hashtable ht)
{
List <OracleParameter> li = new List <OracleParameter>();
foreach (DictionaryEntry objDE in ht)
{
li.Add(ora.BuildOracleParameter(objDE.Key.ToString(), OracleDbType.Varchar2, ParameterDirection.Input, 0, objDE.Value.ToString()));
}
return(ora.Query(sql, li.ToArray()));
}