/// <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="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="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> /// 根据评论子集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="uif"></param> /// <returns></returns> public bool islogin(userinfo uif) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@username", uif.username), new MySqlParameter("@pwd", uif.pwd) }; var data = ud.testlogin(@"SELECT id FROM boke.userinfo where username=@username and pwd=@pwd and isdel=0", mySqlParameter); return(data.Rows.Count == 1); }
/// <summary> /// 获得用户基础信息 /// </summary> /// <param name="uif"></param> /// <returns></returns> public DataTable Getuserinfo(userinfo uif) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@username", uif.username), new MySqlParameter("@pwd", uif.pwd) }; var data = ud.testlogin(@"SELECT username, id, nicheng,touxiangurl FROM boke.userinfo where username=@username and pwd=@pwd and isdel=0", mySqlParameter); return(data); }
/// <summary> /// 判断用户名是否存在 /// </summary> /// <param name="UserName">要判断是否存在的用户名</param> /// <returns></returns> public bool isHaveThisUserName(string UserName) { UserinfoDAL BLL = new UserinfoDAL(); userinfo uif = BLL.isHaveThisUserName(UserName); if (uif == null) { return(false); } return(true); }
public UserInfoController(UserinfoDAL udal, DAL.LiushuiDAL lsdal, DAL.ChongzhiDAL czdal, DAL.TixianDAL txdal, DAL.YugengdanDAL yudal, DAL.QuanxianDAL qxdal, DAL.XiazhuinfoDAL xzdal, DAL.Admin_quanxianDAL admin_qxdal) : base(udal) { this.dal = udal; this.lsdal = lsdal; this.czdal = czdal; this.txdal = txdal; this.yudal = yudal; this.qxdal = qxdal; this.xzdal = xzdal; this.admin_qxdal = admin_qxdal; }
/// <summary> /// 根据评论id子集,判断该评论子集是否该用户所留 /// </summary> /// <param name="userid">用户id</param> /// <param name="pinglunsonid">评论子集id</param> /// <returns></returns> public bool isgaipinglunsonzuoze(int userid, int pinglunsonid) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", pinglunsonid), new MySqlParameter("@pinglunrenid", userid) }; DataTable dataTable = ud.testlogin("select pinglunid from boke.wenzhangpinglunson where id=@id and pinglunrenid=@pinglunrenid and isdel=0", mySqlParameter); if (dataTable.Rows.Count > 0) { return(true); } return(false); }
/// <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="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> /// 添加文章评论 /// </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> /// 根据评论子集id判断该用户是否是该评论的作者 /// </summary> /// <param name="userid">作者id</param> /// <param name="pinglunsonid">要判断的评论子集id</param> /// <returns></returns> public bool iswenzhangzuoze(int userid, int pinglunsonid) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", pinglunsonid), new MySqlParameter("@userid", userid) }; DataTable pingluniddt = ud.testlogin("select pinglunid from boke.wenzhangpinglunson where id=@id", mySqlParameter); if (pingluniddt.Rows.Count < 1) { return(false); } else { int pinglunid = Convert.ToInt32(pingluniddt.Rows[0][0]); return(iswenzhangbelongher(userid, pinglunid)); } }
/// <summary> /// 根据评论id判断用户是否是他的作者 /// </summary> /// <param name="userid">作者id</param> /// <param name="pinglunid">要判断的评论id</param> /// <returns></returns> public bool iswenzhangbelongher(int userid, int pinglunid) { UserinfoDAL ud = new UserinfoDAL(); MySqlParameter[] mySqlParameter = { new MySqlParameter("@id", pinglunid) }; DataTable wenzhangiddt = ud.testlogin("select wenzhangid from boke.wenzhangpinglun where id=@id and isdel=0", mySqlParameter); if (wenzhangiddt.Rows.Count < 1) { return(false); } else { int wenzhangid = Convert.ToInt32(wenzhangiddt.Rows[0][0]); MySqlParameter[] mySqlPa = { new MySqlParameter("@id", wenzhangid), new MySqlParameter("@userid", userid) }; var data = ud.testlogin(@"select id from boke.userwenzhang where id = @id and userid = @userid and isdel=0", mySqlPa); return(data.Rows.Count > 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="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="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); }
/// <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="UserName">要判断是否存在的用户名</param> /// <returns></returns> public userinfo GetThisUserNameInfo(string UserName) { UserinfoDAL BLL = new UserinfoDAL(); return(BLL.isHaveThisUserName(UserName)); }
public XiaZhuInfoController(UserinfoDAL udal, DAL.XiazhuinfoDAL dal, DAL.WanfaDAL wfdal) : base(udal) { this.dal = dal; this.wfdal = wfdal; }
/// <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); }
public QiHaoInfoController(UserinfoDAL udal, DAL.QihaoinfoDAL dal, BLL.BJPK10 pk10bll) : base(udal) { this.dal = dal; this.pk10bll = pk10bll; }
public WanFaController(UserinfoDAL udal, DAL.WanfaDAL dal, DAL.CaizhongDAL czdal) : base(udal) { this.dal = dal; this.czdal = czdal; }