Vue增删改查

表格增删改查

<template>
  <!-- 重置中用到了 handleQuery(),而handleQuery方法中又去调getUserInfo()-->
  <!-- 提交按钮(修改与新增)、删除里 去调getUserInfo() 分页中绑定的是 @pagination="getUserInfo" -->
  <!-- 创建完成created中去请求查询数据  this.getUserInfo();-->

  <div class="app-container">
    <div class="title-container">
      <span class="title-container-left">客户信息查询</span>
    </div>

    <el-form
      :model="queryParams"
      ref="queryForm"
      :inline="true"
      :label-position="labelPosition"
      label-width="100px"
    >
      <el-row>
        <el-col :span="8" :xs="24">
          <el-form-item label="客户号码" prop="customerNo">
            <el-input
              v-model="queryParams.customerNo"
              placeholder="请输入客户号码"
              clearable
              size="small"
              style="width: 240px"
              @keyup.enter.native="getUserInfo"
            />
          </el-form-item>
        </el-col>

        <el-col :span="8">
          <el-form-item label="姓名" prop="name">
            <el-input
              v-model="queryParams.name"
              placeholder="请输入姓名"
              clearable
              size="small"
              style="width: 240px"
              @keyup.enter.native="getUserInfo"
            /> </el-form-item
        ></el-col>

        <el-col :span="8" :xs="24">
          <el-form-item label="出生日期" prop="birthday">
            <el-date-picker
              size="small"
              style="width: 240px"
              value-format="yyyy-MM-dd"
              v-model="queryParams.birthday"
              placeholder="选择日期"
              @keyup.enter.native="getUserInfo"
            >
            </el-date-picker>

            <!-- <el-input
              v-model="queryParams.birthday"
              placeholder="请输入出生日期"
              clearable
              size="small"
              style="width: 240px"
              @keyup.enter.native="getUserInfo"
            />  -->
          </el-form-item></el-col
        >
      </el-row>

      <!-- second row-->
      <el-row>
        <el-col :span="8">
          <el-form-item label="性别" prop="sex">
            <el-select
              v-model="queryParams.sex"
              placeholder="请选择"
              clearable
              size="small"
              style="width: 240px"
              prop="sex"
            >
              <el-option label="男" value="0"></el-option>
              <el-option label="女" value="1"></el-option>
            </el-select>
          </el-form-item>
        </el-col>

        <el-col :span="8">
          <el-form-item label="证件类型" prop="idType">
            <el-select
              v-model="queryParams.idType"
              placeholder="请选择"
              clearable
              size="small"
              style="width: 240px"
            >
              <el-option label="身份证" value="01"></el-option>
            </el-select>
          </el-form-item>
        </el-col>

        <el-col :span="8">
          <el-form-item label="证件号码" prop="idNo">
            <el-input
              v-model="queryParams.idNo"
              placeholder="请输入证件号码"
              clearable
              size="small"
              style="width: 240px"
            />
          </el-form-item>
        </el-col>
      </el-row>
    </el-form>

    <!-- 查询按钮 :disabled="!submissionFlag"-->
    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button type="primary" size="mini" @click="handleQuery"
          >查询</el-button
        >
      </el-col>
      <!-- 删除 -->
      <el-col :span="1.5">
        <el-button
          type="danger"
          size="mini"
          @click="handleDelete"
          :disabled="multiple"
          v-hasPermi="['system:clientInfo:remove']"
          >删除</el-button
        >
      </el-col>

      <!-- 新增 -->
      <el-col :span="1.5">
        <el-button
          type="success"
          size="mini"
          @click="handleAdd"
          v-hasPermi="['system:clientInfo:add']"
          >新增</el-button
        >
      </el-col>

      <!-- 修改 -->
      <el-col :span="1.5">
        <el-button
          type="warning"
          size="mini"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['system:clientInfo:edit']"
          >修改</el-button
        >
      </el-col>

      <!-- 重置 -->
      <el-col :span="1.5">
        <el-button type="primary" size="mini" @click="resetQuery"
          >重置</el-button
        >
      </el-col>

      <!-- 导出 -->
      <!-- <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          v-hasPermi="['system:clientInfo:export']"
          >导出</el-button
        >
      </el-col> -->
    </el-row>

    <!-- 表格 -->
    <el-table
      v-loading="loading"
      :data="tableData"
      height="300px"
      style="width: 100%"
      class="table"
      @selection-change="handleSelectionChange"
    >
      <el-table-column type="selection" width="55" align="center" />

      <el-table-column
        prop="customerNo"
        label="客户号码"
        width="150"
      ></el-table-column>
      <el-table-column prop="name" label="姓名" width="150"></el-table-column>
      <el-table-column
        prop="sex"
        label="性别"
        width="150"
        :formatter="sexFormatter"
      ></el-table-column>

      <el-table-column
        prop="birthday"
        label="出生日期"
        width="200"
      ></el-table-column>

      <el-table-column
        prop="idType"
        label="证件类型"
        :formatter="idTypeFormatter"
        width="180"
      ></el-table-column>

      <el-table-column
        prop="idNo"
        label="证件号码"
        width="200"
      ></el-table-column>

      <el-table-column
        fixed="right"
        label="操作"
        align="center"
        class-name="small-padding fixed-width"
      >
        <template slot-scope="scope">
          <!-- 修改 -->
          <el-button
            size="mini"
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['system:clientInfo:edit']"
            >修改</el-button
          >
          <!-- 删除 -->
          <el-button
            size="mini"
            type="text"
            icon="el-icon-delete"
            @click.native.prevent="handleDelete(scope.row)"
            v-hasPermi="['system:clientInfo:remove']"
            >删除</el-button
          >
        </template>
      </el-table-column>
    </el-table>

    <!-- 对话框编辑***********************************************************-->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form
        ref="form"
        :model="form"
        :rules="rules"
        label-width="80px"
        class="demo-form"
      >
        <el-form-item label="姓名" prop="name">
          <el-input v-model="form.name" placeholder="请输入姓名" />
        </el-form-item>

        <el-form-item label="出生日期" prop="birthday">
          <!-- <el-input v-model="form.birthday" placeholder="请输入出生日期" /> -->
          <el-date-picker
            v-model="form.birthday"
            value-format="yyyy-MM-dd"
            placeholder="请输入出生日期"
            style="width: 100%"
          />
        </el-form-item>

        <!-- 性别 -->
        <el-form-item label="性别" prop="sex">
          <el-radio-group v-model="form.sex">
            <el-radio label="0">男</el-radio>
            <el-radio label="1">女</el-radio>
          </el-radio-group>
        </el-form-item>
        <!-- 证件类型  就一个身份证 -->
        <el-form-item label="证件类型" prop="idType">
          <el-select v-model="form.idType" placeholder="请选择证件类型">
            <el-option label="身份证" value="01"></el-option>
          </el-select>
        </el-form-item>

        <!-- 证件号码 -->
        <el-form-item label="证件号码" prop="idNo">
          <el-input v-model="form.idNo" placeholder="请输入证件号码" />
        </el-form-item>
      </el-form>
      <!-- 底部 -->
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>

    <!-- 分页 -->
    <!-- pageNum代表当前页号，即第几页，pageSize代表每页显示的条数。 -->
    <pagination
      v-show="total > 0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getUserInfo"
    />
  </div>
