protected void ibExcel_Click(object sender, ImageClickEventArgs e) { try { if (RadGrid1.Visible == true) { if (RadGrid1.Items.Count > 0) { List <Informe_Produccion_V2> lista = new List <Informe_Produccion_V2>(); for (int i = 0; i < RadGrid1.Items.Count; i++) { Informe_Produccion_V2 p = new Informe_Produccion_V2(); p.Semana = RadGrid1.Items[i]["Semana"].Text; p.Maquina = RadGrid1.Items[i]["Maquina"].Text; p.Giros = RadGrid1.Items[i]["Giros"].Text.Replace(".", ""); p.Entradas = RadGrid1.Items[i]["Entradas"].Text; p.HorasTiraje = RadGrid1.Items[i]["HorasTiraje"].Text; p.HorasImproductivas = RadGrid1.Items[i]["HorasImproductivas"].Text; p.HorasPreparacion = RadGrid1.Items[i]["HorasPreparacion"].Text; p.HorasSinTrabajo = RadGrid1.Items[i]["HorasSinTrabajo"].Text; p.HorasSinPersonal = RadGrid1.Items[i]["HorasSinPersonal"].Text; p.HorasMantencion = RadGrid1.Items[i]["HorasMantencion"].Text; p.HorasPruebaImpresion = RadGrid1.Items[i]["HorasPruebaImpresion"].Text; p.GirosMalosPreparacion = RadGrid1.Items[i]["GirosMalosPreparacion"].Text.Replace(".", ""); p.PliegosMalosPreparacion = RadGrid1.Items[i]["PliegosMalosPreparacion"].Text.Replace(".", ""); p.GirosMalosTiraje = RadGrid1.Items[i]["GirosMalosTiraje"].Text.Replace(".", ""); p.PliegosMalosTiraje = RadGrid1.Items[i]["PliegosMalosTiraje"].Text.Replace(".", ""); p.Buenos = RadGrid1.Items[i]["Buenos"].Text.Replace(".", ""); lista.Add(p); } GridView GridView1 = new GridView(); GridView1.DataSource = lista; GridView1.DataBind(); GridView1.HeaderRow.Cells[0].Text = "Dia"; GridView1.HeaderStyle.BackColor = System.Drawing.Color.Blue; GridView1.HeaderStyle.ForeColor = System.Drawing.Color.White; ExportToExcel("Estadistica_ProduccionDiaria", "", GridView1); } } else { if (RadGrid2.Items.Count > 0) { List <Informe_Produccion_V2> lista = new List <Informe_Produccion_V2>(); for (int i = 0; i < RadGrid2.Items.Count; i++) { Informe_Produccion_V2 p = new Informe_Produccion_V2(); p.Semana = RadGrid2.Items[i]["Semana"].Text; p.Maquina = RadGrid2.Items[i]["Maquina"].Text; p.Entradas = RadGrid2.Items[i]["Entradas"].Text; p.HorasTiraje = RadGrid2.Items[i]["HorasTiraje"].Text; p.HorasImproductivas = RadGrid2.Items[i]["HorasImproductivas"].Text; p.HorasPreparacion = RadGrid2.Items[i]["HorasPreparacion"].Text; p.HorasSinTrabajo = RadGrid2.Items[i]["HorasSinTrabajo"].Text; p.HorasSinPersonal = RadGrid2.Items[i]["HorasSinPersonal"].Text; p.HorasMantencion = RadGrid2.Items[i]["HorasMantencion"].Text; p.HorasPruebaImpresion = RadGrid2.Items[i]["HorasPruebaImpresion"].Text; p.PliegosMalosPreparacion = RadGrid2.Items[i]["PliegosMalosPreparacion"].Text.Replace(".", ""); p.GirosMalosPreparacion = p.PliegosMalosPreparacion; p.PliegosMalosTiraje = RadGrid2.Items[i]["PliegosMalosTiraje"].Text.Replace(".", ""); p.GirosMalosTiraje = p.PliegosMalosTiraje; p.Buenos = RadGrid2.Items[i]["Buenos"].Text.Replace(".", ""); p.Giros = p.Buenos; lista.Add(p); } GridView GridView1 = new GridView(); GridView1.DataSource = lista; GridView1.DataBind(); GridView1.HeaderRow.Cells[0].Text = "Dia"; GridView1.HeaderStyle.BackColor = System.Drawing.Color.Blue; GridView1.HeaderStyle.ForeColor = System.Drawing.Color.White; ExportToExcel("Estadistica_ProduccionDiaria", "", GridView1); } } } catch (Exception ex) { string popupScript = "<script language='JavaScript'> alert('Ha Ocurrido un error al exportar a Excel\\n Error:" + ex.Message + "'); </script>"; Page.RegisterStartupScript("PopupScript", popupScript); } }
public List <Informe_Produccion_V2> EstadisticaProduccion_V2(string Maquina, DateTime fechainicio, DateTime fechatermino, int procedimiento) { Conexion con = new Conexion(); List <Informe_Produccion_V2> lista = new List <Informe_Produccion_V2>(); SqlCommand cmd = con.AbrirConexionIntranet(); if (cmd != null) { cmd.CommandText = "[Produccion_EstadisticaProduccion_V2]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MAQUINA", Maquina); cmd.Parameters.AddWithValue("@FECHAINICIO", fechainicio); cmd.Parameters.AddWithValue("@FECHATERMINO", fechatermino); cmd.Parameters.AddWithValue("@PROCEDIMIENTO", procedimiento); cmd.CommandTimeout = 3000000; SqlDataReader reader = cmd.ExecuteReader(); string ceros = "00"; while (reader.Read()) { Informe_Produccion_V2 p = new Informe_Produccion_V2(); p.Semana = reader["semana"].ToString(); p.Maquina = reader["Maquina"].ToString().Replace("C150", "").Replace("M2016", "WEB 2"); p.Giros = Convert.ToInt32(reader["Giros"].ToString()).ToString("N0").Replace(",", "."); p.Entradas = reader["Entradas"].ToString(); TimeSpan t1 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasTiraje"].ToString())); int Dias1 = t1.Days * 24; p.HorasTiraje = (t1.Hours + Dias1).ToString() + ":" + ceros.Substring(0, ceros.Length - t1.Minutes.ToString().Length) + t1.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t1.Seconds.ToString().Length) + t1.Seconds.ToString(); TimeSpan t2 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasImproductivas"].ToString())); int Dias2 = t2.Days * 24; p.HorasImproductivas = (t2.Hours + Dias2).ToString() + ":" + ceros.Substring(0, ceros.Length - t2.Minutes.ToString().Length) + t2.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t2.Seconds.ToString().Length) + t2.Seconds.ToString(); TimeSpan t3 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasPreparacion"].ToString())); int Dias3 = t3.Days * 24; p.HorasPreparacion = (t3.Hours + Dias3).ToString() + ":" + ceros.Substring(0, ceros.Length - t3.Minutes.ToString().Length) + t3.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t3.Seconds.ToString().Length) + t3.Seconds.ToString(); TimeSpan t4 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasSinTrabajo"].ToString())); int Dias4 = t4.Days * 24; p.HorasSinTrabajo = (t4.Hours + Dias4).ToString() + ":" + ceros.Substring(0, ceros.Length - t4.Minutes.ToString().Length) + t4.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t4.Seconds.ToString().Length) + t4.Seconds.ToString(); TimeSpan t5 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasSinPersonal"].ToString())); int Dias5 = t5.Days * 24; p.HorasSinPersonal = (t5.Hours + Dias5).ToString() + ":" + ceros.Substring(0, ceros.Length - t5.Minutes.ToString().Length) + t5.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t5.Seconds.ToString().Length) + t5.Seconds.ToString(); TimeSpan t6 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasMantencion"].ToString())); int Dias6 = t6.Days * 24; p.HorasMantencion = (t6.Hours + Dias6).ToString() + ":" + ceros.Substring(0, ceros.Length - t6.Minutes.ToString().Length) + t6.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t6.Seconds.ToString().Length) + t6.Seconds.ToString(); TimeSpan t7 = TimeSpan.FromSeconds(Convert.ToDouble(reader["HorasPruebaImpresion"].ToString())); int Dias7 = t7.Days * 24; p.HorasPruebaImpresion = (t7.Hours + Dias7).ToString() + ":" + ceros.Substring(0, ceros.Length - t7.Minutes.ToString().Length) + t7.Minutes.ToString() + ":" + ceros.Substring(0, ceros.Length - t7.Seconds.ToString().Length) + t7.Seconds.ToString(); p.GirosMalosPreparacion = Convert.ToInt32(reader["GirosMalosPreparacion"].ToString()).ToString("N0").Replace(",", "."); p.PliegosMalosPreparacion = Convert.ToInt32(reader["PliegosMalosPreparacion"].ToString()).ToString("N0").Replace(",", "."); p.GirosMalosTiraje = Convert.ToInt32(reader["GirosMalosTiraje"].ToString()).ToString("N0").Replace(",", "."); p.PliegosMalosTiraje = Convert.ToInt32(reader["PliegosMalosTiraje"].ToString()).ToString("N0").Replace(",", "."); p.Buenos = Convert.ToInt32(reader["Buenos"].ToString()).ToString("N0").Replace(",", "."); lista.Add(p); } } con.CerrarConexion(); return(lista); }