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