1 17:42:01 SQL Execute: ORACLE - select * from BM_YHKDM0 ORDER BY YHKDH0
2 17:42:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000
3 17:42:01 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 2 and PJSYR0 = ?
and SYBZ00 = 'Y'
4 17:42:01 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
5 17:42:01 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
6 17:42:01 SQL Execute: ORACLE - select * from vw_sf_brjflb
7 17:42:01 SQL Execute: ORACLE - select * from VW_BM_BRZFFS where 1=1
and ZFFSBH<>18
order by nvl(XSXH00,0),ZFFSBH
8 17:42:01 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000
9 17:42:02 SQL Execute: ORACLE - Select SYSDATE from Dual
10 17:42:02 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'
11 17:42:02 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')
12 17:42:02 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
13 17:42:03 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 ='FZYBA85304910' and ICKNBH ='FZYBA85304910'
14 17:42:03 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =732401
15 17:42:03 SQL Execute: ORACLE - select A.*,B.FBMC00 from BM_BRXXB0 A, BM_BRFBB0 B where A.fbbh00 = B.fbbh00
and BRID00 in ( select BRID00 from IC_YHXX00 where ICKH00 = 'FZYBA85304910' and ZT0000='1' )
16 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
17 17:42:03 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =?
18 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
19 17:42:03 SQL Execute: ORACLE - select * from IC_YHXX00 where BRID00 = ? and ZT0000='1'
20 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
21 17:42:03 SQL Execute: ORACLE - select SF_SF_BRSFWJSFY(?) msg from dual
22 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
23 17:42:03 SQL Execute: ORACLE - select SF_SF_ZHYJJYEJY(?) FHJG00 from dual
24 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
25 17:42:03 SQL Execute: ORACLE - select * from SF_BRZHXX where JFLBID = 1 and BRID00 = ?
26 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
27 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
28 17:42:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Q
29 17:42:03 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual
30 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
31 17:42:03 SQL Execute: ORACLE - select tyje01,YBSBK0,ICKH00 from VW_SF_BRZHXX where brid00= ?
32 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
33 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
34 17:42:03 SQL Execute: ORACLE - select sum(CFZJE0)+sum(NVL(ZYDJFY,0)) JE0000,sum(NVL(ZYDJFY,0)) ZYDJFY from VW_SF_YFMZCF A where (A.BCCFH0 is null)
and A.CFZT00 = '0'
and A.BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
35 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
36 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
37 17:42:03 SQL Execute: ORACLE - select sum(ZJE000) JE0000 from VW_SF_YJYW00 where (CXDJH0 is null)
and SFDJH0+0 = 0 and XMZT00 = '1'
and BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
38 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
39 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
40 17:42:03 SQL Execute: ORACLE - select SUM(ROUND(B.YPZSL0*B.LSDJ00,2)*B.ZFBL00) JE0000 from VW_SF_YFMZCF A,YF_MZCFMX B where A.CFLSH0=B.CFLSH0 AND (A.BCCFH0 is null)
and A.CFZT00 = '0' and b.SFZBY0='N'
and A.BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
41 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
42 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
43 17:42:03 SQL Execute: ORACLE - select SUM(ZFJE00) JE0000 from VW_SF_YJYW00 A,YJ_YWJJ00 B where A.YJDJH0=B.YJDJH0 AND (CXDJH0 is null)
and SFDJH0+0 = 0 and XMZT00 = '1'
and BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
44 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
45 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
46 17:42:03 SQL Execute: ORACLE - select sum(CFZJE0)+sum(NVL(ZYDJFY,0)) JE0000 from VW_SF_YFMZCF A where (A.BCCFH0 is null)
and A.CFZT00 = '0'
and A.BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
47 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
48 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
49 17:42:03 SQL Execute: ORACLE - select sum(ZJE000) JE0000 from VW_SF_YJYW00 where (CXDJH0 is null)
and SFDJH0+0 = 0 and XMZT00 = '1'
and BRID00 = ?
and ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')+GHYXTS>=sysdate
and brid00= ?)
50 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
51 17:42:03 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual
52 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金
53 17:42:03 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=?
54 17:42:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
55 17:42:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
56 17:42:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Q
57 17:42:03 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual
58 17:42:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
59 17:42:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000
60 17:42:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Q
61 17:42:06 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual
62 17:42:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
63 17:42:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
64 17:42:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Q
65 17:42:07 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual
66 17:42:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
67 17:42:10 SQL Execute: ORACLE - select SF_SF_ZHYJJYEJY(?) FHJG00 from dual
68 17:42:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
69 17:42:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
70 17:42:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
71 17:42:10 SQL Execute: ORACLE - select SF_ZY_GETTKSJ(?,?,?) as FHXX00 from dual
72 17:42:10 SQL Execute: ORACLE - Select SYSDATE from Dual
73 17:42:10 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'
74 17:42:10 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')
75 17:42:10 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
76 17:42:11 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 ='FZYBA85304910' and ICKNBH ='FZYBA85304910'
77 17:42:11 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =732401
78 17:42:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
79 17:42:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
80 17:42:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
81 17:42:11 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 18159921003
82 17:42:11 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 18159921003
83 17:42:11 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
84 17:42:11 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual
85 17:42:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
86 17:42:11 SQL Execute: ORACLE - SELECT * FROM VW_SF_BRZFFS WHERE ZFFSBH = ?
87 17:42:11 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
88 17:42:11 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='支付统一平台参数' and BH0000='JKQYSQM') VALUE0,SF_BM_SQXQTSXX('JKQYSQM','支付统一平台参数',1513,'230029') TSXX00 from dual
89 17:42:11 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
90 17:42:11 SQL Data In: ORACLE - Param = 2, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
91 17:42:11 SQL Data In: ORACLE - Param = 3, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
92 17:42:11 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
93 17:42:11 SQL Data In: ORACLE - Param = 5, Name = PJYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000
94 17:42:11 SQL Data In: ORACLE - Param = 6, Name = PQTCS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
95 17:42:11 SQL Data In: ORACLE - Param = 7, Name = PCXLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
96 17:42:11 SQL Data In: ORACLE - Param = 8, Name = PTKJLS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
97 17:42:11 SQL Data In: ORACLE - Param = 9, Name = PTKJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
98 17:42:11 SQL Data In: ORACLE - Param = 10, Name = PERRSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
99 17:42:11 SQL Data In: ORACLE - Param = 11, Name = PXTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Q
100 17:42:11 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_TKDATA" (PBRID00 => :PBRID00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PMZZYBZ => :PMZZYBZ,PJYJE00 => :PJYJE00,PQTCS00 => :PQTCS00,PCXLSH0 => :PCXLSH0,PTKJLS0 => :PTKJLS0,PTKJE00 => :PTKJE00,PERRSTR => :PERRSTR,PXTCS00 => :PXTCS00); END;
101 17:42:11 SQL Execute: ORACLE - commit
102 17:42:11 SQL Data In: ORACLE - Rows affected = 0
103 17:42:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
104 17:42:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20210125174301
105 17:42:11 SQL Execute: ORACLE - select * from PAY_YJJ_MXCX where BRID00=? and CXLSH0=? order by DJH000 desc
106 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000
107 17:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
108 17:42:19 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual
109 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
110 17:42:19 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
111 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
112 17:42:19 SQL Execute: ORACLE - SELECT * FROM VW_SF_BRZFFS WHERE ZFFSBH = ?
113 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000
114 17:42:19 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
115 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
116 17:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
117 17:42:19 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=?
118 17:42:19 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
119 17:42:19 SQL Execute: ORACLE - insert into BM_ZFPTCS(NBID00,JKQQCS)values ('122','0Q13退预交金124微信支付-0.01YLPAYY732401000020316888|MZ202101251742300140|20210125174227200214520|4200000790202101252624456941|732401|退预交金|FZYBA85304910|-0.01|0|N|E|20210125174300MZ202101251742300140020210125174300000.01N0192.168.10.500')
120 17:42:19 SQL Data In: ORACLE - Rows affected = 1
121 17:42:19 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000
122 17:42:19 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
123 17:42:19 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
124 17:42:19 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
125 17:42:19 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000
126 17:42:19 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
127 17:42:19 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
128 17:42:19 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
129 17:42:19 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
130 17:42:19 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
131 17:42:19 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
132 17:42:19 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
133 17:42:19 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000
134 17:42:19 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
135 17:42:19 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251742300140
136 17:42:19 SQL Data In: ORACLE - Param = 16, Name = PPJXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
137 17:42:19 SQL Data In: ORACLE - Param = 17, Name = PZDBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
138 17:42:19 SQL Data In: ORACLE - Param = 18, Name = PZFQDBM, Type = fldZSTRING, Precision = 5, Scale = 0, Data = YLPAY
139 17:42:19 SQL Data In: ORACLE - Param = 19, Name = PZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
140 17:42:19 SQL Data In: ORACLE - Param = 20, Name = PZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
141 17:42:19 SQL Data In: ORACLE - Param = 21, Name = PZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
142 17:42:19 SQL Data In: ORACLE - Param = 22, Name = PINCS00, Type = fldZSTRING, Precision = 144, Scale = 0, Data = 13|0|20316888|MZ202101251742300140|20210125174227200214520|4200000790202101252624456941|732401|退预交金|FZYBA85304910|-0.01|0|N|E|20210125174300
143 17:42:19 SQL Data In: ORACLE - Param = 23, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
144 17:42:19 SQL Data In: ORACLE - Param = 24, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
145 17:42:19 SQL Data In: ORACLE - Param = 25, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
146 17:42:19 SQL Data In: ORACLE - Param = 26, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
147 17:42:19 SQL Data In: ORACLE - Param = 27, Name = PJKQQCS, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 122
148 17:42:19 SQL Data In: ORACLE - Param = 28, Name = PZFMXBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
149 17:42:19 SQL Data In: ORACLE - Param = 29, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
150 17:42:19 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_YNZFRZ" (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,PPJXH00 => :PPJXH00,PZDBH00 => :PZDBH00,PZFQDBM => :PZFQDBM,PZPKHYH => :PZPKHYH,PZPDWMC => :PZPDWMC,PZPH000 => :PZPH000,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG,PJKQQCS => :PJKQQCS,PZFMXBH => :PZFMXBH,PCZYKS0 => :PCZYKS0); END;
151 17:42:19 SQL Execute: ORACLE - COMMIT
152 17:42:19 SQL Data In: ORACLE - Rows affected = 0
153 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
154 17:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
155 17:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251742300140
156 17:42:19 SQL Execute: ORACLE - Select B.ZFMXBH from BM_ZFRZ00 A ,SF_BRJFB0 B
where A.BRID00=B.BRID00 and A.DJH000=B.DJH000 and A.BRID00=? and A.MZZYBZ=? and A.DDLSH0=?
157 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
158 17:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = E
159 17:42:19 SQL Execute: ORACLE - Select * from BM_ZFFSMX where ZFFSBH=? and ZFMXBH=?
160 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
161 17:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=?
and FSLX00 in ('0','2') and lower(CSLXMC)='header'
order by MXID00
162 17:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
163 17:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=?
and FSLX00 in ('0','2') and lower(CSLXMC)='body'
order by MXID00
164 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 00
165 17:42:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退款成功
166 17:42:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
167 17:42:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
168 17:42:21 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=?,OUTCS0=?,JKXYBM=?,JKXYXX=?,BZ0000=? where DDLSH0=?
169 17:42:21 SQL Data In: ORACLE - Rows affected = 1
170 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
171 17:42:21 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=?
and FSLX00 in ('1','2')
order by MXID00
172 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.01
173 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
174 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = refund_amount
175 17:42:21 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
176 17:42:21 SQL Data In: ORACLE - Rows affected = 1
177 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 28, Scale = 0, Data = 4200000790202101252624456941
178 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
179 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = trade_no
180 17:42:21 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
181 17:42:21 SQL Data In: ORACLE - Rows affected = 1
182 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 21, Scale = 0, Data = 202101251743051022771
183 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
184 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = out_request_no
185 17:42:21 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
186 17:42:21 SQL Data In: ORACLE - Rows affected = 1
187 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = YLPAY
188 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 00
189 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
190 17:42:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
191 17:42:21 SQL Execute: ORACLE - Select SF_SF_PAYZT0(?,?,?,?)FHXX00 from dual
192 17:42:21 SQL Execute: ORACLE - COMMIT
193 17:42:21 SQL Data In: ORACLE - Rows affected = 0
194 17:42:21 SQL Data In: ORACLE - Param = 1, Name = PDDLSH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
195 17:42:21 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000
196 17:42:21 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
197 17:42:21 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
198 17:42:21 SQL Data In: ORACLE - Param = 5, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
199 17:42:21 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000
200 17:42:21 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
201 17:42:21 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
202 17:42:21 SQL Data In: ORACLE - Param = 9, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
203 17:42:21 SQL Data In: ORACLE - Param = 10, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
204 17:42:21 SQL Data In: ORACLE - Param = 11, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
205 17:42:21 SQL Data In: ORACLE - Param = 12, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000
206 17:42:21 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
207 17:42:21 SQL Data In: ORACLE - Param = 14, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
208 17:42:21 SQL Data In: ORACLE - Param = 15, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
209 17:42:21 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_YNZFQR" (PDDLSH0 => :PDDLSH0,PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PZYHGHH => :PZYHGHH,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PJFBZ00 => :PJFBZ00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PJFJE00 => :PJFJE00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
210 17:42:21 SQL Execute: ORACLE - COMMIT
211 17:42:21 SQL Data In: ORACLE - Rows affected = 0
212 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
213 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202101251743090141
214 17:42:21 SQL Execute: ORACLE - select * from BM_ZFRZ00 where BRID00=? and DDLSH0=?
215 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 732401.000000
216 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金
217 17:42:21 SQL Execute: ORACLE - select * from SF_BRZHXX where brid00 = ?
and jflbid in ( select JFLBID from BM_BRJFLB where jflbmc = ?)
218 17:42:21 SQL Execute: ORACLE - select BRZJBH,brid00 from BM_BRXXB0 where BRBLH0='*527901' and BRZJLX='身份证'
219 17:42:21 SQL Execute: ORACLE - SELECT a.*,decode('N','Y','补打','N',' ') SFBD00 FROM VW_SF_BRJFXX a where a.DJH000=0
220 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
221 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
222 17:42:21 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=?
223 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
224 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
225 17:42:21 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence
226 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
227 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
228 17:42:21 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence
229 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
230 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
231 17:42:21 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence
232 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
233 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
234 17:42:21 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence
235 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
236 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
237 17:42:21 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence
238 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
239 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
240 17:42:21 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence
241 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
242 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
243 17:42:21 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence
244 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
245 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
246 17:42:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
247 17:42:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
248 17:42:21 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID
249 17:42:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
250 17:42:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
251 17:42:21 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence