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