JW/EMIS.Web/Controllers/StudentManage/StudentChange/DifferentDynamicResultController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using EMIS.ViewModel;
using EMIS.Web.Controls;
using EMIS.CommonLogic.Students;
using Bowin.Web.Controls.Mvc;
using EMIS.ViewModel.DifferentDynamic;
using Bowin.Common.Linq.Entity;
using Bowin.Common.Utility;
using Bowin.Common.Linq;
using Bowin.Common.Mvc;
using EMIS.CommonLogic.CalendarManage;
namespace EMIS.Web.Controllers.DifferentDynamic
{
    /// <summary>
    /// 异动结果
    /// </summary>
    [Authorization]
    public class DifferentDynamicResultController : DifferentDynamicController
    {
        public ISchoolYearServices SchoolYearServices { get; set; }
        //[StaticFileWriteFilter]
        public ActionResult List()
        {
            var schoolYear = SchoolYearServices.GetSchoolYearIsCurrent(true);

            ViewBag.SchoolYearID = schoolYear == null ? "-1" : schoolYear.SchoolyearID.ToString();//默认当前学年
            return View();
        }

        /// <summary>
        /// 列表查询
        /// </summary>
        /// <param name="pararms"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult List(QueryParamsModel pararms)
        {
            ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(pararms);

            var campusID = pararms.getExtraGuid("CampusDropdown"); //校区
            var collegeID = pararms.getExtraGuid("CollegeDropdown"); //院系所
            var year = CheckIsSelectAll(pararms.getExtraInt("SchoolyearDictionaryDropDown")); //年级
            var standard = CheckIsSelectAll(pararms.getExtraInt("StandardDictionaryDropDown")); //专业名称
            var education = CheckIsSelectAll(pararms.getExtraInt("DictionaryEducation")); //培养层次
            var learningform = CheckIsSelectAll(pararms.getExtraInt("DictionaryLearningform")); //学习形式
            var classmajorID = pararms.getExtraGuid("ClassmajorDropdown"); //班级名称
            var schoolYearID = pararms.getExtraGuid("SchoolYearDropdown"); //异动学期
            var differentDynamicType = CheckIsSelectAll(pararms.getExtraInt("DictionaryDifferentDynamicType")); //异动类型
            var differentDynamicStatus = DifferentDynamicServices.GetCorrectEndStatus();// CheckIsSelectAll(pararms.getExtraInt("DictionaryDifferentDynamicStatus")); //审批状态
            var LearnSystem = pararms.getExtraString("DictionaryLearnSystem");
            var result = DifferentDynamicServices.GetDifferentDynamicViewGrid(configuretView, campusID, collegeID, year, standard, education, learningform, classmajorID, schoolYearID, differentDynamicType, differentDynamicStatus, LearnSystem, (int)pararms.page, (int)pararms.rows, 0);

            return Json(result);
        }

        public ActionResult Edit(Guid? id)
        {
            var vm = new DifferentDynamicView();

            if (id != null && id != Guid.Empty)
                vm = DifferentDynamicServices.GetDifferentDynamicView(id);

            return View(vm);
        }

        [HttpPost]
        public ActionResult Excel()
        {
            NpoiExcelHelper neh = new NpoiExcelHelper();
            ConfiguretView configuretView = ConfiguretExtensions.GetConfiguretermsView(null);
            //避开全选值
            //var roleID = Request.Form["Role"].ParseStrTo<Guid>();
            var campusID = Request.Form["CampusDropdown"].ParseStrTo<Guid>(); //校区
            var collegeID = Request.Form["CollegeDropdown"].ParseStrTo<Guid>(); //院系所
            var year = CheckIsSelectAll(Request.Form["DictionarySchoolyear"].ParseStrTo<int>()); //年级
            var standard = CheckIsSelectAll(Request.Form["DictionaryStandard"].ParseStrTo<int>()); //专业名称
            var education = CheckIsSelectAll(Request.Form["DictionaryEducation"].ParseStrTo<int>()); //培养层次
            var learningform = CheckIsSelectAll(Request.Form["DictionaryLearningform"].ParseStrTo<int>()); //学习形式
            var classmajorID = Request.Form["ClassmajorDropdown"].ParseStrTo<Guid>(); //班级名称
            var schoolYearID = Request.Form["SchoolYearDropdown"].ParseStrTo<Guid>();  //异动学期
            var differentDynamicType = CheckIsSelectAll(Request.Form["DictionaryDifferentDynamicType"].ParseStrTo<int>()); //异动类型
            var differentDynamicStatus = DifferentDynamicServices.GetCorrectEndStatus(); //审批状态
            var LearnSystem = Request.Form["DictionaryLearnSystem"].ToString();
            var result = DifferentDynamicServices.GetDifferentDynamicViewList(configuretView, campusID, collegeID, year, standard, education, learningform, classmajorID, schoolYearID, differentDynamicType, differentDynamicStatus, LearnSystem, 0);

            var dt = result.OrderBy(x => x.EntityCreateTime).Select(s => new
            {
                s.SchoolyearCode,
                s.LoginID,
                s.Name,
                s.DifferentDynamicTypeName,
                s.ReasonName,
                s.InSchoolStatusName,
                s.StudentStatusName,
                s.StandardName,
                s.ClassmajorName,
                s.AfterStandardName,
                s.AfterClassmajorName,
                s.AfterInSchoolStatusName,
                s.AfterStudentStatusName,
                s.EntityCreateTimeStr,
                s.ReportStatusName,
            }).ToTable();

            string[] liststring = { "异动学期", "学号", "姓名", "异动类型", "异动原因", "在校状态", "学籍状态",
                                    "异动前专业", "异动前班级", "异动后专业", "异动后班级", "异动后在校状态", "异动后学籍状态",
                                    "异动日期",  "注册状态" };
            
            neh.Export(dt, liststring, "异动结果");
            return RedirectToAction("MsgShow", "Common", new
            {
                msg = "导出成功！",
                url = Url.Action("List").AddMenuParameter()
            });
        }

        [HttpPost]
        public ActionResult StudentDifferentDynamicApplyInfo(Guid? Userid)
        {
            var view = DifferentDynamicServices.GetStudentDifferentInfoViewGrid(Userid);
            return Json(view);
        }

    }
}