private void buttonX1_Click(object sender, EventArgs e) { if (MessageBox.Show("你确定要执行重置操作?这将会删除除“教师信息”外的所有数据!", "警告!!!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { try { SqlHelper help = new SqlHelper(); help.delete("Logs_Data", ""); help.delete("Placement_Data", ""); help.delete("SpareTime_Data", ""); help.delete("Classes_Data", ""); help.delete("Conf", ""); Main.fm.flashListview(); MessageBox.Show("操作成功"); } catch { MessageBox.Show("操作失败"); } } }
private void buttonX2_Click(object sender, EventArgs e) { if (listView1.CheckedItems.Count != 0) { SqlHelper help = new SqlHelper(); string condition = " where " + "Teacher='" + listView1.CheckedItems[0].SubItems[1].Text + "'"; if (help.delete("Teachers_Data", condition) > 0) { MessageBox.Show("删除成功"); } else { MessageBox.Show("删除失败"); } listView1.Items.Clear(); setTbEnable(); clear_listview(); totalpage = pageshow.totalpage("select * from Teachers_Data", pagesize, "Teachers_Data"); labPageAll.Text = totalpage + ""; textBoxNow.Text = currentpage.ToString(); DataTable dt = pageshow.ListviewShow("select * from Teachers_Data", currentpage, pagesize, "Teachers_Data"); UIShow show = new UIShow(); show.teachers_listview_write(dt, listView1); groupBox1.SendToBack(); } }
private void buttonX2_Click(object sender, EventArgs e) { if (MessageBox.Show("你确定要执行删除操作?这将会删除当前的所有数据!", "警告!!!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { try { SqlHelper help = new SqlHelper(); help.delete("Classes_Data", " "); frmPlan_Load(sender, e); } catch (Exception) { } } }