</template>

<script>
import {
  listClient,
  getClient,
  addClient,
  updateClient,
  delClient,
  exportClient,
} from "@/api/system/clientInfo";
export default {
  data() {
    return {
      // 遮罩层
      loading: false,
      // 对齐
      labelPosition: "",
      //默认灰色
      // submissionFlag: true,
      // 选中数组
      ids: [],
      // 不是多个时禁用(删除)
      multiple: true,
      // 不是单个时禁用(修改)
      single: true,
      // 总条数
      total: 0,
      // 客户表格数据
      tableData: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 日期
      birthday: "",

      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        customerNo: "",
        name: "",
        birthday: "",
        sex: "",
        idType: "",
        idNo: "",
      },

      // 表单参数 对话框
      form: {
        name: undefined,
        birthday: undefined,
        sex: undefined,
        idType: undefined,
        idNo: undefined,
      },

      // 表单校验
      rules: {
        name: [{ required: true, message: "姓名不能为空", trigger: "blur" }],
        birthday: [
          { required: true, message: "出生日期不能为空", trigger: "blur" },
        ],
        sex: [{ required: true, message: "性别不能为空", trigger: "blur" }],
        idType: [
          { required: true, message: "证件类型不能为空", trigger: "blur" },
        ],
        idNo: [
          { required: true, message: "证件号码不能为空", trigger: "blur" },
        ],
      },

      // 客户表格的数据
      newData: [
        {
          customerNo: "001",
          name: "用户1",
          sex: "男",
          birthday: "2016-05-02",
          idNo: "12300000009999",
          idType: "01",
        },
        {
          customerNo: "002",
          name: "用户2",
          sex: "女",
          birthday: "2016-05-02",
          idNo: "12345678910123456",
          idType: "01",
        },
        {
          customerNo: "003",
          name: "用户3",
          sex: "女",
          birthday: "2016-05-02",
          idNo: "1234567999923456",
          idType: "01",
        },
      ],
    };
  },

  methods: {
    // 查询客户列表tableData
    getUserInfo() {
      // this.submissionFlag = false;
      // this.tableData = this.newData;//测试   
      listClient(this.queryParams).then((response) => {
        // this.tableData = response.data.returnUser; //无分页
        this.tableData = response.rows;
        this.total = response.total; //分页
        // this.submissionFlag = true;
      });
    },

    /** 查询按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getUserInfo();
    },

    // 性别校验
    sexFormatter(row) {
      return row.sex == 0 ? "男" : "女";
    },
    // sexFormatter(row) {
    //   const sex = row.sex;
    //   if (sex == 0) {
    //     return "男";
    //   } else {
    //     return "女";
    //   }
    // },
    // 证件类型
    idTypeFormatter(row) {
      const idType = row.idType;
      if (idType == "01") {
        return "身份证";
      } else {
        return "其他";
      }
    },

    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    reset() {
      this.form = {
        name: undefined,
        birthday: undefined,
        sex: undefined,
        idType: undefined,
        idNo: undefined,
      };
      this.resetForm("form");
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.resetForm("queryForm");
      // this.getUserInfo();
      this.handleQuery();
      // 将getUserInfo替换成handleQuery
    },
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map((item) => item.customerNo);
      this.single = selection.length != 1;
      this.multiple = !selection.length;
    },

    // 新增按钮
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加客户信息";
    },

    // 确定按钮
    submitForm: function () {
      this.$refs["form"].validate((valid) => {
        // 校验成功
        if (valid) {
          console.log("customerNo=" + this.form.customerNo);
          // 判断
          if (this.form.customerNo != undefined) {
            updateClient(this.form).then((response) => {
              this.$message("修改成功");
              this.open = false;
              this.getUserInfo();
            });
          } else {
            addClient(this.form).then((response) => {
              this.$message("新增成功");
              this.open = false;
              this.getUserInfo();
            });
          }
        }
      });
    },

    // 修改按钮
    handleUpdate(row) {
      this.reset();
      const customerId = row.customerNo || this.ids[0];
      const customerNoData = {
        customerNo: customerId,
      };
      getClient(customerNoData).then((response) => {
        this.form = response.data.returnUser[0]; 
        this.open = true;
        this.title = "修改客户信息";
      });
    },

    // 删除
    handleDelete(row) {
      const customerNos = row.customerNo || this.ids[0];
      const customerNosData = {
        customerNo: customerNos,
      };
      this.$confirm(
        '是否删除客户号码为"' + customerNos + '"的数据项?',
        "警告",
        {
          confirmButtonText: "确定",
          cancelButtonText: "取消",
          type: "warning",
        }
      )
        .then(function () {
          return delClient(customerNosData);
          // this.tableData.splice(idx, 1);
        })
        .then(() => {
          this.getUserInfo();
          this.$message("删除成功");
        })
        .catch(() => {});
    },

    /** 导出按钮操作 */
    handleExport() {
      const queryParams = this.queryParams;
      this.$confirm("是否确认导出所有用户数据项?", "警告", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(function (res) {
          // 添加
          return exportClient(queryParams);
        })
        .then((res) => {
          console.log(res);
          //文件流转换成url
          const blob = new Blob([res.data], {
            type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
          });
          console.log(blob);
          //创建a链接自动跳转后自动删除
          const url = window.URL.createObjectURL(blob);
          console.log(url);
          const a = document.createElement("a");
          a.style.display = "none";
          a.href = url;
          a.target = "_blank";

          a.setAttribute("download", name);
          document.body.appendChild(a);
          a.click();
          document.body.removeChild(a);
          //  window.open(url, '_blank')
        })
        .catch((err) => {
          this.$message.error("文件下载失败！");
        });
    },
  },
};
</script>

