protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e)
{
Titu.Visible = false;
Literal5.Text = "";
GridView1.Visible = false;
Rale1.Items.Clear();
Rale1.Items.Add(new ListItem("-- Selecciona Rale --", ""));
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;
Dias.Text = "";
Dias.Enabled = false;
tipo_doc.Items.Clear();
tipo_doc.Items.Add(new ListItem("-- Seleccione Tipo de Documento --", "-1"));
tipo_doc.Enabled = false;
tipo_mov.Items.Clear();
tipo_mov.Items.Add(new ListItem("-- Seleccione Tipo de Movimiento --", "-1"));
tipo_mov.Enabled = false;
Rale1.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_RCV ) ORDER BY VALUE1 ASC";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
Rale1.DataSource = cmd.ExecuteReader();
Rale1.DataTextField = "MOSTRAR";
Rale1.DataValueField = "VALUE";
Rale1.DataBind();
if (Rale1.Items.Count > 1)
{
Rale1.Enabled = true;
}
else
{
Rale1.Enabled = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e)
{
LabelMensaje.Visible = false;
Rale1.Items.Clear();
Rale1.Items.Add(new ListItem("-- Selecciona Rale Base --", ""));
Rale2.Items.Clear();
Rale2.Items.Add(new ListItem("-- Selecciona Rale a Comparar --", ""));
Rale2.Enabled = false;
RadioButtonList1.ClearSelection();
RadioButtonList1.Enabled = false;
RadioButtonList2.ClearSelection();
RadioButtonList2.Enabled = false;
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;
Rale1.AppendDataBoundItems = true;
String strConnString = ConfigurationManager.ConnectionStrings["SupervisionConnectionString"].ConnectionString;
String strQuery = "SELECT CONVERT(NVARCHAR, fecha_rale, 105) AS MOSTRAR, CONVERT (NVARCHAR, fecha_rale, 112) AS VALUE FROM Rales_Combo WHERE (tipo_rale = @COP_RCV ) ORDER BY VALUE ASC";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
Rale1.DataSource = cmd.ExecuteReader();
Rale1.DataTextField = "MOSTRAR";
Rale1.DataValueField = "VALUE";
Rale1.DataBind();
if (Rale1.Items.Count > 1)
{
Rale1.Enabled = true;
}
else
{
Rale1.Enabled = false;
Rale2.Enabled = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e)
{
Rale1.Items.Clear();
Rale1.Items.Add(new ListItem("-- Selecciona Rale --", ""));
Rale1.AppendDataBoundItems = true;
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 Rales_Combo WHERE (tipo_rale = @COP_RCV ) ORDER BY VALUE1 ASC";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
Rale1.DataSource = cmd.ExecuteReader();
Rale1.DataTextField = "MOSTRAR";
Rale1.DataValueField = "VALUE";
Rale1.DataBind();
if (Rale1.Items.Count > 1)
{
Rale1.Enabled = true;
}
else
{
Rale1.Enabled = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
