/// <summary>
/// 选择节点事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tvBookType_AfterSelect(object sender, TreeViewEventArgs e)
{
//获取当前选择节点
TreeNode tn = tvBookType.SelectedNode;
int typeid = Convert.ToInt32(tn.Tag.ToString());
BookTypeExtModel model = btbll.GetBookTypeId(typeid);
if (model == null)
{
MessageBox.Show("获取图书类别信息出错");
return;
}
else
{
if (model.ParentTypeId == 0)
{
txtParentTypeId.Text = "NULL";
txtParentTypeName.Text = "NULL";
}
else
{
txtParentTypeId.Text = model.ParentTypeId2.ToString();
txtParentTypeName.Text = model.ParentTypeName;
}
txtTypeId.Text = model.TypeId.ToString();
txtTypeName.Text = model.TypeName;
txtDESC.Text = model.TypeDESC;
}
}
/// <summary>
/// 根据类别Id得到类别信息及父类信息
/// </summary>
/// <param name="typeId"></param>
/// <returns></returns>
public BookTypeExtModel GetBookTypeId(int typeId)
{
string sql = "select * from (select TypeId, TypeName, TypeDESC, ParentTypeId from booktype) a left join (select TypeId as ParentTypeId2, TypeName as ParentTypeName,TypeDESC as ParentTypeDESC from booktype) b on a.ParentTypeId = b.ParentTypeid2 where a.typeid = @typeId";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("TypeId", typeId)
};
BookTypeExtModel model = null;
DataSet ds = helper.GetDataSetSql(sql, para);
if (ds.Tables[0].Rows.Count > 0)
{
model = ListDataSet.DataSetToIList <BookTypeExtModel>(ds, 0).ToList().First();
}
return(model);
}
private void Editbkfrm()
{
lblTiele.Text = "【修改图书】";
BookExtModel bkinfo = bkbll.GetBookModelById(bookid);
if (bkinfo != null)
{
//页面控件赋值
txtBookId.Text = bkinfo.BookId;
txtBookId.ReadOnly = true;
txtBookISBN.Text = bkinfo.ISBN;
txtBookName.Text = bkinfo.BookName;
txtBookAuthor.Text = bkinfo.BookAuthor;
txtBookPrice.Text = bkinfo.BookPrice.ToString();
cboBookPress.Text = bkinfo.BookPress.ToString();
dtpPublishDate.Text = bkinfo.BookPublishDate.ToString();
lblStorageInDate.Text = bkinfo.StorageInDate.ToString();
txtStorageInNum.Value = bkinfo.StorageInNum;
lblInventoryNum.Value = bkinfo.InventoryNum;
lblBorrowedNum.Value = bkinfo.BorrowedNum;
//把文本转成图片
if (string.IsNullOrWhiteSpace(bkinfo.BookImage))
{
pbCurrentImage.Image = null;
}
else
{
pbCurrentImage.Image = (Image)SerializeObjectToString.DeserializeObject(bkinfo.BookImage);
}
//处理下拉框
cboBookPress.SelectedItem = presslist.Find(x => x.PressId == bkinfo.BookPress);
//得到当前书类别信息
BookTypeExtModel currenttype = btbll.GetBookTypeId(bkinfo.BookType);
BookTypeModel typeone = typelist.Find(x => x.TypeId == currenttype.ParentTypeId);
cboBookTypeOne.SelectedItem = typeone;
}
}
