/// <summary>
/// 查询列表
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="searchKey"></param>
/// <returns></returns>
public static Model.Model.PageResult <ht_review> GetReviewList(int page, int rows, ht_review searchKey)
{
Model.Model.PageResult <ht_review> pageModel = new Model.Model.PageResult <ht_review>();
using (Entities db = new Entities())
{
db.Configuration.ProxyCreationEnabled = false;
var data = db.ht_review.Where(p => p.status == 1); //审核才出现
if (!string.IsNullOrWhiteSpace(searchKey.review_type))
{
data = data.Where(p => p.review_type == searchKey.review_type);
}
if (searchKey.news_id != 0)
{
data = data.Where(p => p.news_id == searchKey.news_id);
}
data = data.OrderByDescending(p => p.add_time);
pageModel.list = data.Skip((page - 1) * rows).Take(rows).ToList();
foreach (var item in pageModel.list)
{
item.reply_list = db.ht_review
.Where(p => p.review_id == item.id && p.status == 1 && p.review_type == "reply")
.OrderByDescending(p => p.id).ToList();
}
pageModel.total = data.Count();
}
pageModel.totalpage = (int)Math.Ceiling((decimal)pageModel.total / (decimal)rows);//总页数
return(pageModel);
}
public ActionResult SubscribeNewsList(int subscribe_id, int page = 1, int rows = 5)
{
Model.Model.PageResult <ht_news> pageModel = BLLNews.GetSubscribeNewsListPageResult(page, rows, subscribe_id);
if (Request.IsAjaxRequest())
{
apiResp.status = true;
apiResp.result = pageModel;
return(Json(apiResp));
}
return(View(pageModel));
}
/// <summary>
/// 留言列表
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult ReviewList(int page, int rows, HT.Model.ht_review searchKey)
{
Model.Model.PageResult <Model.ht_review> pageModel = BLLReview.GetReviewList(page, rows, searchKey);
if (Request.IsAjaxRequest())
{
apiResp.status = true;
apiResp.result = pageModel;
return(Json(apiResp));
}
return(View(pageModel));
}
/// <summary>
/// 获取订阅列表
/// </summary>
/// <returns></returns>
public static Model.Model.PageResult <ht_news_subscribe> GetSubscribeListPageResult(int curUserid)
{
Model.Model.PageResult <ht_news_subscribe> pageModel = new Model.Model.PageResult <ht_news_subscribe>();
using (Entities db = new Entities())
{
pageModel.list = db.ht_news_subscribe.Where(p => p.add_userid == curUserid).ToList();
pageModel.total = pageModel.list.Count;
}
pageModel.totalpage = 1;//总页数
return(pageModel);
}
/// <summary>
/// 获取信息列表返回数据
/// </summary>
/// <returns></returns>
public static Model.Model.PageResult <ht_news> GetNewsListPageResult(int page, int rows, ht_news searchKey, bool isRecommend)
{
Model.Model.PageResult <ht_news> pageModel = new Model.Model.PageResult <ht_news>();
using (Entities db = new Entities())
{
pageModel.total = GetNewsData(db, searchKey).Count();
pageModel.list = GetNewsData(db, searchKey, true, isRecommend).Skip((page - 1) * rows).Take(rows).ToList();
}
pageModel.totalpage = (int)Math.Ceiling((decimal)pageModel.total / (decimal)rows);//总页数
return(pageModel);
}
/// <summary>
/// 信息列表
/// </summary>
/// <param name="searchKey"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult BaseNewsList(ht_news searchKey, int page = 1, int rows = 5, bool recommend = false)
{
Model.Model.PageResult <ht_news> pageModel = BLLNews.GetNewsListPageResult(page, rows, searchKey, recommend);
if (Request.IsAjaxRequest())
{
apiResp.status = true;
apiResp.result = pageModel;
return(Json(apiResp));
}
return(View(pageModel));
}
public ActionResult SubscribeList()
{
int curUserid = BLLAuthentication.GetAuthenticationUser().id;
Model.Model.PageResult <ht_news_subscribe> pageModel = BLLNewsSubscribe.GetSubscribeListPageResult(curUserid);
if (Request.IsAjaxRequest())
{
apiResp.status = true;
apiResp.result = pageModel;
return(Json(apiResp));
}
return(View(pageModel));
}
/// <summary>
/// 信息列表
/// </summary>
/// <param name="searchKey"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult BaseNewsList(ht_news searchKey, int page = 1, int rows = 5)
{
var curUserid = BLLAuthentication.GetAuthenticationUser().id;
if (searchKey.isme.HasValue && searchKey.isme.Value)
{
searchKey.add_userid = curUserid; //我的发布
}
Model.Model.PageResult <ht_news> pageModel = BLLNews.GetNewsListPageResult(page, rows, searchKey, curUserid);
if (Request.IsAjaxRequest())
{
apiResp.status = true;
apiResp.result = pageModel;
return(Json(apiResp));
}
return(View(pageModel));
}
/// <summary>
/// 获取订阅信息列表返回数据
/// </summary>
/// <returns></returns>
public static Model.Model.PageResult <ht_news> GetSubscribeNewsListPageResult(int page, int rows, int subscribe_id)
{
Model.Model.PageResult <ht_news> pageModel = new Model.Model.PageResult <ht_news>();
using (Entities db = new Entities())
{
db.Configuration.ProxyCreationEnabled = false;
var data = db.ht_news.Where(p => p.cateid == 1 && p.status == 1).Join(
db.ht_news_subscribe_relation.Where(p => p.subscribe_id == subscribe_id),
x => x.id,
y => y.news_id,
(x, y) => new
{
rel_id = y.id,
islook = y.is_look,
set_top = x.set_top.Value,
news_id = x.id,
news = x
});
pageModel.total = data.Count();
var list = data.OrderBy(p => p.islook)
.ThenByDescending(p => p.set_top)
.Skip((page - 1) * rows).Take(rows).ToList();
if (list.Count > 0)
{
var idList = list.Select(p => p.rel_id).ToList();
//变阅读状态
db.ht_news_subscribe_relation.Where(p => p.is_look == 0 && idList.Contains(p.id)).Update(p => new ht_news_subscribe_relation {
is_look = 1
});
pageModel.list = list.Select(p => p.news).ToList();
}
else
{
pageModel.list = new List <ht_news>();
}
}
pageModel.totalpage = (int)Math.Ceiling((decimal)pageModel.total / (decimal)rows);//总页数
return(pageModel);
}
/// <summary>
/// 获取信息列表返回数据
/// </summary>
/// <returns></returns>
public static Model.Model.PageResult <ht_news> GetNewsListPageResult(int page, int rows, ht_news searchKey, int curUserid)
{
Model.Model.PageResult <ht_news> pageModel = new Model.Model.PageResult <ht_news>();
using (Entities db = new Entities())
{
pageModel.total = GetNewsData(db, searchKey).Count();
pageModel.list = GetNewsData(db, searchKey, true).Skip((page - 1) * rows).Take(rows).ToList();
if (searchKey.add_userid == 0 && curUserid > 0)
{
foreach (var item in pageModel.list)
{
item.is_praise = db.ht_comm_relation.FirstOrDefault(p => p.main_id == item.id.ToString() && p.relation_id == curUserid.ToString() && p.relation_type == "praise") != null;
}
}
}
pageModel.totalpage = (int)Math.Ceiling((decimal)pageModel.total / (decimal)rows);//总页数
return(pageModel);
}