Example #1
0
 public static bool AddForum(Models.Forums form)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         return(db.Insert(form) != null);
     }
 }
Example #2
0
        public ActionResult Add(string title, int cid, string content)
        {
            ViewData["Title"] = "创建";
            ViewBag.Category  = DataProvider.ForumDataProvider.GetAllCategory();
            ViewBag.NodeId    = cid;
            if (ModelState.IsValid)
            {
                Models.User        user  = Session["User"] as Models.User;
                XBBS.Models.Forums forum = new Models.Forums();
                forum.AddTime    = DateTime.Now;
                forum.Cid        = cid;
                forum.Uid        = user.Uid;
                forum.Content    = content;
                forum.Title      = title;
                forum.Comments   = 0;
                forum.Views      = 0;
                forum.UpdateTime = DateTime.Now;
                bool b = DataProvider.ForumDataProvider.AddForum(forum);
                if (b)
                {
                    return(Redirect("/"));
                }
            }

            return(View());
        }
Example #3
0
 public static int AddForum(Models.Forums form)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         int id = Convert.ToInt32(db.Insert(form));
         return(id);
     }
 }
Example #4
0
 public static bool UpdateForum(Models.Forums forum)
 {
     using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
     {
         forum.UpdateTime = DateTime.Now;
         db.Save(forum);
         return(true);
     }
 }
Example #5
0
        public ActionResult Add(string title, int cid, string content)
        {
            ViewData["Title"] = "创建";
            ViewBag.Category  = DataProvider.ForumDataProvider.GetAllCategory();
            ViewBag.NodeId    = cid;
            if (ModelState.IsValid)
            {
                Models.User        user  = Session["User"] as Models.User;
                XBBS.Models.Forums forum = new Models.Forums();
                forum.AddTime    = DateTime.Now;
                forum.Cid        = cid;
                forum.Uid        = user.Uid;
                forum.Content    = content;
                forum.Title      = title;
                forum.Comments   = 0;
                forum.Views      = 0;
                forum.UpdateTime = DateTime.Now;
                int b = DataProvider.ForumDataProvider.AddForum(forum);
                if (b > 0)
                {
                    DataProvider.ForumDataProvider.DeleteTarg(b);
                    string[] strsKey = null;
                    if (string.IsNullOrEmpty(Request.Form["keywords"]))
                    {
                        List <string> list = new List <string>();
                        foreach (var item in XBBS.DataProvider.CommonDataProvider.GetAllTag())
                        {
                            if (forum.Content.IndexOf(item) >= 0)
                            {
                                list.Add(item);
                            }
                        }
                        strsKey = list.ToArray();
                    }
                    else
                    {
                        strsKey = Request.Form["keywords"].Split(',', ' ');
                    }
                    foreach (var item in strsKey)
                    {
                        DataProvider.ForumDataProvider.AddTarg(item.Trim(), b);
                    }
                    return(Redirect("/"));
                }
            }

            return(View());
        }
Example #6
0
        public ActionResult Add(string title, int cid, string content)
        {
            ViewData["Title"] = "创建";
            ViewBag.Category = DataProvider.ForumDataProvider.GetAllCategory();
            ViewBag.NodeId = cid;
            if (ModelState.IsValid)
            {
                Models.User user = Session["User"] as Models.User;
                XBBS.Models.Forums forum = new Models.Forums();
                forum.AddTime = DateTime.Now;
                forum.Cid = cid;
                forum.Uid = user.Uid;
                forum.Content = content;
                forum.Title = title;
                forum.Comments = 0;
                forum.Views = 0;
                forum.UpdateTime = DateTime.Now;
                int b = DataProvider.ForumDataProvider.AddForum(forum);
                if (b > 0)
                {
                    DataProvider.ForumDataProvider.DeleteTarg(b);
                    string[] strsKey = null;
                    if (string.IsNullOrEmpty(Request.Form["keywords"]))
                    {
                        List<string> list = new List<string>();
                        foreach (var item in XBBS.DataProvider.CommonDataProvider.GetAllTag())
                        {
                            if (forum.Content.IndexOf(item) >= 0)
                            {
                                list.Add(item);
                            }
                        }
                        strsKey = list.ToArray();
                    }
                    else
                    {
                        strsKey = Request.Form["keywords"].Split(',', ' ');
                    }
                    foreach (var item in strsKey)
                    {
                        DataProvider.ForumDataProvider.AddTarg(item.Trim(), b);
                    }
                    return Redirect("/");
                }
            }

            return View();
        }