Merge branch 'dev_新疆_大罗素马铃薯new' of http://114.132.189.42:9002/r/product-inv...

huminmin

2026-06-01 a563ea879ef5fb6897e76d2df661e465dce2ab9b

 src/views/tool/gen/importTable.vue

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,126 @@
<template>

  <!-- å¯¼å…¥è¡¨ -->

  <el-dialog title="导入表" v-model="visible" width="800px" top="5vh" append-to-body>

    <el-form :model="queryParams" ref="queryRef" :inline="true">

      <el-form-item label="表名称" prop="tableName">

        <el-input

          v-model="queryParams.tableName"

          placeholder="请输入表名称"

          clearable

          style="width: 180px"

          @keyup.enter="handleQuery"

        />

      </el-form-item>

      <el-form-item label="表描述" prop="tableComment">

        <el-input

          v-model="queryParams.tableComment"

          placeholder="请输入表描述"

          clearable

          style="width: 180px"

          @keyup.enter="handleQuery"

        />

      </el-form-item>

      <el-form-item>

        <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>

        <el-button icon="Refresh" @click="resetQuery">重置</el-button>

      </el-form-item>

    </el-form>

    <el-row>

      <el-table @row-click="clickRow" ref="table" :data="dbTableList" @selection-change="handleSelectionChange" height="260px">

        <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"

      />

    </el-row>

    <template #footer>

      <div class="dialog-footer">

        <el-button type="primary" @click="handleImportTable">ç¡® å®š</el-button>

        <el-button @click="visible = false">取 æ¶ˆ</el-button>

      </div>

    </template>

  </el-dialog>

</template>



<script setup>

import { listDbTable, importTable } from "@/api/tool/gen"



const total = ref(0)

const visible = ref(false)

const tables = ref([])

const dbTableList = ref([])

const { proxy } = getCurrentInstance()



const queryParams = reactive({

  pageNum: 1,

  pageSize: 10,

  tableName: undefined,

  tableComment: undefined

})



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")

    }

  })

}



defineExpose({

  show,

})

</script>