1 15:56:49 Log started for: SQL Navigator for Oracle 2 15:58:18 Log started for: Yjsystem 3 15:58:27 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 4 15:58:27 SQL Prepare: ORACLE - select 1 from dual 5 15:58:27 SQL Execute: ORACLE - select 1 from dual 6 15:58:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 15:58:27 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 8 15:58:27 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') 9 15:58:27 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') 10 15:58:27 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 11 15:58:27 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 12 15:58:27 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 13 15:58:27 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 14 15:58:27 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 15 15:58:27 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 16 15:58:27 SQL Prepare: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' order by BMBH00 17 15:58:27 SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' order by BMBH00 18 15:58:58 SQL Prepare: ORACLE - Select SYSDATE from Dual 19 15:58:58 SQL Execute: ORACLE - Select SYSDATE from Dual 20 15:58:58 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 21 15:58:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 22 15:58:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 23 15:58:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 24 15:58:58 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 25 15:58:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 26 15:58:58 SQL Prepare: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=137182 27 15:58:58 SQL Execute: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=137182 28 15:58:58 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 29 15:58:58 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 30 15:58:58 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 31 15:58:58 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 15:58:58 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 33 15:58:58 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 15:58:58 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 15:58:58 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 36 15:58:58 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 15:58:58 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 15:58:58 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 15:58:58 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 40 15:58:58 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 15:58:58 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 15:58:58 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 15:58:58 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 15:58:58 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 15:58:58 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 15:58:58 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 47 15:58:59 SQL Prepare: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=:1 and (YJKSBH=:2 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=:3) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=:4)) or (KDKSBH=:5 and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between :6 and :7 order by yjdjh0 48 15:58:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 49 15:58:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 50 15:58:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 51 15:58:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 52 15:58:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 53 15:58:59 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140131 54 15:58:59 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140214 55 15:58:59 SQL Execute: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=? and (YJKSBH=? or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=?) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=?)) or (KDKSBH=? and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between ? and ? order by yjdjh0 56 15:58:59 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 57 15:58:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 58 15:58:59 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 59 15:58:59 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 60 15:58:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 61 15:58:59 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 62 15:59:04 SQL Prepare: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000=:1 63 15:59:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5525095 64 15:59:04 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000=? 65 15:59:04 SQL Prepare: ORACLE - select * from bm_brxxb0 where brid00=:1 66 15:59:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 67 15:59:04 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=? 68 15:59:04 SQL Prepare: ORACLE - select GHQXBZ from bm_ghlbb0 where LBBH00=:1 69 15:59:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 70 15:59:04 SQL Execute: ORACLE - select GHQXBZ from bm_ghlbb0 where LBBH00=? 71 15:59:04 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMSQXZZXKS' 72 15:59:04 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMSQXZZXKS' 73 15:59:05 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 74 15:59:05 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 75 15:59:05 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 76 15:59:05 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 77 15:59:05 SQL Prepare: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='5525095' 78 15:59:05 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='5525095' 79 15:59:05 SQL Prepare: ORACLE - select * from bm_brxxb0 where brid00=137182 80 15:59:05 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=137182 81 15:59:05 SQL Prepare: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=10353814 82 15:59:05 SQL Execute: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=10353814 83 15:59:05 SQL Prepare: ORACLE - select sysdate from dual 84 15:59:05 SQL Execute: ORACLE - select sysdate from dual 85 15:59:05 SQL Prepare: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 86 15:59:05 SQL Execute: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 87 15:59:05 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 88 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 89 15:59:05 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 90 15:59:05 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 91 15:59:05 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 92 15:59:05 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 93 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 94 15:59:05 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 95 15:59:05 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 96 15:59:05 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 97 15:59:05 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 98 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 99 15:59:05 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 100 15:59:05 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 101 15:59:05 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 102 15:59:05 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 103 15:59:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 104 15:59:05 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 105 15:59:05 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 106 15:59:05 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 107 15:59:05 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_MXXMSFQX' 108 15:59:05 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_MXXMSFQX' 109 15:59:12 SQL Prepare: ORACLE - Select SYSDATE from Dual 110 15:59:12 SQL Execute: ORACLE - Select SYSDATE from Dual 111 15:59:12 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 112 15:59:12 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 113 15:59:12 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 114 15:59:12 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 115 15:59:13 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 116 15:59:13 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 117 15:59:13 SQL Prepare: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=137182 118 15:59:13 SQL Execute: ORACLE - select * from bm_brxxb0 where zyzt00='1' and brid00=137182 119 15:59:13 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 120 15:59:13 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 121 15:59:13 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 122 15:59:13 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 123 15:59:13 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 124 15:59:13 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 125 15:59:13 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 126 15:59:13 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 15:59:13 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 15:59:13 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 129 15:59:13 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 130 15:59:13 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 131 15:59:13 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 132 15:59:13 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 133 15:59:13 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 15:59:13 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 135 15:59:13 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 136 15:59:13 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 137 15:59:13 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 138 15:59:13 SQL Prepare: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='5525095' 139 15:59:13 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000='5525095' 140 15:59:13 SQL Prepare: ORACLE - select * from bm_brxxb0 where brid00=137182 141 15:59:13 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=137182 142 15:59:13 SQL Prepare: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=10353814 143 15:59:13 SQL Execute: ORACLE - select GHKS00,JZYS00,JZYSXM from sf_brxxb0 where ghid00=10353814 144 15:59:13 SQL Prepare: ORACLE - select sysdate from dual 145 15:59:13 SQL Execute: ORACLE - select sysdate from dual 146 15:59:13 SQL Prepare: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 147 15:59:13 SQL Execute: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 148 15:59:13 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 149 15:59:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 150 15:59:13 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 151 15:59:13 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 152 15:59:13 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 153 15:59:13 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 154 15:59:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 155 15:59:13 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 156 15:59:13 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 157 15:59:13 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID 158 15:59:32 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 159 15:59:32 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 160 15:59:33 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmbh,SFJE00,wbsm00,zlxmid,pysm00,YBLBMC,ZFBL00,COLOUR from VW_YJ_FBFYYZ where (wbsm00 Like :1) and( ((ybbrlb='0' and ybzxlb='0' and fbbh00='1' and sfsfxm='Y') or (sfsfxm='N')) ) Order By wbsm00) where Rownum<=10 161 15:59:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = s% 162 15:59:33 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmbh,SFJE00,wbsm00,zlxmid,pysm00,YBLBMC,ZFBL00,COLOUR from VW_YJ_FBFYYZ where (wbsm00 Like ?) and( ((ybbrlb='0' and ybzxlb='0' and fbbh00='1' and sfsfxm='Y') or (sfsfxm='N')) ) Order By wbsm00) where Rownum<=10 163 15:59:39 SQL Prepare: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=19071 order by zxmbh0 164 15:59:39 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=19071 order by zxmbh0 165 16:00:00 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 166 16:00:00 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 167 16:00:00 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 168 16:00:00 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 169 16:00:00 SQL Prepare: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 170 16:00:00 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 171 16:00:00 SQL Prepare: ORACLE - Select SYSDATE from Dual 172 16:00:00 SQL Execute: ORACLE - Select SYSDATE from Dual 173 16:00:00 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 174 16:00:00 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 175 16:00:00 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 176 16:00:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 177 16:00:00 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 178 16:00:00 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 179 16:00:00 SQL Prepare: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='5525095' 180 16:00:00 SQL Execute: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='5525095' 181 16:00:00 SQL Prepare: ORACLE - select BMBH00 from vw_yj_kdks00 where bmmc00=:1 182 16:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 体检中心 183 16:00:00 SQL Execute: ORACLE - select BMBH00 from vw_yj_kdks00 where bmmc00=? 184 16:00:00 SQL Prepare: ORACLE - BEGIN "SP_YJ_XMWH" (PYJDJH0 => :PYJDJH0,PYJKSBH => :PYJKSBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PYEXM00 => :PYEXM00,PBRXM00 => :PBRXM00,PXB0000 => :PXB0000,PCSRQ00 => :PCSRQ00,PZLXMID => :PZLXMID,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PLRXM00 => :PLRXM00,PJZBZ00 => :PJZBZ00,PBWMC00 => :PBWMC00,PZDID00 => :PZDID00,PMZZYBZ => :PMZZYBZ,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PYWMXID => :PYWMXID,POPNAME => :POPNAME,PNEWDJH => :PNEWDJH,PDQBQ00 => :PDQBQ00,PCZY000 => :PCZY000,PCZKS00 => :PCZKS00,PTSBZBH => :PTSBZBH); END; 185 16:00:00 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 186 16:00:00 SQL Data In: ORACLE - Param = 2, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 187 16:00:00 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 188 16:00:00 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10353814.000000 189 16:00:00 SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 190 16:00:00 SQL Data In: ORACLE - Param = 6, Name = PBRXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 191 16:00:00 SQL Data In: ORACLE - Param = 7, Name = PXB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 192 16:00:00 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 193 16:00:00 SQL Data In: ORACLE - Param = 9, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19071.000000 194 16:00:00 SQL Data In: ORACLE - Param = 10, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 195 16:00:00 SQL Data In: ORACLE - Param = 11, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000 196 16:00:00 SQL Data In: ORACLE - Param = 12, Name = PLRXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 林于 197 16:00:00 SQL Data In: ORACLE - Param = 13, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 198 16:00:00 SQL Data In: ORACLE - Param = 14, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 199 16:00:00 SQL Data In: ORACLE - Param = 15, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 200 16:00:00 SQL Data In: ORACLE - Param = 16, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 201 16:00:00 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 202 16:00:00 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 203 16:00:00 SQL Data In: ORACLE - Param = 19, Name = PYWMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 204 16:00:00 SQL Data In: ORACLE - Param = 20, Name = POPNAME, Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 205 16:00:00 SQL Data In: ORACLE - Param = 21, Name = PNEWDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 206 16:00:00 SQL Data In: ORACLE - Param = 22, Name = PDQBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 207 16:00:00 SQL Data In: ORACLE - Param = 23, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 208 16:00:00 SQL Data In: ORACLE - Param = 24, Name = PCZKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 209 16:00:00 SQL Data In: ORACLE - Param = 25, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 210 16:00:00 SQL Execute: ORACLE - BEGIN "SP_YJ_XMWH" (PYJDJH0 => :PYJDJH0,PYJKSBH => :PYJKSBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PYEXM00 => :PYEXM00,PBRXM00 => :PBRXM00,PXB0000 => :PXB0000,PCSRQ00 => :PCSRQ00,PZLXMID => :PZLXMID,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PLRXM00 => :PLRXM00,PJZBZ00 => :PJZBZ00,PBWMC00 => :PBWMC00,PZDID00 => :PZDID00,PMZZYBZ => :PMZZYBZ,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PYWMXID => :PYWMXID,POPNAME => :POPNAME,PNEWDJH => :PNEWDJH,PDQBQ00 => :PDQBQ00,PCZY000 => :PCZY000,PCZKS00 => :PCZKS00,PTSBZBH => :PTSBZBH); END; 211 16:00:01 SQL Prepare: ORACLE - INSERT INTO YJ_YWMX00 (ID0000,YJDJH0,ZLXMID) values (SQ_YJ_YWMX00_ID0000.NEXTVAL,:1,:2) 212 16:00:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14481638.000000 213 16:00:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19071.000000 214 16:00:01 SQL Execute: ORACLE - INSERT INTO YJ_YWMX00 (ID0000,YJDJH0,ZLXMID) values (SQ_YJ_YWMX00_ID0000.NEXTVAL,?,?) 215 16:00:01 SQL Data In: ORACLE - Rows affected = 1 216 16:00:01 SQL Prepare: ORACLE - Commit 217 16:00:01 SQL Execute: ORACLE - Commit 218 16:00:01 SQL Data In: ORACLE - Rows affected = 0 219 16:00:01 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00); END; 220 16:00:01 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14481638.000000 221 16:00:01 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 222 16:00:01 SQL Execute: ORACLE - BEGIN "SP_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00); END; 223 16:00:37 SQL Prepare: ORACLE - select sysdate from dual 224 16:00:37 SQL Execute: ORACLE - select sysdate from dual 225 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 226 16:00:37 SQL Execute: ORACLE - Select yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,lrxm00,kdsj00,zje000, xb0000,sl0000,csrq00,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,brid00,mzzybz from vw_yj_yw0000_wzx b where xmzt00 in('0','1') and brid00=137182 and (YJKSBH=33 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=33) and kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=33)) or KDKSBH=33) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null)) and kdrq00='20140214' order by YJdjh0 227 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 228 16:00:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 229 16:00:37 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 230 16:00:37 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 231 16:00:37 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 232 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 233 16:00:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 234 16:00:37 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 235 16:00:37 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 236 16:00:37 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 237 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 238 16:00:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 239 16:00:37 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 240 16:00:37 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 241 16:00:37 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 242 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 243 16:00:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 244 16:00:37 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 245 16:00:37 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 246 16:00:37 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 247 16:00:37 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 248 16:00:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 249 16:00:37 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 250 16:00:37 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 251 16:00:37 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 252 16:00:39 SQL Prepare: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=:1 and (YJKSBH=:2 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=:3) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=:4)) or (KDKSBH=:5 and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between :6 and :7 order by yjdjh0 253 16:00:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 137182.000000 254 16:00:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 255 16:00:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 256 16:00:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 257 16:00:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 258 16:00:39 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140131 259 16:00:39 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140214 260 16:00:39 SQL Execute: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=? and (YJKSBH=? or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=?) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=?)) or (KDKSBH=? and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between ? and ? order by yjdjh0 261 16:00:40 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 262 16:00:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 263 16:00:40 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 264 16:00:40 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 265 16:00:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14481638.000000 266 16:00:40 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 267 16:00:40 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 268 16:00:40 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 269 16:00:40 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 270 16:00:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 271 16:00:40 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 272 16:00:40 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 273 16:00:40 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 274 16:00:40 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 275 16:00:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 276 16:00:40 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 277 16:00:40 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 278 16:00:40 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 279 16:00:40 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 280 16:00:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14481638 281 16:00:40 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 282 16:00:40 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 283 16:00:40 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ, J.jjje00,J.gfje00,J.zfje00,J.sfsx00,J.ybbz00,S.XMMC00,j.jzje00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and Yjdjh0=14481638 284 16:02:04 Log started for: 门诊医生工作站分系统 285 16:02:04 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12116' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 286 16:02:04 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12116' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 287 16:02:04 SQL Data In: ORACLE - Rows affected = 1 288 16:02:04 SQL Prepare: ORACLE - Commit 289 16:02:04 SQL Execute: ORACLE - Commit 290 16:02:04 SQL Data In: ORACLE - Rows affected = 0 291 16:02:04 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 292 16:02:04 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 293 16:02:04 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 294 16:02:04 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 295 16:02:04 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 296 16:02:04 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 297 16:02:04 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 298 16:02:04 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 299 16:02:04 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1897' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:DBA981A5CB78796E6BEBF295B35F7720' from dual 300 16:02:04 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1897' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:DBA981A5CB78796E6BEBF295B35F7720' from dual 301 16:02:04 SQL Data In: ORACLE - Rows affected = 1 302 16:02:04 SQL Prepare: ORACLE - Commit 303 16:02:04 SQL Execute: ORACLE - Commit 304 16:02:04 SQL Data In: ORACLE - Rows affected = 0 305 16:02:04 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 306 16:02:04 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 307 16:02:04 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 308 16:02:04 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 309 16:02:10 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 310 16:02:10 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 311 16:02:10 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1899' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 312 16:02:10 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1899' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 313 16:02:10 SQL Data In: ORACLE - Rows affected = 1 314 16:02:10 SQL Prepare: ORACLE - Commit 315 16:02:10 SQL Execute: ORACLE - Commit 316 16:02:10 SQL Data In: ORACLE - Rows affected = 0 317 16:02:10 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 318 16:02:10 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 319 16:02:10 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 320 16:02:10 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 321 16:02:10 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 322 16:02:10 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 323 16:02:10 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 324 16:02:10 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 325 16:02:10 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12124' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 326 16:02:10 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12124' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 327 16:02:10 SQL Data In: ORACLE - Rows affected = 1 328 16:02:10 SQL Prepare: ORACLE - Commit 329 16:02:10 SQL Execute: ORACLE - Commit 330 16:02:10 SQL Data In: ORACLE - Rows affected = 0 331 16:02:10 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 332 16:02:10 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 333 16:02:10 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 334 16:02:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 335 16:02:10 SQL Prepare: ORACLE - Select SYSDATE from Dual 336 16:02:10 SQL Execute: ORACLE - Select SYSDATE from Dual 337 16:02:10 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 338 16:02:10 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 339 16:02:10 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 340 16:02:10 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 341 16:02:10 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 342 16:02:10 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 343 16:02:10 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 344 16:02:10 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 345 16:02: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 346 16:02: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 347 16:02:10 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 348 16:02:10 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 349 16:02:10 SQL Prepare: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 350 16:02:10 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 351 16:02:10 SQL Prepare: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 352 16:02:10 SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 353 16:02:13 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 354 16:02:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 355 16:02:13 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 356 16:02:13 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 357 16:02:13 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 358 16:02:13 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 359 16:02:13 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 360 16:02:13 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 361 16:02:13 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 362 16:02:13 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 363 16:02:13 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 364 16:02:13 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 365 16:02:13 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')) 366 16:02:13 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')) 367 16:02:13 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443084,478,'wlzx-1','8',nvl('96694430',' '),'192.168.5.22#319:12124@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 368 16:02:13 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443084,478,'wlzx-1','8',nvl('96694430',' '),'192.168.5.22#319:12124@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 369 16:02:13 SQL Data In: ORACLE - Rows affected = 1 370 16:02:13 SQL Prepare: ORACLE - Commit 371 16:02:13 SQL Execute: ORACLE - Commit 372 16:02:13 SQL Data In: ORACLE - Rows affected = 0 373 16:02:13 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 374 16:02:13 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 375 16:02:13 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 376 16:02:13 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 377 16:02:13 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 378 16:02:13 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 379 16:02:13 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 380 16:02:13 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 381 16:02:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 382 16:02:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 383 16:02:13 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 384 16:02:13 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 385 16:02:13 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 386 16:02:13 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 387 16:02:13 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 388 16:02:13 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 389 16:02:15 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 390 16:02:15 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 391 16:02:15 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 392 16:02:15 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 393 16:02:15 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 394 16:02:15 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 395 16:02:16 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 396 16:02:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 397 16:02:16 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 398 16:02:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 399 16:02:16 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 400 16:02:16 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 401 16:02:16 SQL Prepare: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 402 16:02:16 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 403 16:02:16 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 404 16:02:16 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 405 16:02:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 406 16:02:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 407 16:02:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 408 16:02:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 409 16:02:16 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 410 16:02:16 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 411 16:02:16 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 412 16:02:16 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 413 16:02:16 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 414 16:02:16 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 415 16:02:16 SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 416 16:02:16 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 417 16:02:16 SQL Prepare: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 418 16:02:16 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 419 16:02:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 420 16:02:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 421 16:02:16 SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1) 422 16:02:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 423 16:02:16 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 424 16:02:16 SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 425 16:02:16 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 426 16:02:16 SQL Prepare: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=:1 and GHYSBH=:2 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 427 16:02:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 428 16:02:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 429 16:02:16 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 430 16:02:16 SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1 431 16:02:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 432 16:02:16 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 433 16:02:16 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 434 16:02:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 435 16:02:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 436 16:02:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 437 16:02:17 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 438 16:02:17 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 439 16:02:17 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 440 16:02:17 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 441 16:02:17 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 442 16:02:17 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 443 16:02:17 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 444 16:02:17 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 445 16:02:19 SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 446 16:02:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 447 16:02:19 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 448 16:02:19 SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 449 16:02:19 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 450 16:02:19 SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=:1 451 16:02:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 452 16:02:19 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 453 16:02:19 SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and GZDJ00 <=:2 and MZDJ00 <=:3 and DPDJ00 <=:4 and KSSDJ0<=:5 and ((SJDJ00 >=:6 and :7 >'0') or SJDJ00='0') and Rownum=1 454 16:02:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 455 16:02:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 456 16:02:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 457 16:02:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 458 16:02:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 459 16:02:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 460 16:02:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 461 16:02:19 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 462 16:02:19 SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1 463 16:02:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 464 16:02:19 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 465 16:02:19 SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1 466 16:02:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 467 16:02:19 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 468 16:02:19 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 469 16:02:19 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 470 16:02:20 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 471 16:02:20 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 472 16:02:20 SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00 473 16:02:20 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 474 16:02:20 SQL Prepare: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 475 16:02:20 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 476 16:02:20 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 477 16:02:20 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 478 16:02:20 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 479 16:02:20 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 480 16:02:20 SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 481 16:02:20 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 482 16:02:20 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 483 16:02:20 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 484 16:02:20 SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 485 16:02:20 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 486 16:02:20 SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 487 16:02:20 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 488 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 489 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 490 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 491 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 492 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 493 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 494 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 495 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 496 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 497 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 498 16:02:20 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 499 16:02:20 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 500 16:02:20 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=:1 and ghksbh=:2 501 16:02:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 502 16:02:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 503 16:02:20 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 504 16:02:20 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=:1 and jzks00=:2 505 16:02:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 506 16:02:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 507 16:02:20 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 508 16:02:20 SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 509 16:02:20 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 510 16:02:20 SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 511 16:02:20 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 512 16:02:20 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 513 16:02:20 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 514 16:02:20 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 515 16:02:20 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 516 16:02:20 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 517 16:02:20 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 518 16:02:20 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 519 16:02:20 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 520 16:02:20 SQL Prepare: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 521 16:02:20 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 522 16:02:28 SQL Prepare: ORACLE - Select SYSDATE from Dual 523 16:02:28 SQL Execute: ORACLE - Select SYSDATE from Dual 524 16:02:28 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 525 16:02:28 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 526 16:02:28 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 527 16:02:28 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 528 16:02:28 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 529 16:02:28 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 530 16:02:28 SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1 531 16:02:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 532 16:02:28 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 533 16:02:28 SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1 534 16:02:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 535 16:02:28 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 536 16:02:28 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 537 16:02:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 538 16:02:28 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 539 16:03:06 SQL Prepare: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=:1 and PBLX00='1' and flag00='4' 540 16:03:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 541 16:03:06 SQL Execute: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 542 16:03:06 SQL Prepare: ORACLE - Rollback 543 16:03:06 SQL Execute: ORACLE - Rollback 544 16:03:06 SQL Data In: ORACLE - Rows affected = 0 545 16:03:06 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3443084 546 16:03:06 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3443084 547 16:03:06 SQL Data In: ORACLE - Rows affected = 1 548 16:03:06 SQL Prepare: ORACLE - Commit 549 16:03:06 SQL Execute: ORACLE - Commit 550 16:03:06 SQL Data In: ORACLE - Rows affected = 0 551 16:03:06 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 552 16:03:06 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 553 16:03:06 SQL Data In: ORACLE - Rows affected = 0 554 16:03:06 SQL Prepare: ORACLE - Commit 555 16:03:06 SQL Execute: ORACLE - Commit 556 16:03:06 SQL Data In: ORACLE - Rows affected = 0 557 16:03:29 Log started for: 门诊医生工作站分系统 558 16:03:29 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 559 16:03:29 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 560 16:03:29 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12139' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 561 16:03:29 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12139' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 562 16:03:29 SQL Data In: ORACLE - Rows affected = 1 563 16:03:29 SQL Prepare: ORACLE - Commit 564 16:03:29 SQL Execute: ORACLE - Commit 565 16:03:29 SQL Data In: ORACLE - Rows affected = 0 566 16:03:29 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 567 16:03:29 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 568 16:03:29 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 569 16:03:29 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 570 16:03:29 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 571 16:03:29 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 572 16:03:29 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 573 16:03:29 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 574 16:03:29 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1956' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 575 16:03:29 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1956' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 576 16:03:29 SQL Data In: ORACLE - Rows affected = 1 577 16:03:29 SQL Prepare: ORACLE - Commit 578 16:03:29 SQL Execute: ORACLE - Commit 579 16:03:29 SQL Data In: ORACLE - Rows affected = 0 580 16:03:29 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 581 16:03:29 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 582 16:03:29 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 583 16:03:29 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 584 16:03:29 SQL Prepare: ORACLE - Select SYSDATE from Dual 585 16:03:29 SQL Execute: ORACLE - Select SYSDATE from Dual 586 16:03:29 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 587 16:03:29 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 588 16:03:29 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 589 16:03:29 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 590 16:03:29 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 591 16:03:29 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 592 16:03:29 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 593 16:03:29 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 594 16:03:29 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 595 16:03:29 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 596 16:03:29 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 597 16:03:29 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 598 16:03:29 SQL Prepare: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 599 16:03:29 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 600 16:03:29 SQL Prepare: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 601 16:03:29 SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 602 16:03:31 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 603 16:03:31 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 604 16:03:31 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 605 16:03:31 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 606 16:03:31 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 607 16:03:31 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 608 16:03:31 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 609 16:03:31 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 610 16:03:31 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 611 16:03:31 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 612 16:03:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 613 16:03:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 614 16:03:31 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')) 615 16:03:31 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')) 616 16:03:31 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443085,478,'wlzx-1','8',nvl('96694434',' '),'192.168.5.22#309:1956@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 617 16:03:31 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443085,478,'wlzx-1','8',nvl('96694434',' '),'192.168.5.22#309:1956@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 618 16:03:31 SQL Data In: ORACLE - Rows affected = 1 619 16:03:31 SQL Prepare: ORACLE - Commit 620 16:03:31 SQL Execute: ORACLE - Commit 621 16:03:31 SQL Data In: ORACLE - Rows affected = 0 622 16:03:31 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 623 16:03:31 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 624 16:03:31 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 625 16:03:31 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 626 16:03:31 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 627 16:03:31 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 628 16:03:31 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 629 16:03:31 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 630 16:03:31 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 631 16:03:31 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 632 16:03:31 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 633 16:03:31 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 634 16:03:31 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 635 16:03:31 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 636 16:03:31 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 637 16:03:31 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 638 16:03:33 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 639 16:03:33 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 640 16:03:33 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 641 16:03:33 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 642 16:03:33 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 643 16:03:33 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 644 16:03:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 645 16:03:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 646 16:03:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 647 16:03:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 648 16:03:33 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 649 16:03:33 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 650 16:03:33 SQL Prepare: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 651 16:03:33 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 652 16:03:33 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 653 16:03:33 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 654 16:03:33 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 655 16:03:33 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 656 16:03:33 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 657 16:03:33 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 658 16:03:34 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 659 16:03:34 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 660 16:03:34 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 661 16:03:34 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 662 16:03:34 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 663 16:03:34 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 664 16:03:34 SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 665 16:03:34 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 666 16:03:34 SQL Prepare: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 667 16:03:34 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 668 16:03:34 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 669 16:03:34 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 670 16:03:34 SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1) 671 16:03:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 672 16:03:34 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 673 16:03:34 SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 674 16:03:34 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 675 16:03:34 SQL Prepare: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=:1 and GHYSBH=:2 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 676 16:03:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 677 16:03:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 678 16:03:34 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 679 16:03:34 SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1 680 16:03:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 681 16:03:34 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 682 16:03:34 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 683 16:03:34 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 684 16:03:34 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 685 16:03:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 686 16:03:34 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 687 16:03:34 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 688 16:03:34 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 689 16:03:34 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 690 16:03:34 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 691 16:03:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 692 16:03:34 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 693 16:03:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 694 16:03:37 SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 695 16:03:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 696 16:03:37 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 697 16:03:37 SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 698 16:03:37 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 699 16:03:37 SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=:1 700 16:03:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 701 16:03:37 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 702 16:03:37 SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and GZDJ00 <=:2 and MZDJ00 <=:3 and DPDJ00 <=:4 and KSSDJ0<=:5 and ((SJDJ00 >=:6 and :7 >'0') or SJDJ00='0') and Rownum=1 703 16:03:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 704 16:03:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 705 16:03:37 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 706 16:03:37 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 707 16:03:37 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 708 16:03:37 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 709 16:03:37 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 710 16:03:37 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 711 16:03:37 SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1 712 16:03:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 713 16:03:37 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 714 16:03:37 SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1 715 16:03:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 716 16:03:37 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 717 16:03:37 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 718 16:03:37 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 719 16:03:37 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 720 16:03:37 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 721 16:03:37 SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00 722 16:03:37 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 723 16:03:37 SQL Prepare: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 724 16:03:37 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 725 16:03:38 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 726 16:03:38 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 727 16:03:38 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 728 16:03:38 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 729 16:03:38 SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 730 16:03:38 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 731 16:03:38 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 732 16:03:38 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 733 16:03:38 SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 734 16:03:38 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 735 16:03:38 SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 736 16:03:38 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 737 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 738 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 739 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 740 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 741 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 742 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 743 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 744 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 745 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 746 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 747 16:03:38 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 748 16:03:38 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 749 16:03:38 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=:1 and ghksbh=:2 750 16:03:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 751 16:03:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 752 16:03:38 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 753 16:03:38 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=:1 and jzks00=:2 754 16:03:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 755 16:03:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 756 16:03:38 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 757 16:03:38 SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 758 16:03:38 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 759 16:03:38 SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 760 16:03:38 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 761 16:03:38 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 762 16:03:38 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 763 16:03:38 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 764 16:03:38 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 765 16:03:38 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 766 16:03:38 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 767 16:03:38 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 768 16:03:38 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 769 16:03:38 SQL Prepare: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 770 16:03:38 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 771 16:03:40 SQL Prepare: ORACLE - Select SYSDATE from Dual 772 16:03:40 SQL Execute: ORACLE - Select SYSDATE from Dual 773 16:03:40 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 774 16:03:40 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 775 16:03:40 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 776 16:03:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 777 16:03:40 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 778 16:03:40 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 779 16:03:40 SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1 780 16:03:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 781 16:03:40 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 782 16:03:40 SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1 783 16:03:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 784 16:03:40 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 785 16:03:40 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 786 16:03:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 787 16:03:40 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 788 16:03:40 SQL Prepare: ORACLE - select * from (select GHRQ00,GHKSMC,count(*) as GHCS00 from (select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc ) group by GHRQ00,GHKSMC ) order by GHRQ00 789 16:03:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 790 16:03:40 SQL Execute: ORACLE - select * from (select GHRQ00,GHKSMC,count(*) as GHCS00 from (select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc ) group by GHRQ00,GHKSMC ) order by GHRQ00 791 16:03:40 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 792 16:03:40 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 793 16:03:40 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 794 16:03:40 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 795 16:03:53 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 796 16:03:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 797 16:03:53 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 798 16:04:05 SQL Prepare: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=:1 and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,:2)>0) 799 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10353813 800 16:04:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = /222137/ 801 16:04:05 SQL Execute: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=? and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,?)>0) 802 16:04:05 SQL Prepare: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='5525094' and HZZT00 in ('0','2','4') 803 16:04:05 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='5525094' and HZZT00 in ('0','2','4') 804 16:04:05 SQL Data In: ORACLE - Rows affected = 0 805 16:04:05 SQL Prepare: ORACLE - commit 806 16:04:05 SQL Execute: ORACLE - commit 807 16:04:05 SQL Data In: ORACLE - Rows affected = 0 808 16:04:05 SQL Prepare: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = :1 order by zzdbz0 809 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10353813.000000 810 16:04:05 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 811 16:04:05 SQL Prepare: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=:1 order by zzdbz0 812 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10353813.000000 813 16:04:05 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 814 16:04:05 SQL Prepare: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=10353813 815 16:04:05 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=10353813 816 16:04:05 SQL Prepare: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=:1 817 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10353813.000000 818 16:04:05 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 819 16:04:05 SQL Prepare: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=137182)and GHID00<10353813 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=137182)and GHID00>10353813 and rownum=1 820 16:04:05 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=137182)and GHID00<10353813 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=137182)and GHID00>10353813 and rownum=1 821 16:04:05 SQL Prepare: ORACLE - select sum(CFZJE0) from YF_MZCF00 where GHH000=:1 and cfzt00 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=:2 and MZZYBZ='0' and xmzt00 in ('0','1') 822 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5525094 823 16:04:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 5525094 824 16:04:05 SQL Execute: ORACLE - select sum(CFZJE0) from YF_MZCF00 where GHH000=? and cfzt00 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 825 16:04:05 SQL Prepare: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=:1 and a.BRID00=b.BRID00 826 16:04:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 827 16:04:05 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 828 16:04:05 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 829 16:04:05 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 830 16:04:20 SQL Prepare: ORACLE - Select SYSDATE from Dual 831 16:04:20 SQL Execute: ORACLE - Select SYSDATE from Dual 832 16:04:20 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 833 16:04:20 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 834 16:04:20 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 835 16:04:20 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 836 16:04:20 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 837 16:04:20 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 838 16:04:20 SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1 839 16:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 840 16:04:20 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 841 16:04:20 SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1 842 16:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 843 16:04:20 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 844 16:04:20 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 845 16:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 846 16:04:20 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 847 16:04:20 SQL Prepare: ORACLE - select * from (select GHRQ00,GHKSMC,count(*) as GHCS00 from (select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc ) group by GHRQ00,GHKSMC ) order by GHRQ00 848 16:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 849 16:04:20 SQL Execute: ORACLE - select * from (select GHRQ00,GHKSMC,count(*) as GHCS00 from (select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc ) group by GHRQ00,GHKSMC ) order by GHRQ00 850 16:04:20 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 851 16:04:20 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5525095' and LBBH00='0' 852 16:04:20 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 853 16:04:20 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='137182' and ZT0000='1' 854 16:04:23 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 855 16:04:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 856 16:04:23 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 857 16:04:47 SQL Prepare: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=:1 and PBLX00='1' and flag00='4' 858 16:04:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 859 16:04:47 SQL Execute: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 860 16:04:47 SQL Prepare: ORACLE - Rollback 861 16:04:47 SQL Execute: ORACLE - Rollback 862 16:04:47 SQL Data In: ORACLE - Rows affected = 0 863 16:04:47 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3443085 864 16:04:47 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3443085 865 16:04:47 SQL Data In: ORACLE - Rows affected = 1 866 16:04:47 SQL Prepare: ORACLE - Commit 867 16:04:47 SQL Execute: ORACLE - Commit 868 16:04:47 SQL Data In: ORACLE - Rows affected = 0 869 16:04:47 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 870 16:04:47 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 871 16:04:47 SQL Data In: ORACLE - Rows affected = 0 872 16:04:47 SQL Prepare: ORACLE - Commit 873 16:04:47 SQL Execute: ORACLE - Commit 874 16:04:47 SQL Data In: ORACLE - Rows affected = 0 875 16:06:07 Log started for: 门诊医生工作站分系统 876 16:06:07 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 877 16:06:07 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 878 16:06:07 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1969' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 879 16:06:07 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','309','1969' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 880 16:06:07 SQL Data In: ORACLE - Rows affected = 1 881 16:06:07 SQL Prepare: ORACLE - Commit 882 16:06:07 SQL Execute: ORACLE - Commit 883 16:06:07 SQL Data In: ORACLE - Rows affected = 0 884 16:06:07 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 885 16:06:07 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 886 16:06:07 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 887 16:06:07 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 888 16:06:07 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 889 16:06:07 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 890 16:06:07 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 891 16:06:07 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 892 16:06:07 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12203' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 893 16:06:07 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','319','12203' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:0134E298383CDA6C52FDE140EE55291E' from dual 894 16:06:07 SQL Data In: ORACLE - Rows affected = 1 895 16:06:07 SQL Prepare: ORACLE - Commit 896 16:06:07 SQL Execute: ORACLE - Commit 897 16:06:07 SQL Data In: ORACLE - Rows affected = 0 898 16:06:07 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 899 16:06:07 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 900 16:06:07 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 901 16:06:07 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 902 16:06:07 SQL Prepare: ORACLE - Select SYSDATE from Dual 903 16:06:07 SQL Execute: ORACLE - Select SYSDATE from Dual 904 16:06:07 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 905 16:06:07 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 906 16:06:07 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 907 16:06:07 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 908 16:06:07 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 909 16:06:07 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 910 16:06:07 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 911 16:06:07 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 912 16:06:07 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 913 16:06:07 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 914 16:06:07 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 915 16:06:07 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 916 16:06:07 SQL Prepare: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 917 16:06:07 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 918 16:06:07 SQL Prepare: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 919 16:06:07 SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') and rownum=1 920 16:06:10 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 921 16:06:10 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 922 16:06:10 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 923 16:06:10 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=478 924 16:06:10 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 925 16:06:10 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 926 16:06:10 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 927 16:06:10 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 928 16:06:10 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 929 16:06:10 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 930 16:06:10 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 931 16:06:10 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 932 16:06:10 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')) 933 16:06:10 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')) 934 16:06:10 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443086,478,'wlzx-1','8',nvl('96694439',' '),'192.168.5.22#319:12203@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 935 16:06:10 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3443086,478,'wlzx-1','8',nvl('96694439',' '),'192.168.5.22#319:12203@appYS_YSGZZ.exe+门诊医生工作站分系统',20) 936 16:06:10 SQL Data In: ORACLE - Rows affected = 1 937 16:06:10 SQL Prepare: ORACLE - Commit 938 16:06:10 SQL Execute: ORACLE - Commit 939 16:06:10 SQL Data In: ORACLE - Rows affected = 0 940 16:06:10 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 941 16:06:10 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 20 942 16:06:10 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 943 16:06:10 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 944 16:06:10 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 945 16:06:10 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 946 16:06:10 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 947 16:06:10 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 948 16:06:10 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 949 16:06:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 950 16:06:10 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 951 16:06:10 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 20 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 952 16:06:10 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 953 16:06:10 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 954 16:06:10 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 955 16:06:10 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 956 16:06:12 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 957 16:06:12 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='478' and name00='SYSTEMSKIN' 958 16:06:12 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 959 16:06:12 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 960 16:06:12 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 961 16:06:12 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20140214' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',20,' )>0 ) 962 16:06:12 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 963 16:06:12 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 964 16:06:12 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 965 16:06:12 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 966 16:06:13 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 967 16:06:13 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 968 16:06:13 SQL Prepare: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 969 16:06:13 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 970 16:06:13 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 971 16:06:13 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 972 16:06:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 973 16:06:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 974 16:06:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 975 16:06:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS') 976 16:06:13 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 977 16:06:13 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 978 16:06:13 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 979 16:06:13 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 980 16:06:13 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 981 16:06:13 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 982 16:06:13 SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 983 16:06:13 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 984 16:06:13 SQL Prepare: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 985 16:06:13 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 986 16:06:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 987 16:06:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 478 988 16:06:13 SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1) 989 16:06:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 990 16:06:13 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 991 16:06:13 SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 992 16:06:13 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 993 16:06:13 SQL Prepare: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=:1 and GHYSBH=:2 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 994 16:06:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 995 16:06:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 996 16:06:13 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 997 16:06:13 SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1 998 16:06:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 999 16:06:13 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 1000 16:06:13 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 1001 16:06:13 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 1002 16:06:13 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 1003 16:06:13 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='8'))) 1004 16:06:13 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 1005 16:06:13 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 1006 16:06:13 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 1007 16:06:13 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 ((478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='0 '))) 1008 16:06:13 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 1009 16:06:13 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 1010 16:06:13 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 1011 16:06:13 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 478= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=478 and XTDM00='+ '))) 1012 16:06:16 SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 1013 16:06:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 1014 16:06:16 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 1015 16:06:16 SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 1016 16:06:16 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 1017 16:06:16 SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=:1 1018 16:06:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 1019 16:06:16 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 1020 16:06:16 SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and GZDJ00 <=:2 and MZDJ00 <=:3 and DPDJ00 <=:4 and KSSDJ0<=:5 and ((SJDJ00 >=:6 and :7 >'0') or SJDJ00='0') and Rownum=1 1021 16:06:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1022 16:06:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1023 16:06:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1024 16:06:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1025 16:06:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1026 16:06:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1027 16:06:16 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1028 16:06:16 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 1029 16:06:16 SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1 1030 16:06:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 1031 16:06:16 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 1032 16:06:16 SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1 1033 16:06:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 1034 16:06:16 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 1035 16:06:16 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 1036 16:06:16 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 1037 16:06:16 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 1038 16:06:16 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 1039 16:06:16 SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00 1040 16:06:16 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 1041 16:06:17 SQL Prepare: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 1042 16:06:17 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 1043 16:06:17 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 1044 16:06:17 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 1045 16:06:17 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 1046 16:06:17 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 1047 16:06:17 SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 1048 16:06:17 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 1049 16:06:17 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1050 16:06:17 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1051 16:06:17 SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1052 16:06:17 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1053 16:06:17 SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1054 16:06:17 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=20 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 1055 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 1056 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 1057 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 1058 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 1059 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 1060 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 1061 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 1062 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 1063 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 1064 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 1065 16:06:17 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 1066 16:06:17 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 1067 16:06:17 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=:1 and ghksbh=:2 1068 16:06:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 1069 16:06:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 1070 16:06:17 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 1071 16:06:17 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=:1 and jzks00=:2 1072 16:06:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 478 1073 16:06:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 1074 16:06:17 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 1075 16:06:17 SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 1076 16:06:17 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 478 1077 16:06:17 SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 1078 16:06:17 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 1079 16:06:17 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 1080 16:06:17 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 1081 16:06:17 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 1082 16:06:17 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 1083 16:06:17 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 1084 16:06:17 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 1085 16:06:17 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 1086 16:06:17 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 1087 16:06:17 SQL Prepare: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 1088 16:06:17 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=478 1089 16:06:19 SQL Prepare: ORACLE - Select SYSDATE from Dual 1090 16:06:19 SQL Execute: ORACLE - Select SYSDATE from Dual 1091 16:06:19 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 1092 16:06:19 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 1093 16:06:19 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 1094 16:06:19 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 1095 16:06:20 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 1096 16:06:20 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137100878821' and ICKNBH = '0222137100878821' 1097 16:06:20 SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1 1098 16:06:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 1099 16:06:20 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 1100 16:06:20 SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1 1101 16:06:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 1102 16:06:20 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 1103 16:06:20 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 1104 16:06:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 137182 1105 16:06:20 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=478) or (a.JZYS00=0) ) or (a.GHKS00=20 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc