public void FilterExpressionBool()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(bool), "Column1");
columnFilterLogic.SetFilter(true);
TestFilterExpression("[COLUMN1] = 1", columnFilterLogic);
columnFilterLogic.SetFilter(false);
TestFilterExpression("[COLUMN1] = 0", columnFilterLogic);
}
public void FilterExpressionText()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(string), "Column1");
columnFilterLogic.SetFilter("Hello");
TestFilterExpression("[COLUMN1]='Hello'", columnFilterLogic);
columnFilterLogic.SetFilter("He\'llo");
TestFilterExpression("[Column1]='He\'\'llo'", columnFilterLogic);
columnFilterLogic.SetFilter(10);
columnFilterLogic.Operator = "longer";
TestFilterExpression("Len([Column1]) > 10", columnFilterLogic);
}
public void FilterExpressionNumber()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(float), "Column1");
columnFilterLogic.SetFilter(5.0);
TestFilterExpression("[Column1] = 5", columnFilterLogic);
}
public void SetFilter()
{
var control = new ColumnFilterLogic(typeof(double), "Column1");
control.SetFilter(2);
Assert.AreEqual("[Column1] = 2", control.BuildSQLCommand(control.ValueText));
}
public void SetFilterTest()
{
using (var crtl = new ColumnFilterLogic(typeof(double), "Column1"))
{
crtl.SetFilter(2);
Assert.AreEqual("[Column1] = 2", crtl.BuildSQLCommand(crtl.ValueText));
}
}
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 Active()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "Column1");
var dtm = DateTime.Now;
columnFilterLogic.SetFilter(dtm);
columnFilterLogic.Active = true;
Assert.IsTrue(columnFilterLogic.Active);
}
public void SetActiveTest()
{
using (var crtl = new ColumnFilterLogic(typeof(DateTime), "Column1"))
{
var dtm = DateTime.Now;
crtl.SetFilter(dtm);
crtl.Active = true;
Assert.IsTrue(crtl.Active);
}
}
public void FilterExpressionDate()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "Column1");
columnFilterLogic.SetFilter(new DateTime(2020, 02, 20));
var test = columnFilterLogic.FilterExpression.ToUpperInvariant().Replace(" ", "");
Assert.IsTrue(test.Contains("[COLUMN1]>=#02/20/2020#"));
Assert.IsTrue(test.Contains("[COLUMN1]<#02/21/2020#"));
}
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);
}
}
