PropertyStatement Constructor (Condition, Argument)

Initializes a new instance of the PropertyStatement class with a condition and a scalar result.

네임스페이스: Microsoft.SqlServer.NotificationServices.Rules
어셈블리: Microsoft.SqlServer.NotificationServices.Rules (in microsoft.sqlserver.notificationservices.rules.dll)

구문

‘선언
Public Sub New ( _
    condition As Condition, _
    result As Argument _
)

public PropertyStatement (
    Condition condition,
    Argument result
)

public:
PropertyStatement (
    Condition^ condition, 
    Argument^ result
)

public PropertyStatement (
    Condition condition, 
    Argument result
)

public function PropertyStatement (
    condition : Condition, 
    result : Argument
)

매개 변수

condition
The Condition object that represents the condition to evaluate. This parameter sets the Condition property.

result
The Argument object that represents the scalar result to return if the condition is met. This parameter sets Result property.

주의

You can define a NULL result by setting the result parameter to new ConstantValue(null).

예

The following example shows how to specify three properties: Few, Some, and Alot. Subscribers can use these properties when defining subscriptions.

// Define a new property that defines "Few," "Some," and "Alot"
// of inventory. 
PropertyRule quantityCategory = new PropertyRule(
    new ViewInputType(eventView),
    new PropertyStatement(new SimpleLeafCondition(
        new FieldValue("Quantity"),
        SimpleOperator.LessThan, 100), "Few"),
    new PropertyStatement(new BetweenLeafCondition(
        new FieldValue("Quantity"), 100, 200), "Some"),
    new PropertyStatement(new SimpleLeafCondition(
            new FieldValue("Quantity"),
            SimpleOperator.GreaterThan, 200),
        "Alot"));

// Create subscription and define basic properties.
s = new Subscription(nsApplication, subscriptionClassName);
s.SubscriberId = "Scott";
s.Enabled = true;
s.RuleName = "InventoryTrackerRule";
s.SetFieldValue("DeviceName", "myDevice");
s.SetFieldValue("SubscriberLocale", "en-us");


// Use the new property to return only products with "few" remaining
// in inventory. Note that the category definition can be reused.
s.Condition = new SimpleLeafCondition(
    new RuleValue(quantityCategory),
    SimpleOperator.Equals,
    "Few");

// Add subscription.
s.Add();

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

PropertyStatement Class
PropertyStatement Members
Microsoft.SqlServer.NotificationServices.Rules Namespace

Last updated on 2008-12-15