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