通过ajax 绑定 国家地区联动下拉列表
上章写到不用ajax进行关联,现记录下通过ajax绑定国家地区下拉列表
js:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
//地区下拉 function changeRegion(stateid, controlsid,showSelect) { if (stateid != "0") { $.ajax({ type: "POST", url: "Ajax/Region.ashx?action=changeRegion&id=" + stateid, data: "yshop=yshop", async: false, dataType: "JSON", success: function (data, df) { var json = eval('(' + data + ')'); changeResponse(json, stateid, controlsid, showSelect); } }); } } function changeResponse(result, stateid, controlsid, showSelect) { var sel = document.getElementById(controlsid); if (result.error == 0) { sel.length = 0; var goods = result.content.goods; if (showSelect != "") { var opt = document.createElement("OPTION"); opt.value = "0"; opt.text = showSelect; sel.options.add(opt); } if (goods.length) { for (i = 0; i < goods.length; i++) { var opt = document.createElement("OPTION"); opt.value = goods[i].goods_id; opt.text = goods[i].goods_name; if (stateid == goods[i].goods_id) { opt.selected = true; //默认选择 } sel.options.add(opt); } } } if (result.message.length > 0) { alert(result.message); } }
html:
<asp:DropDownList ID="ddlstate" runat="server" onchange="changeRegion(this.value,'ddlcity','')"> <asp:ListItem Value="0">请选择</asp:ListItem> </asp:DropDownList> <asp:DropDownList ID="ddlcity" runat="server"> <asp:ListItem Value="0">请选择</asp:ListItem> </asp:DropDownList> <script type="text/javascript"> $(function () { changeRegion("1", "ddlstate",""); }); </script>
c#:
//http://www.cnblogs.com/yfdong22
public static string GetRegionNameAndIDOption(string keywords, string strWhere) { Glant.BLL.BLLRegion bll = new Glant.BLL.BLLRegion(); List<Model.ModelRegion> list = bll.GetModelList("parent_id=" + keywords + " " + strWhere); System.Text.StringBuilder sbjson = new System.Text.StringBuilder(); if (list.Count > 0) { foreach (Model.ModelRegion model in list) { sbjson.Append("{\"goods_id\":\"" + model.region_id.ToString() + "\",\"goods_name\":\"" + model.region_name.ToString() + "\"},"); } } return "{\"content\":{\"goods\":[" + sbjson.ToString() + "]},\"message\":\"\",\"error\":\"0\"}"; }
myblog:http://www.cnblogs.com/yfdong22
地区数据mysql:下载页面:http://ishare.iask.sina.com.cn/f/4950333.html