今天郁闷啊,easyui下的treegrid各种问题,各种促发不到事件,各种后台转换json,写这篇文章就是记录下来,以后好提醒自己。
第一步:js页面代码和官方的给代码一样如下:
<table title="Products" class="easyui-treegrid"
data-options="
url: '${path}/plat/view.do',
rownumbers: true,
fit:'true',
pagination: true,
idField: 'id',
treeField: 'nameCn',
onBeforeLoad: function(row,param){
console.log(row);
if (!row) { // load top level rows
param.id = 1; // set id=0, indicate to load new page rows
}
}
">
<thead>
<tr>
<th field="nameCn" width="250">分类名称(中)</th>
<th field="nameEn" width="250" >分类名称(英)</th>
<th field="skillName" width="150" >技能</th>
<th field="STATUS" width="150" formatter="formatDollar">装态</th>
<th field="sort" width="150" >排序</th>
</tr>
</thead>
</table>
<script>
function formatDollar(value){
if (value == 101001){
return '可用';
} else {
return '不可用';
}
}
</script>
在这里要说明的是param.id = 1;是初始化的时候未传入id,所以给个默认值(根目录父类编号),好查询出更目录,一般是0。我的数据库设计比较特殊,所以是1,有的说要促发事件,追加节点,我想说的是完全没必要。
第二步:写controller代码,默认post提交,传入参数有id:父类编号,page:当前页,row:分页条数。代码如下:
package com.zerdoor.controller;
import com.google.gson.Gson;
import com.google.gson.JsonObject;
import com.zerdoor.model.TaskType;
import com.zerdoor.pagehelper.PageHelper;
import com.zerdoor.pagehelper.PageInfo;
import com.zerdoor.service.PlatSetService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* Project: acgplat
* Module ID: 011
* Comments: 平台设置管理
* JDK version used: JDK1.7
* Namespace: controller
* Author:xiaobo
* Create Date:2014-11-24
* Modified By: <修改人中文名或拼音缩写>
* Modified Date: <修改日期,格式:YYYY-MM-DD>
* Why & What is modified <修改原因描述>
* Version: <版本号>
*/
@Controller
@RequestMapping("plat")
public class PlatController {
@Autowired
private PlatSetService platSetService;
@RequestMapping(value = "/index",method = RequestMethod.GET)
public String index(){return "/setting/view";}
/**
* 查询树形列表(任务分类)
* @param id 任务父类编号
* @param request
* @param page 当前页
* @param rows 页大小
* @return
*/
@RequestMapping(value = "view", method = RequestMethod.POST)
@ResponseBody
public String view(int id,HttpServletRequest request,int page,int rows){
Map<String,Object> map = new HashMap<String,Object>();
map.put("id",id);
//第一次访问时id=1,分页时id=1
if(id == 1){
PageHelper.startPage(page, rows);
List<Map<String, Object>> list = platSetService.getTaskTypeInfo(map);
PageInfo pageInfo = new PageInfo(list);
Gson gson = new Gson();
Map<String,Object> obj = new HashMap<String, Object>();
obj.put("rows", getJson(list));
obj.put("total", pageInfo.getTotal());
String result = gson.toJson(obj);
return result;
}else{
//id!=1时添加子节点
List<Map<String, Object>> list = platSetService.getTaskTypeInfo(map);
Gson gson = new Gson();
return gson.toJson(list);
}
}
/**
* 初始化list列表
* @param list
* @return
*/
public List<TaskType> getJson(List<Map<String, Object>> list){
List<TaskType> list2 = new ArrayList<TaskType>();
for (Map<String, Object> temp : list){
TaskType t = new TaskType();
t.setId(Integer.parseInt(temp.get("id").toString()));
t.setNameCn(temp.get("nameCn").toString());
t.setNameEn(temp.get("nameEn").toString());
t.setSort(Integer.parseInt(temp.get("sort").toString()));
t.setSTATUS(Integer.parseInt(temp.get("STATUS").toString()));
t.setSkill(temp.get("skill").toString());
list2.add(t);
}
return list2;
}
}
TaskType类代码如下:
package com.zerdoor.model;
/**
* Created by xiaoji on 2015/1/26.
*/
public class TaskType {
public int id;
public String nameCn;
public String nameEn;
public int sort;
public int STATUS;
public String skill;
private int parentId;
private String state = "closed";
public TaskType(){
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getNameCn() {
return nameCn;
}
public void setNameCn(String nameCn) {
this.nameCn = nameCn;
}
public String getNameEn() {
return nameEn;
}
public void setNameEn(String nameEn) {
this.nameEn = nameEn;
}
public int getSort() {
return sort;
}
public void setSort(int sort) {
this.sort = sort;
}
public int getSTATUS() {
return STATUS;
}
public void setSTATUS(int STATUS) {
this.STATUS = STATUS;
}
public String getSkill() {
return skill;
}
public void setSkill(String skill) {
this.skill = skill;
}
public int getParentId() {
return parentId;
}
public void setParentId(int parentId) {
this.parentId = parentId;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
}
上面这个类有四个属性很重要id,name,parentId,state = "closed"(我就死在这个属性上,没这个属性,你异步加载点击促发不到方法),
下面把gson包的maven地址一起发了
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.2.4</version>
</dependency>
以上就是耽搁了我2个小时时间,坑啊!