monitordbclass.cs

监控系统

using System;
using System.Data;
using System.Data.OleDb;

namespace MonitorSystem.BasicClass
{
	/// <summary>
	/// MonitorDBClass 的摘要说明。
	/// </summary>
	public class DbTableSpaceRule:MonitorRule
	{
		public string Connstring;
		public string SqlScript;
		public string KeyField;

		/// <summary>
		/// 获取应用系统中数据库的监控信息
		/// </summary>
		/// <param name="strConnection">数据库连接字符串</param>
		/// <param name="strSql">查询语句</param>
		/// <returns>监控信息</returns>
		public object GetAppDBInfo(string strConnection, string strSql)
		{
			int ret=0;
			OleDbConnection conn=null;
			OleDbCommand comm=null;

			try
			{
				conn = new OleDbConnection(strConnection);
				conn.Open();
				comm = new OleDbCommand();
				comm.Connection=conn;

				comm.CommandText=strSql;
				ret = (int)comm.ExecuteScalar();
			}
			catch(Exception)
			{
				ret=-1;
			}
			finally
			{
				if(comm!=null)
				{
					comm=null;
				}
				if(conn!=null)
				{
					conn.Close();
				}
			}
			
			return ret;
		}

		public override object ExcuteCollect()
		{
			this.LastExcuteTime = DateTime.Now;
			return GetAppDBInfo(this.Connstring, this.SqlScript);
		}
	}

	public class DbListenerRule:MonitorRule
	{
		public override object ExcuteCollect()
		{

			this.LastExcuteTime = DateTime.Now;
			return 0;
		}
	}

	public class DbLogRule:MonitorRule
	{
		public override object ExcuteCollect()
		{

			this.LastExcuteTime = DateTime.Now;
			return 0;
		}
	}
}