1       09:43:20  SQL Execute: ORACLE - select a.*,'图像'TX0000,decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.BGURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.BGURL0||'z.asp?zyh='||a.ZYHGHH),a.BGURL0||a.YJDJH0) BGADDR,
decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.YXURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.YXURL0||'z.asp?zyh='||a.ZYHGHH),a.YXURL0||a.YJDJH0) YXADDR 
 from VW_PACS_BGCX00  a where BRID00=3096566 and YJDJH0<>18745258 and JCLBID=2 order by YJDJH0 desc

2       09:43:21  SQL Execute: ORACLE - select a.*,'图像'TX0000,decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.BGURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.BGURL0||'z.asp?zyh='||a.ZYHGHH),a.BGURL0||a.YJDJH0) BGADDR,
decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.YXURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.YXURL0||'z.asp?zyh='||a.ZYHGHH),a.YXURL0||a.YJDJH0) YXADDR 
 from VW_PACS_BGCX00  a where BRID00=3096566 and YJDJH0<>18745259 and JCLBID=2 order by YJDJH0 desc

3       09:43:22  SQL Execute: ORACLE - select a.*,'图像'TX0000,decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.BGURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.BGURL0||'z.asp?zyh='||a.ZYHGHH),a.BGURL0||a.YJDJH0) BGADDR,
decode(a.ZYZBMC,'病理',decode(a.MZZYBZ,'0',a.YXURL0||'m.asp?mzh='||a.ZYHGHH,'1',a.YXURL0||'z.asp?zyh='||a.ZYHGHH),a.YXURL0||a.YJDJH0) YXADDR 
 from VW_PACS_BGCX00  a where BRID00=3096566 and YJDJH0<>18745258 and JCLBID=2 order by YJDJH0 desc