--------有打勾------ 1 16:09:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2 16:09:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 3 16:09:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 4 16:09:06 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5 16:09:06 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 6 16:09:06 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 7 16:09:06 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 16:09:06 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 9 16:09:06 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 16:09:06 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 11 16:09:06 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 12 16:09:06 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 16:09:06 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 14 16:09:06 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 15 16:09:06 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 16:09:06 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 17 16:09:06 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 16:09:06 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 16:09:06 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 20 16:09:06 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 21 16:09:06 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 16:09:06 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 23 16:09:06 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 45 24 16:09:06 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 16:09:06 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 26 16:09:06 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 27 16:09:06 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 16:09:06 SQL Data In: ORACLE - Param = 28, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4492.000000 29 16:09:06 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 30 16:09:06 SQL Data In: ORACLE - Param = 30, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 31 16:09:06 SQL Execute: ORACLE - update BM_YBSFDY a set YBXMBH=decode(1,0,‘’,nvl((select XMBH00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBXMBH)) , YBZYFP=decode(?,0,?,nvl((select ZYFPXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBZYFP)) , YBMZFP=decode(?,0,?,nvl((select MZFPXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBMZFP)) , SFYBXM=decode(?,0,?,nvl((select SFYBXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),SFYBXM)) , YBLB00=decode(?,0,?,nvl((select YBLB00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBLB00)) , ZFBL00=decode(?,0,?,nvl((select ZFBL00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),ZFBL00)) , YBBRLB=decode(?,0,?,nvl((select YBBRLB from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBBRLB)) , BZ0000=decode(?,0,?,nvl((select BZ0000 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),BZ0000)) , ZYZFBL=decode(?,0,?,nvl((select ZYZFBL from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),ZYZFBL)) WHERE SFXMID = ? and SFYP00 ='Y' and YBZXLB <> ? and FBBH00 = ? 32 16:09:06 SQL Data In: ORACLE - Rows affected = 4 33 16:09:06 SQL Execute: ORACLE - commit 34 16:09:06 SQL Data In: ORACLE - Rows affected = 0 35 16:09:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 36 16:09:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 37 16:09:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4492.000000 38 16:09:06 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.ybbz00,a.TZBZ00,a.ZYZFBL 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 39 16:09:57 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 40 16:09:57 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 464.000000 41 16:09:57 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12378593.000000 42 16:09:57 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 43 16:09:57 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 12378593.00) --------没打勾------ 1 16:11:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2 16:11:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 3 16:11:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 4 16:11:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5 16:11:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 6 16:11:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 7 16:11:21 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 16:11:21 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 9 16:11:21 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 16:11:21 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 16:11:21 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 12 16:11:21 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 16:11:21 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 14 16:11:21 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 15 16:11:21 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 16:11:21 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 17 16:11:21 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 16:11:21 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 16:11:21 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 20 16:11:21 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 21 16:11:21 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 16:11:21 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 23 16:11:21 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 45 24 16:11:21 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 16:11:21 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 16:11:21 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 27 16:11:21 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 16:11:21 SQL Data In: ORACLE - Param = 28, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4492.000000 29 16:11:21 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 30 16:11:21 SQL Data In: ORACLE - Param = 30, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 31 16:11:21 SQL Execute: ORACLE - update BM_YBSFDY a set YBXMBH=decode(?,0,?,nvl((select XMBH00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBXMBH)) , YBZYFP=decode(?,0,?,nvl((select ZYFPXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBZYFP)) , YBMZFP=decode(?,0,?,nvl((select MZFPXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBMZFP)) , SFYBXM=decode(?,0,?,nvl((select SFYBXM from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),SFYBXM)) , YBLB00=decode(?,0,?,nvl((select YBLB00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBLB00)) , ZFBL00=decode(?,0,?,nvl((select ZFBL00 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),ZFBL00)) , YBBRLB=decode(?,0,?,nvl((select YBBRLB from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),YBBRLB)) , BZ0000=decode(?,0,?,nvl((select BZ0000 from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),BZ0000)) , ZYZFBL=decode(?,0,?,nvl((select ZYZFBL from BM_YBSFXM where XMBH00=rpad(?,20) and YBZXLB=a.YBZXLB and FBBH00=a.FBBH00 and rownum=1),ZYZFBL)) WHERE SFXMID = ? and SFYP00 ='Y' and YBZXLB <> ? and FBBH00 = ? 32 16:11:21 SQL Data In: ORACLE - Rows affected = 4 33 16:11:21 SQL Execute: ORACLE - commit 34 16:11:21 SQL Data In: ORACLE - Rows affected = 0 35 16:11:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 36 16:11:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 37 16:11:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4492.000000 38 16:11:21 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.ybbz00,a.TZBZ00,a.ZYZFBL 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