easyui treegrid 操作

最新推荐文章于 2022-11-03 09:13:16 发布
最新推荐文章于 2022-11-03 09:13:16 发布
阅读量748 收藏
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/bossszhou/article/details/81330379
版权

 项目需求变更，留着以备他用

前端界面

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>签核关卡设定</title>
<!--jquery-->
<script type="text/javascript"
	src="inc/plugins/jquery/1.9.1/jquery-1.9.1.js"></script>
<!--easyUI-->
<link rel="stylesheet" type="text/css"
	href="inc/plugins/jquery.easyui/1.5/themes/gray/easyui.css">
<link rel="stylesheet" type="text/css"
	href="inc/plugins/jquery.easyui/1.5/themes/icon.css">
<script type="text/javascript"
	src="inc/plugins/jquery.easyui/1.5/jquery.easyui.min.js"></script>
</head>
<script type="text/javascript">
$(document).ready(function(){
	$('#mingcheng').treegrid({
	    url:'gate/allGATEBASIC',
	    method:'get',
	    idField:'ID',
	    treeField:'GATENAME',
	    animate: true,
  		collapsible: true,
  		fitColumns: true,
  		singleSelect: true,
		 columns:[[
			{field:'GATENAME',title:'签核关卡',width:100,editor:'text'},
			//{field:'guanqia',title:'关卡',width:100},
			{field:'DEPT',title:'部门',width:100,editor:{
                type: 'combobox',
                options: {
                    url: "dept/alldept",
                    method: "get",
                    valueField: "DNAME",
                    textField: "DNAME",
                    editable: false
                }
        	}},
			{field:'WAY',title:'评核方式',width:100,editor:'text'},
			{field:'WEIGHT',title:'权重',width:100,editor:'text'},
			{field:'STARTDATE',title:'适用起始日期',width:100,editor:'datebox'},
			{field:'BELONGS',title:'分组标志'}
				
	    ]]
	});
	$("#mingcheng").treegrid('hideColumn','BELONGS');
	$('#quanzhong').treegrid({
		singleSelect:true,
	    url:'treegrid_data4.json',
	    method:'get',
	    idField:'ID',
	    treeField:'qianhe',
	    animate: true,
  		collapsible: true,
  		fitColumns: true,
  		//fit: true,
	    columns:[[
			{field:'qianhe',title:'签核关卡',width:100,editor:'text'},
			{field:'fangshi',title:'评核方式',width:100,editor:'text'},
			{field:'dept',title:'单位',width:100,editor:'text'},
			{field:'kebie',title:'课别',width:100,editor:'text'},
			//{field:'guanqia',title:'关卡',width:100},
			{field:'quanzhong',title:'权重',width:100,editor:'text'},
			{field:'startyear',title:'适用起始年份',width:100,editor:'text'},
			{field:'startmonth',title:'适用起始月份',width:100,editor:'text'}
	    ]]
	});
	/* $('#mingcheng').datagrid({
		singleSelect:true,
	    url:'datagrid_data1.json',
	    columns:[[
			{field:'niandu',title:'年度',width:100},
			{field:'yuefen',title:'月份',width:100},
			{field:'xiangmumingcheng',title:'绩效项目名称',width:100},
			{field:'dept',title:'部门别',width:100},
			{field:'quanzhong',title:'权重',width:100},
			{field:'efectdate',title:'生效日期',width:100},
			{field:'stop',title:'是否停用',width:100},
			{field:'beizhu',title:'备注',width:100}
	    ]]
	}); */
});

