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("删除成功!", "软件提示");
     }
 }
Beispiel #2
0
 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("删除失败!", "软件提示");
             }
         }
     }
 }