select count(*) as total,sum(case when u_bmzt='已报' then 1 else 0 end)*1.0/count(*) as yb,sum(case when u_bmzt='未报' then 1 else 0 end)*1.0/count(*) as wb from kf_user
以上是在sql计算出的结果,在C#前台中可以用如下方法进行格式化
<%# stringFrrmat("{0:P},Eval(yb)")%>
select count(*) as total,sum(case when u_bmzt='已报' then 1 else 0 end)*1.0/count(*) as yb,sum(case when u_bmzt='未报' then 1 else 0 end)*1.0/count(*) as wb from kf_user
<%# stringFrrmat("{0:P},Eval(yb)")%>