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);
}
}
}