public ActionResult DeviceStationExcelReport(T_DEVICE_STATION_COND Cond)
{
List <string> headers = new List <string>()
{
"사용여부", "스테이션명", "주소", "우편번호", "위도", "경도", "설명", "박수갯수", "수정자", "수정시간"
};
Cond.PAGE = 1;
Cond.PAGE_COUNT = 100000;
return(Service.deviceService.GetDeviceStationList(Cond).Select(s => new
{
HIDE = s.HIDE == true ? "미사용" : "사용"
,
STATION_NAME = s.STATION_NAME
,
ADDRESS = s.ADDRESS1.ToString("") + " " + s.ADDRESS2.ToString("")
,
ZIP_CODE = s.ZIP_CODE
,
LATITUDE = s.LATITUDE
,
LONGITUDE = s.LONGITUDE
,
STATION_DESC = s.STATION_DESC
,
DEVICE_CNT = s.DEVICE_CNT
,
UPDATE_NAME = s.UPDATE_NAME
,
UPDATE_DATE = s.UPDATE_DATE
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
;
}
public JsonResult GetDeviceStationList(T_DEVICE_STATION_COND Cond)
{
var list = new DeviceService().GetDeviceStationList(Cond);
return(new JsonResult {
Data = list
});
}
public JsonResult GetDeviceStationMapList(T_DEVICE_STATION_COND Cond)
{
return(new JsonResult {
Data = Service.deviceService.GetDeviceStationList(Cond).Where(w => w.LATITUDE > 30 && w.LONGITUDE > 120).Select(s => new DAUM_MAPLIST {
EnMapType = enMapType.Station, ACTIVE_YN = true, TITLE = s.STATION_NAME, SUB_TITLE = s.DEVICE_CNT.ToString() + "(" + s.NEW_DEVICE_CNT.ToString() + ")", CONTENT = s.STATION_DESC, LATITUDE = s.LATITUDE, LONGITUDE = s.LONGITUDE, LINK_URL = "/basic/devicestationreg/" + s.STATION_CODE.ToString()
}).OrderBy(o => o.ACTIVE_YN).ToList()
});
}
public List <T_DEVICE_STATION> GetDeviceStationMapList(T_DEVICE_STATION_COND Cond)
{
List <T_DEVICE_STATION> list = new DeviceService().GetDeviceStationMapList(Cond).Where(w => w.LATITUDE > 30 && w.LONGITUDE > 120).ToList();
return(list);
}
public PartialViewResult PV_deviceStationList(T_DEVICE_STATION_COND Cond)
{
ViewBag.list = new DeviceService().GetDeviceStationList(Cond);
ViewBag.Cond = Cond;
return(PartialView2());
}
