Exemple #1
0
        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());
        }
Exemple #2
0
        public async Task <T> GetResultAsync <T>(ISqlQuery query)
        {
            var sql = ReplaceSql(_sql);

            return((await query.QueryListAsync <T>(sql, _searcheObj)).FirstOrDefault());
        }
Exemple #3
0
        public async Task <List <T> > GetResultsAsync <T>(ISqlQuery query)
        {
            var sql = ReplaceSql(_sql);

            return((await query.QueryListAsync <T>(sql, _searcheObj)).ToList());
        }
Exemple #4
0
 public async Task <List <T> > GetPageListAsync <T>(ISqlQuery query)
 {
     return((await query.QueryListAsync <T>(PageFullSql, _searcheObj)).ToList());
 }
Exemple #5
0
        public async Task <dynamic> GetTotalCountValuesAsync(ISqlQuery query)
        {
            var list = await query.QueryListAsync(TotalCountFullSql, _searcheObj);

            return(list.FirstOrDefault());
        }