/// <summary> /// 文章更新 /// </summary> /// <param name="uz"></param> /// <param name="path"></param> /// <returns></returns> public Result <userwenzhang> editwenzhang(userwenzhang uz, string path) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter1 = { new MySqlParameter("@userid", uz.userid), new MySqlParameter("@id", uz.id) }; Result <userwenzhang> rs = new Result <userwenzhang>(); rs.issuf = false; int ishavathiswenzhang = Convert.ToInt32(ud.testlogin(@"select count(id) from boke.userwenzhang where userid =@userid and id =@id and isdel=0", mySqlParameter1).Rows[0][0]); if (ishavathiswenzhang == 1) { string pathjichu = "\\upload\\wenzhang\\" + DateTime.Now.ToString("yyyyMMdd") + "\\" + Guid.NewGuid() + ".ihtml"; pathjichu = pathjichu.Replace("\\", "/"); path = path + "wwwroot" + pathjichu; if (bokeSite.tools.FileRW.CreateHtml(path, uz.content)) { string content100 = ""; uz.content100 = bokeSite.tools.FileRW.Html2Text(uz.content100); if (uz.content100 != null && uz.content100.Length > 400) { content100 = uz.content100.Substring(0, 400); } else { content100 = uz.content100; } MySqlParameter[] mySqlParameter = { new MySqlParameter("@content", uz.content100), new MySqlParameter("@content100", content100) , new MySqlParameter("@iskejian", uz.iskejian), new MySqlParameter("@leixing", uz.leixing), new MySqlParameter("@userid", uz.userid) , new MySqlParameter("@wenzhangname", bokeSite.tools.FileRW.Html2Text(uz.wenzhangname)), new MySqlParameter("@wenzhangurl", pathjichu), new MySqlParameter("@id", uz.id) }; var data = ud.dataUapdatOrInsert(@"update boke.userwenzhang set leixing=@leixing,content=@content,content100=@content100,xiugaishijian=now(),wenzhangname=@wenzhangname,iskejian=@iskejian,wenzhangurl=@wenzhangurl where userid=@userid and id=@id and isdel=0", mySqlParameter); if (data == 1) { rs.issuf = true; rs.count = 1; rs.content = new userwenzhang() { id = uz.id }; return(rs); } else { rs.msg = "发生了不知名的错误"; } } else { rs.msg = "服务器写入错误"; } } else { rs.msg = "你要修改的文章不存在"; } return(rs); }
/// <summary> /// 添加文章 /// </summary> /// <param name="uz"></param> /// <returns></returns> public Result <userwenzhang> addwenzhang(userwenzhang uz, string path) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter1 = { new MySqlParameter("@userid", uz.userid), new MySqlParameter("@wenzhangname", uz.wenzhangname) }; Result <userwenzhang> rs = new Result <userwenzhang>(); rs.issuf = false; int ishavaname = Convert.ToInt32(ud.testlogin(@"select count(id) from boke.userwenzhang where userid =@userid and wenzhangname =@wenzhangname and isdel=0", mySqlParameter1).Rows[0][0]); if (ishavaname == 0) { string pathjichu = "\\upload\\wenzhang\\" + DateTime.Now.ToString("yyyyMMdd") + "\\" + Guid.NewGuid() + ".ihtml"; pathjichu = pathjichu.Replace("\\", "/"); path = path + "wwwroot" + pathjichu; if (bokeSite.tools.FileRW.CreateHtml(path, uz.content)) { uz.content100 = bokeSite.tools.FileRW.Html2Text(uz.content100); string content100 = ""; if (uz.content100 != null && uz.content100.Length > 400) { content100 = uz.content100.Substring(0, 400); } else { content100 = uz.content100; } MySqlParameter[] mySqlParameter = { new MySqlParameter("@content", uz.content100), new MySqlParameter("@content100", content100) , new MySqlParameter("@iskejian", uz.iskejian), new MySqlParameter("@leixing", uz.leixing), new MySqlParameter("@userid", uz.userid) , new MySqlParameter("@wenzhangname", bokeSite.tools.FileRW.Html2Text(uz.wenzhangname)), new MySqlParameter("@wenzhangurl", pathjichu) }; var data = ud.dataUapdatOrInsert(@"insert into boke.userwenzhang values(null,@leixing,@userid,@content,@content100,now(),now(),0,@wenzhangname,@iskejian,false,@wenzhangurl)", mySqlParameter); if (data == 1) { var dt = ud.testlogin(@"select id from boke.userwenzhang where wenzhangname =@wenzhangname and isdel=0 order by zhuceshijian desc", mySqlParameter); rs.issuf = true; rs.count = 1; rs.content = DataToEnity <userwenzhang> .DataRowToEntity(dt.Rows[0]); rs.content.content = null; return(rs); } else { rs.msg = "发生了不知名的错误"; } } else { rs.msg = "服务器写入错误"; } } else { rs.msg = "文章名字已经存在了"; } return(rs); }
public JsonResult editwenzhang(userwenzhang uwz) { userinfo uif = new userinfo(); uif.username = HttpContext.Request.Cookies["user"]; uif.pwd = HttpContext.Request.Cookies["key"]; WenZhangBLL uib = new WenZhangBLL(); var data = uib.Getuserinfo(uif); uwz.userid = data.Rows.Count != 0 ? Convert.ToInt32(data.Rows[0]["id"]) : 0; if (string.IsNullOrEmpty(uwz.content) && string.IsNullOrEmpty(uwz.content100) && string.IsNullOrEmpty(uwz.wenzhangname) && uwz.id == 0) { return(Json(new { issuf = false, msg = "参数错误" })); } else { Result <userwenzhang> result = uib.editwenzhang(uwz, serverPath); return(Json(new { result })); } }
public JsonResult delwenzhang(userwenzhang uwz) { userinfo uif = new userinfo(); uif.username = HttpContext.Request.Cookies["user"]; uif.pwd = HttpContext.Request.Cookies["key"]; WenZhangBLL uib = new WenZhangBLL(); var data = uib.Getuserinfo(uif); uwz.userid = data.Rows.Count != 0 ? Convert.ToInt32(data.Rows[0]["id"]) : 0; if (uwz.userid == 0 || uwz.id == 0) { return(Json(new { msg = "你是傻子吧" })); } else { Result <userwenzhang> result = uib.delwenzhang(uwz); return(Json(new { result })); } }
/// <summary> /// 删除文章 /// </summary> /// <param name="uz"></param> /// <returns></returns> public Result <userwenzhang> delwenzhang(userwenzhang uz) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@userid", uz.userid), new MySqlParameter("@id", uz.id) }; Result <userwenzhang> rs = new Result <userwenzhang>(); rs.issuf = false; int data = ud.dataUapdatOrInsert(@"update boke.userwenzhang set isdel=true where id = @id and userid = @userid and isdel=0", mySqlParameter); if (data == 1) { rs.issuf = true; return(rs); } else { rs.msg = "文章不属于你,或者文章已经删除"; } return(rs); }