public SqlServerPageRequest(JObject form, Dictionary <string, string> defaultSort = null, string[] ignore = null) { Queries = new List <IQuery>(); Sort = new SqlServerSort(); if (form.ContainsKey("params") && form["params"] is JObject param) { foreach (var keyValue in param) { switch (keyValue.Key.ToLower()) { case "current": this.Current = keyValue.Value.ToInt(); break; case "pagesize": this.Size = keyValue.Value.ToInt(); break; default: if (keyValue.Key.IsSqlField() && (ignore == null || !ignore.Contains(keyValue.Key))) { Queries.Add(new DefaultQuery(GetValue(keyValue.Value), new DefaultQuerySql(keyValue.Key, GetQuerySymbol(form, keyValue.Key)))); } break; } } } if (defaultSort != null) { foreach (var keyValue in defaultSort) { Sort.Add(keyValue.Key, ToSortOrder(keyValue.Value.ToStr().ToLower())); } } if (form.ContainsKey("sort") && form["sort"] is JObject sort && sort.HasValues) { foreach (var jToken in sort) { if (jToken.Key.IsSqlField()) { Sort.Add(jToken.Key, ToSortOrder(jToken.Value.ToStr())); } } }
public SqlServerPageRequest() { Sort = new SqlServerSort().Add("Id"); Queries = new List <IQuery>(); }