Esempio n. 1
0
 public static List <Models.Forums> GetLastForums(int top, int skip = 0)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         return(db.SkipTake <Models.Forums>(skip, top, "where is_hidden=0  order by is_top desc,addtime DESC").ToList());
     }
 }
Esempio n. 2
0
 public static List <Models.Forums> GetLastForums(int top, int skip = 0)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         return(db.SkipTake <Models.Forums>(skip, top, "  ORDER BY addtime DESC").ToList());
     }
 }
Esempio n. 3
0
 public static List<Models.Forums> GetLastForums(int top, int skip = 0)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         return db.SkipTake<Models.Forums>(skip, top, "  ORDER BY addtime DESC").ToList();
     }
 }