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);
}
