PropertyRule Class

Defines logic that evaluates to a scalar value for any row in an input table or view. This class cannot be inherited.

命名空間: Microsoft.SqlServer.NotificationServices.Rules
組件: Microsoft.SqlServer.NotificationServices.Rules (in microsoft.sqlserver.notificationservices.rules.dll)

語法

'宣告
Public Class PropertyRule
    Inherits RuleLogic

public class PropertyRule : RuleLogic

public ref class PropertyRule : public RuleLogic

public class PropertyRule extends RuleLogic

public class PropertyRule extends RuleLogic

備註

A property rule contains statements in the form "IF Condition THEN Result" where the result is a scalar value determined by evaluating the conditions in the rule.

You must define at least one PropertyStatement using the PropertyStatements property or the PropertyRule(InputType,PropertyStatement[]) constructor. If you define multiple statements, the result of evaluating this rule is the result of the first statement with a matching Condition criteria, or NULL if no criteria is met.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.NotificationServices.Rules.RuleObject
     Microsoft.SqlServer.NotificationServices.Rules.StoredRuleObject
       Microsoft.SqlServer.NotificationServices.Rules.RuleLogic
        Microsoft.SqlServer.NotificationServices.Rules.PropertyRule

範例

The following example shows how to define a property rule that defines three properties: Few, Some, and Alot. It uses this property rule to define a subscription to events where Quantity equals Few:

// 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();

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

PropertyRule Members
Microsoft.SqlServer.NotificationServices.Rules Namespace