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