c# 树形结构的数据获取方法

///
/// 取所有子类(包括自己)的id(record_sta字段)
///
/// 记录id
/// 表名
/// 数据库名
/// id字符串（用,相隔）
public static string Get_All_Child_ids(int id, string Table_Name, string DB_Name)
{
string return_str = id.ToString();

        string sql = "select id from " + Table_Name + " where record_sta=1 and Parent_Id=" + Convert.ToString(id);
        DataSet ds =DataBaseHelper.Get_DS(sql, DB_Name);

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            return_str = return_str + "," + Get_All_Child_ids(Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()), Table_Name, DB_Name);
        }

        ds.Dispose();

        return return_str;
    }


    /// <summary>
    /// 取所有子类(包括自己)的id(Record_sta字段)
    /// </summary>
    /// <param name="id">记录id</param>
    /// <param name="Table_Name">表名</param>
    /// <param name="DB_Name">数据库名</param>
    /// <param name="n">int（随便...）</param>
    /// <returns>id字符串（用,相隔）</returns>
    public static string Get_All_Child_ids(int id, string Table_Name, string DB_Name, int n)
    {
        string return_str = id.ToString();

        string sql = "select id from " + Table_Name + " where Record_sta=1 and parent_id=" + Convert.ToString(id);
        DataSet ds = DataBaseHelper.Get_DS(sql, DB_Name);

        for (int i = 0; i < ds.Tables[0].Rows.