/// <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));
}
