| | |
| | | <el-table-column prop="createTime" label="创建时间"></el-table-column> |
| | | <el-table-column prop="updateTime" label="更新时间"></el-table-column> |
| | | </el-table> |
| | | <pagination v-show="total>0" :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" @pagination="getList" /> |
| | | <pagination v-show="total > 0" :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" @pagination="getList" /> |
| | | </el-row> |
| | | <template #footer> |
| | | <div class="dialog-footer"> |
| | |
| | | const queryFormRef = ref<ElFormInstance>(); |
| | | |
| | | const queryParams = reactive<DbTableQuery>({ |
| | | pageNum: 1, |
| | | pageSize: 10, |
| | | dataName: '', |
| | | tableName: '', |
| | | tableComment: '' |
| | | pageNum: 1, |
| | | pageSize: 10, |
| | | dataName: '', |
| | | tableName: '', |
| | | tableComment: '' |
| | | }); |
| | | const dataNameList = ref<Array<string>>([]); |
| | | |
| | |
| | | |
| | | /** 查询参数列表 */ |
| | | const show = (dataName: string) => { |
| | | getDataNameList(); |
| | | if(dataName){ |
| | | queryParams.dataName = dataName; |
| | | } else { |
| | | queryParams.dataName = 'master'; |
| | | } |
| | | getList(); |
| | | visible.value = true; |
| | | getDataNameList(); |
| | | if (dataName) { |
| | | queryParams.dataName = dataName; |
| | | } else { |
| | | queryParams.dataName = 'master'; |
| | | } |
| | | getList(); |
| | | visible.value = true; |
| | | } |
| | | /** 单击选择行 */ |
| | | const clickRow = (row: DbTableVO) => { |
| | | // ele bug |
| | | tableRef.value?.toggleRowSelection(row); |
| | | // ele bug |
| | | tableRef.value?.toggleRowSelection(row); |
| | | } |
| | | /** 多选框选中数据 */ |
| | | const handleSelectionChange = (selection: DbTableVO[]) => { |
| | | tables.value = selection.map(item => item.tableName); |
| | | tables.value = selection.map(item => item.tableName); |
| | | } |
| | | /** 查询表数据 */ |
| | | const getList = async () => { |
| | | const res = await listDbTable(queryParams); |
| | | dbTableList.value = res.rows; |
| | | total.value = res.total; |
| | | const res = await listDbTable(queryParams); |
| | | dbTableList.value = res.rows; |
| | | total.value = res.total; |
| | | } |
| | | /** 搜索按钮操作 */ |
| | | const handleQuery = () => { |
| | | queryParams.pageNum = 1; |
| | | getList(); |
| | | queryParams.pageNum = 1; |
| | | getList(); |
| | | } |
| | | /** 重置按钮操作 */ |
| | | const resetQuery = () => { |
| | | queryFormRef.value?.resetFields(); |
| | | handleQuery(); |
| | | queryFormRef.value?.resetFields(); |
| | | handleQuery(); |
| | | } |
| | | /** 导入按钮操作 */ |
| | | const handleImportTable = async () => { |
| | | const tableNames = tables.value.join(","); |
| | | if (tableNames == "") { |
| | | proxy?.$modal.msgError("请选择要导入的表"); |
| | | return; |
| | | } |
| | | const res = await importTable({ tables: tableNames, dataName: queryParams.dataName }); |
| | | proxy?.$modal.msgSuccess(res.msg); |
| | | if (res.code === 200) { |
| | | visible.value = false; |
| | | emit("ok"); |
| | | } |
| | | const tableNames = tables.value.join(","); |
| | | if (tableNames == "") { |
| | | proxy?.$modal.msgError("请选择要导入的表"); |
| | | return; |
| | | } |
| | | const res = await importTable({ tables: tableNames, dataName: queryParams.dataName }); |
| | | proxy?.$modal.msgSuccess(res.msg); |
| | | if (res.code === 200) { |
| | | visible.value = false; |
| | | emit("ok"); |
| | | } |
| | | } |
| | | /** 查询多数据源名称 */ |
| | | const getDataNameList = async () => { |
| | |
| | | } |
| | | |
| | | defineExpose({ |
| | | show, |
| | | show, |
| | | }); |
| | | </script> |