var mingcheng_editingId;
var mingcheng_operation;
var mingcheng_editingrows=[];
function mingcheng_append(){
	var appendleaveflag = false;
	//var amount;
	if(mingcheng_editingrows.length==0)
		$.messager.prompt('提示', '请输入关卡数量', function(amount){
			if (amount){
				if(!isNum(amount)){
					$.messager.alert('提示','请输入数字');
					//appendleaveflag = true;
				}else if(amount=="0"){
					$.messager.alert('提示','关卡数量不能为0');
				}else{
					mingcheng_operation = "add";
					 if (mingcheng_editingId != undefined){
						$('#mingcheng').treegrid('select', mingcheng_editingId);
						return;
					}
				   //var node = $('#mingcheng').treegrid('getSelected');
				   $.ajax({
					   url: "gate/getnextBELONGS",
					   success: function(data){
						   mingcheng_editingId = data.extend.nextbelongs;
						   mingcheng_editingrows.push(data.extend.nextbelongs);
						   $('#mingcheng').treegrid('append', {
							    data: [{
							    	ID: data.extend.nextbelongs,
							        GATENAME: "try",//treegrid id 
							        BELONGS: data.extend.nextbelongs
							    }]
							});
						   $('#mingcheng').treegrid("beginEdit",data.extend.nextbelongs);
						   for(var i=0;i<amount;i++){
							   var bottomid = i+1;
							   if(bottomid<10)
								   bottomid="0"+bottomid;
							   var obj_id = data.extend.nextbelongs+bottomid;
							   mingcheng_editingrows.push(obj_id);
							   $('#mingcheng').treegrid('append', {
								    parent: data.extend.nextbelongs,//treegrid 父id 必须指定
								    data: [{
								        ID: obj_id,//treegrid id 
								        GATENAME: "TRY",
								        _parentId: data.extend.nextbelongs,
								        BELONGS: data.extend.nextbelongs
								    }]
								});
						  		$('#mingcheng').treegrid("beginEdit",obj_id);
						   }
					   }
				   });
				}
			}
		});
}
function mingcheng_edit(){
	mingcheng_operation = "edit";
	if (mingcheng_editingId != undefined){
		$('#mingcheng').treegrid('select', mingcheng_editingId);
		return;
	}
	var row = $('#mingcheng').treegrid('getSelected');
	mingcheng_editingrows.push(row.ID);
	if (row){
		if(row._parentId!=null){
			$.messager.alert('提示','请选择根节点');
			return;
		}
		if(row.state=="closed"){
			$("#mingcheng").treegrid('expand',row.ID);
		}
		var allrows = $("#mingcheng").treegrid('getChildren',row.ID);
		$.each(allrows,function(i,item){
				mingcheng_editingrows.push(item.ID);
		});
		$.each(mingcheng_editingrows,function(i,item){
			$("#mingcheng").treegrid('beginEdit',item);
		});
	}
}
function mingcheng_save(){
	if(mingcheng_operation=="add"){
		var addleaveflag=false;
		var children;
		if(mingcheng_editingrows.length!=0){
			var json={};
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('endEdit',item);
			});
			//选出子节点children
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('selectRow',item);
				var row = $("#mingcheng").treegrid('getSelected');
				if(row._parentId==undefined){
					children = $("#mingcheng").treegrid('getChildren',row.ID);
				}
				$("#mingcheng").treegrid('unselect',item);
			});
			//格式检验
			for(var i=0;i<children.length;i++){
				for(var j=i+1;j<children.length;j++){
					if(children[i].GATENAME==children[j].GATENAME){
						$.messager.alert('提示','同一项目下不能有相同的名称');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						addleaveflag=true;
						break;
					}else if(children[i].WAY==children[j].WAY){
						$.messager.alert('提示','同一项目下不能有相同的评核方式');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						addleaveflag=true;
						break;
					}
				}
				if(addleaveflag==true)
					break;
			}
			if(addleaveflag==true)
				return;
			addleaveflag=false;
			var addweightsum=0;
			$.each(children,function(i,item){
				addweightsum+=parseInt(item.WEIGHT);
				if(item.GATENAME==""||item.WAY==""||item.WEIGHT==""){
					$.messager.alert('提示','关卡的名称、评核方式和权重不能为空');
					$.each(mingcheng_editingrows,function(i,item){
						$("#mingcheng").treegrid('beginEdit',item);
					});
					addleaveflag=true;
					return;
				}
			});
			if(addleaveflag==true)
				return;
			addleaveflag=false;
			if(addweightsum!=100){
				$.messager.alert('提示','各关卡权重之和应为100');
				$.each(mingcheng_editingrows,function(i,item){
					$("#mingcheng").treegrid('beginEdit',item);
				});
				return;
			}
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('selectRow',item);
				var row = $("#mingcheng").treegrid('getSelected');
				if(row._parentId==undefined){
					if(row.GATENAME==""||row.STARTDATE==""){
						$.messager.alert('提示','根节点的名称和适用起始日期不能为空');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						addleaveflag=true;
						return;
					}
					json = JSON.stringify(row);
				}
				$("#mingcheng").treegrid('unselect',item);
			});
			if(addleaveflag==true)
				return;
			addleaveflag=false;
			$.ajax({
				async: false,
				url: "gate/saveGATEBASIC",
				type: 'post',
				data: json,
				dataType: "json",
				contentType:"application/json;charsetset=UTF-8",
				success: function(data){
					if(data.extend.msg=="savesuccess")
						$.messager.alert('提示','保存成功');
					else if(data.extend.msg=="existedGATENAME"){
						$.messager.alert('提示','已存在此名称');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
					}
					else if(data.extend.msg=="savefailed")
						$.messager.alert('提示','保存失败');
				}
			});
		}
	}
	else if(mingcheng_operation=="edit"){
		var editleaveflag;
		var children;
		if(mingcheng_editingrows.length!=0){
			var json={};
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('endEdit',item);
			});
			//选出子节点children
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('selectRow',item);
				var row = $("#mingcheng").treegrid('getSelected');
				if(row._parentId==undefined){
					children = $("#mingcheng").treegrid('getChildren',row.ID);
				}
				$("#mingcheng").treegrid('unselect',item);
			});
			//格式检验
			for(var i=0;i<children.length;i++){
				for(var j=i+1;j<children.length;j++){
					if(children[i].GATENAME==children[j].GATENAME){
						$.messager.alert('提示','同一项目下不能有相同的名称');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						editleaveflag=true;
						break;
					}else if(children[i].WAY==children[j].WAY){
						$.messager.alert('提示','同一项目下不能有相同的评核方式');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						editleaveflag=true;
						break;
					}
				}
				if(editleaveflag==true)
					break;
			}
			if(editleaveflag==true)
				return;
			editleaveflag=false;
			var addweightsum=0;
			$.each(children,function(i,item){
				addweightsum+=parseInt(item.WEIGHT);
				if(item.GATENAME==""||item.WAY==""||item.WEIGHT==""){
					$.messager.alert('提示','关卡的名称、评核方式和权重不能为空');
					$.each(mingcheng_editingrows,function(i,item){
						$("#mingcheng").treegrid('beginEdit',item);
					});
					editleaveflag=true;
					return;
				}
			});
			if(editleaveflag==true)
				return;
			editleaveflag=false;
			if(addweightsum!=100){
				$.messager.alert('提示','各关卡权重之和应为100');
				$.each(mingcheng_editingrows,function(i,item){
					$("#mingcheng").treegrid('beginEdit',item);
				});
				return;
			}
			$.each(mingcheng_editingrows,function(i,item){
				$("#mingcheng").treegrid('selectRow',item);
				var row = $("#mingcheng").treegrid('getSelected');
				if(row._parentId==undefined){
					if(row.GATENAME==""||row.STARTDATE==""){
						$.messager.alert('提示','根节点的名称和适用起始日期不能为空');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
						editleaveflag=true;
						return;
					}
					json = JSON.stringify(row);
				}
				$("#mingcheng").treegrid('unselect',item);
			});
			if(editleaveflag==true)
				return;
			editleaveflag=false;
			$.ajax({
				async: false,
				url: "gate/updateGATEBASIC",
				type: 'post',
				data: json,
				dataType: "json",
				contentType:"application/json;charsetset=UTF-8",
				success: function(data){
					if(data.extend.msg=="updatesuccess")
						$.messager.alert('提示','修改成功');
					else if(data.extend.msg=="existedGATENAME"){
						$.messager.alert('提示','已存在此名称');
						$.each(mingcheng_editingrows,function(i,item){
							$("#mingcheng").treegrid('beginEdit',item);
						});
					}
					else if(data.extend.msg=="updatefailed")
						$.messager.alert('提示','保存失败');
				}
			});
		}
	}
}

