private void GroupHeaderStyle(UltraGridGroup @group)
{
var color = GetColorRandom();
group.CellAppearance.BackColor = color;
group.Header.Appearance.BackColor = color;
}
private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
//Create the groups
UltraGridGroup accountGroup = e.Layout.Bands[0].Groups.Add("Account", "Account");
UltraGridGroup contraGroup = e.Layout.Bands[0].Groups.Add("ContraAccount", "Contra account");
UltraGridGroup contraBill = e.Layout.Bands[0].Groups.Add("ContraBill", "Billing account");
UltraGridGroup contraNom = e.Layout.Bands[0].Groups.Add("ContraNom", "Nominal account");
// Set the parent Group
contraBill.RowLayoutGroupInfo.ParentGroup = contraGroup;
contraNom.RowLayoutGroupInfo.ParentGroup = contraGroup;
foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn col in e.Layout.Bands[0].Columns)
{
//Set the Group for each columns
switch (col.Key)
{
case "A":
case "B":
case "C":
ultraGrid1.DisplayLayout.Bands[0].Columns[col.Key].RowLayoutColumnInfo.ParentGroup = accountGroup;
break;
case "D":
case "E":
case "F":
ultraGrid1.DisplayLayout.Bands[0].Columns[col.Key].RowLayoutColumnInfo.ParentGroup = contraBill;
break;
case "G":
case "H":
case "I":
case "J":
case "K":
ultraGrid1.DisplayLayout.Bands[0].Columns[col.Key].RowLayoutColumnInfo.ParentGroup = contraNom;
break;
}
}
// This property is important, because determinate that we are using groups
ultraGrid1.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;
}
private void frmListaAtenciones_Load(object sender, EventArgs e)
{
UltraGridBand band = this.grdData.DisplayLayout.Bands[0];
//Arrange the band's column in Group Layout style
this.grdData.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;
//Enbale Column/Group moving
this.grdData.DisplayLayout.Override.AllowRowLayoutColMoving = Infragistics.Win.Layout.GridBagLayoutAllowMoving.AllowAll;
UltraGridGroup GrupoDatosPersonales = band.Groups.Add("GrupoDatosGenerales", "DatosGenerales");
band.Groups["GrupoDatosGenerales"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["v_ServiceId"].RowLayoutColumnInfo.ParentGroup = GrupoDatosPersonales;
band.Columns["d_ServiceDate"].RowLayoutColumnInfo.ParentGroup = GrupoDatosPersonales;
band.Columns["v_Pacient"].RowLayoutColumnInfo.ParentGroup = GrupoDatosPersonales;
band.Columns["v_AptitudeStatusName"].RowLayoutColumnInfo.ParentGroup = GrupoDatosPersonales;
//Create a parent group for 1stQuarter and 2ndQuarter columns
UltraGridGroup GrupoCertificados = band.Groups.Add("GrupoCertificado", "Certificados");
band.Groups["GrupoCertificado"].Header.Appearance.BackColor = System.Drawing.Color.Green;
band.Columns["CertGenerado"].RowLayoutColumnInfo.ParentGroup = GrupoCertificados;
band.Columns["CertEnviado"].RowLayoutColumnInfo.ParentGroup = GrupoCertificados;
//Create a parent group for 1stQuarter and 2ndQuarter columns
UltraGridGroup GrupoHistorias = band.Groups.Add("GrupoHistorias", "Historias");
band.Groups["GrupoHistorias"].Header.Appearance.BackColor = System.Drawing.Color.Yellow;
band.Columns["HistoriaGenerada"].RowLayoutColumnInfo.ParentGroup = GrupoHistorias;
band.Columns["HistoriaEnviada"].RowLayoutColumnInfo.ParentGroup = GrupoHistorias;
dtpDateTimeStar.Value = dtpDateTimeStar.Value.AddDays(-1);
OperationResult objOperationResult = new OperationResult();
var clientOrganization = BLL.Utils.GetJoinOrganizationAndLocation(ref objOperationResult, Globals.ClientSession.i_CurrentExecutionNodeId);
Utils.LoadDropDownList(ddlCustomerOrganization, "Value1", "Id", clientOrganization, DropDownListAction.All);
// Obtener permisos de cada examen de un rol especifico
var componentProfile = _serviceBL.GetRoleNodeComponentProfileByRoleNodeId(Globals.ClientSession.i_CurrentExecutionNodeId, Globals.ClientSession.i_RoleId.Value);
_componentListTemp = BLL.Utils.GetAllComponents(ref objOperationResult);
var xxx = _componentListTemp.FindAll(p => p.Value4 != -1);
List <KeyValueDTO> groupComponentList = xxx.GroupBy(x => x.Value4).Select(group => group.First()).ToList();
groupComponentList.AddRange(_componentListTemp.ToList().FindAll(p => p.Value4 == -1));
// Remover los componentes que no estan asignados al rol del usuario
var results = groupComponentList.FindAll(f => componentProfile.Any(t => t.v_ComponentId == f.Value2));
dtpDateTimeStar.CustomFormat = "dd/MM/yyyy";
dptDateTimeEnd.CustomFormat = "dd/MM/yyyy";
// Establecer el filtro inicial para los datos
strFilterExpression = null;
}
public void InitGrid()
{
DataTable columns = new DataTable();
DataColumn column = new DataColumn();
column = columns.Columns.Add(colCodigo);
column.Caption = "CÓDIGO";
column.DataType = typeof(String);
column = columns.Columns.Add(colDescripcion);
column.Caption = "DESCRIPCIÓN";
column.DataType = typeof(String);
column = columns.Columns.Add(colUnidad);
column.Caption = "UNIDAD";
column.DataType = typeof(String);
column = columns.Columns.Add(colCantidadCotizacion);
column.Caption = "CANTIDAD";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colPrecioCotizacion);
column.Caption = "PRECIO";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colTotalCotizacion);
column.Caption = "TOTAL";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colCantidadReal);
column.Caption = "CANTIDAD";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colPrecioReal);
column.Caption = "PRECIO";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colTotalReal);
column.Caption = "TOTAL";
column.DataType = typeof(decimal);
ugItems.DataSource = columns;
ugItems.DisplayLayout.Bands[0].Columns[colDescripcion].Width = 200;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].Header.Appearance.ForeColor = Color.Blue;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].Header.Appearance.ForeColor = Color.Blue;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].Header.Appearance.ForeColor = Color.Blue;
UltraGridGroup grupoAM = new UltraGridGroup("ACABADO / MÁQUINA", 1);
UltraGridGroup grupoCotizacion = new UltraGridGroup("COTIZACIÓN", 2);
UltraGridGroup grupoReal = new UltraGridGroup("REAL", 3);
grupoReal.Header.Appearance.ForeColor = Color.Blue;
grupoReal.Header.Appearance.FontData.Bold = DefaultableBoolean.True;
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoAM);
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoCotizacion);
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoReal);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCodigo]);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colDescripcion]);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colUnidad]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colTotalReal]);
MapKeys(ref ugItems);
}
public void InitGrid()
{
DataTable columns = new DataTable();
DataColumn column = new DataColumn();
column = columns.Columns.Add(colCodigo);
column.Caption = "CÓDIGO";
column.DataType = typeof(String);
column = columns.Columns.Add(colDescripcion);
column.Caption = "DESCRIPCIÓN";
column.DataType = typeof(String);
column = columns.Columns.Add(colUnidad);
column.Caption = "UNIDAD";
column.DataType = typeof(String);
column = columns.Columns.Add(colCantidadCotizacion);
column.Caption = "CANTIDAD";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colPrecioCotizacion);
column.Caption = "PRECIO";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colTotalCotizacion);
column.Caption = "TOTAL";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colCantidadReal);
column.Caption = "CANTIDAD";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colPrecioReal);
column.Caption = "PRECIO";
column.DataType = typeof(decimal);
column = columns.Columns.Add(colTotalReal);
column.Caption = "TOTAL";
column.DataType = typeof(decimal);
ugItems.DataSource = columns;
ugItems.DisplayLayout.Bands[0].Columns[colDescripcion].Width = 200;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal].Header.Appearance.ForeColor = Color.Blue;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal].Header.Appearance.ForeColor = Color.Blue;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DoubleNonNegative;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellAppearance.TextHAlign = HAlign.Right;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellAppearance.BackColor = Color.LemonChiffon;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].CellActivation = Activation.NoEdit;
ugItems.DisplayLayout.Bands[0].Columns[colTotalReal].Header.Appearance.ForeColor = Color.Blue;
UltraGridGroup grupoAM = new UltraGridGroup("ACABADO / MÁQUINA",1);
UltraGridGroup grupoCotizacion = new UltraGridGroup("COTIZACIÓN",2);
UltraGridGroup grupoReal = new UltraGridGroup("REAL",3);
grupoReal.Header.Appearance.ForeColor = Color.Blue;
grupoReal.Header.Appearance.FontData.Bold = DefaultableBoolean.True;
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoAM);
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoCotizacion);
ugItems.DisplayLayout.Bands[0].Groups.Add(grupoReal);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCodigo]);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colDescripcion]);
grupoAM.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colUnidad]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCantidadCotizacion]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colPrecioCotizacion]);
grupoCotizacion.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colTotalCotizacion]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colCantidadReal]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colPrecioReal]);
grupoReal.Columns.Add(ugItems.DisplayLayout.Bands[0].Columns[colTotalReal]);
MapKeys(ref ugItems);
}
private void frmLaboratorio_Load(object sender, EventArgs e)
{
UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
//Arrange the band's column in Group Layout style
this.ultraGrid1.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;
//Enbale Column/Group moving
this.ultraGrid1.DisplayLayout.Override.AllowRowLayoutColMoving = Infragistics.Win.Layout.GridBagLayoutAllowMoving.AllowAll;
#region Grupo Acido Urico
//Create a parent group for 1stQuarter and 2ndQuarter columns
UltraGridGroup GrupoAcidoUrico = band.Groups.Add("GrupoAcidoUrico", "Ácido Úrico");
band.Columns["AcidoUrico"].RowLayoutColumnInfo.ParentGroup = GrupoAcidoUrico;
band.Columns["AUricoDeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAcidoUrico;
#endregion
#region Aglutaciones
UltraGridGroup GrupoAglutaciones = band.Groups.Add("Aglutaciones", "Aglutaciones en Lámina");
band.Groups["Aglutaciones"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Groups["Aglutaciones"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ParatificoA"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["ParatificoADeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["tificoO"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["tificoODeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["TificoH"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["TificoHDeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["ParatificoB"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["ParatificoBDeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAglutaciones;
band.Columns["ParatificoA"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ParatificoA"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ParatificoADeseable"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ParatificoADeseable"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["tificoO"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["tificoO"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["tificoODeseable"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["tificoODeseable"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["TificoH"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["TificoH"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["TificoHDeseable"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["TificoHDeseable"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ParatificoB"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ParatificoB"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ParatificoBDeseable"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ParatificoBDeseable"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
#endregion
#region Antígeno Prostático
UltraGridGroup GrupoAntigenoProstatico = band.Groups.Add("GrupoAntigenoProstatico", "Ántigeno Prostático");
band.Columns["PASDeseable"].RowLayoutColumnInfo.ParentGroup = GrupoAntigenoProstatico;
band.Columns["AntigenoProstatico"].RowLayoutColumnInfo.ParentGroup = GrupoAntigenoProstatico;
#endregion
#region BK - Directo
UltraGridGroup GrupoBKDirecto = band.Groups.Add("GrupoBKDirecto", "BK Directo");
band.Groups["GrupoBKDirecto"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Groups["GrupoBKDirecto"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ResultadoBK"].RowLayoutColumnInfo.ParentGroup = GrupoBKDirecto;
band.Columns["MuestraBK"].RowLayoutColumnInfo.ParentGroup = GrupoBKDirecto;
band.Columns["ColoracionBK"].RowLayoutColumnInfo.ParentGroup = GrupoBKDirecto;
band.Columns["ResultadoBK"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ResultadoBK"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["MuestraBK"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["MuestraBK"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
band.Columns["ColoracionBK"].Header.Appearance.BackColor = System.Drawing.Color.Tomato;
band.Columns["ColoracionBK"].Header.Appearance.BackColor2 = System.Drawing.Color.Tomato;
#endregion
}
