private void btn_delete_Click(object sender, EventArgs e) { for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { if (this.dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { if (this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "未下达") { //删除周计划 deletePlan d = new deletePlan(this.dataGridView1.Rows[i].Cells["ID"].Value.ToString(), "周"); bool b = d.doDelete(); if (b) { MessageBox.Show("删除周计划成功!", "提示"); this.dataGridView1.Rows.RemoveAt(i); updateDataGridView(); } else { MessageBox.Show("删除周计划失败!", "提示"); } } } else { MessageBox.Show("该周计划不可删除!", "提示"); } } }
private void btn_delete_Click(object sender, EventArgs e) { for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { if (this.dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { if (this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "未下达") { //删除年计划 deletePlan d = new deletePlan(this.dataGridView1.Rows[i].Cells["ID"].Value.ToString(), "年"); bool b = d.doDelete(); //得到对应月计划ID,删除对应月计划 String qStr = "select ID from MonthPlanning where planID = '" + this.dataGridView1.Rows[i].Cells["ID"].Value.ToString() + "'"; SQLquery query = new SQLquery(qStr); DataTable dt = query.doSelect(); if (dt != null) { for (int j = 0; j < dt.Rows.Count; j++) { //得到对应周计划ID,删除对应周计划 String qStr1 = "select ID from WeekPlanning where planID = '" + dt.Rows[j][0].ToString() + "'"; SQLquery query1 = new SQLquery(qStr1); DataTable dt1 = query1.doSelect(); if (dt1 != null) { for (int k = 0; k < dt1.Rows.Count; k++) { deletePlan d1 = new deletePlan(dt1.Rows[k][0].ToString(), "周"); d1.doDelete(); } } deletePlan d2 = new deletePlan(dt.Rows[j][0].ToString(), "月"); d2.doDelete(); } } if (b) { MessageBox.Show("删除年计划成功!", "提示"); this.dataGridView1.Rows.RemoveAt(i); updateDataGridView(); } else { MessageBox.Show("删除年计划失败!", "提示"); } } else { MessageBox.Show("该年计划不可删除!", "提示"); } } } }
private void btn_delete_Click(object sender, EventArgs e) { for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { if (this.dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { if (this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "新增" || this.dataGridView1.Rows[i].Cells[7].Value.ToString() == "不通过") { if (this.usrKind != "业务员") { MessageBox.Show("用户权限不够!", "提示"); return; } //删除月计划 deletePlan d = new deletePlan(this.dataGridView1.Rows[i].Cells["ID"].Value.ToString(), "月"); bool b = d.doDelete(); //得到对应周计划ID,删除对应周计划 String qStr = "select ID from WeekPlanning where planID = '" + this.dataGridView1.Rows[i].Cells["ID"].Value.ToString() + "'"; SQLquery query = new SQLquery(qStr); DataTable dt = query.doSelect(); if (dt != null) { for (int j = 0; j < dt.Rows.Count; j++) { deletePlan d2 = new deletePlan(dt.Rows[j][0].ToString(), "周"); d2.doDelete(); } } if (b) { MessageBox.Show("删除月计划成功!", "提示"); this.dataGridView1.Rows.RemoveAt(i); updateDataGridView(); } else { MessageBox.Show("删除月计划失败!", "提示"); } } else { MessageBox.Show("该月计划不可删除!", "提示"); } } } }