static public List <CommentData> FindCommentDataByUserId(int user_id) { List <CommentData> cdList = new List <CommentData>(); string sql = "select weike.weike_id ,weike.title,weike.subject,weike.user_id as author_id,weike.src,weike.size,weike.description,weike.star,weike.postdate,weike.commentNum, comment.comment_id,comment.user_id as commenter_id,comment.date,comment.content,comment.parent,user1.name as author, user2.name,user2.avatar as commenter from weike inner join comment inner join user as user1 inner join user as user2 where comment.weike_id = weike.weike_id and user1.user_id = weike.user_id and user2.user_id = comment.user_id and comment.user_id = @userid order by comment.date desc;"; MySqlConnection conn = Connection.getMySqlCon(); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.AddWithValue("@userid", user_id); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Weike weike = new Weike((int)reader["weike_id"], (string)reader["title"], reader.GetString("subject"), (int)reader["author_id"], (string)reader["src"], (string)reader["size"], (string)reader["description"], (int)reader["star"], (DateTime)reader["postdate"], (int)reader["commentNum"]); Comment comment = new Comment((int)reader["comment_id"], (int)reader["commenter_id"], (int)reader["weike_id"], (DateTime)reader["date"], (string)reader["content"], (int)reader["parent"]); CommentData cd = new CommentData(weike, comment, (string)reader["author"], (string)reader["commenter"], (string)reader["avatar"]); cdList.Add(cd); } reader.Close(); conn.Close(); return(cdList); }
public NestedComment(CommentData commentData, List <NestedComment> nestedComments) { this.commentData = commentData; this.nestedComments = nestedComments; }