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.Close(); 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.Close(); 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 训练时间,描绘信封靶,对不动目标射击,原地射击,行进射击,平稳跟踪目标,白天稳像工况射击,白天装表工况射击,夜间稳像工况射击,夜间装表工况射击,自动跟踪射击,稳像工况应急射击 from ConScore where Number='" + number + "'", "ConScore").Tables[0]; } else if (selectText == "稳定器操作训练") { Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间,描绘信封靶,对不动目标射击,原地射击,行进射击,平稳跟踪目标 from ConScore where Number='" + number + "'", "ConScore").Tables[0]; } else if (selectText == "射击操作训练") { Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间,白天稳像工况射击,白天装表工况射击,夜间稳像工况射击,夜间装表工况射击,自动跟踪射击,稳像工况应急射击 from ConScore where Number='" + number + "'", "ConScore").Tables[0]; } else { Scoredata.DataSource = MySQLiteClass.Getsqliteset("select 训练时间," + selectText + " from ConScore where Number='" + number + "' and " + selectText + " is not null", "ConScore").Tables[0]; } }