From 8ba37cc2e73c81e00f16010f390e3228d842750e Mon Sep 17 00:00:00 2001 From: zhuzhuanzhuan Date: 星期二, 18 七月 2023 09:59:17 +0800 Subject: [PATCH] 标准加工时间的导入导出功能,加工数量界面的绘制和功能,调取接口渲染数据,测试,假期管理、计划停机和非计划停机配置界面的弹窗样式调整 --- src/views/mdc/base/modules/mdcStandardProcessDuration/MdcStandardProcessDurationList.vue | 48 ++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 42 insertions(+), 6 deletions(-) diff --git a/src/views/mdc/base/modules/mdcStandardProcessDuration/MdcStandardProcessDurationList.vue b/src/views/mdc/base/modules/mdcStandardProcessDuration/MdcStandardProcessDurationList.vue index 7fa4ce5..e2d3b2e 100644 --- a/src/views/mdc/base/modules/mdcStandardProcessDuration/MdcStandardProcessDurationList.vue +++ b/src/views/mdc/base/modules/mdcStandardProcessDuration/MdcStandardProcessDurationList.vue @@ -35,10 +35,10 @@ <div class="table-operator" style="display: inline;"> <a-button @click="handleAdd" type="primary" icon="plus">鏂板 </a-button> - <!--<a-button type="primary" icon="download" @click="handleExportXls('鍋囨湡绠$悊')">瀵煎嚭</a-button>--> - <!--<a-upload name="file" :showUploadList="false" :multiple="false" :headers="tokenHeader" :action="importExcelUrl" @change="handleImportExcel">--> - <!--<a-button type="primary" icon="import">瀵煎叆</a-button>--> - <!--</a-upload>--> + <a-button type="primary" icon="download" @click="handleExportXls('鍋囨湡绠$悊')">瀵煎嚭</a-button> + <a-upload name="file" :showUploadList="false" :multiple="false" :headers="tokenHeader" :action="importExcelUrl" @change="handleImportExcel"> + <a-button type="primary" icon="import">瀵煎叆</a-button> + </a-upload> <a-dropdown v-if="selectedRowKeys.length > 0"> <a-menu slot="overlay"> <a-menu-item key="1" @click="batchDel"> @@ -91,6 +91,7 @@ import { requestPut, deleteAction, + downFile, getAction } from '@/api/manage' import MdcStandardProcessDurationModal from './MdcStandardProcessDurationModal' @@ -188,8 +189,8 @@ delete: '/mdc/mdcStandardProcessDuration/delete', deleteBatch: '/mdc/mdcStandardProcessDuration/deleteBatch', getEquipmentByPid: '/mdc/mdcequipment/getEquipmentByPid', - exportXlsUrl: "/mdc/MdcTorqueConfig/exportXls", - importExcelUrl: "/mdc/MdcTorqueConfig/importExcel", + exportXlsUrl: "/mdc/mdcStandardProcessDuration/exportXls", + importExcelUrl: "/mdc/mdcStandardProcessDuration/importExcel", } } }, @@ -570,6 +571,41 @@ } }) }, + handleExportXls(fileName){ + if(!fileName || typeof fileName != "string"){ + fileName = "瀵煎嚭鏂囦欢" + } + let param = this.getQueryParams(); + if(this.selectedRowKeys && this.selectedRowKeys.length>0){ + param['selections'] = this.selectedRowKeys.join(",") + } + param.pageSize = this.ipagination.pageSize; + param.field = this.getQueryField(); + param.parentId = this.queryParams.parentId; + param.equipmentId = this.queryParams.equipmentId; + param.startTime = this.queryParam.startTime; + param.endTime = this.queryParam.endTime; + console.log("瀵煎嚭鍙傛暟",param) + downFile(this.url.exportXlsUrl,param).then((data)=>{ + if (!data) { + this.$message.warning("鏂囦欢涓嬭浇澶辫触") + return + } + if (typeof window.navigator.msSaveBlob !== 'undefined') { + window.navigator.msSaveBlob(new Blob([data],{type: 'application/vnd.ms-excel'}), fileName+'.xls') + }else{ + let url = window.URL.createObjectURL(new Blob([data],{type: 'application/vnd.ms-excel'})) + let link = document.createElement('a') + link.style.display = 'none' + link.href = url + link.setAttribute('download', fileName+'.xls') + document.body.appendChild(link) + link.click() + document.body.removeChild(link); //涓嬭浇瀹屾垚绉婚櫎鍏冪礌 + window.URL.revokeObjectURL(url); //閲婃斁鎺塨lob瀵硅薄 + } + }) + }, exportExcel() { $("#DeviceList").table2excel({ exclude: ".noExl", -- Gitblit v1.9.3