ASPxGridView后台嵌套

using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DevExpress.Web.ASPxGridView;
using DevExpress.Web.ASPxClasses;
using DevExpress.Data;
using XD.Common;
using System.Xml;
using System.Collections.Generic;
public partial class Master_MasterPage_QueryList: System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        BandData();
    }
    protected void BandData()
    {
        XmlObject obj = XmlObject.Instance(xmlFile);
        Hashtable hash = XmlObject.GetSession("ColumnsShowOrNot_" + xmlFile) as Hashtable;
        List < string > lGroupCols = XmlObject.GetSession("strGroup_" + xmlFile) as List < string > ;
        string strQRY = "";
        strQRY = strMaster == string.Empty ? null : string.Format(strMaster, DropDownList_ConnectionString.Text, "#", strKeyone.Split('|')[0].ToString());
        DataTable dt = XD.DBUtility.DbHelperSQL.Query(strQRY).Tables[0];
        ASPxGridView1.KeyFieldName = "单位编码";
        ASPxGridView1.SettingsDetail.ShowDetailRow = true;
        ASPxGridView1.SettingsText.EmptyDataRow = "无数据";
        ASPxGridView1.SettingsLoadingPanel.Text = "数据加载中，请稍候..";
        ASPxGridView1.SettingsPager.Summary.Text = "  第{0}/{1}页(共{2}条)";
        ASPxGridView1.SettingsPager.PageSize = int.Parse(this.DropDownList_PageSize.Text);
        ASPxGridView1.Settings.ShowFooter = true;
        ASPxGridView1.SettingsBehavior.AllowFocusedRow = true;
        ASPxGridView1.DataSource = dt;
        ASPxGridView1.DataBind();
        XmlObject.SetSession("ChartSource", dt);
        if(!IsPostBack)
        {
            string[] summaryItem = sumByColumn.Split('|');
            for(int i = 0; i < summaryItem.Length; i++)
            {
                ASPxGridView1.TotalSummary.Add(SummaryItemType.Sum, summaryItem[i].ToString()).DisplayFormat = "{0:n}";
            }
            zz = new GridViewCommandColumn();
            zz.VisibleIndex = -1;
            zz.ClearFilterButton.Visible = true;
            zz.ClearFilterButton.Text = "清除";
            ASPxGridView1.Columns.Add(zz);
        }
        ASPxGridView1.Templates.DetailRow = new DetailGridTemplate();
        // ASPxGridView1.SortBy(ASPxGridView1.Columns["单位编码"], ColumnSortOrder.Ascending);
        ASPxGridView1.Columns[1].FixedStyle = GridViewColumnFixedStyle.Left;
        ASPxGridView1.Settings.ShowFilterRow = true;
        ASPxGridView1.SettingsDetail.AllowOnlyOneMasterRowExpanded = true;
        ASPxGridView1.Styles.AlternatingRow.Enabled = DefaultBoolean.True;
        ASPxGridView1.Width = 900;
        ASPxGridView1.Styles.AlternatingRow.BackColor = System.Drawing.Color.FromName("#e0f3f3");
        ASPxGridView1.Styles.Header.BackgroundImage.ImageUrl = "~/images/Gridbg.gif";
        ASPxGridView1.Styles.Header.Border.BorderStyle = BorderStyle.Solid;
        ASPxGridView1.Styles.Header.Border.BorderColor = System.Drawing.Color.Teal;
        ASPxGridView1.Styles.FocusedRow.BackColor = System.Drawing.Color.FromName("#8ab5b5");
        ASPxGridView1.Styles.Footer.BackColor = System.Drawing.Color.FromName("#c2d4d4");
        ASPxGridView1.Styles.LoadingPanel.BackColor = System.Drawing.Color.FromName("#8ab5b5");
        ASPxGridView1.CollapseAll();
        //ASPxGridView1.SettingsLoadingPanel;
        //ASPxGridView1.DetailRows.ExpandRow(0);//第一行展开    
    }
}
public class DetailGridTemplate: ITemplate
{
    Control parent;
    object masterKey;
    ASPxGridView detailGrid;
    public void InstantiateIn(Control container)
    {
        parent = container;
        masterKey = ((GridViewDetailRowTemplateContainer) parent).KeyValue;
        CreateDetailGrid();
    }
    private void CreateDetailGrid()
    {
        detailGrid = new ASPxGridView();
        detailGrid.ID = "detailGrid";
        //detailGrid.AutoGenerateColumns = false;
        //在模板中追加detailGrid控件
        parent.Controls.Add(detailGrid);
        //创建明细Grid列 方法
        //CreateDetailColumns(detailGrid);
        //detailGrid.KeyFieldName = "单位名称";
        //指定明细数据源，这里可以根据上面取得的masterKey 作为明细数据源的参数
        //通过自定GetDetailDataSource()方法取得
        //detailGrid.SettingsBehavior.AllowFocusedRow = true;
        DataTable dt = CompareData(HttpContext.Current.Session["xmlFileName"].ToString(), GetDetailDataSource(masterKey));
        //dt.Columns.Remove("总数");
        //-----------------------------记录生成报表SQL语句-----------------------------------//
        //XmlObject.SetSession("strSQL_" + HttpContext.Current.Session["xmlFileName"].ToString(),GetSqlString().Replace(HttpContext.Current.Session["strKey"].ToString(),""));
        //--------------------------------------记录生成Excel表----------------------------//
        //DataTable dtNew=XD.DBUtility.DbHelperSQL.Query(GetSqlString().Replace(HttpContext.Current.Session["strKey"].ToString(),"")).Tables[0];
        //dtNew.Columns.Remove("总数");
        detailGrid.DataSource = dt.DefaultView;
        detailGrid.SettingsText.EmptyDataRow = "无子单位数据^o^";
        detailGrid.KeyFieldName = "单位编码";
        detailGrid.DataBind();
        detailGrid.Settings.ShowFilterRow = true;
        detailGrid.Settings.ShowHorizontalScrollBar = true;
        detailGrid.SettingsDetail.ShowDetailRow = true;
        detailGrid.SettingsPager.Summary.Text = "  第{0}/{1}页(共{2}条)";
        detailGrid.Width = 900;
        detailGrid.SettingsDetail.IsDetailGrid = true;
        detailGrid.SettingsLoadingPanel.Text = "数据加载中，请稍候..";
        detailGrid.Settings.ShowFooter = true;
        detailGrid.Styles.AlternatingRow.Enabled = DefaultBoolean.True;
        detailGrid.SettingsDetail.AllowOnlyOneMasterRowExpanded = true;
        detailGrid.SettingsDetail.ShowDetailButtons = true;
        detailGrid.Styles.AlternatingRow.BackColor = System.Drawing.Color.FromName("#e0f3f3");
        detailGrid.Styles.Header.BackgroundImage.ImageUrl = "~/images/Gridbg.gif";
        detailGrid.Styles.Header.Border.BorderStyle = BorderStyle.Solid;
        detailGrid.Styles.Header.Border.BorderColor = System.Drawing.Color.Teal;
        detailGrid.Styles.FocusedRow.BackColor = System.Drawing.Color.FromName("#8ab5b5");
        detailGrid.Styles.Footer.BackColor = System.Drawing.Color.FromName("#c2d4d4");
        detailGrid.Styles.LoadingPanel.BackColor = System.Drawing.Color.FromName("#8ab5b5");
        detailGrid.Border.BorderColor = System.Drawing.Color.Teal;
        detailGrid.DetailRowExpandedChanged += new ASPxGridViewDetailRowEventHandler(detailGrid_DetailRowExpandedChanged);
        //追加明细Grid更新事件
        //detailGrid.RowUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(detailGrid_RowUpdating);
        // 类似可追加 RowDeleting 和 RowInserting
    }
    void detailGrid_DetailRowExpandedChanged(object sender, ASPxGridViewDetailRowEventArgs e)
        {
            // HttpContext.Current.Response.Write(e.VisibleIndex.ToString());
            DataRowView row = (DataRowView)((ASPxGridView) sender).GetRow(e.VisibleIndex);
            string strID = row.DataView.Table.Rows[e.VisibleIndex][1].ToString();
            string strkeyTemp = HttpContext.Current.Session["strKey"].ToString();
            string strsqls = "select 1 from Sys_DataField where DfParentCode='{0}'";
            DataTable dtss = XD.DBUtility.DbHelperSQL.Query(string.Format(strsqls, strID)).Tables[0];
            if(dtss.Rows.Count == 0)
            {
                ((ASPxGridView) sender).Templates.DetailRow = new DetailGridTemplateFou();
                HttpContext.Current.Session["strKey"] = HttpContext.Current.Session["strKeyTwo"].ToString();
                HttpContext.Current.Session["Flag"] = "1";
            }
            else
            {
                ((ASPxGridView) sender).Templates.DetailRow = new DetailGridTemplateOne();
                HttpContext.Current.Session["strKey"] = strkeyTemp;
                HttpContext.Current.Session["Flag"] = "0";
            }
        }
        /// <summary>
        /// 对detail内数据格式化
        /// </summary>
        /// <param name="xmlfile"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
    protected DataTable CompareData(string xmlfile, DataTable dt)
    {
        XmlDocument doc = new XmlDocument();
        doc.Load(HttpContext.Current.Server.MapPath("~/App_Data/" + xmlfile));
        XmlNodeList columnList = doc.SelectNodes("/table/columns/column");
        XmlObject obj = XmlObject.Instance(xmlfile);
        foreach(DataColumn DcolName in dt.Columns)
        {
            foreach(XmlNode node in columnList)
            {
                if(node.SelectSingleNode("cnName").InnerText == DcolName.ColumnName && node.SelectSingleNode("type").InnerText == "double")
                {
                    for(int i = 0; i < dt.Rows.Count; i++)
                    {
                        if(dt.Rows[i][DcolName.ColumnName].ToString() != "")
                        {
                            dt.Rows[i][DcolName.ColumnName] = string.Format("{0:n}", decimal.Parse(dt.Rows[i][DcolName.ColumnName].ToString()));
                        }
                    }
                }
            }
        }
        return dt;
    }
    protected DataTable CompareDataFromCS(DataTable dt)
    {
        for(int i = 0; i < dt.Rows.Count; i++)
        {
            decimal b = 0;
            foreach(DataColumn DcolName in dt.Columns)
            {
                dt.Rows[i][DcolName.ColumnName] = decimal.TryParse(dt.Rows[i][DcolName.ColumnName].ToString(), out b) ? string.Format("{0:n}", b) : dt.Rows[i][DcolName.ColumnName].ToString();
            }
        }
        return dt;
    }
    private DataTable GetDetailDataSource(object masterKey)
    {
        return XD.DBUtility.DbHelperSQL.Query(string.Format(HttpContext.Current.Session["strMaster"].ToString(), HttpContext.Current.Session["DropDownList_ConnectionString"].ToString(), (string) masterKey, HttpContext.Current.Session["strKeyOne"].ToString().Split('|')[1].ToString())).Tables[0];
    }
    public string GetSqlString()
    {
        return "";
    }
}