1 09:30:45 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=431 or DQKS00=431) order by XXID00 2 09:30:46 SQL Data In: ORACLE - Param = 1, Name = PCFLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = S 3 09:30:46 SQL Data In: ORACLE - Param = 2, Name = PYPQLPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 4 09:30:46 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 5 09:30:46 SQL Data In: ORACLE - Param = 4, Name = PCFLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 6 09:30:46 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 7 09:30:46 SQL Execute: ORACLE - BEGIN "SP_BQ_CFZF00" (PCFLB00 => :PCFLB00,PYPQLPC => :PYPQLPC,PBQH000 => :PBQH000,PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000); END; 8 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 9 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 10 09:30:46 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 11 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 12 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 13 09:30:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 14 09:30:46 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 15 09:30:46 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') ) 16 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 17 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 18 09:30:46 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') 19 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 20 09:30:46 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 21 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 22 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 23 09:30:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 24 09:30:46 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 25 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 26 09:30:46 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, decode(thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 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') 27 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 28 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 29 09:30:46 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(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00, decode(m.thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000,c.ysgzh0,c.dqks00 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') 30 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 31 09:30:46 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 32 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 33 09:30:46 SQL Execute: ORACLE - select decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC) XMMC00,c.BAXMID FPXMID,sum(a.HJJE00) HJJE00, sum(a.ZFJE00) ZFJE00 from ZY_FYMX00 a,BM_YYSFXM b,BM_BAXM00 c,ZY_BRFY00 d where a.XMBH00 = b.SFXMID and b.BAXMID = c.BAXMID(+) and d.DJH000 = a.DJH000 and d.ZYID00 =? group by decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC),c.BAXMID order by c.BAXMID 34 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 35 09:30:46 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 36 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 37 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 38 09:30:46 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 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 39 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 40 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 41 09:30:46 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,'2','已收费','已收费')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00='2' and Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND (YJLRBZ='N' or exists (select 1 from xt_xtcs00 where Name00='BQ_SFWZXYJDBNCY' and value0='Y') ) and not exists (select 1 from yj_yw0000 where brid00=y.brid00 and cxdjh0=y.yjdjh0) order by kdrq00 42 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 43 09:30:46 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(c.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') 44 09:30:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 45 09:30:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 46 09:30:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1749814.000000 47 09:30:46 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, (select c.bmmc00 from bm_bmbm00 c where y.kdksbh=c.BMBH00) KDKSMC 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' or YJLRBZ='D')) and zyghid=? and nvl(cxdjh0,0)=0 union all select SSDH00 yjdjh0,SSMC00 ZLXMJC,'1次' SL0000, to_number(NULL) ZJE000,SQKSMC bmmc00,NULL YEXM00, SQYSXM KDYSXM,TO_DATE(SQRQSJ,'yyyymmddhh24:mi:ss') KDRQSJ, DECODE(SSFYBZ,'0','申请','1','计价')XMZT00,to_number(NULL) CXDJH0,NULL bz0000, (select c.bmmc00 from bm_bmbm00 c where y.SQKS00=c.BMBH00) KDKSMC from vw_ss_yw0000 Y where ZYGHID=? and SSFYBZ in ('0','1') and MZFYBZ in ('0','1') and sszt00<>'1' and srkslb='0' order by bmmc00,KDRQSJ 48 09:30:46 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='HKDischargeCheck' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',431,')>0) order by nvl(a.QYKS00,'0') desc 49 09:30:46 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 50 09:30:46 SQL Execute: ORACLE - select MC0000,BH0000 from VW_ZY_matn_type where 1=1 order by XSXH00 51 09:30:47 SQL Execute: ORACLE - select MC0000,BH0000 from VW_ZY_birctrl_type where 1=1 order by XSXH00 52 09:30:47 SQL Execute: ORACLE - select MC0000,BH0000 from VW_ZY_LATECHB_FLAG where 1=1 order by XSXH00 53 09:30:47 SQL Execute: ORACLE - select MC0000,BH0000 from VW_ZY_PRET_FLAG where 1=1 order by XSXH00 54 09:30:47 SQL Execute: ORACLE - select MC0000,BH0000 from VW_ZY_DSCG_WAY where 1=1 order by XSXH00 55 09:30:47 SQL Execute: ORACLE - select to_date(nvl(SYFMRQ,to_char(sysdate,'YYYYMMDD')),'YYYYMMDD') SYFMRQ,to_date(nvl(SJRYRQ,'19800101'),'YYYYMMDD') SJRYRQ from ZY_BRXXB0 where ZYID00=1749814 56 09:30:47 SQL Execute: ORACLE - select * from ss_yw0000 where zyghid=1749814 57 09:30:47 SQL Execute: ORACLE - select MC0000 from bm_tyzd00 where zdmc00 ='拟接收医疗机构名称'