在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);
}
/*********************** 视图 ***************************/