1 08:46:13 Log started for: 住院医生工作站系统 2 08:46:18 SQL Prepare: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=:1 and rownum=1 3 08:46:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.000000 4 08:46:18 SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1 5 08:46:18 SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00 6 08:46:18 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 7 08:46:18 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 8 08:46:18 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 9 08:46:18 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 10 08:46:18 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 11 08:46:18 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 12 08:46:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 13 08:46:18 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 14 08:46:18 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 15 08:46:18 SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 16 08:46:18 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 17 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 18 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 19 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 20 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 21 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 22 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 23 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 24 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 25 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 26 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 27 08:46:18 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 28 08:46:18 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 29 08:46:18 SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='62' 30 08:46:18 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='62' 31 08:46:18 SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 32 08:46:18 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 33 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='62' 34 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='62' 35 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='62' 36 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='62' 37 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='62' 38 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='62' 39 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='62' 40 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='62' 41 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='62' 42 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='62' 43 08:46:18 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='62' 44 08:46:18 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='62' 45 08:46:18 SQL Prepare: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140922' and '20140922' and ( ( A.SQKS00+0 = '62' or A.SQBQ00+0 = '62') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140922' and '20140922' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '62' or DQKS00='62')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 46 08:46:18 SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140922' and '20140922' and ( ( A.SQKS00+0 = '62' or A.SQBQ00+0 = '62') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20140922' and '20140922' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '62' or DQKS00='62')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 47 08:46:18 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 48 08:46:18 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='FB' 49 08:46:18 SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='FB0001' and pyrq00='20140922' and rownum=1 50 08:46:18 SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='FB0001' and pyrq00='20140922' and rownum=1 51 08:46:18 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0001' and PYRQ00 = '20140922' 52 08:46:18 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'FB0001' and PYRQ00 = '20140922' 53 08:46:18 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358) 54 08:46:18 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16358) 55 08:46:18 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0001' and pyrq00='20140922' ORDER BY DYSX00 56 08:46:18 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='FB0001' and pyrq00='20140922' ORDER BY DYSX00