public static bool AddForum(Models.Forums form) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { return(db.Insert(form) != null); } }
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()); }
public static int AddForum(Models.Forums form) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { int id = Convert.ToInt32(db.Insert(form)); return(id); } }
public static bool UpdateForum(Models.Forums forum) { using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection")) { forum.UpdateTime = DateTime.Now; db.Save(forum); return(true); } }
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()); }
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(); }