復制代碼 代碼如下:

[Serializable]
public enum CustomerStatus
{
New = 0,
Active = 1,
Overdue = 2,
Suspended = 3,
Closing = 4,
Closed = 5
}

復制代碼 代碼如下:

public enum CustomerStatus
{
New = 1,
Active = 1<<1,
Overdue = 1<<2,
Suspended = 1<<3,
Closing = 1<<4,
Closed = 1<<5
}

復制代碼 代碼如下:

Select *
From Customer
Where [Status] & @Status = [Status]

復制代碼 代碼如下:

Select *
From Customer
Where ( @Status is null Or [Status] & @Status = [Status])