我有一个任务有问题。

我需要计算直接或间接向特定经理报告的所有下属（与众不同）

我有一个Employee这样的表：

EMPLOYEE_ID Int,MANAGER_ID Int,EMPLOYEE_NAME varchar(200)

例子：

            Alex(1)
    --------------------
    Jhon(2)          Kevin(3)
------------------------------
Mike(4) Amanda(5)  Tom(6) Jery(7)

我只能算直接向经理汇报的员工：

SELECT 
    MANAGER_ID,COUNT(MANAGER_ID) as SubCount
FROM [dbo].[EMPLOYEE]
GROUP BY MANAGER_ID

但是结果是我有这样的事情：

Manager_ID | SubCount
----------------------
1          | 2
2          | 2
3          | 2
----------------------

反而：

Manager_ID | SubCount
----------------------
1          | 6
2          | 2
3          | 2
----------------------

如果有任何建议或想法，我将很高兴。

解决方法

if(crashes >= ((NumberOfTimesUserLaunched + 1) * 10)) -> Show notification

public class FamilyMember
    {
        /// <summary>
        /// 身份
        /// </summary>
        public string identity { get; set; }
        public int level { get; set; }
        /// <summary>
        /// 父亲
        /// </summary>
        public string father { get; set; }
    }

/// <summary>
        /// 递归获取晚辈
        /// </summary>
        /// <param name="members"></param>
        /// <param name="m"></param>
        /// <returns></returns>
        public static List<FamilyMember> GetYoungers(List<FamilyMember> members, FamilyMember m)
        {
            var result = new List<FamilyMember>();

            //获取子女
            var subordinate = members.Where(e => e.father == m.identity).ToList();

            //如果存在子女
            if (subordinate != null)
            {
                result.AddRange(subordinate);
                foreach (var subo in subordinate)
                {
                    result.AddRange(GetYoungers(members, subo));
                }
            }

            return result;
        }

/// <summary>
        /// 测试递归
        /// </summary>
        public static void CheckRecursion()
        {
            List<FamilyMember> list = new List<FamilyMember>
            {
                new FamilyMember{ identity = "爷爷", level = 1, father = ""},
                new FamilyMember{ identity = "爸爸", level = 2, father = "爷爷"},
                new FamilyMember{ identity = "叔叔", level = 2, father = "爷爷"},
                new FamilyMember{ identity = "自己", level = 3, father = "爸爸"},
                new FamilyMember{ identity = "弟弟", level = 3, father = "爸爸"},
                new FamilyMember{ identity = "堂兄", level = 3, father = "叔叔"},
                new FamilyMember{ identity = "堂弟", level = 3, father = "叔叔"},
                new FamilyMember{ identity = "儿子", level = 4, father = "自己"},
                new FamilyMember{ identity = "女儿", level = 4, father = "自己"},
                new FamilyMember{ identity = "侄子", level = 4, father = "弟弟"},
                new FamilyMember{ identity = "侄女", level = 4, father = "弟弟"}
            };

            var self = new FamilyMember { identity = "爷爷", level = 1, father = "" };

            var youngers = GetYoungers(list, self).OrderBy(p => p.level).ToList();
            if(youngers != null)
            {
                foreach(var p in youngers)
                {
                    Console.WriteLine(p.identity);
                }
            }
        }