1 11:36:57 Log started for: 临床路径维护系统 2 11:37:00 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3635224,2,'longzz','CP',nvl('1548279528',' '),'192.168.0.208-192.168.2.107#1858:23250@Prj_CP.exe+临床路径维护系统',218) 3 11:37:00 SQL Data In: ORACLE - Rows affected = 1 4 11:37:00 SQL Execute: ORACLE - Commit 5 11:37:00 SQL Data In: ORACLE - Rows affected = 0 6 11:37:00 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 218 7 11:37:00 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221889' 8 11:37:00 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 9 11:37:00 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.2.107' 10 11:37:00 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 11 11:37:00 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 218 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 12 11:37:00 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221889') 13 11:37:00 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (a.YYID00='221889' or trim(a.YYID00)='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'CP'||',')>0 ) 14 11:37:02 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='2' and name00='SYSTEMSKIN' 15 11:37:02 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 16 11:37:02 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20170320' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',218,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='CP') 17 11:37:02 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 18 11:37:02 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 19 11:37:02 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 20 11:37:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='CP' and (( 2= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=2 and XTDM00='CP'))) 21 11:37:15 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'CP$%' and A.XTDM00='CP' and trim(A.MKDM00)='CP$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 22 11:37:15 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((2= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=2 and XTDM00='0 '))) 23 11:37:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 24 11:37:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 2= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=2 and XTDM00='+ '))) 25 11:37:15 SQL Execute: ORACLE - Select XTBB00 from XT_YYXT00 where XTDM00='CP' 26 11:37:15 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' or name00 in ('ZS_SFSYBYLCLJ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_LJMBWHMS','ZS_LJBMSFKBJ','ZS_LJSFSYZLJ','ZS_FPSYSFYXSRPS','ZS_SFXSBBMC','ZS_SFKYSRZLYZ','CP_LJWHYYGXH','CP_LSYZZLSFKXG','CP_XSSSXMJC','CP_XZJDZDJRMRZ','CP_XZLJSFMRTSBY','CP_ZBLJXSFS','CP_ZDTJSFLYZDKSFP','CP_LZJHSFZXSDJD','CP_JHYZXLXSYF','CP_JHYZGLYF','CP_XSGYYZJD','CP_BZYZDYQZ','CP_XGSDJLMRBX','CP_JBXXLJZSJSFS','CP_WDSFCSJK' ) 27 11:37:15 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 2 28 11:37:15 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 29 11:37:15 SQL Execute: ORACLE - select count(*) cou from XT_XTCZRZ where cztable='LJ_JDYZMX' and CZRYBM=0 30 11:37:18 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='CP' and MKDM00='CP013' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='CP' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=2)))) 31 11:37:18 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=2 and YGXZ00 like '%5%' 32 11:37:18 SQL Execute: ORACLE - SELECT a.*,(select count(*) from LJ_JDYZMX b where b.YZZT00='0' and CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where LJZT00<>'2' and (a.KSBH00=0 or exists(select 1 from BM_BMBM00 d where a.KSBH00=d.BMBH00 and d.YYID00='221889') ) order by to_number(LJBM00) 33 11:37:18 SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=82 and YXBZ00='1' 34 11:37:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 35 11:37:18 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX where LJZT00<>'2' and LJID00=? 36 11:37:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 37 11:37:18 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00 38 11:37:18 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where FLAG00='1' and CZBZ00<>'2' and BMXZ00 in('3') order by decode(trim(YYID00),'221889',0,1),PXXH00 39 11:37:18 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where BMXZ00 in('2','3') and FLAG00='1' and CZBZ00<>'2' and (BMMC00 like '%中药%' or BMMC00 like '%全成%') order by decode(trim(YYID00),'221889',0,1),nvl(PXXH00,0) 40 11:37:18 SQL Execute: ORACLE - select * from YS_JYFS00 order by bh0000 41 11:37:18 SQL Data In: ORACLE - Param = 1, Name = AD_LJID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 42 11:37:18 SQL Data In: ORACLE - Param = 2, Name = AS_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 43 11:37:18 SQL Data In: ORACLE - Param = 3, Name = AS_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 44 11:37:18 SQL Data In: ORACLE - Param = 4, Name = ad_DEPTID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 45 11:37:18 SQL Data In: ORACLE - Param = 5, Name = AS_ZLXMTS, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 11:37:18 SQL Execute: ORACLE - BEGIN "SP_ZY_LJ_GETLJTZYPTS" (AD_LJID00 => :AD_LJID00,AS_RETURN => :AS_RETURN,AS_ERROR0 => :AS_ERROR0,ad_DEPTID => :ad_DEPTID,AS_ZLXMTS => :AS_ZLXMTS); END; 47 11:37:20 SQL Execute: ORACLE - select count(*) cou from all_objects where object_name='ZS_BLZCXM' 48 11:37:20 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 49 11:37:20 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=2) and (BMBH00=0 or BMBH00=218) and DLXTMC='临床路径维护系统' and CTMC00='FrmCP_LJMBWH' order by YGBH00 50 11:37:25 SQL Execute: ORACLE - select count(*) from LJ_MBZLJD where JDZT00='0' and LJID00=82 51 11:37:25 SQL Execute: ORACLE - select distinct YEXM00 from LJ_JDYZMX where LJID00=82 and YZZT00='0' 52 11:37:25 SQL Execute: ORACLE - select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where A.LJID00=82 and JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 53 11:37:25 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=612 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 54 11:37:25 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=613 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 55 11:37:25 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=614 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 56 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=614 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 57 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=614 and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 58 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=614 and KSTS00=4 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 59 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=614 and KSTS00=5 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 60 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=615 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 61 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=615 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 62 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=615 and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 63 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=616 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 64 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=616 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 65 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=616 and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 66 11:37:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=82 and RCID00=617 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 67 11:37:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 82.000000 68 11:37:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 612.000000 69 11:37:26 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX where LJID00=? and RCID00=? and KSTS00=1 and LB0000=0 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 70 11:37:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 82.000000 71 11:37:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 612.000000 72 11:37:39 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX where LJID00=? and RCID00=? and KSTS00=1 and LB0000=0 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 73 11:37:40 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=612 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 74 11:37:40 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 75 11:37:40 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=82 and RCID00= 612 76 11:37:40 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=612 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 77 11:37:44 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 78 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 79 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 80 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 81 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 82 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 83 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 84 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 85 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 86 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 87 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 88 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 89 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 90 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 91 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 92 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 93 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 94 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 95 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 96 11:37:45 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 97 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 98 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 99 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 100 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 101 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 102 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 103 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 104 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 105 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 106 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 107 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 108 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 109 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 110 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 111 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 112 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 113 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 114 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 115 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 116 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 117 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 118 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 119 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 120 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 121 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 122 11:37:46 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 123 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 124 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 125 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 126 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 127 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 128 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 129 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 130 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 131 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 132 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 133 11:37:47 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 134 11:37:55 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 135 11:37:55 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 136 11:37:57 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 137 11:37:58 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 138 11:37:58 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 139 11:38:01 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=612 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 140 11:38:04 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=613 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 141 11:38:05 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 142 11:38:05 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=82 and RCID00= 613 143 11:38:05 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=613 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 144 11:38:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 145 11:38:22 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 146 11:38:23 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=613 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 147 11:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 82.000000 148 11:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 613.000000 149 11:38:27 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBHLHDXX where LJID00=? and RCID00=? and KSTS00=1 order by KSTS00,YZXZLX,XH0000 150 11:38:28 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=613 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 151 11:38:28 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 152 11:38:28 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=82 and RCID00= 613 153 11:38:28 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=613 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 154 11:38:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 82.000000 155 11:38:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 613.000000 156 11:38:28 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX where LJID00=? and RCID00=? and KSTS00=1 and LB0000=0 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 157 11:38:31 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=613 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 158 11:38:31 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 159 11:38:31 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=82 and RCID00= 613 160 11:38:31 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=613 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 161 11:38:38 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 162 11:38:42 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 163 11:38:48 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 164 11:38:49 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 165 11:38:49 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 166 11:38:49 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 167 11:38:50 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 168 11:38:50 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 169 11:38:50 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 170 11:38:52 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 171 11:38:58 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='CP' and MKDM00='CP013' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='CP' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=2)))) 172 11:38:58 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=2 and YGXZ00 like '%5%' 173 11:38:58 SQL Execute: ORACLE - SELECT a.*,(select count(*) from LJ_JDYZMX b where b.YZZT00='0' and CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where LJZT00<>'2' and (a.KSBH00=0 or exists(select 1 from BM_BMBM00 d where a.KSBH00=d.BMBH00 and d.YYID00='221889') ) order by to_number(LJBM00) 174 11:38:59 SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=82 and YXBZ00='1' 175 11:38:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 176 11:38:59 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX where LJZT00<>'2' and LJID00=? 177 11:38:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 178 11:38:59 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00 179 11:38:59 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where FLAG00='1' and CZBZ00<>'2' and BMXZ00 in('3') order by decode(trim(YYID00),'221889',0,1),PXXH00 180 11:38:59 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where BMXZ00 in('2','3') and FLAG00='1' and CZBZ00<>'2' and (BMMC00 like '%中药%' or BMMC00 like '%全成%') order by decode(trim(YYID00),'221889',0,1),nvl(PXXH00,0) 181 11:38:59 SQL Execute: ORACLE - select * from YS_JYFS00 order by bh0000 182 11:38:59 SQL Data In: ORACLE - Param = 1, Name = AD_LJID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 183 11:38:59 SQL Data In: ORACLE - Param = 2, Name = AS_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 184 11:38:59 SQL Data In: ORACLE - Param = 3, Name = AS_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 185 11:38:59 SQL Data In: ORACLE - Param = 4, Name = ad_DEPTID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 186 11:38:59 SQL Data In: ORACLE - Param = 5, Name = AS_ZLXMTS, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 187 11:38:59 SQL Execute: ORACLE - BEGIN "SP_ZY_LJ_GETLJTZYPTS" (AD_LJID00 => :AD_LJID00,AS_RETURN => :AS_RETURN,AS_ERROR0 => :AS_ERROR0,ad_DEPTID => :ad_DEPTID,AS_ZLXMTS => :AS_ZLXMTS); END; 188 11:39:00 SQL Execute: ORACLE - select count(*) cou from all_objects where object_name='ZS_BLZCXM' 189 11:39:00 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 190 11:39:00 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=2) and (BMBH00=0 or BMBH00=218) and DLXTMC='临床路径维护系统' and CTMC00='FrmCP_LJMBWH' order by YGBH00 191 11:39:01 SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=99 and YXBZ00='1' 192 11:39:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 99 193 11:39:01 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX where LJZT00<>'2' and LJID00=? 194 11:39:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 99 195 11:39:01 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00 196 11:39:03 SQL Execute: ORACLE - select count(*) from LJ_MBZLJD where JDZT00='0' and LJID00=99 197 11:39:03 SQL Execute: ORACLE - select distinct YEXM00 from LJ_JDYZMX where LJID00=99 and YZZT00='0' 198 11:39:03 SQL Execute: ORACLE - select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where A.LJID00=99 and JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 199 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=585 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 200 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=586 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 201 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=586 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 202 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=587 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 203 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=587 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 204 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=587 and KSTS00=3 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 205 11:39:03 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=99 and RCID00=588 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 206 11:39:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 99.000000 207 11:39:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 585.000000 208 11:39:03 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX where LJID00=? and RCID00=? and KSTS00=1 and LB0000=0 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 209 11:39:06 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=585 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 210 11:39:06 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 211 11:39:06 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=99 and RCID00= 585 212 11:39:06 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=585 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 213 11:39:10 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 214 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 215 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 216 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 217 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 218 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 219 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 220 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 221 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 222 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 223 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 224 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 225 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 226 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 227 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 228 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 229 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 230 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 231 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 232 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 233 11:39:11 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 234 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 235 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 236 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 237 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 238 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 239 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 240 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 241 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 242 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 243 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 244 11:39:12 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 245 11:39:14 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 246 11:39:15 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 247 11:39:21 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='CP' and MKDM00='CP013' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='CP' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=2)))) 248 11:39:21 SQL Execute: ORACLE - select 1 from BM_YGBM00 where YGBH00=2 and YGXZ00 like '%5%' 249 11:39:21 SQL Execute: ORACLE - SELECT a.*,(select count(*) from LJ_JDYZMX b where b.YZZT00='0' and CLBZ00 in('0','1') and SYFW00=0 and LJID00=a.LJID00 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 FROM VW_ZY_LJ_MBXX a where LJZT00<>'2' and (a.KSBH00=0 or exists(select 1 from BM_BMBM00 d where a.KSBH00=d.BMBH00 and d.YYID00='221889') ) order by to_number(LJBM00) 250 11:39:21 SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=82 and YXBZ00='1' 251 11:39:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 252 11:39:21 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX where LJZT00<>'2' and LJID00=? 253 11:39:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 82 254 11:39:21 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00 255 11:39:21 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where FLAG00='1' and CZBZ00<>'2' and BMXZ00 in('3') order by decode(trim(YYID00),'221889',0,1),PXXH00 256 11:39:21 SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'221889',0,1),YYID00 from BM_BMBM00 where BMXZ00 in('2','3') and FLAG00='1' and CZBZ00<>'2' and (BMMC00 like '%中药%' or BMMC00 like '%全成%') order by decode(trim(YYID00),'221889',0,1),nvl(PXXH00,0) 257 11:39:21 SQL Execute: ORACLE - select * from YS_JYFS00 order by bh0000 258 11:39:21 SQL Data In: ORACLE - Param = 1, Name = AD_LJID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 259 11:39:21 SQL Data In: ORACLE - Param = 2, Name = AS_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 260 11:39:21 SQL Data In: ORACLE - Param = 3, Name = AS_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 261 11:39:21 SQL Data In: ORACLE - Param = 4, Name = ad_DEPTID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 262 11:39:21 SQL Data In: ORACLE - Param = 5, Name = AS_ZLXMTS, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 263 11:39:21 SQL Execute: ORACLE - BEGIN "SP_ZY_LJ_GETLJTZYPTS" (AD_LJID00 => :AD_LJID00,AS_RETURN => :AS_RETURN,AS_ERROR0 => :AS_ERROR0,ad_DEPTID => :ad_DEPTID,AS_ZLXMTS => :AS_ZLXMTS); END; 264 11:39:23 SQL Execute: ORACLE - select count(*) cou from all_objects where object_name='ZS_BLZCXM' 265 11:39:23 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 266 11:39:23 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=2) and (BMBH00=0 or BMBH00=218) and DLXTMC='临床路径维护系统' and CTMC00='FrmCP_LJMBWH' order by YGBH00 267 11:39:24 SQL Execute: ORACLE - select count(*) COU from LJ_YZLBZD a where LJID00=102 and YXBZ00='1' 268 11:39:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 102 269 11:39:24 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_MBXX where LJZT00<>'2' and LJID00=? 270 11:39:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 102 271 11:39:24 SQL Execute: ORACLE - SELECT * FROM VW_ZY_LJ_LJMBTJXX where LJID00=? and TJZT00='0' order by ZDLB00 272 11:39:26 SQL Execute: ORACLE - select count(*) from LJ_MBZLJD where JDZT00='0' and LJID00=102 273 11:39:26 SQL Execute: ORACLE - select distinct YEXM00 from LJ_JDYZMX where LJID00=102 and YZZT00='0' 274 11:39:26 SQL Execute: ORACLE - select A.*,B.LJMC00 from LJ_MBZLJD A,LJ_MB0000 B where A.LJID00=102 and JDZT00='0' and A.LJID00=B.LJID00 order by xh0000 275 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=528 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 276 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=529 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 277 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=529 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 278 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=530 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 279 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=531 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 280 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=532 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 281 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=533 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 282 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=534 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 283 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=535 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 284 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=535 and KSTS00=2 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 285 11:39:26 SQL Execute: ORACLE - select count(*) COU from VW_ZY_LJ_MBYZXX a where LJID00=102 and RCID00=536 and KSTS00=1 and SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID)=1 286 11:39:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 102.000000 287 11:39:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 528.000000 288 11:39:26 SQL Execute: ORACLE - select * from VW_ZY_LJ_MBKJXX where LJID00=? and RCID00=? and KSTS00=1 and LB0000=0 order by LB0000,KSTS00,CLBZ00,YZXZLX,XH0000 289 11:39:28 SQL Execute: ORACLE - select a.*,to_char(ROWNUM) as ZNO000,SP_ZY_LJ_GETLJTZYPZT(a.LJID00,a.YPNM00,218,0,a.ZLXMID) YPZT00,0 TEMPNO from VW_ZY_LJ_MBYZXX a where CYCFBZ='0' and RCID00=528 and KSTS00>=1 and KSTS00<=1 and nvl(JDGYYZ,'N')='N' order by CLBZ00,RCID00,KSTS00,LBIDXH,YZXZLX,PXH000,NO0000,TLBZXH,XH0000 290 11:39:28 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 291 11:39:28 SQL Execute: ORACLE - select ZYR000+zlts00-1 ZYR000 from LJ_MBZLJD where LJID00=102 and RCID00= 528 292 11:39:28 SQL Execute: ORACLE - select distinct LBIDXH,CFMC00,NO0000,RCID00,(select count(*) from VW_ZY_LJ_MBYZXX where LJID00=a.LJID00 and RCID00=a.RCID00 and NO0000=a.NO0000 and CFMC00=a.CFMC00 and SP_ZY_LJ_GETLJTZYPZT(LJID00,YPNM00,218,0,ZLXMID)=1) YZZT00 from VW_ZY_LJ_MBYZXX a where CYCFBZ='1' and RCID00=528 and JDGYYZ='N' and KSTS00>=1 and KSTS00<=1 order by LBIDXH,NO0000 293 11:39:32 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 294 11:39:32 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 295 11:39:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 296 11:39:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By pysm00) where Rownum<=30 297 11:39:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %s% 298 11:39:43 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'s'),pysm00) where Rownum<=30 299 11:39:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %sc% 300 11:39:43 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'sc'),pysm00) where Rownum<=30 301 11:42:29 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 302 11:42:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 303 11:42:29 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By pysm00) where Rownum<=30 304 11:42:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %s% 305 11:42:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'s'),pysm00) where Rownum<=30 306 11:42:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %sc% 307 11:42:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'sc'),pysm00) where Rownum<=30 308 11:42:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %scj% 309 11:42:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'scj'),pysm00) where Rownum<=30 310 11:42:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %scjs% 311 11:42:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'scjs'),pysm00) where Rownum<=30 312 11:42:32 SQL Execute: ORACLE - select BBID00,BBMC00 from VW_ZY_LJ_ZLBBMC where zlxmid=10881 313 11:42:32 SQL Execute: ORACLE - select KSBH00,BMMC00 from VW_ZS_JYKSXM where zlxmid=10881 314 11:42:34 SQL Execute: ORACLE - select count(*) from BM_YGBM00 where YGBH00=2 and instr(YGXZ00,'5')>0 315 11:42:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 316 11:42:34 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By pysm00) where Rownum<=30 317 11:42:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %s% 318 11:42:37 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'s'),pysm00) where Rownum<=30 319 11:42:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %sc% 320 11:42:37 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'sc'),pysm00) where Rownum<=30 321 11:42:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %scj% 322 11:42:38 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'scj'),pysm00) where Rownum<=30 323 11:42:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %scjs% 324 11:42:38 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00,lbbh00,xmzhsm from VW_CP_ZLZD00 where (pysm00 Like ?) Order By Instrb(pysm00,'scjs'),pysm00) where Rownum<=30 325 11:50:14 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1