C# SQL 的拼接Union和循环遍历子节点

SQL 的拼接Union和循环

随便写的拼接。
最后一次不用union。

SQL 的拼接Union

// An highlighted block
 List<string> item = db.Fetch<string>(@"select a.id from User_FunctionalModule a  where a.ParentId = @0", pa.Id);
 all.AddRange(item);
 for (int i = 0; i < all.Count; i++)
                        {
                            sql.Append(@"select a.*,c.id as [PowerId],0 as [Open], 0 as [IsParent] from 	User_FunctionalModule a left join  (select * from User_Relevance b where b.AcceptId = @0) c on a.Id = c.PassiveId  where a.id  = @1  ", pa.RoleId, all[i]");                          
                            if (i != all.Count - 1)
                                sql.Append(" union all ");
                        }
                        sql.Append(" order by [CreateTime]");;

循环遍历子节点Id

// An highlighted block
/// Bll层，对string[] Id进行转换，用list b进行保存，然后再把list转换成string[] Id;
 	List<string> b = Id.ToList();
            foreach (var it in Id)
            {             
                GetIds(it, b);
            }
            Id = b.ToArray();
//使用子节点方法
   private void GetIds(string id, List<string> list)
        {
            var result = DbInstance.CreateDataBase().Fetch<string>("select a.Id from User_FunctionalModule WHERE ParentId = @0", id);
            if (result.Count > 0)
            {
                foreach (var item in result)
                {
                    list.Add(item);
                    GetIds(item, list);
                }
            }
        }