private void ChangeBtn2_Click(object sender, EventArgs e)
{
if (listView2.SelectedItems.Count == 0)
{
MessageBox.Show("请选择一行");
return;
}
Intent.State = "CHANGE";
DriverEdit de = new DriverEdit();
Driver d = new Driver();
d.SetValue(
listView2.SelectedItems[0].SubItems[0].Text,
listView2.SelectedItems[0].SubItems[1].Text,
listView2.SelectedItems[0].SubItems[2].Text,
listView2.SelectedItems[0].SubItems[3].Text,
listView2.SelectedItems[0].SubItems[4].Text,
listView2.SelectedItems[0].SubItems[5].Text
);
de.d = d;
Intent.OLD_ID = d.DNo;
if (de.ShowDialog() == DialogResult.OK)
{
sql = @"" +
" UPDATE [Driver]" +
" SET" +
" [DNo]='" + de.d.DNo + "'," +
" [DName]='" + de.d.DName + "'," +
" [Gender]='" + de.d.Gender + "'," +
" [Age]=" + de.d.Age + "," +
" [Phone]='" + de.d.Phone + "'," +
" [Password]='" + de.d.Password + "'" +
" WHERE [DNo]='" + Intent.OLD_ID + "'";
db.SetBySQL(sql);
UpdateListView();
}
}
/* Tab2所有功能 */
private void AddBtn2_Click(object sender, EventArgs e)
{
Intent.State = "ADD";
DriverEdit de = new DriverEdit();
if (de.ShowDialog() == DialogResult.OK)
{
sql = @"" +
" INSERT INTO [Driver]" +
" VALUES" +
" (" +
" '" + de.d.DNo + "'," +
" '" + de.d.DName + "'," +
" '" + de.d.Gender + "'," +
" " + de.d.Age + "," +
" '" + de.d.Phone + "'," +
" '" + de.d.Password + "'" +
" )";
db.SetBySQL(sql);
UpdateListView();
}
}