1 10:21:37 Log started for: 手术麻醉管理系统 2 10:21:37 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:21:37 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.220','E','ssmzsystem.exe'||'+'||'手术麻醉管理系统','263','11996' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 4 10:21:37 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.220','E','ssmzsystem.exe'||'+'||'手术麻醉管理系统','263','11996' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 5 10:21:37 SQL Prepare: ORACLE - Commit 6 10:21:37 SQL Execute: ORACLE - Commit 7 10:21:37 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:21:37 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 10:21:37 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 10:21:37 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 10:21:37 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 10:21:37 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 10:21:37 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 10:21:37 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 15 10:21:37 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.220','E','ssmzsystem.exe'||'+'||'手术麻醉管理系统','507','17024' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 16 10:21:37 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.220','E','ssmzsystem.exe'||'+'||'手术麻醉管理系统','507','17024' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 17 10:21:37 SQL Prepare: ORACLE - Commit 18 10:21:37 SQL Execute: ORACLE - Commit 19 10:21:37 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='E' 20 10:21:37 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='E' 21 10:21:37 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 10:21:37 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 23 10:21:37 SQL Prepare: ORACLE - Select SYSDATE from Dual 24 10:21:37 SQL Execute: ORACLE - Select SYSDATE from Dual 25 10:21:37 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 26 10:21:37 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 10:21:37 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 28 10:21:37 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 29 10:21:37 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='E' 30 10:21:37 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='E' 31 10:21:37 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 32 10:21:37 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 33 10:21:37 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 34 10:21:37 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 35 10:21:37 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 36 10:21:37 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 37 10:21:38 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'E' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 38 10:21:38 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'E' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='E' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 39 10:21:38 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 40 10:21:38 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 41 10:21:38 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 10:21:38 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 10:21:38 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 44 10:21:38 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 45 10:21:38 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 46 10:21:38 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 10:21:38 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 10:21:38 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 10:21:38 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')) 50 10:21:38 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')) 51 10:21:39 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4193411,476,'wlzx-8','E',nvl('228136395',' '),'192.168.5.220#507:17024@ssmzsystem.exe+手术麻醉管理系统',54) 52 10:21:39 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4193411,476,'wlzx-8','E',nvl('228136395',' '),'192.168.5.220#507:17024@ssmzsystem.exe+手术麻醉管理系统',54) 53 10:21:39 SQL Prepare: ORACLE - Commit 54 10:21:39 SQL Execute: ORACLE - Commit 55 10:21:39 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 54 56 10:21:39 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 54 57 10:21:39 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 58 10:21:39 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 59 10:21:39 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 60 10:21:39 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 61 10:21:39 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.220' 62 10:21:39 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.220' 63 10:21:39 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 64 10:21:39 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 65 10:21:39 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 54 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 10:21:39 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 54 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 67 10:21:39 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 10:21:39 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 69 10:21:39 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'E'||',')>0 70 10:21:39 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'E'||',')>0 71 10:21:41 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 72 10:21:41 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 73 10:21:41 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 74 10:21:41 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 75 10:21:41 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140711' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',54,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='E') 76 10:21:41 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140711' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',54,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='E') 77 10:21:41 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 10:21:41 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 79 10:21:41 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 10:21:41 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 81 10:21:41 SQL Prepare: ORACLE - select sysdate from dual 82 10:21:41 SQL Execute: ORACLE - select sysdate from dual 83 10:21:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='E' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='E'))) 84 10:21:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='E' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='E'))) 85 10:21:41 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'E$%' and A.XTDM00='E' and trim(A.MKDM00)='E$'||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 86 10:21:41 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'E$%' and A.XTDM00='E' and trim(A.MKDM00)='E$'||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 87 10:21:41 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 88 10:21:41 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 89 10:21:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 90 10:21:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 91 10:21:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 92 10:21:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 93 10:21:41 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_SS_%' AND STATUS<>'VALID' 94 10:21:41 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_SS_%' AND STATUS<>'VALID' 95 10:21:41 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_SS_%' 96 10:21:41 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_SS_%' 97 10:21:41 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 98 10:21:41 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 99 10:21:41 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 100 10:21:41 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 101 10:21:41 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 102 10:21:41 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 103 10:21:41 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 104 10:21:41 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 105 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_MZSFDL' 106 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_MZSFDL' 107 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_KSSFXT' 108 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_KSSFXT' 109 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPBZDYID' 110 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPBZDYID' 111 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='XT_DMCFZJJZBZ' 112 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='XT_DMCFZJJZBZ' 113 10:21:41 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='YJ_XMYXTS' 114 10:21:41 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_XMYXTS' 115 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_MZKSDL' 116 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_MZKSDL' 117 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_YBBRSFKCZ' 118 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_YBBRSFKCZ' 119 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_DMCFYX' 120 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_DMCFYX' 121 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSTZDGS' 122 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSTZDGS' 123 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_YXZJHJ' 124 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_YXZJHJ' 125 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_LSCLSFXZ' 126 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_LSCLSFXZ' 127 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_SYBLHCZ' 128 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_SYBLHCZ' 129 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_YJMRGHLB' 130 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_YJMRGHLB' 131 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='MZYS_YBBRYXGH' 132 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='MZYS_YBBRYXGH' 133 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_RHXMLYKSZX' 134 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_RHXMLYKSZX' 135 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_GHHZYHWKSFMRSYBR' 136 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_GHHZYHWKSFMRSYBR' 137 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SFTSDCFJZ' 138 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SFTSDCFJZ' 139 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_CFLRXGBCKCXX' 140 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_CFLRXGBCKCXX' 141 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_QHYFSFSCYCF' 142 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_QHYFSFSCYCF' 143 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAP_BRLLXSBG' 144 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAP_BRLLXSBG' 145 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAP_SFMRZDSX' 146 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAP_SFMRZDSX' 147 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_FYHJ_ZDSCWSFJL' 148 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_FYHJ_ZDSCWSFJL' 149 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSYJYWSQKS' 150 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSYJYWSQKS' 151 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPGZLTJBBTX' 152 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPGZLTJBBTX' 153 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPCXMZAPXSBKS' 154 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPCXMZAPXSBKS' 155 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_TJDZDDFKLC' 156 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='YJ_TJDZDDFKLC' 157 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPMRDQRQ' 158 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSAPMRDQRQ' 159 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSSQSFXSCW' 160 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSSQSFXSCW' 161 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='XK_SXSQBGDJ' 162 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='XK_SXSQBGDJ' 163 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='XK_SFZDJYJG' 164 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='XK_SFZDJYJG' 165 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SQZDSFZDY' 166 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SQZDSFZDY' 167 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSSQSFBBTSJ' 168 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_SSSQSFBBTSJ' 169 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_ZXSWFYSSXM' 170 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_ZXSWFYSSXM' 171 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_BQSSSQSFMSXSS' 172 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_BQSSSQSFMSXSS' 173 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='XK_XKBMBH' 174 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='XK_XKBMBH' 175 10:21:41 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='SS_APYHPBKS' 176 10:21:41 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='SS_APYHPBKS' 177 10:21:41 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_YZHDQR','BQ_SXSQYZSFHDTZ','zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','YS_JKXXDZ','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','BQ_YJZYPSFYXTY','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YJCXD_ZDY','BQ_LSCFSFLRYP','BQ_CYDJS0','BQ_YPMCLB') 178 10:21:41 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_YZHDQR','BQ_SXSQYZSFHDTZ','zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','YS_JKXXDZ','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','BQ_YJZYPSFYXTY','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YJCXD_ZDY','BQ_LSCFSFLRYP','BQ_CYDJS0','BQ_YPMCLB') 179 10:21:42 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 180 10:21:42 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 181 10:21:42 SQL Prepare: ORACLE - select * from vw_bm_mzbm00 where bmbh00='54' 182 10:21:42 SQL Execute: ORACLE - select * from vw_bm_mzbm00 where bmbh00='54' 183 10:21:42 SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476 184 10:21:42 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=476 185 10:21:42 SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='3' 186 10:21:42 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3' 187 10:21:42 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 188 10:21:42 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 189 10:21:42 SQL Prepare: ORACLE - select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000, a.brlb00,a.zyhghh,a.sqzdmc,ssmc00,a.ssysxm,a.sszsxm,a.mzysxm, a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc, glbz00,c.rycwh0,ssdh00,a.shryxm ,a.ssdjmc,a.ssqsrq,a.grqk00,XSHSXM,a.bz0000 from vw_ss_yw0000 a,vw_ss_zybrxx c where a.tzbz00='Y' and sszt00='2' and mzzybz='1' and a.zyghid=c.zyid00 and a.ssfybz<>'2' and a.ssqsrq between :1 and :2 union all select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000, a.brlb00,a.zyhghh,a.sqzdmc,ssmc00,a.ssysxm,a.sszsxm,a.mzysxm, a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc, glbz00,'' rycwh0,ssdh00,a.shryxm,a.ssdjmc,a.ssqsrq,a.grqk00,XSHSXM,a.bz0000 from vw_ss_yw0000 a where a.tzbz00='Y' and sszt00='2' and mzzybz='0' and a.ssfybz<>'2' and a.ssqsrq between :3 and :4 order by ssrqsj,ssdh00 190 10:21:42 SQL Execute: ORACLE - select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000, a.brlb00,a.zyhghh,a.sqzdmc,ssmc00,a.ssysxm,a.sszsxm,a.mzysxm, a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc, glbz00,c.rycwh0,ssdh00,a.shryxm ,a.ssdjmc,a.ssqsrq,a.grqk00,XSHSXM,a.bz0000 from vw_ss_yw0000 a,vw_ss_zybrxx c where a.tzbz00='Y' and sszt00='2' and mzzybz='1' and a.zyghid=c.zyid00 and a.ssfybz<>'2' and a.ssqsrq between ? and ? union all select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000, a.brlb00,a.zyhghh,a.sqzdmc,ssmc00,a.ssysxm,a.sszsxm,a.mzysxm, a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc, glbz00,'' rycwh0,ssdh00,a.shryxm,a.ssdjmc,a.ssqsrq,a.grqk00,XSHSXM,a.bz0000 from vw_ss_yw0000 a where a.tzbz00='Y' and sszt00='2' and mzzybz='0' and a.ssfybz<>'2' and a.ssqsrq between ? and ? order by ssrqsj,ssdh00 191 10:21:54 SQL Prepare: ORACLE - select a.*,rpad(trim(SF_SS_YWMX00_ZLXMJC(a.ssdh00)),120) ssmc0m,a.ssdjmc ssdjm1,Decode(a.jzbz00,'Y',1,0) JZLS,Decode(a.SSZT00,'0',1,0) SQLS,Decode(a.SSZT00,'1',1,0) THLS,Decode(a.SSZT00,'2',1,0) SPLS from vw_ss_yw0000 a where 1=1 and a.sqrq00 between :1 and :2 and a.SSZT00='0' 192 10:21:54 SQL Execute: ORACLE - select a.*,rpad(trim(SF_SS_YWMX00_ZLXMJC(a.ssdh00)),120) ssmc0m,a.ssdjmc ssdjm1,Decode(a.jzbz00,'Y',1,0) JZLS,Decode(a.SSZT00,'0',1,0) SQLS,Decode(a.SSZT00,'1',1,0) THLS,Decode(a.SSZT00,'2',1,0) SPLS from vw_ss_yw0000 a where 1=1 and a.sqrq00 between ? and ? and a.SSZT00='0' 193 10:22:17 SQL Prepare: ORACLE - select gldjmc,gldjbh from bm_gldj00 194 10:22:17 SQL Execute: ORACLE - select gldjmc,gldjbh from bm_gldj00 195 10:22:17 SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_bm_ssbm00 196 10:22:17 SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_bm_ssbm00 197 10:22:17 SQL Prepare: ORACLE - select ssdjmc,ssdjbh from bm_ssdj00 198 10:22:17 SQL Execute: ORACLE - select ssdjmc,ssdjbh from bm_ssdj00 199 10:22:17 SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_bm_mzbm00 200 10:22:17 SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_bm_mzbm00 201 10:22:17 SQL Prepare: ORACLE - select bmmc00,bmbh00 from vw_bm_bq0000 202 10:22:17 SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_bm_bq0000 203 10:22:17 SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='0' and (ssfybz='0' or ssfybz='1') and a.mzzybz='1' and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and sqrq00 between'20140708' and '20140711' order by SSDH00) b 204 10:22:17 SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='0' and (ssfybz='0' or ssfybz='1') and a.mzzybz='1' and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and sqrq00 between'20140708' and '20140711' order by SSDH00) b 205 10:22:17 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 206 10:22:18 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 207 10:22:18 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 208 10:22:18 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 209 10:22:18 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 210 10:22:18 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 211 10:22:18 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 212 10:22:18 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 213 10:22:18 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=54 and DLXTMC='手术麻醉管理系统' and CTMC00='frmSS_SSAP' 214 10:22:18 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=54 and DLXTMC='手术麻醉管理系统' and CTMC00='frmSS_SSAP' 215 10:22:31 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 216 10:22:31 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291410' 217 10:22:31 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 218 10:22:31 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 219 10:22:31 SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select a.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='2' and (ssfybz='0' or ssfybz='1') and a.mzzybz='1' and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and sqrq00 between'20140708' and '20140711' order by SSDH00) b 220 10:22:31 SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select a.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='2' and (ssfybz='0' or ssfybz='1') and a.mzzybz='1' and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and sqrq00 between'20140708' and '20140711' order by SSDH00) b 221 10:22:31 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 222 10:22:31 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 223 10:22:32 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 224 10:22:32 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 225 10:22:32 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 226 10:22:32 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 227 10:22:32 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 228 10:22:32 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 229 10:22:33 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290603' 230 10:22:33 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290603' 231 10:22:33 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 232 10:22:33 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 233 10:22:35 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290660' 234 10:22:35 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290660' 235 10:22:35 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 236 10:22:35 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 237 10:22:36 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291219' 238 10:22:36 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291219' 239 10:22:36 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 240 10:22:36 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 241 10:22:37 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290989' 242 10:22:37 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290989' 243 10:22:37 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 244 10:22:37 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 245 10:22:38 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 246 10:22:38 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='291140' 247 10:22:38 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 248 10:22:38 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 249 10:22:38 SQL Prepare: ORACLE - select (rownum-1) XH0000,b.* from (select A.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='2' and (ssfybz='0' or ssfybz='1') and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and YYSSRQ between'20140708' and '20140711' order by SSDH00) b 250 10:22:38 SQL Execute: ORACLE - select (rownum-1) XH0000,b.* from (select A.XX0000 XKXX00,a.* from vw_ss_yw0000 a where SSZT00='2' and (ssfybz='0' or ssfybz='1') and SQKS00 not in (select bmbh00 from vw_bm_mzbm00) and (mzzybz='0' or (mzzybz='1' and exists (select 1 from zy_brxxb0 where zyid00=a.zyghid and brzt00 like '2%'))) and YYSSRQ between'20140708' and '20140711' order by SSDH00) b 251 10:22:38 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290525' 252 10:22:38 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290525' 253 10:22:38 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 254 10:22:38 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 255 10:22:38 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290989' 256 10:22:38 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290989' 257 10:22:39 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 258 10:22:39 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 259 10:22:43 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290525' 260 10:22:43 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290525' 261 10:22:43 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 262 10:22:43 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 263 10:22:43 SQL Prepare: ORACLE - select * from vw_ss_zybrxx where ZYH000='290633' 264 10:22:43 SQL Execute: ORACLE - select * from vw_ss_zybrxx where ZYH000='290633' 265 10:22:43 SQL Prepare: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=:1 and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0 266 10:22:43 SQL Execute: ORACLE - select a.*,a.ssxmjc ssmc00,c.bz0000 from ss_ywmx00 a,vw_bm_sszd00 b,ss_yw0000 c where a.ssdh00=? and a.ssbh00=b.ssbh00(+) and a.ssdh00=c.ssdh00 order by SFZSS0