1 17:06:43 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 2 17:06:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 3 17:06:43 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 4 17:06:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 5 17:06:43 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 6 17:06:51 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 7 17:06:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 8 17:06:51 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 9 17:06:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 10 17:06:51 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 11 17:06:59 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 12 17:06:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13 17:06:59 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 14 17:06:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 15 17:06:59 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 16 17:07:07 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 17 17:07:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18 17:07:07 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 19 17:07:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 20 17:07:07 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 21 17:07:15 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 22 17:07:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 23 17:07:15 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 24 17:07:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 25 17:07:15 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 26 17:07:23 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 27 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 28 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 29 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 30 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 31 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 32 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 33 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 34 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 35 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 36 17:07:23 SQL Execute: ORACLE - Update YF_CFDL00 set DYRQ00=to_char(sysdate,'YYYYMMDD'),DYSJ00=to_char(sysdate,'HH24:MI:SS'),ZT0000='1' where CFLSH0=? 37 17:07:23 SQL Data In: ORACLE - Rows affected = 1 38 17:07:23 SQL Execute: ORACLE - commit 39 17:07:23 SQL Data In: ORACLE - Rows affected = 0 40 17:07:23 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 41 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 42 17:07:23 SQL Execute: ORACLE - select YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=? 43 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 44 17:07:23 SQL Execute: ORACLE - SELECT trim(GETCFJNDJCTS(B.CFLSH0))||' '||DECODE(INSTR(BMMC00,'急'),0,DECODE(INSTR(BMMC00,'儿'),0,'','儿科'),'急诊') XZKS00 FROM SF_BRXXB0 A,YF_MZCF00 B,BM_BMBM00 C WHERE A.GHID00=B.GHID00 AND A.JZKS00=C.BMBH00 AND B.CFLSH0=? 45 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 46 17:07:23 SQL Execute: ORACLE - select * from VW_YF_MZXYDY_BZ Where CFLSH0=? 47 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750486 48 17:07:23 SQL Execute: ORACLE - select * from VW_YF_MZXYMX_BZ Where CFLSH0=? and CFID00>0 order by CFID00 49 17:07:23 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS=nvl(CFBDCS,0)+1 where CFLSH0='4750486' 50 17:07:23 SQL Data In: ORACLE - Rows affected = 1 51 17:07:23 SQL Execute: ORACLE - COMMIT 52 17:07:23 SQL Data In: ORACLE - Rows affected = 0 53 17:07:23 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 54 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 55 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 56 17:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 57 17:07:23 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 58 17:07:31 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 59 17:07:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 60 17:07:31 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 61 17:07:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 62 17:07:31 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 63 17:07:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 64 17:07:31 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 65 17:07:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 66 17:07:31 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 67 17:07:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 68 17:07:31 SQL Execute: ORACLE - Update YF_CFDL00 set DYRQ00=to_char(sysdate,'YYYYMMDD'),DYSJ00=to_char(sysdate,'HH24:MI:SS'),ZT0000='1' where CFLSH0=? 69 17:07:32 SQL Data In: ORACLE - Rows affected = 1 70 17:07:32 SQL Execute: ORACLE - commit 71 17:07:32 SQL Data In: ORACLE - Rows affected = 0 72 17:07:32 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 73 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 74 17:07:32 SQL Execute: ORACLE - select YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=? 75 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 76 17:07:32 SQL Execute: ORACLE - SELECT trim(GETCFJNDJCTS(B.CFLSH0))||' '||DECODE(INSTR(BMMC00,'急'),0,DECODE(INSTR(BMMC00,'儿'),0,'','儿科'),'急诊') XZKS00 FROM SF_BRXXB0 A,YF_MZCF00 B,BM_BMBM00 C WHERE A.GHID00=B.GHID00 AND A.JZKS00=C.BMBH00 AND B.CFLSH0=? 77 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 78 17:07:32 SQL Execute: ORACLE - select * from VW_YF_MZXYDY_BZ Where CFLSH0=? 79 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750496 80 17:07:32 SQL Execute: ORACLE - select * from VW_YF_MZXYMX_BZ Where CFLSH0=? and CFID00>0 order by CFID00 81 17:07:32 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS=nvl(CFBDCS,0)+1 where CFLSH0='4750496' 82 17:07:32 SQL Data In: ORACLE - Rows affected = 1 83 17:07:32 SQL Execute: ORACLE - COMMIT 84 17:07:32 SQL Data In: ORACLE - Rows affected = 0 85 17:07:32 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 86 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 87 17:07:32 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 88 17:07:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 89 17:07:32 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 90 17:07:40 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 91 17:07:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 92 17:07:40 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 93 17:07:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 94 17:07:40 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 95 17:07:48 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 96 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 97 17:07:48 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 98 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 99 17:07:48 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 100 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 101 17:07:48 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 102 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 103 17:07:48 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 104 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 105 17:07:48 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 106 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 107 17:07:48 SQL Execute: ORACLE - Update YF_CFDL00 set DYRQ00=to_char(sysdate,'YYYYMMDD'),DYSJ00=to_char(sysdate,'HH24:MI:SS'),ZT0000='1' where CFLSH0=? 108 17:07:48 SQL Data In: ORACLE - Rows affected = 1 109 17:07:48 SQL Execute: ORACLE - commit 110 17:07:48 SQL Data In: ORACLE - Rows affected = 0 111 17:07:48 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 112 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 113 17:07:48 SQL Execute: ORACLE - select YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=? 114 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 115 17:07:48 SQL Execute: ORACLE - SELECT trim(GETCFJNDJCTS(B.CFLSH0))||' '||DECODE(INSTR(BMMC00,'急'),0,DECODE(INSTR(BMMC00,'儿'),0,'','儿科'),'急诊') XZKS00 FROM SF_BRXXB0 A,YF_MZCF00 B,BM_BMBM00 C WHERE A.GHID00=B.GHID00 AND A.JZKS00=C.BMBH00 AND B.CFLSH0=? 116 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 117 17:07:48 SQL Execute: ORACLE - select * from VW_YF_MZXYDY_BZ Where CFLSH0=? 118 17:07:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750485 119 17:07:48 SQL Execute: ORACLE - select * from VW_YF_MZXYMX_BZ Where CFLSH0=? and CFID00>0 order by CFID00 120 17:07:48 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS=nvl(CFBDCS,0)+1 where CFLSH0='4750485' 121 17:07:48 SQL Data In: ORACLE - Rows affected = 1 122 17:07:48 SQL Execute: ORACLE - COMMIT 123 17:07:48 SQL Data In: ORACLE - Rows affected = 0 124 17:07:48 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 125 17:07:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 126 17:07:49 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 127 17:07:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 128 17:07:49 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 129 17:07:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 130 17:07:49 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 131 17:07:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 132 17:07:49 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 133 17:07:57 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 134 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 135 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 136 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 137 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 138 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 139 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 140 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 141 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 142 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 143 17:07:57 SQL Execute: ORACLE - Update YF_CFDL00 set DYRQ00=to_char(sysdate,'YYYYMMDD'),DYSJ00=to_char(sysdate,'HH24:MI:SS'),ZT0000='1' where CFLSH0=? 144 17:07:57 SQL Data In: ORACLE - Rows affected = 1 145 17:07:57 SQL Execute: ORACLE - commit 146 17:07:57 SQL Data In: ORACLE - Rows affected = 0 147 17:07:57 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 148 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 149 17:07:57 SQL Execute: ORACLE - select YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=? 150 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 151 17:07:57 SQL Execute: ORACLE - SELECT trim(GETCFJNDJCTS(B.CFLSH0))||' '||DECODE(INSTR(BMMC00,'急'),0,DECODE(INSTR(BMMC00,'儿'),0,'','儿科'),'急诊') XZKS00 FROM SF_BRXXB0 A,YF_MZCF00 B,BM_BMBM00 C WHERE A.GHID00=B.GHID00 AND A.JZKS00=C.BMBH00 AND B.CFLSH0=? 152 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 153 17:07:57 SQL Execute: ORACLE - select * from VW_YF_MZXYDY_BZ Where CFLSH0=? 154 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4750492 155 17:07:57 SQL Execute: ORACLE - select * from VW_YF_MZXYMX_BZ Where CFLSH0=? and CFID00>0 order by CFID00 156 17:07:57 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS=nvl(CFBDCS,0)+1 where CFLSH0='4750492' 157 17:07:57 SQL Data In: ORACLE - Rows affected = 1 158 17:07:57 SQL Execute: ORACLE - COMMIT 159 17:07:57 SQL Data In: ORACLE - Rows affected = 0 160 17:07:57 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 161 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 162 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 163 17:07:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 164 17:07:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 165 17:08:05 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 166 17:08:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 167 17:08:05 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 168 17:08:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 169 17:08:05 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 170 17:08:13 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 171 17:08:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 172 17:08:13 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 173 17:08:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 174 17:08:13 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 175 17:08:21 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 176 17:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 177 17:08:21 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 178 17:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 179 17:08:21 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 180 17:08:29 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 181 17:08:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 182 17:08:29 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 183 17:08:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 184 17:08:29 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 185 17:08:37 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 186 17:08:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 187 17:08:37 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 188 17:08:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 189 17:08:37 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 190 17:08:45 SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=3 and a.jzrq00>=to_char(sysdate-30,'YYYYMMDD') order by a.FYDLXH 191 17:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 192 17:08:45 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=? 193 17:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 194 17:08:45 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg, trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000), trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and b.cflsh0=?