1 11:09:18 Log started for: 临床输血管理系统 2 11:09:18 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.154','O',trim(PROGRAM)||'+'||'临床输血管理系统',SID,serial# ,'20101217','11:09:19','scott@4002:BF9E0F53FAB4A7790B8A89F6298730E8' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 11:09:18 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.154','O',trim(PROGRAM)||'+'||'临床输血管理系统',SID,serial# ,'20101217','11:09:19','scott@4002:BF9E0F53FAB4A7790B8A89F6298730E8' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 11:09:18 SQL Prepare: ORACLE - Commit 5 11:09:18 SQL Execute: ORACLE - Commit 6 11:09:18 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 11:09:18 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 11:09:18 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 11:09:18 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 11:09:18 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4002' and CZBZ00 in ('1') 11 11:09:18 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4002' and CZBZ00 in ('1') 12 11:09:18 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.154','O',trim(PROGRAM)||'+'||'临床输血管理系统',SID,serial# ,'20101217','11:09:19','sd_Hospital@4002:7F133ACBFAD05E9540083F53FB3855F4' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 11:09:18 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.154','O',trim(PROGRAM)||'+'||'临床输血管理系统',SID,serial# ,'20101217','11:09:19','sd_Hospital@4002:7F133ACBFAD05E9540083F53FB3855F4' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 11:09:18 SQL Prepare: ORACLE - Commit 15 11:09:18 SQL Execute: ORACLE - Commit 16 11:09:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='O' 17 11:09:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='O' 18 11:09:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4002' and CZBZ00 in ('1') 19 11:09:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4002' and CZBZ00 in ('1') 20 11:09:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 21 11:09:18 SQL Execute: ORACLE - Select SYSDATE from Dual 22 11:09:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 23 11:09:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 24 11:09:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 25 11:09:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 26 11:09:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='O' 27 11:09:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='O' 28 11:09:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 11:09:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 11:09:18 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 31 11:09:18 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 32 11:09:18 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='O' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4002')) order by BH0000 33 11:09:18 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='O' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4002')) order by BH0000 34 11:09:18 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '4002'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'O' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4002')) 35 11:09:18 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '4002'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'O' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4002')) 36 11:09:18 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=367 37 11:09:18 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=367 38 11:09:18 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 39 11:09:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 40 11:09:18 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 41 11:09:18 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 42 11:09:18 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 43 11:09:18 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 44 11:09:18 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 45 11:09:18 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 46 11:09:18 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')) 47 11:09:18 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')) 48 11:09:18 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2390577,367,'血库','O',nvl('3079067',' '),'192.168.11.154#646:737@xkgl.exe+临床输血管理系统',90) 49 11:09:18 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2390577,367,'血库','O',nvl('3079067',' '),'192.168.11.154#646:737@xkgl.exe+临床输血管理系统',90) 50 11:09:18 SQL Prepare: ORACLE - Commit 51 11:09:18 SQL Execute: ORACLE - Commit 52 11:09:18 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 90 53 11:09:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 90 54 11:09:18 SQL Prepare: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 55 11:09:18 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 56 11:09:18 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.11.154' 57 11:09:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.11.154' 58 11:09:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 59 11:09:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 60 11:09:18 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 61 11:09:18 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 62 11:09:18 SQL Prepare: ORACLE - Commit 63 11:09:18 SQL Execute: ORACLE - Commit 64 11:09:18 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 90 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 11:09:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 90 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 11:09:18 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 67 11:09:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 11:09:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 69 11:09:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 70 11:09:18 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='O') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',90,')> 0) and YXQ000>='20101217' 71 11:09:18 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='O') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',90,')> 0) and YXQ000>='20101217' 72 11:09:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 73 11:09:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 74 11:09:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 75 11:09:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 76 11:09:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 77 11:09:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 78 11:09:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='O' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='O' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 79 11:09:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='O' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='O' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 80 11:09:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'O$%' and A.XTDM00='O' and trim(A.MKDM00)='O$'||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 81 11:09:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'O$%' and A.XTDM00='O' and trim(A.MKDM00)='O$'||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 82 11:09:18 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 ((367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 83 11:09:18 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 ((367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 84 11:09:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 85 11:09:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 86 11:09:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 87 11:09:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 367= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=367)))) 88 11:09:18 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND (OBJECT_NAME LIKE 'TR_XK_%' or OBJECT_NAME LIKE 'TR_BM_%') AND STATUS<>'VALID' 89 11:09:18 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND (OBJECT_NAME LIKE 'TR_XK_%' or OBJECT_NAME LIKE 'TR_BM_%') AND STATUS<>'VALID' 90 11:09:19 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND (Trigger_NAME LIKE 'TR_XK_%' OR Trigger_NAME LIKE 'TR_BM_%') 91 11:09:19 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND (Trigger_NAME LIKE 'TR_XK_%' OR Trigger_NAME LIKE 'TR_BM_%') 92 11:09:20 SQL Prepare: ORACLE - select sysdate from dual 93 11:09:20 SQL Execute: ORACLE - select sysdate from dual 94 11:09:20 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 367 95 11:09:20 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 367 96 11:09:20 SQL Prepare: ORACLE - Select XTBB00 from XT_YYXT00 where XTDM00='O' 97 11:09:20 SQL Execute: ORACLE - Select XTBB00 from XT_YYXT00 where XTDM00='O' 98 11:09:20 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 in ('CXTJ_MZZYQD','YJ_XMYXTS','YJ_XMCXZJTF','XK_KCCXZTSZ','XK_SFSXDXXFJF','XK_SXSQBGDJ','XK_SFZDJYJG','XK_SFXSCXR0','XK_XYRKSFDR','XK_SQDKJCPXZT','XK_BXSQDKDKS','XK_BXSQDFWKS','XK_SFXSBXAN','XK_YJDZXBZ','XK_XXJDPRINT','XK_SFDRDWMR','XKJCPXMFPP','XK_SXJLDGSLB','XK_FXQXRSFKK','XK_XXFJZSFKK','XK_XXJYZSFMR','XK_JCPXMFPP','XK_SFZJZXXM','XK_XXMRBRXX','XK_JCPXFF1MC','XK_JCPXFF1ZG','XK_JCPXFF1CG','XK_RKDDRGE','XK_SFZJCJHQS','XK_JCPXFF2MC', 'XK_JCPXFF2ZG','XK_JCPXFF2CG','XK_SFMRTXM00','XK_RKSFMRXYPZ','XK_XYYXQTSTS','XK_SFDYJCPXBGD','XK_SXJLDSFDYLC','XK_XXSFYXXG','XK_JCPXSFYXXXWK','XK_XYRKDRLJ','XK_FXSFSCSXSQ','XK_JCPXSFYCXD','XK_SFXSZXBXGN','XK_XXJDZLXM','XK_TXXZGZXD','XK_RHDYXSFTS', 'XK_JCPXSFZXSSXSQD','XK_JCPXSFPDSXCF','XK_JCPXSFTXXYSY','XK_SXSQSFZJJSGN','XK_SFDYBLFYHBD','BQ_YZLL_XSSJYE','XK_CXRQMRTQTS','XK_SXJLSFXSFXDH','XK_BRXXSFYXFLRRXG','XK_FXSFXYYZXDBH','XK_MZSFDKFX','XK_SQDZXSFXS','XK_SXSQXSTS') 99 11:09:20 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 in ('CXTJ_MZZYQD','YJ_XMYXTS','YJ_XMCXZJTF','XK_KCCXZTSZ','XK_SFSXDXXFJF','XK_SXSQBGDJ','XK_SFZDJYJG','XK_SFXSCXR0','XK_XYRKSFDR','XK_SQDKJCPXZT','XK_BXSQDKDKS','XK_BXSQDFWKS','XK_SFXSBXAN','XK_YJDZXBZ','XK_XXJDPRINT','XK_SFDRDWMR','XKJCPXMFPP','XK_SXJLDGSLB','XK_FXQXRSFKK','XK_XXFJZSFKK','XK_XXJYZSFMR','XK_JCPXMFPP','XK_SFZJZXXM','XK_XXMRBRXX','XK_JCPXFF1MC','XK_JCPXFF1ZG','XK_JCPXFF1CG','XK_RKDDRGE','XK_SFZJCJHQS','XK_JCPXFF2MC', 'XK_JCPXFF2ZG','XK_JCPXFF2CG','XK_SFMRTXM00','XK_RKSFMRXYPZ','XK_XYYXQTSTS','XK_SFDYJCPXBGD','XK_SXJLDSFDYLC','XK_XXSFYXXG','XK_JCPXSFYXXXWK','XK_XYRKDRLJ','XK_FXSFSCSXSQ','XK_JCPXSFYCXD','XK_SFXSZXBXGN','XK_XXJDZLXM','XK_TXXZGZXD','XK_RHDYXSFTS', 'XK_JCPXSFZXSSXSQD','XK_JCPXSFPDSXCF','XK_JCPXSFTXXYSY','XK_SXSQSFZJJSGN','XK_SFDYBLFYHBD','BQ_YZLL_XSSJYE','XK_CXRQMRTQTS','XK_SXJLSFXSFXDH','XK_BRXXSFYXFLRRXG','XK_FXSFXYYZXDBH','XK_MZSFDKFX','XK_SQDZXSFXS','XK_SXSQXSTS') 100 11:09:20 SQL Prepare: ORACLE - select * from XK_XYRK00 where RKZT00='1' AND CKZT00='0' AND YXRQ00>=to_char(sysdate,'YYYYMMDD') AND YXRQ00<=to_char(sysdate+1,'YYYYMMDD') 101 11:09:20 SQL Execute: ORACLE - select * from XK_XYRK00 where RKZT00='1' AND CKZT00='0' AND YXRQ00>=to_char(sysdate,'YYYYMMDD') AND YXRQ00<=to_char(sysdate+1,'YYYYMMDD') 102 11:09:23 SQL Prepare: ORACLE - select a.* From VW_XK_SXSQ00 a where 1=1 and LRRQ00 between '20101217' and '20101217' and SQZT00 = '0' order by SQDH00 desc 103 11:09:23 SQL Execute: ORACLE - select a.* From VW_XK_SXSQ00 a where 1=1 and LRRQ00 between '20101217' and '20101217' and SQZT00 = '0' order by SQDH00 desc 104 11:09:23 SQL Prepare: ORACLE - SELECT B.JYXMMC,B.JYXMBH,A.JYJG00, A.JYJG00,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID AND B.BGDJID=:1 AND ZYID00(+)=:2 and A.SQDH00(+)=:3 ORDER BY JYXMBH 105 11:09:23 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH,A.JYJG00, A.JYJG00,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID AND B.BGDJID=? AND ZYID00(+)=? and A.SQDH00(+)=? ORDER BY JYXMBH 106 11:09:23 SQL Prepare: ORACLE - SELECT B.JYXMMC,B.JYXMBH,A.JYJG00, A.JYJG00,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID AND B.BGDJID=:1 AND ZYID00(+)=:2 and A.SQDH00(+)=:3 ORDER BY JYXMBH 107 11:09:23 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH,A.JYJG00, A.JYJG00,A.ZYID00,B.BGXMID FROM XK_SQDJG0 A,XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID AND B.BGDJID=? AND ZYID00(+)=? and A.SQDH00(+)=? ORDER BY JYXMBH 108 11:09:24 SQL Prepare: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 109 11:09:24 SQL Execute: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 110 11:09:25 SQL Prepare: ORACLE - select XXMC00,XXBH00 from VW_XK_RHXXBM 111 11:09:25 SQL Execute: ORACLE - select XXMC00,XXBH00 from VW_XK_RHXXBM 112 11:09:25 SQL Prepare: ORACLE - select * from bm_tyzd00 where zdmc00='交叉配血试验结果' and yxbz00='1' 113 11:09:25 SQL Execute: ORACLE - select * from bm_tyzd00 where zdmc00='交叉配血试验结果' and yxbz00='1' 114 11:09:25 SQL Prepare: ORACLE - select XYPZMC,XYPZBH from VW_XK_XYPZBM 115 11:09:25 SQL Execute: ORACLE - select XYPZMC,XYPZBH from VW_XK_XYPZBM 116 11:09:25 SQL Prepare: ORACLE - select XXMC00,XXBH00 from VW_XK_XXBM00 117 11:09:25 SQL Execute: ORACLE - select XXMC00,XXBH00 from VW_XK_XXBM00 118 11:09:25 SQL Prepare: ORACLE - select PXFFID,PXFFMC from VW_XK_PXFFBM order by PXFFID 119 11:09:25 SQL Execute: ORACLE - select PXFFID,PXFFMC from VW_XK_PXFFBM order by PXFFID 120 11:09:25 SQL Prepare: ORACLE - select * FROM VW_BM_XKBRXX_mzzy WHERE ZYH000='199237' 121 11:09:25 SQL Execute: ORACLE - select * FROM VW_BM_XKBRXX_mzzy WHERE ZYH000='199237' 122 11:09:25 SQL Prepare: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 123 11:09:25 SQL Execute: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 124 11:09:25 SQL Prepare: ORACLE - SELECT * FROM VW_XK_SXSQ00 WHERE BRID00=1146533 and SQZT00 in ('0','1','2','9') 125 11:09:25 SQL Execute: ORACLE - SELECT * FROM VW_XK_SXSQ00 WHERE BRID00=1146533 and SQZT00 in ('0','1','2','9') 126 11:09:25 SQL Prepare: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '全血' and XX0000='O' and RHXX00='' order by YXRQ00 127 11:09:25 SQL Execute: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '全血' and XX0000='O' and RHXX00='' order by YXRQ00 128 11:09:25 SQL Prepare: ORACLE - SELECT * FROM VW_XK_JCPXBG WHERE SQDH00='035282' 129 11:09:25 SQL Execute: ORACLE - SELECT * FROM VW_XK_JCPXBG WHERE SQDH00='035282' 130 11:09:26 SQL Prepare: ORACLE - select * FROM VW_BM_XKBRXX_mzzy WHERE ZYH000='199237' 131 11:09:26 SQL Execute: ORACLE - select * FROM VW_BM_XKBRXX_mzzy WHERE ZYH000='199237' 132 11:09:26 SQL Prepare: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 133 11:09:26 SQL Execute: ORACLE - select Trim(ZDXX00) ZDXX00 from XK_BRXX00 where brid00=1146533 134 11:09:26 SQL Prepare: ORACLE - SELECT * FROM VW_XK_SXSQ00 WHERE BRID00=1146533 and SQZT00 in ('0','1','2','9') 135 11:09:26 SQL Execute: ORACLE - SELECT * FROM VW_XK_SXSQ00 WHERE BRID00=1146533 and SQZT00 in ('0','1','2','9') 136 11:09:26 SQL Prepare: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '全血' and XX0000='O' and RHXX00='' order by YXRQ00 137 11:09:26 SQL Execute: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '全血' and XX0000='O' and RHXX00='' order by YXRQ00 138 11:09:26 SQL Prepare: ORACLE - SELECT * FROM VW_XK_JCPXBG WHERE SQDH00='035282' 139 11:09:26 SQL Execute: ORACLE - SELECT * FROM VW_XK_JCPXBG WHERE SQDH00='035282' 140 11:09:28 SQL Prepare: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '悬浮红细胞' and XX0000='O' and RHXX00='' order by YXRQ00 141 11:09:28 SQL Execute: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '悬浮红细胞' and XX0000='O' and RHXX00='' order by YXRQ00 142 11:09:30 SQL Prepare: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '悬浮红细胞' and XX0000='O' and RHXX00='阳性' order by YXRQ00 143 11:09:30 SQL Execute: ORACLE - select * from VW_XK_XYKC00 where XYPZMC like '悬浮红细胞' and XX0000='O' and RHXX00='阳性' order by YXRQ00 144 11:09:31 SQL Prepare: ORACLE - SELECT A.SFTXPX FROM XK_JCPXGZ A, VW_XK_XYPZBM B WHERE A. XYPZID=B.XYPZID AND B.XYPZMC='悬浮红细胞' 145 11:09:31 SQL Execute: ORACLE - SELECT A.SFTXPX FROM XK_JCPXGZ A, VW_XK_XYPZBM B WHERE A. XYPZID=B.XYPZID AND B.XYPZMC='悬浮红细胞' 146 11:09:31 SQL Prepare: ORACLE - select d.brxm00,d.BRID00 from xk_jcpxbg a,yj_yw0000 b,xk_sxsq00 c,bm_brxxb0 d where a.xyyjdh=b.yjdjh0 and b.xmzt00=2 and c.brid00=d.brid00 and c.sqdh00=a.sqdh00 and a.cxbz00<>'N' AND a.XDBH00='01976838' 147 11:09:31 SQL Execute: ORACLE - select d.brxm00,d.BRID00 from xk_jcpxbg a,yj_yw0000 b,xk_sxsq00 c,bm_brxxb0 d where a.xyyjdh=b.yjdjh0 and b.xmzt00=2 and c.brid00=d.brid00 and c.sqdh00=a.sqdh00 and a.cxbz00<>'N' AND a.XDBH00='01976838' 148 11:09:37 SQL Prepare: ORACLE - select d.brxm00,d.BRID00 from yj_yw0000 b,xk_sxsq00 c,bm_brxxb0 d where c.yyyjdh=b.yjdjh0 and b.xmzt00=2 and c.brid00=d.brid00 AND c.YYXDBH='01976838' 149 11:09:37 SQL Execute: ORACLE - select d.brxm00,d.BRID00 from yj_yw0000 b,xk_sxsq00 c,bm_brxxb0 d where c.yyyjdh=b.yjdjh0 and b.xmzt00=2 and c.brid00=d.brid00 AND c.YYXDBH='01976838' 150 11:09:43 SQL Prepare: ORACLE - SELECT B.KSMC00,C.XM0000,C.ZYH000,a.sqdh00 FROM XK_JCPXBG A,XK_SXSQ00 B,ZY_BRXXB0 C WHERE B.ZYID00=C.ZYID00 AND A.SQDH00=B.SQDH00 AND CXBZ00<>'N' AND XDBH00='01976838' 151 11:09:43 SQL Execute: ORACLE - SELECT B.KSMC00,C.XM0000,C.ZYH000,a.sqdh00 FROM XK_JCPXBG A,XK_SXSQ00 B,ZY_BRXXB0 C WHERE B.ZYID00=C.ZYID00 AND A.SQDH00=B.SQDH00 AND CXBZ00<>'N' AND XDBH00='01976838'