/// <summary>
/// loggal box 광고데이터 가져오기 거리순(2019.11.16)
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public IList <LOGGAL_BOX_DATA2> GetLoggalBoxList2(LOGGAL_BOX_COND2 Cond)
{
if (3 != Cond.GUBUN)
{
return(GetOutAdLoggalBoxList(Cond));
}
else
{
return(GetUnRegAdLoggalBoxList2(Cond));
}
}
public PartialViewResult pv_AdDevicelist2(LOGGAL_BOX_COND2 Cond, int?SELECT_TYPE)
{
ViewBag.cond = Cond;
Cond.HOST = GlobalMvc.Host;
Cond.STATUS = 9;
if (1 == SELECT_TYPE)
{
ViewBag.list = new loggalServiceBiz.LoggalBoxService().GetMyLoggalBoxList(Cond);
}
else
{
ViewBag.list = new loggalServiceBiz.LoggalBoxService().GetLoggalBoxList2(Cond);
}
return(PartialView2());
}
public IList <LOGGAL_BOX_DATA2> GetUnRegAdLoggalBoxList2(LOGGAL_BOX_COND2 Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "LoggalBox\\LoggalBoxApi2.xml"
, "GetLoggalBoxAddList2"
, Cond.DEVICE_CODE.ToString("0")
, Cond.DEVICE_NUMBER.ToString("")
, Cond.PAGE.ToString("1")
, Cond.PAGE_COUNT.ToString("1000000")
, Cond.HOST.ToString("") //Global.ConfigInfo.MANAGEMENT_SITE.ToString("")
, (!Cond.bWorkingTime) ? "0" : "1"
, Cond.STATUS.ToString("")
, Cond.CATEGORY_CODE.ToString("")
, Cond.TITLE.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.AD_FRAME_TYPE.ToString("")
);
return(db.ExecuteQuery <LOGGAL_BOX_DATA2>(sql).ToList());
}
