using Common;
using Dao;
using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.Web;
using System.Web.Profile;
using System.Web.SessionState;

public partial class Welcome : PageBase<SysUser>, IRequiresSessionState
{
    protected List<GwClient> GwClientList;


    protected void Page_Load(object sender, EventArgs e)
    {
        using (GwClientDao gwClientDao = new GwClientDao())
            this.GwClientList = gwClientDao.Clientlist();
    }

    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 str1 = dataRowReader.GetString("tablespace_name");
                if (str1 == "SMGWDAT" || str1 == "SMGWLOG")
                    str1 = "<span class=\"label label-primary\">" + str1 + "</span>";
                Decimal @decimal = dataRowReader.GetDecimal("used_pct");
                string str2 = string.Format("<span class=\"label {0}\">{1}%</span>", @decimal >= new Decimal(90) ? (object)"label-warning" : (object)"label-primary", (object)@decimal);
                stringBuilder.AppendFormat("<tr><td>{0}</td><td>{1}MB</td><td>{2}MB</td><td>{3}</td></tr>", (object)str1, (object)dataRowReader.GetInt("total_mb"), (object)dataRowReader.GetString("used_mb"), (object)str2);
            }
            return stringBuilder.ToString();
        }
    }
    //客户ID转换名称
    public string ClientIdToName(string clientId)
    {
        if (this.GwClientList.Count == 0)
            return clientId;
        foreach (GwClient bean in this.GwClientList)
        {
            if (clientId.Equals(bean.ClientID))
                return bean.Company;
            else
                continue;
        }

        return clientId;
    }
}