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