From 6b988bd582bfcd17fee48c476a5a6e5cc172b0d5 Mon Sep 17 00:00:00 2001
From: baoshiwei <baoshiwei@shlanbao.cn>
Date: 星期三, 12 三月 2025 10:08:33 +0800
Subject: [PATCH] dev-2
---
src/views/tool/gen/importTable.vue | 152 ++++++++++++++++++++++++++------------------------
1 files changed, 78 insertions(+), 74 deletions(-)
diff --git a/src/views/tool/gen/importTable.vue b/src/views/tool/gen/importTable.vue
index 33b5633..f6e75cc 100644
--- a/src/views/tool/gen/importTable.vue
+++ b/src/views/tool/gen/importTable.vue
@@ -1,22 +1,17 @@
<template>
<!-- 瀵煎叆琛� -->
- <el-dialog title="瀵煎叆琛�" v-model="visible" width="800px" top="5vh" append-to-body>
- <el-form :model="queryParams" ref="queryRef" :inline="true">
+ <el-dialog v-model="visible" title="瀵煎叆琛�" width="1100px" top="5vh" append-to-body>
+ <el-form ref="queryFormRef" :model="queryParams" :inline="true">
+ <el-form-item label="鏁版嵁婧�" prop="dataName">
+ <el-select v-model="queryParams.dataName" filterable placeholder="璇烽�夋嫨/杈撳叆鏁版嵁婧愬悕绉�">
+ <el-option v-for="item in dataNameList" :key="item" :label="item" :value="item"> </el-option>
+ </el-select>
+ </el-form-item>
<el-form-item label="琛ㄥ悕绉�" prop="tableName">
- <el-input
- v-model="queryParams.tableName"
- placeholder="璇疯緭鍏ヨ〃鍚嶇О"
- clearable
- @keyup.enter="handleQuery"
- />
+ <el-input v-model="queryParams.tableName" placeholder="璇疯緭鍏ヨ〃鍚嶇О" clearable @keyup.enter="handleQuery" />
</el-form-item>
<el-form-item label="琛ㄦ弿杩�" prop="tableComment">
- <el-input
- v-model="queryParams.tableComment"
- placeholder="璇疯緭鍏ヨ〃鎻忚堪"
- clearable
- @keyup.enter="handleQuery"
- />
+ <el-input v-model="queryParams.tableComment" placeholder="璇疯緭鍏ヨ〃鎻忚堪" clearable @keyup.enter="handleQuery" />
</el-form-item>
<el-form-item>
<el-button type="primary" icon="Search" @click="handleQuery">鎼滅储</el-button>
@@ -24,20 +19,14 @@
</el-form-item>
</el-form>
<el-row>
- <el-table @row-click="clickRow" ref="table" :data="dbTableList" @selection-change="handleSelectionChange" height="260px">
+ <el-table ref="tableRef" :data="dbTableList" height="260px" @row-click="clickRow" @selection-change="handleSelectionChange">
<el-table-column type="selection" width="55"></el-table-column>
<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>
<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" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" :total="total" @pagination="getList" />
</el-row>
<template #footer>
<div class="dialog-footer">
@@ -48,71 +37,86 @@
</el-dialog>
</template>
-<script setup>
-import { listDbTable, importTable } from "@/api/tool/gen";
+<script setup lang="ts">
+import { listDbTable, importTable, getDataNames } from '@/api/tool/gen';
+import { DbTableQuery, DbTableVO } from '@/api/tool/gen/types';
const total = ref(0);
const visible = ref(false);
-const tables = ref([]);
-const dbTableList = ref([]);
-const { proxy } = getCurrentInstance();
+const tables = ref<Array<string>>([]);
+const dbTableList = ref<Array<DbTableVO>>([]);
+const { proxy } = getCurrentInstance() as ComponentInternalInstance;
-const queryParams = reactive({
+const tableRef = ref<ElTableInstance>();
+const queryFormRef = ref<ElFormInstance>();
+
+const queryParams = reactive<DbTableQuery>({
pageNum: 1,
pageSize: 10,
- tableName: undefined,
- tableComment: undefined
+ dataName: '',
+ tableName: '',
+ tableComment: ''
});
+const dataNameList = ref<Array<string>>([]);
-const emit = defineEmits(["ok"]);
+const emit = defineEmits(['ok']);
/** 鏌ヨ鍙傛暟鍒楄〃 */
-function show() {
- getList();
- visible.value = true;
-}
-/** 鍗曞嚮閫夋嫨琛� */
-function clickRow(row) {
- proxy.$refs.table.toggleRowSelection(row);
-}
-/** 澶氶�夋閫変腑鏁版嵁 */
-function handleSelectionChange(selection) {
- tables.value = selection.map(item => item.tableName);
-}
-/** 鏌ヨ琛ㄦ暟鎹� */
-function getList() {
- listDbTable(queryParams).then(res => {
- dbTableList.value = res.rows;
- total.value = res.total;
- });
-}
-/** 鎼滅储鎸夐挳鎿嶄綔 */
-function handleQuery() {
- queryParams.pageNum = 1;
- getList();
-}
-/** 閲嶇疆鎸夐挳鎿嶄綔 */
-function resetQuery() {
- proxy.resetForm("queryRef");
- handleQuery();
-}
-/** 瀵煎叆鎸夐挳鎿嶄綔 */
-function handleImportTable() {
- const tableNames = tables.value.join(",");
- if (tableNames == "") {
- proxy.$modal.msgError("璇烽�夋嫨瑕佸鍏ョ殑琛�");
- return;
- }
- importTable({ tables: tableNames }).then(res => {
- proxy.$modal.msgSuccess(res.msg);
- if (res.code === 200) {
- visible.value = false;
- emit("ok");
+const show = (dataName: string) => {
+ getDataNames().then((res) => {
+ if (res.code == 200) {
+ dataNameList.value = res.data;
+ if (dataName) {
+ queryParams.dataName = dataName;
+ } else {
+ queryParams.dataName = dataNameList.value[0];
+ }
+ getList();
+ visible.value = true;
}
});
-}
+};
+/** 鍗曞嚮閫夋嫨琛� */
+const clickRow = (row: DbTableVO) => {
+ // ele bug
+ tableRef.value?.toggleRowSelection(row, false);
+};
+/** 澶氶�夋閫変腑鏁版嵁 */
+const handleSelectionChange = (selection: DbTableVO[]) => {
+ tables.value = selection.map((item) => item.tableName);
+};
+/** 鏌ヨ琛ㄦ暟鎹� */
+const getList = async () => {
+ const res = await listDbTable(queryParams);
+ dbTableList.value = res.rows;
+ total.value = res.total;
+};
+/** 鎼滅储鎸夐挳鎿嶄綔 */
+const handleQuery = () => {
+ queryParams.pageNum = 1;
+ getList();
+};
+/** 閲嶇疆鎸夐挳鎿嶄綔 */
+const resetQuery = () => {
+ 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');
+ }
+};
defineExpose({
- show,
+ show
});
</script>
--
Gitblit v1.9.3