asp.net mvc jQuery 城市二级联动

页面效果图：

数据库表结构：

首先在数据库中创建省级、城市的表，我的表如下：我用了一张表放下了省级、城市的数据，用level划分省份和城市，parentId表示该城市所在省份的id

主要文件有：index.cshtml，ErJLDController.cs ，数据处理层，业务处理层，还有数据库文件 。

index.cshtml：

 1 
 2     

 3         
 4           请选择省份
 5         
 6         
 7             请选择市区
 8         
 9     
10 
11     
47 
48 
49 Index.cshtml

View Code

 ErJLDController.cs

 1 namespace Mvcproject.Controllers
 2 {
 3     //二级联动
 4     public class ErJLDController : Controller
 5     {
 6 
 7         ZjbEntities db = new ZjbEntities();
 8         //
 9         // GET: /Test/
10         
11         public ActionResult Index()
12         {
13             //pro_city province=new pro_city();
14             
15             return View();
16         }
17 
18         public JsonResult getProvince() {
19             
20             List provinceList = (from p in db.pro_city where p.level == 1 select p).ToList();
21   
22 
23             JsonResult Jprovince = new JsonResult();
24             Jprovince.Data = provinceList;
25             Jprovince.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
26             return Jprovince;
27 
28         }
29 
30         public JsonResult getCity(string pName)
31         {
32 
33             //string pid = (from p in db.pro_city where p.areaValue == pName select p.id).ToString();
34             //int id = int.Parse(pid);
35             int id = int.Parse(pName);
36 
37             List cityList = (from p in db.pro_city where p.parentId == id select p).ToList();
38   
39             JsonResult Jcity = new JsonResult();
40             Jcity.Data = cityList;
41             Jcity.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
42             return Jcity;
43 
44         }
45        
46     }
47 }
48 
49 ErJLDController.cs