王旭
2022-09-29 4cf81d61254f532d9c7dc4a4219b1c843a9f2dad
src/views/datamanage/dictionaryManage.vue
@@ -1,15 +1,20 @@
<template>
  <div class="authorityManagement_box">
    <My-bread :list="['数据管理', '字典管理']"></My-bread>
    <My-bread
      :list="[
        `${$t('dataManage.dataManage')}`,
        `${$t('dataManage.dictionaryManage')}`,
      ]"
    ></My-bread>
    <el-divider />
    <div class="searchComp">
      <el-form ref="ruleForm" :model="ruleForm" :inline="true">
        <el-form-item label="表名称" prop="name">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.tableName')" prop="name">
          <el-select
            clearable
            v-model="queryName"
            @change="changeQueryName"
            placeholder="请选择表名称"
            :placeholder="$t('dataManage.dictionaryManageObj.selectTableName')"
          >
            <el-option
              v-for="(item, i) in selectData"
@@ -26,14 +31,14 @@
            icon="el-icon-edit"
            type="success"
            size="small"
            >新增</el-button
            >{{$t('dataManage.dictionaryManageObj.add')}}</el-button
          >
          <el-button
            @click="DelFormData"
            icon="el-icon-delete"
            type="danger"
            size="small"
            >删除</el-button
            >{{$t('dataManage.dictionaryManageObj.del')}}</el-button
          >
        </el-form-item>
      </el-form>
@@ -49,52 +54,47 @@
            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 prop="orderNum" :label="$t('dataManage.dictionaryManageObj.number')" />
            <el-table-column min-width="100" prop="field" :label="$t('dataManage.dictionaryManageObj.fieldName')" />
            <el-table-column min-width="90" prop="alias" :label="$t('dataManage.dictionaryManageObj.fieldAliasName')" />
            <el-table-column min-width="100" prop="type" :label="$t('dataManage.dictionaryManageObj.fieldType')" />
            <el-table-column min-width="60" prop="len" :label="$t('dataManage.dictionaryManageObj.fieldLength')" />
            <el-table-column min-width="60" prop="precision" :label="$t('dataManage.dictionaryManageObj.FieldPrecision')" />
            <el-table-column min-width="100" prop="tab" :label="$t('dataManage.dictionaryManageObj.rangeAssociationTable')" />
            <el-table-column min-width="100" prop="bak" :label="$t('dataManage.dictionaryManageObj.remark')" />
            <el-table-column
              min-width="100"
              prop="createTime"
              label="创建时间"
              :label="$t('dataManage.dictionaryManageObj.creationTime')"
              :formatter="formatData"
            />
            <el-table-column
              min-width="100"
              prop="createUser"
              label="创建人员"
              :label="$t('dataManage.dictionaryManageObj.createPersonnel')"
            />
            <el-table-column
              min-width="100"
              prop="updateTime"
              label="更新时间"
              :label="$t('dataManage.dictionaryManageObj.updateTime')"
              :formatter="formatData"
            />
            <el-table-column
              min-width="100"
              prop="updateUser"
              label="更新人员"
              :label="$t('dataManage.dictionaryManageObj.updatePersonnel')"
            />
            <el-table-column min-width="70" label="操作">
            <el-table-column min-width="70" :label="$t('dataManage.dictionaryManageObj.operation')">
              <template slot-scope="scope">
                <el-link @click="showDetail(scope.$index, scope.row)"
                  >查看</el-link
                  >{{$t('dataManage.dictionaryManageObj.lookOver')}}</el-link
                >
                <el-link
                  @click="handleEdit(scope.$index, scope.row)"
                  style="margin-left: 10px"
                  >修改</el-link
                  >{{$t('dataManage.dictionaryManageObj.revamp')}}</el-link
                >
                <!-- <el-link
                  @click="handleDelete(scope.$index, scope.row)"
                  style="margin-left: 10px"
                  >删除</el-link
                > -->
              </template>
            </el-table-column>
          </el-table>
