private void Get_TDlist_threadRun()
{
if (this.curr_reader == null)
{
return;
}
while (this.curr_reader.Read())
{
if (this.threadStop_flag)
{
break;
}
Task_Detail td = new Task_Detail();
td.Init_from_reader(this.curr_reader);
this.taskDetail_list.Add(td);
}
Thread th = new Thread(this.curr_reader.Close);
th.Name = "DB Reader thread " + DateTime.Now.ToString();
th.Start();
this.dataFinishedLoading_flag = true;
}
public static List <Task_Detail> GetTaskDetail_list(int taskID, string sourceID, string taskName)
{
List <Task_Detail> list = new List <Task_Detail>();
DB_select db_sel = new DB_select(Task_Detail.Get_cmdTP());
SQL_relation rela0 = new SQL_relation("TaskID", RelationalOperator.Equals, taskID);
SQL_relation rela1 = new SQL_relation("sourceID", RelationalOperator.Equals, sourceID);
SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1);
if (taskName != null)
{
SQL_relation rela2 = new SQL_relation("TaskName", RelationalOperator.Equals, taskName);
cond = new SQL_condition(cond, ConditionalOperator.And, rela2);
}
db_sel.SetCondition(cond);
DB_reader reader = new DB_reader(db_sel, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Task_Detail dp = new Task_Detail();
dp.Init_from_reader(reader);
list.Add(dp);
}
reader.Close();
return(list);
}