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