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");
}
