private void tbDeleteAll_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 0)
{
MessageBox.Show("请选择记录！");
return;
}
if (MessageBox.Show(this, "是否删除此记录", "请确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = this.dataGridView1.SelectedRows.Count; i > 0; i--)
{
int ID = Convert.ToInt32(dataGridView1.SelectedRows[i - 1].Cells[0].Value);
dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[i - 1].Index);
//使用获得的ID删除数据库的数据
string SQL1 = "delete from Student where ID=" + ID.ToString() + ";";
string sql2 = "delete from Teaching where StuID=" + ID.ToString() + ";";
DBControl ADB = new DBControl();
ADB.linkUpdate(sql2);
ADB.linkUpdate(SQL1);
ADB.Close();
}
}
}
//添加教师表
private void btAddTeacher_Click(object sender, EventArgs e)
{
if (tbTCollege.Text != null && tbTID.Text != null && tbTName.Text != null)
{
DBControl ADB = new DBControl();
ADB.linkUpdate("insert into Teacher(ID,Name,College,Password) values(" + tbTID.Text + ",'" + tbTName.Text + "','" + tbTCollege.Text + "'," + tbTID.Text + ");");
MessageBox.Show("更新成功！");
ADB.Close();
tbTCollege.Clear();
tbTID.Clear();
tbTName.Clear();
}
else
{
MessageBox.Show("您的数据输入不完整，请检查您的数据！");
}
}
//添加数据至课程表
private void btAddCourse_Click(object sender, EventArgs e)
{
if (tbCID.Text != null && tbCName.Text != null && tbCCredit.Text != null)
{
DBControl ADB = new DBControl();
ADB.linkUpdate("insert into Course(ID,Name,Credit,Remarks) values(" + tbCID.Text + ",'" + tbCName.Text + "'," + tbCCredit.Text + ",'" + tbCRemarks.Text + "');");
MessageBox.Show("更新成功！");
ADB.Close();
tbCID.Clear();
tbCName.Clear();
tbCCredit.Clear();
tbCRemarks.Clear();
}
else
{
MessageBox.Show("您的数据输入不完整，请检查您的数据！");
}
}
//更新学生表
private void btAddStudent_Click(object sender, EventArgs e)
{
if (tbSID.Text != null && tbSMajor.Text != null && tbSClass.Text != null && tbSCollege.Text != null && tbSName.Text != null && cbSSex.SelectedItem != null)
{
DBControl ADB = new DBControl();
ADB.linkUpdate("insert into Student(ID,Name,Sex,College,Class,Major,Password) values(" + tbSID.Text + ",'" + tbSName.Text + "','" + cbSSex.SelectedItem.ToString() + "','" + tbSCollege.Text + "','" + tbSClass.Text + "','" + tbSMajor.Text + "'," + tbSID.Text + ");");
MessageBox.Show("更新成功！");
ADB.Close();
tbSID.Clear();
tbSMajor.Clear();
tbSClass.Clear();
tbSCollege.Clear();;
tbSName.Clear();
}
else
{
MessageBox.Show("您的数据输入不完整，请检查您的数据！");
}
}
//添加教学计划
private void btAddTeaching_Click(object sender, EventArgs e)
{
if (tbTeachTime.Text != null && tbClassroom.Text != null && cbSID.SelectedItem != null && cbTID.SelectedItem != null && cbCID.SelectedItem != null)
{
int sid = 0;
int tid = 0;
int cid = 0;
DBControl ADB = new DBControl();
SqlDataReader gSID = ADB.linkQuery("select ID from Student where Name='" + cbSID.SelectedItem.ToString() + "';");
if (gSID.Read())
{
sid = gSID.GetInt32(0);
}
gSID.Close();
SqlDataReader gTID = ADB.linkQuery("select ID from Teacher where Name='" + cbTID.SelectedItem.ToString() + "';");
if (gTID.Read())
{
tid = gTID.GetInt32(0);
}
gTID.Close();
SqlDataReader gCID = ADB.linkQuery("select ID from Course where Name='" + cbCID.SelectedItem.ToString() + "';");
if (gCID.Read())
{
cid = gCID.GetInt32(0);
}
gCID.Close();
//MessageBox.Show(sid.ToString()+"**"+tid.ToString()+"$$"+cid.ToString());
ADB.linkUpdate("insert into Teaching(StuID,TeachID,CourseID,Classroom,TeachTime,Remarks) values(" + sid.ToString() + "," + tid.ToString() + "," + cid.ToString() + ",'" + tbClassroom.Text + "','" + tbTeachTime.Text + "','" + tbRemarks.Text + "')");
MessageBox.Show("更新成功");
ADB.Close();
tbTeachTime.Clear();
tbClassroom.Clear();
tbRemarks.Clear();
}
else
{
MessageBox.Show("您的数据输入不完整，请检查您的数据！");
}
}
//更改密码
private void btUpdatePWD_Click(object sender, EventArgs e)
{
if (tbThisPWD.Text != null && tbForePWD.Text != null && tbCheckPWD.Text != null)
{
DBControl ADB = new DBControl();
SqlDataReader gForePWD = ADB.linkQuery("select Password from Admin where [ID]=" + id + ";");
gForePWD.Read();
String forePWD = gForePWD.GetString(0);
gForePWD.Close();
//MessageBox.Show(gForePWD.GetString(0));
if (tbThisPWD.Text.Equals(tbCheckPWD.Text))
{
if (tbThisPWD.Text.Equals(forePWD))
{
MessageBox.Show("不能与原密码相同！");
}
else
{
ADB.linkUpdate("update Admin set [Password]='" + tbThisPWD.Text + "' where [ID]=" + id + ";");
MessageBox.Show("更改成功！");
}
}
else
{
MessageBox.Show("密码确认框输入不一致！");
}
ADB.Close();
}
else
{
MessageBox.Show("您的数据输入不完整，请检查您的数据！");
}
tbForePWD.Clear();
tbThisPWD.Clear();
tbCheckPWD.Clear();
}
private void btSUpdatePWD_Click(object sender, EventArgs e)
{
DBControl ADB = new DBControl();
SqlDataReader gForePWD = ADB.linkQuery("select Password from Student where [ID]=" + id + ";");
gForePWD.Read();
String forePWD = gForePWD.GetString(0);
gForePWD.Close();
//MessageBox.Show(forePWD + "\n" + tbForePWD.Text);
if (tbNewPWD.Text.Equals(tbCheckPWD.Text))
{
if (tbForePWD.Text.Trim().Equals(forePWD))
{
if (tbNewPWD.Text.Equals(tbForePWD.Text))
{
MessageBox.Show("不能与原密码相同！");
}
else
{
ADB.linkUpdate("update Student set [Password]='" + tbNewPWD.Text + "' where [ID]=" + id + ";");
MessageBox.Show("更改成功！");
}
}
else
{
MessageBox.Show("请正确输入原密码！");
}
}
else
{
MessageBox.Show("密码确认框输入不一致！");
}
ADB.Close();
}
