private void showMemeberDetail()
{
long[] dt = ProjectDll.DAL.ProjectDal.GetProjUser();
List <Proj_VUserScore> pslist = ProjectDll.DAL.ProjectDal.GetProjMemScoreById(memberId);
Proj_VUserScore userInfo = new Proj_VUserScore();
userInfo = pslist.FirstOrDefault();
imageUser.ImageUrl = "http://va.neu.edu.cn/my/User%20Photos/Profile%20Pictures/" + userInfo.Account + "_MThumb.jpg";
userName.InnerText = userInfo.Name;
if (memberScore == "")
{
pSumScore.Visible = false;
}
else
{
pSumScore.InnerText = "积分：" + memberScore;
}
ddSchoolName.InnerText = "单位：" + userInfo.SchoolName;
if (memberRank == 0)
{
ddRank.Visible = false;
}
else
{
ddRank.InnerText = "排名：" + memberRank + "/" + (dt.Length.ToString()); //头像及一些基本信息
}
//HtmlContainerControl htmlLi;
// htmlLi = new HtmlGenericControl("li");
HtmlContainerControl htmlUl = new HtmlGenericControl("ul");
foreach (var item in pslist)
{
string str = "";
str += "<li><dl class='clearfix'><dd class='science-competition-title'>";
str += "<strong><a href = 'PDetails.aspx?ProjectID=" + item.ProjectID + "&pageTypeId=0' target ='_blank'>" + item.PName + "</a></strong>";
str += "<div class='competition-info clearfix'><span class='status-over'>加入时间:" + item.ApplyInTime + "</span>";
str += "<div class='cp-box'><span class='competition'>项目状态:" + item.StateName + "</span>";
str += "<span class='competition'>个人得分:" + item.Score + "</span>";
str += "<span class='competition'>项目得分：" + item.PScore + "</span>";
str += "</div></div></dd></dl></li>";
htmlUl.Controls.Add(new LiteralControl(str));
//htmlUl.Attributes.Add("class", "science-list clearfix");
}
divProjectList.Controls.Add(htmlUl);
}
private void showProjTopMan()
{
HtmlContainerControl htmlLi;
htmlLi = new HtmlGenericControl("li");
HtmlContainerControl htmlUl = new HtmlGenericControl("ul");
long[] dt = ProjectDll.DAL.ProjectDal.GetProjUser(); //得到参加过项目的UserID
List <Proj_VUserScore> pslist = new List <Proj_VUserScore>();
DataTable dtSumScore = CreateUserScoreTable();
double fSumScore = 0.0;
Proj_VUserScore userInfo = new Proj_VUserScore();
for (int i = 0; i < dt.Length; i++) //将用户的信息和总积分存储到dataTable dtSumScore中
{
DataRow dr = dtSumScore.NewRow();
pslist = ProjectDll.DAL.ProjectDal.GetProjMemScoreById(dt[i]);
userInfo = pslist.FirstOrDefault();
foreach (var item in pslist)
{
fSumScore += (double)item.Score * (double)item.PScore;
}
fSumScore = fSumScore / 100.0;
dr["UserID"] = dt[i];
dr["SumScore"] = fSumScore;
dr["Name"] = userInfo.Name;
dr["SchoolName"] = userInfo.SchoolName;
dr["Account"] = userInfo.Account;
dtSumScore.Rows.Add(dr);
fSumScore = 0.0;
}
/*
* 对总分进行排序，得到DataTable t
*/
DataRow[] rows = dtSumScore.Select("", "SumScore desc");
DataTable t = dtSumScore.Clone();
t.Clear();
foreach (DataRow row in rows)
{
t.ImportRow(row);
}
int temp = 100;
if (dtSumScore.Rows.Count < 100)
{
temp = t.Rows.Count;
}
for (int i = 0; i < temp; i++)
{
string jifen = string.Format("{0:###.##}", t.Rows[i][1]);
string str = "<li><dl><dt><a href ='MemberDetail.aspx?userId=" + t.Rows[i][0] + "&sumScore=" + jifen + "&Rank=" + (i + 1).ToString() + "' target = '_blank'>";
string imgurl = "./images/headgif.gif";
string headImg = "http://va.neu.edu.cn/my/User%20Photos/Profile%20Pictures/" + t.Rows[i][4] + "_LThumb.jpg";
if (ProjectDll.DAL.Common.UrlCheck(headImg))
{
imgurl = headImg;
}
str += "<img width = '180' height = '180' src = '" + imgurl + "' border = 'none'></a></dt>";
str += "<dd class='science-list-rank-text'>";
str += "<a href = 'MemberDetail.aspx?userId=" + t.Rows[i][0] + "&sumScore=" + jifen + "&Rank=" + (i + 1).ToString() + "' target = '_blank'>" + t.Rows[i][2] + "</a>";
str += "<span>排名:<em>" + (i + 1).ToString() + "</em>/" + t.Rows.Count + "</span></dd>";
str += "<dd class='science-school'> <abbr title='学校名称' rel='tooltip'>" + t.Rows[i][3] + "</abbr>";
str += "<span style='padding-left:60px;'>积分:<em>" + jifen + "</em> </span>";
str += "</dd></dl></li>";
htmlUl.Controls.Add(new LiteralControl(str));
htmlUl.Attributes.Add("class", "science-list clearfix");
}
divTopman.Controls.Add(htmlUl);
}
