/// <summary>
/// 查询传输对象列表
/// </summary>
/// <typeparam name="TDto">传输对象类型</typeparam>
/// <param name="condition">查询条件</param>
/// <param name="ignoreFields">要忽略的字段</param>
/// <param name="isWrite">是否为写连接(事务中使用)</param>
/// <returns>传输对象列表</returns>
public IEnumerable <TDto> QueryList <TDto>(object condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <TDto>(condition, TableName, ignoreFields: ignoreFields, dbType: isWrite ? WriterDataType : ReaderDataType);
return(GetDataAccess(isWrite: isWrite).Query <TDto>(query));
}
/// <summary>
/// 异步查询传输对象列表
/// </summary>
/// <typeparam name="TDto">传输对象类型</typeparam>
/// <param name="condition">查询条件</param>
/// <param name="ignoreFields">要忽略的字段</param>
/// <param name="isWrite">是否为写连接(事务中使用)</param>
/// <returns>传输对象列表</returns>
public Task <IEnumerable <TDto> > QueryListAsync <TDto>(Expression <Func <T, bool> > condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <TDto, T>(condition, TableName, ignoreFields: ignoreFields, dbType: isWrite ? WriterDataType : ReaderDataType);
return(GetDataAccess(isWrite: isWrite).QueryAsync <TDto>(query));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="isWrite">是否为写连接(事务中使用)</param>
/// <returns>列表</returns>
public IEnumerable <T> QueryList(object condition, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery(condition, TableName, dbType: isWrite ? WriterDataType : ReaderDataType);
return(GetDataAccess(isWrite: isWrite).Query <T>(query));
}
/// <summary>
/// 异步查询列表
/// </summary>
/// <param name="condition">查询条件</param>
/// <param name="isWrite">是否为写连接(事务中使用)</param>
/// <returns>列表</returns>
public Task <IEnumerable <T> > QueryListAsync(Expression <Func <T, bool> > condition, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery(condition, TableName, dbType: isWrite ? WriterDataType : ReaderDataType);
return(GetDataAccess(isWrite: isWrite).QueryAsync <T>(query));
}
public Task <IEnumerable <T> > QueryListAsync(bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <T>(null, TableName, string.Empty, topCount: null, dbType: WriterDataType);
return(GetDataAccess(isWrite).QueryAsync <T>(query));
}
public Task <IEnumerable <TDto> > QueryListAsync <TDto>(object condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <TDto>(condition, TableName, string.Empty, topCount: null, ignoreFields: ignoreFields, dbType: WriterDataType);
return(GetDataAccess(isWrite).QueryAsync <TDto>(query));
}
public IEnumerable <TDto> QueryList <TDto>(Expression <Func <T, bool> > condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <TDto>(condition, TableName, string.Empty, topCount: null, dbType: WriterDataType);
return(GetDataAccess(isWrite).Query <TDto>(query));
}
public IEnumerable <T> QueryList(object condition, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <T>(condition, TableName, string.Empty, topCount: null, dbType: WriterDataType);
return(GetDataAccess(isWrite).Query <T>(query));
}
/// <summary>
/// 获取模型
/// </summary>
/// <param name="condition"></param>
/// <param name="ignoreFields"></param>
/// <param name="isWrite"></param>
/// <returns></returns>
public Task <T> GetInfoAsync(Expression <Func <T, bool> > condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <T>(condition, TableName, string.Empty, topCount: null, ignoreFields: ignoreFields, dbType: WriterDataType);
return(GetDataAccess().ExecuteScalarAsync <T>(query));
}
/// <summary>
/// 获取模型
/// </summary>
/// <param name="condition"></param>
/// <param name="ignoreFields"></param>
/// <param name="isWrite"></param>
/// <returns></returns>
public T GetInfo(object condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <T>(condition, TableName, string.Empty, topCount: null, ignoreFields: ignoreFields, dbType: WriterDataType);
return(GetDataAccess().QuerySingleOrDefault <T>(query));
}
/// <summary>
/// 获取DTO
/// </summary>
/// <typeparam name="TDto"></typeparam>
/// <param name="condition"></param>
/// <param name="ignoreFields"></param>
/// <param name="isWrite"></param>
/// <returns></returns>
public TDto GetDto <TDto>(object condition, string[] ignoreFields = null, bool isWrite = false)
{
SqlQuery query = SqlQueryUtil.BuilderQuerySqlQuery <TDto>(condition, TableName, string.Empty, topCount: null, ignoreFields: ignoreFields, dbType: WriterDataType);
return(GetDataAccess().ExecuteScalar <TDto>(query));
}