1       10:57:18  SQL Prepare: ORACLE - select sum(XYGJJE) XYGJJE,sum(CYGJJE) CYGJJE,sum(ZYGJJE) ZYGJJE,sum(YXGJJE) YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND jzyf00>='201206' and JZYF00<'202104' and XMBH00='10' 

2       10:57:18  SQL Execute: ORACLE - select sum(XYGJJE) XYGJJE,sum(CYGJJE) CYGJJE,sum(ZYGJJE) ZYGJJE,sum(YXGJJE) YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND jzyf00>='201206' and JZYF00<'202104' and XMBH00='10' 

3       10:57:18  SQL Prepare: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND  JZYF00='202104' and XMBH00='00' 

4       10:57:18  SQL Execute: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND  JZYF00='202104' and XMBH00='00' 

5       10:57:18  SQL Prepare: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='97' 

6       10:57:18  SQL Execute: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='97' 

7       10:57:18  SQL Prepare: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='99' 

8       10:57:18  SQL Execute: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='99' 

9       10:57:18  SQL Prepare: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='10' 

10      10:57:18  SQL Execute: ORACLE - select XYGJJE,CYGJJE,ZYGJJE,YXGJJE FROM YK_JXCYB0
WHERE YKBMBH=11 AND JZYF00='202104' and XMBH00='10' 

11      10:57:18  SQL Prepare: ORACLE - select JZRQ00,JZSJ00,YKBMBH,XMBH00,XMMC00,XYLSJE,CYLSJE,ZYLSJE,YXLSJE,XH0000,JZYF00,CZYBH0,
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, YXGJJE), YXGJJE) YXGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',21267179.52,'99',4997706.69,'00',5590635.96, XYGJJE), XYGJJE) XYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, CYGJJE), CYGJJE) CYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, ZYGJJE), ZYGJJE) ZYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',YXGJJE,0),0) YXCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',XYGJJE,0),0) XYCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',CYGJJE,0),0) CYCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',ZYGJJE,0),0) ZYCJJE,
SUBSTR(JZRQ00,1,4)||'-'||SUBSTR(JZRQ00,5,2)||'-'||SUBSTR(JZRQ00,7,2)||' '||JZSJ00 as JZRQSJ  
 FROM YK_JXCYB0 
 WHERE YKBMBH=:1 AND JZYF00=:2 
 ORDER BY JZRQ00,JZSJ00,XH0000,XMBH00

12      10:57:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000
13      10:57:18  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 202104
14      10:57:18  SQL Execute: ORACLE - select JZRQ00,JZSJ00,YKBMBH,XMBH00,XMMC00,XYLSJE,CYLSJE,ZYLSJE,YXLSJE,XH0000,JZYF00,CZYBH0,
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, YXGJJE), YXGJJE) YXGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',21267179.52,'99',4997706.69,'00',5590635.96, XYGJJE), XYGJJE) XYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, CYGJJE), CYGJJE) CYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',0,'97',0,'99',0,'00',0, ZYGJJE), ZYGJJE) ZYGJJE, 
DECODE('Y','Y',DECODE(XMBH00,'10',YXGJJE,0),0) YXCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',XYGJJE,0),0) XYCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',CYGJJE,0),0) CYCJJE,
DECODE('Y','Y',DECODE(XMBH00,'10',ZYGJJE,0),0) ZYCJJE,
SUBSTR(JZRQ00,1,4)||'-'||SUBSTR(JZRQ00,5,2)||'-'||SUBSTR(JZRQ00,7,2)||' '||JZSJ00 as JZRQSJ  
 FROM YK_JXCYB0 
 WHERE YKBMBH=? AND JZYF00=? 
 ORDER BY JZRQ00,JZSJ00,XH0000,XMBH00