/// <summary>
/// 查询datatable
/// </summary>
/// <param name="Sql"></param>
/// <param name="Cache"></param>
/// <returns></returns>
public DataTable Get(Parm <string> Sql, bool Cache = false)
{
if (Cache)
{
var table = Level2CacheRegister.Get(Sql.Entity, GetTable);
return(table);
}
else
{
var table = GetTable(Sql.Entity);
return(table);
}
}
/// <summary>
/// 查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Entity"></param>
/// <param name="Cache"></param>
/// <returns></returns>
public List <T> Get <T>(T Entity, bool Cache = false) where T : DTOBase, new()
{
var sql = CreateSql.Build((DTOBase)Entity);
List <T> list = null;
if (Cache)
{
list = Level2CacheRegister.Get <T>(sql, Entity.QueryParams, GetList <T>);
}
else
{
list = GetList <T>(sql, Entity.QueryParams);
}
Entity.ResetQuery();
return(list);
}
/// <summary>
/// 查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="where"></param>
/// <param name="parameters"></param>
/// <param name="columns"></param>
/// <param name="Cache"></param>
/// <returns></returns>
public List <T> Get <T>(string where = null, object[] parameters = null, object[] columns = null, bool Cache = false) where T : DTOBase, new()
{
T Entity = new T();
if (columns != null)
{
Entity.Select(columns);
}
if (!string.IsNullOrWhiteSpace(where))
{
Entity.Where(where, parameters);
}
var sql = CreateSql.Build((DTOBase)Entity);
List <T> list = null;
list = Cache ? Level2CacheRegister.Get <T>(sql, Entity.QueryParams, GetList <T>)
: GetList <T>(sql, Entity.QueryParams);
Entity.ResetQuery();
return(list);
}
