public static string getDetail(List <Model.Project_Achievement> project, int ID)
{
project = (from result in project where result.p_id == ID select result).ToList();
Model.Project_Achievement p = project[0];
string str0 = p.p_name;
string str1 = p.p_type;
string str2 = p.leader.nickname;
string str3 = string.Format("姓名:{0}, 手机号码:{1}, 邮箱:{2}", p.leader.nickname, p.leader.phone, p.leader.email);
string str4 = null;
foreach (Model.Member m in p.member)
{
str4 += m.nickname + " ";
}
string str5 = p.now_level;
string str6 = p.create_time;
string str7 = p.f_time;
string htmlstr = string.Format("{{ \"p_name\": \"{0}\", \"type\": \"{1}\", \"st_name\": \"{2}\", \"st_detail\": \"{3}\", \"group\": \"{4}\", \"rank\": \"{5}\", \"s_time\": \"{6}\", \"f_time\": \"{7}\"}}", str0, str1, str2, str3, str4, str5, str6, str7);
return(htmlstr);
}
public List <Model.Project_Achievement> getProject_Achievement()
{
List <Model.Project_Achievement> project = new List <Model.Project_Achievement>();
DataTable da = SqlHelper.GetTable("getProject_Achievement", CommandType.StoredProcedure, null);
Model.Project_Achievement p = null;
foreach (DataRow row in da.Rows)
{
p = new Model.Project_Achievement();
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.now_level = ConvertToLevel(row["now_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.leader = getLeader(p.p_id);
p.member = getMember(p.p_id);
project.Add(p);
}
return(project);
}
public List<Model.Project_Achievement> getProject_Achievement()
{
List<Model.Project_Achievement> project = new List<Model.Project_Achievement>();
DataTable da = SqlHelper.GetTable("getProject_Achievement", CommandType.StoredProcedure, null);
Model.Project_Achievement p=null;
foreach(DataRow row in da.Rows ){
p = new Model.Project_Achievement();
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.now_level =ConvertToLevel( row["now_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.leader=getLeader(p.p_id);
p.member = getMember(p.p_id);
project.Add(p);
}
return project;
}
