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