4级联动,这么写不要死人?
而且数据都是从表里面读的。二级如下:
#include "doclib";
#include "codelib";
var opts = $TOOLS.createOptions();
opts.add("","");
var parent_cat= getItemValue("cat_1");
w = " and parent_cat = '" + parent_cat+ "'";
var documentProcess = getDocProcess($WEB.getApplication());
var dql = "$formname=getApplication()+'/MasterData/Form_Ticket_Cat_2'" +w;
var params = new Packages.cn.myapps.base.action.ParamsTable();
params.setParameter("domain",$WEB.getDomainid());
params.setParameter("_orderby", "item_CAT_NAME");
params.setParameter("_sortStatus", "");
var docs= documentProcess.queryByDQL(dql,params,$WEB.getDomainid());
if (docs!=null)
for(var iter = docs.getDatas().iterator(); iter.hasNext();) {
var doc = iter.next();
var cat_id = doc.getItemValueAsString("cat_id");
var cat_name= doc.getItemValueAsString("cat_name");
opts.add(cat_name,cat_id);
}
opts; |