public static void CriteriaToWhereClause(XElement elem)
{
var item = elem.DescendantsAndSelf("Item").First();
if (item.Attribute("type") == null)
{
return;
}
var origQueryType = item.Attribute("queryType")?.Value;
item.SetAttributeValue("queryType", "ignore");
var builder = new CriteriaBuilder()
{
Operator = "and",
Type = "[" + item.Attribute("type").Value.Replace(' ', '_') + "]"
};
ProcessCriteria(elem, builder);
var where = item.Attribute("where");
var whereClause = builder.ToString();
if (where != null)
{
whereClause += " and " + where.Value;
}
item.SetAttributeValue("where", whereClause);
}
public string GetSqlString()
{
StringBuilder _queryBuilder = new StringBuilder();
_queryBuilder.Append(CriteriaBuilder.ToString());
_queryBuilder.Append(GroupBy.GetSqlString());
_queryBuilder.Append(Orders.GetSqlString());
return(_queryBuilder.ToString());
}
public static void CriteriaToWhereClause(XElement elem)
{
var item = elem.DescendantsAndSelf("Item").First();
if (item.Attribute("type") == null)
return;
var builder = new CriteriaBuilder()
{
Operator = "and",
Type = "[" + item.Attribute("type").Value.Replace(' ', '_') + "]"
};
ProcessCriteria(elem, builder);
var where = item.Attribute("where");
var whereClause = builder.ToString();
if (where != null)
whereClause += " and " + where.Value;
item.SetAttributeValue("where", whereClause);
}
public override string ToString()
{
return(_criteriaBuilder.ToString());
}
