1 09:40:36 SQL Prepare: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(trim(C.YBBHSB),'Y',D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(trim(C.YBBHSB),'Y',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 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 >= '20080101' and D.JZRQ00 <= '20090509' and D.JZRQ00||D.JZSJ00 >= '2008010100:00:00' and D.JZRQ00||D.JZSJ00 <= '2009050923:59:59' group by C.YBMC00,E.ZWXM00 2 09:40:36 SQL Execute: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(trim(C.YBBHSB),'Y',D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(trim(C.YBBHSB),'Y',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 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 >= '20080101' and D.JZRQ00 <= '20090509' and D.JZRQ00||D.JZSJ00 >= '2008010100:00:00' and D.JZRQ00||D.JZSJ00 <= '2009050923:59:59' group by C.YBMC00,E.ZWXM00 3 09:40:36 SQL Prepare: 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,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 4 09:40:36 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 5 09:40:36 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090509 6 09:40:36 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 7 09:40:36 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 8 09:40:36 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 9 09:40:36 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 10 09:40:36 SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 11 09:40:36 SQL Data In: ORACLE - Param = 8, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 12 09:40:36 SQL Data In: ORACLE - Param = 9, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 13 09:40:36 SQL Data In: ORACLE - Param = 10, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 14 09:40:36 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 09:40:36 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 09:40:36 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 09:40:36 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,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 18 09:40:36 SQL Prepare: ORACLE - select * from ( select A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00 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 C.YGBH00 <>0 and A.ID0000=:1 union all select A.*,'','','','','','' 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 C.YGBH00=0 and A.ID0000=:2 ) order by BMMC00,GHRQ00 19 09:40:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 20 09:40:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 21 09:40:36 SQL Execute: ORACLE - select * from ( select A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00 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 C.YGBH00 <>0 and A.ID0000=? union all select A.*,'','','','','','' 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 C.YGBH00=0 and A.ID0000=? ) order by BMMC00,GHRQ00 22 09:40:36 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 23 09:40:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 24 09:40:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 25 09:40:36 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 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(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 26 09:40:36 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 27 09:40:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 28 09:40:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120409.000000 29 09:40:36 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 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(trim(E.YBBHSB),'Y',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))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(trim(E.YBBHSB),'Y',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 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 A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 30 09:40:36 SQL Prepare: 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,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 31 09:40:36 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20080101 32 09:40:36 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 33 09:40:36 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090509 34 09:40:36 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 35 09:40:36 SQL Data In: ORACLE - Param = 5, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 36 09:40:36 SQL Data In: ORACLE - Param = 6, Name = AS_YBMC00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 37 09:40:36 SQL Data In: ORACLE - Param = 7, Name = AS_JZR000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有记帐人 38 09:40:36 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 09:40:36 SQL Data In: ORACLE - Param = 9, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 40 09:40:36 SQL Data In: ORACLE - Param = 10, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 41 09:40:36 SQL Data In: ORACLE - Param = 11, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 09:40:36 SQL Data In: ORACLE - Param = 12, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 09:40:36 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,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 44 09:40:37 SQL Prepare: ORACLE - select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(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) BRXM00,D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYRQ00,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,F.ZWXM00,A.* 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=:1 union all select '合 计',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),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=:2 45 09:40:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113276.000000 46 09:40:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113276.000000 47 09:40:37 SQL Execute: ORACLE - select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(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) BRXM00,D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYRQ00,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,F.ZWXM00,A.* 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=? union all select '合 计',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),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=? 48 09:40:37 SQL Error: ORACLE - ORA-01789: 查询块具有不正确的结果列数 49 09:40:37 SQL Error: ORACLE - Unmapped SQL Error Code: 1789 50 09:40:37 SQL Data In: ORACLE - Rows affected = 0