public JsonResult SignageSave(T_SIGNAGE Param) { Param.INSERT_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE; RTN_SAVE_DATA rtn = new LoggalBoxService().SignageSave(Param); return(new JsonResult { Data = rtn }); }
/// <summary> /// T_SIGNAGE 저장하기 /// </summary> /// <param name="Param"></param> /// <returns></returns> public RTN_SAVE_DATA SignageSave(T_SIGNAGE Param) { RTN_SAVE_DATA rtn = new RTN_SAVE_DATA(); try { using (TransactionScope tran = new TransactionScope()) { string sql = string.Empty; if (Param.SAVE_TYPE == "D") { sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE.xml", "SignageDelete" , Param.SIGN_CODE.ToString("-1") ); } else { sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE.xml", "SignageSave" , Param.SIGN_CODE.ToString("-1") , Param.SIGN_NAME.ToString("") , Param.AUTH_NUMBER.ToString("") , Param.DEVICE_NUMBER.ToString("") , Param.IS_VERTICAL == false ? "0" : "1" , Param.PLAY_TIME.ToString("") , Param.ADDRESS1.ToString("") , Param.ADDRESS2.ToString("") , Param.ZIP_CODE.ToString("") , Param.LATITUDE.ToString("") , Param.LONGITUDE.ToString("") , Param.RADIUS.ToString("") , (Param.HIDE == null || Param.HIDE == false) ? "0" :"1" , Param.REMARK.ToString("") , Param.INSERT_CODE.ToString("") ); } rtn.DATA = db.ExecuteQuery <long>(sql).First().ToString(); tran.Complete(); } } catch (Exception ex) { rtn.ERROR_MESSAGE = ex.Message; } return(rtn); }
/// <summary> /// T_SIGNAGE_CONTROL 저장하기 /// </summary> /// <param name="Param"></param> /// <returns></returns> public RTN_SAVE_DATA SignageSubCopySave(T_SIGNAGE Param) { RTN_SAVE_DATA rtn = new RTN_SAVE_DATA(); try { using (TransactionScope tran = new TransactionScope()) { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Signage\\T_SIGNAGE.xml", "SignageSubCopySave" , Param.REPRE_SIGN_CODE.ToString("") , Param.INSERT_CODE.ToString("0") ); rtn.DATA = db.ExecuteQuery <string>(sql).First(); tran.Complete(); } } catch (Exception ex) { rtn.ERROR_MESSAGE = ex.Message; } return(rtn); }