1       16:53:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 357227.000000
2       16:53:43  SQL Execute: ORACLE - select count(distinct F.SFXMID) FROM ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F where   a.ZYID00=? and  a.djh000=b.djh000 and  b.XMBH00  = F.SFXMID and  (F.BAXMID=0 or F.BAXMID is null) 

3       16:53:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 357227.000000
4       16:53:43  SQL Execute: ORACLE -  select 
 sum(b.hjje00) HJJE00 
 FROM 
 ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F 
 where  a.djh000=b.djh000 and  b.XMBH00  = F.SFXMID 
 and  F.BAXMID<>0 
 and  a.ZYID00=?

5       16:53:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 357227.000000
6       16:53:43  SQL Execute: ORACLE - select nvl(F.BAXMID,0) BAXMID,sum(A.HJJE00) HJJE00
                       from  ZY_FYMX00 A,ZY_BRFY00 D,BM_YYSFXM F
                      where  A.DJH000  = D.DJH000                        
                        and  A.XMBH00  = F.SFXMID 
                        and  D.zyid00=?
                   group by  F.BAXMID

7       16:53:43  SQL Execute: ORACLE - select * from VW_ZS_BAXXDY_SMDY where ZYID00=357227 

8       16:53:43  SQL Execute: ORACLE - select * from ( (SELECT to_char(zyid00) zyid00,'主要诊断' zdlbmc,zdm000,zdmc00,zlxg00,zlxgzy,zlxghz,zlxgwy,zlxgsw,zlxgqt  FROM VW_ZS_BACYZD WHERE ZYID00=357227 AND ZDLBMC='出院主要诊断'  and rownum<=1)  union all (select * from (SELECT to_char(zyid00) zyid00,'其它诊断' zdlbmc,zdm000,zdmc00,zlxg00,zlxgzy,zlxghz,zlxgwy,zlxgsw,zlxgqt FROM VW_ZS_BACYZD WHERE ZYID00=357227 AND ZDLBMC='出院其他诊断'  union all  select null zyid00, '其它诊断' zdlbmc, null zdm000,null zdmc00,null zlxg00,null zlxgzy, null zlxghz,null zlxgwy,null zlxgsw,null zlxgqt from bm_yd0000 where rownum<=9 )  where rownum<=9 )  union all  select * from (SELECT to_char(zyid00) zyid00,'医院感染' zdlbmc,zdm000,zdmc00,zlxg00,zlxgzy,zlxghz,zlxgwy,zlxgsw,zlxgqt FROM VW_ZS_BACYZD WHERE ZYID00=357227 AND  ZDLBMC ='医院感染' and rownum=1  union all  select null zyid00, '医院感染' zdlbmc, null zdm000,null zdmc00,null zlxg00,null zlxgzy, null zlxghz,null zlxgwy,null zlxgsw,null zlxgqt from bm_yd0000 where rownum<=1 )  where rownum<=1    ) where rownum<12 

9       16:53:43  SQL Execute: ORACLE - select * from (select to_char(A.SSBH00) SSBH00, substr(A.SSRQSJ,1,8) as SSRQ00, A.SSMC00, A.SSYSXM, decode(sign(instr(A.SSZSXM,';')),1,substr(A.SSZSXM,1,instr(A.SSZSXM,';')-1),A.SSZSXM) as ZSXM01, decode(sign(instr(A.SSZSXM,';')),1,substr(A.SSZSXM,instr(A.SSZSXM,';')+1,length(a.SSZSXM)-instr(A.SSZSXM,';')),a.SSZSXM) as ZSXM02,  A.MZMC00,A.MZYSXM,  QKDJMC||YHDJMC QKYHDJ from vw_ss_yw0000 A  where zyghid=357227 union all (select null SSBH00, null SSRQ00 , null SSMC00 , null SSYSXM , null ZSXM01,null ZSXM02, null MZMC00 , null MZYSXM, null QKYHDJ from BM_YD0000 where rownum<=7)) where rownum<=7 

10      16:53:43  SQL Execute: ORACLE - select    decode('66','无','0','66') CWF000, decode('37','无','0','37') HLF000, decode('749.89','无','0','749.89') XYF000, decode('无','无','0','无') CYF000, decode('无','无','0','无') ZCY000, decode('608','无','0','608') HYF000, decode('80','无','0','80') FSF000, decode('40','无','0','40') SYF000, decode('无','无','0','无') SXF000, decode('200','无','0','200') ZLF000, decode('1300','无','0','1300') SSF000, decode('无','无','0','无') JSF000, decode('432','无','0','432') JCF000, decode('650','无','0','650') MZF000, decode('无','无','0','无') YEF000, decode('无','无','0','无') PCF000, decode('313.48','无','0','313.48') QTF000, decode('4476.37','无','0','4476.37') ZJE000 from dual