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 "";
}
}
ASPxGridView后台嵌套
于 2009-11-18 14:49:00 首次发布