RecroGridRGFilterAdd(RecroGridRGFilterLogicalOperatorEnum, Int32, String, RecroGridRGFilterSQLOperatorEnum, Object) Method
Adds the specified condition.
Namespace: Recrovit.RecroGridFrameworkAssembly: Recrovit.RecroGrid (in Recrovit.RecroGrid.dll) Version: 6.1.0.23.1204.1+9d8b98a22c49d038b4e3323bfe56aa1d0eabe7ae
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.
//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);