//借阅按钮事件
private void btEnter_Click(object sender, EventArgs e)
{
//首先判断是否存在已经借阅了此本书的情况
if (cbReader.Text != "" && cbBook.Text != "")
{
CtbLend cLend = new CtbLend();
CtbLendBLL cLendBll = new CtbLendBLL();
int readerID = int.Parse(cbReader.Text);
int bookID = int.Parse(cbBook.Text);
string sql = "bookID=" + bookID + " and readerID=" + readerID + " and lendNum>0";
if (cLendBll.GetModelList(sql).Count > 0)
{
MessageBox.Show("该读者已经借阅了此本书.请先归还现有数目！", "操作提示");
return;
}
else
{
if (tbLendNum.Text != "")
{
int lendNum = 0;
try
{
lendNum = int.Parse(tbLendNum.Text);
}
catch (Exception ex)
{
MessageBox.Show("输入的数量不正确,请确定格式正确。详细异常信息：\n" + ex.Message, "出现异常");
return;
}
if (lendNum > int.Parse(lbTrueName1.Text))
{
MessageBox.Show("借出数量不应该大于实际存书数量", "出现异常");
return;
}
CtbLendBLL lendBll = new CtbLendBLL();
CtbLend lend = new CtbLend();
lend.readerID = int.Parse(cbReader.Text);
lend.bookID = int.Parse(cbBook.Text);
lend.lendDate = dtkBorrowDate.Value;
lend.lendYDate = dtkYReturnDate.Value;
lend.lendSDate = null;
lend.lendNum = int.Parse(tbLendNum.Text);
CtbBookInformation cBook = new CtbBookInformation();
CtbBookInformationBLL cBookBll = new CtbBookInformationBLL();
cBook = cBookBll.GetModel(lend.bookID);
cBook.bookLendNum = cBook.bookLendNum + lend.lendNum;
cBookBll.Update(cBook);
lendBll.Add(lend);
MessageBox.Show("添加借阅信息成功！", "操作提示");
}
else
{
MessageBox.Show("借出数量不能为空", "出现异常");
return;
}
}
}
}
//绑定图书编号列表到控件
public void BooksComboxBinding()
{
cbBook.Items.Clear();
CtbBookInformationBLL cBookBll = new CtbBookInformationBLL();
List <CtbBookInformation> cBooks = cBookBll.GetModelList("bookID>0");
foreach (CtbBookInformation cb in cBooks)
{
cbBook.Items.Add(cb.bookID);
cbGBookID.Items.Add(cb.bookID);
}
}
private void cbBook_TextChanged(object sender, EventArgs e)
{
CtbBookInformationBLL cBookBll = new CtbBookInformationBLL();
CtbBookInformation cBook = cBookBll.GetModel(int.Parse(cbBook.Text));
if (cBook != null)
{
lbBname.Visible = true;
lbBname1.Visible = true;
lbBname1.Text = cBook.bookName;
//同时显示图书实际存货
lbTrueNum.Visible = true;
lbTrueName1.Visible = true;
lbTrueName1.Text = cBook.bookRealNum.ToString();
}
}
/// <summary>
/// 删除卡片信息
/// </summary>
private void tsbDeleteInfo_Click(object sender, EventArgs e)
{
CtbBookInformationBLL bookInfo = new CtbBookInformationBLL();
if (dgvAllBookInfo.CurrentRow != null)
{
int bookID = int.Parse(dgvAllBookInfo.CurrentRow.Cells["bookID"].Value.ToString());
if (MessageBox.Show("删除编号为" + bookID.ToString() + "的图书会删除所有与此图书关联的借阅与还书信息,确定要删除吗？", "操作提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bookInfo.Delete(bookID);//执行删除
MessageBox.Show("删除成功！", "操作提示");
}
RefreshAllInfo();//刷新显示
}
else
{
MessageBox.Show("请选中你要删除的信息再执行删除！", "操作提示");
}
}
/// <summary>
/// 绑定所有书目信息到datagridview
/// </summary>
private void RefreshAllInfo()
{
this.dgvAllBookInfo.Columns.Clear();
List <CtbBookInformation> allBookInfo = new List <CtbBookInformation>();
CtbBookInformationBLL allBInfoBll = new CtbBookInformationBLL();
allBookInfo = allBInfoBll.GetModelList("bookID>0");
this.dgvAllBookInfo.DataSource = allBookInfo;
this.dgvAllBookInfo.Columns["bookID"].HeaderText = "图书编号";
this.dgvAllBookInfo.Columns["bookSortID"].HeaderText = "图书类型编号";
this.dgvAllBookInfo.Columns["bookName"].HeaderText = "图书名称";
this.dgvAllBookInfo.Columns["bookAutor"].HeaderText = "图书作者";
this.dgvAllBookInfo.Columns["bookPublish"].HeaderText = "图书出版社";
this.dgvAllBookInfo.Columns["bookPubDate"].HeaderText = "出版日期";
this.dgvAllBookInfo.Columns["bookPrice"].HeaderText = "定价";
this.dgvAllBookInfo.Columns["bookSummary"].HeaderText = "内容摘要";
this.dgvAllBookInfo.Columns["bookRealNum"].HeaderText = "实际数量";
this.dgvAllBookInfo.Columns["bookLendNum"].HeaderText = "借出数量";
this.dgvAllBookInfo.Columns["bookResDate"].HeaderText = "卡片登记日期";
}
private void btEnter_Click(object sender, EventArgs e)
{
//在这里我们要进行判断我们进行的是添加还是修改
//判断的方法我们这里只介绍针对我们现在这种情况的方法
//方法就是判断按钮的TEXT是"添加"还是"保存"
#region 添加事件代码
if (btEnter.Text == "添加")
{
//任何时候不要忘记做程序异常检查
//这是个良好的习惯,便于检查程序运行过程出现的容易忽略的错误
try
{
//这里做添加事件的代码
//先判断输入的数据是否为空
//我们进行进行整体判断
if (tbBookID.Text != "")
{
if (cbBookSortID.Text != "")
{
if (tbBookName.Text != "")
{
if (tbBookAutor.Text != "")
{
if (tbBookPublish.Text != "")
{
if (tbBookPrice.Text != "")
{
if (tbBookRealNum.Text != "")
{
if (tbLendNum.Text != "")
{
if (rtbBookSummary.Text != "")
{
//添加图书卡片信息的代码
CtbBookInformation newBook = new CtbBookInformation();
CtbBookInformationBLL newBookBll = new CtbBookInformationBLL();
newBook.bookID = int.Parse(tbBookID.Text);
newBook.bookSortID = int.Parse(cbBookSortID.Text);
newBook.bookName = tbBookName.Text;
newBook.bookAutor = tbBookAutor.Text;
newBook.bookPublish = tbBookPublish.Text;
newBook.bookPubDate = dtpPublishDate.Value;
newBook.bookPrice = decimal.Parse(tbBookPrice.Text);
newBook.bookRealNum = int.Parse(tbBookRealNum.Text);
newBook.bookLendNum = int.Parse(tbLendNum.Text);
newBook.bookSummary = rtbBookSummary.Text;
newBook.bookResDate = dtpBookResDate.Value;
newBookBll.Add(newBook);
if (MessageBox.Show("添加成功！是否继续添加？", "操作提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
ClearControlValue();//清除控件中的现有值
}
else
{
dlg();//同步更新
this.Close();
}
}
else
{
MessageBox.Show("图书摘要不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("借出数量不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("实际数量不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("定价不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("出版社不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("作者不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("图书名称不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("图书类别不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("图书编号不能为空！", "操作提示");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "程序异常提示");
}
}
#endregion
#region 修改事件代码
else if (btEnter.Text == "保存")
{
//这里做修改事件的代码
try
{
//这里我们也应该判断修改后的数据有没有空值
if (cbBookSortID.Text != "")
{
if (tbBookName.Text != "")
{
if (tbBookAutor.Text != "")
{
if (tbBookPublish.Text != "")
{
if (tbBookPrice.Text != "")
{
if (tbBookRealNum.Text != "")
{
if (tbLendNum.Text != "")
{
if (rtbBookSummary.Text != "")
{
//修改图书卡片信息的代码
CtbBookInformation newBook = new CtbBookInformation();
CtbBookInformationBLL newBookBll = new CtbBookInformationBLL();
newBook.bookID = int.Parse(tbBookID.Text);
newBook.bookSortID = int.Parse(cbBookSortID.Text);
newBook.bookName = tbBookName.Text;
newBook.bookAutor = tbBookAutor.Text;
newBook.bookPublish = tbBookPublish.Text;
newBook.bookPubDate = dtpPublishDate.Value;
newBook.bookPrice = decimal.Parse(tbBookPrice.Text);
newBook.bookRealNum = int.Parse(tbBookRealNum.Text);
newBook.bookLendNum = int.Parse(tbLendNum.Text);
newBook.bookSummary = rtbBookSummary.Text;
newBook.bookResDate = dtpBookResDate.Value;
newBookBll.Update(newBook);
MessageBox.Show("修改成功！", "操作提示");
dlg(); //同步更新
this.Close();
}
else
{
MessageBox.Show("图书摘要不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("借出数量不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("实际数量不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("定价不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("出版社不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("作者不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("图书名称不能为空！", "操作提示");
}
}
else
{
MessageBox.Show("图书类别不能为空！", "操作提示");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "程序异常提示");
}
}
#endregion
}
//图书查询按钮事件
private void btBookInfo_Click(object sender, EventArgs e)
{
List <CtbBookInformation> cBooks = new List <CtbBookInformation>();
CtbBookInformationBLL cBookBll = new CtbBookInformationBLL();
string sqlstr = "";
if (cbBBookID.Checked)
{
if (tbBBookID.Text != "")
{
sqlstr = sqlstr + "and bookID=" + tbBBookID.Text + " ";
}
}
if (cbBSortID.Checked)
{
if (tbBSortID.Text != "")
{
sqlstr = sqlstr + "and bookSortID=" + tbBSortID.Text + " ";
}
}
if (cbBName.Checked)
{
if (tbBName.Text != "")
{
sqlstr = sqlstr + "and bookName='" + tbBName.Text + "' ";
}
}
if (cbBAuthor.Checked)
{
if (tbBAuthor.Text != "")
{
sqlstr = sqlstr + "and bookAutor='" + tbBAuthor.Text + "' ";
}
}
if (cbBPublish.Checked)
{
if (tbBPublish.Text != "")
{
sqlstr = sqlstr + "and bookPublish='" + tbBPublish.Text + "' ";
}
}
if (sqlstr != "")
{
sqlstr = sqlstr.Remove(0, 4);//去掉字符串中最前面的and
cBooks = cBookBll.GetModelList(sqlstr);
if (cBooks.Count > 0)
{
this.dgvSearchResult.Columns.Clear();
this.dgvSearchResult.DataSource = cBooks;
this.dgvSearchResult.Columns["bookID"].HeaderText = "图书编号";
this.dgvSearchResult.Columns["bookSortID"].HeaderText = "图书类型编号";
this.dgvSearchResult.Columns["bookName"].HeaderText = "图书名称";
this.dgvSearchResult.Columns["bookAutor"].HeaderText = "图书作者";
this.dgvSearchResult.Columns["bookPublish"].HeaderText = "图书出版社";
this.dgvSearchResult.Columns["bookPubDate"].HeaderText = "出版日期";
this.dgvSearchResult.Columns["bookPrice"].HeaderText = "定价";
this.dgvSearchResult.Columns["bookSummary"].HeaderText = "内容摘要";
this.dgvSearchResult.Columns["bookRealNum"].HeaderText = "实际数量";
this.dgvSearchResult.Columns["bookLendNum"].HeaderText = "借出数量";
this.dgvSearchResult.Columns["bookResDate"].HeaderText = "卡片登记日期";
}
else
{
MessageBox.Show("未查到相关信息！", "操作提示");
}
}
else
{
sqlstr = "bookID>0";
cBooks = cBookBll.GetModelList(sqlstr);
if (cBooks.Count > 0)
{
this.dgvSearchResult.Columns.Clear();
this.dgvSearchResult.DataSource = cBooks;
this.dgvSearchResult.Columns["bookID"].HeaderText = "图书编号";
this.dgvSearchResult.Columns["bookSortID"].HeaderText = "图书类型编号";
this.dgvSearchResult.Columns["bookName"].HeaderText = "图书名称";
this.dgvSearchResult.Columns["bookAutor"].HeaderText = "图书作者";
this.dgvSearchResult.Columns["bookPublish"].HeaderText = "图书出版社";
this.dgvSearchResult.Columns["bookPubDate"].HeaderText = "出版日期";
this.dgvSearchResult.Columns["bookPrice"].HeaderText = "定价";
this.dgvSearchResult.Columns["bookSummary"].HeaderText = "内容摘要";
this.dgvSearchResult.Columns["bookRealNum"].HeaderText = "实际数量";
this.dgvSearchResult.Columns["bookLendNum"].HeaderText = "借出数量";
this.dgvSearchResult.Columns["bookResDate"].HeaderText = "卡片登记日期";
}
else
{
MessageBox.Show("未查到相关信息！", "操作提示");
}
}
}
