private void btnOK_Click(object sender, EventArgs e) { if (t != null) { t.BookTypeName = textBox1.Text.Trim(); if (aa.booktype.updateBookType(t) > 0) { aa.dataGridView1.DataSource = aa.booktype.selectBookType1().Tables[0]; //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(t.BookTypeId.ToString(), aa.dataGridView1); } else { MessageBox.Show("修改失败!"); } } if (r != null) { r.ReaderTypeName = textBox1.Text.Trim(); if (aa.readerType_bll.updateReaderType(r) > 0) { aa.dataGridView2.DataSource = aa.readerType_bll.selectReaderType1().Tables[0]; //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(r.ReaderTypeId.ToString(), aa.dataGridView2); } else { MessageBox.Show("修改失败!"); } } if (d != null) { d.DepartmentName = textBox1.Text.Trim(); if (aa.department_bll.updateDepartment(d) > 0) { aa.dataGridView3.DataSource = aa.department_bll.selectDepartment1().Tables[0]; //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(d.DepartmentId.ToString(), aa.dataGridView3); } else { MessageBox.Show("修改失败!"); } } if (c != null) { c.ClassName = textBox1.Text.Trim(); if (aa.class_bll.updateClass(c) > 0) { aa.dataGridView4.DataSource = aa.class_bll.selectClass1().Tables[0]; //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(c.ClassId.ToString(), aa.dataGridView4); } else { MessageBox.Show("修改失败!"); } } this.Close(); }
private void dgvBorrowed_CellContentClick(object sender, DataGridViewCellEventArgs e) { int BorrowReturnId = -1; try { //选中行的借阅编号 BorrowReturnId = (int)dgvBorrowed.Rows[e.RowIndex].Cells[0].Value; } catch (Exception) { } //DataGridView的总列数 int rows = dgvBorrowed.Columns.Count; if (e.ColumnIndex == rows - 2)//修改 { DialogResult result = MessageBox.Show("确定续借吗?", "提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { BorrowReturn b = new BorrowReturn(); b.BorrowId = BorrowReturnId; if (borrowReturn_bll.RenewBook(b) > 0) { MessageBox.Show("续借成功!"); dgvReaderInfo_DataSourceChanged(null, null); autocoumns.AutoFindRow(b.BorrowId, dgvBorrowed); } else { MessageBox.Show("续借失败!"); } } } else if (e.ColumnIndex == rows - 1)//还书 { DialogResult result = MessageBox.Show("确定还书吗?", "提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { if (borrowReturn_bll.ReturnBook(BorrowReturnId) > 0) { dgvReaderInfo_DataSourceChanged(null, null); MessageBox.Show("还书成功!"); txtBookId_TextChanged(null, null); } else { MessageBox.Show("还书失败!"); } } } }
private void btnUpdate_Click(object sender, EventArgs e) { Reader r = new Reader(); r.ReaderId = txtReaderId.Text.Trim(); r.ReaderName = txtReaderName.Text.Trim(); r.TimeIn = dtTimeIn.Value; r.TimeOut = dtTimeOut.Value; r.ReaderTypeId = (int)cboReaderType.SelectedValue; r.DepartmentId = (int)cboDepartment.SelectedValue; r.ClassId = (int)cboClass.SelectedValue; r.IdentityCard = txtIdentityCard.Text.Trim(); r.Gender = txtGender.Text.Trim(); if (reader_bll.updateReader(r) > 0) { MessageBox.Show("修改成功!"); //单价查询 reader.btnSelect_Click(null, null); //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(txtReaderId.Text.Trim(), reader.dgvHeaderInfo); } else { MessageBox.Show("修改失败!"); } }
/// <summary> /// 保存修改信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { // 创建添加的对象 BookInfo book = new BookInfo(); book.BookId = txtBookId.Text.Trim(); book.BookName = txtBookName.Text.Trim(); book.TimeIn = TimeIn.Value; book.BookTypeId = (int)cboBookTypeId.SelectedValue; book.Author = txtAuthor.Text.Trim(); book.PinYinCode = txtPinYinCode.Text.Trim(); book.Translator = txtTranslator.Text.Trim(); book.Language = txtLanguge.Text.Trim(); book.BookNumber = txtBookNumber.Text.Trim(); book.Price = txtPrice.Text.Trim(); book.Layout = txtLayout.Text.Trim(); book.Address = txtAddress.Text.Trim(); book.ISBS = txtISBS.Text.Trim(); book.Versions = txtVersions.Text.Trim(); book.BookRemark = txtBookRemark.Text.Trim(); if (bookInfo.ExitBookInfo(book) > 0) { MessageBox.Show("修改信息成功!"); // 单击查询 manager.btnSelect_Click(null, null); // 自动找到刚刚修改成功的行,并选中 com.AutoFindRow(txtBookId.Text.Trim(), this.manager.dataGridView1); } else { MessageBox.Show("修改信息失败!"); } }
// 添加图书类型 private void button1_Click(object sender, EventArgs e) { BookType type = new BookType(); type.BookTypeName = textBox1.Text.Trim(); if (booktype.AddBookTypeInfo(type) == 0) { MessageBox.Show("添加成功!"); this.dataGridView1.DataSource = booktype.selectBookType1().Tables[0]; // 自动找到刚刚添加成功的新行,并选中 com.AutoFindRow(type.BookTypeId.ToString(), this.dataGridView1); } else { MessageBox.Show("添加失败!"); } }
/// <summary> /// 添加图书信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { // 图书编号必须唯一 int rows = this.manager.dataGridView1.RowCount; lab.Text = ""; for (int i = 0; i < rows; i++) { string Columns1 = this.manager.dataGridView1.Rows[i].Cells[0].Value.ToString(); if (Columns1 == txtBookId.Text.Trim()) { lab.Text = "图书编号已存在!"; return; } } // 创建添加的对象 BookInfo book = new BookInfo(); book.BookId = txtBookId.Text.Trim(); book.BookName = txtBookName.Text.Trim(); book.TimeIn = TimeIn.Value; book.BookTypeId = (int)cboBookTypeId.SelectedValue; book.Author = txtAuthor.Text.Trim(); book.PinYinCode = txtPinYinCode.Text.Trim(); book.Translator = txtTranslator.Text.Trim(); book.Language = txtLanguge.Text.Trim(); book.BookNumber = txtBookNumber.Text.Trim(); book.Price = txtPrice.Text.Trim(); book.Layout = txtLayout.Text.Trim(); book.Address = txtAddress.Text.Trim(); book.ISBS = txtISBS.Text.Trim(); book.Versions = txtVersions.Text.Trim(); book.BookRemark = txtBookRemark.Text.Trim(); if (bookInfo.AddBookInfo(book) > 0) { MessageBox.Show("添加信息成功!"); // 图书类型信息的绑定 manager.dataGridView1.DataSource = manager.bookInfo_bll.selectBookInfo1().Tables[0]; // 自动找到刚刚添加成功的新行,并选中 com.AutoFindRow(txtBookId.Text.Trim(), this.manager.dataGridView1); } else { MessageBox.Show("添加信息失败!"); } }
// 新增读者信息 private void btnAdd_Click(object sender, EventArgs e) { // 图书编号必须唯一 int rows = reader.dgvHeaderInfo.RowCount; lab.Text = ""; for (int i = 0; i < rows; i++) { string Columns1 = reader.dgvHeaderInfo.Rows[i].Cells[0].Value.ToString(); if (Columns1 == txtReaderId.Text.Trim()) { lab.Text = "读者编号已存在!"; return; } } Reader r = new Reader(); r.ReaderId = txtReaderId.Text.Trim(); r.ReaderName = txtReaderName.Text.Trim(); r.TimeIn = dtTimeIn.Value; r.TimeOut = dtTimeOut.Value; r.ReaderTypeId = (int)cboReaderType.SelectedValue; r.DepartmentId = (int)cboDepartment.SelectedValue; r.ClassId = (int)cboClass.SelectedValue; r.IdentityCard = txtIdentityCard.Text.Trim(); r.Gender = txtGender.Text.Trim(); r.Phone = txtPhone.Text.Trim(); r.Special = txtSpecial.Text.Trim(); r.Email = txtEmail.Text.Trim(); r.Address = txtAddress.Text.Trim(); r.ReaderRemark = txtRemark.Text.Trim(); if (reader_bll.addReader(r) == 0) { MessageBox.Show("新增成功!"); // 单击查询 刷新读者信息表 reader.btnSelect_Click(null, null); // 自动找到刚刚添加成功的新行,并选中 com.AutoFindRow(txtReaderId.Text.Trim(), reader.dgvHeaderInfo); } else { MessageBox.Show("新增失败!"); } }
private void btnUpdate_Click(object sender, EventArgs e) { PersonInfo r = new PersonInfo(); if (reader_bll.updateReader(r) > 0) { MessageBox.Show("修改成功!"); //单价查询 reader.btnSelect_Click(null, null); //自动找到刚刚修改成功的行,并选中 com.AutoFindRow(txtReaderId.Text.Trim(), reader.dgv_UserInfo); } else { MessageBox.Show("修改失败!"); } }
/// <summary> /// 新增人员信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Add_Click(object sender, EventArgs e) { //人员编号必须唯一 int rows = personInfoManager.dgv_UserInfo.RowCount; for (int i = 0; i < rows; i++) { if (personInfo_BLL.IsPersonIDHaving(tb_PersonID.Text.Trim())) { MessageBox.Show("人员编号已存在!!!"); return; } } PersonInfo personInfo = new PersonInfo(); personInfo.PersonID = Convert.ToInt32(tb_PersonID.Text.Trim()); personInfo.PersonName = tb_PersonName.Text.Trim(); if (personInfo_BLL.AddPersonInfo(personInfo)) { MessageBox.Show("新增成功!"); //单击查询 刷新人员信息表 personInfoManager.ShowLayout_dgv_UserInfo(); personInfoManager.ShowData_dgv_PersonInfo(); //自动找到刚刚添加成功的新行,并选中 com.AutoFindRow(tb_PersonID.Text.Trim(), personInfoManager.dgv_UserInfo); this.Close(); } else { MessageBox.Show("新增失败!"); } }