/// <summary>
/// 泛型查询默认主键排倒叙
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source">条件</param>
/// <param name="Storing">排序</param>
/// <param name="ConnectionName">数据库连接名字</param>
/// <returns></returns>
public static List <T> GTSearch <T>(this IEnumerable <T> source, string Storing = null, string ConnectionName = null) where T : new()
{
SQLServerDBHeper Helper = GetDBHeper(ConnectionName);
List <T> lt = new List <T>();
DataTable dt = Helper.GetDataTable((source.ToString().Contains("Where") ? (source.AsQueryable().Expression).DealExpress() : "") + " order by " + (string.IsNullOrEmpty(Storing) ? (" Id desc") : Storing), typeof(T).Name);
if (dt == null || dt.Rows.Count == 0)
{
return(lt);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
lt.Add(dt.Rows[i].ToModel <T>());
}
}
return(lt);
}
/// <summary>
/// 泛型查询默认主键排倒叙
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Model">对象</param>
/// <param name="Exp">条件</param>
/// <param name="Storing">排序</param>
/// <param name="ConnectionName">数据库连接名字</param>
/// <returns></returns>
public static List <T> GTSearch <T>(this T Model, Expression <Func <T, bool> > Exp = null, string Storing = null, string ConnectionName = null) where T : new()
{
SQLServerDBHeper Helper = GetDBHeper(ConnectionName);
List <T> lt = new List <T>();
string Condition = Exp.DealExpress();
DataTable dt = Helper.GetDataTable(string.IsNullOrEmpty(Condition) ? "" : " and " + Condition + " order by " + (string.IsNullOrEmpty(Storing) ? (" Id desc") : Storing), typeof(T).Name);
if (dt == null || dt.Rows.Count == 0)
{
return(lt);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
lt.Add(dt.Rows[i].ToModel <T>());
}
}
return(lt);
}
/// <summary>
/// 泛型查询默认主键排倒叙
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Model"></param>
/// <param name="Condition"></param>
/// <param name="ConnectionName">数据库连接名字</param>
/// <returns></returns>
public static List <T> GTSearchCondition <T>(this T Model, string Condition, string ConnectionName = null) where T : new()
{
SQLServerDBHeper Helper = GetDBHeper(ConnectionName);
List <T> lt = new List <T>();
PropertyInfo[] propertys = Model.GetType().GetProperties();
string ModelName = Model.GetType().Name;
DataTable dt = Helper.GetDataTable(Condition, ModelName);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
lt.Add(dt.Rows[i].ToModel <T>());
}
}
return(lt);
}
