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