/* ###################### 要求三 ###################### */
private void AddBtn_Click(object sender, EventArgs e)
{
Intent.STATE = "ADD";
StudentEdit se = new StudentEdit();
if (se.ShowDialog() == DialogResult.OK)
{
Student s = se.s;
sql = @"" +
" INSERT INTO [Student]" +
" VALUES" +
" ('" + s.SNo + "', '" + s.SName + "','" + s.Date + "', '" + s.classNo + "')";
db.SetBySQL(sql);
}
UpdateListView();
}
private void ChangeBtn_Click(object sender, EventArgs e)
{
Intent.STATE = "CHANGE";
if (listView3.SelectedItems.Count == 0)
{
MessageBox.Show("请选择一行");
return;
}
Student s = new Student();
s.SetValue(
listView3.SelectedItems[0].SubItems[0].Text,
listView3.SelectedItems[0].SubItems[1].Text,
listView3.SelectedItems[0].SubItems[2].Text,
listView3.SelectedItems[0].SubItems[3].Text
);
StudentEdit se = new StudentEdit();
se.s = s;
Intent.OLD_ID = s.SNo;
if (se.ShowDialog() == DialogResult.OK)
{
sql = @"" +
" UPDATE [Student]" +
" SET" +
" [Sno]='" + s.SNo + "'," +
" [SName]='" + s.SName + "'," +
" [Date]='" + s.Date + "'," +
" [classNo]='" + s.classNo + "'" +
" WHERE [Sno]='" + Intent.OLD_ID.ToString() + "'";
db.SetBySQL(sql);
}
UpdateListView();
}