cmd.CommandText = "s elect case when a.shopid=0 then '公司总部' Else '腾远宝贝王淘气堡区' End, a.wsname As 服务名称,a.trancount As 次数,b.membercardsn As 会员卡号,b.membername As 会员姓名,b.yinshoujiner,b.daijinquan,b.weixinjiner &_ from {sealacc} a inner join {sealhdhacc} b on (a.sealhdhaccid=b.sealhdhaccid And a.TranCount>1) inner join {members} c on (b.membercardsn=c.membercardsn And c.memberdeptid<>0)"