public ActionResult AddArticle(ViewAddArticleModel model)
{
var course = bamnContext.Set <Course>().Where(m => m.ID == model.CourseID).Include("Catalog").FirstOrDefault();
if (course == null)
{
return(Content("路径不对"));
}
ViewBag.Course = course;
if (ModelState.IsValid)
{
var info = new Article();
info.Title = model.Title;
//算法计算
info.Sort = model.LastSort + 1;
info.AddTime = DateTime.Now;
info.UpdateTime = DateTime.Now;
info.Status = 1;
info.CourseID = model.CourseID;
info.Content = model.Content;
info.Identity = model.Identity.ToLower();
try
{
if (repositiory.Add <Article>(info))
{
//改变其他的排序
//排第一
if (model.LastSort == 0)
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Articles] SET [Sort] = [Sort]+1 WHERE [ID]<{0}", info.ID);
}//排中间
else if (repositiory.GetCount <Article>(m => m.Sort >= info.Sort && m.ID != info.ID) > 0)
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Articles] SET [Sort] = [Sort]+1 WHERE [ID]!={0} and [Sort]>={1}", info.ID, info.Sort);
}
return(Redirect(string.Format("/{2}/{1}/{0}.html", info.Identity, course.Identity, course.Catalog.Identity)));
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
var list = repositiory.GetSelect <Article, int>(m => m.CourseID == model.CourseID, m => m.Sort);
ViewData["ArticleList"] = GetArticleList(list, list.Count == 0 ? 0 : list.LastOrDefault().Sort);
return(View(model));
}
//修改文章页面
public ActionResult ModifyArticle(string identity)
{
if (string.IsNullOrEmpty(identity))
{
return(Content("路径不对"));
}
var model = repositiory.Find <Article>(m => m.Identity == identity.ToLower());
if (model == null)
{
return(Content("路径不对"));
}
var article = new ViewAddArticleModel();
article.Identity = identity;
article.Content = model.Content;
article.Title = model.Title;
return(View(article));
}
public ActionResult ModifyArticle(ViewAddArticleModel model)
{
if (ModelState.IsValid)
{
var article = repositiory.Find <Article>(m => m.Identity == model.Identity.ToLower());
if (article == null)
{
return(Content("路径不对"));
}
article.UpdateTime = DateTime.Now;
article.Title = model.Title;
article.Content = model.Content;
if (repositiory.Update(article))
{
return(RedirectToAction("Article", "Home", new { catalogidentity = article.Course.Catalog.Identity, courseidentity = article.Course.Identity, identity = article.Identity }));
}
}
return(View());
}
