1       10:04:30  SQL Prepare: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=60 or DQKS00=60)
 order by XXID00 

2       10:04:30  SQL Execute: ORACLE -  SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a 
 where XXLB00='1'
  and SFLL00='0' 
  and (DQBQ00=60 or DQKS00=60)
 order by XXID00 

3       10:04:30  SQL Prepare: ORACLE - select a.*,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,(BWBRS0+BZBRS0) WZRS00 from zh_zyrbb0 a where A.zyrq00=:1 
 and (RYRS00<>0 or ZRRS00<>0 or CYRS00<>0 or ZCRS00<>0)
 order by a.bqh000,a.ksh000 

4       10:04:30  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160731
5       10:04:30  SQL Execute: ORACLE - select a.*,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,(BWBRS0+BZBRS0) WZRS00 from zh_zyrbb0 a where A.zyrq00=? 
 and (RYRS00<>0 or ZRRS00<>0 or CYRS00<>0 or ZCRS00<>0)
 order by a.bqh000,a.ksh000 

6       10:04:30  SQL Prepare: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=:1 and flag00='1' 
 order by a.bqh000,a.ksh000,b.zyh000 

7       10:04:30  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160731
8       10:04:30  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='1' 
 order by a.bqh000,a.ksh000,b.zyh000 

9       10:04:31  SQL Prepare: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=:1 and flag00='2' 
 order by a.bqh000,a.ksh000,b.zyh000 

10      10:04:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160731
11      10:04:31  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='2' 
 order by a.bqh000,a.ksh000,b.zyh000 

12      10:04:32  SQL Prepare: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=:1 and flag00='3' 
 order by a.bqh000,a.ksh000,b.zyh000 

13      10:04:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160731
14      10:04:32  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='3' 
 order by a.bqh000,a.ksh000,b.zyh000 

15      10:04:33  SQL Prepare: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=:1 and flag00='4' 
 order by a.bqh000,a.ksh000,b.zyh000 

16      10:04:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160731
17      10:04:33  SQL Execute: ORACLE - Select a.ZYRQ00,(select BMMC00 from bm_bmbm00 where bmbh00=a.ksh000) ksmc00,a.BQH000,a.KSH000,a.flag00,b.zyh000,b.xm0000,b.xb0000,decode(a.cyflag,'0','治愈','1','好转','2','未愈','3','死亡','4','其他','其他') CYZT00
 from zy_zybrmx a,zy_brxxb0 b where a.zyid00=b.zyid00 and a.zyrq00=? and flag00='4' 
 order by a.bqh000,a.ksh000,b.zyh000