public static void ImprimirVentasPorMozo(DateTime desde, DateTime hasta) { List <string[]> lista = new List <string[]>(); lista = Persona_datos.VentasPorMozo(desde, hasta); string SheetsName = "Hoja1"; ExcelManagement em = ExcelManagement.GetInstance(); em.Open(Application.StartupPath + "\\VentasPorMozo.xlsx"); int c = 2; foreach (string[] array in lista) { em.WriteCell(SheetsName, 1, 1, desde.Date); em.WriteCell(SheetsName, 1, 2, hasta.Date); em.WriteCell(SheetsName, c, 1, Convert.ToInt32(array[0])); em.WriteCell(SheetsName, c, 2, array[1]); em.WriteCell(SheetsName, c, 3, Convert.ToDouble(array[2])); c++; } string path = string.Concat(Application.StartupPath, "\\VentasPorMozo", DateTime.Today.Day.ToString(), DateTime.Today.Month.ToString(), DateTime.Today.Year.ToString(), ".xlsx"); em.SaveAsNew(path); Process.Start(path); }
public static void ImprimirVentasDiarias(DateTime desde, DateTime hasta) { List <string[]> lista = new List <string[]>(); lista = Comanda_datos.VentasPorDia(desde, hasta); string SheetsName = "Hoja1"; ExcelManagement em = ExcelManagement.GetInstance(); em.Open(Application.StartupPath + "\\VentasDiarias.xlsx"); int c = 2; foreach (string[] array in lista) { em.WriteCell(SheetsName, 1, 1, desde.Date); em.WriteCell(SheetsName, 1, 2, hasta.Date); em.WriteCell(SheetsName, c, 1, array[0]); em.WriteCell(SheetsName, c, 2, Convert.ToDouble(array[1])); c++; } string path = string.Concat(Application.StartupPath, "\\VentasDiarias", DateTime.Today.Day.ToString(), DateTime.Today.Month.ToString(), DateTime.Today.Year.ToString(), ".xlsx"); em.SaveAsNew(path); //ProcessStartInfo startInfo = new ProcessStartInfo(); //startInfo.FileName = "EXCEL.EXE"; //startInfo.Arguments = path; //Process.Start(startInfo); System.Diagnostics.Process.Start(path); }
public static void ImprimirPreciosPorCategoria() { List <string[]> lista = new List <string[]>(); lista = Producto_datos.PreciosPorCategoria(); string SheetsName = "Hoja1"; ExcelManagement em = ExcelManagement.GetInstance(); em.Open(Application.StartupPath + "\\PreciosPorCategoria.xlsx"); int c = 2; foreach (string[] array in lista) { em.WriteCell(SheetsName, c, 1, array[0]); em.WriteCell(SheetsName, c, 2, Convert.ToInt32(array[1])); em.WriteCell(SheetsName, c, 3, array[2]); em.WriteCell(SheetsName, c, 4, Convert.ToDouble(array[3])); c++; } string path = string.Concat(Application.StartupPath, "\\PreciosPorCategoria", DateTime.Today.Day.ToString(), DateTime.Today.Month.ToString(), DateTime.Today.Year.ToString(), ".xlsx"); em.SaveAsNew(path); //ProcessStartInfo startInfo = new ProcessStartInfo(); //startInfo.FileName = "EXCEL.EXE"; //startInfo.Arguments = path; //Process.Start(startInfo); System.Diagnostics.Process.Start(path); }
/// <summary> /// Obtiene una instancia del manejador de Excel /// </summary> /// <returns></returns> public static ExcelManagement GetInstance() { if (excelManagement == null) { excelManagement = new ExcelManagement(); } return(excelManagement); }
public static void ImprimirMateriaPrimaUtilizada(DateTime desde, DateTime hasta) { List <string[]> listaProdConsCom = new List <string[]>(); List <string[]> listaConsComp = new List <string[]>(); listaProdConsCom = Producto_datos.ProductosConsumidosComanda(desde, hasta); listaConsComp = Producto_datos.MPConsumidaPorCompuestos(desde, hasta); string SheetsName = "Hoja1"; ExcelManagement em = ExcelManagement.GetInstance(); em.Open(Application.StartupPath + "\\MateriaPrimaUtilizada.xlsx"); int c = 2; foreach (string[] array in listaProdConsCom) { em.WriteCell(SheetsName, 1, 1, desde.Date); em.WriteCell(SheetsName, 1, 2, hasta.Date); em.WriteCell(SheetsName, c, 1, array[0]); em.WriteCell(SheetsName, c, 2, Convert.ToInt32(array[1])); em.WriteCell(SheetsName, c, 3, array[2]); em.WriteCell(SheetsName, c, 4, Convert.ToDouble(array[3])); c++; } c = 2; foreach (string[] array in listaConsComp) { em.WriteCell(SheetsName, c, 6, Convert.ToInt32(array[0])); em.WriteCell(SheetsName, c, 7, array[1]); em.WriteCell(SheetsName, c, 8, Convert.ToDouble(array[2])); em.WriteCell(SheetsName, c, 9, array[3]); c++; } string path = string.Concat(Application.StartupPath, "\\MateriaPrimaUtilizada", DateTime.Today.Day.ToString(), DateTime.Today.Month.ToString(), DateTime.Today.Year.ToString(), ".xlsx"); em.SaveAsNew(path); //ProcessStartInfo startInfo = new ProcessStartInfo(); //startInfo.FileName = "EXCEL.EXE"; //startInfo.Arguments = path; //Process.Start(startInfo); System.Diagnostics.Process.Start(path); }