public async Task <List <T> > GetExSqlResultsAsync <T>(ISqlQuery query, string exSubSqlKey)
{
var sql = _subSqlDict[exSubSqlKey];
sql = ReplaceSql(sql);
return((await query.QueryListAsync <T>(sql, _searcheObj)).ToList());
}
public async Task <T> GetResultAsync <T>(ISqlQuery query)
{
var sql = ReplaceSql(_sql);
return((await query.QueryListAsync <T>(sql, _searcheObj)).FirstOrDefault());
}
public async Task <List <T> > GetResultsAsync <T>(ISqlQuery query)
{
var sql = ReplaceSql(_sql);
return((await query.QueryListAsync <T>(sql, _searcheObj)).ToList());
}
public async Task <List <T> > GetPageListAsync <T>(ISqlQuery query)
{
return((await query.QueryListAsync <T>(PageFullSql, _searcheObj)).ToList());
}
public async Task <dynamic> GetTotalCountValuesAsync(ISqlQuery query)
{
var list = await query.QueryListAsync(TotalCountFullSql, _searcheObj);
return(list.FirstOrDefault());
}