private void tlbMenu_PrintClick() { try { Cursor = Cursors.WaitCursor; List <ReporteProgramProductionBE> lstReporte = null; lstReporte = new ReporteProgramProductionBL().Listado(int.Parse(gvProgramProduction.GetFocusedRowCellValue("IdProgramProduction").ToString())); if (lstReporte != null) { if (lstReporte.Count > 0) { RptVistaReportes objRptProgramProduction = new RptVistaReportes(); objRptProgramProduction.VerRptProgramProduction(lstReporte); objRptProgramProduction.ShowDialog(); } else { XtraMessageBox.Show("No hay información para el periodo seleccionado", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } Cursor = Cursors.Default; } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnInforme_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; List <ReporteProgramProductionBE> lstReporte = null; if (chkClient.Checked && chkVendor.Checked) { lstReporte = new ReporteProgramProductionBL().ListadoFecha(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue), Convert.ToInt32(cboVendor.EditValue), Convert.ToDateTime(deDateFrom.DateTime.ToShortDateString()), Convert.ToDateTime(deDateTo.DateTime.ToShortDateString())); if (lstReporte != null) { if (lstReporte.Count > 0) { RptVistaReportes objRptEpp = new RptVistaReportes(); objRptEpp.VerRptProgramProductionDate(lstReporte, deDateFrom.DateTime.ToShortDateString(), deDateTo.DateTime.ToShortDateString()); objRptEpp.ShowDialog(); } else { XtraMessageBox.Show("No hay información para el periodo seleccionado", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } Cursor = Cursors.Default; return; } if (chkClient.Checked) { lstReporte = new ReporteProgramProductionBL().ListadoFecha(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue), 0, Convert.ToDateTime(deDateFrom.DateTime.ToShortDateString()), Convert.ToDateTime(deDateTo.DateTime.ToShortDateString())); if (lstReporte != null) { if (lstReporte.Count > 0) { RptVistaReportes objRptEpp = new RptVistaReportes(); objRptEpp.VerRptProgramProductionDate(lstReporte, deDateFrom.DateTime.ToShortDateString(), deDateTo.DateTime.ToShortDateString()); objRptEpp.ShowDialog(); } else { XtraMessageBox.Show("No hay información para el periodo seleccionado", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } Cursor = Cursors.Default; return; } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void ExportarExcel(string filename) { Excel._Application xlApp; Excel._Workbook xlLibro; Excel._Worksheet xlHoja; Excel.Sheets xlHojas; xlApp = new Excel.Application(); filename = Path.Combine(Directory.GetCurrentDirectory(), "Excel\\ProductionProgramClient.xlsx"); xlLibro = xlApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); xlHojas = xlLibro.Sheets; xlHoja = (Excel._Worksheet)xlHojas[1]; Cursor.Current = Cursors.WaitCursor; try { int Row = 6; int Secuencia = 1; List <ReporteProgramProductionBE> lstReporteProgramProduction = null; lstReporteProgramProduction = new ReporteProgramProductionBL().ListadoClient(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue), Convert.ToInt32(txtPeriodo.EditValue)); if (lstReporteProgramProduction.Count > 0) { string strTitulo = ""; strTitulo = "SUMMARY PROG PROD " + cboClient.Text.ToString() + " " + txtPeriodo.Text.ToString(); xlHoja.Cells[2, 1] = strTitulo; decimal decComision = 0; ClientBE objE_Client = null; objE_Client = new ClientBL().Selecciona(Convert.ToInt32(cboClient.EditValue)); if (objE_Client != null) { decComision = objE_Client.PercentComision1; } xlHoja.Shapes.AddPicture(Path.Combine(Directory.GetCurrentDirectory(), "Logo.jpg"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 1, 1, 100, 60); foreach (var item in lstReporteProgramProduction) { xlHoja.Cells[Row, 2] = item.TotalUnits; xlHoja.Cells[Row, 3] = item.TotalFob; xlHoja.Cells[Row, 4] = decComision; Row = Row + 1; Secuencia = Secuencia + 1; } } xlLibro.SaveAs("C:\\Excel\\ProductionProgramClient.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); xlLibro.Close(true, Missing.Value, Missing.Value); xlApp.Quit(); Cursor.Current = Cursors.Default; BSUtils.OpenExcel("C:\\Excel\\ProductionProgramClient.xlsx"); //XtraMessageBox.Show("It was imported correctly \n The file was generated C:\\Excel\\Classification.xlsx", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { xlLibro.Close(false, Missing.Value, Missing.Value); xlApp.Quit(); Cursor.Current = Cursors.Default; MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }