C# ForumPost类代码示例

        public ActionResult Create(int subforumID, int userID, string threadTitle, string threadContent)
        {
            if (!SessionHandler.Logon)
                return RedirectToAction("Index", "Login");

            User user = db.Users.SingleOrDefault(i => i.id == SessionHandler.UID);

            if (user.is_banned)
                return View("Error", new ArgumentException("You cannot add new threads or posts while banned."));

            ForumThread ft = new ForumThread();
            ft.author_id = userID;
            ft.datetime_posted = DateTime.Now;
            ft.num_hits = 1;
            ft.title = SecurityHelper.StripHTML(threadTitle);
            ft.subforum_id = subforumID;

            db.ForumThreads.Add(ft);

            db.SaveChanges();

            ForumPost fp = new ForumPost();
            fp.author_id = userID;
            fp.datetime_posted = DateTime.Now;
            fp.thread_id = ft.id;
            fp.text = SecurityHelper.StripHTMLExceptAnchor(threadContent);

            db.ForumPosts.Add(fp);

            db.SaveChanges();

            return RedirectToAction("Index", "Posts", new { threadID = ft.id });
        }

        public ActionResult AddPost(int parentThread, string postContent)
        {
            //checks if the user has been authenticated
            if (!SessionHandler.Logon)
                return RedirectToAction("Index", "Login");

            //checks if the user is banned
            User user = _db.Users.SingleOrDefault(i => i.id == SessionHandler.UID);

            if (user.is_banned)
                return View("Error", new ArgumentException("You cannot add new threads or posts while banned."));

            //creates a new forum posts and adds it to the database
            ForumPost fp = new ForumPost();
            fp.thread_id = parentThread;
            fp.author_id = SessionHandler.UID;
            fp.text = SecurityHelper.StripHTMLExceptAnchor(postContent);
            fp.datetime_posted = DateTime.Now;

            _db.ForumPosts.Add(fp);

            _db.SaveChanges();

            return RedirectToAction("Index", new { threadID = parentThread });
        }

        private void addPost( object[] args, object target ) {

            OpenComment comment = args[0] as OpenComment;
            if (comment == null || comment.Id <= 0) return;

            // 只监控论坛评论，其他所有评论跳过
            if (comment.TargetDataType != typeof( ForumTopic ).FullName) return;

            // 附属信息
            ForumTopic topic = commentService.GetTarget( comment ) as ForumTopic;
            User creator = comment.Member;
            IMember owner = getOwner( topic );
            IApp app = ForumApp.findById( topic.AppId );

            // 内容
            ForumPost post = new ForumPost();

            post.ForumBoardId = topic.ForumBoard.Id;
            post.TopicId = topic.Id;
            post.ParentId = getParentId( comment, topic );
            post.Title = "re:" + topic.Title;
            post.Content = comment.Content;
            post.Ip = comment.Ip;


            // 保存
            // 因为comment本身已有通知，所以论坛不再发通知
            postService.InsertNoNotification( post, creator, owner, app );

            // 同步表
            CommentSync objSync = new CommentSync();
            objSync.Post = post;
            objSync.Comment = comment;
            objSync.insert();
        }

 public static String GetPostEdit( List<ForumBoard> boards, ForumPost post, MvcContext ctx )
 {
     StringBuilder sb = getBuilder( boards, ctx );
     sb.AppendFormat( "<span style=\"margin-left:5px;\">" + alang( ctx, "pPostEdit" ) + ": <a href=\"{0}\">{1}</a></span>", alink.ToAppData( post ), post.Title );
     sb.Append( "</div></div>" );
     return sb.ToString();
 }

 private Boolean boardError( ForumPost post ) {
     if (ctx.GetLong( "boardId" ) != post.ForumBoardId) {
         echoRedirect( lang( "exNoPermission" ) + ": borad id error" );
         return true;
     }
     return false;
 }

        public static List<ForumPost> GetPostIdsPages()
        {
            List<ForumPost> postInfoList = new List<ForumPost>();
            using (SqlConnection con = new SqlConnection(connectstring))
            {
                try
                {                    
                    con.Open();
                    SqlCommand cmd = con.CreateCommand();
                    cmd.CommandText = @"select distinct ThreadID,PageCount from [dbo].[FirstPostTemp] where PageCount>1";
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        ForumPost post = new ForumPost();
                        post.ThreadID = int.Parse(reader["ThreadID"].ToString());
                        post.PageCount = int.Parse(reader["PageCount"].ToString());
                        postInfoList.Add(post);
                    }

                }
                catch (SqlException e)
                {
                    throw e;
                }
                finally
                {
                    con.Close();
                    con.Dispose();
                }
                return postInfoList;
            }
        }

        private Boolean hasAdminPermission( ForumPost post )
        {
            ForumBoard board = boardService.GetById( post.ForumBoardId, ctx.owner.obj );

            IList adminCmds = PermissionUtil.GetTopicAdminCmds( (User)ctx.viewer.obj, board, ctx );

            return adminCmds.Count > 0;
        }

        private string getTopicLastPage( ForumPost post ) {
            String lnk = to( new wojilu.Web.Controller.Forum.TopicController().Show, post.TopicId );
            int pageNo = postService.GetPageCount( post.TopicId, getPageSize( ctx.app.obj ) );
            lnk = PageHelper.AppendNo( lnk, pageNo );

            lnk = lnk + "?rd=" + getRandomStr() + "#post" + post.Id;

            return lnk;
        }

        public string AddDiscussionAjax(int topicid = 0, string addtitle = "", string post = "", string name = "", string email = "", string company = "", bool notify = false, string recaptcha_challenge_field = "", string recaptcha_response_field = "")
        {
            CurtDevDataContext db = new CurtDevDataContext();
            JavaScriptSerializer js = new JavaScriptSerializer();
            #region trycatch
            try {
                string remoteip = (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null) ? Request.ServerVariables["HTTP_X_FORWARDED_FOR"] : Request.ServerVariables["REMOTE_ADDR"];
                if (!(Models.ReCaptcha.ValidateCaptcha(recaptcha_challenge_field, recaptcha_response_field, remoteip))) {
                    throw new Exception("The Captcha was incorrect. Try again please!");
                }
                if (topicid == 0) { throw new Exception("The topic was invalid."); }
                if (addtitle.Trim() == "") { throw new Exception("Title is required."); }
                if (post.Trim() == "") { throw new Exception("Post is required"); }
                if (email.Trim() != "" && (!IsValidEmail(email.Trim()))) { throw new Exception("Your email address was not a valid address."); }
                if (notify == true && email.Trim() == "") { throw new Exception("You cannot be notified by email without an email address."); }
                if(checkIPAddress(remoteip)) { throw new Exception("You cannot post because your IP Address is blocked by our server."); }

                bool moderation = Convert.ToBoolean(ConfigurationManager.AppSettings["ForumModeration"]);

                ForumThread t = new ForumThread {
                    topicID = topicid,
                    active = true,
                    closed = false,
                    createdDate = DateTime.Now,
                };

                db.ForumThreads.InsertOnSubmit(t);
                db.SubmitChanges();

                ForumPost p = new ForumPost {
                    threadID = t.threadID,
                    title = addtitle,
                    post = post,
                    name = name,
                    email = email,
                    notify = notify,
                    approved = !moderation,
                    company = company,
                    createdDate = DateTime.Now,
                    flag = false,
                    active = true,
                    IPAddress = remoteip,
                    parentID = 0,
                    sticky = false
                };

                db.ForumPosts.InsertOnSubmit(p);
                db.SubmitChanges();

                Post newpost = ForumModel.GetPost(p.postID);
                return js.Serialize(newpost);

            } catch (Exception e) {
                return "{\"error\": \"" + e.Message + "\"}";
            }
            #endregion
        }

    private string getPostHTML(ForumPost post)
    {
        String HTML = "<h1>" + post.topic.title + "</h1>";
        List<Comment> comments = post.comments;
        foreach (Comment c in comments)
        {
            HTML += getCommentHTML(c);
        }

        return HTML;
    }

        private static void updatePost( ForumPost post ) {

            if (post.OwnerType != typeof( Site ).FullName) return;

            IMember owner = Site.Instance;
            int appId = post.AppId;

            IndexViewCacher.Update( owner, appId );
            BoardViewCacher.Update( owner, appId, post.ForumBoardId, 1 );
            RecentViewCacher.Update( owner, appId, "Post" );
        }

        public void BanPost( ForumPost post )
        {
            // post 所在分页列表失效
            String turl = controller.to( new TopicController().Show, post.TopicId );
            int pageNumber = getPostPage( post.Id, post.TopicId, 10 ); // 所属主题详细页的分页页面失效
            if (pageNumber > 1) {
                turl = Link.AppendPage( turl, pageNumber );
            }
            removeCacheSingle( turl );

            String url = controller.to( new PostController().Show, post.Id );
            removeCacheSingle( url );
        }

        public ActionResult AddPost(int id = 0, string titlestr = "", string post = "", bool sticky = false)
        {
            string remoteip = (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null) ? Request.ServerVariables["HTTP_X_FORWARDED_FOR"] : Request.ServerVariables["REMOTE_ADDR"];
            try {
                if (id == 0) throw new Exception("Topic is required.");
                if (titlestr.Trim().Length == 0) throw new Exception("Title is required.");
                if (post.Trim().Length == 0) throw new Exception("Post content is required.");
                CurtDevDataContext db = new CurtDevDataContext();

                ForumThread t = new ForumThread {
                    topicID = id,
                    active = true,
                    closed = false,
                    createdDate = DateTime.Now
                };
                db.ForumThreads.InsertOnSubmit(t);
                db.SubmitChanges();
                user u = Users.GetUser(Convert.ToInt32(Session["userID"]));

                ForumPost p = new ForumPost {
                    threadID = t.threadID,
                    title = titlestr,
                    post = post,
                    IPAddress = remoteip,
                    createdDate = DateTime.Now,
                    approved = true,
                    active = true,
                    flag = false,
                    notify = false,
                    parentID = 0,
                    name = u.fname + " " + u.lname,
                    company = "CURT Manufacturing",
                    email = u.email,
                    sticky = sticky
                };
                db.ForumPosts.InsertOnSubmit(p);
                db.SubmitChanges();

                return RedirectToAction("threads", new { id = id });

            } catch (Exception e) {
                FullTopic topic = ForumModel.GetTopic(id);
                ViewBag.topic = topic;
                ViewBag.error = e.Message;
                ViewBag.titlestr = titlestr;
                ViewBag.post = post;
                ViewBag.sticky = sticky;
                return View();
            }
        }

        public int Create(string title, string content, int categoryId, string userId)
        {
            ForumPost newPost = new ForumPost()
            {
                Title = title,
                Content = content,
                CategoryId = categoryId,
                CreatedOn = DateTime.Now,
                UserId = userId,
            };

            this.forumRepository.Add(newPost);
            this.forumRepository.Save();

            return newPost.Id;
        }

        private void bindPostOne( IBlock block, ForumPost post )
        {
            String title = post.Title;

            if (strUtil.IsNullOrEmpty( title )) {

                ForumTopic topic = topicService.GetByPost( post.Id );
                if (topic == null) return;

                title = "re:" + topic.Title;
            }

            block.Set( "p.Titile", title );
            block.Set( "p.Url", Link.To( post.OwnerType, post.OwnerUrl, new PostController().Show, post.Id, post.AppId ) );

            block.Set( "p.CreateTime", post.Created );

            block.Next();
        }