protected void BindBDdl()
{
string LtxtSql = string.Format("EXEC SP_TablasIngenieria 16,'','','','','','','','','AKRte',0,0,0,0,0,{0},'01-01-1','02-01-1','03-01-1'", Session["!dC!@"]);
DdlAeronave.DataSource = Cnx.DSET(LtxtSql);
DdlAeronave.DataMember = "Datos";
DdlAeronave.DataTextField = "Matricula";
DdlAeronave.DataValueField = "CodAeronave";
DdlAeronave.DataBind();
}
protected void BindBDdl()
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_Reporte_Manto2 11,'','','','','',0,0,0,@ICC,'01-01-1','02-01-1','03-01-1'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DST = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DST);
DST.Tables[0].TableName = "HK";
DST.Tables[1].TableName = "Estado";
DST.Tables[2].TableName = "OT";
DST.Tables[3].TableName = "Rte";
ViewState["DST"] = DST;
}
}
}
}
DST = (DataSet)ViewState["DST"];
DdlAeronave.DataSource = DST.Tables[0];
DdlAeronave.DataTextField = "Matricula";
DdlAeronave.DataValueField = "CodAeronave";
DdlAeronave.DataBind();
DdlStatus.DataSource = DST.Tables[1];
DdlStatus.DataTextField = "Descripcion";
DdlStatus.DataValueField = "CodStatus";
DdlStatus.DataBind();
DdlOTPpl.DataSource = DST.Tables[2];
DdlOTPpl.DataTextField = "Descripcion";
DdlOTPpl.DataValueField = "CodOt";
DdlOTPpl.DataBind();
DdlRpteNro.DataSource = DST.Tables[3];
DdlRpteNro.DataTextField = "Descripcion";
DdlRpteNro.DataValueField = "CodIdLvDetManto";
DdlRpteNro.DataBind();
}
protected void BindData(string Accion)
{
try
{
Idioma = (DataTable)ViewState["TablaIdioma"];
string VbTxtSql, VbCodAnt;
if (Accion.Equals("UPD"))
{
Cnx.SelecBD();
using (SqlConnection SCnx = new SqlConnection(Cnx.GetConex()))
{
string VbHK;
if (DdlAeronave.Text.Equals(""))
{
VbHK = "";
}
else
{
VbHK = DdlAeronave.SelectedItem.Text.Trim();
}
if (VbHK.Trim().Equals(""))
{
VbTxtSql = "EXEC Consultas_General 6, '', '', '',@Todo,@Di, @ICC, '06-01-2012', '06-01-2012'";
}
else
{
VbTxtSql = "EXEC Consultas_General 6, @A, '', '',@Todo,@Di, @ICC, '06-01-2012', '06-01-2012'";
}
SCnx.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, SCnx))
{
SC.Parameters.AddWithValue("@Todo", CkbVisualTodo.Checked == true ? 1 : 0);
SC.Parameters.AddWithValue("@Di", TxtDiaVisual.Text);
SC.Parameters.AddWithValue("@A", VbHK);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DST = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DST);
DST.Tables[0].TableName = "Servicios";
DST.Tables[1].TableName = "HK";
DST.Tables[2].TableName = "SvcRst";
DST.Tables[3].TableName = "UbicacionSinInst";
ViewState["DST"] = DST;
}
}
}
}
}
DST = (DataSet)ViewState["DST"];
if (DST.Tables[0].Rows.Count > 0)
{
GrdDatos.DataSource = DST.Tables[0]; GrdDatos.DataBind();
}
else
{
DST.Tables[0].Rows.Add(DST.Tables[0].NewRow());
GrdDatos.DataSource = DST.Tables[0];
GrdDatos.DataBind();
GrdDatos.Rows[0].Cells.Clear();
GrdDatos.Rows[0].Cells.Add(new TableCell());
DataRow[] Result = Idioma.Select("Objeto= 'SinRegistros'");
foreach (DataRow row in Result)
{
GrdDatos.Rows[0].Cells[0].Text = row["Texto"].ToString();
}
GrdDatos.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
VbCodAnt = DdlAeronave.Text.Trim();
DdlAeronave.DataSource = DST.Tables[1];
DdlAeronave.DataTextField = "Matricula";
DdlAeronave.DataValueField = "CodAeronave";
DdlAeronave.DataBind();
DdlAeronave.Text = VbCodAnt;
}
catch (Exception Ex)
{
DataRow[] Result = Idioma.Select("Objeto= 'MensIncovCons'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //
Cnx.UpdateErrorV2(Session["C77U"].ToString(), ViewState["PFileName"].ToString().Trim(), "Consulta Proximos cumplimientos", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString());
}
}
