public PageModel <SensitiveWordsInfo> GetSensitiveWords(SensitiveWordQuery query) { int num = 0; IQueryable <SensitiveWordsInfo> page = context.SensitiveWordsInfo.AsQueryable <SensitiveWordsInfo>(); if (!string.IsNullOrWhiteSpace(query.SensitiveWord)) { page = from item in page where item.SensitiveWord.Contains(query.SensitiveWord) select item; } if (!string.IsNullOrWhiteSpace(query.CategoryName)) { page = from item in page where item.CategoryName.Contains(query.CategoryName) select item; } page = page.GetPage(out num, query.PageNo, query.PageSize, null); return(new PageModel <SensitiveWordsInfo>() { Models = page, Total = num }); }
public JsonResult List(int page, string keywords, int rows, string category) { ISensitiveWordService sensitiveWordService = ServiceHelper.Create <ISensitiveWordService>(); SensitiveWordQuery sensitiveWordQuery = new SensitiveWordQuery() { SensitiveWord = keywords, CategoryName = category, PageNo = page, PageSize = rows }; PageModel <SensitiveWordsInfo> sensitiveWords = sensitiveWordService.GetSensitiveWords(sensitiveWordQuery); var list = from item in sensitiveWords.Models.ToList() select new { Id = item.Id, SensitiveWord = item.SensitiveWord, CategoryName = item.CategoryName }; return(Json(new { rows = list, total = sensitiveWords.Total })); }
public QueryPageModel <SensitiveWordInfo> GetSensitiveWords(SensitiveWordQuery query) { var Infos = DbFactory.Default.Get <SensitiveWordInfo>(); if (!string.IsNullOrWhiteSpace(query.SensitiveWord)) { Infos.Where(item => item.SensitiveWord.Contains(query.SensitiveWord)); } if (!string.IsNullOrWhiteSpace(query.CategoryName)) { Infos.Where(item => item.CategoryName.Contains(query.CategoryName)); } var rets = Infos.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize); QueryPageModel <SensitiveWordInfo> pageModel = new QueryPageModel <SensitiveWordInfo>() { Models = rets, Total = rets.TotalRecordCount }; return(pageModel); }
public ObsoletePageModel <SensitiveWordsInfo> GetSensitiveWords(SensitiveWordQuery query) { int total = 0; IQueryable <SensitiveWordsInfo> Infos = Context.SensitiveWordsInfo.AsQueryable(); if (!string.IsNullOrWhiteSpace(query.SensitiveWord)) { Infos = Infos.Where(item => item.SensitiveWord.Contains(query.SensitiveWord)); } if (!string.IsNullOrWhiteSpace(query.CategoryName)) { Infos = Infos.Where(item => item.CategoryName.Contains(query.CategoryName)); } Infos = Infos.GetPage(out total, query.PageNo, query.PageSize); ObsoletePageModel <SensitiveWordsInfo> pageModel = new ObsoletePageModel <SensitiveWordsInfo>() { Models = Infos, Total = total }; return(pageModel); }