1 15:43:44 Log started for: 项目管理系统 2 15:43:44 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3 15:43:44 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 4 15:43:44 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 5 15:43:44 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 6 15:43:44 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 7 15:43:44 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 8 15:43:44 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','C','PrjXmgl.exe'||'+'||'项目管理系统','294','8680' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 9 15:43:44 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','C','PrjXmgl.exe'||'+'||'项目管理系统','294','8680' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:0A1AF7CE587A5DD7280165C0BA14BFED' from dual 10 15:43:44 SQL Data In: ORACLE - Rows affected = 1 11 15:43:44 SQL Prepare: ORACLE - Commit 12 15:43:44 SQL Execute: ORACLE - Commit 13 15:43:44 SQL Data In: ORACLE - Rows affected = 0 14 15:43:44 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='C' 15 15:43:44 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='C' 16 15:43:44 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 17 15:43:44 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 18 15:43:44 SQL Prepare: ORACLE - Select SYSDATE from Dual 19 15:43:44 SQL Execute: ORACLE - Select SYSDATE from Dual 20 15:43:44 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 15:43:44 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 15:43:44 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 23 15:43:44 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 24 15:43:44 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='C' 25 15:43:44 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='C' 26 15:43:44 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 15:43:44 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 15:43:44 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 29 15:43:44 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 30 15:43:44 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('8','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 31 15:43:44 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('8','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 32 15:43:47 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'C' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 33 15:43:47 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'C' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 34 15:43:47 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 35 15:43:47 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 36 15:43:47 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 15:43:47 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 15:43:47 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 39 15:43:47 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 40 15:43:47 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 41 15:43:47 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 42 15:43:47 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 43 15:43:47 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 44 15:43:47 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 45 15:43:47 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 46 15:43:49 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4229096,1143,'wlzx-1','C',nvl('228329436',' '),'192.168.5.22#294:8680@PrjXmgl.exe+项目管理系统',15) 47 15:43:49 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4229096,1143,'wlzx-1','C',nvl('228329436',' '),'192.168.5.22#294:8680@PrjXmgl.exe+项目管理系统',15) 48 15:43:49 SQL Data In: ORACLE - Rows affected = 1 49 15:43:49 SQL Prepare: ORACLE - Commit 50 15:43:49 SQL Execute: ORACLE - Commit 51 15:43:49 SQL Data In: ORACLE - Rows affected = 0 52 15:43:49 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 53 15:43:49 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 54 15:43:49 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 55 15:43:49 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 56 15:43:49 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 57 15:43:49 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 58 15:43:49 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 59 15:43:49 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 60 15:43:49 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 61 15:43:49 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 62 15:43:49 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 63 15:43:49 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 64 15:43:49 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 65 15:43:49 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 66 15:43:49 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'C'||',')>0 67 15:43:49 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'C'||',')>0 68 15:43:51 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 69 15:43:51 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 70 15:43:51 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 71 15:43:51 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 72 15:43:51 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140805' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',15,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='C') 73 15:43:51 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140805' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',15,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='C') 74 15:43:51 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 75 15:43:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 76 15:43:51 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 77 15:43:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 78 15:43:51 SQL Prepare: ORACLE - Select SYSDATE from Dual 79 15:43:51 SQL Execute: ORACLE - Select SYSDATE from Dual 80 15:43:52 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='C' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='C'))) 81 15:43:52 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='C' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='C'))) 82 15:43:52 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'C$%' and A.XTDM00='C' and trim(A.MKDM00)='C$'||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 83 15:43:52 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'C$%' and A.XTDM00='C' and trim(A.MKDM00)='C$'||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 84 15:43:52 SQL Prepare: 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 85 15:43:52 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 86 15:43:52 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 87 15:43:52 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 88 15:43:52 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 89 15:43:52 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 90 15:43:52 SQL Prepare: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_SFGL' and (( 1143= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 91 15:43:52 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_SFGL' and (( 1143= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 92 15:43:52 SQL Prepare: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_CLGL' and (( 1143= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 93 15:43:52 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_CLGL' and (( 1143= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143)))) 94 15:43:52 SQL Prepare: ORACLE - select yydj00 from xt_yyxx00 where yyid00='222137' 95 15:43:52 SQL Execute: ORACLE - select yydj00 from xt_yyxx00 where yyid00='222137' 96 15:43:52 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 97 15:43:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 98 15:43:52 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 99 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 100 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = XM_ZXGXXLH_ID00 101 15:43:52 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 102 15:43:52 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 103 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 104 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_HZSRF 105 15:43:52 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 106 15:43:52 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 107 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 108 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_SRXG0 109 15:43:52 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 110 15:43:52 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 111 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 112 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_PPFX0 113 15:43:52 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 114 15:43:52 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 115 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 116 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_ZDJLS 117 15:43:52 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 118 15:43:52 SQL Prepare: ORACLE - select name00,value0 from xt_yhcs00 where ygbh00=1143 order by name00 119 15:43:52 SQL Execute: ORACLE - select name00,value0 from xt_yhcs00 where ygbh00=1143 order by name00 120 15:43:52 SQL Prepare: ORACLE - select * from xt_xtcs00 where NAME00='XMGL_YBYPDYSCMM' 121 15:43:52 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00='XMGL_YBYPDYSCMM' 122 15:44:05 SQL Prepare: ORACLE - select distinct ZDMC00 ZDMC00 from BM_TYZD00 a where exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=a.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143))))) or MKDM00 is null ORDER BY ZDMC00 123 15:44:05 SQL Execute: ORACLE - select distinct ZDMC00 ZDMC00 from BM_TYZD00 a where exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=a.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143))))) or MKDM00 is null ORDER BY ZDMC00 124 15:45:14 SQL Prepare: ORACLE - select distinct ZDMC00 ZDMC00 from BM_TYZD00 a where exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=a.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143))))) or MKDM00 is null ORDER BY ZDMC00 125 15:45:14 SQL Execute: ORACLE - select distinct ZDMC00 ZDMC00 from BM_TYZD00 a where exists ( select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and MKDM00=a.MKDM00 and ( (BZ0000<>'0' and MKDM00 like 'CZD%' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1143))))) or MKDM00 is null ORDER BY ZDMC00 126 15:45:36 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊IP' Order by Bh0000 127 15:45:36 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊IP' Order by Bh0000 128 15:47:07 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊时间' Order by Bh0000 129 15:47:07 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊时间' Order by Bh0000 130 15:53:34 SQL Prepare: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊IP' Order by Bh0000 131 15:53:34 SQL Execute: ORACLE - select NBBH00,ZDMC00, LBBZ00, BH0000, MC0000,PYSM00,WBSM00,XSXH00, BZ0000, YXBZ00, XTBZ00,DJ0000,BZDYBH from BM_TYZD00 WHERE ZDMC00='限制开诊IP' Order by Bh0000