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