1       10:25:50  SQL Execute: ORACLE - Select * from xt_xtcs00 where name00='XT_CXCFXSSJ'

2       10:25:50  SQL Execute: ORACLE - select a.* from vw_py_fycfdl a where a.FYCKBH=5 and ((a.zt0000='2' or (a.zt0000 = '4' AND a.pysj00 is not null )) and a.dyrq00=to_char(sysdate,'YYYYMMDD')) order by a.dysj00

3       10:25:54  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 = 'R') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',495,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1860
  AND b.JSKSBH = '495')
  AND (INSTR (',' || a.jsksbh || ',',',495,') > 0 or a.jsksbh is null)  

4       10:25:54  SQL Execute: ORACLE - Select * from xt_xtcs00 where name00='XT_CXCFXSSJ'

5       10:25:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495
6       10:25:54  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:24:54
7       10:25:54  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
8       10:25:54  SQL Execute: ORACLE -  select * from vw_py_fycfdl where  dyrq00=to_char(sysdate,'YYYYMMDD') and yfbmbh=? and ((zt0000='4' and dysj00>? and pysj00 is null ) or (zt0000 ='1')) and fyckbh=? order by fydlxh

9       10:25:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4939127         
10      10:25:54  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

11      10:25:54  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1860) and  (BMBH00=0 or  BMBH00=495)
 and DLXTMC='门诊配药系统' and CTMC00='frmPY_MZPYXT_SEY' order by YGBH00 

12      10:25:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4938918         
13      10:25:55  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 a.cflsh0=?