/// <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);
}
public void SendMessage(string content, int comment_ID, int comment_user)
{
MonkeyDBEntities blog = new MonkeyDBEntities();
//向数据库添加信息
string dtime = DateTime.Now.ToString();
string dttime_two = dtime.Substring(dtime.LastIndexOf(" ") + 1);
Comment comm_Window_Insert = new Comment()
{
Comment_Time = Convert.ToDateTime(dttime_two),
Comment_Content = content,
Parent_Comment_Id = comment_ID,
Comment_User = comment_user,
ULogin_Id = comment_user
};
//添加信息
blog.Entry(comm_Window_Insert).State = System.Data.EntityState.Added;
int count = blog.SaveChanges();
//获取头像
string img = blog.Users_Details.Where(a => a.Users_Details_ID == comment_user).Select(a => a.Users_Details_Photo).First();
Clients.Caller.getMessage(dtime, content, img);
}
/// <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>
/// 名称：修改密码
/// 时间：
/// 作者：
/// </summary>
/// <param name="phone">手机号</param>
/// <param name="newpassword">新密码</param>
/// <param name="code">验证码</param>
/// <returns></returns>
public JsonResult ForgetSucc(string newpassword, string code)
{
//验证已获取验证码
if (Session["sendCode"] == null)
{
return(Json(new DTO_Result()
{
Result_Code = "6565", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
else if (!code.Equals((Session["sendCode"] as DTO_Reg).Code))
{
return(Json(new DTO_Result()
{
Result_Code = "6565", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
else if (string.IsNullOrEmpty(newpassword))
{
return(Json(new DTO_Result()
{
Result_Code = "656665", Result_Title = "请输入密码"
}, JsonRequestBehavior.AllowGet));
}
//创建数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
string s = (Session["sendCode"] as DTO_Reg).Phone;
//查询用户
ULogin _ul = _db.ULogin.Where(a => a.ULogin_Phone.Equals(s)).FirstOrDefault();
if (_ul != null)
{
_ul.ULogin_Password = MD5JM(newpassword);
}
//提交数据
if (_db.SaveChanges() > 0)
{
return(Json(new DTO_Result()
{
Result_Code = "000000", Result_Title = "密码修改成功，请重新登录"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new DTO_Result()
{
Result_Code = "004400", Result_Title = "密码修改失败"
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 名称：添加专栏信息
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_sp">要添加的专栏数据</param>
/// <returns>新添加的自定义类别自增id</returns>
public static int AddSpecial(Special _sp)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
_db.Special.Add(_sp);
//提交
_db.SaveChanges();
//返回自增id
return(_sp.Special_Id);
}
/// <summary>
/// 名称：添加自定义类别
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_ca">要添加的自定义类别数据</param>
/// <returns>新添加的自定义类别自增id</returns>
public static int AddCategory(Category _ca)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
_db.Category.Add(_ca);
//提交
_db.SaveChanges();
//返回自增id
return(_ca.Category_Id);
}
public JsonResult DelPeraonalComment(Blog_Comment bc)
{
MonkeyDBEntities db = new MonkeyDBEntities();
//查询该篇文章的所有评论
List <Blog_Comment> querybc = db.Blog_Comment.AsNoTracking().Where(a => a.BC_ArticleID == bc.BC_ArticleID).ToList();
del(db, querybc, bc);
//操作数据库
int count = db.SaveChanges();
return(Json(count, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 用户自己修改个人信息
/// </summary>
/// <param name="ud">前台修改的值</param>
/// <returns>返回index页</returns>
public ActionResult Update_UserInfo(Users_Details ud)
{
//博客账号名可能发生重复
//用户登录编号
string str_U_id = U_Id();
//根据登录编号修改个人信息
int Login_Id = Convert.ToInt32(str_U_id);
//根据Login_ID查询个人信息
Users_Details details = _be.Users_Details.Where(a => a.Users_Details_ID == Login_Id).FirstOrDefault();
//修改
details.Users_Details_Birthday = ud.Users_Details_Birthday; //生日
details.Users_Details_Industry = ud.Users_Details_Industry; //行业
details.Users_Details_Jop = ud.Users_Details_Jop; //职位
details.Users_Details_Name = ud.Users_Details_Name; //昵称
details.Users_Details_RealName = ud.Users_Details_RealName; //真实姓名
details.Users_Details_Sex = ud.Users_Details_Sex; //性别
details.Users_Details_Resume = ud.Users_Details_Resume; //备注
details.Users_Details_LoginUrl = ud.Users_Details_LoginUrl; //登录地址
int count = _be.SaveChanges();
return(RedirectToAction("Index", "Personal"));
}
/// <summary>
/// 名称：修改自定义类别
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_ca">修改后的对象</param>
/// <returns>修改后受影响的行id</returns>
public static int UpdateCategory(Category _ca)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
var _upd = _db.Entry(_ca);
//指定数据已更新
_upd.State = System.Data.EntityState.Unchanged;
//指定修改的字段
_upd.Property("Category_Reception").IsModified = _ca.Category_Reception != null;
_upd.Property("Category_Type").IsModified = !string.IsNullOrEmpty(_ca.Category_Type);
return(_db.SaveChanges());
}
/// <summary>
/// 名称：修改专栏信息
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_sp">修改的数据</param>
/// <returns>操作受影响的行数</returns>
public static int UpdateSpecial(Special _sp)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
var _upd = _db.Entry(_sp);
//指定数据已更新
_upd.State = System.Data.EntityState.Unchanged;
//指定修改的字段
_upd.Property("Special_Name").IsModified = !string.IsNullOrEmpty(_sp.Special_Name);
_upd.Property("Special_Introduce").IsModified = !string.IsNullOrEmpty(_sp.Special_Introduce);
return(_db.SaveChanges());
}
/// <summary>
/// 名称：删除专栏信息
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_spId">要删除的专栏编号</param>
/// <returns>新添加的自定义类别自增id</returns>
public static int DeleteSpecial(int _spId)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
//编辑要删除的数据
Special _sp = new Special()
{
Special_Id = _spId
};
//指定要删除的自定义类别
_db.Entry(_sp).State = System.Data.EntityState.Deleted;
_db.Special.Remove(_sp);
return(_db.SaveChanges());
}
/// <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());
}
/// <summary>
/// 名称：删除自定义类别
/// 时间：1-18
/// 作者：
/// </summary>
/// <param name="_caId">要删除的自定义类别编号</param>
/// <returns>删除后受影响的行</returns>
public static int DeleteCategory(int _caId)
{
//创建一个数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
//编辑要删除的数据
Category _ca = new Category()
{
Category_Id = _caId
};
//指定要删除的自定义类别
_db.Entry(_ca).State = System.Data.EntityState.Deleted;
_db.Category.Remove(_ca);
return(_db.SaveChanges());
}
/// <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 Register_in(string username, string password, string repassword, string code)
{
//判断手机号是否为空
if (string.IsNullOrEmpty(username))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "请输入手机号"
}, JsonRequestBehavior.AllowGet));
}
//判断手机号是否符合规则
else if (!IsMobilePhone(username))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "手机号格式不正确"
}, JsonRequestBehavior.AllowGet));
}
//判断是否输入验证码
else if (Session["sendCode"] == null || string.IsNullOrEmpty(code))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "请输入验证码"
}, JsonRequestBehavior.AllowGet));
}
//判断是否输入密码
else if (string.IsNullOrEmpty(password))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "请输入密码"
}, JsonRequestBehavior.AllowGet));
}
//判断两次输入的密码
else if (!password.Equals(repassword))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "前后两次密码不一致"
}, JsonRequestBehavior.AllowGet));
}
//验证验证码是否输入正确
else if (!code.Equals((Session["sendCode"] as DTO_Reg).Code))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
//验证验证码是否超时
else if ((DateTime.Now - ((Session["sendCode"] as DTO_Reg).Time)).TotalSeconds > OutTime)
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "验证码超时"
}, JsonRequestBehavior.AllowGet));
}
//录入数据
else
{
//创建数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
//验证手机号是否注册
if (_db.ULogin.Where(a => a.ULogin_Phone == username).Count() <= 0)
{
//录入
Users_Details _det = _db.Users_Details.Add(new Users_Details()
{
Users_Details_Name = username, Users_Details_Follow = 0, Users_Details_Etc = 0, Users_Details_LoginDate = DateTime.Now
});
ULogin _ul = _db.ULogin.Add(new ULogin()
{
Ulogin_BlogName = username, ULogin_Password = MD5JM(password), ULogin_Phone = username, Users_Details_ID = _det.Users_Details_ID
});
if (_db.SaveChanges() >= 2)
{
return(Json(new DTO_Result()
{
Result_Code = "000000", Result_Title = "注册成功"
}));
}
else
{
_db.ULogin.Remove(_ul);
_db.Users_Details.Remove(_det);
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "注册失败"
}));
}
}
else
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "该用户已存在，注册失败"
}));
}
}
}
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));
}
