public static MySqlConditionBuilder CreateCondition(JObject criteria, MySqlConditionBuilder condition = null)
{
condition = condition ?? new MySqlConditionBuilder();
condition.NewGroup();
int i = 0;
foreach (KeyValuePair <string, JToken> pair in criteria)
{
if (i > 0)
{
condition.And();
}
condition.Column(pair.Key);
string value = (string)pair.Value;
string[] operands = value.Split("OR");
foreach (string operand in operands)
{
string[] split = operand.Split(" ");
if (split[0] == "LIKE")
{
condition.Like(split[1]);
}
else
{
condition.Equals(operand, MySql.Data.MySqlClient.MySqlDbType.String);
}
if (operands.Last() != operand)
{
condition.Or();
}
}
i++;
}
return(condition.EndGroup());
}