Esempio n. 1
0
 public IEnumerable <Post> getMentions(Diapasone diapasone, bool isAscending)
 {
     return(Post.LoadByIds(
                from stringId in Config.instance.mainConnection.LoadIdsByConditions(
                    Mention.TableSpec.instance,
                    new ComparisonCondition(
                        Mention.TableSpec.instance.getColumnSpec(Mention.TableSpec.FIELD_MENTIONEDUSERID),
                        ComparisonType.EQUAL,
                        this.id.ToString()
                        ),
                    diapasone,
                    Mention.TableSpec.instance.getColumnSpec(Mention.TableSpec.FIELD_POSTID),
                    new SortSpec(Mention.TableSpec.instance.getIdSpec(), isAscending)
                    ) select int.Parse(stringId)
                ));
 }
Esempio n. 2
0
 public IEnumerable <Post> getPosts(Diapasone diapasone, bool isAscending)
 {
     diapasone.total = this.totalPosts;
     return(Post.LoadByIds(
                from stringId in Config.instance.mainConnection.LoadIdsByConditions(
                    Post.TableSpec.instance,
                    new ComparisonCondition(
                        Post.TableSpec.instance.getColumnSpec(Post.TableSpec.FIELD_THREADID),
                        ComparisonType.EQUAL,
                        this.id.ToString()
                        ),
                    diapasone,
                    new JoinSpec[0],
                    new SortSpec[] {
         new SortSpec(
             Post.TableSpec.instance.getIdSpec(),
             isAscending
             ),
     }
                    ) select int.Parse(stringId)
                ));
 }