public void CreaTree(TreeView tree, int open) { string queryCat; queryCat = "SELECT * FROM CatalogCategories WHERE ParentID = 0"; DataSet dsC = DatabaseConnection.CreateDataset(queryCat); foreach (DataRow dr in dsC.Tables[0].Rows) { TreeNode tv = new TreeNode(); string del = "0"; if (Convert.ToInt32(DatabaseConnection.SqlScalar("SELECT COUNT(*) FROM CATALOGCATEGORIES WHERE PARENTID=" + dr["Id"].ToString())) > 0) { del = "1"; } else if (Convert.ToInt32(DatabaseConnection.SqlScalar("SELECT COUNT(*) FROM CATALOGPRODUCTS WHERE CATEGORY=" + dr["Id"].ToString())) > 0) { del = "1"; } tv.Text = "<a href=\"javascript:copyData('" + dr["Id"].ToString() + "','" + dr["Description"].ToString() + "','" + dr["ParentID"].ToString() + "'," + del + ",'" + ((dr["EMAILOWNER"] != DBNull.Value)?dr["EMAILOWNER"].ToString():string.Empty) + "')\" style=\"color:black;text-decoration:none\">" + dr["Description"].ToString() + "</a>"; tv.NodeData = dr["Id"].ToString(); tv.Expanded = FillCategoryTree(Convert.ToInt32(dr["Id"]), tv, open); // Chiamata ricorsiva per fare le foglie tree.Nodes.Add(tv); } tree.CssClass = "normal"; }
public void CreaTree(TreeView tree, int open) { string queryCat; queryCat = "SELECT * FROM FILESCATEGORIES WHERE PARENTID = 0"; DataSet dsC = DatabaseConnection.CreateDataset(queryCat); TreeNode tv1 = new TreeNode(); tv1.Text = "<a href=\"javascript:copyData('', '','CategoryTextSearch','CategoryIdSearch','Find')\" style=\"color:black;text-decoration:none\">" + Root.rm.GetString("Dsttxt21") + "</a>"; tree.Nodes.Add(tv1); foreach (DataRow dr in dsC.Tables[0].Rows) { TreeNode tv = new TreeNode(); tv.Text = "<a href=\"javascript:copyData('" + dr["Id"].ToString() + "', '" + dr["Description"].ToString() + "','CategoryTextSearch','CategoryIdSearch','Find')\" style=\"color:black;text-decoration:none\">" + dr["Description"].ToString() + "</a>"; tv.NodeData = dr["Id"].ToString(); tv.Expanded = FillCategoryTree(Convert.ToInt32(dr["Id"]), tv, open); // Chiamata ricorsiva per fare le foglie tv.ImageUrl = "/webctrl_client/1_0/treeimages/folder.gif"; tv.ExpandedImageUrl = "/webctrl_client/1_0/treeimages/folderopen.gif"; tree.Nodes.Add(tv); } tree.CssClass = "normal"; }
private TreeView _treeview; // parent #endregion Fields #region Constructors /// <summary> /// Initializes a new instance of a TreeNode. /// </summary> public TreeNode() : base() { _level = -1; _treeview = null; _strInheritedType = null; _NodeTypeIndex = -1; _bBound = false; _Nodes = new TreeNodeCollection(this); }
public void FillTree(Microsoft.Web.UI.WebControls.TreeView tvtemp, string strQueryType) { string strProvID = this.txtProviderID.Text.Trim(); string strProvName = this.txtProviderName.Text.Trim(); string strGoodsID = this.txtGoodsID.Text.Trim(); string strGoodsName = this.txtGoodsName.Text.Trim(); Hashtable htpara = new Hashtable(); htpara.Add("strProvID", strProvID); htpara.Add("strProvName", strProvName); htpara.Add("strGoodsID", strGoodsID); htpara.Add("strGoodsName", strGoodsName); Hashtable htapp = (Hashtable)Application["appconf"]; string strcons = (string)htapp["cons"]; StoBusi = new BusiComm.StorageBusi(strcons); DataTable table = StoBusi.GetProviderStockFillTree(strQueryType, htpara); tvtemp.Nodes.Clear(); if (strQueryType == "prov") { Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode(); node.ID = "0"; node.Text = "供应商"; node.Type = "prov"; node.ImageUrl = "../image/promotion.png"; tvtemp.Nodes.Add(node); } else { Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode(); node.ID = "0"; node.Text = "货品"; node.Type = "good"; node.ImageUrl = "../image/rss.png"; tvtemp.Nodes.Add(node); DataTable dtPClass = (DataTable)Application["PClass"]; foreach (DataRow dr in dtPClass.Rows) { if (dr["vcCommSign"].ToString() == "Pack" || dr["vcCommSign"].ToString() == "Raw") { node = new Microsoft.Web.UI.WebControls.TreeNode(); node.ID = "0"; node.Text = dr["vcCommName"].ToString(); node.Type = "good"; node.ImageUrl = "../image/rss.png"; tvtemp.Nodes[0].Nodes.Add(node); } } } foreach (DataRow row in table.Rows) { if (strQueryType == "prov") { Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode(); node.ID = row["cnvcPrvdCode"].ToString(); node.Text = row["cnvcPrvdName"].ToString(); node.Type = "prov"; node.ImageUrl = "../image/next.png"; tvtemp.Nodes[0].Nodes.Add(node); } else { Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode(); node.ID = row["cnvcGoodsName"].ToString(); node.Text = row["cnvcGoodsName"].ToString(); node.Type = "good"; node.ImageUrl = "../image/next.png"; foreach (Microsoft.Web.UI.WebControls.TreeNode notmp in tvtemp.Nodes[0].Nodes) { if (notmp.Text == row["cnvcProductClassName"].ToString()) { notmp.Nodes.Add(node); break; } } } } }
public void GenerateRegionTree(Microsoft.Web.UI.WebControls.TreeView tr_region) { tr_region.Nodes.Clear(); dictionary.GenerateTree(tr_region); }
public void GenerateTree(Microsoft.Web.UI.WebControls.TreeView tr_region) { BusinessObjectCollection ParentCollection = new BusinessObjectCollection("Dictionary"); ParentCollection.SessionInstance = session; BusinessFilter filter = new BusinessFilter("Dictionary"); filter.AddFilterItem("Parent", Level.Top, Operation.Equal, FilterType.NumberType, AndOr.AND); filter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND); // filter.AddFilterItem("Parent","0",Operation.Equal,FilterType.NumberType,AndOr.AND); // if (type == DictionaryType.Region) // { // filter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else if (type == DictionaryType.Product) // { // filter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else // { // filter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND); // } filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); ParentCollection.AddFilter(filter); DataTable parenttable = ParentCollection.GetDataTable(); for (int i = 0; i < parenttable.Rows.Count; i++) { Microsoft.Web.UI.WebControls.TreeNode node = new TreeNode(); node.NodeData = parenttable.Rows[i]["PKID"].ToString(); node.Text = parenttable.Rows[i]["Name"].ToString(); node.ID = parenttable.Rows[i]["path"].ToString(); tr_region.Nodes.Add(node); BusinessObjectCollection childCollection = new BusinessObjectCollection("Dictionary"); childCollection.SessionInstance = session; BusinessFilter subfilter = new BusinessFilter("Dictionary"); subfilter.AddFilterItem("Parent", parenttable.Rows[i]["PKID"].ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND); subfilter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND); // if (type == DictionaryType.Region) // { // subfilter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else if (type == DictionaryType.Product) // { // subfilter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND); // } // else // { // subfilter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND); // } subfilter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND); childCollection.AddFilter(subfilter); DataTable childtable = childCollection.GetDataTable(); GenerateElement(node, childtable); } }
public static string GetSelectedPath(Microsoft.Web.UI.WebControls.TreeView tv, string index) { Microsoft.Web.UI.WebControls.TreeNode node; node = tv.GetNodeFromIndex(index); return(node.ID); }