protected void LoadHouseTree() { this.tvWarehouse.Nodes.Clear(); dsHouse = objHouse.QueryAllWarehouse(); foreach (DataRow row in dsHouse.Tables[0].Rows) { TreeNode node = new TreeNode(row["WH_NAME"].ToString(), row["WH_CODE"].ToString()); node.Target = "frame"; node.ImageUrl = "../../images/leftmenu/in_warehouse.gif"; tvWarehouse.Nodes.Add(node); } DataSet dsTemp = objArea.QueryAllArea(); if (dsTemp.Tables[0].Rows.Count > 0) { foreach (DataRow r in dsTemp.Tables[0].Rows) { TreeNode nodeHouse = tvWarehouse.FindNode(r["WH_CODE"].ToString()); if (nodeHouse != null) { nodeHouse.ExpandAll(); TreeNode nodeArea = new TreeNode("库区:" + r["AREANAME"].ToString(), r["AREACODE"].ToString()); nodeArea.ToolTip = r["AREA_ID"].ToString(); nodeArea.Target = "frame"; nodeHouse.ChildNodes.Add(nodeArea); } } } dsTemp = objShelf.QueryAllShelf(); foreach (DataRow r2 in dsTemp.Tables[0].Rows) { TreeNode nodeArea = tvWarehouse.FindNode(r2["WH_CODE"].ToString() + "/" + r2["AREACODE"].ToString()); if (nodeArea != null) { TreeNode nodeShelf = new TreeNode("货架:" + r2["SHELFNAME"].ToString(), r2["SHELFCODE"].ToString()); nodeShelf.ToolTip = r2["SHELF_ID"].ToString(); nodeArea.ChildNodes.Add(nodeShelf); } } }
protected void LoadHouseTree() { //tvWarehouse.Attributes.Add("onclick", "postBackByObject()"); this.tvWarehouse.Nodes.Clear(); dsHouse = objHouse.QueryAllWarehouse(); foreach (DataRow row in dsHouse.Tables[0].Rows) { TreeNode node = new TreeNode(row["WH_NAME"].ToString(), row["WH_CODE"].ToString()); node.Target = "frame"; node.ImageUrl = "../../images/leftmenu/in_warehouse.gif"; tvWarehouse.Nodes.Add(node); } DataSet dsTemp = objArea.QueryAllArea(); if (dsTemp.Tables[0].Rows.Count > 0) { foreach (DataRow r in dsTemp.Tables[0].Rows) { TreeNode nodeHouse = tvWarehouse.FindNode(r["WH_CODE"].ToString()); if (nodeHouse != null) { nodeHouse.ExpandAll(); TreeNode nodeArea = new TreeNode("库区:" + r["AREANAME"].ToString(), r["AREACODE"].ToString()); nodeArea.ToolTip = r["AREA_ID"].ToString(); nodeArea.Target = "frame"; nodeHouse.ChildNodes.Add(nodeArea); } } } dsTemp = objShelf.QueryAllShelf(); foreach (DataRow r2 in dsTemp.Tables[0].Rows) { TreeNode nodeArea = tvWarehouse.FindNode(r2["WH_CODE"].ToString() + "/" + r2["AREACODE"].ToString()); if (nodeArea != null) { TreeNode nodeShelf = new TreeNode("货架:" + r2["SHELFNAME"].ToString(), r2["SHELFCODE"].ToString()); nodeShelf.ToolTip = r2["SHELF_ID"].ToString(); nodeArea.ChildNodes.Add(nodeShelf); } } dsTemp = objCell.QueryAllCell(); foreach (DataRow r3 in dsTemp.Tables[0].Rows) { TreeNode nodeShelf = tvWarehouse.FindNode(r3["WH_CODE"].ToString() + "/" + r3["AREACODE"].ToString() + "/" + r3["SHELFCODE"].ToString()); if (nodeShelf != null) { if (!IsPostBack) { nodeShelf.CollapseAll(); } TreeNode nodeCell = new TreeNode("货位:" + r3["CELLNAME"].ToString(), r3["CELLCODE"].ToString()); nodeCell.Text = string.Format("货位:{0}", r3["CELLNAME"].ToString()); nodeCell.ToolTip = r3["CELL_ID"].ToString(); nodeCell.NavigateUrl = "javascript:function(){return false;}"; nodeShelf.ChildNodes.Add(nodeCell); } } }
protected void LoadHouseTree() { tvWarehouse.Attributes.Add("onclick", "postBackByObject()"); this.tvWarehouse.Nodes.Clear(); dsHouse = objHouse.QueryAllWarehouse(); foreach (DataRow row in dsHouse.Tables[0].Rows) { TreeNode node = new TreeNode(row["WH_NAME"].ToString(), row["WH_CODE"].ToString()); node.Target = "frame"; node.ImageUrl = "../../images/leftmenu/in_warehouse.gif"; tvWarehouse.Nodes.Add(node); } DataSet dsTemp = objArea.QueryAllArea(); if (dsTemp.Tables[0].Rows.Count > 0) { foreach (DataRow r in dsTemp.Tables[0].Rows) { TreeNode nodeHouse = tvWarehouse.FindNode(r["WH_CODE"].ToString()); if (nodeHouse != null) { nodeHouse.ExpandAll(); TreeNode nodeArea = new TreeNode("库区:" + r["AREANAME"].ToString(), r["AREACODE"].ToString()); nodeArea.ToolTip = r["AREA_ID"].ToString(); nodeArea.Target = "frame"; nodeHouse.ChildNodes.Add(nodeArea); } } } dsTemp = objShelf.QueryAllShelf(); foreach (DataRow r2 in dsTemp.Tables[0].Rows) { TreeNode nodeArea = tvWarehouse.FindNode(r2["WH_CODE"].ToString() + "/" + r2["AREACODE"].ToString()); if (nodeArea != null) { TreeNode nodeShelf = new TreeNode("货架:" + r2["SHELFNAME"].ToString(), r2["SHELFCODE"].ToString()); nodeShelf.ToolTip = r2["SHELF_ID"].ToString(); nodeArea.ChildNodes.Add(nodeShelf); } } dsTemp = objCell.QueryAllCell(); foreach (DataRow r3 in dsTemp.Tables[0].Rows) { TreeNode nodeShelf = tvWarehouse.FindNode(r3["WH_CODE"].ToString() + "/" + r3["AREACODE"].ToString() + "/" + r3["SHELFCODE"].ToString()); if (nodeShelf != null) { if (!IsPostBack) { nodeShelf.CollapseAll(); } TreeNode nodeCell = new TreeNode("货位:" + r3["CELLNAME"].ToString(), r3["CELLCODE"].ToString()); if (r3["UNITNAME"].ToString().Contains("条")) { nodeCell.Text = string.Format("货位({0}):<font color='#1E7ACE'>{1}</font>", r3["UNITNAME"].ToString(), r3["CELLNAME"].ToString()); } else if (r3["UNITNAME"].ToString().Contains("件")) { nodeCell.Text = string.Format("货位({0}):<font color='#000000'>{1}</font>", r3["UNITNAME"].ToString(), r3["CELLNAME"].ToString()); } else { nodeCell.Text = string.Format("货位({0}):<font color='RED'>{1}</font>", r3["UNITNAME"].ToString(), r3["CELLNAME"].ToString()); } nodeCell.ToolTip = r3["CELL_ID"].ToString(); nodeShelf.ChildNodes.Add(nodeCell); } } }