public JsonResult adSigninfoSignageSave(T_AD_SIGNINFO_SIGNAGE_SAVE Param) { RTN_SAVE_DATA rtn = new LoggalBoxService().adSigninfoSignageSave(Param); return(new JsonResult { Data = rtn }); }
/// <summary> /// T_AD_SIGNINFO_SIGNAGE 저장하기 /// </summary> /// <param name="Param"></param> /// <returns></returns> public RTN_SAVE_DATA adSigninfoSignageSave(T_AD_SIGNINFO_SIGNAGE_SAVE Param) { RTN_SAVE_DATA rtn = new RTN_SAVE_DATA(); try { using (TransactionScope tran = new TransactionScope()) { foreach (T_AD_SIGNINFO_SIGNAGE data in Param.list) { data.SIGN_CODE = Param.SIGN_CODE; data.INSERT_CODE = Param.REG_CODE; if (data.SAVE_TYPE.ToString("") == "D") { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_AD_SIGNINFO_SIGNAGE.xml", "adSigninfoSignageDel" , data.IDX.ToString("-1") ); rtn.DATA = db.ExecuteQuery <string>(sql).First(); } else if (data.SAVE_TYPE.ToString("") == "HIDE") { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_AD_SIGNINFO_SIGNAGE.xml", "adSigninfoSignageHide" , data.IDX.ToString("-1") ); rtn.DATA = db.ExecuteQuery <string>(sql).First(); } else { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_AD_SIGNINFO_SIGNAGE.xml", "adSigninfoSignageSave" , data.IDX.ToString("-1") , data.AD_CODE.ToString("") , data.SIGN_CODE.ToString("") , data.FR_DATE.ToString("") , data.TO_DATE.ToString("") , data.FR_TIME.ToString("") , data.TO_DATE.ToString("") , data.REMARK.ToString("") , (data.HIDE == null || data.HIDE == false ? "0" : "1") , data.INSERT_CODE.ToString("") ); rtn.DATA = db.ExecuteQuery <string>(sql).First(); } } tran.Complete(); } } catch (Exception ex) { rtn.ERROR_MESSAGE = ex.Message; } return(rtn); }