protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
//ColumnHeader colHead;
//for (int i = 0; i < e.Layout.Bands[0].HeaderLayout.Count; i++)
//{
// colHead = e.Layout.Bands[0].HeaderLayout[i] as ColumnHeader;
// colHead.RowLayoutColumnInfo.OriginY = 1;
//}
//ColumnHeader chInicial = new ColumnHeader(true);
//chInicial.Caption = "";
//chInicial.Style.HorizontalAlign = HorizontalAlign.Center;
//chInicial.RowLayoutColumnInfo.OriginX = 0;
//chInicial.RowLayoutColumnInfo.OriginY = 0;
//chInicial.RowLayoutColumnInfo.SpanX = 2;
//e.Layout.Bands[0].HeaderLayout.Add(chInicial);
//ColumnHeader ch = new ColumnHeader(true);
//ch.Caption = "Produccion de Proceso Origen";
//ch.Style.HorizontalAlign = HorizontalAlign.Center;
//ch.RowLayoutColumnInfo.OriginX = 2;
//ch.RowLayoutColumnInfo.OriginY = 0;
//ch.RowLayoutColumnInfo.SpanX = 3;
//e.Layout.Bands[0].HeaderLayout.Add(ch);
//ColumnHeader ch1 = new ColumnHeader(true);
//ch1.Caption = "Produccion de Proceso Destino";
//ch1.Style.HorizontalAlign = HorizontalAlign.Center;
//ch1.RowLayoutColumnInfo.OriginX = 5;
//ch1.RowLayoutColumnInfo.OriginY = 0;
//ch1.RowLayoutColumnInfo.SpanX = 3;
//e.Layout.Bands[0].HeaderLayout.Add(ch1);
}
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;
e.Layout.Bands[0].Columns.FromKey("구분").Header.Caption = "구분";
e.Layout.Bands[0].Columns.FromKey("구분").Width = 40;
e.Layout.Bands[0].Columns.FromKey("구분").Header.Style.HorizontalAlign = HorizontalAlign.Left;
e.Layout.Bands[0].Columns.FromKey("년도").Header.Caption = "년도";
e.Layout.Bands[0].Columns.FromKey("년도").Width = 30;
e.Layout.Bands[0].Columns.FromKey("년도").Header.Style.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns.FromKey("합계").CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns.FromKey("합계").Format = "#,##0";
e.Layout.Bands[0].Columns.FromKey("합계").Width = 80;
for (int i = 1; i < e.Layout.Bands[0].Columns.Count; i++)
{
//e.Layout.Bands[0].Columns.FromKey(i.ToString()+"월").Header.Caption = cboCom.Items[i].Text;
e.Layout.Bands[0].Columns.FromKey(i.ToString() + "월").CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns.FromKey(i.ToString() + "월").Format = "#,##0";
e.Layout.Bands[0].Columns.FromKey(i.ToString() + "월").Width = 59;
}
}
catch
{
}
}
protected void ugrdTaskShareList_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
//string striType = "";
//int cntRow = ugrdTaskShareList.Rows.Count;
//CheckBox chkCheck;
//UltraGridRow ugrdRow;
//TemplatedColumn col_Check = (TemplatedColumn)ugrdTaskShareList.Bands[0].Columns.FromKey("selchk");
//for (int i = 0; i < ugrdTaskShareList.Rows.Count; i++)
//{
// chkCheck = (CheckBox)((CellItem)col_Check.CellItems[ugrdTaskShareList.Rows[i].BandIndex]).FindControl("cBox");
// ugrdRow = ugrdTaskShareList.Rows[i];
// if (chkCheck.Checked)
// {
// striType = ugrdTaskShareList.Rows[i].Cells.FromKey("ITYPE").ToString();
// if (striType == "U")
// {
// chkCheck.BackColor = Color.Red;
// ugrdTaskShareList.Rows[i].Cells.FromKey("ITYPE").Value = "D";
// }
// else if (striType == "A")
// {
// ugrdTaskShareList.Rows.Remove(ugrdRow);
// }
// }
//}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
string sYYYYMMs = GetByValueDropDownList(ddlYearS) + GetByValueDropDownList(ddlMonthS);
string sYYYYMMe = GetByValueDropDownList(ddlYearE) + GetByValueDropDownList(ddlMonthE);
string[] saTerm = GetMonthDiff(sYYYYMMs, sYYYYMMe, "M");
try
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = e.Layout.Bands[0].Columns[0].Header;
for (int i = 0; i < saTerm.Length; i++)
{
e.Layout.Bands[0].Columns.FromKey("SEM_CODE2_NAME").MergeCells = true;
e.Layout.Bands[0].Columns.FromKey("V_" + saTerm[i]).CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns.FromKey("V_" + saTerm[i]).Format = "#,##0.0";
e.Layout.Bands[0].Columns[i + 3].Width = 72;
}
}
catch
{
}
//e.Layout.Bands[0].RowStyle.BackColor = GetChartColor(0);
}
//This method initializes the format of the UltraWebGrid
// In this method the multiple headers are drawn and also the header caption and the
// appearance of the columns are initialized
public void UltraWebGrid1_InitializeLayout(object sender,
Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
QMReportsClass objQMReports = new QMReportsClass();
objQMReports.ContainerViewUltraGrid_Initialize(e, this.regionCode);
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
try
{
int intWidth = 0;
e.Layout.Bands[0].HeaderLayout.Reset();
intWidth = ((e.Layout.Bands[0].Columns.Count - 1) > 0) ? Convert.ToInt32(720 / (e.Layout.Bands[0].Columns.Count - 1)) : 0;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].Width = 40;
}
else
{
e.Layout.Bands[0].Columns[i].Width = intWidth;
e.Layout.Bands[0].Columns[i].Format = "#,##0.0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
}
catch
{
}
}
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 intWid = 0;
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 = 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) ? 25 : (25 + intWid++);
}
}
}
catch
{
}
}
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 = 0;
iIndex++;
}
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 = 100;
}
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 = 54;
}
}
}
catch
{
}
}
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;
e.Layout.Bands[0].Columns.FromKey("YY").Header.Caption = "년도";
e.Layout.Bands[0].Columns.FromKey("YY").Width = 60;
e.Layout.Bands[0].Columns.FromKey("YY").Header.Style.HorizontalAlign = HorizontalAlign.Center;
for (int i = 1; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i > 0 && i < 13)
{
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 = 64;
}
else
{
e.Layout.Bands[0].Columns[i].Hidden = true;
}
}
}
catch
{
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.ColumnHeader ch;
ch = e.Layout.Bands[0].Columns[0].Header;
ch.RowLayoutColumnInfo.OriginY = 0;
ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.SpanY = 1;
ch.RowLayoutColumnInfo.SpanX = 2;
ch.Style.HorizontalAlign = HorizontalAlign.Center;
ch.Caption = "용도";
e.Layout.Bands[0].Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns[0].MergeCells = true;
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);
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.00";
}
}
protected void ugrdResultStatus_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
ugrdResultStatus.DisplayLayout.AllowSortingDefault = AllowSorting.Yes;
ugrdResultStatus.DisplayLayout.HeaderClickActionDefault = HeaderClickAction.SortMulti;
ugrdResultStatus.DisplayLayout.Pager.AllowCustomPaging = true;
ugrdResultStatus.DisplayLayout.Pager.AllowPaging = true;
ugrdResultStatus.DisplayLayout.Pager.StyleMode = PagerStyleMode.Numeric;
}
protected void ConsultaBancos_InicializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].CellClickAction = CellClickAction.Edit;
ValueList articulo = UltraWebGrid1.Columns[1].ValueList;
ValueList modelo = UltraWebGrid1.Columns[4].ValueList;
ValueList Impresiones = UltraWebGrid1.Columns[5].ValueList;
ValueList Capacidad = UltraWebGrid1.Columns[6].ValueList;
ValueList rango = UltraWebGrid1.Columns[7].ValueList;
ValueList real = UltraWebGrid1.Columns[8].ValueList;
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
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.#";
}
}
private void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.SelectTypeColDefault = SelectType.Single;
e.Layout.SelectTypeRowDefault = SelectType.Extended;
e.Layout.TableLayout = TableLayout.Fixed;
e.Layout.RowStyleDefault.BorderDetails.ColorTop = Color.Gray;
e.Layout.Bands[0].AllowAdd = Infragistics.WebUI.UltraWebGrid.AllowAddNew.Yes;
for (int i = 0; i < UltraWebGrid1.Bands.Count; i++)
{
for (int j = 0; j < UltraWebGrid1.Bands[i].Columns.Count; j++)
{
if (UltraWebGrid1.DisplayLayout.Bands[i].Columns[j].BaseColumnName != "Chk")
{
UltraWebGrid1.DisplayLayout.Bands[i].Columns[j].SelectedCellStyle.BackColor = Color.Yellow;
UltraWebGrid1.DisplayLayout.Bands[i].Columns[j].SelectedCellStyle.Cursor = Infragistics.WebUI.Shared.Cursors.Text;
}
}
}
// UltraWebGrid1.Bands[0].RowStyle.BackColor=Color.PaleTurquoise;
UltraWebGrid1.DisplayLayout.SelectedHeaderStyleDefault.BackColor = Color.Red;
UltraWebGrid1.DisplayLayout.SelectTypeCellDefault = Infragistics.WebUI.UltraWebGrid.SelectType.Single;
UltraWebGrid1.DisplayLayout.AllowColSizingDefault = Infragistics.WebUI.UltraWebGrid.AllowSizing.Free;
//set cursor
UltraWebGrid1.DisplayLayout.FrameStyle.Cursor = Infragistics.WebUI.Shared.Cursors.Default;
UltraWebGrid1.DisplayLayout.Bands[0].HeaderStyle.Cursor = Infragistics.WebUI.Shared.Cursors.Default;
UltraWebGrid1.DisplayLayout.SelectedHeaderStyleDefault.BackColor = Color.Red;
// ********************************************************************************************************** //
e.Layout.Bands[0].Columns.FromKey("elt_account_number").Hidden = true;
e.Layout.Bands[0].Columns.FromKey("org_account_number").Hidden = true;
e.Layout.Bands[0].Columns.Insert(0, "Chk");
e.Layout.Bands[0].Columns.FromKey("Chk").CellStyle.BackgroundImage = "../../../Images/mark_o.gif";
e.Layout.Bands[0].Columns.FromKey("Chk").CellStyle.HorizontalAlign = HorizontalAlign.Center;
e.Layout.Bands[0].Columns.FromKey("Chk").CellStyle.CustomRules = "background-position:center ;background-repeat:no-repeat";
e.Layout.Bands[0].Columns.FromKey("Chk").Header.Caption = "";
e.Layout.Bands[0].Columns.FromKey("Chk").Width = new Unit("40px");
e.Layout.Bands[0].Columns.FromKey("Chk").CellStyle.BackColor = Color.FromArgb(249, 236, 212);
e.Layout.Bands[0].Columns.FromKey("Chk").CellStyle.Cursor = Infragistics.WebUI.Shared.Cursors.Hand;
e.Layout.Bands[0].Columns.FromKey("Chk").AllowUpdate = Infragistics.WebUI.UltraWebGrid.AllowUpdate.Yes;
e.Layout.Bands[0].Columns.FromKey("sb").Header.Caption = "Schedule B";
e.Layout.Bands[0].Columns.FromKey("sb_unit1").Header.Caption = "Unit 1";
e.Layout.Bands[0].Columns.FromKey("sb_unit2").Header.Caption = "Unit 2";
e.Layout.Bands[0].Columns.FromKey("description").Header.Caption = "Description";
e.Layout.Bands[0].Columns.FromKey("sb_unit1").Width = new Unit("40px");
e.Layout.Bands[0].Columns.FromKey("sb_unit2").Width = new Unit("40px");
e.Layout.Bands[0].Columns.FromKey("description").Width = new Unit("180px");
}
private void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
UltraWebGrid1.Bands[0].Columns.FromKey("org_account_number").Width = new Unit("50px");
UltraWebGrid1.Bands[0].Columns.FromKey("dba_name").Width = new Unit("200px");
UltraWebGrid1.Bands[0].Columns.FromKey("business_address").Width = new Unit("200px");
UltraWebGrid1.Bands[0].Columns.FromKey("business_city").Width = new Unit("100px");
UltraWebGrid1.Bands[0].Columns.FromKey("org_account_number").Header.Caption = "Number";
UltraWebGrid1.Bands[0].Columns.FromKey("dba_name").Header.Caption = "Business Name";
UltraWebGrid1.Bands[0].Columns.FromKey("business_address").Header.Caption = "Address";
UltraWebGrid1.Bands[0].Columns.FromKey("business_city").Header.Caption = "City";
}
private void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].Columns[0].Width = new Unit("217px");
e.Layout.Bands[1].Columns[0].Hidden = true;
for (int i = 0; i < UltraWebGrid1.Bands.Count; i++)
{
for (int j = 0; j < UltraWebGrid1.Bands[i].Columns.Count; j++)
{
UltraWebGrid1.DisplayLayout.Bands[i].Columns[j].SelectedCellStyle.BackColor = Color.Yellow;
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].Columns[0].CellStyle.BackColor = GetGridColor(gEN_GRID_COLOR.GROUP1);
//e.Layout.Bands[0].Columns[0].MergeCells = true;
//e.Layout.Bands[0].Columns[0].CellStyle.VerticalAlign = VerticalAlign.Top;
//e.Layout.Bands[0].Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
//e.Layout.Bands[0].Columns[1].MergeCells = true;
for (int i = 1; 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 UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
string sYYYYMMs, sYYYYMMe;
string[] saMonthTerm = GetMonthTerm(out sYYYYMMs, out sYYYYMMe); // 현재
try
{
for (int i = 0; i < saMonthTerm.Length; i++)
{
e.Layout.Bands[0].Columns.FromKey(saMonthTerm[i].Substring(4, 2) + "월").CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns.FromKey(saMonthTerm[i].Substring(4, 2) + "월").Format = "#,##0";
}
}
catch {}
}
//This method initializes the Ultra Grid for Container Search Results
public void uwgSearchRes_InitializeLayout(object sender,
Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
// c.Header.RowLayoutColumnInfo.OriginY = 4;
if (c.Header.Caption.Equals("ContainerName") || c.Header.Caption.Equals("Select a Container"))
{
c.Header.Caption = "Select a Container";
c.Hidden = false;
// c.CellStyle.ForeColor = System.Drawing.Color.PowderBlue;
c.CellStyle.Font.Bold = true;
}
else
{
c.Hidden = true;
}
}
}
/// <summary>
/// 결재아이콘 범례생성
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
#region public void SetDraftLegend(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
public void SetDraftLegend(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
try
{
e.Layout.StationaryMargins = StationaryMargins.HeaderAndFooter;
e.Layout.CellClickActionDefault = CellClickAction.RowSelect;
e.Layout.ColFootersVisibleDefault = ShowMarginInfo.Yes;
e.Layout.FooterStyleDefault.Height = Unit.Pixel(25);
e.Layout.FooterStyleDefault.BackColor = Color.WhiteSmoke;
e.Layout.FooterStyleDefault.ForeColor = Color.Navy;
e.Layout.FooterStyleDefault.Margin.Right = Unit.Pixel(10);
e.Layout.FooterStyleDefault.HorizontalAlign = HorizontalAlign.Right;
e.Layout.FooterStyleDefault.VerticalAlign = VerticalAlign.Middle;
int iCol = e.Layout.Bands[0].Columns.Count - 1;
int iMrg = iCol; // Start Colspan Length
int iFRow = 0; // Start Colspan Index
for (int i = 0; i < iCol; i++)
{
iFRow += 1;
if (e.Layout.Bands[0].Columns[i].Hidden)
{
iMrg -= 1;
}
else
{
e.Layout.Bands[0].Columns[i].Footer.RowLayoutColumnInfo.SpanX = iMrg;
break;
}
}
if (iFRow > 0)
{
string sLegend = Biz_Type.app_legend;
e.Layout.Bands[0].Columns[iFRow - 1].Footer.Caption = sLegend;
e.Layout.Bands[0].Columns[iFRow - 1].Footer.Style.Width = Unit.Percentage(100);
}
}
catch (Exception ex)
{
}
}
protected void ugrdBudgetList_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
ugrdBudgetList.DisplayLayout.ColFootersVisibleDefault = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes;
ugrdBudgetList.DisplayLayout.HeaderStyleDefault.HorizontalAlign = HorizontalAlign.Center;
UltraGridColumn budget_ymColumn = e.Layout.Bands[0].Columns.FromKey("BUDGET_YM_NAME");
budget_ymColumn.Footer.Caption = "합 계";
budget_ymColumn.FooterStyleResolved.HorizontalAlign = HorizontalAlign.Right;
UltraGridColumn monthlyAmountColumn = e.Layout.Bands[0].Columns.FromKey("MONTHLY_AMOUNT");
//monthlyAmountColumn.Width = Unit.Percentage(20);
monthlyAmountColumn.Format = "###,###,###,##0";
monthlyAmountColumn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
monthlyAmountColumn.FooterTotal = SummaryInfo.Sum;
monthlyAmountColumn.Footer.Style.HorizontalAlign = HorizontalAlign.Right;
monthlyAmountColumn.FooterStyle.Padding.Left = new Unit(6);
UltraGridColumn amountColumn = e.Layout.Bands[0].Columns.FromKey("AMOUNT");
//amountColumn.Width = Unit.Percentage(20);
amountColumn.Format = "###,###,###,##0";
amountColumn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
amountColumn.FooterTotal = SummaryInfo.Sum;
amountColumn.Footer.Style.HorizontalAlign = HorizontalAlign.Right;
amountColumn.FooterStyle.Padding.Left = new Unit(6);
UltraGridColumn rateColumn = e.Layout.Bands[0].Columns.FromKey("RATE");
//rateColumn.Width = Unit.Percentage(20);
rateColumn.Format = "##0.00";
rateColumn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
rateColumn.FooterTotal = SummaryInfo.Avg;
rateColumn.Footer.Style.HorizontalAlign = HorizontalAlign.Right;
rateColumn.FooterStyle.Padding.Left = new Unit(6);
ugrdBudgetList.DisplayLayout.FooterStyleDefault.BackColor = Color.FromName("#94BAC9");
}
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;
e.Layout.Bands[0].Columns.FromKey("YY").Header.Caption = "년도";
e.Layout.Bands[0].Columns.FromKey("YY").Width = 40;
for (int i = 0; i < cboCom.Items.Count; i++)
{
//e.Layout.Bands[0].Columns.FromKey("AREA" + i.ToString()).Header.Caption = cboCom.Items[i].Text;
e.Layout.Bands[0].Columns.FromKey(cboCom.Items[i].Text).CellStyle.HorizontalAlign = HorizontalAlign.Right;
e.Layout.Bands[0].Columns.FromKey(cboCom.Items[i].Text).Format = "#,##0";
e.Layout.Bands[0].Columns.FromKey(cboCom.Items[i].Text).Width = 70;
}
}
catch
{
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridColumn c in e.Layout.Bands[0].Columns)
{
c.Header.RowLayoutColumnInfo.OriginY = 1;
}
ColumnHeader ch = new ColumnHeader(true);
ch.Caption = "Desperdicio";
ch.Style.HorizontalAlign = HorizontalAlign.Center;
//ch.RowLayoutColumnInfo.OriginX = 0;
ch.RowLayoutColumnInfo.OriginX = 1;
ch.RowLayoutColumnInfo.OriginY = 0;
// extend the newly added header over 3 columns
ch.RowLayoutColumnInfo.SpanX = 1;
e.Layout.Bands[0].HeaderLayout.Add(ch);
ColumnHeader ch2 = new ColumnHeader(true);
ch2.Caption = "Proceso";
ch2.Style.HorizontalAlign = HorizontalAlign.Center;
ch2.RowLayoutColumnInfo.OriginX = 3;
// This will set it on the first row of the HeaderLayout object
// The columns created by the control are all on the first row by default.
ch2.RowLayoutColumnInfo.OriginY = 0;
// Add the newly created Header object to the HeaderLayout object
e.Layout.Bands[0].HeaderLayout.Add(ch2);
// Expand the new column header to cover two columns.
/*ch.RowLayoutColumnInfo.SpanX = 3;*/
ch2.RowLayoutColumnInfo.SpanX = 8;
}
public void dgPVGrid_InitializeLayout(object sender,
Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
dgPVGrid.Bands[0].Columns[0].Hidden = true;
//dgPVGrid.Bands[0].Columns[1].CellStyle.Font.Size = 8;
dgPVGrid.Bands[0].Columns[1].AllowUpdate = AllowUpdate.No;
//dgPVGrid.Bands[0].Columns[2].Hidden = true;
dgPVGrid.Bands[1].Columns[0].Hidden = true;
dgPVGrid.Bands[1].Columns[1].Hidden = true;
//dgPVGrid.Bands[1].Columns[2].Hidden = true;
dgPVGrid.Bands[1].Columns[2].AllowUpdate = AllowUpdate.No;
dgPVGrid.Bands[1].Columns[2].CellStyle.BorderStyle = BorderStyle.Solid;
dgPVGrid.Bands[1].Columns[2].Width = Unit.Percentage(100);
dgPVGrid.Bands[1].Columns[3].CellStyle.BorderStyle = BorderStyle.Ridge;
//dgPVGrid.Bands[1].Columns[5].Hidden = true;
//dgPVGrid.Bands[0].Columns[dgPVGrid.Bands[0].Columns.Count-1].Hidden = true;
// dgPVGrid.Bands[1].Columns[dgPVGrid.Bands[1].Columns.Count].Hidden = true;
dgPVGrid.DisplayLayout.TableLayout = TableLayout.Auto;
dgPVGrid.Bands[0].CellSpacing = 5;
dgPVGrid.Width = Unit.Empty;
// dgPVGrid.Bands[1].Columns[2].Width = 100;
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].Columns[0].MergeCells = true;
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].Width = 30;
}
else if (i == 1)
{
e.Layout.Bands[0].Columns[i].Width = 100;
}
else
{
e.Layout.Bands[0].Columns[i].Width = 54;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
try
{
e.Layout.Bands[0].HeaderLayout.Reset();
for (int i = 0; i < e.Layout.Bands[0].Columns.Count; i++)
{
if (i == 0)
{
e.Layout.Bands[0].Columns[i].Width = 40;
}
else
{
e.Layout.Bands[0].Columns[i].Width = 63;
e.Layout.Bands[0].Columns[i].Format = "#,##0";
e.Layout.Bands[0].Columns[i].CellStyle.HorizontalAlign = HorizontalAlign.Right;
}
}
}
catch
{
}
}
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, 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)
{
}
protected void UltraWebGrid1_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
{
e.Layout.Bands[0].Columns[0].MergeCells = true;
}