public static string GetWhereClause(JQGrid grid, string filters, string ignoreFilterField)
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
JsonMultipleSearch jsonMultipleSearch = javaScriptSerializer.Deserialize <JsonMultipleSearch>(filters);
string text = "";
foreach (MultipleSearchRule current in jsonMultipleSearch.rules)
{
if (string.IsNullOrEmpty(current.op))
{
continue;
}
if (!string.IsNullOrWhiteSpace(ignoreFilterField) && current.field == ignoreFilterField)
{
continue;
}
Util.SearchArguments args = new Util.SearchArguments
{
SearchColumn = current.field,
SearchString = current.data,
SearchOperation = Util.GetSearchOperationFromString(current.op)
};
string str = (text.Length > 0) ? (" " + jsonMultipleSearch.groupOp + " ") : "";
text = text + str + Util.ConstructLinqFilterExpression(grid, args);
}
return(text);
}
public static string GetWhereClause(JQGrid grid, string searchField, string searchString, string searchOper)
{
string text = " && ";
string text2 = "";
new Hashtable();
Util.SearchArguments args = new Util.SearchArguments
{
SearchColumn = searchField,
SearchString = searchString,
SearchOperation = Util.GetSearchOperationFromString(searchOper)
};
string str = (text2.Length > 0) ? text : "";
string str2 = Util.ConstructLinqFilterExpression(grid, args);
return(text2 + str + str2);
}
