久久久久久久999_99精品久久精品一区二区爱城_成人欧美一区二区三区在线播放_国产精品日本一区二区不卡视频_国产午夜视频_欧美精品在线观看免费

<s id="8w4su"></s>

標(biāo)題: MFC的樹(shù)形控件怎么添加具有層次性的目錄 [打印本頁(yè)]

作者: bibi 時(shí)間: 2015-4-18 20:58
標(biāo)題: MFC的樹(shù)形控件怎么添加具有層次性的目錄
我用一個(gè)access數(shù)據(jù)庫(kù)來(lái)管理圖片資源，需要對(duì)這些圖片進(jìn)行歸門別類，開(kāi)始在網(wǎng)上Google了很久都沒(méi)找到什么什么資料出來(lái)，不過(guò)自己整理出思路來(lái)了。。貼在這可以給需要的人看看。

一、設(shè)計(jì)數(shù)據(jù)庫(kù)
這里設(shè)計(jì)了兩張表tbCategores、tbPictures，如下圖所示

圖1 表tbCategores，IDCat是主鍵，自動(dòng)編號(hào)，ParentID是目錄Categores的父目錄ID，為0表示沒(méi)有父目錄

圖2 表tbPictures存儲(chǔ)相應(yīng)下的圖片，有IDCat（外鍵）表明當(dāng)前圖片（IDpict）屬于哪個(gè)目錄

圖3 兩張表的關(guān)系

二、代碼
這里給出怎么將表tbCategores填充到Treectrl的代碼，其他代碼可以自行發(fā)揮！！

void CGalleryDlg::InitTree()
{

CMedicalApp *pApp = (CMedicalApp *)AfxGetApp();
m_treeImages.Create(16,16,ILC_MASK |ILC_COLOR32,3,3);

m_treeImages.Add(pApp->LoadIcon(IDI_DB ));
m_treeImages.Add(pApp->LoadIcon(IDI_FOLDER_YELLOW ));
m_treeImages.Add(pApp->LoadIcon(IDI_FOLDER_YELLOW_OPEN ));
m_treeFolder.SetImageList(&m_treeImages,TVSIL_NORMAL);

ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sDBName = m_AdoConn.GetDBName();

int i=sDBName.ReverseFind('\\');
CString nFileText = _T("[") + sDBName.Mid(i+1) + _T("]");

//insert item
long lItemTitle;
CString sItemTitle;

// item created
HTREEITEM tiTestNode;
HTREEITEM tiParentNode;

//insert root item
TVINSERTSTRUCT tvInsert;
tvInsert.hParent = NULL;
tvInsert.hInsertAfter = NULL;
tvInsert.item.mask = TVIF_TEXT;
tvInsert.item.pszText = nFileText.GetBuffer();

m_treeFolder.DeleteAllItems();
HTREEITEM h_root=m_treeFolder.InsertItem(&tvInsert);

//add categroes
CString  sql;
sql.Format(_T("select * from tbCategores order by No desc"));
_RecordsetPtr pRecordset;
pRecordset = m_AdoConn.GetRecordset((_bstr_t)sql);

while(!m_AdoConn.m_pRecordset->adoEOF)
{
_variant_t vIDCat, vCategores, vParentID;
vIDCat = pRecordset->GetCollect("IDCat");
vCategores= pRecordset->GetCollect("Categores");
vParentID = pRecordset->GetCollect("ParentID");

sItemTitle = (TCHAR*)(_bstr_t)vCategores;
lItemTitle = vIDCat.lVal;

// insert the node
if(vParentID.vt != VT_NULL)
tiParentNode = FindItem((long)(vParentID.lVal));  //查找父節(jié)點(diǎn)

if(vIDCat.lVal==0)
{
tiTestNode = m_treeFolder.InsertItem(sItemTitle,1,2,h_root);
m_treeFolder.SetItemData(tiTestNode,lItemTitle);
}

//for the other nodes
if( tiParentNode )
{
tiTestNode = m_treeFolder.InsertItem(sItemTitle,1,2, tiParentNode);
m_treeFolder.SetItemData(tiTestNode, lItemTitle);
}

pRecordset->MoveNext();
}

m_treeFolder.Expand(m_treeFolder.GetRootItem(), TVE_EXPAND);

m_treeFolder.EnableMultiSelect(FALSE);
m_AdoConn.ExitConnect();
}

//查找某一個(gè)節(jié)點(diǎn)

HTREEITEM CGalleryDlg::FindItem(long lItemData)
{
// the tree object
// the current item
HTREEITEM tiItem= m_treeFolder.GetNextItem(TVGN_ROOT,TVGN_ROOT);
long       lCurrentData;

while (tiItem)
{
m_treeFolder.Expand(tiItem,TVE_EXPAND);

lCurrentData = (long)m_treeFolder.GetItemData(tiItem);

if( lCurrentData == lItemData )
return tiItem;
tiItem= m_treeFolder.GetNextItem(tiItem,TVGN_NEXTVISIBLE);
}

return NULL;

}

下圖是填充目錄后的Treectrl。

歡迎光臨 (http://m.zg4o1577.cn/bbs/)