示例#1
0
        public static List<Post> GetPostsByThreadId(int thread_id)
        {
            DataTable table = ForumDB.QuerySproc("GetPostsByThreadId", new SqlParameter("thread_id", thread_id));
            List<Post> results = new List<Post>();
            for (int i = 0; i < table.Rows.Count; i++)
            {
                Post result = new Post
                {

                    post_id = table.Rows[i].ToInt32("post_id"),
                    thread_id = table.Rows[i].ToInt32("thread_id"),
                    subject = table.Rows[i].ToString("subject"),
                    content = table.Rows[i].ToString("content"),
                    post_date = table.Rows[i].ToDateTime("post_date"),
                    reply_to = table.Rows[i].ToNullableInt32("reply_to"),
                    user = new User
                    {
                        UserId = table.Rows[i].ToInt32("user_id"),
                        Username = table.Rows[i].ToString("username")
                    }

                };
                results.Add(result);
            }
            return results;
        }
示例#2
0
 public void AddPost(Post post)
 {
     int post_id = (int)ForumDB.ExecuteScalar("ReplyToPost", new SqlParameter("thread_id", this.thread_id), new SqlParameter("user_id", post.user.UserId), new SqlParameter("content", post.content), new SqlParameter("reply_to", post.reply_to));
     post.post_id = post_id;
 }