通过

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