• 递归小案例(转载整理)


    1.sql语句实现

     //获取所有子级

    WITH temps  
    AS  
    (  
    SELECT * FROM [its].[dbo].[Citys]  WHERE areaid = 2  
    UNION ALL  
    SELECT m.* FROM [its].[dbo].[Citys]  AS m  
    INNER JOIN temps AS child ON m.ParentId = child.areaid  
    )  
    SELECT * FROM temps

     

     //获取所有父级

    WITH TEMP AS
    (
    SELECT * FROM [its].[dbo].[Citys] WHERE areaid='2' --表的主键ID
    UNION ALL
    SELECT T0.* FROM TEMP,[its].[dbo].[Citys] T0 WHERE TEMP.ParentId=T0.areaid --父级ID==子级ID
    )
    SELECT * FROM TEMP;

    2.C#实现

    using System;
    using System.Collections.Generic;
    using System.Linq;
    
    namespace ConsoleApp1
    {
        class Program
        {
            static void Main(string[] args)
            {
    
                var data = GetData();
    
                //获取所有下级
                var query = GetSons(data, 1);
    
                //获取所有上级
                //var query = GetFatherList(data, 5);
                Console.WriteLine("Id	 区划	 父ID	 层级	");
                query.ToList().ForEach(q => Console.WriteLine("{0}	 {1}	 {2}	 {3}	", q.Id, q.Name, q.Fid, q.Level));
    
                Console.ReadLine();
            }
    
            #region 测试数据
            public static IList<menu> GetData()
            {
                var list = new List<menu>();
                list.Add(new menu { Id = 1, Name = "广东省", Fid = 0, Level = 1 });
                list.Add(new menu { Id = 2, Name = "深圳市", Fid = 1, Level = 2 });
                list.Add(new menu { Id = 3, Name = "南山区", Fid = 2, Level = 3 });
                list.Add(new menu { Id = 4, Name = "福田区", Fid = 2, Level = 3 });
                list.Add(new menu { Id = 5, Name = "上梅林", Fid = 4, Level = 4 });
                list.Add(new menu { Id = 6, Name = "下梅林", Fid = 4, Level = 4 });
                list.Add(new menu { Id = 7, Name = "车公庙", Fid = 4, Level = 4 });
                list.Add(new menu { Id = 8, Name = "蛇口", Fid = 5, Level = 4 });
                list.Add(new menu { Id = 9, Name = "科技园", Fid = 5, Level = 4 });
                list.Add(new menu { Id = 10, Name = "湖南省", Fid = 0, Level = 1 });
                list.Add(new menu { Id = 11, Name = "长沙市", Fid = 10, Level = 2 });
                list.Add(new menu { Id = 12, Name = "芙蓉区", Fid = 11, Level = 3 });
                return list;
            }
            #endregion
    
            #region 获取所有下级
            public static IEnumerable<menu> GetSons(IList<menu> list, int Fid)
            {
                var query = list.Where(p => p.Id == Fid).ToList();
                var list2 = query.Concat(GetSonList(list, Fid));
                return list2;
            }
    
            public static IEnumerable<menu> GetSonList(IList<menu> list, int Fid)
            {
                var query = list.Where(p => p.Fid == Fid).ToList();
                return query.ToList().Concat(query.ToList().SelectMany(t => GetSonList(list, t.Id)));
            }
            #endregion
    
            #region 获取所有上级
            public static IEnumerable<menu> GetFatherList(IList<menu> list, int Id)
            {
                var query = list.Where(p => p.Id == Id).ToList();
                return query.ToList().Concat(query.ToList().SelectMany(t => GetFatherList(list, t.Fid)));
            }
            #endregion
    
            #region 实体类
            public class menu
            {
                public int Id { set; get; }
                public string Name { set; get; }
                public int Fid { set; get; }
                public int Level { set; get; }
            }
            #endregion
        }
    }

     

  • 相关阅读:
    Linux CentOS7.0 (04)systemctl vs chkconfig、service
    SpringCloud是否值得引入?
    SpringCloud的Hystrix(二) 某消费者应用(如:ui、网关)访问的多个微服务的断路监控
    SpringCloud的Hystrix(一) 一个消费者内的两个服务监控
    SpringCloud的Bus(一)消息中间件的概念和用途
    api-gateway实践(13)新服务网关
    SpringCloud应用入库后乱码问题
    SpringCloud的应用发布(四)vmvare+linux,网关代理
    SpringCloud的DataRest(四)restful特性展示
    win10 如何让其他机器访问自己机器上的mysql
  • 原文地址:https://www.cnblogs.com/LiChen19951127/p/11005323.html
Copyright © 2020-2023  润新知