private void Exportar()
 {
     try
     {
         List <String> Titulos = new List <String>();
         Titulos.Add("Reporte");
         Int32 _fila = 2;
         Infrastructure.WinForms.Controls.ExcelAportes _xls = new Infrastructure.WinForms.Controls.ExcelAportes(1, Titulos, "");
         Object[]  _cabeceras = new Object[1];
         DataTable _dt        = _xls.RadGridViewToDataTable(grdItems, ref _cabeceras, grdItems.FilterDescriptors.Count > 0);
         /*****************************************/
         if (_dt.Columns["Print"] != null)
         {
             _dt.Columns.Remove("Print");
         }
         _cabeceras = new Object[_dt.Columns.Count];
         for (int i = 0; i < _dt.Columns.Count; i++)
         {
             _cabeceras[i] = _dt.Columns[i].Caption;
         }
         /*******************************************/
         if (_dt.Rows.Count > 0)
         {
             DateTime      thisDay           = DateTime.Today;
             List <String> _listTituloFiltro = new List <String>();
             _listTituloFiltro.Add("GENERADO : " + thisDay.ToString("D"));
             _xls.InsertarTitulos(Presenter.Title, 1, ref _fila, 1, _listTituloFiltro, _cabeceras.Length);
             _xls.addDataArray(1, _cabeceras, 1, _fila + 2, true, true);
             _xls.addDataList(1, _dt, 1, _fila + 3, true, true);
         }
     }
     catch (Exception ex)
     { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al exportar.", ex); }
 }
Пример #2
0
 private void Exportar()
 {
     try
     {
         List <String> Titulos = new List <String>();
         Titulos.Add("Reporte");
         Int32 _fila = 2;
         Infrastructure.WinForms.Controls.ExcelAportes _xls = new Infrastructure.WinForms.Controls.ExcelAportes(1, Titulos, "");
         Object[]  _cabeceras = new Object[1];
         DataTable _dt        = _xls.RadGridViewToDataTable(grdItems, ref _cabeceras, grdItems.FilterDescriptors.Count > 0);
         if (_dt.Rows.Count > 0)
         {
             List <String> _listTituloFiltro = new List <String>();
             _listTituloFiltro.Add("");
             _xls.InsertarTitulos(Presenter.Title, 1, ref _fila, 1, _listTituloFiltro, _cabeceras.Length);
             _xls.addDataArray(1, _cabeceras, 1, _fila + 2, true, true);
             _xls.addDataList(1, _dt, 1, _fila + 3, true, true);
         }
     }
     catch (Exception ex)
     { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, "Ha ocurrido un error al exportar.", ex); }
 }