protected void Grid_ProcessColumnAutoFilter(object sender, DevExpress.Web.ASPxGridViewAutoFilterEventArgs e)
{
var grid = (ASPxGridView)sender;
if (e.Column.FieldName == SpecialFilterColumnFieldName && e.Kind == GridViewAutoFilterEventKind.CreateCriteria)
{
grid.FilterExpression = UpdateGridFilterExpression(grid, e);
e.Criteria = null;
}
}
protected void testGrid_ProcessColumnAutoFilter(object sender, DevExpress.Web.ASPxGridViewAutoFilterEventArgs e)
{
if (e.Value == "|")
{
return;
}
if (e.Column.FieldName != "OrderDate")
{
return;
}
if (e.Kind == GridViewAutoFilterEventKind.CreateCriteria)
{
String[] dates = e.Value.Split('|');
Session["DateFilterText"] = dates[0] + " - " + dates[1];
DateTime dateFrom = Convert.ToDateTime(dates[0]), dateTo = Convert.ToDateTime(dates[1]);
e.Criteria = (new OperandProperty("OrderDate") >= dateFrom) & (new OperandProperty("OrderDate") < dateTo);
}
}
protected void ASPxGridView1_ProcessColumnAutoFilter(object sender, DevExpress.Web.ASPxGridViewAutoFilterEventArgs e)
{
if (e.Column.FieldName != "OrderDate")
{
return;
}
if (e.Kind == DevExpress.Web.GridViewAutoFilterEventKind.CreateCriteria)
{
if (DateTime.TryParse(e.Value, CultureInfo.InvariantCulture, DateTimeStyles.None, out curDate))
{
BinaryOperator op1 = new BinaryOperator("OrderDate", curDate, BinaryOperatorType.GreaterOrEqual);
BinaryOperator op2 = new BinaryOperator("OrderDate", curDate.AddMinutes(1), BinaryOperatorType.Less);
GroupOperator grOp = new GroupOperator(GroupOperatorType.And, op1, op2);
e.Criteria = grOp;
displayText = curDate.ToString("dd-MMMM-yyyy hh:mm");
}
}
if (e.Kind == DevExpress.Web.GridViewAutoFilterEventKind.ExtractDisplayText)
{
e.Value = displayText;
}
}
protected void grvData_ProcessColumnAutoFilter(object sender, DevExpress.Web.ASPxGridViewAutoFilterEventArgs e)
{
Search();
}