1       10:00:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 28866548        
2       10:00:12  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(replace(to_char(a.ypzsl0,'FM99999990.999')||' ','. ',''))||'('||trim(a.cfdw00)||')' as sldw00,trim(replace(to_char(a.csl000,'FM99999990.9999')||' ','. ',''))||'('||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 a.cflsh0=? order by a.ZB0000

3       10:00:12  SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
 WHERE GHH000='32641661' 

4       10:00:12  SQL Execute: ORACLE - SELECT SF_YF_GETZD0('32641661') ZDMC00 from dual 

5       10:00:12  SQL Execute: ORACLE - SELECT SF_YF_BSLXX('32641661') ZBSLXX from dual 

6       10:00:12  SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=57860414  and MZZYBZ='0' order by CZRQ00||CZSJ00 desc 

7       10:00:12  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

8       10:00:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 28866548        
9       10:00:12  SQL Execute: ORACLE - select YSGZH0,YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, 
 SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=?

10      10:00:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 28866548        
11      10:00:12  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=?

12      10:00:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 28866548        
13      10:00:12  SQL Execute: ORACLE - select * from VW_YF_MZXYDY_BZ Where CFLSH0=?  

14      10:00:12  SQL Execute: ORACLE - select decode(a.YPDLBH,'0','西药方','1','中成药方','2','草药方',a.YPDLBH) CFLX00,a.*,b.*,c.*
 ,(select YYID00 from bm_bmbm00 where BMBH00=b.JZKS00) YYID00,(select KMH000 from IC_YHXX00 where BRID00=a.BRID00 and ZT0000='1') KMH000
 ,decode(a.CFZT00,'0','0','1','0','2','0','3','2','4','0','5','1','6','1') CFZT00
,to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') EventTime,(select BMMC00 from BM_BMBM00 where BMBH00=b.JZKS00) JZKSMC
 from yf_mzcf00 a, SF_BRXXB0 b,BM_BRXXB0 c 
 where a.BRID00=b.BRID00 and  a.BRID00=c.BRID00 and b.GHH000=a.GHH000  and a.cflsh0='28866548'

15      10:00:12  SQL Execute: ORACLE - select decode(a.SFZBY0,'Y','2','1') SFZBY,decode(a.YPDLBH,'0','西药方','1','中成药方','2','草药方',a.YPDLBH) CFLX00,a.*
 ,(select CKMC00 from BM_CKBM00 where CKBH00=b.FYCKBH ) FYCKMC
 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' 
 and b.cflsh0(+)=a.cflsh0  and a.cflsh0='28866548'

16      10:00:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 28866548        
17      10:00:12  SQL Execute: ORACLE - select * from VW_YF_MZXYMX_BZ Where CFLSH0=? and CFID00>0 order by YPDLBH,CFID00,CFXH00 

18      10:01:02  Log started for: 药房管理系统
19      10:02:49  Log started for: SQL Navigator for Oracle