1 09:48:12 SQL Execute: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00= K.BMBH00 and D.JZRQ00 >= '20131101' and D.JZRQ00 <= '20131130' and D.JZRQ00||D.JZSJ00 >= '2013110100:00:00' and D.JZRQ00||D.JZSJ00 <= '2013113023:59:59' group by C.YBMC00,E.ZWXM00 2 09:48:12 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131101 3 09:48:12 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131130 4 09:48:12 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 5 09:48:12 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 6 09:48:12 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 09:48:12 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 09:48:12 SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 9 09:48:12 SQL Data In: ORACLE - Param = 8, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 10 09:48:12 SQL Data In: ORACLE - Param = 9, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 09:48:12 SQL Data In: ORACLE - Param = 10, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 09:48:12 SQL Data In: ORACLE - Param = 11, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 13 09:48:12 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 09:48:12 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 09:48:12 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 09:48:12 SQL Data In: ORACLE - Param = 15, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 17 09:48:12 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0); END; 18 09:48:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509466.000000 19 09:48:15 SQL Execute: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(GHKS18),1,20) BRLXMC,A.*,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00,G.BMMC00 KSMC00, (select max(aa.zyh000) from zy_brxxb0 aa where aa.brid00=b.brid00 )MRN000, substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00,F.ZWXM00 JGYS00,A.GHKS21+A.GHKS22 as QZFJE0 ,B.BRZTQK,B.TYDWMC,E.CYRQ00,E.CYSJ00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,BM_YGBM00 F,ZY_BRXXB0 E,BM_BMBM00 G where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and A.GHKS12 = G.BMBH00(+) and a.ghks17=f.ygbh00(+) and A.GHKS18=E.ZYID00(+) and C.YGBH00 <>0 and A.ID0000=? ) order by BMMC00,GHRQ00 20 09:48:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509466.000000 21 09:48:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509466.000000 22 09:48:17 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1, NVL(GHKS04,0)+NVL(GHKS05,0),NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00, sum(GHKS21+GHKS22) QZFJE0,sum(GHKS11)ZYTS00,SUM(GHKS25) YPFY00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00, sum(GHKS21+GHKS22) QZFJE0,sum(GHKS11)ZYTS00,SUM(GHKS25) YPFY00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 23 09:48:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509466.000000 24 09:48:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509466.000000 25 09:48:17 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00, sum(GHKS21+GHKS22) QZFJE0 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),'1',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00, sum(GHKS21+GHKS22) QZFJE0 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 26 09:48:17 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131101 27 09:48:17 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 28 09:48:17 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131130 29 09:48:17 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 30 09:48:17 SQL Data In: ORACLE - Param = 5, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 31 09:48:17 SQL Data In: ORACLE - Param = 6, Name = AS_YBMC00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 32 09:48:17 SQL Data In: ORACLE - Param = 7, Name = AS_JZR000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有记帐人 33 09:48:17 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 34 09:48:17 SQL Data In: ORACLE - Param = 9, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 35 09:48:17 SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 36 09:48:17 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 09:48:17 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 09:48:17 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 09:48:17 SQL Data In: ORACLE - Param = 14, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 40 09:48:17 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0); END; 41 09:48:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 811511.000000 42 09:48:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 811511.000000 43 09:48:21 SQL Execute: ORACLE - select * from ( select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,C.YBZYH0,(select pjxh00 from zy_pjsyqk k where k.fzpjh0=b.pjh000 and pjzt00='0' and rownum=1) PJXH00 ,DECODE(C.RYLB00,'生育',D.BRXM00||'(生育)','生育实时刷卡住院',D.BRXM00||'(生育)','工伤',D.BRXM00||'(工伤)',D.BRXM00) BRXM00, D.BRXB00,D.BRZTQK,D.TYDWMC,C.RYRQ00,C.CYDJRQ,A.SFXM02 ZYTS00, (B.HJJE00/decode(nvl(A.SFXM02,1),0,1,nvl(A.SFXM02,1))) PJFY00 ,B.HJJE00,B.JZJE00, B.GFJE00,B.GRZHZF,B.TCJJZF,B.ZFJE00,B.SBGRZH,B.SBTCJJ,B.JJZFE0,B.SYBXZF,B.SBZFE0,B.BJZFE0,B.GWYBZ0,F.ZWXM00, A.ID0000,A.BMBH00,A.XMHJ00,A.YPHJ00,A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20,A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26, A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31,A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36, A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42,A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46, A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53,A.SFXM54,A.SFXM55,A.SFXM56, A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64,A.SFXM65,A.SFXM66, A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75,A.SFXM76, A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96, A.SFXM97,A.SFXM98,A.SFXM99,A.BMMC00,A.SJYSXM from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,BM_BRXXB0 D,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G,BM_BMBM00 H where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND C.BRID00=D.BRID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND C.DQKS00=H.BMBH00 AND A.ID0000=? order by D.YBKH00 ) union all select '合 计','合计记录数:'||to_char(count(B.ZYID00)), '合计病人数:'||to_char(count(distinct B.ZYID00)),null,null,null,null,null,null,NULL,NULL,NULL,null,NULL,sum(nvl(A.SFXM02,0)),sum(B.HJJE00)/decode(sum(nvl(A.SFXM02,1)),0,1,sum(nvl(A.SFXM02,1))),sum(B.HJJE00),sum(B.JZJE00), sum(B.GFJE00),sum(B.GRZHZF),sum(B.TCJJZF),sum(B.ZFJE00),sum(B.SBGRZH),sum(B.SBTCJJ),sum(B.JJZFE0),sum(B.SYBXZF),SUM(B.SBZFE0),SUM(B.BJZFE0),SUM(B.GWYBZ0),NULL,0,0,0,0,0,0, sum(A.SFXM03),sum(A.SFXM04),sum(A.SFXM05),sum(A.SFXM06), sum(A.SFXM07),sum(A.SFXM08),sum(A.SFXM09),sum(A.SFXM10),sum(A.SFXM11),sum(A.SFXM12),sum(A.SFXM13),sum(A.SFXM14),sum(A.SFXM15),sum(A.SFXM16), sum(A.SFXM17),sum(A.SFXM18),sum(A.SFXM19),sum(A.SFXM20), sum(A.SFXM21),sum(A.SFXM22),sum(A.SFXM23),sum(A.SFXM24),sum(A.SFXM25),sum(A.SFXM26),sum(A.SFXM27),sum(A.SFXM28),sum(A.SFXM29),sum(A.SFXM30),sum(A.SFXM31), sum(A.SFXM32),sum(A.SFXM33),sum(A.SFXM34),sum(A.SFXM35),sum(A.SFXM36),sum(A.SFXM37),sum(A.SFXM38),sum(A.SFXM39),sum(A.SFXM40),sum(A.SFXM41),sum(A.SFXM42), sum(A.SFXM43),sum(A.SFXM44),sum(A.SFXM45),sum(A.SFXM46),sum(A.SFXM47),sum(A.SFXM48),sum(A.SFXM49),sum(A.SFXM50),sum(A.SFXM51),sum(A.SFXM52),sum(A.SFXM53), sum(A.SFXM54),sum(A.SFXM55),sum(A.SFXM56),sum(A.SFXM57),sum(A.SFXM58),sum(A.SFXM59),sum(A.SFXM60),sum(A.SFXM61),sum(A.SFXM62),sum(A.SFXM63),sum(A.SFXM64), sum(A.SFXM65),sum(A.SFXM66),sum(A.SFXM67),sum(A.SFXM68),sum(A.SFXM69),sum(A.SFXM70),sum(A.SFXM71),sum(A.SFXM72),sum(A.SFXM73),sum(A.SFXM74),sum(A.SFXM75), sum(A.SFXM76),sum(A.SFXM77),sum(A.SFXM78),sum(A.SFXM79),sum(A.SFXM80),SUM(A.SFXM81),SUM(A.SFXM82),SUM(A.SFXM83),SUM(A.SFXM84),SUM(A.SFXM85),SUM(A.SFXM86), sum(A.SFXM87),sum(A.SFXM88),sum(A.SFXM89),sum(A.SFXM90),sum(A.SFXM91),SUM(A.SFXM92),SUM(A.SFXM93),SUM(A.SFXM94),SUM(A.SFXM95),SUM(A.SFXM96),SUM(A.SFXM97),SUM(A.SFXM98),SUM(A.SFXM99),null,null from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND A.ID0000=? 44 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-19 45 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-18 46 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-17 47 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-16 48 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-15 49 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-14 50 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-13 51 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-12 52 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-11 53 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-10 54 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-9 55 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-8 56 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-7 57 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-6 58 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-5 59 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-4 60 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-3 61 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-2 62 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-1 63 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=0 64 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=1 65 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=2 66 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=3 67 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=4 68 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=5 69 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=6 70 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=7 71 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=8 72 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=9 73 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=10 74 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=11 75 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=12 76 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=13 77 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=14 78 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=15 79 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=16 80 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=17 81 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=18 82 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=19 83 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=20 84 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=21 85 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=22 86 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=23 87 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=24 88 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=25 89 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=26 90 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=27 91 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=28 92 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=29 93 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=30 94 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=31 95 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=32 96 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=33 97 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=34 98 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=35 99 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=36 100 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=37 101 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=38 102 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=39 103 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=40 104 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=41 105 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=42 106 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=43 107 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=44 108 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=45 109 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=46 110 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=47 111 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=48 112 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=49 113 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=50 114 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=51 115 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=52 116 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=53 117 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=54 118 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=55 119 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=56 120 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=57 121 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=58 122 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=59 123 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=60 124 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=61 125 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=62 126 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=63 127 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=64 128 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=65 129 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=66 130 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=67 131 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=68 132 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=69 133 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=70 134 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=71 135 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=72 136 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=73 137 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=74 138 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=75 139 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=76 140 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=77 141 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=78 142 09:48:22 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=79 143 09:48:22 SQL Execute: ORACLE - select C.YBMC00,count(distinct F.ZYID00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20131101' and D.JZRQ00 <= '20131130' and D.JZRQ00||D.JZSJ00 >= '2013110100:00:00' and D.JZRQ00||D.JZSJ00 <= '2013113023:59:59' group by C.YBMC00 having sum(D.BRZJE0)<>0 union all select '合计',COUNT(distinct f.zyid00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20131101' and D.JZRQ00 <= '20131130' and D.JZRQ00||D.JZSJ00 >= '2013110100:00:00' and D.JZRQ00||D.JZSJ00 <= '2013113023:59:59' 144 09:48:22 SQL Execute: ORACLE - select C.YBMC00,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00, sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0, sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.RYLB00 IN ('生育','生育实时刷卡住院','工伤') and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20131101' and D.JZRQ00 <= '20131130' and D.JZRQ00||D.JZSJ00 >= '2013110100:00:00' and D.JZRQ00||D.JZSJ00 <= '2013113023:59:59' group by C.YBMC00 145 09:48:22 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131101 146 09:48:22 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20131130 147 09:48:22 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 148 09:48:22 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 149 09:48:22 SQL Data In: ORACLE - Param = 5, Name = AS_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 150 09:48:22 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 151 09:48:22 SQL Data In: ORACLE - Param = 7, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 152 09:48:22 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 153 09:48:22 SQL Data In: ORACLE - Param = 9, Name = AS_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 154 09:48:22 SQL Data In: ORACLE - Param = 10, Name = AS_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 155 09:48:22 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 156 09:48:22 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 157 09:48:22 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 158 09:48:22 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_DBZTJB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_BRYBZX => :AS_BRYBZX,AS_YBZXMC => :AS_YBZXMC,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_TJFS00 => :AS_TJFS00,AS_SFDZX0 => :AS_SFDZX0,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 159 09:48:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509467.000000 160 09:48:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509467.000000 161 09:48:22 SQL Execute: ORACLE - SELECT B.BMMC00,BEIZHU,GHRQ00,count(*) RS0000,sum(XMHJ00) XMHJ00,sum(GHKS03) GHKS03,sum(GHKS09) GHKS09,sum(GHKS04) GHKS04,sum(GHKS05) GHKS05,sum(GHKS06) GHKS06,sum(GHKS07) GHKS07,sum(GHKS12) GHKS12,sum(GHKS13) GHKS13,sum(GHKS17) GHKS17 FROM BM_GHKSTJ A,BM_BMBM00 B,BM_YGBM00 C,BM_BRXXB0 D where A.ID0000 =? and GHKS01 > 0 and GHKS01 = D.BRID00(+) AND GHKS02 = C.YGBH00(+) and A.GHKS10 = B.BMBH00(+) group by B.BMMC00,BEIZHU,GHRQ00 Union all select ' 合计'BMMC00, NULL BEIZHU,NULL GHRQ00,COUNT(*) RS0000,sum(XMHJ00) XMHJ00,sum(GHKS03) GHKS03,sum(GHKS09) GHKS09,sum(GHKS04) GHKS04,sum(GHKS05) GHKS05,sum(GHKS06) GHKS06,sum(GHKS07) GHKS07,sum(GHKS12) GHKS12,sum(GHKS13) GHKS13,sum(GHKS17) GHKS17 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and A.GHKS01 > 0 and A.ID0000 =? order by BMMC00 162 09:48:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509467.000000 163 09:48:22 SQL Execute: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(dyid00),1,20) BRLXMC,A.*,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00, D.BMMC00, (select aa.zyh000 from zy_brxxb0 aa where aa.brid00=b.brid00 and rownum=1 )MRN000, substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00 ,B.BRZTQK,B.TYDWMC,E.CYRQ00,E.CYSJ00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C, bm_bmbm00 D, ZY_BRXXB0 E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and A.dyid00=E.ZYID00(+) and C.YGBH00 <>0 and A.ID0000=? ) order by BMMC00,GHRQ00