两个下拉框联动的实现

两个下拉框联动的实现

1.只写一个查询

var flag = '{#flag#}';
app.info(flag);
if(flag == '0'){
  /* 个人 */
	app.output('select t.item_name AS D,T.item_code AS V from rdm.t_dict_entry t where t.dict_code = \'DM1304\' and T.ITEM_CODE = \'1\' ');
}else if(flag == '1'){
/* 机构 */
	app.output("select t.item_name AS D,T.item_code AS V from rdm.t_dict_entry t where t.dict_code = \'DM1304\' and T.ITEM_CODE BETWEEN \'2\' AND \'6\' ");
}else {
  /* 产品 */
	app.output("select t.item_name AS D,T.item_code AS V from rdm.t_dict_entry t where t.dict_code = \'DM1304\' and T.ITEM_CODE = \'7\'  ");
}