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); } }
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 save_Click(object sender, EventArgs e) { user_x ux1 = new user_x(username, "添加", "台账"); sql_sel s1 = new sql_sel(); ux1.insert_log(mincheng.Text); MessageBox.Show("添加了" + s1.insert_only("B台账", dbo(), values()) + "条数据!台账里有" + img_add() + "张图片," + shiyitu_add() + "示意图!", "提示", MessageBoxButtons.OK); ID.Text = Convert.ToString(int.Parse(ID.Text) + 1); }
private void main_Load(object sender, EventArgs e) { login1(); Text = "远望谷—客服中心管理平台。" + username + ",欢迎您!"; caozuo_list(); time(); user_x ux = new user_x(username); mean.Visible = false; if (int.Parse(ux.dengji()) > 1) { mean.Visible = true; } }
private void tjwhjl_Click(object sender, EventArgs e) { sql_sel s2 = new sql_sel(); if (ID1 != null) { user_x ux1 = new user_x(username, "添加", "维护记录"); ux1.insert_log(mincheng.Text); MessageBox.Show("向" + ID1 + "号台账" + mincheng.Text + "添加了" + s2.insert_only("B维护记录", lie(), zhi()) + "条维护记录!", username + ",维护记录添加成功!", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有选择需要添加维护记录的台账!", username + ",维护记录添加失败!", 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 tjwhjl_Click(object sender, EventArgs e) { sql_sel s2 = new sql_sel(); if (wh_id != null) { user_x ux1 = new user_x(username, "修改", "维护记录"); if (ux1.sy() > 0) { ux1.insert_log(mincheng.Text); MessageBox.Show("修改了台账" + mincheng.Text + "的" + s2.update_only("B维护记录", lie(), zhi(), "R序号", wh_id) + "条维护记录!", username + ",维护记录修改成功!", MessageBoxButtons.OK, MessageBoxIcon.Information); b1 = true; } else { ux1.cw_message(); } } else { MessageBox.Show("没有选择需要修改的维护记录!", username + ",维护记录修改失败!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }