public void Contains() { var columnFilterLogic = new ColumnFilterLogic(typeof(string), "strCol"); columnFilterLogic.SetFilter("Hello"); columnFilterLogic.Operator = ColumnFilterLogic.GetOperators(typeof(string)).First().ToString(); TestFilterExpression("[strCol] like '%Hello%'", columnFilterLogic); }
public void AllFilterBool() { var columnFilterLogic = new ColumnFilterLogic(typeof(bool), "strCol"); columnFilterLogic.SetFilter("true"); foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType)) { columnFilterLogic.Operator = op.ToString(); Assert.IsNotNull(columnFilterLogic.FilterExpression); } }
public void AllFilterString() { var columnFilterLogic = new ColumnFilterLogic(typeof(string), "strCol") { ValueText = "Hello" }; foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType)) { columnFilterLogic.Operator = op.ToString(); columnFilterLogic.Active = true; Assert.IsNotNull(columnFilterLogic.FilterExpression); } }
public void GetOperatorsTest() { var stringType = ColumnFilterLogic.GetOperators(typeof(string)); Assert.AreEqual(9, stringType.Length); var dateTimeType = ColumnFilterLogic.GetOperators(typeof(DateTime)); Assert.AreEqual(8, dateTimeType.Length); var boolType = ColumnFilterLogic.GetOperators(typeof(bool)); Assert.AreEqual(4, boolType.Length); }
public void AllFilterInt() { var columnFilterLogic = new ColumnFilterLogic(typeof(int), "intCol") { ValueText = "-10" }; Assert.AreEqual("-10", columnFilterLogic.ValueText); foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType)) { columnFilterLogic.Operator = op.ToString(); columnFilterLogic.Active = true; Assert.IsNotNull(columnFilterLogic.FilterExpression); } }
public void AllFilterDateTime() { var dtm = DateTime.Now; var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "dtmCol") { ValueDateTime = dtm }; Assert.AreEqual(dtm, columnFilterLogic.ValueDateTime); foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType)) { columnFilterLogic.Operator = op.ToString(); columnFilterLogic.Active = true; Assert.IsNotNull(columnFilterLogic.FilterExpression); } }