220421

-----控制器-----

        /// <summary>
        /// 显示数据
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            using (var db = new HouseInfoDBEntity())
            {
                var list = db.HouseInfo.Select(s => new ListViewModel()
                {
                    Id = s.Id,
                    HouseName = s.HouseName,
                    Area = s.Area,
                    Price = s.Price,
                    FloorCount = s.FloorCount,
                    Floor = s.Floor,
                    State = s.State,
                    HouseDescribe = s.HouseDescribe,
                    Years = s.Years,
                    Name = s.HouseType.Name
                }).ToList();
                return View(list);
            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="Age"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Index(string Name, string Age)
        {
            using (var db = new StudentDBEntity())
            {
                var list = db.Student.Select(s => new ListViewModel()
                {
                    Id = s.Id,
                    Name = s.Name,
                    Age = s.Age,
                    Mobile = s.Mobile,
                    Email = s.Email,
                    ClassName = s.Class.ClassName
                }).Where(w => w.Name.Contains(Name)).ToList();

                if (Age != "")
                {
                    list = list.Where(o => o.Age == Convert.ToInt32(Age)).ToList();
                }
                ViewBag.Name = Name;
                ViewBag.Age = Age;
                return View(list);
            }
        }

        /// <summary>
        /// 绑定下拉列表
        /// </summary>
        /// <returns></returns>
        public List<SelectListItem> DDLList()
        {
            using (var db = new HouseInfoDBEntity())
            {
                var list = db.HouseType.Select(s => new SelectListItem()
                {
                    Text = s.Name,
                    Value = s.Id.ToString()
                }).ToList();
                return list;
            }
        }

        /// <summary>
        /// 加载添加视图
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public ActionResult Add()
        {
            ViewBag.ddllist = DDLList();
            return View();
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="viewModel"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Add(AddViewModel viewModel)
        {
            if (ModelState.IsValid)
            {
                using (var db = new HouseInfoDBEntity())
                {
                    var model = new HouseInfo()
                    {
                        HouseName = viewModel.HouseName,
                        Area = viewModel.Area,
                        Price = viewModel.Price,
                        FloorCount = viewModel.FloorCount,
                        Floor = viewModel.Floor,
                        State = viewModel.State,
                        Years = viewModel.Years,
                        TypeId = viewModel.TypeId,
                        HouseDescribe = viewModel.HouseDescribe
                    };
                    db.HouseInfo.Add(model);
                    db.SaveChanges();
                    ViewBag.msg = "添加成功";
                }
            }
            else
            {
                ModelState.AddModelError("", "您输入的信息有误");
            }
            ViewBag.ddllist = DDLList();
            return View(viewModel);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult Delete(int id)
        {
            using (var db = new HouseInfoDBEntity())
            {
                var model = db.HouseInfo.FirstOrDefault(s => s.Id == id);
                if (model != null)
                {
                    db.HouseInfo.Remove(model);
                    db.SaveChanges();
                    return Json(new { State = 1, Message = "删除成功" });
                }
                else
                {
                    return Json(new { State = -1, Message = "删除失败" });
                }
            }
        }

        /// <summary>
        /// 加载修改视图
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public ActionResult Edit(int id)
        {
            using (var db = new HouseInfoDBEntity())
            {
                var model = db.HouseInfo.FirstOrDefault(s => s.Id == id);
                if (model != null)
                {
                    var viewModel = new EditViewModel()
                    {
                        Id = model.Id,
                        HouseName = model.HouseName,
                        Area = model.Area,
                        Price = model.Price,
                        FloorCount = model.FloorCount,
                        Floor = model.Floor,
                        State = model.State,
                        Years = model.Years,
                        TypeId = model.TypeId,
                        HouseDescribe = model.HouseDescribe
                    };
                    ViewBag.ddllist = DDLList();
                    return View(viewModel);
                }
                else
                {
                    return HttpNotFound();
                }
            }
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Edit(EditViewModel viewModel)
        {
            if (ModelState.IsValid)
            {
                using (var db = new HouseInfoDBEntity())
                {
                    var model = db.HouseInfo.FirstOrDefault(s => s.Id == viewModel.Id);
                    if (model != null)
                    {
                        model.HouseName = viewModel.HouseName;
                        model.Area = viewModel.Area;
                        model.Price = viewModel.Price;
                        model.FloorCount = viewModel.FloorCount;
                        model.Floor = viewModel.Floor;
                        model.State = viewModel.State;
                        model.Years = viewModel.Years;
                        model.TypeId = viewModel.TypeId;
                        model.HouseDescribe = viewModel.HouseDescribe;
                        db.SaveChanges();
                        ViewBag.msg = "修改成功";
                    }
                }
            }
            else
            {
                ModelState.AddModelError("", "您输入的信息有误");
            }
            ViewBag.ddllist = DDLList();
            return View(viewModel);
        }

        /// <summary>
        /// 上架
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult update(int id)
        {
            using (var db = new HouseInfoDBEntity())
            {
                var model = db.HouseInfo.FirstOrDefault(s => s.Id == id);
                if (model != null)
                {
                    model.State = 0;
                    db.SaveChanges();
                    return Json(new { State = 1, Message = "上架成功" });
                }
                else
                {
                    return Json(new { State = -1, Message = "上架失败" });
                }
            }
        }

        /// <summary>
        /// 下架
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult downdate(int id)
        {
            using (var db = new HouseInfoDBEntity())
            {
                var model = db.HouseInfo.FirstOrDefault(s => s.Id == id);
                if (model != null)
                {
                    model.State = 1;
                    db.SaveChanges();
                    return Json(new { State = 1, Message = "下架成功" });
                }
                else
                {
                    return Json(new { State = -1, Message = "下架失败" });
                }
            }
        }

-----AJAX-----

<script>
    //删除
    function del(id, t) {
        if (confirm("您确定要删除吗?")) {
            $.ajax({
                url: "/HouseInfo/Delete",
                type: "post",
                data: { "id": id },
                dataType: "json",
                success: function (r) {
                    alert(r.Message);
                    if (r.State == 1) {
                        $(t).parent().parent().remove();
                    }
                },
                error: function () {

                    alert("数据处理错误");
                }
            })
        }
    }
    //上架
    function update(id) {
        if (confirm("您确定要上架该信息吗?")) {
            $.ajax({
                url: "/HouseInfo/update",
                type: "post",
                data: { "id": id },
                dataType: "json",
                success: function (r) {
                    alert(r.Message);
                    if (r.State == 1) {
                        location.reload();
                    }
                },
                error: function () {
                    alert("数据处理错误");
                }
            })
        }
    }
    //下架
    function downdate(id) {
        if (confirm("您确定要下架该信息吗")) {
            $.ajax({
                url: "/HouseInfo/downdate",
                type: "post",
                data: { "id": id },
                dataType: "json",
                success: function (r) {
                    alert(r.Message);
                    if (r.State == 1) {
                        location.reload();
                    }
                },
                error: function () {
                    alert("数据处理错误");
                }
            })
        }
    }
</script>

-----搜索框-----

<div>
    <form action="/Student/Index" method="post">
        姓名：<input type="text" name="Name" value="@ViewBag.Name" />
        年龄：<input type="text" name="Age" value="@ViewBag.Age" />
        <input type="submit" name="" value="查询" class="btn btn-success " />
        <a href="/Student/ADD" class="btn btn-primary">添加</a>
    </form>
</div>

-----操作-----

             <td>
                <a href="/HouseInfo/Edit/@item.Id" class="btn btn-info">编辑</a>
                @if (item.State == 0)
                {
                    <a href="#" class="btn btn-warning" οnclick="downdate(@item.Id)">下架</a>
                }
                else
                {
                    <a href="#" class="btn btn-warning" οnclick="update(@item.Id)">上架</a>
                }
                <a href="#" class="btn btn-danger" οnclick="del(@item.Id ,this)">删除</a>
            </td>

-----前台两个-----

        <div class="form-group">
            @Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.RadioButtonFor(model => model.State, 0, new { @checked = "checked" })上架
                @Html.RadioButtonFor(model => model.State, 1)下架
                @Html.ValidationMessageFor(model => model.State, "", new { @class = "text-danger" })
            </div>
        </div>
        <div class="form-group">
            @Html.LabelFor(model => model.TypeId, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.DropDownListFor(model => model.TypeId,ViewBag.ddllist as IEnumerable<SelectListItem>, new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.TypeId, "", new { @class = "text-danger" })
            </div>
        </div>

@Html.HiddenFor(model => model.Id)