Esempio n. 1
0
        public List <Page> GetPages(Guid userId)
        {
            var q = PageQuery(EqExp.Eq("h.create_by", userId.ToString()) & Exp.Eq("h.version", 1))
                    .OrderBy("p.pagename", true);

            return(ExecQuery(q));
        }
Esempio n. 2
0
        public List <Page> GetPages(string category)
        {
            var q = PageQuery(EqExp.Eq("c.categoryname", category))
                    .InnerJoin("wiki_categories c", Exp.EqColumns("p.pagename", "c.pagename") & Exp.EqColumns("p.tenant", "c.tenant"))
                    .OrderBy("p.pagename", true);

            return(ExecQuery(q));
        }