public JsonResult delcommentson(wenzhangpinglunson wps)
{
try
{
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.iswenzhangzuoze(uif.id, wps.id))
{
wps.pinglunrenid = uif.id;
return(Json(new { issuf = cb.delcommentson(wps) }));
}
else if (cb.isgaipinglunsonzuoze(uif.id, wps.id))
{
wps.pinglunrenid = uif.id;
return(Json(new { issuf = cb.delcommentson(wps) }));
}
return(Json(new { issuf = false }));
}
catch
{
return(Json(new { issuf = true }));
}
}
/// <summary>
/// 添加评论子集
/// </summary>
/// <param name="wzs"></param>
/// <returns></returns>
public wenzhangpinglunson Addcommentson(wenzhangpinglunson wzs)
{
UserinfoDAL ud = new UserinfoDAL();
//MySqlParameter[] Parameter = { new MySqlParameter("@pinglunid", wzs.pinglunid) };
//var pinglunpa = ud.testlogin("select pinglunrenid from boke.wenzhangpinglun where id=@pinglunid", Parameter);
//if (pinglunpa != null)
//{
// wzs.huifurenid = Convert.ToInt32(pinglunpa.Rows[0][0]);
//}
//else
//{
// return null;
//}
MySqlParameter[] mySqlParameter = { new MySqlParameter("@pinglunneirong", bokeSite.tools.FileRW.Html2Text(wzs.pinglunneirong)),
new MySqlParameter("@pinglunrenid", wzs.pinglunrenid), new MySqlParameter("@pinglunid",wzs.pinglunid), new MySqlParameter("@huifurenid", wzs.huifurenid) };
var data = ud.dataUapdatOrInsert(@"insert into boke.wenzhangpinglunson values(null,@pinglunid,@pinglunrenid,@pinglunneirong,0,1,now(),@huifurenid,1)", mySqlParameter);
if (data == 1)
{
var dt = ud.testlogin(@"select * from boke.wenzhangpinglunson where pinglunid=@pinglunid and pinglunneirong=@pinglunneirong and pinglunrenid=@pinglunrenid and huifurenid=@huifurenid order by pinglunshijian desc", mySqlParameter);
return(DataToEnity <wenzhangpinglunson> .DataRowToEntity(dt.Rows[0]));
}
return(null);
}
/// <summary>
/// 评论的子集点赞
/// </summary>
/// <param name="wzs"></param>
/// <returns></returns>
public JsonResult pinglundianzhanson(wenzhangpinglunson wzs)
{
CommentBLL commentBLL = new CommentBLL();
bool issuf = commentBLL.pinglundianzhanson(wzs);
return(Json(new { issuf = issuf }));
}
/// <summary>
/// 根据评论子集id删除评论（实际为修改评论是否删除的标识）
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public bool delcommentson(wenzhangpinglunson wzp)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", wzp.id) };
int dt = ud.dataUapdatOrInsert(@"update boke.wenzhangpinglunson set isdel=true where id=@id", mySqlParameter);
return(dt > 0);
}
/// <summary>
/// 评论点赞书增加1
/// </summary>
/// <param name="wzp"></param>
/// <returns></returns>
public bool pinglundianzhanson(wenzhangpinglunson 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.wenzhangpinglunson 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.wenzhangpinglunson set dianzanshu=@dianzanshu where id=@id and isdel=0", mySqlPr) > 0);
}
catch
{
return(false);
}
}
/// <summary>
/// 对评论进行评论
/// </summary>
/// <param name="wps"></param>
/// <returns></returns>
public JsonResult Addcommentson(wenzhangpinglunson wps)
{
userinfo uif = new userinfo();
uif.username = HttpContext.Request.Cookies["user"];
uif.pwd = HttpContext.Request.Cookies["key"];
if (wps.pinglunid == 0 || wps.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"
};
wenzhangpinglunson wenzhangpinglunson = new CommentBLL().Addcommentson(wps);
return(Json(new { issuf = true, wenzhangpinglunson, userinfo }));
}
else
{
WenZhangBLL uib = new WenZhangBLL();
var uifdata = uib.Getuserinfo(uif);
wps.pinglunrenid = uifdata.Rows.Count != 0 ? Convert.ToInt32(uifdata.Rows[0]["id"]) : 0;
if (wps.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";
}
wenzhangpinglunson wenzhangpinglunson = new CommentBLL().Addcommentson(wps);
return(Json(new { issuf = true, wenzhangpinglunson, userinfo }));
}
}
}
