增删改查

using Mvclogin.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Entity;

namespace Mvclogin.Controllers
{
    public class HomeController : Controller
    {
        //
        // GET: /Home/
        ExampleEntities dben = new ExampleEntities();
        public ActionResult Index()
        {
            List<StuInfo> list = dben.StuInfo.Take(10).ToList(); 
            return View(list);
        }
        public ActionResult Delete()
        {
            string id =Request.Form["Id"].ToString();
            StuInfo stu = dben.StuInfo.Where(e => e.stuid == id).FirstOrDefault();
            dben.StuInfo.Remove(stu);
            int i = dben.SaveChanges();
            if(i>0)
            {
                return Content("1");
            }
            else
            {
                return Content("0");
            }
            
        }
        public ActionResult modifypage(string id)
        {
            
            StuInfo stu = dben.StuInfo.FirstOrDefault(e => e.stuid == id);
            return View(stu);
        }
         public ActionResult Modify()
        {
             string id =Request.Form["stuid"];

            StuInfo stuinfo = dben.StuInfo.FirstOrDefault(e => e.stuid == id);
            stuinfo.stuname = Request.Form["stuname"].Trim().ToString();
            stuinfo.age = Convert.ToInt32(Request.Form["age"].Trim());
            stuinfo.address = Request.Form["address"].Trim().ToString();
             dben.Entry<StuInfo>(stuinfo).State=System.Data.EntityState.Modified;
             dben.SaveChanges();
             return RedirectToAction("Index", "Home");
        }
        /// <summary>
        /// 增加
        /// </summary>
        /// <returns></returns>
        public ActionResult Add()
         {
             StuInfo stuinfo = new StuInfo();
             stuinfo.stuname = Request.Form["stuname"].Trim().ToString();
             stuinfo.age = Convert.ToInt32(Request.Form["age"]. Trim());
             stuinfo.address = Request.Form["address"].Trim().ToString();
             dben.StuInfo.Add(stuinfo);
             dben.SaveChanges();
           if(dben.SaveChanges()>0)
           {
               return Content("1");
           }
           else
           {
               return Content("0");
           }
         }
    }
}

 

posted @ 2015-11-16 23:21  monica_guorong  阅读(170)  评论(0编辑  收藏  举报