public List <WJ_InvestmentModel> GetInvestmentList(WJ_InvestmentFilter filter, out int total) { using (DataProvider dp = new DataProvider()) { var list = dp.WJ_Investment.Where(m => true); if (filter.Title.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.Title.Contains(filter.Title)); } if (filter.Brief.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.Brief.Contains(filter.Brief)); } total = list.Count(); var listLoc = Mapper.Map <List <WJ_InvestmentModel> >(list.OrderBy(m => !m.IsTop).ThenByDescending(m => m.Sort).ThenByDescending(m => m.CreateTime).Skip(filter.Skip).Take(filter.PageSize).ToList()); return(listLoc); } }
public ActionResult GetInvestmentList(WJ_InvestmentFilter filter) { var data = service.GetInvestmentList(filter, out int total); return(Json(new TableDataModel(total, data))); }