From 35603c9d2edd3ba95f80a90d2a6cafd0caf5b1b8 Mon Sep 17 00:00:00 2001
From: fs-danaus <danaus314@qq.com>
Date: 星期五, 27 八月 2021 10:43:50 +0800
Subject: [PATCH] 完善农行支付功能
---
src/com/yc/abc/service/AbcPayServiceImpl.java | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/src/com/yc/abc/service/AbcPayServiceImpl.java b/src/com/yc/abc/service/AbcPayServiceImpl.java
index 80859ff..eaec547 100644
--- a/src/com/yc/abc/service/AbcPayServiceImpl.java
+++ b/src/com/yc/abc/service/AbcPayServiceImpl.java
@@ -38,11 +38,21 @@
public OrderEntity getOrder(String docCode) {
try {
return this.jdbcTemplate.queryForObject("set nocount on\n" +
- " select a.doccode as orderNo,a.SumAmount as amount,a.cltCode,a.cltName,b.companyName from t150101H a join oCompany b on a.CompanyID=b.companyid where DocCode=?", new BeanPropertyRowMapper<>(OrderEntity.class), docCode);
+ " select a.doccode as orderNo,a.SumAmount as amount,a.cltCode,a.cltName,b.companyName,a.onlinePaymentOneQRForAllUnid,a.onlinePaymentReturnCode \n" +
+ " from t150101H a join oCompany b on a.CompanyID=b.companyid where DocCode=?", new BeanPropertyRowMapper<>(OrderEntity.class), docCode);
}catch (EmptyResultDataAccessException e){
return null;
}
}
+
+ @Override
+ public void save150101OrderInfo(JSON json, String qrCodeUnid) {
+ String sql="set nocount on\n" +
+ " declare @ReturnCode varchar(20)=?,@ErrorMessage varchar(200)=?,@PaymentURL varchar(200)=?,@qrCodeUnid varchar(50)=?" +
+ " update a set a.OnlinePaymentReturnCode=@ReturnCode,a.OnlinePaymentErrorMessage=@ErrorMessage,a.OnlinePaymentURL=@PaymentURL,a.OnlinePaymentOneQRForAllUnid=@qrCodeUnid from t150101H a where a.docCode=?";
+ jdbcTemplate.update(sql,json.GetKeyValue("ReturnCode"),json.GetKeyValue("ErrorMessage"),json.GetKeyValue("PaymentURL"),qrCodeUnid,json.GetKeyValue("OrderNo"));
+ }
+
@Transactional(rollbackFor = Exception.class)
@Override
public void save150101Log(PaymentResult paymentResult) {
--
Gitblit v1.8.0