本文整理汇总了C#中Criteria.AddOr方法的典型用法代码示例。如果您正苦于以下问题:C# Criteria.AddOr方法的具体用法?C# Criteria.AddOr怎么用?C# Criteria.AddOr使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Criteria
的用法示例。
在下文中一共展示了Criteria.AddOr方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: InitCriteria
private void InitCriteria()
{
criteria = new Criteria(CriteriaType.None);
if (string.IsNullOrEmpty(KeyWord))
{
if (IncludeChildren && Channel != null)
{
criteria.Add(CriteriaType.Like, "ChannelFullUrl", Channel.FullUrl + "%");
}
else
{
criteria.Add(CriteriaType.Equals, "OwnerID", Channel.ID);
}
}
string tag = We7Helper.RemoveHtml(System.Web.HttpUtility.UrlDecode(Request["tag"]));
if (!String.IsNullOrEmpty(tag))
{
criteria.Add(CriteriaType.Like, "Tags", "%" + HttpUtility.UrlDecode(tag) + "%");
}
string title = We7Helper.RemoveHtml(System.Web.HttpUtility.UrlDecode(Request["title"]));
if (!String.IsNullOrEmpty(title))
{
criteria.Add(CriteriaType.Like, "Title", "%" + title + "%");
}
string channel = We7Helper.RemoveHtml(System.Web.HttpUtility.UrlDecode(Request["channel"]));
if (!String.IsNullOrEmpty(channel))
{
Channel ch = HelperFactory.Instance.GetHelper<ChannelHelper>().GetChannel(channel, null);
if (ch != null)
{
criteria.Add(CriteriaType.Like, "ChannelFullUrl", ch.FullUrl + "%");
}
}
string author = We7Helper.RemoveHtml(System.Web.HttpUtility.UrlDecode(Request["author"]));
if (!String.IsNullOrEmpty(author))
{
criteria.Add(CriteriaType.Equals, "Author", author);
}
if (!string.IsNullOrEmpty(KeyWord))
{
Criteria keyCriteria = new Criteria(CriteriaType.None);
keyCriteria.Mode = CriteriaMode.Or;
keyCriteria.AddOr(CriteriaType.Like, "Title", "%" + KeyWord + "%");
keyCriteria.AddOr(CriteriaType.Like, "Description", "%" + KeyWord + "%");
criteria.Criterias.Add(keyCriteria);
}
criteria.Add(CriteriaType.Equals, "State", 1);
}
示例2: QueryArticlesByChannels
/// <summary>
/// 根据栏目获取文章
/// </summary>
protected List<Article> QueryArticlesByChannels()
{
#region 将非空的栏目ID添加到 ListOwnerID
List<string> ListOwnerID = new List<string>(); ;
if (!string.IsNullOrEmpty(OwnerID1))
ListOwnerID.Add(OwnerID1);
if (!string.IsNullOrEmpty(OwnerID2))
ListOwnerID.Add(OwnerID2);
if (!string.IsNullOrEmpty(OwnerID3))
ListOwnerID.Add(OwnerID3);
if (!string.IsNullOrEmpty(OwnerID4))
ListOwnerID.Add(OwnerID4);
if (!string.IsNullOrEmpty(OwnerID5))
ListOwnerID.Add(OwnerID5);
if (!string.IsNullOrEmpty(OwnerID6))
ListOwnerID.Add(OwnerID6);
if (!string.IsNullOrEmpty(OwnerID7))
ListOwnerID.Add(OwnerID7);
if (!string.IsNullOrEmpty(OwnerID8))
ListOwnerID.Add(OwnerID8);
if (!string.IsNullOrEmpty(OwnerID9))
ListOwnerID.Add(OwnerID9);
if (!string.IsNullOrEmpty(OwnerID10))
ListOwnerID.Add(OwnerID10);
#endregion
Criteria c = new Criteria(CriteriaType.None);
//c.Add(CriteriaType.Like, "ChannelFullUrl", ch.FullUrl + "%");
c.Add(CriteriaType.Equals, "State", 1);
if (!String.IsNullOrEmpty(Tags))
{
c.Add(CriteriaType.Like, "Tags", "%'" + Tags + "'%");
}
if (ListOwnerID.Count > 0)
{
Criteria cOr = new Criteria(CriteriaType.None);
cOr.Mode = CriteriaMode.Or;
foreach (string chID in ListOwnerID)
{
cOr.AddOr(CriteriaType.Equals, "OwnerID", chID);
}
c.Criterias.Add(cOr);
}
Order[] os = IsShow ? new Order[] { new Order("IsShow", OrderMode.Desc), new Order("Updated", OrderMode.Desc), new Order("ID", OrderMode.Desc) } : new Order[] { new Order("Updated", OrderMode.Desc), new Order("ID", OrderMode.Desc) };
return Assistant.List<Article>(c, os, 0, PageSize,
new string[] {"ID", "Title", "ChannelFullUrl", "Created", "SN"});
}