function mingcheng_delete(){
		var row = $('#mingcheng').treegrid('getSelected');
		mingcheng_editingrows.push(row.ID);
		if (row){
			if(row._parentId!=null){
				$.messager.alert('提示','请选择根节点');
				return;
			}else{
				$.messager.confirm('提示','此操作将会删除该项目下的子项目，确定吗',function(r){
					if(r){
						$.ajax({
							url: "gate/deleteGATEBASIC",
							data:{"BELONGS":row.ID},
							success: function(data){
								$("#mingcheng").treegrid('reload');
								$.messager.alert('提示','删除成功');
							},
							error: function(data){
								$.messager.alert('提示','删除失败');
							}
						});
					}
				});
				
			}
		}
}

function mingcheng_cancel(){
	/* if (mingcheng_editingId != undefined){
		$('#mingcheng').treegrid('cancelEdit', mingcheng_editingId);
		mingcheng_editingId = undefined;
	} */
	if(mingcheng_operation=="edit"){
		$.each(mingcheng_editingrows,function(i,item){
			$('#mingcheng').treegrid('cancelEdit', item);
			$('#mingcheng').treegrid('unselect', item);
		});
		mingcheng_editingId = undefined;
		mingcheng_editingrows = [];
	}
	else if(mingcheng_operation=="add"){
		$.messager.confirm('提示', '此操作将会删除所有未保存的数据，确定吗', function(r){
			if (r){
				$("#mingcheng").treegrid('reload');
				mingcheng_editingrows = [];
				mingcheng_editingId = undefined;
			}
		});
	}
}

