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