public List <Model.Project_Schedule> getProject_Schedule()
{
List <Model.Project_Schedule> project = new List <Model.Project_Schedule>();
DataTable da = SqlHelper.GetTable("getProject_Schedule", CommandType.StoredProcedure, null);
Model.Project_Schedule p = null;
foreach (DataRow row in da.Rows)
{
p = new Model.Project_Schedule();
p.p_id = Convert.ToInt16(row["ID"]);
p.p_name = row["name"].ToString();
p.p_type = row["type"].ToString();
// p.p_type = ConvertToLevel("b");
p.target_level = ConvertToLevel(row["target_level"].ToString());
p.create_time = Convert.ToDateTime(row["create_time"]).ToString("yyyy-MM-dd");;
p.f_time = Convert.ToDateTime(row["end_time"]).ToString("yyyy-MM-dd");;
p.declarant = getDeclarant(p.p_id);
p.schedule = getSchedule(p.p_id);
p.leader = getLeader(p.p_id);
p.s_time = Convert.ToDateTime(row["start_time"]).ToString("yyyy-MM-dd");
project.Add(p);
}
return(project);
}
public List<Model.Project_Schedule> getProject_Schedule()
{
List<Model.Project_Schedule> project = new List<Model.Project_Schedule>();
DataTable da = SqlHelper.GetTable("getProject_Schedule", CommandType.StoredProcedure, null);
Model.Project_Schedule p = null;
foreach (DataRow row in da.Rows)
{
p = new Model.Project_Schedule();
p.p_id = Convert.ToInt16(row["ID"]);
p.p_name = row["name"].ToString();
p.p_type = row["type"].ToString();
// p.p_type = ConvertToLevel("b");
p.target_level = ConvertToLevel(row["target_level"].ToString());
p.create_time = Convert.ToDateTime(row["create_time"]).ToString("yyyy-MM-dd");;
p.f_time = Convert.ToDateTime(row["end_time"]).ToString("yyyy-MM-dd");;
p.declarant = getDeclarant(p.p_id);
p.schedule = getSchedule(p.p_id);
p.leader = getLeader(p.p_id);
p.s_time = Convert.ToDateTime(row["start_time"]).ToString("yyyy-MM-dd");
project.Add(p);
}
return project;
}
