RecroGridRGFilterAdd(RecroGridRGFilterLogicalOperatorEnum, Int32, String, RecroGridRGFilterSQLOperatorEnum, Object) Method

Adds the specified condition.

Definition

Namespace: Recrovit.RecroGridFramework
Assembly: Recrovit.RecroGrid (in Recrovit.RecroGrid.dll) Version: 6.1.0.23.1204.1+9d8b98a22c49d038b4e3323bfe56aa1d0eabe7ae
C#
public void Add(
	RecroGridRGFilterLogicalOperatorEnum logicalOperator,
	int id,
	string colName,
	RecroGridRGFilterSQLOperatorEnum sqlOperator,
	params Object[] paramsArray
)

Parameters

logicalOperator  RecroGridRGFilterLogicalOperatorEnum
The logical operator.
id  Int32
The identifier.
colName  String
Name of the column.
sqlOperator  RecroGridRGFilterSQLOperatorEnum
The SQL operator.
paramsArray  Object
The parameter values to use for the filter.

Example

C#
//Only the data of the current user
FixFilter.Add(this, RGFilter.LogicalOperatorEnum.And, "UserId", RGFilter.SQLOperatorEnum.Equal, RecroSec.GetCurrentUserId(rgContext.HttpContext));

//A separate filter object for a parenthesized condition
RGFilter user1 = new RGFilter();
user1.Add(this, RGFilter.LogicalOperatorEnum.Or, "FromUserId", RGFilter.SQLOperatorEnum.Equal, RecroSec.GetCurrentUserId(rgContext.HttpContext));
user1.AddAliasCol(this, RGFilter.LogicalOperatorEnum.Or, "ToUserID", RGFilter.SQLOperatorEnum.Equal, RecroSec.GetCurrentUserId(rgContext.HttpContext));
FixFilter.Add(RGFilter.LogicalOperatorEnum.And, user1);

See Also