FormulaCondition コンストラクタ(IFormulaProvider,String)

新規 FormulaCondition オブジェクトを作成します。

シンタックス

Visual Basic

'宣言
 
Public Function New( _
   ByVal provider As Infragistics.Win.CalcEngine.IFormulaProvider, _
   ByVal formula As String _
)

C#

public FormulaCondition( 
   Infragistics.Win.CalcEngine.IFormulaProvider provider,
   string formula
)

パラメータ

provider

数式をコンパイルする Infragistics.Win.CalcEngine.IFormulaProvider オブジェクトへの参照

formula

比較を実行するために使用するフォーミュラ。

使用例

Visual Basic

Imports Infragistics.Win
Imports Infragistics.Win.CalcEngine

Private  Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
	' Create a new ConditionValueAppearance
	Dim conditionValueAppearance As ConditionValueAppearance =  New ConditionValueAppearance() 
 
	' Create a ConditionGroup
	Dim conditionGroup As ConditionGroup =  New ConditionGroup() 
 
	' Create a OperatorCondition that checks for numbers that are greater than or 
	' equal to -2. 
	Dim operatorCondition As OperatorCondition =  New OperatorCondition(ConditionOperator.GreaterThanOrEqualTo,-2) 
 
	' Create a FormulaCondition that checks for numbers that are less than or 
	' equal to 2.  The column passed into the constructor is the column that the FormulaCondition
	' will be a part of, and acts as the IFormulaProvider
	Dim formulaProvider As IFormulaProvider =  Me.ultraGrid1.DisplayLay.Bands(0).Columns(0) 
	Dim formulaCondition As FormulaCondition =  New FormulaCondition(formulaProvider,"[ConditionValue] <= 2") 
 
	' Add the two conditions to the conditionGroup
	conditionGroup.Add(operatorCondition)
	conditionGroup.Add(formulaCondition)
 
	' We only want the color to apply to cells that meet both conditions. So we
	' will set the Logical Operator to 'And'.
	conditionGroup.CombineOperator = LogicalOperator.And
 
	' Create an appearance that sets the ForeColor to green.
	Dim greenAppearance As Infragistics.Win.Appearance =  New Infragistics.Win.Appearance("Between -2 and +2") 
	greenAppearance.BackColor = Color.Green
	greenAppearance.ForeColor = Color.White
 
	' Now that we have the condition and appearance we need, add them to the 
	' conditionValueAppearance. 
	conditionValueAppearance.Add(conditionGroup, greenAppearance)
 
	' Finally, assign the ConditionValueAppearance to the column
	Me.ultraGrid1.DisplayLay.Bands(0).Columns(0).ValueBasedAppearance = conditionValueAppearance
End Sub

C#

using Infragistics.Win;
using Infragistics.Win.CalcEngine;


private void button1_Click(object sender, EventArgs e)
{
	// Create a new ConditionValueAppearance
	ConditionValueAppearance conditionValueAppearance = new ConditionValueAppearance();

	// Create a ConditionGroup
	ConditionGroup conditionGroup = new ConditionGroup();

	// Create a OperatorCondition that checks for numbers that are greater than or 
	// equal to -2. 
	OperatorCondition operatorCondition = new OperatorCondition(ConditionOperator.GreaterThanOrEqualTo, -2);

	// Create a FormulaCondition that checks for numbers that are less than or 
	// equal to 2.  The column passed into the constructor is the column that the FormulaCondition
	// will be a part of, and acts as the IFormulaProvider
	IFormulaProvider formulaProvider = this.ultraGrid1.DisplayLayout.Bands[0].Columns[0];
	FormulaCondition formulaCondition = new FormulaCondition(formulaProvider, "[ConditionValue] <= 2");
            
	// Add the two conditions to the conditionGroup
	conditionGroup.Add(operatorCondition);
	conditionGroup.Add(formulaCondition);

	// We only want the color to apply to cells that meet both conditions. So we
	// will set the Logical Operator to 'And'.
	conditionGroup.CombineOperator = LogicalOperator.And;

	// Create an appearance that sets the ForeColor to green.
	Infragistics.Win.Appearance greenAppearance = new Infragistics.Win.Appearance("Between -2 and +2");
	greenAppearance.BackColor = Color.Green;
	greenAppearance.ForeColor = Color.White;

	// Now that we have the condition and appearance we need, add them to the 
	// conditionValueAppearance. 
	conditionValueAppearance.Add(conditionGroup, greenAppearance);

	// Finally, assign the ConditionValueAppearance to the column
	this.ultraGrid1.DisplayLayout.Bands[0].Columns[0].ValueBasedAppearance = conditionValueAppearance;
}