var quanzhong_editingId;
function quanzhong_append(){
	$('#win').window({
		title:"请选择签核关卡",
	    width:300,
	    height:150,
	    modal:true
	});
}
function quanzhong_edit(){
	if (quanzhong_editingId != undefined){
		$('#quanzhong').treegrid('select', quanzhong_editingId);
		return;
	}
	var row = $('#quanzhong').treegrid('getSelected');
	if (row){
		quanzhong_editingId = row.ID;
		$('#quanzhong').treegrid('beginEdit', quanzhong_editingId);
	}
}
function quanzhong_save(){
	if (quanzhong_editingId != undefined){
		var t = $('#quanzhong');
		t.treegrid('endEdit', quanzhong_editingId);
		quanzhong_editingId = undefined;
		/* var persons = 0;
		var rows = t.treegrid('getChildren');
		for(var i=0; i<rows.length; i++){
			var p = parseInt(rows[i].persons);
			if (!isNaN(p)){
				persons += p;
			}
		}
		var frow = t.treegrid('getFooterRows')[0];
		frow.persons = persons;
		t.treegrid('reloadFooter'); */
	}
}
function quanzhong_cancel(){
	if (quanzhong_editingId != undefined){
		$('#quanzhong').treegrid('cancelEdit', quanzhong_editingId);
		quanzhong_editingId = undefined;
	}
}

function isNum(val){
    // isNaN()函数 把空串 空格 以及NUll 按照0来处理 所以先去除
    if(val === "" || val ==null){
        return false;
    }
    if(!isNaN(val)){
        return true;
    }else{
        return false;
    }
}

function win_confirm(){
	$.ajax({
		url: "gate/getGATEBASICByBELONGS",
		data: {"BELONGS":$("#GATE").combobox('getValue')},
		success: function(data){
			$("#win").window('close');
			console.log(data);
			$.messager.alert('提示','success');
		},
		error: function(data){
			$.messager.alert('提示','取出关卡数据出错');
		}
	});
}
function win_cancel(){
	$("#win").window('close');
}
//扩展datagrid:动态添加删除editor
$.extend($.fn.datagrid.methods, {
    addEditor : function(jq, param) {
        if (param instanceof Array) {
            $.each(param, function(index, item) {
                var e = $(jq).datagrid('getColumnOption', item.field); 
                e.editor = item.editor; }); 
            } else {
                var e = $(jq).datagrid('getColumnOption', param.field);    
                e.editor = param.editor;    
            }   
        },  
    removeEditor : function(jq, param) {    
        if (param instanceof Array) {   
            $.each(param, function(index, item) {  
                var e = $(jq).datagrid('getColumnOption', item);   
                e.editor = {};  
                });
        } else {
            var e = $(jq).datagrid('getColumnOption', param);
            e.editor = {}; 
        }
    }
});
</script>
<body>
<div class="easyui-tabs" style="width:100%;height:auto;">
	<div title="签核关卡设定" style="padding:10px;">
		<div style="margin:20px 0;">
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="mingcheng_append()">添加</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true" onclick="mingcheng_edit()">编辑</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-save',plain:true" onclick="mingcheng_save()">保存</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-remove',plain:true" onclick="mingcheng_delete()">删除</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-cancel',plain:true" onclick="mingcheng_cancel()">取消</a>
		</div>
		<table id="mingcheng"></table>
	</div>
	<div title="特殊关卡设定" style="padding:10px;">
		<div style="margin:20px 0;">
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="quanzhong_append()">添加</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true" onclick="quanzhong_edit()">编辑</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-save',plain:true" onclick="quanzhong_save()">保存</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-cancel',plain:true" onclick="quanzhong_cancel()">取消</a>
		</div>
		<table id="quanzhong"></table>
	</div>
	<!-- <div title="部門別設定" style="padding:10px;">
		<table id="dept"></table>
	</div> -->
