1 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=498 and ZLXMID=21653 and YJDJH0=9867867 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 2 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=498 and ZLXMID=21691 and YJDJH0=9867867 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 3 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=498 and ZLXMID=21693 and YJDJH0=9867867 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 4 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=498 and ZLXMID=21694 and YJDJH0=9867867 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 5 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=502 and ZLXMID=21868 and YJDJH0=9867871 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 6 10:42:32 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=3833224 and KSBH00=502 and ZLXMID=21868 and YJDJH0=9867871 and JCRQ00 IS NOT NULL and rownum=1 7 10:42:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=559 and ZLXMID=18408 and YJDJH0=9867872 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 8 10:42:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=499 and ZLXMID=17819 and YJDJH0=9867873 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 9 10:42:33 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=3833224 and KSBH00=499 and ZLXMID=17819 and YJDJH0=9867873 and JCRQ00 IS NOT NULL and rownum=1 10 10:42:34 SQL Execute: ORACLE - update TJ_TJBG00 set JCYS00='1214',JCYSXM='张宗婵',JCRQ00='20130608' where GHID00='3833224' and KSBH00='559' and ZLXMID='18408' and YJDJH0='9867872' 11 10:42:34 SQL Data In: ORACLE - Rows affected = 1 12 10:42:34 SQL Execute: ORACLE - update TJ_TJBG00 set CDZ000='心房纤颤 部分导联T波改变',JGSM00='',CZY000='1057',CZYXM0='管理员',CDMS00='',ICD900='TJ24',XXZ000='',SXZ000='',JBMC00='心房纤颤' where BGID00='293858' 13 10:42:34 SQL Data In: ORACLE - Rows affected = 1 14 10:42:34 SQL Execute: ORACLE - Commit 15 10:42:34 SQL Data In: ORACLE - Rows affected = 0 16 10:42:34 SQL Execute: ORACLE - SELECT BGXMID FROM BM_JCXMDY WHERE XTCS00 IN ('TJ_YG1ID','TJ_YG2ID','TJ_YG3ID','TJ_YG4ID','TJ_YG5ID','TJ_YG6ID') AND BGXMID IS NOT NULL 17 10:42:34 SQL Execute: ORACLE - update TJ_TJBG00 set SFJRXJ='Y' where BGID00='293858' 18 10:42:34 SQL Data In: ORACLE - Rows affected = 1 19 10:42:34 SQL Execute: ORACLE - Commit 20 10:42:34 SQL Data In: ORACLE - Rows affected = 0 21 10:42:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 36, Scale = 0, Data = (1)心电图:心房纤颤 部分导联T波改变 22 10:42:34 SQL Execute: ORACLE - update TJ_TJXJB0 a set CDZ000=?,JCYS00='1214',JCYSXM='张宗婵',JCRQ00='20130608' WHERE GHID00 = 3833224 and KSBH00 = 559 AND ZLXMID IS NULL and SFDDDY='N' 23 10:42:34 SQL Data In: ORACLE - Rows affected = 1 24 10:42:34 SQL Execute: ORACLE - SELECT JCXMID FROM BM_JCXMDY WHERE BGXMID||'A' = '836A' AND KSBH00||'A' = '559A' 25 10:42:34 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3833224 26 10:42:34 SQL Data In: ORACLE - Param = 2, Name = PKSBH00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 559 27 10:42:34 SQL Execute: ORACLE - BEGIN "SP_TJ_TJJYHZ" (PGHID00 => :PGHID00,PKSBH00 => :PKSBH00); END; 28 10:42:34 SQL Execute: ORACLE - Commit 29 10:42:34 SQL Data In: ORACLE - Rows affected = 0 30 10:42:34 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='3833224' or ghid00='') ) C WHERE YYID00 = '220035' 31 10:42:34 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='3833224' and KSBH00='559' and SFDDDY='N' 32 10:42:34 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='3833224' and ksbh00='559' order by ID0000 33 10:42:34 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='3833224' and A.KSBH00='559' and A.YJDJH0='9867872' and A.ZLXMID='18408' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='3833224' and C.KSBH00='559' and C.YJDJH0='9867872' and C.ZLXMID='18408' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,XSSX00 34 10:42:34 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=3833224 and KSBH00=559 and ZLXMID=18408 and YJDJH0=9867872 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999