private void ShowClassTop()
{
int Qgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int Qclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
LearnSite.BLL.Students st = new LearnSite.BLL.Students();
GridViewclass.DataSource = st.TopClassQuiz(Qgrade, Qclass);
GridViewclass.DataBind();
}
private void showattitude()
{
LearnSite.Model.Cook cook = new LearnSite.Model.Cook();
Labeltitle.Text = cook.Sgrade.ToString() + "年级" + cook.Sclass.ToString() + "班本学期学习表现积分排行";
LearnSite.BLL.Students sbll = new LearnSite.BLL.Students();
GridViewclass.DataSource = sbll.GetListSattitude(cook.Syear, cook.Sgrade, cook.Sclass);
GridViewclass.DataBind();
}
private void showattitude()
{
int Sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int Sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
int Syear = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Syear"].ToString());
Labeltitle.Text = Sgrade.ToString() + "年级" + Sclass.ToString() + "班本学期学习表现积分排行";
LearnSite.BLL.Students sbll = new LearnSite.BLL.Students();
GridViewclass.DataSource = sbll.GetListSattitude(Syear, Sgrade, Sclass);
GridViewclass.DataBind();
}
private void showQscore()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
int Sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int Sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
LearnSite.BLL.Result bll = new LearnSite.BLL.Result();
GridViewclass.DataSource = bll.GetListTodayScore(Sgrade, Sclass);
GridViewclass.DataBind();
Labeltitle.Text = DateTime.Now.ToLongDateString() + "今天班级常识测验排行榜";
Labelmsg.Text = "未测验同学名单：<br/><br/>" + bll.GetListTodayNoScore(Sgrade, Sclass);
}
}
private void showQscore()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
LearnSite.Model.Cook cook = new LearnSite.Model.Cook();
int Sgrade = cook.Sgrade;
int Sclass = cook.Sclass;
LearnSite.BLL.Result bll = new LearnSite.BLL.Result();
GridViewclass.DataSource = bll.GetListTodayScore(Sgrade, Sclass);
GridViewclass.DataBind();
Labeltitle.Text = DateTime.Now.ToLongDateString() + "今天班级常识测验排行榜";
Labelmsg.Text = "未测验同学名单：<br/><br/>" + bll.GetListTodayNoScore(Sgrade, Sclass);
}
}
private void showFscore()
{
if (Request.QueryString["Vid"] != null)
{
int sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
int vid = Int32.Parse(Request.QueryString["Vid"].ToString());
LearnSite.BLL.SurveyFeedback fbll = new LearnSite.BLL.SurveyFeedback();
GridViewclass.DataSource = fbll.GetClassFscore(sgrade, sclass, vid);
GridViewclass.DataBind();
LearnSite.BLL.Survey vbll = new LearnSite.BLL.Survey();
LearnSite.Model.Survey model = new LearnSite.Model.Survey();
model = vbll.GetModel(vid);
Labeltitle.Text = HttpUtility.HtmlDecode(model.Vtitle);
if (GridViewclass.Rows.Count < 1)
{
Labelmsg.Text = "暂无排行！";
}
}
}
private void showtotal()
{
string cidSelect = DDLCid.SelectedValue;
if (!string.IsNullOrEmpty(cidSelect))
{
DateTime dt1 = DateTime.Now;
int Sgrade = Int32.Parse(Request.QueryString["wGrade"].ToString());
int Sclass = Int32.Parse(Request.QueryString["wClass"].ToString());
int Cid = Int32.Parse(cidSelect);
LearnSite.BLL.Courses cbll = new LearnSite.BLL.Courses();
string Ctitle = cbll.GetTitle(Cid);
DataTable dt = cbll.CourseTotals(Cid, Sgrade, Sclass);
string clm = RBsort.SelectedValue;
if (dt.Columns.Contains("汇总"))
{
if (clm == "汇总")
{
dt.DefaultView.Sort = clm + " desc";
}
else
{
dt.DefaultView.Sort = clm + " asc";
}
}
else
{
dt.DefaultView.Sort = " 学号 asc";
}
GridViewclass.DataSource = dt.DefaultView.ToTable();
GridViewclass.DataBind();
LearnSite.BLL.Students sbll = new LearnSite.BLL.Students();
DataTable dtg = sbll.groupscores(Sgrade, Sclass, dt, Cid);
string sl = RBsortGroup.SelectedValue;
switch (sl)
{
case "0":
break; //默认排序
case "1":
dtg.DefaultView.Sort = "Sgscore desc,Svscore desc";
break;
case "2":
dtg.DefaultView.Sort = "Svscore desc,Sgscore desc";
break;
case "3":
dtg.DefaultView.Sort = "Sgwork desc,Svscore desc,Sgscore desc";
break;
case "4":
dtg.DefaultView.Sort = "Sgattitude desc,Sgwork desc,Svscore desc,Sgscore desc";
break; //Sgattitude
}
DataList1.DataSource = dtg.DefaultView.ToTable();
DataList1.DataBind();
if (DataList1.Items.Count == 0)
{
RBsortGroup.Visible = false;
}
dtg.Dispose();
dt.Dispose();//强制释放
DateTime dt2 = DateTime.Now;
Labelmsg.Text = "汇总费时：" + LearnSite.Common.Computer.DatagoneMilliseconds(dt1, dt2) + "毫秒";
this.Page.Title = LabelGradeClass.Text + "《" + DDLCid.SelectedItem.Text + "》学习汇总";
}
}
private void ShowClassTop()
{
LearnSite.BLL.Students st = new LearnSite.BLL.Students();
GridViewclass.DataSource = st.TopClassQuiz(cook.Sgrade, cook.Sclass);
GridViewclass.DataBind();
}