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