public static void SetUltraGridValueList <T>(UltraGridLayout layout, IEnumerable <T> collection,
UltraGridColumn column, string valueMember, string displayMember, string defaultValue)
{
ValueList vl;
if (!layout.ValueLists.Exists(typeof(T).Name + valueMember + displayMember))
{
vl = layout.ValueLists.Add(typeof(T).Name + valueMember + displayMember);
}
vl = layout.ValueLists[typeof(T).Name + valueMember + displayMember];
vl.ValueListItems.Clear();
if (defaultValue != null)
{
vl.ValueListItems.Add(-1, defaultValue);
}
foreach (T entity in collection)
{
vl.ValueListItems.Add(entity.GetType().GetProperty(valueMember).GetValue(entity, null),
entity.GetType().GetProperty(displayMember).GetValue(entity, null).ToString());
}
vl.SelectedItem = -1;
//column.ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
column.ValueList = layout.ValueLists[typeof(T).Name + valueMember + displayMember];
}
private void grdPrincipal_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
int index = 0;
foreach (UltraGridColumn column in band.Columns.Cast <UltraGridColumn>()
.Where(x => x.Index >= 4 && int.TryParse(x.Header.Caption, out index)))
{
column.Header.Caption = this.lstLines
.Single(x => x.ProductLineId == Convert.ToInt32(column.Header.Caption)).Name.Trim();
column.Header.TextOrientation = new TextOrientationInfo(65, TextFlowDirection.Horizontal);
column.PerformAutoResize();
}
foreach (UltraGridRow row in this.frmVerticalIntegration.grdPrincipal.Rows.Where(x => x.Cells != null))
{
foreach (UltraGridCell cell in row.Cells.Cast <UltraGridCell>().Where(x => x.Column.Index >= 4))
{
if (!Convert.ToBoolean(cell.Value))
{
cell.Appearance.BackColor = Color.Yellow;
}
}
}
band.Columns["CustomerId"].Header.Caption = "Id Cliente";
band.Columns["Agent"].Header.Caption = "Agente";
band.Columns["CustomerName"].Header.Caption = "Nombre Cliente";
band.Columns["ComercialName"].Header.Caption = "Nombre Comercial";
band.SortedColumns.Add("Agent", false, true);
}
public static void SetUltraGridValueList(UltraGridLayout layout, DataTable dataTable,
UltraGridColumn column, string valueMember, string displayMember, string defaultValue)
{
ValueList vl;
if (dataTable.TableName == null)
{
dataTable.TableName = string.Empty;
}
if (!layout.ValueLists.Exists(dataTable.TableName + valueMember + displayMember))
{
vl = layout.ValueLists.Add(dataTable.TableName + valueMember + displayMember);
}
vl = layout.ValueLists[dataTable.TableName + valueMember + displayMember];
vl.ValueListItems.Clear();
if (defaultValue != null)
{
vl.ValueListItems.Add(-1, defaultValue);
}
foreach (DataRow row in dataTable.Rows)
{
vl.ValueListItems.Add(row[valueMember], row[displayMember].ToString());
}
vl.SelectedItem = -1;
column.ValueList = layout.ValueLists[dataTable.TableName + valueMember + displayMember];
}
private void grdPrincipal_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
WindowsFormsUtil.SetUltraGridValueList(layout, TimeUtil.Months,
band.Columns["Month"], "Index", "Name", null);
}
private void grdPrincipal_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
WindowsFormsUtil.SetUltraGridValueList(layout, this.srvGeneric.GetListByParameters <BusinessType>(null),
band.Columns["BusinessTypeId"], "BusinessTypeId", "Name", "Seleccione");
}
/// <summary>
/// Handles the InitializeLayout event of the gridInventory control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs"/> instance containing the event data.</param>
private void gridInventory_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
layout.AutoFitStyle = AutoFitStyle.ResizeAllColumns;
layout.Override.CellClickAction = CellClickAction.RowSelect;
layout.LoadStyle = LoadStyle.LoadOnDemand;
layout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
layout.Override.RowSizing = RowSizing.Fixed;
layout.Override.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Center;
layout.Override.CellAppearance.TextVAlign = Infragistics.Win.VAlign.Middle;
layout.Override.HeaderClickAction = HeaderClickAction.SortMulti;
layout.Override.CellSpacing = 3;
UltraGridBand band = layout.Bands[0];
if (band.Key == "Deliveries")
{
band.Columns["EndDateTime"].Hidden = true;
band.Columns["AllDayEvent"].Hidden = true;
band.Columns["Category"].Hidden = true;
band.Columns["DataKey"].Header.Caption = Properties.Resources.PartNumber;
band.Columns["Weight"].Header.Caption = Properties.Resources.TotalWeightLbs;
band.Columns["Cost"].Header.Caption = Properties.Resources.TotalDue;
band.Columns["Subject"].Header.Caption = Properties.Resources.Subject;
band.Columns["Description"].Header.Caption = Properties.Resources.Description;
band.Columns["Count"].Header.Caption = Properties.Resources.Count;
UltraGridColumn column = band.Columns["StartDateTime"];
column.Header.Caption = Properties.Resources.DeliveryDate;
column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateWithoutDropDown;
band.SortedColumns.Add(column, false);
}
else
{
UltraGridColumn column = band.Columns["WeightPerItem"];
column.Header.Caption = Properties.Resources.WeightLbs;
column.Format = "F1";
column = band.Columns["PricePerItem"];
column.Header.Caption = Properties.Resources.PricePerItem;
column.Format = "C";
band.Columns["PartNumber"].Header.Caption = Properties.Resources.PartNumber;
band.Columns["InStock"].Header.Caption = Properties.Resources.InStock;
band.Columns["Manufacturer"].Header.Caption = Properties.Resources.Manufacturer;
band.Columns["Component"].Header.Caption = Properties.Resources.Component;
// Add a column for the Orders ("Order Part", "View Shipment") button
if (band.Columns.IndexOf("Orders") == -1)
{
UltraGridColumn deliveries = band.Columns.Add("Orders");
deliveries.Header.Caption = Properties.Resources.Availability;
deliveries.DataType = typeof(string);
deliveries.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;
deliveries.ButtonDisplayStyle = ButtonDisplayStyle.Always;
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="InitializeLayoutEventArgs"/> class.
/// </summary>
/// <param name="layout">The layout.</param>
/// <exception cref="System.ArgumentNullException">the layout is null</exception>
public InitializeLayoutEventArgs(UltraGridLayout layout)
{
if (layout == null)
{
throw new ArgumentNullException(nameof(layout));
}
this.Layout = layout;
}
private void grdRegionOption_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
UltraGridColumn imageColumn = band.Columns.Add("Delete");
imageColumn.DataType = typeof(Image);
imageColumn.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Image;
}
private void grdDetSummary_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
layout.Override.AllowUpdate = DefaultableBoolean.False;
layout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All;
layout.AutoFitStyle = AutoFitStyle.ExtendLastColumn;
band.Override.RowSizing = RowSizing.AutoFixed;
band.Columns["Description"].CellMultiLine = DefaultableBoolean.True;
}
private void grdCredits_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
e.Layout.Override.AllowUpdate = DefaultableBoolean.False;
e.Layout.Override.HeaderClickAction = HeaderClickAction.Select;
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["movimiento"],
TextFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["importe"],
TextFormatEnum.Currency);
}
private void clbColumnas_ItemCheck(object sender, ItemCheckEventArgs e)
{
UltraGridLayout layout = this.grdDetalleQuincena.DisplayLayout;
UltraGridBand band = layout.Bands[0];
if (this.grdDetalleQuincena.DisplayLayout.Bands[0].Columns.Count > 0)
{
band.Columns[e.Index].Hidden = this.clbColumnas.GetItemChecked(e.Index);
checkedColumns[band.Columns[e.Index].Header.Caption]
= band.Columns[e.Index].Hidden ? "0" : "1";
}
FileUtils.Write(checkedColumns, "dictionary.bin");
}
private void grdMultiquotaSchemes_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
layout.Override.AllowUpdate = DefaultableBoolean.False;
band.Columns["esquema"].Hidden = true;
band.Columns["agente"].Hidden = true;
band.Columns["nombre"].Header.Caption = "Esquema";
band.Columns["nombre"].Width = 200;
band.Columns["fecha"].Header.Caption = "Fecha de inicio";
band.Columns["cuota_servicios"].Header.Caption = "Cuota de servicios";
band.Columns["cuota_productos"].Header.Caption = "Cuota de productos";
band.Columns["comisiona_servicios"].Hidden = true;
}
private void grdDetLog_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = this.frmOpportunity.grdDetLog.DisplayLayout;
UltraGridBand band = layout.Bands[0];
layout.AutoFitStyle = AutoFitStyle.ExtendLastColumn;
band.Override.MinRowHeight = 3;
band.Override.DefaultRowHeight = 3;
band.Override.RowSizing = RowSizing.AutoFree;
band.Override.RowSizingAutoMaxLines = 5;
band.Columns["Description"].CellMultiLine = DefaultableBoolean.True;
band.Columns["Description"].VertScrollBar = true;
band.Columns["OpportunityLogId"].CellActivation = Activation.ActivateOnly;
band.Columns["LogDate"].CellActivation = Activation.ActivateOnly;
}
private void grdLines_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
e.Layout.Override.AllowUpdate = DefaultableBoolean.False;
e.Layout.Override.HeaderClickAction = HeaderClickAction.Select;
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["numero_linea"],
TextFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["precio_pactado"],
TextFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["costo_promedio"],
TextFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["cantidad"],
TextFormatEnum.NaturalQuantity);
}
private void grdAgentSegments_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
layout.Override.AllowUpdate = DefaultableBoolean.False;
band.Columns["id"].Hidden = true;
band.Columns["esquema"].Hidden = true;
band.Columns["utilidad_inicial"].Header.Caption = "Utilidad inicial";
band.Columns["comision"].Header.Caption = "Comisión";
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["utilidad_inicial"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["comision"],
WindowsFormsUtil.TextMaskFormatEnum.Percentage);
}
private void grdFacturasPendientes_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
e.Layout.Override.AllowUpdate = DefaultableBoolean.False;
e.Layout.Override.HeaderClickAction = HeaderClickAction.Select;
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["fiscal"],
TextFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["factura"],
TextFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["utilidad"],
TextFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["total_acumulado"],
TextFormatEnum.Currency);
}
private void grdPrincipal_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
int index = 0;
foreach (UltraGridColumn column in band.Columns.Cast <UltraGridColumn>()
.Where(x => x.Index >= 4))
{
if (!int.TryParse(column.Header.Caption.Split(' ').First(), out index))
{
continue;
}
column.Header.Caption = TimeUtil.MonthName((TimeUtil.MonthEnum)index);
}
foreach (UltraGridColumn column in band.Columns
.Cast <UltraGridColumn>().Where(x => x.Index >= 4))
{
WindowsFormsUtil.SetUltraColumnFormat(column, TextFormatEnum.Currency);
column.Width = 100;
}
foreach (UltraGridRow row in this.frmHorizontalIntegration.grdPrincipal.Rows.Where(x => x.Cells != null))
{
foreach (UltraGridCell cell in row.Cells.Cast <UltraGridCell>().Where(x => x.Column.Index >= 4))
{
if (Convert.ToDecimal(cell.Value) == 0M)
{
cell.Appearance.BackColor = Color.Yellow;
}
}
}
band.Columns["CustomerId"].Header.Caption = "Id Cliente";
band.Columns["Agent"].Header.Caption = "Agente";
band.Columns["CustomerName"].Header.Caption = "Nombre Cliente";
band.Columns["ComercialName"].Header.Caption = "Nombre Comercial";
band.SortedColumns.Add("Agent", false, true);
}
private void grdRelations_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
band.Override.AllowUpdate = DefaultableBoolean.False;
layout.AutoFitStyle = AutoFitStyle.ExtendLastColumn;
band.Override.MinRowHeight = 3;
band.Override.RowSizing = RowSizing.AutoFixed;
band.Override.RowSizingAutoMaxLines = 5;
band.Columns["TenderLineId"].CellActivation = Activation.ActivateOnly;
band.Columns["Description"].CellMultiLine = DefaultableBoolean.True;
band.Columns["Description"].VertScrollBar = true;
band.Columns["Concept"].CellMultiLine = DefaultableBoolean.True;
band.Columns["Concept"].VertScrollBar = true;
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["Quantity"],
TextFormatEnum.NaturalQuantity);
}
/// <summary>
/// 设置中文文本
/// </summary>
/// <param name="gridlayout"></param>
/// <param name="ColumnsName"></param>
/// <param name="CaptionName"></param>
void SetUltragridCaption(UltraGridLayout gridlayout, string ColumnsName, string CaptionName)
{
gridlayout.Bands[0].Columns[ColumnsName].Header.Caption = CaptionName;
}
private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridLayout gridLayout = e.Layout;
switch (this.contentType)
{
case Enums.ContentType.Customers:
#region Customers
// use fixed headers.
gridLayout.UseFixedHeaders = true;
// turn off the fixed header indicator so the user cannot change them.
gridLayout.Override.FixedHeaderIndicator = FixedHeaderIndicator.None;
// turn off the border that draws between fixed cells and non-fixed cells.
gridLayout.Override.FixedCellSeparatorColor = Color.Transparent;
// hide the customer id column.
gridLayout.Bands[0].Columns["CustomerID"].Hidden = true;
// add an unbound column for an image.
if (!gridLayout.Bands[0].Columns.Contains("CustomerImage"))
{
UltraGridColumn col = gridLayout.Bands[0].Columns.Insert(0, "CustomerImage");
col.DataType = typeof(Image);
col.Style = ColumnStyle.Image;
col.Header.Caption = string.Empty;
col.Header.Fixed = true;
}
#endregion // Customers
break;
case Enums.ContentType.Orders:
#region Orders
// hide the order id column.
gridLayout.Bands[0].Columns["OrderID"].Hidden = true;
// set the caption of the other id fields to a ui friendly string.
gridLayout.Bands[0].Columns["CustomerID"].Header.Caption = Utilities.GetLocalizedString("Customer");
gridLayout.Bands[0].Columns["EmployeeID"].Header.Caption = Utilities.GetLocalizedString("Employee");
// An example to show a combo editor in a cell instead of showing the id.
Infragistics.Win.UltraWinEditors.UltraComboEditor ultraComboEditor = new UltraComboEditor();
this.Controls.Add(ultraComboEditor);
ultraComboEditor.DataSource = this.nWind1.Tables["Employees"];
ultraComboEditor.DisplayMember = "LastName";
ultraComboEditor.ValueMember = "EmployeeID";
ultraComboEditor.ValueList.ItemHeight = 35;
gridLayout.Bands[0].Columns["EmployeeID"].Style = ColumnStyle.DropDownList;
gridLayout.Bands[0].Columns["EmployeeID"].EditorComponent = ultraComboEditor;
// An example to show a combo editor in a cell instead of showing the id.
Infragistics.Win.UltraWinEditors.UltraComboEditor ultraComboEditor2 = new UltraComboEditor();
this.Controls.Add(ultraComboEditor2);
ultraComboEditor2.DataSource = this.nWind1.Tables["Customers"];
ultraComboEditor2.DisplayMember = "CompanyName";
ultraComboEditor2.ValueMember = "CustomerID";
ultraComboEditor2.ValueList.ItemHeight = 35;
gridLayout.Bands[0].Columns["CustomerID"].Style = ColumnStyle.DropDownList;
gridLayout.Bands[0].Columns["CustomerID"].EditorComponent = ultraComboEditor2;
// An example to show a combo editor in a cell instead of showing the id.
Infragistics.Win.UltraWinEditors.UltraComboEditor ultraComboEditor3 = new UltraComboEditor();
this.Controls.Add(ultraComboEditor3);
ultraComboEditor3.DataSource = this.nWind1.Tables["Shippers"];
ultraComboEditor3.DisplayMember = "CompanyName";
ultraComboEditor3.ValueMember = "ShipperID";
ultraComboEditor3.ValueList.ItemHeight = 35;
gridLayout.Bands[0].Columns["ShipVia"].Style = ColumnStyle.DropDownList;
gridLayout.Bands[0].Columns["ShipVia"].EditorComponent = ultraComboEditor3;
// An example to show a calendar combo in a cell instead of showing the DateTimeEditor and the .net month calendar.
Infragistics.Win.UltraWinSchedule.UltraCalendarCombo ultraCalendarCombo = new UltraCalendarCombo();
this.Controls.Add(ultraCalendarCombo);
gridLayout.Bands[0].Columns["OrderDate"].EditorComponent = ultraCalendarCombo;
Infragistics.Win.UltraWinSchedule.UltraCalendarCombo ultraCalendarCombo2 = new UltraCalendarCombo();
this.Controls.Add(ultraCalendarCombo2);
gridLayout.Bands[0].Columns["RequiredDate"].EditorComponent = ultraCalendarCombo2;
Infragistics.Win.UltraWinSchedule.UltraCalendarCombo ultraCalendarCombo3 = new UltraCalendarCombo();
this.Controls.Add(ultraCalendarCombo3);
gridLayout.Bands[0].Columns["ShippedDate"].EditorComponent = ultraCalendarCombo3;
#endregion // Orders
break;
case Enums.ContentType.OrderDetails:
#region OrderDetails
// set the caption of the other id fields to a ui friendly string.
gridLayout.Bands[0].Columns["OrderID"].Header.Caption = Utilities.GetLocalizedString("Order");
gridLayout.Bands[0].Columns["ProductID"].Header.Caption = Utilities.GetLocalizedString("Product");
// give ProductID a MinWidth so it looks nice.
gridLayout.Bands[0].Columns["ProductID"].MinWidth = 200;
// An example to show a combo editor in a cell instead of showing the id.
Infragistics.Win.UltraWinEditors.UltraComboEditor ultraComboEditor4 = new UltraComboEditor();
this.Controls.Add(ultraComboEditor4);
ultraComboEditor4.DataSource = this.nWind1.Tables["Products"];
ultraComboEditor4.DisplayMember = "ProductName";
ultraComboEditor4.ValueMember = "ProductID";
gridLayout.Bands[0].Columns["ProductID"].Style = ColumnStyle.DropDownList;
gridLayout.Bands[0].Columns["ProductID"].EditorComponent = ultraComboEditor4;
// UnitPrice can pick up local currency symbols and display styles.
gridLayout.Bands[0].Columns["UnitPrice"].Style = ColumnStyle.Currency;
gridLayout.Bands[0].Columns["UnitPrice"].MaskDisplayMode = MaskMode.IncludeLiterals;
// make this grid show in OutlookGroupBy mode.
gridLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;
// make the OrderID column the GroupBy column.
gridLayout.Bands[0].SortedColumns.Add("OrderID", false, true);
#endregion // OrderDetails
break;
case Enums.ContentType.QuarterlyOrders:
break;
case Enums.ContentType.ProductSales:
#region Products
// hide the product id and supplier id columns.
gridLayout.Bands[0].Columns["ProductID"].Hidden = true;
gridLayout.Bands[0].Columns["SupplierID"].Hidden = true;
// set the caption of the other id fields to a ui friendly string.
gridLayout.Bands[0].Columns["CategoryID"].Header.Caption = Utilities.GetLocalizedString("Category");
// An example to show a combo editor in a cell instead of showing the id.
Infragistics.Win.UltraWinEditors.UltraComboEditor ultraComboEditor5 = new UltraComboEditor();
this.Controls.Add(ultraComboEditor5);
ultraComboEditor5.DataSource = this.nWind1.Tables["Categories"];
ultraComboEditor5.DisplayMember = "CategoryName";
ultraComboEditor5.ValueMember = "CategoryID";
gridLayout.Bands[0].Columns["CategoryID"].Style = ColumnStyle.DropDownList;
gridLayout.Bands[0].Columns["CategoryID"].EditorComponent = ultraComboEditor5;
// UnitPrice can pick up local currency symbols and display styles.
gridLayout.Bands[0].Columns["UnitPrice"].Style = ColumnStyle.Currency;
gridLayout.Bands[0].Columns["UnitPrice"].MaskDisplayMode = MaskMode.IncludeLiterals;
#endregion // Products
break;
case Enums.ContentType.SalesByCategory:
#region Categories
// hide the category id and the hideous NorthWind picture columns.
gridLayout.Bands[0].Columns["CategoryID"].Hidden = true;
gridLayout.Bands[0].Columns["Picture"].Hidden = true;
#endregion // Categories
break;
case Enums.ContentType.SalesByQuarter:
break;
case Enums.ContentType.SalesByYear:
break;
case Enums.ContentType.Shippers:
#region Shippers
// hide the shipper id column
gridLayout.Bands[0].Columns["ShipperID"].Hidden = true;
#endregion // Shippers
break;
case Enums.ContentType.Suppliers:
break;
default:
break;
}
#region UI friendly column headers
// give the column headers more readable strings instead of mushed camel casing text.
foreach (UltraGridBand ultraGridBand in gridLayout.Bands)
{
foreach (UltraGridColumn column in ultraGridBand.Columns)
{
Utilities.SetUIFriendlyString(column.Header);
}
}
#endregion //UI friendly column headers
}
/// <summary>
/// Handles the InitializeLayot of the grid.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grdCashflowSources_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
// Store some useful variable refernences.
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
UltraGridOverride ov = layout.Override;
// This grid needs no selection.
ov.HeaderClickAction = HeaderClickAction.Default;
ov.SelectTypeCell = SelectType.None;
ov.SelectTypeRow = SelectType.None;
ov.SelectTypeCol = SelectType.None;
ov.CellClickAction = CellClickAction.CellSelect;
// No row selectors or borders.
ov.RowSelectors = DefaultableBoolean.False;
ov.BorderStyleCell = UIElementBorderStyle.None;
ov.BorderStyleRow = UIElementBorderStyle.None;
ov.BorderStyleHeader = UIElementBorderStyle.None;
// Set the BackColor and ForeColor of the row so that the rows look like the same
// color as the background.
ov.RowAppearance.BackColor = Color.FromArgb(235, 233, 234);
ov.RowAppearance.ForeColor = Color.FromArgb(154, 154, 154);
// Set up the header colors so that like the rows, the headers also blend
// into the background.
ov.HeaderAppearance.BackColor = Color.FromArgb(235, 233, 234);
ov.HeaderAppearance.ForeColor = Color.FromArgb(102, 102, 102);
ov.HeaderAppearance.FontData.Bold = DefaultableBoolean.True;
// Align the text in all cells and headers to the left.
ov.CellAppearance.TextHAlign = HAlign.Left;
ov.HeaderAppearance.TextHAlign = HAlign.Left;
// Put a little space in between rows.
ov.RowSpacingBefore = 4;
// Don't let the user change anything.
ov.AllowUpdate = DefaultableBoolean.False;
ov.AllowDelete = DefaultableBoolean.False;
ov.AllowColMoving = AllowColMoving.NotAllowed;
// The data source has a whole bunch of fields in it and we only want to display
// a small few. So start off hiding them all, and then we will make the ones we want visible.
foreach (UltraGridColumn column in band.Columns)
{
column.Hidden = true;
}
// Label Column
// This column shows the legend.
//
#region Label Column
UltraGridColumn labelColumn = CashflowDetails.GetOrCreateUnboundColumn(band, "label", typeof(Image), null);
labelColumn.Header.VisiblePosition = 0;
labelColumn.Header.Caption = this.GetLocalizedGridHeaderCaption(labelColumn.Key);
labelColumn.Hidden = false;
#endregion // Label Column
// Source Column
// This column shows the source of the inflow / outflow.
//
#region Source Column
UltraGridColumn sourceColumn = band.Columns["Source"];
sourceColumn.Header.VisiblePosition = 1;
sourceColumn.Header.Caption = this.GetLocalizedGridHeaderCaption(sourceColumn.Key);
sourceColumn.Hidden = false;
// Loop through each source.
Source[] sources = (Source[])Enum.GetValues(typeof(Source));
ValueList sourcesValueList = new ValueList();
foreach (Source source in sources)
{
string resourceName = string.Format("Source_Text_{0}", source.ToString());
sourcesValueList.ValueListItems.Add(source, Utilities.LocalizeString(resourceName));
}
sourceColumn.ValueList = sourcesValueList;
#endregion // Source Column
// Value Column
// Show the value (inflow or outflow) for the current selected month.
//
#region Value Column
// The key of the value column will vary depending on whether this is Inflow or Outflow
// so get the key and store it here.
string valueColumnKey = this.GetValueColumnKey();
UltraGridColumn valueColumn = band.Columns[valueColumnKey];
valueColumn.Header.VisiblePosition = 2;
valueColumn.Header.Caption = this.GetLocalizedGridHeaderCaption("value");
valueColumn.Hidden = false;
// Give this column a nice currently format.
valueColumn.Format = "c0";
#endregion // Value Column
// LastMonth column
// This column shows the value from last month and also a little indicator and a percentage
// of how much we went up or down from the previous month.
//
#region LastMonth Column
UltraGridColumn lastMonthColumn = CashflowDetails.GetOrCreateUnboundColumn(band, "last month", typeof(string), null);
lastMonthColumn.Header.VisiblePosition = 3;
lastMonthColumn.Header.Caption = this.GetLocalizedGridHeaderCaption(lastMonthColumn.Key);
lastMonthColumn.Hidden = false;
#endregion // LastMonth Column
// LastYear column
// This column shows the value from last year and also a little indicator and a percentage
// of how much we went up or down from the previous year.
//
#region LastYear Column
UltraGridColumn lastYearColumn = CashflowDetails.GetOrCreateUnboundColumn(band, "last year", typeof(string), null);
lastYearColumn.Header.VisiblePosition = 4;
lastYearColumn.Header.Caption = this.GetLocalizedGridHeaderCaption(lastYearColumn.Key);
lastYearColumn.Hidden = false;
#endregion // LastYear Column
// Projected column
// This column shows the project value (inflow or outflow) for the selected month and
// also a little indicator and a percentage of how the actual value differs from the
// projection
//
#region Projected column
UltraGridColumn projectedColumn = CashflowDetails.GetOrCreateUnboundColumn(band, "projected", typeof(string), null);
projectedColumn.Header.VisiblePosition = 5;
projectedColumn.Header.Caption = this.GetLocalizedGridHeaderCaption(projectedColumn.Key);
projectedColumn.Hidden = false;
#endregion // Projected column
// Make the visible columns fill the available width of the grid.
layout.AutoFitStyle = AutoFitStyle.ResizeAllColumns;
}
public void LoadData()
{
UltraGridLayout layout = this.grdDetalleQuincena.DisplayLayout;
UltraGridBand band = layout.Bands[0];
try
{
this.LlenaDicMeses();
if (this.DtDetalleComisiones == null)
{
return;
}
this.Text = this.Title;
try
{
checkedColumns = FileUtils.Read("dictionary.bin");
}
catch
{
checkedColumns = new Dictionary <string, string>();
}
try
{
this.grdDetalleQuincena.DataSource = this.DtDetalleComisiones.AsEnumerable()
.AsParallel().Where(x => Convert.ToInt32(x["mes"]) == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año).OrderBy(x => x["es_servicio"]).ThenBy(x => x["factura"]).CopyToDataTable();
this.tcFacturasPagadas.TabPages["FacturasPagadas"].Text = "Facturas Pagadas [" +
this.grdDetalleQuincena.Rows.Count + "]";
}
catch
{
this.tcFacturasPagadas.TabPages["FacturasPagadas"].Text = "Facturas Pagadas [0]";
}
try
{
this.grdFacturasCanceladas.DataSource = this.DtFacturasCanceladas.AsEnumerable()
.AsParallel().Where(x => this.dicMeses[x["mes"].ToString()] == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año).OrderBy(x => x["factura"]).CopyToDataTable();
this.tcComplemento.TabPages["FacturasCanceladas"].Text = "Facturas Canceladas [" +
this.grdFacturasCanceladas.Rows.Count + "]";
}
catch
{
this.tcComplemento.TabPages["FacturasCanceladas"].Text = "Facturas Canceladas [0]";
}
try
{
this.grdFacturasPendientes.DataSource = this.DtFacturasPendientes.AsEnumerable()
.AsParallel().Where(x => this.dicMeses[x["mes"].ToString()] == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año).OrderBy(x => x["factura"]).CopyToDataTable();
this.tcComplemento.TabPages["FacturasPendientes"].Text = "Facturas Pendientes [" +
this.grdFacturasPendientes.Rows.Count + "]";
}
catch
{
this.tcComplemento.TabPages["FacturasPendientes"].Text = "Facturas Pendientes [0]";
}
foreach (string columName in this.DtDetalleComisiones.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName))
{
this.clbColumnas.Items.Add(columName);
this.columnIndexes.Add(columName, this.clbColumnas.Items.Count - 1);
if (checkedColumns.ContainsKey(columName))
{
this.clbColumnas.SetItemChecked(this.clbColumnas.Items.Count - 1,
checkedColumns[columName] == "1");
band.Columns[columName].Hidden = checkedColumns[columName] == "0";
}
else
{
this.checkedColumns.Add(columName, "1");
this.clbColumnas.SetItemChecked(this.clbColumnas.Items.Count - 1, true);
}
}
}
catch (Exception ex) { ex.ToString(); }
}
private void grdDetalleQuincena_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
UltraGridLayout layout = e.Layout;
UltraGridBand band = layout.Bands[0];
e.Layout.Override.AllowUpdate = DefaultableBoolean.False;
e.Layout.Override.HeaderClickAction = HeaderClickAction.Select;
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["fiscal"],
WindowsFormsUtil.TextMaskFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["factura"],
WindowsFormsUtil.TextMaskFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["factura_original"],
WindowsFormsUtil.TextMaskFormatEnum.Integer);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["importe"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["costo"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["utilidad"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["utilidad_comisionable"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["margen_utilidad"],
WindowsFormsUtil.TextMaskFormatEnum.Percentage);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["total_acumulado"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["acumulado_cuota"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["acumulado_comision"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["acumulado_comision_agente"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["total"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["total_pagado"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["porcentaje_comision"],
WindowsFormsUtil.TextMaskFormatEnum.Percentage);
WindowsFormsUtil.SetUltraColumnFormat(band.Columns["cuota"],
WindowsFormsUtil.TextMaskFormatEnum.Currency);
Parallel.ForEach(this.grdDetalleQuincena.Rows, row =>
{
if (row.Cells["pendiente_pago"].Value.ToString() == "Si")
{
row.CellAppearance.BackColor = Color.LightGreen;
}
decimal utilidad = Convert.ToDecimal(row.Cells["utilidad_comisionable"].Value);
decimal utilidadComissionable = Convert.ToDecimal(row.Cells["utilidad_comisionable"].Value);
if (utilidad - utilidadComissionable > 0.01M || utilidadComissionable <= 0)
{
if (row.CellAppearance.BackColor == Color.LightGreen)
{
row.CellAppearance.BackColor = Color.YellowGreen;
}
else
{
row.CellAppearance.BackColor = Color.Yellow;
}
}
});
}
