/// <summary>
/// 修改分类页面
/// </summary>
/// <param name="id">分类id</param>
/// <returns></returns>
public ActionResult CateUpdate(int id)
{
cate ca = db.cate.SingleOrDefault <cate>(c => c.id == id);
ViewData["cate"] = ca;
return(View());
}
public JsonResult ProcessAdd(string cateName)
{
cate mycate = new cate();
var result = from c in dbContext.cate
where c.catname == cateName
select c;
if (result.Count() > 0)
{
return(Json(new { status = 0, data = "该分类已存在,请重新输入！" }));
}
else
{
mycate.catname = cateName;
dbContext.cate.Add(mycate);
if (dbContext.SaveChanges() != 0)
{
return(Json(new { status = 1, data = "添加成功" }));
}
else
{
return(Json(new { status = 0, data = "添加失败" }));
}
}
}
public static cate UpdateCate(int id)
{
using (MyBlogEntities db = new MyBlogEntities())
{
cate cate = db.cate.Find(id);
return(cate);
}
}
public ActionResult UpdateCate(int id)
{
cate mycate = dbContext.cate.Find(id);
ViewBag.id = mycate.id;
ViewBag.catename = mycate.catname;
return(View());
}
/// <summary>
/// 删除分类请求
/// </summary>
/// <param name="id">分类id</param>
/// <returns></returns>
public ActionResult CateDeleteRequest(int id)
{
cate ca = db.cate.SingleOrDefault <cate>(c => c.id == id);
db.cate.DeleteObject(ca);
db.SaveChanges();
return(Redirect("/home/catepage"));
}
public static void SelectAllDelete(int idStr)
{
using (MyBlogEntities db = new MyBlogEntities())
{
cate cate = db.cate.Find(idStr);
db.cate.Remove(cate);
db.SaveChanges();
}
}
/// <summary>
/// 修改分类业务实现
/// </summary>
/// <param name="id"></param>
/// <param name="content"></param>
/// <returns></returns>
public ActionResult CateUpdateRequest(int id, String content)
{
if (content.Length > 0)
{
cate ca = db.cate.SingleOrDefault <cate>(c => c.id == id);
ca.catecontent = content;
db.SaveChanges();
}
return(Redirect("/home/catepage"));
}
/// <summary>
/// 添加分类请求
/// </summary>
/// <returns></returns>
public ActionResult CateAddRequest(String content)
{
if (content.Length > 0)
{
user_table user = checkUser();
cate ca = new cate();
ca.catecontent = content;
ca.uid = user.id;
ca.fid = user.fid;
db.cate.AddObject(ca);
db.SaveChanges();
}
return(Redirect("/home/catepage"));
}
public static int IsCheckAddCate(cate cate)
{
using (MyBlogEntities db = new MyBlogEntities())
{
try
{
db.cate.Add(cate);
db.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
}
public JsonResult IsCheckAddCate(string cateName)
{
cate cate = new cate();
cate.catname = cateName;
var result = CategoryBLL.IsCheckAddCate(cate);
if (result == 1)
{
return(Json(new { status = 1, data = "新增成功！" }));
}
else
{
return(Json(new { status = 0, data = "新增失败！" }));
}
}
public void ProcessDelete(int id)
{
cate mycate = dbContext.cate.Find(id);
var result = from a in dbContext.article
where a.cateid == id
select a;
if (result.Count() > 0) //如果要删除的分类下有文章，那么就把这些文章的cateid=1，也就是“未分类”
{
foreach (var a in result)
{
a.cateid = 1;
}
}
dbContext.cate.Remove(mycate);
dbContext.SaveChanges();
}
public JsonResult ProcessUpdate(int cateId, string cateName)
{
var result = from c in dbContext.cate
where c.catname == cateName
select c;
if (result.Count() > 0)
{
return(Json(new { status = 0, data = "该分类已存在,请重新输入！" }));
}
else
{
cate mycate = dbContext.cate.Find(cateId);
mycate.catname = cateName;
if (dbContext.SaveChanges() != 0)
{
return(Json(new { status = 1, data = "修改成功" }));
}
else
{
return(Json(new { status = 0, data = "修改失败" }));
}
}
}
public static int IsCheckAddCate(cate cate)
{
return(CategoryDAL.IsCheckAddCate(cate));
}
