private List <CheckTaskStatus> GetTaskStatus()
{
List <CheckTaskStatus> _ret = new List <CheckTaskStatus>();
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);
}
}
CheckTaskConfigSection TaskList = (CheckTaskConfigSection)ConfigurationManager.GetSection("CheckTaskList");
foreach (CheckTaskConfigurationElement _el in TaskList.PluginCollection)
{
CheckTaskStatus _wss = new CheckTaskStatus();
_wss.Name = _el.Name;
_wss.Description = _el.Description;
_wss.RWID = _el.RWID;
GetTaskRunFlag(_wss, _el.ConnectName, _connList);
_ret.Add(_wss);
}
return(_ret);
}
private string GetFlag(CheckTaskStatus _ws)
{
if (_ws.RWZT == 5)
{
return("4");
}
switch (_ws.LastRunFlag)
{
case 0:
return("1");
case 9:
return("3");
default:
return("2");
}
}
private void GetTaskRunFlag(CheckTaskStatus _wss, string cName, Dictionary <string, string> _connList)
{
if (_connList.ContainsKey(cName))
{
string _cstr = _connList[cName];
using (OracleConnection cn = new OracleConnection(_cstr))
{
try
{
cn.Open();
OracleCommand _cmd = new OracleCommand(SQL_GetTaskRunFlag, cn);
_cmd.Parameters.Add(":RWID", decimal.Parse(_wss.RWID));
using (OracleDataReader _dr = _cmd.ExecuteReader())
{
while (_dr.Read())
{
_wss.Description = _dr.IsDBNull(0) ? "" : _dr.GetString(0);
_wss.LastRunFlag = _dr.IsDBNull(1) ? (int)-1 : Convert.ToInt32(_dr.GetDecimal(1));
_wss.RWZT = _dr.IsDBNull(2) ? (int)-1 : Convert.ToInt32(_dr.GetDecimal(2));
}
_dr.Close();
}
OracleCommand _cmd2 = new OracleCommand(SQL_GetErrorNum, cn);
_cmd2.Parameters.Add(":RUNTIME", DateTime.Now.Date.AddDays(-7));
_cmd2.Parameters.Add(":RWID", decimal.Parse(_wss.RWID));
decimal _count = (decimal)_cmd2.ExecuteScalar();
_wss.ErrorNum = Convert.ToInt32(_count);
}
catch (Exception ex)
{
_wss.LastRunFlag = -1;
_wss.RWZT = -1;
}
}
}
else
{
_wss.ErrorNum = -1;
_wss.LastRunFlag = -1;
_wss.RWZT = -1;
}
}
