public static void ImprimirGrillaReporte(Cedeira.UI.frmBase Formulario, Janus.Windows.GridEX.GridEX Grilla, string TituloAplicacion, bool Apaisada, Janus.Windows.GridEX.FitColumnsMode ModoAjusteColumnas, DateTime Fecha) { try { Formulario.Cursor = System.Windows.Forms.Cursors.WaitCursor; Janus.Windows.GridEX.GridEXPrintDocument gridEXPrintDocument=new Janus.Windows.GridEX.GridEXPrintDocument(); foreach (System.Drawing.Printing.PaperSize ps in gridEXPrintDocument.PrinterSettings.PaperSizes) { if (ps.Kind == System.Drawing.Printing.PaperKind.Letter) { gridEXPrintDocument.DefaultPageSettings.PaperSize=ps; break; } } gridEXPrintDocument.ExpandFarColumn=false; gridEXPrintDocument.DefaultPageSettings.Landscape=Apaisada; gridEXPrintDocument.DefaultPageSettings.Margins.Bottom=60; gridEXPrintDocument.DefaultPageSettings.Margins.Top=30; gridEXPrintDocument.DefaultPageSettings.Margins.Left=10; gridEXPrintDocument.DefaultPageSettings.Margins.Right=70; gridEXPrintDocument.HeaderDistance=15; gridEXPrintDocument.FitColumns=ModoAjusteColumnas; gridEXPrintDocument.PageHeaderFormatStyle.FontBold=Janus.Windows.GridEX.TriState.True; gridEXPrintDocument.PageHeaderLeft=TituloAplicacion; gridEXPrintDocument.PageHeaderCenter=Formulario.Titulo; gridEXPrintDocument.PageHeaderRight=Fecha.ToString("d"); gridEXPrintDocument.PrintCollapsedRows=true; gridEXPrintDocument.DocumentName=Formulario.Text; gridEXPrintDocument.GridEX=Grilla; gridEXPrintDocument.PrepareDocument(); gridEXPrintDocument.Print(); } catch (System.Exception ex) { Cedeira.Ex.ExceptionManager.Publish(ex); } finally { Formulario.Cursor=System.Windows.Forms.Cursors.Default; } }
public void ExportDetails(Janus.Windows.GridEX.GridEX Grilla, Cedeira.SV.Export.ExportFormat FormatType, string FileName) { Cedeira.SV.Export export = new Cedeira.SV.Export(); System.Diagnostics.Process loProcess = System.Diagnostics.Process.GetCurrentProcess(); loProcess.MaxWorkingSet = (IntPtr)10000000; loProcess.MinWorkingSet = (IntPtr)5000000; try { DataSet dsExport = Cedeira.SV.Fun.GetDataSetFromJanusGridEx(Grilla, FileName); dsExport.DataSetName = "Export"; dsExport.Tables[0].TableName = "Values"; string[] sHeaders = new string[dsExport.Tables[0].Columns.Count]; string[] sFileds = new string[dsExport.Tables[0].Columns.Count]; for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++) { dsExport.Tables[0].Columns[i].ColumnName = Convert.ToString(i); } for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++) { sHeaders[i] = export.ReemplazarEspaciosyAcentos(dsExport.Tables[0].Columns[i].Caption); dsExport.Tables[0].Columns[i].ColumnName = sHeaders[i]; sFileds[i] = sHeaders[i]; } int columnas = dsExport.Tables[0].Columns.Count; for (int l = 0; l < dsExport.Tables[0].Rows.Count; l++) { for (int i = 0; i < dsExport.Tables[0].Columns.Count; i++) { string aux = export.ReemplazarXPath(Convert.ToString(dsExport.Tables[0].Rows[l].ItemArray[i])); dsExport.Tables[0].Rows[l][i] = aux; dsExport.Tables[0].Rows[l].AcceptChanges(); } if (dsExport.Tables[0].Rows[l][0].ToString() == "") { decimal real = 0; decimal plan = 0; if (dsExport.Tables[0].Rows[l][columnas - 2].ToString().Trim() != "") { real = Convert.ToDecimal(dsExport.Tables[0].Rows[l][columnas - 2].ToString()); } if (dsExport.Tables[0].Rows[l][columnas - 3].ToString().Trim() != "") { plan = Convert.ToDecimal(dsExport.Tables[0].Rows[l][columnas - 3].ToString()); } if (plan != 0) { dsExport.Tables[0].Rows[l][columnas - 1] = Convert.ToString(Math.Round((real / plan - 1) * 100, 2)); dsExport.Tables[0].Rows[l].AcceptChanges(); } } } string dir = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal) + "\\CedForecast\\"; if (!System.IO.Directory.Exists(dir)) { System.IO.Directory.CreateDirectory(dir); } FileName = dir + export.ReemplazarCaracteresMalos(FileName); export.Export_with_XSLT_Windows(dsExport, sHeaders, sFileds, FormatType, FileName); System.Diagnostics.Process.Start(FileName); } catch (Exception Ex) { throw Ex; } }
public static void ImprimirGrilla(Cedeira.UI.frmBase Formulario, Janus.Windows.GridEX.GridEX Grilla, string TituloAplicacion, bool Apaisada) { ImprimirGrilla(Formulario, Grilla, TituloAplicacion, Apaisada, Janus.Windows.GridEX.FitColumnsMode.Zooming); }
public void ExportDetails(Janus.Windows.GridEX.GridEX Grilla, Cedeira.SV.Export.ExportFormat FormatType, string FileName) { Cedeira.SV.Export export = new Cedeira.SV.Export(); System.Diagnostics.Process loProcess = System.Diagnostics.Process.GetCurrentProcess(); loProcess.MaxWorkingSet = (IntPtr)10000000; loProcess.MinWorkingSet = (IntPtr)5000000; try { DataSet dsExport = Cedeira.SV.Fun.GetDataSetFromJanusGridExDS(Grilla, FileName); dsExport.DataSetName = "Export"; for (int t = 0; t < dsExport.Tables.Count; t++) { for (int i = 0; i < dsExport.Tables[t].Columns.Count; i++) { if (dsExport.Tables[t].Columns[i].Caption != "") { dsExport.Tables[t].Columns[i].ColumnName = Convert.ToString(i); } } for (int i = 0; i < dsExport.Tables[t].Columns.Count; i++) { if (dsExport.Tables[t].Columns[i].Caption != "") { dsExport.Tables[t].Columns[i].ColumnName = export.ReemplazarEspaciosyAcentos(dsExport.Tables[t].Columns[i].Caption); } } int columnas = dsExport.Tables[t].Columns.Count; for (int l = 0; l < dsExport.Tables[t].Rows.Count; l++) { for (int i = 0; i < dsExport.Tables[t].Columns.Count; i++) { string aux = export.ReemplazarXPath(Convert.ToString(dsExport.Tables[t].Rows[l].ItemArray[i])); dsExport.Tables[t].Rows[l][i] = aux; dsExport.Tables[t].Rows[l].AcceptChanges(); } } } string dir = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal) + "\\CedForecast\\"; if (!System.IO.Directory.Exists(dir)) { System.IO.Directory.CreateDirectory(dir); } FileName = dir + export.ReemplazarCaracteresMalos(FileName); export.Export_with_XSLT_WindowsDS(dsExport, FormatType, FileName); System.Diagnostics.Process.Start(FileName); } catch (Exception Ex) { throw Ex; } }