</div>
<div id="win" style="display:none">
	<div style="width:80%">
		<div style="padding-top:10px">
			<input class="easyui-combobox" 
				id="GATE"
				data-options="
						url:'gate/IDandGATENAME',
						method:'get',
						valueField:'ID',
						textField:'GATENAME',
						width:'100%',
						panelHeight:'auto'
				">
		</div>
		<div style="padding-top:10px;text-align:right">
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="win_confirm()">确定</a>
			<a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="win_cancel()">取消</a>
		</div>
	</div>
</div>
</body>
</html>

controller

package com.chenyuantech.kpi.controller;

import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;

import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.chenyuantech.kpi.bean.GATEBASIC;
import com.chenyuantech.kpi.bean.Msg;
import com.chenyuantech.kpi.service.DEPTService;
import com.chenyuantech.kpi.service.GATEBASICService;

@Controller
@RequestMapping(value="gate")
public class GATEController {
	
	@Autowired
	private GATEBASICService GBService;
	@Autowired
	private DEPTService DService;

	SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
	
	@RequestMapping(value="/IDandGATENAME")
	@ResponseBody
	public List<HashMap<String, Object>> getIDAndGATENAME(){
		
		return GBService.getIDAndGATENAME();
	}
	
	@RequestMapping(value="/getGATEBASICByBELONGS")
	@ResponseBody
	public List<HashMap<String, Object>> getGATEBASICByBELONGS(String BELONGS){
		
		return GBService.getGATEBASICByBELONGS(BELONGS);
	}
	
	@RequestMapping(value="/allGATEBASIC")
	@ResponseBody
	public JSONObject getAllGATEBASIC(){
		List<HashMap<String, Object>> records = GBService.getAllGATEBASIC();
		for(int i=0;i<records.size();i++){
			if(records.get(i).get("ROOTID")==null)
				records.get(i).put("state", "closed");
			else {
				records.get(i).put("state", "open");
			}
			records.get(i).put("_parentId", records.get(i).get("ROOTID"));
		}
		JSONObject json = new JSONObject();
		json.put("total", records.size());
		json.put("rows", records);
		return json;
	}
	
	@RequestMapping(value="/getnextBELONGS")
	@ResponseBody
	public Msg getnextBELONGS(){
		String temp = "";
		String nextbelongs = GBService.getnexBELONGS();
		if(nextbelongs==null){
			nextbelongs = "001";
			return Msg.success().add("nextbelongs", nextbelongs);
		}
		else{
			int IntNUM = Integer.parseInt(nextbelongs);
			IntNUM+=1;
			if(IntNUM>0 && IntNUM<10)
				temp="00"+String.valueOf(IntNUM);
			else if(IntNUM>=10 && IntNUM<100)
				temp="0"+String.valueOf(IntNUM);
			else if(IntNUM>=100)
				temp=String.valueOf(IntNUM);
			return Msg.success().add("nextbelongs", temp);
		}
	}
	
	@RequestMapping(value="/saveGATEBASIC",method=RequestMethod.POST)
	@ResponseBody
	public Msg saveGATEBASIC(@RequestBody JSONObject records,HttpSession session){
		List<String> GATENAMEs = GBService.getAllGATENAME();
		if(GATENAMEs.contains(records.getString("GATENAME"))){
			return Msg.success().add("msg", "existedGATENAME");
		}
		JSONArray children = records.getJSONArray("children");
		GATEBASIC gate = new GATEBASIC();
		try {
			gate.setID(records.getString("ID"));
			gate.setGATENAME(records.getString("GATENAME"));
			gate.setDEPT(DService.getDEPTIDByDNAME(records.getString("DEPT")));
			gate.setSTARTDATE(records.getString("STARTDATE"));
			gate.setBELONGS(records.getString("BELONGS"));
			gate.setCREATEMAN((String)session.getAttribute("userid"));
			gate.setCREATEDATE(sdf.format(new Date()));
			gate.setAMOUNT(new BigDecimal(children.size()));
			GBService.saveGATEBASIC(gate);
			for (int i = 0; i <children.size(); i++) {
				GATEBASIC child = new GATEBASIC();
				JSONObject json = (JSONObject) children.get(i);
				child.setID(json.getString("ID"));
				child.setGATENAME(json.getString("GATENAME"));
				child.setWAY(json.getString("WAY"));
				child.setWEIGHT(json.getShort("WEIGHT"));
				child.setROOTID(json.getString("_parentId"));
				child.setBELONGS(json.getString("BELONGS"));
				GBService.saveGATEBASIC(child);
			}
		} catch (Exception e) {
			e.printStackTrace();
			return Msg.success().add("msg", "savefailed");
		}
		
		return Msg.success().add("msg", "savesuccess");
		//return GBService.saveGATEBASIC(record);
	}
	
