private void button1_Click(object sender, EventArgs e)
{
string sql = "update Yy set Sh='" + comboBox2.Text + "'where Sjd='" + str[3] + "'";
Dao1 dao = new Dao1();
dao.Execute(sql);
this.Hide();
ShenHe shenhe = new ShenHe();
shenhe.Show();
}
private void 取消预约ToolStripMenuItem_Click(object sender, EventArgs e)
{
string Id, Name;
Id = dataGridView1.SelectedCells[0].Value.ToString();
Name = dataGridView1.SelectedCells[1].Value.ToString();
string sql = "delete from Yy where Id='" + Id + "'and Name='" + Name + "'";
Dao1 dao = new Dao1();
MessageBox.Show("取消成功");
dao.Execute(sql);
}
private void 除账号ToolStripMenuItem_Click(object sender, EventArgs e)
{
string Name, Password;
Name = dataGridView1.SelectedCells[0].Value.ToString();
Password = dataGridView1.SelectedCells[1].Value.ToString();
string sql = "delete from YH where Name='" + Name + "'and Password='******'";
Dao1 dao = new Dao1();
MessageBox.Show("删除成功!");
dao.Execute(sql);
}
private void 除实验室ToolStripMenuItem_Click(object sender, EventArgs e)
{
string Sjd, Date, Id;
Date = dataGridView1.SelectedCells[0].Value.ToString();
Sjd = dataGridView1.SelectedCells[1].Value.ToString();
Id = dataGridView1.SelectedCells[2].Value.ToString();
string sql = "delete from class where Date='" + Date + "'and Sjd='" + Sjd + "'and Id='" + Id + "'";
Dao1 dao = new Dao1();
MessageBox.Show("删除成功");
dao.Execute(sql);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == null || textBox2.Text == null || comboBox1.Text == null)
{
MessageBox.Show("输入不完整，请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
string sql = "insert into class values('" + textBox1.Text + "','" + comboBox1.Text + "','" + textBox2.Text + "')";
Dao1 dao = new Dao1();
int i = dao.Execute(sql);
if (i > 0)
{
MessageBox.Show("添加成功！");
this.Hide();
}
}
