public List<Uto_Microblog> GetMicroBlogIndex(int pageIndex = 1, int pageSize = 1000) { using (UtopiaEntities db = new UtopiaEntities()) { string sql = @"select top " + pageSize.ToString() + " * from uto_microblog where microblogId not in (select top ((" + pageIndex.ToString() + "-1)*" + pageSize.ToString() + ") microblogId from uto_microblog order by microblogId desc) order by microblogId desc"; List<Uto_Microblog> microblogs = db.ExecuteStoreQuery<Uto_Microblog>(sql).ToList(); return microblogs; } }
public List<Uto_Microblog> GetUserMicroBlog(long userId, int pageIndex = 1, int pageSize = 10) { using (UtopiaEntities db = new UtopiaEntities()) { string sql = @"select top " + pageSize.ToString() + " * from uto_microblog where microblogId not in (select top ((" + pageIndex.ToString() + "-1)*" + pageSize.ToString() + ") microblogId from uto_microblog where userid="+userId.ToString()+" order by microblogId desc) and userId=" + userId.ToString() + " order by microblogId desc"; List<Uto_Microblog> microblogs = db.ExecuteStoreQuery<Uto_Microblog>(sql).ToList(); //解析吐槽Body及吐槽repeatContent microblogs = AnalyzeBody(microblogs); return microblogs; } }
public List<Uto_Comment> GetCommentByBelongId(long belongId,string type,out long commentCount,bool all=false,int pageSize=10,int pageIndex=1) { using (UtopiaEntities db = new UtopiaEntities()) { List<Uto_Comment> comments = db.Uto_Comment.Where(n => n.BelongId == belongId && n.Type == type).OrderBy(n=>n.CommentId).ToList(); commentCount = comments.Count; if (!all) { comments = comments.Take(10).ToList(); } else { string sql = @"select top " + pageSize.ToString() + " * from uto_comment where commentId not in (select top ((" + pageIndex.ToString() + "-1)*" + pageSize.ToString() + ") commentId from uto_comment where belongid=" + belongId.ToString() + " and type='"+type+"' order by commentId desc) and belongid=" + belongId.ToString() + " and type='"+type+"' order by commentId desc"; comments = db.ExecuteStoreQuery<Uto_Comment>(sql).ToList(); } //解析评论Body for (int i = 0; i < comments.Count; i++) { comments.ElementAt(i).Body = Utility.AnalyzeBody(comments.ElementAt(i).Body); } return comments; } }