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