单、多选删除，以及删除子模块

父节点和子节点并同删除，直接在后台的service里拼sql

 
 @RemoteMethod
 public int deleteByParCode(String parCode){
  String sql = "DELETE FROM Organization WHERE organizationCode='" + parCode + "' OR parentCode='" + parCode + "'";
  return this.commonDao.execute(sql);
 }

 

@RemoteMethod
 public int deleteSelectedsByParCodes(String[] parCodes){
  String link = "";
  for(int i=0; i<parCodes.length-1; i++){
   link += "'" + parCodes[i] + "',";
  }
  link += "'" + parCodes[parCodes.length-1] + "'";
  
  String sql = "DELETE FROM Organization WHERE organizationCode in  (" + link + ") OR parentCode in (" + link + ")";
  return this.commonDao.execute(sql);
 }

 

不用：

//删除
   function deleteFun(rowId,parentCode) {
    if(confirm("删除该模块将同时删除其所有从属模块，确认要删除吗？")){
     //存放所有删除的Code
     var arrayId = new Array();
     arrayId.push(rowId);
      //设置dwr调用为同步
     dwr.engine.setAsync(false);
     OrganizationService.findMapByPropertiesQuick(['organizationCode'],"parentCode='" + rowId + "'",false,function(data){
      if(data){
       for(var i = 0; i < data.length; i++){
        arrayId.push(data[i].organizationCode);
       }
      }
     });
      //设置dwr调用为异步
     dwr.engine.setAsync(true);
       //alert(arrayId);
       //进行删除
       OrganizationService.deleteByIds(arrayId,function(data){
        if(data){
         alert("删除成功！");
         //刷新表格
         $("#moduleTable").trigger("reloadGrid");
         //刷新树
         zTreeObj.reAsyncChildNodes(_treeNode, "refresh");
        }else{
         alert("删除失败！");
        }
       });
     }
   }
   
   
   
   //多选删除
   function deleteSelectedsFun(){
    var selrow = getSelectedRowIDs();
    var arrayId = selrow;
    if(selrow != null && selrow.length > 0){
     if(confirm("删除这些模块将同时删除其所有从属模块，确认要删除吗？")) {
         
       //设置dwr调用为同步
      dwr.engine.setAsync(false);
      for(var i = 0; i < selrow.length; i++){
      
       OrganizationService.findMapByPropertiesQuick(['organizationCode'],"parentCode='" + selrow[i] + "'",false,function(data){
        if(data){
         for(var i = 0; i < data.length; i++){
          arrayId.push(data[i].organizationCode);
         }
        }
       });
      }
      //设置dwr调用为异步
      dwr.engine.setAsync(true);
      alert(arrayId);
     }
     
     //进行删除
     OrganizationService.deleteByIds(arrayId,function(data){
      if(data){
         alert("删除成功！");
         //刷新表格
         $("#moduleTable").trigger("reloadGrid");
         //刷新树
         zTreeObj.reAsyncChildNodes(_treeNode, "refresh");
         }else{
         alert("删除失败！");
         }
     });
    } else {
     alert("请选择数据");
    }
    return false;
   }
   function getSelectedRowIDs(){
    return jQuery('#moduleTable').getGridParam('selarrrow');//多选
   }
   function getSelectedRowID(){
     return jQuery('#moduleTable').getGridParam('selrow');//单选
   }