```
if(config.path){
admin.req({
url: layui.setter.apiUrl.SlopsApi + '/Execute',
data: {
path: config.path,
UserID: layui.data(layui.setter.tableName).userInfo.ID,
},
done: function (res) {
var nodes = [];
// 思路： 使用對象屬性特性，緩存每個MenuID對應的節點對象，用于判斷對應的上級在不在，如果在，則可直接將節點掛接到其上級菜單節點下；不在則將節點放到根節點上
// rels 用于 建立MenuID 與 節點的關系
var tables = res.tables, len = tables.length, townlist = [], towns= {};
// 組裝 Tom
$.each(tables[0], function (idx, item){
if(!towns[item.TownID]){
var t = {TownID: item.TownID, TownName: item.TownName, villageList: []};
townlist.push(t);
towns[item.TownID] = t;
}
towns[item.TownID].villageList.push({VillageID: item.VillageID, VillageName: item.VillageName });
});
view('hongbo-chooseVillage-body').send($('#hongbo-chooseVillage-fill').html(),
$.extend({ type: config.type }, { townList: config.full ? datas.fullVillage : datas.villageList }, {townList: townlist})
);
form.render(null, 'hongbo-chooseVillage-form');
}
});
}
```
```
select distinct v.ID as VillageID, v.Name as VillageName,c.ID as TownID,c.Name as TownName
from dbo.P_ProBidVill pb1
inner join dbo.f_getUserBidList(@UserID) ub on ub.BidID = pb1.BidID
LEFT JOIN Slops.dbo.S_Village v on v.ID = pb1.Village
LEFT JOIN Slops.dbo.S_County c on c.ID = v.CountyID
```
