当前位置: 首页>>代码示例>>C#>>正文


C# Criteria.AddOr方法代码示例

本文整理汇总了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);
        }
开发者ID:priceLiu,项目名称:CMS,代码行数:53,代码来源:PagedArticleList.Default.cs

示例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"});
        }
开发者ID:priceLiu,项目名称:CMS,代码行数:51,代码来源:NewsTab.Speeches.cs


注:本文中的Criteria.AddOr方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。