1 19:04:51 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '7') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',35,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1080,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1080 AND b.JSKSBH = '35') AND (INSTR (',' || a.jsksbh || ',',',35,') > 0 or a.jsksbh is null) 2 19:04:53 SQL Execute: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='391606' 3 19:04:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 住院神经外科 4 19:04:53 SQL Execute: ORACLE - select BMBH00 from vw_yj_kdks00 where bmmc00=? 5 19:04:53 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 19:04:53 SQL Data In: ORACLE - Param = 2, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000 7 19:04:53 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1543511.000000 8 19:04:53 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 740318.000000 9 19:04:53 SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 19:04:53 SQL Data In: ORACLE - Param = 6, Name = PBRXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 11 19:04:53 SQL Data In: ORACLE - Param = 7, Name = PXB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 12 19:04:53 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 13 19:04:53 SQL Data In: ORACLE - Param = 9, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5936.000000 14 19:04:53 SQL Data In: ORACLE - Param = 10, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 418.000000 15 19:04:53 SQL Data In: ORACLE - Param = 11, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2350.000000 16 19:04:53 SQL Data In: ORACLE - Param = 12, Name = PLRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林俊荣 17 19:04:53 SQL Data In: ORACLE - Param = 13, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 18 19:04:53 SQL Data In: ORACLE - Param = 14, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 19:04:53 SQL Data In: ORACLE - Param = 15, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 20 19:04:53 SQL Data In: ORACLE - Param = 16, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 21 19:04:53 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 22 19:04:53 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 23 19:04:53 SQL Data In: ORACLE - Param = 19, Name = PYWMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 19:04:53 SQL Data In: ORACLE - Param = 20, Name = POPNAME, Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 25 19:04:53 SQL Data In: ORACLE - Param = 21, Name = PNEWDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 26 19:04:53 SQL Data In: ORACLE - Param = 22, Name = PDQBQ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1649 27 19:04:53 SQL Data In: ORACLE - Param = 23, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1080.000000 28 19:04:53 SQL Data In: ORACLE - Param = 24, Name = PCZKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000 29 19:04:53 SQL Data In: ORACLE - Param = 25, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 30 19:04:53 SQL Data In: ORACLE - Param = 26, Name = PYZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 31 19:04:53 SQL Data In: ORACLE - Param = 27, Name = PYSZID0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.000000 32 19:04:53 SQL Data In: ORACLE - Param = 28, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 33 19:04:53 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,PYZLX00 => :PYZLX00,PYSZID0 => :PYSZID0,PZDMC00 => :PZDMC00); END; 34 19:04:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30881633.000000 35 19:04:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5936.000000 36 19:04:53 SQL Execute: ORACLE - INSERT INTO YJ_YWMX00 (ID0000,YJDJH0,ZLXMID) values (SQ_YJ_YWMX00_ID0000.NEXTVAL,?,?) 37 19:04:53 SQL Data In: ORACLE - Rows affected = 1 38 19:04:53 SQL Execute: ORACLE - Commit 39 19:04:53 SQL Data In: ORACLE - Rows affected = 0 40 19:04:53 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30881633.000000 41 19:04:53 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 42 19:04:53 SQL Execute: ORACLE - BEGIN "SP_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00); END; 43 19:04:55 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='开单' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' 44 19:04:55 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='YJ00_ZJ00_0001' and SFQY00='1' 45 19:04:55 SQL Execute: ORACLE - select sysdate from dual 46 19:04:55 SQL Execute: ORACLE - Select b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.lrxm00,b.kdsj00,b.zje000, b.xb0000,b.sl0000,b.csrq00,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.brid00,b.mzzybz,b.yzlx00 from vw_yj_yw0000_wzx b where b.xmzt00 in('0','1') and b.brid00=1543511 and (b.YJKSBH=35 or (b.Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=35) and b.kdksbh in (select Sqxmks from vw_xt_xmfwfx where jsxmks=35)) or b.KDKSBH=35) 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 b.kdrq00='20210322' order by b.YJdjh0 47 19:04:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30881633 48 19:04:55 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 49 19:04:55 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=30881633 50 19:04:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30881633 51 19:04:55 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 52 19:04:55 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=30881633 53 19:04:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30881633 54 19:04:55 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 55 19:04:55 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=30881633 56 19:04:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30881633 57 19:04:55 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 58 19:04:55 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=30881633 59 19:04:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 30881633 60 19:04:55 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 61 19:04:55 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=30881633