示例#1
0
        public void  Delete(int articleID)
        {
            Member            member = Session[CDictionary.SK_Logined_Member] as Member;
            List <string>     author = authority.Authorityjudgment(member);
            TicketSysEntities db     = new TicketSysEntities();

            //是一般會員且是作者,就可以編輯
            Article article = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault();

            if (author.Contains("管理員"))
            {
                var q     = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault();
                var reply = db.Reply.Where(n => n.ArticleID == articleID);
                foreach (var item in reply)
                {
                    var qq = db.Reply_Emotion.Where(n => n.ReplyId == item.ReplyID);
                    foreach (var items in qq)
                    {
                        db.Reply_Emotion.Remove(items);
                    }
                }

                foreach (var item in reply)
                {
                    db.Reply.Remove(item);
                }
                db.Article.Remove(q);
                db.SaveChanges();
                Response.Write("<script>" +
                               "alert('刪除成功!即將跳轉至討論版首頁');" +
                               "window.location.href='http://localhost:49949/Forum/forum_mainblock';" +
                               "</script> ");
            }
            else if (author.Contains("一般會員"))
            {
                if (article.MemberID == member.MemberID)
                {
                    var q     = db.Article.Where(n => n.ArticleID == articleID).FirstOrDefault();
                    var reply = db.Reply.Where(n => n.ArticleID == articleID);
                    foreach (var item in reply)
                    {
                        db.Reply.Remove(item);
                    }
                    db.Article.Remove(q);
                    db.SaveChanges();
                    Response.Write("<script>" +
                                   "alert('刪除成功!即將跳轉至討論版首頁');" +
                                   "window.location.href='http://localhost:49949/Forum/forum_mainblock';" +
                                   "</script> ");
                }
                else
                {
                    Response.Write("<script>alert('您非該文章作者,禁止刪除!即將跳轉至討論版首頁');" +
                                   "window.location.href='http://localhost:49949/Forum/forum_mainblock';</script> ");
                }
            }
            else
            {
                Response.Write("<script>alert('您尚未登入!即將跳轉至登入頁面');" +
                               "window.location.href='http://localhost:49949/Login/Login';</script> ");
            }
        }