public void SnsExcelDownload(AdminMarvelFrozenSNSQueryOptions options) { var query = service.GetSns(options).OrderByDescending(x => x.CreateDate).ToList(); var data = query.Select(e => new { 공유일 = e.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), 디바이스 = e.User.Channel, 이름 = e.User.Name, 연락처 = e.User.Mobile, 나이 = e.User.Age, SNS = e.SnsTypeDisplayName, 아이디 = e.SnsId, 닉네임 = e.SnsName, URL = e.Post, IP = e.User.IpAddress }).ToList(); common.ExcelDownLoad(data, "[2017 마블프로즌 이벤트] 공유_" + DateTime.Now.ToString("yyyyMMddHHmmss")); }
public IQueryable <MavelFrozenSNS> GetSns(AdminMarvelFrozenSNSQueryOptions options) { return(snsRepository.GetAll().AsExpandable().Where(options.BuildPredicate())); }
public PagedList.IPagedList <MavelFrozenSNS> GetMarvelFrozenSNSList([FromUri] AdminMarvelFrozenSNSQueryOptions options) { var users = service.GetSns(options).OrderByDescending(x => x.CreateDate); return(new SerializablePagedList <MavelFrozenSNS>(users, options.Page, options.PageSize)); }