1 08:03:05 Log started for: 健康体检系统 2 08:03:05 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','T',trim(PROGRAM)||'+'||'健康体检系统',SID,serial# ,'20110705','08:03:00','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 08:03:05 SQL Execute: ORACLE - Commit 4 08:03:05 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 5 08:03:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 6 08:03:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 7 08:03:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','T',trim(PROGRAM)||'+'||'健康体检系统',SID,serial# ,'20110705','08:03:00','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 8 08:03:06 SQL Execute: ORACLE - Commit 9 08:03:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 10 08:03:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 08:03:06 SQL Execute: ORACLE - Select SYSDATE from Dual 12 08:03:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 13 08:03:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 14 08:03:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 08:03:06 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 16 08:03:06 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='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 17 08:03:10 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 18 08:03:10 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 19 08:03:10 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 20 08:03:10 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 21 08:03:11 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 22 08:03:11 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 23 08:03:11 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')) 24 08:03:11 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2455475,476,'wlzx-2','T',nvl('7541988',' '),'192.168.15.15#87:2826@MedicalExa.exe+健康体检系统',125) 25 08:03:11 SQL Execute: ORACLE - Commit 26 08:03:11 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 27 08:03:11 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 28 08:03:11 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 29 08:03:11 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 30 08:03:11 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 31 08:03:11 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='T') and YXQ000>='20110705' 32 08:03:11 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 33 08:03:11 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 34 08:03:11 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='T' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='T' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 35 08:03:11 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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 36 08:03:11 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 MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 37 08:03:11 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 38 08:03:11 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 39 08:03:11 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 40 08:03:11 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 41 08:03:11 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '476' 42 08:03:11 SQL Execute: ORACLE - SELECT name00,SF_TJ_GETXTCS('222137',value0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 43 08:03:12 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT') 44 08:03:12 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 45 08:03:19 SQL Execute: ORACLE - select GZGZKL AS ZKL000 from BM_ZKLQXB where YGBH00 = 476 46 08:03:19 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_TJKSSFZJSF' 47 08:03:31 SQL Execute: ORACLE - select * from VW_TJ_HAVEGH where yyid00='222137' 48 08:06:41 Log started for: 后台维护系统 49 08:06:44 SQL Execute: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000 50 08:06:44 SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000, t1.PYSM00,t1.WBSM00, (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00, t1.YGXZ00, t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00, t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB, (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00, t1.YSLB00, (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC, t1.ssdj00,t1.ylfl00 from BM_YGBM00 t1 where t1.YGBH00>=1 and(1=? OR CZBZ00<>'2') order by t1.XKH000,t1.BMBH00 51 09:32:26 SQL Execute: ORACLE - Select * from XT_YGXZ00 ORDER BY DM0000 52 09:32:27 SQL Execute: ORACLE - select t1.YGBH00,t1.BMBH00,t1.ZWXM00,t1.XB0000,t1.XKH000, t1.PYSM00,t1.WBSM00, (select BMMC00 from BM_BMBM00 where t1.BMBH00=BMBH00(+)) BMMC00, t1.YGXZ00, t1.CFJB00,t1.GZDJ00,t1.MZDJ00,t1.DPDJ00,t1.SJDJ00, t1.CZBZ00,t1.DLMM00,t1.BRID00,t1.MRGHLB, (select LBMC00 from BM_GHLBB0 where SFYX00='Y' and t1.MRGHLB=LBBH00(+)) LBMC00, t1.YSLB00, (select YSLBMC from BM_YSLB00 where t1.YSLB00=YSLB00(+)) YSLBMC, t1.ssdj00,t1.ylfl00 from BM_YGBM00 t1 where t1.YGBH00>=1 and(1=? OR CZBZ00<>'2') order by t1.XKH000,t1.BMBH00 53 09:32:37 SQL Execute: ORACLE - UPDATE BM_YGBM00 SET YHKL00='9B63C8F1CBDB0A04CFB9CD18CFBAEBF1' where ygbh00=174 54 09:32:37 SQL Execute: ORACLE - Commit 55 09:33:51 Log started for: 健康体检系统 56 09:33:51 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','T',trim(PROGRAM)||'+'||'健康体检系统',SID,serial# ,'20110705','09:33:51','scott@6601:A493D669E3B87112BEA44658B3010D1C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 57 09:33:51 SQL Execute: ORACLE - Commit 58 09:33:51 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 59 09:33:51 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 60 09:33:51 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='6601' and CZBZ00 in ('1') 61 09:33:51 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','T',trim(PROGRAM)||'+'||'健康体检系统',SID,serial# ,'20110705','09:33:51','sd_hospital@6601:9B63C8F1CBDB0A04CFB9CD18CFBAEBF1' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 62 09:33:51 SQL Execute: ORACLE - Commit 63 09:33:51 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 64 09:33:51 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='6601' and CZBZ00 in ('1') 65 09:33:51 SQL Execute: ORACLE - Select SYSDATE from Dual 66 09:33:51 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 67 09:33:51 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 68 09:33:51 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 69 09:33:51 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 70 09:33:51 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='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6601')) order by BH0000 71 09:33:51 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '6601'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='6601')) 72 09:33:51 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=174 73 09:33:51 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 74 09:33:51 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 75 09:33:51 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 76 09:33:51 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 77 09:33:51 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')) 78 09:33:51 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2455479,174,'wlzx-2','T',nvl('7542002',' '),'192.168.15.15#82:4810@MedicalExa.exe+健康体检系统',125) 79 09:33:51 SQL Execute: ORACLE - Commit 80 09:33:51 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 81 09:33:51 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 82 09:33:51 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 83 09:33:51 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 84 09:33:51 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 85 09:33:51 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='T') and YXQ000>='20110705' 86 09:33:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 87 09:33:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 09:33:51 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='T' and (( 174= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='T' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=174)))) 89 09:33:51 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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 90 09:33:51 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 ((174= 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=174)))) 91 09:33:51 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 92 09:33:51 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 174= 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=174)))) 93 09:33:51 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 94 09:33:51 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 95 09:33:51 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '174' 96 09:33:51 SQL Execute: ORACLE - SELECT name00,SF_TJ_GETXTCS('222137',value0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 97 09:33:51 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT') 98 09:33:51 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 99 09:33:54 SQL Execute: ORACLE - select GZGZKL AS ZKL000 from BM_ZKLQXB where YGBH00 = 174 100 09:33:54 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_TJKSSFZJSF' 101 09:33:55 SQL Execute: ORACLE - select * from VW_TJ_HAVEGH where yyid00='222137' 102 09:33:58 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where BRID00=1063214 and LBBH00='0' 103 09:33:58 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE DWID00=0 AND SFTJ00='N' and BRID00='1063214' order by GHID00 desc 104 09:33:58 SQL Execute: ORACLE - select TO_CHAR(SYSDATE-TO_NUMBER('365'),'YYYYMMDD') YXRQ00,GHRQ00 from sf_brxxb0 where ghid00=5687753 105 09:33:58 SQL Execute: ORACLE - commit 106 09:33:58 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE DWID00=0 AND SFTJ00='N' and BRID00='1063214' order by GHID00 desc 107 09:33:58 SQL Execute: ORACLE - SELECT * FROM TJ_BRXXB0 WHERE GHID00 = '5687753' 108 09:33:58 SQL Execute: ORACLE - SELECT DWZBID,ZBMC00 MC0000 FROM TJ_DWZB00 WHERE DWID00=0 109 09:33:58 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '222137' order by YJdjh0,KSXH00 110 09:33:58 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 111 09:33:58 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '5687753' AND ROWNUM = 1 AND XMZT00 < 2 112 09:33:58 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 113 09:34:00 SQL Execute: ORACLE - Select KDRQ00 from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND KDRQ00 IS NOT NULL AND ROWNUM = 1 114 09:34:00 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 115 09:34:00 SQL Execute: ORACLE - SELECT YJDJH0 FROM YJ_YW0000 WHERE ZLXMID = (SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '5687753' AND ROWNUM = 1 AND XMZT00 < 2 116 09:34:00 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '5687753' AND ROWNUM = 1 AND XMZT00 < 2 117 09:34:04 SQL Execute: ORACLE - SELECT DJH000 FROM SF_FYMX00 WHERE DJH000 IN (SELECT DJH000 FROM SF_BRFY00 WHERE JZDH00 = '0' and MZID00 = '5687753') AND ROWNUM = 1 AND XMBH00 = '2917' 118 09:34:04 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from dual 119 09:34:04 SQL Execute: ORACLE - select * from TJ_TJQMQX where YGBH00 = '174' and (QSRQ00 is not null and ZZRQ00 is not null) AND (QSRQ00 <= '20110705' AND ZZRQ00 >= '20110705') AND QMCS00 > 0 120 09:34:06 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 121 09:34:06 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '5687753' AND ROWNUM = 1 AND XMZT00 < 2 122 09:34:06 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 123 09:34:06 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.yyid00 = '222137' order by YJdjh0,KSXH00 124 09:34:06 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 125 09:34:06 SQL Execute: ORACLE - SELECT NVL(ZJE000,0) FROM YJ_YW0000 WHERE ZLXMID = (SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00 = 'TJ_ZLZDZEJMXMID') AND ZYGHID = '5687753' AND ROWNUM = 1 AND XMZT00 < 2 126 09:34:06 SQL Execute: ORACLE - Select b.* from VW_TJ_YJ_YW0000 b where ZYGHID='5687753' and xmzt00 < 2 and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) order by YJdjh0,KSXH00 127 09:43:21 Log started for: 门诊医生工作站分系统 128 09:43:21 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20110705','09:43:21','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 129 09:43:21 SQL Execute: ORACLE - Commit 130 09:43:21 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 131 09:43:21 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 132 09:43:21 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 133 09:43:21 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','8',trim(PROGRAM)||'+'||'门诊医生工作站分系统',SID,serial# ,'20110705','09:43:21','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 134 09:43:21 SQL Execute: ORACLE - Commit 135 09:43:21 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 136 09:43:21 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 137 09:43:21 SQL Execute: ORACLE - Select SYSDATE from Dual 138 09:43:21 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 139 09:43:21 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 140 09:43:21 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 141 09:43:21 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 142 09:43:21 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 143 09:43:21 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' 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 ('0','1') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 144 09:43:21 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 145 09:43:21 SQL Execute: ORACLE - select GHKSBH from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') and rownum=1 146 09:43:24 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' 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='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 147 09:43:24 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 148 09:43:24 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 149 09:43:24 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 150 09:43:24 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 151 09:43:24 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 152 09:43:24 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')) 153 09:43:24 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2455480,476,'wlzx-2','8',nvl('7542004',' '),'192.168.15.15#75:6467@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 154 09:43:24 SQL Execute: ORACLE - Commit 155 09:43:24 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 156 09:43:24 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 157 09:43:24 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 158 09:43:24 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 159 09:43:24 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 160 09:43:24 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 161 09:43:24 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 162 09:43:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 163 09:43:24 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 164 09:43:25 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20110705' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 165 09:43:25 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 166 09:43:25 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 167 09:43:25 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 168 09:43:25 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 169 09:43:25 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 170 09:43:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 171 09:43:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS') 172 09:43:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 476 173 09:43:25 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 174 09:43:25 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 175 09:43:25 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 176 09:43:25 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 177 09:43:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 178 09:43:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='8'))) 179 09:43:25 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||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 180 09:43:25 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 '))) 181 09:43:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 182 09:43:25 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='+ '))) 183 09:43:27 SQL Execute: ORACLE - select YSLB00 from BM_YGBM00 where YGBH00=? 184 09:43:27 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 185 09:43:27 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 186 09:43:27 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 187 09:43:27 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 188 09:43:27 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 189 09:43:27 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 190 09:43:27 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 191 09:43:27 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 192 09:43:27 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 193 09:43:27 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 194 09:43:27 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 195 09:43:28 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 196 09:43:28 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 197 09:43:28 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 198 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 199 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 200 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 201 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 202 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 203 09:43:28 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 204 09:43:28 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 205 09:43:28 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 206 09:43:28 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 476 207 09:43:28 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 208 09:43:28 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 209 09:43:28 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 210 09:43:28 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 211 09:43:28 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 212 09:43:28 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=476 213 09:43:29 SQL Execute: ORACLE - Select SYSDATE from Dual 214 09:43:29 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 215 09:43:29 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 216 09:43:29 SQL Execute: ORACLE - Commit 217 09:43:29 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'IC_YBYYJKLM' 218 09:43:29 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 219 09:43:29 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 220 09:43:29 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 221 09:43:29 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 222 09:43:29 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 order by ghh000 desc 223 09:43:30 SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 224 09:43:30 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0 from YS_BRZDXX a, XT_ICD900 b where a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? 225 09:43:30 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD from YS_BRZDXX where SFXYZD='0'and GHID00=? 226 09:43:30 SQL Execute: ORACLE - select sf_ys_ghxz00(20,476,20601) from dual 227 09:43:31 SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0 where lbbh00 in (12,13,14,15,16,17,18,19,26) 228 09:43:31 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 229 09:43:31 SQL Execute: ORACLE - select SFYD00 from BM_BRXXB0 where BRID00=20601 230 09:43:31 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601) and rownum=1 231 09:43:31 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 232 09:43:31 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 233 09:43:31 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 234 09:43:33 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 235 09:43:33 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 236 09:43:35 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 237 09:43:35 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 238 09:43:35 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 239 09:43:40 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 240 09:43:43 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'jmy'),PYSM00) where Rownum<=32 241 09:43:45 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 242 09:43:45 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 243 09:43:53 SQL Execute: ORACLE - select 1 NUM from YS_CRBDJ0 where brid00 = '20601' and trim(jbmc00)= '角膜炎，点状' and czrq00>to_char(sysdate-365,'YYYYMMDD') 244 09:43:58 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1 245 09:43:58 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 246 09:43:58 SQL Execute: ORACLE - commit 247 09:43:58 SQL Execute: ORACLE - insert into YS_BRZDXX (ZDXXID, GHID00, GHH000,ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM,JZKS00,ZDMC00, SFYZ00, SFXYZD,ZDRQ00,ZDSJ00)Values (SQ_YS_BRZDXX_ZDXXID.nextval, 5687755,'3827609','3','H16.101','','476','陈剑锋','20','角膜炎，点状','1','1',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS')) 248 09:43:58 SQL Execute: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00)Values('',5687755,SQ_YS_BRBQB0_BRBQID.Nextval,'3827609',476,0,to_char(sysdate,'yyyymmdd')||substr(to_char(sysdate,'hh24:mi:ss'),1,2)||substr(to_char(sysdate,'hh24:mi:ss'),4,2),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'陈剑锋','20110702') 249 09:43:58 SQL Execute: ORACLE - commit 250 09:43:58 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END; 251 09:43:59 SQL Execute: ORACLE - commit 252 09:43:59 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 253 09:43:59 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 254 09:43:59 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687755 255 09:43:59 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 256 09:43:59 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687755 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687755 and rownum=1 257 09:43:59 SQL Execute: ORACLE - select sum(CFZJE0) from YF_MZCF00 where GHH000=? and cfzt00 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 258 09:43:59 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 259 09:43:59 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 260 09:43:59 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 261 09:44:00 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 262 09:44:00 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 263 09:44:00 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 264 09:44:00 SQL Execute: ORACLE - Select SYSDATE from Dual 265 09:44:00 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 266 09:44:00 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 267 09:44:00 SQL Execute: ORACLE - Commit 268 09:44:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 269 09:44:00 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 270 09:44:00 SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=? and GHYSBH=? and PBLX00='0' and GHLBBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj 271 09:44:00 SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=? and PBLX00='1' and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj 272 09:44:00 SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00,AS_ZSQGFF => :AS_ZSQGFF); END; 273 09:44:02 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='3827609' and HZZT00 in ('0','2','4') 274 09:44:02 SQL Execute: ORACLE - select ghid00,LBBH00,ZDFF00,ZLFA00 from SF_BRXXB0 where ghh000=? 275 09:44:02 SQL Execute: ORACLE - update YS_BRZDXX set GHID00=5687756 WHERE GHID00=5687755 276 09:44:02 SQL Execute: ORACLE - update YS_BRBQB0 set GHID00=5687756 WHERE GHID00=5687755 277 09:44:02 SQL Execute: ORACLE - COMMIT 278 09:44:02 SQL Execute: ORACLE - Commit 279 09:44:02 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 280 09:44:02 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'H16.101',ZDMSMC = '',ZDMC00 = '角膜炎，点状',SFYZ00 = '1' where ZDXXID = 1669173 281 09:44:02 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 282 09:44:02 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 283 09:44:02 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 284 09:44:02 SQL Execute: ORACLE - Commit 285 09:44:02 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 286 09:44:02 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 287 09:44:02 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 288 09:44:02 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 289 09:44:02 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 290 09:44:02 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 291 09:44:02 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 292 09:44:04 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 293 09:44:07 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 294 09:44:09 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 295 09:44:09 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 296 09:44:10 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 297 09:44:10 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 298 09:44:10 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 299 09:44:12 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 300 09:44:12 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 301 09:44:12 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 302 09:44:13 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 303 09:44:13 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 304 09:44:13 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 305 09:44:19 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 306 09:44:20 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 307 09:44:21 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 308 09:44:21 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 309 09:44:21 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 310 09:44:21 SQL Execute: ORACLE - Select SYSDATE from Dual 311 09:44:21 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 312 09:44:21 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 313 09:44:21 SQL Execute: ORACLE - Commit 314 09:44:21 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 315 09:44:21 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 316 09:44:21 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 317 09:44:21 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'H10.802',ZDMSMC = '',ZDMC00 = '结膜炎',SFYZ00 = '1' where ZDXXID = 1669173 318 09:44:21 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 319 09:44:21 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 320 09:44:21 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 321 09:44:21 SQL Execute: ORACLE - Commit 322 09:44:21 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 323 09:44:21 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 324 09:44:21 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 325 09:44:21 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 326 09:44:21 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 327 09:44:21 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 328 09:44:21 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 329 09:44:23 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 330 09:44:24 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 331 09:44:24 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 332 09:44:25 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 333 09:44:25 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 334 09:44:25 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 335 09:44:30 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 336 09:44:32 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 337 09:44:32 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 338 09:44:32 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 339 09:44:32 SQL Execute: ORACLE - Select SYSDATE from Dual 340 09:44:32 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 341 09:44:32 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 342 09:44:32 SQL Execute: ORACLE - Commit 343 09:44:32 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 344 09:44:32 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 345 09:44:32 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 346 09:44:32 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'A50.301+',ZDMSMC = '',ZDMC00 = '点状角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 347 09:44:32 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 348 09:44:32 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 349 09:44:32 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 350 09:44:32 SQL Execute: ORACLE - Commit 351 09:44:32 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 352 09:44:32 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 353 09:44:32 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 354 09:44:32 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 355 09:44:32 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 356 09:44:32 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 357 09:44:32 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 358 09:44:36 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 359 09:44:37 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 360 09:44:37 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 361 09:44:38 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 362 09:44:40 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 363 09:44:40 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 364 09:44:42 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 365 09:44:42 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 366 09:44:43 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 367 09:44:46 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 368 09:44:52 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 369 09:44:53 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 370 09:44:53 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 371 09:44:53 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 372 09:44:53 SQL Execute: ORACLE - Select SYSDATE from Dual 373 09:44:53 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 374 09:44:53 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 375 09:44:53 SQL Execute: ORACLE - Commit 376 09:44:53 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 377 09:44:53 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 378 09:44:53 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 379 09:44:53 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'A36.804+',ZDMSMC = '',ZDMC00 = '结膜炎，白喉性',SFYZ00 = '1' where ZDXXID = 1669173 380 09:44:53 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 381 09:44:53 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 382 09:44:53 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 383 09:44:53 SQL Execute: ORACLE - Commit 384 09:44:53 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 385 09:44:53 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 386 09:44:53 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 387 09:44:53 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 388 09:44:53 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 389 09:44:53 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 390 09:44:53 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 391 09:44:55 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 392 09:44:56 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 393 09:44:56 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 394 09:44:57 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 395 09:44:57 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 396 09:44:57 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 397 09:45:01 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'jmy'),PYSM00) where Rownum<=32 398 09:45:05 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 399 09:45:06 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 400 09:45:06 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 401 09:45:06 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 402 09:45:06 SQL Execute: ORACLE - Select SYSDATE from Dual 403 09:45:06 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 404 09:45:06 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 405 09:45:06 SQL Execute: ORACLE - Commit 406 09:45:06 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 407 09:45:06 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 408 09:45:06 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 409 09:45:06 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'B00.505+',ZDMSMC = '',ZDMC00 = '角膜炎，单纯疱疹性',SFYZ00 = '1' where ZDXXID = 1669173 410 09:45:06 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 411 09:45:06 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 412 09:45:06 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 413 09:45:06 SQL Execute: ORACLE - Commit 414 09:45:06 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 415 09:45:06 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 416 09:45:06 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 417 09:45:06 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 418 09:45:06 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 419 09:45:06 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 420 09:45:06 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 421 09:45:07 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 422 09:45:09 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 423 09:45:09 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 424 09:45:09 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 425 09:45:10 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 426 09:45:14 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 427 09:45:16 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 428 09:45:17 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 429 09:45:18 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 430 09:45:18 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 431 09:45:18 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 432 09:45:18 SQL Execute: ORACLE - Select SYSDATE from Dual 433 09:45:18 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 434 09:45:18 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 435 09:45:18 SQL Execute: ORACLE - Commit 436 09:45:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 437 09:45:18 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 438 09:45:18 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 439 09:45:18 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'N64.803',ZDMSMC = '',ZDMC00 = '哺乳(产)后乳房复旧不全',SFYZ00 = '1' where ZDXXID = 1669173 440 09:45:18 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 441 09:45:18 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 442 09:45:18 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 443 09:45:18 SQL Execute: ORACLE - Commit 444 09:45:18 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 445 09:45:18 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 446 09:45:18 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 447 09:45:18 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 448 09:45:18 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 449 09:45:18 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 450 09:45:18 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 451 09:45:20 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 452 09:45:22 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 453 09:45:22 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 454 09:45:22 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 455 09:45:24 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 456 09:45:24 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 457 09:45:24 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 458 09:45:24 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 459 09:45:24 SQL Execute: ORACLE - Select SYSDATE from Dual 460 09:45:24 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 461 09:45:24 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 462 09:45:24 SQL Execute: ORACLE - Commit 463 09:45:24 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 464 09:45:24 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 465 09:45:24 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 466 09:45:24 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = 'M95.003',ZDMSMC = '',ZDMC00 = '鼻骨肥大',SFYZ00 = '1' where ZDXXID = 1669173 467 09:45:24 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 468 09:45:24 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 469 09:45:24 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 470 09:45:24 SQL Execute: ORACLE - Commit 471 09:45:25 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 472 09:45:25 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 473 09:45:25 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 474 09:45:25 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 475 09:45:25 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 476 09:45:25 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 477 09:45:25 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 478 09:45:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 479 09:45:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 480 09:47:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 481 09:47:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 482 09:49:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 483 09:49:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 484 09:51:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 485 09:51:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 486 09:52:44 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 487 09:52:46 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 488 09:52:48 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 489 09:52:48 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 490 09:52:49 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 491 09:52:49 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 492 09:52:49 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 493 09:52:53 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 494 09:52:55 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,Instrb(PYSM00,'jmy'),PYSM00) where Rownum<=32 495 09:53:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 496 09:53:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 497 09:54:20 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 498 09:54:22 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 499 09:55:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 500 09:55:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 501 09:57:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 502 09:57:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 503 09:58:56 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 504 09:58:57 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 505 09:58:57 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 506 09:58:58 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 507 09:58:58 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 508 09:58:58 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 509 09:59:01 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 510 09:59:06 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 511 09:59:06 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 512 09:59:06 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 513 09:59:06 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 514 09:59:06 SQL Execute: ORACLE - Select SYSDATE from Dual 515 09:59:06 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 516 09:59:06 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 517 09:59:06 SQL Execute: ORACLE - Commit 518 09:59:06 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 519 09:59:06 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 520 09:59:06 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 521 09:59:06 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = '',ZDMSMC = '',ZDMC00 = '角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 522 09:59:06 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 523 09:59:07 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 524 09:59:07 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 525 09:59:07 SQL Execute: ORACLE - Commit 526 09:59:07 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 527 09:59:07 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 528 09:59:07 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 529 09:59:07 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 530 09:59:07 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 531 09:59:07 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 532 09:59:07 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 533 09:59:10 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 534 09:59:27 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 535 09:59:27 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 536 10:00:28 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 537 10:00:30 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 538 10:00:30 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 539 10:00:30 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 540 10:00:30 SQL Execute: ORACLE - Select SYSDATE from Dual 541 10:00:31 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 542 10:00:31 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 543 10:00:31 SQL Execute: ORACLE - Commit 544 10:00:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 545 10:00:31 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 546 10:00:31 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 547 10:00:31 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = '',ZDMSMC = '',ZDMC00 = '角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 548 10:00:31 SQL Execute: ORACLE - Rollback 549 10:00:34 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 550 10:00:34 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 551 10:00:34 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 552 10:00:34 SQL Execute: ORACLE - Select SYSDATE from Dual 553 10:00:34 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 554 10:00:34 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 555 10:00:34 SQL Execute: ORACLE - Commit 556 10:00:34 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 557 10:00:34 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 558 10:00:34 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 559 10:00:34 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = '',ZDMSMC = '',ZDMC00 = '角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 560 10:00:34 SQL Execute: ORACLE - Rollback 561 10:01:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 562 10:01:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 563 10:01:28 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 564 10:01:28 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 565 10:01:28 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 566 10:01:28 SQL Execute: ORACLE - Select SYSDATE from Dual 567 10:01:28 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 568 10:01:28 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 569 10:01:28 SQL Execute: ORACLE - Commit 570 10:01:28 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 571 10:01:28 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 572 10:01:28 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 573 10:01:28 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = '',ZDMSMC = '',ZDMC00 = '角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 574 10:01:28 SQL Execute: ORACLE - Rollback 575 10:01:31 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 576 10:01:31 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 577 10:01:32 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 578 10:01:33 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 579 10:01:33 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 580 10:01:36 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 581 10:01:38 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 582 10:01:39 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='3827609' and LBBH00='0' 583 10:01:39 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 584 10:01:39 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='20601' and ZT0000='1' 585 10:01:39 SQL Execute: ORACLE - Select SYSDATE from Dual 586 10:01:39 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 587 10:01:39 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 588 10:01:39 SQL Execute: ORACLE - Commit 589 10:01:39 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 590 10:01:39 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100150096' and ICKNBH = '0222137100150096' 591 10:01:39 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='1' and ZDXXID not in (-1,1669173) 592 10:01:39 SQL Execute: ORACLE - update YS_BRZDXX set ZZDBZ0 = '3',ICD900 = '2222',ZDMSMC = '',ZDMC00 = '角膜炎',SFYZ00 = '1' where ZDXXID = 1669173 593 10:01:39 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='3827609' and SFXYZD='0' and ZDXXID not in (-1) 594 10:01:39 SQL Execute: ORACLE - update YS_BRBQB0 set ZS0000 ='',SZ0000 ='',ST0000 ='',MX0000 ='',TW0000 ='',XTCS00 ='',HXCS00 ='',SZY000 ='',SSY000 ='',SFHC00 ='0',BS0000 =?,TGJC00 =?,SYSJC0 =?,ZDCLNR =?,FBRQ00 ='20110702'Where GHH000='3827609' 595 10:01:39 SQL Execute: ORACLE - update SF_BRXXB0 set SFLG00='N' where GHID00=5687756 596 10:01:39 SQL Execute: ORACLE - Commit 597 10:01:39 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 598 10:01:39 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 599 10:01:39 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 600 10:01:39 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 601 10:01:39 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00 from SF_BRXXB0 where GHID00=5687756 602 10:01:39 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 603 10:01:39 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00<5687756 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=20601)and GHID00>5687756 and rownum=1 604 10:03:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 605 10:03:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 606 10:05:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 607 10:05:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 608 10:07:26 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 609 10:07:26 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 610 10:09:04 SQL Execute: ORACLE - select DJID00 from YS_CRBDJ0 where MZID00=? 611 10:09:06 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 612 10:09:06 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 613 10:09:07 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 614 10:09:07 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 615 10:09:07 SQL Execute: ORACLE - Select * from (select JBMC00,ICD900,PYSM00,WBSM00,SFCRB0,colour from vw_ys_jbzdzd where (PYSM00 Like ?) and( (cjr000=476 or cjks00=20 or yxfw00='2') ) Order By PXH000,PYSM00) where Rownum<=32 616 10:09:11 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 617 10:09:13 SQL Execute: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 618 10:09:13 SQL Execute: ORACLE - Rollback 619 10:09:13 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2455480 620 10:09:13 SQL Execute: ORACLE - Commit 621 10:09:13 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 622 10:09:13 SQL Execute: ORACLE - Commit 623 10:09:13 Log started for: 健康体检系统 624 11:36:42 SQL Execute: ORACLE - SELECT DWZBID,ZBMC00 MC0000 FROM TJ_DWZB00 WHERE DWID00=0 AND UPPER(PYSM00) like '%-%' 625 11:36:43 SQL Execute: ORACLE - SELECT DWZBID,ZBMC00 MC0000 FROM TJ_DWZB00 WHERE DWID00=0 AND UPPER(PYSM00) like '%--%' 626 16:23:06 Log started for: Gysystem 627 16:23:06 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110705','16:23:06','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 628 16:23:06 SQL Execute: ORACLE - Commit 629 16:23:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 630 16:23:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 631 16:23:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 632 16:23:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110705','16:23:06','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 633 16:23:06 SQL Execute: ORACLE - Commit 634 16:23:06 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 635 16:23:07 SQL Execute: ORACLE - Commit 636 16:23:07 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 637 16:23:07 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 638 16:23:07 SQL Execute: ORACLE - Select SYSDATE from Dual 639 16:23:07 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 640 16:23:07 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 641 16:23:07 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 642 16:23:07 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 643 16:23:07 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 644 16:23:07 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 645 16:23:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 646 16:23:14 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 647 16:23:14 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 648 16:23:14 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 649 16:23:14 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 650 16:23:14 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 651 16:23:14 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')) 652 16:23:14 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2455483,476,'wlzx-2','F',nvl('7542029',' '),'192.168.15.15#75:6598@GYSystem.exe+供应室管理子系统',23) 653 16:23:14 SQL Execute: ORACLE - Commit 654 16:23:14 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 23 655 16:23:14 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 656 16:23:14 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 657 16:23:14 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 658 16:23:14 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 659 16:23:14 SQL Execute: ORACLE - Commit 660 16:23:14 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 23 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 661 16:23:14 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 662 16:23:14 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',23,')> 0) and YXQ000>='20110705' 663 16:23:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 664 16:23:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 665 16:23:14 SQL Execute: ORACLE - select sysdate from dual 666 16:23:14 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 667 16:23:14 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 668 16:23:14 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 669 16:23:14 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 670 16:23:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 671 16:23:15 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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 672 16:23: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 ((476= 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=476)))) 673 16:23:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 476= 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=476)))) 674 16:23:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 675 16:23:15 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 676 16:23:15 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 677 16:23:15 SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX' ) 678 16:23:15 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 679 16:23:15 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 680 16:23:15 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 681 16:23:15 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 682 16:23:15 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB' 683 16:23:15 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq000'2' ) order by XKH000,PYSM00) where Rownum<=32 696 16:23:30 SQL Execute: ORACLE - SELECT * FROM vw_gy_kslywh where bmbh00=? ORDER BY WPBH00 697 16:23:32 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 698 16:23:41 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 699 16:23:41 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 700 16:23:44 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 701 16:23:44 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 702 16:23:48 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 703 16:23:49 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 704 16:23:51 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 705 16:23:51 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 706 16:23:54 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 707 16:23:55 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 708 16:23:56 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 709 16:24:14 SQL Execute: ORACLE - select sq_gy_kswply_qldh00.nextval from dual 710 16:24:14 SQL Execute: ORACLE - insert into GY_KSWPLY(QLDH00,QLKSBH,QLRBH0,QLRQ00,QLSJ00,QLCZY0,ZT0000,FFKSBH) values('47337','20','4','20110705', to_char(sysdate,'HH24:MI:SS'),'476',1,'150') 711 16:24:14 SQL Execute: ORACLE - insert into GY_WPLYMX(ID0000, QLDH00, WPBH00, QLSL00) values(SQ_GY_WPLYMX_ID0000.NextVal, '47337', 'b20', '60') 712 16:24:14 SQL Execute: ORACLE - Commit 713 16:24:26 SQL Execute: ORACLE - select * from vw_gy_kswply where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) AND QLRQ00 BETWEEN ? AND ? AND FFKSBH=? 714 16:24:26 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 715 16:24:26 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 716 16:24:26 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 717 16:24:26 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00