//点击datagridview里的单元格发生 private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { //点击删除按钮 if (e.ColumnIndex == 0 && e.RowIndex > -1) //如果是点击的是内容而不是列名之类的 { int row = e.RowIndex; //点击单元格的行索引 string id = dataGridView1.Rows[row].Cells["编号"].Value.ToString(); OvertimeBll ob = new OvertimeBll(); var result = MessageBox.Show("删除后不可恢复,确定?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (result == DialogResult.OK) { ob.DeleteById(id); dataGridView1.DataSource = ob.QueryByEmpIdUsingDateSet(this.Tag.ToString()).Tables[0]; return; } else { return; } } //////////////////////////////////////////////////////////// //点击更新按钮 else if (e.ColumnIndex == 1 && e.RowIndex > -1) { int row = e.RowIndex; string id = dataGridView1.Rows[row].Cells["编号"].Value.ToString(); //该员工的员工号 string tag = this.Tag.ToString(); string proName = dataGridView1.Rows[row].Cells["项目名"].Value.ToString(); //该员工需加班的项目名 string date = dataGridView1.Rows[row].Cells["开始时间"].Value.ToString(); //加班开始时间 FrmOvertimeAddOrUpdate frmot = new FrmOvertimeAddOrUpdate(tag + " " + id + " " + proName + " " + date); frmot.ShowDialog(); var res = frmot.DialogResult; if (res == DialogResult.OK) { OvertimeBll ob = new OvertimeBll(); dataGridView1.DataSource = ob.QueryByEmpIdUsingDateSet(this.Tag.ToString()).Tables[0]; return; } } else if (e.RowIndex > -1) { //设置点击任意单元格其一行内所有单元格高亮 int hang = e.RowIndex; //dataGridView1.Rows[hang].Cells[0].Selected = true; //dataGridView1.Rows[hang].Cells[1].Selected = true; dataGridView1.Rows[hang].Cells[2].Selected = true; dataGridView1.Rows[hang].Cells[3].Selected = true; dataGridView1.Rows[hang].Cells[4].Selected = true; dataGridView1.Rows[hang].Cells[5].Selected = true; dataGridView1.Rows[hang].Cells[6].Selected = true; dataGridView1.Rows[hang].Cells[7].Selected = true; dataGridView1.Rows[hang].Cells[8].Selected = true; dataGridView1.Rows[hang].Cells[9].Selected = true; return; } }
//点击添加按钮 private void btnAdd_Click(object sender, EventArgs e) { FrmOvertimeAddOrUpdate overtime = new FrmOvertimeAddOrUpdate(this.Tag.ToString(), "添加"); overtime.ShowDialog(); //点击添加按钮,弹出添加页面 if (overtime.DialogResult == System.Windows.Forms.DialogResult.OK) //如果添加成功,刷新页面 { OvertimeBll ob = new OvertimeBll(); var datas = ob.QueryByEmpIdUsingDateSet(this.Tag.ToString()).Tables[0]; if (datas != null) { dataGridView1.DataSource = datas; } } }