1 15:30:55 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' 2 15:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 3 15:30:55 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' and MC0000 =? 4 15:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 5 15:30:55 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 6 15:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 7 15:30:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 8 15:30:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 9 15:30:55 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual 10 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 11 15:31:04 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 12 15:31:04 SQL Execute: ORACLE - Select SYSDATE from Dual 13 15:31:04 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 14 15:31:04 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 15 15:31:04 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0227769100484745' and ICKNBH = '0227769100484745' 16 15:31:04 SQL Execute: ORACLE - select * from BM_BRZFFS where ZFFSBH in (2,18) 17 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 18 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 19 15:31:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 20 15:31:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 21 15:31:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 22 15:31:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 23 15:31:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 24 15:31:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 25 15:31:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 26 15:31:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 27 15:31:04 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 28 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 29 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 30 15:31:04 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 31 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 32 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 33 15:31:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 34 15:31:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 15:31:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 36 15:31:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 37 15:31:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 38 15:31:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 39 15:31:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 40 15:31:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 41 15:31:04 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 42 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 43 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 44 15:31:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 45 15:31:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 46 15:31:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 47 15:31:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 48 15:31:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 49 15:31:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 50 15:31:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 51 15:31:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 52 15:31:04 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 53 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 54 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 55 15:31:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 15:31:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 57 15:31:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 58 15:31:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 59 15:31:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 60 15:31:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 61 15:31:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 62 15:31:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 63 15:31:04 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 64 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 65 15:31:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 66 15:31:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 15:31:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 68 15:31:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 69 15:31:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 70 15:31:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 71 15:31:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 72 15:31:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 73 15:31:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 74 15:31:04 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 75 15:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 76 15:31:04 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 77 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 78 15:31:05 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 79 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 80 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 81 15:31:05 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0 from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 82 15:31:05 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 83 15:31:05 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 84 15:31:05 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 85 15:31:05 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 86 15:31:05 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 87 15:31:05 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25测试库 88 15:31:05 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 89 15:31:05 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 90 15:31:05 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 91 15:31:05 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 92 15:31:05 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 93 15:31:05 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 94 15:31:05 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000 95 15:31:05 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 96 15:31:05 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 97 15:31:05 SQL Data In: ORACLE - Param = 16, Name = PINCS00, Type = fldZSTRING, Precision = 67, Scale = 0, Data = 09330038||||139317|退预交金|平台支付|-0.01|0|N||20210203153104||193 98 15:31:05 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 99 15:31:05 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 100 15:31:05 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 15:31:05 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 15:31:05 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_ZFRZ00" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PZYHGHH => :PZYHGHH,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PJFBZ00 => :PJFBZ00,PJZDH00 => :PJZDH00,PYJDH00 => :PYJDH00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PJFJE00 => :PJFJE00,PFKTM00 => :PFKTM00,PTKDDH0 => :PTKDDH0,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END; 103 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 104 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 105 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 106 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 107 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 108 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 109 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 110 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 111 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 112 15:31:05 SQL Execute: ORACLE - COMMIT 113 15:31:05 SQL Data In: ORACLE - Rows affected = 0 114 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 115 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 116 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 117 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 118 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 119 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 120 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031531040348 121 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param 122 15:31:05 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 123 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031531040348 124 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra 125 15:31:05 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 126 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 127 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 128 15:31:05 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 129 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = {"transType":"hop.trade.setinfo","param":{"serveraddr":"http://192.168.1.174:8060/onepay-web/oneweb/oneapi","appid":"1ESC4PDP9009AE01A8C000002A7ADB55","appsecret":"1ESC4PDOC00FAE01A8C000005EF91C22"},"notes":"缴费退款|0|09330038||||139317|退预交金|平台支付 130 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031531040348 131 15:31:05 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=? 132 15:31:05 SQL Data In: ORACLE - Rows affected = 1 133 15:31:05 SQL Execute: ORACLE - COMMIT 134 15:31:05 SQL Data In: ORACLE - Rows affected = 0 135 15:31:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 85, Scale = 0, Data = {"encryptType":"PLAIN","param":null,"respCode":"030002","respMsg":"原订单流水不存在"} 136 15:31:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030002 137 15:31:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 原订单流水不存在 138 15:31:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031531040348 139 15:31:05 SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=? 140 15:31:05 SQL Data In: ORACLE - Rows affected = 1 141 15:31:05 SQL Execute: ORACLE - COMMIT 142 15:31:05 SQL Data In: ORACLE - Rows affected = 0 143 15:31:05 SQL Execute: ORACLE - Rollback 144 15:31:05 SQL Data In: ORACLE - Rows affected = 0