//课程列表更新 编辑后保存 private void dataGridView3_CellEndEdit(object sender, DataGridViewCellEventArgs e) { CourseModel couModelToBeUpdated = new CourseModel(); CourseBusiness couBusiness = new CourseBusiness(); couModelToBeUpdated.Cid = int.Parse(this.dataGridView3.CurrentRow.Cells["cid"].Value.ToString()); couModelToBeUpdated.Cname = this.dataGridView3.CurrentRow.Cells["cname"].Value.ToString(); couModelToBeUpdated.Credit = int.Parse(this.dataGridView3.CurrentRow.Cells["credit"].Value.ToString()); if (this.dataGridView3.CurrentCell.ColumnIndex == this.dataGridView3.Columns["pid"].Index) { couModelToBeUpdated.Pid = int.Parse(this.dataGridView3.CurrentRow.Cells["pid"].Value.ToString()); } else { couModelToBeUpdated.Pid = int.Parse(this.dataGridView3.CurrentRow.Cells["placeid"].Value.ToString()); } if (this.dataGridView3.CurrentCell.ColumnIndex == this.dataGridView3.Columns["ctid"].Index) { couModelToBeUpdated.Tid = int.Parse(this.dataGridView3.CurrentRow.Cells["ctid"].Value.ToString()); } else { couModelToBeUpdated.Tid = int.Parse(this.dataGridView3.CurrentRow.Cells["teacherid"].Value.ToString()); } switch (this.dataGridView3.CurrentRow.Cells["section"].Value.ToString()) { case "周一(1)": couModelToBeUpdated.Section = 1; break; case "周一(2)": couModelToBeUpdated.Section = 2; break; case "周一(3)": couModelToBeUpdated.Section = 3; break; case "周一(4)": couModelToBeUpdated.Section = 4; break; case "周一(5)": couModelToBeUpdated.Section = 5; break; case "周一(6)": couModelToBeUpdated.Section = 6; break; case "周二(1)": couModelToBeUpdated.Section = 7; break; case "周二(2)": couModelToBeUpdated.Section = 8; break; case "周二(3)": couModelToBeUpdated.Section = 9; break; case "周二(4)": couModelToBeUpdated.Section = 10; break; case "周二(5)": couModelToBeUpdated.Section = 11; break; case "周二(6)": couModelToBeUpdated.Section = 12; break; case "周三(1)": couModelToBeUpdated.Section = 13; break; case "周三(2)": couModelToBeUpdated.Section = 14; break; case "周三(3)": couModelToBeUpdated.Section = 15; break; case "周三(4)": couModelToBeUpdated.Section = 16; break; case "周三(5)": couModelToBeUpdated.Section = 17; break; case "周三(6)": couModelToBeUpdated.Section = 18; break; case "周四(1)": couModelToBeUpdated.Section = 19; break; case "周四(2)": couModelToBeUpdated.Section = 20; break; case "周四(3)": couModelToBeUpdated.Section = 21; break; case "周四(4)": couModelToBeUpdated.Section = 22; break; case "周四(5)": couModelToBeUpdated.Section = 23; break; case "周四(6)": couModelToBeUpdated.Section = 24; break; case "周五(1)": couModelToBeUpdated.Section = 25; break; case "周五(2)": couModelToBeUpdated.Section = 26; break; case "周五(3)": couModelToBeUpdated.Section = 27; break; case "周五(4)": couModelToBeUpdated.Section = 28; break; case "周五(5)": couModelToBeUpdated.Section = 29; break; case "周五(6)": couModelToBeUpdated.Section = 30; break; case "周六(1)": couModelToBeUpdated.Section = 31; break; case "周六(2)": couModelToBeUpdated.Section = 32; break; case "周六(3)": couModelToBeUpdated.Section = 33; break; case "周六(4)": couModelToBeUpdated.Section = 34; break; case "周六(5)": couModelToBeUpdated.Section = 35; break; case "周六(6)": couModelToBeUpdated.Section = 36; break; case "周日(1)": couModelToBeUpdated.Section = 37; break; case "周日(2)": couModelToBeUpdated.Section = 38; break; case "周日(3)": couModelToBeUpdated.Section = 39; break; case "周日(4)": couModelToBeUpdated.Section = 40; break; case "周日(5)": couModelToBeUpdated.Section = 41; break; case "周日(6)": couModelToBeUpdated.Section = 42; break; } //couModelToBeUpdated.Section = int.Parse(this.dataGridView3.CurrentRow.Cells["section"].Value.ToString()); if (this.dataGridView3.CurrentRow.Cells["week"].Value.ToString() == "1-16") { couModelToBeUpdated.Week = 1; } else if (this.dataGridView3.CurrentRow.Cells["week"].Value.ToString() == "1-8") { couModelToBeUpdated.Week = 2; } else { couModelToBeUpdated.Week = 3; } couModelToBeUpdated.Precourse = int.Parse(this.dataGridView3.CurrentRow.Cells["precourse"].Value.ToString()); couModelToBeUpdated.Maxstu = int.Parse(this.dataGridView3.CurrentRow.Cells["maxstu"].Value.ToString()); int result = couBusiness.updatecourse(couModelToBeUpdated); if (result != 0) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } }