1 10:43:17 Log started for: 检验信息系统 2 10:43:17 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:43:17 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 10:43:17 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','72','10548' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 5 10:43:17 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','72','10548' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 6 10:43:17 SQL Data In: ORACLE - Rows affected = 1 7 10:43:17 SQL Prepare: ORACLE - Commit 8 10:43:17 SQL Execute: ORACLE - Commit 9 10:43:17 SQL Data In: ORACLE - Rows affected = 0 10 10:43:17 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 10:43:17 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 10:43:18 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 10:43:18 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 10:43:18 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 15 10:43:18 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 16 10:43:18 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 10:43:18 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 10:43:18 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','168','10543' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 19 10:43:18 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','168','10543' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 20 10:43:18 SQL Data In: ORACLE - Rows affected = 1 21 10:43:18 SQL Prepare: ORACLE - Commit 22 10:43:18 SQL Execute: ORACLE - Commit 23 10:43:18 SQL Data In: ORACLE - Rows affected = 0 24 10:43:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 25 10:43:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 26 10:43:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 27 10:43:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 28 10:43:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 10:43:18 SQL Execute: ORACLE - Select SYSDATE from Dual 30 10:43:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 10:43:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 10:43:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 10:43:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 10:43:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 35 10:43:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 36 10:43:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 10:43:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 10:43:18 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 39 10:43:18 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 40 10:43:18 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' 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','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 41 10:43:18 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' 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','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 42 10:43:21 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' 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='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 43 10:43:21 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' 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='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 44 10:43:21 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 45 10:43:21 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 46 10:43:21 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 10:43:21 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 10:43:21 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 10:43:21 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 10:43:21 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 10:43:21 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 10:43:21 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 10:43:21 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 10:43:21 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 55 10:43:21 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')) 56 10:43:23 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4354902,476,'wlzx-8','J',nvl('229104520',' '),'192.168.8.220#168:10543@PrjLIS_LIS.exe+检 验 管 理 系 统',23) 57 10:43:23 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4354902,476,'wlzx-8','J',nvl('229104520',' '),'192.168.8.220#168:10543@PrjLIS_LIS.exe+检 验 管 理 系 统',23) 58 10:43:23 SQL Data In: ORACLE - Rows affected = 1 59 10:43:23 SQL Prepare: ORACLE - Commit 60 10:43:23 SQL Execute: ORACLE - Commit 61 10:43:23 SQL Data In: ORACLE - Rows affected = 0 62 10:43:23 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 23 63 10:43:23 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 23 64 10:43:23 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 10:43:23 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 10:43:23 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 10:43:23 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 10:43:23 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220' 69 10:43:23 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220' 70 10:43:23 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 10:43:23 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 10:43:23 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 23 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 10:43:23 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 23 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 10:43:23 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 10:43:23 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 10:43:23 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 77 10:43:23 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 78 10:43:25 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 79 10:43:25 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 80 10:43:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 10:43:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 10:43:25 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20141105' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',23,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 83 10:43:25 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20141105' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',23,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 84 10:43:25 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 10:43:25 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 10:43:25 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 10:43:25 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 10:43:25 SQL Prepare: ORACLE - select sysdate from dual 89 10:43:25 SQL Execute: ORACLE - select sysdate from dual 90 10:43:25 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 476 91 10:43:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 476 92 10:43:27 SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00 93 10:43:27 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 94 10:43:27 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 95 10:43:27 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 96 10:43:27 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 97 10:43:27 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 98 10:43:27 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 99 10:43:27 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 100 10:43:27 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 101 10:43:27 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 102 10:43:27 SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 103 10:43:27 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 104 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 105 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 106 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 107 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 108 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 109 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 110 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 111 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 112 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 113 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 114 10:43:27 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 115 10:43:27 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 116 10:43:27 SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='23' 117 10:43:27 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='23' 118 10:43:27 SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 119 10:43:27 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 120 10:43:27 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='23' 121 10:43:27 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='23' 122 10:43:27 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='23' 123 10:43:27 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='23' 124 10:43:27 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='23' 125 10:43:27 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='23' 126 10:43:27 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='23' 127 10:43:27 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='23' 128 10:43:27 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='23' 129 10:43:27 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='23' 130 10:43:27 SQL Prepare: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( A.SQKS00+0 = '23' or A.SQBQ00+0 = '23') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '23' or DQKS00='23')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 131 10:43:27 SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( A.SQKS00+0 = '23' or A.SQBQ00+0 = '23') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '23' or DQKS00='23')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 132 10:43:28 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='BI' 133 10:43:28 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='BI' 134 10:43:28 SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='BI1297' and pyrq00='20141105' and rownum=1 135 10:43:28 SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='BI1297' and pyrq00='20141105' and rownum=1 136 10:43:28 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'BI1297' and PYRQ00 = '20141105' 137 10:43:28 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'BI1297' and PYRQ00 = '20141105' 138 10:43:28 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,3327) 139 10:43:28 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,3327) 140 10:43:28 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='BI1297' and pyrq00='20141105' ORDER BY DYSX00 141 10:43:28 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='BI1297' and pyrq00='20141105' ORDER BY DYSX00 142 10:43:30 SQL Prepare: ORACLE - SELECT distinct PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00,JLS000 FROM VW_JY_XJJG00 WHERE YBH000=:1 AND PYRQ00=:2 143 10:43:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI1297 144 10:43:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20141105 145 10:43:30 SQL Execute: ORACLE - SELECT distinct PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00,JLS000 FROM VW_JY_XJJG00 WHERE YBH000=? AND PYRQ00=? 146 10:43:30 SQL Prepare: ORACLE - select rownum,JG.* from (select B.XH0000,B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,B.ZWMC00 as KSSMC0 from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='941' AND YBH000='BI1297' AND PYRQ00='20141105' ORDER BY XH0000) JG 147 10:43:30 SQL Execute: ORACLE - select rownum,JG.* from (select B.XH0000,B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,B.ZWMC00 as KSSMC0 from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='941' AND YBH000='BI1297' AND PYRQ00='20141105' ORDER BY XH0000) JG 148 10:43:30 SQL Prepare: ORACLE - SELECT DISTINCT LCPY00,ZJPY00,BZ0000 FROM JY_XJJGPY WHERE YBH000='BI1297' AND PYRQ00='20141105' 149 10:43:30 SQL Execute: ORACLE - SELECT DISTINCT LCPY00,ZJPY00,BZ0000 FROM JY_XJJGPY WHERE YBH000='BI1297' AND PYRQ00='20141105' 150 10:43:31 SQL Prepare: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 151 10:43:31 SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 152 10:43:31 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='LX' 153 10:43:31 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='LX' 154 10:43:31 SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='LX0021' and pyrq00='20141105' and rownum=1 155 10:43:31 SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='LX0021' and pyrq00='20141105' and rownum=1 156 10:43:32 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0021' and PYRQ00 = '20141105' 157 10:43:32 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'LX0021' and PYRQ00 = '20141105' 158 10:43:32 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22591,22590) 159 10:43:32 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,22591,22590) 160 10:43:32 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0021' and pyrq00='20141105' ORDER BY DYSX00 161 10:43:32 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0021' and pyrq00='20141105' ORDER BY DYSX00 162 10:43:37 SQL Prepare: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 163 10:43:37 SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 164 10:43:40 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 165 10:43:40 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 166 10:43:40 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','41','42092' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 167 10:43:40 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','41','42092' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 168 10:43:40 SQL Data In: ORACLE - Rows affected = 1 169 10:43:40 SQL Prepare: ORACLE - Commit 170 10:43:40 SQL Execute: ORACLE - Commit 171 10:43:40 SQL Data In: ORACLE - Rows affected = 0 172 10:43:40 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 173 10:43:40 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 174 10:43:41 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 175 10:43:41 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 176 10:43:41 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 177 10:43:41 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 178 10:43:41 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 179 10:43:41 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 180 10:43:41 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','187','21779' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 181 10:43:41 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.220','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','187','21779' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 182 10:43:41 SQL Data In: ORACLE - Rows affected = 1 183 10:43:41 SQL Prepare: ORACLE - Commit 184 10:43:41 SQL Execute: ORACLE - Commit 185 10:43:41 SQL Data In: ORACLE - Rows affected = 0 186 10:43:41 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 187 10:43:41 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 188 10:43:41 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 189 10:43:41 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 190 10:43:41 SQL Prepare: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 191 10:43:41 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 192 10:43:41 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' 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','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 193 10:43:41 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' 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','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 194 10:43:43 SQL Prepare: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 195 10:43:43 SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=23or SQBQ00+0=23) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 196 10:43:43 SQL Prepare: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '24' 197 10:43:43 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '24' 198 10:43:43 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 199 10:43:43 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 200 10:43:43 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' 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='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 201 10:43:43 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' 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='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 202 10:43:43 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 203 10:43:43 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 204 10:43:43 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 205 10:43:43 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 206 10:43:43 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4354902 207 10:43:43 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4354902 208 10:43:43 SQL Data In: ORACLE - Rows affected = 1 209 10:43:43 SQL Prepare: ORACLE - Commit 210 10:43:43 SQL Execute: ORACLE - Commit 211 10:43:43 SQL Data In: ORACLE - Rows affected = 0 212 10:43:43 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 213 10:43:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 214 10:43:43 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 215 10:43:43 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 216 10:43:43 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 217 10:43:43 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')) 218 10:43:46 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4354903,476,'wlzx-8','J',nvl('229104522',' '),'192.168.8.220#187:21779@PrjLIS_LIS.exe+检 验 管 理 系 统',24) 219 10:43:46 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4354903,476,'wlzx-8','J',nvl('229104522',' '),'192.168.8.220#187:21779@PrjLIS_LIS.exe+检 验 管 理 系 统',24) 220 10:43:46 SQL Data In: ORACLE - Rows affected = 1 221 10:43:46 SQL Prepare: ORACLE - Commit 222 10:43:46 SQL Execute: ORACLE - Commit 223 10:43:46 SQL Data In: ORACLE - Rows affected = 0 224 10:43:46 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 24 225 10:43:46 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 24 226 10:43:46 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 227 10:43:46 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 228 10:43:46 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 229 10:43:46 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 230 10:43:46 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220' 231 10:43:46 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.220' 232 10:43:46 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 233 10:43:46 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 234 10:43:46 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 24 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 235 10:43:46 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 24 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 236 10:43:46 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20141105' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',24,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 237 10:43:46 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20141105' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',24,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 238 10:43:46 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 239 10:43:46 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 240 10:43:46 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 241 10:43:46 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 242 10:43:46 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 476 243 10:43:46 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 476 244 10:43:47 SQL Prepare: ORACLE - select BBMC00,BBID00 from BM_BBZD00 245 10:43:47 SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00 246 10:43:47 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 247 10:43:47 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' 248 10:43:47 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 249 10:43:47 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=nvl('476','0') and BMBH00=12345 and DLXTMC='检验结果查询' and CTMC00='FormQuery' 250 10:43:47 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 251 10:43:47 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 252 10:43:47 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 253 10:43:47 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_SFCKDGDBZ') 254 10:43:47 SQL Prepare: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 255 10:43:47 SQL Execute: ORACLE - Select value0 From XT_XTCS00 where name00 in ('JY_JGCXSJFW') 256 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 257 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_SKQDZTSZ' and rownum=1 258 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 259 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JGCXBRXXKD' and rownum=1 260 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 261 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXFJYKSFCXQY' and rownum=1 262 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 263 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFCXGBRSYJYD' and rownum=1 264 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 265 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_HZBRJYJG' and rownum=1 266 10:43:47 SQL Prepare: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 267 10:43:47 SQL Execute: ORACLE - select value0 from XT_XTCS00 where trim(name00)='JY_JYJGCXSFJXJS' and rownum=1 268 10:43:47 SQL Prepare: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='24' 269 10:43:47 SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='24' 270 10:43:47 SQL Prepare: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 271 10:43:47 SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT' 272 10:43:47 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='24' 273 10:43:47 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='24' 274 10:43:47 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='24' 275 10:43:47 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='24' 276 10:43:47 SQL Prepare: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='24' 277 10:43:47 SQL Execute: ORACLE - select 1 from VW_JY_BQKS00 where bmbh00='24' 278 10:43:47 SQL Prepare: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='24' 279 10:43:47 SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='24' 280 10:43:47 SQL Prepare: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='24' 281 10:43:47 SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='24' 282 10:43:47 SQL Prepare: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( A.SQKS00+0 = '24' or A.SQBQ00+0 = '24') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '24' or DQKS00='24')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 283 10:43:47 SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( A.SQKS00+0 = '24' or A.SQBQ00+0 = '24') ) union select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') and A.PYRQ00 between '20141105' and '20141105' and ( ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE zyid00=A.ZYGHID and (DQBQ00 = '24' or DQKS00='24')))) ) t1 ) order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc 284 10:43:48 SQL Prepare: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AD' 285 10:43:48 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AD' 286 10:43:48 SQL Prepare: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='AD0026' and pyrq00='20141105' and rownum=1 287 10:43:48 SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from vw_jy_yw0000 a WHERE ybh000='AD0026' and pyrq00='20141105' and rownum=1 288 10:43:48 SQL Prepare: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AD0026' and PYRQ00 = '20141105' 289 10:43:48 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AD0026' and PYRQ00 = '20141105' 290 10:43:48 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16851) 291 10:43:48 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,16851) 292 10:43:48 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AD0026' and pyrq00='20141105' ORDER BY DYSX00 293 10:43:48 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AD0026' and pyrq00='20141105' ORDER BY DYSX00 294 10:43:50 SQL Prepare: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=24or SQBQ00+0=24) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 295 10:43:50 SQL Execute: ORACLE - select count(*) from JY_YW0000 where (SQKS00+0=24or SQBQ00+0=24) and JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 296 10:44:51 SQL Prepare: ORACLE - SELECT YGBH00 FROM BM_YGBM00 WHERE UPPER(XKH000)='9998' 297 10:44:51 SQL Execute: ORACLE - SELECT YGBH00 FROM BM_YGBM00 WHERE UPPER(XKH000)='9998' 298 10:44:51 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 299 10:44:51 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 300 10:44:51 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 301 10:44:51 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 302 10:44:51 SQL Prepare: ORACLE - select distinct BRXM00,CH0000,YBH000,PYRQ00 from jy_yw0000 where (SQKS00='24' or SQBQ00='24') AND JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 303 10:44:51 SQL Execute: ORACLE - select distinct BRXM00,CH0000,YBH000,PYRQ00 from jy_yw0000 where (SQKS00='24' or SQBQ00='24') AND JGZT00 in ('6','8') and YXBZ00='Y' and BGCKR0 is null and pyrq00>=to_char(sysdate-30,'yyyymmdd') 304 10:44:51 SQL Prepare: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0292' and pyrq00='20141016' ORDER BY DYSX00 305 10:44:51 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='LX0292' and pyrq00='20141016' ORDER BY DYSX00