public MODEL.Teacher UserLogin(MODEL.Teacher teacher)
{
string sql = "select * from dbo.teacher where id=@id and psw=@psw";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@id", teacher.UserId),
new SqlParameter("@psw", teacher.Password)
};
try
{
SqlDataReader reader = SqlDbHelper.GetDataReader(sql, paras);
if (reader.Read())
{
teacher.UserId = reader["id"].ToString();
}
else
{
teacher = null;
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
return(teacher);
}
private void button1_Click(object sender, EventArgs e)
{
MODEL.Teacher teacher = new MODEL.Teacher()
{
UserId = this.textBox1.Text.Trim(),
Password = this.textBox2.Text.Trim()
};
MODEL.Teacher teacherLogin = teacherLogic.UserLogin(teacher);
if (teacherLogin == null)
{
MessageBox.Show("账号或密码错误，请重新输入");
return;
}
else
{
this.DialogResult = DialogResult.OK;
//MessageBox.Show("登陆成功");
this.uid = teacher.UserId;
教师 a = new 教师(uid);//新窗体弹窗，旧的隐藏
this.Hide();
a.ShowDialog();
this.Show();
}
}
public MODEL.Teacher UserLogin(MODEL.Teacher teacher)
{
return(teacherDao.UserLogin(teacher));
}
