1 11:26:31 SQL Prepare: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00); END; 2 11:26:31 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71.000000 3 11:26:31 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4 11:26:31 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 5 11:26:31 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 6 11:26:31 SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 11:26:31 SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 8 11:26:31 SQL Data In: ORACLE - Param = 7, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/31/2009 0:0:0:0 9 11:26:31 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00); END; 10 11:30:31 SQL Prepare: ORACLE - BEGIN "SP_BQ_YJYZZX_NOHL" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PLBBH00 => :PLBBH00,PZXRQ00 => :PZXRQ00,PBCTQID => :PBCTQID); END; 11 11:30:31 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71.000000 12 11:30:31 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 11:30:31 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 14 11:30:31 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 11:30:31 SQL Data In: ORACLE - Param = 5, Name = PLBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 16 11:30:31 SQL Data In: ORACLE - Param = 6, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/31/2009 0:0:0:0 17 11:30:31 SQL Data In: ORACLE - Param = 7, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 11:30:31 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZZX_NOHL" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PLBBH00 => :PLBBH00,PZXRQ00 => :PZXRQ00,PBCTQID => :PBCTQID); END; 19 11:30:31 SQL Prepare: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=:1 and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((:2),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=:3 and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND ( (YZZT00='1' AND (:4)>=QSRQSJ) OR(YZZT00='2' AND (:5)>TQRQSJ ) ) ORDER BY RYCWH0 20 11:30:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 21 11:30:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 15:0:0:0 22 11:30:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 23 11:30:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 23:0:0:0 24 11:30:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 23:0:0:0 25 11:30:31 SQL Execute: ORACLE - SELECT DISTINCT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YZZXJL_XYZX W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.QSRQ00<=TO_CHAR((?),'YYYYMMDD') UNION SELECT B.RYCWH0,B.ZYH000,B.XM0000,B.ZYID00 FROM ZY_BRXXB0 B,VW_BQ_YJYZ00_WTZ W WHERE DQBQ00=? and brzt00 like '2%' AND B.ZYID00=W.ZYID00 AND W.YZLB00<>1 AND ( (YZZT00='1' AND (?)>=QSRQSJ) OR(YZZT00='2' AND (?)>TQRQSJ ) ) ORDER BY RYCWH0 26 11:30:31 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 27 11:30:31 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 28 11:30:31 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 63540 29 11:30:31 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 30 11:30:31 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 11:30:31 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 11:30:31 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 11:30:31 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 11:30:31 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 35 11:30:31 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 36 11:30:31 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 11:30:31 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 11:30:31 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 11:30:31 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 40 11:30:31 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 11:30:31 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 11:30:31 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 43 11:30:31 SQL Prepare: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=:1 AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((:2),'YYYYMMDD') AND ZYID00=:3 ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 44 11:30:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 188674.000000 45 11:30:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 15:0:0:0 46 11:30:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 188674.000000 47 11:30:31 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托') order by tqrqsj,clbz00,lbmc00,yzid00 48 11:30:31 SQL Prepare: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID FROM VW_BQ_YJYZ00_WTZ WHERE ZYID00=:1 AND YZLB00<>1 and ( (YZZT00='1' AND (:2)-QSRQSJ>=0) OR(YZZT00='2' AND (:3)-TQRQSJ>0) ) order by tqrqsj,clbz00,lbmc00,yzmxid 49 11:30:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 188674.000000 50 11:30:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 23:0:0:0 51 11:30:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/31/2009 23:0:0:0 52 11:30:31 SQL Execute: ORACLE - SELECT DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID FROM VW_BQ_YJYZ00_WTZ WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) order by tqrqsj,clbz00,lbmc00,yzmxid