1 09:50:59 Log started for: 药房管理系统 2 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=c.brid00) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=c.brid00) LXRSFZ, C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00, C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00, C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00,C.DMCFBH, (select substrb(SF_BQ_CSRQTONL(C.CSRQ00),1,100) from dual) BRNL00,C.YEXM00 FROM YF_ZYCF00 C,BM_YGBM00 G WHERE C.ZYH000='382978' and ((C.SFKSLY='-1') or ('-1'='-1')) AND C.YFBMBH=45 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 C.ZYID00=D.ZYID00 AND CFZT00 in ('0','1') ))) AND C.CFXZ00<>'0' AND C.CZY000=G.YGBH00 3 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 4 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 5 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 6 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 7 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 8 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 9 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 10 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 11 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 12 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 13 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 14 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 15 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 16 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 17 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 18 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 19 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 20 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 21 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 22 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 23 09:51:37 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 24 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 25 09:51:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1686684 26 09:51:37 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00, YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0, HSKPPH,ZFBL00,YBLB00,ZB0000 FROM YF_ZYCFMX WHERE CFLSH0=? AND SFZBY0='N' 27 09:51:37 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 28 09:51:37 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 29 09:51:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 30 09:51:37 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,YGBH00,BMBH00 from VW_YF_YGYYBMQX where (PYSM00 Like ?) and( BMBH00=45 ) Order By PYSM00) where Rownum<=10000 31 09:51:39 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',341,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =341 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 32 09:51:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1686687 33 09:51:47 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00, YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0, HSKPPH,ZFBL00,YBLB00,ZB0000 FROM YF_ZYCFMX WHERE CFLSH0=? AND SFZBY0='N' 34 09:51:47 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 35 09:51:47 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 36 09:51:49 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',341,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =341 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 37 09:51:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1686684 38 09:51:50 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00, YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0, HSKPPH,ZFBL00,YBLB00,ZB0000 FROM YF_ZYCFMX WHERE CFLSH0=? AND SFZBY0='N' 39 09:51:50 SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=4674535) BRZJBH, (Select BRLXXM from BM_BRXXB0 WHERE brid00=4674535) BRLXXM, (Select LXRSFZ from BM_BRXXB0 WHERE brid00=4674535) LXRSFZ, X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0, X.YXQFJE,BRID00,ZYH000,CH0000 FROM VW_YF_ZYBRZH X WHERE X.BRID00='4674535' and X.ZYID00='1547198' order by X.ZYID00 desc 40 09:51:50 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640101) AS NL FROM DUAL 41 09:51:58 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2928' and CZBZ00<>'2' and BMBH00='55' 42 09:51:58 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 43 09:51:58 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2928' and CZBZ00 in ('1') 44 09:51:58 SQL Execute: ORACLE - Commit 45 09:51:58 SQL Data In: ORACLE - Rows affected = 0 46 09:51:58 SQL Execute: ORACLE - UPDATE YF_ZYCF00 SET LYR000=314 WHERE CFLSH0='1686684' 47 09:51:58 SQL Data In: ORACLE - Rows affected = 1 48 09:51:58 SQL Data In: ORACLE - Param = 1, Name = P_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1686684 49 09:51:58 SQL Data In: ORACLE - Param = 2, Name = P_CFJSZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 50 09:51:58 SQL Data In: ORACLE - Param = 3, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 51 09:51:58 SQL Data In: ORACLE - Param = 4, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 341.000000 52 09:51:58 SQL Data In: ORACLE - Param = 5, Name = P_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 53 09:51:58 SQL Data In: ORACLE - Param = 6, Name = P_BYJFY0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 09:51:58 SQL Execute: ORACLE - BEGIN "SP_YF_ZYCFCL" (P_CFLSH0 => :P_CFLSH0,P_CFJSZT => :P_CFJSZT,P_YFBMBH => :P_YFBMBH,P_CZYBH0 => :P_CZYBH0,P_DJH000 => :P_DJH000,P_BYJFY0 => :P_BYJFY0); END; 55 09:51:58 SQL Execute: ORACLE - ROLLBACK WORK 56 09:51:59 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',341,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =341 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)