示例#1
0
        public ActionResult StoreStatisticsExcelReport(STORE_STATISTICS_COND Cond)
        {
            List <string> headers = new List <string>()
            {
                "업체명", "로컬박스수", "실제갯수", "가상갯수", "1 Frame(박스)", "6 Frame(박스)", "내부배너", "외부배너", "내부+외부"
                , "배너수", "1 Frame(배너)", "6 Frame(배너)", "모바일배너", "로컬박스배너", "모바일+로컬박스"
            };

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



            return(new StoreService().GetStoreStatisticsList(Cond).Select
                       (s => new {
                s.STORE_NAME
                , s.LOCALBOX_CNT
                , s.REAL_CNT
                , s.VIRTUAL_CNT
                , s.LOCALBOX_FRAME1_CNT
                , s.LOCALBOX_FRAME6_CNT
                , s.DEVICE_TYPE1
                , s.DEVICE_TYPE2
                , s.DEVICE_TYPE3
                , s.AD_CNT
                , s.AD_FRAME_TYPE1_CNT
                , s.AD_FRAME_TYPE6_CNT
                , s.AD_TYPE1
                , s.AD_TYPE2
                , s.AD_TYPE3
            }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));



            //return .Select(s => new
            //{
            //    DEVICE_CODE = s.DEVICE_CODE
            //   ,
            //    DEVICE_NAME = s.DEVICE_NAME
            //   ,
            //    STORE_NAME = s.STORE_NAME
            //   ,
            //    BUSI_TYPE_NAME = s.BUSI_TYPE_NAME
            //   ,
            //    BUSI_TYPE_NAME2 = s.BUSI_TYPE_NAME2
            //   ,
            //    CONTACT_NAME = s.CONTACT_NAME
            //   ,
            //    CONTACT_PHONE = s.CONTACT_PHONE
            //   ,
            //    AUTH_NUMBER = s.AUTH_NUMBER
            //   ,
            //    ADDRESS = s.ADDRESS
            //   ,
            //    UPDATE_NAME = s.UPDATE_NAME
            //   ,
            //    UPDATE_DATE = s.UPDATE_DATE
            //}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers);
            //;
        }
示例#2
0
        public PartialViewResult pv_StoreStatisticsList(STORE_STATISTICS_COND Cond)
        {
            ViewBag.combolist = Request["combolist"] == null ? new List <T_COMMON>() : JsonConvert.DeserializeObject <List <T_COMMON> >(Request["combolist"]);
            ViewBag.list      = new StoreService().GetStoreStatisticsList(Cond);

            return(PartialView2());
        }
示例#3
0
 public ActionResult StoreStatisticsList(STORE_STATISTICS_COND Cond)
 {
     if (SessionHelper.LoginInfo.STORE_CODE != 1)
     {
         ViewBag.data = new STORE_STATISTICS_COND()
         {
             COMPANY_CODE = SessionHelper.LoginInfo.COMPANY_CODE
             ,
             COMPANY_NAME = SessionHelper.LoginInfo.STORE.COMPANY_NAME
             ,
             STORE_CODE = SessionHelper.LoginInfo.STORE_CODE
             ,
             STORE_NAME = SessionHelper.LoginInfo.STORE.STORE_NAME
         };
     }
     ViewBag.data = Cond ?? new STORE_STATISTICS_COND();
     return(View());
 }
示例#4
0
        public List <STORE_STATISTICS_LIST> GetStoreStatisticsList(STORE_STATISTICS_COND Cond)
        {
            string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Store\\storeStatistics.xml", "GetStoreStatisticsList"
                                                , Cond.PAGE_COUNT.ToString("10")
                                                , Cond.PAGE.ToString("")
                                                , Cond.SORT.ToString("A.STORE_NAME")
                                                , Cond.FR_DATE.ToString("").RemoveDateString()
                                                , Cond.TO_DATE.ToString("").RemoveDateString()
                                                , Cond.COMPANY_CODE.ToString("")
                                                , Cond.COMPANY_NAME.ToString("")
                                                , Cond.STORE_CODE.ToString("")
                                                , Cond.STORE_NAME.ToString("")
                                                , Cond.LOCALBOX_REG_YN.ToString("")
                                                , Cond.BANNER_REG_YN.ToString("")
                                                , Cond.REG_YN.ToString("")
                                                );

            return(db.ExecuteQuery <STORE_STATISTICS_LIST>(sql).ToList());
        }