你先建一个 类型表 A;
另外建一个表B 这个A表的编号=B表的编号
在树形的视图里面 选择类型 右边出现B表对应的数据
B表视图 SQL
var treeid = getParameter("treedocid");
println("属性id-----》"+treeid);
var sql="";
if(treeid != ""){
sql = "select * from tlk_equipments_manage where item_name = '"+treeid+"'";
}else{
sql = "select * from tlk_equipments_manage where item_name = '1232132'";
}
sql;
A表树形视图
var sql = "select item_code as id, item_code,item_name,item_per_code,item_sort ,applicationid,domainid from tlk_equipment";
sql; |