/// <summary> /// 返回Ilist或者List<T> /// </summary> /// <typeparam name="T"></typeparam> /// <param name="where"></param> /// <param name="colNameSort">null 则不排序</param> /// <param name="cmdParms"></param> /// <returns></returns> public static List <T> GetListWhere <T>(string where, string colNameSort, params OracleParameter[] cmdParms) { T model = Activator.CreateInstance <T>(); Type type = model.GetType(); StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("SELECT * FROM {0} WHERE 1=1 ", type.Name); strSql.Append(where); if (!string.IsNullOrEmpty(colNameSort)) { strSql.AppendFormat(" Order BY {0}", colNameSort); } return(DataConvertHelper.ReaderToList <T>(ExecuteDataReader(strSql.ToString(), cmdParms))); }