F9 开发之左树右表中的左树

1 首先在前端应用树树控件

 

<div class="fui-left">
		<div role="head" title="地区选择"></div>
		<div role="body">
			<div id="key" class="mini-textbox hidden" style="width: 150px;" onenter="onKeyEnter" />
			<div class="mini-button hidden" style="width: 50px;" onclick="search()">查询</div>
			<div id="tree1" class="mini-tree" showFolderCheckBox="true" action="treeModel" canCheckParent="true"></div>
		</div>
	</div>

 

2 在后台要有一个变量与之对应

private TreeModel treeModel = null;

3 这个变量的get方法来获得数据

public TreeModel getTreeModel() {
        if (treeModel == null) {
            treeModel = new TreeModel()
            {
                private static final long serialVersionUID = 1L;

                @Override
                public List<TreeNode> fetch(TreeNode pNode) {
                    List<Record> tmplist;
                    String guid = "";
                    if (pNode != null)
                        guid = pNode.getId();

                    // 根节点
                    if (StringUtil.isBlank(guid)) {

                        tmplist = service.findList(
                                "select CityName,CityCode from HuiYuan_City where right(CityCode,4)='0000' order by CityCode ",
                                Record.class);

                    }
                    else {
                        guid = Functions.TrimEnd(guid, "0");
                        String sql = "";
                        if (guid.length() == 2) {
                            sql = "select CityName,CityCode from HuiYuan_City where citycode like '" + guid
                                    + "%' and right(CityCode,2)='00' and right(CityCode,4)<>'0000' order by CityCode";
                        }
                        else if (guid.length() == 4) {
                            sql = "select CityName,CityCode from HuiYuan_City where citycode like '" + guid
                                    + "%' and right(CityCode,2)<>'00' order by CityCode";
                        }
                        tmplist = service.findList(sql, Record.class);
                    }

                    List<TreeNode> treeNodes = new ArrayList<TreeNode>();
                    
                    //修改在省级子节点中出现"所有地区"节点的问题   by dingbq 2016-8-29
                    if(StringUtil.isBlank(guid)){
                        TreeNode node1 = new TreeNode();
                        node1.setId("999");
                        node1.setText("所有地区");
                        node1.setLeaf(false);
                        node1.setExpanded(true);
                        treeNodes.add(node1);
                    }
                    
                    for (Record record : tmplist) {
                        TreeNode node = new TreeNode();
                        node.setId(record.getStr("CityCode"));
                        node.setText(record.getStr("CityName"));
                        String code = node.getId();
                        if(StringUtil.isBlank(guid)){
                            node.setPid("999");
                        }
                        if (code.endsWith("00"))
                            node.setLeaf(false);
                        else
                            node.setLeaf(true);
                        treeNodes.add(node);
                    }
                    return treeNodes;
                }

            };

        }
        return treeModel;
    }