/// <summary>
/// 获取数据库属性信息
/// </summary>
/// <param name="lastDatabasePropertyInfo">前一次获取到的数据库属性信息</param>
/// <returns>数据库属性信息</returns>
protected override DatabasePropertyInfo PrimitiveGetDatabasePropertyInfo(DatabasePropertyInfo lastDatabasePropertyInfo)
{
using (var con = base.CreateConnection())
{
var dbConnection = con.DbConnection;
long memorySize = this.PrimitiveGetMemorySize(dbConnection);
long diskSize = this.PrimitiveGetDiskSize(dbConnection);
int maxConnectCount = this.PrimitiveGetMaxConnectCount(dbConnection);
int totalConnectCount = this.PrimitiveGetTotalConnectCount(dbConnection);
int concurrentConnectCount, activeConnectCount;
this.PrimitiveGetTotalConnectCountAndConcurrentConnectCount(dbConnection, out concurrentConnectCount, out activeConnectCount);
DateTime startTime, createtTime;
if (lastDatabasePropertyInfo == null)
{
startTime = this.PrimitiveGetStartTime(dbConnection);
createtTime = this.PrimitiveGetCreatetTime(dbConnection);
}
else
{
startTime = lastDatabasePropertyInfo.StartTime;
createtTime = lastDatabasePropertyInfo.CreatetTime;
}
List <string> allUserNameList = this.GetAllUserNameList(dbConnection);
float cpuRate = 0f;
return(new DatabasePropertyInfo(memorySize, diskSize, maxConnectCount, totalConnectCount,
concurrentConnectCount, activeConnectCount, allUserNameList, startTime, createtTime, cpuRate));
}
}
private void btnDatabasePropertyInfo_Click(object sender, EventArgs e)
{
try
{
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
DatabasePropertyInfo databasePropertyInfo = dbAccess.Database.GetDatabasePropertyInfo();
Loger.Info($"[{config.ConName}] [{databasePropertyInfo.ToString()}]");
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
/// <summary> /// 获取数据库属性信息 /// </summary> /// <param name="lastDatabasePropertyInfo">前一次获取到的数据库属性信息</param> /// <returns>数据库属性信息</returns> protected abstract DatabasePropertyInfo PrimitiveGetDatabasePropertyInfo(DatabasePropertyInfo lastDatabasePropertyInfo);
/// <summary>
/// 获取数据库属性信息
/// </summary>
/// <returns>数据库属性信息</returns>
public DatabasePropertyInfo GetDatabasePropertyInfo()
{
this._lastDatabasePropertyInfo = this.PrimitiveGetDatabasePropertyInfo(this._lastDatabasePropertyInfo);
return(this._lastDatabasePropertyInfo);
}
