public void UserExcelDownload(AdminFindingDory2017QueryOptions options) { var query = service.GetUser(options).OrderByDescending(x => x.CreateDate).ToList(); var data = query.Select(e => new { 참여일 = e.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), 디바이스 = e.Channel, IP = e.IpAddress, 이름 = e.Name, 연락처 = e.Mobile, 주소 = e.Address, 상세주소 = e.AddressDetail, 우편번호 = e.ZipCode, 나이 = e.Age }).ToList(); common.ExcelDownLoad(data, "[2017 도리를찾아서 이벤트] 참여자_" + DateTime.Now.ToString("yyyyMMddHHmmss")); }
/// <summary> /// 개인정보 데이터 리스트 /// </summary> /// <param name="options"></param> /// <returns></returns> public IQueryable <FindingDory2017User> GetUser(AdminFindingDory2017QueryOptions options) { return(userRepository.GetAll().AsExpandable().Where(options.BuildPredicate())); }
public PagedList.IPagedList <FindingDory2017User> GetFindingDory2017UserList([FromUri] AdminFindingDory2017QueryOptions options) { var users = service.GetUser(options).OrderByDescending(x => x.CreateDate); return(new SerializablePagedList <FindingDory2017User>(users, options.Page, options.PageSize)); }