1 16:49:13 Log started for: 住院收费管理系统 2 16:49:23 Log started for: Yjsystem 3 16:49:23 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','519','3844' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:DA0EAE149D09996EA79567577DAFEB94' from dual 4 16:49:23 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','519','3844' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:DA0EAE149D09996EA79567577DAFEB94' from dual 5 16:49:23 SQL Data In: ORACLE - Rows affected = 1 6 16:49:23 SQL Prepare: ORACLE - Commit 7 16:49:23 SQL Execute: ORACLE - Commit 8 16:49:23 SQL Data In: ORACLE - Rows affected = 0 9 16:49:23 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 16:49:23 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 16:49:23 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007' 12 16:49:23 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007' 13 16:49:23 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 14 16:49:23 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 15 16:49:23 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 16:49:23 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 16:49:23 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','485','17685' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:DD9797F585FCF4FEE26856997F87E032' from dual 18 16:49:23 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','485','17685' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:DD9797F585FCF4FEE26856997F87E032' from dual 19 16:49:23 SQL Data In: ORACLE - Rows affected = 1 20 16:49:23 SQL Prepare: ORACLE - Commit 21 16:49:23 SQL Execute: ORACLE - Commit 22 16:49:23 SQL Data In: ORACLE - Rows affected = 0 23 16:49:23 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 24 16:49:23 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 25 16:49:23 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 26 16:49:23 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 27 16:49:23 SQL Prepare: ORACLE - Select SYSDATE from Dual 28 16:49:23 SQL Execute: ORACLE - Select SYSDATE from Dual 29 16:49:23 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 16:49:23 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 16:49:23 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 16:49:23 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 16:49:23 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 34 16:49:23 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 35 16:49:23 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 16:49:23 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 16:49:23 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 38 16:49:23 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 39 16:49:23 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1','5','9','a','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) order by b.PLXH00,a.BH0000 40 16:49:23 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1','5','9','a','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) order by b.PLXH00,a.BH0000 41 17:01:18 Log started for: 住院收费管理系统 42 17:05:11 Log started for: Yjsystem 43 17:05:11 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','518','1680' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:DA0EAE149D09996EA79567577DAFEB94' from dual 44 17:05:11 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','518','1680' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@hjh:DA0EAE149D09996EA79567577DAFEB94' from dual 45 17:05:11 SQL Data In: ORACLE - Rows affected = 1 46 17:05:11 SQL Prepare: ORACLE - Commit 47 17:05:11 SQL Execute: ORACLE - Commit 48 17:05:11 SQL Data In: ORACLE - Rows affected = 0 49 17:05:11 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 50 17:05:11 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 51 17:05:11 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007' 52 17:05:11 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='220007' 53 17:05:11 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 54 17:05:11 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 55 17:05:11 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 56 17:05:11 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 57 17:05:11 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','501','3237' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:DD9797F585FCF4FEE26856997F87E032' from dual 58 17:05:11 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.7.10.112','7','YJsystem.exe'||'+'||'医技管理系统','501','3237' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@hjh:DD9797F585FCF4FEE26856997F87E032' from dual 59 17:05:11 SQL Data In: ORACLE - Rows affected = 1 60 17:05:11 SQL Prepare: ORACLE - Commit 61 17:05:11 SQL Execute: ORACLE - Commit 62 17:05:11 SQL Data In: ORACLE - Rows affected = 0 63 17:05:11 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 64 17:05:11 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 65 17:05:11 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 66 17:05:11 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HJH' and CZBZ00 in ('1') 67 17:05:11 SQL Prepare: ORACLE - Select SYSDATE from Dual 68 17:05:11 SQL Execute: ORACLE - Select SYSDATE from Dual 69 17:05:11 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 70 17:05:11 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 71 17:05:11 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 72 17:05:11 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 73 17:05:11 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 74 17:05:11 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 75 17:05:11 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 76 17:05:11 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 77 17:05:11 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 78 17:05:11 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 79 17:05:11 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1','5','9','a','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) order by b.PLXH00,a.BH0000 80 17:05:11 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1','5','9','a','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) order by b.PLXH00,a.BH0000 81 17:05:21 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'hjh'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH') 82 17:05:21 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'hjh'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='HJH') 83 17:05:21 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1372 84 17:05:21 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1372 85 17:05:21 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 86 17:05:21 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 87 17:05:21 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 88 17:05:21 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 89 17:05:21 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 90 17:05:21 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 91 17:05:21 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 92 17:05:21 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 93 17:05: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')) 94 17:05: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')) 95 17:05:23 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(7470515,1372,'PC-20120208YHGY','7',nvl('60186152',' '),'10.7.10.112#501:3237@YJsystem.exe+医技管理系统',94) 96 17:05:23 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(7470515,1372,'PC-20120208YHGY','7',nvl('60186152',' '),'10.7.10.112#501:3237@YJsystem.exe+医技管理系统',94) 97 17:05:24 SQL Data In: ORACLE - Rows affected = 1 98 17:05:24 SQL Prepare: ORACLE - Commit 99 17:05:24 SQL Execute: ORACLE - Commit 100 17:05:24 SQL Data In: ORACLE - Rows affected = 0 101 17:05:24 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 94 102 17:05:24 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 94 103 17:05:24 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= 'A' 104 17:05:24 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= 'A' 105 17:05:24 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 106 17:05:24 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 107 17:05:24 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.7.10.112' 108 17:05:24 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.7.10.112' 109 17:05:24 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 110 17:05:24 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 111 17:05:24 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 94 and FLAG00 like '%' order by decode(CKBH00,1284,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 112 17:05:24 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 94 and FLAG00 like '%' order by decode(CKBH00,1284,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 113 17:05:24 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('A') 114 17:05:24 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('A') 115 17:05:24 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where (a.YYID00='A' or trim(a.YYID00)='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 ) 116 17:05:24 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (a.YYID00='A' or trim(a.YYID00)='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'7'||',')>0 ) 117 17:05:24 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1372' and name00='SYSTEMSKIN' 118 17:05:24 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1372' and name00='SYSTEMSKIN' 119 17:05:24 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 120 17:05:24 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 121 17:05:24 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20151222' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',94,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='7') 122 17:05:24 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20151222' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',94,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='7') 123 17:05:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 124 17:05:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 125 17:05:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 126 17:05:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 127 17:05:25 SQL Prepare: ORACLE - select sysdate from dual 128 17:05:25 SQL Execute: ORACLE - select sysdate from dual 129 17:05:25 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='7'))) 130 17:05:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='7' and (( 1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='7'))) 131 17:05:25 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 132 17:05:25 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 133 17:05:25 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='0 '))) 134 17:05: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 ((1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='0 '))) 135 17:05:25 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 136 17:05:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 137 17:05:25 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='+ '))) 138 17:05:25 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1372= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1372 and XTDM00='+ '))) 139 17:05:25 SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 140 17:05:25 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 141 17:05:25 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet','BQ_ZXDPrinterM') and YGBH00 = 1372 142 17:05:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY','YJ_BBCYHZDPrintSet','BQ_ZXDPrinterM') and YGBH00 = 1372 143 17:05:25 SQL Prepare: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','YJ_XSKDYGS_NEW','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY','YJ_ZXDSFZDYYSFXM','YS_FYJKURL') 144 17:05:25 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YF_YYGXH','YJ_YXCXTS','YJ_YXCXTS2','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_SYKSFZDDY','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YF_MZCFTDHS','YJ_XMZJYSWSSKS','YJ_XSKDYGS','YJ_XSKDYGS_NEW','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','YJ_SYHDSFDY','YJ_ZJLZDYDY','YJ_XMWHCKSFKYZXXM','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY','YJ_XMAPSFAKSCX','YJ_XMAPDYZDYID','YJ_XMSQKSYSSFMRWK','YJ_SYGCDZDYDY','YJ_CFFWFXWHXZ','YJ_TXMDYSFFY','YJ_YJCXD_ZDY','XT_ZYXTGBDW','YF_MZCFSFDYXXYF','YF_CFSFDYTYM','YF_CFTDGSSFZJZD','YF_MZCFJYDJGHS','YF_MZCFSFDYYS','YF_MZCFTDDDHS','YF_CFTDSFDYFB','YF_ZYJYF_SFDM','YF_SFDYCFT','YJ_SFQYMZYDSY','YJ_ZXDSFZDYYSFXM','YS_FYJKURL') 145 17:05:25 SQL Prepare: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 146 17:05:25 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 147 17:05:25 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=1372 and name00='YJ_QSBRLB' 148 17:05:25 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=1372 and name00='YJ_QSBRLB' 149 17:05:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 150 17:05:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 151 17:05:28 SQL Prepare: ORACLE - select yyqc00 from xt_yyxx00 152 17:05:28 SQL Execute: ORACLE - select yyqc00 from xt_yyxx00 153 17:05:28 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=:1 154 17:05:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 155 17:05:28 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 156 17:05:28 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL' 157 17:05:28 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL' 158 17:05:28 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y') 159 17:05:28 SQL Execute: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y') 160 17:05:28 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ' 161 17:05:28 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ' 162 17:05:28 SQL Prepare: ORACLE - select 1 from dual where 94 in (61,476,186,550) 163 17:05:28 SQL Execute: ORACLE - select 1 from dual where 94 in (61,476,186,550) 164 17:05:28 SQL Prepare: ORACLE - select 1 from dual where 94 in (186,476) 165 17:05:28 SQL Execute: ORACLE - select 1 from dual where 94 in (186,476) 166 17:05:28 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD' 167 17:05:28 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD' 168 17:05:28 SQL Prepare: ORACLE - select bmbh00,bmmc00,YYID00,PXXH00 from bm_bmbm00 where bmxz00='9' and flag00='1' and czbz00<>'2' order by decode(trim(YYID00),'A','0',trim(YYID00)),PXXH00 169 17:05:28 SQL Execute: ORACLE - select bmbh00,bmmc00,YYID00,PXXH00 from bm_bmbm00 where bmxz00='9' and flag00='1' and czbz00<>'2' order by decode(trim(YYID00),'A','0',trim(YYID00)),PXXH00 170 17:05:28 SQL Prepare: ORACLE - select count(*) from xt_zldczl where rownum=1 171 17:05:28 SQL Execute: ORACLE - select count(*) from xt_zldczl where rownum=1 172 17:05:28 SQL Prepare: ORACLE - select * from YJ_YYZLZD a where KSBH00 =94 order by XMWHID 173 17:05:28 SQL Execute: ORACLE - select * from YJ_YYZLZD a where KSBH00 =94 order by XMWHID 174 17:05:28 SQL Prepare: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=20 and XMZT00 in('0','1','2') and (YJKSBH=:1 or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:3) )) and ( (',550,186,'=',0,') or (instr(',550,186,',:4 )>0) ) ) ) and kdrq00 between :5 and :6 order by kdrq00,KDSJ00,brid00) g 175 17:05:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 176 17:05:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 177 17:05:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 178 17:05:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,94, 179 17:05:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151220 180 17:05:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20151222 17:00:00 181 17:05:28 SQL Execute: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=20 and XMZT00 in('0','1','2') and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',550,186,'=',0,') or (instr(',550,186,',? )>0) ) ) ) and kdrq00 between ? and ? order by kdrq00,KDSJ00,brid00) g 182 17:05:28 SQL Error: ORACLE - ORA-00918: 未明确定义列 183 17:05:28 SQL Error: ORACLE - Unmapped SQL Error Code: 918 184 17:05:28 SQL Data In: ORACLE - Rows affected = 0 185 17:05:29 SQL Prepare: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=21 and XMZT00 in('0','1','2') and (YJKSBH=:1 or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:3) )) and ( (',550,186,'=',0,') or (instr(',550,186,',:4 )>0) ) ) ) and kdrq00 between :5 and :6 order by kdrq00,KDSJ00,brid00) g 186 17:05:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 187 17:05:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 188 17:05:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 189 17:05:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,94, 190 17:05:29 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151220 191 17:05:29 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20151222 17:00:00 192 17:05:29 SQL Execute: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=21 and XMZT00 in('0','1','2') and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',550,186,'=',0,') or (instr(',550,186,',? )>0) ) ) ) and kdrq00 between ? and ? order by kdrq00,KDSJ00,brid00) g 193 17:05:29 SQL Error: ORACLE - ORA-00918: 未明确定义列 194 17:05:29 SQL Error: ORACLE - Unmapped SQL Error Code: 918 195 17:05:29 SQL Data In: ORACLE - Rows affected = 0 196 17:05:29 SQL Prepare: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=20 and XMZT00 in('0','1','2') and (YJKSBH=:1 or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:2)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:3) )) and ( (',550,186,'=',0,') or (instr(',550,186,',:4 )>0) ) ) ) and kdrq00 between :5 and :6 order by kdrq00,KDSJ00,brid00) g 197 17:05:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 198 17:05:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 199 17:05:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 94.000000 200 17:05:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,94, 201 17:05:29 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20151220 202 17:05:29 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20151222 17:00:00 203 17:05:29 SQL Execute: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC,(select BMMC00 from BM_BMBM00 where BMBH00=b.KDBQ00) KDBQMC ,b.SQID00,b.YYBZ00,HBDJH0,nvl(c.JCLBID,0) JCLBID,nvl(c.JCZID0,0) JCZID0,nvl(HBXHID,0) HBXHID,(select YYH000 from YJ_YYBRB0 where YYID00=b.YYID00 and YYZT00<>'2') YYXH00, (select JCLBMC from BM_JCLB00 where JCLBID=c.JCLBID) JCLBMC,nvl((select YYRQ00 from YJ_YYBRB0 where YYID00=b.YYID00),(select YYRQ00 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0)) YYRQ00, (select YYXMMC from YJ_YYZLZD where XMWHID=c.JCZID0 and rownum=1) JCZMC0,nvl(YYID00,0) YYID00, (select XH0000 from YJ_JCHBXH where HBXHID=b.HBXHID and HBXHID>0) SH0000, decode(YYZT00,'0','已预约','1','已检查','2','取消','-1','') YYZT00,0 XGBZ00,' ' color0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and nvl(c.JCZID0,0)>0 and (not XMZT00 in('6') ) and SL0000>0 and not exists(select 1 from YJ_YW0000 where ZYHGHH=b.ZYHGHH and CXDJH0=b.YJDJH0) and exists(select 1 from zy_brxxb0 where zyid00=b.ZYGHID and substr(brzt00,1,1)='2') and (nvl(YYID00,0)=0 or YYZT00='2') and b.mzzybz='1' and nvl(c.JCZID0,0)=20 and XMZT00 in('0','1','2') and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',550,186,'=',0,') or (instr(',550,186,',? )>0) ) ) ) and kdrq00 between ? and ? order by kdrq00,KDSJ00,brid00) g 204 17:05:29 SQL Error: ORACLE - ORA-00918: 未明确定义列 205 17:05:29 SQL Error: ORACLE - Unmapped SQL Error Code: 918 206 17:05:29 SQL Data In: ORACLE - Rows affected = 0