1       16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
2       16:16:38  SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and  dlxh00>0  
 order by jzys00,dlxh00

3       16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
4       16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
5       16:16:38  SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and dlxh00>0  and SF_MZHS_CHECKWB(ghqssj,ghjssj)='1' 
 order by  decode(HZZT00,'4',-1,0),dlxh00,SFXZ00

6       16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
7       16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
8       16:16:38  SQL Execute: ORACLE - select * from vw_ys_yzbr00
where jzks00=? and jzys00=?
 order by dlxh00 desc

9       16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
10      16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
11      16:16:38  SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a,
 (select count(*) total,hzlb00 ,jzys00 from VW_YS_HZBR00  where hzlb00>0 and jzks00=?  group by hzlb00,jzys00 ) b 
 where  a.hzlb00=b.hzlb00 and jzys00=?
 
 

12      16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
13      16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
14      16:16:38  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
15      16:16:38  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where hzlb00=? and (jzys00=? or jzys00=0)
and jzks00=? and nvl(dlxh00,0)=0

16      16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
17      16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
18      16:16:38  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
19      16:16:38  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where hzlb00=? and (jzys00=? or jzys00=0)
and jzks00=? and nvl(dlxh00,0)=0

20      16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
21      16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
22      16:16:38  SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=?  and jzys00=? and HZZT00='2' and  dlxh00>0

23      16:16:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000
24      16:16:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1209.000000
25      16:16:38  SQL Execute: ORACLE - select a.YYH000,a.YYJSSJ,decode(a.YYZT00,'0','µÇ¼Ç','È·ÈÏ') YYZT00,a.BRXM00,a.BRXB00,a.YYID00  from vw_yy_bryyxxcx  a where a.YYRQ00=to_char(sysdate,'YYYYMMDD') and a.YYZT00 in ('0','1') 
 and a.YYKSBH=?
 and a.YYYSBH=?
 order by a.YYJSSJ

26      16:16:41  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=8 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'