protected void btnFiltro_Click(object sender, EventArgs e) { if ((ddlMes.SelectedItem.Text.ToString() != "Seleccione Mes") && (ddlAnos.SelectedItem.Text.ToString() != "Seleccione Año") && (ddlInforme.SelectedItem.Text.ToString() != "Seleccionar Informe")) { string mes = ddlMes.SelectedValue.ToString(); string Año = ddlAnos.SelectedItem.Text.ToString(); string Informe = ddlInforme.SelectedValue.ToString(); Controller_StockxPeriodo control = new Controller_StockxPeriodo(); RadGridInsumo.DataSource = control.ListarStock(Convert.ToInt32(mes), Convert.ToInt32(Año), Informe); RadGridInsumo.DataBind(); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { GridView gv = new GridView(); if ((ddlMes.SelectedItem.Text.ToString() != "Seleccione Mes") && (ddlAnos.SelectedItem.Text.ToString() != "Seleccione Año") && (ddlInforme.SelectedItem.Text.ToString() != "Seleccionar Informe")) { string mes = ddlMes.SelectedValue.ToString(); string Año = ddlAnos.SelectedItem.Text.ToString(); string Informe = ddlInforme.SelectedValue.ToString(); Controller_StockxPeriodo control = new Controller_StockxPeriodo(); gv.DataSource = control.ListarStock(Convert.ToInt32(mes), Convert.ToInt32(Año), Informe); gv.DataBind(); gv.HeaderStyle.BackColor = System.Drawing.Color.Blue; gv.HeaderStyle.ForeColor = System.Drawing.Color.White; gv.HeaderRow.Cells[0].Text = "Cod. Item"; gv.HeaderRow.Cells[1].Text = "Descripción"; if (Informe == "Tintas") { gv.HeaderRow.Cells[4].Visible = false; gv.HeaderRow.Cells[5].Visible = false; gv.HeaderRow.Cells[6].Visible = false; gv.HeaderRow.Cells[11].Visible = false; gv.HeaderRow.Cells[13].Visible = false; gv.HeaderRow.Cells[14].Visible = false; gv.HeaderRow.Cells[21].Visible = false; gv.HeaderRow.Cells[22].Visible = false; gv.HeaderRow.Cells[23].Visible = false; gv.HeaderRow.Cells[24].Visible = false; gv.HeaderRow.Cells[25].Visible = false; gv.HeaderRow.Cells[28].Visible = false; gv.HeaderRow.Cells[30].Visible = false; gv.HeaderRow.Cells[31].Visible = false; gv.HeaderRow.Cells[32].Visible = false; gv.HeaderRow.Cells[33].Visible = false; gv.HeaderRow.Cells[34].Visible = false; gv.HeaderRow.Cells[35].Visible = false; gv.HeaderRow.Cells[36].Visible = false; gv.HeaderRow.Cells[37].Visible = false; gv.HeaderRow.Cells[38].Visible = false; for (int contador = 0; contador < gv.Rows.Count; contador++) { GridViewRow row = gv.Rows[contador]; row.Cells[4].Visible = false; row.Cells[5].Visible = false; row.Cells[6].Visible = false; row.Cells[11].Visible = false; row.Cells[13].Visible = false; row.Cells[14].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[28].Visible = false; row.Cells[30].Visible = false; row.Cells[31].Visible = false; row.Cells[32].Visible = false; row.Cells[33].Visible = false; row.Cells[34].Visible = false; row.Cells[35].Visible = false; row.Cells[36].Visible = false; row.Cells[37].Visible = false; row.Cells[38].Visible = false; } } else if (Informe == "Insumos") { gv.HeaderRow.Cells[3].Visible = false; gv.HeaderRow.Cells[4].Visible = false; gv.HeaderRow.Cells[5].Visible = false; gv.HeaderRow.Cells[6].Visible = false; gv.HeaderRow.Cells[11].Visible = false; gv.HeaderRow.Cells[13].Visible = false; gv.HeaderRow.Cells[21].Visible = false; gv.HeaderRow.Cells[22].Visible = false; gv.HeaderRow.Cells[23].Visible = false; gv.HeaderRow.Cells[24].Visible = false; gv.HeaderRow.Cells[28].Visible = false; gv.HeaderRow.Cells[30].Visible = false; gv.HeaderRow.Cells[31].Visible = false; gv.HeaderRow.Cells[32].Visible = false; gv.HeaderRow.Cells[33].Visible = false; gv.HeaderRow.Cells[34].Visible = false; gv.HeaderRow.Cells[35].Visible = false; for (int contador = 0; contador < gv.Rows.Count; contador++) { GridViewRow row = gv.Rows[contador]; row.Cells[3].Visible = false; row.Cells[4].Visible = false; row.Cells[5].Visible = false; row.Cells[6].Visible = false; row.Cells[11].Visible = false; row.Cells[13].Visible = false; row.Cells[21].Visible = false; row.Cells[22].Visible = false; row.Cells[23].Visible = false; row.Cells[24].Visible = false; row.Cells[28].Visible = false; row.Cells[30].Visible = false; row.Cells[31].Visible = false; row.Cells[32].Visible = false; row.Cells[33].Visible = false; row.Cells[34].Visible = false; row.Cells[35].Visible = false; } } else if (Informe == "Pliegos") { gv.HeaderRow.Cells[11].Visible = false; gv.HeaderRow.Cells[12].Visible = false; gv.HeaderRow.Cells[13].Visible = false; gv.HeaderRow.Cells[21].Visible = false; gv.HeaderRow.Cells[22].Visible = false; gv.HeaderRow.Cells[23].Visible = false; gv.HeaderRow.Cells[24].Visible = false; gv.HeaderRow.Cells[28].Visible = false; gv.HeaderRow.Cells[36].Visible = false; gv.HeaderRow.Cells[37].Visible = false; gv.HeaderRow.Cells[38].Visible = false; for (int contador = 0; contador < gv.Rows.Count; contador++) { GridViewRow row = gv.Rows[contador]; row.Cells[11].Visible = false; row.Cells[12].Visible = false; row.Cells[13].Visible = false; row.Cells[21].Visible = false; row.Cells[22].Visible = false; row.Cells[23].Visible = false; row.Cells[24].Visible = false; row.Cells[28].Visible = false; row.Cells[36].Visible = false; row.Cells[37].Visible = false; row.Cells[38].Visible = false; } } else if (Informe == "Bobinas") { gv.HeaderRow.Cells[23].Visible = false; gv.HeaderRow.Cells[24].Visible = false; gv.HeaderRow.Cells[30].Visible = false; gv.HeaderRow.Cells[31].Visible = false; gv.HeaderRow.Cells[32].Visible = false; gv.HeaderRow.Cells[33].Visible = false; gv.HeaderRow.Cells[34].Visible = false; gv.HeaderRow.Cells[35].Visible = false; gv.HeaderRow.Cells[36].Visible = false; gv.HeaderRow.Cells[37].Visible = false; gv.HeaderRow.Cells[38].Visible = false; for (int contador = 0; contador < gv.Rows.Count; contador++) { GridViewRow row = gv.Rows[contador]; row.Cells[23].Visible = false; row.Cells[24].Visible = false; row.Cells[30].Visible = false; row.Cells[31].Visible = false; row.Cells[32].Visible = false; row.Cells[33].Visible = false; row.Cells[34].Visible = false; row.Cells[35].Visible = false; row.Cells[36].Visible = false; row.Cells[37].Visible = false; row.Cells[38].Visible = false; } } else if (Informe == "Planchas") { gv.HeaderRow.Cells[4].Visible = false; gv.HeaderRow.Cells[5].Visible = false; gv.HeaderRow.Cells[6].Visible = false; gv.HeaderRow.Cells[11].Visible = false; gv.HeaderRow.Cells[13].Visible = false; gv.HeaderRow.Cells[21].Visible = false; gv.HeaderRow.Cells[22].Visible = false; gv.HeaderRow.Cells[23].Visible = false; gv.HeaderRow.Cells[24].Visible = false; gv.HeaderRow.Cells[28].Visible = false; gv.HeaderRow.Cells[30].Visible = false; gv.HeaderRow.Cells[31].Visible = false; gv.HeaderRow.Cells[32].Visible = false; gv.HeaderRow.Cells[33].Visible = false; gv.HeaderRow.Cells[34].Visible = false; gv.HeaderRow.Cells[35].Visible = false; gv.HeaderRow.Cells[36].Visible = false; gv.HeaderRow.Cells[37].Visible = false; gv.HeaderRow.Cells[38].Visible = false; for (int contador = 0; contador < gv.Rows.Count; contador++) { GridViewRow row = gv.Rows[contador]; row.Cells[4].Visible = false; row.Cells[5].Visible = false; row.Cells[6].Visible = false; row.Cells[11].Visible = false; row.Cells[13].Visible = false; row.Cells[21].Visible = false; row.Cells[22].Visible = false; row.Cells[23].Visible = false; row.Cells[24].Visible = false; row.Cells[28].Visible = false; row.Cells[30].Visible = false; row.Cells[31].Visible = false; row.Cells[32].Visible = false; row.Cells[33].Visible = false; row.Cells[34].Visible = false; row.Cells[35].Visible = false; row.Cells[36].Visible = false; row.Cells[37].Visible = false; row.Cells[38].Visible = false; } } ExportToExcel("Informe Stock de " + Informe + " " + DateTime.Now.ToString("dd-MM-yyyy HH:mm"), gv, ddlMes.SelectedItem.Text.ToString(), Año, ddlInforme.SelectedItem.Text.ToString()); } }