public bool del(string ID1) { bool a = false; if (ID1 != null & ID1 != "") { user_x ux1 = new user_x(username, "删除", "台账"); if (ux1.sy() > 0) { sql_sel sqq1 = new sql_sel(); DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除台账: " + sqq1.select_only("B台账", "R名称", "R序号", ID1) + " 吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { ux1.insert_log(ux1.TZ_name(ID1)); MessageBox.Show("删除了编号为:" + ID1 + "的" + sqq1.delete_only("B台账", "R序号", ID1) + "个台账,台账的" + sqq1.delete_only("B示意图", "R所属台账编号", ID1) + "张示意图和" + sqq1.delete_only("B图片", "R所属台账序号", ID1) + "张图片也被同时删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); sqq1.delete_only("B维护记录", "R所属台账编号", ID1); a = true; } } else { ux1.cw_message(); } } else { MessageBox.Show("未选择台账!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); a = false; } return(a); }
private void del_whjl_Click(object sender, EventArgs e) { if (wh_id != null) { user_x ux1 = new user_x(username, "删除", "维护记录"); if (ux1.sy() > 0) { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除台账 " + mincheng.Text + " 的维护记录" + whxm.Text + "吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { sql_sel sqq1 = new sql_sel(); ux1.insert_log(mincheng.Text); MessageBox.Show("删除了台账 " + mincheng.Text + " 的" + sqq1.delete_only("B维护记录", "R序号", wh_id) + "条维护记录" + whxm.Text + " !", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); b1 = true; Close(); } } else { ux1.cw_message(); } } else { MessageBox.Show("未选择台账!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void zhiwei_del(string select_zhiwei) { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除职位: " + select_zhiwei + " 吗?", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (select_zhiwei != null & select_zhiwei != "") { sql_sel s1 = new sql_sel(); if (s1.delete_only("B职位", "R职位", select_zhiwei) == 1) { MessageBox.Show("删除" + select_zhiwei + "成功!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); zhiwei_load(); } else { MessageBox.Show("删除" + select_zhiwei + "失败,请重试!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("未选择要删除的职位!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
void del(string select_name) { if (select_name == username) { MessageBox.Show("你不能删除自己!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { DialogResult dr; dr = MessageBox.Show(username + "您好!您确定要删除用户: " + select_name + " 吗?删除后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (select_name != null & select_name != "") { sql_sel s1 = new sql_sel(); if (s1.delete_only("B用户", "R姓名", select_name) == 1) { MessageBox.Show("删除" + select_name + "成功!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); user_load(); } else { MessageBox.Show("删除" + select_name + "失败,请重试!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("未选择要删除的用户!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
private void save_Click(object sender, EventArgs e) { user_x ux1 = new user_x(username, "修改", "台账"); if (ux1.sy() > 0) { DialogResult dr; dr = MessageBox.Show("你确定要修改台账吗?修改后不可恢复!!!", "警告!!!", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { sql_sel sq1 = new sql_sel(); ux1.insert_log(mincheng.Text); sq1.delete_only("B图片", "R所属台账序号", ID1); sq1.delete_only("B示意图", "R所属台账编号", ID1); MessageBox.Show("修改了" + sq1.update_only("B台账", dbo(), values(), "R序号", ID1) + "条数据!台账里有" + img_add() + "张图片," + shiyitu_add() + "示意图!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { ux1.cw_message(); } }
private void del_cg_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); MessageBox.Show("成功删除型号 " + cg_list.SelectedItem.ToString() + " " + s1.delete_only("B设备型号", "R型号", cg_list.SelectedItem.ToString()) + "个磁钢型号!", "添加成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("没有选择要删除的型号!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void zt_del_Click(object sender, EventArgs e) { try { sql_sel s1 = new sql_sel(); MessageBox.Show("成功删除型号 " + zt_list.SelectedItem.ToString() + " " + s1.delete_only("B安装状态", "R安装状态", zt_list.SelectedItem.ToString()) + "个安装状态型号!", "删除成功", MessageBoxButtons.OK, MessageBoxIcon.Information); load(); } catch { MessageBox.Show("没有选择要删除的项目!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); } }