示例#1
0
        public ActionResult AdDeviceLogExcelReport(T_AD_DEVICE_LOG_COND Cond)
        {
            List <string> headers = new List <string>()
            {
                "일자", "배너코드", "제목", "시작일자", "종료일자", "프레임", "로컬박스명", "상태", "배너업체", "로컬박스업체", "클릭수", "비고", "추가글"
            };

            Cond.PAGE = 1; Cond.PAGE_COUNT = 100000;

            return(Service.deviceService.GetAdDeviceLogList(Cond).Select(s => new {
                UPDATE_DATE = s.UPDATE_DATE
                ,
                AD_CODE = s.AD_CODE
                ,
                TITLE = s.TITLE
                ,
                FR_DATE = s.FR_DATE
                ,
                TO_DATE = s.TO_DATE
                ,
                AD_FRAME_TYPE = s.AD_FRAME_TYPE
                ,
                DEVICE_CODE = s.DEVICE_CODE
                ,
                STATUS = s.STATUS
                ,
                AD_STORE_NAME = s.AD_STORE_NAME
                ,
                DEVICE_STORE_NAME = s.DEVICE_STORE_NAME
                ,
                CLICK_CNT = s.CLICK_CNT
                ,
                REMARK = s.REMARK
                ,
                REMARK2 = s.REMARK2
            }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
        }
示例#2
0
        public PartialViewResult PV_AdDeviceLogList(T_AD_DEVICE_LOG_COND Cond)
        {
            ViewBag.list = Service.deviceService.GetAdDeviceLogList(Cond);

            return(PartialView2());
        }