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)); }
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)); }