public PartialViewResult PV_Ad_PageList(AD_PAGE_COND Cond) { if (SessionHelper.LoginInfo.STORE_CODE != 1 || !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4)) { Cond.COMPANY_CODE = SessionHelper.LoginInfo.COMPANY_CODE; } if (SessionHelper.LoginInfo.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4)) { Cond.STORE_CODE = SessionHelper.LoginInfo.STORE_CODE; } if (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH != null) { switch (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH) { case 2: /*상위부서권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.DEPT_SEARCH = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH.ToString(""); break; case 3: /*부서권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.DEPT_CODE = SessionHelper.LoginInfo.EMPLOYEE.DEPT_CODE; break; case 8: /*상급자권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.PARENT_MEMBER_CODE = SessionHelper.LoginInfo.EMPLOYEE.MEMBER_CODE; break; case 9: /*본인권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.MEMBER_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE; break; } } ViewBag.list = new AdvertisingService().GetT_Ad_PageList(Cond); return(PartialView2()); }
public ActionResult T_AD_ExcelReport(AD_PAGE_COND Cond) { if (SessionHelper.LoginInfo.STORE_CODE != 1 || !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4)) { Cond.COMPANY_CODE = SessionHelper.LoginInfo.COMPANY_CODE; } if (SessionHelper.LoginInfo.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4)) { Cond.STORE_CODE = SessionHelper.LoginInfo.STORE_CODE; } if (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH != null) { switch (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH) { case 2: /*상위부서권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.DEPT_SEARCH = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH.ToString(""); break; case 3: /*부서권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.DEPT_CODE = SessionHelper.LoginInfo.EMPLOYEE.DEPT_CODE; break; case 8: /*상급자권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.PARENT_MEMBER_CODE = SessionHelper.LoginInfo.EMPLOYEE.MEMBER_CODE; break; case 9: /*본인권한*/ Cond.STORE_CODE = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE; Cond.MEMBER_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE; break; } } //if(!(SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH == 2 || SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH == 4)) /**/ //{ //} List <string> headers = new List <string>() { "코드", "로고|LINK", "대표카테고리", "제목", "부제목", "상태", "내용|LINK", "시작일자" , "종료일자", "시작시간", "종료시간", "클릭수", "요청회사", "요청지점", "요청자" , "비고", "숨김여부", "등록자", "등록시간", "수정자", "수정시간" }; Cond.PAGE = 1; Cond.PAGE_COUNT = 100000; return(new AdvertisingService().GetT_Ad_PageList(Cond).Select(s => new { AD_CODE = s.AD_CODE , LOGO_URL = s.LOGO_URL , REP_CATEGORY_NAME = s.REP_CATEGORY_NAME , TITLE = s.TITLE , SUB_TITLE = s.SUB_TITLE , STATUS_NAME = s.STATUS_NAME , CONTENT = Global.ConfigInfo.MANAGEMENT_SITE + "/advertise/contentview/" + s.AD_CODE.ToString("") , FR_DATE = s.FR_DATE , TO_DATE = s.TO_DATE , FR_TIME = s.FR_TIME , TO_TIME = s.TO_TIME , CLICK_CNT = s.CLICK_CNT //,GRADE_POINT = s.GRADE_POINT , COMPANY_NAME = s.COMPANY_NAME , STORE_NAME = s.STORE_NAME , MEMBER_NAME = s.MEMBER_NAME , REMARK = s.REMARK , HIDE_NAME = s.HIDE_NAME , INSERT_NAME = s.INSERT_NAME , INSERT_DATE = s.INSERT_DATE , UPDATE_NAME = s.UPDATE_NAME , UPDATE_DATE = s.UPDATE_DATE }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers)); }
public ActionResult Index(AD_PAGE_COND Cond) { ViewBag.Cond = Cond; return(View()); }