|
|
1
2
|
<template>
<!-- 导入表 -->
|
|
|
3
4
5
6
7
8
9
|
<el-dialog
title="导入表"
:visible.sync="visible"
width="800px"
top="5vh"
append-to-body
>
|
|
|
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
<el-form :model="queryParams" ref="queryForm" :inline="true">
<el-form-item label="表名称" prop="tableName">
<el-input
v-model="queryParams.tableName"
placeholder="请输入表名称"
clearable
size="small"
@keyup.enter.native="handleQuery"
/>
</el-form-item>
<el-form-item label="表描述" prop="tableComment">
<el-input
v-model="queryParams.tableComment"
placeholder="请输入表描述"
clearable
size="small"
@keyup.enter.native="handleQuery"
/>
</el-form-item>
<el-form-item>
|
|
|
30
31
32
33
34
35
36
37
38
39
|
<el-button
type="primary"
icon="el-icon-search"
size="mini"
@click="handleQuery"
>搜索</el-button
>
<el-button icon="el-icon-refresh" size="mini" @click="resetQuery"
>重置</el-button
>
|
|
|
40
41
42
|
</el-form-item>
</el-form>
<el-row>
|
|
|
43
44
45
46
47
48
49
|
<el-table
@row-click="clickRow"
ref="table"
:data="dbTableList"
@selection-change="handleSelectionChange"
height="260px"
>
|
|
|
50
|
<el-table-column type="selection" width="55"></el-table-column>
|
|
|
51
52
53
54
55
56
57
58
59
60
|
<el-table-column
prop="tableName"
label="表名称"
:show-overflow-tooltip="true"
></el-table-column>
<el-table-column
prop="tableComment"
label="表描述"
:show-overflow-tooltip="true"
></el-table-column>
|
|
|
61
62
63
64
|
<el-table-column prop="createTime" label="创建时间"></el-table-column>
<el-table-column prop="updateTime" label="更新时间"></el-table-column>
</el-table>
<pagination
|
|
|
65
|
v-show="total > 0"
|
|
|
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
:total="total"
:page.sync="queryParams.pageNum"
:limit.sync="queryParams.pageSize"
@pagination="getList"
/>
</el-row>
<div slot="footer" class="dialog-footer">
<el-button type="primary" @click="handleImportTable">确 定</el-button>
<el-button @click="visible = false">取 消</el-button>
</div>
</el-dialog>
</template>
<script>
import { listDbTable, importTable } from "@/api/tool/gen";
export default {
data() {
return {
// 遮罩层
visible: false,
// 选中数组值
tables: [],
// 总条数
total: 0,
// 表数据
dbTableList: [],
// 查询参数
queryParams: {
pageNum: 1,
pageSize: 10,
tableName: undefined,
|
|
|
97
98
|
tableComment: undefined,
},
|
|
|
99
100
101
102
103
104
105
106
107
108
109
110
111
|
};
},
methods: {
// 显示弹框
show() {
this.getList();
this.visible = true;
},
clickRow(row) {
this.$refs.table.toggleRowSelection(row);
},
// 多选框选中数据
handleSelectionChange(selection) {
|
|
|
112
|
this.tables = selection.map((item) => item.tableName);
|
|
|
113
114
115
|
},
// 查询表数据
getList() {
|
|
|
116
|
listDbTable(this.queryParams).then((res) => {
|
|
|
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
if (res.code === 200) {
this.dbTableList = res.rows;
this.total = res.total;
}
});
},
/** 搜索按钮操作 */
handleQuery() {
this.queryParams.pageNum = 1;
this.getList();
},
/** 重置按钮操作 */
resetQuery() {
this.resetForm("queryForm");
this.handleQuery();
},
/** 导入按钮操作 */
handleImportTable() {
|
|
|
135
|
importTable({ tables: this.tables.join(",") }).then((res) => {
|
|
|
136
137
138
139
140
141
|
this.msgSuccess(res.msg);
if (res.code === 200) {
this.visible = false;
this.$emit("ok");
}
});
|
|
|
142
143
|
},
},
|
|
|
144
145
|
};
</script>
|
