在 MVC 4 剃须刀中将 ID(主键)设置为会话而不是密码

Question

我喜欢在 mvc 4 razor sql 中将id(主键(设置为会话而不是password。谢谢大家！

我的模型

public bool check(string Pass)
{
bool convert = false;
string configuration = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(configuration))
{
con.Open();
var sql1 = "select ID(Primary key) from employees where Pass = '" + Pass + "' ";
MySqlCommand cmd = new MySqlCommand(sql1, con);
convert = Convert.ToBoolean(cmd.ExecuteScalar()); 
con.Close();
return convert;

}
}

这是我的控制器

if (ModelState.IsValid)
{
if (person.check(person.Pass))
{
Session["Pass"] = person.Pass;
Session.Timeout = 100000;
return Content("<script language='javascript' type='text/javascript'>alert('Welcome User'); window.location.href='Home/Mainmenu';</script>");
}
else
{
return Content("<script language='javascript' type='text/javascript'>alert('Invalid UserID'); window.location.href='Home/Login';</script>");
}
}

Answer 1

Session["Pass"] = person.Pass;

改成

Session["Pass"] = person.yourPKeyID;