public override DataBaseInfo GetDataBaseInfo()
{
string version = "";
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "SELECT size*8,(status & 0x40) as type FROM sysfiles;SELECT @@VERSION";
DataBaseInfo dataBaseInfo = new DataBaseInfo();
using (XSqlDataReader reader = query.ExecuteReader())
{
int dataSize = 0;
int logoSize = 0;
while (reader.Read())
{
if (reader.GetInt32(1) == 0)
dataSize += reader.GetInt32(0);
else
logoSize += reader.GetInt32(0);
}
if (reader.NextResult())
{
while (reader.Read())
version += "(" + reader.GetString(0) + ")";
}
dataBaseInfo.DataSize = dataSize * 1024;
dataBaseInfo.LogSize = logoSize * 1024;
dataBaseInfo.Version = version;
}
return dataBaseInfo;
}
}
protected void Page_Load(object sender, EventArgs e)
{
WaitForFillSimpleUsers<ConsoleLoginLog>(ConsoleLog);
OSVersion = Environment.OSVersion.ToString();
if (OSVersion.IndexOf("Microsoft Windows NT 5.0") > -1)
{
OSVersion = string.Concat("Microsoft Windows 2000 (", OSVersion, ")");
IISVersion = "IIS 5";
}
else if (OSVersion.IndexOf("Microsoft Windows NT 5.1") > -1)
{
OSVersion = string.Concat("Microsoft Windows XP (", OSVersion, ")");
IISVersion = "IIS 5.1";
}
else if (OSVersion.IndexOf("Microsoft Windows NT 5.2") > -1)
{
OSVersion = string.Concat("Microsoft Windows 2003 (", OSVersion, ")");
IISVersion = "IIS 6";
}
else if (OSVersion.IndexOf("Microsoft Windows NT 6.0") > -1)
{
OSVersion = string.Concat("Microsoft Windows Vista (", OSVersion, ")");
IISVersion = "IIS 7";
}
else if (OSVersion.IndexOf("Microsoft Windows NT 6.1") > -1)
{
OSVersion = string.Concat("Microsoft Windows 7 (", OSVersion, ")");
IISVersion = "IIS 7.5";
}
NETVersion = Environment.Version.ToString();
dataBaseInfo = DataAccess.DatabaseInfoDao.Instance.GetDataBaseInfo();
try
{
memoryInfo = new MemoryInfo().GetMemoryInfo();
}
catch
{
memoryInfo = new MemoryInfo();
}
}