123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 |
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.Mvc;
- using EMIS.CommonLogic.EvaluationManage;
- using EMIS.CommonLogic.CalendarManage;
- using EMIS.ViewModel;
- using Bowin.Common.Data;
- using Bowin.Common.Utility;
- using EMIS.Web.Controls;
- using Bowin.Web.Controls.Mvc;
- using System.Linq.Expressions;
- using EMIS.Entities;
- namespace EMIS.Web.Controllers.EvaluationManage.StudentEvaluationCount
- {
- [Authorization]
- public class StudentEvaluationCountController : Controller
- {
- //
- // GET: /StudentEvaluationCount/
- public IStudentEvaluationCountServices StudentEvaluationCountServices { get; set; }
- public ISchoolYearServices SchoolYearServices { get; set; }
- [HttpGet]
- public ActionResult List()
- {
- var schoolYear = SchoolYearServices.GetSchoolYearIsCurrent(true);
- ViewBag.SchoolYearID = schoolYear == null ? "-1" : schoolYear.SchoolyearID.ToString();//默认当前学年
- return View();
- }
- [HttpPost]
- public ActionResult List(QueryParamsModel pararms)
- {
- ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(pararms);
- var classID = pararms.getExtraGuid("cgClassmajor"); //班级名称
- var standardID = pararms.getExtraInt("ddlStandard");//专业名称
- var SchoolyearNumID = pararms.getExtraInt("ddlYear") == Bowin.Web.Controls.Mvc.DropdownList.SELECT_ALL ? null : pararms.getExtraInt("ddlYear");//年级
- var collegeID = pararms.getExtraGuid("cgCollege");//院系所
- var schoolyearID = pararms.getExtraGuid("SchoolYearDropdown"); //学年学期
- var result = StudentEvaluationCountServices.GetStudentView(configuretView, SchoolyearNumID, collegeID, schoolyearID, standardID, classID, (int)pararms.page, (int)pararms.rows);
- return Json(result);
- }
- #region 2.0 列表信息导出
- [HttpPost]
- public ActionResult Excel()
- {
- try
- {
- NpoiExcelHelper neh = new NpoiExcelHelper();
- ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(null);
- //var subjectID = Request.Form["ddlExaminationSubject"].ParseStrTo<Guid>();
- var collegeID = Request.Form["cgCollege"].ParseStrTo<Guid>();
- var schoolyearID = Request.Form["SchoolYearDropdown"].ParseStrTo<Guid>();
- var classID = Request.Form["cgClassmajor"].ParseStrTo<Guid>();
- //var examinationTypeID = Request.Form["cgExamination"].ParseStrTo<Guid>();
- var SchoolyearNumID = Request.Form["ddlYear"].ParseStrTo<int>() == Bowin.Web.Controls.Mvc.DropdownList.SELECT_ALL ? null : Request.Form["ddlYear"].ParseStrTo<int>();
- var standardID = Request.Form["ddlStandard"].ParseStrTo<int>() == Bowin.Web.Controls.Mvc.DropdownList.SELECT_ALL ? null : Request.Form["ddlStandard"].ParseStrTo<int>();
- var dt = StudentEvaluationCountServices.GetStudentView(configuretView, SchoolyearNumID, collegeID, schoolyearID, standardID, classID).Select(x => new
- {
- x.StudentNo,
- x.Name,
- x.ClassmajorName,
- x.NeedEvaluationCount,
- x.CompleteCount,
- x.UncompletedCount
- }).ToTable();
- string[] liststring = { "学号", "姓名", "班级名称", "需评人次", "已评人次", "未评人次" };
- //string[] liststring = { "评价编号", "课程名称", "评价类型 ", "被评教师号", "被评教师", "任务班名称", "参评类型 ", "已评次数" };
- neh.Export(dt, liststring, "学生评价人次");
- return RedirectToAction("MsgShow", "Common", new
- {
- msg = "导出成功!",
- url = Url.Content("~/StudentEvaluationCount/List").AddMenuParameter()
- });
- }
- catch (Exception ex)
- {
- return RedirectToAction("MsgShow", "Common", new
- {
- msg = "导出失败,原因:" + ex.Message + "!",
- url = Url.Content("~/StudentEvaluationCount/List").AddMenuParameter()
- });
- }
- }
- #endregion
- }
- }
|