1 10:37:23 SQL Prepare: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 2 10:37:23 SQL Execute: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 3 10:37:23 SQL Prepare: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 4 10:37:23 SQL Execute: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 5 10:37:23 SQL Prepare: ORACLE - SELECT C.FBMC00,A.LSH000,A.BAH000,A.ZYCS00,A.ZYH000,A.YBKH00,A.JKDAH0,' ' QTYBKH,A.MZYS00,A.BRXM00,A.BRXB00, to_date(A.BRCSRQ,'YYYYMMDD') BRCSRQ,A.YECSTZ,A.YERYTZ, A.BRNL00,A.HYZK00,A.ZY0000,A.BRLY00,NVL(A.CSSF00,'福建') CSSF00,A.CSDS00,A.CSXS00,A.JGSF00,A.JGXS00, A.MZ0000,A.GJ0000,A.SFZH00,A.XZZSF0,A.XZZDQ0,A.XZZXS0,A.XZZXC0,A.XZZDH0,A.XZZYB0,A.JTDZSF,A.JTDZDQ,A.JTDZXS,A.JTDZ01, A.GZDW00,A.GZDH00,A.GZYB00,A.JTDZ00,A.JTDH00,A.JTYB00,A.LXRXM0,A.LXRDZ0,A.LXRDH0,A.LXRGX0, A.ZDFS00,A.RYQK00,to_date(A.RYRQ00,'YYYYMMDD') RYRQ00,A.RYSJ00,A.RYKB00,A.RYKBMC,A.RYBF00, A.RYTJ00,A.RYTJ01,A.RYQZL0,A.RYQZL1, to_date(decode(A.CYRQ00,null,decode(b.cyrq00,'20991231',null,b.cyrq00),A.CYRQ00),'YYYYMMDD') CYRQ00, A.CYSJ00,A.CYKB00,A.CYKBMC,A.CYBF00,A.CYFS00,A.CYFS01,A.ZLLB00,A.ZLLB01,A.ZKKB00,A.ZKKBMC,A.ZKBF00, A.ZZZYZJ,A.ZZZYZ1,A.ZYTS00,to_date(A.QZRQ00,'YYYYMMDD') QZRQ00, A.SRRK00,A.LRRY00,A.LRRYMC,to_date(A.LRRQ00,'YYYYMMDD') LRRQ00,A.CARDNO,A.ZYLSH0,A.EJKS00,A.EJKSMC, A.BLZD00,A.BLH000,A.SSZDWY,A.SFYWGM,A.GMYW00,A.ZYMZCY,A.ZYRYCY,A.HBSAG0,A.HCVAB0,A.HIVAB0, A.MZCYFH,A.RYCYFH,A.SQSHFH,A.LCBLFH,A.FSBLFH, A.QJCS00,A.CGCS00,A.QJFF00,A.QJFF01,A.SFWZ00,A.SFWZ01,A.SFJZ00,A.SFJZ01,A.SFYNQK,A.YNQK01, A.KZR000,A.KZRMC0,A.FZR000,A.FZRMC0,A.ZZYS00,A.ZZYSMC,A.ZYYS00,A.ZYYSMC, A.ZRHS00,A.ZRHSMC,A.JXYS00,A.JXYSMC,A.YJSYS0,A.YJSMC0,A.SXYS00,A.SXYSMC,A.ZKYS00,A.ZKYSMC,A.ZKHS00,A.ZKHSMC,A.BAZT00,A.BAZL00, A.XX0000,A.LXRDZ1,A.RH0000,A.SFSJ00,A.BLZDBM,to_date(A.ZKRQ00,'YYYYMMDD') ZKRQ00 FROM BA_BRZYXX A, ZY_BRXXB0 B,BM_BRFBB0 C WHERE A.LSH000=B.ZYID00 AND A.LSH000=:1 and B.FBBH00=C.FBBH00 6 10:37:23 SQL Execute: ORACLE - SELECT C.FBMC00,A.LSH000,A.BAH000,A.ZYCS00,A.ZYH000,A.YBKH00,A.JKDAH0,' ' QTYBKH,A.MZYS00,A.BRXM00,A.BRXB00, to_date(A.BRCSRQ,'YYYYMMDD') BRCSRQ,A.YECSTZ,A.YERYTZ, A.BRNL00,A.HYZK00,A.ZY0000,A.BRLY00,NVL(A.CSSF00,'福建') CSSF00,A.CSDS00,A.CSXS00,A.JGSF00,A.JGXS00, A.MZ0000,A.GJ0000,A.SFZH00,A.XZZSF0,A.XZZDQ0,A.XZZXS0,A.XZZXC0,A.XZZDH0,A.XZZYB0,A.JTDZSF,A.JTDZDQ,A.JTDZXS,A.JTDZ01, A.GZDW00,A.GZDH00,A.GZYB00,A.JTDZ00,A.JTDH00,A.JTYB00,A.LXRXM0,A.LXRDZ0,A.LXRDH0,A.LXRGX0, A.ZDFS00,A.RYQK00,to_date(A.RYRQ00,'YYYYMMDD') RYRQ00,A.RYSJ00,A.RYKB00,A.RYKBMC,A.RYBF00, A.RYTJ00,A.RYTJ01,A.RYQZL0,A.RYQZL1, to_date(decode(A.CYRQ00,null,decode(b.cyrq00,'20991231',null,b.cyrq00),A.CYRQ00),'YYYYMMDD') CYRQ00, A.CYSJ00,A.CYKB00,A.CYKBMC,A.CYBF00,A.CYFS00,A.CYFS01,A.ZLLB00,A.ZLLB01,A.ZKKB00,A.ZKKBMC,A.ZKBF00, A.ZZZYZJ,A.ZZZYZ1,A.ZYTS00,to_date(A.QZRQ00,'YYYYMMDD') QZRQ00, A.SRRK00,A.LRRY00,A.LRRYMC,to_date(A.LRRQ00,'YYYYMMDD') LRRQ00,A.CARDNO,A.ZYLSH0,A.EJKS00,A.EJKSMC, A.BLZD00,A.BLH000,A.SSZDWY,A.SFYWGM,A.GMYW00,A.ZYMZCY,A.ZYRYCY,A.HBSAG0,A.HCVAB0,A.HIVAB0, A.MZCYFH,A.RYCYFH,A.SQSHFH,A.LCBLFH,A.FSBLFH, A.QJCS00,A.CGCS00,A.QJFF00,A.QJFF01,A.SFWZ00,A.SFWZ01,A.SFJZ00,A.SFJZ01,A.SFYNQK,A.YNQK01, A.KZR000,A.KZRMC0,A.FZR000,A.FZRMC0,A.ZZYS00,A.ZZYSMC,A.ZYYS00,A.ZYYSMC, A.ZRHS00,A.ZRHSMC,A.JXYS00,A.JXYSMC,A.YJSYS0,A.YJSMC0,A.SXYS00,A.SXYSMC,A.ZKYS00,A.ZKYSMC,A.ZKHS00,A.ZKHSMC,A.BAZT00,A.BAZL00, A.XX0000,A.LXRDZ1,A.RH0000,A.SFSJ00,A.BLZDBM,to_date(A.ZKRQ00,'YYYYMMDD') ZKRQ00 FROM BA_BRZYXX A, ZY_BRXXB0 B,BM_BRFBB0 C WHERE A.LSH000=B.ZYID00 AND A.LSH000=? and B.FBBH00=C.FBBH00 7 10:37:23 SQL Prepare: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, A.ZDM000 JBBM00,' ' XHBM00,A.ZDMC00 JBMC00,A.FZBM00,A.FZMC00, to_date(decode(A.ZDRQ00,'00000000','',A.ZDRQ00),'YYYYMMDD') ZDRQ00, A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, a.M16800 ,a.RYBQ00 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ZLXG00 D, XT_SFYZ00 E WHERE A.zyid00=:1 AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and A.ZDFS00='1' order by B.PLXH00,A.ID0000 8 10:37:23 SQL Execute: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, A.ZDM000 JBBM00,' ' XHBM00,A.ZDMC00 JBMC00,A.FZBM00,A.FZMC00, to_date(decode(A.ZDRQ00,'00000000','',A.ZDRQ00),'YYYYMMDD') ZDRQ00, A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, a.M16800 ,a.RYBQ00 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ZLXG00 D, XT_SFYZ00 E WHERE A.zyid00=? AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and A.ZDFS00='1' order by B.PLXH00,A.ID0000 9 10:37:23 SQL Prepare: ORACLE - select a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=454331 and a.ZDLB00='3' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 10 10:37:23 SQL Execute: ORACLE - select a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=454331 and a.ZDLB00='3' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 11 10:37:23 SQL Prepare: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=:1 12 10:37:23 SQL Execute: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=? 13 10:37:23 SQL Prepare: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=:1 and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00 14 10:37:23 SQL Execute: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=? and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00 15 10:37:27 SQL Prepare: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 16 10:37:27 SQL Execute: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 17 10:37:27 SQL Prepare: ORACLE - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000, SWGBYY,SFSJ00,SWRQ00,SWSJ00,DYBL00,ZDDYL0, SSDYBL,SSDYL0,JCDYBL,ZCDYL0,ZLDYBL,ZLDYL0,SFSZ00,SZQX00, SFCRB0,CRBFL0,SFBG00,SFCRB1,CRBFL1,SFBG01, XX0000,RH0000,SXFY01,SXFY00,SYFY00,SYFY01, HXB000,XXB000,XJ0000,QX0000,SXQT00, SJBL00,KYBL00,KYBL01, LYFS00,ZYYLJG,ZZYJH0,ZZYMD0, to_char(HMRYQD) HMRYQD, to_char(HMRYQH) HMRYQH, to_char(HMRYQM) HMRYQM, to_char(HMRYHD) HMRYHD, to_char(HMRYHH) HMRYHH, to_char(HMRYHM) HMRYHM FROM BA_BRZYXX WHERE LSH000=:1 18 10:37:27 SQL Execute: ORACLE - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000, SWGBYY,SFSJ00,SWRQ00,SWSJ00,DYBL00,ZDDYL0, SSDYBL,SSDYL0,JCDYBL,ZCDYL0,ZLDYBL,ZLDYL0,SFSZ00,SZQX00, SFCRB0,CRBFL0,SFBG00,SFCRB1,CRBFL1,SFBG01, XX0000,RH0000,SXFY01,SXFY00,SYFY00,SYFY01, HXB000,XXB000,XJ0000,QX0000,SXQT00, SJBL00,KYBL00,KYBL01, LYFS00,ZYYLJG,ZZYJH0,ZZYMD0, to_char(HMRYQD) HMRYQD, to_char(HMRYQH) HMRYQH, to_char(HMRYQM) HMRYQM, to_char(HMRYHD) HMRYHD, to_char(HMRYHH) HMRYHH, to_char(HMRYHM) HMRYHM FROM BA_BRZYXX WHERE LSH000=? 19 10:37:27 SQL Prepare: ORACLE - select nvl(F.BAXMID,0) BAXMID,sum(A.HJJE00) HJJE00 from ZY_FYMX00 A,ZY_BRFY00 D,BM_YYSFXM F where A.DJH000 = D.DJH000 and A.XMBH00 = F.SFXMID and D.zyid00=:1 and F.BAXMID>100 group by F.BAXMID 20 10:37:27 SQL Execute: ORACLE - select nvl(F.BAXMID,0) BAXMID,sum(A.HJJE00) HJJE00 from ZY_FYMX00 A,ZY_BRFY00 D,BM_YYSFXM F where A.DJH000 = D.DJH000 and A.XMBH00 = F.SFXMID and D.zyid00=? and F.BAXMID>100 group by F.BAXMID 21 10:37:28 SQL Prepare: ORACLE - SELECT LSH000,SSXH00,SSLB00,SSM000,SSMC00,to_date(SSRQ00,'YYYYMMDD')SSRQ00,SSSJ00,SSZL00,SQSHFH, SSYS00,SSYSMC,IYS000,IYSMC0,IIYS00,IIYSMC,MZFS00,QKYHDJ,MZYS00,MZYSMC,CZY000,CZRQ00,CZSJ00 FROM BA_BRSSXX WHERE LSH000=:1 order by SSXH00 22 10:37:28 SQL Execute: ORACLE - SELECT LSH000,SSXH00,SSLB00,SSM000,SSMC00,to_date(SSRQ00,'YYYYMMDD')SSRQ00,SSSJ00,SSZL00,SQSHFH, SSYS00,SSYSMC,IYS000,IYSMC0,IIYS00,IIYSMC,MZFS00,QKYHDJ,MZYS00,MZYSMC,CZY000,CZRQ00,CZSJ00 FROM BA_BRSSXX WHERE LSH000=? order by SSXH00 23 10:37:28 SQL Prepare: ORACLE - select sum(b.hjje00) HJJE00 FROM ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F where a.djh000=b.djh000 and b.XMBH00 = F.SFXMID and F.BAXMID<>0 and F.BAXMID>100 and a.ZYID00=:1 24 10:37:28 SQL Execute: ORACLE - select sum(b.hjje00) HJJE00 FROM ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F where a.djh000=b.djh000 and b.XMBH00 = F.SFXMID and F.BAXMID<>0 and F.BAXMID>100 and a.ZYID00=? 25 10:37:28 SQL Prepare: ORACLE - select nvl(sum(b.ZFJE00),0) ZFJE00 from ZY_BRFY00 a,ZY_JZB000 b where a.ZYID00=:1 and a.JZDH00+0>0 and a.JZDH00+0=b.JZDH00 and a.BRFB00=3 26 10:37:28 SQL Execute: ORACLE - select nvl(sum(b.ZFJE00),0) ZFJE00 from ZY_BRFY00 a,ZY_JZB000 b where a.ZYID00=? and a.JZDH00+0>0 and a.JZDH00+0=b.JZDH00 and a.BRFB00=3 27 10:37:28 SQL Prepare: ORACLE - select nvl(sum(a.HJJE00),0) KJYWFY from VW_ZY_RQDMX0 a,BM_YD0000 b where a.ZYID00=:1 and a.SFYP00='Y' and a.XMBH00=b.YPNM00 and b.KSSJB0>0 28 10:37:28 SQL Execute: ORACLE - select nvl(sum(a.HJJE00),0) KJYWFY from VW_ZY_RQDMX0 a,BM_YD0000 b where a.ZYID00=? and a.SFYP00='Y' and a.XMBH00=b.YPNM00 and b.KSSJB0>0 29 10:37:29 SQL Prepare: ORACLE - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC FROM BA_YSXX00 WHERE LSH000=:1 30 10:37:29 SQL Execute: ORACLE - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC FROM BA_YSXX00 WHERE LSH000=? 31 10:37:29 SQL Prepare: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=:1 32 10:37:29 SQL Execute: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=? 33 10:37:29 SQL Prepare: ORACLE - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000, SWGBYY,SFSJ00,SWRQ00,SWSJ00,DYBL00,ZDDYL0, SSDYBL,SSDYL0,JCDYBL,ZCDYL0,ZLDYBL,ZLDYL0,SFSZ00,SZQX00, SFCRB0,CRBFL0,SFBG00,SFCRB1,CRBFL1,SFBG01, XX0000,RH0000,SXFY01,SXFY00,SYFY00,SYFY01, HXB000,XXB000,XJ0000,QX0000,SXQT00, SJBL00,KYBL00,KYBL01, LYFS00,ZYYLJG,ZZYJH0,ZZYMD0, to_char(HMRYQD) HMRYQD, to_char(HMRYQH) HMRYQH, to_char(HMRYQM) HMRYQM, to_char(HMRYHD) HMRYHD, to_char(HMRYHH) HMRYHH, to_char(HMRYHM) HMRYHM FROM BA_BRZYXX WHERE LSH000=:1 34 10:37:29 SQL Execute: ORACLE - SELECT LSH000,BRXM00,BAH000,ZYCS00,ZYH000, SWGBYY,SFSJ00,SWRQ00,SWSJ00,DYBL00,ZDDYL0, SSDYBL,SSDYL0,JCDYBL,ZCDYL0,ZLDYBL,ZLDYL0,SFSZ00,SZQX00, SFCRB0,CRBFL0,SFBG00,SFCRB1,CRBFL1,SFBG01, XX0000,RH0000,SXFY01,SXFY00,SYFY00,SYFY01, HXB000,XXB000,XJ0000,QX0000,SXQT00, SJBL00,KYBL00,KYBL01, LYFS00,ZYYLJG,ZZYJH0,ZZYMD0, to_char(HMRYQD) HMRYQD, to_char(HMRYQH) HMRYQH, to_char(HMRYQM) HMRYQM, to_char(HMRYHD) HMRYHD, to_char(HMRYHH) HMRYHH, to_char(HMRYHM) HMRYHM FROM BA_BRZYXX WHERE LSH000=? 35 10:37:29 SQL Prepare: ORACLE - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC FROM BA_YSXX00 WHERE LSH000=:1 36 10:37:29 SQL Execute: ORACLE - SELECT LSH000,KZR000,KZRMC0,FZR000,FZRMC0,ZZYS00,ZZYSMC,ZYYS00,ZYYSMC,JXYS00,JXYSMC,YJSYS0, YJSMC0,SXYS00,SXYSMC,ZKYS00,ZKYSMC,ZKHS00,ZKHSMC,JSYS00,JSYSMC FROM BA_YSXX00 WHERE LSH000=? 37 10:37:29 SQL Prepare: ORACLE - SELECT LSH000,SSXH00,SSLB00,SSM000,SSMC00,to_date(SSRQ00,'YYYYMMDD')SSRQ00,SSSJ00,SSZL00,SQSHFH, SSYS00,SSYSMC,IYS000,IYSMC0,IIYS00,IIYSMC,MZFS00,QKYHDJ,MZYS00,MZYSMC,CZY000,CZRQ00,CZSJ00 FROM BA_BRSSXX WHERE LSH000=:1 order by SSXH00 38 10:37:29 SQL Execute: ORACLE - SELECT LSH000,SSXH00,SSLB00,SSM000,SSMC00,to_date(SSRQ00,'YYYYMMDD')SSRQ00,SSSJ00,SSZL00,SQSHFH, SSYS00,SSYSMC,IYS000,IYSMC0,IIYS00,IIYSMC,MZFS00,QKYHDJ,MZYS00,MZYSMC,CZY000,CZRQ00,CZSJ00 FROM BA_BRSSXX WHERE LSH000=? order by SSXH00 39 10:37:29 SQL Prepare: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=:1 40 10:37:29 SQL Execute: ORACLE - select Max(SSXH00) SSXH00 FROM BA_BRSSXX where LSH000=? 41 10:37:29 SQL Prepare: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=:1 and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00 42 10:37:29 SQL Execute: ORACLE - select a.dpkjmc,b.DPKJLX,a.dpbz00 from BA_BASYDP a,BA_BADPDX b where a.LSH000=? and a.DPLB00='0' and a.DPKJMC=b.DPKJMC and a.DPLB00=b.DPLB00 order by b.dpdxlb,b.pxxh00 43 10:37:31 SQL Prepare: ORACLE - select count(distinct F.SFXMID) FROM ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F where a.ZYID00=:1 and a.djh000=b.djh000 and b.XMBH00 = F.SFXMID and (F.BAXMID<=100 or F.BAXMID is null) 44 10:37:31 SQL Execute: ORACLE - select count(distinct F.SFXMID) FROM ZY_BRFY00 a ,ZY_FYMX00 b,BM_YYSFXM F where a.ZYID00=? and a.djh000=b.djh000 and b.XMBH00 = F.SFXMID and (F.BAXMID<=100 or F.BAXMID is null) 45 10:37:31 SQL Prepare: ORACLE - select * from VW_ZS_BAXXDY_NEW where ZYID00=454331 46 10:37:31 SQL Execute: ORACLE - select * from VW_ZS_BAXXDY_NEW where ZYID00=454331 47 10:37:32 SQL Prepare: ORACLE - select A.ZYID00,A.ZDLBMC,A.ZDM000,decode(rownum,1,'主要诊断: '||A.ZDMC00,2,'其他诊断: '||A.ZDMC00,12,'其他诊断: '||A.ZDMC00,A.ZDMC00) ZDMC00,A.RYBQ00,A.RYBQBH from ( (SELECT to_char(zyid00) zyid00,'主要诊断' zdlbmc,zdm000,zdmc00,RYBQ00,RYBQBH,id0000 FROM VW_ZS_BACYZD WHERE ZYID00=454331 AND ZDLBMC='出院主要诊断' and ZDFS00='1' and rownum<=1) union all (select * from (select * from (SELECT to_char(zyid00) zyid00,'其它诊断' zdlbmc,zdm000,zdmc00,RYBQ00,RYBQBH,id0000 FROM VW_ZS_BACYZD WHERE ZYID00=454331 and ZDFS00='1' AND (ZDLBMC<>'出院主要诊断' and ZDLBMC<>'医院感染' and instr(ZDLBMC,'门诊')=0 ) union all select null zyid00, '其它诊断' zdlbmc, null zdm000,null zdmc00,null RYBQ00,null RYBQBH,999999999 id0000 from bm_yd0000 where rownum<=21 ) order by ID0000 ) where rownum<=21 ) ) A where rownum<=22 48 10:37:32 SQL Execute: ORACLE - select A.ZYID00,A.ZDLBMC,A.ZDM000,decode(rownum,1,'主要诊断: '||A.ZDMC00,2,'其他诊断: '||A.ZDMC00,12,'其他诊断: '||A.ZDMC00,A.ZDMC00) ZDMC00,A.RYBQ00,A.RYBQBH from ( (SELECT to_char(zyid00) zyid00,'主要诊断' zdlbmc,zdm000,zdmc00,RYBQ00,RYBQBH,id0000 FROM VW_ZS_BACYZD WHERE ZYID00=454331 AND ZDLBMC='出院主要诊断' and ZDFS00='1' and rownum<=1) union all (select * from (select * from (SELECT to_char(zyid00) zyid00,'其它诊断' zdlbmc,zdm000,zdmc00,RYBQ00,RYBQBH,id0000 FROM VW_ZS_BACYZD WHERE ZYID00=454331 and ZDFS00='1' AND (ZDLBMC<>'出院主要诊断' and ZDLBMC<>'医院感染' and instr(ZDLBMC,'门诊')=0 ) union all select null zyid00, '其它诊断' zdlbmc, null zdm000,null zdmc00,null RYBQ00,null RYBQBH,999999999 id0000 from bm_yd0000 where rownum<=21 ) order by ID0000 ) where rownum<=21 ) ) A where rownum<=22 49 10:37:32 SQL Prepare: ORACLE - select * from (select * from (select to_char(A.SSXH00) SSBH00, substr(A.SSRQ00,1,8) as SSRQ00, A.SSLB00,A.SSZL00 SSJB00,A.SSMC00, A.SSYSMC SSYSXM, decode(sign(instr(A.IYSMC0,';')),1,substr(A.IYSMC0,1,instr(A.IYSMC0,';')-1),A.IYSMC0) as ZSXM01, decode(sign(instr(A.IYSMC0,';')),1,substr(A.IYSMC0,instr(A.IYSMC0,';')+1,length(a.IYSMC0)-instr(A.IYSMC0,';')),a.IYSMC0) as ZSXM02, A.MZFS00 MZMC00,A.MZYSMC MZYSXM, A.QKYHDJ QKYHDJ from BA_BRSSXX A where A.LSH000=454331 order by A.SSXH00) union all (select null SSBH00, null SSRQ00 , null SSLB00,null SSJB00,null SSMC00 , null SSYSXM , null ZSXM01,null ZSXM02, null MZMC00 , null MZYSXM, null QKYHDJ from BM_YD0000 where rownum<=8)) where rownum<=8 50 10:37:32 SQL Execute: ORACLE - select * from (select * from (select to_char(A.SSXH00) SSBH00, substr(A.SSRQ00,1,8) as SSRQ00, A.SSLB00,A.SSZL00 SSJB00,A.SSMC00, A.SSYSMC SSYSXM, decode(sign(instr(A.IYSMC0,';')),1,substr(A.IYSMC0,1,instr(A.IYSMC0,';')-1),A.IYSMC0) as ZSXM01, decode(sign(instr(A.IYSMC0,';')),1,substr(A.IYSMC0,instr(A.IYSMC0,';')+1,length(a.IYSMC0)-instr(A.IYSMC0,';')),a.IYSMC0) as ZSXM02, A.MZFS00 MZMC00,A.MZYSMC MZYSXM, A.QKYHDJ QKYHDJ from BA_BRSSXX A where A.LSH000=454331 order by A.SSXH00) union all (select null SSBH00, null SSRQ00 , null SSLB00,null SSJB00,null SSMC00 , null SSYSXM , null ZSXM01,null ZSXM02, null MZMC00 , null MZYSXM, null QKYHDJ from BM_YD0000 where rownum<=8)) where rownum<=8 51 10:37:32 SQL Prepare: ORACLE - select decode('11507.7','无','0',nvl('11507.7',' ')) HJJE00, decode('','无','0',nvl('',' ')) ZFJE00, nvl(decode('453','无','0','453'),0) YLFWF0, nvl(decode('433','无','0','433'),0) ZLCZF0, nvl(decode('240','无','0','240'),0) HLF000, nvl(decode('0','无','0','0'),0) ZHQTFY, nvl(decode('985','无','0','985'),0) BLZDF0, nvl(decode('575','无','0','575'),0) SYSZDF, nvl(decode('183','无','0','183'),0) YXXZDF, nvl(decode('222','无','0','222'),0) LCZDXM, nvl(decode('0','无','0','0'),0) FSSZLF, nvl(decode('0','无','0','0'),0) LCWLZL, nvl(decode('2995','无','0','2995'),0) SSZLF0, nvl(decode('795','无','0','795'),0) MZF000, nvl(decode('2200','无','0','2200'),0) SSF000, nvl(decode('0','无','0','0'),0) KFF000, nvl(decode('0','无','0','0'),0) ZYZLF0, nvl(decode('3974.1','无','0','3974.1'),0) XYF000, nvl(decode('0','无','0','0'),0) KJYWFY, nvl(decode('0','无','0','0'),0) CYF000, nvl(decode('0','无','0','0'),0) ZCYF00, nvl(decode('0','无','0','0'),0) XF0000, nvl(decode('0','无','0','0'),0) BDBFY0, nvl(decode('0','无','0','0'),0) QDBFY0, nvl(decode('0','无','0','0'),0) NXYZFY, nvl(decode('0','无','0','0'),0) XBYZFY, nvl(decode('284.94','无','0','284.94'),0) JCCLF0, nvl(decode('364.54','无','0','364.54'),0) ZLCLF0, nvl(decode('798.12','无','0','798.12'),0) SSCLF0, nvl(decode('0','无','0','0'),0) QTF000 from dual 52 10:37:32 SQL Execute: ORACLE - select decode('11507.7','无','0',nvl('11507.7',' ')) HJJE00, decode('','无','0',nvl('',' ')) ZFJE00, nvl(decode('453','无','0','453'),0) YLFWF0, nvl(decode('433','无','0','433'),0) ZLCZF0, nvl(decode('240','无','0','240'),0) HLF000, nvl(decode('0','无','0','0'),0) ZHQTFY, nvl(decode('985','无','0','985'),0) BLZDF0, nvl(decode('575','无','0','575'),0) SYSZDF, nvl(decode('183','无','0','183'),0) YXXZDF, nvl(decode('222','无','0','222'),0) LCZDXM, nvl(decode('0','无','0','0'),0) FSSZLF, nvl(decode('0','无','0','0'),0) LCWLZL, nvl(decode('2995','无','0','2995'),0) SSZLF0, nvl(decode('795','无','0','795'),0) MZF000, nvl(decode('2200','无','0','2200'),0) SSF000, nvl(decode('0','无','0','0'),0) KFF000, nvl(decode('0','无','0','0'),0) ZYZLF0, nvl(decode('3974.1','无','0','3974.1'),0) XYF000, nvl(decode('0','无','0','0'),0) KJYWFY, nvl(decode('0','无','0','0'),0) CYF000, nvl(decode('0','无','0','0'),0) ZCYF00, nvl(decode('0','无','0','0'),0) XF0000, nvl(decode('0','无','0','0'),0) BDBFY0, nvl(decode('0','无','0','0'),0) QDBFY0, nvl(decode('0','无','0','0'),0) NXYZFY, nvl(decode('0','无','0','0'),0) XBYZFY, nvl(decode('284.94','无','0','284.94'),0) JCCLF0, nvl(decode('364.54','无','0','364.54'),0) ZLCLF0, nvl(decode('798.12','无','0','798.12'),0) SSCLF0, nvl(decode('0','无','0','0'),0) QTF000 from dual