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);
}
