1 15:29:19 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' 2 15:29:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 3 15:29:19 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' and MC0000 =? 4 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 5 15:29:26 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 6 15:29:26 SQL Execute: ORACLE - Select SYSDATE from Dual 7 15:29:26 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 8 15:29:26 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') 9 15:29:26 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0227769100484745' and ICKNBH = '0227769100484745' 10 15:29:26 SQL Execute: ORACLE - select * from BM_BRZFFS where ZFFSBH in (2,18) 11 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 12 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 13 15:29:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 14 15:29:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 15:29:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 16 15:29:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 17 15:29:26 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 18 15:29:26 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 19 15:29:26 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 20 15:29:26 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 21 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 22 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 23 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 24 15:29:26 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 25 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 26 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 27 15:29:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 15:29:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 15:29:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 30 15:29:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 31 15:29:26 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 32 15:29:26 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 33 15:29:26 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 34 15:29:26 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 36 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 37 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 38 15:29:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 15:29:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 40 15:29:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 41 15:29:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 42 15:29:26 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 43 15:29:26 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 44 15:29:26 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 45 15:29:26 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 46 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 47 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 48 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 49 15:29:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 50 15:29:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 51 15:29:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 52 15:29:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 53 15:29:26 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 54 15:29:26 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 55 15:29:26 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 56 15:29:26 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 57 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 58 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 59 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 60 15:29:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 61 15:29:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 62 15:29:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 63 15:29:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 64 15:29:26 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 65 15:29:26 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 66 15:29:26 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 67 15:29:26 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 68 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 69 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 70 15:29:26 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 71 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 72 15:29:26 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 73 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 74 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 75 15:29:26 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=? 76 15:29:26 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 77 15:29:26 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 78 15:29:26 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 79 15:29:26 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 15:29:26 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 81 15:29:26 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25测试库 82 15:29:26 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 83 15:29:26 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 84 15:29:26 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 85 15:29:26 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 86 15:29:26 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 87 15:29:26 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 88 15:29:26 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.010000 89 15:29:26 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 90 15:29:26 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 15:29:26 SQL Data In: ORACLE - Param = 16, Name = PINCS00, Type = fldZSTRING, Precision = 61, Scale = 0, Data = 107||||139317|收预交金|平台支付|0.01|0|N||20210203152926||193 92 15:29:26 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 93 15:29:26 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 15:29:26 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 15:29:26 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 15:29:26 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; 97 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 98 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 99 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 100 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 101 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 102 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 103 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 104 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 105 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 106 15:29:26 SQL Execute: ORACLE - COMMIT 107 15:29:26 SQL Data In: ORACLE - Rows affected = 0 108 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 109 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 110 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 111 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 112 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 113 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 114 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031529250347 115 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param 116 15:29:26 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 117 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031529250347 118 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra 119 15:29:26 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 120 15:29:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 121 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 122 15:29:26 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 123 15:29:26 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|107||||139317|收预交金|平台支付|0.01 124 15:29:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031529250347 125 15:29:26 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=? 126 15:29:26 SQL Data In: ORACLE - Rows affected = 1 127 15:29:26 SQL Execute: ORACLE - COMMIT 128 15:29:26 SQL Data In: ORACLE - Rows affected = 0 129 15:29:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 000000 130 15:29:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付成功交易成功 131 15:29:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031529250347 132 15:29:54 SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=? 133 15:29:54 SQL Data In: ORACLE - Rows affected = 1 134 15:29:54 SQL Execute: ORACLE - COMMIT 135 15:29:54 SQL Data In: ORACLE - Rows affected = 0 136 15:29:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 137 15:29:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031529250347 138 15:29:54 SQL Execute: ORACLE - select * from BM_ZFRZ00 where BRID00=? and DDLSH0=? 139 15:30:01 SQL Execute: ORACLE - select SF_SF_JJYJJSFZDZXBKSXM('0') as SFZDZX,SF_SF_JJYJJSFZDZXBKSXM('1') as SFTCTS from dual