private void LoadGroup() { try { GroupsNames = new Dictionary <int, string>(); Groups = new Dictionary <int, GridViewColumnGroup>(); ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); Int32 IndexGroup = 0; Int32 IndexColumn = 0; GridViewColumnGroup group = new GridViewColumnGroup(); Int32 nivel = 0; foreach (DataColumn column in Presenter.DTReporte.Columns) { if (column.ColumnName.Contains('#')) { String[] columns = column.ColumnName.Split('#'); if (!GroupsNames.ContainsKey(nivel) || (GroupsNames.ContainsKey(nivel) && GroupsNames[nivel] != columns[nivel])) { GroupsNames = new Dictionary <int, string>(); Groups = new Dictionary <int, GridViewColumnGroup>(); String columngroup = columns[nivel]; group = new GridViewColumnGroup(columngroup); if (GroupsNames.ContainsKey(nivel)) { GroupsNames[nivel] = columns[nivel]; Groups[nivel] = group; } else { GroupsNames.Add(nivel, columngroup); Groups.Add(nivel, group); } view.ColumnGroups.Add(group); } else { group = Groups[nivel]; } LoadSubGroup(ref group, column, nivel + 1, IndexColumn, IndexColumn++); } else { view.ColumnGroups.Add(new GridViewColumnGroup(column.ColumnName)); view.ColumnGroups[IndexGroup].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[IndexGroup].Rows[0].Columns.Add(grdItems.Columns[column.ColumnName]); IndexGroup += 1; } IndexColumn += 1; } grdItems.ViewDefinition = view; } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al cargar los grupos.", ex); } }
private void Group_Gridview() { try { ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); view.ColumnGroups.Add(new GridViewColumnGroup("Item Information")); view.ColumnGroups.Add(new GridViewColumnGroup("Purchase Information")); view.ColumnGroups.Add(new GridViewColumnGroup("Current Inventory")); view.ColumnGroups.Add(new GridViewColumnGroup("On Order")); view.ColumnGroups.Add(new GridViewColumnGroup("Recived")); view.ColumnGroups.Add(new GridViewColumnGroup("Backorder")); view.ColumnGroups.Add(new GridViewColumnGroup("Supplied")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["No"]); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["InventoryID"]); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["Name"]); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["Description"]); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["Area"]); view.ColumnGroups[0].Rows[0].Columns.Add(this.dgvData.Columns["ShelfBin"]); view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["Maker"]); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["Supplier"]); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["Price"]); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["Leadtime"]); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["MinStock"]); view.ColumnGroups[1].Rows[0].Columns.Add(this.dgvData.Columns["Plan"]); view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[2].Rows[0].Columns.Add(this.dgvData.Columns["CurrentInventory_Qty"]); view.ColumnGroups[2].Rows[0].Columns.Add(this.dgvData.Columns["CurrentInventory_Velue"]); view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[3].Rows[0].Columns.Add(this.dgvData.Columns["OnOrder_Qty"]); view.ColumnGroups[3].Rows[0].Columns.Add(this.dgvData.Columns["OnOrder_Value"]); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].Columns.Add(this.dgvData.Columns["Receive_Qty"]); view.ColumnGroups[4].Rows[0].Columns.Add(this.dgvData.Columns["Receive_Value"]); view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[5].Rows[0].Columns.Add(this.dgvData.Columns["BackOrder_Qty"]); view.ColumnGroups[5].Rows[0].Columns.Add(this.dgvData.Columns["BackOrder_Value"]); view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[6].Rows[0].Columns.Add(this.dgvData.Columns["Supplied_Qty"]); view.ColumnGroups[6].Rows[0].Columns.Add(this.dgvData.Columns["Supplied_Value"]); view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[7].Rows[0].Columns.Add(this.dgvData.Columns["Balance_Value"]); view.ColumnGroups[7].Rows[0].Columns.Add(this.dgvData.Columns["GrandTotal_Value"]); view.ColumnGroups[7].Rows[0].Columns.Add(this.dgvData.Columns["Remark"]); dgvData.ViewDefinition = view; }catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void SetViewDefinitions(ColumnGroupsViewDefinition dimensionsVd, ColumnGroupsViewDefinition detailsVd, ColumnGroupsViewDefinition furnitureVd) { }
private ColumnGroupsViewDefinition SetColumnGroupsView(RadGridView dgv) { ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); view.ColumnGroups.Add(new GridViewColumnGroup("Num")); view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[0].Rows[0].ColumnNames.Add("Номер модуля"); view.ColumnGroups[0].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("F")); view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[1].Rows[0].ColumnNames.Add("Форма модуля"); view.ColumnGroups[1].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("I")); view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[2].Rows[0].ColumnNames.Add("Icon"); view.ColumnGroups[2].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("Размеры")); view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Высота модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Ширина модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Глубина модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("A размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("B размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("C размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("D размер (мм)"); view.ColumnGroups.Add(new GridViewColumnGroup("zertg")); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].ColumnNames.Add("Сборка модуля2"); view.ColumnGroups[4].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("z")); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].ColumnNames.Add("Задняя стенка2"); view.ColumnGroups[4].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("ppse")); view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[5].Rows[0].ColumnNames.Add("Крепление полки"); view.ColumnGroups[5].ShowHeader = false; view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[6].Rows[0].ColumnNames.Add("Кол-во полок"); view.ColumnGroups[6].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("Фасад")); view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[7].Rows[0].ColumnNames.Add("№ схемы фасада"); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Высота"); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Ширина"); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Тип фасада2"); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Режим расчёта2"); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Материал фасада2"); return(view); }
private void FormatDataGrid(String x_TipoTarifa) { try { RadGridLocalizationProvider.CurrentProvider = new MySpanishRadGridLocalizationProvider(); grdItems.Columns.Clear(); grdItems.EnableHotTracking = true; grdItems.EnableAlternatingRowColor = false; grdItems.ShowFilteringRow = false; grdItems.ShowHeaderCellButtons = false; grdItems.TableElement.RowSpacing = 0; grdItems.TableElement.CellSpacing = 0; grdItems.EnableFiltering = false; grdItems.MasterTemplate.EnableFiltering = false; grdItems.AllowColumnHeaderContextMenu = false; grdItems.AllowCellContextMenu = false; grdItems.AllowAddNewRow = false; grdItems.AllowDeleteRow = false; grdItems.AllowEditRow = false; grdItems.AutoGenerateColumns = false; grdItems.AllowMultiColumnSorting = false; grdItems.AllowRowResize = false; grdItems.AllowColumnResize = true; grdItems.ShowGroupPanel = false; switch (x_TipoTarifa) { case "L": /* Logistico */ GridViewCommandColumn commandEdiarColumn; commandEdiarColumn = new GridViewCommandColumn(); commandEdiarColumn.Name = "Edit"; commandEdiarColumn.HeaderText = @"Editar"; commandEdiarColumn.DefaultText = @"Editar"; commandEdiarColumn.UseDefaultText = true; grdItems.Columns.Add(commandEdiarColumn); grdItems.Columns["Edit"].AllowSort = false; grdItems.Columns["Edit"].AllowFiltering = false; GridViewCommandColumn commandColumn; commandColumn = new GridViewCommandColumn(); commandColumn.Name = "Delete"; commandColumn.HeaderText = @"Eliminar"; commandColumn.DefaultText = @"Eliminar"; commandColumn.UseDefaultText = true; grdItems.Columns.Add(commandColumn); grdItems.Columns["Delete"].AllowSort = false; grdItems.Columns["Delete"].AllowFiltering = false; grdItems.Columns.Add("TIPE_Descripcion", "Rol", "TIPE_Descripcion"); grdItems.Columns["TIPE_Descripcion"].Width = 120; grdItems.Columns.Add("ENTC_RazonSocial", "Entidad", "ENTC_RazonSocial"); grdItems.Columns["ENTC_RazonSocial"].Width = 200; grdItems.Columns.Add("DTAR_Costo20", "Costo", "DTAR_Costo20"); grdItems.Columns["DTAR_Costo20"].Width = 70; grdItems.Columns["DTAR_Costo20"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_Costo20"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_Costo20"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_CostoSada20", "Costo Sada", "DTAR_CostoSada20"); grdItems.Columns["DTAR_CostoSada20"].Width = 70; grdItems.Columns["DTAR_CostoSada20"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_CostoSada20"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_CostoSada20"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_Costo40", "Costo", "DTAR_Costo40"); grdItems.Columns["DTAR_Costo40"].Width = 70; grdItems.Columns["DTAR_Costo40"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_Costo40"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_Costo40"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_CostoSada40", "Costo Sada", "DTAR_CostoSada40"); grdItems.Columns["DTAR_CostoSada40"].Width = 70; grdItems.Columns["DTAR_CostoSada40"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_CostoSada40"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_CostoSada40"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_CostoHBL", "HBL", "DTAR_CostoHBL"); grdItems.Columns["DTAR_CostoHBL"].Width = 70; grdItems.Columns["DTAR_CostoHBL"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_CostoHBL"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_CostoHBL"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_CostoSadaHBL", "HBL Sada", "DTAR_CostoSadaHBL"); grdItems.Columns["DTAR_CostoSadaHBL"].Width = 70; grdItems.Columns["DTAR_CostoSadaHBL"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_CostoSadaHBL"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_CostoSadaHBL"].TextAlignment = ContentAlignment.MiddleRight; ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition(); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Acciones")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Datos Generales")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Standar 20")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Standar 40")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("HBL")); columnGroupsView.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[0].Rows[0].Columns.Add(grdItems.Columns["Edit"]); columnGroupsView.ColumnGroups[0].Rows[0].Columns.Add(grdItems.Columns["Delete"]); columnGroupsView.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[1].Rows[0].Columns.Add(grdItems.Columns["TIPE_Descripcion"]); columnGroupsView.ColumnGroups[1].Rows[0].Columns.Add(grdItems.Columns["ENTC_RazonSocial"]); columnGroupsView.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[2].Rows[0].Columns.Add(grdItems.Columns["DTAR_Costo20"]); columnGroupsView.ColumnGroups[2].Rows[0].Columns.Add(grdItems.Columns["DTAR_CostoSada20"]); columnGroupsView.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[3].Rows[0].Columns.Add(grdItems.Columns["DTAR_Costo40"]); columnGroupsView.ColumnGroups[3].Rows[0].Columns.Add(grdItems.Columns["DTAR_CostoSada40"]); columnGroupsView.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[4].Rows[0].Columns.Add(grdItems.Columns["DTAR_CostoHBL"]); columnGroupsView.ColumnGroups[4].Rows[0].Columns.Add(grdItems.Columns["DTAR_CostoSadaHBL"]); grdItems.ViewDefinition = columnGroupsView; break; case "A": /* Aduana */ GridViewCommandColumn commandEditar; commandEditar = new GridViewCommandColumn(); commandEditar.Name = "Edit"; commandEditar.HeaderText = @"Editar"; commandEditar.DefaultText = @"Editar"; commandEditar.UseDefaultText = true; grdItems.Columns.Add(commandEditar); grdItems.Columns["Edit"].AllowSort = false; grdItems.Columns["Edit"].AllowFiltering = false; grdItems.Columns["Edit"].Width = 60; GridViewCommandColumn commandDeleteColumn; commandDeleteColumn = new GridViewCommandColumn(); commandDeleteColumn.Name = "Delete"; commandDeleteColumn.HeaderText = @"Eliminar"; commandDeleteColumn.DefaultText = @"Eliminar"; commandDeleteColumn.UseDefaultText = true; grdItems.Columns.Add(commandDeleteColumn); grdItems.Columns["Delete"].AllowSort = false; grdItems.Columns["Delete"].AllowFiltering = false; grdItems.Columns.Add("CONS_Desc_SPA", "Base", "CONS_Desc_SPA"); grdItems.Columns["CONS_Desc_SPA"].Width = 300; grdItems.Columns.Add("DTAR_Costo", "Valor", "DTAR_Costo"); grdItems.Columns["DTAR_Costo"].Width = 70; grdItems.Columns["DTAR_Costo"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_Costo"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_Costo"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("DTAR_Minimo", "Minimo", "DTAR_Minimo"); grdItems.Columns["DTAR_Minimo"].Width = 70; grdItems.Columns["DTAR_Minimo"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_Minimo"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_Minimo"].TextAlignment = ContentAlignment.MiddleRight; break; case "T": /* Transporte */ GridViewCommandColumn commandEdita; commandEdita = new GridViewCommandColumn(); commandEdita.Name = "Edit"; commandEdita.HeaderText = @"Editar"; commandEdita.DefaultText = @"Editar"; commandEdita.UseDefaultText = true; grdItems.Columns.Add(commandEdita); grdItems.Columns["Edit"].AllowSort = false; grdItems.Columns["Edit"].AllowFiltering = false; GridViewCommandColumn commanDeleteColumn; commanDeleteColumn = new GridViewCommandColumn(); commanDeleteColumn.Name = "Delete"; commanDeleteColumn.HeaderText = @"Eliminar"; commanDeleteColumn.DefaultText = @"Eliminar"; commanDeleteColumn.UseDefaultText = true; grdItems.Columns.Add(commanDeleteColumn); grdItems.Columns["Delete"].AllowSort = false; grdItems.Columns["Delete"].AllowFiltering = false; grdItems.Columns.Add("CONS_Desc_TRA", "Tipo", "CONS_Desc_TRA"); grdItems.Columns["CONS_Desc_TRA"].Width = 120; grdItems.Columns.Add("ORIGEN", "Origen", "ORIGEN"); grdItems.Columns["ORIGEN"].Width = 150; grdItems.Columns.Add("DESTINO", "Destino", "DESTINO"); grdItems.Columns["DESTINO"].Width = 150; grdItems.Columns.Add("DTAR_Costo", "Costo", "DTAR_Costo"); grdItems.Columns["DTAR_Costo"].Width = 70; grdItems.Columns["DTAR_Costo"].FormatString = @"{0:###,##0.00}"; grdItems.Columns["DTAR_Costo"].AutoSizeMode = BestFitColumnMode.DisplayedCells; grdItems.Columns["DTAR_Costo"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns.Add("CONS_Desc_SPA", "Base", "CONS_Desc_SPA"); grdItems.Columns["CONS_Desc_SPA"].Width = 120; GridViewCheckBoxColumn chkDTAR_Roundtrip = new GridViewCheckBoxColumn(); chkDTAR_Roundtrip.Name = "DTAR_Roundtrip"; chkDTAR_Roundtrip.HeaderText = @"Roundtrip"; chkDTAR_Roundtrip.FieldName = "DTAR_Roundtrip"; grdItems.Columns.Add(chkDTAR_Roundtrip); grdItems.Columns["DTAR_Roundtrip"].Width = 65; grdItems.Columns["DTAR_Roundtrip"].ReadOnly = true; break; } } catch (Exception ex) { Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.FormatDataGridView, ex); } }
private void InitializeGrid() { this.radGridView1.Columns["FirstName"].Width = 80; this.radGridView1.Columns["LastName"].Width = 80; this.radGridView1.Columns["Title"].Width = 120; this.radGridView1.Columns["Photo"].Width = 80; this.radGridView1.Columns["Photo"].ImageLayout = ImageLayout.Stretch; this.radGridView1.Columns["City"].Width = 70; this.radGridView1.Columns["Country"].Width = 70; this.radGridView1.Columns["Address"].Width = 200; this.radGridView1.Columns["Notes"].Width = 260; this.radGridView1.Columns["Notes"].WrapText = true; this.radGridView1.Columns["BirthDate"].FormatString = "{0:d}"; this.radGridView1.Columns["BirthDate"].Width = 120; this.radGridView1.Columns["HireDate"].FormatString = "{0:d}"; ((GridViewTextBoxColumn)this.radGridView1.Columns["Notes"]).Multiline = true; tableViewInfo = new ViewDefinitionInfo(); tableViewInfo.ViewDefinition = (TableViewDefinition)this.radGridView1.ViewDefinition; tableViewInfo.Columns = new List <string>() { "FirstName", "LastName", "Title", "Country", "HomePhone", "Address", "Check", "Combo" }; // column groups view ColumnGroupsViewDefinition cgv = new ColumnGroupsViewDefinition(); columnGroupViewInfo = new ViewDefinitionInfo(); columnGroupViewInfo.ViewDefinition = cgv; columnGroupViewInfo.Columns = new List <string>() { "Photo", "FirstName", "LastName", "Title", "Address", "City", "Country", "HomePhone", "Notes" }; columnGroupViewInfo.RowHeight = 90; columnGroupViewInfo.HeaderHeight = 60; cgv.ColumnGroups.Add(new GridViewColumnGroup()); cgv.ColumnGroups.Add(new GridViewColumnGroup("General")); cgv.ColumnGroups.Add(new GridViewColumnGroup("Details")); cgv.ColumnGroups.Add(new GridViewColumnGroup("Notes")); cgv.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[0].Rows[0].Columns.Add(this.radGridView1.Columns["Photo"]); cgv.ColumnGroups[0].ShowHeader = false; cgv.ColumnGroups[1].Rows[0].Columns.Add(this.radGridView1.Columns["Title"]); cgv.ColumnGroups[1].Rows[1].Columns.Add(this.radGridView1.Columns["FirstName"]); cgv.ColumnGroups[1].Rows[1].Columns.Add(this.radGridView1.Columns["LastName"]); cgv.ColumnGroups[2].Rows[0].Columns.Add(this.radGridView1.Columns["City"]); cgv.ColumnGroups[2].Rows[0].Columns.Add(this.radGridView1.Columns["Country"]); cgv.ColumnGroups[2].Rows[0].Columns.Add(this.radGridView1.Columns["HomePhone"]); cgv.ColumnGroups[2].Rows[1].Columns.Add(this.radGridView1.Columns["Address"]); cgv.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); cgv.ColumnGroups[3].Rows[0].Columns.Add(this.radGridView1.Columns["Notes"]); cgv.ColumnGroups[3].ShowHeader = false; // html view htmlViewInfo = new ViewDefinitionInfo(); htmlViewInfo.ViewDefinition = new HtmlViewDefinition(); htmlViewInfo.Columns = new List <string>() { "Photo", "Title", "FirstName", "LastName", "City", "Country", "Address", "Phone", "BirthDate", "HireDate", "HomePhone" }; HtmlViewDefinition htmlView = new HtmlViewDefinition(); htmlView.RowTemplate.Rows.Add(new RowDefinition()); htmlView.RowTemplate.Rows.Add(new RowDefinition()); htmlView.RowTemplate.Rows.Add(new RowDefinition()); htmlView.RowTemplate.Rows[0].Cells.Add(new CellDefinition("Photo", 0, 1, 3)); htmlView.RowTemplate.Rows[0].Cells.Add(new CellDefinition("FirstName", 0, 1, 1)); htmlView.RowTemplate.Rows[0].Cells.Add(new CellDefinition("LastName", 0, 2, 1)); htmlView.RowTemplate.Rows[0].Cells.Add(new CellDefinition("BirthDate", 0, 1, 1)); htmlView.RowTemplate.Rows[1].Cells.Add(new CellDefinition("Title", 0, 3, 1)); htmlView.RowTemplate.Rows[1].Cells.Add(new CellDefinition("HireDate", 0, 1, 1)); htmlView.RowTemplate.Rows[2].Cells.Add(new CellDefinition("Address", 0, 1, 1)); htmlView.RowTemplate.Rows[2].Cells.Add(new CellDefinition("City", 0, 1, 1)); htmlView.RowTemplate.Rows[2].Cells.Add(new CellDefinition("Country", 0, 1, 1)); htmlView.RowTemplate.Rows[2].Cells.Add(new CellDefinition("HomePhone", 0, 1, 1)); htmlView.RowTemplate.Rows[0].Height = 23; htmlView.RowTemplate.Rows[1].Height = 23; htmlView.RowTemplate.Rows[2].Height = 32; htmlViewInfo.RowHeight = -1; htmlViewInfo.HeaderHeight = -1; htmlViewInfo.ViewDefinition = htmlView; }
private void LoadGroup() { try { GroupsNames = new Dictionary <int, string>(); Groups = new Dictionary <int, GridViewColumnGroup>(); ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); Int32 IndexGroup = 0; Int32 IndexColumn = 0; GridViewColumnGroup group = new GridViewColumnGroup(); Int32 nivel = 0; foreach (DataColumn column in Presenter.DTReporte.Columns) { if (column.ColumnName.Contains('#')) { String[] columns = column.ColumnName.Split('#'); if ((GroupsNames.ContainsKey(nivel) && GroupsNames[nivel] != columns[nivel]) || !GroupsNames.ContainsKey(nivel)) { GroupsNames = new Dictionary <int, string>(); Groups = new Dictionary <int, GridViewColumnGroup>(); String columngroup = columns[nivel]; group = new GridViewColumnGroup(columngroup); if (GroupsNames.ContainsKey(nivel)) { GroupsNames[nivel] = columns[nivel]; Groups[nivel] = group; Int32 _nivelesuperiores = nivel + 1; while ((GroupsNames.ContainsKey(_nivelesuperiores))) { GroupsNames.Remove(_nivelesuperiores); Groups.Remove(_nivelesuperiores); _nivelesuperiores += 1; } } else { GroupsNames.Add(nivel, columngroup); Groups.Add(nivel, group); } view.ColumnGroups.Add(group); } else { group = Groups[nivel]; } LoadSubGroup(ref group, column, nivel + 1, IndexColumn, IndexColumn++); } else { grdItems.Columns.Add(column.ColumnName, column.ColumnName, column.ColumnName); view.ColumnGroups.Add(new GridViewColumnGroup(column.ColumnName)); view.ColumnGroups[IndexGroup].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[IndexGroup].Rows[0].Columns.Add(grdItems.Columns[column.ColumnName]); IndexGroup += 1; } IndexColumn += 1; } grdItems.ViewDefinition = view; LoadGroupexcel(); } catch (Exception) { throw; } }
private void FormatDataGrid() { try { Telerik.WinControls.UI.Localization.RadGridLocalizationProvider.CurrentProvider = new Infrastructure.WinForms.Controls.MySpanishRadGridLocalizationProvider(); this.grdItems.Columns.Clear(); this.grdItems.AllowAddNewRow = false; GridViewCommandColumn commandColumn; commandColumn = new GridViewCommandColumn(); commandColumn.Name = "CtaCte"; commandColumn.HeaderText = "Cta Cte."; commandColumn.DefaultText = "CtaCte"; commandColumn.UseDefaultText = true; this.grdItems.Columns.Add(commandColumn); this.grdItems.Columns["CtaCte"].AllowSort = false; this.grdItems.Columns["CtaCte"].WrapText = true; this.grdItems.Columns["CtaCte"].AllowFiltering = false; GridViewCheckBoxColumn checkboxColum = new GridViewCheckBoxColumn(); //checkboxColum.DataType = typeof(bool); checkboxColum.Name = "Seleccionar"; checkboxColum.HeaderText = "Seleccionar"; checkboxColum.FieldName = "Seleccionar"; grdItems.Columns.Add(checkboxColum); grdItems.Columns["Seleccionar"].Width = 90; grdItems.Columns["Seleccionar"].ReadOnly = false; this.grdItems.Columns.Add("TIPO_TDO", "Tipo", "TIPO_TDO"); this.grdItems.Columns.Add("CCCT_Serie", "Serie", "CCCT_Serie"); this.grdItems.Columns.Add("CCCT_Numero", "Número", "CCCT_Numero"); this.grdItems.Columns.Add("ENTC_DocIden", "RUC", "ENTC_DocIden"); this.grdItems.Columns.Add("ENTC_RazonSocial", "Entidad", "ENTC_RazonSocial"); this.grdItems.Columns.Add("CCCT_FechaEmision", "Fecha", "CCCT_FechaEmision"); this.grdItems.Columns.Add("CCCT_Pendiente_Text", "Monto", "CCCT_Pendiente_Text"); this.grdItems.Columns.Add("CCCT_FechaVcto", "Fec. Vencimiento", "CCCT_FechaVcto"); this.grdItems.Columns.Add("OV_OP", "OV / OP", "OV_OP"); this.grdItems.Columns.Add("MBL_HBL", "MBL / HBL", "MBL_HBL"); this.grdItems.Columns.Add("NAVE_Nombre", "Nave Viaje", "NAVE_Nombre"); this.grdItems.Columns.Add("CCCT_Estado", "Estado", "CCCT_Estado"); this.grdItems.Columns.Add("CCCT_Codigo", "Nro.", "CCCT_Codigo"); this.grdItems.Columns.Add("MODULO", "Modulo", "MODULO"); if (Presenter.TPlanilla == Entities.Planillas.TipoPlanilla.MedioVirtual) { this.grdItems.Columns.Add("ENTC_Interbancario", "Cta. Interbancaria", "ENTC_Interbancario"); } this.grdItems.Columns.Add("ENCB_NroCuenta", "Cta. Asignada", "ENCB_NroCuenta"); grdItems.Columns["Seleccionar"].ReadOnly = false; grdItems.Columns["TIPO_TDO"].ReadOnly = true; grdItems.Columns["CCCT_Serie"].ReadOnly = true; grdItems.Columns["CCCT_Numero"].ReadOnly = true; grdItems.Columns["ENTC_DocIden"].ReadOnly = true; grdItems.Columns["ENTC_RazonSocial"].ReadOnly = true; grdItems.Columns["CCCT_FechaEmision"].FormatString = "{0:dd/MM/yyyy}"; grdItems.Columns["CCCT_FechaEmision"].ReadOnly = true; grdItems.Columns["CCCT_Pendiente_Text"].ReadOnly = true; grdItems.Columns["CCCT_Pendiente_Text"].TextAlignment = ContentAlignment.MiddleRight; grdItems.Columns["CCCT_Pendiente_Text"].WrapText = true; grdItems.Columns["CCCT_FechaVcto"].ReadOnly = true; grdItems.Columns["OV_OP"].ReadOnly = true; grdItems.Columns["NAVE_Nombre"].ReadOnly = true; grdItems.Columns["MBL_HBL"].ReadOnly = true; grdItems.Columns["CCCT_Estado"].ReadOnly = true; grdItems.Columns["CCCT_Codigo"].ReadOnly = true; grdItems.Columns["MODULO"].ReadOnly = true; if (Presenter.TPlanilla == Entities.Planillas.TipoPlanilla.MedioVirtual) { grdItems.Columns["ENTC_Interbancario"].ReadOnly = true; } grdItems.Columns["ENCB_NroCuenta"].ReadOnly = true; /* Crear Grupor para Unir cabeceras */ ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition(); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Documento")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Datos Vinculados")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Transacción")); columnGroupsView.ColumnGroups.Add(new GridViewColumnGroup("Datos Bancarios")); int index = 0; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].ShowHeader = false; columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CtaCte"]); index++; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].ShowHeader = false; columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["Seleccionar"]); index++; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["TIPO_TDO"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_Serie"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_Numero"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["ENTC_DocIden"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["ENTC_RazonSocial"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_FechaEmision"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_Pendiente_Text"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_FechaVcto"]); index++; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["OV_OP"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["MBL_HBL"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["NAVE_Nombre"]); index++; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].ShowHeader = true; columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_Codigo"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["CCCT_Estado"]); columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["MODULO"]); index++; columnGroupsView.ColumnGroups[index].Rows.Add(new GridViewColumnGroupRow()); columnGroupsView.ColumnGroups[index].ShowHeader = true; if (Presenter.TPlanilla == Entities.Planillas.TipoPlanilla.MedioVirtual) { columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["ENTC_Interbancario"]); } columnGroupsView.ColumnGroups[index].Rows[0].Columns.Add(this.grdItems.Columns["ENCB_NroCuenta"]); index++; grdItems.ViewDefinition = columnGroupsView; /* Propiedades Finales */ grdItems.ReadOnly = false; grdItems.ShowFilteringRow = false; grdItems.EnableFiltering = false; grdItems.MasterTemplate.EnableFiltering = false; grdItems.EnableGrouping = false; grdItems.MasterTemplate.EnableGrouping = false; grdItems.EnableSorting = false; grdItems.MasterTemplate.EnableCustomSorting = false; grdItems.AutoGenerateColumns = false; } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.FormatDataGridView + " (Grid Servicios)", ex); } }
public void SetViewDefinitions(ColumnGroupsViewDefinition dimensionsVd, ColumnGroupsViewDefinition detailsVd, ColumnGroupsViewDefinition furnitureVd) { mainInfoDgv.ViewDefinition = dimensionsVd; detailsDgv.ViewDefinition = detailsVd; furnitureDgv.DataSource = furnitureVd; }
private void PopulateData() { try { DtBhavCopyData = new DataTable(); DtBhavCopySqlData = new DataTable(); RdGrdReportResult.DataSource = null; DataColumn DcColBhavCopyData = new DataColumn("cSYMBOL", typeof(string)); DcColBhavCopyData.DefaultValue = ""; DcColBhavCopyData.Caption = "Company Name(Symbol)"; DtBhavCopyData.Columns.Add(DcColBhavCopyData); DcColBhavCopyData = new DataColumn("cSERIES", typeof(string)); DcColBhavCopyData.DefaultValue = ""; DcColBhavCopyData.Caption = "Company Series(Series)"; DtBhavCopyData.Columns.Add(DcColBhavCopyData); DcColBhavCopyData = new DataColumn("cSummary", typeof(double)); DcColBhavCopyData.DefaultValue = 0; DcColBhavCopyData.Caption = "Total Summary"; DtBhavCopyData.Columns.Add(DcColBhavCopyData); string StrSqlQuery = ""; string StrSqlQueryFilter = "Where "; RdProgressBar.Minimum = 1; RdProgressBar.Maximum = DvBhavCopyCompany.Count; RdProgressBar.Value1 = 1; RdProgressBar.Text = "Filling Company Details"; DataRow _DataRowBhavCopy; for (int i = 0; i < DvBhavCopyCompany.Count; i++) { _DataRowBhavCopy = DtBhavCopyData.NewRow(); _DataRowBhavCopy["cSYMBOL"] = DvBhavCopyCompany[i]["cSYMBOL"]; _DataRowBhavCopy["cSERIES"] = DvBhavCopyCompany[i]["cSERIES"]; DtBhavCopyData.Rows.Add(_DataRowBhavCopy); RdProgressBar.Value1 = RdProgressBar.Value1 < DvBhavCopyCompany.Count ? RdProgressBar.Value1 + 1 : DvBhavCopyCompany.Count; RdProgressBar.Text = " Filling Company Details - " + ((RdProgressBar.Value1 * 100) / DvBhavCopyCompany.Count).ToString() + " %"; RdProgressBar.Update(); RdProgressBar.Refresh(); Application.DoEvents(); } RdProgressBar.Value1 = 1; RdProgressBar.Text = "Filling Company Completed"; string StrCompnay = ""; StrCompnay = string.Join("','", DvBhavCopyCompany.ToTable().AsEnumerable().Select(x => x.Field <string>("cSYMBOL")).ToArray());//+ "_" + x.Field<string>("cSERIES") StrSqlQueryFilter = StrSqlQueryFilter + " Convert(DateTime,dTIMESTAMP,101) >=Convert(DateTime,'" + _DtpFromDate.ToString("yyyy/MM/dd") + "',101) AND Convert(DateTime,dTIMESTAMP,101) <=Convert(DateTime,'" + _DtpToDate.ToString("yyyy/MM/dd") + "',101)"; StrSqlQuery = @"select * from [A3DBhavCopyData].[dbo].[BhavCopyDetails]"; StrSqlQuery = StrSqlQuery + Environment.NewLine + StrSqlQueryFilter + Environment.NewLine + " AND cSYMBOL IN ('" + StrCompnay + "')";//+ '_' + cSERIES using (var DbContext = new A3DBhavCopyDataContext()) { var vAtmUpTime = DbContext.Database.SqlQuery <MClsBhavCopyDetails>(StrSqlQuery).ToList(); DtBhavCopySqlData = ClsUtility._IClsUtility.NewTable(string.Concat("BhavCopyData"), vAtmUpTime); } double _IDaysInMonth = (_DtpToDate - _DtpFromDate).TotalDays; ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); GridViewColumnGroup gridViewColumnGroup; gridViewColumnGroup = new GridViewColumnGroup("Company Details"); gridViewColumnGroup.Rows.Add(new GridViewColumnGroupRow()); gridViewColumnGroup.Rows[0].ColumnNames.Add("cSYMBOL"); gridViewColumnGroup.Rows[0].ColumnNames.Add("cSERIES"); gridViewColumnGroup.Rows[0].ColumnNames.Add("cSummary"); gridViewColumnGroup.IsPinned = true; gridViewColumnGroup.PinPosition = PinnedColumnPosition.Left; view.ColumnGroups.Add(gridViewColumnGroup); for (int i = 0; i <= _IDaysInMonth; i++) { DateTime _DtMonthDate = _DtpFromDate.AddDays(Convert.ToDouble(i)); if (_DtMonthDate.DayOfWeek.ToString() == "Sunday" || _DtMonthDate.DayOfWeek.ToString() == "Saturday") { continue; } DcColBhavCopyData = new DataColumn("cPREVCLOSE_" + _DtMonthDate.ToString("dd-MMM-yyyy"), typeof(double)) { DefaultValue = 0, Caption = "Previous Day Closing Value" }; DtBhavCopyData.Columns.Add(DcColBhavCopyData); DcColBhavCopyData = new DataColumn("cCLOSE_" + _DtMonthDate.ToString("dd-MMM-yyyy"), typeof(double)) { DefaultValue = 0, Caption = "Today Closing Value" }; DtBhavCopyData.Columns.Add(DcColBhavCopyData); if (EnuReportType == enumReportType.SortByQty) { DcColBhavCopyData = new DataColumn("cTOTTRDQTY_" + _DtMonthDate.ToString("dd-MMM-yyyy"), typeof(double)) { DefaultValue = 0, Caption = "Total Trading Quantity" }; DtBhavCopyData.Columns.Add(DcColBhavCopyData); } else { DcColBhavCopyData = new DataColumn("cTOTTRDVAL_" + _DtMonthDate.ToString("dd-MMM-yyyy"), typeof(double)) { DefaultValue = 0, Caption = "Total Trading Value" }; DtBhavCopyData.Columns.Add(DcColBhavCopyData); } DcColBhavCopyData = new DataColumn("cPriceChange_" + _DtMonthDate.ToString("dd-MMM-yyyy"), typeof(double)) { DefaultValue = 0, Caption = "Price Change" }; DtBhavCopyData.Columns.Add(DcColBhavCopyData); gridViewColumnGroup = new GridViewColumnGroup(_DtMonthDate.ToString("dd-MMM-yyyy")); gridViewColumnGroup.Rows.Add(new GridViewColumnGroupRow()); gridViewColumnGroup.Rows[0].ColumnNames.Add("cPREVCLOSE_" + _DtMonthDate.ToString("dd-MMM-yyyy")); gridViewColumnGroup.Rows[0].ColumnNames.Add("cCLOSE_" + _DtMonthDate.ToString("dd-MMM-yyyy")); if (EnuReportType == enumReportType.SortByQty) { gridViewColumnGroup.Rows[0].ColumnNames.Add("cTOTTRDQTY_" + _DtMonthDate.ToString("dd-MMM-yyyy")); } else { gridViewColumnGroup.Rows[0].ColumnNames.Add("cTOTTRDVAL_" + _DtMonthDate.ToString("dd-MMM-yyyy")); } gridViewColumnGroup.Rows[0].ColumnNames.Add("cPriceChange_" + _DtMonthDate.ToString("dd-MMM-yyyy")); view.ColumnGroups.Add(gridViewColumnGroup); } RdGrdReportResult.ViewDefinition = view; RdProgressBar.Minimum = 1; RdProgressBar.Maximum = DtBhavCopyData.DefaultView.Count; RdProgressBar.Value1 = 1; RdProgressBar.Text = "Filling Bhav-Copy Data"; double dblSummary = 0; foreach (DataRowView DrvCompany in DtBhavCopyData.DefaultView) { dblSummary = 0; RdProgressBar.Text = " Filling < " + DrvCompany["cSYMBOL"] + " > Company Data - " + ((RdProgressBar.Value1 * 100) / DtBhavCopyData.DefaultView.Count).ToString() + " %"; RdProgressBar.Update(); RdProgressBar.Refresh(); Application.DoEvents(); DtBhavCopySqlData.DefaultView.RowFilter = "cSYMBOL='" + DrvCompany["cSYMBOL"] + "' AND cSERIES='" + DrvCompany["cSERIES"] + "' "; foreach (DataRowView DrvBhavCopySqlData in DtBhavCopySqlData.DefaultView) { //DrvCompany["cPREVCLOSE"] = DrvBhavCopySqlData["cPREVCLOSE"]; //DrvCompany["cCLOSE"] = DrvBhavCopySqlData["cCLOSE"]; //DrvCompany["cTOTTRDVAL"] = DrvBhavCopySqlData["cTOTTRDVAL"]; if (DtBhavCopyData.Columns.Contains("cPREVCLOSE_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy"))) { DrvCompany["cPREVCLOSE_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")] = DrvBhavCopySqlData["cPREVCLOSE"]; } if (DtBhavCopyData.Columns.Contains("cCLOSE_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy"))) { DrvCompany["cCLOSE_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")] = DrvBhavCopySqlData["cCLOSE"]; } if (EnuReportType == enumReportType.SortByQty) { if (DtBhavCopyData.Columns.Contains("cTOTTRDQTY_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy"))) { DrvCompany["cTOTTRDQTY_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")] = DrvBhavCopySqlData["cTOTTRDQTY"]; } } else { if (DtBhavCopyData.Columns.Contains("cTOTTRDVAL_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy"))) { DrvCompany["cTOTTRDVAL_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")] = DrvBhavCopySqlData["cTOTTRDVAL"]; } } if (DtBhavCopyData.Columns.Contains("cPriceChange_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy"))) { DrvCompany["cPriceChange_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")] = Math.Round(Convert.ToDouble(DrvBhavCopySqlData["cCLOSE"]) - Convert.ToDouble(DrvBhavCopySqlData["cPREVCLOSE"]), 2); dblSummary = dblSummary + Convert.ToDouble(DrvCompany["cPriceChange_" + Convert.ToDateTime(DrvBhavCopySqlData["dTIMESTAMP"]).ToString("dd-MMM-yyyy")]); } } DrvCompany["cSummary"] = dblSummary; DtBhavCopySqlData.DefaultView.RowFilter = ""; RdProgressBar.Value1 = RdProgressBar.Value1 < DvBhavCopyCompany.Count ? RdProgressBar.Value1 + 1 : DvBhavCopyCompany.Count; } RdGrdReportResult.DataSource = DtBhavCopyData; ConditionalFormattingObject _ConditionalFormattingObject = new ConditionalFormattingObject("MyCondition", ConditionTypes.Less, "0", "", false); //obj.CellBackColor = Color.SkyBlue; _ConditionalFormattingObject.CellForeColor = Color.Red; //obj.TextAlignment = ContentAlignment.MiddleRight; RdGrdReportResult.Columns["cSYMBOL"].PinPosition = PinnedColumnPosition.Left; RdGrdReportResult.Columns["cSYMBOL"].IsPinned = true; RdGrdReportResult.Columns["cSERIES"].PinPosition = PinnedColumnPosition.Left; RdGrdReportResult.Columns["cSERIES"].IsPinned = true; RdGrdReportResult.Columns["cSummary"].PinPosition = PinnedColumnPosition.Left; RdGrdReportResult.Columns["cSummary"].IsPinned = true; RdGrdReportResult.Columns["cSummary"].ConditionalFormattingObjectList.Add(_ConditionalFormattingObject); foreach (var gridViewDataColumn in RdGrdReportResult.Columns) { if (gridViewDataColumn.Name.Contains("cPriceChange_")) { gridViewDataColumn.ConditionalFormattingObjectList.Add(_ConditionalFormattingObject); } } RdProgressBar.Value1 = 1; RdProgressBar.Text = "Done"; ClsMessage._IClsMessage.showMessage("Done!!"); } catch (Exception ex) { ClsMessage._IClsMessage.ProjectExceptionMessage(ex); } }
public void RefreshGrid() { if (totalPage != 0) showShedule = showShedule.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList<VisitaJayaPerkasa.Entities.Schedule>(); else showShedule = null; radToolStripLabelIndexing.Text = currentPage + " / " + totalPage; ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("")); view.ColumnGroups.Add(new GridViewColumnGroup("Ro Begin")); view.ColumnGroups.Add(new GridViewColumnGroup("RO End")); view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[0].Rows[0].Columns.Add(ScheduleGridView.Columns["ID"]); view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[1].Rows[0].Columns.Add(ScheduleGridView.Columns["tujuan"]); view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[2].Rows[0].Columns.Add(ScheduleGridView.Columns["vesselID"]); view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[3].Rows[0].Columns.Add(ScheduleGridView.Columns["berangkatTujuan"]); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].Columns.Add(ScheduleGridView.Columns["namaKapal"]); view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[5].Rows[0].Columns.Add(ScheduleGridView.Columns["voy"]); view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[6].Rows[0].Columns.Add(ScheduleGridView.Columns["tglclosing"]); view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[7].Rows[0].Columns.Add(ScheduleGridView.Columns["etd"]); view.ColumnGroups[8].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[8].Rows[0].Columns.Add(ScheduleGridView.Columns["td"]); view.ColumnGroups[9].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[9].Rows[0].Columns.Add(ScheduleGridView.Columns["eta"]); view.ColumnGroups[10].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[10].Rows[0].Columns.Add(ScheduleGridView.Columns["ta"]); view.ColumnGroups[11].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[11].Rows[0].Columns.Add(ScheduleGridView.Columns["Keterangan"]); view.ColumnGroups[12].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[12].Rows[0].Columns.Add(ScheduleGridView.Columns["unLoading"]); view.ColumnGroups[13].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[13].Rows[0].Columns.Add(ScheduleGridView.Columns["ro_begin_20"]); view.ColumnGroups[13].Rows[0].Columns.Add(ScheduleGridView.Columns["ro_begin_40"]); view.ColumnGroups[14].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[14].Rows[0].Columns.Add(ScheduleGridView.Columns["ro_end_20"]); view.ColumnGroups[14].Rows[0].Columns.Add(ScheduleGridView.Columns["ro_end_40"]); ScheduleGridView.DataSource = showShedule; this.ScheduleGridView.ViewDefinition = view; Constant.VisitaJayaPerkasaApplication.pBarForm.Invoke ( (MethodInvoker)delegate() { Constant.VisitaJayaPerkasaApplication.pBarForm.Close(); Constant.VisitaJayaPerkasaApplication.pBarForm.Dispose(); Constant.VisitaJayaPerkasaApplication.pBarForm = null; } ); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); DataTable table = new DataTable(); table.Columns.Add("ID", typeof(int)); table.Columns.Add("Task", typeof(string)); table.Columns.Add("Project", typeof(string)); table.Columns.Add("StartCell", typeof(int)); table.Columns.Add("EndCell", typeof(int)); table.Columns.Add("Color", typeof(int)); AddRow(table, 1, "Task 1", "Project 1"); AddRow(table, 2, "Task 2", "Project 1"); AddRow(table, 3, "Task 3", "Project 1"); AddRow(table, 4, "Task 4", "Project 1"); AddRow(table, 5, "Task 5", "Project 1"); AddRow(table, 6, "Task 1", "Project 2"); AddRow(table, 7, "Task 2", "Project 2"); AddRow(table, 8, "Task 3", "Project 2"); this.radGridView1.CreateRowInfo += new GridViewCreateRowInfoEventHandler(radGridView1_CreateRowInfo); this.radGridView1.RowPaint += new GridViewRowPaintEventHandler(radGridView1_RowPaint); this.radGridView1.EnableCustomDrawing = true; this.radGridView1.ReadOnly = true; this.radGridView1.AutoExpandGroups = true; this.radGridView1.DataSource = table; this.radGridView1.GroupDescriptors.Add(new Telerik.WinControls.Data.GroupDescriptor("Project")); string[] months = new string[] { "Jan", "Feb", "Mar" }; for (int i = 0; i < months.Length; i++) { for (int j = 1; j <= 4; j++) { GridViewTextBoxColumn column = new GridViewTextBoxColumn(months[i] + "Week" + j); column.HeaderText = "Week " + j.ToString(); this.radGridView1.Columns.Add(column); } } ColumnGroupsViewDefinition def = new ColumnGroupsViewDefinition(); def.ColumnGroups.Add(new GridViewColumnGroup("Event")); def.ColumnGroups[0].ShowHeader = false; def.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); def.ColumnGroups[0].Rows[0].Columns.Add(this.radGridView1.Columns[0]); def.ColumnGroups[0].Rows[0].Columns.Add(this.radGridView1.Columns[1]); for (int i = 0; i < months.Length; i++) { def.ColumnGroups.Add(new GridViewColumnGroup(months[i] + "'11")); def.ColumnGroups[1 + i].Rows.Add(new GridViewColumnGroupRow()); for (int j = 1; j <= 4; j++) { def.ColumnGroups[1 + i].Rows[0].Columns.Add(this.radGridView1.Columns[months[i] + "Week" + j]); } } this.radGridView1.ViewDefinition = def; }
private ColumnGroupsViewDefinition SetColumnGroupsView(RadGridView dgv) { ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition(); view.ColumnGroups.Add(new GridViewColumnGroup("Num")); view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[0].Rows[0].ColumnNames.Add("Номер модуля"); view.ColumnGroups[0].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("F")); view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[1].Rows[0].ColumnNames.Add("Форма модуля"); view.ColumnGroups[1].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("I")); view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[2].Rows[0].ColumnNames.Add("Icon"); view.ColumnGroups[2].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("Размеры")); view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Высота модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Ширина модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("Глубина модуля (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("A размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("B размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("C размер (мм)"); view.ColumnGroups[3].Rows[0].ColumnNames.Add("D размер (мм)"); view.ColumnGroups.Add(new GridViewColumnGroup("zertg")); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].ColumnNames.Add("Сборка модуля2"); view.ColumnGroups[4].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("z")); view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[4].Rows[0].ColumnNames.Add("Задняя стенка2"); view.ColumnGroups[4].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("ppse")); view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[5].Rows[0].ColumnNames.Add("Полка по ширине секции (шт)2"); view.ColumnGroups[5].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("ppmin")); view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[6].Rows[0].ColumnNames.Add("Полка - 2мм (шт)2"); view.ColumnGroups[6].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("ppraz")); view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[7].Rows[0].ColumnNames.Add("Полка разделительная (шт)"); view.ColumnGroups[7].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("ppraz")); view.ColumnGroups[8].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[8].Rows[0].ColumnNames.Add("Полка стеклянная (шт)"); view.ColumnGroups[8].ShowHeader = false; view.ColumnGroups.Add(new GridViewColumnGroup("Фасад")); view.ColumnGroups[9].Rows.Add(new GridViewColumnGroupRow()); view.ColumnGroups[9].Rows[0].ColumnNames.Add("№ схемы фасада"); view.ColumnGroups[9].Rows[0].ColumnNames.Add("Тип фасада2"); view.ColumnGroups[9].Rows[0].ColumnNames.Add("Режим расчёта2"); view.ColumnGroups[9].Rows[0].ColumnNames.Add("Горизонтальный размер"); view.ColumnGroups[9].Rows[0].ColumnNames.Add("Вертикальный размер"); view.ColumnGroups[9].Rows[0].ColumnNames.Add("Материал фасада2"); return(view); }