/// <summary>
/// 根据评论id删除评论（实际为修改评论是否删除的标识）
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public bool delcomment(wenzhangpinglun wzp)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", wzp.id) };
int dt = ud.dataUapdatOrInsert(@"update boke.wenzhangpinglun set isdel=true where id=@id", mySqlParameter);
return(dt > 0);
}
/// <summary>
/// 添加文章评论
/// </summary>
/// <param name="wzp"></param>
/// <returns></returns>
public wenzhangpinglun addWenZhangPingLun(wenzhangpinglun wzp)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@pinglunneirong", bokeSite.tools.FileRW.Html2Text(wzp.pinglunneirong)),
new MySqlParameter("@pinglunrenid", wzp.pinglunrenid), new MySqlParameter("@wenzhangid", wzp.wenzhangid) };
var data = ud.dataUapdatOrInsert(@"insert into boke.wenzhangpinglun values(null,@wenzhangid,@pinglunneirong,@pinglunrenid,now(),0,1,1)", mySqlParameter);
if (data == 1)
{
var dt = ud.testlogin(@"select * from boke.wenzhangpinglun where wenzhangid=@wenzhangid and pinglunneirong=@pinglunneirong and pinglunrenid=@pinglunrenid order by pinglunshijian desc", mySqlParameter);
return(DataToEnity <wenzhangpinglun> .DataRowToEntity(dt.Rows[0]));
}
return(null);
}
/// <summary>
/// 创建评论条
/// </summary>
/// <param name="wzp"></param>
/// <returns></returns>
public JsonResult Addcomment(wenzhangpinglun wzp)
{
userinfo uif = new userinfo();
uif.username = HttpContext.Request.Cookies["user"];
uif.pwd = HttpContext.Request.Cookies["key"];
if (wzp.wenzhangid == 0 || wzp.pinglunneirong == null)
{
return(Json(new { msg = "操作出错" }));
}
if (string.IsNullOrEmpty(uif.username))
{
userinfo userinfo = new userinfo()
{
id = 0, nicheng = "欠名", username = "******", touxiangurl = @"\images\header-img-comment_03.png"
};
wenzhangpinglun wenzhangpinglun = new CommentBLL().addWenZhangPingLun(wzp);
return(Json(new { issuf = true, wenzhangpinglun, userinfo }));
}
else
{
WenZhangBLL uib = new WenZhangBLL();
var uifdata = uib.Getuserinfo(uif);
wzp.pinglunrenid = uifdata.Rows.Count != 0 ? Convert.ToInt32(uifdata.Rows[0]["id"]) : 0;
if (wzp.pinglunrenid == 0)
{
return(Json(new { msg = "非法登陆,评论失败" }));
}
else
{
var userinfo = DataToEnity <userinfo> .DataRowToEntity(uifdata.Rows[0]);
if (userinfo.touxiangurl == null)
{
userinfo.touxiangurl = @"\images\header-img-comment_03.png";
}
if (userinfo.nicheng == null || userinfo.nicheng == "")
{
userinfo.nicheng = "未设置昵称";
}
wenzhangpinglun wenzhangpinglun = new CommentBLL().addWenZhangPingLun(wzp);
return(Json(new { issuf = true, wenzhangpinglun, userinfo }));
}
}
}
/// <summary>
/// 评论点赞书增加1
/// </summary>
/// <param name="wzp"></param>
/// <returns></returns>
public bool pinglundianzhan(wenzhangpinglun wzp)
{
if (wzp.dianzanshu == 0)
{
return(false);
}
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", wzp.id) };
try
{
int dianzhanshu = Convert.ToInt32(ud.testlogin("select dianzanshu from boke.wenzhangpinglun where id=@id and isdel=0", mySqlParameter).Rows[0][0]);
MySqlParameter[] mySqlPr = { new MySqlParameter("@dianzanshu", dianzhanshu + 1), new MySqlParameter("@id", wzp.id) };
return(ud.dataUapdatOrInsert("update boke.wenzhangpinglun set dianzanshu=@dianzanshu where id=@id and isdel=0", mySqlPr) > 0);
}
catch
{
return(false);
}
}
public JsonResult delcomment(wenzhangpinglun wzp)
{
userinfo uif = new userinfo();
uif.username = HttpContext.Request.Cookies["user"];
uif.pwd = HttpContext.Request.Cookies["key"];
WenZhangBLL wz = new WenZhangBLL();
uif = DataToEnity <userinfo> .DataRowToEntity(wz.Getuserinfo(uif).Rows[0]);
CommentBLL cb = new CommentBLL();
if (cb.iswenzhangbelongher(uif.id, wzp.id))
{
wzp.pinglunrenid = uif.id;
return(Json(new { issuf = cb.delcomment(wzp) }));
}
else if (cb.isgaipinglunzuoze(uif.id, wzp.id))
{
wzp.pinglunrenid = uif.id;
return(Json(new { issuf = cb.delcomment(wzp) }));
}
return(Json(new { issuf = false }));
}
/// <summary>
/// 评论点赞
/// </summary>
/// <param name="wzp"></param>
/// <returns></returns>
public JsonResult pinglundianzhan(wenzhangpinglun wzp)
{
CommentBLL commentBLL = new CommentBLL();
return(Json(new { issuf = commentBLL.pinglundianzhan(wzp) }));
}