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);
}
