1 07:38:01 Log started for: 住院收费管理系统 2 07:38:01 SQL Prepare: ORACLE - Select SYSDATE from Dual 3 07:38:01 SQL Execute: ORACLE - Select SYSDATE from Dual 4 07:38:01 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 5 07:38:01 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 6 07:38:01 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 7 07:38:01 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 8 07:38:01 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 9 07:38:01 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 10 07:38:01 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 11 07:38:01 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 12 07:38:01 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 13 07:38:01 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 14 07:38:10 Log started for: 住院收费管理系统 15 07:38:10 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','5',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 16 07:38:10 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','5',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 17 07:38:10 SQL Prepare: ORACLE - Commit 18 07:38:10 SQL Execute: ORACLE - Commit 19 07:38:10 SQL Prepare: ORACLE - Select SYSDATE from Dual 20 07:38:10 SQL Execute: ORACLE - Select SYSDATE from Dual 21 07:38:10 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 07:38:10 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 23 07:38:10 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 24 07:38:10 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 25 07:38:10 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 07:38:10 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 07:38:10 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 28 07:38:10 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 29 07:38:10 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 30 07:38:10 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 31 07:38:11 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('4') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 32 07:38:11 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('4') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 33 07:38:13 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 34 07:38:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 35 07:38:13 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 36 07:38:13 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 37 07:38:13 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 07:38:13 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 39 07:38:13 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 40 07:38:13 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 41 07:38:13 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 42 07:38:13 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 43 07:38:13 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 44 07:38:13 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 45 07:38:13 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1780039,476,'wlzx-2','5',nvl('3110270',' '),'',43) 46 07:38:13 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1780039,476,'wlzx-2','5',nvl('3110270',' '),'',43) 47 07:38:13 SQL Prepare: ORACLE - Commit 48 07:38:13 SQL Execute: ORACLE - Commit 49 07:38:13 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 50 07:38:13 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 51 07:38:13 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 52 07:38:13 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 53 07:38:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 54 07:38:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 55 07:38:13 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 56 07:38:13 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 57 07:38:13 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20090618' 58 07:38:13 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20090618' 59 07:38:13 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 60 07:38:13 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 61 07:47:35 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 62 07:47:35 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 63 07:47:35 SQL Prepare: ORACLE - select sysdate nowtime from dual 64 07:47:35 SQL Execute: ORACLE - select sysdate nowtime from dual 65 07:47:35 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 66 07:47:35 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 67 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJHSC0' 68 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJHSC0' 69 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_MRNZYH' 70 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_MRNZYH' 71 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_DYYBFP' 72 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_DYYBFP' 73 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00 ' 74 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00 ' 75 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHTYJE' 76 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHTYJE' 77 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHBJJE' 78 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHBJJE' 79 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBJSTKD' 80 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBJSTKD' 81 07:47:35 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_SFYJS0_BZ0000' 82 07:47:35 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_SFYJS0_BZ0000' 83 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_WJZBNCY' 84 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_WJZBNCY' 85 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PRINTSCALE' 86 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PRINTSCALE' 87 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTDBQX' 88 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTDBQX' 89 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTQFQX' 90 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTQFQX' 91 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_QXCYQX' 92 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_QXCYQX' 93 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TKPAR0_CZY000' 94 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TKPAR0_CZY000' 95 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJZF0_CZY000' 96 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJZF0_CZY000' 97 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 98 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 99 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFXSSPM' 100 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFXSSPM' 101 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBSFCF' 102 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBSFCF' 103 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFLS' 104 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFLS' 105 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFHS' 106 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFHS' 107 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFABRFYDY' 108 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFABRFYDY' 109 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJCJD_WIDTHHEIGH' 110 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJCJD_WIDTHHEIGH' 111 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_RQDSFBSFYBXM' 112 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_RQDSFBSFYBXM' 113 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_YFSBGSJZSFJK' 114 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_YFSBGSJZSFJK' 115 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 116 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 117 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYFPSFXSFYBF' 118 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYFPSFXSFYBF' 119 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFBXLRNL' 120 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFBXLRNL' 121 07:47:35 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 122 07:47:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 123 07:47:35 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 124 07:47:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 125 07:47:35 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 126 07:47:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 127 07:47:35 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXSFCDLYJXM' 128 07:47:35 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXSFCDLYJXM' 129 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGS00' 130 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGS00' 131 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 132 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 133 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 134 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 135 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 136 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 137 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YTFSFYXCY' 138 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YTFSFYXCY' 139 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 140 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 141 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZY_SFZDXS' 142 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZY_SFZDXS' 143 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJKSSJ' 144 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJKSSJ' 145 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJJSSJ' 146 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJJSSJ' 147 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 148 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 149 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPWidth' 150 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPWidth' 151 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPHeigh' 152 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPHeigh' 153 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYSFJJBSJ' 154 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYSFJJBSJ' 155 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_SYDJKYDBQF' 156 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_SYDJKYDBQF' 157 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 158 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 159 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_QDXXZHYE' 160 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_QDXXZHYE' 161 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKDSFTD' 162 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKDSFTD' 163 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKSFAJJBSJ' 164 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKSFAJJBSJ' 165 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYJKDGS0' 166 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYJKDGS0' 167 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJDJGS' 168 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJDJGS' 169 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBRQDFS' 170 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBRQDFS' 171 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 172 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 173 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFFZ' 174 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFFZ' 175 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 176 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 177 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 178 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 179 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 180 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 181 07:47:35 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 182 07:47:35 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 183 07:47:35 SQL Prepare: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 184 07:47:35 SQL Execute: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 185 07:47:35 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_FPTOP' 186 07:47:35 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_FPTOP' 187 07:47:35 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_SFQZGSYB' 188 07:47:35 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_SFQZGSYB' 189 07:47:35 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_YJJDYE' 190 07:47:35 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_YJJDYE' 191 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 192 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 193 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDFPXMSFDY' 194 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDFPXMSFDY' 195 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BRCYSFDYBASY' 196 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BRCYSFDYBASY' 197 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_LeftPage' 198 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_LeftPage' 199 07:47:35 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_TopPage' 200 07:47:35 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_TopPage' 201 07:47:35 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='ZY_CRYTJSFAKS' 202 07:47:35 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='ZY_CRYTJSFAKS' 203 07:47:35 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='ZY_HZQDDYSFXSYBFY' 204 07:47:35 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='ZY_HZQDDYSFXSYBFY' 205 07:47:35 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS') 206 07:47:35 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS') 207 07:47:35 SQL Prepare: ORACLE - select upper(value0) from XT_XTCS00 where NAME00 = 'ZY_RQDGSCS' 208 07:47:35 SQL Execute: ORACLE - select upper(value0) from XT_XTCS00 where NAME00 = 'ZY_RQDGSCS' 209 07:47:35 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFSYPANHJK','ZY_KP_QKPYHFS','ZY_JKDJXJYJSFXS','ZY_YLFYMXTJHS','ZY_YLFYMXTJLS','ZY_YLFYMXZ_SFCF', 'ZY_QDSFXSJMJE','ZY_SFSXYJJE','MZ_ZY_YJJPJ_IDColor','ZY_YJJSFSKHYH','ZY_YBRYSFSYDT','ZY_XNHBRSFCSICKH','ZY_NHBRSFCSJBZD','ZY_CYBRFYYSZD','ZY_JSXSGS') 210 07:47:35 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFSYPANHJK','ZY_KP_QKPYHFS','ZY_JKDJXJYJSFXS','ZY_YLFYMXTJHS','ZY_YLFYMXTJLS','ZY_YLFYMXZ_SFCF', 'ZY_QDSFXSJMJE','ZY_SFSXYJJE','MZ_ZY_YJJPJ_IDColor','ZY_YJJSFSKHYH','ZY_YBRYSFSYDT','ZY_XNHBRSFCSICKH','ZY_NHBRSFCSJBZD','ZY_CYBRFYYSZD','ZY_JSXSGS') 211 07:47:36 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='9998' 212 07:47:36 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='9998' 213 07:47:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 214 07:47:41 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 215 07:47:41 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 216 07:47:41 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 217 07:47:41 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 218 07:47:41 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 219 07:47:41 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 220 07:47:41 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 221 07:47:41 SQL Prepare: 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)))) 222 07:47:41 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)))) 223 07:47:41 SQL Prepare: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 224 07:47:41 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 225 07:47:41 SQL Prepare: ORACLE - Commit 226 07:47:41 SQL Execute: ORACLE - Commit 227 07:47:45 SQL Prepare: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00='9' and CZBZ00 <> '2' order by bh0000 228 07:47:45 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00='9' and CZBZ00 <> '2' order by bh0000 229 07:47:45 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where rownum=1 230 07:47:45 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where rownum=1 231 07:48:18 SQL Prepare: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 232 07:48:18 SQL Execute: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 233 07:49:01 SQL Prepare: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 234 07:49:01 SQL Execute: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 235 07:49:03 SQL Prepare: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 236 07:49:03 SQL Execute: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 237 07:49:03 SQL Prepare: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 238 07:49:03 SQL Execute: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 239 07:49:11 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= :1 order by beizhu,beizh1 240 07:49:11 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= ? order by beizhu,beizh1 241 07:49:12 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= :1 order by beizhu,beizh1 242 07:49:12 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= ? order by beizhu,beizh1 243 07:49:12 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= :1 order by beizhu,beizh1 244 07:49:12 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= ? order by beizhu,beizh1 245 07:49:12 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= :1 order by beizhu,beizh1 246 07:49:12 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= ? order by beizhu,beizh1 247 07:49:12 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= :1 order by beizhu,beizh1 248 07:49:12 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524702) and ghks04= ? order by beizhu,beizh1 249 07:49:23 SQL Prepare: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 250 07:49:23 SQL Execute: ORACLE - select B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?) ) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 251 07:49:38 SQL Prepare: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 252 07:49:38 SQL Execute: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 253 07:49:38 SQL Prepare: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 254 07:49:38 SQL Execute: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 255 07:49:39 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= :1 order by beizhu,beizh1 256 07:49:39 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= ? order by beizhu,beizh1 257 07:49:39 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= :1 order by beizhu,beizh1 258 07:49:39 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= ? order by beizhu,beizh1 259 07:49:39 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= :1 order by beizhu,beizh1 260 07:49:39 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= ? order by beizhu,beizh1 261 07:49:39 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= :1 order by beizhu,beizh1 262 07:49:39 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= ? order by beizhu,beizh1 263 07:49:40 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= :1 order by beizhu,beizh1 264 07:49:40 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524703) and ghks04= ? order by beizhu,beizh1 265 07:49:56 SQL Prepare: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=:1 and G.JFRQ00||G.JFSJ00<=(:2)||(:3)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=:4 and F.CZRQ00||F.CZSJ00<=(:5)||(:6)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=:7 AND B.RYRQ00||B.RYSJ00<=(:8)||(:9)) or (B.CYRQ00> :10 and B.CYRQ00||B.CYSJ00> (:11)||(:12))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 266 07:49:56 SQL Execute: ORACLE - select B.ZYID00,B.DQBQ00,C.BMMC00 DQBQMC,B.ZYH000,B.YBZYH0,B.MRN000,B.RYCWH0,B.XM0000 BRXM00,JFLBID,A.BRID00,D.FBMC00,'20090618_23:59:59' RCYRQ0, (select NVL(sum(JFJE00),0) from zy_brjfb0 G,ZY_PJSYQK H where G.brid00 =A.BRID00 AND G.PJH000=H.PJH000 and JFLBID = 2 and h.plbh00 in (4,8) and G.JFRQ00<=? and G.JFRQ00||G.JFSJ00<=(?)||(?)) YJZJE0, (select NVL(sum(F.HJJE00),0) from zy_brfy00 E,ZY_FYMX00 F WHERE B.ZYID00=E.ZYID00 AND E.DJH000=F.DJH000 and F.CZRQ00<=? and F.CZRQ00||F.CZSJ00<=(?)||(?)) ZJE000 from ZY_BRZHXX A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BRFBB0 D where A.BRID00 = B.BRID00 and A.JFLBID = 2 and B.DQBQ00 = C.BMBH00 AND B.FBBH00=D.FBBH00 and ((B.CYRQ00 IS NULL and B.RYRQ00<=? AND B.RYRQ00||B.RYSJ00<=(?)||(?)) or (B.CYRQ00> ? and B.CYRQ00||B.CYSJ00> (?)||(?))) AND B.ZYH000='151214' and C.BMMC00='五病区' order by C.BMBH00,B.zyh000 267 07:49:56 SQL Prepare: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 268 07:49:56 SQL Execute: ORACLE - BEGIN "SP_ZY_YSYLKMXZ" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 269 07:49:57 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= :1 order by beizhu,beizh1 270 07:49:57 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= ? order by beizhu,beizh1 271 07:49:57 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= :1 order by beizhu,beizh1 272 07:49:57 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= ? order by beizhu,beizh1 273 07:49:57 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= :1 order by beizhu,beizh1 274 07:49:57 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= ? order by beizhu,beizh1 275 07:49:57 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= :1 order by beizhu,beizh1 276 07:49:57 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= ? order by beizhu,beizh1 277 07:49:57 SQL Prepare: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= :1 order by beizhu,beizh1 278 07:49:57 SQL Execute: ORACLE - select beizhu pxbh00 ,beizh1 jfrq00,beizh2 pjxh00,beizh3 czyxm0,ghks01 jfje00,ghks02 dfje00,ghks03 ye0000 from bm_ghkstj where id0000 in (524704) and ghks04= ? order by beizhu,beizh1