	@RequestMapping(value="/updateGATEBASIC",method=RequestMethod.POST)
	@ResponseBody
	public Msg updateGATEBASIC(@RequestBody JSONObject records,HttpSession session){
		JSONArray children = records.getJSONArray("children");
		GATEBASIC gate = new GATEBASIC();
		try {
			gate.setID(records.getString("ID"));
			gate.setGATENAME(records.getString("GATENAME"));
			gate.setDEPT(DService.getDEPTIDByDNAME(records.getString("DEPT")));
			gate.setSTARTDATE(records.getString("STARTDATE"));
			gate.setBELONGS(records.getString("BELONGS"));
			gate.setALTERMAN((String)session.getAttribute("userid"));
			gate.setALTERDATE(sdf.format(new Date()));
			GBService.updateGATEBASIC(gate);
			for (int i = 0; i <children.size(); i++) {
				GATEBASIC child = new GATEBASIC();
				JSONObject json = (JSONObject) children.get(i);
				child.setID(json.getString("ID"));
				child.setGATENAME(json.getString("GATENAME"));
				child.setWAY(json.getString("WAY"));
				child.setWEIGHT(json.getShort("WEIGHT"));
				child.setROOTID(json.getString("_parentId"));
				child.setBELONGS(json.getString("BELONGS"));
				GBService.updateGATEBASIC(child);
			}
		} catch (Exception e) {
			e.printStackTrace();
			return Msg.success().add("msg", "updatefailed");
		}
		
		return Msg.success().add("msg", "updatesuccess");
		//return GBService.saveGATEBASIC(record);
	}
	
	@RequestMapping(value="/deleteGATEBASIC")
	@ResponseBody
	public Integer deleteGATEBASIC(String BELONGS){
		
		return GBService.deleteGATEBASIC(BELONGS);
	}
	
}

service

package com.chenyuantech.kpi.service;

import java.util.HashMap;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.chenyuantech.kpi.bean.GATEBASIC;
import com.chenyuantech.kpi.dao.GATEBASICExtMapper;
import com.chenyuantech.kpi.dao.GATEBASICMapper;

@Service
public class GATEBASICService {
	
	@Autowired
	private GATEBASICExtMapper GBEMapper;
	@Autowired
	private GATEBASICMapper GBMapper;
	
	public String getnexBELONGS(){
		return GBEMapper.selectnextBELONGS();
	}
	
	public int saveGATEBASIC(GATEBASIC record){
		return GBMapper.insertSelective(record);
	}
	
	public int updateGATEBASIC(GATEBASIC record){
		return GBMapper.updateByPrimaryKey(record);
	}
	
	public List<HashMap<String, Object>> getAllGATEBASIC(){
		return GBEMapper.selectAllGATEBASIC();
	}
	
	public List<String> getAllGATENAME(){
		return GBEMapper.selectAllGATENAME();
	}
	
	public Integer deleteGATEBASIC(String BELONGS){
		return GBEMapper.deleteGATEBASICByBELONGS(BELONGS);
	}
	
	public List<HashMap<String, Object>> getIDAndGATENAME(){
		return GBEMapper.selectIDAndGATENAME();
	}
	
	public List<HashMap<String, Object>> getGATEBASICByBELONGS(String BELONGS){
		List<HashMap<String, Object>> records = GBEMapper.selectGATEBASICByBELONGS(BELONGS);
		for(int i=0;i<records.size();i++){
			records.get(i).put("_parentId", records.get(i).get("ROOTID"));
		}
		return records;
	}
}

mapper

package com.chenyuantech.kpi.dao;

