1       10:37:00  Log started for: 药房管理系统


52      10:37:02  SQL Data In: ORACLE - Rows affected = 0
53      10:37:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000
54      10:37:02  SQL Execute: ORACLE - SELECT  CFLSH0, GHH000, BRXM00, XB0000, BRID00, TSYS00, SHBZ00, SHQK00, CSRQ00,YSXM00, GHKS00, ZYTS00, ZYDJS0, GHKSBM, SRRQ01, JZRQ01, CFZJE0, CFZT00,YPDLBH, LRY000, ZZDMC0, BRBLH0, CFDGS0, BZ0000, FYRQ01, FYSJ00, CFZTMC, SRRQ00,SFPD00,GHID00 FROM VW_YF_MZFYCF c
 WHERE C.BRID00=? 
 AND C.YFBMBH=70
 AND ((C.CFZT00 = '1'
 AND C.JZRQ00>TO_CHAR(SYSDATE-1/3-30,'YYYYMMDD')
 AND not exists (SELECT 1 FROM YF_MZCF00 D WHERE C.CFLSH0=D.BCCFH0 AND c.GHID00=d.GHID00 AND CFZT00='0'))
 OR (C.CFZT00 in ('0','4')
 AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3-1,'YYYYMMDD')
 AND C.BCCFH0 IS NULL)
)
 AND C.CFXZ00='0' AND C.SFKSLY='N'
 ORDER BY C.CFLSH0 DESC

55      10:37:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 12104483        
56      10:37:04  SQL Execute: ORACLE - SELECT  '0' check0,A.TSYS00,' ' TSYSMC,CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
       CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC,
       YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00,
TRIM(A.YFSMMC)||TRIM(A.YPYFMC)||TRIM(A.XMYFMC)||
TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=A.PSLBID)) as YYFF00,
YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX A
WHERE  CFLSH0=?  AND SFZBY0='N' AND CXBZ00='Z'
order by ZB0000,CFID00

57      10:37:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31947.000000
58      10:37:04  SQL Execute: ORACLE - select A.XM0000,A.XB0000,A.NL0000,A.YBMC00,A.LASTGH,A.BRBLH0,A.ZYE000
 FROM VW_YF_BRJBXX_MZ A WHERE A.BRID00=?

59      10:37:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29790795.000000
60      10:37:04  SQL Execute: ORACLE - SELECT DTGHCS,GHKSMC FROM VW_YF_GHXX00 WHERE GHID00=?