1       16:27:22  SQL Prepare: ORACLE - select * from (select WZMC00, WZSXMC, WZGG00, WZXH00, 
BZDW00,decode(decode(sign(DJBZ00-1),'-1',concat('0',to_char(DJBZ00)),to_char(DJBZ00)),'0','',decode(sign(DJBZ00-1),'-1',concat('0',to_char(DJBZ00)),to_char(DJBZ00))) DJBZ00, 
decode(decode(sign(ZMSBZ0-1),'-1',concat('0',to_char(ZMSBZ0)),to_char(ZMSBZ0)),'0','',decode(sign(ZMSBZ0-1),'-1',concat('0',to_char(ZMSBZ0)),to_char(ZMSBZ0))) ZMSBZ0, ZMJE00, 
decode(decode(decode(sign(SWSBZ0-1),'-1',concat('0',to_char(SWSBZ0)),to_char(SWSBZ0)),'0',''),'0','',decode(sign(SWSBZ0-1),'-1',concat('0',to_char(SWSBZ0)),to_char(SWSBZ0))) SWSBZ0,
SWJE00, decode(to_char(YKSBZ0),'0','',to_char(YKSBZ0)) YKSBZ0, YKJE00,PDMXID 
 from VW_WZ_PDMX00 where PDID00=:1
 union all
 select '合计：',   null,    null,   null, 
 null,    null,    null,    sum(ZMJE00), 
 null,   sum(SWJE00),null,  sum(YKJE00), 
 0 PDMXID from VW_WZ_PDMX00   where PDID00=:2) order by PDMXID

2       16:27:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8202.000000
3       16:27:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8202.000000
4       16:27:22  SQL Execute: ORACLE - select * from (select WZMC00, WZSXMC, WZGG00, WZXH00, 
BZDW00,decode(decode(sign(DJBZ00-1),'-1',concat('0',to_char(DJBZ00)),to_char(DJBZ00)),'0','',decode(sign(DJBZ00-1),'-1',concat('0',to_char(DJBZ00)),to_char(DJBZ00))) DJBZ00, 
decode(decode(sign(ZMSBZ0-1),'-1',concat('0',to_char(ZMSBZ0)),to_char(ZMSBZ0)),'0','',decode(sign(ZMSBZ0-1),'-1',concat('0',to_char(ZMSBZ0)),to_char(ZMSBZ0))) ZMSBZ0, ZMJE00, 
decode(decode(decode(sign(SWSBZ0-1),'-1',concat('0',to_char(SWSBZ0)),to_char(SWSBZ0)),'0',''),'0','',decode(sign(SWSBZ0-1),'-1',concat('0',to_char(SWSBZ0)),to_char(SWSBZ0))) SWSBZ0,
SWJE00, decode(to_char(YKSBZ0),'0','',to_char(YKSBZ0)) YKSBZ0, YKJE00,PDMXID 
 from VW_WZ_PDMX00 where PDID00=?
 union all
 select '合计：',   null,    null,   null, 
 null,    null,    null,    sum(ZMJE00), 
 null,   sum(SWJE00),null,  sum(YKJE00), 
 0 PDMXID from VW_WZ_PDMX00   where PDID00=?) order by PDMXID

5       16:27:22  SQL Prepare: ORACLE - SELECT 
TO_CHAR(SYSDATE,'YYYY')||'年'||TO_CHAR(SYSDATE,'MM')||'月'||TO_CHAR(SYSDATE,'DD')||'日' RQ0000
 FROM DUAL

6       16:27:22  SQL Execute: ORACLE - SELECT 
TO_CHAR(SYSDATE,'YYYY')||'年'||TO_CHAR(SYSDATE,'MM')||'月'||TO_CHAR(SYSDATE,'DD')||'日' RQ0000
 FROM DUAL