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 ""; }}