自定义输出表格，有时用得到[WEB学习示例]

来源：互联网发布：深圳市软件企业协会编辑：程序博客网时间：2024/05/01 19:02

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;
}