public void cargardatos(string FechaRangoMin, string FechaRangoMax, Bobina bobina)
{
Bobina_Controller controlbob = new Bobina_Controller();
RadGrid1.DataSource = controlbob.Listar_Informe_fallaCorte(bobina, FechaRangoMin, FechaRangoMax);
RadGrid1.DataBind();
}
protected void ibExcel_Click(object sender, ImageClickEventArgs e)
{
Bobina_Controller controlbob = new Bobina_Controller();
Bobina bob = new Bobina();
string FechaInicio = "";
string FechaTermino = "";
if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
string[] str = txtFechaInicio.Text.Split('-');
FechaInicio = str[2] + "-" + str[1] + "-" + str[0];
string[] str2 = txtFechaTermino.Text.Split('-');
FechaTermino = str2[2] + "-" + str2[1] + "-" + str2[0];
}
bob.NumeroOp = txtNumeroOT.Text.ToString().Trim();
bob.Codigo = txtCodigoBob.Text.ToString().Trim();
if (ddlCategoria.SelectedItem.Text != "Todas")
{
bob.Marca = ddlCategoria.SelectedItem.Text.ToString();
}
else
{
bob.Marca = "";
}
if (ddlMaquina.SelectedItem.Text != "Todas")
{
bob.Lote = ddlMaquina.SelectedItem.Text.ToString();
}
else
{
bob.Lote = "";
}
List <Bobina> lista = controlbob.Listar_Informe_fallaCorte(bob, FechaInicio, FechaTermino);
GridView GridView1 = new GridView();
GridView1.DataSource = lista;
GridView1.DataBind();
GridView1.HeaderStyle.BackColor = System.Drawing.Color.Blue;
GridView1.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView1.HeaderRow.Cells[0].Text = "Maquina";
GridView1.HeaderRow.Cells[1].Text = "OTs";
GridView1.HeaderRow.Cells[2].Text = "Pliegos";
GridView1.HeaderRow.Cells[3].Text = "Categoria";
GridView1.HeaderRow.Cells[4].Text = "Motivo";
GridView1.HeaderRow.Cells[5].Text = "Cod. Bob. ";
GridView1.HeaderRow.Cells[6].Text = "Tipo Bob.";
GridView1.HeaderRow.Cells[7].Text = "Marca";
GridView1.HeaderRow.Cells[8].Text = "Proveedor";
GridView1.HeaderRow.Cells[9].Text = "Gr.";
GridView1.HeaderRow.Cells[10].Text = "Ancho";
GridView1.HeaderRow.Cells[11].Text = "Fecha";
GridView1.HeaderRow.Cells[12].Visible = false;
GridView1.HeaderRow.Cells[13].Visible = false;
GridView1.HeaderRow.Cells[14].Visible = false;
GridView1.HeaderRow.Cells[15].Visible = false;
GridView1.HeaderRow.Cells[16].Visible = false;
GridView1.HeaderRow.Cells[17].Visible = false;
GridView1.HeaderRow.Cells[18].Visible = false;
GridView1.HeaderRow.Cells[19].Visible = false;
GridView1.HeaderRow.Cells[20].Visible = false;
GridView1.HeaderRow.Cells[21].Visible = false;
GridView1.HeaderRow.Cells[22].Visible = false;
GridView1.HeaderRow.Cells[23].Visible = false;
GridView1.HeaderRow.Cells[24].Visible = false;
GridView1.HeaderRow.Cells[25].Visible = false;
GridView1.HeaderRow.Cells[26].Visible = false;
GridView1.HeaderRow.Cells[27].Visible = false;
for (int contador = 0; contador < GridView1.Rows.Count; contador++)
{
GridViewRow row = GridView1.Rows[contador];
string once = row.Cells[11].Text;
row.Cells[11].Text = row.Cells[0].Text;
row.Cells[0].Text = row.Cells[26].Text;
row.Cells[10].Text = row.Cells[4].Text;
row.Cells[4].Text = row.Cells[1].Text;
row.Cells[1].Text = once;
row.Cells[2].Text = row.Cells[22].Text;
row.Cells[9].Text = row.Cells[3].Text;
row.Cells[3].Text = row.Cells[24].Text;
string cinco = row.Cells[7].Text;
row.Cells[7].Text = row.Cells[5].Text;
row.Cells[5].Text = cinco;
row.Cells[8].Text = row.Cells[25].Text;
row.Cells[12].Visible = false;
row.Cells[13].Visible = false;
row.Cells[14].Visible = false;
row.Cells[15].Visible = false;
row.Cells[16].Visible = false;
row.Cells[17].Visible = false;
row.Cells[18].Visible = false;
row.Cells[19].Visible = false;
row.Cells[20].Visible = false;
row.Cells[21].Visible = false;
row.Cells[22].Visible = false;
row.Cells[23].Visible = false;
row.Cells[24].Visible = false;
row.Cells[25].Visible = false;
row.Cells[26].Visible = false;
row.Cells[27].Visible = false;
}
ExportToExcel("Falla Corte Banda" + FechaInicio, GridView1);
}
