public void Reverse() { var item = new OrderByItem("field1", SortOrder.Ascending); item.Reverse(); Assert.AreEqual("field1 desc", item.ToString()); Assert.AreEqual(SortOrder.Descending, item.Order); }
public void IsEmpty() { var clause = new OrderByClause(); Assert.IsTrue(clause.IsEmpty); var item = new OrderByItem("field1", SortOrder.Descending); clause.Add(item); Assert.IsFalse(clause.IsEmpty); }
public void Create() { var item = new OrderByItem("field1", SortOrder.Ascending); Assert.AreEqual("field1", item.GetSql()); Assert.AreEqual("field1", item.ToString()); item.Order = SortOrder.Descending; Assert.AreEqual("field1 desc",item.ToString()); Assert.IsFalse(item.IsEmpty); }
public void Clone() { var item = new OrderByItem("field1", SortOrder.Descending); var clone = item.Clone(); Assert.IsTrue(item.Equals(clone)); clone.Reverse(); Assert.IsFalse(item.Equals(clone)); clone.Reverse(); Assert.IsTrue(item.Equals(clone)); }
public void Create() { var item = new OrderByItem("field1", SortOrder.Ascending); var clause = new OrderByClause("field1 asc"); Assert.AreEqual(item, clause); clause.Add("field2 desc"); Assert.AreEqual("field1,field2 desc", clause.ToString()); clause = new OrderByClause("field1 desc, field2"); Assert.AreEqual("field1 desc,field2", clause.ToString()); }
public void IsEmpty() { var item = new OrderByItem(); Assert.IsTrue(item.IsEmpty); item.Field = "test"; item.Order = SortOrder.Ascending; Assert.IsFalse(item.IsEmpty); Assert.AreEqual("test", item.GetSql()); item.Order = SortOrder.Descending; Assert.AreEqual("test desc", item.GetSql()); }
protected IOrderByClause Add(string field, SortOrder order, AddWhen when) { if (String.IsNullOrEmpty(field)) { throw new ArgumentOutOfRangeException("The field name cannot be missing to add a sort"); } string sortOrder = order == SortOrder.Ascending ? "" : " DESC"; int index = InnerList.Count - 1; string fieldNameClean = unAliased(field.Trim().ToLower()); var crit = new OrderByItem(fieldNameClean, order); return(Add(crit, when)); }
public void Add() { IOrderByClause clause = new OrderByClause("field1 desc, field2"); var item = new OrderByItem("field3", SortOrder.Descending); clause.Add(item); Assert.AreEqual("field1 desc,field2,field3 desc", clause.ToString()); // can't add existing field Assert.Throws<ArgumentException>(() => { clause.Add("field2"); }); clause.AddAlways("field1", SortOrder.Ascending); Assert.AreEqual("field2,field3 desc,field1", clause.ToString()); item.Reverse(); Assert.AreEqual("field2,field3,field1", clause.ToString()); }
public OrderByItem Clone() { OrderByItem clone = new OrderByItem(Field,Order); return clone; }
protected IOrderByClause Add(string field, SortOrder order,AddWhen when) { if (String.IsNullOrEmpty(field)) { throw new ArgumentOutOfRangeException("The field name cannot be missing to add a sort"); } string sortOrder = order == SortOrder.Ascending ? "" : " DESC"; int index = InnerList.Count - 1; string fieldNameClean = unAliased(field.Trim().ToLower()); var crit = new OrderByItem(fieldNameClean, order); return Add(crit,when); }
public OrderByItem Clone() { OrderByItem clone = new OrderByItem(Field, Order); return(clone); }