update  BM_BRZFFS set XSXH00=0 where zffsbh=1;  --现金 
 update  BM_BRZFFS set XSXH00=1 where zffsbh=8;  --银行卡
 update  BM_BRZFFS set XSXH00=2 where zffsbh=2;  --转账 
 update  BM_BRZFFS set XSXH00=3 where zffsbh=13;  --商业保险支付
 update  BM_BRZFFS set XSXH00=4 where zffsbh=18;  --电子钱包
 update  BM_BRZFFS set XSXH00=98 where (SFYX00)='Y' and zffsbh not in (1,2,8,13,18)--不显示的支付方式 
 update  BM_BRZFFS set XSXH00=99 where UPPER(SFYX00)='N' --不显示的支付方式 
 commit;