/// <summary> /// 获取提现记录列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="type"></param> /// <returns></returns> public static HT.Model.Model.PageResult <ht_user_money_log> GetUserMoneyLogList(int pageIndex, int pageSize, int type, int?status = null) { HT.Model.Model.PageResult <ht_user_money_log> pageModel = new HT.Model.Model.PageResult <ht_user_money_log>(); using (Entities db = new Entities()) { db.Configuration.ProxyCreationEnabled = false; var userMoneyList = db.ht_user_money_log.Where(r => true); if (type > 0) { userMoneyList = userMoneyList.Where(r => r.type == type); } if (status.HasValue) { userMoneyList = userMoneyList.Where(r => r.status == status); } int total = userMoneyList.Count(); pageModel.totalpage = (int)Math.Ceiling((decimal)total / (decimal)pageSize);//总页数 pageModel.total = total; pageModel.list = userMoneyList.OrderByDescending(p => p.id).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); return(pageModel); } }
/// <summary> /// 获取项目列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="cateId"></param> /// <param name="keyword"></param> /// <returns></returns> public static HT.Model.Model.PageResult <ht_news> GetNewsList(int pageIndex, int pageSize, int cateId, string status, string keyword, string fromDate = "", string toDate = "") { HT.Model.Model.PageResult <ht_news> pageModel = new HT.Model.Model.PageResult <ht_news>(); using (Entities db = new Entities()) { db.Configuration.ProxyCreationEnabled = false; var unDelList = db.ht_news.Where(r => true); if (cateId > 0) { unDelList = unDelList.Where(r => r.cateid == cateId); } if (!string.IsNullOrWhiteSpace(keyword)) { unDelList = unDelList.Where(r => r.title.Contains(keyword.Trim())); } if (!string.IsNullOrWhiteSpace(status)) { int statusInt = int.Parse(status); if (statusInt > 0) { unDelList = unDelList.Where(r => r.status == statusInt); } else { if (statusInt == 0) { unDelList = unDelList.Where(r => r.status == 0 && r.pay_status == 1); } else { unDelList = unDelList.Where(r => r.status == 0 && r.pay_status == 0); } } } if (!string.IsNullOrWhiteSpace(fromDate)) { DateTime dtFrom = DateTime.Parse(fromDate); unDelList = unDelList.Where(r => r.add_time >= dtFrom); } if (!string.IsNullOrWhiteSpace(toDate)) { DateTime dtTo = DateTime.Parse(toDate).AddDays(1).AddSeconds(-1); unDelList = unDelList.Where(r => r.add_time <= dtTo); } int total = unDelList.Count(); pageModel.totalpage = (int)Math.Ceiling((decimal)total / (decimal)pageSize);//总页数 pageModel.total = total; pageModel.list = unDelList.OrderByDescending(p => p.id).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); foreach (var item in pageModel.list) { item.review_s0 = db.ht_review .Where(p => p.news_id == item.id && p.status == 0) .Count(); } } return(pageModel); }
{/// <summary> /// 获取列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="keyword"></param> /// <returns></returns> public static HT.Model.Model.PageResult <ht_user> GetUsersList(int pageIndex, int pageSize, string keyword) { HT.Model.Model.PageResult <ht_user> pageModel = new HT.Model.Model.PageResult <ht_user>(); using (Entities db = new Entities()) { db.Configuration.ProxyCreationEnabled = false; var unDelList = db.ht_user.Where(r => true); unDelList = unDelList.Where(p => p.isdelete == 0); if (!string.IsNullOrWhiteSpace(keyword)) { unDelList = unDelList.Where(r => r.mobile.Contains(keyword.Trim()) || r.nickname.Contains(keyword.Trim())); } int total = unDelList.Count(); pageModel.totalpage = (int)Math.Ceiling((decimal)total / (decimal)pageSize);//总页数 pageModel.total = total; pageModel.list = unDelList.OrderByDescending(p => p.id).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); return(pageModel); } }
/// <summary> /// 获取列表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="type"></param> /// <param name="keyword"></param> /// <returns></returns> public static HT.Model.Model.PageResult <ht_review> GetReviewsList(int pageIndex, int pageSize, string news_id, string type, string status, string keyword, string review_id) { HT.Model.Model.PageResult <ht_review> pageModel = new HT.Model.Model.PageResult <ht_review>(); using (Entities db = new Entities()) { db.Configuration.ProxyCreationEnabled = false; var unDelList = db.ht_review.Where(r => true); if (!string.IsNullOrWhiteSpace(news_id)) { int newsid = int.Parse(news_id); unDelList = unDelList.Where(r => r.news_id == newsid); } if (!string.IsNullOrWhiteSpace(type) && type != "all") { unDelList = unDelList.Where(r => r.review_type == type); } if (!string.IsNullOrWhiteSpace(keyword)) { unDelList = unDelList.Where(r => r.nickname == keyword || r.review_content.StartsWith(keyword)); } if (!string.IsNullOrWhiteSpace(status)) { int statusInt = int.Parse(status); unDelList = unDelList.Where(r => r.status == statusInt); } if (!string.IsNullOrWhiteSpace(review_id)) { int review_id_num = Convert.ToInt32(review_id); unDelList = unDelList.Where(r => r.review_id == review_id_num); } int total = unDelList.Count(); pageModel.totalpage = (int)Math.Ceiling((decimal)total / (decimal)pageSize);//总页数 pageModel.total = total; pageModel.list = unDelList.OrderBy(p => p.status).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); if (type == "all") { foreach (var item in pageModel.list) { if (item.review_type == "reply") { var pr = db.ht_review.Find(item.review_id); if (pr != null) { item.parent_content = pr.review_content; } } else if (item.review_type == "comment") { var pn = db.ht_news.Find(item.news_id); if (pn == null) { continue; } if (pn.cateid == 1 || pn.cateid == 2) { item.parent_content = BLLNews.GetCity(pn.start_city, pn.start_district, pn.start_province) + "→" + BLLNews.GetCity(pn.stop_city, pn.stop_district, pn.stop_province); } else { item.parent_content = pn.add_nickname + " " + pn.cate; } } } } return(pageModel); } }