public object GetArticleListWidthSub(int kid, int pagesize = 10, int page = 1, string key = "", string random = "", string timeStamp = "", string signature = "") { var where = Article._.IsHide != 1; if (kid > 0) { //获取下属 List <int> kids = new List <int>(); kids.Add(kid); IList <ArticleCategory> subkinds = ArticleCategory.FindByParentID(kid); if (subkinds != null && subkinds.Count > 0) { foreach (var item in subkinds) { kids.Add(item.Id); } } where &= Article._.KId.In(kids); } if (!string.IsNullOrEmpty(key)) { where &= Article._.Title.Contains(key); } if (page <= 0) { page = 1; } //计算分页 int numPerPage, currentPage, startRowIndex; numPerPage = pagesize; currentPage = page; startRowIndex = (currentPage - 1) * numPerPage; IList <Article> list = Article.FindAll(where, Article._.Sequence.Asc(), null, startRowIndex, numPerPage); long totalCount = Article.FindCount(where, Article._.Sequence.Asc(), null, startRowIndex, numPerPage); List <object> relist = new List <object>(); if (list != null && list.Count > 0) { foreach (var item in list) { relist.Add(new { id = item.Id, title = item.Title, subTitle = item.SubTitle, pic = item.Pic, description = item.Description, addTime = item.AddTime.ToString("yyyy-MM-dd HH:mm"), origin = item.Origin }); } } dynamic re = new { total = totalCount, page = page, list = relist }; reJson.code = 0; reJson.message = "获取成功"; reJson.detail = re; return(reJson); }
public IActionResult GetArticleList(string keyword, int page = 1, int limit = 20) { int numPerPage, currentPage, startRowIndex; numPerPage = limit; currentPage = page; startRowIndex = (currentPage - 1) * numPerPage; Expression ex = Article._.Id > 0; if (!string.IsNullOrWhiteSpace(keyword)) { if (Utils.IsInt(keyword)) { ex &= (Article._.Id == int.Parse(keyword) | Article._.Title.Contains(keyword)); } else { ex &= Article._.Title.Contains(keyword); } } string kid = Request.Query["kid"]; string isshowsub = Request.Query["isshowsub"]; if (Utils.IsInt(kid) && int.Parse(kid) > 0) { //获取栏目 if (isshowsub == "1") { List <int> kids = new List <int>(); kids.Add(int.Parse(kid)); IList <ArticleCategory> subkinds = ArticleCategory.FindByParentID(int.Parse(kid)); if (subkinds != null && subkinds.Count > 0) { foreach (var item in subkinds) { kids.Add(item.Id); } ex &= Article._.KId.In(kids); } } else { ex &= Article._.KId == int.Parse(kid); } } IList <Article> list = Article.FindAll(ex, Article._.Sequence.Asc().And(Article._.Id.Desc()), null, startRowIndex, numPerPage); long totalCount = Article.FindCount(ex, Article._.Sequence.Asc().And(Article._.Id.Desc()), null, startRowIndex, numPerPage); return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(new { total = totalCount, rows = list }), "text/plain")); //return Json(new { total = totalCount, rows = list }, JsonRequestBehavior.AllowGet); }
public IActionResult GetArticleList(string keyword, int page = 1, int limit = 20) { int numPerPage, currentPage, startRowIndex; numPerPage = limit; currentPage = page; startRowIndex = (currentPage - 1) * numPerPage; Expression ex = new Expression();; Admin my = Admin.GetMyInfo(); List <int> aclist = new List <int>(); if (my.Roles.IsSuperAdmin != 1) { aclist = Newtonsoft.Json.JsonConvert.DeserializeObject <List <int> >(string.IsNullOrEmpty(my.Roles.AuthorizedArticleCagegory)?"[]": my.Roles.AuthorizedArticleCagegory); if (aclist == null) { aclist = new List <int>(); } if (aclist.Count > 0) { ex &= Article._.KId.In(aclist); } //仅显示有权限内容 if (my.Roles.OnlyEditMyselfArticle == 1) { ex &= Article._.AuthorId == my.Id; } } if (!string.IsNullOrWhiteSpace(keyword)) { if (Utils.IsInt(keyword)) { ex &= (Article._.Id == int.Parse(keyword) | Article._.Title.Contains(keyword)); } else { ex &= Article._.Title.Contains(keyword); } } string kid = Request.Query["kid"]; string isshowsub = Request.Query["isshowsub"]; if (Utils.IsInt(kid) && int.Parse(kid) > 0) { //获取栏目 if (isshowsub == "1") { List <int> kids = new List <int>(); kids.Add(int.Parse(kid)); IList <ArticleCategory> subkinds = ArticleCategory.FindByParentID(int.Parse(kid)); if (subkinds != null && subkinds.Count > 0) { foreach (var item in subkinds) { kids.Add(item.Id); } ex &= Article._.KId.In(kids); } } else { ex &= Article._.KId == int.Parse(kid); } } IList <Article> list = Article.FindAll(ex, Article._.Sequence.Asc().And(Article._.Id.Desc()), null, startRowIndex, numPerPage); long totalCount = Article.FindCount(ex, Article._.Sequence.Asc().And(Article._.Id.Desc()), null, startRowIndex, numPerPage); //return Content(Newtonsoft.Json.JsonConvert.SerializeObject(new { total = totalCount, rows = list }), "text/plain"); return(Json(new { total = totalCount, rows = list })); }