---选择病人费别后的跟踪，TZBZ00传%,因为默认停止按钮是未勾选的，TZBZ00传值应该是0 1 09:57:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 2 09:57:48 SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=? AND yblb00=ybzxlb 3 09:57:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 4 09:57:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5 09:57:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6 09:57:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 7 09:57:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 8 09:57:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 9 09:57:48 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,BKEH83,BKEA96, ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00,DYBZ00,ZYZFBL,ZYZFJE,PYSM00,WBSM00, MZZYBZ,DECODE(MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,FYBBH0,GG0000,SCCJ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 10 09:57:55 SQL Execute: ORACLE - select b.YBMC00,a.FBBH00,a.SFXMID,a.YBZXLB,a.YYDJXH AS YYDJ00,a.YYDJMC,a.YYXMMC,a.YBXMBH,a.YBXMMC,a.ZFBL00,a.ZFJE00,a.YBZYFP,a.YBMZFP,a.ZYFPXM,a.MZFPXM,a.SFYP00,a.SFYBXM,a.YBLB00,DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.YBBRLB,DECODE(a.YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,a.yyxmbh,a.JMBL00,a.JMJE00,a.SFSX00,a.BH0000,a.BZ0000,a.TZBZ00,a.ZYZFBL,a.ZYZFJE,a.BKEH83,a.MZZYBZ, DECODE(a.MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,a.FYBBH0,a.GG0000,a.SCCJ00 from VW_BM_YBSFDYXMMCFP a inner join IC_YBBRLB b on a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB where a. SFXMID=8000063427 and a.YBZXLB<>'2' and a.FBBH00='3' order by b.YBMC00 11 09:57:55 SQL Execute: ORACLE - select * from VW_BM_YBCBDY where FBBH00 = 3 and YBZXLB = '2' and SFXMID = 8000063427.00 and SFYP00='N' --勾选停止按钮后的跟踪，TZBZ00传% 12 09:59:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 13 09:59:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 14 09:59:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 15 09:59:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 16 09:59:00 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 17 09:59:00 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 18 09:59:00 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,BKEH83,BKEA96, ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00,DYBZ00,ZYZFBL,ZYZFJE,PYSM00,WBSM00, MZZYBZ,DECODE(MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,FYBBH0,GG0000,SCCJ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 19 09:59:08 SQL Execute: ORACLE - select b.YBMC00,a.FBBH00,a.SFXMID,a.YBZXLB,a.YYDJXH AS YYDJ00,a.YYDJMC,a.YYXMMC,a.YBXMBH,a.YBXMMC,a.ZFBL00,a.ZFJE00,a.YBZYFP,a.YBMZFP,a.ZYFPXM,a.MZFPXM,a.SFYP00,a.SFYBXM,a.YBLB00,DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.YBBRLB,DECODE(a.YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,a.yyxmbh,a.JMBL00,a.JMJE00,a.SFSX00,a.BH0000,a.BZ0000,a.TZBZ00,a.ZYZFBL,a.ZYZFJE,a.BKEH83,a.MZZYBZ, DECODE(a.MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,a.FYBBH0,a.GG0000,a.SCCJ00 from VW_BM_YBSFDYXMMCFP a inner join IC_YBBRLB b on a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB where a. SFXMID=8000063427 and a.YBZXLB<>'2' and a.FBBH00='3' order by b.YBMC00 20 09:59:08 SQL Execute: ORACLE - select * from VW_BM_YBCBDY where FBBH00 = 3 and YBZXLB = '2' and SFXMID = 8000063427.00 and SFYP00='N' 21 09:59:14 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 22 09:59:14 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 37.000000 23 09:59:14 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15039117.000000 24 09:59:14 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 25 09:59:14 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1 and CZXH00 = 15039117.00) --停止按钮不勾选后的跟踪，TZBZ00传值0 26 09:59:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 27 09:59:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 28 09:59:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 29 09:59:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 30 09:59:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 31 09:59:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 32 09:59:20 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,BKEH83,BKEA96, ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00,DYBZ00,ZYZFBL,ZYZFJE,PYSM00,WBSM00, MZZYBZ,DECODE(MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,FYBBH0,GG0000,SCCJ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 33 09:59:26 SQL Execute: ORACLE - select b.YBMC00,a.FBBH00,a.SFXMID,a.YBZXLB,a.YYDJXH AS YYDJ00,a.YYDJMC,a.YYXMMC,a.YBXMBH,a.YBXMMC,a.ZFBL00,a.ZFJE00,a.YBZYFP,a.YBMZFP,a.ZYFPXM,a.MZFPXM,a.SFYP00,a.SFYBXM,a.YBLB00,DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.YBBRLB,DECODE(a.YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,a.yyxmbh,a.JMBL00,a.JMJE00,a.SFSX00,a.BH0000,a.BZ0000,a.TZBZ00,a.ZYZFBL,a.ZYZFJE,a.BKEH83,a.MZZYBZ, DECODE(a.MZZYBZ,'0','限门诊','1','限住院','2','不限制') MZZYBZ0,a.FYBBH0,a.GG0000,a.SCCJ00 from VW_BM_YBSFDYXMMCFP a inner join IC_YBBRLB b on a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB where a. SFXMID=20011 and a.YBZXLB<>'2' and a.FBBH00='3' order by b.YBMC00 34 09:59:26 SQL Execute: ORACLE - select * from VW_BM_YBCBDY where FBBH00 = 3 and YBZXLB = '2' and SFXMID = 20011.00 and SFYP00='N'