/// <summary>
/// 彻底删除文章
/// </summary>
/// <returns></returns>
public JsonResult RealDelBlogManagerIndex(Write_blog wb)
{
MonkeyDBEntities db = new MonkeyDBEntities();
db.Entry(wb).State = System.Data.EntityState.Deleted;; //彻底删除博客
//查询该条博客下面的所有评论
List <Blog_Comment> bclist = db.Blog_Comment.Where(a => a.BC_ArticleID == wb.Write_blog_Id).ToList();
//遍历该博客下面的所评论
foreach (var item in bclist)
{
//删除评论
db.Entry(item).State = System.Data.EntityState.Deleted;
}
//先关闭验证实体有效性（ValidateOnSaveEnabled）这个开关（默认是开启的）
db.Configuration.ValidateOnSaveEnabled = false;
int count = db.SaveChanges();//保存到数据库
//在开启验证实体有效性（ValidateOnSaveEnabled）这个开关
db.Configuration.ValidateOnSaveEnabled = true;
return(Json(count, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加博客文章
/// 时间：1-17
/// 修改：1、时间：1-18,内容：将返回值修改为当前添加的文章的自增id
/// </summary>
/// <param name="_wb">文章信息</param>
/// <returns>当前添加的文章的自增ID</returns>
public static int AddBlog(Write_blog _wb)
{
MonkeyDBEntities _db = new MonkeyDBEntities();
//判断文章是否公开，公开就将审核状态改为0（待审核）
//if (_wb.Write_Private == 1)
_wb.Write_State = 0;
//将浏览量和点赞量设为0
_wb.Write_ReadCount = 0;
_wb.Write_ZanCount = 0;
_wb.Write_Collection = 0;
_wb.ULogin_IdIsManager = "否";
//如果创建时间为空，就将系统当前时间设置为文章创建时间
if (_wb.Write_Createdate == null)
{
_wb.Write_Createdate = DateTime.Now;
}
_wb.Blog_Recommend = 2;
//添加到数据库但未提交
_db.Write_blog.Add(_wb);
//提交到数据库，返回提交结果
_db.SaveChanges();
return(_wb.Write_blog_Id);
}
/// <summary>
/// 博客详情页
/// </summary>
/// <returns></returns>
public ActionResult DetailsWriteBlogIndex()
{
MonkeyDBEntities db = new MonkeyDBEntities();
Write_blog wb = db.Write_blog.Where(a => a.Write_blog_Id == 10).FirstOrDefault();
@ViewBag.wb = wb;
return(View());
}
/// <summary>
/// 删除指定文章（真删，彻底清除文章）
/// 时间：1-17
/// </summary>
/// <param name="_blogId">文章编号</param>
/// <returns></returns>
public static int DeleteOneBlog(int _blogId)
{
MonkeyDBEntities _db = new MonkeyDBEntities();
//创建要删除的实体对象
Write_blog _wb = new Write_blog()
{
Write_blog_Id = _blogId
};
//指定需要删除的数据
_db.Entry(_wb).State = System.Data.EntityState.Deleted;
_db.Write_blog.Remove(_wb);
//提交数据库并返回结果
return(_db.SaveChanges());
}
public ActionResult UpdateWriteBlogIndex(int Write_blog_Id)
{
ULogin u = Session["ULogin"] as ULogin;//Session["ULogin"] as ULogin;
MonkeyDBEntities db = new MonkeyDBEntities();
//查询所有的后台博客类别
List <Backstage_Category> _bclist = DTO_Backstage_Category.SelectBackstage_Category();
//查询所有自定类别
List <Category> clist = DTO_Category.SelectCategory(u.ULogin_Id);
Write_blog wb = db.Write_blog.Where(a => a.Write_blog_Id == Write_blog_Id).FirstOrDefault();
string[] strlist = wb.Category_Id.Split(',');//这篇文章的类型数组
@ViewBag._bclist = _bclist;
@ViewBag.clist = clist;
@ViewBag.wb = wb;
@ViewBag.Mycalist = strlist;
return(View());
}
/// <summary>
/// 将指定文章收入回收站
/// 时间：1-17
/// </summary>
/// <param name="_blogId">文章编号</param>
/// <returns></returns>
public static int DeleteBlog(int _blogId)
{
MonkeyDBEntities _db = new MonkeyDBEntities();
//创建要删除的实体对象
Write_blog _wb = new Write_blog()
{
Write_blog_Id = _blogId, Write_Deletedate = DateTime.Now, Write_IsDel = 0
};
var _upd = _db.Entry(_wb);
//指定数据已更新
_upd.State = System.Data.EntityState.Unchanged;
//指定修改的字段
_upd.Property("Write_Deletedate").IsModified = true;
_upd.Property("Write_IsDel").IsModified = true;
//提交数据，并返回结果
return(_db.SaveChanges());
}
public JsonResult PublishWriteBlog(bool Category_Type_way)
{
MonkeyDBEntities db = new MonkeyDBEntities();
//接收JSON串
string jsonstr = Request["json"];
//反序列化JSON串
Write_blog wb = JsonConvert.DeserializeObject <Write_blog>(jsonstr);
//赋值
wb.ULogin_Id = 1;
wb.Category_Id = Request["Category_Idstr"]; //接收自定义分类的字符串
wb.Write_Content = Request["Write_Content"]; //文章内容
wb.Write_Private = Convert.ToInt32(Request["Write_Private"]);
wb.Write_IsDel = Convert.ToInt32(Request["Write_IsDel"]);
//判断是否添加新的个人分类
if (Category_Type_way == true)
{
//反序列化字符串
Category ca = JsonConvert.DeserializeObject <Category>(jsonstr);
//实力例集合
List <Category> calist = new List <Category>();
//分割字符串
string[] Category_Typelist = ca.Category_Type.Split(',');
//查询所有自定义个人分类
List <Category> calist2 = db.Category.AsNoTracking().Where(a => a.ULogin_Id == 1).ToList();
//循环分割后的分类数组
for (int i = 0; i < Category_Typelist.Length; i++)
{
//根据类名查询是否有相同的自定义个人分类
Category ca2 = calist2.Where(a => a.Category_Type == Category_Typelist[i]).FirstOrDefault();
//判断该分类是否已经存在
if (ca2 != null)
{
return(Json("类名为'" + ca.Category_Type + "'的个人分类已经存在，重新添加或选择个人分类", JsonRequestBehavior.AllowGet));
}
ca = new Category();
ca.ULogin_Id = 1; //用户编号
ca.Category_Reception = 0; //是否显示在前台0显示,1不显示
ca.Category_Type = Category_Typelist[i];
ca.Category_Type = Category_Typelist[i];
//添加对象到对象的集合
calist.Add(ca);
}
//便利集合
foreach (var item in calist)
{
db.Category.Add(item); //添加到上下文中
int row = db.SaveChanges(); //保存到数据库
if (row <= 0)
{
return(Json("添加新的个人分类有错", JsonRequestBehavior.AllowGet));
}
if (wb.Category_Id == "" || wb.Category_Id == null)
{
wb.Category_Id += "" + item.Category_Id;
}
else
{
wb.Category_Id += "," + item.Category_Id;//得到新的个人分类字符串
}
}
}
//调用添加博客文章的方法
int count = DTO_Write_blog.AddBlog(wb);
//判断是否添加成功
if (count <= 0)
{
return(Json("保存失败", JsonRequestBehavior.AllowGet));
}
return(Json(count, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateWriteBlog(bool Category_Type_way)
{
MonkeyDBEntities db = new MonkeyDBEntities();
try
{
//接收JSON串
string jsonstr = Request["json"];
//反序列化JSON串
Write_blog wb = JsonConvert.DeserializeObject <Write_blog>(jsonstr);
//赋值
wb.Category_Id = Request["Category_Idstr"]; //接收自定义分类的字符串
wb.Write_Content = Request["Write_Content"]; //文章内容
wb.Write_Private = Convert.ToInt32(Request["Write_Private"]);
wb.Write_IsDel = Convert.ToInt32(Request["Write_IsDel"]);
wb.Write_State = 0; //审核状态
wb.Write_Createdate = DateTime.Now; //创建时间
if (wb.Write_IsDel == 1)
{
wb.Write_State = null;
}
//判断是否添加新的个人分类
if (Category_Type_way == true)
{
//反序列化字符串
Category ca = JsonConvert.DeserializeObject <Category>(jsonstr);
//实力例集合
List <Category> calist = new List <Category>();
//分割字符串
string[] Category_Typelist = ca.Category_Type.Split(',');
//查询所有自定义个人分类
List <Category> calist2 = db.Category.AsNoTracking().Where(a => a.ULogin_Id == 1).ToList();
//循环分割后的分类数组
for (int i = 0; i < Category_Typelist.Length; i++)
{
//根据类名查询是否有相同的自定义个人分类
Category ca2 = calist2.Where(a => a.Category_Type == Category_Typelist[i]).FirstOrDefault();
//判断该分类是否已经存在
if (ca2 != null)
{
return(Json("类名为'" + ca.Category_Type + "'的个人分类已经存在，重新添加或选择个人分类", JsonRequestBehavior.AllowGet));
}
ca = new Category();
ca.ULogin_Id = 1; //用户编号
ca.Category_Reception = 0; //是否显示在前台0显示,1不显示
ca.Category_Type = Category_Typelist[i];
//添加对象到对象的集合
calist.Add(ca);
}
//便利集合
foreach (var item in calist)
{
db.Category.Add(item); //添加到上下文中
int row = db.SaveChanges(); //保存到数据库
if (row <= 0)
{
return(Json("添加新的个人分类有错", JsonRequestBehavior.AllowGet));
}
if (wb.Category_Id == "" || wb.Category_Id == null)
{
wb.Category_Id += "" + item.Category_Id;
}
else
{
wb.Category_Id += "," + item.Category_Id;//得到新的个人分类字符串
}
}
}
//获取给定实体
var update = db.Entry(wb);
//设置给定实体的状态
update.State = System.Data.EntityState.Unchanged;
//指定要修改的字段
update.Property("Write_Title").IsModified = true;
update.Property("Write_ArticleType").IsModified = true;
update.Property("Write_Content").IsModified = true;
update.Property("Backstage_Category_Id").IsModified = true;
update.Property("Write_Label").IsModified = true;
update.Property("Category_Id").IsModified = true;
update.Property("Write_Title").IsModified = true;
update.Property("Write_Private").IsModified = true;
update.Property("Write_Createdate").IsModified = true;
update.Property("Write_State").IsModified = true;
update.Property("Write_IsDel").IsModified = true;
}
catch (Exception ex)
{
string str = ex.Message;
}
//保存到数据库
int count = db.SaveChanges();
if (count <= 0)
{
return(Json("修改失败", JsonRequestBehavior.AllowGet));
}
return(Json(count, JsonRequestBehavior.AllowGet));
}
