Xnip2021-01-04_09-45-31.jpg

//導(dǎo)出

        <el-form-item>
          <el-button @click="onExport" class="btn">導(dǎo)出</el-button>
        </el-form-item>

//導(dǎo)入

        <el-form-item>
          <el-upload
            class="upload-demo"
            action=""
            accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel"
            :before-remove="beforeRemove"
            :http-request="uploadFile"
            multiple
            :limit="1"
            :on-exceed="handleExceed"
            :file-list="fileList"
          >
            <el-button class="btn">導(dǎo)入</el-button>
            <!-- <div slot="tip" class="el-upload__tip">只能上傳Excel文件</div> -->
          </el-upload>
        </el-form-item>

export default {
data() {
  return {
    fileList: [],
    UploadSuccess: false,
    handleExceed(files, fileList) {
      this.$message.warning(
        `當(dāng)前限制選擇 1 個(gè)文件，本次選擇了 ${
          files.length
        } 個(gè)文件然走，共選擇了 ${files.length + fileList.length} 個(gè)文件`
      );
    },

  methods: {
    beforeRemove(file, fileList) {
      return this.$confirm(`確定移除 ${file.name}援制？`);
    },
    async DietUp_load(form) {
      const res = await Diet_Up_load(form);
      if (res.result == 0) {
        this.UploadSuccess = true;
        this.$message({
          type: "success",
          message: "上傳成功!"
        });
      } else {
        this.UploadSuccess = false;
        this.fileList = [];
        this.$message({
          type: "warning",
          message: "請(qǐng)重新導(dǎo)入!"
        });
      }
    },
    uploadFile(item) {
      var form = new FormData();
      form.append("file", item.file);
      this.DietUp_load(form); //導(dǎo)入//form接口
    },
}

======

   onExport() {//導(dǎo)出按鈕
      this.pageIndex = 1;
      this.get_Wxexport();
    },

   get_Wxexport() {//調(diào)用導(dǎo)出接口
      let Params = {
        applicantName: this.formInline.applicantName, //報(bào)修人
        applicantPhoneNumber: this.formInline.applicantPhoneNumber, //報(bào)修手機(jī)
        repairerName: this.formInline.repairerName, //維修人
        repairerPhoneNumber: this.formInline.repairerPhoneNumber, //維修人手機(jī)
        formState: this.formInline.formState, //狀態(tài)
        order: "id desc",
        pageNum: this.pageIndex,
        pageSize: this.pageSize
      };
      axios({
        url: `manager-api/repair-form/export`,
        method: "get",
        params: Params,
        headers: {
          Authorization: getToken()
        },
        responseType: "blob"
      })
        .then(res => {
          const blob = new Blob([res.data], {
            type: "application/vnd.ms-excel"
          });
          let link = document.createElement("a");
          link.href = URL.createObjectURL(blob);
          link.setAttribute(
            "download",
            moment().format("MM-DD") + "報(bào)修和維修記錄.xlsx"
          );
          link.click();
          link = null;
          this.$message.success("報(bào)修和維修記錄 導(dǎo)出成功");
        })
        .catch(err => {
          console.log(err);
        });
    }