1       19:21:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
2       19:21:22  SQL Execute: ORACLE - select * from IC_YHXX00 where ickh00=?

3       19:21:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140428
4       19:21:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140428
5       19:21:22  SQL Execute: ORACLE - select a.*,decode(a.zt0000,'0','未打印未配药','1','已打印未配药','2','已配药未发药','3','已发药','4','已冲销') ztmc00,d.bmmc00,substr(sf_BQ_csrqtonl(a.csrq00),1,10) as brnl00,c.YSXM00 as kdys00,e.bmmc00 as kdks00,g.FBMC00 as fbmc00,  c.thbz00,c.thyy00,   h.ybmc00 as ybmc00,c.ZYTS00,i.zwxm00 as pyr000, (SELECT nvl(MC0000,'') FROM BM_TYZD00 WHERE ZDMC00='发药窗口对应标识' and BH0000=a.FYCKBH and rownum=1)||a.FYDLXH as FYDLH2  from yf_cfdl00 a,bm_ckbm00 b,yf_mzcf00 c,bm_bmbm00 d,bm_bmbm00 e,bm_brxxb0 f,BM_BRFBB0 g,ic_ybbrlb h,BM_YGBM00 i where a.cflsh0=c.cflsh0 and c.ghks00=e.bmbh00 and a.PYCKBH=b.ckbh00 and a.BRID00=f.BRID00 and f.FBBH00=g.fbbh00 and f.fbbh00=h.fbbh00 and DYRQ00= to_char(sysdate,'YYYYMMDD')  and f.yblb00=h.yblb00 and a.yfbmbh=d.bmbh00 and c.pfr000=i.ygbh00  and a.pyrq00>=? and a.pyrq00<=? order by a.cflsh0

6       19:21:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2063065         
7       19:21:22  SQL Execute: ORACLE - select 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_mzcf00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=? order by a.ZB0000