1 09:35:58 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 2 09:35:58 SQL Data In: ORACLE - Param = 2, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 3 09:35:58 SQL Data In: ORACLE - Param = 3, Name = PYPYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/7/2022 0:0:0:0 4 09:35:58 SQL Data In: ORACLE - Param = 4, Name = PFYYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/7/2022 0:0:0:0 5 09:35:58 SQL Data In: ORACLE - Param = 5, Name = PPTXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 6 09:35:58 SQL Data In: ORACLE - Param = 6, Name = PCWXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 7 09:35:58 SQL Data In: ORACLE - Param = 7, Name = PDBXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 8 09:35:58 SQL Data In: ORACLE - Param = 8, Name = PWTQYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 09:35:58 SQL Data In: ORACLE - Param = 9, Name = PWZXYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 10 09:35:58 SQL Data In: ORACLE - Param = 10, Name = PWZXYJS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 11 09:35:58 SQL Data In: ORACLE - Param = 11, Name = PWGZCGS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 12 09:35:58 SQL Data In: ORACLE - Param = 12, Name = PWGZCWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 09:35:58 SQL Data In: ORACLE - Param = 13, Name = PWGZDBS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 09:35:58 SQL Data In: ORACLE - Param = 14, Name = PWYJYWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 09:35:58 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 09:35:58 SQL Execute: ORACLE - Select count(*) from bq_jzxm00 where tzrq00 is null and zyid00=463562 17 09:35:59 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=415 or DQKS00=415) order by XXID00 18 09:36:00 SQL Execute: ORACLE - update bq_yzzxjl set zt0000='2' where zyid00=463562 and zt0000='0' 19 09:36:00 SQL Data In: ORACLE - Rows affected = 0 20 09:36:00 SQL Execute: ORACLE - Commit 21 09:36:00 SQL Data In: ORACLE - Rows affected = 0 22 09:36:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 23 09:36:00 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:36:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 25 09:36:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 26 09:36:00 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:36:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 28 09:36:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 29 09:36:00 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:36:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 31 09:36:00 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:36:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 33 09:36:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 34 09:36:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 35 09:36:00 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:36:03 SQL Execute: ORACLE - Select value0,name00 from xt_xtcs00 where name00 in ('BQ_YZTZTS','BQ_CGGZTS','BQ_CWGZTS','BQ_DBGZTS') 37 09:36:03 SQL Execute: ORACLE - Select * from xt_yyxt00 where XTDM00='E' 38 09:36:03 SQL Execute: ORACLE - select BH0000 from bm_tyzd00 where zdmc00 ='限制转区借床的病区' 39 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 40 09:36:03 SQL Execute: ORACLE - select RYCWH0,ZYH000,XM0000,ZYID00,RYZD00,TRUNC(SYSDATE)-TO_DATE(RYRQ00,'YYYYMMDD')"ZYTS00",ZZYS00,ZZYSXM,SYFMRQ from ZY_BRXXB0 a where 1=1 and DQBQ00=? and BRZT00 in ('20') and nvl(a.BRSZXT,'0')='0' order by rycwh0 41 09:36:03 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 09:36:03 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0227021 43 09:36:03 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 09:36:03 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 45 09:36:03 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 09:36:03 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 47 09:36:03 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 48 09:36:03 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 49 09:36:03 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 09:36:03 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 09:36:03 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 09:36:03 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 53 09:36:03 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 09:36:03 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 09:36:03 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 56 09:36:03 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; 57 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 58 09:36:03 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 59 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 60 09:36:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 61 09:36:03 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 62 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 63 09:36:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 64 09:36:03 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') 65 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 66 09:36:03 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 67 09:36:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 68 09:36:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 69 09:36:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 456637.000000 70 09:36:03 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 71 09:36:07 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 09:36:07 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0227707 73 09:36:07 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 74 09:36:07 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 75 09:36:07 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 09:36:07 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 09:36:07 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 09:36:07 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 79 09:36:07 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 80 09:36:07 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 81 09:36:07 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 82 09:36:07 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 83 09:36:07 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 84 09:36:07 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 85 09:36:07 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 86 09:36:07 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; 87 09:36:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 88 09:36:07 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 89 09:36:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 90 09:36:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 91 09:36:07 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 92 09:36:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 93 09:36:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 94 09:36:07 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') 95 09:36:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 96 09:36:07 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 97 09:36:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 98 09:36:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 99 09:36:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 100 09:36:07 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 101 09:36:09 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=415 or DQKS00=415) order by XXID00 102 09:36:09 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 103 09:36:09 SQL Data In: ORACLE - Param = 2, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 104 09:36:09 SQL Data In: ORACLE - Param = 3, Name = PYPYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/7/2022 0:0:0:0 105 09:36:09 SQL Data In: ORACLE - Param = 4, Name = PFYYZJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/7/2022 0:0:0:0 106 09:36:09 SQL Data In: ORACLE - Param = 5, Name = PPTXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 107 09:36:09 SQL Data In: ORACLE - Param = 6, Name = PCWXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 108 09:36:09 SQL Data In: ORACLE - Param = 7, Name = PDBXMJZ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2022 0:0:0:0 109 09:36:09 SQL Data In: ORACLE - Param = 8, Name = PWTQYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 110 09:36:09 SQL Data In: ORACLE - Param = 9, Name = PWZXYPS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 111 09:36:09 SQL Data In: ORACLE - Param = 10, Name = PWZXYJS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 112 09:36:09 SQL Data In: ORACLE - Param = 11, Name = PWGZCGS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 113 09:36:09 SQL Data In: ORACLE - Param = 12, Name = PWGZCWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 114 09:36:09 SQL Data In: ORACLE - Param = 13, Name = PWGZDBS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 115 09:36:09 SQL Data In: ORACLE - Param = 14, Name = PWYJYWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 116 09:36:09 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; 117 09:36:09 SQL Execute: ORACLE - Select count(*) from bq_jzxm00 where tzrq00 is null and zyid00=463562 118 09:36:10 SQL Execute: ORACLE - update bq_yzzxjl set zt0000='2' where zyid00=463562 and zt0000='0' 119 09:36:10 SQL Data In: ORACLE - Rows affected = 0 120 09:36:10 SQL Execute: ORACLE - Commit 121 09:36:10 SQL Data In: ORACLE - Rows affected = 0 122 09:36:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 123 09:36:10 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 124 09:36:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 125 09:36:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 126 09:36:10 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 127 09:36:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 128 09:36:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 129 09:36:10 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') 130 09:36:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 131 09:36:10 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 132 09:36:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 133 09:36:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 415.000000 134 09:36:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 463562.000000 135 09:36:10 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