public TaskModel GetById(string conn, string taskid) { TaskModel task = new TaskModel(); string sql = "SELECT Id,TaskName,TaskDescription,CategoryId,NodeId,TaskCreateTime,TaskUpdateTime,TaskStartTime,TaskStopTime,TaskCron,TaskState,TaskClassPath,TaskFileName,TaskClassNamespace FROM Task WHERE Id=@taskid"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@taskid", taskid) }; DataTable dt = SqlServerHelper.Get(conn, sql, parameters); if (dt.Rows.Count > 0) { task = TaskModel.CreateModel(dt.Rows[0]); } return(task); }
public List <TaskModel> List(string conn) { List <TaskModel> list = new List <TaskModel>(); string sql = "SELECT Id,TaskName,TaskDescription,CategoryId,NodeId,TaskCreateTime,TaskUpdateTime,TaskStartTime,TaskStopTime,TaskCron,TaskState,TaskClassPath,TaskFileName,TaskClassNamespace FROM Task"; DataTable dt = SqlServerHelper.Get(conn, sql); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { TaskModel model = new TaskModel(); model = TaskModel.CreateModel(dt.Rows[i]); list.Add(model); } } return(list); }