private void btn_v_update_Click(object sender, EventArgs e) { //没有在DataGridView中选中项目 if (dgvvideo.SelectedRows.Count <= 0) { MessageBox.Show("当前没有选择项目,请选择一个项目进行更新!", "基于虚拟现实的铁路综合运输训练系统", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //在DataGridView中选中两个或两个以上题目 if (dgvvideo.SelectedRows.Count > 1) { MessageBox.Show("无法同时对多个项目进行更新操作,请选择一个项目进行更新!", "基于虚拟现实的铁路综合运输训练系统", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //根据DataGridView选中项,生成一个Video类的实例 Video video = new Video(); DataGridViewRow currentRow = dgvvideo.Rows[dgvvideo.SelectedRows[0].Index]; video.id = Convert.ToInt32(currentRow.Cells[0].Value); video.name = currentRow.Cells[1].Value.ToString(); video.major = currentRow.Cells[5].Value.ToString(); DBHelper db = new DBHelper(); string sql = "select startTime,endTime,fileName from game_questions where id=" + video.id; try { DbCommand cmd = db.GetSqlStringCommand(sql); using (DbDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { video.startTime = float.Parse(reader["startTime"].ToString()); video.endTime = float.Parse(reader["endTime"].ToString()); video.url = reader["fileName"].ToString(); } } } catch (Exception ex) { throw ex; } v_dialog = new VideoEditedFrom(); //设置对话框的题目数据 v_dialog.video = video; //显示对话框 if (v_dialog.ShowDialog() == DialogResult.OK) { //更新题目信息 if (update_video(v_dialog.video) <= 0) { return; } show_video(); } }
private void btn_v_Add_Click(object sender, EventArgs e) { v_dialog = new VideoEditedFrom(); //清空题目信息对话框的数据 v_dialog.video = null; //如果在对话框中选择了“确定”,则根据输入信息添加 if (v_dialog.ShowDialog() == DialogResult.OK) { if (add_video(v_dialog.video) <= 0) { return; } show_video(); } }
private void loadVideoEditedFrom() { VideoEditedFrom video = new VideoEditedFrom(); video.ShowDialog(); }