Ejemplo n.º 1
0
        /// <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));
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 前台发送消息
        /// </summary>
        /// <param name="jsonstr">前台拼接json字符窜</param>
        /// <returns></returns>
        public ActionResult Message_ManySend(string jsonstr)
        {
            Comment Comm_New = JsonConvert.DeserializeObject <Comment>(jsonstr);
            //添加回复消息

            string savedt = DateTime.Now.ToString().Substring(DateTime.Now.ToString().LastIndexOf(' ') + 1);

            Comment comm_insert = new Comment()
            {
                ULogin_Id         = Comm_New.ULogin_Id,
                Write_blog_Id     = Comm_New.Write_blog_Id,
                Comment_Content   = Comm_New.Comment_Content,
                Comment_Time      = Convert.ToDateTime(savedt),
                Parent_Comment_Id = Comm_New.Comment_Id,
                Comment_User      = Comm_New.ULogin_Id
            };

            _be.Entry(comm_insert).State = System.Data.EntityState.Added;

            int count = _be.SaveChanges();

            return(RedirectToAction("Personal_Message"));
        }
Ejemplo n.º 4
0
        /// <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());
        }
Ejemplo n.º 5
0
        /// <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());
        }
Ejemplo n.º 6
0
        /// <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());
        }
Ejemplo n.º 7
0
        /// <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());
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 删除评论的递归算法
        /// </summary>
        /// <param name="db">数据库上下对象</param>
        /// <param name="querybc">该条评论所属文章的所有评论</param>
        /// <param name="bc">该条评论的信息</param>
        public void del(MonkeyDBEntities db, List <Blog_Comment> querybc, Blog_Comment bc)
        {
            //查询该条评论的二级评论
            List <Blog_Comment> bclist1 = querybc.Where(a => a.BC_Comment_ParentId == bc.BC_CommentId).ToList();

            //设置实体状态
            db.Entry(bc).State = System.Data.EntityState.Deleted;

            //判断该条评论的二级评论条数是否大于等于1
            if (bclist1.Count() >= 1)
            {
                //遍历该评论的二级评论的集合
                foreach (var item in bclist1)
                {
                    //递归调用
                    del(db, querybc, item);
                }
            }
        }
Ejemplo n.º 9
0
        /// <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());
        }
Ejemplo n.º 10
0
        /// <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());
        }
Ejemplo n.º 11
0
        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));
        }