private void FrmOperation_Load(object sender, EventArgs e)
{
this.Focus();
CmpSetDgv();
dgvOperationlog.DataSource = OperationDao.SelectOperationlogAll();
spOperationlog.DataSource = SpendDao.SelectSpendOperation();
}
private void btnClear_Click(object sender, EventArgs e)
{
string sql = "delete from operationlog";
int n = DBHelper.ExecuteNonQuery(sql);
if (n > 0)
{
MessageBox.Show("删除日志成功", "删除提示");
dgvOperationlog.DataSource = OperationDao.SelectOperationlogAll();
}
else
{
MessageBox.Show("删除日志失败", "错误提示");
}
}
private void dgvOperationlog_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == this.dgvOperationlog.Columns["columnDelete"].Index)
{
//判断列索引是不是删除按钮
int rows = dgvOperationlog.CurrentRow.Index; //得到当前行的索引
int operationId = (int)(dgvOperationlog.Rows[rows].Cells[1].Value);
if (operationId != 0 && MessageBox.Show("您确定要删除吗？", "重要提示！", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.OK)
{
string sql = "delete from operationlog where OperationId='" + operationId + "'";
int n = DBHelper.ExecuteNonQuery(sql);
if (n > 0)
{
MessageBox.Show("删除日志成功", "删除提示");
dgvOperationlog.DataSource = OperationDao.SelectOperationlogAll();
}
else
{
MessageBox.Show("删除日志失败", "错误提示");
}
}
}
}
public static List <OperationLog> SelectOperationlogAll()
{
return(OperationDao.SelectOperationlogAll());
}
public static int InsertOperationLog(OperationLog opr)
{
return(OperationDao.InsertOperationLog(opr));
}
