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