public ActionResult TeaQueryGrade(int classid, int projectid)
{
ViewBag.ProjectID = new SelectList(rb.GetProjects(), "ID", "ProjectName", projectid);
ViewBag.ClassID = new SelectList(cb.GetClasses(), "ID", "ClassName", classid);
var dt = new DataTable();
if (Request.Params["ScoreOrder"] == "false")
{
dt = rb.GetSumGrade(projectid, classid);
ViewBag.ScoreOrder = false;
}
else
{
dt = rb.GetSumGradeOrder(projectid, classid);
ViewBag.ScoreOrder = true;
}
var QGM = new QueryGradeModel();
QGM.DT = dt;
if (Request.Params["outexcel"] != null)
{
DataTable2Excel(dt);
}
return(View(QGM));
}
public ActionResult StuQueryGrade(string reviewstuno)
{
ViewBag.ProjectID = new SelectList(rb.GetProjects(), "ID", "ProjectName");
var QGM = new QueryGradeModel();
QGM.DT = new DataTable();
QGM.StuNo = reviewstuno;
return(View(QGM));
}
public ActionResult TeaQueryGrade(int TeacherID)
{
ViewBag.ProjectID = new SelectList(rb.GetProjects(), "ID", "ProjectName");
ViewBag.ClassID = new SelectList(cb.GetClasses(), "ID", "ClassName");
var QGM = new QueryGradeModel();
QGM.DT = new DataTable();
QGM.TeacherID = TeacherID;
return(View(QGM));
}
public ActionResult StuQueryGrade(string reviewstuno, string projectid)
{
ViewBag.ProjectID = new SelectList(rb.GetProjects(), "ID", "ProjectName", projectid);
var dt = new DataTable();
if (!string.IsNullOrEmpty(projectid) && !string.IsNullOrEmpty(reviewstuno))
{
int proid = int.Parse(projectid);
dt = rb.GetSumGrade(proid, reviewstuno);
}
var QGM = new QueryGradeModel();
QGM.DT = dt;
QGM.StuNo = reviewstuno;
return(View(QGM));
}