62,072
社区成员
发帖
与我相关
我的任务
分享
public string quyu_shiyonglv()
{
Double[] leiji = new Double[4]; string strBody = null, jifan = "", quyu = "";
strBody += "<table border='1' style='width: 100%'><tr>";
strBody += "<td style='width: 20%; color: #0000FF;'>区域名称</td>";
strBody += "<td style='width: 20%; color: #0000FF;'>区名称</td>";
strBody += "<td style='width: 20%; color: #0000FF;'>区域总使用率</td>";
strBody += "<td style='width: 20%; color: #0000FF;'>已用配置</td>";
strBody += "<td style='width: 20%; color: #0000FF;'>实际配置</td></tr>";
Socut.Reader dr = new Socut.Reader("SELECT * FROM YUJIN where quyu like '%" + xuanzequyu + "%'or jifan like '%" + xuanzequyu + "%'or mingcheng like '%" + xuanzequyu + "%' order by jifan asc");//desc
while (dr.Read())//循环读取
{
if (jifan == "") { jifan = dr["jifan"].ToString(); quyu = dr["quyu"].ToString(); }
if (dr["jifan"].ToString() == jifan)
{
leiji[0] += Double.Parse(dr["yiyongxinshu"].ToString());
leiji[1] += Double.Parse(dr["shijipeizhi"].ToString());
}
else
{
leiji[2] += Double.Parse(dr["yiyongxinshu"].ToString());
leiji[3] += Double.Parse(dr["shijipeizhi"].ToString());
}
if (dr["jifan"].ToString() != jifan)
{
strBody += "<tr><td style='width: 20%'>" + quyu + "</td>";
strBody += "<td style='width: 20%; text-align: left;'>" + jifan + "</td>";
strBody += "<td style='width: 20%'>" + Math.Round((leiji[0] / leiji[1]) * 100, 2) + "%</td>";
strBody += "<td style='width: 20%'>" + leiji[0] + "</td>";
strBody += "<td style='width: 20%'>" + leiji[1] + "</td></tr>";
leiji[0] = 0; leiji[1] = 0;
if (dr.Read() == true)
{
quyu = dr["quyu"].ToString(); jifan = dr["jifan"].ToString();
}
if (leiji[2] > 0 || leiji[3] > 0)
{
leiji[0] = leiji[2]; leiji[1] = leiji[3];
leiji[2] = 0; leiji[3] = 0;
}
}
}
dr.Close();
strBody += "<tr><td style='width: 20%'>" + quyu + "</td>";
strBody += "<td style='width: 20%; text-align: left;'>" + jifan + "</td>";
strBody += "<td style='width: 20%'>" + Math.Round((leiji[0] / leiji[1]) * 100, 2) + "%</td>";
strBody += "<td style='width: 20%'>" + leiji[0] + "</td>";
strBody += "<td style='width: 20%'>" + leiji[1] + "</td></tr>";
strBody += "</table>";
return strBody;
}
<div><%=quyu_shiyonglv%></div>
div id="div1"><%=_str %></div>
protected string _str ="test";