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]; } }