public void showTermScore()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
string mynum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DLterm.DataSource = tbll.GetSnumTermList(mynum);
DLterm.DataBind();
}
}
public void showTermScore()
{
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
LearnSite.Model.Cook cook = new LearnSite.Model.Cook();
string mynum = cook.Snum;
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DLterm.DataSource = tbll.GetSnumTermList(mynum);
DLterm.DataBind();
}
}
protected void BtnExcel_Click(object sender, EventArgs e)
{
string ty = DDLYear.SelectedValue;
string tg = DDLgrade.SelectedValue;
string tt = DDLterm.SelectedValue;
if (ty != "" && tg != "" && tt != "")
{
int tyear = Int32.Parse(ty);
int tgrade = Int32.Parse(tg);
int tterm = Int32.Parse(tt);
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
tbll.TotalTermExcel(tyear, tgrade, tterm);
}
}
protected void Btnape_Click(object sender, EventArgs e)
{
DateTime nowtime1 = DateTime.Now;
LearnSite.BLL.Students stus = new LearnSite.BLL.Students();
int perA = int.Parse(DDLA.SelectedValue);
int perE = int.Parse(DDLE.SelectedValue);
stus.TermAPE(perA, perE);//开始自动评价汇总，perA百分比为A优秀，perE百分比为E待合格，其余为合格
DateTime nowtime2 = DateTime.Now;
System.Threading.Thread.Sleep(1000);
LearnSite.BLL.TermTotal mbll = new LearnSite.BLL.TermTotal();
mbll.TermScore();//生成学期统计表
Labelmsg.Text = "自动评价用时：" + LearnSite.Common.Computer.DatagoneMilliseconds(nowtime1, nowtime2) + "毫秒，本学期成绩自动存档成功！";
showstudents();
}
private void showTermScores()
{
string ty = DDLYear.SelectedValue;
string tg = DDLgrade.SelectedValue;
string ts = DDLclass.SelectedValue;
string tt = DDLterm.SelectedValue;
if (ty != "" && tg != "" && ts != "" && tt != "")
{
int tyear = Int32.Parse(ty);
int tgrade = Int32.Parse(tg);
int tclass = Int32.Parse(ts);
int tterm = Int32.Parse(tt);
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
GVTermScore.DataSource = tbll.GetGradeTermScore(tyear, tgrade, tclass, tterm);
GVTermScore.DataBind();
}
}
private void Grade()
{
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DDLYear.DataSource = tbll.TyearList();
DDLYear.DataTextField = "Tyear";
DDLYear.DataValueField = "Tyear";
DDLYear.DataBind();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLclass.DataSource = room.GetClass();
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
}
private void Grade()
{
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DDLYear.DataSource = tbll.TyearList();
DDLYear.DataTextField = "Tyear";
DDLYear.DataValueField = "Tyear";
DDLYear.DataBind();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLgrade.SelectedIndex = 0;
DDLclass.DataSource = room.GetLimitClass(Int32.Parse(DDLgrade.SelectedValue));
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
}
private void showSgrade()
{
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DDLYear.DataSource = tbll.TyearList();
DDLYear.DataTextField = "Tyear";
DDLYear.DataValueField = "Tyear";
DDLYear.DataBind();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
CBgrades.DataSource = room.GetAllGrade().Tables[0];
CBgrades.DataTextField = "Rgrade";
CBgrades.DataValueField = "Rgrade";
CBgrades.DataBind();
int count = CBgrades.Items.Count;
for (int i = 0; i < count; i++)
{
CBgrades.Items[i].Selected = true;
}
}
private void showGv()
{
string tyear = DDLYear.SelectedValue;
if (tyear != null)
{
string cgrades = "";
int count = CBgrades.Items.Count;
for (int i = 0; i < count; i++)
{
if (CBgrades.Items[i].Selected)
{
cgrades = cgrades + "," + CBgrades.Items[i].Value;
}
}
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DateTime d1 = DateTime.Now;
GVapes.DataSource = tbll.GetMerit(Int32.Parse(tyear), cgrades);
GVapes.DataBind();
DateTime d2 = DateTime.Now;
Labelmsg.Text = "学生总数：" + GVapes.Rows.Count.ToString() + "位，查询费时：" + LearnSite.Common.Computer.DatagoneMilliseconds(d1, d2) + "毫秒";
}
}