.NET的添加，删除，查询

 在DAL里创建一个UserDAL类

//通过id实现删除

        public bool DeleteById(int id)
        {
            OA_TestEntities2 oat = new OA_TestEntities2();

            //不用查询直接删除的方法
            users us = new users();
            us.userId = id;
            oat.Entry<users>(us).State = System.Data.EntityState.Deleted;

            return oat.SaveChanges() > 0;
       

        }

/***********************      控制器        ***************************/

//更具id删除用户
        public ActionResult DeleteById(int id)
        {
            //通过ef实现删除

            UserDAL ud = new UserDAL();

            bool isdelete = ud.DeleteById(id);
            if (isdelete == true)
            {
                return RedirectToAction("Users");
            }
            else
            {
                return View();
            }

        }

/*********************       视图 ****************************/

 public List<users> GetAllusers()
        {
            OA_TestEntities2 oat = new OA_TestEntities2();

            List<users> uslist = oat.users.ToList();

            return uslist;
        }

 //通过id实现添加
        
        public bool adduser(User_DTO usd,List<string> adduserid)  
        {
            OA_TestEntities2 oat = new OA_TestEntities2();

                users us = new users();
                
                us.userId = usd.userId;
                us.userName =usd.userName;
                us.userSex = usd.userSex;
                us.userBirday = usd.userBirday;
                us.userHome = usd.userHome;
                us.userFace = usd.userFace;
                us.userInConpanyTime = usd.userInConpanyTime;
                us.dep_Id = Convert.ToInt32(usd.dep_Id);
                us.userPosition = usd.userPosition;
                us.userPhone = usd.userPhone;
                us.userMobilePhone = usd.userMobilePhone;
                us.userEmail = usd.userEmail;
                us.userTalk = usd.userTalk;
           
            oat.users.Add(us);
            return oat.SaveChanges() > 0;
            
        }

/***********************      控制器        ***************************/

  public ActionResult GiveUsers()
        {
            UserDAL ud = new UserDAL();

            ViewBag.allusers = ud.GetAllusers();
            return View();
        }

        public ActionResult GiveUseradd(User_DTO usd)
        {
            return View();
        }

        //添加用户信息
        public JsonResult AddHome(User_DTO usd, string nam)
        {

            string result = Newtonsoft.Json.JsonConvert.SerializeObject(usd);

            UserDAL ud = new UserDAL();
            bool isscuess = ud.adduser(usd, null);

            return Json(result, JsonRequestBehavior.AllowGet);
        }

/*********************       视图 ****************************/

 //查询用户所有
        public List<users> GetUsers()
        {
            OA_TestEntities2 oat = new OA_TestEntities2();
          
            List<users> ulist = oat.users.ToList();
            return ulist;
        }

/***********************      控制器        ***************************/

        //查询所有用户
        public ActionResult Users()
        {
            UserDAL ud = new UserDAL();

            List<users> us = ud.GetUsers();

            ViewBag.userlist = us;

            return View(us);
        }

/***********************      视图        ***************************/