go-xorm-create/output/vue/page/GenTableView.vue

<template>
  <div class="back-form-container">
    <div>
    <el-form :model="query" label-width="80px" :inline="true">
      
        
        
      
        
        
            
            
            
        <el-form-item label="数据库名" prop="tableName">
          <el-input v-model="query.tableName" placeholder="请输入数据库名"/>
        </el-form-item>
        
      
        
        
            
            
            
        <el-form-item label="数据库注释" prop="tableComment">
          <el-input v-model="query.tableComment" placeholder="请输入数据库注释"/>
        </el-form-item>
        
      
        
        
            
            
            
        <el-form-item label="名字" prop="name">
          <el-input v-model="query.name" placeholder="请输入名字"/>
        </el-form-item>
        
      
        
        
            
            
            
        <el-form-item label="路由名" prop="routerName">
          <el-input v-model="query.routerName" placeholder="请输入路由名"/>
        </el-form-item>
        
      
        
        
            
            
            
        <el-form-item label="备注" prop="remark">
          <el-input v-model="query.remark" placeholder="请输入备注" type="textarea"/>
        </el-form-item>
        
      
    </el-form>
    </div>
    <div class="back-table-handler">
      <el-row :gutter="10" class="mb8">
        <el-col :span="1.5">
          <el-button type="primary" plain size="small" @click="getList(pageNum)">
            <el-icon>
              <RefreshLeft/>
            </el-icon>
            <span>刷新</span>
          </el-button>
        </el-col>
        <el-col :span="1.5">
          <el-button type="primary" plain size="small" @click="openDialog('save', GenTable.Create())">
            <el-icon>
              <Plus/>
            </el-icon>
            <span>新增</span>
          </el-button>
        </el-col>
        <el-col :span="1.5">
          <el-button type="danger" plain size="small" @click="deleteByIds()">
            <el-icon>
              <Delete/>
            </el-icon>
            <span>删除</span>
          </el-button>
        </el-col>
      </el-row>
    </div>

    <div class="back-table">
      <el-table v-loading="listLoading" :data="list" @selection-change="selected" border :key="ListKey">
        <el-table-column type="selection" width="40" align="center"/>
        
        <el-table-column label="id" align="center" prop="id"/>
        <el-table-column label="数据库名" align="center" prop="tableName"/>
        <el-table-column label="数据库注释" align="center" prop="tableComment"/>
        <el-table-column label="名字" align="center" prop="name"/>
        <el-table-column label="路由名" align="center" prop="routerName"/>
        <el-table-column label="备注" align="center" prop="remark"/>
        <el-table-column label="操作" align="center" fixed="right">
          <template #default="scope">
            <el-button link type="primary" @click="openDialog('update', scope.row)">修改</el-button>
            <el-button link type="danger" @click="deleteById(scope.row.id)">删除</el-button>
          </template>
        </el-table-column>
      </el-table>
      <div class="pagination-container">
        <el-pagination
            background
            :current-page="pageNum"
            @current-change="getList"
            :page-size="pageSize"
            :page-sizes="[10, 20, 30, 50,100]"
            :total="total"
            @size-change="SetPageSized"
            layout="total, sizes, prev, pager, next"
        />
      </div>

        <!-- 添加或修改参数配置对话框 -->
        <el-dialog :title="dialogType=='update'?'更改字典类型':'新增字典类型'" v-model="open" width="500px" append-to-body>
          <el-form ref="dictRef" :model="dialogForm" label-width="80px">
            
        <el-form-item label="数据库名" prop="tableName">
          <el-input v-model="dialogForm.tableName" placeholder="请输入数据库名"/>
        </el-form-item>
        <el-form-item label="数据库注释" prop="tableComment">
          <el-input v-model="dialogForm.tableComment" placeholder="请输入数据库注释"/>
        </el-form-item>
        <el-form-item label="名字" prop="name">
          <el-input v-model="dialogForm.name" placeholder="请输入名字"/>
        </el-form-item>
        <el-form-item label="路由名" prop="routerName">
          <el-input v-model="dialogForm.routerName" placeholder="请输入路由名"/>
        </el-form-item>
        <el-form-item label="备注" prop="remark">
          <el-input v-model="dialogForm.remark" placeholder="请输入备注" type="textarea"/>
        </el-form-item>
          </el-form>
          <template #footer>
            <div class="dialog-footer">
              <el-button type="primary" @click="submitForm()">确 定</el-button>
              <el-button @click="open=false">取 消</el-button>
            </div>
          </template>
        </el-dialog>
    </div>
  </div>
</template>

<script setup lang="ts">
import {ref} from "vue";
import {
  DeleteBaseGenTableById,
  GetBaseGenTableListByGenTable,
  SaveBaseGenTable,
  UpdateBaseGenTable,
  GenTable,
  GenTableQuery
} from "../../../api/back/BaseBackApi.ts";
import {ElMessage} from "element-plus";
import {Delete, Plus, RefreshLeft} from "@element-plus/icons-vue";
import router from "../../../router";
import {store} from "../../../state/TokenState.ts";
import DictTag from "../../../components/dict/DictTag.vue";
import MultipleTag from "../../../components/MultipleTag/MultipleTag.vue";
import ImageUpload from "../../../components/ImageUpload/ImageUpload.vue";

let listLoading = ref(true)
let total = ref(0)
let pageNum = ref(1)
let pageSize = ref(10)
let list = ref<GenTable[]>([])
let ListKey = ref(0)
//搜索用
//let search = ref<GenTable>(GenTable.Create())
//修改，添加用
let open = ref(false)
let dialogType = ref("")//save添加，update修改
let dialogForm = ref<GenTable>(null)
let query = ref<GenTableQuery>(GenTableQuery.Create())
let selectItems = ref<GenTable[]>([])
const selected = (arr: GenTable[]) => {
  selectItems.value = arr
}

getList()
const SetPageSized = (val: number) => {
  pageSize.value = val
  getList(pageNum.value)
}

function openDialog(type: string, row: GenTable) {
  open.value = true
  dialogType.value = type
  if (type==="save"){
    dialogForm.value = GenTable.Create()
    return
  }
  //深拷贝，不会影响数据
  dialogForm.value = JSON.parse(JSON.stringify(row))
}

function deleteByIds() {
  for (let i = 0; i < selectItems.value.length; i++) {
      deleteById(selectItems[i].id)
  }
}

function deleteById(id) {
  DeleteBaseGenTableById(id).then(response => {
    if (response.code == 200) {
      ElMessage.success("删除成功,id:" + id)
      getList()
    } else {
      ElMessage.error("删除失败,id:" + id)
    }
  })
}

function getList(pn = 1) {
  pageNum.value = pn
  GetBaseGenTableListByGenTable(query.value, pageNum.value, pageSize.value).then(response => {
    let data = response.data
    total.value = data.total
    list.value = response.data.list
    ListKey.value++
    listLoading.value = false
  })
}

function submitForm() {
  switch (dialogType.value) {
    case "update":
      UpdateBaseGenTable(dialogForm.value, dialogForm.value.id).then(response => {
        if (response.code == 200) {
          open.value = false
          getList()
          ElMessage.success("修改成功")
        } else {
          ElMessage.error("修改失败")
        }
      })
      break
    case "save":
      SaveBaseGenTable(dialogForm.value).then(response => {
        if (response.code == 200) {
          open.value = false
          getList()
          ElMessage.success("添加成功")
        } else {
          ElMessage.error("添加失败")
        }
      })
      break
    default:
      break
  }
}
</script>