| | |
| | | <el-card class="search-card"> |
| | | <div slot="header" class="clearfix"> |
| | | <span>查询条件</span> |
| | | <el-button |
| | | style="float: right; padding: 3px 0" |
| | | <el-button |
| | | style="float: right; padding: 3px 0" |
| | | type="text" |
| | | @click="toggleCollapse" |
| | | > |
| | | {{ collapse ? '展开' : '收起' }} |
| | | </el-button> |
| | | </div> |
| | | |
| | | |
| | | <el-form :model="queryParams" ref="queryForm" :inline="true"> |
| | | <el-row :gutter="20"> |
| | | <el-col :span="8"> |
| | | <el-form-item label="地区代码"> |
| | | <el-input |
| | | v-model="queryParams.HNumber" |
| | | <el-input |
| | | v-model="queryParams.HNumber" |
| | | placeholder="请输入地区代码" |
| | | clearable |
| | | /> |
| | |
| | | </el-col> |
| | | <el-col :span="8"> |
| | | <el-form-item label="地区名称"> |
| | | <el-input |
| | | v-model="queryParams.HName" |
| | | <el-input |
| | | v-model="queryParams.HName" |
| | | placeholder="请输入地区名称" |
| | | clearable |
| | | /> |
| | |
| | | </el-col> |
| | | <el-col :span="8"> |
| | | <el-form-item label="内容"> |
| | | <el-input |
| | | v-model="queryParams.ColContent" |
| | | <el-input |
| | | v-model="queryParams.ColContent" |
| | | placeholder="请输入内容" |
| | | clearable |
| | | /> |
| | |
| | | @selection-change="handleSelectionChange" |
| | | > |
| | | <el-table-column type="selection" width="55" align="center" /> |
| | | <el-table-column |
| | | <el-table-column |
| | | v-for="column in tableColumns" |
| | | :key="column.field" |
| | | :prop="column.field" |
| | |
| | | </el-table-column> |
| | | </el-table> |
| | | |
| | | |
| | | |
| | | <el-pagination |
| | | @size-change="handleSizeChange" |
| | | @current-change="handleCurrentChange" |
| | |
| | | dialogVisible: false, |
| | | collapse: false, |
| | | loading: false, |
| | | |
| | | |
| | | // 查询参数 |
| | | queryParams: { |
| | | HNumber: '', |
| | |
| | | Comparator: '0', |
| | | ColContent: '' |
| | | }, |
| | | |
| | | |
| | | // 表格数据 |
| | | tableData: [], |
| | | tableColumns: [], |
| | | selectedRow: null, |
| | | multipleSelection: [], |
| | | |
| | | |
| | | // 分页 |
| | | pagination: { |
| | | page: 1, |
| | | size: 50, |
| | | total: 0 |
| | | }, |
| | | |
| | | |
| | | // 隐藏字段 |
| | | hiddenFields: ["HItemID", "短代码", "父级ID", "等级", "末级标志", "助记码", "创建组织", "英文名称"], |
| | | |
| | | baseURL: process.env.VUE_APP_BASE_URL || 'http://47.96.97.237/API/', |
| | | |
| | | baseURL: process.env.VUE_APP_BASE_API || 'http://47.96.97.237/API/', |
| | | user: 'admin', |
| | | HModName: 'Gy_AreaSet' |
| | | } |
| | |
| | | initData() { |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | async loadTableData() { |
| | | this.loading = true |
| | | try { |
| | | const sWhere = this.buildQueryCondition() |
| | | |
| | | |
| | | const response = await axios.get(`${this.baseURL}/Gy_BadReason/Gy_AreaSetList`, { |
| | | params: { |
| | | sWhere: sWhere, |
| | |
| | | size: this.pagination.size |
| | | } |
| | | }) |
| | | |
| | | |
| | | if (response.data.count === 1) { |
| | | this.tableData = response.data.data |
| | | this.pagination.total = response.data.total || response.data.data.length |
| | |
| | | this.loading = false |
| | | } |
| | | }, |
| | | |
| | | |
| | | |
| | | |
| | | buildQueryCondition() { |
| | | let sWhere = "" |
| | | |
| | | |
| | | |
| | | if (this.queryParams.HNumber) { |
| | | sWhere += ` and 地区代码 like '%${this.queryParams.HNumber}%'` |
| | |
| | | sWhere += ` and 地区名称 like '%${this.queryParams.HName}%'` |
| | | } |
| | | |
| | | if (this.queryParams.ColName && this.queryParams.ColName !== "0" && |
| | | if (this.queryParams.ColName && this.queryParams.ColName !== "0" && |
| | | this.queryParams.Comparator && this.queryParams.Comparator !== "0") { |
| | | let com = "" |
| | | switch (this.queryParams.Comparator) { |
| | |
| | | } |
| | | sWhere += ` and ${this.queryParams.ColName} ${com}` |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | sWhere += this.addSWhereByOpenType() |
| | | |
| | | |
| | | return sWhere |
| | | }, |
| | | |
| | | |
| | | |
| | | addSWhereByOpenType() { |
| | | |
| | | return " and 禁用标志 = '否' and 审核人 != ''" |
| | | }, |
| | | |
| | | |
| | | |
| | | generateTableColumns(columnList) { |
| | | this.tableColumns = [] |
| | | |
| | | |
| | | |
| | | this.tableColumns.push({ type: 'selection', fixed: 'left' }) |
| | | |
| | | |
| | | |
| | | if (columnList && columnList.length > 0) { |
| | | columnList.forEach(item => { |
| | |
| | | sortable: true, |
| | | width: 200 |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | if (item.ColmType === 'DateTime') { |
| | | column.formatter = this.formatDate |
| | | } |
| | | |
| | | |
| | | this.tableColumns.push(column) |
| | | } |
| | | }) |
| | |
| | | this.tableColumns = [...this.tableColumns, ...defaultColumns] |
| | | } |
| | | }, |
| | | |
| | | |
| | | // 查询 |
| | | handleQuery() { |
| | | this.pagination.page = 1 |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | // 重置查询 |
| | | handleReset() { |
| | | this.queryParams = { |
| | |
| | | this.pagination.page = 1 |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | // 刷新 |
| | | handleRefresh() { |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | // 切换折叠状态 |
| | | toggleCollapse() { |
| | | this.collapse = !this.collapse |
| | | }, |
| | | |
| | | |
| | | // 行双击事件 |
| | | handleRowDblClick(row) { |
| | | this.selectedRow = row |
| | | this.confirmSelection() |
| | | }, |
| | | |
| | | |
| | | // 行点击事件 |
| | | handleRowClick(row) { |
| | | this.$refs.table.toggleRowSelection(row) |
| | | this.selectedRow = row |
| | | }, |
| | | |
| | | |
| | | // 选择变化 |
| | | handleSelectionChange(selection) { |
| | | this.multipleSelection = selection |
| | |
| | | this.selectedRow = selection[0] |
| | | } |
| | | }, |
| | | |
| | | |
| | | // 确认选择 |
| | | confirmSelection() { |
| | | if (this.selectedRow) { |
| | |
| | | this.$message.warning('请选择一条数据') |
| | | } |
| | | }, |
| | | |
| | | |
| | | // 退出 |
| | | handleExit() { |
| | | this.dialogVisible = false |
| | | }, |
| | | |
| | | |
| | | // 关闭对话框 |
| | | handleClose(done) { |
| | | this.$confirm('确认关闭?') |
| | |
| | | }) |
| | | .catch(_ => {}) |
| | | }, |
| | | |
| | | |
| | | // 分页大小改变 |
| | | handleSizeChange(size) { |
| | | this.pagination.size = size |
| | | this.pagination.page = 1 |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | // 当前页改变 |
| | | handleCurrentChange(page) { |
| | | this.pagination.page = page |
| | | this.loadTableData() |
| | | }, |
| | | |
| | | |
| | | // 格式化日期 |
| | | formatDate(dateString) { |
| | | if (!dateString) return '' |