protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
///e.Layout.Bands[0].HeaderLayout.Reset();
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누계";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 6;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "증감액";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "달성율";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
protected void ugrdInPower_InitializeLayout(object sender, LayoutEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당월 누적";
ch.Style.HorizontalAlign = HorizontalAlign.Center;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 3;
e.Layout.Bands[0].HeaderLayout.Add(ch);
}
protected void ugrdPrjList_InitializeLayout(object sender, LayoutEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
}
// 단일 헤더 합침
ch = e.Layout.Bands[0].Columns.FromKey("PRJ_CODE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("PRJ_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("PROCEED_RATE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("OWNER_EMP_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("TASK_OWNER_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("EFFECTIVENESS").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획기간";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "비 용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
private void InitializeGrid(UltraWebGrid grid)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in grid.DisplayLayout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
}
// 단일 헤더 합침
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_CODE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PRJ_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("PROCEED_RATE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("OWNER_EMP_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("TASK_OWNER_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = grid.DisplayLayout.Bands[0].Columns.FromKey("EFFECTIVENESS").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획기간";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "비 용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
protected void ugrdMScore_InitializeLayout(object sender, LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
for (int i = 0; i < this.IcntCol; i++)
{
//e.Layout.Bands[0].Columns[i * 6].Hidden = true;
//e.Layout.Bands[0].Columns[i * 6 + 1].Hidden = true;
//e.Layout.Bands[0].Columns[i * 6 + 5].Hidden = true;
e.Layout.Bands[0].Columns[i * 3].Header.Caption = "순위";
e.Layout.Bands[0].Columns[i * 3 + 1].Header.Caption = "부서명";
e.Layout.Bands[0].Columns[i * 3 + 2].Header.Caption = "점수";
/*
* e.Layout.Bands[0].Columns[i * 6 + 2].Header.RowLayoutColumnInfo.OriginX = (i * 3) + 0;
* e.Layout.Bands[0].Columns[i * 6 + 3].Header.RowLayoutColumnInfo.OriginX = (i * 3) + 1;
* e.Layout.Bands[0].Columns[i * 6 + 4].Header.RowLayoutColumnInfo.OriginX = (i * 3) + 2;
*/
e.Layout.Bands[0].Columns[i * 3].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[i * 3 + 1].CellStyle.HorizontalAlign = HorizontalAlign.Left;
e.Layout.Bands[0].Columns[i * 3 + 2].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i * 3].Width = Unit.Pixel(30);
e.Layout.Bands[0].Columns[i * 3 + 1].Width = Unit.Pixel(70);
e.Layout.Bands[0].Columns[i * 3 + 2].Width = Unit.Pixel(50);
//e.Layout.Bands[0].Columns[i * 6 + 2].MergeCells = true;
}
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
for (int i = 0; i < this.IcntCol; i++)
{
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = String.Format("{0}월", i + 1);
ch.Style.HorizontalAlign = HorizontalAlign.Center;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = i * 3;
ch.RowLayoutColumnInfo.SpanX = 3;
e.Layout.Bands[0].HeaderLayout.Add(ch);
}
}
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 ugrdUser_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "성과관리부서";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "기간시스템부서";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 5;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[9].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanY = 2;
/*
* ugrdUser.DisplayLayout.Pager.AllowCustomPaging = true;
* ugrdUser.DisplayLayout.Pager.AllowPaging = true;
* ugrdUser.DisplayLayout.Pager.StyleMode = PagerStyleMode.Numeric;
*/
}
protected void ugrdDeptEmp_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "성과관리시스템";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(17);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "기간계시스템";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(17);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "상태";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(17);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[5].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanY = 2;
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당기";
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.Caption = "전기";
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 = e.Layout.Bands[0].Columns.FromKey("DADT_1").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, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
e.Layout.Bands[0].Reset();
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "구분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "주택.난방용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "일반용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "냉방용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "산업용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "열병합용(상:공동, 하:특정건물)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "지역난방";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 13;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "수송용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 16;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "기본요금";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 17;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "투자재원";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 19;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평균단가";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 20;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "공급비용";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 21;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[7].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[16].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 16;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[19].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 19;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[20].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 20;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[21].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 21;
ch.RowLayoutColumnInfo.SpanY = 2;
int intCol = UltraWebGrid1.Bands[0].Columns.Count;
for (int i = 1; i < intCol; i++)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Width = 80;
e.Layout.Bands[0].Columns[i].Format = "#,##0.#0";
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
int intWid = 0;
int intCntCol = e.Layout.Bands[0].Columns.Count;
e.Layout.Bands[0].HeaderLayout.Reset();
if (ddlGbn.SelectedValue == "HS")
{
for (int i = 0; i < intCntCol; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
e.Layout.Bands[0].Columns[i].Width = 64;
}
else if (i == 1)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[i].Width = 43;
}
else
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
//e.Layout.Bands[0].Columns[i].Width = (i < 7) ? 30 : (30 + intWid++);
e.Layout.Bands[0].Columns[i].Width = 44;
}
}
}
else
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "금 일(차이:계획-실적)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전 일(차이:금일-전일)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전년동일(차이:금일-전년동일)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전전년동일(차이:금일-전전년동일)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 12;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
intWid = 800;
for (int i = 0; i < intCntCol; i++)
{
switch (i % 4)
{
case 0:
e.Layout.Bands[0].Columns[i].Header.Caption = "계획";
break;
case 1:
e.Layout.Bands[0].Columns[i].Header.Caption = "실적";
break;
case 2:
e.Layout.Bands[0].Columns[i].Header.Caption = "달성율";
break;
case 3:
e.Layout.Bands[0].Columns[i].Header.Caption = "차이";
break;
default:
break;
}
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
e.Layout.Bands[0].Columns[i].Width = (intCntCol == 0) ? 0 : Convert.ToInt32((intWid / intCntCol));
}
}
}
protected void ugrdSignal_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "표시상태";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "등급구간";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평가 Table";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
switch (i)
{
case 0:
e.Layout.Bands[0].Columns[i].Width = 80;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
break;
case 1:
e.Layout.Bands[0].Columns[i].Width = 35;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
break;
case 2:
e.Layout.Bands[0].Columns[i].Width = 78;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Center;
break;
case 3:
e.Layout.Bands[0].Columns[i].Width = 125;
e.Layout.Bands[0].Columns[i].DataType = "System.Double";
e.Layout.Bands[0].Columns[i].Format = "###,###,###,###,###,###,###,###,###,##0.#####";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
break;
case 4:
e.Layout.Bands[0].Columns[i].Header.Caption = "달성율";
e.Layout.Bands[0].Columns[i].Width = 63;
e.Layout.Bands[0].Columns[i].DataType = "System.Double";
e.Layout.Bands[0].Columns[i].Format = "###,###,###,###,###,###,###,###,###,##0.##";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
break;
case 5:
e.Layout.Bands[0].Columns[i].Width = 62;
e.Layout.Bands[0].Columns[i].Format = "###,###,###,###,###,###,###,###,###,##0.##";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
break;
default:
//e.Layout.Bands[0].Columns[i].Hidden = true;
break;
}
}
}
protected void uGrid_InitializeLayout(object sender, LayoutEventArgs e)
{
///e.Layout.Bands[0].HeaderLayout.Reset();
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "향후추정";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
int month = DataTypeUtility.GetToInt32(YMD.Substring(4, 2));
if (month >= 4 && month <= 6)
{
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Hidden = false;
}
else if (month >= 7 && month <= 9)
{
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Hidden = false;
}
else if (month >= 10 && month <= 12)
{
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Width = Unit.Pixel(0);
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Width = Unit.Pixel(60);
e.Layout.Bands[0].Columns.FromKey("2Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("3Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("4Q_EXPT_RESULT_TS").Hidden = false;
e.Layout.Bands[0].Columns.FromKey("EXPT_RESULT_TS_SUM").Hidden = false;
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
int year = 2010;
///e.Layout.Bands[0].HeaderLayout.Reset();
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전년동기실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "'"+year.ToString()+"년 상반기";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 4;
//ch.RowLayoutColumnInfo.SpanX = 8;
//ch.Style.Height = Unit.Pixel(20);
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "달성율";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 4;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "사업계획대비";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전년동기대비";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
private void InitializeGrid(UltraWebGrid grid)
{
grid.DisplayLayout.Bands[0].HeaderLayout.Reset();
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in grid.DisplayLayout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "월";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 0;
//ch.RowLayoutColumnInfo.SpanX = 1;
//ch.Style.Height = Unit.Pixel(20);
//grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
//grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = this.GetText("LBL_00012", "Target");
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = this.GetText("LBL_00011", "Goal"); //_itarget_mod_name;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
grid.DisplayLayout.Bands[0].HeaderLayout.Add(ch);
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
grid.DisplayLayout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = grid.DisplayLayout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = grid.DisplayLayout.Bands[0].Columns[7].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = grid.DisplayLayout.Bands[0].Columns[8].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanY = 2;
for (int i = 0; i < grid.DisplayLayout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
grid.DisplayLayout.Bands[0].Columns[i].Width = 80;
grid.DisplayLayout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Center;
}
else if (i > 0 && i < 5)
{
grid.DisplayLayout.Bands[0].Columns[i].DataType = "System.Double";
grid.DisplayLayout.Bands[0].Columns[i].Format = "###,###,###,###,###,###,##0.####";
grid.DisplayLayout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
else
{
//grid.DisplayLayout.Bands[0].Columns[i].Width = 100;
//grid.DisplayLayout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
}
}
protected void ugrdWorkTaskList_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "사용여부";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "세부일정명칭";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "가중치(%)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "집행율(%)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "관리항목수";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[1].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[2].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[9].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[10].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanY = 2;
}
protected void ugrdResultTotal_InitializeLayout(object sender, LayoutEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
}
// 단일 헤더 합침
ch = e.Layout.Bands[0].Columns.FromKey("EMP_REF_ID").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("EST_DEPT_REF_ID").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("POS_CLS_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("DEPT_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("POS_GRP_ID").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("POS_GRP_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("EMP_CODE").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("EMP_NAME").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = e.Layout.Bands[0].Columns.FromKey("WEIGHT_SUM").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "조직";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "개인";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "목표1";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "목표2";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 11;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "목표3";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 13;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
}
protected void ugrdClose_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "KPI_CODE";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "KPI명";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "부서명";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "챔피언명";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "확정실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "산식실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[1].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[2].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[3].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanY = 2;
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
e.Layout.Bands[0].Reset();
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "구분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "년월";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "고객지원센터";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "울산특판";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "시공업체/기타";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "합계";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획대비실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
try
{
//Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = e.Layout.Bands[0].Columns[0].Header;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
e.Layout.Bands[0].Columns[i].Width = 50;
}
else if (i == 10)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = "#,##0.0";
e.Layout.Bands[0].Columns[i].Width = 60;
}
else
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
e.Layout.Bands[0].Columns[i].Width = 75;
}
}
}
catch
{
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
e.Layout.Bands[0].HeaderLayout.Reset();
//e.Layout.Bands[0].Reset();
e.Layout.Bands[0].Columns[0].MergeCells = true;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
if (rBtnType.SelectedValue.Equals("2"))
{
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "조직";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당월";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누계";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].HeaderLayout.Add(ch);
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i < 2)
{
e.Layout.Bands[0].Columns[i].Width = 120;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
else if (i > 0 && i < 8)
{
e.Layout.Bands[0].Columns[i].Width = 90;
e.Layout.Bands[0].Columns[i].Format = (i == 3 || i == 6) ? "#,##0" : "#,##0.#";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
else
{
e.Layout.Bands[0].Columns[i].Hidden = true;
}
}
}
else
{
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "조직";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당월";
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.Caption = "누계";
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 = e.Layout.Bands[0].Columns[0].Header;
ch.Caption = "부문명";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i < 1)
{
e.Layout.Bands[0].Columns[i].Width = 240;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
else if (i > 0 && i < 7)
{
e.Layout.Bands[0].Columns[i].Width = 90;
e.Layout.Bands[0].Columns[i].Format = (i == 2 || i == 5) ? "#,##0" : "#,##0.#";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
else
{
e.Layout.Bands[0].Columns[i].Hidden = true;
}
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
e.Layout.Bands[0].Reset();
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "구분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전년동기";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획대비";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전년대비";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[1].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[2].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[3].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanY = 2;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].Width = 110;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
else if (i == 5 || i == 7)
{
e.Layout.Bands[0].Columns[i].Width = 80;
e.Layout.Bands[0].Columns[i].Format = "#,##0.0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
else
{
e.Layout.Bands[0].Columns[i].Width = 100;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
if (e.Layout.Bands[0].Columns[i].Header.Caption == "차이" || e.Layout.Bands[0].Columns[i].Header.Caption == "차 이")
{
e.Layout.Bands[0].Columns[i].Header.Caption = "차이";
}
}
}
protected void ugrdBias_InitializeLayout(object sender, LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평가단";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평가자";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 1;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "지표명";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 1;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "원시점수";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 3;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평균조정점수";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 3;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "평균.편차조정점수";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 3;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "조정여부";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 12;
ch.RowLayoutColumnInfo.SpanX = 1;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[1].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[2].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanY = 2;
ch = e.Layout.Bands[0].Columns[12].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 12;
ch.RowLayoutColumnInfo.SpanY = 2;
e.Layout.Bands[0].Columns.FromKey("EMP_NAME").CellStyle.BackColor = Color.WhiteSmoke;
e.Layout.Bands[0].Columns.FromKey("KPI_NAME").CellStyle.BackColor = Color.WhiteSmoke;
e.Layout.Bands[0].Columns.FromKey("ORI_SCORE").CellStyle.BackColor = Color.FromName("#DCE1E5");
e.Layout.Bands[0].Columns.FromKey("AVG_SCORE").CellStyle.BackColor = Color.FromName("#DCE1E5");
e.Layout.Bands[0].Columns.FromKey("STD_SCORE").CellStyle.BackColor = Color.FromName("#DCE1E5");
}
protected void ugrdExtScore_InitializeLayout(object sender, LayoutEventArgs e)
{
//this.SetDraftLegend(sender, e);
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
c.CellStyle.BackColor = Color.WhiteSmoke;
c.AllowUpdate = AllowUpdate.No;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "지표기본정보";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 5;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "가중치";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누계(내부)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누계(외부)";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "원시점수/등급";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 11;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "최종점수";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 14;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//ch = e.Layout.Bands[0].Columns[13].Header;
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 13;
//ch.RowLayoutColumnInfo.SpanY = 2;
//ch = e.Layout.Bands[0].Columns[12].Header;
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 14;
//ch.RowLayoutColumnInfo.SpanY = 2;
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
try
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = e.Layout.Bands[0].Columns[0].Header;
int iIndex = 0;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "구 분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당 월";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 3;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누 계";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[i].Width = 40;
}
else if (i == 1)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[i].Width = 50;
}
else if (i == 2)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
e.Layout.Bands[0].Columns[i].Width = 156;
}
else
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = ((i + 1) % 3 == 0) ? "#,##0.0" : "#,##0";
e.Layout.Bands[0].Columns[i].Width = ((i + 1) % 3 == 0) ? 70 : 100;
}
}
}
catch
{
}
}
protected void ugrdETC_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid grid = (UltraWebGrid)sender;
grid.Columns[5].Hidden = true;
grid.Columns[6].Hidden = true;
grid.Columns[7].Hidden = true;
grid.Columns[8].Hidden = true;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "매출(당월)";
ch.Style.HorizontalAlign = HorizontalAlign.Center;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 4;
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당기순이익";
ch.Style.HorizontalAlign = HorizontalAlign.Center;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 9;
ch.RowLayoutColumnInfo.SpanX = 4;
e.Layout.Bands[0].HeaderLayout.Add(ch);
////// 단일 헤더 합침
////ch = e.Layout.Bands[0].Columns.FromKey("MM").Header;
////ch.RowLayoutColumnInfo.SpanY = 2;
////ch.RowLayoutColumnInfo.OriginY = 0;
//int iIndex = 0;
//Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
//foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
//{
// c.Header.RowLayoutColumnInfo.OriginY = 1;
// c.Header.RowLayoutColumnInfo.OriginX = iIndex;
// iIndex++;
//}
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "월";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 0;
//ch.RowLayoutColumnInfo.SpanX = 1;
//ch.Style.Height = Unit.Pixel(20);
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "[ 당 월 ]";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 1;
//ch.RowLayoutColumnInfo.SpanX = 6;
//ch.Style.Height = Unit.Pixel(20);
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 7;
//ch.RowLayoutColumnInfo.SpanX = 1;
//ch.Style.Height = Unit.Pixel(20);
//ch.Style.BackColor = Color.White;
//ch.Style.BorderColor = Color.White;
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "[ 누 적 ]";
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 8;
//ch.RowLayoutColumnInfo.SpanX = 7;
//ch.Style.Height = Unit.Pixel(20);
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
//// 단일 헤더 합침
//ch = e.Layout.Bands[0].Columns.FromKey("MM").Header;
//ch.RowLayoutColumnInfo.SpanY = 2;
//ch.RowLayoutColumnInfo.OriginY = 0;
//e.Layout.Bands[0].Columns.FromKey("SPLITER").Header.Style.BackColor = Color.White;
//// 단일 헤더 합침
////ch = e.Layout.Bands[0].Columns.FromKey("SPLITER").Header;
////ch.RowLayoutColumnInfo.SpanY = 2;
////ch.RowLayoutColumnInfo.OriginY = 0;
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
e.Layout.Bands[0].Reset();
//e.Layout.FrameStyle.Height = 160;
e.Layout.Bands[0].Columns[0].Hidden = true;
e.Layout.Bands[0].Columns[1].Hidden = true;
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
Infragistics.WebUI.UltraWebGrid.ColumnHeader[] arrCh = new Infragistics.WebUI.UltraWebGrid.ColumnHeader[3];
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "구 분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당 월 실 적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누 계 실 적";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 5;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "전 년 동 기";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
string[] arrColNm = new string[13] {
"코드1", "코드2", "상위계정", "하위계정", "계획", "실적", "집행율(%)", "계획", "실적", "집행율(%)", "실적", "증감", "증가율(%)"
};
e.Layout.Bands[0].Columns[2].MergeCells = true;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
e.Layout.Bands[0].Columns[i].Header.Caption = arrColNm[i];
if (i < 2)
{
e.Layout.Bands[0].Columns[i].Hidden = true;
}
else if (i == 2)
{
e.Layout.Bands[0].Columns[i].Width = 80;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
else if (i == 3)
{
e.Layout.Bands[0].Columns[i].Width = 135;
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Left;
}
else
{
e.Layout.Bands[0].Columns[i].Width = (i % 3 == 0) ? 60 : 80;
e.Layout.Bands[0].Columns[i].Format = (i % 3 == 0) ? "#,##0.0" : "#,##0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
//e.Layout.Bands[0].Columns[0].CellStyle.BackColor = System.Drawing.Color.FromArgb(0x98, 0xc7, 0xd0); //#98c7d0, #b9dce3, #
//e.Layout.Bands[0].Columns[1].CellStyle.BackColor = System.Drawing.Color.FromArgb(0xb9, 0xdc, 0xe3); //#98c7d0, #b9dce3, #
e.Layout.Bands[0].Columns[0].CellStyle.BackColor = GetGridColor(gEN_GRID_COLOR.GROUP1);
e.Layout.Bands[0].Columns[1].CellStyle.BackColor = GetGridColor(gEN_GRID_COLOR.GROUP2);
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 2;
c.Header.Caption = msaHeader[iIndex];
iIndex++;
}
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 3;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Caption = "구분";
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "당 월";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 6;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 2;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 4;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획대비 실적";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 6;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "누 계";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 6;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "실적";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 10;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "계획대비 실적";
ch.RowLayoutColumnInfo.OriginY = 1;
ch.RowLayoutColumnInfo.OriginX = 12;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[0].MergeCells = true;
for (int i = 2; i < UltraWebGrid1.Columns.Count; i++)
{
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns[i].Format = "#,##0.##";
}
}
protected void ugrdKpiResultStatus_InitializeLayout(object sender, LayoutEventArgs e)
{
//Infragistics.WebUI.UltraWebGrid.ColumnHeader ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "월별 조회";
//ch.Style.HorizontalAlign = HorizontalAlign.Center;
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 1;
//ch.RowLayoutColumnInfo.SpanX = 6;
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
//ch.Caption = "누적 조회";
//ch.Style.HorizontalAlign = HorizontalAlign.Center;
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.OriginX = 8;
//ch.RowLayoutColumnInfo.SpanX = 6;
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//// 단일 헤더 합침
//ch = e.Layout.Bands[0].Columns.FromKey("MM").Header;
//ch.RowLayoutColumnInfo.SpanY = 2;
//ch.RowLayoutColumnInfo.OriginY = 0;
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
c.Header.RowLayoutColumnInfo.OriginX = iIndex;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "월";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "[ 당 월 ]";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.SpanX = 6;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 7;
ch.RowLayoutColumnInfo.SpanX = 1;
ch.Style.Height = Unit.Pixel(20);
ch.Style.BackColor = Color.White;
ch.Style.BorderColor = Color.White;
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Caption = "[ 누 적 ]";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 8;
ch.RowLayoutColumnInfo.SpanX = 7;
ch.Style.Height = Unit.Pixel(20);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
// 단일 헤더 합침
ch = e.Layout.Bands[0].Columns.FromKey("MM").Header;
ch.RowLayoutColumnInfo.SpanY = 2;
ch.RowLayoutColumnInfo.OriginY = 0;
e.Layout.Bands[0].Columns.FromKey("SPLITER").Header.Style.BackColor = Color.White;
// 단일 헤더 합침
//ch = e.Layout.Bands[0].Columns.FromKey("SPLITER").Header;
//ch.RowLayoutColumnInfo.SpanY = 2;
//ch.RowLayoutColumnInfo.OriginY = 0;
}
//private void drawGraph(DataSet dsGrph)
//{
// DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 550, 50
// , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2
// , Color.FromArgb(0xFF, 0xFF, 0xFE)
// , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
// , -1
// , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None);
// Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "계획", null, SeriesChartType.StackedColumn, 0, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
// Series series2 = DundasCharts.CreateSeries(Chart1, "Series2", "Default", "실적", null, SeriesChartType.StackedColumn, 0, Color.FromArgb(0xFF, 0x8A, 0x00), Color.FromArgb(0xD7, 0x41, 0x01), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
// //------------------------------------------------------Chart2
// Chart1.DataSource = dsGrph.Tables[0].DefaultView;
// series1.ValueMembersY = "CY_AMT";
// series2.ValueMembersY = "PY_AMT";
// series1.ValueMemberX = "ACCT_NM";
// DundasAnimations.DundasChartBase(Chart1, AnimationTheme.None, -1, -1, false, 1);
// DundasAnimations.GrowingAnimation(Chart1, series1, 0.0, 3.0, true);
//}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].HeaderLayout.Reset();
e.Layout.Bands[0].Reset();
int iIndex = 0;
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
Infragistics.WebUI.UltraWebGrid.ColumnHeader[] arrCh = new Infragistics.WebUI.UltraWebGrid.ColumnHeader[3];
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
iIndex++;
}
ch = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
ch.Key = "GUBUN";
ch.Caption = "구 분";
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanX = 3;
ch.Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(ch);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
int intSpan = 3;
for (int i = 0; i < arrCh.Length; i++)
{
arrCh[i] = new Infragistics.WebUI.UltraWebGrid.ColumnHeader(true);
switch (i)
{
case 0:
if ( cboGbn.SelectedValue == "A")
{
arrCh[i].Caption = Convert.ToString(int.Parse(cboYY.SelectedValue)-1)+"/"+"12";
}
else
{
arrCh[i].Caption = Convert.ToString(int.Parse(cboYY.SelectedValue)-1)+"/"+cboMM.SelectedValue;
}
break;
case 1:
arrCh[i].Caption = cboYY.SelectedValue + "/" + cboMM.SelectedValue;
break;
case 2:
arrCh[i].Caption = "전년대비";
break;
default:
break;
}
arrCh[i].Key = e.Layout.Bands[0].Columns[i].Header.Caption;
arrCh[i].RowLayoutColumnInfo.OriginY = 0;
arrCh[i].RowLayoutColumnInfo.OriginX = intSpan;
arrCh[i].RowLayoutColumnInfo.SpanX = 2;
arrCh[i].Style.Height = Unit.Pixel(22);
e.Layout.Bands[0].HeaderLayout.Add(arrCh[i]);
e.Layout.Bands[0].HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
intSpan = intSpan + 2;
}
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].Width =90;
e.Layout.Bands[0].Columns[i].MergeCells = true;
}
else if (i == 1)
{
e.Layout.Bands[0].Columns[i].Width = 60;
e.Layout.Bands[0].Columns[i].MergeCells = true;
}
else if (i == 2)
{
e.Layout.Bands[0].Columns[i].Width = 110;
}
else
{
e.Layout.Bands[0].Columns[i].Width = (i%2==0) ? 50:80;
e.Layout.Bands[0].Columns[i].Format = (i % 2 == 0) ? "0.#" : "#,##0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
}
