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