//树的 实现 private void UserBookSelectFrm_Load(object sender, EventArgs e) { TreeNode rootNode = this.Treeview.Nodes[0]; rootNode.ExpandAll(); TreeNode nodeBook = null; TreeNode nodeJournal = null; foreach (TreeNode nd in rootNode.Nodes) { if (nd.Name == "nodeBook") { nodeBook = nd; } if (nd.Name == "nodeJournal") { nodeJournal = nd; } } foreach (TreeNode nd in rootNode.Nodes) { //添加图书的子节点 if (nd.Name == "nodeBook") { string Conditon = " IdentitySeries='图书'"; dt = bm.SelectView(Conditon); for (int i = 1; i < dt.Rows.Count + 1; i++) { TreeNode node = new TreeNode(dt.Rows[i - 1][0].ToString()); nodeBook.Nodes.Add(node); if (dt.Rows.Count < 20) { nodeBook.Expand(); } } } //添加期刊的子节点 if (nd.Name == "nodeJournal") { string Conditons = " IdentitySeries='期刊'"; dt = bm.SelectView(Conditons); for (int i = 1; i < dt.Rows.Count + 1; i++) { TreeNode node = new TreeNode(dt.Rows[i - 1][0].ToString()); nodeJournal.Nodes.Add(node); if (dt.Rows.Count < 20) { nodeJournal.Expand(); } } } } } private void Treeview_MouseDoubleClick(object sender, MouseEventArgs e) { string Conditon = string.Empty; string SelectText = this.Treeview.SelectedNode.Text; Conditon = string.Format(" PressDate>='{0} ' and PressDate<='{1}'", cbbYear.Text + "/" + cbbMonth.Text, cbbThisYear.Text + "/" + cbbThisMonth.Text); if (SelectText != "图书" || SelectText != "期刊") { Conditon += string.Format(" and BookCatagory ='{0} '", SelectText); } else { return; } dt = bm.UserBookSelect(Conditon); dgvBook.DataSource = dt; NewStyle(); //表的样式 }