1.根据网点的改变显示不同用户
<form method="post" class="form">
<fieldset>
<legend>信息</legend>
<table class="table" style="width: 100%;">
<tr>
<td><input name="id" value="<%=id%>" readonly="readonly" hidden="hidden" /></td>
</tr>
<tr>
<th>网点</th>
<td><select id="orgid" name="orgid" class="easyui-combotree" style="width: 173px;"
data-options="editable:false,idField:'id',textField:'name',parentField:'pid',
url:'<%=contextPath%>/base/syorganization!doNotNeedSecurity_comboTree.sy'" >
</select></td>
</tr>
<tr>
<th>用户</th>
<td><select id = "pkcus" name="pkcus" class="easyui-combobox"
data-options="required:true,prompt:'请先选择所属机构',url:'',
idField:'PKCUS',valueField:'PKCUS',textField:'UNAME',"></select>
</td>
</tr>
</table>
</fieldset>
</form>
2.网点onChange事件
<script type="text/javascript">
$(function() {
if ($(':input[name="id"]').val().length > 0) {
parent.$.messager.progress({
text : '数据加载中....'
});
$.post(sy.contextPath + '/khjlgl/customer!findById.sy', {
id : $(':input[name="id"]').val()
}, function(result) {
if (result[0].ID != undefined) {
$('form').form('load', {
'id' : result[0].ID,
'orgid' : result[0].ORGID,
'pkcus' : result[0].PKCUS,
'managerrisk' : result[0].MANAGERRISK,
'createname' : result[0].CREATENAME,
'modifyname' : result[0].MODIFYNAME
});
}
parent.$.messager.progress('close');
}, 'json');
}
$('#orgid').combotree({
onChange: function (newValue,oldValue) {
console.info(newValue);
if (newValue != null) {
$("#pkcus").combobox("setValue",null);
$('#pkcus').combobox('readonly', false);
$('#pkcus').combobox('reload', sy.contextPath + '/khjlgl/customer!findUserTree.sy?orgid='+newValue);
}
},
});
});
</script>
3.xml文件
<select id="findUserTree" resultType="java.util.Map">
SELECT
syu.ID pkcus,
syu.name uname,
syo.id orgid,
syo.name
FROM syuser_syorganization ss
LEFT JOIN syuser syu
ON ss.syuser_id=syu.id
LEFT JOIN syorganization syo
ON syo.id=ss.SYORGANIZATION_ID
where syo.id=#{orgid,jdbcType=VARCHAR}
ORDER BY syo.id
</select>