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