1       17:22:16  SQL Prepare: ORACLE - select ID0000,SFXMMC,SFJE00,ZCS000,JE0000 from VW_BQ_FJZXXM
where YZID00 = :1
and TZRQ00 is null
and CSLY00 = '2'

2       17:22:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5076341.000000
3       17:22:16  SQL Execute: ORACLE - select ID0000,SFXMMC,SFJE00,ZCS000,JE0000 from VW_BQ_FJZXXM
where YZID00 = ?
and TZRQ00 is null
and CSLY00 = '2'

4       17:22:16  SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where name00 = 'YZ_XZHDHS'

5       17:22:16  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where name00 = 'YZ_XZHDHS'

6       17:22:16  SQL Prepare: ORACLE - BEGIN "SP_BQ_YJYZQT" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_HDRXM0 => :P_HDRXM0,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00,P_CZY000 => :P_CZY000); END;
7       17:22:16  SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
8       17:22:16  SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5076341.000000
9       17:22:16  SQL Data In: ORACLE - Param = 3, Name = P_HDRXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ʵ´ï
10      17:22:16  SQL Data In: ORACLE - Param = 4, Name = P_TZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 952.000000
11      17:22:16  SQL Data In: ORACLE - Param = 5, Name = P_TZRXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ʵ´ï
12      17:22:16  SQL Data In: ORACLE - Param = 6, Name = P_TZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110623
13      17:22:16  SQL Data In: ORACLE - Param = 7, Name = P_TZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:03:00
14      17:22:16  SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
15      17:22:16  SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 952.000000
16      17:22:16  SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZQT" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_HDRXM0 => :P_HDRXM0,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00,P_CZY000 => :P_CZY000); END;
17      17:22:16  SQL Prepare: ORACLE - Commit

18      17:22:16  SQL Execute: ORACLE - Commit

19      17:22:16  SQL Data In: ORACLE - Rows affected = 0
20      17:22:16  SQL Prepare: ORACLE - select * from bq_yjyz00 where yzmxid= 5076341

21      17:22:16  SQL Execute: ORACLE - select * from bq_yjyz00 where yzmxid= 5076341

22      17:22:16  SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00
where ZYID00 = :1

23      17:22:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 771363.000000
24      17:22:16  SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00
where ZYID00 = ?

25      17:22:16  SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1
and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD')))
order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID

26      17:22:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 771363.000000
27      17:22:16  SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ?
and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD')))
order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID