using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.IO;namespace 资料管理器{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void Form1_Load(object sender, EventArgs e)        {            //加载类别到TreeView            LoadCategoryToTree(treeView1.Nodes, GetCategoriesByParentId(-1));            //设置TreeView中节点单击的时候显示右键菜单            AddMouseClickShowContentMenu();        }        private void AddMouseClickShowContentMenu()        {            //遍历TreeView的每个节点            SearchNode(treeView1.Nodes);        }        private void SearchNode(TreeNodeCollection treeNodeCollection)        {            foreach (TreeNode item in treeNodeCollection)            {                if (item.Level == 1)                {                    item.ContextMenuStrip = contextMenuStrip1;                }                SearchNode(item.Nodes);            }        }        //递归加载类别信息到TreeView        private void LoadCategoryToTree(TreeNodeCollection treeNodeCollection, List
     
       list)        {            foreach (Category item in list)            {                //把当前节点加到treeNodeCollection集合中                TreeNode tnode = treeNodeCollection.Add(item.TName);                //把当前类别的Id记录到Tag中。                tnode.Tag = item.TId;                //List
      
        listSub = GetCategoriesByParentId(item.TId);                //if (listSub.Count == 0)                //{                //    tnode.ContextMenuStrip = contextMenuStrip1;                //}                LoadCategoryToTree(tnode.Nodes, GetCategoriesByParentId(item.TId));            }        }        private List
       
         GetCategoriesByParentId(int pid)        {            List
        
          list = new List
         
          ();            string sql = "select tid,tname from Category where tParentId=@pid";            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@pid", pid)))            {                if (reader.HasRows)                {                    while (reader.Read())                    {                        Category model = new Category();                        model.TId = reader.GetInt32(0);                        model.TName = reader.GetString(1);                        list.Add(model);                    }                }            }            return list;        }        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)        {            if (e.Node != null)            {                LoadTitleToListBox(e.Node);            }        }        private void LoadTitleToListBox(TreeNode node)        {            //获取当前节点对应的类别id            int categoryId = (int)node.Tag;            //从文章表中查询dtid为categoryId的所有文章            List
          
            list = GetContentByCategoryId(categoryId); listBox1.Items.Clear(); //遍历list集合将文章信息加到Listbox中 foreach (var item in list) { listBox1.Items.Add(item); } } private List
           
             GetContentByCategoryId(int categoryId) { List
            
              list = new List
             
              (); //select did,dname from ContentInfo where dtid=@categoryId using (SqlDataReader reader = SqlHelper.ExecuteReader("select did,dname from ContentInfo where dtid=@categoryId", new SqlParameter("@categoryId", categoryId))) { if (reader.HasRows) { while (reader.Read()) { ContentInfo model = new ContentInfo(); model.DId = reader.GetInt32(0); model.DName = reader.GetString(1); list.Add(model); } } } return list; } private void listBox1_MouseClick(object sender, MouseEventArgs e) { } private void listBox1_MouseDoubleClick(object sender, MouseEventArgs e) { //ListBox的鼠标双击事件 // e. if (listBox1.SelectedItem != null) { //获取选中项中的文章的Id ContentInfo article = listBox1.SelectedItem as ContentInfo; int id = article.DId; textBox1.Text = GetContentInfoByContentId(id); } } //根据文章Id获取文章内容 private string GetContentInfoByContentId(int id) { //string sql = "select dcontent from ContentInfo where did=@id"; //using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@id", id))) //{ // if (reader.HasRows) // { // if (reader.Read()) // { // return reader.GetString(0); // } // } //} //return string.Empty; string sql = "select dcontent from ContentInfo where did=@id"; return SqlHelper.ExecuteScalar(sql, new SqlParameter("@id", id)).ToString(); } private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { treeView1.SelectedNode = e.Node; } private void 导入文章ToolStripMenuItem_Click(object sender, EventArgs e) { if (treeView1.SelectedNode != null) { //获取当前选中类别的categoryId int categoryId = (int)treeView1.SelectedNode.Tag; openFileDialog1.Multiselect = false; openFileDialog1.Filter = "txt files (*.txt)|*.txt"; openFileDialog1.FileName = string.Empty; //导入文章 //1.弹出一个选择路径的一个对话框 DialogResult result = openFileDialog1.ShowDialog(); if (result == System.Windows.Forms.DialogResult.OK) { //获取用户选择的文件的路径 string path = openFileDialog1.FileName; string title = Path.GetFileNameWithoutExtension(path); string content = File.ReadAllText(path, System.Text.Encoding.Default); //执行insert语句将该文章导入到数据库中 string sql = "insert into ContentInfo(dtid,dname,dcontent) values(@categoryId,@title,@content)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@categoryId",categoryId), new SqlParameter("@title",title), new SqlParameter("@content",content) }; //直接执行插入语句 SqlHelper.ExecuteNonQuery(sql, pms); } //重新加载ListBox LoadTitleToListBox(treeView1.SelectedNode); } } }}