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