1       10:11:45  SQL Execute: ORACLE - select B.ZYID00,B.BRID00,B.XMBH00,B.XMMC00,B.XMGG00,B.XMDW00,sum(B.XMSL00)  XMSL00,sum(B.HJJE00)  HJJE00,XMBZ00, SHJG00, ZFBL00,Sum(nvl(TCJE00,0)) AS TCJE00  from vw_zy_ybfymx B where ZYID00=658977 group by B.ZYID00,B.BRID00,B.XMBH00,B.XMMC00,B.XMGG00,B.XMDW00,B.XMDJ00,XMBZ00,SHJG00,ZFBL00 ORDER BY XMBZ00 

2       10:11:45  SQL Execute: ORACLE - select nvl(round(sum(xyf000),2),0) xyf000,nvl(round(sum(cyf000),2),0) cyf000,nvl(round(sum(caoyf0),2),2) caoyf0,nvl(round(sum(zyf000),2),0) zyf000 from(  select nvl(b.hjje00,0) xyf000,0 cyf000,0 caoyf0,0 zyf000 from zy_brfy00 a,zy_fymx00 b where a.djh000=b.djh000 and b.xmmc00='西药费' and a.zyid00=658977 union select 0 xyf000,nvl(b.hjje00,0) cyf000,0 caoyf0,0 zyf000 from zy_brfy00 a,zy_fymx00 b where a.djh000=b.djh000 and b.xmmc00='成药费' and a.zyid00=658977 union select 0 xyf000,0 cyf000,nvl(b.hjje00,0) caoyf0,0 zyf000 from zy_brfy00 a,zy_fymx00 b where a.djh000=b.djh000 and b.xmmc00='草药费' and a.zyid00=658977 union select 0 xyf000,0 cyf000,0 caoyf0,nvl(b.hjje00,0) zyf000 from zy_brfy00 a,zy_fymx00 b where a.djh000=b.djh000 and b.xmmc00 in('西药费','成药费','草药费') and a.zyid00=658977 )