1       17:17:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
2       17:17:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081523:59:59
3       17:17:47  SQL Execute: ORACLE -  select  NVL(sum(A.HJJE00),0) JE0000  from  zy_brfy00 A  where  A.CZRQ00 <=?  and  A.CZRQ00||A.CZSJ00 < ? and JZDH00=0

4       17:18:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
5       17:18:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
6       17:18:42  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081523:59:59
7       17:18:42  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081523:59:59
8       17:18:42  SQL Execute: ORACLE -  select  NVL(sum(A.HJJE00),0) JE0000  from  zy_brfy00 A,zy_jzb000 B where  A.jzdh00 = B.jzdh00 and B.jzrq00 >=?  and A.CZRQ00 <=? and A.CZRQ00||A.CZSJ00 < ? and B.JZRQ00||B.JZSJ00 > ?   

9       17:21:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
10      17:21:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081500:00:00
11      17:21:09  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
12      17:21:09  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081523:59:59
13      17:21:09  SQL Execute: ORACLE -  select  NVL(sum(B.HJJE00),0) JE0000  from  zy_brfy00 A,zy_fymx00 B where A.DJH000=B.DJH000 and  A.CZRQ00 >=?  and  A.CZRQ00||A.CZSJ00 >= ? and A.CZRQ00 <=?  and  A.CZRQ00||A.CZSJ00 <= ?

14      17:21:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
15      17:21:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081500:00:00
16      17:21:23  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120815
17      17:21:23  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012081523:59:59
18      17:21:23  SQL Execute: ORACLE -  select  NVL(sum(B.HJJE00),0) JE0000  from  zy_jzb000 B where  B.jzrq00 >=?  and  B.JZRQ00||B.JZSJ00 >=? and B.jzrq00 <=?  and  B.JZRQ00||B.JZSJ00 <=?

19      17:21:23  SQL Execute: ORACLE - select  '住院处' XMMC00 ,to_char(15708086.02) QQJC00 ,to_char(1279037.57) BQZJ00 ,to_char(2079640.10) BQJS00, to_char(14907483.49) BQJC00   from  dual 
 union  all  
select  '财务科' XMMC00 ,NULL QQJC00 ,NULL BQZJ00 , NULL BQJS00,NULL BQJC00   from  dual 
 union  all  
select  '财务科调拨' XMMC00 ,NULL QQJC00 ,NULL BQZJ00 , NULL BQJS00,NULL BQJC00   from  dual 
 union  all  
select  '财务科调整数' XMMC00 ,NULL QQJC00 ,NULL BQZJ00 , NULL BQJS00,NULL BQJC00   from  dual