/// <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>
/// 根据评论子集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>
/// 文章更新
/// </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);
}
/// <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="userid"></param>
/// <param name="leixingming"></param>
/// <returns>添加成功的文章类型的主键</returns>
public int addleixing(string userid, string leixingming)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@leixingming", bokeSite.tools.FileRW.Html2Text(leixingming)), new MySqlParameter("@userid", userid) };
var data = ud.dataUapdatOrInsert(@"insert into boke.userwenzhangleixing values(null,@userid,@leixingming,now(),now())", mySqlParameter);
if (data == 1)
{
var dt = ud.testlogin(@"select id from boke.userwenzhangleixing where userid=@userid and leixingming =@leixingming order by zhuceshijian desc", mySqlParameter);
return(Convert.ToInt32(dt.Rows[0][0]));
}
return(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="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);
}