@@ -119,56 +119,56 @@
    <div class="infoBox" v-show="showinfoBox">
      <el-card class="box-card">
        <div slot="header" class="clearfix">
          <span>详细信息</span>
          <span>{{$t('dataManage.dictionaryManageObj.particulars')}}</span>
          <div style="float: right; cursor: pointer" @click="closeDetial">
            <i class="el-icon-close"></i>
          </div>
        </div>
        <div class="contentBox">
          <p>表名称:{{ itemdetail.tab }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.tableName')}}:{{ itemdetail.tab }}</p>
          <el-divider></el-divider>
          <p>表显示名称:{{ itemdetail.tabDesc }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.tableAliasName')}}:{{ itemdetail.tabDesc }}</p>
          <el-divider></el-divider>
          <!-- <p>表类型:{{ itemdetail.type }}</p>
          <el-divider></el-divider> -->
          <p>字段名称:{{ itemdetail.field }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.fieldName')}}:{{ itemdetail.field }}</p>
          <el-divider></el-divider>
          <p>字段显示名称:{{ itemdetail.alias }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.fieldAliasName')}}:{{ itemdetail.alias }}</p>
          <el-divider></el-divider>
          <p>字段类型:{{ itemdetail.type }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.fieldType')}}:{{ itemdetail.type }}</p>
          <el-divider></el-divider>
          <p>字段长度:{{ itemdetail.len }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.fieldLength')}}:{{ itemdetail.len }}</p>
          <el-divider></el-divider>
          <p>字段精度:{{ itemdetail.precision }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.FieldPrecision')}}:{{ itemdetail.precision }}</p>
          <el-divider></el-divider>
          <!-- <p>值域关联表:{{ itemdetail.domain_name }}</p>
          <el-divider></el-divider> -->
          <p>备注:{{ itemdetail.bak }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.remark')}}:{{ itemdetail.bak }}</p>
          <el-divider></el-divider>
          <p>创建时间:{{ itemdetail.createTime }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.creationTime')}}:{{ itemdetail.createTime }}</p>
          <el-divider></el-divider>
          <p>创建人员:{{ itemdetail.createUser }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.createPersonnel')}}:{{ itemdetail.createUser }}</p>
          <el-divider></el-divider>
          <p>更新时间:{{ itemdetail.updateTime }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.updateTime')}}:{{ itemdetail.updateTime }}</p>
          <el-divider></el-divider>
          <p>更新人员:{{ itemdetail.updateUser }}</p>
          <p>{{$t('dataManage.dictionaryManageObj.updatePersonnel')}}:{{ itemdetail.updateUser }}</p>
        </div>
      </el-card>
    </div>
    <el-dialog
      top="3vh"
      style="overflow: hidden"
      title="修改详情"
      :title="$t('dataManage.dictionaryManageObj.revamp')"
      :visible.sync="dialogFormVisible"
    >
      <el-form :model="upform">
        <el-form-item label="编号" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.number')" :label-width="formLabelWidth">
          <el-input v-model="upform.orderNum" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表名" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.tableName')" :label-width="formLabelWidth">
          <el-input v-model="upform.tab" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="表别名" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.tableAliasName')" :label-width="formLabelWidth">
          <el-input v-model="upform.tabDesc" autocomplete="off"></el-input>
        </el-form-item>
        <!-- <el-form-item label="类型" :label-width="formLabelWidth">
@@ -182,56 +182,50 @@
            <el-option label="面几何" value="面几何"></el-option>
          </el-select>
        </el-form-item> -->
        <el-form-item label="字段名称" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldName')" :label-width="formLabelWidth">
          <el-input v-model="upform.field" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段别名" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldAliasName')" :label-width="formLabelWidth">
          <el-input v-model="upform.alias" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段类型" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldType')" :label-width="formLabelWidth">
          <el-input v-model="upform.type" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="长度" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldLength')" :label-width="formLabelWidth">
          <el-input v-model="upform.len" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="精度" :label-width="formLabelWidth">
        <el-form-item :label="$t('dataManage.dictionaryManageObj.FieldPrecision')" :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-form-item :label="$t('dataManage.dictionaryManageObj.remark')" :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>
        <el-button @click="dialogFormVisible = false">{{$t('dataManage.dictionaryManageObj.cancel')}}</el-button>
        <el-button type="primary" @click="updateForm">{{$t('dataManage.dictionaryManageObj.confirm')}}</el-button>
      </div>
    </el-dialog>
    <el-dialog
      title="添加数据"
      :title="$t('dataManage.dictionaryManageObj.add')"
      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 :label="$t('dataManage.dictionaryManageObj.number')" :label-width="formLabelWidth">
          <el-input v-model="insertform.orderNum" 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 :label="$t('dataManage.dictionaryManageObj.tableName')" :label-width="formLabelWidth">
          <el-input v-model="insertform.tab" 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 :label="$t('dataManage.dictionaryManageObj.tableAliasName')" :label-width="formLabelWidth">
          <el-input v-model="insertform.tabDesc" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="类型" :label-width="formLabelWidth">
        <!-- <el-form-item label="类型" :label-width="formLabelWidth">
          <el-select
            v-model="insertform.table_type"
            style="width: 100%"
@@ -241,47 +235,38 @@
            <el-option label="线几何" value="线几何"></el-option>
            <el-option label="面几何" value="面几何"></el-option>
          </el-select>
        </el-form-item> -->
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldName')" :label-width="formLabelWidth">
          <el-input v-model="insertform.field" autocomplete="off"></el-input>
        </el-form-item>
        <el-form-item label="字段名称" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.field_name"
            autocomplete="off"
          ></el-input>
        <el-form-item :label="$t('dataManage.dictionaryManageObj.fieldAliasName')" :label-width="formLabelWidth">
          <el-input v-model="insertform.alias" 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 :label="$t('dataManage.dictionaryManageObj.fieldType')" :label-width="formLabelWidth">
          <el-input v-model="insertform.type" 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 :label="$t('dataManage.dictionaryManageObj.fieldLength')" :label-width="formLabelWidth">
          <el-input v-model="insertform.len" 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-form-item :label="$t('dataManage.dictionaryManageObj.FieldPrecision')" :label-width="formLabelWidth">
          <el-input
            v-model="insertform.precision"
            autocomplete="off"
          ></el-input>
        </el-form-item>
        <el-form-item label="值域名称" :label-width="formLabelWidth">
        <!-- <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-item :label="$t('dataManage.dictionaryManageObj.remark')" :label-width="formLabelWidth">
          <el-input v-model="insertform.bak" 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>
        <el-button @click="InsertFormdialog = false">{{$t('dataManage.dictionaryManageObj.cancel')}}</el-button>
        <el-button type="primary" @click="insertFromData">{{$t('dataManage.dictionaryManageObj.confirm')}}</el-button>
      </div>
    </el-dialog>
  </div>
@@ -293,6 +278,7 @@
  selectDictTab,
  deleteDicts,
  updateDict,
  insertDict,
} from "../../api/api";
import MyBread from "../../components/MyBread.vue";
export default {
@@ -391,47 +377,27 @@
    },
    //修改详情
    updateForm() {
      this.$confirm("是否确定保存修改内容?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
      this.$confirm(`${$t('dataManage.dictionaryManageObj.tipsUp')}`,`${$t('dataManage.dictionaryManageObj.tips')}`, {
        confirmButtonText: `${$t('dataManage.dictionaryManageObj.confirm')}`,
        cancelButtonText: `${$t('dataManage.dictionaryManageObj.cancel')}`,
        type: "warning",
      })
        .then(async () => {
          const data = await updateDict(this.upform);
          if (data.code != 200) {
            this.$message.error("修改失败");
            this.$message.error(`${$t('dataManage.dictionaryManageObj.failModify')}`);
          }
          this.dialogFormVisible = false;
          this.startQueryNameData();
          this.$message({
            message: "修改成功",
            message: `${$t('dataManage.dictionaryManageObj.modifySuccessfully')}`,
            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;
@@ -447,21 +413,7 @@
      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} 条`);
@@ -472,20 +424,28 @@
      this.listData.pageIndex = val;
      this.startQueryNameData();
    },
    //新增
    insertFromData() {
      this.$confirm("是否确定添加?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
      this.$confirm(`${$t('dataManage.dictionaryManageObj.tipsAdd')}`, `${$t('dataManage.dictionaryManageObj.tips')}`, {
        confirmButtonText: `${$t('dataManage.dictionaryManageObj.confirm')}`,
        cancelButtonText: `${$t('dataManage.dictionaryManageObj.cancel')}`,
        type: "warning",
      })
        .then(() => {
        .then(async () => {
          const data = await insertDict(this.insertform);
          if (data.code != 200) {
            this.$message.error( `${$t('dataManage.dictionaryManageObj.FailedAdd')}`);
          }
          this.InsertFormdialog = false;
          this.startQueryNameData();
          this.$message({
            message: `${$t('dataManage.dictionaryManageObj.NewSuccess')}`,
            type: "success",
          });
        })
        .catch(() => {});
    },
    countFromData(name) {},
    selectFromData(size, index, name) {},
    //列表选择
    handleSelectionChange(val) {
      this.multipleSelection = val;
@@ -497,31 +457,25 @@
      for (var i in this.multipleSelection) {
        std.push(this.multipleSelection[i].id);
      }
      this.$confirm("确定是否删除所选内容?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
      this.$confirm(`${$t('dataManage.dictionaryManageObj.tipsDelete')}`, `${$t('dataManage.dictionaryManageObj.tips')}`, {
        confirmButtonText:`${$t('dataManage.dictionaryManageObj.confirm')}`,
        cancelButtonText: `${$t('dataManage.dictionaryManageObj.cancel')}`,
        type: "warning",
      })
        .then(async () => {
          const data = await deleteDicts({ ids: std.toString() });
          if (data.code != 200) {
            this.$message.error("列表删除失败");
            this.$message.error(`${$t('dataManage.dictionaryManageObj.DeleteFailed')}`);
          }
          this.$message({
            type: "success",
            message: "删除成功!",
            message:`${$t('dataManage.dictionaryManageObj.deletedSuccessfully')}`,
          });
          this.startFromData();
          this.startQueryNameData();
        })
        .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;