Пример #1
0
        public IPagedList <BagtotheFutureSns> Get([FromUri] BagtotheFutureSnsQueryOptions options)
        {
            var data = service.GetBagtotheFutureSns().AsQueryable().AsExpandable()
                       .Where(options.BuildPredicate()).OrderByDescending(x => x.CreateDate);

            return(new SerializablePagedList <BagtotheFutureSns>(data, options.Page, options.PageSize));
        }
Пример #2
0
        public void ExcelDownloadSns(BagtotheFutureSnsQueryOptions options)
        {
            var entry = service.GetBagtotheFutureSns().AsQueryable().AsExpandable()
                        .Where(options.BuildPredicate()).OrderByDescending(x => x.CreateDate).Select(x => new {
                참여일       = x.CreateDate,
                채널        = x.User.Channel,
                아이피주소     = x.User.IpAddress,
                이름        = x.User.Name,
                연락처       = x.User.Mobile,
                SNS유형     = x.SnsTypeDisplayName,
                SNS닉네임    = x.SnsName,
                SNS스크랩URL = x.Post
            });

            common.ExcelDownLoad(entry, "bag-to-the-future-event02-sns");
        }