import java.util.HashMap;
import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface GATEBASICExtMapper {

	@Select("SELECT BELONGS FROM (SELECT DISTINCT BELONGS FROM KPI_GATEBASIC ORDER BY BELONGS DESC)"
			+ "WHERE ROWNUM=1")
	String selectnextBELONGS();
	
	@Select("SELECT G.ID,G.GATENAME,G.WAY,G.WEIGHT,G.STARTDATE,G.ROOTID,D.DNAME DEPT "
			+ " FROM KPI_GATEBASIC G LEFT JOIN KPI_DEPT D ON G.DEPT=D.DEPTID ORDER BY ID")
	List<HashMap<String, Object>> selectAllGATEBASIC();
	
	@Select("SELECT GATENAME FROM KPI_GATEBASIC WHERE ROOTID IS NULL")
	List<String> selectAllGATENAME();
	
	@Select("DELETE FROM KPI_GATEBASIC WHERE BELONGS=#{BELONGS}")
	Integer deleteGATEBASICByBELONGS(@Param("BELONGS")String BELONGS);
	
	@Select("SELECT ID,GATENAME FROM KPI_GATEBASIC WHERE ROOTID IS NULL")
	List<HashMap<String, Object>> selectIDAndGATENAME();
	
	@Select("SELECT G.ID,G.GATENAME,D.DNAME DEPT,G.WAY,G.WEIGHT,G.STARTDATE,G.ROOTID "
			+ " FROM KPI_GATEBASIC G LEFT JOIN KPI_DEPT D "
			+ " ON G.DEPT=D.DEPTID WHERE G.BELONGS=#{BELONGS}")
	List<HashMap<String, Object>> selectGATEBASICByBELONGS(String BELONGS);
	
}

 

