public ActionResult AjaxGetList(UserPurviewSearchDTO dto)
{
var listDTO = _purviewService.GetPurviewList(dto);
return(Json(new
{
sEcho = dto.sEcho,
iTotalRecords = listDTO.TotalRecords,
iTotalDisplayRecords = listDTO.TotalRecords,
aaData = listDTO.List
},
JsonRequestBehavior.AllowGet));
}
public List <PurviewEntity> GetPurviewList(UserPurviewSearchDTO searchDTO, out long totalCount)
{
var sqlExp = db.From <PurviewEntity>();
if (searchDTO.PurviewID.HasValue)
{
sqlExp.Where(m => m.PurviewID == searchDTO.PurviewID);
}
if (!string.IsNullOrEmpty(searchDTO.PurviewTitle))
{
sqlExp.Where(m => m.PurviewTitle == searchDTO.PurviewTitle);
}
totalCount = base.Count(sqlExp);
sqlExp.Limit((searchDTO.PageIndex - 1) * searchDTO.iDisplayLength, searchDTO.iDisplayLength);
var list = base.QueryWhere(sqlExp);
return(list);
}
public UserPurviewListDTO GetPurviewList(UserPurviewSearchDTO searchDTO)
{
UserPurviewListDTO result = new UserPurviewListDTO();
IEnumerable <PurviewEntity> list = GetAllFromCache();
if (searchDTO.PurviewID.HasValue)
{
list = list.Where(m => m.PurviewID == searchDTO.PurviewID);
}
if (!string.IsNullOrEmpty(searchDTO.PurviewTitle))
{
list = list.Where(m => m.PurviewTitle == searchDTO.PurviewTitle);
}
var pagedList = list.Skip((searchDTO.PageIndex - 1) * searchDTO.iDisplayLength).Take(searchDTO.iDisplayLength);
result.TotalRecords = list.Count();
result.List = pagedList.Select(m => Mapper.DynamicMap <UserPurviewListItemDTO>(m)).ToList();
return(result);
}
public ActionResult Index()
{
var searchDTO = new UserPurviewSearchDTO();
return(View(searchDTO));
}
