/* * 借阅信息的删除 */ private void btn_DelBorr_Click(object sender, EventArgs e) { string bkNum = null; string usrName = null; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { bkNum = dataGridView1.Rows[i].Cells[1].Value.ToString(); usrName = dataGridView1.Rows[i].Cells[2].Value.ToString(); } } Opertion bean = new Opertion(); Boolean ok = bean.BorrowDelete(bkNum, usrName); if (ok) { MessageBox.Show("dalete success!"); SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from Borrow"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); } else { MessageBox.Show("error!"); } //this.dataGridView1.Update(); //this.btn_ReadAllBorrow_Click(this.SendToBack, this.Events); }
/* * 首先获取图书的信息,然后还书就是删除借书表的记录(这里需要书号,借阅人),然后改变图书的借出状态(书号) */ private void btn_backBook_Click(object sender, EventArgs e) { int flag = 0; string bkNum = null; string usrName = null; //获取图书的信息 for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { bkNum = dataGridView1.Rows[i].Cells[1].Value.ToString(); usrName = dataGridView1.Rows[i].Cells[2].Value.ToString(); } } Opertion bean = new Opertion(); Boolean ok1 = bean.BorrowDelete(bkNum, usrName); if (ok1)//如果记录删除成功 { flag = 1; //MessageBox.Show("delete success !"); Boolean ok2 = bean.BkBuffUpdate(bkNum); if (ok2) { flag = 1; } else { flag = 0; } } else { flag = 0; } if (1 == flag) { MessageBox.Show("还书成功"); } else { MessageBox.Show("failed!"); } SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from Borrow"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); }