/// <summary> /// 查询文章 /// </summary> /// <param name="_is">是否是自己,大于0为自己,等于0不是自己</param> /// <param name="_val">查询内容</param> /// <returns>查询结果</returns> public JsonResult SearchAll(int _is, string _val) { List <Write_blog> lis = new List <Write_blog>(); var _sess = Session["ULogin"]; var _ulogin = _sess as ULogin; if (_sess != null && _is > 0) { //查询自己的文章 List <Write_blog> _blis = DTO_Write_blog.Select(_ulogin.ULogin_Id, 1, _val); } else if (_sess != null && _is == 0) { //查询指定用户的文章 List <Write_blog> _blis = DTO_Write_blog.Select(_ulogin.ULogin_Id, 0, _val); } else { //查询所有用户的文章 List <Write_blog> _blis = DTO_Write_blog.Select(0, -1, _val); } return(Json(lis, JsonRequestBehavior.AllowGet)); }
public JsonResult DelWriteBlog(int Write_blog_Id) { MonkeyDBEntities db = new MonkeyDBEntities(); //调用删除的方法 int count = DTO_Write_blog.DeleteBlog(Write_blog_Id); return(Json(count, JsonRequestBehavior.AllowGet)); }
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)); }