MVC 三级联动

最新推荐文章于 2021-11-07 20:59:26 发布

SGB4096420

最新推荐文章于 2021-11-07 20:59:26 发布

阅读量186

点赞数

文章标签：测试数据库

原文链接：http://www.cnblogs.com/Mr-xue/p/4636244.html

版权

本篇实现中国省市区三级联动，先看最终效果：

初始状态:

当选择第1个Select,第2、3个Select可供选择：

当选择第２个Select,第１个不变、第3个Select可供选择：

当选择第３个Select,第１、２个不变：

下面是代码：

控制器Controllers\HomeController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using 省市区__三级联动.Models;

namespace 省市区__三级联动.Controllers
{
    public class HomeController : Controller
    {
        //
        // GET: /Home/
        [HttpGet] //刚开始加载页面的时候
        public ActionResult Index()
        {
            //省份  根据编号0001查的就是省份
          
            List<ChinaStates> listsheng = new ChinaDA().SelectBysheng("0001");
            ViewBag.shengs = new SelectList(listsheng, "AreaCode", "AreaName");


       
            List<ChinaStates> listshi = new ChinaDA().SelectByshi("11");
            ViewBag.shis = new SelectList(listshi, "AreaCode", "AreaName");

           
            List<ChinaStates> listqu = new ChinaDA().SelectByqu("1101");
            ViewBag.qus = new SelectList(listqu, "AreaCode", "AreaName");


            return View();
        }
        [HttpPost]  
        public ActionResult Index(string sheng, string shi, string qu)
        {
            
            List<ChinaStates> listsheng = new ChinaDA().SelectBysheng("0001");
            ViewBag.shengs = new SelectList(listsheng, "AreaCode", "AreaName",sheng);

            List<ChinaStates> listshi = new ChinaDA().SelectByshi(sheng);
            ViewBag.shis = new SelectList(listshi, "AreaCode", "AreaName",shi);

            var b = listshi.Exists(P => P.AreaCode == shi) ? shi : listshi[0].AreaCode;
            List<ChinaStates> listqu = new ChinaDA().SelectByqu(b);
            ViewBag.qus = new SelectList(listqu, "AreaCode", "AreaName");
           
            return View();
        }

    }
}

　　模型:

首先要用linq连接数据库然后建一个类开始写方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace 省市区__三级联动.Models
{
    public class ChinaDA
    {
        private ChinaDataContext _Context = new ChinaDataContext();
        public List<ChinaStates> Select()
        {
            return _Context.ChinaStates.ToList();
        }
        public List<ChinaStates> SelectBysheng(string AreaCode)
        {
            var query = _Context.ChinaStates.Where(p => p.ParentAreaCode == AreaCode);
            return query.ToList();
           
        }
        public List<ChinaStates> SelectByshi(string AreaCode)
        {
            var query = _Context.ChinaStates.Where(p => p.ParentAreaCode == AreaCode);
            return query.ToList();
        }
        public List<ChinaStates> SelectByqu(string AreaCode)
        {
            var query = _Context.ChinaStates.Where(p => p.ParentAreaCode == AreaCode);
            return query.ToList();
        }
    }
}

　　视图:

@using 省市区__三级联动.Models
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    @using (Html.BeginForm("Index", "Home", FormMethod.Post))
        {
    <div>
            @Html.DropDownList("sheng",ViewBag.shengs as SelectList,new { οnchange="document.forms[0].submit();"})
            @Html.DropDownList("shi",ViewBag.shis as SelectList, new { οnchange="document.forms[0].submit();"})
            @Html.DropDownList("qu",ViewBag.qus as SelectList)
       
    </div>
        }
</body>
</html>

转载于:https://www.cnblogs.com/Mr-xue/p/4636244.html

SGB4096420

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MVC 三级联动

本篇实现中国省市区三级联动，先看最终效果：初始状态:当选择第1个Select,第2、3个Select可供选择：当选择第２个Select,第１个不变、第3个Select可供选择：当选择第３个Select,第１、２个不变：下面是代码：控制器Controllers\HomeController.csusing System;using S...
复制链接

扫一扫