导出

 

开发工具与关键技术：  vs       导出

作者：      周乐献       

撰写时间：   2019      年        5月   28     日

导出学生数据首先根据自己所需查询所要的数据，然后根据学院id、年级id、班级id、学生id一一对应获取数据。最后把导出的数据和根据自己查询出的数据比较，所导出的数据必须等于查询出的数据。

<form class="form-inline form-row">

                    <label class="col-form-label mr-2" for="searchAcademeID">学院</label>

                    <select id="searchAcademeID" class="form-control form-control-sm mr-4 col-sm-3 col-md-2"></select>

 

                    <label class="col-form-label mr-2" for="searchGradeID">年级</label>

                    <select id="searchGradeID" class="form-control form-control-sm mr-3 col-sm-2 col-md-1"></select>

 

                    <label class="col-form-label mr-2" for="searchClassID">班级</label>

                    <select id="searchClassID" class="form-control form-control-sm mr-3 col-sm-2 col-md-1"></select>

 

                    <label class="col-form-label mr-2" for="searchStudentNumber">学号/姓名</label>

                    <input class="form-control form-control-sm mr-3" id="searchStudentNumber" name="StudentNumber" />

 

                    <div class="w-100 mb-2 d-sm-none d-md-none d-lg-none d-xl-none"></div>

 

                    <div class="form-group">

                        <button type="button" class="btn btn-sm btn-primary mr-3" οnclick="tabStudentSearch()">查询</button>

                    </div>

                </form>

<div class="layui-btn-container">

            <button type="button" class="btn btn-sm btn-primary mr-1" οnclick="openImportExcel()">导入考生</button>

            <button type="button" class="btn btn-sm btn-primary" οnclick="ExportToExcel()">导出考生</button>

        </div>

function ExportToExcel() {

            查询出所需数据

            var strSeachWhere = "";

            for (var key in tabStudent.config.where) {

                strSeachWhere += '&' + key + '=' + tabStudent.config.where[key];

            }

            console.log(strSeachWhere);

           获取导出条件

            var AcademeID = $("#searchAcademeID").val();

            if (AcademeID==""||AcademeID==undefined) {

                AcademeID = 0;

            }

            var GradeID = $("#searchGradeID").val();

            if (GradeID == "" || GradeID == undefined) {

                GradeID = 0;

            }

            var ClassID = $("#searchClassID").val();

            if (ClassID == "" || ClassID == undefined) {

                ClassID = 0;

            }

            var StudentInfo = $("#searchStudentNumber").val();

            if (StudentInfo == undefined) {

                StudentInfo = "";

            }

            var strTemp = '&AcademeID=' + AcademeID + '&GradeID=' + GradeID + '&ClassID=' + ClassID + '&StudentInfo=' + StudentInfo;

            console.log(strTemp);

            if (strSeachWhere == strTemp)

            {

提示所导出数据的条数

                layer.confirm('您确定要导出' + tabStudent.config.page.count + '条学生信息?', { icon: 3, titile: "提示" }, function (index) {

                    layer.close(index);

                    window.open('/ExaminationManagement/SetExaminee/ExportToExccl?' + strTemp.substring(1, strTemp.length));

                });

            }

            else

            {

                layer.msg("请查询出要导出的数据!", { icon: 0, skin: "layui-layer-molv" });

            }

        }

导出到所写的excel文件