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