private void button进入二级_Click(object sender, EventArgs e)
{
ziAdminForm ziadmin = new ziAdminForm();
ziadmin.Show();
//this.Hide();
}
private void btnAccess_Click(object sender, EventArgs e)
{
string selecString1 = "select * from 管理员信息表 where mName='" + UseText.Text + "' and mPassword='******'";
string selecString2 = "select * from 学生个人信息表 where sName='" + UseText.Text + "' and sPassword='******'";
SqlConnection conn = new SqlConnection("server=(local);database=MyBookSys;Integrated Security=SSPI");
try
{
conn.Open();
if (rBnadmin.Checked)
{
if (UseText.Text != "" && PasswordText.Text != "")
{
SqlCommand cmd = new SqlCommand(selecString1, conn);
SqlDataReader dr1 = cmd.ExecuteReader();
if (dr1.Read())
{
ziAdminForm ziadmin = new ziAdminForm();
ziadmin.Show();
// this.Hide();
}
else if (UseText.Text == "admin" && int.Parse(PasswordText.Text) == 123456)
{
AdminForm admin = new AdminForm();
admin.Show();
// this.Hide();
}
else
{
MessageBox.Show("用户名或密码错误！", "**警告**", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("请输入用户名和密码！", "**警告**", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (rBnstu.Checked)
{
if (UseText.Text != "" && PasswordText.Text != "")
{
SqlCommand cmd = new SqlCommand(selecString2, conn);
SqlDataReader dr2 = cmd.ExecuteReader();
if (dr2.Read())
{
StuForm stu = new StuForm(UseText.Text);
stu.Show();
//this.Hide();
}
else
{
MessageBox.Show("用户名或密码错误！", "**警告**", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("请输入用户名和密码！", "**警告**", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("请选择登录身份！", "**警告**", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException ex) { MessageBox.Show(ex.ToString()); }
finally { conn.Close(); }
}
