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);
}
}
