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("新增失败！");
}
}
