public void Update(Core.Domain.Common.Users user)
{
var sql = $@"update Users set
[Name] =@Name,
[Password]=@Password
where ID=@ID";
_context.Execute(sql, new
{
Name = user.Name,
Password = user.Password,
ID = user.ID
});
}
public void Insert(Core.Domain.Common.Users user)
{
var sql = $@"insert into Users(
[Name],
[Password])
VALUES (
@Name,
@Password)";
_context.Execute(sql, new
{
Name = user.Name,
Password = user.Password
});
}
public ActionResult Login(LoginModel loginModel)
{
if (ModelState.IsValid)
{
UserLoginResult result = _userValidateService.Validate(loginModel.UserName, loginModel.Password, loginModel.IsFromOtherSystem);
switch (result)
{
case UserLoginResult.Successful:
Core.Domain.Common.Users user = _userService.GetByCode(loginModel.UserName);
_authenticationService.SignIn(user, loginModel.RememberMe);
if (!String.IsNullOrEmpty(loginModel.ReturnUrl) && Url.IsLocalUrl(loginModel.ReturnUrl))
{
return(Redirect(loginModel.ReturnUrl));
}
return(Redirect("~/Home/Index"));
case UserLoginResult.UserNotExist:
ModelState.AddModelError("UserName_NotExist", "登录失败");
break;
case UserLoginResult.WrongPassword:
ModelState.AddModelError("Password_Wrong", "密码错误");
break;
}
//Core.Domain.Common.Users user = _userService.GetByCode(loginModel.UserName);
//_authenticationService.SignIn(user, loginModel.RememberMe);
//if (!String.IsNullOrEmpty(loginModel.ReturnUrl) && Url.IsLocalUrl(loginModel.ReturnUrl))
//{
// return Redirect("~/Hotel/Index?returnUrl=" + HttpUtility.UrlEncode(loginModel.ReturnUrl));
//}
//return Redirect("~/Hotel");
}
return(View(loginModel));
}
