//修改卡片信息 private void tsbUpdateInfo_Click(object sender, EventArgs e) { CtbBookInformation updateBook = new CtbBookInformation(); _delegateRefreshAllInfo dlg = new _delegateRefreshAllInfo(RefreshAllInfo); if (dgvAllBookInfo.CurrentRow != null) { updateBook.bookID = int.Parse(dgvAllBookInfo.CurrentRow.Cells["bookID"].Value.ToString()); updateBook.bookSortID = int.Parse(dgvAllBookInfo.CurrentRow.Cells["bookSortID"].Value.ToString()); updateBook.bookName = dgvAllBookInfo.CurrentRow.Cells["bookName"].Value.ToString(); updateBook.bookAutor = dgvAllBookInfo.CurrentRow.Cells["bookAutor"].Value.ToString(); updateBook.bookPublish = dgvAllBookInfo.CurrentRow.Cells["bookPublish"].Value.ToString(); updateBook.bookPubDate = DateTime.Parse(dgvAllBookInfo.CurrentRow.Cells["bookPubDate"].Value.ToString()); updateBook.bookPrice = Decimal.Parse(dgvAllBookInfo.CurrentRow.Cells["bookPrice"].Value.ToString()); updateBook.bookSummary = dgvAllBookInfo.CurrentRow.Cells["bookSummary"].Value.ToString(); updateBook.bookRealNum = int.Parse(dgvAllBookInfo.CurrentRow.Cells["bookRealNum"].Value.ToString()); updateBook.bookLendNum = int.Parse(dgvAllBookInfo.CurrentRow.Cells["bookLendNum"].Value.ToString()); updateBook.bookResDate = DateTime.Parse(dgvAllBookInfo.CurrentRow.Cells["bookResDate"].Value.ToString()); frmBookInfoAddOrUpdate frmUpdate = new frmBookInfoAddOrUpdate(updateBook, dlg);//打开修改窗体 frmUpdate.Show(); } else { MessageBox.Show("请选中你要修改的信息再执行修改!", "操作提示"); } }
public frmBookInfoAddOrUpdate(CtbBookInformation bookInfoModel, frmBookInfoManage._delegateRefreshAllInfo _dlg) { InitializeComponent(); //此构造函数用于创建修改图书卡片信息的窗体 dlg = _dlg; //然后修改窗体标题显示的信息以及按钮显示的信息 this.Text = "修改卡片信息"; btEnter.Text = "保存"; //将传过来的待修改的信息进行窗体赋值 tbBookID.Text = bookInfoModel.bookID.ToString(); cbBookSortID.Text = bookInfoModel.bookSortID.ToString(); tbBookName.Text = bookInfoModel.bookName; tbBookAutor.Text = bookInfoModel.bookAutor; tbBookPublish.Text = bookInfoModel.bookPublish; dtpPublishDate.Value = bookInfoModel.bookPubDate; tbBookPrice.Text = bookInfoModel.bookPrice.ToString(); tbBookRealNum.Text = bookInfoModel.bookRealNum.ToString(); tbLendNum.Text = bookInfoModel.bookLendNum.ToString(); rtbBookSummary.Text = bookInfoModel.bookSummary; dtpBookResDate.Value = bookInfoModel.bookResDate; //图书编号在修改过程不能更改 tbBookID.ReadOnly = true; }
//借阅按钮事件 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; } } } }
/// <summary> /// 获得数据列表 /// </summary> public List <CtbBookInformation> GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); List <CtbBookInformation> modelList = new List <CtbBookInformation>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { CtbBookInformation model; for (int n = 0; n < rowsCount; n++) { model = new CtbBookInformation(); if (ds.Tables[0].Rows[n]["bookID"].ToString() != "") { model.bookID = int.Parse(ds.Tables[0].Rows[n]["bookID"].ToString()); } if (ds.Tables[0].Rows[n]["bookSortID"].ToString() != "") { model.bookSortID = int.Parse(ds.Tables[0].Rows[n]["bookSortID"].ToString()); } model.bookName = ds.Tables[0].Rows[n]["bookName"].ToString(); model.bookAutor = ds.Tables[0].Rows[n]["bookAutor"].ToString(); model.bookPublish = ds.Tables[0].Rows[n]["bookPublish"].ToString(); if (ds.Tables[0].Rows[n]["bookPubDate"].ToString() != "") { model.bookPubDate = DateTime.Parse(ds.Tables[0].Rows[n]["bookPubDate"].ToString()); } if (ds.Tables[0].Rows[n]["bookPrice"].ToString() != "") { model.bookPrice = decimal.Parse(ds.Tables[0].Rows[n]["bookPrice"].ToString()); } model.bookSummary = ds.Tables[0].Rows[n]["bookSummary"].ToString(); if (ds.Tables[0].Rows[n]["bookRealNum"].ToString() != "") { model.bookRealNum = int.Parse(ds.Tables[0].Rows[n]["bookRealNum"].ToString()); } if (ds.Tables[0].Rows[n]["bookLendNum"].ToString() != "") { model.bookLendNum = int.Parse(ds.Tables[0].Rows[n]["bookLendNum"].ToString()); } if (ds.Tables[0].Rows[n]["bookResDate"].ToString() != "") { model.bookResDate = DateTime.Parse(ds.Tables[0].Rows[n]["bookResDate"].ToString()); } modelList.Add(model); } } return(modelList); }
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(); } }
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 }