<template>
|
<div class="authorityManagement_box">
|
<My-bread :list="['数据管理', '字典管理']"></My-bread>
|
<el-divider />
|
<div class="searchComp">
|
<el-form ref="ruleForm" :model="ruleForm" :inline="true">
|
<el-form-item label="表名称" prop="name">
|
<el-select
|
clearable
|
v-model="queryName"
|
@change="changeQueryName"
|
placeholder="请选择表名称"
|
>
|
<el-option
|
v-for="(item, i) in selectData"
|
:key="i"
|
:label="item.tabDesc"
|
:value="item.tab"
|
>
|
</el-option>
|
</el-select>
|
</el-form-item>
|
<el-form-item>
|
<el-button
|
@click="InsertFormdialog = true"
|
icon="el-icon-edit"
|
type="success"
|
size="small"
|
>新增</el-button
|
>
|
<el-button
|
@click="DelFormData"
|
icon="el-icon-delete"
|
type="danger"
|
size="small"
|
>删除</el-button
|
>
|
</el-form-item>
|
</el-form>
|
</div>
|
<div class="bottom">
|
<div class="rightTable">
|
<div class="table_box">
|
<el-table
|
:data="tableData"
|
border
|
style="width: 100%"
|
@selection-change="handleSelectionChange"
|
height="98%"
|
>
|
<el-table-column type="selection" width="55" />
|
<el-table-column prop="orderNum" label="编号" />
|
<el-table-column min-width="100" prop="field" label="字段名称" />
|
<el-table-column min-width="90" prop="alias" label="字段显示名称" />
|
<el-table-column min-width="100" prop="type" label="字段类型" />
|
<el-table-column min-width="60" prop="len" label="字段长度" />
|
<el-table-column min-width="60" prop="precision" label="字段精度" />
|
<el-table-column min-width="100" prop="tab" label="值域关联表" />
|
<el-table-column min-width="100" prop="bak" label="备注" />
|
<el-table-column
|
min-width="100"
|
prop="createTime"
|
label="创建时间"
|
:formatter="formatData"
|
/>
|
<el-table-column
|
min-width="100"
|
prop="createUser"
|
label="创建人员"
|
/>
|
<el-table-column
|
min-width="100"
|
prop="updateTime"
|
label="更新时间"
|
:formatter="formatData"
|
/>
|
<el-table-column
|
min-width="100"
|
prop="updateUser"
|
label="更新人员"
|
/>
|
|
<el-table-column min-width="70" label="操作">
|
<template slot-scope="scope">
|
<el-link @click="showDetail(scope.$index, scope.row)"
|
>查看</el-link
|
>
|
<el-link
|
@click="handleEdit(scope.$index, scope.row)"
|
style="margin-left: 10px"
|
>修改</el-link
|
>
|
<!-- <el-link
|
@click="handleDelete(scope.$index, scope.row)"
|
style="margin-left: 10px"
|
>删除</el-link
|
> -->
|
</template>
|
</el-table-column>
|
</el-table>
|
</div>
|
<div
|
style="margin-top: 20px; text-align: center"
|
class="pagination_box"
|
>
|
<el-pagination
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
:current-page="listData.pageIndex"
|
:page-sizes="[10, 20, 50, 100]"
|
:page-size="listData.pageSize"
|
layout="total, sizes, prev, pager, next, jumper"
|
:total="count"
|
>
|
</el-pagination>
|
</div>
|
</div>
|
</div>
|
<div class="infoBox" v-show="showinfoBox">
|
<el-card class="box-card">
|
<div slot="header" class="clearfix">
|
<span>详细信息</span>
|
<div style="float: right; cursor: pointer" @click="closeDetial">
|
<i class="el-icon-close"></i>
|
</div>
|
</div>
|
<div class="contentBox">
|
<p>表名称：{{ itemdetail.tab }}</p>
|
<el-divider></el-divider>
|
<p>表显示名称：{{ itemdetail.tabDesc }}</p>
|
<el-divider></el-divider>
|
<!-- <p>表类型：{{ itemdetail.type }}</p>
|
<el-divider></el-divider> -->
|
<p>字段名称：{{ itemdetail.field }}</p>
|
<el-divider></el-divider>
|
<p>字段显示名称：{{ itemdetail.alias }}</p>
|
<el-divider></el-divider>
|
<p>字段类型：{{ itemdetail.type }}</p>
|
<el-divider></el-divider>
|
<p>字段长度：{{ itemdetail.len }}</p>
|
<el-divider></el-divider>
|
<p>字段精度：{{ itemdetail.precision }}</p>
|
<el-divider></el-divider>
|
<!-- <p>值域关联表：{{ itemdetail.domain_name }}</p>
|
<el-divider></el-divider> -->
|
<p>备注：{{ itemdetail.bak }}</p>
|
<el-divider></el-divider>
|
<p>创建时间：{{ itemdetail.createTime }}</p>
|
<el-divider></el-divider>
|
<p>创建人员：{{ itemdetail.createUser }}</p>
|
<el-divider></el-divider>
|
<p>更新时间：{{ itemdetail.updateTime }}</p>
|
<el-divider></el-divider>
|
<p>更新人员：{{ itemdetail.updateUser }}</p>
|
</div>
|
</el-card>
|
</div>
|
<el-dialog
|
top="3vh"
|
style="overflow: hidden"
|
title="修改详情"
|
:visible.sync="dialogFormVisible"
|
>
|
<el-form :model="upform">
|
<el-form-item label="编号" :label-width="formLabelWidth">
|
<el-input v-model="upform.orderNum" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="表名" :label-width="formLabelWidth">
|
<el-input v-model="upform.tab" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="表别名" :label-width="formLabelWidth">
|
<el-input v-model="upform.tabDesc" autocomplete="off"></el-input>
|
</el-form-item>
|
<!-- <el-form-item label="类型" :label-width="formLabelWidth">
|
<el-select
|
v-model="upform.table_type"
|
style="width: 100%"
|
placeholder="请选择数据类型"
|
>
|
<el-option label="点几何" value="点几何"></el-option>
|
<el-option label="线几何" value="线几何"></el-option>
|
<el-option label="面几何" value="面几何"></el-option>
|
</el-select>
|
</el-form-item> -->
|
<el-form-item label="字段名称" :label-width="formLabelWidth">
|
<el-input v-model="upform.field" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="字段别名" :label-width="formLabelWidth">
|
<el-input v-model="upform.alias" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="字段类型" :label-width="formLabelWidth">
|
<el-input v-model="upform.type" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="长度" :label-width="formLabelWidth">
|
<el-input v-model="upform.len" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="精度" :label-width="formLabelWidth">
|
<el-input v-model="upform.precision" autocomplete="off"></el-input>
|
</el-form-item>
|
<!-- <el-form-item label="值域名称" :label-width="formLabelWidth">
|
<el-input v-model="upform.domain_name" autocomplete="off"></el-input>
|
</el-form-item> -->
|
<el-form-item label="备注" :label-width="formLabelWidth">
|
<el-input v-model="upform.bak" autocomplete="off"></el-input>
|
</el-form-item>
|
</el-form>
|
<div slot="footer" class="dialog-footer">
|
<el-button @click="dialogFormVisible = false">取 消</el-button>
|
<el-button type="primary" @click="updateForm">确 定</el-button>
|
</div>
|
</el-dialog>
|
<el-dialog
|
title="添加数据"
|
top="3vh"
|
style="overflow: hidden"
|
:visible.sync="InsertFormdialog"
|
>
|
<el-form :model="insertform">
|
<el-form-item label="编号" :label-width="formLabelWidth">
|
<el-input v-model="insertform.oid" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="表名" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.table_name"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="表别名" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.table_alias"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="类型" :label-width="formLabelWidth">
|
<el-select
|
v-model="insertform.table_type"
|
style="width: 100%"
|
placeholder="请选择数据类型"
|
>
|
<el-option label="点几何" value="点几何"></el-option>
|
<el-option label="线几何" value="线几何"></el-option>
|
<el-option label="面几何" value="面几何"></el-option>
|
</el-select>
|
</el-form-item>
|
<el-form-item label="字段名称" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.field_name"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="字段别名" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.field_alias"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="字段类型" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.field_type"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="长度" :label-width="formLabelWidth">
|
<el-input v-model="insertform.length" autocomplete="off"></el-input>
|
</el-form-item>
|
<el-form-item label="精度" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.precision"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="值域名称" :label-width="formLabelWidth">
|
<el-input
|
v-model="insertform.domain_name"
|
autocomplete="off"
|
></el-input>
|
</el-form-item>
|
<el-form-item label="备注" :label-width="formLabelWidth">
|
<el-input v-model="insertform.remarks" autocomplete="off"></el-input>
|
</el-form-item>
|
</el-form>
|
<div slot="footer" class="dialog-footer">
|
<el-button @click="InsertFormdialog = false">取 消</el-button>
|
<el-button type="primary" @click="insertFromData">确 定</el-button>
|
</div>
|
</el-dialog>
|
</div>
|
</template>
|
|
<script>
|
import {
|
selectByPageAndCount,
|
selectDictTab,
|
deleteDicts,
|
updateDict,
|
} from "../../api/api";
|
import MyBread from "../../components/MyBread.vue";
|
export default {
|
name: "dictionaryManage",
|
components: { MyBread },
|
data() {
|
return {
|
multipleSelection: [],
|
formLabelWidth: "120px",
|
dialogFormVisible: false,
|
InsertFormdialog: false,
|
insertform: {},
|
upform: {},
|
showinfoBox: false,
|
itemdetail: {},
|
ruleForm: {
|
name: "",
|
},
|
tableData: [],
|
count: 0,
|
currentPage: 1,
|
searchName: "",
|
selectName: [],
|
queryName: "",
|
listData: {
|
pageIndex: 1,
|
pageSize: 10,
|
},
|
selectData: [],
|
};
|
},
|
created() {
|
this.startQueryNameData();
|
this.getSelectDictTab();
|
},
|
methods: {
|
//下拉选项调用
|
async getSelectDictTab() {
|
this.selectData = [];
|
const data = await selectDictTab();
|
if (data.code != 200) {
|
this.$message.error("下拉调用失败");
|
}
|
data.result.forEach((e) => {
|
if (e) {
|
this.selectData.push({
|
tab: e.tab,
|
tabDesc: `${e.tabDesc}（${e.tab}）`,
|
});
|
}
|
});
|
},
|
//列表请求
|
async startQueryNameData() {
|
if (this.listData.tab == "") {
|
delete this.listData.tab;
|
}
|
const data = await selectByPageAndCount(this.listData);
|
if (data.code != 200) {
|
this.$message.error("列表调用失败");
|
}
|
this.tableData = data.result;
|
this.count = data.count;
|
},
|
//格式化时间
|
add0(m) {
|
return m < 10 ? "0" + m : m;
|
},
|
//格式化时间
|
format(shijianchuo) {
|
//shijianchuo是整数，否则要parseInt转换
|
var time = new Date(shijianchuo);
|
var y = time.getFullYear();
|
var m = time.getMonth() + 1;
|
var d = time.getDate();
|
var h = time.getHours();
|
var mm = time.getMinutes();
|
var s = time.getSeconds();
|
return (
|
y + "-" + this.add0(m) + "-" + this.add0(d)
|
// " " +
|
// this.add0(h) +
|
// ":" +
|
// this.add0(mm) +
|
// ":" +
|
// this.add0(s)
|
);
|
},
|
//格式化列表
|
formatData(row, column) {
|
let data = row[column.property];
|
if (data == null) {
|
return data;
|
}
|
return this.format(data);
|
},
|
//修改详情
|
updateForm() {
|
this.$confirm("是否确定保存修改内容?", "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(async () => {
|
const data = await updateDict(this.upform);
|
if (data.code != 200) {
|
this.$message.error("修改失败");
|
}
|
this.dialogFormVisible = false;
|
this.startQueryNameData();
|
this.$message({
|
message: "修改成功",
|
type: "success",
|
});
|
})
|
.catch(() => {});
|
},
|
submitForm(formName) {
|
this.$refs[formName].validate((valid) => {
|
if (valid) {
|
this.searchName = this.ruleForm.name.trim();
|
this.count = 0;
|
this.selectFromData(10, 1, this.searchName);
|
this.countFromData(this.searchName);
|
} else {
|
console.log("error submit!!");
|
return false;
|
}
|
});
|
},
|
resetForm(formName) {
|
this.count = 0;
|
this.pageSize = 1;
|
this.pageNum = 10;
|
this.selectFromData(10, 1, "");
|
this.countFromData("");
|
this.searchName = "";
|
this.$refs[formName].resetFields();
|
},
|
showDetail(index, row) {
|
// console.log(index, row);
|
this.showinfoBox = true;
|
this.itemdetail = row;
|
},
|
closeDetial() {
|
this.showinfoBox = false;
|
this.itemdetail = {};
|
},
|
//修改详情弹框
|
handleEdit(index, row) {
|
this.dialogFormVisible = true;
|
this.upform = row;
|
console.log(this.upform);
|
},
|
handleDelete(index, row) {
|
this.$confirm("确定是否删除所选内容?", "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(() => {
|
this.$message({
|
type: "success",
|
message: "删除成功!",
|
});
|
this.startFromData();
|
})
|
.catch(() => {});
|
},
|
handleSizeChange(val) {
|
console.log(val);
|
// console.log(`每页 ${val} 条`);
|
this.listData.pageSize = val;
|
this.startQueryNameData();
|
},
|
handleCurrentChange(val) {
|
this.listData.pageIndex = val;
|
this.startQueryNameData();
|
},
|
|
insertFromData() {
|
this.$confirm("是否确定添加?", "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(() => {
|
this.InsertFormdialog = false;
|
})
|
.catch(() => {});
|
},
|
countFromData(name) {},
|
selectFromData(size, index, name) {},
|
//列表选择
|
handleSelectionChange(val) {
|
this.multipleSelection = val;
|
},
|
//删除列表
|
DelFormData() {
|
var std = [];
|
console.log(this.multipleSelection);
|
for (var i in this.multipleSelection) {
|
std.push(this.multipleSelection[i].id);
|
}
|
this.$confirm("确定是否删除所选内容?", "提示", {
|
confirmButtonText: "确定",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(async () => {
|
const data = await deleteDicts({ ids: std.toString() });
|
if (data.code != 200) {
|
this.$message.error("列表删除失败");
|
}
|
this.$message({
|
type: "success",
|
message: "删除成功!",
|
});
|
this.startFromData();
|
})
|
.catch(() => {});
|
},
|
startFromData() {
|
this.count = 0;
|
this.pageSize = 1;
|
this.pageNum = 10;
|
this.selectFromData(10, 1, this.searchName);
|
this.countFromData(this.searchName);
|
},
|
//搜索框
|
changeQueryName(val) {
|
this.listData.tab = val;
|
this.startQueryNameData();
|
},
|
},
|
};
|
</script>
|
<style lang="less" scoped>
|
//@import url(); 引入公共css类
|
.authorityManagement_box {
|
background: rgb(240, 242, 245);
|
border-radius: 10px;
|
height: 100%;
|
padding: 10px;
|
box-sizing: border-box;
|
.searchComp {
|
margin: 10px auto;
|
background: #fff;
|
border-radius: 5px;
|
border: 1px solid rgb(202, 201, 204);
|
.el-form-item {
|
margin: 5px;
|
}
|
.el-input {
|
width: 467px;
|
}
|
}
|
.bottom {
|
width: 100%;
|
height: 85%;
|
.rightTable {
|
height: 100%;
|
width: 100%;
|
.table_box {
|
width: 100%;
|
height: 93%;
|
margin: 0 auto;
|
overflow: auto;
|
background: #fff;
|
.el-table {
|
height: 100%;
|
}
|
.el-table /deep/ .el-table__header-wrapper tr th {
|
background-color: rgb(255, 255, 255) !important;
|
color: rgb(0, 0, 0);
|
}
|
// 修改每行样式：
|
.el-table /deep/ .el-table__row {
|
background-color: rgba(255, 255, 255) !important;
|
color: rgb(0, 0, 0);
|
}
|
.el-table /deep/ .el-table__body tr.current-row > td {
|
background-color: rgb(211, 211, 211) !important;
|
}
|
.el-table /deep/ .el-table__body tr:hover > td {
|
background-color: rgb(211, 211, 211) !important;
|
}
|
// 修改表格每行边框的样式：
|
.el-table /deep/ td,
|
.el-table /deep/ th.is-leaf {
|
border-bottom: 1px solid #eee;
|
border-right: 1px solid #eee;
|
}
|
.el-table /deep/ .el-table__cell {
|
padding: 0;
|
}
|
// 设置表格每行的高度：
|
.el-table /deep/ .el-table__header tr,
|
.el-table /deep/ .el-table__header th {
|
height: 40px;
|
}
|
.el-table__body tr,
|
.el-table__body td {
|
height: 40px;
|
padding: 0;
|
}
|
// 设置表格边框颜色：
|
|
.el-table--border::after,
|
.el-table--group::after {
|
width: 0;
|
}
|
.el-table::before {
|
height: 0;
|
}
|
// a {
|
// color: #000;
|
// }
|
}
|
}
|
}
|
.infoBox {
|
width: 500px;
|
border: 1px solid #eee;
|
position: absolute;
|
z-index: 100;
|
top: 15%;
|
right: 25%;
|
background-color: #fff;
|
.el-card {
|
background-color: transparent;
|
span {
|
font-size: 16px;
|
font-weight: 600;
|
}
|
}
|
.contentBox {
|
margin: 0 aotu 10px;
|
height: 610px;
|
overflow: auto;
|
p {
|
// background-color: #bfa;
|
// margin-bottom: 10px;
|
font-size: 14px;
|
}
|
}
|
}
|
}
|
</style>
|
