public string UserLogin2(UserLogIn2 model)
{
using (var db = new Db())
{
var userAllRight = db.Database.SqlQuery <UserLogIn2>($"select * from user where login_name = '{model.Login_name}' and password = '******'").FirstOrDefault();
if (userAllRight == null)
{
var loginNameExist = db.Database.SqlQuery <UserLogIn2>($"select * from user where login_name = '{model.Login_name}'").FirstOrDefault();
if (loginNameExist != null)
{
var entity = new UserLog
{
Log_name = model.Login_name,
Log_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
Log_state = "fail"
};
db.UserLogs.Add(entity);
db.SaveChanges();
}
return("fail");
}
else
{
var entity = new UserLog
{
Log_name = model.Login_name,
Log_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
Log_state = "success"
};
db.UserLogs.Add(entity);
db.SaveChanges();
return("success");
}
}
}
public string UserSignUp(UserLogIn2 model)
{
using (var db = new Db())
{
var userState = db.Database.SqlQuery <UserLogIn2>($"select * from user where login_name = '{model.Login_name}'").FirstOrDefault();
if (userState == null)
{
var entity = new UserLogIn2
{
Login_name = model.Login_name,
Password = model.Password.Md5String()
};
db.UserLogIn2s.Add(entity);
db.SaveChanges();
return("account add success");
}
else
{
return("username exist");
}
}
}
