private List <SystemLogStatus> GetSystemlogStatus()
{
List <SystemLogStatus> _ret = new List <SystemLogStatus>();
Dictionary <string, string> _connList = new Dictionary <string, string>();
foreach (ConnectionStringSettings _cstr in ConfigurationManager.ConnectionStrings)
{
if (_cstr.ProviderName == "System.Data.OracleClient")
{
_connList.Add(_cstr.Name, _cstr.ConnectionString);
}
}
CheckSystemLogConfigSection SystemList = (CheckSystemLogConfigSection)ConfigurationManager.GetSection("CheckSystemLogList");
foreach (CheckSystemLogConfigurationElement _el in SystemList.PluginCollection)
{
SystemLogStatus _wss = new SystemLogStatus();
_wss.Name = _el.Name;
_wss.Description = _el.Description;
CheckSystemLogConfigSection(_wss, _el.ConnectName, _connList);
_ret.Add(_wss);
}
return(_ret);
}
private void CheckSystemLogConfigSection(SystemLogStatus _wss, string cName, Dictionary <string, string> _connList)
{
if (_connList.ContainsKey(cName))
{
string _cstr = _connList[cName];
_wss.ErrorNum = 0;
_wss.InfoNum = 0;
using (OracleConnection cn = new OracleConnection(_cstr))
{
try
{
cn.Open();
OracleCommand _cmd = new OracleCommand(SQL_CountQueryLogError, cn);
_cmd.Parameters.Add(":COUNTDATE", DateTime.Now.Date.AddDays(-7));
decimal _errnum = (decimal)_cmd.ExecuteScalar();
_wss.ErrorNum = Convert.ToInt32(_errnum);
OracleCommand _cmd2 = new OracleCommand(SQL_CountQueryLogAll, cn);
_cmd2.Parameters.Add(":COUNTDATE", DateTime.Now.Date.AddDays(-7));
decimal _allnum = (decimal)_cmd2.ExecuteScalar();
_wss.InfoNum = Convert.ToInt32(_allnum - _errnum);
}
catch (Exception ex)
{
_wss.ErrorNum = -1;
_wss.InfoNum = -1;
}
}
}
else
{
_wss.ErrorNum = -1;
_wss.InfoNum = -1;
}
}
private dynamic GetFlag(SystemLogStatus _ws)
{
if (_ws.ErrorNum > 0)
{
return("3");
}
return("1");
}
private void CheckSystemLogConfigSection(SystemLogStatus _wss, string cName, Dictionary <string, string> _connList)
{
if (_connList.ContainsKey(cName))
{
string _cstr = _connList[cName];
_wss.ErrorNum = 0;
_wss.InfoNum = 0;
using (OracleConnection cn = new OracleConnection(_cstr))
{
try
{
cn.Open();
OracleCommand _cmd = new OracleCommand(SQL_CountSystemLogError, cn);
_cmd.Parameters.Add(":COUNTDATE", DateTime.Now.Date.AddDays(-7));
using (OracleDataReader _dr = _cmd.ExecuteReader())
{
while (_dr.Read())
{
string _errtype = _dr.IsDBNull(0) ? "" : _dr.GetString(0);
decimal _errnum = _dr.IsDBNull(1) ? (decimal)0 : _dr.GetDecimal(1);
if (_errtype.ToUpper() == "INFO")
{
_wss.InfoNum = Convert.ToInt32(_errnum);
}
else
{
_wss.ErrorNum = _wss.ErrorNum + Convert.ToInt32(_errnum);
}
}
_dr.Close();
}
}
catch (Exception ex)
{
_wss.ErrorNum = -1;
_wss.InfoNum = -1;
}
}
}
else
{
_wss.ErrorNum = -1;
_wss.InfoNum = -1;
}
}
