1 15:04:16 SQL Prepare: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=:1 AND a.YBZXLB<>:2 and a.sfxmid=:3 and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 2 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 3 15:04:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 4 15:04:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 5 15:04:16 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 6 15:04:16 SQL Prepare: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=:1 7 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 8 15:04:16 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 9 15:04:16 SQL Prepare: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=:1 AND a.YBZXLB<>:2 and a.sfxmid=:3 and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 10 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 11 15:04:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 12 15:04:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 13 15:04:16 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 14 15:04:16 SQL Prepare: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=:1 15 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 16 15:04:16 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 17 15:04:16 SQL Prepare: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=:1 AND a.YBZXLB<>:2 and a.sfxmid=:3 and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 18 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 19 15:04:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 20 15:04:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 21 15:04:16 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 22 15:04:16 SQL Prepare: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=:1 23 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 24 15:04:16 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 25 15:04:16 SQL Prepare: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=:1 AND a.YBZXLB<>:2 and a.sfxmid=:3 and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 26 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 27 15:04:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = @ 28 15:04:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 29 15:04:16 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 30 15:04:16 SQL Prepare: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=:1 31 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6428.000000 32 15:04:16 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 33 15:04:16 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 34 15:04:16 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 35 15:04:16 SQL Prepare: ORACLE - select xmmc00,zfbl00,ypjx00,YPGG00,XMBH00,YBBRLB,PYSM00,WBSM00,YPSM00 from VW_BM_YBSFXM_YBXM00 where (PYSM00 Like :1 or XMBH00 Like :2) and( (sfyx00='Y') and (flag00='1') and (FBBH00=3) and (ybzxlb='@') ) and Rownum<=1 36 15:04:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 37 15:04:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 38 15:04:16 SQL Execute: ORACLE - select xmmc00,zfbl00,ypjx00,YPGG00,XMBH00,YBBRLB,PYSM00,WBSM00,YPSM00 from VW_BM_YBSFXM_YBXM00 where (PYSM00 Like ? or XMBH00 Like ?) and( (sfyx00='Y') and (flag00='1') and (FBBH00=3) and (ybzxlb='@') ) and Rownum<=1