1 09:47:12 SQL Execute: ORACLE - Select value0,name00 from xt_xtcs00 where name00 in ('BQ_YZTZTS','BQ_CGGZTS','BQ_CWGZTS','BQ_DBGZTS') 2 09:47:12 SQL Execute: ORACLE - Select * from xt_yyxt00 where XTDM00='E' 3 09:47:12 SQL Execute: ORACLE - select BH0000 from bm_tyzd00 where zdmc00 ='限制转区借床的病区' 4 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 5 09:47:12 SQL Execute: ORACLE - select RYCWH0,ZYH000,XM0000,ZYID00,RYZD00,TRUNC(SYSDATE)-TO_DATE(RYRQ00,'YYYYMMDD')"ZYTS00",ZZYS00,ZZYSXM from ZY_BRXXB0 a where 1=1 and DQBQ00=? and BRZT00 in ('20') order by rycwh0 6 09:47:12 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 09:47:12 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 2003249 8 09:47:12 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 09:47:12 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 09:47:12 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 09:47:12 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 09:47:12 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 09:47:12 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 09:47:12 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 09:47:12 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 09:47:12 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 09:47:12 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 09:47:12 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 09:47:12 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 09:47:12 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 09:47:12 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; 22 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 23 09:47:12 SQL Execute: ORACLE - select p.xmmc00,sum(y.hjje00)hjje00,sum(y.zfje00)zfje00, sum(y.jzje00)jzje00,sum(y.gfje00)gfje00 from zy_fymx00 y,bm_yysfxm s,zy_brfy00 f,bm_fpxm00 p where y.xmbh00=s.sfxmid and f.djh000=y.djh000 and s.zyfpid=p.fpxmid and f.zyid00=? group by p.xmmc00 24 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 25 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 26 09:47:12 SQL Execute: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=? AND BQH000=? AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 27 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 28 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 29 09:47:12 SQL Execute: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=? AND BQH000=? and yzzt00 in ('1','2') 30 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 31 09:47:12 SQL Execute: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=? AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 32 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 33 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 34 09:47:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 35 09:47:12 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=? AND Z.BQH000=? AND Z.YZID00=D.YZID00 AND D.ZYID00=? order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 36 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 37 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 38 09:47:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 39 09:47:12 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 40 09:47:12 SQL Execute: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =? and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = ? and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 41 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 42 09:47:12 SQL Execute: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND zyid00=? and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 43 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 44 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 45 09:47:12 SQL Execute: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药','3','药械')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 46 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 47 09:47:12 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 48 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 49 09:47:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 50 09:47:12 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00 in ('0','1') AND Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND YJLRBZ='N' order by kdrq00 51 09:47:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 52 09:47:12 SQL Execute: ORACLE - select 0 YPQLPC,C.CFLSH0,YPMC00,YPGG00, TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00, TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND CFZT00 IN ('0') AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ NOT IN ('4','5','6','7') 53 09:47:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 54 09:47:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 55 09:47:13 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00,KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ,DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,Y.YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1' and xmzt00 in ('0','1') AND (kdbq00=? and YJLRBZ='Y' or YJLRBZ='S') and zyghid=? and nvl(cxdjh0,0)=0 56 09:47:15 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 57 09:47:15 SQL Data In: ORACLE - Param = 2, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 58 09:47:15 SQL Data In: ORACLE - Param = 3, Name = PYPYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/17/2020 0:0:0:0 59 09:47:15 SQL Data In: ORACLE - Param = 4, Name = PFYYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/17/2020 0:0:0:0 60 09:47:15 SQL Data In: ORACLE - Param = 5, Name = PPTXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/17/2020 0:0:0:0 61 09:47:15 SQL Data In: ORACLE - Param = 6, Name = PCWXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/17/2020 0:0:0:0 62 09:47:15 SQL Data In: ORACLE - Param = 7, Name = PDBXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/17/2020 0:0:0:0 63 09:47:15 SQL Data In: ORACLE - Param = 8, Name = PWTQYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 09:47:15 SQL Data In: ORACLE - Param = 9, Name = PWZXYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 65 09:47:15 SQL Data In: ORACLE - Param = 10, Name = PWZXYJS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 09:47:15 SQL Data In: ORACLE - Param = 11, Name = PWGZCGS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 67 09:47:15 SQL Data In: ORACLE - Param = 12, Name = PWGZCWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 09:47:15 SQL Data In: ORACLE - Param = 13, Name = PWGZDBS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 09:47:15 SQL Data In: ORACLE - Param = 14, Name = PWYJYWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 09:47:15 SQL Execute: ORACLE - BEGIN "SP_BQ_CYYZPD" (PZYID00 => :PZYID00,PBQH000 => :PBQH000,PYPYZJZ => :PYPYZJZ,PFYYZJZ => :PFYYZJZ,PPTXMJZ => :PPTXMJZ,PCWXMJZ => :PCWXMJZ,PDBXMJZ => :PDBXMJZ,PWTQYPS => :PWTQYPS,PWZXYPS => :PWZXYPS,PWZXYJS => :PWZXYJS,PWGZCGS => :PWGZCGS,PWGZCWS => :PWGZCWS,PWGZDBS => :PWGZDBS,PWYJYWS => :PWYJYWS); END; 71 09:47:16 SQL Execute: ORACLE - Update Bq_ypyz00 Set tzrq00=to_char(SysDate,'YYYYMMDD'),tzsj00=to_char(SysDate,'HH24:MI:SS'),yzzt00='3',tzys00=kzys00,tzrxm0='陈月娥' where yzzt00 in ('2','1') and zyid00=2229155 and decode(yzzt00,'1',to_char(to_date(qyrq00,'YYYYMMDD')-1,'YYYYMMDD'),'2',tqrq00)>='20200517' 72 09:47:16 SQL Data In: ORACLE - Rows affected = 11 73 09:47:16 SQL Execute: ORACLE - commit 74 09:47:16 SQL Data In: ORACLE - Rows affected = 0 75 09:47:18 SQL Execute: ORACLE - Update Bq_yjyz00 Set tzrq00=to_char(SysDate,'YYYYMMDD'),tzsj00=to_char(SysDate,'HH24:MI:SS'),yzzt00='3',tzys00=kzys00,tzrxm0='陈月娥' where yzzt00 in ('2','1') and zyid00=2229155 and decode(yzzt00,'1',to_char(to_date(qyrq00,'YYYYMMDD')-1,'YYYYMMDD'),'2',tqrq00)>='20200517' 76 09:47:18 SQL Data In: ORACLE - Rows affected = 23 77 09:47:18 SQL Execute: ORACLE - commit 78 09:47:18 SQL Data In: ORACLE - Rows affected = 0 79 09:47:18 SQL Execute: ORACLE - Select count(*) from bq_jzxm00 where tzrq00 is null and zyid00=2229155 80 09:47:19 SQL Execute: ORACLE - Update Bq_jzxm00 set tzrq00=to_char(SysDate,'YYYYMMDD'),tzsj00=to_char(SysDate,'HH24:MI:SS'),tzrxm0='陈月娥' where tzrq00 is null and zyid00=2229155 81 09:47:19 SQL Data In: ORACLE - Rows affected = 4 82 09:47:19 SQL Execute: ORACLE - commit 83 09:47:19 SQL Data In: ORACLE - Rows affected = 0 84 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 85 09:47:19 SQL Execute: ORACLE - select p.xmmc00,sum(y.hjje00)hjje00,sum(y.zfje00)zfje00, sum(y.jzje00)jzje00,sum(y.gfje00)gfje00 from zy_fymx00 y,bm_yysfxm s,zy_brfy00 f,bm_fpxm00 p where y.xmbh00=s.sfxmid and f.djh000=y.djh000 and s.zyfpid=p.fpxmid and f.zyid00=? group by p.xmmc00 86 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 87 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 88 09:47:19 SQL Execute: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=? AND BQH000=? AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 89 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 90 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 91 09:47:19 SQL Execute: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=? AND BQH000=? and yzzt00 in ('1','2') 92 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 93 09:47:19 SQL Execute: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=? AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 94 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 95 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 96 09:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 97 09:47:19 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=? AND Z.BQH000=? AND Z.YZID00=D.YZID00 AND D.ZYID00=? order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 98 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 99 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 100 09:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 101 09:47:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 102 09:47:19 SQL Execute: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =? and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = ? and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 103 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 104 09:47:19 SQL Execute: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND zyid00=? and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 105 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 106 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 107 09:47:19 SQL Execute: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药','3','药械')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 108 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 109 09:47:19 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 110 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 111 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 112 09:47:19 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00 in ('0','1') AND Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND YJLRBZ='N' order by kdrq00 113 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 114 09:47:19 SQL Execute: ORACLE - select 0 YPQLPC,C.CFLSH0,YPMC00,YPGG00, TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00, TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND CFZT00 IN ('0') AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ NOT IN ('4','5','6','7') 115 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 116 09:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 117 09:47:19 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00,KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ,DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,Y.YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1' and xmzt00 in ('0','1') AND (kdbq00=? and YJLRBZ='Y' or YJLRBZ='S') and zyghid=? and nvl(cxdjh0,0)=0 118 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 119 09:47:19 SQL Execute: ORACLE - select BMMC00,BH0000,pysm00,wbsm00,BMBH00 from VW_BQ_BQBM00 where bmbh00<>? order by Bh0000 120 09:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39.000000 121 09:47:19 SQL Execute: ORACLE - select BMMC00,BH0000,pysm00,wbsm00,BMBH00 FROM BM_BMBM00 WHERE FLAG00='1' AND (CZBZ00='1'or CZBZ00='0') AND BMXZ00='0'AND BMBH00 IN (SELECT KSH000 FROM BM_BQKS00 where BQH000=?) 122 09:47:19 SQL Execute: ORACLE - select yszid0,yszmc0 from zs_ysz000 a where ssksbh=34 and yszzt0<>'3' order by xsxh00 123 09:47:19 SQL Execute: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='2229155' and a.yszid0=b.yszid0 124 09:47:24 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2229155.000000 125 09:47:24 SQL Data In: ORACLE - Param = 2, Name = PZCBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 126 09:47:24 SQL Data In: ORACLE - Param = 3, Name = PZRBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39.000000 127 09:47:24 SQL Data In: ORACLE - Param = 4, Name = PKSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 128 09:47:24 SQL Data In: ORACLE - Param = 5, Name = PZKYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 624.000000 129 09:47:24 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1018.000000 130 09:47:24 SQL Data In: ORACLE - Param = 7, Name = PZKJCBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 131 09:47:24 SQL Execute: ORACLE - BEGIN "SP_BQ_BRZKDJ" (PZYID00 => :PZYID00,PZCBQ00 => :PZCBQ00,PZRBQ00 => :PZRBQ00,PKSH000 => :PKSH000,PZKYS00 => :PZKYS00,PCZY000 => :PCZY000,PZKJCBZ => :PZKJCBZ); END; 132 09:47:25 SQL Execute: ORACLE - Select value0,name00 from xt_xtcs00 where name00 in ('BQ_YZTZTS','BQ_CGGZTS','BQ_CWGZTS','BQ_DBGZTS') 133 09:47:25 SQL Execute: ORACLE - Select * from xt_yyxt00 where XTDM00='E' 134 09:47:25 SQL Execute: ORACLE - select BH0000 from bm_tyzd00 where zdmc00 ='限制转区借床的病区' 135 09:47:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 136 09:47:25 SQL Execute: ORACLE - select RYCWH0,ZYH000,XM0000,ZYID00,RYZD00,TRUNC(SYSDATE)-TO_DATE(RYRQ00,'YYYYMMDD')"ZYTS00",ZZYS00,ZZYSXM from ZY_BRXXB0 a where 1=1 and DQBQ00=? and BRZT00 in ('20') order by rycwh0 137 09:47:25 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 138 09:47:25 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 2002445 139 09:47:25 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 140 09:47:25 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 141 09:47:25 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 142 09:47:25 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 143 09:47:25 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 144 09:47:25 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 145 09:47:25 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 146 09:47:25 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 147 09:47:25 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 148 09:47:25 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 149 09:47:25 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 150 09:47:25 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 151 09:47:25 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 152 09:47:25 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; 153 09:47:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 154 09:47:25 SQL Execute: ORACLE - select p.xmmc00,sum(y.hjje00)hjje00,sum(y.zfje00)zfje00, sum(y.jzje00)jzje00,sum(y.gfje00)gfje00 from zy_fymx00 y,bm_yysfxm s,zy_brfy00 f,bm_fpxm00 p where y.xmbh00=s.sfxmid and f.djh000=y.djh000 and s.zyfpid=p.fpxmid and f.zyid00=? group by p.xmmc00 155 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 156 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 157 09:47:26 SQL Execute: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=? AND BQH000=? AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 158 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 159 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 160 09:47:26 SQL Execute: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=? AND BQH000=? and yzzt00 in ('1','2') 161 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 162 09:47:26 SQL Execute: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=? AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 163 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 164 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 165 09:47:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 166 09:47:26 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=? AND Z.BQH000=? AND Z.YZID00=D.YZID00 AND D.ZYID00=? order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 167 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 168 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 169 09:47:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 170 09:47:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 171 09:47:26 SQL Execute: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =? and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = ? and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 172 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 173 09:47:26 SQL Execute: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND zyid00=? and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 174 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 175 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 176 09:47:26 SQL Execute: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药','3','药械')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 177 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 178 09:47:26 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 179 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 180 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 181 09:47:26 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00 in ('0','1') AND Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND YJLRBZ='N' order by kdrq00 182 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 183 09:47:26 SQL Execute: ORACLE - select 0 YPQLPC,C.CFLSH0,YPMC00,YPGG00, TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00, TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(m.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND CFZT00 IN ('0') AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ NOT IN ('4','5','6','7') 184 09:47:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 185 09:47:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2198955.000000 186 09:47:26 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00,KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ,DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000,Y.YJKSBH FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1' and xmzt00 in ('0','1') AND (kdbq00=? and YJLRBZ='Y' or YJLRBZ='S') and zyghid=? and nvl(cxdjh0,0)=0