1 10:58:17 SQL Prepare: ORACLE - select yyqc00 from xt_yyxx00 2 10:58:17 SQL Execute: ORACLE - select yyqc00 from xt_yyxx00 3 10:58:17 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 4 10:58:17 SQL Prepare: ORACLE - 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.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1 5 10:58:17 SQL Execute: ORACLE - 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.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1 6 10:58:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 10:58:17 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 8 10:58:17 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL' 9 10:58:17 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL' 10 10:58:17 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') 11 10:58:17 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') 12 10:58:17 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ' 13 10:58:17 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ' 14 10:58:17 SQL Prepare: ORACLE - select 1 from dual where 163 in (61,476,186,550) 15 10:58:17 SQL Execute: ORACLE - select 1 from dual where 163 in (61,476,186,550) 16 10:58:17 SQL Prepare: ORACLE - select 1 from dual where 163 in (186,476) 17 10:58:17 SQL Execute: ORACLE - select 1 from dual where 163 in (186,476) 18 10:58:17 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD' 19 10:58:17 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD' 20 10:58:17 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 21 10:58:17 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 22 10:58:17 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 23 10:58:17 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 24 10:58:17 SQL Prepare: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' 25 10:58:17 SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' 26 10:58:17 SQL Prepare: ORACLE - select count(*) from xt_zldczl where rownum=1 27 10:58:17 SQL Execute: ORACLE - select count(*) from xt_zldczl where rownum=1 28 10:58:22 SQL Prepare: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1 29 10:58:22 SQL Execute: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1 30 10:58:22 SQL Prepare: ORACLE - select * from BQ_YPYZMX where YZID00=:1 31 10:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 10:58:22 SQL Execute: ORACLE - select * from BQ_YPYZMX where YZID00=? 33 10:58:22 SQL Prepare: ORACLE - select * from BQ_YPYZMX where YZMXID=:1 34 10:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 98.000000 35 10:58:22 SQL Execute: ORACLE - select * from BQ_YPYZMX where YZMXID=? 36 10:58:22 SQL Prepare: ORACLE - 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 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and ( (xmzt00 in ('3','4')) or ( xmzt00='2' and B.ZXSL00>0)) and b.mzzybz='0' 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 brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 37 10:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 163.000000 38 10:58:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 163.000000 39 10:58:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 163.000000 40 10:58:22 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,163, 41 10:58:22 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110722 42 10:58:22 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110722 43 10:58:22 SQL Execute: ORACLE - 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 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and ( (xmzt00 in ('3','4')) or ( xmzt00='2' and B.ZXSL00>0)) and b.mzzybz='0' 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 brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 44 10:58:22 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 45 10:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23168000.000000 46 10:58:22 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 47 10:58:22 SQL Prepare: ORACLE - select f.*,f.PCMC00,f.ypyfmc from yf_mzcfmx f where f.cflsh0 in (9638803) 48 10:58:22 SQL Execute: ORACLE - select f.*,f.PCMC00,f.ypyfmc from yf_mzcfmx f where f.cflsh0 in (9638803)