//绑定图书类别信息到Combox private void ComboxDataBinding() { CtbBookSortBLL cBs = new CtbBookSortBLL(); List <CtbBookSort> LbookSort = cBs.GetModelList("bookSortID>0"); foreach (CtbBookSort ctbSort in LbookSort) { cbBookSortID.Items.Add(ctbSort.bookSortID); } }
/// <summary> /// 绑定所有种类信息到dgv /// </summary> private void dgvDataBindingAllInfo() { this.dgvAllSortInfo.Columns.Clear(); CtbBookSortBLL cBs = new CtbBookSortBLL(); List <CtbBookSort> LbookSort = cBs.GetModelList("bookSortID>0"); this.dgvAllSortInfo.DataSource = LbookSort; this.dgvAllSortInfo.Columns["bookSortID"].HeaderText = "图书类别编号"; this.dgvAllSortInfo.Columns["bookSortRemark"].HeaderText = "图书类别说明"; }
/// <summary> /// 当选中图书类别编号时在标签中显示类别说明 /// </summary> private void cbBookSortID_TextChanged(object sender, EventArgs e) { string selectedSortID = cbBookSortID.Text; CtbBookSortBLL cBs = new CtbBookSortBLL(); List <CtbBookSort> LbookSort = cBs.GetModelList("bookSortID>0"); foreach (CtbBookSort ctbSort in LbookSort) { if (ctbSort.bookSortID.ToString() == selectedSortID) { lBookSortMark.Text = ctbSort.bookSortRemark; break; } } }
/// <summary> /// 删除图书类别 /// </summary> private void tsbDeleteSort_Click(object sender, EventArgs e) { try { int currentIndex = this.dgvAllSortInfo.CurrentRow.Index; CtbBookSortBLL ctbDel = new CtbBookSortBLL(); int bookSortID = int.Parse(this.dgvAllSortInfo["bookSortID", currentIndex].Value.ToString()); if (MessageBox.Show("删除" + bookSortID.ToString() + "的图书编号会删除所有与此关联的图书信息,确定要删除吗?", "操作提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { ctbDel.Delete(bookSortID); MessageBox.Show("删除成功!", "操作提示"); } dgvDataBindingAllInfo();//刷新绑定信息 } catch (Exception ex) { MessageBox.Show(ex.Message, "错误信息"); } }
/// <summary> /// 添加图书种类 /// </summary> private void tsbAddSort_Click(object sender, EventArgs e) { try { if (tbSortID.Text != "" && tbSortCaption.Text != "") { CtbBookSort newSort = new CtbBookSort(); newSort.bookSortID = int.Parse(tbSortID.Text); newSort.bookSortRemark = tbSortCaption.Text; CtbBookSortBLL newSortBll = new CtbBookSortBLL(); newSortBll.Add(newSort); MessageBox.Show("添加成功!", "消息提示"); dgvDataBindingAllInfo();//刷新绑定信息 } else { MessageBox.Show("图书类别编号与图书类别说明不能为空!", "操作提示"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "错误信息"); } }