| | |
| | | } |
| | | } |
| | | |
| | | if (val !== '') { |
| | | if (col.prefix) { |
| | | val = col.prefix + val |
| | | } |
| | | if (col.postfix) { |
| | | val = val + col.postfix |
| | | } |
| | | } |
| | | |
| | | _row[col.Column] = val |
| | | }) |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | if (val !== '') { |
| | | if (col.prefix) { |
| | | val = col.prefix + val |
| | | } |
| | | if (col.postfix) { |
| | | val = val + col.postfix |
| | | } |
| | | } |
| | | |
| | | _row[col.Column] = val |
| | | }) |
| | | |
| | |
| | | const wb = XLSX.utils.book_new() |
| | | XLSX.utils.book_append_sheet(wb, ws, btn.verify.sheet || 'Sheet1') |
| | | |
| | | XLSX.writeFile(wb, `${btn.$menuName || ''}${moment().format('YYYYMMDDHHmmss')}.xlsx`) |
| | | XLSX.writeFile(wb, `${btn.verify.excelName || btn.$menuName || ''}${moment().format('YYYYMMDDHHmmss')}.xlsx`) |
| | | |
| | | this.execSuccess({ErrCode: ErrCode || 'S', message: msg || '导出成功!'}) |
| | | } |
| | |
| | | _setting.arr_field = [] |
| | | |
| | | btn.verify.columns.forEach(col => { |
| | | if (col.Column && col.Column !== '$Index') { |
| | | _setting.arr_field.push(col.Column) |
| | | } |
| | | if (col.output === 'false' || !col.Column || col.Column === '$Index') return |
| | | |
| | | _setting.arr_field.push(col.Column) |
| | | }) |
| | | _setting.arr_field = _setting.arr_field.join(',') |
| | | _setting.execute = btn.verify.defaultSql !== 'false' |