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