protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { e.Layout.Bands[0].HeaderLayout.Reset(); int iIndex = 0; foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns) { c.Header.RowLayoutColumnInfo.OriginY = 1; iIndex++; } Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = null; ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = Convert.ToString(int.Parse(ddlYear.SelectedValue) - 0) + "년"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 1; ch.RowLayoutColumnInfo.SpanX = 4; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = Convert.ToString(int.Parse(ddlYear.SelectedValue) - 1) + "년"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 5; ch.RowLayoutColumnInfo.SpanX = 4; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = Convert.ToString(int.Parse(ddlYear.SelectedValue) - 2) + "년"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 9; ch.RowLayoutColumnInfo.SpanX = 4; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch = e.Layout.Bands[0].Columns.FromKey("MONTH").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = null; ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "목표"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 5; ch.RowLayoutColumnInfo.SpanX = 2; //ch.RowLayoutColumnInfo.SpanY = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "달성율(%)"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 8; ch.RowLayoutColumnInfo.SpanX = 2; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { e.Layout.Bands[0].HeaderLayout.Reset(); string yearStr = ddlYear.SelectedValue; string monthStr = ddlMonth.SelectedValue; string yearTStr = ddlTYear.SelectedValue; string monthTStr = ddlTMonth.SelectedValue; string areaStr = ddlArea.SelectedValue; DataTable dt = GetHeaderTable(yearStr, monthStr, yearTStr, monthTStr, areaStr); int iIndex = 0; foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns) { c.Header.RowLayoutColumnInfo.OriginY = 1; iIndex++; } Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = null; ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "매출량"; ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 0; ch.RowLayoutColumnInfo.SpanX = 1; //ch.RowLayoutColumnInfo.SpanY = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["C_ACTUAL"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 1; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["C_PLAN"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 4; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["P_PAST_ACTUAL"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 7; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["P_PAST_COUNT"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 10; ch.RowLayoutColumnInfo.SpanX = 1; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["P_PAST_RATE"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 11; ch.RowLayoutColumnInfo.SpanX = 1; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["P_PLAN_COUNT"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 12; ch.RowLayoutColumnInfo.SpanX = 1; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = double.Parse(dt.Rows[0]["P_PLAN_RATE"].ToString()).ToString("#,##0.#"); ch.RowLayoutColumnInfo.OriginY = 2; ch.RowLayoutColumnInfo.OriginX = 13; ch.RowLayoutColumnInfo.SpanX = 1; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = ddlYear.SelectedValue + "년" + ddlMonth.SelectedValue + "월~" + ddlTMonth.SelectedValue + "월 실적"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 1; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = ddlYear.SelectedValue + "년 " + ddlMonth.SelectedValue + "월~" + ddlTMonth.SelectedValue + "월 계획"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 4; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "전년동기간 실적"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 7; ch.RowLayoutColumnInfo.SpanX = 3; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "전년대비"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 10; ch.RowLayoutColumnInfo.SpanX = 2; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch.Reset(); ch.Caption = "계획대비"; ch.RowLayoutColumnInfo.OriginY = 0; ch.RowLayoutColumnInfo.OriginX = 12; ch.RowLayoutColumnInfo.SpanX = 2; ch.Style.HorizontalAlign = HorizontalAlign.Center; e.Layout.Bands[0].HeaderLayout.Add(ch); ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true); ch = e.Layout.Bands[0].Columns.FromKey("T_2_NAME").Header; ch.RowLayoutColumnInfo.SpanY = 2; ch.RowLayoutColumnInfo.OriginY = 0; }