--手麻输血单打印  
SELECT B.JYXMMC,B.JYXMBH,A.JYJG00,
A.JYJG00,A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.BGXMID(+)=B.BGXMID
 AND ZYID00(+)=2512429 and A.SQDH00(+)='095139' 
 and  (B.BGDJID=280  or  (BGXMMC='输血申请中输血成分个性报告' and BZ0000='滤白冷沉淀凝血因子') ) 
 ORDER BY JYXMBH

--手麻输血前台显示 
SELECT B.JYXMMC,B.JYXMBH,
A.JYJG00,
 A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.JYXMID(+)=B.JYXMID
 and  (B.BGDJID=280  or  (B.BGXMMC='输血申请中输血成分个性报告' and B.BZ0000='滤白冷沉淀凝血因子') ) 
  AND ZYID00(+)=2512429  and  A.SQDH00(+)='095139'
 order by JYXMBH