[C#] winform Treeview(트리뷰) 채우기

[C#] winform Treeview(트리뷰) 채우기

 

- 재귀쿼리로 Treeview 셋팅

public class CodeValueEntity { public string Code { get; set; } public string Value { get; set; } } public class GroupCodeValueEntity { public string ParentCode { get; set; } public string Code { get; set; } public string Value { get; set; } } public class DataBaseModel { public List<CodeValueEntity> GetListParent() { // 테이블1 형식 //row = 테이블명1.NewRow(); row["Code"] = "001"; row["Value"] = "테스트1"; 테이블명1.Rows.Add(row); //row = 테이블명1.NewRow(); row["Code"] = "002"; row["Value"] = "테스트2"; 테이블명1.Rows.Add(row); DataTable dt = StaticModel.DB_CT.Tables["테이블명1"]; var list = (from DataRow row in dt.Rows select new CodeValueEntity { Code = row["Code"].ToString(), Value = row["Value"].ToString() }).ToList(); return list; } public List<GroupCodeValueEntity> GetListChild() { // 테이블2 형식 //row = 테이블명2.NewRow(); row["Group"] = "001"; row["Code"] = "001"; row["Value"] = "001_테스트1"; 테이블명2.Rows.Add(row); //row = 테이블명2.NewRow(); row["Group"] = "001"; row["Code"] = "002"; row["Value"] = "001_테스트2"; 테이블명2.Rows.Add(row); DataTable dt = StaticModel.DB_CT.Tables["테이블명2"]; var list = (from DataRow row in dt.Rows select new GroupCodeValueEntity { Group = row["Group"].ToString(), Code = row["Code"].ToString(), Value = row["Value"].ToString() }).ToList(); return list; } } public partial class frmHelp : Form { private void InitializeTreeview(string selectedNodeName) { DataBaseModel dataBaseModel = new DataBaseModel(); List<CodeValueEntity> parents = dataBaseModel.GetListParent(); // 부모 카테고리 리스트 가져오기 List<GroupCodeValueEntity> childs = dataBaseModel.GetListChild(); // 자식 카테고리 리스트 가져오기 treeview1.Nodes.Clear(); treeview1.ImageList = imglstIcon; TreeNode tNode = new TreeNode(); foreach (CodeValueEntity parent in parents) { if (groupParent.Code == "") continue; TreeNode node = getNodeChild(getNodeParent(parent), childCateorys.Where(x => x.ParentCode == parent.Code).ToList()); treeview1.Nodes.Add(node); } treeview1.ExpandAll(); // 선택된 Node Focus 주기 if ( selectedNodeName != "" ) { TreeNode[] tNodes = this.treeview1.Nodes.Find(selectedNodeName, true); this.treeview1.SelectedNode = tNodes[0]; } } private TreeNode getNodeParent(CodeValueEntity parent) { TreeNode node = new TreeNode(); node.Text = parent.Value; node.Tag = parent.Code; node.Name = parent.Code; node.ImageIndex = 0; node.SelectedImageIndex = 0; return node; } private TreeNode getNodeChild(TreeNode parentNode, List<GroupCodeValueEntity> childs) { foreach (GroupCodeValueEntity child in childs) { TreeNode node = new TreeNode(); node.Text = child.Value; node.Tag = child.Code; node.Name = item.ParentCode + "_||_" + item.Code; node.ImageIndex = 1; node.SelectedImageIndex = 1; parentNode.Nodes.Add(node); } return parentNode; } }