<style scoped>
.title-container {
  width: 100%;
  height: 40px;
  line-height: 40px;
  background-color: #d6e4ff;
 color: #999;
  opacity: 0.8;
  font-weight: bold;
  font-size: 14px;
  margin-bottom: 24px;
}
.title-container-left {
  position: absolute;
  display: inline-block;
  left: 32px;
}

/* .center {
  width: 100%;
  box-sizing: border-box;
  padding: 24px 32px;
  border: 1px solid #ccc;
} */
.table {
  margin-top: 24px;
}
</style>

js文件

import request from "@/utils/request";

// 查询客户列表
export function listClient(query) {
  return request({
    url: '/posuser/userDealMapper/selectByTable?pageNum='+query.pageNum+'&pageSize='+query.pageSize,
    // url: "/posuser/userDealMapper/select",//
    method: "post",
    data: query,
  });
}

// 查询客户详细
export function getClient(customerNo) {
  return request({
    url: "/posuser/userDealMapper/select",
    method: "post",
    data: customerNo,
  });
}

// 新增客户
export function addClient(data) {
  return request({
   url: "/posuser/userDealMapper/insert",
    method: "post",
    data: data,
  });
}

// 修改客户
export function updateClient(data) {
  return request({
    url: "/posuser/userDealMapper/update",
    method: "post",
    data: data,
  });
}

// 删除客户
export function delClient(customerNo) {
  return request({
    // url: "/posuser/userDealMapper/delete?customerNo=" + customerNo,
     url: "/posuser/userDealMapper/delete",
    method: "post",
    data: customerNo
  });
}



// 导出 exportClient
export function exportClient(query) {
  return request({
    url: "/posuser/userDealMapper/export",
    method: "post",
    data: query,
    responseType: 'blob'
  });
}