数据库格式

1588558901501-b71938ac-3652-41bf-91ba-adadc3b80799.png

代码:

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Data.SqlClient;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Windows.Forms;
  9. namespace Sign_plate_management_system
  10. {
  11.     public static class BindTVData
  12.     {
  13.         private static DataTable dt = null;
  15.         //获取数据库所有数据
  16.         public static DataTable InitDataTable()
  17.         {
  18.             SqlConnection conn = new SqlConnection($"Server={ MyDBControls.Server };database={ MyDBControls.Dbase};uid={ MyDBControls.Uid };pwd={ MyDBControls.Pwd}");
  19.             SqlDataAdapter sda = new SqlDataAdapter("select * from TVNodesInfo", conn);
  20.             dt = new DataTable();
  21.             sda.Fill(dt);
  22.             return dt;
  23.         }
  24.         //绑定根节点
  25.         public static void BindRootNode(TreeView trv)
  26.         {
  27.             DataRow[] rows = InitDataTable().Select("NodeTagID=0");
  28.             //取根
  29.             foreach (DataRow dRow in rows)
  30.             {
  31.                 TreeNode rootNode = new TreeNode
  32.                 {
  33.                     Tag = (int)dRow["ID"],
  34.                     Text = dRow["NodeText"].ToString(),
  35.                     Name= dRow["NodeName"].ToString()
  36.                 };
  37.                 trv.Nodes.Add(rootNode);
  38.                 BindChildNode(rootNode);
  39.             }
  40.         }
  41.         //递归绑定子区域
  42.         private static void BindChildNode(TreeNode FNode)
  43.         {
  44.             //父节点数据关联的数据行
  45.             int nodetagId = (int)FNode.Tag;
  46.             //父节点ID
  47.             DataRow[] rows = dt.Select($"NodeTagID={nodetagId}");
  48.             //子区域
  49.             if (rows.Length == 0)//递归终止，区域不包含子区域时
  50.             {
  51.                 return;
  52.             }
  53.             foreach (DataRow dRow in rows)
  54.             {
  55.                 TreeNode node = new TreeNode
  56.                 {
  57.                     Tag = (int)dRow["ID"],
  58.                     Text = dRow["NodeText"].ToString(),
  59.                     Name = dRow["NodeName"].ToString()
  60.                 };
  61.                 //添加子节点
  62.                 FNode.Nodes.Add(node);
  63.                 //递归
  64.                 BindChildNode(node);
  65.             }
  66.         }
  67.     }
  68. }