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