public ActionResult LogOn(Users user) { var q = from u in DBContext.Users join r in DBContext.Roles on u.RoleId equals r.Id where u.Number == user.Number && u.Password==user.Password&&r.Name=="讲解员" select u.Id; int id = q.FirstOrDefault(); if (id != 0) { FormsAuthentication.SetAuthCookie(id.ToString(), false); return RedirectToAction("PlayList", "pad"); } else { ViewData["Error"] = "用户名或密码错误,请重新填写!"; return View(); } }
/// <summary> /// Deprecated Method for adding a new object to the Users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToUsers(Users users) { base.AddObject("Users", users); }
/// <summary> /// Create a new Users object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="password">Initial value of the Password property.</param> /// <param name="number">Initial value of the Number property.</param> /// <param name="roleId">Initial value of the RoleId property.</param> public static Users CreateUsers(global::System.Int32 id, global::System.String name, global::System.String password, global::System.String number, global::System.Int32 roleId) { Users users = new Users(); users.Id = id; users.Name = name; users.Password = password; users.Number = number; users.RoleId = roleId; return users; }
public ActionResult EditUser(Users user) { var obj = DBContext.Users.FirstOrDefault(e => e.Id == user.Id); if (user.Password != null && user.Password.Trim() != string.Empty) obj.Password = user.Password; obj.Number = user.Number; obj.Name = user.Name; obj.Tel = user.Tel; obj.Email = user.Email; obj.Remark = user.Remark; if (obj.RoleId != user.RoleId) { var result = DBContext.UsersRights.Where(e => e.UserId == obj.Id); foreach (var v in result) DBContext.DeleteObject(v); obj.RoleId = user.RoleId; AuthorizationToUser(obj.Id, user.RoleId); } else { DBContext.SaveChanges(); } return RedirectToAction("IndexUser"); }
public ActionResult AddUser(Users user) { DBContext.AddToUsers(user); DBContext.SaveChanges(); AuthorizationToUser(user.Id, user.RoleId); return RedirectToAction("IndexUser"); }