private void RegistButton_Click(object sender, EventArgs e)
{
number = NumberTextbox.Text;
password = PasswordTextbox.Text;
if (number == "" || password == "")
{
ErrorLabel.Text = "请输入注册学号或密码";
}
else
{
SQLiteDataReader sdrLogin = MySQLiteClass.Getmysqlread("select Number from Login where Number='" + number + "'");
sdrLogin.Read();
if (sdrLogin.HasRows)
{
sdrLogin.Dispose();
ErrorLabel.Text = "该学号已注册";
}
else
{
MySQLiteClass.Getmysqlcom("insert into Login(Number,Password) values('" + number + "','" + password + "')");
ErrorLabel.Text = "注册成功";
}
}
NumberTextbox.Text = "";
PasswordTextbox.Text = "";
}
private void LoginButton_Click(object sender, EventArgs e)
{
number = NumberTextbox.Text;
password = PasswordTextbox.Text;
if (number == "" || password == "")
{
ErrorLabel.Text = "请输入学号或密码";
}
else
{
SQLiteDataReader sdrLogin = MySQLiteClass.Getmysqlread("select Password from Login where Number ='" + number + "'");
sdrLogin.Read();
if (sdrLogin.HasRows)
{
if (password != sdrLogin["Password"].ToString())
{
ErrorLabel.Text = "请输入正确的学号和密码";
}
else
{
sdrLogin.Dispose();
MySQLiteClass.sqlClose(MySQLiteClass.Getsqlitecon());
ErrorLabel.Text = "欢迎回来，学员" + number;
BGpictureBox.Visible = true;
Logoutbutton.Visible = true;
Scorebutton.Visible = true;
NumberLabel.Visible = false;
NumberTextbox.Visible = false;
PasswordLabel.Visible = false;
PasswordTextbox.Visible = false;
passwordCheckBox.Visible = false;
LoginButton.Visible = false;
RegistButton.Visible = false;
}
}
else
{
ErrorLabel.Text = "请输入正确的学号和密码";
}
}
NumberTextbox.Text = "";
PasswordTextbox.Text = "";
}
private void Scoretree_AfterSelect(object sender, TreeViewEventArgs e)
{
selectText = Scoretree.SelectedNode.Text;
Scoredata.DataSource = null;
if (selectText == "全部训练")
{
Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间,低速挡驾驶,依次换挡驾驶,重点难点动作驾驶,各种速度驾驶,坡上驾驶,直线桩间限制路,下坡桩间限制路,“S”型限制路,车辙桥,土岭,弹坑,弯道限制路,双直角限制路,连续限制路和障碍物驾驶,道路驾驶,行军驾驶 from DirScore where Number='" + number + "'", "DirScore").Tables[0];
}
else if (selectText == "基础驾驶")
{
Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间,低速挡驾驶,依次换挡驾驶,重点难点动作驾驶,各种速度驾驶 from DirScore where Number='" + number + "'", "DirScore").Tables[0];
}
else if (selectText == "单个限制路和障碍物驾驶")
{
Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间,直线桩间限制路,下坡桩间限制路,“S”型限制路,车辙桥,土岭,弹坑,弯道限制路,双直角限制路 from DirScore where Number='" + number + "'", "DirScore").Tables[0];
}
else
{
Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间," + selectText + " from DirScore where Number='" + number + "' and " + selectText + " is not null", "DirScore").Tables[0];
}
}
