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; } }