private void button1_Click(object sender, EventArgs e)
{
MySqlHelper h = new MySqlHelper();
try
{
if (this.textBox1.Text.Length == 0)
{
MessageBox.Show("用户名不能为空！");
}
else if (this.textBox2.Text.Length == 0)
{
MessageBox.Show("密码不能为空！");
}
else
{
userCtrl ctrl = new userCtrl();
string sql = "select * from user where userName='******' and hashed_password='******'";
DataTable dtuser = h.ExecuteQuery(sql, CommandType.Text);//DBHelp.GetDataSet(sql);
if (dtuser.Rows.Count > 0)
{
if (dtuser.Rows[0]["isActive"].ToString() == "1")
{
saveLocal();
PropertyClass.SendNameValue = dtuser.Rows[0]["fullName"].ToString();
PropertyClass.UserId = Convert.ToInt32(dtuser.Rows[0]["id"]);
//PropertyClass.SendPopedomValue = dtuser.Rows[0]["user_competence"].ToString();
//PropertyClass.Password = dtuser.Rows[0]["user_password"].ToString();
PropertyClass.Role = Convert.ToInt32(dtuser.Rows[0]["role"]);
MainForm mainform = new MainForm();
this.Hide();
mainform.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("用户已被注销！");
}
}
else
{
MessageBox.Show("用户名或者密码错误！");
this.textBox2.Focus();
this.textBox2.SelectAll();
}
}
}
catch (Exception)
{
MessageBox.Show("服务器登陆失败！");
return;
}
}
