导出数据excel文件

 

 

Html代码：script代码

 

<div class="col-auto mt-2 mt-lg-0">

      <button class="btn btn-outline-primary" type="button" onclick="exportExcel()">导出</button>

</div>

 

script代码：  function exportExcel() {

            var formDataText = $("#formSearch").serialize();

            window.open("/Baseinfo/Student/ExportExcel?" + formDataText);

        }

 

控制器代码：

  public ActionResult ExportExcel(int? academeID,int? specialtyID,int?gradeID,int?classID,string searchText)

        {

            var query = from tbStudent in myModel.Student

                        join tbAcademe in myModel.Academe on tbStudent.academeID equals tbAcademe.academeID

                        join tbGrade in myModel.Grade on tbStudent.gradeID equals tbGrade.gradeID

                        join tbSpecialty in myModel.Specialty on tbStudent.specialtyID equals tbSpecialty.specialtyID

                        join tbClass in myModel.Class on tbStudent.classID equals tbClass.classID

                        select new StudentVo

                        {

                            studentID = tbStudent.studentID,

                            academeID = tbStudent.academeID,