treeview控件,第二层只能显示1条数据,怎么解决?
treeview控件分三层,第一层是根目录,显示文本"请选择房间和类别"
第二层和第三层分别调用游标显示tt_fjlb表和tt_lbdm表中的内容。
问题,第二层只显示表中第一条记录,怎样才能显示表中所有记录?
代码如下:
string ls_fjdm,ls_fjmc,ls_lbdm,ls_lbmc
TreeViewItem ltvi_Item,ltvi_Item1,ltvi_Item2
long lng_handle,lng_handle1,lng_handle2,ll_root
ll_root = tv_1.FindItem(RootTreeItem!, 0)
ltvi_Item.label = "请选择房间和类别"
ltvi_Item.data = ""
ltvi_Item.pictureindex = 1
ltvi_Item.children = True
ltvi_Item.selectedpictureindex = 2
lng_handle = tv_1.InsertItemLast(0, ltvi_Item)
//tv_1.ExpandItem(lng_handle)
DECLARE de_fjlb CURSOR FOR
SELECT tt_fjlb.fjlbdm,
tt_fjlb.fjlbmc
FROM tt_fjlb ;
//声明游标
open de_fjlb;
//打开游标
FETCH de_fjlb INTO :ls_fjlb,:ls_fjmc;
DO WHILE SQLCA.SQLCODE = 0
ltvi_Item1.label = ls_fjlb + " " + ls_fjmc
ltvi_Item1.data = ls_fjlb
ltvi_Item1.pictureindex = 1
ltvi_Item1.children = True
ltvi_Item1.selectedpictureindex = 2
lng_handle1 = tv_1.InsertItemLast(lng_handle, ltvi_Item1)
// tv_1.ExpandItem(lng_handle)
DECLARE de_lbdm CURSOR FOR
SELECT tt_lbdm.lbdm,
tt_lbdm.lbmc
FROM tt_lbdm ;
//声明游标
open de_lbdm;
//打开游标
FETCH de_lbdm INTO :ls_lbdm,:ls_lbmc;
DO WHILE SQLCA.SQLCODE = 0
ltvi_Item2.label = ls_lbdm + " " + ls_lbmc
ltvi_Item2.data = ls_lbdm
ltvi_Item2.pictureindex = 3
ltvi_Item2.children = false
ltvi_Item2.selectedpictureindex = 4
lng_handle2 = tv_1.InsertItemLast(lng_handle1, ltvi_Item2)
tv_1.ExpandItem(lng_handle1)
FETCH de_lbdm INTO :ls_lbdm,:ls_lbmc;
LOOP
CLOSE de_fjlb;
tv_1.ExpandItem(ll_root)
FETCH de_fjlb INTO :ls_fjlb,:ls_fjmc;
LOOP
CLOSE de_fjlb;