编辑单元格

编辑单元格

开发工具与关键技术：Visual Studio + MVC + SQL Server + .Net
作者：琉敏
撰写时间：2019年1月26日

下面跟大家分享个编辑单元格的写法：
1、下面大家看到的就是一个要编辑的单元格；

2、只要在上面的单元格内输入想要的内容，然后保存就好了，经典代码如下：
（1）表格数据：

<div class="row examineeIfor" style="border:1px solid #eee;">
   <form class="form-horizontal" role="form" id="form" action="" method="post">
       <table id="tabNurse" style="width:100%">
           <tr>
               <th w_index="NursePaiBanID" w_check="true"></th>
               <th w_num="total_line">序号</th>
               <th w_index="nurseID" w_hidden="true"></th>
               <th w_index="UserID" w_hidden="true"></th>
               <th w_index="PaiBanClassesID" w_hidden="true"></th>
               <th w_edit="text" w_index="nurse">护士</th>
               <th w_edit="text" w_index="monday">星期一</th>
               <th w_edit="text" w_index="Tuesday">星期二</th>
               <th w_edit="text" w_index="Wednesday">星期三</th>
               <th w_edit="text" w_index="Thursday">星期四</th>
               <th w_edit="text" w_index="Friday">星期五</th>
               <th w_edit="text" w_index="Saturday">星期六</th>
               <th w_edit="text" w_index="Sunday">星期日</th>
               <th w_edit="text" w_index="StartTime">开始日期</th>
               <th w_edit="text" w_index="FinishTime">结束日期</th>
           </tr>
       </table>
   </form>            
</div>      

（2）编辑单元格点击事件：

$(function () {
    tabNurse = $.fn.bsgrid.init('tabNurse', {
        //编辑单元格
        extend: {
            settings: {
                supportGridEdit: true, 
                supportGridEditTriggerEvent: 'rowClick' 
            }
        }
    })        
 });

（3）编辑好单元格保存：

$("#save").click(function () {
    var returnA = 0;
      var OldRecords = tabNurse.getChangedRowsOldRecords();
      $.each(tabNurse.getRowsChangedColumnsValue(), function (key, object) {
          returnA++;
          $("#nurse").val(OldRecords[returnA - 1].nurse);               
          $("#PaiBanClassesID").val(OldRecords[returnA - 1].PaiBanClassesID);
          $("#monday").val(OldRecords[returnA - 1].monday);
          $("#Tuesday").val(OldRecords[returnA - 1].Tuesday);
          $("#Wednesday").val(OldRecords[returnA - 1].Wednesday);
          $("#Thursday").val(OldRecords[returnA - 1].Thursday);
          $("#Friday").val(OldRecords[returnA - 1].Friday);
          $("#Saturday").val(OldRecords[returnA - 1].Saturday);
          $("#Sunday").val(OldRecords[returnA - 1].Sunday);
          $("#StartTime").val(OldRecords[returnA - 1].StartTime);
          $("#FinishTime").val(OldRecords[returnA - 1].FinishTime);

          var rowIndex = key.split("_");//row_7   [0]:row,[1]:7
          var NursePaiBanID = tabNurse.getColumnValue(rowIndex[1], "NursePaiBanID");
          $("#NursePaiBanID").val(NursePaiBanID);
          $.each(object, function (ckey, cvalue) {
              var idName = "#" + ckey;
              $(idName).val(cvalue);
          });
          var layerIndex = layer.load(0);//显示 加载层
          $.ajaxSettings.async = false;
          $("#formNurse").ajaxSubmit(function (msg) {
              if (msg == "success") {
                  layer.close(layerIndex);
                  layer.alert("修改成功", { icon: 1, title: '提示' });
              }
          });
      })
  });