bossszhou
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
[Easyui Treegrid ]单行选中编辑
ytangdigl的博客
05-15 3259
1、Easyui Treegrid 单行选中编辑，只能选中叶子节点。 单击另外一个叶子节点，另外一个叶子节点选中，并进行编辑状态，上个正在编辑的节点退出编辑状态，并且不选中。并且只能选中叶子节点。 2、如何设置TreeGrid默认选中根节点
Easyui Treegrid改变默认图标的方法
09-02
除了基本的图标替换，内容中还提及了jQuery EasyUI Treegrid的增删改查操作。这部分代码展示了如何实现数据的动态管理： - `deleteRow`函数用于删除选中的行，通过`treegrid('remove')`方法执行删除操作，并重新...
EasyUI TreeGrid滚动条异常
liuganhaha的博客
11-03 362
当使用treeGrid并且只需要显示一列数据的时候，不论Treegrid是HTML里标记的，还是js初始化的，都不要使用冻结列，不然就可能出现滚动条异常的情况。
easyui treegrid的使用示例
09-22 202
一、前端： 1 <div id="tbList" fit="true"></div> 2 3 $(function () { 4 $("#tbList").treegrid({ 5 url: "/Action/MenuIndex/", 6 method: 'post', 7 ...
easyui treegrid 大坑！！
q1273577278的博客
09-20 283
easyui treegrid 踩坑记录
easyui treegrid实现的两种方式
a316883923的博客
07-09 5125
感觉easyui官方的treegrid文档不是很清晰，当时使用的时候查了许多资料才做出来，现在总结一下两种实现方式的思路： 两种方式前台都一样： $('#tree').treegrid({ url:"", //idField指定的是对象的code（为唯一值）非父code idField:'code', rownumbers:true, //指定文件夹图...
easyui treegrid php,jQuery中关于EasyUI的TreeGrid查询功能的实现
weixin_34672536的博客
03-12 172
这篇文章主要介绍了jQuery EasyUI的TreeGrid查询功能实现方法,需要的朋友可以参考下最近需要实现对treeGrid的查询功能，具体查询界面如下：可以查询根节点和具体子节点的信息，开始使用EasyUI的TreeGrid的loadData 加载url的方式不能实现查询功能，于是利用异步AJAX查询了一下数据返回后，赋值给变量，然后利用TreeGrid的loadData加载这个json格...
easyui treegrid php,JQuery EasyUI TreeGrid控件的使用
weixin_36215903的博客
03-12 204
最近在做一些前端的工作，很多用户要求的复杂前端可以使用jq easyui实现，开源且功能强大，相信很多人早就尝到甜头了。下面进入正题，本篇博文主要介绍treegrid控件。官网DEMO有很多，可以借鉴。想看拖拽相关介绍的直接跳到第三步……treegrid效果图：第一步：数据看到这样的前端控件，我最先关心的是数据是如何存储的。这里以json为例，贴一个来自官网的样例json文件：[{"id":1,"...
easyui treegrid php,Easyui Treegrid改变默认图标的方法
weixin_36076701的博客
03-12 204
普通情况下，treegrid的图标是默认的文件夹与文件的形式，如下图：我们可以在json文本中加入iconCls来改变默认图标，例如样例中：{"total":7,"rows":[{"id":1,"name":"All Tasks","begin":"3/4/2010","end":"3/20/2010","progress":60,"iconCls":"icon-ok"},{"id":2,"nam...
EasyUI Treegrid 树形网格（官网没有提到的实现方式）
NJR10byh的博客
10-10 365
EasyUI Treegrid 树形网格（官网没有提到的实现方式）
jQuery Easyui Treegrid实现显示checkbox功能
10-19
jQuery Easyui Treegrid 是一个强大的数据展示组件，它结合了树形结构和表格的优点，常用于管理层次结构的数据。在实际应用中，我们经常需要添加复选框（checkbox）功能，以便用户可以多选操作。本文将详细介绍如何...
解决 easyui treegrid 批量展开和关闭卡顿问题。
05-09
当TreeGrid数据量过大的时候 使用 $('#tg').treegrid('collapseAll'); 和 $('#tg').treegrid('expandAll');会造成严重卡顿， 解决方案： 数据增加属性 state：closed， 即可默认收起，反之展开，需再展开时，将加载...
jQuery EasyUI的TreeGrid查询功能实现方法
10-19
主要介绍了jQuery EasyUI的TreeGrid查询功能实现方法,需要的朋友可以参考下
数理方法习题 前六章.pdf
08-03
数理方法习题 前六章
某大型制造企业IT蓝图规划及实施路线.pptx
08-03
某大型制造企业IT蓝图规划及实施路线.pptx
基于Springboot和Vue的社区团购系统设计源码 社区团购系统设计代码（98分期末优秀大作业）
08-03
社区团购系统设计源码（高分毕设），个人经导师指导并认可通过的98分毕业设计项目，主要针对计算机相关专业的正在做毕设的学生和需要项目实战练习的学习者。也可作为课程设计、期末大作业。包含全部项目源码[代码]、该项目可以直接作为毕设使用。项目技术栈：前端是vue，后端是springboot，项目代码都经过严格调试，代码没有任何bug！ 系统源码（高分毕设），个人经导师指导并认可通过的98分毕业设计项目，主要针对计算机相关专业的正在做毕设的学生和需要项目实战练习的学习者。也可作为课程设计、期末大作业。包含全部项目源码[代码]、该项目可以直接作为毕设使用。项目技术栈：前端是vue，后端是springboot，项目代码都经过严格调试，代码没有任何bug！ 系统源码（高分毕设），个人经导师指导并认可通过的98分毕业设计项目，主要针对计算机相关专业的正在做毕设的学生和需要项目实战练习的学习者。也可作为课程设计、期末大作业。包含全部项目源码[代码]、该项目可以直接作为毕设使用。项目技术栈：前端是vue，后端是springboot，项目代码都经过严格调试，代码没有任何bug！
去哪儿旅游&小红书-旅行行业：2023五一旅行趋势报告—想出去玩.pdf
最新发布
08-03
去哪儿旅游&小红书-旅行行业：2023五一旅行趋势报告—想出去玩
基于matlab设计的火焰检测定位.zip
08-03
在MATLAB中，可以使用多种方法进行车牌、人脸、车道线、表盘检测、行人识别和行为识别。以下是一些常见的方法： 1. 车牌检测：可以使用基于图像处理和机器学习的方法来检测车牌。常见的方法包括颜色过滤、形态学操作、边缘检测和字符分割等。 2. 人脸检测：可以使用基于特征提取和分类的方法来检测人脸。常见的方法包括Haar级联分类器、人工神经网络和深度学习方法等。 3. 车道线检测：可以使用基于边缘检测和曲线拟合的方法来检测车道线。常见的方法包括Canny边缘检测和霍夫变换等。 4. 表盘检测：可以使用基于特征提取和机器学习的方法来检测表盘。常见的方法包括颜色过滤、形态学操作、边缘检测和特征匹配等。 5. 行人识别：可以使用基于特征提取和分类的方法来识别行人。常见的方法包括HOG特征提取、SIFT特征提取和深度学习方法等。 6. 行为识别：可以使用基于特征提取和分类的方法来识别行为。常见的方法包括间接算法、基于模型的方法和深度学习方法等。 以上只是一些常见的方法，具体的实现还需要根据具体的问题和数据来选择合适的方法。MATLAB提供了丰富的图像处理和机器学习工具，可以方便地实现这些功能。
easyui treegrid 懒加载
05-12
easyui treegrid懒加载是一种用于提高网页性能的技术。与通常的加载方式不同，easyui treegrid 懒加载只在用户请求时才加载数据，而不是一次性加载所有数据。这个方法对于处理大量数据的应用程序特别有用。 实现...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值