1 17:25:36 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 2 17:25:36 SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM 3 17:25:36 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_ZY' 4 17:25:36 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'JKQYSQM' 5 17:25:36 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'SFJYSZFW' 6 17:25:36 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'CYJSZFYM' 7 17:25:36 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'ZYYJJSTDJDYZFFS' 8 17:25:36 SQL Execute: ORACLE - select * from VW_BM_BRZFFS order by XSXH00 9 17:25:36 SQL Execute: ORACLE - select * from BM_YHKDM0 order by XSXH00 10 17:25:36 SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = -1.00 and PLBH00 in (4,8) 11 17:25:36 SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = -1.00 12 17:25:36 SQL Execute: ORACLE - select sysdate from dual 13 17:25:36 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 14 17:25:36 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 15 17:25:36 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1057,'管理员','192.168.29.129','00-0C-29-35-52-32','5','ACT_ZYSF_YW_YJJJKDJ','24131238') 16 17:25:36 SQL Data In: ORACLE - Rows affected = 1 17 17:25:36 SQL Execute: ORACLE - Commit 18 17:25:36 SQL Data In: ORACLE - Rows affected = 0 19 17:25:45 SQL Execute: ORACLE - select nvl(max(ZYID00),-1) MaxZYID from VW_ZY_BRXXB0 where ZYH000 = '00180019' 20 17:25:45 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 11601.00 21 17:25:45 SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 11601.00 and SFDJ00 = '0' 22 17:25:45 SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = 11601.00 and PLBH00 in (4,8) 23 17:25:45 SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = 11601.00 24 17:25:45 SQL Execute: ORACLE - select sysdate from dual 25 17:25:45 SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 11601.00 and KDRQ00 <= '20181203' order by SFYP00,ZXKSBH,XMBH00 26 17:25:45 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 27 17:25:45 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 28 17:25:51 SQL Execute: ORACLE - select * from BM_BRZFFS where ZFFSBH in (2,18) 29 17:25:57 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 30 17:25:57 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 31 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 32 17:25:57 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 33 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 34 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 35 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 36 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 37 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 38 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 39 17:25:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 40 17:25:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 41 17:25:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 42 17:25:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 43 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 44 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 45 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 46 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 47 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 48 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 49 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 50 17:25:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 51 17:25:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 52 17:25:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 53 17:25:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 54 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 55 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 56 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 57 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 58 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 60 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 61 17:25:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 62 17:25:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 63 17:25:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 64 17:25:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 65 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 66 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 67 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 68 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 69 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 71 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 72 17:25:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 73 17:25:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 74 17:25:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 75 17:25:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 76 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 77 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 78 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金 79 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 80 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 81 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 82 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 83 17:25:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 84 17:25:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 85 17:25:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 86 17:25:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 87 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 88 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 89 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 90 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 91 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 92 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 93 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 94 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYSFZX(?,?,?,?,?,?)FHXX00 from dual 95 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 96 17:25:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 97 17:25:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 98 17:25:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 99 17:25:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 100 17:25:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 101 17:25:57 SQL Execute: ORACLE - Select SF_ZY_PAYSFZX(?,?,?,?,?,?)FHXX00 from dual 102 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 103 17:25:57 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 104 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000 105 17:25:57 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 106 17:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11601.000000 107 17:25:57 SQL Execute: ORACLE - select a.*,b.* from bm_brxxb0 a,zy_brxxb0 b where a.brid00=b.brid00 and b.zyid00=? 108 17:25:58 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 109 17:25:58 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2079989.000000 110 17:25:58 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11601.000000 111 17:25:58 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00180019 112 17:25:58 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000 113 17:25:58 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 114 17:25:58 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 115 17:25:58 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 116 17:25:58 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 117 17:25:58 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 118 17:25:58 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 119 17:25:58 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 120 17:25:58 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 121 17:25:58 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 122 17:25:58 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 123 17:25:58 SQL Data In: ORACLE - Param = 16, Name = PINCS00, Type = fldZSTRING, Precision = 51, Scale = 0, Data = 0||||11601|收预交金|现金|30.00|0|N||20181203172558| 124 17:25:58 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 125 17:25:58 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 126 17:25:58 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 17:25:58 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 17:25:58 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; 129 17:25:58 SQL Execute: ORACLE - COMMIT 130 17:25:58 SQL Data In: ORACLE - Rows affected = 0 131 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 132 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 133 17:25:58 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 134 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 135 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 136 17:25:58 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 137 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 138 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param 139 17:25:58 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 140 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 141 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra 142 17:25:58 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 143 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 144 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 145 17:25:58 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 146 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 147 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 148 17:25:58 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=? 149 17:25:58 SQL Data In: ORACLE - Rows affected = 1 150 17:25:58 SQL Execute: ORACLE - COMMIT 151 17:25:58 SQL Data In: ORACLE - Rows affected = 0 152 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 153 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 000000 154 17:25:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 模拟支付成功 155 17:25:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 156 17:25:58 SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=? 157 17:25:58 SQL Data In: ORACLE - Rows affected = 1 158 17:25:58 SQL Execute: ORACLE - COMMIT 159 17:25:58 SQL Data In: ORACLE - Rows affected = 0 160 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 161 17:25:58 SQL Execute: ORACLE - Select SF_SF_ICKH00_CARDNO(?)FHXX00 from dual 162 17:25:58 SQL Data In: ORACLE - Param = 1, Name = IN_OPERETORID, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 163 17:25:58 SQL Data In: ORACLE - Param = 2, Name = IN_OPERETORNAME, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员 164 17:25:58 SQL Data In: ORACLE - Param = 3, Name = IN_TERMNO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 165 17:25:58 SQL Data In: ORACLE - Param = 4, Name = IN_CARDTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 166 17:25:58 SQL Data In: ORACLE - Param = 5, Name = IN_CARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00180019 167 17:25:58 SQL Data In: ORACLE - Param = 6, Name = IN_ACCOUNTTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 168 17:25:58 SQL Data In: ORACLE - Param = 7, Name = IN_IDNO, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350103194612280065 169 17:25:58 SQL Data In: ORACLE - Param = 8, Name = IN_DEPOSITTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 170 17:25:58 SQL Data In: ORACLE - Param = 9, Name = IN_AMOUNT, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 30.00 171 17:25:58 SQL Data In: ORACLE - Param = 10, Name = IN_CHANNELTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 172 17:25:58 SQL Data In: ORACLE - Param = 11, Name = IN_OUTRECHARGENO, Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 173 17:25:58 SQL Data In: ORACLE - Param = 12, Name = IN_RECHARGENO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 174 17:25:58 SQL Data In: ORACLE - Param = 13, Name = IN_EXTERNALNO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 175 17:25:58 SQL Data In: ORACLE - Param = 14, Name = IN_POSTRANS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 176 17:25:58 SQL Data In: ORACLE - Param = 15, Name = IN_NOTES, Type = fldZSTRING, Precision = 56, Scale = 0, Data = 22|0|0||||11601|收预交金|现金|30.00|0|N||20181203172558| 177 17:25:58 SQL Data In: ORACLE - Param = 16, Name = OUT_RETCODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 178 17:25:58 SQL Data In: ORACLE - Param = 17, Name = OUT_RETMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 179 17:25:58 SQL Data In: ORACLE - Param = 18, Name = OUT_BALANCE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 180 17:25:58 SQL Data In: ORACLE - Param = 19, Name = OUT_TRACETIME, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 181 17:25:58 SQL Data In: ORACLE - Param = 20, Name = OUT_TRACENO, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 182 17:25:58 SQL Execute: ORACLE - BEGIN "SP_PAY_YJJ_ZHCZ" (IN_OPERETORID => :IN_OPERETORID,IN_OPERETORNAME => :IN_OPERETORNAME,IN_TERMNO => :IN_TERMNO,IN_CARDTYPE => :IN_CARDTYPE,IN_CARDNO => :IN_CARDNO,IN_ACCOUNTTYPE => :IN_ACCOUNTTYPE,IN_IDNO => :IN_IDNO,IN_DEPOSITTYPE => :IN_DEPOSITTYPE,IN_AMOUNT => :IN_AMOUNT,IN_CHANNELTYPE => :IN_CHANNELTYPE,IN_OUTRECHARGENO => :IN_OUTRECHARGENO,IN_RECHARGENO => :IN_RECHARGENO,IN_EXTERNALNO => :IN_EXTERNALNO,IN_POSTRANS => :IN_POSTRANS,IN_NOTES => :IN_NOTES,OUT_RETCODE => :OUT_RETCODE,OUT_RETMSG => :OUT_RETMSG,OUT_BALANCE => :OUT_BALANCE,OUT_TRACETIME => :OUT_TRACETIME,OUT_TRACENO => :OUT_TRACENO); END; 183 17:25:58 SQL Execute: ORACLE - Rollback 184 17:25:58 SQL Data In: ORACLE - Rows affected = 0 185 17:25:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2079989.000000 186 17:25:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY201812031724240844 187 17:25:58 SQL Execute: ORACLE - select * from BM_ZFRZ00 where BRID00=? and DDLSH0=? 188 17:25:58 SQL Execute: ORACLE - select PJH000 from ZY_BRJFB0 where DJH000 = 0.00 189 17:25:58 SQL Execute: ORACLE - select nvl(max(PJXH00),'0') PJXH00 from ZY_PJSYQK where PJH000 = 0.00 190 17:26:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 191 17:26:18 SQL Execute: ORACLE - select * from VW_ZY_YJJPJ0_NEW where PJH000 = ? 192 17:26:18 SQL Execute: ORACLE - select 1057 as UserId,'9999' as UserCode,'管理员' as UserName,2113 as UserLogDepId,'分院住院处' as UserLogDepName, '5' as UserLogSysCode,'住院收费管理系统' as UserLogSysName,'220007' as HospitalCode,'福建中医药大学附属人民医院' as HospitalName, '229112' as UserLogDepYYID,'南平市第一医院' as UserLogDepYYMC from dual 193 17:26:26 SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = -1.00 and PLBH00 in (4,8) 194 17:26:26 SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = -1.00 195 17:26:26 SQL Execute: ORACLE - select sysdate from dual 196 17:26:26 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual 197 17:26:26 SQL Execute: ORACLE - select SF_ZY_GETPJXH(1057,8,2113) as PJDQH0 from dual