public ActionResult ModifyCatalog(ViewAddCatalogModel model)
{
if (ModelState.IsValid)
{
var info = repositiory.Find <Catalog>(m => m.Identity == model.Identity.ToLower());
if (info == null)
{
return(Content("路径不对"));
}
info.Name = model.Name;
if (model.LastSort != info.Sort - 1)
{
if (model.LastSort < info.Sort - 1)
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Catalogs] SET [Sort] = [Sort]+1 WHERE [Sort]<{0} and [Sort]>{1}", info.Sort, model.LastSort);
}
else
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Catalogs] SET [Sort] = [Sort]-1 WHERE [Sort]>{0} and [Sort]<={1}", info.Sort, model.LastSort);
}
info.Sort = model.LastSort + 1;
}
if (repositiory.Update(info))
{
return(Redirect(string.Format("/{0}.html", info.Identity)));
}
}
var list = repositiory.GetSelect <Catalog>(m => true);
ViewBag.CatalogList = list;
return(View(model));
}
public ActionResult AddCatalog(ViewAddCatalogModel model)
{
if (ModelState.IsValid)
{
var info = new Catalog();
info.Name = model.Name;
//算法计算
info.Sort = model.LastSort + 1;
info.AddTime = DateTime.Now;
info.UpdateTime = DateTime.Now;
info.Status = 1;
info.Identity = model.Identity.ToLower();
if (repositiory.Add <Catalog>(info))
{
//改变其他的排序
//第一
if (model.LastSort == 0)
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Catalogs] SET [Sort] = [Sort]+1 WHERE [ID]<{0}", info.ID);
}
//中间
else if (repositiory.GetCount <Catalog>(m => m.Sort >= info.Sort && m.ID != info.ID) > 0)
{
bamnContext.Database.ExecuteSqlCommand("UPDATE [dbo].[Catalogs] SET [Sort] = [Sort]+1 WHERE [ID]!={0} and [Sort]>={1}", info.ID, info.Sort);
}
return(Redirect(string.Format("/{0}.html", info.Identity)));
}
}
var list = repositiory.GetSelect <Catalog>(m => true);
ViewBag.CatalogList = list;
return(View(model));
}
//修改分类
public ActionResult ModifyCatalog(string identity)
{
if (string.IsNullOrEmpty(identity))
{
return(Content("路径不对"));
}
var model = repositiory.Find <Catalog>(m => m.Identity == identity.ToLower());
if (model == null)
{
return(Content("路径不对"));
}
var list = repositiory.GetSelect <Catalog, int>(m => m.Identity != identity.ToLower(), m => m.Sort);
ViewData["CatalogList"] = GetTimeHourList(list, model.Sort - 1);
var viewModel = new ViewAddCatalogModel();
viewModel.Identity = model.Identity;
viewModel.Name = model.Name;
viewModel.LastSort = model.Sort - 1;
return(View(viewModel));
}
