/// <summary>
/// T_SIGNAGE 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public List <T_SIGNAGE> GetSignageList(T_SIGNAGE_COND Param)
{
List <T_SIGNAGE> list = new List <T_SIGNAGE>();
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE.xml", "GetSignageList"
, Param.PAGE.ToString("1")
, Param.PAGE_COUNT.ToString("10")
, Param.SORT.ToString("A.SIGN_CODE")
, Param.SIGN_CODE.ToString("")
, Param.SIGN_NAME.ToString("")
, (Param.IS_REPRESENT == null ? "" : (Param.IS_REPRESENT == true ? "1" : "0"))
, Param.REPRE_SIGN_CODE.ToString("")
, Param.AUTH_NUMBER.ToString("")
, Param.AUTH_YN.ToString("")
, Param.COMPANY_CODE.ToString("")
, Param.COMPANY_NAME.ToString("")
, Param.STORE_CODE.ToString("")
, Param.STORE_NAME.ToString("")
, Param.MEMBER_CODE.ToString("")
, Param.MEMBER_NAME.ToString("")
, Param.CONTACT_COMPANY_CODE.ToString("")
, Param.CONTACT_COMPANY_NAME.ToString("")
, Param.CONTACT_STORE_CODE.ToString("")
, Param.CONTACT_STORE_NAME.ToString("")
, Param.CONTACT_CODE.ToString("")
, Param.CONTACT_NAME.ToString("")
, Param.HIDE == null ? "" : (Param.HIDE == true ? "1" : "0")
);
return(db.ExecuteQuery <T_SIGNAGE>(sql).ToList());
}
public ActionResult SignageReg(T_SIGNAGE_COND Cond)
{
Cond.id = Cond.id == null ? -1 : Cond.id;
if (Cond.id > 0)
{
Cond.SIGN_CODE = Cond.id;
}
if (Cond.REPRE_SIGN_CODE != null && Cond.REPRE_SIGN_CODE > 0)
{
T_SIGNAGE data = new LoggalBoxService().GetSignageList(new T_SIGNAGE_COND {
SIGN_CODE = Cond.REPRE_SIGN_CODE
}).FirstOrDefault();
data.SIGN_CODE = null;
data.SIGN_NAME = data.SIGN_NAME + "(서브)";
data.REPRE_SIGN_CODE = Cond.REPRE_SIGN_CODE;
data.REPRE_SIGN_NAME = data.SIGN_NAME;
data.IS_REPRESENT = false;
ViewBag.data = data;
}
else
{
ViewBag.data = new LoggalBoxService().GetSignageList(Cond).FirstOrDefault();
}
return(View());
}
public ActionResult SignageExcelReport(T_SIGNAGE_COND Cond)
{
List <string> headers = new List <string>()
{
"사용여부", "코드", "사이니지명", "디스플레이", "플레이시간", "주소", "우편번호", "위도", "경도", "사이니지", "배너수", "수정자", "수정시간"
};
Cond.PAGE = 1;
Cond.PAGE_COUNT = 100000;
return(new LoggalBoxService().GetSignageList(Cond).Select(s => new {
HIDE = s.HIDE == true ? "미사용" : "사용"
, SIGN_CODE = s.SIGN_CODE
, SIGN_NAME = s.SIGN_NAME
, IS_VERTICAL_NAME = s.IS_VERTICAL_NAME
, ADDRESS = s.ADDRESS1 + " " + s.ADDRESS2
, ZIP_CODE = s.ZIP_CODE
, LATITUDE = s.LATITUDE
, LONGITUDE = s.LONGITUDE
,
AUTH_NUMBER = s.AUTH_NUMBER == null ? "미등록" : s.AUTH_NUMBER.ToString()
,
AD_SIGNINFO_CNT = s.AD_SIGNINFO_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 GetSignageMapList(T_SIGNAGE_COND Cond)
{
return(new JsonResult {
Data = new LoggalBoxService().GetSignageList(Cond).Where(w => w.LATITUDE > 30 && w.LONGITUDE > 120).Select(s => new DAUM_MAPLIST {
ACTIVE_YN = true, TITLE = s.SIGN_NAME, LATITUDE = s.LATITUDE, LONGITUDE = s.LONGITUDE, LINK_URL = "/basic/signagereg/" + s.SIGN_CODE.ToString()
}).ToList()
});
}
public PartialViewResult pv_SignageList(T_SIGNAGE_COND Cond)
{
ViewBag.cond = Cond;
ViewBag.list = new LoggalBoxService().GetSignageList(Cond);
return(PartialView2());
}
public IList <T_SIGNAGE> GetSignageList(T_SIGNAGE_COND Cond)
{
IList <T_SIGNAGE> list = new LoggalBoxService().GetSignageList(Cond);
return(list);
}