1       11:14:12  Log started for: 药房管理系统
2       11:14:36  Log started for: Sickberth
3       11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1631017.000000
4       11:14:58  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
5       11:14:58  SQL Execute: ORACLE - select sum(HJJE00)HJJE00 from  ZY_BRFY00  where BRID00=? and ZYID00=?
 and JZDH00=0

6       11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
7       11:14:58  SQL Execute: ORACLE - select count(1) as num from yf_zycf00 where CFZT00='1' and ZYID00=? 

8       11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
9       11:14:58  SQL Execute: ORACLE - select  count(*) NUM  from  YF_YZYPSQ  where  ZYID00 =?  and  QLZT00 in ('0','5') and CXBZ00 <> 'Z'

10      11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
11      11:14:58  SQL Execute: ORACLE -  select count(*) NUM  from  YF_ZYCF00 A where A.ZYID00 = ?
 and  A.CFZT00 in ('0','5') and  A.BCCFH0  in (select CFLSH0 from  yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00 = 0 and F.ZYID00 = A.ZYID00 ) 

12      11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
13      11:14:58  SQL Execute: ORACLE - select count(*) NUM from  VW_ZY_YJYW00 A where  A.ZYID00 = ?
 and  A.CXDJH0 in ( select YJDJH0  from  YJ_YW0000 where ZYGHID = A.ZYID00 and SFDJH0 in ( select DJH000 from ZY_BRFY00  where JZDH00 = 0 and ZYID00=A.ZYID00)) 
 and  A.SFDJH0+0 = 0 

14      11:14:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 688182.000000
15      11:14:58  SQL Execute: ORACLE - select count(*) NUM from  bq_yjyz00 A where  A.ZYID00 = ?
 and  A.ZLXMID = 0   
 and  A.ZLXMJC  like '%垫付%'

16      11:15:01  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 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',130,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '130')
  AND (INSTR (',' || a.jsksbh || ',',',130,') > 0 or a.jsksbh is null)