private void delete_toolStripMenuItem_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("确认删除选中的缴费记录吗?删除后数据不可恢复,请谨慎操作。", "消息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } VerificationForm form = new VerificationForm(); form.ShowDialog(); if (!form.Result) { return; } int[] selectRows = gridView1.GetSelectedRows(); int[] rowsID = new int[selectRows.Length]; for (int i = 0; i < selectRows.Length; i++) { rowsID[i] = (gridView1.GetRow(selectRows[i]) as PayRecordInfo).ID; } int result = SQLiteControl.RealyDelete("PayRecordTable", "ID", rowsID); if (result <= 0) { XtraMessageBox.Show("删除选中的缴费记录失败", "消息", MessageBoxButtons.YesNo, MessageBoxIcon.Error); return; } Query(); }
/// <summary> /// 真正的删除 /// </summary> /// <param name="IDs"></param> /// <returns></returns> public static int RealyDelete(int[] IDs) { //删除GroupClassTable的内容 int result = SQLiteControl.RealyDelete("GroupClassTable", "ID", IDs); //删除关联的StudentsCheckinTable内容 if (result > 0) { result = SQLiteControl.RealyDelete("StudentsCheckinTable", "GroupID", IDs); } return(result); }
/// <summary> /// 批量删除(彻底从数据库移除) /// </summary> /// <param name="ID"></param> /// <returns></returns> public static int RealyDelete(int[] IDs) { return(SQLiteControl.RealyDelete("StudentsTable", "ID", IDs)); }