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