MVC 程序开发对汽车种类的联动查询。厂商，系列，型号

最新推荐文章于 2025-09-07 17:43:44 发布

weixin_30429201

最新推荐文章于 2025-09-07 17:43:44 发布

阅读量56

点赞数

CC 4.0 BY-SA版权

文章标签：测试

原文链接：http://www.cnblogs.com/275147378abc/p/4638541.html

本文介绍了一个使用ASP.NET MVC的应用实例，展示了如何通过不同控制器和模型类来实现汽车产品系列及型号的选择功能，包括从数据库中获取产品、品牌及具体车型数据。

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

namespace MvcApplication8.Models
{
    public class BrandDA
    {
        private masterDataContext _Context = new masterDataContext();

        //查询全部系列
        public List<Brand> Select()
        {
            return _Context.Brand.ToList();
        }
        //根据厂商查询系列
        public List<Brand> SelectByProd(string prodCode)
        {
            var query = _Context.Brand.Where(p => p.Prod_Code == prodCode);
            return query.ToList();
        }
    }
}

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

namespace MvcApplication8.Models
{
    public class CarDA
    {
        private masterDataContext _Context = new masterDataContext();
        public List<Car> Select()
        {
            return _Context.Car.ToList();
        }

        //通过系列查所有型号
        public List<Car> SelectByBrand(string brandCode)
        {
            var query = _Context.Car.Where(p => p.Brand == brandCode);
            return query.ToList();
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcApplication8.Models;

namespace MvcApplication8.Controllers
{
    public class CarsController : Controller
    {
        //
        // GET: /Cars/

        public ActionResult Index(string prod, string brand, string car)
        {
            //查询全部厂商
            List<Productor> listProd = new ProductorDA().Select();
            //厂商下拉表的显示
            ViewBag.Prods = new SelectList(listProd, "Prod_Code", "Prod_Name", prod);

            //通过厂商查询系列
            List<Brand> listBrand = new BrandDA().SelectByProd(prod);
            //系列下拉表的显示
            ViewBag.Brands = new SelectList(listBrand, "Brand_Code", "Brand_Name",brand);


            var b = listBrand.Exists(p =>p.Brand_Code == brand)?brand:listBrand[0].Brand_Code; 

            //通过系列查询小汽车的型号
            List<Car> listCar = new CarDA().SelectByBrand(b);

            //小汽车下拉表的显示
            ViewBag.Cars = new SelectList(listCar, "Code", "Name",car);
            return View();
        }

        

        [HttpGet]
        public ActionResult Index()
        {
            List<Productor> listProd = new ProductorDA().Select();
            ViewBag.Prods = new SelectList(listProd, "Prod_Code", "Prod_Name", "p001");

            List<Brand> listBrand = new BrandDA().SelectByProd("p001");
            ViewBag.Brands = new SelectList(listBrand, "Brand_Code", "Brand_Name");

            List<Car> listCar = new CarDA().SelectByBrand("b001");
            ViewBag.Cars = new SelectList(listCar, "Code", "Name");
            return View();
        }
    }
}

@using MvcApplication8.Models;
@model List<MvcApplication8.Models.Car>
@using MvcApplication8.Controllers;

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <div>
        @using(Html.BeginForm("Index","Cars", FormMethod.Post))
        {
        @Html.DropDownList("prod", ViewBag.Prods as SelectList,new { onchange="document.forms[0].submit();"})
        @Html.DropDownList("brand",ViewBag.Brands as SelectList,new { onchange="document.forms[0].submit();"})
        @Html.DropDownList("car",ViewBag.Cars as SelectList)
        }

        <form attion="CarsControllers" method="post">

        </form>


        
    </div>
</body>
</html>