Beispiel #1
0
 public ActionResult DelPost(int id)
 {
     DB db = new DB();
     Post posts = new Post();
     posts =
         (from p in db.Posts
         where p.ID == id
         select p).FirstOrDefault();
     db.Posts.Remove(posts);
     db.SaveChanges();
     return Redirect("/Admin/ManagePost");
 }
Beispiel #2
0
 public ActionResult ManagePost()
 {
     if (this.HttpContext.Session["User"] == null)
         return Redirect("/Admin/Login");
     else
     {
         DB db = new DB();
         List<Post> posts = new List<Post>();
         posts =
             (from p in db.Posts
              select p).ToList();
         int counts = posts.Count();
         ViewData["counts"] = counts;
         ViewBag.posts = posts;
         return View();
     }
 }
Beispiel #3
0
 public ActionResult Index()
 {
     DB db = new DB();
     List<Post> posts = new List<Post>();
     List<vPost> vposts = new List<vPost>();
     posts =
         (from p in db.Posts
          orderby p.ID descending
          select p).ToList();
     foreach (Post post in posts)
     {
         vPost vpost = new vPost(post);
         vposts.Add(vpost);
     }
     ViewBag.posts = vposts;
     return View();
 }
Beispiel #4
0
 public ActionResult Login(string username , string password)
 {
     DB db = new DB();
     User user = new User();
     //user =
     //    (from U in db.Users
     //     where username == U.Name && password == U.Password
     //     select U).FirstOrDefault();
     user = (db.Users.Where(u => u.Password == password && u.Name == username)).FirstOrDefault();
     if (user != null)
     {
         this.HttpContext.Session["User"] = username;
         return Redirect("/Admin/Home/Index");
     }
     else
     {
         return Redirect("/Admin/Error");
     }
 }
Beispiel #5
0
        public ActionResult Index(int page)
        {
            DB db = new DB();
            int index = page * 10;
            List<Post> posts = new List<Post>();
            List<vPost> vposts = new List<vPost>();
            posts =
                (from p in db.Posts
                 orderby p.ID descending
                 select p).Skip(index).Take(10).ToList();
            foreach (Post item in posts)
            {
                vposts.Add(new vPost(item));
            }
            AjaxModel ajaxModel = new AjaxModel();
            try
            {
                if (vposts.Count() == 0)
                {
                    ajaxModel.Data = "";
                    ajaxModel.Statu = "end";
                    ajaxModel.Msg = "没有更多了";
                }
                else
                {
                    ajaxModel.Data = vposts;
                    ajaxModel.Statu = "OK";
                    ajaxModel.Msg = "加载成功";
                }
            }
            catch
            {
                ajaxModel.Statu = "err";
                ajaxModel.Msg = "获取失败";

            }
            return Json(ajaxModel);
        }
Beispiel #6
0
 public ActionResult Message()
 {
     DB db = new DB();
     List<Message> messages = new List<Message>();
     messages =
         (from m in db.messages
         select m).ToList();
     ViewBag.messages = messages;
     return View();
 }
Beispiel #7
0
 public ActionResult RevPost(int id)
 {
     DB db = new DB();
         Post posts = new Post();
         posts =
             (from p in db.Posts
              where p.ID == id
              select p).FirstOrDefault();
         return Redirect("/Admin/ManagePost");
 }
Beispiel #8
0
 public ActionResult Register(string username , string password , string rpassword)
 {
     DB db = new DB();
     User user = new User();
     user.Name = username;
     user.Password = password;
     db.Users.Add(user);
     int row = db.SaveChanges();
     if (row > 0)
     {
         return Redirect("/Admin/Login");
     }
     else
     {
         return Redirect("/Admin/Error");
     }
 }
Beispiel #9
0
 public ActionResult PublicPosts(string title, string content, string classify)
 {
     DB db = new DB();
         Post posts = new Post();
         posts.Title = title;
         posts.Content = content;
         posts.Classify = classify;
         posts.DateOfIssue = DateTime.Now;
         posts.Author = "尹逸朋";
         db.Posts.Add(posts);
         int row = db.SaveChanges();
         if (row > 0)
         {
             return Redirect("/Admin/Home/PublicPosts");
         }
         else
         {
             return Redirect("/Admin/Error");
         }
 }
Beispiel #10
0
        public ActionResult PostMore(int id)
        {
            DB db = new DB();
            List<Post> posts = new List<Post>();
            List<vPost> vposts = new List<vPost>();
            posts =
                (from p in db.Posts
                 select p).ToList();
            foreach (Post post in posts)
            {
                vPost vpost = new vPost(post);
                vposts.Add(vpost);
            }
            ViewBag.posts = vposts;

            List<Post> postList = new List<Post>();
            postList =
                (from l in db.Posts
                 orderby l.Browse descending
                 select l).ToList();
            ViewBag.postList = postList;

            Post post2 = new Post();
            post2 =
                 (from p in db.Posts
                  where p.ID == id
                  select p).FirstOrDefault();
            post2.Browse++;
            db.SaveChanges();
            ViewData["id"] = post2.ID;
            ViewData["title"] = post2.Title;
            ViewData["content"] = post2.Content;

            List<PostReply> postreply = new List<PostReply>();
            postreply =
                (from p in db.PostReply
                 where p.PostID == id
                 select p).ToList();
            ViewBag.postreply = postreply;
            return View();
        }
Beispiel #11
0
        //慢生活
        public ActionResult Slive()
        {
            DB db = new DB();
            List<Post> posts = new List<Post>();
            List<vPost> vPosts = new List<vPost>();
            posts =
                (from p in db.Posts
                 orderby p.ID descending
                 select p).ToList();

            foreach (Post post in posts)
            {
                vPost vpost = new vPost(post);
                vPosts.Add(vpost);
            }
            ViewBag.posts = vPosts;

            List<Post> postList = new List<Post>();
            postList =
                (from l in db.Posts
                 orderby l.Browse descending
                 select l).ToList();
            ViewBag.postList = postList;

            return View();
        }
Beispiel #12
0
        public ActionResult PostMore_reply(int id, string content)
        {
            DB db = new DB();
            PostReply postreply = new PostReply();
            postreply.PostID = id;
            postreply.ReplyContent = content;
            postreply.DateOfIssue = DateTime.Now;

            db.PostReply.Add(postreply);
            int row = db.SaveChanges();
            if (row > 0)
            {
                return Redirect("/Home/Index");
            }
            else
            {
                return Redirect("/Home/Error");
            }
        }