/// <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);
}
}
