Ejemplo n.º 1
0
        /// <summary>
        /// 비콘 조회
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public List <T_BEACON> GetBeaconList(T_BEACON_COND Param)
        {
            List <T_BEACON> list = new List <T_BEACON>();
            string          sql  = Global.DBAgent.LoadSQL(sqlBasePath + "Beacon\\T_BEACON.xml", "GetBeaconList"
                                                          , Param.PAGE.ToString("1")
                                                          , Param.PAGE_COUNT.ToString("10")
                                                          , Param.SORT.ToString("A.BEACON_CODE")
                                                          , Param.BEACON_CODE.ToString("")
                                                          , Param.BEACON_NAME.ToString("")
                                                          , Param.HIDE == null ? "" : (Param.HIDE == true ? "1" : "0")
                                                          );

            return(db.ExecuteQuery <T_BEACON>(sql).ToList());
        }
Ejemplo n.º 2
0
        public ActionResult BeaconExcelReport(T_BEACON_COND Cond)
        {
            List <string> headers = new List <string>()
            {
                "사용여부", "코드", "사이니지명", "디스플레이", "플레이시간", "주소", "우편번호", "위도", "경도", "사이니지", "배너수", "수정자", "수정시간"
            };

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

            return(new BeaconService().GetBeaconList(Cond).Select(s => new {
                HIDE = s.HIDE == true ? "미사용" : "사용"
                , BEACON_CODE = s.BEACON_CODE
                , BEACON_NAME = s.BEACON_NAME
                , ADDRESS = s.ADDRESS1 + " " + s.ADDRESS2
                , ZIP_CODE = s.ZIP_CODE
                , LATITUDE = s.LATITUDE
                , LONGITUDE = s.LONGITUDE
                , UPDATE_NAME = s.UPDATE_NAME
                , UPDATE_DATE = s.UPDATE_DATE
            }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));

            ;
        }
Ejemplo n.º 3
0
 /// <summary>
 /// 로컬사이니지정보 가져오기
 /// </summary>
 /// <param name="Cond"></param>
 /// <returns></returns>
 public PartialViewResult pv_BeaconList(T_BEACON_COND Cond)
 {
     ViewBag.list = new BeaconService().GetBeaconList(Cond);
     return(PartialView2());
 }