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("该月计划不可删除！", "提示");
}
}
}
}
