SimpleOperator Enumeration
Operators supported for SimpleLeafCondition.
Espace de noms: Microsoft.SqlServer.NotificationServices.Rules
Assembly: Microsoft.SqlServer.NotificationServices.Rules (in microsoft.sqlserver.notificationservices.rules.dll)
Syntaxe
'Déclaration
Public Enumeration SimpleOperator
public enum SimpleOperator
public enum class SimpleOperator
public enum SimpleOperator
public enum SimpleOperator
Members
Member name | Description |
---|---|
Equals | The SimpleLeafCondition evaluates to true if the arguments are equal. |
GreaterThan | The SimpleLeafCondition evaluates to true if the Left argument is greater than the Right argument. |
GreaterThanOrEqualTo | The SimpleLeafCondition evaluates to true if the Left argument is greater than or equal to the Right argument. |
LessThan | The SimpleLeafCondition evaluates to true if the Left argument is less than the Right argument. |
LessThanOrEqualTo | The SimpleLeafCondition evaluates to true if the Left argument is less than or equal to the Right argument. |
Like | The SimpleLeafCondition evaluates to true if the character string in the Left argument matches the pattern in the Right argument. For more information, see LIKE (Transact-SQL). |
NotEquals | The SimpleLeafCondition evaluates to true if the Left argument does not equal the Right argument. |
Exemple
The following example shows the use of the Equals and LessThanOrEqualTo operators:
// Create the NSInstance object.
NSInstance testInstance =
new NSInstance("InventoryTrackerInstance");
// Create the NSApplication object.
NSApplication testApplication =
new NSApplication(testInstance, "InventoryTracker");
// Create Subscription object.
Subscription s = new Subscription(testApplication,
"InventoryTrackerSubscriptions");
// Define subscription properties
s.SubscriberId = "TestUser1";
s.Enabled = true;
s.RuleName = "InventoryTrackerRule";
s["DeviceName"] = "Work e-mail";
s["SubscriberLocale"] = "en-US";
// Define OrCondition
s.Condition = new AndCondition(
new SimpleLeafCondition(new FieldValue("ProductName"),
SimpleOperator.Equals,
"Road-250 Black, 48"),
new SimpleLeafCondition(new FieldValue("LocationName"),
SimpleOperator.Equals,
"Final Assembly"),
new SimpleLeafCondition(new FieldValue("Quantity"),
SimpleOperator.LessThanOrEqualTo,
35)
);
// Add subscription
s.Add();
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.