.net 无限级 部门维护（多级部门员工的显示）

protected void GetChildsSN(string Fsn)
    {
        string strsql = "select DepartMentSN from  T_DepartMent where FDSN ='" + Fsn + "'";
        DataTable dt = Hst.DBUtility.DbHelperSQL.Query(strsql).Tables[0];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            AllSn += ",'" + dt.Rows[i][0].ToString() + "'";
            GetChildsSN(dt.Rows[i][0].ToString());
        }         

    }

    string AllSn = "";
    void BindDataList(string strWhere, int PageIndex)
    {      
        string strsql = " select DepartMentSN from T_DepartMent where DepartMentName = '生产部'";
        string Sn = Convert.ToString(Hst.DBUtility.DbHelperSQL.GetSingle(strsql));
        if (Sn != "")
        {
            AllSn = "'" + Sn + "'";
            GetChildsSN(Sn);
            strWhere += " and  DepartMentSN in (" + AllSn + ")";
        }
        else
        {
            strWhere += " and 1<>1";
        }

        Hst.BLL.T_Employee bll = new Hst.BLL.T_Employee();       
        DataList1.DataSource = bll.GetList(strWhere).Tables[0];
        DataList1.DataBind();
         }