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="userid"></param>
/// <param name="id"></param>
/// <returns></returns>
public userwenzhangkuozhan GetUserwenzhangText(string userid, string id)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", id), new MySqlParameter("@userid", userid) };
var data = ud.testlogin(@"SELECT id, leixing, userid,wenzhangurl, zhuceshijian, xiugaishijian, dianjiliang, wenzhangname,iskejian FROM boke.userwenzhang where id=@id and userid=@userid and isdel=false", mySqlParameter);
if (data.Rows.Count == 1)
{
var dt = DataToEnity <userwenzhangkuozhan> .DataRowToEntity(data.Rows[0]);
dt.leixingming = "未设主题";
dt.nicheng = "欠名";
if (dt.leixing != 0)
{
dt.leixingming = Getuserwenzhang(userid).Where(u => u.id == dt.leixing).FirstOrDefault().leixingming;
}
var uif = new UserInfoBLL().Getuserinfo(dt.userid);
if (uif != null && uif.nicheng != null)
{
dt.nicheng = uif.nicheng;
}
dt.content = bokeSite.tools.FileRW.readHtml(dt.wenzhangurl);
return(dt);
}
return(null);
}
/// <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>
/// 通过用户id获得用户信息
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public userinfo Getuserinfo(int userid)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@userid", userid) };
var data = ud.testlogin(@"SELECT username, id, nicheng FROM boke.userinfo where id=@userid and isdel=0", mySqlParameter);
if (data.Rows.Count == 1)
{
return(DataToEnity <userinfo> .DataRowToEntity(data.Rows[0]));
}
return(null);
}
/// <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="UserName"></param>
/// <returns></returns>
public userinfo isHaveThisUserName(string UserName)
{
MySqlParameter[] mySqlParameter = { new MySqlParameter("@username", UserName) };
string sql = @"SELECT username,id,nicheng,zhuceshijian,xiugaishijian,touxiangurl FROM boke.userinfo where username=@username and isdel=0";
DataTable dt = MySqlHelpers.ExecuteQuery(sql, mySqlParameter);
if (dt.Rows.Count == 1)
{
return(DataToEnity <userinfo> .DataRowToEntity(dt.Rows[0]));
}
else
{
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>
/// 获取指定评论的子评论
/// </summary>
/// <param name="punlunid"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public Result <List <wenzhangpinglunsonkuozhan> > GetWenzhangpinglunsons(int punlunid, List <int> arelarr, out List <int> arr, int page = 0, int pagecount = 5)
{
int start = page * pagecount;
int end = start + pagecount;
Result <List <wenzhangpinglunsonkuozhan> > list = new Result <List <wenzhangpinglunsonkuozhan> >();
UserinfoDAL udl = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@pinglunid", punlunid), new MySqlParameter("@start", start), new MySqlParameter("@end", end) };
DataTable pinglunsondt = udl.testlogin("select id,pinglunid,pinglunrenid,pinglunneirong,pinglunshijian,huifurenid,dianzanshu from boke.wenzhangpinglunson " +
"where pinglunid=@pinglunid and isdel=0 order by pinglunshijian limit @start,@end", mySqlParameter);
arr = arelarr;
if (pinglunsondt.Rows.Count > 0)
{
List <wenzhangpinglunsonkuozhan> wezsonlist = new List <wenzhangpinglunsonkuozhan>();
foreach (DataRow item in pinglunsondt.Rows)
{
wenzhangpinglunsonkuozhan wzkz = DataToEnity <wenzhangpinglunsonkuozhan> .DataRowToEntity(item);
if (arr == null || arr.IndexOf(wzkz.pinglunrenid) == -1)
{
arr.Add(wzkz.pinglunrenid);
}
if (arr == null || arr.IndexOf(wzkz.huifurenid) == -1)
{
arr.Add(wzkz.huifurenid);
}
wezsonlist.Add(wzkz);
}
list.content = wezsonlist;
list.count = Convert.ToInt32(udl.testlogin("select count(1) from boke.wenzhangpinglunson where pinglunid=@pinglunid and isdel=0", mySqlParameter).Rows[0][0]);
list.issuf = true;
list.msg = end.ToString();
return(list);
}
list.issuf = false;
list.msg = "无信息可看";
list.count = 0;
return(list);
}
/// <summary>
/// 获取指定文章id的评论
/// </summary>
/// <param name="wenzhangid"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public Result <List <allwenzhengpinglun> > GetAllwenzhengpingluns(int wenzhangid, out List <int> arr, int page = 0, int pagecount = 20)
{
int start = page * pagecount;
int end = start + pagecount;
Result <List <allwenzhengpinglun> > list = new Result <List <allwenzhengpinglun> >();
UserinfoDAL udl = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@wenzhangid", wenzhangid), new MySqlParameter("@start", start), new MySqlParameter("@end", end) };
DataTable pinglundt = udl.testlogin("select id,wenzhangid,pinglunneirong,pinglunrenid,pinglunshijian,dianzanshu from boke.wenzhangpinglun" +
" where wenzhangid=@wenzhangid and isdel=0 order by pinglunshijian desc limit @start,@end", mySqlParameter);
arr = new List <int>();
if (pinglundt.Rows.Count > 0)
{
List <allwenzhengpinglun> wzllist = new List <allwenzhengpinglun>();
foreach (DataRow item in pinglundt.Rows)
{
// allwenzhengpinglun azpl = new allwenzhengpinglun();
allwenzhengpinglun azpl = DataToEnity <allwenzhengpinglun> .DataRowToEntity(item);
//azpl.wenzhangid = wzl.wenzhangid;
//azpl
if (arr == null || arr.IndexOf(azpl.pinglunrenid) == -1)
{
arr.Add(azpl.pinglunrenid);
}
azpl.wenzhangpinglunsonlist = GetWenzhangpinglunsons(azpl.id, arr, out arr);
wzllist.Add(azpl);
}
list.content = wzllist;
list.count = Convert.ToInt32(udl.testlogin("select count(1) from boke.wenzhangpinglun where wenzhangid=@wenzhangid and isdel=0", mySqlParameter).Rows[0][0]);
list.issuf = true;
list.msg = end.ToString();
return(list);
}
list.issuf = false;
list.msg = "无信息可看";
list.count = 0;
return(list);
}
/// <summary>
/// 获取用户文章分类
/// </summary>
/// <param name="uif"></param>
/// <returns></returns>
public List <userwenzhangleixingkuozhan> Getuserwenzhang(string id)
{
UserinfoDAL ud = new UserinfoDAL();
MySqlParameter[] mySqlParameter = { new MySqlParameter("@userid", id) };
var data = ud.testlogin(@"SELECT id, userid, leixingming FROM boke.userwenzhangleixing where userid=@userid", mySqlParameter);
//if (data.Rows.Count == 0) return null ;
List <userwenzhangleixingkuozhan> list = new List <userwenzhangleixingkuozhan>();
foreach (DataRow item in data.Rows)
{
var row = DataToEnity <userwenzhangleixingkuozhan> .DataRowToEntity(item);
MySqlParameter[] leixingmySqlParameter = { new MySqlParameter("@userid", id), new MySqlParameter("@leixing", row.id) };
row.count = Convert.ToInt32(ud.testlogin(@"SELECT count(id) FROM boke.userwenzhang where leixing=@leixing and userid=@userid and isdel=false", leixingmySqlParameter).Rows[0][0]);
list.Add(row);
}
return(list);
}
/// <summary>
/// 根据id获取用户信息
/// </summary>
/// <param name="useridlist">用户id列表</param>
/// <returns></returns>
public List <userinfo> GetUserinfos(List <int> useridlist)
{
UserinfoDAL uid = new UserinfoDAL();
string userliststr = "";
if (useridlist.Count > 0)
{
foreach (var item in useridlist)
{
userliststr += item + ",";
}
}
else
{
userliststr = "0";
}
userliststr = userliststr.Trim(',');
string sql = string.Format("select username,id, nicheng,zhuceshijian, xiugaishijian, touxiangurl from boke.userinfo where id in({0}) and isdel=0", userliststr);
MySqlParameter[] mySqlParameter = { new MySqlParameter("@null", "null") };
DataTable dt = uid.testlogin(sql, mySqlParameter);
if (dt.Rows.Count > 0)
{
List <userinfo> list = new List <userinfo>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
list.Add(DataToEnity <userinfo> .DataRowToEntity(item));
}
}
return(list);
}
return(null);
}
/// <summary>
/// 获取文章列表
/// </summary>
/// <param name="id"></param>
/// <param name="wenzhangleixing"></param>
/// <param name="desc">是否倒序</param>
/// <param name="pagestart"></param>
/// <param name="pagecount"></param>
/// <param name="datetimesta"></param>
/// <param name="datetimeend"></param>
/// <returns></returns>
public List <userwenzhangkuozhan> Getuserwenzhanglist(string id, string wenzhangleixing = "-1", string keyword = "", int pagestart = 0, int pagecount = 20, string desc = "asc", string paixuziduan = "zhuceshijian", string datetimesta = "-1", string datetimeend = "-1")
{
List <userwenzhangkuozhan> list = new List <userwenzhangkuozhan>();
UserinfoDAL ud = new UserinfoDAL();
DataTable data = new DataTable();
int toal = 0;
int start = pagestart * pagecount;
DateTime dtsta = DateTime.Parse("1970-01-01");
DateTime dtend = DateTime.Now;
if (datetimesta != "-1")
{
dtsta = DateTime.Parse(datetimesta);
}
if (datetimeend != "-1")
{
dtend = DateTime.Parse(datetimeend);
}
string key = "";
if (string.IsNullOrEmpty(keyword) || keyword == "-1")
{
key = ".{1}";
}
else
{
for (int i = 0; i < keyword.Length; i++)
{
if (Regex.IsMatch(keyword[i].ToString(), "[a-z|A-Z]"))
{
key += keyword[i];
continue;
}
key += keyword[i] + ".{0,8}";
}
}
if (wenzhangleixing == "-1")
{
MySqlParameter[] mySqlParameter = { new MySqlParameter("@userid", id), new MySqlParameter("@pagestart", start), new MySqlParameter("@pagecount", pagecount), new MySqlParameter("@zhuceshijiansta", dtsta), new MySqlParameter("@zhuceshijianend", dtend), new MySqlParameter("@content", key) };
data = ud.testlogin(String.Format("SELECT id, leixing, userid, content100, zhuceshijian, xiugaishijian, dianjiliang, wenzhangname FROM boke.userwenzhang where userid=@userid and zhuceshijian>@zhuceshijiansta and zhuceshijian<@zhuceshijianend and isdel=false and content regexp @content order by {0} {1} limit @pagestart,@pagecount", paixuziduan, desc), mySqlParameter);
toal = Convert.ToInt32(ud.testlogin(@"SELECT count(id) as toal FROM boke.userwenzhang where userid=@userid and zhuceshijian>@zhuceshijiansta and zhuceshijian<@zhuceshijianend and isdel=false and content regexp @content", mySqlParameter).Rows[0][0]);
}
else
{
MySqlParameter[] mySqlParameter = { new MySqlParameter("@userid", id), new MySqlParameter("@leixing", wenzhangleixing), new MySqlParameter("@pagestart", start), new MySqlParameter("@pagecount", pagecount), new MySqlParameter("@zhuceshijiansta", dtsta), new MySqlParameter("@zhuceshijianend", dtend), new MySqlParameter("@content", key) };
data = ud.testlogin(String.Format("SELECT id, leixing, userid, content100, zhuceshijian, xiugaishijian, dianjiliang, wenzhangname FROM boke.userwenzhang where leixing=@leixing and userid=@userid and zhuceshijian>@zhuceshijiansta and zhuceshijian<@zhuceshijianend and isdel=false and content regexp @content order by {0} {1} limit @pagestart,@pagecount", paixuziduan, desc), mySqlParameter);
toal = Convert.ToInt32(ud.testlogin(@"SELECT count(id) as toal FROM boke.userwenzhang where leixing=@leixing and userid=@userid and zhuceshijian>@zhuceshijiansta and zhuceshijian<@zhuceshijianend and isdel=false and content regexp @content", mySqlParameter).Rows[0][0]);
}
var leixinglist = Getuserwenzhang(id);;
foreach (DataRow item in data.Rows)
{
var row = DataToEnity <userwenzhangkuozhan> .DataRowToEntity(item);
MySqlParameter[] mySqlParameter = { new MySqlParameter("@wenzhangid", row.id) };
row.pingluntiaoshu = Convert.ToInt32(ud.testlogin(@"SELECT count(id) as toal FROM boke.wenzhangpinglun where wenzhangid=@wenzhangid and isdel=0", mySqlParameter).Rows[0][0]);
var leixingming = leixinglist.Where(u => u.id == row.leixing).ToList();
row.leixingming = "未设主题";
if (leixingming != null && leixingming.Count == 1)
{
row.leixingming = leixingming[0].leixingming;
}
list.Add(row);
}
if (list.Count > 0)
{
list[0].toal = toal;
list[0].count = list.Count;
}
else
{
list.Add(new userwenzhangkuozhan()
{
toal = toal, count = 0
});
}
return(list);
}
