不論二級還是多級聯動,資料層的基礎都是一張帶父編號的表:id、parent_id、name 三個欄位。
用二維陣列,以父編號當索引:
a[父編號] = [[子編號1, 子名稱1], [子編號2, 子名稱2], ...];
先依父編號取出所有子項,再把編號與名稱塞進下拉選單。
var cities = new Array(); cities['00000000-0000-0000-0000-000000000000'] = [['028db215-...','長春'], ['bcb32195-...','沈陽']]; var schools = new Array(); schools['028db215-...'] = [['5f22403a-...','長春1'], ['e8f0f665-...','長春2']]; schools['bcb32195-...'] = [['4a743dbf-...','沈陽1']];
第一級是城市,第二級是學校。
// type=0 城市,type=1 學校;pid 為父編號;obj 為目標 dropdown
function SetRegions(type, pid, obj)
{
var text = "<option value='00000000-0000-0000-0000-000000000001'>請選擇</option>";
var tempArray = new Array();
if (type == 0) { tempArray = cities[pid]; }
else if (type == 1) { tempArray = schools[pid]; }
if (tempArray != null)
{
for (var i = 0; i < tempArray.length; i++){
text += "<option value='" + tempArray[i][0] + "'>" + tempArray[i][1] + "</option>";
}
}
$(obj).html(text);
}
function CityChanged(){
SetRegions(1, $("#cities").val(), "#schools");
}
這一步以前最讓人頭痛——修改資料時必須把已選的值還原:
// cityId 城市編號,schoolId 學校編號
function InitRegions(cityId, schoolId)
{
$("#cities option[value=" + cityId + "]").attr("selected", "selected");
if (schoolId != "00000000-0000-0000-0000-000000000001"){
SetRegions(1, cityId, "#schools");
$("#schools option[value=" + schoolId + "]").attr("selected", "selected");
}
}
<select runat="server" id="cities" onchange="CityChanged();"></select> <select runat="server" id="schools"></select> <script type="text/javascript"> SetRegions(0, '00000000-0000-0000-0000-000000000000', "#cities"); var cityId = '<asp:Literal ID="Literal_cityId" runat="server"></asp:Literal>'; var schoolId = '<asp:Literal ID="Literal_schoolId" runat="server"></asp:Literal>'; InitRegions(cityId, schoolId); </script>
string cityId = Request.Form["cities"] == null ? "00000000-0000-0000-0000-000000000001" : Request.Form["cities"]; string schoolId = Request.Form["schools"] == null ? "00000000-0000-0000-0000-000000000001" : Request.Form["schools"];
最後一步是在後端把資料表轉成 JavaScript 檔:
private void CreateRegions()
{
string _cities = "var cities=new Array();";
string _schools = "var schools=new Array();";
DAL.RegionInfo dalRegion = new DAL.RegionInfo();
DataTable dtcity = dalRegion.GetList("parent_id='00000000-0000-0000-0000-000000000000'").Tables[0];
_cities += "cities['" + ParentId + "']=[";
foreach (DataRow c in dtcity.Rows)
{
_cities += "['" + c["id"] + "','" + c["name"] + "'],";
DataTable dtschool = dalRegion.GetList("parent_id='" + c["id"] + "'").Tables[0];
if (dtschool == null || dtschool.Rows.Count == 0) { continue; }
_schools += "schools['" + c["id"] + "']=[";
foreach (DataRow s in dtschool.Rows)
{
_schools += "['" + s["id"] + "','" + s["name"] + "'],";
}
_schools = _schools.TrimEnd(',') + "];";
}
_cities = _cities.TrimEnd(',') + "];";
Response.Write(_cities);
Response.Write(_schools);
}
把輸出的內容貼進 js 檔即可。想擴成三級、多級聯動也是同一套邏輯——每一層都用父編號當索引去取下一層,只是多包一層迴圈與遞迴而已。