/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
public ActionResult index(string key = "", string type = "", int page = 1)
{
// 查询八字简批的关键字段
using (WeiQingEntities db = new WeiQingEntities())
{
#region 搜索入口, 搜索帖子和预测内容
if (type != null && type.Length > 0 && key != null && key.Length > 0)
{
switch (type)
{
// 搜索预测文章
case "ycls":
var yc = db.bazijianpi.Where(x => x.state == 1 && (x.bazi.Contains(key) || x.born_place.Contains(key) || x.name.Contains(key))).OrderByDescending(x => x.addtime).Take(12).ToList();
ViewData["baziList"] = yc; // 搜索预测历史
break;
default:
return(Redirect("/index/index"));
}
}
else
{
#region 搜索默认
var yc = db.bazijianpi.Where(x => x.state == 1).OrderByDescending(x => x.addtime).Take(12).ToList();
ViewData["baziList"] = yc; // 默认显示的预测历史
#endregion
}
#endregion
// 判断预测的文章数量,是否显示更多按钮,打开列表页
var ycCount = db.bazijianpi.Where(x => x.state == 1).Count();
ViewData["ycCount"] = ycCount;
}
return(View());
}
/// <summary>
/// 查看帖子详情,一次显示12条
/// </summary>
/// <param name="id">帖子表的外键tid (title表的主键)</param>
/// <param name="page">页码</param>
/// <returns></returns>
public ActionResult tiezi(int id = 0, int page = 1)
{
if (id > 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var title = (from t in db.title join us in db.user on t.uid equals us.id where t.id == id && t.state == 1 select new TitleExt()
{
uname = us.nick_name, id = t.id, addtime = t.addtime, art_title = t.art_title, keywords = t.keywords, state = t.state, uid = t.uid
}).FirstOrDefault();
ViewData["title"] = title; // 获取帖子标题
ViewData["tid"] = title.id; // 回帖需要用的参数
var q = (from tit in db.title join tz in db.tiezi on tit.id equals tz.tid where tz.state == 1 && tit.state == 1 && tz.tid == id orderby tz.id select new TieZiExt()
{
id = tz.id, addtime = tz.addtime, content = tz.content, floor = tz.floor, state = tz.state, tid = tz.tid, uid = tz.uid, uname = tz.uname
});
// ViewData["sql"] = q.ToString();
var p = new EFPaging <TieZiExt>();
var tzList = p.getPageList(q, "/index/tiezi/" + id, page, 12); // 获取帖子内容列表, 再获取回复内容列表
if (tzList != null && tzList.Count > 0)
{
foreach (var item in tzList)
{
var replyList = (from tz in db.tiezi join rep in db.tzreply on tz.id equals rep.tzid where tz.state == 1 && rep.state == 1 && rep.tzid == item.id orderby rep.id select rep).ToList();
item.replyList = replyList; // 根据帖子内容的id获取回复的内容列表
}
}
ViewData["tzList"] = tzList;
ViewData["url"] = p.pageUrl;
}
}
return(View());
}
public ActionResult tzReply(tzreply model)
{
if (model != null && model.tzid > 0)
{
reflectModel.setValues(model);
if (model.content.Length == 0)
{
return(Content("-2")); // 用户没有正确输入内容
}
var u = (user)Session["user"];
model.uid = (int)u.id;
model.addtime = DateTime.Now;
model.state = 1; // 显示,被举报之后可能会屏蔽
model.uname = u.nick_name;
using (WeiQingEntities db = new WeiQingEntities())
{
var tzuid = db.tiezi.Where(x => x.id == model.tzid).Select(x => x.uid).FirstOrDefault(); // 回复的帖子的uid
if (tzuid == u.id)
{
return(Content("不能回复自己的内容哦,请在底部发布内容"));
}
db.tzreply.Add(model);
return(Content(db.SaveChanges().ToString()));
}
}
return(Content("-1"));
}
/// <summary>
/// 显示管理员的后台页面
/// </summary>
/// <returns></returns>
public ActionResult index(string key = "", int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var efp = new EFPaging <bazijianpi>();
if (key != null && key.Length > 0)
{
var bl = (from q in db.bazijianpi
where (q.name.Contains(key) || q.born_place.Contains(key) || q.bazi.Contains(key))
orderby q.state, q.addtime
select q); // 优先查看待简批的八字
ViewData["baziList"] = efp.getPageList(bl, "/admin/index", page, 10);
ViewData["url"] = efp.pageUrl;
}
else
{
var bl = (from q in db.bazijianpi
orderby q.state, q.addtime
select q); // 优先查看待简批的八字
ViewData["baziList"] = efp.getPageList(bl, "/admin/index", page, 10);
ViewData["url"] = efp.pageUrl;
}
var notice = db.notice.OrderByDescending(x => x.addtime).FirstOrDefault();
ViewData["notice"] = notice;
}
return(View());
}
public ActionResult adminLogin(user u)
{
if (u != null)
{
// 查询用户的数据,判断权限
reflectModel.setValues(u);
if (u.nick_name.Length > 0 && u.pwd.Length > 0)
{
u.pwd = HashTools.SHA1_Hash(u.pwd);
using (WeiQingEntities db = new WeiQingEntities())
{
var user = db.user.Where(x => (x.nick_name.Equals(u.nick_name) || x.email.Equals(u.nick_name)) && x.pwd.Equals(u.pwd) && x.state == 1).FirstOrDefault();
if (user != null && user.is_admin && user.id > 0)
{
Session["user"] = user;
string ip = Tools.GetRealIP();
login_log log = new login_log()
{
uid = (int)user.id, login_ip = ip, login_time = DateTime.Now
};
db.login_log.Add(log);
db.SaveChanges();
return(Content("1"));
}
}
}
return(Content("-2"));
}
return(Content("-1"));
}
/// <summary>
/// 密码默认初始化为666666
/// </summary>
/// <param name="name">用户名</param>
/// <returns></returns>
public ActionResult resetUserPwd(string name = "", int id = 0, string newpwd = "")
{
var state = System.Configuration.ConfigurationManager.AppSettings["InitPwd"];
if ("1".Equals(state))
{
using (WeiQingEntities db = new WeiQingEntities())
{
if (id > 0)
{
var u = db.user.Where(x => x.id == id).FirstOrDefault();
if (u != null && u.id > 0)
{
if (newpwd != null && newpwd.Length >= 6)
{
u.pwd = HashTools.SHA1_Hash(newpwd);
}
else
{
u.pwd = HashTools.SHA1_Hash("666666");
}
int res = db.SaveChanges();
if (res > 0 && string.IsNullOrEmpty(newpwd))
{
return(Content("<script>alert('初始化密码成功,密码为666666,请立即修改密码')</script>"));
}
else if (res > 0)
{
return(Content("<script>alert('初始化密码成功,密码为" + newpwd + " ,请立即修改密码')</script>"));
}
}
}
if (name != null && name.Length > 0)
{
var u = db.user.Where(x => x.nick_name.Equals(name)).FirstOrDefault();
if (u != null && u.id > 0)
{
if (newpwd != null && newpwd.Length >= 6)
{
u.pwd = HashTools.SHA1_Hash(newpwd);
}
else
{
u.pwd = HashTools.SHA1_Hash("666666");
}
int res = db.SaveChanges();
if (res > 0 && string.IsNullOrEmpty(newpwd))
{
return(Content("<script>alert('初始化密码成功,密码为666666,请立即修改密码')</script>"));
}
else if (res > 0)
{
return(Content("<script>alert('初始化密码成功,密码为" + newpwd + " ,请立即修改密码')</script>"));
}
}
}
}
}
return(Content("设置失败,请检查是否在应用程序设置中开启了此接口,或者已设置为初始密码"));
}
/// <summary>
/// 八字简批上传的八字
/// </summary>
/// <returns></returns>
public ActionResult BaZiJianPi(bazijianpi model)
{
if (model != null)
{
if (model.born_date == DateTime.MinValue)
{
return(Content("出生时间参数错误"));
}
try
{
reflectModel.setValues(model, false);
using (WeiQingEntities db = new WeiQingEntities())
{
model.addtime = DateTime.Now;
db.bazijianpi.Add(model);
int res = db.SaveChanges();
if (res > 0)
{
var t1 = model.addtime.Date;
var count = db.bazijianpi.Where(p => p.addtime > t1).Count();
return(Content(string.Format("提交成功,您前面还有{0}位求测者,请耐心等待", count - 1)));
}
}
}
catch (Exception ex)
{
return(Content("后台出现错误:" + ex.Message));
}
}
return(Content("参数错误"));
}
public ActionResult updatePwd(UserExt u)
{
if (u != null)
{
reflectModel.setValues(u);
if (u.nick_name.Length >= 3 && u.pwd.Length >= 6 && u.newpwd.Length >= 6 && !u.pwd.Equals(u.newpwd))
{
try
{
string old_hash_pwd = HashTools.SHA1_Hash(u.pwd); // 旧的hash密码
using (WeiQingEntities db = new WeiQingEntities())
{
var user = db.user.Where(p => p.nick_name.Equals(u.nick_name) && p.pwd.Equals(old_hash_pwd)).FirstOrDefault();
if (user != null && u.nick_name.Equals(user.nick_name))
{
user.pwd = HashTools.SHA1_Hash(u.newpwd);
int res = db.SaveChanges(); // 修改密码
if (res > 0)
{
Session["user"] = null;
}
return(Content(res.ToString()));
}
return(Content("旧密码不正确"));
}
}
catch (Exception ex)
{
return(Content("后台出现错误"));
}
}
return(Content("修改失败"));
}
return(Content("参数错误"));
}
/// <summary>
/// PC版模板页获取最新的10条留言板内容
/// </summary>
/// <returns></returns>
public static List <liuyanban> getLybList()
{
using (WeiQingEntities db = new WeiQingEntities())
{
return(db.liuyanban.Where(x => x.state == 1).OrderByDescending(x => x.addtime).Take(10).ToList());
}
}
public ActionResult jubao_sub(tiezi_jubao model)
{
if (model != null && model.tzid > 0 && model.reason != null)
{
model.addtime = DateTime.Now;
model.ip = Tools.GetRealIP();
model.state = 0;
using (WeiQingEntities db = new WeiQingEntities())
{
var t1 = DateTime.Now.Date;
var ipCount = db.tiezi_jubao.Where(x => x.addtime > t1 && x.ip.Equals(model.ip)).Count();
if (ipCount >= 10)
{
return(Content("-1"));
}
var count = db.tiezi_jubao.Where(x => x.tzid == model.tzid).Count(); // 此帖子是否已经举报过
if (count > 0)
{
return(Content("2"));
}
db.tiezi_jubao.Add(model);
return(Content(db.SaveChanges().ToString()));
}
}
return(Content("-1"));
}
/// <summary>
/// 模板页获取show=true的公告
/// </summary>
/// <returns></returns>
public static notice getNotice()
{
using (WeiQingEntities db = new WeiQingEntities())
{
var notice = db.notice.Where(x => x.show == true).OrderByDescending(x => x.addtime).FirstOrDefault();
return(notice);
}
}
public ActionResult getPwd(user u)
{
if (u != null)
{
reflectModel.setValues(u);
if (u.nick_name.Length >= 3 && Tools.IsEmail(u.email))
{
try
{
using (WeiQingEntities db = new WeiQingEntities())
{
var user = db.user.Where(p => p.nick_name.Equals(u.nick_name) && p.email.Equals(u.email)).FirstOrDefault();
// 检查用户名和邮箱是否匹配
if (user != null && u.nick_name.Equals(user.nick_name))
{
DateTime dt = DateTime.Now;
string ip = Tools.GetRealIP(); // 获取客户端ip
// 检查当前 uid 一周之内是否已经找回过密码, 同一个ip一天之内之内找回3次密码
var t1 = dt.AddDays(-7);
var gpl_uid = db.getpwdlog.Where(p => p.uid == user.id && p.log_time > t1).Count();
if (gpl_uid > 0)
{
return(Content("一个星期之内只能找回一次密码"));
}
var t2 = dt.AddHours(-24);
var gpl_ip = db.getpwdlog.Where(p => p.ip_address.Equals(ip) && p.log_time > t2).Count();
if (gpl_ip >= 3)
{
return(Content("同一个ip地址一天之内只能找回3次密码"));
}
string newpwd = Tools.getRandomStr();
string res = Tools.SendEmail(u.email, "您的密码是:" + newpwd); // 失败返回错误信息
if ("发送成功".Equals(res))
{
var chPwdLog = new getpwdlog()
{
uid = (Int32)user.id, ip_address = ip, nick_name = user.nick_name, log_time = dt
};
db.getpwdlog.Add(chPwdLog); // 修改密码的日志
user.pwd = HashTools.SHA1_Hash(newpwd);
db.SaveChanges(); // 修改密码
}
return(Content(res));
}
return(Content("用户名或者邮箱不正确"));
}
}
catch (Exception ex)
{
return(Content("后台出现错误:" + ex.Message));
}
}
}
return(Content("参数错误"));
}
/// <summary>
/// 帖子管理, 显示帖子列表视图页
/// </summary>
/// <param name="key"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult tieziList(string key = "", int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
if (key != null && key.Length > 0)
{
var q = from t in db.title
join u in db.user on t.uid equals u.id
where t.art_title.Contains(key) || t.keywords.Contains(key)
orderby t.top descending, t.sort ascending, t.state descending, t.addtime descending
select new TitleUserExt()
{
id = t.id,
addtime = t.addtime,
art_title = t.art_title,
keywords = t.keywords,
nick_name = u.nick_name,
sort = t.sort,
state = t.state,
top = t.top,
uid = t.uid
};
// var q = db.title.Where(x => x.art_title.Contains(key) || x.keywords.Contains(key)).OrderByDescending(x => x.top).ThenBy(x => x.sort).ThenBy(x => x.state).ThenByDescending(x => x.addtime);
var p = new EFPaging <TitleUserExt>();
var tlist = p.getPageList(q, "/admin/tieziList", page, 20);
ViewData["tlist"] = tlist;
ViewData["url"] = p.pageUrl;
return(View());
}
else
{
var q = from t in db.title
join u in db.user on t.uid equals u.id
orderby t.top descending, t.sort ascending, t.state descending, t.addtime descending
select new TitleUserExt()
{
id = t.id,
addtime = t.addtime,
art_title = t.art_title,
keywords = t.keywords,
nick_name = u.nick_name,
sort = t.sort,
state = t.state,
top = t.top,
uid = t.uid
};
// var q = db.title.OrderByDescending(x => x.top).ThenBy(x => x.sort).ThenBy(x => x.state).ThenByDescending(x => x.addtime);
var p = new EFPaging <TitleUserExt>();
var tlist = p.getPageList(q, "/admin/tieziList", page, 20);
ViewData["tlist"] = tlist;
ViewData["url"] = p.pageUrl;
}
}
return(View());
}
public ActionResult addTitle(TitleExt model)
{
if (model != null)
{
reflectModel.setValues(model);
int res = 0;
DateTime dt = DateTime.Now;
try
{
var u = (user)Session["user"];
title t = new title()
{
uid = u.id, addtime = dt, art_title = model.art_title, keywords = model.keywords, state = 1, sort = 100, top = false
};
TransactionOptions transOpt = new TransactionOptions();
//设置事务隔离级别
transOpt.IsolationLevel = IsolationLevel.ReadCommitted;
// 设置事务超时时间为60秒
transOpt.Timeout = new TimeSpan(0, 0, 60);
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, transOpt))
{
using (WeiQingEntities db = new WeiQingEntities())
{
db.title.Add(t);
res = db.SaveChanges(); // 保存帖子标题
if (res > 0)
{
var tid = db.title.Where(x => x.uid == u.id).Max(x => x.id);
tiezi tz = new tiezi()
{
tid = tid, addtime = dt, uid = u.id, content = model.content, floor = 1, state = 1, uname = u.nick_name
};
db.tiezi.Add(tz);
res = db.SaveChanges(); // 保存帖子的内容,一楼
if (res > 0)
{
scope.Complete();
return(Content(res.ToString()));
}
}
}
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
return(Content("0"));
}
/// <summary>
/// 模板页获取可以显示的文章列表,按时间倒序,只取前10条
/// </summary>
/// <returns></returns>
public static List <article> getArtList()
{
using (WeiQingEntities db = new WeiQingEntities())
{
var list = db.article.Where(x => x.state == 1).OrderByDescending(x => x.addtime).Take(10).ToList();
if (list == null)
{
return(new List <article>());
}
return(list);
}
}
/// <summary>
/// 审批列表页
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult jubaoshenpi(int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var q = from t in db.tiezi_jubao orderby t.state, t.addtime select t;
var p = new EFPaging <tiezi_jubao>();
var list = p.getPageList(q, "/admin/jubaoshenpi", page, 20);
ViewData["list"] = list;
ViewData["url"] = p.pageUrl;
}
return(View());
}
/// <summary>
/// 根据时间逆序分页显示留言板的内容
/// </summary>
/// <returns></returns>
public ActionResult liuyanList(int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var q = db.liuyanban.OrderByDescending(x => x.state).ThenByDescending(x => x.addtime);
var p = new EFPaging <liuyanban>();
var list = p.getPageList(q, "/admin/liuyanList", page, 20);
ViewData["list"] = list;
ViewData["url"] = p.pageUrl;
}
return(View());
}
/// <summary>
/// 分页查看帖子列表
/// </summary>
/// <returns></returns>
public ActionResult titleList(string key = "", int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
if (key != null && key.Length > 0)
{
var q1 = from t in db.title
join u in db.user on t.uid equals u.id
where t.state == 1 && (t.art_title.Contains(key) || t.keywords.Contains(key))
orderby t.top descending, t.sort ascending, t.state descending, t.addtime descending
select new EFDao.EntityExt.TitleUserExt()
{
addtime = t.addtime,
art_title = t.art_title,
id = t.id,
keywords = t.keywords,
nick_name = u.nick_name,
state = t.state,
uid = t.uid
};
var p = new EFPaging <EFDao.EntityExt.TitleUserExt>();
ViewData["list"] = p.getPageList(q1, "/index/titleList", page, 20);
ViewData["url"] = p.pageUrl;
return(View());
}
else
{
var q1 = from t in db.title
join u in db.user on t.uid equals u.id
where t.state == 1
orderby t.top descending, t.sort ascending, t.state descending, t.addtime descending
select new EFDao.EntityExt.TitleUserExt()
{
addtime = t.addtime,
art_title = t.art_title,
id = t.id,
keywords = t.keywords,
nick_name = u.nick_name,
state = t.state,
uid = t.uid
};
var p = new EFPaging <EFDao.EntityExt.TitleUserExt>();
ViewData["list"] = p.getPageList(q1, "/index/titleList", page, 20);
ViewData["url"] = p.pageUrl;
return(View());
}
}
}
/// <summary>
/// 修改留言内容的状态
/// </summary>
/// <param name="id">主键</param>
/// <param name="state">设定的状态值</param>
/// <returns></returns>
public ActionResult liuyanState(int id = 0, int state = -1)
{
if (id > 0 && state >= 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var m = db.liuyanban.Where(x => x.id == id).FirstOrDefault();
if (m != null && m.id > 0)
{
m.state = state;
return(Content(db.SaveChanges().ToString()));
}
}
}
return(Content("0"));
}
/// <summary>
/// 八字简批
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult bzjp(int id = 0)
{
if (id > 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var m = db.bazijianpi.Where(x => x.id == id).FirstOrDefault();
if (m != null && m.id > 0)
{
ViewData["m"] = m;
return(View());
}
}
}
return(Redirect("/index/index"));
}
/// <summary>
/// 显示指定用户的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult user_edit(int id = 0)
{
if (id > 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var u = db.user.Where(x => x.id == id).FirstOrDefault();
if (u != null && u.id > 0)
{
ViewData["u"] = u;
return(View());
}
}
}
return(Content("无数据,没有找到指定用户的资料"));
}
/// <summary>
/// 帖子审批
/// </summary>
/// <param name="model"></param>
/// <param name="jbid">举报表的主键</param>
/// <returns></returns>
public ActionResult shenPiTieZi(TieZiExt model, int jbid = 0)
{
if (model != null && model.id > 0 && jbid > 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
int res = 0;
var t = db.tiezi.Where(x => x.id == model.id).FirstOrDefault();
if (t != null && t.id > 0)
{
t.state = model.state;
if (model.replyList != null && model.replyList.Count > 0)
{
var rlist = db.tzreply.Where(x => x.tzid == t.id).ToList(); // 获取帖子的回复列表
if (rlist != null && rlist.Count > 0)
{
var tempdic = model.replyList.ToDictionary(x => x.id);
foreach (var item in rlist)
{
if (tempdic.ContainsKey(item.id))
{
item.state = tempdic[item.id].state;
}
}
res += EfExt.UpdateMany(rlist);
}
}
var jb = db.tiezi_jubao.Where(x => x.id == jbid).FirstOrDefault();
if (jb != null && jb.id > 0 && jb.tzid == t.id)
{
jb.state = 1; // 已审批
res += db.SaveChanges();
if (res > 0)
{
return(Content("审核成功"));
}
return(Content("审核失败"));
}
}
}
}
return(Content("参数错误"));
}
/// <summary>
/// 管理员更新帖子的设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult editTitle(title model)
{
if (model != null && model.id > 0 && model.sort <= 100 && model.sort >= 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var m = db.title.Where(x => x.id == model.id).FirstOrDefault();
if (m != null && m.id > 0)
{
m.top = model.top;
m.sort = model.sort;
m.state = model.state;
return(Content(db.SaveChanges().ToString()));
}
}
}
return(Content("修改失败"));
}
public ActionResult login(user u)
{
if (u != null)
{
reflectModel.setValues(u);
if (u.nick_name.Length >= 3 && u.pwd.Length >= 6)
{
u.pwd = HashTools.SHA1_Hash(u.pwd);
try
{
using (WeiQingEntities db = new WeiQingEntities())
{
var user = db.user.Where(p => (p.nick_name.Equals(u.nick_name) || p.email.Equals(u.nick_name)) &&
p.pwd.Equals(u.pwd)).FirstOrDefault();
if (user != null && (user.nick_name.Equals(u.nick_name) || user.email.Equals(u.nick_name)))
{
// 检查用户是否禁止登录,并且判断是否为管理员
if (user.state == 0)
{
return(Content("你的账号被禁止登录"));
}
string ip = Tools.GetRealIP();
login_log log = new login_log()
{
uid = (int)user.id, login_ip = ip, login_time = DateTime.Now
};
db.login_log.Add(log);
db.SaveChanges();
Session["user"] = user;
return(Content("1"));
}
}
}
catch (Exception ex)
{
return(Content("后台出现错误:" + ex.Message));
}
}
return(Content("用户名和密码不正确"));
}
return(Content("参数错误"));
}
public ActionResult SaveYuCe(bazijianpi model)
{
if (model != null && model.id > 0)
{
reflectModel.setValues(model);
using (WeiQingEntities db = new WeiQingEntities())
{
var jp = db.bazijianpi.Where(x => x.id == model.id).FirstOrDefault();
if (jp != null && jp.id > 0)
{
jp.bazi = model.bazi;
jp.yuce_content = model.yuce_content;
jp.state = model.state;
int res = db.SaveChanges();
return(Content(res.ToString()));
}
}
}
return(Content("-1"));
}
public ActionResult huitie(tiezi model)
{
if (model != null && model.tid > 0 && model.content != null && model.content.Length > 0)
{
model.addtime = DateTime.Now;
var user = (user)Session["user"];
model.uid = user.id;
model.state = 1;
model.uname = user.nick_name;
// 获取楼层
using (WeiQingEntities db = new WeiQingEntities())
{
var floor = db.tiezi.Where(x => x.tid == model.tid).Max(x => x.floor);
model.floor = floor + 1; // 当前楼层加1
db.tiezi.Add(model);
return(Content(db.SaveChanges().ToString()));
}
}
return(Content("-1"));
}
/// <summary>
/// 分页查看文章列表
/// </summary>
/// <param name="key"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult artList(string key = "", int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
if (key != null && key.Length > 0)
{
var q = db.article.Where(x => x.state == 1 && (x.title.Contains(key) || x.keywords.Contains(key))).OrderByDescending(x => x.addtime);
var p = new EFPaging <article>();
ViewData["list"] = p.getPageList(q, "/index/artList", page, 20);
ViewData["url"] = p.pageUrl;
return(View());
}
else
{
var q = db.article.Where(x => x.state == 1).OrderByDescending(x => x.addtime);
var p = new EFPaging <article>();
ViewData["list"] = p.getPageList(q, "/index/artList", page, 20);
ViewData["url"] = p.pageUrl;
}
}
return(View());
}
/// <summary>
/// 审批视图页面
/// </summary>
/// <param name="id">指定楼层的帖子id,主键</param>
/// <returns></returns>
public ActionResult editShenPi(int id = 0, int jbid = 0)
{
if (id > 0)
{
using (WeiQingEntities db = new WeiQingEntities())
{
var t = (from te in db.tiezi where te.id == id select te).FirstOrDefault();
var model = reflectModel.AutoCopyToChild <tiezi, TieZiExt>(t); // 获取当前id的帖子对象
if (model.id > 0)
{
var list = (from r in db.tzreply where r.tzid == model.id select r).ToList();
model.replyList = list;
ViewData["model"] = model;
ViewData["jbid"] = jbid;
if (model != null && model.id > 0)
{
return(View());
}
}
}
}
return(Content("没有数据"));
}
/// <summary>
/// 获取前10条帖子, 置顶->排序->状态(显示优先)->添加时间 逆序
/// </summary>
/// <returns></returns>
public static List <TitleUserExt> getTitleList()
{
using (WeiQingEntities db = new WeiQingEntities())
{
var q = from t in db.title
join u in db.user on t.uid equals u.id
where t.state == 1
orderby t.top descending, t.sort ascending, t.state descending, t.addtime descending
select new TitleUserExt()
{
id = t.id,
addtime = t.addtime,
art_title = t.art_title,
keywords = t.keywords,
nick_name = u.nick_name,
sort = t.sort,
state = t.state,
top = t.top,
uid = t.uid
};
return(q.Take(10).ToList());
}
}
/// <summary>
/// 用户当前论坛注册用户的列表,包括被禁止的用户
/// </summary>
/// <param name="key">查询条件</param>
/// <param name="page">页码</param>
/// <returns></returns>
public ActionResult userList(string key = "", int page = 1)
{
using (WeiQingEntities db = new WeiQingEntities())
{
if (key != null && key.Length > 0)
{
var q = db.user.Where(x => x.nick_name.Contains(key) || x.email.Contains(key) || x.mobile.Contains(key) || x.qq.Contains(key) || x.wei_xin.Contains(key)).OrderByDescending(x => x.is_admin).ThenBy(x => x.state).ThenByDescending(x => x.reg_date);
var p = new EFPaging <user>();
var ulist = p.getPageList(q, "/index/userList", page, 20);
ViewData["ulist"] = ulist;
ViewData["url"] = p.pageUrl;
}
else
{
var q = db.user.OrderByDescending(x => x.is_admin).ThenBy(x => x.state).ThenByDescending(x => x.reg_date);
var p = new EFPaging <user>();
var ulist = p.getPageList(q, "/index/userList", page, 20);
ViewData["ulist"] = ulist;
ViewData["url"] = p.pageUrl;
}
}
return(View());
}
