三级联动-使用Jquery实现城市三级数据联动的实例

三级联动使用Jquery实现城市三级数据联动的实例.txt21春暖花会开！如果你曾经历过冬天，那么你就会有春色！如果你有着信念，那么春天一定会遥远；如果你正在付出，那么总有一天你会拥有花开满圆。使用Jquery实现城市三级数据联动的实例View:<scripttype="text/javascript">$(document).ready(function(){GetByJquery();$("#ddlProvince").change(function(){GetCity()});$("#ddlCity").change(function(){GetDistrict()});});functionGetByJquery(){$("#ddlProvince").empty();//清空省份SELECT控件$.getJSON("/ajax/GetProvinceList",function(data){$.each(data,function(i,item){$("<option></option>").val(item["ProvinceID"]).text(item["ProvinceName"]).appendTo($("#ddlProvince"));});GetCity();});}functionGetCity(){$("#ddlCity").empty();//清空城市SELECT控件varurl="/ajax/GetCityList/"+$("#ddlProvince").val();$.getJSON(url,function(data){$.each(data,function(i,item){$("<option></option>").val(item["CityID"]).text(item["CityName"]).appendTo($("#ddlCity"));});GetDistrict();});}functionGetDistrict(){$("#ddlDistrict").empty();//清空市区SELECT控件varurl="/ajax/GetDistrictList/"+$("#ddlCity").val();$.getJSON(url,function(data){$.each(data,function(i,item){$("<option></option>").val(item["DistrictID"]).text(item["DistrictName"]).appendTo($("#ddlDistrict"));});});}</script><table><tr><td><selectid="ddlProvince"/></td><td><selectid="ddlCity"/></td><td><selectid="ddlDistrict"/></td></tr></table>Controller:usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Mvc;usingSystem.Web.Mvc.Ajax;namespaceMvcBBS.Controllers{publicclassAjaxController:Controller{////GET:/Ajax////<summary>///获取所有［省份］数据///</summary>publicActionResultGetProvinceList(){if(!Request.IsAjaxRequest()){returnContent("请不要非法方法,这是不道德的行为！");}DAL://BLL,Model就不贴出来了！usingSystem;usingSystem.Data;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Collections.Generic;usingDBUtility;//请先添加引用namespaceMvcBBS.DAL{publicclassProvince{publicProvince(){}///<summary>///获取所有省份数据///</summary>///<returns></returns>publicList<Model.S_Province>GetProvinceList(){StringBuilderstrSql=newStringBuilder();strSql.Append("SELECTProvinceID,ProvinceName");strSql.Append("FROMS_Province");List<Model.S_Province>modelList=newList<MvcBBS.Model.S_Province>();SqlDataReaderdr=DbHelperSQL.ExecuteReader(strSql.ToString());while(dr.Read()){Model.S_Province_model=newMvcBBS.Model.S_Province();_model.ProvinceID=int.Parse(dr["ProvinceID"].ToString());_model.ProvinceName=dr.GetString(1);modelList.Add(_model);}dr.Close();returnmodelList;}///<summary>///获取某省份的所有城市数据///</summary>///<paramname="ProvinceID"></param>///<returns></returns>publicList<Model.S_City>GetCityList(intProvinceID){StringBuilderstrSql=newStringBuilder();strSql.Append("SELECTCityID,CityName,ZipCode");strSql.Append("FROMS_City");strSql.Append("WHEREProvinceID=");strSql.Append(ProvinceID.ToString());List<Model.S_City>modelList=newList<MvcBBS.Model.S_City>();SqlDataReaderdr=DbHelperSQL.ExecuteReader(strSql.ToString());while(dr.Read()){Model.S_City_model=newMvcBBS.Model.S_City();_model.CityID=int.Parse(dr["CityID"].ToString());_model.CityName=dr.GetString(1);_model.ZipCode=dr.GetString(2);_model.ProvinceID=ProvinceID;modelList.Add(_model);}dr.Close();returnmodelList;}///<summary>///获取某城市的所有市区///</summary>///<paramname="CityID"></param>///<returns></returns>publicList<Model.S_District>GetDistrict(intCityID){StringBuilderstrSql=newStringBuilder();strSql.Append("SELECTDistrictID,DistrictName");strSql.Append("FROMS_District");strSql.Append("WHERECityID=");strSql.Append(CityID.ToString());List<Model.S_District>modelList=newList<MvcBBS.Model.S_District>();SqlDataReaderdr=DbHelperSQL.ExecuteReader(strSql.ToString());while(dr.Read()){Model.S_District_model=newMvcBBS.Model.S_District();