//绑定图书类别信息到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, "错误信息");
}
}
