1 01:00:25 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 2 01:00:25 SQL Data In: ORACLE - Param = 2, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 3 01:00:25 SQL Data In: ORACLE - Param = 3, Name = PYPYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/5/2017 0:0:0:0 4 01:00:25 SQL Data In: ORACLE - Param = 4, Name = PFYYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/5/2017 0:0:0:0 5 01:00:25 SQL Data In: ORACLE - Param = 5, Name = PPTXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/5/2017 0:0:0:0 6 01:00:25 SQL Data In: ORACLE - Param = 6, Name = PCWXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/5/2017 0:0:0:0 7 01:00:25 SQL Data In: ORACLE - Param = 7, Name = PDBXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/5/2017 0:0:0:0 8 01:00:25 SQL Data In: ORACLE - Param = 8, Name = PWTQYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 01:00:25 SQL Data In: ORACLE - Param = 9, Name = PWZXYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 10 01:00:25 SQL Data In: ORACLE - Param = 10, Name = PWZXYJS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 11 01:00:25 SQL Data In: ORACLE - Param = 11, Name = PWGZCGS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 12 01:00:25 SQL Data In: ORACLE - Param = 12, Name = PWGZCWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 01:00:25 SQL Data In: ORACLE - Param = 13, Name = PWGZDBS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 01:00:25 SQL Data In: ORACLE - Param = 14, Name = PWYJYWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 01:00:25 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; 16 01:00:25 SQL Execute: ORACLE - Select count(*) from bq_jzxm00 where tzrq00 is null and zyid00=777489 17 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 18 01:00: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 19 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 20 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 21 01:00:25 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 22 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 23 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 24 01:00:25 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') 25 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 26 01:00:25 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 27 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 28 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 29 01:00:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 30 01:00:25 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 31 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 32 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 33 01:00:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 34 01:00:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 35 01:00:25 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') ) 36 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 37 01:00:25 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') 38 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 39 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 40 01:00:25 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') 41 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 42 01:00:25 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 43 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 44 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 45 01:00:25 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 46 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 47 01:00:25 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') 48 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 49 01:00:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 50 01:00:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 51 01:00:25 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 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,SQKS00 YJKSBH from vw_ss_yw0000 where ZYGHID=? and SSFYBZ in ('0','1') and MZFYBZ in ('0','1') and sszt00<>'1' and srkslb='0' order by bmmc00,KDRQSJ 52 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 53 01:00:25 SQL Execute: ORACLE - select BMMC00,BH0000,pysm00,wbsm00,BMBH00 from VW_BQ_BQBM00 where bmbh00<>? order by Bh0000 54 01:00:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000 55 01:00:25 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=?) 56 01:00:25 SQL Execute: ORACLE - select yszid0,yszmc0 from zs_ysz000 where ssksbh=487 and yszzt0<>'3' order by xsxh00 57 01:00:25 SQL Execute: ORACLE - select a.yszid0,a.yszmc0 from zs_ysz000 a,zy_brxxb0 b where b.zyid00='777489' and a.yszid0=b.yszid0 58 01:00:27 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 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',507,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '507') AND (INSTR (',' || a.jsksbh || ',',',507,') > 0 or a.jsksbh is null) 59 01:00:28 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777489.000000 60 01:00:28 SQL Data In: ORACLE - Param = 2, Name = PZCBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 61 01:00:28 SQL Data In: ORACLE - Param = 3, Name = PZRBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000 62 01:00:28 SQL Data In: ORACLE - Param = 4, Name = PKSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000 63 01:00:28 SQL Data In: ORACLE - Param = 5, Name = PZKYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1282.000000 64 01:00:28 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 65 01:00:28 SQL Data In: ORACLE - Param = 7, Name = PZKJCBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 66 01:00:28 SQL Execute: ORACLE - BEGIN "SP_BQ_BRZKDJ" (PZYID00 => :PZYID00,PZCBQ00 => :PZCBQ00,PZRBQ00 => :PZRBQ00,PKSH000 => :PKSH000,PZKYS00 => :PZKYS00,PCZY000 => :PCZY000,PZKJCBZ => :PZKJCBZ); END; 67 01:00:28 SQL Error: ORACLE - ORA-20010: 病人有未记账的医技单，不能转区！* ORA-06512: 在 "SD_HOSPITAL.SP_BQ_BRZKDJ", line 358 ORA-06512: 在 line 1 68 01:00:28 SQL Error: ORACLE - Unmapped SQL Error Code: 20010