vue2中使用el-table实现直接编辑表格,鼠标点击空白处实现保存并传递给后端的简单方法

一、实现表格编辑

1.首先我们需要用到highlight-current-row去初始定位高亮指定行,意思就是选中某个数据行时,高亮该行。

需求实现如下:点击某个单元格实现整行数据高亮,并且可以修改,修改完成后鼠标点击空白处,实现保存修改后的整行数据并传递给后端。

2.用vue的axios发起post请求:

3. 在el-input中@blur的意思是当元素失去焦点时所触发的事件,当不点击单元格时显示值,点击单元格时显示编辑框,用v-ifv-else来判断

<div class="divCaculateResultDisplay">
      <div class="divParamInput2">
        <label class="labConfidenceParamTitle">结果:</label>
      </div>
      <div class="divNotAllowCaculateResult">
        <div class="divResultTitle">
          <p class="pValueResult">导入数据</p>
        </div>
        <el-table 
        border 
        height="385" 
        :data="tableData" 
        class="tb-edit" 
        style="width: 100%" 
        highlight-current-row>
          <el-table-column fixed align="center" prop="createTime" label="创建时间" width="150">
          </el-table-column>
          <el-table-column prop="powerFactor" label="功率因素" width="" align="center">
            <template slot-scope="scope">
              <span v-if="!scope.row.setingFlag" @click="handleEdit(scope.row)">{{scope.row.powerFactor}}</span>
              <div v-else>
                <el-input v-model="scope.row.powerFactor" @blur="handleBlur(scope.row)"></el-input>
              </div>
            </template>
          </el-table-column>
          <!-- 此处省略 -->
          <el-table-column label="操作">
            <template slot-scope="scope">
              <!--<el-button @click="handleEdit(scope.$index, scope.row)">编辑</el-button>-->
              <el-button type="danger" @click="handleDelete(scope.$index, scope.row)">删除</el-button>
            </template>
          </el-table-column>
        </el-table>
        <el-pagination :current-page="page" :page-size="10" @current-change="CurrentChange" style="
            margin-top: 10px;
            display: flex;
            justify-content: center;
            align-items: center;
          " background layout="prev, pager, next" :total="total">
        </el-pagination>
      </div>
    </div>

4.引入接口

5.返回数组

6.方法使用

handleBlur(row) {
        row.setingFlag = false;
        const param={
          id:row.id,
          powerFactor:row.powerFactor,
          currentA:row.currentA,
          currentB:row.currentB,
          currentC:row.currentC,
          voltage:row.voltage,
          voltageA:row.voltageA,
          voltageB:row.voltageB,
          voltageC:row.voltageC,
          activePower:row.activePower,
          reactivePower:row.reactivePower,
          apparentPower:row.apparentPower,
          calculatedPowerFactor:row.calculatedPowerFactor,
          energyConsumption:row.energyConsumption
        }
        modify(param).then(res=>{
          if(res.code == 200){
            this.$message.success('修改数据成功!')
          }else{
            this.$message.error('获取数据失败!')
          }
        })
      },
      handleEdit(row) {
        this.$set(row, 'setingFlag', true)
      },

7.完整代码如下:

<template>
<div class="divCaculateResultDisplay">
      <div class="divParamInput2">
        <label class="labConfidenceParamTitle">结果:</label>
      </div>
      <div class="divNotAllowCaculateResult">
        <div class="divResultTitle">
          <p class="pValueResult">导入数据</p>
        </div>
        <el-table 
        border 
        height="385" 
        :data="tableData" 
        class="tb-edit" 
        style="width: 100%" 
        highlight-current-row>
          <el-table-column fixed align="center" prop="createTime" label="创建时间" width="150">
          </el-table-column>
          <el-table-column prop="powerFactor" label="功率因素" width="" align="center">
            <template slot-scope="scope">
              <span v-if="!scope.row.setingFlag" @click="handleEdit(scope.row)">{{scope.row.powerFactor}}</span>
              <div v-else>
                <el-input v-model="scope.row.powerFactor" @blur="handleBlur(scope.row)"></el-input>
              </div>
            </template>
          </el-table-column>
          <!-- 此处省略 -->
          <el-table-column label="操作">
            <template slot-scope="scope">
              <!--<el-button @click="handleEdit(scope.$index, scope.row)">编辑</el-button>-->
              <el-button type="danger" @click="handleDelete(scope.$index, scope.row)">删除</el-button>
            </template>
          </el-table-column>
        </el-table>
        <el-pagination :current-page="page" :page-size="10" @current-change="CurrentChange" style="
            margin-top: 10px;
            display: flex;
            justify-content: center;
            align-items: center;
          " background layout="prev, pager, next" :total="total">
        </el-pagination>
      </div>
    </div>
</template>
<script>
import {modify} from "@/api/request"
export default {
data() {
      return {
             page: 1,
             limit: 10,
             total:0,
             tableData: [],
        }
    }
methods: {
        handleBlur(row) {
        row.setingFlag = false;
        const param={
          id:row.id,
          powerFactor:row.powerFactor,
          currentA:row.currentA,
          currentB:row.currentB,
          currentC:row.currentC,
          voltage:row.voltage,
          voltageA:row.voltageA,
          voltageB:row.voltageB,
          voltageC:row.voltageC,
          activePower:row.activePower,
          reactivePower:row.reactivePower,
          apparentPower:row.apparentPower,
          calculatedPowerFactor:row.calculatedPowerFactor,
          energyConsumption:row.energyConsumption
        }
        modify(param).then(res=>{
          if(res.code == 200){
            this.$message.success('修改数据成功!')
          }else{
            this.$message.error('获取数据失败!')
          }
        })
      },
      handleEdit(row) {
        this.$set(row, 'setingFlag', true)
      },
    }
}
</script>

  • 2
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Chen__FY

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值