/// <summary> /// Получить все с пагинацией /// </summary> /// <param name="skip"></param> /// <param name="limit"></param> /// <returns></returns> public BrigadePaging GetAllSync(int skip, int limit) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var sql = Sql.SqlQueryCach["Brigade.All"]; var result = conn.Query <Brigade>(sql, new { skip = skip, limit = limit }); var sqlc = Sql.SqlQueryCach["Brigade.CountAll"]; var count = conn.ExecuteScalar <int>(sqlc); var output = new BrigadePaging() { Data = result.ToArray(), Total = count }; return(output); } }
public async Task <BrigadePaging> GetAll(int skip, int limit, string filter) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { CreateFilter(filter, out var sqlfilter, out var sql); var result = await conn.QueryAsync <Brigade>(sql, new { skip = skip, limit = limit }); var sqlc = $"{BrigadeCommon.sqlCountCommon} {sqlfilter}"; var count = conn.ExecuteScalar <int>(sqlc); var output = new BrigadePaging() { Data = result.ToArray(), Total = count }; return(output); } }