public RTN_SAVE_DATA FileSave([FromBody] T_FILE Param)
{
Param.TABLE_NAME = Global.SecurityInfo.Decrypt_data(Param.TABLE_NAME);
Param.TABLE_KEY = Global.SecurityInfo.Decrypt_data(Param.TABLE_KEY);
Param.FILE_URL = Global.SecurityInfo.Decrypt_data(Param.FILE_URL);
RTN_SAVE_DATA rtn = new CommonService().FileSave(Param);
return(rtn);
}
public List <T_FILE> GetFileList(T_FILE Cond)
{
Cond.TABLE_NAME = Global.SecurityInfo.Decrypt_data(Cond.TABLE_NAME);
Cond.TABLE_KEY = Global.SecurityInfo.Decrypt_data(Cond.TABLE_KEY);
List <T_FILE> list = new CommonService().GetFileList(Cond);
return(list);
}
public JsonResult FileSave(T_FILE param)
{
param.INSERT_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE;
RTN_SAVE_DATA data = new CommonService().FileSave(param);
return(new JsonResult {
Data = data
});
}
/// <summary>
/// T_FILE 조회하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public List <T_FILE> GetFileList(T_FILE Param)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_FILE.xml", "GetFileList"
, Param.TABLE_NAME.ToString("10")
, Param.TABLE_KEY.ToString("1")
, Param.FILE_SEQ.ToString()
);
return(db.ExecuteQuery <T_FILE>(sql).ToList());
}
/// <summary>
/// T_FILE 저장하기
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public RTN_SAVE_DATA FileSave(T_FILE Param)
{
RTN_SAVE_DATA rtn = new RTN_SAVE_DATA();
try
{
string sql = string.Empty;
using (TransactionScope tran = new TransactionScope())
{
if (Param.SAVE_TYPE == "D")
{
sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_FILE.xml", "FileDelete"
, Param.TABLE_NAME.ToString("-1")
, Param.TABLE_KEY.ToString("-1")
, Param.FILE_SEQ.ToString("-1")
);
}
else
{
sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_FILE.xml", "FileSave"
, Param.TABLE_NAME.ToString("-1")
, Param.TABLE_KEY.ToString("-1")
, Param.FILE_SEQ.ToString("-1")
, Param.FILE_TYPE.ToString("1")
, Param.FILE_NAME.ToString("")
, Param.FILE_EXT.ToString("")
, Param.FILE_URL.ToString("")
, Param.REF_DATA1.ToString("")
, Param.REF_DATA2.ToString("")
, Param.REMARK.ToString("")
, Param.INSERT_CODE.ToString("0")
);
}
rtn.DATA = db.ExecuteQuery <int>(sql).First().ToString();
tran.Complete();
}
}
catch (Exception ex)
{
rtn.ERROR_MESSAGE = ex.Message;
}
return(rtn);
}
