1       12:28:00  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=1150 or (JSKSBH=20 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

2       12:28:05  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=1150 or (JSKSBH=20 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

3       12:28:10  Log started for: 药房管理系统
4       12:28:12  SQL Execute: ORACLE - SELECT C.CFLSH0,C.ZYH000,C.BRXM00,C.XB0000,C.CH0000,C.BRID00,'0' FLAG00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.SFKSLY,C.DQBQ00,C.DQKS00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ
,G.ZWXM00 AS LRY000,C.ZYDJS0,C.ZYID00,substr(SF_YF_GETALLZYZD(C.ZYID00),1,127) RYZD00, 
(SELECT nvl(sum(zfje00),0) FROM YF_ZYCFMX WHERE  CFLSH0=C.CFLSH0 and sfzby0='N' ) ypzje0,  
(select substrb(SF_BQ_CSRQTONL(C.CSRQ00),1,100) from dual) BRNL00,C.YEXM00 
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.ZYH000='1502494'
 and (C.SFKSLY='-1') 
 AND C.YFBMBH=35
 AND ((C.CFZT00 in ('0')
 AND C.BCCFH0 IS NULL)
 OR (C.CFZT00 in ('1')  AND C.BCCFH0 IS NULL 
 AND NOT EXISTS (SELECT 1 FROM YF_ZYCF00 D WHERE  C.CFLSH0=D.BCCFH0 AND ZYH000='1502494'  AND CFZT00 in ('0','1')  )))
 AND C.CFXZ00='0'
 AND C.CZY000=G.YGBH00
 ORDER BY C.CFLSH0

5       12:28:18  SQL Execute: ORACLE - SELECT BRID00 FROM ZY_BRXXB0
 WHERE ZYH000=''

6       12:28:29  SQL Execute: ORACLE - SELECT C.CFLSH0,C.ZYH000,C.BRXM00,C.XB0000,C.CH0000,C.BRID00,'0' FLAG00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.SFKSLY,C.DQBQ00,C.DQKS00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ
,G.ZWXM00 AS LRY000,C.ZYDJS0,C.ZYID00,substr(SF_YF_GETALLZYZD(C.ZYID00),1,127) RYZD00, 
(SELECT nvl(sum(zfje00),0) FROM YF_ZYCFMX WHERE  CFLSH0=C.CFLSH0 and sfzby0='N' ) ypzje0,  
(select substrb(SF_BQ_CSRQTONL(C.CSRQ00),1,100) from dual) BRNL00,C.YEXM00 
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.ZYH000='1502494'
 and (C.SFKSLY='-1') 
 AND C.CFZT00 = '2' AND C.FYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
 AND C.YFBMBH=35
 AND C.CFXZ00='0'
 AND C.CZY000=G.YGBH00
 and exists(select 1 from YF_ZYCFMX A,BQ_YPYZ00 B,BQ_YPYZMX E where A.CFLSH0=C.CFLSH0 and A.YZID00=B.YZID00 
 and B.YZID00=E.YZID00 and A.YZMXID=E.YZMXID and B.YZLY00='1' and E.YZCLLB='出院带药')
 ORDER BY C.CFLSH0