1       10:18:05  Log started for: 门诊护士工作站
2       10:18:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
3       10:18:08  SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and  dlxh00>0  
 order by jzys00,dlxh00

4       10:18:08  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
5       10:18:08  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
6       10:18:08  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

7       10:18:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
8       10:18:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
9       10:18:09  SQL Execute: ORACLE - select * from vw_ys_yzbr00
where jzks00=? and jzys00=?
 order by dlxh00 desc

10      10:18:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
11      10:18:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
12      10:18:09  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=?
 
 

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

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

21      10:18:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
22      10:18:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
23      10:18:09  SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=?  and jzys00=? and HZZT00='2' and  dlxh00>0

24      10:18:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
25      10:18:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
26      10:18:09  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

27      10:18:09  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'

28      10:18:13  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'