/// <summary> /// 判断不同的单元格中不同控件的处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvBlackList_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvBlackList.Columns[e.ColumnIndex].Name == "buttonEdit") { DriverList driver = new DriverList(); driver.Id = dgvBlackList.CurrentRow.Cells[2].Value.ToString(); driver.User_ChineseName = dgvBlackList.CurrentRow.Cells[3].Value.ToString(); driver.User_EnglishName = dgvBlackList.CurrentRow.Cells[4].Value.ToString(); driver.Department_ChineseName = dgvBlackList.CurrentRow.Cells[5].Value.ToString(); driver.Department_EnglishName = dgvBlackList.CurrentRow.Cells[6].Value.ToString(); driver.Job = dgvBlackList.CurrentRow.Cells[7].Value.ToString(); driver.Sex = dgvBlackList.CurrentRow.Cells[8].Value.ToString(); driver.Birthdy = dgvBlackList.CurrentRow.Cells[9].Value.ToString(); driver.Identification_Type = dgvBlackList.CurrentRow.Cells[10].Value.ToString(); driver.Identification_Number = dgvBlackList.CurrentRow.Cells[11].Value.ToString(); driver.Employer = dgvBlackList.CurrentRow.Cells[12].Value.ToString(); driver.Telephone = dgvBlackList.CurrentRow.Cells[13].Value.ToString(); Form blackNameListEdit = new BlackNameListEdit(driver, this); blackNameListEdit.Show(); } if (dgvBlackList.Columns[e.ColumnIndex].Name == "btnDelete") { string getblacklistsql = "select ID ,User_ChineseName as 中文,User_EnglishName as 英文,Department_ChineseName as 单位名称中文,Department_EnglishName as 单位名称英文,Job as 职务,Sex as 性别,Birthdy as 出生日期,Identification_Type as 身份证件类型,Identification_Number as 身份证件号码,Employer as 工作单位,TELEPHONE as 联系方式 from TB_BlacakList "; if (MessageBox.Show("确定删除?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { int id = Convert.ToInt32(dgvBlackList.CurrentRow.Cells[2].Value.ToString()); string sql = "delete from TB_BlacakList where ID=" + id + ""; try { if (driverListBll.ExecuteSql(sql)) { MessageBox.Show("删除成功"); dgvBlackList.DataSource = driverListBll.FindAll_infos(getblacklistsql); dgvBlackList.Rows[0].Selected = false; } } catch (Exception ex) { throw; } } DataTable dtDriverList = driverListBll.FindAll_infos(getblacklistsql); dgvBlackList.DataSource = dtDriverList; } }
/// <summary> /// 判断不同的单元格中不同控件的处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvBlackList_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvBlackList.Columns[e.ColumnIndex].Name == "buttonEdit") { DriverList driver = new DriverList(); driver.Id = dgvBlackList.CurrentRow.Cells[2].Value.ToString(); driver.User_ChineseName = dgvBlackList.CurrentRow.Cells[3].Value.ToString(); driver.User_EnglishName = dgvBlackList.CurrentRow.Cells[4].Value.ToString(); driver.Department_ChineseName = dgvBlackList.CurrentRow.Cells[5].Value.ToString(); driver.Department_EnglishName = dgvBlackList.CurrentRow.Cells[6].Value.ToString(); driver.Job = dgvBlackList.CurrentRow.Cells[7].Value.ToString(); driver.Sex = dgvBlackList.CurrentRow.Cells[8].Value.ToString(); driver.Birthdy = dgvBlackList.CurrentRow.Cells[9].Value.ToString(); driver.Identification_Type = dgvBlackList.CurrentRow.Cells[10].Value.ToString(); driver.Identification_Number = dgvBlackList.CurrentRow.Cells[11].Value.ToString(); driver.Employer = dgvBlackList.CurrentRow.Cells[12].Value.ToString(); driver.Telephone = dgvBlackList.CurrentRow.Cells[13].Value.ToString(); Form blackNameListEdit = new BlackNameListEdit(driver,this); blackNameListEdit.Show(); } if (dgvBlackList.Columns[e.ColumnIndex].Name == "btnDelete") { string getblacklistsql = "select ID ,User_ChineseName as 中文,User_EnglishName as 英文,Department_ChineseName as 单位名称中文,Department_EnglishName as 单位名称英文,Job as 职务,Sex as 性别,Birthdy as 出生日期,Identification_Type as 身份证件类型,Identification_Number as 身份证件号码,Employer as 工作单位,TELEPHONE as 联系方式 from TB_BlacakList "; if (MessageBox.Show("确定删除?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { int id = Convert.ToInt32(dgvBlackList.CurrentRow.Cells[2].Value.ToString()); string sql = "delete from TB_BlacakList where ID=" + id + ""; try { if (driverListBll.ExecuteSql(sql)) { MessageBox.Show("删除成功"); dgvBlackList.DataSource = driverListBll.FindAll_infos(getblacklistsql); dgvBlackList.Rows[0].Selected = false; } } catch (Exception ex) { throw; } } DataTable dtDriverList = driverListBll.FindAll_infos(getblacklistsql); dgvBlackList.DataSource = dtDriverList; } }