private void toolDeleteCTextBox_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要删除吗?", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { if (ControlId != 0) //旧的控件 { CommClass cc = new CommClass(); DataOperate dataOper = new DataOperate(); try { if (cc.IsExistConstraint("tb_BillTemplate", ControlId.ToString())) //对应的子表tb_BillText已生成外键数据,先删除外键记录 { if (MessageBox.Show("该输入框已生成快递单数据,若继续执行将删除与之相关的数据,是否继续执行?", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No) { return; //停止执行 } } if (dataOper.ExecDataBySql("Delete From tb_BillTemplate Where ControlId = '" + ControlId + "'") == 0) //从模板表中删除该控件对应的记录 { MessageBox.Show("删除失败!", "软件提示"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message, "软件提示"); return; } } this.Dispose(); MessageBox.Show("删除成功!", "软件提示"); } }
private void toolDelete_Click(object sender, EventArgs e) { if (dgvExpressBill.RowCount > 0) { if (MessageBox.Show("确定要删除吗?", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { m_ExpressBillCode = dgvExpressBill.CurrentRow.Cells[strExpressBillCodeColumn].Value.ToString(); string strSql = "Delete From tb_BillText Where BillTypeCode = '" + m_BillTypeCode + "' and ExpressBillCode = '" + m_ExpressBillCode + "'"; if (dataOper.ExecDataBySql(strSql) > 0) { dgvExpressBill.Rows.Remove(dgvExpressBill.CurrentRow); MessageBox.Show("删除成功!", "软件提示"); } else { MessageBox.Show("删除失败!", "软件提示"); } } } }