public JsonResult shareSave(T_SHARE list)
{
RTN_SAVE_DATA rtn = new ShareService().ShareSave(list);
return(new JsonResult {
Data = rtn
});
}
/// <summary>
/// T_SHARE 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public RTN_SAVE_DATA ShareSave(T_SHARE Param)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
using (TransactionScope tran = new TransactionScope())
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Base\\T_SHARE.xml", "ShareSave"
, Param.SHARE_CODE.ToString()
, Param.SEND_MEMBER_CODE.ToString("")
, Param.AD_CODE.ToString("")
, Param.DEVICE_CODE.ToString("")
, Param.COMMENT.ToString("")
, (Param.HIDE == null || Param.HIDE == false ? "0" : "1")
, Param.REMARK.ToString("")
, Param.INSERT_CODE.ToString("")
);
rtn = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
if (!string.IsNullOrEmpty(rtn.ERROR_MESSAGE))
{
throw new Exception(rtn.ERROR_MESSAGE);
}
Param.SHARE_CODE = rtn.DATA.ToLong();
foreach (T_SHARE_DTL data in Param.detaillist)
{
data.SHARE_CODE = Param.SHARE_CODE;
sql = Global.DBAgent.LoadSQL(sqlBasePath + "Base\\T_SHARE.xml", "ShareDtlSave"
, data.SHARE_CODE.ToString("")
, data.RECEIVE_MEMBER_CODE.ToString("")
, (data.IS_VIEW == null || data.IS_VIEW == false ? "0" : "1")
, (data.HIDE == null || data.HIDE == false ? "0" : "1")
, data.REMARK.ToString("")
, data.INSERT_CODE.ToString("")
);
db.ExecuteCommand(sql);
}
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
