/// <summary>
/// Refresh TableSpace size
/// </summary>
private void RefreshSize()
{
DataSet ds = DatabaseProcessor.Instance.GetTableSpaceList();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string tableSpaceName = ds.Tables[0].Rows[i]["NAME"].ToString();
double freeSize = Convert.ToDouble(ds.Tables[0].Rows[i]["FREE_SIZE"].ToString());
int percentage = Convert.ToInt32(ds.Tables[0].Rows[i]["PERCENTAGE"].ToString());
for (int k = 0; k < uiFlp_Main.Controls.Count; k++)
{
TableSpaceCtl ctl = uiFlp_Main.Controls[k] as TableSpaceCtl;
if (ctl.TABLESPACE_NAME != tableSpaceName)
{
continue;
}
ctl.FREE_SIZE = freeSize;
ctl.PERCENTAGE = percentage;
ctl.SetCapacity();
}
}
}
}
/// <summary>
/// Create TableSpace control
/// </summary>
/// <param name="ds"></param>
private void CreateTableSpaceControl(DataSet ds)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TableSpaceCtl ctl = new TableSpaceCtl()
{
TABLESPACE_NAME = ds.Tables[0].Rows[i]["NAME"].ToString(),
TOTAL_SIZE = Convert.ToDouble(ds.Tables[0].Rows[i]["TOTAL_SIZE"].ToString()),
FREE_SIZE = Convert.ToDouble(ds.Tables[0].Rows[i]["FREE_SIZE"].ToString()),
PERCENTAGE = Convert.ToInt32(ds.Tables[0].Rows[i]["PERCENTAGE"].ToString()),
};
uiFlp_Main.Controls.Add(ctl);
}
}
