/// <summary> /// 根据分类加载项 /// </summary> public void listGoodsLoad() { tvw.Nodes.Clear(); if (this.rdbGoods.Checked == true) { goods.SelectListByWhere(""); propertyClass.SelectListByWhere(""); foreach (DataRow pro in propertyClass.SelectListByWhere("").Rows) { TreeNode node = new TreeNode(pro["CalssName"].ToString()); node.Tag = pro["ClassID"].ToString(); this.tvw.Nodes.Add(node); //遍历所有资产 foreach (DataRow goodsNode in goods.SelectListByWhere("").Rows) { if (pro["ClassID"].ToString() == goodsNode["ClassID"].ToString()) { TreeNode subNode = new TreeNode(goodsNode["GoodsName"].ToString()); node.Nodes.Add(subNode); } } } } if (this.radioButton2.Checked == true) { goods.SelectListByWhere(""); repertory.SelectListByWhere(""); foreach (DataRow pro in repertory.SelectListByWhere("").Rows) { TreeNode node = new TreeNode(pro["RepName"].ToString()); node.Tag = pro["RepID"].ToString(); this.tvw.Nodes.Add(node); //遍历所有资产 foreach (DataRow goodsNode in goods.SelectListByWhere("").Rows) { if (pro["RepID"].ToString() == goodsNode["RepID"].ToString()) { TreeNode subNode = new TreeNode(goodsNode["GoodsName"].ToString()); node.Nodes.Add(subNode); } } } } }
/// <summary> /// 动态加载list /// </summary> public void Repertoryliew() { this.listRepertory.Items.Clear(); NewFolder1.Repertory repertory = new NewFolder1.Repertory(); DataTable dt = repertory.SelectListByWhere(""); foreach (DataRow table in dt.Rows) { ListViewItem item = new ListViewItem(table["RepName"].ToString()); item.SubItems.Add(table["RepID"].ToString()); item.SubItems.Add(table["RepPosition"].ToString()); this.listRepertory.Items.Add(item); } }