public async Task <FaultPaging> GetAll(int skip, int limit) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var sql = Sql.SqlQueryCach["Fault.All"]; var result = await conn.QueryAsync <Fault>(sql, new { skip = skip, limit = limit }); var sqlc = Sql.SqlQueryCach["Fault.CountAll"]; var count = await conn.ExecuteScalarAsync <int>(sqlc); var output = new FaultPaging() { Data = result.ToArray(), Total = count }; return(output); } }
public async Task <FaultPaging> GetAll(int skip, int limit, string filter) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { string sqlfilter, sql; CreateFilter(filter, out sqlfilter, out sql); //var sql = Sql.SqlQueryCach["Fault.All"]; var result = await conn.QueryAsync <Fault>(sql, new { skip = skip, limit = limit }); var sqlc = $"{FaultCommon.sqlCountCommon} {sqlfilter}"; var count = conn.ExecuteScalar <int>(sqlc); var output = new FaultPaging() { Data = result.ToArray(), Total = count }; return(output); } }