问题描述:
英语翻译
private void button1_Click(object sender,EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "")
{
MessageBox.Show("请输入用户名和密码","错误提示");
}
else
{
DB.cn.Open();
OleDbCommand cmd = new OleDbCommand("",DB.cn);
string sql = "select RoleName from UserInfo where user='" + textBox1.Text.Trim() + "' and Password='" + textBox2.Text.Trim() + "'";
cmd.CommandText = sql;
string rolename;
if (null = cmd.ExecuteScalar())
{
rolename = cmd.ExecuteScalar().ToString();
this.Visible = false;
Main main = new Main();
main.Tag = this.FindForm();
sql = "select * from Roles where RoleName='" + rolename + "'";
cmd.CommandText = sql;
OleDbDataReader xq = cmd.ExecuteReader();
xq.Read();
main.XTMenuItem.Visible = (bool)(xq.GetValue(1));
main.CJMenuItem.Visible = (bool)(xq.GetValue(2));
main.BJMenuItem.Visible = (bool)(xq.GetValue(4));
main.KCMenuItem.Visible = (bool)(xq.GetValue(5));
main.DAMenuItem.Visible = (bool)(xq.GetValue(6));
main.StatusLabel2.Text = textBox1.Text.Trim();
main.ShowDialog();
DB.cn.Close();
}
else
{
MessageBox.Show("用户名或密码错误","登录失败");
DB.cn.Close();
}
}
private void button1_Click(object sender,EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "")
{
MessageBox.Show("请输入用户名和密码","错误提示");
}
else
{
DB.cn.Open();
OleDbCommand cmd = new OleDbCommand("",DB.cn);
string sql = "select RoleName from UserInfo where user='" + textBox1.Text.Trim() + "' and Password='" + textBox2.Text.Trim() + "'";
cmd.CommandText = sql;
string rolename;
if (null = cmd.ExecuteScalar())
{
rolename = cmd.ExecuteScalar().ToString();
this.Visible = false;
Main main = new Main();
main.Tag = this.FindForm();
sql = "select * from Roles where RoleName='" + rolename + "'";
cmd.CommandText = sql;
OleDbDataReader xq = cmd.ExecuteReader();
xq.Read();
main.XTMenuItem.Visible = (bool)(xq.GetValue(1));
main.CJMenuItem.Visible = (bool)(xq.GetValue(2));
main.BJMenuItem.Visible = (bool)(xq.GetValue(4));
main.KCMenuItem.Visible = (bool)(xq.GetValue(5));
main.DAMenuItem.Visible = (bool)(xq.GetValue(6));
main.StatusLabel2.Text = textBox1.Text.Trim();
main.ShowDialog();
DB.cn.Close();
}
else
{
MessageBox.Show("用户名或密码错误","登录失败");
DB.cn.Close();
}
}
问题解答:
我来补答展开全文阅读