public void SignUP(string Account, string Password)
{
try
{
using (var db = new AccountContext())
{
var u = db.SysUsers.Where(a => a.UserAccount.Equals(Account)).FirstOrDefault(); //查账户
if (u != null)
{
throw new Exception("用户名已存在！");
}
else
{
db.SysUsers.Add(new SysUser {
UserAccount = Account, UserPassword = Password
}); //增加新账户
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public SysUser GetUser(string Account, string Password)
{
try
{
using (var db = new AccountContext()) //数据库上下文联动
{
var u = db.SysUsers.Where(a => a.UserAccount.Equals(Account) && a.UserPassword.Equals(Password)).FirstOrDefault(); //判断账户密码是否相等，取相等的，否则返回空值
return(u);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Change(string Account, string OldPassword, string Password)
{
try
{
using (var db = new AccountContext())
{
var u = db.SysUsers.Where(a => a.UserAccount.Equals(Account) && a.UserPassword.Equals(OldPassword)).FirstOrDefault(); //查此账号
if (u == null)
{
throw new Exception("用户名或密码错误！");
}
else
{
u.UserAccount = Account;
u.UserPassword = Password;
db.SaveChanges(); //修改
}
}
}
catch (Exception ex)
{
throw ex;
}
}