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