using Common;
using Dao;
using System;
using System.Data;
using System.Text;
using System.Web;
using System.Web.Profile;
using System.Web.SessionState;
using System.Web.UI;

public partial class TableSpace : Page, IRequiresSessionState
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    public string RenderTableSpaceTable()
    {
        using (GwUtilityDao gwUtilityDao = new GwUtilityDao())
        {
            StringBuilder stringBuilder = new StringBuilder();
            DataTable tableSpaceStatis = gwUtilityDao.GetTableSpaceStatis();
            stringBuilder.AppendFormat("<tr><td> 表空间</td><td>总大小</td><td>已使用</td><td>已使用百分比</td></tr>");
            foreach (DataRow row in (InternalDataCollectionBase)tableSpaceStatis.Rows)
            {
                DataRowReader dataRowReader = new DataRowReader(row);
                string str = dataRowReader.GetString("tablespace_name");
                if (str == "SMGWDAT" || str == "SMGWLOG")
                    str = "<span class=\"label label-primary\">" + str + "</span>";
                stringBuilder.AppendFormat("<tr><td>{0}</td><td>{1}MB</td><td>{2}MB</td><td>{3}%</td></tr>", (object)str, (object)dataRowReader.GetInt("total_mb"), (object)dataRowReader.GetString("used_mb"), (object)dataRowReader.GetDecimal("used_pct"));
            }
            return stringBuilder.ToString();
        }
    }
}