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

三级联动 使用Jquery实现城市三级数据联动的实例.txt21春暖花会开！如果你曾经历过冬天，那么你就会有春色！如果你有着信念，那么春天一定会遥远；如果你正在付出，那么总有一天你会拥有花开满圆。使用Jquery实现城市三级数据联动的实例View: $(document).ready(function() GetByJquery(); $(#ddlProvince).change(function() GetCity() ); $(#ddlCity).change(function() GetDistrict() ); ); function GetByJquery() $(#ddlProvince).empty(); /清空省份SELECT控件 $.getJSON(/ajax/GetProvinceList, function(data) $.each(data, function(i, item) $() .val(itemProvinceID) .text(itemProvinceName) .appendTo($(#ddlProvince); ); GetCity(); ); function GetCity() $(#ddlCity).empty(); /清空城市SELECT控件 var url =/ajax/GetCityList/ + $(#ddlProvince).val(); $.getJSON(url, function(data) $.each(data, function(i, item) $() .val(itemCityID) .text(itemCityName) .appendTo($(#ddlCity); ); GetDistrict(); ); function GetDistrict() $(#ddlDistrict).empty(); /清空市区SELECT控件 var url = /ajax/GetDistrictList/ + $(#ddlCity).val(); $.getJSON(url, function(data) $.each(data, function(i, item) $() .val(itemDistrictID) .text(itemDistrictName) .appendTo($(#ddlDistrict); ); ); Controller :using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;using System.Web.Mvc.Ajax;namespace MvcBBS.Controllers public class AjaxController : Controller / / GET: /Ajax/ / / 获取所有省份数据 / public ActionResult GetProvinceList() if (!Request.IsAjaxRequest() return Content(请不要非法方法,这是不道德的行为！); BLL.Province bll = new MvcBBS.BLL.Province(); List modellist = bll.GetProvinceList(); return Json(modellist); / / 获取某省份的所有城市数据 / public ActionResult GetCityList(int id) if (!Request.IsAjaxRequest() return Content(请不要非法方法,这是不道德的行为！); BLL.Province bll = new MvcBBS.BLL.Province(); List modellist = bll.GetCityList(id); return Json(modellist); / / 获取某城市的所有市区数据 / public ActionResult GetDistrictList(int id) if (!Request.IsAjaxRequest() return Content(请不要非法方法,这是不道德的行为！); BLL.Province bll = new MvcBBS.BLL.Province(); List modellist = bll.GetDistrict(id); return Json(modellist); 我比较喜欢使用三层工厂模式来读写数据，O/R Mapping不太适合我的要求！我们写的项目经常不是为了方便移植，而是选择明确的数据库，需要更高的性能，更强的业务逻辑！大家看到上面的代码，应该很熟悉，从数据库读数据到List中返回，并使有ASP.NET MVC内置的Json方法转换数据并ResponseDAL: / BLL,Model就不贴出来了！using System;using System.Data;using System.Text;using System.Data.SqlClient;using System.Collections.Generic;using DBUtility; /请先添加引用 namespace MvcBBS.DAL public class Province public Province() / / 获取所有省份数据 / / public List GetProvinceList() StringBuilder strSql = new StringBuilder(); strSql.Append(SELECT ProvinceID,ProvinceName ); strSql.Append( FROM S_Province ); List modelList = new List(); SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString(); while (dr.Read() Model.S_Province _model = new MvcBBS.Model.S_Province(); _model.ProvinceID = int.Parse(drProvinceID.ToString(); _model.ProvinceName = dr.GetString(1); modelList.Add(_model); dr.Close(); return modelList; / / 获取某省份的所有城市数据 / / / public List GetCityList(int ProvinceID) StringBuilder strSql = new StringBuilder(); strSql.Append(SELECT CityID,CityName,ZipCode); strSql.Append( FROM S_City ); strSql.Append( WHERE ProvinceID=); strSql.Append(ProvinceID.ToString(); List modelList = new List(); SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString(); while (dr.Read() Model.S_City _model = new MvcBBS.Model.S_City(); _model.CityID = int.Parse(drCityID.ToString(); _model.CityName = dr.GetString(1); _model.ZipCode = dr.GetString(2); _model.ProvinceID = ProvinceID; modelList.Add(_model); dr.Close(); return modelList; / / 获取某城市的所有市区 / / / public List GetDistrict(int CityID) StringBuilder strSql = new StringBuilder(); strSql.Append(SELECT DistrictID,DistrictName); strSql.Append( FROM S_District ); strSql.Append( WHERE CityID=); strSql.Append(CityID.ToString(); List modelList = new List(); SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString(); while (dr.Read() Model.S_District _model = new