/// <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;
}
