二级菜单 局部刷新 重计算 可以获取一级菜单的 三级菜单获取不到二级的值
代码写法二三级基本都一样 ,设置基本也都一样
三级菜单脚本
(function (){
var city=getItemValueAsString("city_name");//获取市的值
println(city+"获取市的值");
var opts = $TOOLS.createOptions();
opts.add("","");
var sql = "SELECT * FROM vant_district t WHERE t.`status` = '0' AND t.`level` = '2' AND LEFT (CODE, 2) = LEFT ('"+city+"', 2)";
var datas = queryByDSName("micro",sql);
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var name= map1.get("name");
var value = map1.get("code");
opts.add(name,value);
}
}
return opts;
})() |