/// <summary> /// 分页查询 /// </summary> /// <param name="pageSize">每页数据</param> /// <param name="pageIndex">页码</param> /// <returns>返回集合</returns> public static List<Comments_M> CommentsListPager(string pageSize, string pageIndex) { List<Comments_M> list = new List<Comments_M>(); string sql = string.Format("select top ({0}) *from Comments where CommentId not in(select top (({1}-1)*{0}) CommentId from Comments order by CommentId)order by CommentId",pageSize,pageIndex); SqlDataReader dr = SQLDBHelper.ExecuteReader(sql); if (dr.HasRows) { while (dr.Read()) { Comments_M comment = new Comments_M(); if (dr["CommentId"] != DBNull.Value) { comment.CommentId = Convert.ToInt32(dr["CommentId"]); } if (dr["PostId"] != DBNull.Value) { comment.PostId = Convert.ToInt32(dr["PostId"]); } if (dr["UserId"] != DBNull.Value) { comment.UserId = Convert.ToInt32(dr["UserId"]); } if (dr["Commentsmeta"] != DBNull.Value) { comment.Commentsmeta = Convert.ToString(dr["Commentsmeta"]); } if (dr["CommentsTime"] != DBNull.Value) { comment.CommentsTime = Convert.ToDateTime(dr["CommentsTime"]); } list.Add(comment); } } dr.Close(); return list; }
/// <summary> /// 查询所有评论 /// </summary> /// <returns>返回集合</returns> public static List<Comments_M> CommentsList() { List<Comments_M> list = new List<Comments_M>(); string sql = "select * from Comments"; SqlDataReader dr = SQLDBHelper.ExecuteReader(sql); if (dr.HasRows) { while (dr.Read()) { Comments_M comment = new Comments_M(); if (dr["CommentId"] != DBNull.Value) { comment.CommentId = Convert.ToInt32(dr["CommentId"]); } if (dr["PostId"] != DBNull.Value) { comment.PostId = Convert.ToInt32(dr["PostId"]); } if (dr["UserId"] != DBNull.Value) { comment.UserId = Convert.ToInt32(dr["UserId"]); } if (dr["Commentsmeta"] != DBNull.Value) { comment.Commentsmeta = Convert.ToString(dr["Commentsmeta"]); } if (dr["CommentsTime"] != DBNull.Value) { comment.CommentsTime = Convert.ToDateTime(dr["CommentsTime"]); } list.Add(comment); } } dr.Close(); return list; }