고객센터 공지사항 상세

t

작성자 :
관리자
조회수 :
6
작성시간 :
2020-03-06 15:28:53.0
내용 :

try {

String setSql = "";

if(!FWStringUtil.isNull((String)args.get("depositDate"))) 

setSql += "DEPOSIT_DATETIME = '" + args.get("depositDate") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("depositor"))) 

setSql += "DEPOSITOR = '" + args.get("depositor") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("issueDate"))) 

setSql += "ISSUE_DATETIME = '" + args.get("issueDate") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("cancelDateTime"))) 

setSql += "CANCEL_DATETIME = '" + args.get("cancelDateTime") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("bankCode"))) 

setSql += "BANK_CODE = '" + args.get("bankCode") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("bankName"))) 

setSql += "BANK_NAME = '" + args.get("bankName") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("accountHolder"))) 

setSql += "ACCOUNT_HOLDER = '" + args.get("accountHolder") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("expireDate"))) 

setSql += "EXPIRE_DATE = '" + args.get("expireDate") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("cashUseFlag"))) 

setSql += "CASH_USE_FLAG = '" + args.get("cashUseFlag") + "',\n" ;

 

if(!FWStringUtil.isNull((String)args.get("cashType"))) 

setSql += "CASH_TYPE = '" + args.get("cashType") + "',\n" ;

 

if(!FWStringUtil.isNull((String)args.get("cashNo"))) 

setSql += "CASH_NO = GET_ENCRYPT('"+ args.get("cashNo")+"', KIDX),\n" ;

if(!FWStringUtil.isNull((String)args.get("depositor"))) 

setSql += "DEPOSITOR = '" + args.get("depositor") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("cashAuthNo"))) 

setSql += "CASH_AUTH_NO = '" + args.get("cashAuthNo") + "',\n" ;

 

if(!FWStringUtil.isNull((String)args.get("cashAuthDate"))) 

setSql += "CASH_AUTH_DATE = '" + args.get("cashAuthDate") + "',\n" ;

 

if(!FWStringUtil.isNull((String)args.get("cashTranNo"))) 

setSql += "CASH_TRAN_NO = '" + args.get("cashTranNo") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("responseCode"))) 

setSql += "RESPONSE_CODE = '" + args.get("responseCode") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("responseMsg"))) 

setSql += "RESPONSE_MSG = '" + args.get("responseMsg") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("affiliaterResponseCode"))) 

setSql += "AFFILIATER_RESPONSE_CODE = '" + args.get("affiliaterResponseCode") + "',\n" ;

if(!FWStringUtil.isNull((String)args.get("affiliaterResponseMsg"))) 

setSql += "AFFILIATER_RESPONSE_MSG = '" + args.get("affiliaterResponseMsg") + "',\n" ;

setSql += "STATUS_CODE = ? \n" ;

String sql = 

" UPDATE TB_VA_TRANSACTION \n" +

" SET \n" +

setSql +

" WHERE TRANSACTION_ID = ? \n" +

" AND AMOUNT = ? \n" +

" AND ACCOUNT = ? \n" +

" AND AFFILIATER_TRANSACTION_ID = ? \n";

 

Object params[] = {

args.get("statusCode"),

args.get("transactionId"),

args.get("amount"),

args.get("account"),

args.get("affiliaterTransactionId")

};

result = (new FWSqlExecutor()).executeUpdate(sql, params);

}

catch(Exception e) {

throw e;

}

return result;