/// <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());
}
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));
;
}
/// <summary>
/// 로컬사이니지정보 가져오기
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public PartialViewResult pv_BeaconList(T_BEACON_COND Cond)
{
ViewBag.list = new BeaconService().GetBeaconList(Cond);
return(PartialView2());
}