C# (CSharp) CountQuery.Add示例

示例#1

文件： TransitImage.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (mExcludeBlogImages)
            {
                query.Add(Expression.Sql("NOT EXISTS ( SELECT * FROM PostImage e WHERE e.Image_Id = this_.Image_Id )"));
                query.Add(Expression.Sql("NOT EXISTS ( SELECT * FROM Highlight h WHERE h.Image_Id = this_.Image_Id )"));
            }

            base.Apply(query);
        }

示例#2

 public override void Apply(CountQuery query)
 {
     if (SourceId != 0)
     {
         query.Add(Expression.Eq("SourceId", SourceId));
     }
     if (!string.IsNullOrEmpty(SourceType))
     {
         query.Add(Expression.Eq("SourceType", SourceType));
     }
     base.Apply(query);
 }

示例#3

文件： TransitReferrerHost.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (DateStart != DateTime.MinValue)
            {
                query.Add(Expression.Ge("Created", DateStart));
            }

            base.Apply(query);
        }

示例#4

文件： TransitReference.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (!string.IsNullOrEmpty(SearchQuery))
            {
                query.Add(Expression.Like("Word", string.Format("%{0}%", SearchQuery)));
            }

            base.Apply(query);
        }

示例#5

        public override void Apply(CountQuery query)
        {
            if (Type != TransitFeedType.Unknown)
            {
                query.Add(Expression.Eq("Type", Type.ToString()));
            }

            base.Apply(query);
        }

示例#6

        public override void Apply(CountQuery query)
        {
            if (PostId != 0)
            {
                query.Add(Expression.Eq("Post.Id", PostId));
            }

            base.Apply(query);
        }

示例#7

文件： TransitFeedItem.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (FeedId != 0)
            {
                query.Add(Expression.Eq("Feed.Id", FeedId));
            }

            base.Apply(query);
        }

示例#8

        public override void Apply(CountQuery query)
        {
            if (AssociatedId != 0)
            {
                query.Add(Expression.Eq(string.Format("{0}.Id", Table), AssociatedId));
            }

            base.Apply(query);
        }

示例#9

文件： TransitPostImage.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (PostId != 0)
            {
                query.Add(Expression.Eq("Post.Id", PostId));
            }

            if (PreferredOnly)
            {
                throw new NotImplementedException();
            }

            base.Apply(query);
        }

示例#10

文件： TransitPost.cs 项目： belmirojr/dblog

        public override void Apply(CountQuery query)
        {
            if (TopicId != 0)
            {
                query.Add(Expression.Sql(string.Format("EXISTS ( SELECT * FROM PostTopic t WHERE t.Post_Id = this_.Post_Id AND t.Topic_Id = {0})",
                                                       TopicId)));
            }

            if (!string.IsNullOrEmpty(Query))
            {
                query.Add(Expression.Sql(string.Format("( FREETEXT (Title, '{0}') OR FREETEXT (Body, '{0}') )",
                                                       Renderer.SqlEncode(Query))));
            }

            if (DateStart != DateTime.MinValue)
            {
                query.Add(Expression.Ge("Created", DateStart));
            }

            if (DateEnd != DateTime.MaxValue)
            {
                query.Add(Expression.Le("Created", DateEnd));
            }

            if (PublishedOnly)
            {
                query.Add(Expression.Eq("Publish", true));
            }

            if (DisplayedOnly)
            {
                query.Add(Expression.Eq("Display", true));
            }

            base.Apply(query);
        }

示例#11

文件： TransitPostLogin.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (PostId != 0)
            {
                query.Add(Expression.Eq("Post.Id", PostId));
            }

            base.Apply(query);
        }

示例#12

文件： TransitAssociatedComment.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (AssociatedId != 0)
            {
                query.Add(Expression.Eq(string.Format("{0}.Id", Table), AssociatedId));
            }

            base.Apply(query);
        }

示例#13

文件： TransitFeedItem.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (FeedId != 0)
            {
                query.Add(Expression.Eq("Feed.Id", FeedId));
            }

            base.Apply(query);
        }

示例#14

文件： TransitPost.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (TopicId != 0)
            {
                query.Add(Expression.Sql(string.Format("EXISTS ( SELECT * FROM PostTopic t WHERE t.Post_Id = this_.Post_Id AND t.Topic_Id = {0})",
                    TopicId)));
            }

            if (! string.IsNullOrEmpty(Query))
            {
                query.Add(Expression.Sql(string.Format("( FREETEXT (Title, '{0}') OR FREETEXT (Body, '{0}') )",
                    Renderer.SqlEncode(Query))));
            }

            if (DateStart != DateTime.MinValue)
            {
                query.Add(Expression.Ge("Created", DateStart));
            }

            if (DateEnd != DateTime.MaxValue)
            {
                query.Add(Expression.Le("Created", DateEnd));
            }

            if (PublishedOnly)
            {
                query.Add(Expression.Eq("Publish", true));
            }

            if (DisplayedOnly)
            {
                query.Add(Expression.Eq("Display", true));
            }

            base.Apply(query);
        }

示例#15

文件： TransitReference.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (!string.IsNullOrEmpty(SearchQuery))
            {
                query.Add(Expression.Like("Word", string.Format("%{0}%", SearchQuery)));
            }

            base.Apply(query);
        }

示例#16

文件： TransitFeed.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (Type != TransitFeedType.Unknown)
            {
                query.Add(Expression.Eq("Type", Type.ToString()));
            }

            base.Apply(query);
        }

示例#17

文件： TransitPermalink.cs 项目： dblock/dblog

 public override void Apply(CountQuery query)
 {
     if (SourceId != 0) query.Add(Expression.Eq("SourceId", SourceId));
     if (!string.IsNullOrEmpty(SourceType)) query.Add(Expression.Eq("SourceType", SourceType));
     base.Apply(query);
 }

示例#18

文件： TransitPostImage.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (PostId != 0)
            {
                query.Add(Expression.Eq("Post.Id", PostId));
            }

            if (PreferredOnly)
            {
                throw new NotImplementedException();
            }

            base.Apply(query);
        }

示例#19

文件： TransitImage.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (mExcludeBlogImages)
            {
                query.Add(Expression.Sql("NOT EXISTS ( SELECT * FROM PostImage e WHERE e.Image_Id = this_.Image_Id )"));
                query.Add(Expression.Sql("NOT EXISTS ( SELECT * FROM Highlight h WHERE h.Image_Id = this_.Image_Id )"));
            }

            base.Apply(query);
        }

示例#20

文件： TransitReferrerHost.cs 项目： dblock/dblog

        public override void Apply(CountQuery query)
        {
            if (DateStart != DateTime.MinValue)
            {
                query.Add(Expression.Ge("Created", DateStart));
            }

            base.Apply(query);
        }