1 11:27:26 Log started for: 门诊医生工作站分系统 2 11:28:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 3 11:28:37 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 4 11:28:38 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5780407' and LBBH00='0' 5 11:28:38 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='1758444' and ZT0000='1' 6 11:28:38 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='1758444' and ZT0000='1' 7 11:28:38 SQL Execute: ORACLE - Select SYSDATE from Dual 8 11:28:38 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 9 11:28:38 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 10 11:28:38 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090539005' and ICKNBH = '0221094090539005' 11 11:28:38 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC,'0' XGBZ00, decode(a.jcqzy0,null,(select jcqzysx from bm_zlzd00 where zlxmid=a.zlxmid),a.jcqzy0) JCQZYSX,c.LBBH00 ,nvl(c.JCLBID,0) JCLBID,nvl(c.SQDID0,0) SQDID0,'0' as yjmxzt,decode(nvl(a.SQID00,0),0,'未申请','已申请:'||a.SQID00) SQZT00,a.YJDJH0 YJDJH1,c.BWBH00 WHBWBH,a.BWBH00 OLDBW0,a.ZLXMJC OLDMC0 from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.MZZYBZ='0' and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.ZYHGHH='5780407' and a.SL0000>0 and (a.XMZT00='0' or a.XMZT00='1' or a.XMZT00='5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='5780407') order by a.YJDJH0 12 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844528 13 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 14 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 15 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 16 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 17 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 18 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844528 19 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 20 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844528 21 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 22 11:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 23 11:28:38 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 24 11:28:38 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.MZZYBZ='0' and a.ZYHGHH='5780407' and a.SL0000>0 and (a.XMZT00<>'0' and a.XMZT00<>'1' and a.XMZT00<>'5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='5780407') order by a.YJDJH0 25 11:28:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 26 11:28:39 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 27 11:28:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844531 28 11:28:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2311 29 11:28:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10694957 30 11:28:39 SQL Execute: ORACLE - SELECT 1 FROM YJ_YW0000 A,BM_ZLZD00 B,YS_XMSQD0 C WHERE A.zlxmid=B.zlxmid AND B.sqdid0=C.sqdid0 AND C.ghid00=A.zyghid AND A.mzzybz='0' AND A.XMZT00 IN ('0','1') AND A.YJDJH0<>? AND c.sqdid0=(select sqdid0 from bm_zlzd00 where ZLXMID=? ) and a.zyghid=? 31 11:28:40 SQL Execute: ORACLE - select SF_YS_JYDCXMDEL(25844531,0) TS0000 from dual 32 11:28:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25844528 33 11:28:40 SQL Execute: ORACLE - SELECT SQID00 FROM YJ_YW0000 WHERE YJDJH0=? 34 11:28:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25844531.000000 35 11:28:40 SQL Execute: ORACLE - delete from YJ_YW0000 where YJDJH0 = ? 36 11:28:40 SQL Data In: ORACLE - Rows affected = 1 37 11:28:40 SQL Execute: ORACLE - SELECT SQID00,KDYS00,ZLXMID,ZLXMJC,BWMC00,XMZT00,(select SQDID0 from BM_ZLZD00 where ZLXMID=a.ZLXMID) SQDID0 FROM YJ_YW0000 a WHERE ZYGHID=10694957 AND MZZYBZ='0' AND XMZT00 IN ('0','1') AND YJDJH0<>25844531 and SQID00=10746 38 11:30:27 Log started for: SQL Navigator for Oracle