private void lvTeacher_DoubleClick(object sender, EventArgs e)
{
if (this.IsAdd)
{
MessageBox.Show("尚未添加完成");
return;
}
else if (this.IsEdit)
{
MessageBox.Show("尚未编辑完成");
return;
}
//MessageBox.Show(this.lvTeacher.SelectedItems[0].Text);
int clickTeacherIndex = this.lvTeacher.SelectedIndices[0];
string clickTeacherID = this.TeacherList[clickTeacherIndex].Id;
TeacherTeachCourse teacherTeachCourse = new TeacherTeachCourse();
teacherTeachCourse.Id = Guid.NewGuid().ToString("N");
teacherTeachCourse.Create = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
teacherTeachCourse.Modify = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
teacherTeachCourse.UkTeacherId = clickTeacherID;
teacherTeachCourse.UkCourseId = this.currentCourseID;
this.ITeacherFormReq.AddOneTeacherForCourse(teacherTeachCourse);
this.TeacherSelList.Add(this.TeacherList[clickTeacherIndex]);
this.lvTeacherSel.Items.Add(this.TeacherSelList.Last().Name);
this.TeacherList.RemoveAt(clickTeacherIndex);
this.lvTeacher.Items.RemoveAt(clickTeacherIndex);
}
public void AddOneTeacherForCourse(TeacherTeachCourse ttc)
{
string insertSql = "INSERT INTO teacher_teach_course (teacher_teach_course.id,teacher_teach_course.utc8_create, teacher_teach_course.utc8_modify, teacher_teach_course.uk_course_id, teacher_teach_course.uk_teacher_id, teacher_teach_course.other)VALUES (@id,@create,@modife,@courseId,@teacherId,@other)";
MySqlConnection mySqlConnection = new MySqlConnection(Model.MySqlHelper.Conn);
mySqlConnection.Open();
Model.MySqlHelper.ExecuteNonQuery(mySqlConnection, CommandType.Text, insertSql,
new MySqlParameter("@id", ttc.Id),
new MySqlParameter("@create", ttc.Create),
new MySqlParameter("@modife", ttc.Modify),
new MySqlParameter("@courseId", ttc.UkCourseId),
new MySqlParameter("@teacherId", ttc.UkTeacherId),
new MySqlParameter("@other", ttc.Other));
mySqlConnection.Close();
}
