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 }