Exemplo n.º 1
0
    protected void Rale1_SelectedIndexChanged(object sender, EventArgs e)
    {
        LabelMensaje.Visible     = false;
        RadioButtonList1.Enabled = false;
        RadioButtonList1.ClearSelection();
        RadioButtonList2.Enabled = false;
        RadioButtonList2.ClearSelection();
        fecha1.Items.Clear();
        fecha1.Items.Add(new ListItem("-- Seleccione el Periodo Inicial --", ""));
        fecha1.Enabled = false;
        fecha2.Items.Clear();
        fecha2.Items.Add(new ListItem("-- Seleccione el Periodo Final --", ""));
        fecha2.Enabled = false;
        Rale2.Items.Clear();
        Rale2.Items.Add(new ListItem("-- Selecciona Rale a Comparar --", ""));
        Rale2.AppendDataBoundItems = true;
        String        strConnString = ConfigurationManager.ConnectionStrings["SupervisionConnectionString"].ConnectionString;
        String        strQuery      = "SELECT CONVERT(NVARCHAR, [fecha_rale], 105) AS MOSTRAR,CONVERT(NVARCHAR, [fecha_rale], 105) AS VALUE,CONVERT (NVARCHAR, fecha_rale, 112) AS VALUE1 FROM [Supervision].[dbo].[Rales_Combo] WHERE [tipo_rale]= @TIPO  AND [fecha_rale] > @FEC ORDER BY VALUE1 ASC";
        SqlConnection con           = new SqlConnection(strConnString);
        SqlCommand    cmd           = new SqlCommand();

        cmd.Parameters.AddWithValue("@TIPO", Tipo_Rale.SelectedItem.Value);
        cmd.Parameters.AddWithValue("@FEC", Rale1.SelectedItem.Value);
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = strQuery;
        cmd.Connection  = con;
        try
        {
            con.Open();
            Rale2.DataSource     = cmd.ExecuteReader();
            Rale2.DataTextField  = "MOSTRAR";
            Rale2.DataValueField = "VALUE";
            Rale2.DataBind();
            if (Rale2.Items.Count > 1)
            {
                Rale2.Enabled = true;
            }
            else
            {
                Rale2.Enabled = false;
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
            con.Dispose();
        }
    }
Exemplo n.º 2
0
    protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (RadioButtonList1.SelectedValue == "1")
        {
            Literal5.Text     = "";
            Panel3.Visible    = false;
            Panel2.Visible    = true;
            GridView1.Visible = false;
            GridView2.Visible = false;
            Rale1.Items.Clear();
            Rale1.Items.Add(new ListItem("-- Selecciona Rale --", ""));
            Rale1.Enabled = false;

            TIPO.Items.Clear();
            TIPO.Items.Add(new ListItem("-- Selecione la Subdelegación --", ""));
            TIPO.Enabled = false;

            incidencia.Items.Clear();
            incidencia.Items.Add(new ListItem("-- Seleccione Incidencia --", ""));
            incidencia.Enabled = false;

            Tipo_Rale.Items.Clear();
            Tipo_Rale.Items.Add(new ListItem("-- Selecciona Tipo de Rale --", ""));
            Tipo_Rale.Enabled = true;
            Tipo_Rale.AppendDataBoundItems = true;
            String        strQuery = "SELECT DISTINCT [tipo_rale] as id,[tipo_rale] as des FROM [Supervision].[dbo].[Rales_Combo]";
            SqlConnection con      = new SqlConnection(strConnString);
            SqlCommand    cmd      = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strQuery;
            cmd.Connection  = con;
            try
            {
                con.Open();
                Tipo_Rale.DataSource     = cmd.ExecuteReader();
                Tipo_Rale.DataTextField  = "des";
                Tipo_Rale.DataValueField = "id";
                Tipo_Rale.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
            }
        }
        else
        {
            if (RadioButtonList1.SelectedValue == "2")
            {
                Literal5.Text                  = "";
                Encabezado.Visible             = false;
                EncabezadoSegundaTabla.Visible = false;
                GridView3.Visible              = false;
                Panel2.Visible                 = false;
                Panel3.Visible                 = true;
                GridView1.Visible              = false;
                Rale2.Items.Clear();
                Reg_Pat.Text = null;
                Rale2.Items.Add(new ListItem("-- Selecciona Rale --", ""));
                Rale2.AppendDataBoundItems = true;
                String        strQuery = "SELECT CONVERT(NVARCHAR, fecha_rale, 105) AS MOSTRAR, CONVERT (NVARCHAR, fecha_rale, 105) AS VALUE, CONVERT (NVARCHAR, fecha_rale, 102) AS VALUE1 FROM Rales_Combo WHERE (tipo_rale = 'COP' ) ORDER BY VALUE1 ASC";
                SqlConnection con      = new SqlConnection(strConnString);
                SqlCommand    cmd      = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = strQuery;
                cmd.Connection  = con;
                try
                {
                    con.Open();
                    Rale2.DataSource     = cmd.ExecuteReader();
                    Rale2.DataTextField  = "MOSTRAR";
                    Rale2.DataValueField = "VALUE";
                    Rale2.DataBind();
                    if (Rale2.Items.Count > 1)
                    {
                        Rale2.Enabled = true;
                    }
                    else
                    {
                        Rale2.Enabled = false;
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    con.Close();
                    con.Dispose();
                }
            }
        }
    }