Api+Mvc增删查改

***********************************************************************************************************

Api:

    public class StuController : ApiController
    {
    //实例化对象
        Day3Entities ent = new Day3Entities();

    //显示

        // GET api/stu
        public List<Student> Get()
        {
            return ent.Students.ToList();
        }

    //查询

         //GET api/stu/5
        public Student Get(string name)
        {
            var list = ent.Students.Where(T=>T.NAME.Contains(name)).FirstOrDefault();
            return list;
        }
        //public Student Get(int id)
        //{
        //    var list = ent.Students.Where(T => T.ID==id).FirstOrDefault();
        //    return list;


        //}
    
    //添加

        // POST api/stu
        public void Post([FromBody]Student stu)
        {
            var res = ent.Students.Add(stu);
            ent.SaveChanges();
        }

    //修改
     
        // PUT api/stu/5
        public void Put([FromBody]Student stu)
        {
            var res = ent.Students.Where(T => T.ID == stu.ID).FirstOrDefault();
            res.NAME = stu.NAME;
            res.Sex = stu.Sex;
            res.Age = stu.Age;

            ent.SaveChanges();
        }

    //删除

        // DELETE api/stu/5
        public void Delete(int id)
        {
            var res = ent.Students.Where(T => T.ID == id).FirstOrDefault();
            ent.Students.Remove(res);
            ent.SaveChanges();

        }
    }

***********************************************************************************************************

//显示数据

public class StuMvcController : Controller
    {
        //
        // GET: /StuMvc/

        //定义一个基地址
        public static readonly Uri address = new Uri("http://localhost:61136/");
        public ActionResult Index(int pageIndex=1)
        {
            //实例化泛型
            List<Student> list = new List<Student>();

            //获取api的方法
            Uri url = new Uri(address, "/api/stu");
            //引用命名空间
            using (HttpClient client = new HttpClient())
            {
                var result = client.GetAsync(url).Result;
                //判断返回值状态
                if (result.IsSuccessStatusCode)
                {
                    list = result.Content.ReadAsAsync<List<Student>>().Result;
                }
            }
            return View(list.ToPagedList(pageIndex,3));
        }

        /// <summary>
        /// 添加显示页面
        /// </summary>
        /// <returns></returns>
        public ActionResult Add()
        {
            //自定义下拉列表
            List<SelectListItem> liAge = new List<SelectListItem>() {
            new SelectListItem(){Value="8",Text="8"},
            new SelectListItem(){Value="18",Text="18"},
            new SelectListItem(){Value="20",Text="20"},
            new SelectListItem(){Value="21",Text="21"}
            };
        
        ///SelectList list = new SelectList(dt, "Lid", "LName");
        

            ViewBag.liAge = liAge;
            return View();
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="stu"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Add(Student stu)
        {
            //获取api的方法
            Uri url = new Uri(address, "/api/Stu");
            //引用命名空间
            using (HttpClient client = new HttpClient())
            {
                var result = client.PostAsJsonAsync(url, stu).Result;
                if (result.IsSuccessStatusCode)
                {
                    return Content("<script>alert('添加成功');location.href='/StuMvc/Index';</script>");
                }
                else
                {
                    return Content("<script>alert('添加失败')</script>");
                }
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult Delete(int id)
        {
            //获取api的方法
            Uri url = new Uri(address, "/api/Stu/"+id);
            //引用命名空间
            using (HttpClient client = new HttpClient())
            {
                var result = client.DeleteAsync(url).Result;
                //判断返回值
                if (result.IsSuccessStatusCode)
                {
                    return Content("<script>alert('删除成功');location.href='/StuMvc/Index';</script>");
                }
                else
                {
                    return Content("<script>alert('删除失败')</script>");
                }
            }
        }
        /// <summary>
        /// 查询单个值
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        //public ActionResult Upd(string id)
        //{
        //    Student list = new Student();
        //    Uri url = new Uri(address, "/api/stu/" + id);
        //    //引用命名空间
        //    using (HttpClient client = new HttpClient())
        //    {
        //        var result = client.GetAsync(url).Result;
        //        //判断返回值状态
        //        if (result.IsSuccessStatusCode)
        //        {
        //            list = result.Content.ReadAsAsync<Student>().Result;
        //        }

        //        return Json(list, JsonRequestBehavior.AllowGet);
        //    }
        //}

        /// <summary>
        /// 修改显示页面
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult Upd(int id)
        {
            //自定义下拉列表
            List<SelectListItem> liAge = new List<SelectListItem>() {
            new SelectListItem(){Value="8",Text="8"},
            new SelectListItem(){Value="18",Text="18"},
            new SelectListItem(){Value="20",Text="20"},
            new SelectListItem(){Value="21",Text="21"}
            };
            ViewBag.liAge = liAge;
            //建立接口
            Day3Entities db = new Day3Entities();
            //取出要修改的数据
            var data = db.Students.Where(t => t.ID == id).FirstOrDefault();
            //创建学生类接收数据
            var model = new Student()
            {
                Age = data.Age,
                ID = id,
                NAME = data.NAME,
                Sex=data.Sex
            };
            return View(model);
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="stu"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult Upd(Student stu)
        {
            //获取api的方法
            Uri url = new Uri(address, "/api/Stu");
            //引用命名空间
            using (HttpClient client = new HttpClient())
            {
                var res=client.PutAsJsonAsync(url,stu).Result;
                if (res.IsSuccessStatusCode)
                {
                    return Content("<script>alert('修改成功');location.href='/StuMvc/Index';</script>");
                }
                else
                {
                    return Content("<script>alert('修改失败')</script>");
                }
            }
        }

    }

***********************************************************************************************************

//添加页面
<div>
        @using( Html.BeginForm())
        {
            <p>学生姓名：@Html.TextBoxFor(T => T.NAME)</p>
            <p>学生性别：@Html.RadioButtonFor(T=>T.Sex,"男")男
                     @Html.RadioButtonFor(T => T.Sex, "女")女
            </p>
            <p>学生年龄：@Html.DropDownListFor(T => T.Age, ViewBag.liAge as List<SelectListItem>)</p>

        //////////<p>@Html.DropDownListFor(T=>T.Lid,ViewBag.li as SelectList)</p>


            <p><input id="Submit1" type="submit" value="提交" /></p>
        }
       
 </div>