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