/// <summary>
/// 获得所有任务清单
/// </summary>
/// <returns>IList[Tasks]()</returns>
public IList <Tasks> GetTaskList()
{
IList <Tasks> task = new List <Tasks>();
Tasks t = null;
OracleDataReader dr;
try
{
string sql = "select * from qm_task where taskstate = 'Y' order by taskcreatetime desc";
dr = qmdb.ExecuteReader(CommandType.Text, sql);
while (dr.Read())
{
t = new Tasks();
t.idx = dr["IDX"].ToString();
t.taskClsType = dr["TASKCLSTYPE"].ToString();
t.taskCount = dr["TASKCOUNT"].ToString();
t.taskCreateTime = DateTime.Parse(dr["TASKCREATETIME"].ToString());
if (dr["TASKLASTSTARTTIME"].ToString() != "")
{
t.taskLastStartTime = DateTime.Parse(dr["TASKLASTSTARTTIME"].ToString());
}
if (dr["TASKLASTENDTIME"].ToString() != "")
{
t.taskLastEndTime = DateTime.Parse(dr["TASKLASTENDTIME"].ToString());
}
if (dr["TASKLASTERRORTIME"].ToString() != "")
{
t.taskLastErrorTime = DateTime.Parse(dr["TASKLASTERRORTIME"].ToString());
}
if (dr["TASKERRORCOUNT"].ToString() != "")
{
t.taskErrorCount = int.Parse(dr["TASKERRORCOUNT"].ToString());
}
t.taskType = dr["TASKTYPE"].ToString();
t.taskDBCon = dr["TASKDBCON"].ToString();
t.taskParm = dr["TASKPARM"].ToString();
t.taskFile = dr["TASKFILE"].ToString();
//t.taskExpFile = dr["TASKEXPFILE"].ToString();
t.taskName = dr["TASKNAME"].ToString();
t.taskState = dr["TASKSTATE"].ToString();
t.taskCron = dr["TASKCRON"].ToString();
t.taskRemark = dr["TASKREMARK"].ToString();
t.taskSendby = dr["TASKSENDBY"].ToString();
task.Add(t);
}
dr.Close();
}
catch (QMException ex)
{
throw ex;
}
finally
{
qmdb.Disponse();
}
return(task);
}
public IList <TaskLog> GetLogList(string idx)
{
IList <TaskLog> task = new List <TaskLog>();
TaskLog t = null;
OracleDataReader dr;
try
{
string sql = "select * from qm_tasklog";
if (idx != "")
{
sql += " where taskid='" + idx + "'";
}
sql += " order by createtime";
dr = qmdb.ExecuteReader(CommandType.Text, sql);
while (dr.Read())
{
t = new TaskLog();
t.idx = dr["IDX"].ToString();
t.taskid = dr["TASKID"].ToString();
t.type = dr["TYPE"].ToString();
t.server = dr["SERVER"].ToString();
t.createtime = dr["CREATETIME"].ToString();
t.message = dr["MESSAGE"].ToString();
task.Add(t);
}
dr.Close();
}
catch (QMException ex)
{
throw ex;
}
finally
{
qmdb.Disponse();
}
return(task);
}
